Complex~35min

The Silent Downgrade Wave

5 accounts had active_seats decline in each of the 3 months immediately before they cancelled — a slow bleed no single-month alert ever caught because each drop was small. 8 education-vertical accounts also show a multi-month seat decline, but that's a normal summer dip that fully recovers by September, and none of them ever actually cancel.

Tables you'll query

accountsmonthly_active_seatscancellations

What you'll learn

CTEs (WITH clause)Window FunctionsDate & Time Functions
Investigate this case →