Subscription Commerce Analytics Path · Mission 19 of 25Expert

Churn forensics by reason_code (Q1 2026)

Voluntary vs involuntary churn split. Practice grouping events by two columns (reason_code, event_type), filtering to a date range, and producing a forensics breakdown the retention team uses to prioritize intervention. Voluntary cancels (event_type='cancelled') need product/pricing fixes; involuntary churns (event_type='churned') need billing/payment fixes — different teams, different remediation.

The Brief

You'll practice

Voluntary vs involuntaryWindow SUM frameTrend