Retention Cohort Forecast
Forecast user retention with cohort analysis and LTV projections. Enter values for instant results with step-by-step formulas.
Formula
Cohort_t = Cohort_0 × Retention_Curve(t); Total_Active_t = Σ(All Cohorts × Their Retention at t); Projected Churn = Users × Monthly Churn Rate
The cohort retention formula projects how a user group decays over time based on observed retention curve. Total active users at any point sums all cohorts weighted by their age-specific retention. Churn calculation multiplies current users by churn rate to predict monthly losses. This works because retention typically follows predictable decay patterns—steep initial dropoff, then gradual ongoing churn. By modeling each cohort separately and aggregating, the forecast captures both growth (new cohorts) and decay (existing cohort churn).
Worked Examples
Example 1: Mobile App Launch
Problem:New app, 1,000 user cohort. Day 1: 35%, Day 7: 20%, Day 30: 12%. 6% monthly churn thereafter.
Solution:Retention curve shows 88% lost by Day 30. Of survivors, 6% monthly churn = average 16-month lifetime. Focus: improve Day 1→7 retention to 60%+ to retain the improvement downstream.
Result:12% D30 retention | Fair grade | LTV ~$160 | Improve early retention urgently
Example 2: SaaS Product
Problem:B2B tool, 500 signups. Day 1: 70%, Day 7: 55%, Day 30: 45%. 3% monthly churn.
Solution:Strong early retention. 45% make it to month 1. 3% churn = ~33 month average lifetime. Excellent unit economics if acquisition is efficient.
Result:45% D30 retention | Excellent grade | LTV ~$1,650 | Focus on growth
Example 3: E-commerce Cohort
Problem:1,000 new customers. Day 1: 25%, Day 7: 18%, Day 30: 8%. 8% monthly churn.
Solution:Very high early churn typical for e-commerce (many one-time buyers). Focus on converting Day 30 survivors to repeat buyers. Loyalty programs target this 8%.
Result:8% D30 retention | Typical for e-commerce | Focus on repeat conversion
Frequently Asked Questions
What is cohort retention analysis?
Cohort analysis groups users by signup date and tracks what percentage remain active over time. This reveals retention patterns, identifies when churn happens, and enables comparison between cohorts to measure improvement.
What's a good Day 1 retention rate?
Varies by product. Consumer apps: 30-50%. B2B SaaS: 60-80%. Games: 20-40%. Social apps: 40-60%. Day 1 is critical—users who don't return immediately often never return.
How do I improve Day 1 retention?
Deliver value immediately. Show quick wins in onboarding, reduce friction to aha moment, use welcome emails or push notifications, and make Day 1 experience exceptional. Many apps lose users before they experience core value.
What is good 30-day retention?
Consumer apps: 10-25%. B2B SaaS: 60-80%. E-commerce: 5-15%. Context matters—complex products expect higher retention; simple/casual apps accept lower. 30-day retention strongly predicts long-term retention.
How does churn rate relate to retention?
Monthly churn = users lost / beginning users. Retention = users remaining. They're inverses: 5% monthly churn = 95% monthly retention. Cumulative retention compounds: 95% retention for 12 months = 54% yearly retention.
When should I worry about retention?
Immediately. Retention issues manifest quickly. If Day 1 or Day 7 retention is low, fix onboarding before scaling acquisition. Pouring users into a leaky bucket wastes marketing spend.
How do I forecast retention for new cohorts?
Use historical cohort curves as baseline, adjust for recent product changes, apply expected improvements from retention initiatives, and model multiple scenarios. Conservative forecasting prevents over-optimistic projections.
What's the retention curve shape?
Most products show steep early drop, then flattening. Might lose 60% in first day, 80% in first week, 90% in first month, then slow decay. The curve shape reveals when and why users leave.
How does retention affect LTV?
LTV approximation: (1 / churn rate) × average revenue per period. 5% monthly churn = 20-month average lifetime. Reducing churn from 5% to 4% increases LTV by 25%. Small retention improvements compound to huge LTV impact.
How do I forecast revenue?
Bottom-up forecasting multiplies expected units sold by price. Top-down starts with market size and estimates market share. For existing businesses, use historical growth rates with adjustments. For SaaS: Forecast MRR = Current MRR + New MRR - Churned MRR + Expansion MRR. Always model best, expected, and worst case scenarios.