How eCommerce and subscription data teams prep, model and schedule their data – written by the analysts behind Refyner. Definitions, working SQL and patterns you can use with or without our tool.
What prep actually means on a warehouse, the five jobs every eCommerce team repeats, and why the work stalls in a ticket queue.
Read the guide Marketing analyticsTwo numbers with two different jobs. The formula for each, when to use which, and working Snowflake SQL for both.
Read the guide Unit economicsCohort assignment, cumulative revenue and cohort CAC – step by step, with the SQL for each stage of the dataflow.
Read the guide SchedulingWhat a schedule actually needs beyond cron, where tasks and Airflow strain, and patterns analysts can run alone.
Read the guide RetentionWindows, cohort curves and the right-censoring trap – how to model repeat behaviour honestly in Snowflake.
Read the guide ModellingPrep each source, join on a date–channel spine, and ship one marketing table the whole business can trust.
Read the guideEvery guide uses the same four words the same way – the same way Refyner uses them.
Everything in these guides is a built-in model in Refyner. Connect your Snowflake and your analysts prep, build and schedule it themselves.
Refyner