Enforce an Ordered Conversion Funnel
Hard About 35 min Katabench Pro
Carry each visitor's next valid timestamp through a campaign funnel without mixing or reordering events.
The full brief is part of Katabench Pro
Pro opens this kata's brief, its starter code and its grader. To see how the track works first, try Customer Order Totals, which is free.
How it is graded
Your LINQ or SQL runs against real PostgreSQL. You see the SQL your code generates on the sample tests and can inspect its execution plan, so you learn when the database did the wrong work.
What it practices
- Common table expressions
- Name intermediate results with WITH, and know when a CTE is inlined or materialized.
- Aggregation and grouping
- GROUP BY, HAVING, conditional aggregates, pivots and ROLLUP or grouping sets.
- Dates, times and ranges
- Time zones, local day boundaries, month arithmetic and half-open range overlap.
Related katas
- Recency, Frequency, and Money in One Fold Hard Pro Aggregate customer RFM metrics at an as-of date and apply deterministic segment precedence.
- Build a Cohort Retention Grid Hard Pro Anchor customers to their first purchase, then zero-fill a calendar-month retention grid.
- Common Table Expressions Hard Pro Compare each country against the average of the country totals, an aggregate over aggregates.
- Customer Order Totals Medium Free Sum each customer's orders with a single SQL query instead of an N+1 loop.