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