Churn Cohort Waterfall Analyzer
Visualize customer churn patterns with waterfall analysis and LTV calculations. Enter values for instant results with step-by-step formulas.
Worked Examples
Example 1: SaaS Startup Cohort Analysis
Problem: A SaaS startup acquired 500 customers in January. They want to understand their churn pattern and project 12-month retention. Monthly churn rates are: M1=18%, M2=12%, M3=8%, M4-6=5%, M7-12=3%.
Solution: Month-by-month calculation:\n\nM0 (Start): 500 customers\nM1: 500 × (1 - 0.18) = 410 remaining (90 churned)\nM2: 410 × (1 - 0.12) = 361 remaining (49 churned)\nM3: 361 × (1 - 0.08) = 332 remaining (29 churned)\nM4: 332 × (1 - 0.05) = 315 remaining\nM5: 315 × (1 - 0.05) = 299 remaining\nM6: 299 × (1 - 0.05) = 284 remaining\nM7-12: Apply 3% monthly...\nM12: ~238 remaining\n\n12-month retention: 238/500 = 47.6%\n\nCritical insight: 168 of 262 total churned customers (64%) left in first 3 months. This is the intervention window.
Result: 47.6% retention | 64% of churn in M1-M3 | Focus onboarding to improve overall retention
Example 2: Comparing Two Cohorts
Problem: Q1 cohort had 20% M1 churn. After onboarding improvements, Q2 cohort shows 12% M1 churn. Both have 1000 customers. What's the impact on 12-month retention assuming other months unchanged?
Solution: Q1 Cohort Path:\nM1: 1000 × 0.80 = 800\nM2: 800 × 0.90 = 720\nM3: 720 × 0.93 = 670\nM4-12: Continue at 96% monthly retention...\nM12: ~523 customers (52.3% retention)\n\nQ2 Cohort Path:\nM1: 1000 × 0.88 = 880 (+80 vs Q1)\nM2: 880 × 0.90 = 792\nM3: 792 × 0.93 = 737\nM4-12: Continue at 96%...\nM12: ~575 customers (57.5% retention)\n\nImprovement: 5.2 percentage points\nAt $50 ARPU: Extra 52 customers × $50 × 12 months = $31,200 additional revenue per 1000-customer cohort.
Result: 8% M1 churn reduction → 5.2pp better 12-month retention → $31K additional revenue per 1K customers
Example 3: Enterprise vs SMB Cohort Comparison
Problem: Company serves both enterprise (high-touch, annual contracts) and SMB (self-serve, monthly). Enterprise: M1=5%, M2-12=2%. SMB: M1=25%, M2-3=15%, M4-12=8%. Both start with 100 customers. Compare economics.
Solution: Enterprise Cohort:\nM1: 100 × 0.95 = 95\nM2-12: 95 × (0.98)^11 = 76\n12-month retention: 76%\nIf ARPU = $500/mo: LTV contribution = 76 × $500 × 12 = $456,000\n\nSMB Cohort:\nM1: 100 × 0.75 = 75\nM2: 75 × 0.85 = 64\nM3: 64 × 0.85 = 54\nM4-12: 54 × (0.92)^9 = 26\n12-month retention: 26%\nIf ARPU = $50/mo: LTV contribution = 26 × $50 × 12 = $15,600\n\nEnterprise delivers 29x more revenue despite equal customer counts.\n\nBreak-even: Need ~29 SMB customers to match 1 enterprise customer's value.
Result: Enterprise: 76% retention, $456K revenue | SMB: 26% retention, $15.6K revenue | 29:1 value ratio
Frequently Asked Questions
What is cohort churn analysis?
Cohort churn analysis tracks a group of customers acquired in the same period (a cohort) and measures how many leave over time. Unlike aggregate churn metrics, it reveals when customers are most likely to leave and how retention patterns change as customers mature. This enables targeted interventions at critical moments.
Why use a waterfall chart for churn?
Waterfall charts visually show the 'flow' of customer attrition—each bar represents customers lost in that period, making it easy to spot when the biggest drops occur. Unlike line charts showing remaining customers, waterfalls emphasize the magnitude of each period's losses, highlighting intervention opportunities.
Why is early-stage churn usually highest?
Early churn reflects onboarding failures, mismatched expectations, and customers who didn't find value quickly. The first 30-90 days are critical—customers either establish habits and see value, or leave. Successful products show steep churn curves that flatten after month 3-6.
What causes late-stage churn (months 7-12)?
Late-stage churn typically results from: competitive alternatives, changing business needs, budget cuts, lack of continued value/innovation, or accumulated frustrations. It's harder to address than early churn because customers have already committed but found reasons to leave.
What's the relationship between churn and LTV?
LTV = ARPU × Average Customer Lifetime. If monthly churn is 5%, average lifetime is ~20 months (1/0.05). Small churn improvements dramatically increase LTV: reducing churn from 5% to 4% increases average lifetime from 20 to 25 months—a 25% LTV increase.
Should I track gross or net churn?
Track both. Gross churn measures customers/revenue lost regardless of expansion. Net churn accounts for expansion revenue from remaining customers. You can have negative net churn (>100% net retention) if expansions exceed losses—the gold standard for SaaS.