A Greenwolf Tech Labs site · Our Data Studio agency team, India and USAgreenwolftechlabs.com ↗

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.

Laptop showing a SaaS metrics dashboard with an MRR bridge and retention charts
Industry guide5 min readUpdated November 18, 2026 · by Harsh Khubchandani

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.
01

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.
02

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.

KPIFormulaMain data source
MRRSum of normalized monthly recurring charges for active subscriptionsBilling system
ARRMRR multiplied by 12Billing system
Net new MRRNew plus expansion minus contraction minus churned MRRMRR movement table
Gross revenue retention (GRR)(Starting MRR minus contraction minus churn) divided by starting MRRMRR movement table
Net revenue retention (NRR)(Starting MRR plus expansion minus contraction minus churn) divided by starting MRRMRR movement table
Logo churnCustomers lost in the period divided by customers at the startBilling system
CACSales and marketing spend divided by new customersLedger or ad platforms plus CRM
CAC payback (months)CAC divided by (new MRR per customer multiplied by gross margin)Ledger plus billing
LTV to CACCustomer lifetime value divided by CACBilling plus ledger
03

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.

04

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.

MovementMRRWhat it means
Starting MRR$100,000Recurring revenue on the first day of the month
New+$8,000Customers whose first paid month this is
Expansion+$5,000Upgrades, extra seats and add-ons from existing customers
Contraction-$2,000Downgrades and seat reductions
Churn-$4,000Customers who cancelled or did not renew
Ending MRR$107,000Starting MRR plus net new MRR of $7,000
05

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.
06

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.

07

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.

OptionBest forTrade-off
Billing system reportsEarly-stage companies checking MRR and churnNo CAC, no marketing data, fixed definitions
Dedicated SaaS metrics toolFast standard metrics from one billing sourceAnother subscription; limited joins with CRM and ledger
Spreadsheet modelBoard packs at low volumeManual, error-prone and hard to share live
Data Studio on BigQueryOne view across billing, CRM, ads and financeNeeds a data model built and maintained
08

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.
09

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.

Reviewed by Team Greenwolf Tech Labs · 18 Nov 2026

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.

A Data Studio lead replies from info@greenwolftechlabs.com, usually within one business day. No mailing lists.

Ask us anything

A Data Studio lead replies from info@greenwolftechlabs.com, usually within one business day.

A Data Studio lead replies from info@greenwolftechlabs.com, usually within one business day. No mailing lists.