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
Investigate this case →