📋 Business Problem Statement
Churn is destroying 39% of customers before they deliver full value — costing $45.8K/mo in lost MRR.
🔴 Churn: Critical
⚠ NRR: 62.9%
✓ MRR: $77.7K
39.0%
Churn Rate
Benchmark: <5%
1,952
Lost Customers
of 5,000 total
$45.8K
MRR Lost / Mo
37% of potential MRR
$77.7K
Active MRR / Mo
from 3,048 active
62.9%
NRR
Target: >80%
5,000
Customers Tracked
Jan 2023 – Dec 2024
📊
Loading…
Key Metrics
All numbers reflect the currently selected filters
Total Customers
--
Active Customers
--
Churned Customers
--
Churn Rate
--
Monthly Recurring Revenue
--
Revenue Lost to Churn
--
Net Revenue Retention
--
Avg Customer Lifetime Value
--
Quick Insights
Top signals from the data — updated with every filter change
🏆
Best Performing Plan
--
--
⚠️
Highest Risk Plan
--
--
📢
Best Acquisition Channel
--
--
⏱️
Avg Months Before Churn
--
--
💰
ARPU (Avg Rev per User)
--
--
🌍
Top Region by Volume
--
--
Strategic Recommendations
Priority actions the business should take — ranked by urgency and revenue impact
🔴 Critical
🚀
Fix Onboarding — First 90 Days
Most churn happens in months 1–3. Customers leave before finding value.
Impact
Effort
→ Reduce 0–3mo churn by 30%
🔴 Critical
📦
Audit Basic Plan — Highest Churn Tier
Basic = 49% of customers, likely highest churn. Gate features to drive upsell to Pro.
Impact
Effort
→ Convert 15% Basic → Pro in Q1
🟡 High
📢
Shift Budget to Referral Channel
Referral & Organic customers retain better. Ads bring volume but drive churn.
Impact
Effort
→ Shift 20% budget to Referral/Organic
🟡 High
⚡
Build Early Churn Warning System
Define health score signals. Alert CS team 30 days before likely churn point.
Impact
Effort
→ Identify at-risk 30 days pre-churn
🔵 Medium
💎
Grow Premium Tier Mix
Premium = higher LTV + lower churn. Upsell Pro users at months 3 and 6.
Impact
Effort
→ Premium share 15% → 25% in 6mo
🔵 Medium
🔁
Win-Back Churned Cohorts
Target worst-performing cohorts from the matrix. They know the product — easiest to win back.
Impact
Effort
→ Recover 8–10% churned in 2 quarters
Trend Analysis
Monthly view — each bar or point = one cohort month
📉 Churn Rate by Month
Monthly churn rate per cohort. Rising = worsening. Flat/falling = improving.
Loading…
What You're Seeing
Each point on this line represents one cohort month — the % of customers who signed up in that month and eventually cancelled. A flat line means churn is consistent. A rising line means it's getting worse over time.
What's Healthy
Under 5% churn rate is best-in-class for SaaS. 5–15% is acceptable. Above 15% requires immediate attention. Above 25% is a business model risk.
What to Do With This
Identify the months with the highest spikes. Cross-filter by Plan or Channel to see if specific segments are driving the peak. That's where your retention work should focus first.
👥 New Signups vs Churned
Blue = acquired, Red = churned. The gap is your retained base.
Loading…
What You're Seeing
Blue bars = total customers acquired that month. Red bars = how many of that group eventually cancelled. The gap between blue and red is your retained base from each cohort.
The Business Risk
If red bars are consistently 30–40% the height of blue bars, the business has a "leaky bucket" problem — you're filling with one hand and losing with the other. Growth requires fixing the leak, not just pouring more in.
What to Do With This
Look for months where red is disproportionately large. Were those months high-volume acquisition pushes? If so, were acquisition channels used in those months lower quality (e.g., Ads vs Organic)?
💵 Active MRR by Cohort
MRR retained per cohort. Taller bars = better value retained.
Loading…
What You're Seeing
Each bar = the MRR still being collected from active customers within that cohort. This combines two things: how many survived, and what plan they're on. A tall bar means strong retention and/or higher-value plans.
Why This Matters More Than Headcount
100 surviving Basic customers ($10/mo each) = $1,000 MRR. 30 surviving Premium customers ($60/mo) = $1,800 MRR. Revenue retention beats headcount retention — premium mix matters.
What to Do With This
Find the strongest cohort bars. What made those cohorts different? Same channel? Same time of year? Different plan mix? Those patterns are your playbook for improving future cohorts.
📊 Revenue Kept vs Revenue Lost
Green = active MRR. Orange = permanently lost. Green should dominate.
Loading…
What You're Seeing
Green area = MRR still flowing in from active customers across all cohorts. Orange area = MRR permanently lost. Together they show your total potential MRR — how much you would have if nobody churned.
The Cost of Churn in Dollars
This chart makes the financial cost of churn visible in a way headcount numbers don't. When orange area grows relative to green, you're losing more revenue than you're keeping. NRR below 80% means the business is shrinking in revenue terms.
What to Do With This
The goal is to make the green area dominant. Every percentage point of churn reduction directly shrinks the orange. A 10% reduction in lost MRR adds directly to free cash flow with zero additional acquisition spend.
Segment Breakdown
Distribution of customers across plan, channel, and tenure
📦 Plan Mix
Customer split by plan. More Premium = higher ARPU + better retention.
Loading…
What You're Seeing
Customer distribution across subscription tiers. A heavy Basic-weighted mix means lower average revenue per user and typically higher churn — Basic customers have the least switching cost and the least product investment.
The Ideal Mix
Best-in-class SaaS companies aim for 30%+ of revenue from top tiers. More Premium customers = higher LTV, lower churn, better NRR, and more referral-worthy customers. This chart should shift right over time as upsells work.
What to Do With This
Use the Plan filter above to drill into each plan's churn rate separately. If Basic churn is 2–3× higher than Premium, that confirms an upsell-or-lose dynamic — the business should nudge Basic customers toward Pro early.
📣 Acquisition Channel Mix
Acquisition source. High volume ≠ high value — filter by channel to check churn rates.
Loading…
What You're Seeing
How customers were acquired — Organic search, paid Ads, Referral, or Partnership. Volume does not equal value. A channel that brings 40% of customers but 60% of churn is destroying value even while growing headcount.
Channel Quality vs Channel Quantity
Referral and Organic customers typically have 3–5× better retention than Ads customers — they arrive with higher intent and trust. Partnership customers are often the most sticky. Use the Channel filter to verify this in your own data.
What to Do With This
Filter this dashboard by each channel one at a time. Compare churn rates across channels. Invest more in channels where churn is lowest, regardless of volume. The goal is LTV-positive acquisition, not just more signups.
🕐 How Long Customers Stay
How long customers stayed. Large 0–3mo bar = onboarding problem.
Loading…
What You're Seeing
All customers bucketed by how long they stayed (or have been active). The 0–3 month bucket captures early churn — customers who left before the business recovered its acquisition cost. The 25+ month bucket represents your most loyal, highest-LTV segment.
The Early Churn Warning
If the 0–3 month bar is the tallest, the business has an onboarding/activation crisis. It means customers are not finding value fast enough. This is distinct from a product quality problem — it's a time-to-value problem.
What to Do With This
Focus retention investment on compressing time-to-value: faster setup, in-app guided tours, early success milestones, and proactive check-ins at day 7, 14, and 30. Getting customers past month 6 dramatically improves their lifetime value.
Cohort Retention Matrix
% of cohort still active N months after signup · Green = strong retention · Red = high dropout
Each row = one signup cohort · Each column = months since joining · Fast drops = poor onboarding · Use Plan/Channel filter to drill down
90–100% Excellent
75–90% Good
60–75% Caution
40–60% Warning
Below 40% Critical
Loading…
📖 How to Read This Table
Each row = one cohort (customers who signed up in the same month). Each column = months since joining. M+0 is always 100% because everyone starts active. M+6 shows what % of that group was still paying 6 months later.
Read across a row from left to right — watch how the numbers shrink. A fast drop from M+0 to M+3 signals early churn. A slow, gradual decline is healthier. If a cohort is still showing 60%+ at M+12, that is a strong cohort worth studying.
Read across a row from left to right — watch how the numbers shrink. A fast drop from M+0 to M+3 signals early churn. A slow, gradual decline is healthier. If a cohort is still showing 60%+ at M+12, that is a strong cohort worth studying.
🎯 What the CEO Should Look For
1. Rows with fast early drops (M+0 → M+3): These months had onboarding problems or low-quality acquisition. Find what was different about those months.
2. Consistent green across all rows at M+12: This would mean 12-month retention is solid. Red across the board means a systemic problem.
3. Improving pattern over time: If newer cohorts (bottom rows) show better retention than older ones (top rows), that means retention efforts are working.
2. Consistent green across all rows at M+12: This would mean 12-month retention is solid. Red across the board means a systemic problem.
3. Improving pattern over time: If newer cohorts (bottom rows) show better retention than older ones (top rows), that means retention efforts are working.
💡 How to Use the Filters With This Matrix
Select a single Plan in the filter bar above — then look at the matrix. If Basic plan cohorts show much faster decay than Premium cohorts, that confirms the plan-tier churn difference and tells you exactly where to focus intervention.
Similarly, filter by Channel to see if Ads-acquired cohorts decay faster than Referral cohorts. This kind of cut is extremely powerful for making budget allocation decisions.
Similarly, filter by Channel to see if Ads-acquired cohorts decay faster than Referral cohorts. This kind of cut is extremely powerful for making budget allocation decisions.
📐 Colour Key Explained
90–100% (Dark Green) = Excellent. Almost no churn in this window.
75–90% (Green) = Good. Within acceptable range for most SaaS models.
60–75% (Amber) = Caution. Worth monitoring — below SaaS median.
40–60% (Orange) = Warning. Significant churn — intervention needed.
Below 40% (Red) = Critical. More than 60% of this cohort has already churned.
75–90% (Green) = Good. Within acceptable range for most SaaS models.
60–75% (Amber) = Caution. Worth monitoring — below SaaS median.
40–60% (Orange) = Warning. Significant churn — intervention needed.
Below 40% (Red) = Critical. More than 60% of this cohort has already churned.