Complex~34min
The Bundle Discount That Cannibalizes Full-Price Plans
Total subscriber count grew from 700 to 1,800 over 6 months and total revenue also grew, from 560,000 to 890,000 — both headline numbers look like a win. But revenue-per-subscriber fell from 800 to 494, a 38% decline, because nearly all the subscriber growth is low-revenue bundle accounts diluting the base of full-price standalone accounts. Neither raw metric alone shows it — only tracking the ratio over time does.
Tables you'll query
subscriptions
What you'll learn
CTEs (WITH clause)Window FunctionsAggregations & GROUP BY