All downloads
Metrics

SaaS Growth Metrics Dashboard Template

Every metric a seed to Series B SaaS should track: definition, formula, benchmark, cadence, and data source. Build it in Google Sheets or Excel with the column layout below, wire it to Stripe and Mixpanel or Amplitude with the setup steps, and close the books monthly.

Format · Sheet template · 5 sections · 22 metrics · Free, no gate

01Revenue

Track the top-line recurring revenue that every other metric ultimately rolls up into.

MRR (Monthly Recurring Revenue)

Weekly

The total predictable subscription revenue normalized to a monthly figure.

sum of all active subscriptions normalized to a monthly amount

Benchmark: Seed startups often cross $10k-$50k MRR before raising Series A; healthy growth is roughly 10 to 15 percent month over month at this stage.

Source · Stripe

ARR (Annual Recurring Revenue)

Monthly

The annualized run rate of recurring revenue at a point in time.

MRR * 12

Benchmark: Series A typically lands around $1M-$2M ARR; Series B is commonly $5M-$10M ARR with the strongest companies tripling year one and doubling thereafter (T2D3).

Source · Stripe

ARR Growth Rate (YoY)

Monthly

The year-over-year percentage increase in annual recurring revenue.

(ARR current - ARR 12 months ago) / ARR 12 months ago

Benchmark: Top-quartile seed to Series B SaaS grow ARR 100 to 200 percent YoY; below 60 percent at this stage is a yellow flag for investors.

Source · Stripe

New MRR

Monthly

Recurring revenue added from brand-new customers in the period.

sum of MRR from accounts that started a paid subscription this period

Benchmark: For PLG devtools, new MRR should consistently outpace churned MRR by at least 3x to sustain compounding growth.

Source · Stripe

02Acquisition

Measure how efficiently you turn marketing and sales spend into paying customers.

CAC (Customer Acquisition Cost)

Monthly

The fully loaded cost to acquire one new paying customer.

(sales spend + marketing spend) / new customers acquired

Benchmark: PLG devtools often run blended CAC under $500 for self-serve and $5k-$15k for sales-assisted mid-market deals.

Source · CRM + ad platforms + Stripe

CAC Payback Period

Monthly

The number of months of gross margin needed to recoup the cost of acquiring a customer.

CAC / (ARPA * gross margin)

Benchmark: Best-in-class is under 12 months; under 6 months is excellent for PLG, while above 18 months signals an efficiency problem.

Source · CRM + Stripe

Signup to Paid Conversion

Weekly

The share of free signups or trials that convert into paying customers.

paid conversions / total signups (or trials) in the cohort

Benchmark: Self-serve devtools see 2 to 5 percent free-to-paid; opt-in trials convert 15 to 25 percent, and credit-card trials 40 to 60 percent.

Source · Stripe + Mixpanel/Amplitude

Lead Velocity Rate

Weekly

The month-over-month growth in qualified leads entering the pipeline.

(qualified leads this month - qualified leads last month) / qualified leads last month

Benchmark: A sustained 10 to 15 percent monthly LVR is a leading indicator that revenue growth will hold over the next two to three quarters.

Source · CRM

03Activation

For developer products, activation is the first taste of value, not just account creation.

Activation Rate

Weekly

The percentage of new signups that reach the core aha moment, such as a first successful API call or first deploy.

activated users / total new signups in the cohort

Benchmark: Strong PLG devtools activate 30 to 40 percent of signups; under 20 percent usually points to onboarding or time-to-value friction.

Source · Mixpanel/Amplitude

Time to First Value (TTFV)

Weekly

The median time from signup to the first successful core action like a passing build or first API request.

median(timestamp of first core action - signup timestamp)

Benchmark: Leading developer tools target under 10 minutes to first value; multi-day TTFV correlates strongly with early churn.

Source · Mixpanel/Amplitude

Onboarding Completion Rate

Weekly

The share of new users who finish the guided setup or key onboarding milestones.

users completing onboarding / users who started onboarding

Benchmark: Healthy products see 50 to 70 percent onboarding completion; each abandoned step compounds into lower activation downstream.

Source · Mixpanel/Amplitude

04Retention & Expansion

Retention and expansion separate a leaky bucket from a compounding business.

Gross Revenue Churn

Monthly

The percentage of recurring revenue lost to cancellations and downgrades, before any expansion.

(churned MRR + downgrade MRR) / MRR start

Benchmark: Aim for under 1 percent monthly (12 percent annual) gross churn; mid-market and enterprise SaaS often hold below 0.7 percent monthly.

Source · Stripe

Logo Churn Rate

Monthly

The percentage of customers (accounts) lost in the period, regardless of revenue size.

customers lost in period / customers at start of period

Benchmark: Self-serve devtools tolerate higher logo churn (3 to 5 percent monthly); sales-led products should stay under 1 to 2 percent monthly.

Source · Stripe + CRM

Net Revenue Retention (NRR)

Monthly

The percentage of recurring revenue retained from existing customers including expansion, net of churn and contraction.

(MRR start + expansion MRR - churned MRR - contraction MRR) / MRR start

Benchmark: Best-in-class SaaS exceeds 120 percent NRR; 100 percent or above means the customer base grows revenue without any new logos.

Source · Stripe

Expansion MRR

Monthly

Additional recurring revenue from existing customers via upgrades, seats, or usage growth.

upgrade MRR + seat expansion MRR + usage-based overage MRR

Benchmark: Mature PLG and usage-based devtools generate 20 to 40 percent of new MRR from expansion; usage models can push expansion well past that.

Source · Stripe

LTV (Customer Lifetime Value)

Quarterly

The expected gross-margin revenue from an average customer over their lifetime.

(ARPA * gross margin) / monthly churn rate

Benchmark: LTV is most useful relative to CAC; absolute values vary widely, so track the trend and pair it with payback rather than a fixed target.

Source · Stripe

LTV:CAC Ratio

Quarterly

The ratio of lifetime value to the cost of acquiring that customer.

LTV / CAC

Benchmark: A 3:1 ratio is the healthy baseline; above 5:1 may mean you are underinvesting in growth, while under 1:1 means you lose money on each customer.

Source · Stripe + CRM

DAU/MAU Stickiness

Weekly

The ratio of daily active users to monthly active users, a proxy for habitual usage.

daily active users / monthly active users

Benchmark: Workflow-critical devtools (CI, observability, IDE plugins) hit 30 to 50 percent stickiness; under 20 percent suggests sporadic, replaceable usage.

Source · Mixpanel/Amplitude

05Efficiency

Efficiency metrics tell you whether growth is being bought sustainably or burned through.

Burn Multiple

Quarterly

How much net cash you burn to generate each dollar of net new ARR.

net cash burned / net new ARR

Benchmark: Under 1x is great, 1x to 1.5x is good, 1.5x to 2x is suspect, and above 2x is a warning sign at seed to Series B.

Source · Accounting + Stripe

Magic Number

Quarterly

Sales and marketing efficiency, measuring new ARR generated per dollar of prior-period S&M spend.

(net new ARR in quarter) / (S&M spend in prior quarter)

Benchmark: Above 0.75 justifies pressing on growth spend; below 0.5 means tighten go-to-market before scaling acquisition.

Source · Accounting + CRM

Gross Margin

Quarterly

The percentage of revenue left after the direct cost of delivering the service.

(revenue - cost of goods sold) / revenue

Benchmark: Software SaaS targets 75 to 85 percent gross margin; infra-heavy devtools and AI/ML products often run 50 to 70 percent due to compute costs.

Source · Accounting

Net Monthly Burn

Monthly

Cash consumed per month after accounting for revenue.

cash spent - cash collected (per month)

Benchmark: Pair with runway: most seed to Series B teams aim to keep 18 to 24 months of runway given the current burn rate.

Source · Accounting

Sheet Column Layout

One row per month, these columns in order. Copy the header row into Google Sheets or Excel and the formulas above slot straight in.

AMonthBStarting MRRCNew MRRDExpansion MRREContraction MRRFChurned MRRGEnding MRRHActive CustomersINew CustomersJChurned CustomersKS&M SpendLCACMGross Churn %NNet Revenue Retention %OActivation Rate %PNet Burn

Setup: Stripe + Mixpanel/Amplitude

1

Connect Stripe and pull the revenue base

Add the Stripe connector (Sheets add-on or a CSV export of the MRR and subscriptions report), then map starting MRR, new, expansion, contraction, and churned MRR into the matching sheet columns so the revenue section populates automatically.

2

Define your activation event in Mixpanel or Amplitude

Pick one concrete aha moment (first successful API call, first deploy, or first passing build), create that event, then export the monthly count of activated users versus signups into the activation columns.

3

Wire acquisition cost from CRM and ad platforms

Total monthly sales and marketing spend (salaries, ad spend, tooling) and pull new customer counts from your CRM; the sheet computes CAC, CAC payback, and the magic number from these inputs.

4

Validate the formulas against the prior month

Confirm ending MRR equals starting MRR plus new plus expansion minus contraction minus churned, and that ending MRR ties out to Stripe within a few dollars; reconcile any drift before trusting the derived ratios.

5

Set a recurring monthly close ritual

On the first business day of each month, refresh the Stripe and product analytics exports, paste the new row, and review NRR, LTV:CAC, and burn multiple against the benchmarks flagged in the dashboard.

6

Add weekly leading-indicator snapshots

Track the weekly cadence metrics (MRR, signup to paid, activation rate, stickiness) in a lightweight side tab so you catch trend breaks early instead of waiting for the monthly close.

Want the interactive version? The free SaaS Metrics Calculator and Metrics Dashboard tool compute these live in your browser.

Ready when you are.

Discovery calls are 20 minutes. First one's on me.

Book a Strategy Call