Industry guide
SaaS metrics dashboard: MRR, churn and retention your finance team will trust
A SaaS metrics dashboard shows recurring revenue, how it moved this month, how much you kept from existing customers, and what it cost to win new ones. This guide is for SaaS founders, finance leads and revenue operations teams who want one view the board and the finance team agree on. It covers the metrics, the billing data model underneath them, a worked MRR bridge, and how we build it in Data Studio.

Quick answer
What should a SaaS metrics dashboard include?
A SaaS metrics dashboard should include MRR and ARR, an MRR bridge showing new, expansion, contraction and churned revenue, gross and net revenue retention, logo churn, CAC and CAC payback, and LTV to CAC. Each figure must come from one agreed definition built on billing data, so it matches what finance reports.
- Start from an MRR movement table built on billing events, not from invoice totals.
- Show the MRR bridge every month: new, expansion, contraction and churn.
- Agree written definitions for churn, NRR and CAC before building any chart.
- Most mismatches with finance come from annual plans, discounts, refunds and currency.
What should a SaaS metrics dashboard show?
A SaaS metrics dashboard should show three things on its first page: how much recurring revenue you have, why it changed this month, and whether growth is efficient. Everything else is drill-down.
We split the report by audience. The board and founders get an overview with ARR, the MRR bridge, net revenue retention and CAC payback. Finance gets a reconciliation page that ties MRR to billing and the ledger. Sales and marketing get pipeline, new MRR by channel and CAC by channel. Customer success gets churn and contraction by plan, cohort and account owner.
- Overview: MRR, ARR, net new MRR, NRR, GRR, logo churn and CAC payback.
- MRR bridge: starting MRR, plus new and expansion, minus contraction and churn, equals ending MRR.
- Cohorts: revenue retained by signup month, so you can see whether newer customers stay longer.
- Acquisition: new customers, new MRR and CAC by channel, from ad platforms and the CRM.
- Reconciliation: dashboard MRR against billing and recognized revenue, with the differences explained.
Which SaaS KPIs matter, and how are they calculated?
The KPIs that matter are the ones investors and finance will check, and each needs a formula written down before the build. Two teams can both say churn and mean different things: customers lost, revenue lost, or revenue lost net of expansion.
For efficiency, a widely used reference is David Skok's SaaS Metrics 2.0 guide on forEntrepreneurs.com. It says the best SaaS businesses have an LTV to CAC ratio higher than 3, and that many of the best recover their CAC in 5 to 7 months, while beyond 12 months profitability is weak. Use those as context, not targets, because the right figure depends on contract size and sales motion.
| KPI | Formula | Main data source |
|---|---|---|
| MRR | Sum of normalized monthly recurring charges for active subscriptions | Billing system |
| ARR | MRR multiplied by 12 | Billing system |
| Net new MRR | New plus expansion minus contraction minus churned MRR | MRR movement table |
| Gross revenue retention (GRR) | (Starting MRR minus contraction minus churn) divided by starting MRR | MRR movement table |
| Net revenue retention (NRR) | (Starting MRR plus expansion minus contraction minus churn) divided by starting MRR | MRR movement table |
| Logo churn | Customers lost in the period divided by customers at the start | Billing system |
| CAC | Sales and marketing spend divided by new customers | Ledger or ad platforms plus CRM |
| CAC payback (months) | CAC divided by (new MRR per customer multiplied by gross margin) | Ledger plus billing |
| LTV to CAC | Customer lifetime value divided by CAC | Billing plus ledger |
Why does a SaaS dashboard need an MRR movement table?
A SaaS dashboard needs an MRR movement table because billing systems record invoices and subscription changes, not MRR. The movement table turns those events into one row per customer per month, with the MRR at the start, the MRR at the end, and a label for what changed.
Every number on the overview then comes from that one table. New MRR is the sum of rows labelled new, churn is the sum of rows labelled churn, and NRR is a calculated field over the same rows. Because the table is the single source, the bridge always adds up, and the board deck, the finance pack and the dashboard agree.
We usually build the table in BigQuery with a scheduled query that runs each night, partitioned by month so Data Studio scans only the months a viewer selects. For smaller companies with a few hundred subscriptions, a Google Sheet fed by an export can hold it, but it grows out of Sheets quickly once you keep several years of history.
A worked example: one month's MRR bridge
The example below uses illustrative numbers to show how the bridge and the retention figures connect. It is not client data.
The company started the month at $100,000 MRR. Net new MRR was $7,000, so ending MRR is $107,000. Net revenue retention looks only at existing customers: ($100,000 plus $5,000 minus $2,000 minus $4,000) divided by $100,000 gives 99%. Gross revenue retention ignores expansion: ($100,000 minus $2,000 minus $4,000) divided by $100,000 gives 94%. The headline growth of 7% hides the fact that the existing base shrank slightly, which is exactly what the bridge is for.
| Movement | MRR | What it means |
|---|---|---|
| Starting MRR | $100,000 | Recurring revenue on the first day of the month |
| New | +$8,000 | Customers whose first paid month this is |
| Expansion | +$5,000 | Upgrades, extra seats and add-ons from existing customers |
| Contraction | -$2,000 | Downgrades and seat reductions |
| Churn | -$4,000 | Customers who cancelled or did not renew |
| Ending MRR | $107,000 | Starting MRR plus net new MRR of $7,000 |
Why does the SaaS dashboard disagree with finance?
It usually disagrees because the dashboard and the ledger measure different things. MRR is a run rate of committed recurring charges, while finance reports recognized revenue under accounting rules. The gap is expected, but it must be explained line by line, or nobody will trust either number.
We add a reconciliation page that shows dashboard MRR, billed amounts and recognized revenue side by side, with each known difference listed. Once finance signs off on that page, the rest of the dashboard inherits its credibility.
- Annual and multi-year plans: a $12,000 annual invoice is $1,000 of MRR for twelve months, not $12,000 in the month billed.
- Discounts and coupons: decide whether MRR is shown before or after discounts, and whether temporary discounts expire in the data.
- Refunds and credits: a refund is not always churn, and a credit note is not always contraction.
- Usage and one-off fees: setup fees and services are not recurring and belong outside MRR.
- Currency: convert at a fixed rate for MRR trends, or exchange-rate movement will look like expansion and contraction.
- Paused, trialing and past-due subscriptions: write down whether each counts as active.
Which data sources feed a SaaS metrics dashboard in Data Studio?
Most SaaS dashboards draw on a billing system, a CRM, ad platforms, product analytics and the accounting ledger. Only some of these connect to Data Studio natively.
Google Ads, GA4, Search Console, Sheets and BigQuery have native connectors. Billing systems such as Stripe, CRMs and accounting tools normally arrive through a partner connector or a pipeline into BigQuery. Partner connectors work for simple charts, but billing data needs the movement-table logic above, which is easier to write once in SQL than to rebuild in calculated fields.
Data Studio limits shape the design. Blends allow at most 5 sources with equality joins, and tables on fixed-schema sources such as GA4 and Google Ads are limited to 10 dimensions and 20 metrics, while BigQuery tables allow 100 of each. A SaaS model that joins billing, CRM, ads and the ledger belongs in BigQuery, with Data Studio reading prepared tables.
Should you build a SaaS dashboard in Data Studio or buy a SaaS metrics tool?
Buy a dedicated subscription analytics tool if you want standard metrics from one billing system quickly and do not need to combine them with other data. Build in Data Studio when you need billing, CRM, marketing spend and finance in one place, under your own definitions.
Data Studio itself is free for creators and viewers. Data Studio Pro costs $9 per user per project per month for editors in team workspaces, and viewers need no licence, so a board or the whole company can view the report without per-seat fees. The running costs are BigQuery storage and queries, which stay small with partitioned tables, and any connector subscriptions. Teams whose data already sits in BigQuery can also add Conversational Analytics, generally available since July 30, 2026, so people can ask questions of governed data in plain language.
| Option | Best for | Trade-off |
|---|---|---|
| Billing system reports | Early-stage companies checking MRR and churn | No CAC, no marketing data, fixed definitions |
| Dedicated SaaS metrics tool | Fast standard metrics from one billing source | Another subscription; limited joins with CRM and ledger |
| Spreadsheet model | Board packs at low volume | Manual, error-prone and hard to share live |
| Data Studio on BigQuery | One view across billing, CRM, ads and finance | Needs a data model built and maintained |
What mistakes make SaaS metrics dashboards untrustworthy?
Most failures are definition failures, not chart failures. The report looks fine until a board member asks why churn differs from last quarter's deck.
When should you not build one? If you have one billing system, no paid acquisition and a handful of customers, your billing tool's built-in reports are enough. Build a dashboard when metrics feed board reporting, fundraising or budget decisions and come from more than one system.
- Calculating MRR from invoice totals, which spikes in months with annual renewals.
- Mixing logo churn and revenue churn under one label.
- Counting trials or free plans as customers in churn and CAC.
- Changing a definition without restating history, so trends break silently.
- Building charts straight on a billing connector with no reconciliation to finance.
How Greenwolf Tech Labs builds SaaS metrics dashboards
We begin with a free review of your billing export, CRM and current board metrics, then agree written definitions with finance before quoting a fixed price. The quote lists sources, pages, the movement-table logic and expected running costs.
Our team builds executive KPI and CFO dashboards in Data Studio that bring cash, revenue, spend and margin into one view for finance leaders, and the SaaS version adds the MRR movement table, cohort retention and the reconciliation page. Where data needs a warehouse, we model it in BigQuery and partition it so the report stays fast as history grows. Greenwolf Tech Labs has delivered 100+ projects for 200+ clients, with a team that includes experience from top consulting firms.
FAQ
Frequently asked questions
What metrics should a SaaS dashboard track?
Track MRR and ARR, the MRR bridge of new, expansion, contraction and churn, net and gross revenue retention, logo churn, CAC, CAC payback and LTV to CAC. Add cohort retention once you have a year or more of history. Write the formula for each before building.
How do you calculate net revenue retention?
Take starting MRR from existing customers, add expansion, subtract contraction and churn, then divide by starting MRR. New customers are excluded. For example, $100,000 plus $5,000 minus $2,000 minus $4,000, divided by $100,000, gives 99%.
Can Data Studio connect to Stripe?
Not natively. Stripe data reaches Data Studio through a partner connector or a pipeline into BigQuery. For SaaS metrics, the BigQuery route is usually better because the MRR movement logic is written once in SQL and every chart reads the same table.
Why doesn't my MRR match revenue in the accounts?
MRR is a run rate of recurring charges, while the accounts show recognized revenue. Annual plans, discounts, refunds, one-off fees and currency conversion all create differences. A reconciliation page that lists each difference is the usual fix.
What is a good LTV to CAC ratio for SaaS?
David Skok's SaaS Metrics 2.0 guide says the best SaaS businesses have an LTV to CAC ratio above 3. Treat it as a reference point rather than a target, because sales cycle, contract length and gross margin all change what is healthy.
Is Data Studio good enough for board-level SaaS reporting?
Yes, when it reads from a modelled data source with agreed definitions and a reconciliation to finance. It struggles when charts are built directly on raw billing connectors and blends, because the 5-source blend limit and connector quirks make numbers hard to audit.
Keep reading
Related pages
Get started
Tell us what your reporting has to do
Describe the dashboards you need, who reads them and where the data sits. We reply within one business day with an approach, the connectors involved and a fixed-price plan.
- Free 30-minute reporting review
- Fixed quote before any work starts
- Everything built and owned in your Google account
Prefer email? info@greenwolftechlabs.com
Get a free proposal
Two lines is enough to start.