Is Spend Still Moving Conversion?
Medium About 15 min Katabench Pro
Measure campaign direction and strength with PostgreSQL regression aggregates while handling degenerate samples.
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
- Statistical aggregates
- Medians, percentiles, distributions, weighted averages and regression computed in SQL.
Related katas
- Risk Bands That Do Not Split Ties Medium Pro Assign percentile risk bands with CUME_DIST so accounts with equal scores remain together.
- Rank a Release Before It Ships Medium Pro Use a hypothetical-set RANK aggregate to place an unpersisted release in every channel leaderboard.
- Median Order per Country Medium Pro Filter country groups by their median order total, which AVG cannot give you.
- Average Rates Lie Medium Pro Compose campaign KPIs from summed numerators and denominators instead of averaging unequal daily rates.