Two SaaS companies walk into the same board meeting. Both have dashboards. The first founder pulls up 34 charts and spends eleven minutes explaining why last month’s MRR chart doesn’t match the one in the finance deck. The second founder shows six numbers, points at one of them, and says: “Net revenue retention dropped four points in the mid-market segment. Here’s what we’re doing about it.”
Same data. Same tools. Completely different outcome.
The difference isn’t the dashboard software. It’s that one team built a SaaS metrics dashboard to answer specific questions, and the other built a place to store charts. This guide walks through how to build the first kind — the metrics that belong on it, the definitions that have to be locked down before you build anything, the tools that fit each stage, and a free template layout you can copy into a spreadsheet or BI tool this afternoon.
Why Most SaaS Dashboards Fail
Before the how, it’s worth being honest about the failure modes, because almost every broken dashboard fails in one of four ways.
It has no owner. Someone builds it during a strategy offsite, it’s beautiful for three weeks, then a billing integration changes and nobody notices the numbers went stale.
It mixes altitudes. Board-level ARR sits next to a chart of weekly support ticket volume. Neither audience finds what they need, so both stop looking.
Definitions drift. Sales counts a customer at signature, finance counts them at first payment, product counts them at first login. Three teams, three MRR numbers, endless meetings about whose spreadsheet is right.
It reports history instead of predicting anything. Revenue and churn are lagging indicators — by the time they move, the decision window closed weeks ago. A dashboard built only from lagging indicators tells you what already happened to you.
A useful dashboard is a decision tool, not a scoreboard. Everything below is designed around that.
Step 1: Decide Which Decisions the Dashboard Serves
The single highest-leverage move in this entire process happens before you touch a tool.
Write down the recurring decisions your team actually makes: Do we hire two more AEs next quarter? Do we raise prices on the mid-tier? Is onboarding broken or is the ICP wrong? Can we survive twelve more months without raising? Then work backwards to the smallest set of numbers that answers each one.
This naturally produces three layers, and keeping them physically separate is what stops dashboards from turning into wallpaper.
| Layer | Audience | Cadence | Purpose |
|---|---|---|---|
| Layer 1 — Executive | Founders, board, investors | Monthly | Is the business healthy and financeable? |
| Layer 2 — Operating | Growth, CS, product, finance leads | Weekly | Are our inputs moving in the right direction? |
| Layer 3 — Diagnostic | Analysts, functional owners | On demand | Why did a Layer 1 or 2 number move? |
Layer 1 should fit on one screen without scrolling. If someone has to scroll, it isn’t Layer 1 anymore.
Step 2: Choose the Metrics for Each Layer
Here is the core of the template. These are the metrics that earn a permanent slot, plus what “good” looks like heading into 2026.
Layer 1 — Executive (6–8 numbers, monthly)
ARR and ARR growth rate. The headline. Worth noting that the bar has moved: median annual growth for venture-backed SaaS has compressed from roughly 47% in 2024 to around 26% in 2026, so last cycle’s benchmarks will make you feel worse about a perfectly respectable number.
Net Revenue Retention (NRR). Expansion plus contraction plus churn, measured against a starting cohort. This has quietly become the metric investors weight most heavily. Median NRR has compressed to roughly 101%, with top performers holding 111%+, and the KeyBanc 2026 SaaS survey found companies above 110% growing meaningfully faster than peers stuck in the 95–100% band.
Gross Revenue Retention (GRR). Always show it beside NRR. NRR alone can hide a leaking bucket — a handful of enterprise expansions can mask 8% churn underneath. GRR strips out expansion and shows the raw truth.
One trap worth flagging here: published NRR and GRR benchmarks are annual figures, but most dashboards calculate them monthly. A monthly NRR of 100.5% looks unremarkable next to a 110% benchmark — until you compound it and find it’s actually 106% annualised. Label the period explicitly on the dashboard and compare like with like, or you’ll spend a quarter fixing a problem you don’t have.
CAC Payback Period. Months to recover acquisition cost. Median blended payback has stretched to about 18 months (up from 15 in 2023 per OpenView’s benchmark data), while efficient companies still land under 12. See our full breakdown of why most teams calculate CAC payback wrong.
Rule of 40. Growth rate plus profit margin. Only somewhere between 11% and 30% of SaaS companies actually clear it — which is exactly why it’s a differentiator on a board slide. Details in our Rule of 40 guide.
Gross margin. Healthy SaaS sits at 70–85%. Watch this one carefully if you’ve shipped AI features — inference costs are compressing margins across the category, and a margin slide will quietly break your LTV and payback math before anyone notices.
Cash runway and burn multiple. Net burn divided by net new ARR. Under 1.5x is strong; above 3x is a conversation with your board.
Layer 2 — Operating (weekly)
The MRR movement waterfall. Not just total MRR — the five components: New, Expansion, Contraction, Churned, and Net New MRR. This single chart explains more than any other view on the dashboard, because two months with identical net growth can have completely different underlying stories.
SaaS Quick Ratio. (New MRR + Expansion MRR) ÷ (Contraction MRR + Churned MRR). A fast read on growth efficiency — see our Quick Ratio benchmarks.
Logo churn and revenue churn, separately. Enterprise SaaS above $50M ARR averages roughly 0.7% monthly logo churn; SMB-heavy products run around 4.1%. And remember the compounding: 5% monthly churn is not 60% annually — it’s about 46%, which is still catastrophic but a different kind of catastrophic than most spreadsheets assume.
Involuntary churn rate. Track this as its own line. Failed payments account for up to 48% of all SaaS churn according to 2026 industry data — and dunning automation typically recovers 50–80% of it. It is the single highest-ROI number most teams don’t have on a dashboard.
Expansion MRR as a percentage of new ARR. For companies above $25M ARR, expansion now drives around 38% of new ARR. If yours is near zero, your pricing model — not your sales team — is the constraint. More on this in our guide to SaaS expansion metrics.
Activation rate. The percentage of new signups reaching your defined “aha” event within a set window. This is your earliest reliable churn predictor. Our piece on activation metrics covers how to define the event properly.
Trial-to-paid conversion. Pure self-serve trials average around 4.6%; sales-assisted PQL motions average about 17.4%. Segment these separately or the blended number is meaningless.
LTV:CAC ratio. Healthy range is 3:1 to 5:1. Below 1:1 you lose money on every customer. Full calculation guide here.
Magic Number. Quarterly sales efficiency — above 0.75 generally justifies pouring more into sales. See our SaaS Magic Number explainer.
Layer 3 — Diagnostic (on demand)
Cohort retention curves by signup month. Metric cuts by segment, plan, acquisition channel, and geography. Feature adoption depth. Customer health scores and at-risk account lists. Support ticket volume per 100 customers.
Layer 3 is where you answer why, and it should be built for exploration, not for display.
Step 3: Write the Definitions Before You Write the Formulas
This is the step teams skip and then pay for twice.
Every metric on the dashboard needs a written definition covering four things: the exact formula, the data source of record, the timing rule, and the edge cases. Without this, your numbers will diverge from finance’s numbers within one quarter, guaranteed.
The edge cases that cause the most damage:
- Annual contracts. Divided by 12 into monthly MRR, or recognized at invoice? Pick one and never change it.
- Discounts. MRR is recorded net of discount, always.
- Free and trial users. Excluded from MRR, excluded from customer count, tracked in a separate funnel metric.
- Mid-cycle plan changes. Prorated or counted at next renewal?
- Refunds and credits. Contraction, or a negative adjustment to new MRR?
- Multi-currency. Fixed FX rate for the period, or spot rate at transaction? A floating rate makes month-over-month comparisons meaningless.
- When is a churned customer churned? Cancellation date, or end of paid term?
Ship a Definitions tab with your dashboard. One row per metric, five columns: Metric, Formula, Source System, Owner, Edge Case Notes. It takes an afternoon and eliminates a recurring category of meeting forever.
Step 4: Map Your Data Sources
List every system generating a number you plan to show, and mark which one is the source of record when two disagree.
| Data type | Typical source | Feeds |
|---|---|---|
| Subscription revenue | Stripe, Chargebee, Paddle, Recurly | MRR, ARR, churn, expansion |
| Sales and marketing spend | Ad platforms, payroll, accounting | CAC, payback, Magic Number |
| Pipeline and deals | HubSpot, Salesforce | Conversion rates, sales cycle |
| Product usage | PostHog, Amplitude, Mixpanel | Activation, adoption, health scores |
| Support | Intercom, Zendesk | Ticket volume, CSAT, churn signals |
| Financials | QuickBooks, Xero, NetSuite | Gross margin, burn, runway |
The rule: one source of record per metric, no exceptions. When CRM and billing disagree on customer count, billing wins — and you write that down.
Step 5: Pick the Tool That Matches Your Stage
Tool selection is mostly a function of billing complexity and revenue stage, not feature lists.
Pre-revenue to roughly $10K MRR. A spreadsheet plus a free subscription analytics tool. ProfitWell (now part of Paddle) covers core metrics for free; ChartMogul’s free tier runs up to around $120K ARR. Don’t over-engineer this stage.
$10K–$100K MRR. Baremetrics if you’re Stripe-only and want the cleanest, fastest setup. ChartMogul if revenue spans multiple processors or you need real cohort depth. Both handle the ugly edge cases — refunds, prorations, currency conversion, mid-cycle plan changes — far better than a hand-built sheet.
$100K+ MRR or multi-source needs. A warehouse-plus-BI setup: your billing, CRM, product, and finance data landing in BigQuery, Snowflake, or Postgres, with Metabase, Looker Studio, or Power BI on top. More setup cost, but it’s the only architecture that lets you cut any metric by any dimension.
Cross-functional dashboards. Databox or Klipfolio when you need marketing, sales, and revenue data on one screen and depth matters less than breadth.
A practical note: subscription analytics tools compute SaaS metrics correctly out of the box. General BI tools display anything but make you define everything yourself. Most teams underestimate how much work that second option is.
The Free Template: Layout You Can Copy Today
Here’s the structure. Build it as five tabs in Google Sheets or Excel, or as five views in your BI tool.
Tab 1 — Dashboard (Layer 1). A single screen, no scrolling. Top row: ARR, ARR growth %, NRR, GRR, CAC Payback, Rule of 40. Second row: MRR waterfall chart for the trailing 12 months. Third row: cash balance, net burn, runway in months. Every number gets a current value, a prior-period value, and a target — a number without a comparison is trivia.
Tab 2 — Inputs. One row per month, columns for: Starting MRR, New MRR, Expansion MRR, Contraction MRR, Churned MRR, Customers (start), New Customers, Churned Customers, S&M Spend, R&D Spend, G&A Spend, COGS, Cash Balance. This is the only tab anyone types into.
Tab 3 — Metrics. Every calculated metric, driven entirely by formulas referencing Inputs. The core set:
Ending MRR = Starting MRR + New + Expansion − Contraction − Churned
Net New MRR = New + Expansion − Contraction − Churned
ARR = Ending MRR × 12
GRR = (Starting MRR − Contraction − Churned) / Starting MRR
NRR = (Starting MRR + Expansion − Contraction − Churned) / Starting MRR
Logo Churn % = Churned Customers / Customers (start)
Quick Ratio = (New + Expansion) / (Contraction + Churned)
ARPA = Ending MRR / Ending Customers
Gross Margin % = (Revenue − COGS) / Revenue
CAC = S&M Spend / New Customers
CAC Payback = CAC / (ARPA × Gross Margin %)
LTV = (ARPA × Gross Margin %) / Monthly Revenue Churn Rate
LTV:CAC = LTV / CAC
Rule of 40 = YoY Growth % + FCF Margin %
Burn Multiple = Net Burn / Net New ARR
Tab 4 — Cohorts (Layer 3). Signup month down the rows, months-since-signup across the columns, retained revenue in the cells. This is the tab that tells you whether the product is getting better or you’re just spending more.
Tab 5 — Definitions. Metric, Formula, Source System, Owner, Edge Case Notes. Non-negotiable.
I’ve built this out as a ready-to-use spreadsheet with all formulas wired up and 24 months of sample data — copy the Google Sheet or download the Excel version, replace the sample figures with your own, and the dashboard populates itself. You can also run individual metrics through our SaaS metrics calculator if you just want a quick check on a single number. <!– CTA BLOCK GOES HERE –>
Step 6: Add Targets, Thresholds, and Alerts
A dashboard without thresholds is a dashboard nobody acts on.
For every Layer 1 and Layer 2 metric, set three values: a target, a warning threshold, and a critical threshold. Colour-code against them. Then route the critical ones to a Slack channel so a problem finds the owner instead of waiting for someone to open a tab.
Anomaly alerts matter more than static monthly targets, because static targets catch problems at month-end and anomalies catch them the same week. A 15% single-week jump in contraction MRR is worth an interrupt.
Step 7: Build the Review Ritual
The dashboard is infrastructure. The ritual is the product.
Weekly, 20 minutes: the operating team reviews Layer 2. One question per metric that moved — is this signal or noise?
Monthly, 60 minutes: leadership reviews Layer 1 against targets, with a written commentary on any metric outside threshold. Written, not verbal — writing forces a real explanation.
Quarterly: review the dashboard itself. Which metrics did nobody look at? Delete them. Which questions did you have to leave the dashboard to answer? Add them.
Dashboards decay. The ones that survive are pruned deliberately.
Common Mistakes Worth Avoiding
Tracking 40 metrics because you can. Every metric you add reduces the attention paid to the important ones. If you can’t name the decision a metric informs, cut it.
Blending segments. Self-serve and enterprise have different churn, different CAC, and different payback. A blended number is often the average of two things you’d manage completely differently. Segment first, then blend — never the reverse.
Ignoring cohorts. Aggregate retention improves automatically when you grow, because new customers haven’t had time to churn yet. Only cohorts reveal whether retention is genuinely improving.
Vanity metrics in Layer 1. Total registered users, page views, cumulative signups. If a number can only go up, it can’t tell you anything went wrong. Our guide to product analytics for SaaS covers what to track instead.
Building the tool before agreeing on the definitions. Every time.
A good SaaS metrics dashboard is small, opinionated, and slightly uncomfortable to look at. It shows six numbers to the board, a dozen to the operating team, and gets out of the way when someone needs to dig. Start with the decisions, define the metrics in writing, wire up the layers, then set thresholds and a review cadence — and resist every request to add just one more chart. The teams that get real leverage from their metrics aren’t the ones tracking the most. They’re the ones who agreed, in writing, on what each number means and what they’ll do when it moves.
A SaaS analyst covering product strategy, growth, and customer experience in modern software businesses. Focused on practical insights and real-world SaaS execution.
