Expansion Revenue ARR Cohort Tracker
Track expansion ARR by cohort. Enter Year 1 starting ARR and the expansion rate for each year — see total ARR, expansion ARR, and 5-year cumulative expansion compounding. Compare to OpenView benchmarks (top quartile 200%+ by Year 5). Free, private.
| Year | ARR | Expansion ARR | Cohort Rate | Benchmark |
|---|
What is expansion revenue cohort tracking?
Cohort expansion tracking groups customers by acquisition period (year, quarter, or month) and follows their ARR over time. A cohort's expansion rate at Year N = (Cohort ARR at Year N ÷ Cohort ARR at Year 1) × 100. Per Bessemer State of the Cloud 2026, top-quartile SaaS cohorts show: Y2 = 115-120%, Y3 = 130-140%, Y4 = 145-160%, Y5 = 160-200%+. Cohorts that flatten at 100% are healthy retention but no expansion engine. Cohorts declining below 100% indicate net churn — a major red flag for fundraising.
This calculator shows how a single Year 1 starting cohort compounds over 5 years given your expansion rates. It illustrates the dramatic effect of compounding — a 115% Y2 + 130% Y3 + 145% Y4 + 160% Y5 cohort ends Year 5 with 1.6x the starting ARR, generating 60% incremental ARR purely from existing customers.
Why expansion is more valuable than new logo
Expansion revenue is dramatically more capital-efficient than new logo: (1) Zero acquisition cost — these customers already exist. (2) Higher gross margin — no S&M cost. (3) Longer LTV — expanded customers churn 20-40% less than non-expanded. (4) Higher valuation multiple — investors weight $1 of expansion ARR at 3-5x $1 of new logo ARR in DCF models because expansion predicts NRR durability. Per Forrester ROI Research, public SaaS companies with 130%+ NRR trade at 2x the revenue multiple of those at 100% NRR.
How to drive cohort expansion
Top expansion levers: (1) Usage-based pricing — customers expand naturally as usage grows. Snowflake, Datadog, Twilio show 130-150% NRR from usage growth alone. (2) Multi-product strategy — cross-sell additional products to existing accounts. HubSpot's Hubs strategy drove NRR from 100% to 110%+. (3) Persona expansion — sell into adjacent teams (engineering → marketing → ops). Notion went from per-user to team-wide adoption. (4) Higher tier upgrades — clear upgrade path with feature/seat thresholds at 5, 10, 50, 100 seats. (5) Customer Success investment — proactive CSMs drive 25-40% more expansion than reactive support. (6) Annual contract upgrades at renewal — bundle expansion into renewal motion.
Benchmark cohort expansion by SaaS type
Different SaaS models show different expansion curves. Usage-based infrastructure (Snowflake, Datadog, MongoDB): Y5 = 200%+ — natural growth as customers use more. Seat-based collaboration (Slack, Notion, Figma): Y5 = 140-180% — depends on team growth. Enterprise platform (Salesforce, Workday): Y5 = 130-160% — multi-year contracts plus add-on products. Vertical SaaS (Veeva, Shopify): Y5 = 120-150% — TAM-limited but high retention. SMB-focused single-product: Y5 = 100-115% — limited expansion paths. Compare your cohort curves to these to identify expansion opportunity gaps.
Sources: Bessemer State of the Cloud 2026 (bessemer.com), OpenView SaaS Benchmarks Report 2026 (openview.com), Forrester Customer Lifetime Value Research 2026, Gartner SaaS Retention Benchmarks 2026 (gartner.com), Salesforce State of Sales 2026 (salesforce.com). Last updated: May 2026.