Customer Cohort Retention Curve Calculator
Best-in-class SaaS companies have 'smiling' cohort retention curves — Net Revenue Retention exceeds 100% as expansion outpaces churn. Most companies have 'frowning' curves. Model your cohort retention and project the long-term revenue impact.
| Month 0 Cohort Revenue | — |
| Month 1 Gross Retention | — |
| Month 12 Gross Retention | — |
| Month 12 Expansion % | — |
| Monthly Churn Rate | — |
| Monthly Expansion Rate | — |
| Cumulative Cohort Revenue | — |
| Average Monthly Revenue | — |
| LTV Multiple | — |
| Final NRR | — |
Smiling vs Frowning Curves
A cohort retention curve plots the revenue from a cohort (group of customers acquired in the same period) over time. The shape tells you everything about the business.
Smiling curve: revenue declines initially (some churn), then rises as expansion outpaces remaining churn. NRR ends above 100%. Frowning curve: revenue declines steadily over time as churn outpaces expansion. NRR below 100%.
Source: OpenView Partners + Bessemer SaaS benchmarks
Why Smiling Curves Matter
Top SaaS companies (Snowflake 158% NRR, MongoDB 122%, Datadog 130%) achieve smiling curves. The economic value: every cohort grows revenue without new sales effort. Acquisition cost amortizes faster, valuation multiples higher (revenue compounds).
Frowning curves are more common in B2B SaaS. Achievable NRR depends on product category: usage-based products (Snowflake, AWS) easily expand; flat-fee products (Salesforce Essentials) struggle. Pricing model is the single biggest lever.
How to Push Toward Smiling
(1) Usage-based pricing components — customers grow → bills grow. (2) Seat expansion within accounts — sell to more users in same company. (3) Multi-product attach — sell adjacent products to existing customers. (4) Premium feature gates — upsell to higher tiers.
Hardest to fix: B2C consumer SaaS where users individually consume — limited expansion path. Workarounds: family/team plans, premium AI features (variable cost), success-based pricing.
Cohort Analysis in Practice
Run cohort analysis monthly. Group customers by signup month. Track each cohort's revenue retention over time. Watch for: (a) different cohorts behave differently — product changes affect retention, (b) seasonal patterns, (c) early indicators of churn before it shows in MRR.
Tools: ChartMogul, Baremetrics, Profitwell. Or roll your own with SQL queries against your billing data. The data is essential for predicting MRR growth accurately.