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)
WeeklyThe 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)
MonthlyThe 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)
MonthlyThe 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
MonthlyRecurring 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)
MonthlyThe 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
MonthlyThe 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
WeeklyThe 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
WeeklyThe 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
WeeklyThe 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)
WeeklyThe 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
WeeklyThe 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
MonthlyThe 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
MonthlyThe 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)
MonthlyThe 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
MonthlyAdditional 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)
QuarterlyThe 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
QuarterlyThe 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
WeeklyThe 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
QuarterlyHow 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
QuarterlySales 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
QuarterlyThe 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
MonthlyCash 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.
Setup: Stripe + Mixpanel/Amplitude
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.
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.
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.
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.
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.
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.