Why SaaS Metrics Modeling Matters
Most SaaS founders know their MRR. Far fewer can tell you their net revenue retention, CAC payback period, or gross margin by cohort. That gap is exactly what separates operators from storytellers. Investors who write $5M+ checks model your business before saying yes — so you should model it first. This guide gives you the exact framework, formulas, and benchmarks to do it right.
Master the Core SaaS Metrics Vocabulary
Before you model anything, every number in your business needs a precise definition. Investors use standard definitions — if yours differ, you'll confuse them and lose credibility. Here are the eight numbers that matter most:
MRR
Monthly Recurring Revenue. The sum of all normalized monthly subscription revenue. Annual contracts divided by 12. Never include one-time fees or professional services.
ARR
Annual Recurring Revenue. MRR × 12. Use ARR for storytelling and fundraising; use MRR for operational tracking. Never mix them.
Gross Revenue Retention (GRR)
Revenue retained from existing customers excluding expansion. GRR can never exceed 100%. Formula: (Beginning MRR − Churn − Contraction) ÷ Beginning MRR.
Net Revenue Retention (NRR)
GRR plus expansion revenue from existing customers. NRR above 100% means your cohorts grow over time — the holy grail of SaaS. Formula: (Beginning MRR − Churn − Contraction + Expansion) ÷ Beginning MRR.
CAC
Customer Acquisition Cost. All sales + marketing spend ÷ new customers acquired in the same period. Include salaries, commissions, ad spend, and tooling.
LTV
Customer Lifetime Value. Average MRR per customer × Gross Margin % ÷ Monthly Churn Rate. This is the revenue a customer generates net of delivery costs over their lifetime.
CAC Payback Period
How many months until you recoup what you spent to acquire a customer. Formula: CAC ÷ (Average MRR per customer × Gross Margin %). Under 12 months is great; under 18 is acceptable.
LTV:CAC Ratio
The single most important unit economics ratio. LTV ÷ CAC. 3:1 is the minimum threshold investors want to see. 5:1+ is excellent. 10:1+ often means you're underinvesting in growth.
Pro tip
Build a one-page glossary for your company with exact definitions for each metric. When you share numbers with investors, advisors, or the board, everyone should be using the same formulas.
Build Your MRR Waterfall
The MRR waterfall is the most important operational view of a SaaS business. It breaks down every dollar of MRR movement in a month into four buckets. Without it, you can't understand whether growth is coming from new customers or expansion — or whether churn is accelerating underneath a healthy topline.
The Four Buckets
New MRR
Revenue from brand new customers this month. A customer who signs their first contract contributes to New MRR regardless of contract length.
Expansion MRR
Incremental revenue from existing customers — upgrades, add-ons, seat expansions. This is your most capital-efficient growth because CAC is near zero.
Contraction MRR
Revenue lost from existing customers who downgraded — not churned entirely, just paying less. Often a leading indicator of future churn.
Churned MRR
Revenue lost from customers who cancelled entirely this month. Track both the dollar amount and the customer count separately — they tell different stories.
MRR Waterfall Example
| Metric | Jan | Feb | Mar |
|---|---|---|---|
| Beginning MRR | $80,000 | $91,200 | $104,050 |
| + New MRR | +$12,000 | +$14,000 | +$16,500 |
| + Expansion MRR | +$3,000 | +$2,500 | +$4,200 |
| − Contraction MRR | −$800 | −$650 | −$900 |
| − Churned MRR | −$3,000 | −$3,000 | −$3,500 |
| Ending MRR | $91,200 | $104,050 | $120,350 |
| MoM Growth | 14.0% | 14.1% | 15.7% |
Watch the churn signal
In the example above, churned MRR is growing each month even as total MRR grows fast. That's a yellow flag — high new MRR can mask deteriorating retention. Always look at each bucket in isolation, not just the net number.
Calculate CAC and Payback Period
CAC is the number founders most consistently undercount. The formula seems simple — sales + marketing spend ÷ new customers — but most founders forget to include salaries, commission, and tooling costs. Getting this wrong makes your unit economics look artificially great until a sophisticated investor rebuilds the model.
What to include in CAC
- Sales rep salaries + commissions + benefits
- Marketing team salaries + benefits
- Paid ad spend (Google, LinkedIn, Meta)
- SEO and content creation costs
- CRM and sales tools (Pipedrive, Apollo, etc.)
- Events, conferences, and sponsorships
- Outbound tooling (lemlist, enrichment)
CAC Payback Period Formula
// Full formula
CAC Payback =
CAC
÷ (Avg MRR per customer × Gross Margin %)
Example: $2,400 CAC ÷ ($200 MRR × 75% gross margin) = 16 months payback. That's on the high side — you want to get it under 12 months for efficient growth.
Blended vs. new-logo CAC
Track two CAC numbers: blended (all new customers) and new-logo (first-time customers only, excluding expansion). Blended CAC looks better when you have strong expansion — but investors want to see new-logo CAC separately to understand your true acquisition efficiency.
Model Gross and Net Revenue Retention
Retention is the single most important signal of product-market fit in SaaS. A company with 120% NRR can grow to $100M ARR with half the new customer acquisition of a company with 80% NRR. If you're not measuring retention by cohort, you're flying blind.
GRR vs. NRR — Benchmark Table
| Segment | Good GRR | Great GRR | Good NRR | Great NRR |
|---|---|---|---|---|
| SMB (ACV < $5K) | 80%+ | 85%+ | 95%+ | 105%+ |
| Mid-Market ($5K–$50K) | 85%+ | 90%+ | 100%+ | 110%+ |
| Enterprise (ACV > $50K) | 90%+ | 95%+ | 105%+ | 120%+ |
| Infrastructure / Usage | 85%+ | 90%+ | 110%+ | 130%+ |
How to calculate GRR
GRR = (Jan MRR − Churned MRR − Contraction MRR)
÷ Jan MRR
Example: ($80K − $3K − $0.8K) ÷ $80K = 95.3% GRR
How to calculate NRR
NRR = (Jan MRR − Churned MRR − Contraction MRR
+ Expansion MRR)
÷ Jan MRR
Example: ($80K − $3K − $0.8K + $3K) ÷ $80K = 99.0% NRR
Build Your Unit Economics Model
Unit economics answers the fundamental question: does each customer make you money? A business with bad unit economics can still grow fast in the short term — but it's building on a broken foundation. LTV:CAC ≥ 3:1 with a payback period under 18 months is the minimum bar for most Series A investors.
LTV Formula (Two Methods)
Simple Method
LTV = ARPU × Avg Customer Lifetime
Avg Lifetime = 1 ÷ Monthly Churn Rate
Gross Margin Method (Preferred)
LTV = (ARPU × Gross Margin %)
÷ Monthly Churn Rate
Unit Economics Benchmarks by Stage
| Metric | Seed | Series A | Series B |
|---|---|---|---|
| LTV:CAC | 2:1+ | 3:1+ | 4:1+ |
| CAC Payback (months) | <24 | <18 | <12 |
| Gross Margin | 60%+ | 70%+ | 75%+ |
| Monthly Churn Rate | <3% | <2% | <1.5% |
| NRR | 90%+ | 100%+ | 110%+ |
The single most important insight
A 1% improvement in monthly churn has a disproportionate impact on LTV. If your ARPU is $500/month, your gross margin is 75%, and you cut monthly churn from 2.5% to 1.5%, LTV goes from $15,000 to $25,000 — a 67% increase in unit economics without touching CAC. Retention is leverage.
Set Up a Live Metrics Dashboard
A metrics model is only useful if it updates automatically. If you're rebuilding your MRR waterfall manually in a spreadsheet every month, you're wasting hours and introducing errors. The goal is a live dashboard where every number pulls directly from your CRM and billing data.
Billing Source
Stripe, Chargebee, or Recurly should be your source of truth for MRR. Connect them via native integrations or a data pipeline. Every subscription event — new, upgrade, downgrade, cancel — should flow automatically.
CRM for CAC
Your CRM tracks pipeline stages, deal velocity, and close rates — the inputs for understanding sales efficiency. Pipedrive and Capsule both connect to reporting tools via API.
Product Analytics
Behavioral retention (feature adoption, DAU/MAU, session frequency) is the leading indicator for revenue retention. Amplitude gives you cohort retention charts out of the box.
Start simple
You don't need a $50K data warehouse on day one. A Google Sheet pulling from Stripe via Zapier, updated weekly, beats a manual model updated monthly. Automate incrementally as your team grows and the complexity justifies it.
Recommended Tools for SaaS Metrics
These are the tools I recommend to the founders I work with for tracking product behavior, managing the sales pipeline, and understanding customer engagement.
Amplitude
Best-in-class product analytics with cohort retention, funnel analysis, and behavioral NRR correlation. If you want to know which features drive retention and which predict churn, Amplitude is the answer.
See Amplitude reviewPipedrive
CRM built for sales teams. Tracks deal stages, pipeline velocity, and close rates — the inputs you need to model blended and new-logo CAC accurately over time.
See Pipedrive reviewCapsule CRM
Lightweight CRM for early-stage teams. Great for tracking customer health, renewal dates, and expansion opportunities without the overhead of enterprise tools.
See Capsule review6 Common SaaS Metrics Mistakes
Including non-recurring revenue in MRR
Professional services, setup fees, and one-time payments are not MRR. Including them inflates your ARR and will immediately raise red flags with any investor who looks closely at your billings data.
Reporting logo churn instead of revenue churn
Losing 10% of customers is bad. But if those were your smallest customers, your revenue churn might only be 3%. Report both — but revenue churn is the number that matters for unit economics.
Underestimating CAC with a too-short lookback
If you hired two SDRs in January and they close deals in June, you need to include their January–June salaries in the CAC calculation for those deals. Use a rolling 3-6 month average, not the same-month spend.
Using LTV without a gross margin adjustment
LTV = ARPU ÷ Churn tells you revenue lifetime, not profit lifetime. If your gross margin is 60%, your real LTV is 40% lower. Always calculate LTV on gross margin, not revenue.
Not tracking cohorts
Aggregate NRR hides the story. A 100% NRR could be hiding strong early cohorts masking deteriorating recent ones. Run cohort retention tables — every investor will ask for them at Series A.
Forgetting to normalize contract length
A customer who pays $12,000 upfront for an annual contract is worth $1,000 MRR, not $12,000 MRR. Always normalize to monthly when building your waterfall or you'll see phantom spikes every renewal period.