CTO
SaaS Metrics Dashboard — Track ARR, Churn, LTV, CAC in One View
Key Takeaway
The SaaS skill calculates and tracks the metrics that matter for subscription businesses — ARR, MRR, churn rate, LTV, CAC, CAC payback period, net revenue retention, and cohort analysis. Your agent turns raw billing data into investor-grade metrics.
The Problem
You're running a SaaS business. An investor asks: "What's your net revenue retention?" You don't know. You know your Stripe MRR (sort of). You know roughly how many customers you have. But:
- ARR: Is it MRR × 12, or do you account for annual contracts differently?
- Churn: Logo churn or revenue churn? Gross or net? Monthly or annual?
- LTV: Which calculation method? Simple (ARPU/churn) or cohort-based?
- CAC: Do you include sales salaries? Marketing tools? Content costs?
- NRR: Net revenue retention — the metric that separates good SaaS from great SaaS
- Quick ratio: Can you grow faster than you're losing?
Most founders track MRR in Stripe and everything else in a spreadsheet that hasn't been updated since the last board meeting.
The Solution
The SaaS skill computes all key SaaS metrics from your billing and customer data, builds cohort analyses, and produces investor-ready reports.
The Process
View details
You: Here's our SaaS data for last quarter:
- Starting MRR: $82,000 (140 customers)
- New MRR: $18,000 (28 new customers)
- Expansion MRR: $6,200 (upgrades)
- Contraction MRR: $2,800 (downgrades)
- Churned MRR: $4,400 (8 customers left)
- Ending MRR: $99,000 (160 customers)
Marketing spend: $32,000/quarter
Sales team cost: $45,000/quarter
Average deal size: $643/month
Calculate everything an investor would want to see.
The agent produces:
View details
## SaaS Metrics Report — Q4 2025
### Revenue Metrics
ARR: $1,188,000 ($99K × 12)
ARR Growth Rate: 82% YoY
MRR Growth: 20.7% QoQ ($82K → $99K)
Quick Ratio: 3.4 ($24.2K new+expansion / $7.2K contraction+churn)
→ Above 4 is excellent, above 2 is healthy ✅
### Retention Metrics
Gross Revenue Retention: 91.2%
($82K - $4.4K - $2.8K) / $82K
→ Above 90% is good for SMB SaaS ✅
Net Revenue Retention: 98.8%
($82K + $6.2K - $2.8K - $4.4K) / $82K
→ Below 100% means growth depends entirely on
new customer acquisition ⚠️
→ Target: 110%+ (expansion covers churn)
Logo Churn Rate: 5.7% quarterly (8/140)
→ Annualized: ~21% — high for SaaS ⚠️
→ Target: under 10% annually
Revenue Churn Rate: 5.4% quarterly ($4.4K/$82K)
→ Net Revenue Churn: 0.24% (offset by expansion)
### Unit Economics
CAC: $2,750 ($77K total spend / 28 new customers)
ARPU: $619/month ($99K / 160)
LTV (simple): $619 / 5.4% monthly churn = $11,463
LTV:CAC Ratio: 4.2x
→ Above 3x is healthy ✅
CAC Payback: 4.4 months ($2,750 / $619)
→ Under 12 months is excellent ✅
### Health Indicators
| Metric | Your Value | Benchmark | Status |
|---|---|---|---|
| Quick Ratio | 3.4 | >2.0 | ✅ Healthy |
| Gross Retention | 91.2% | >85% | ✅ Good |
| Net Retention | 98.8% | >100% | ⚠️ Below target |
| Logo Churn | 21% annual | Under 10% | 🔴 High |
| LTV:CAC | 4.2x | >3x | ✅ Healthy |
| CAC Payback | 4.4 mo | Under 12 mo | ✅ Excellent |
### Strategic Insight
Your unit economics are strong (LTV:CAC, payback).
The problem is RETENTION. At 21% annual logo churn,
you need to acquire 34 new customers per quarter
just to stay flat. Your expansion revenue ($6.2K)
nearly but doesn't quite offset churn + contraction.
Priority: reduce churn before increasing acquisition
spend. Every 1% reduction in churn is worth more
than every 1% increase in new customer acquisition
at your current scale.
The Results
| Metric | Stripe Dashboard | Spreadsheet | AI SaaS Skill |
|---|---|---|---|
| MRR | Yes | Yes | Yes |
| NRR | No | Maybe (if formulas right) | Yes + benchmarks |
| Cohort analysis | No | Painful | Automated |
| Quick ratio | No | Rarely | Yes |
| Strategic insight | No | No | Yes (retention vs acquisition) |
| Investor-ready | No | Depends on who built it | Yes |
| Update frequency | Real-time (MRR only) | Quarterly (if lucky) | On-demand |
Setup on MrChief
yamlShow code
skills:
- saas
- data-analysis
Related case studies
SRE
Ansible Playbook for 50 Servers — Configure Everything in One Run
The Ansible skill generates complete playbooks for server configuration, application deployment, and infrastructure management. Describe what you need across your fleet, get idempotent, tested playbooks that configure 50 servers as easily as 1.
Backend Developer
API Design That Developers Actually Love — RESTful Done Right
The API Design skill generates complete RESTful API specifications — OpenAPI 3.1 schemas, endpoint design, authentication flows, pagination strategies, error handling, rate limiting, and versioning. Your agent designs APIs that follow industry best practices so your consumers don't hate you.
Founder
Business Plan in 2 Hours — Not 2 Weeks
The Business Plan skill generates comprehensive business plans — executive summary, market analysis, business model, financial projections, competitive landscape, go-to-market strategy, and risk analysis. From idea to investor-ready document.
Want results like these?
Start free with your own AI team. No credit card required.