SaaS Metrics Dashboard Template - Track the Numbers That Matter
A metrics dashboard template covering MRR, ARR, churn, activation, trial-to-paid, NPS, CAC, LTV, LTV:CAC, and retention benchmarks.
Built for practical use
Core SaaS KPIs
A metrics dashboard template covering MRR, ARR, churn, activation, trial-to-paid, NPS, CAC, LTV, LTV:CAC, and retention benchmarks.
Formula guidance
A metrics dashboard template covering MRR, ARR, churn, activation, trial-to-paid, NPS, CAC, LTV, LTV:CAC, and retention benchmarks.
Benchmark context
A metrics dashboard template covering MRR, ARR, churn, activation, trial-to-paid, NPS, CAC, LTV, LTV:CAC, and retention benchmarks.
Dashboard design recommendations
A metrics dashboard template covering MRR, ARR, churn, activation, trial-to-paid, NPS, CAC, LTV, LTV:CAC, and retention benchmarks.
Part 10: How to Use This Dashboard
Weekly check-ins
Monitor these weekly:
- New MRR / Expansion / Churn
- Activation rate of recent signup cohort
- Support ticket volume (leading indicator of churn)
Monthly reviews
Review these monthly:
- Full metrics dashboard
- NRR trend
- CAC by channel
- Cohort retention curves
Quarterly planning
Use these for strategic planning:
- LTV:CAC by segment
- Rule of 40 trend
- Gross margin trend
- Market / competitive benchmarks
Annual
- Complete financial review
- Valuation benchmarking
- Long-term projection vs. actuals
Calculate Your Core SaaS Metrics
Plug in the baseline numbers and review the output for growth, churn, and efficiency metrics.
| Input | Value | Calculated Metric | Output |
|---|---|---|---|
| Starting MRR | Ending MRR | 0 | |
| New MRR | ARR | 0 | |
| Expansion MRR | MRR Growth Rate | 0% | |
| Churned MRR | ARPA | 0 | |
| Customers at start | Customer churn | 0% | |
| Customers lost | CAC | 0 | |
| Customers gained | LTV | 0 | |
| Sales & marketing spend | LTV:CAC | 0 | |
| Gross margin (%) | CAC payback (months) | 0 |
Why This Exists
Every SaaS founder, product manager, and operator needs a dashboard showing the handful of numbers that actually determine whether the business is working. This document covers:
- Which metrics to track (15 essential KPIs, organized by category)
- How to calculate each one (exact formulas)
- What "good" looks like (industry benchmarks)
- How to visualize them (dashboard design patterns)
- How to spot issues before they become crises
Sources include David Skok's For Entrepreneurs, Lenny Rachitsky's SaaS benchmark survey, SaaS Capital research, ChartMogul benchmark reports, KeyBanc Capital Markets SaaS Survey, and OpenView Partners research.
Who this is for: SaaS founders, CFOs, product/revenue leaders, and agencies consulting on SaaS business health.
Part 1: The 4 Categories of SaaS Metrics
Every SaaS business needs to track metrics across four dimensions:
Category 1: Revenue Metrics
How much money is coming in, at what rate?
- MRR (Monthly Recurring Revenue)
- ARR (Annual Recurring Revenue)
- MRR Growth Rate
- ARPU / ARPA (Average Revenue Per User / Account)
Category 2: Customer Acquisition Metrics
How efficient is our growth engine?
- CAC (Customer Acquisition Cost)
- CAC Payback Period
- LTV (Customer Lifetime Value)
- LTV:CAC Ratio
Category 3: Retention Metrics
Are customers staying (and growing)?
- Churn Rate (Customer and Revenue)
- NRR / NDR (Net Revenue Retention / Net Dollar Retention)
- GRR (Gross Revenue Retention)
- Activation Rate
Category 4: Efficiency Metrics
How capital-efficient is the business?
- Rule of 40
- Gross Margin
- Burn Multiple
- Magic Number / Sales Efficiency
Part 2: Revenue Metrics
Metric 1: Monthly Recurring Revenue (MRR)
What it is: The normalized monthly recurring revenue from all active subscriptions.
Formula:
MRR = Sum of all active subscriptions (normalized to monthly billing)Critical detail: If you have annual contracts, divide by 12 to get the monthly equivalent. A $1,200/year annual contract = $100 MRR, not $1,200 in the month paid.
MRR components to track:
- New MRR — from new customers this period
- Expansion MRR — existing customers upgrading
- Contraction MRR — existing customers downgrading
- Churned MRR — customers who canceled
- Net New MRR = New + Expansion – Contraction – Churned
Why it matters: MRR is the truest measure of your recurring revenue health. Unlike total billings, MRR smooths out annual vs. monthly contracts and seasonal billing cycles.
Benchmark: Not applicable — MRR is absolute. What matters is the growth rate (see next metric).
Metric 2: Annual Recurring Revenue (ARR)
What it is: MRR × 12 — the annualized run rate of recurring revenue.
Formula:
ARR = MRR × 12Why it matters: ARR is the standard metric for SaaS company valuation. Investors talk in ARR, not MRR. Also smooths out monthly variation for a clearer long-term view.
Valuation context: Early-stage SaaS companies are often valued at 5-10× ARR. Public SaaS companies currently trade at 6-15× ARR depending on growth rate and efficiency.
Key ARR milestones:
- $100K ARR: Product-market fit validation
- $1M ARR: Series A readiness (typical)
- $10M ARR: Series B range; achieved by only ~13% of SaaS startups within 10 years (ChartMogul)
- $100M ARR: Public SaaS scale
Metric 3: MRR Growth Rate
What it is: The percentage increase in MRR from one period to the next.
Formula:
MRR Growth Rate = ((MRR this period − MRR last period) / MRR last period) × 100Example: January MRR = $10,000. February MRR = $11,500. Growth rate = (($11,500 − $10,000) / $10,000) × 100 = 15% MoM
Benchmarks (monthly growth rate by stage):
| Stage | "Good" | "Great" | "Exceptional" |
|---|---|---|---|
| Pre-$1M ARR | 10% MoM | 15-20% MoM | 25%+ MoM |
| $1M–$10M ARR | 8% MoM | 10-15% MoM | 20%+ MoM |
| $10M–$50M ARR | 4-7% MoM | 8-10% MoM | 12%+ MoM |
| $50M+ ARR | 2-4% MoM | 4-6% MoM | 8%+ MoM |
The 3-3-2-2-2 Rule (revenue growth benchmark for early-stage SaaS): Triple ARR in year 1, triple in year 2, double in years 3-5.
Metric 4: ARPU / ARPA (Average Revenue Per User / Account)
What it is: The average MRR generated per customer.
Formula:
ARPU = MRR / Number of Active CustomersWhy it matters: Shows whether you're moving upmarket (ARPU rising) or downmarket (ARPU falling). Also informs pricing strategy.
Benchmarks:
- B2C SaaS: $10-50/month typical
- SMB SaaS: $50-500/month typical
- Mid-market SaaS: $500-5,000/month typical
- Enterprise SaaS: $5,000+/month typical
Part 3: Customer Acquisition Metrics
Metric 5: Customer Acquisition Cost (CAC)
What it is: The total cost of acquiring a new customer.
Formula:
CAC = (Total Sales & Marketing Costs) / (Number of New Customers Acquired)What to include in Sales & Marketing costs:
- Marketing salaries and benefits
- Advertising spend
- Content creation costs
- Marketing tools and software
- Sales salaries, commissions, benefits
- Sales tools and software
- Attributable portion of agency/contractor fees
Example: In Q1, you spent $150,000 on sales & marketing and acquired 100 new customers. CAC = $150,000 / 100 = $1,500
Benchmark: CAC varies wildly by ACV (Annual Contract Value). The relevant check is CAC Payback Period and LTV:CAC ratio (below).
Metric 6: CAC Payback Period
What it is: The number of months it takes to recover the cost of acquiring a customer.
Formula:
CAC Payback Period = CAC / (ARPU × Gross Margin)Example: CAC = $1,500. ARPU = $250/month. Gross margin = 80%. CAC Payback = $1,500 / ($250 × 0.80) = $1,500 / $200 = 7.5 months
Benchmarks:
- Under 12 months: Healthy — industry target for most SaaS
- 12-18 months: Acceptable for high-ACV enterprise SaaS with strong retention
- Over 18 months: Problematic — requires significant runway or high NRR to justify
- Best-in-class: Under 6 months
Metric 7: Customer Lifetime Value (LTV)
What it is: The total revenue a customer generates during their entire relationship with your company.
Simple formula (constant ARPU, no expansion):
LTV = ARPU / Customer Churn RateMore accurate formula (with gross margin):
LTV = (ARPU × Gross Margin) / Customer Churn RateExample:
- ARPU = $100/month
- Gross Margin = 80%
- Monthly churn rate = 5%
LTV = ($100 × 0.80) / 0.05 = $1,600
Important caveat: LTV is highly sensitive to churn rate assumptions. At 2% monthly churn, average customer lifespan is 50 months. At 5%, it's 20 months. Small churn improvements dramatically increase LTV.
Why this matters: For early-stage companies with limited historical data, LTV is more of an estimate than a hard number. Track it, but don't overweight it in decisions.
Metric 8: LTV:CAC Ratio
What it is: The ratio of customer lifetime value to customer acquisition cost — the single most important unit economics metric.
Formula:
LTV:CAC Ratio = LTV / CACBenchmarks:
- Below 1:1: Losing money on every customer (critical problem)
- 1:1 to 3:1: Borderline — often means CAC is too high or LTV too low
- 3:1 (standard target): Healthy unit economics — David Skok's well-known rule
- 5:1+ (best-in-class): KeyBanc Capital Markets reports top-quartile SaaS companies achieve 5:1 or better
- Above 10:1: Often indicates under-investment in growth
The 3:1 rule comes from David Skok (For Entrepreneurs): Anything below 3:1 suggests either CAC is too high, LTV is too low (likely due to churn), or you're at an early stage with insufficient data to be conclusive.
Part 4: Retention Metrics
Metric 9: Customer Churn Rate
What it is: The percentage of customers who cancel in a given period.
Formula:
Customer Churn Rate = (Customers Lost in Period / Customers at Start of Period) × 100Example: Started the month with 500 customers. Lost 25 during the month. Customer Churn Rate = (25 / 500) × 100 = 5% monthly churn
Benchmarks:
| Type | Monthly Churn | Annual Churn |
|---|---|---|
| B2C SaaS | 3-8% | 30-70% |
| SMB SaaS | 3-7% | 35-60% |
| Mid-Market SaaS | 1-2% | 10-20% |
| Enterprise SaaS | 0.5-1% | 5-10% |
Best-in-class: Under 2% monthly, under 10% annually.
Annual benchmark: The average annual customer churn rate for SaaS companies is around 5-7% (per RevPartners and ChartMogul benchmark reports).
Metric 10: Revenue Churn Rate (Gross MRR Churn)
What it is: The percentage of MRR lost to cancellations and downgrades.
Formula:
Revenue Churn Rate = (MRR Lost to Churn + Contraction) / MRR at Start of Period × 100Why track this separately from customer churn: Losing a $10,000/month enterprise customer is different from losing a $50/month SMB customer. Revenue churn weights by value.
Benchmarks:
- Under 1% monthly gross MRR churn: Excellent
- 1-2% monthly: Good
- Over 5% monthly: Problematic
Metric 11: Net Revenue Retention (NRR) / Net Dollar Retention (NDR)
What it is: Percentage of recurring revenue retained from existing customers over a period, including expansion, contraction, and churn.
Formula:
NRR = (Starting MRR − Churned MRR − Contraction MRR + Expansion MRR) / Starting MRR × 100Example:
- Starting MRR = $50,000
- Churned MRR = $1,500
- Contraction MRR = $500
- Expansion MRR = $3,000
NRR = ($50,000 − $1,500 − $500 + $3,000) / $50,000 × 100 = 102%
Benchmarks:
- Below 90%: Poor — significant expansion challenges
- 90-100%: Average
- 100-110%: Good — healthy expansion offsetting churn
- 110-120%: Great — best-in-class benchmark from SaaS Capital
- 120%+: Exceptional — very few companies achieve this sustainably
Why NRR matters: An NRR above 100% means your existing customer base grows revenue even without acquiring any new customers. It's the single strongest indicator of product-market fit and expansion opportunity.
Industry context: The median NRR across SaaS is ~102% (SaaS Capital). Public SaaS companies average ~114%.
Metric 12: Gross Revenue Retention (GRR)
What it is: Same as NRR but excludes expansion — it shows how much recurring revenue you'd retain if no customer expanded.
Formula:
GRR = (Starting MRR − Churned MRR − Contraction MRR) / Starting MRR × 100GRR is always ≤ NRR (GRR excludes the positive impact of expansion).
Benchmarks:
- 85-95%: Good for SaaS
- 95-100%: Best-in-class
- Below 85%: Retention problem
Why track both NRR and GRR:
- NRR shows the full picture including growth from existing customers
- GRR shows how "sticky" your product is without relying on upsells to mask churn
- A huge gap between NRR and GRR means you're masking churn problems with expansion revenue
Metric 13: Activation Rate
What it is: Percentage of new signups who reach the activation event (key action correlated with retention).
Formula:
Activation Rate = (Activated Users / Total Signups) × 100Benchmarks (see also Resource 2: SaaS Onboarding Playbook):
- Below 20%: Major onboarding problem
- 20-40%: Typical for most SaaS
- 40-60%: Good
- 60%+: Excellent
Industry median: 25-34% (per Lenny Rachitsky's SaaS benchmark survey).
Part 5: Efficiency Metrics
Metric 14: Rule of 40
What it is: A simple efficiency benchmark: growth rate + profit margin should exceed 40%.
Formula:
Rule of 40 = Revenue Growth Rate (%) + Profit Margin (%)What counts as profit margin:
- Most commonly: EBITDA margin
- Alternatives: Operating margin, free cash flow margin
- For early-stage: Burn rate as a percentage of revenue (negative)
Example:
- Company A: 80% growth, -30% EBITDA margin = Rule of 40 = 50 (passes)
- Company B: 10% growth, 25% EBITDA margin = Rule of 40 = 35 (fails)
- Company C: 30% growth, 20% EBITDA margin = Rule of 40 = 50 (passes)
Why it matters: Rule of 40 forces the trade-off between growth and profitability. You can prioritize either, but the combined number must clear 40%.
Benchmarks:
- Below 20: Concerning — neither growing fast enough nor efficient enough
- 20-40: Below target
- 40+: Standard healthy SaaS benchmark
- 60+: Best-in-class
Metric 15: Gross Margin
What it is: The percentage of revenue remaining after subtracting the cost of delivering your product.
Formula:
Gross Margin = ((Revenue − COGS) / Revenue) × 100COGS (Cost of Goods Sold) for SaaS typically includes:
- Cloud hosting (AWS, Azure, GCP)
- Third-party APIs and services
- Customer support salaries
- Payment processing fees
- Content delivery networks
- Security, compliance, monitoring tools
Benchmarks:
- SaaS gross margin target: 70-80%+
- Best-in-class: 80-85%+
- Below 60%: Review your architecture — SaaS should have high gross margins
- Below 50%: Either not truly SaaS or major efficiency problems
Why gross margin matters:
- It's a ceiling on your LTV (see LTV formula)
- Investors pay more for high-gross-margin businesses
- It determines how much you can invest in CAC
Part 6: Dashboard Layout Template
A well-designed SaaS metrics dashboard has three tiers:
Tier 1: Hero Metrics (Top of Dashboard)
Display 4-6 of the most important numbers prominently:
| Metric | Current | Previous | Change | Target |
|---|---|---|---|---|
| ARR | $2.4M | $2.1M | +14% | $3M |
| MRR Growth Rate | 8% | 10% | -2pp | 10% |
| NRR | 108% | 105% | +3pp | 115% |
| CAC Payback | 9 mo | 11 mo | -2 mo | <12 mo |
| LTV:CAC | 3.8:1 | 3.2:1 | +0.6 | >3:1 |
| Churn (monthly) | 2.1% | 2.4% | -0.3pp | <2% |
Tier 2: Trend Charts (Middle of Dashboard)
- MRR over time (line chart with New / Expansion / Churn / Contraction stacked)
- Customer count over time
- NRR by cohort
- CAC trend by acquisition channel
Tier 3: Detailed Tables (Bottom of Dashboard)
- Customer churn list (recent churn for follow-up)
- Expansion opportunities (customers nearing upgrade thresholds)
- Activation funnel (signup → activation conversion rate)
- Top customer accounts by revenue
Part 7: Dashboard Design Best Practices
(See also Resource 5: SaaS Dashboard Design Guidelines for detailed guidance.)
Do:
- Lead with what matters most. Hero metrics first. Don't bury ARR on page 3.
- Show context. Every number needs a comparison (vs. last period, vs. goal, vs. benchmark).
- Color-code status. Green/yellow/red based on threshold performance.
- Make drill-down easy. Click a number to see the underlying data.
- Keep it current. Show "last updated" timestamp. Stale data is worse than no data.
- Segment by product line, customer tier, geography when relevant.
Don't:
- Show every metric. Pick 15-20 for a dashboard. More becomes noise.
- Use 3D charts. They distort perception.
- Ignore mobile. Executives check dashboards on phones.
- Require login in 5 places. Single sign-on for data access.
- Update quarterly. Real-time or daily is the standard.
Part 8: Red Flags to Watch For
Red Flag 1: Declining NRR
If NRR drops below 100%, expansion isn't offsetting churn. Investigate why existing customers aren't expanding (or are contracting).
Red Flag 2: Increasing CAC with stable ARPU
If CAC is rising but customer spend isn't, your payback period stretches and LTV:CAC worsens. Diagnose: is it ad saturation, channel fatigue, or worse product-market fit?
Red Flag 3: Churn rising at specific cohorts
If certain customer cohorts churn more (e.g., customers acquired through a specific channel, or who signed up during a specific month), dig into why. This is often a leading indicator of broader product/market shifts.
Red Flag 4: Gross margin compression
If gross margin is falling, either hosting/infrastructure costs are rising faster than revenue, or you've added unprofitable revenue streams (e.g., services revenue with lower margins).
Red Flag 5: LTV:CAC approaching or below 1:1
You're losing money on every customer. Immediate attention: either reduce CAC (better targeting, better conversion) or increase LTV (reduce churn, raise prices, expand revenue).
Red Flag 6: Activation rate dropping
Usually means onboarding broke (new release, product change, marketing mismatch). Audit the activation funnel to find the leak.
Red Flag 7: Sudden MRR growth slowdown
Could be normal (end of surge from a launch), or could be a canary in the coal mine. Segment by new vs. expansion vs. churn to find the driver.
Part 9: Tools for Tracking These Metrics
SaaS Metrics Platforms
- ChartMogul — strong subscription analytics, Stripe integration
- Baremetrics — simpler, good for Stripe-based SaaS
- ProfitWell (by Paddle) — free tier; strong reporting
- Amplitude / Mixpanel — for product + business metrics integration
- Vitally / Planhat — customer success platforms with metrics
For Early-Stage SaaS (Simpler Options)
- Google Sheets / Airtable — simple monthly tracking
- Stripe Dashboard — basic revenue metrics if you use Stripe
- Notion / Coda — embedded dashboards for team visibility
For Larger/Public SaaS
- Custom BI stack — Snowflake + dbt + Looker/Tableau/Metabase
- Salesforce Revenue Cloud — for sales + customer data
- Dedicated data teams — often 5-10+ analysts
Part 11: Sample Dashboard Spreadsheet Structure
If you're building your own dashboard (before investing in tools), use this structure:
Sheet 1: Raw Data Inputs (Monthly)
| Month | New Customers | Churned Customers | New MRR | Expansion MRR | Contraction MRR | Churned MRR | S&M Costs | COGS |
|---|---|---|---|---|---|---|---|---|
| Jan 2026 | ||||||||
| Feb 2026 |
Sheet 2: Calculated Metrics (Automated from Sheet 1)
All 15 metrics calculated with formulas pointing to raw data.
Sheet 3: Visual Dashboard
Charts and KPI cards built from Sheet 2.
Sheet 4: Cohort Analysis
Customers grouped by signup month, tracking retention over time.
Sources and References
- David Skok, "SaaS Metrics 2.0" (For Entrepreneurs) — authoritative source for SaaS metrics formulas
- Lenny Rachitsky SaaS benchmark survey (Lenny's Newsletter) — activation and growth benchmarks
- SaaS Capital — NRR, GRR, and revenue benchmark research
- ChartMogul SaaS Benchmark Report — monthly updated benchmarks
- KeyBanc Capital Markets SaaS Survey — annual SaaS financial benchmarks
- OpenView Partners SaaS Benchmarks Report — growth and efficiency benchmarks
- RevPartners SaaS Metric Cheat Sheet — compiled benchmark data
- Baremetrics Academy — practical SaaS metric guides
- Tomasz Tunguz research (Redpoint Ventures) — benchmark analyses
Created by Desisle — SaaS UI/UX Design Agency desisle.com | hello@desisle.com Free to use and share with attribution.
For a custom SaaS metrics dashboard design and implementation, contact us at hello@desisle.com.
Keep Building With These Next
The AI SaaS UX Playbook - Designing for Trust, Transparency & Adoption
A deep playbook for AI product UX covering explainability, confidence indicators, AI error handling, human review flows, progressive disclosure, and adoption metrics.
Open AI UX PlannerUser Journey Mapping Template - From First Touch to Renewal
A visual template for mapping discovery, signup, onboarding, support, renewal, and referral moments with emotion tracking and friction spotting.
Open Journey MapDesign System Starter Kit - Token Architecture + Component Foundation
A starter Figma system with token architecture, core components, naming conventions, and auto-layout structure so teams can build on a real foundation instead of a loose UI kit.
Open System Starter KitNeed This Applied to Your Product? We'll Turn It Into Execution.
These resource pages are meant to be used hands-on. If you want the audit, plan, or framework translated into live product work, we can do that with your team.