B2B SaaS KPI Dashboard Template: The 12 Metrics Every Founder Needs to Track Weekly

The problem with most SaaS dashboards is not missing data — it is too much data. A founder who opens a dashboard with 40 metrics reads none of them carefully. A founder who opens a dashboard with 12 metrics organized by review cadence makes decisions.

This guide gives you the exact 12 KPIs for a B2B SaaS dashboard, the formula and data source for each, the update cadence (daily, weekly, or monthly), and the red flag threshold that triggers action. It also covers the three-tier review structure that separates daily tactical monitoring from weekly strategic review from monthly deep-dive analysis.

The ICP for this dashboard: a $10K–$500K MRR SaaS founder who does not have a dedicated analyst. If you have an ops or finance hire, give them this framework and ask them to build it; if not, this is the exact structure to build yourself.

The Three-Tier Review Structure

Before the 12 metrics, the cadence structure:

Tier 1: Daily Pulse (5 metrics, 5-minute review) Purpose: Detect acute issues before they compound. These are the metrics that change daily and where a one-day lag can matter.

Tier 2: Weekly Review (all 12 metrics, 30-minute review) Purpose: Understand the current week's business trajectory, make adjustments, prepare for team communication. This is the primary operating cadence.

Tier 3: Monthly Deep-Dive (12 metrics + cohorts + benchmarks, 2-hour review) Purpose: Strategic understanding of trends, cohort patterns, segment analysis, benchmark comparison, and model reforecast. This drives hiring and investment decisions.

The 12 Core KPIs

KPI 1: MRR (Monthly Recurring Revenue)

Formula: Sum of monthly normalized recurring revenue from all active paying customers. For annual plans: contract value ÷ 12.

Data source: Billing platform (Stripe, Chargebee) — pull from your metrics tool or the Stripe Sigma query for raw access.

Update cadence: Daily (auto-pulled from billing). The number you check first every morning.

Red flag threshold: MRR declining month-over-month for two consecutive months without a planned explanation (seasonality, intentional churn of low-quality customers).

Why it matters: MRR is the heartbeat metric. Every other metric is a ratio or segment of MRR. If you only look at one number, it is this one — but looking at only MRR tells you nothing about the health of how you got there.

Review question: Is MRR on track vs. the monthly projection in your financial model?

KPI 2: MRR Growth Rate (Month-over-Month)

Formula: (Current MRR - Prior MRR) / Prior MRR × 100

Update cadence: Weekly. Calculate after each week closes (rough estimate) and finalize at month-end.

Red flag threshold:

• At $10K–$100K MRR: below 5% MoM for two consecutive months
• At $100K–$500K MRR: below 3% MoM for two consecutive months

Benchmark context: See SaaS metrics benchmarks 2026 for stage-appropriate growth rate targets.

Review question: Is growth rate accelerating, stable, or decelerating? Deceleration before $500K MRR is a warning signal worth investigating.

KPI 3: New MRR

Formula: Sum of MRR from customers who made their first payment this period. Excludes upgrades from existing customers.

Update cadence: Weekly (review new customer signups and their MRR contribution).

Red flag threshold: New MRR declining two consecutive months while total MRR is stable or growing (means expansion is masking new customer acquisition stall — the denominator trap).

Review question: How many new logos signed this week and what is their average MRR? Is ACV trending up or down?

KPI 4: Expansion MRR

Formula: Sum of incremental MRR from existing customers who upgraded, added seats, or expanded usage in the period.

Update cadence: Weekly.

Red flag threshold: Expansion MRR below 10% of total MRR for mid-market/enterprise products suggests the expansion motion is not working. For SMB products, 5–10% expansion is more typical.

Why it matters: Expansion MRR has near-zero marginal CAC — it is the highest-ROI ARR you can generate. Companies with strong expansion motions compound NRR above 110% and reduce their effective CAC payback period.

KPI 5: Contraction MRR

Formula: Sum of MRR reduction from existing customers who downgraded or reduced usage in the period. (Negative number in the MRR bridge.)

Update cadence: Weekly.

Red flag threshold: Contraction MRR exceeding 50% of Expansion MRR means your expansion motion is being eaten by downgrades — effectively zero net expansion. Investigate: are customers downgrading due to product issues, pricing sensitivity, or usage reduction?

Review question: Which plan tier is seeing the most contraction? Is it concentrated in specific customer segments or cohorts?

KPI 6: Churned MRR

Formula: Sum of MRR from customers who canceled entirely this period. Measured as the MRR they were paying before cancellation (not zero).

Update cadence: Daily (each cancellation). Review weekly in aggregate.

Red flag threshold: Churned MRR above 2% of starting MRR for SMB products, above 1% for mid-market products (monthly).

The lost MRR calculation: Track both the count of churned customers and the dollar value separately. High-count churn with low dollar value (small customers churning) is different from low-count churn with high dollar value (large customers leaving). One is a long-tail problem; the other is a strategic account retention problem.

KPI 7: NRR (Net Revenue Retention)

Formula: (Starting MRR + Expansion MRR - Contraction MRR - Churned MRR) / Starting MRR × 100

Update cadence: Monthly (too noisy on a weekly basis). Track trailing 3-month average.

Red flag threshold:

• NRR below 100% for two consecutive months: your existing customer base is shrinking in absolute terms
• NRR below 95%: structural retention problem requiring immediate diagnosis

The most predictive metric: NRR above 120% means your existing customers are growing the business — each cohort is worth more over time. NRR below 100% means every dollar of new ARR is fighting a headwind of existing customer loss. For the full NRR framework, see NRR calculator guide.

Review question: Is NRR trending up or down over the last six months? What is driving the change — expansion or churn?

KPI 8: Revenue Churn Rate

Formula: Churned MRR / Starting MRR × 100 (monthly)

Update cadence: Monthly.

Benchmark targets by segment:

Review question: Is churn concentrated in a specific plan, cohort month, or acquisition channel? Diffuse churn is a product problem; concentrated churn is a segment or onboarding problem.

KPI 9: CAC (Customer Acquisition Cost)

Formula: Total S&M spend in period / New customers acquired in period (with 30-day lag adjustment).

Update cadence: Monthly.

Red flag threshold: CAC increasing more than 20% quarter-over-quarter without a corresponding increase in average ACV or NRR (meaning you are getting more expensive customers that are not more valuable).

By channel: Track blended CAC and per-channel CAC separately. A blended CAC that looks stable can hide a deteriorating primary channel if a cheaper channel is growing in the mix. For the full CAC framework, see CAC payback period guide.

KPI 10: CAC Payback Period

Formula: CAC / (Avg Monthly Revenue per New Customer × Gross Margin %)

Update cadence: Monthly.

Red flag thresholds:

• Seed stage: above 24 months
• Growth stage ($1M–$10M ARR): above 18 months
• Scale stage: above 12 months

The payback trend: A slowly increasing CAC payback period is often more diagnostic than an absolute number. If payback goes from 12 months to 14 months to 16 months over three quarters, the GTM engine is degrading — even if 16 months is still within the "acceptable" range.

KPI 11: LTV:CAC Ratio

Formula: LTV / CAC, where LTV = (Avg Monthly Revenue × Gross Margin %) / Monthly Churn Rate

Update cadence: Quarterly (LTV is a long-horizon calculation; monthly updates add noise, not signal).

Benchmarks:

• Minimum viable: 3x
• Good: 5x
• Excellent: 7x+

The churn sensitivity problem: LTV is highly sensitive to your churn rate input. At 2% monthly churn and $300 avg MRR with 70% gross margin: LTV = (300 × 0.70) / 0.02 = $10,500. At 4% churn: LTV = $5,250. The ratio halves with a doubling of churn rate. This is why LTV:CAC calculations should always be presented with the churn rate assumption disclosed.

For the full LTV:CAC analysis framework, see LTV:CAC ratio guide and customer lifetime value.

KPI 12: Burn Multiple

Formula: Net Cash Burn / Net New ARR, where Net New ARR = (Ending MRR - Starting MRR) × 12

Update cadence: Monthly. Track trailing 3-month average to reduce noise.

2026 benchmark targets:

Why this is a weekly founder metric: Burn Multiple is the one metric that connects your operational decisions (hiring, spend) to your fundraising outcomes. A deteriorating Burn Multiple with 12 months of runway is an urgent problem. For the full Burn Multiple framework, see Burn Multiple guide.

Dashboard Layout Design

Tier 1 Daily Pulse (top of the dashboard, always visible):

[ MRR: $127K ] [ New MRR this week: $4.2K ] [ Churned MRR this week: $1.1K ]
[ Cash balance: $840K ] [ Trial conversions today: 3 ]

Tier 2 Weekly Review Section (full 12-metric view):

Color coding: Green = at or above benchmark. Yellow = within 20% of red flag threshold. Red = at or beyond red flag threshold.

Trend arrows: Always show trend vs. 4 weeks prior, not vs. prior month. Four-week comparison smooths month-end noise.

Tier 3: Monthly Deep-Dive Agenda

The monthly deep-dive uses the same 12 metrics but adds:

1. Cohort retention heatmap (which cohorts are churning faster or slower than average?)

2. Segment breakdowns (NRR and churn by plan tier, acquisition channel, customer size)

3. Benchmark comparison (how do current numbers compare to 2026 SaaS benchmarks?)

4. Model reforecast (update the SaaS financial model with actuals, reforecast next 12 months)

5. Runway update (what is current runway and does anything need to change?)

Time budget: 90–120 minutes, ideally with a co-founder, CFO, or key operator.

Common Dashboard Anti-Patterns

Anti-pattern 1: Mixing GAAP revenue and MRR in the same view GAAP revenue and MRR are different numbers and should be in separate sections. Mixing them creates confusion about whether "revenue" means recognized GAAP revenue or the current MRR run rate. See SaaS revenue recognition and MRR for the distinction.

Anti-pattern 2: Reporting only blended NRR without segmentation If NRR is 108%, that looks healthy. But if NRR for customers acquired in the last 6 months is 92% and NRR for customers acquired 12–24 months ago is 115%, you have a new customer retention problem that the blended number hides.

Anti-pattern 3: Showing investors a snapshot without trend Investors do not care about your current MRR as much as they care about the trajectory. A dashboard that shows 12 current numbers without 12-month trend lines tells half the story.

Anti-pattern 4: Updating the dashboard quarterly instead of weekly Quarterly updates turn the dashboard into a report. Weekly updates make it an operating tool. The cadence is the feature.

Building the Dashboard: Tool Recommendations

For a detailed comparison of tools, see ChartMogul alternatives.

Conclusion

Twelve metrics, three review cadences, one action framework. That is the complete operating system for a B2B SaaS dashboard.

The founder who reviews MRR, NRR, CAC Payback, and Burn Multiple weekly — with trend data, segment breakdowns, and benchmark context — has the information needed to make good decisions about hiring, spending, GTM focus, and fundraising timing.

The founder who opens a 40-metric dashboard once a month and looks at the current numbers is flying with delayed instruments and too many gauges.

Start with the 12. Build the three-tier cadence. Add segmentation when each metric's aggregate number is no longer sufficient to explain what is happening underneath. Use the calculator to model how changes to any metric affect your 12-month ARR trajectory and use the ARR forecasting guide to connect your current metrics to a forward projection.

Frequently Asked Questions

What are the most important KPIs for a B2B SaaS company?

The 12 core KPIs are: MRR, MRR Growth Rate, New MRR, Expansion MRR, Contraction MRR, Churned MRR, NRR, Revenue Churn Rate, CAC, CAC Payback, LTV:CAC, and Burn Multiple. If you track only four, track MRR, NRR, CAC Payback, and Burn Multiple — these four together predict business health more completely than any other combination.

How often should SaaS founders review their KPI dashboard?

Use a three-tier cadence: daily (5 metrics: MRR, new MRR, churned MRR, cash balance, trial conversions), weekly (all 12 metrics), monthly (full cohort analysis, benchmarking, segment breakdowns). Weekly is the primary review cadence — daily is for flagging acute issues, monthly is for strategy.

What tool should I use for a SaaS KPI dashboard?

For <$50K MRR: Google Sheets spreadsheet is sufficient. $50K–$200K MRR: Baremetrics ($129/month) or the SaasDash.ai diagnostic dashboard. $200K+ MRR: ChartMogul for cohort depth plus a financial model for the forward projection. The tool matters less than the review cadence.

What is a red flag in a SaaS KPI dashboard?

Automatic red flags: NRR below 100% for two consecutive months (you are shrinking your base faster than you grow it), CAC payback above 24 months at growth stage (unsustainable unit economics), monthly revenue churn above 3% for SMB or 1.5% for mid-market, and Burn Multiple above 2x with less than 18 months runway.