SQL for a three-step onboarding funnel
WHAT IT TESTS: Funnel SQL with ordering correctness. OUTLINE: Anchor the 30-day signup cohort, count distinct users reaching each later step in timestamp order; conversion is each step over the prior. RED FLAG: Counting any occurrence regardless of order.
WHAT IT TESTS: Whether you can write order-aware funnel SQL. ANSWER OUTLINE: Define the cohort as distinct users whose signup_complete is in the last 30 days. For each later step, count distinct users who did it after signup and after the prior step, respecting ordering. Conditional aggregation or sequential joins both work. Conversion between steps is later-step distinct users over earlier-step distinct users. RED FLAG: Counting events not users, ignoring ordering, or comparing each step to the total instead of the prior step.
Read the original → interview
- #sql
- #funnel-analysis
- #conversion
- #cohort
- #analytics
Get five bites like this every day.
Tezvyn delivers a daily feed of 60-second tech bites with quizzes to lock in what you learn.