Complex~36min

The Cohort That Pauses Instead of Cancels

The official churn dashboard only counts cancellations in a subscriber's first month, and every cohort shows a clean 10% month-0 churn rate on that metric — including 2024-03. But 12 of that cohort's 30 subscribers paused in month 1 and quietly cancelled in month 3, well outside the reporting window. Tracing what happens after each pause shows 2024-03's real total churn is 50%, not 10%.

Tables you'll query

subscriberssubscription_events

What you'll learn

CTEs (WITH clause)Window FunctionsCohort Analysis
Investigate this case →