churn-analysis

Churn Analysis

Overview

Master churn prediction and prevention by analyzing churn patterns, identifying at-risk accounts before they leave, and executing targeted retention strategies. Effective churn analysis turns data into actionable retention playbooks.

Churn Metrics & Definitions

1. Core Churn Metrics

Churn Rate Calculation:

Monthly Churn Rate = (Customers Lost During Month / Starting Customers) × 100

EXAMPLE:
Starting customers (Jan 1): 200
New customers (Jan): 30
Customers churned (Jan): 5
Ending customers (Jan 31): 225

Monthly Churn Rate = (5 / 200) × 100 = 2.5%

INTERPRETATION:
2.5% monthly churn = 30% annual churn (if consistent)
This is high for SaaS (1-2% monthly is typical)

Related Metrics:

• Net Churn: Revenue churn accounting for expansion revenue
• Logo Churn: Number of customers (what we calculated above)
• Revenue Churn: Dollar value of lost contracts
• Cohort Churn: Churn by customer acquisition cohort (e.g., Q1 2023 cohort)
• Involuntary Churn: Payment failures, non-renewal (vs. voluntary cancellation)

2. Churn Types

VOLUNTARY CHURN (Customer actively leaves):
- Reason: Found better product
- Reason: No longer need capability
- Reason: Switching to competitor
- Reason: Budget cuts
- Typical Rate: 60-70% of total churn
- Intervention: Retention playbook, win-back campaign

INVOLUNTARY CHURN (Payment/technical failure):
- Reason: Payment card declined
- Reason: Non-renewal (contract expired; didn't renew)
- Reason: Delinquent account suspended
- Typical Rate: 30-40% of total churn
- Intervention: Payment processing fix, renewal reminder system

EXPECTED CHURN (Company context):
- Reason: Customer bankruptcy
- Reason: Customer acquires competitor
- Reason: Use case no longer relevant
- Typical Rate: 5-10% of total churn
- Intervention: None; expected; document reason

Churn Analysis Framework

Step 1: Segment Churn by Dimension

Analyze Churn by Customer Segment:

CHURN ANALYSIS BY SEGMENT

Segment | Customers | Churned | Churn Rate | Annual Impact
---------|-----------|---------|-----------|---------------
Enterprise | 25 | 1 | 4% | $250K revenue at risk
Mid-Market | 75 | 3 | 4% | $150K revenue at risk
SMB | 200 | 15 | 7.5% | $200K revenue at risk
Startup | 50 | 8 | 16% | $100K revenue at risk
TOTAL | 350 | 27 | 7.7% | $700K revenue at risk

FINDINGS:
- Startup segment is bleeding (16% churn; disproportionate)
- SMB and Enterprise churn rates similar (4-7.5%)
- SMB represents lowest revenue but highest volume
- Startups likely have cash flow issues (expected churn)

ACTIONABLE INSIGHT:
Focus retention efforts on Startup segment (highest churn);
likely to improve with targeted intervention

Analyze Churn by Acquisition Channel:

Channel | Customers | Churned | Churn Rate | Cost Per Acquisition (CPA)
---------|-----------|---------|-----------|---------------------------
Inbound | 120 | 4 | 3.3% | $500
Sales outreach | 90 | 3 | 3.3% | $2,000
Partner | 80 | 6 | 7.5% | $800
Paid advertising | 60 | 14 | 23.3% | $300

FINDINGS:
- Paid advertising channel has HIGHEST churn (23.3%)
- Lowest CPA (paid ads) + highest churn = poor fit
- Inbound and sales outreach much better (3.3% churn)

ACTIONABLE INSIGHT:
Shift budget away from paid ads; they're attracting wrong customers
This is cost problem, not retention problem

Analyze Churn by Acquisition Cohort (time of signup):

Cohort | Customers | Remaining | Months Old | Churn Rate | Retention
--------|-----------|-----------|-----------|-----------|----------
2021 Jan | 40 | 38 | 36 months | 5% | 95%
2022 Jan | 60 | 55 | 24 months | 8% | 92%
2023 Jan | 100 | 85 | 12 months | 15% | 85%
2023 Oct | 80 | 72 | 4 months | 10% | 90%
2024 Jan | 70 | 68 | 1 month | 3% | 97%

FINDINGS:
- Older cohorts have better retention (inverse selection)
- 12-month cohort critical inflection point (big drop 85%)
- Recent cohort retention looks good (2024 Jan)

ACTIONABLE INSIGHT:
Focus on 12-month customer retention (anniversary date)
Build special program around 12-month renewal
Identify what changed in 2023 cohort onboarding process

Step 2: Identify Churn Reasons

Build Exit Interview Template:

CUSTOMER EXIT INTERVIEW - [Customer Name]

Thank you for using [Product]. We're sorry to see you go. Your feedback
will help us improve. Would you answer a few quick questions?

1. What is the primary reason you're canceling?
   [ ] Found better product
   [ ] Price too high
   [ ] Wasn't meeting our needs
   [ ] Budget constraints
   [ ] Using competitor instead (who? _________)
   [ ] Company restructuring
   [ ] No longer need this capability
   [ ] Poor customer support
   [ ] Technical issues / performance
   [ ] Other: _____________________________

2. On a scale of 1-10, how likely would you recommend [Product]?
   (This is your NPS question)

3. What features would have made us stay?
   _________________________________________________

4. What could we have done differently?
   _________________________________________________

5. May we follow up in 90 days to check if you're interested again?
   [ ] Yes [ ] No

6. Contact info if interested in future win-back: _____________

Analysis of Exit Interview Data:

CHURN REASONS - LAST 6 MONTHS (27 customers lost)

Reason | Count | % | Action
--------|-------|----|---------
Better competitor found | 8 | 30% | Product roadmap gap analysis
Price too high | 6 | 22% | Pricing tier redesign needed
Not meeting needs | 5 | 18% | Onboarding/discovery process issue
Budget cuts | 4 | 15% | Expected churn; downsizing
Poor support | 2 | 7% | CS training needed; SLA tightening
Technical issues | 2 | 7% | Product stability issues

INSIGHTS:
- Competitor churn (30%): Losing to specific product?
- Price churn (22%): Opportunity for mid-tier pricing?
- Feature gap (18%): Feature adoption low during onboarding?
- Budget cuts (15%): Can't fix; expected
- Support/Technical (14%): Operational issues; low hanging fruit

TOP 3 OPPORTUNITIES:
1. Analyze competitor product features; roadmap gaps
2. Introduce mid-tier pricing ($X-$Y/month)
3. Improve onboarding to accelerate feature adoption

Step 3: Build At-Risk Account Model

Early Warning Signals:

CHURN RISK INDICATORS

Indicator | Weight | Red Flag Threshold | Action
-----------|--------|-------------------|-------
Health score | 25% | <50 (from current 80) | Weekly check-in
Feature adoption | 20% | <50% features used | Training program
Support tickets | 20% | 5+ in last 30 days | Issue resolution
Usage decline | 15% | Down 30% MoM | Root cause call
NPS/Satisfaction | 15% | <0 (vs. 50 average) | Executive outreach
Contract renewal | 5% | <90 days until expiry | Renewal proposal

At-Risk Account Scoring Model:

ACCOUNT RISK SCORE (0-100; higher = more at risk)

Account | Health | Adoption | Tickets | Usage | NPS | Renewal Days | Risk Score | Status
---------|--------|----------|---------|-------|-----|--------------|-----------|--------
Acme Corp | 65 | 45% | 8 | Down 25% | -5 | 120 days | 72 | RED
Beta Inc | 80 | 60% | 2 | Up 10% | 45 | 200 days | 35 | GREEN
Gamma Ltd | 55 | 30% | 12 | Down 40% | -20 | 60 days | 88 | RED
Delta Co | 75 | 75% | 1 | Up 5% | 60 | 300 days | 25 | GREEN
Epsilon | 40 | 20% | 15 | Down 50% | -30 | 15 days | 95 | RED

RISK CATEGORIES:
RED (>70): Immediate intervention required; weekly check-ins
YELLOW (40-70): Monitor closely; monthly check-ins; build plan
GREEN (<40): Healthy; standard quarterly reviews

AT-RISK ACCOUNTS REQUIRING IMMEDIATE ACTION: 3 (Acme, Gamma, Epsilon)

Retention Playbooks

Playbook 1: Feature Gap Churn

Trigger: Customer states "found better product" or "feature X not available"

RETENTION PLAYBOOK - FEATURE GAP

IMMEDIATE ACTIONS (Day 1):
1. CSM calls customer within 24 hours
2. Acknowledge gap; don't defend product
3. Understand priority: "How critical is feature X to your use case?"
4. If not critical: Exp