SaaS Metrics Dashboard
Track and analyze key SaaS metrics including MRR, NRR, CAC, LTV with SQL queries and dashboard setup
The SaaS Metrics workflow helps you build a comprehensive metrics dashboard to track the health and growth of your business. From MRR to CAC/LTV ratios, this guide provides SQL queries, calculation methods, and benchmarks.
Overview
| Property | Value |
|---|---|
| Metrics | 15+ key SaaS metrics |
| Tier | Free |
| Typical Duration | 1-2 weeks to implement |
| Best For | SaaS businesses tracking growth |
Outcomes
A successful metrics implementation delivers:
- Real-time metrics dashboard
- Automated metric calculations
- Historical trend analysis
- Benchmarking against industry standards
- Data-driven decision making
Core Metrics Framework
SAAS METRICS HIERARCHY
┌──────────────┐
│ ARR │
│ Revenue │
└──────┬───────┘
│
┌─────────────────┼─────────────────┐
│ │ │
┌──────▼──────┐ ┌──────▼──────┐ ┌──────▼──────┐
│ New MRR │ │ Expansion │ │ Churn │
│ │ │ MRR │ │ MRR │
└──────┬──────┘ └─────────────┘ └─────────────┘
│
┌─────────┴─────────┐
│ │
┌───▼───┐ ┌────▼────┐
│ CAC │ │ LTV │
│ │ │ │
└───────┘ └─────────┘
Revenue Metrics
Monthly Recurring Revenue (MRR)
Definition: Total predictable revenue normalized to one month
Loading code block...
MRR Components:
Loading code block...
Annual Recurring Revenue (ARR)
Loading code block...
Net Revenue Retention (NRR)
Definition: Revenue from existing customers compared to same period last year
Loading code block...
NRR Benchmarks:
| NRR | Rating | Interpretation |
|---|---|---|
| >120% | Excellent | Strong expansion |
| 100-120% | Good | Healthy growth |
| 90-100% | Fair | Maintaining |
| <90% | Poor | Revenue declining |
Gross Revenue Retention (GRR)
Loading code block...
Customer Metrics
Customer Acquisition Cost (CAC)
Definition: Cost to acquire one customer
Loading code block...
CAC by Channel:
Loading code block...
Lifetime Value (LTV)
Definition: Total revenue expected from a customer
Loading code block...
Cohort-based LTV:
Loading code block...
LTV:CAC Ratio
Loading code block...
LTV:CAC Benchmarks:
| Ratio | Rating | Action |
|---|---|---|
| >5:1 | Over-performing | Invest more in growth |
| 3-5:1 | Healthy | Maintain and optimize |
| 1-3:1 | Warning | Improve before scaling |
| <1:1 | Critical | Stop spending, fix fundamentals |
CAC Payback Period
Loading code block...
Churn Metrics
Logo Churn (Customer Churn)
Loading code block...
Revenue Churn
Loading code block...
Churn Benchmarks:
| Segment | Good Monthly Churn | Great Monthly Churn |
|---|---|---|
| SMB | <5% | <3% |
| Mid-Market | <3% | <2% |
| Enterprise | <1% | <0.5% |
Growth Metrics
Growth Rate
Loading code block...
Quick Ratio
Definition: (New MRR + Expansion MRR) / (Churned MRR + Contraction MRR)
Loading code block...
Quick Ratio Benchmarks:
| Ratio | Rating |
|---|---|
| >4 | Excellent growth |
| 2-4 | Good growth |
| 1-2 | Slow growth |
| <1 | Declining |
Dashboard Implementation
Metrics API
Loading code block...
Dashboard Component
Loading code block...
Recommended Agents
| Phase | Agent | Purpose |
|---|---|---|
| Database | database-expert | SQL queries optimization |
| Backend | backend-expert | API implementation |
| Frontend | frontend-expert | Dashboard UI |
| Analytics | analytics-expert | Metric definitions |
Deliverables
| Deliverable | Description |
|---|---|
| Metrics API | Endpoints for all key metrics |
| Dashboard UI | Visual metrics display |
| SQL queries | Optimized queries for each metric |
| Documentation | Metric definitions and formulas |
| Alerts | Threshold-based notifications |
Best Practices
- Automate everything - Manual calculations lead to errors
- Track trends, not just snapshots - Direction matters more than absolute
- Segment your data - Averages hide important patterns
- Benchmark against peers - Context matters
- Review regularly - Weekly at minimum
- Act on insights - Data without action is useless
Common Pitfalls
- Vanity metrics - Focus on actionable metrics
- Wrong timeframes - Match to your sales cycle
- Ignoring cohorts - New and old customers behave differently
- Over-precision - Don't optimize for decimal places
- Delayed data - Real-time > batch for critical metrics
Related Workflows
- Product-Market Fit - Validate PMF with metrics
- Retention - Improve retention metrics
- Acquisition - Optimize CAC
- Fundraising Readiness - Metrics investors want