SaaS Metrics Coach Skill
Overview
Production-ready SaaS metrics toolkit for calculating MRR/ARR, analyzing cohort retention, and evaluating unit economics. Designed for SaaS founders, finance teams, and growth operators who need precise subscription revenue analysis without spreadsheet gymnastics.
Quick Start
# Calculate MRR, ARR, growth rate, and churn from subscription data
python scripts/mrr_calculator.py subscriptions.csv
# Run cohort retention analysis
python scripts/cohort_analyzer.py users.csv --cohort-period monthly
# Calculate LTV, CAC, LTV:CAC ratio, and payback period
python scripts/unit_economics.py metrics.json
Tools Overview
| Tool |
Purpose |
Input |
Output |
mrr_calculator.py |
MRR, ARR, growth rate, churn |
CSV with subscription data |
Revenue metrics + trends |
cohort_analyzer.py |
Cohort retention analysis |
CSV with user signup/activity data |
Retention matrix + curves |
unit_economics.py |
LTV, CAC, LTV:CAC, payback |
JSON with acquisition/revenue data |
Unit economics dashboard |
Workflows
Workflow 1: Monthly SaaS Health Check
- Export subscription data as CSV (columns: customer_id, plan, mrr, start_date, end_date)
- Run
mrr_calculator.py to get current MRR, ARR, net new MRR, churn rate
- Run
cohort_analyzer.py on user activity data to identify retention trends
- Run
unit_economics.py to validate LTV:CAC ratio stays above 3:1
- Review output for warning flags (churn > 5%, LTV:CAC < 3, payback > 18 months)
Workflow 2: Investor Deck Preparation
- Run
mrr_calculator.py --format json to get growth metrics for charts
- Run
cohort_analyzer.py --format json for retention curves
- Run
unit_economics.py --format json for unit economics summary
- Use JSON output to populate investor deck data points
Workflow 3: Churn Investigation
- Run
mrr_calculator.py with --breakdown to see churn by plan tier
- Run
cohort_analyzer.py to identify which cohorts churn fastest
- Cross-reference cohort drop-off periods with product changes
- Identify if churn is concentrated in specific segments or time windows
Reference Documentation
Key SaaS Metrics Definitions
- MRR (Monthly Recurring Revenue): Sum of all active subscription revenue normalized to monthly
- ARR (Annual Recurring Revenue): MRR x 12
- Net New MRR: New MRR + Expansion MRR - Churned MRR - Contraction MRR
- Gross Churn Rate: Lost MRR / Beginning MRR for the period
- Net Revenue Retention (NRR): (Beginning MRR + Expansion - Churn - Contraction) / Beginning MRR
- LTV (Lifetime Value): ARPU / Monthly Churn Rate (simplified) or ARPU x Gross Margin / Churn
- CAC (Customer Acquisition Cost): Total Sales & Marketing Spend / New Customers Acquired
- LTV:CAC Ratio: Target 3:1 or higher for healthy SaaS
- CAC Payback Period: CAC / (ARPU x Gross Margin) in months
See references/saas-metrics-guide.md for comprehensive framework details.
Common Patterns
Pattern: Subscription CSV Format
customer_id,plan,mrr,start_date,end_date,status
C001,pro,99.00,2025-01-15,,active
C002,basic,29.00,2025-02-01,2025-08-15,churned
C003,enterprise,499.00,2025-03-10,,active
Pattern: User Activity CSV Format
user_id,signup_date,last_active_date,activity_month
U001,2025-01-05,2025-06-15,2025-06
U002,2025-01-12,2025-03-20,2025-03
Pattern: Unit Economics JSON Format
{
"period": "2025-Q4",
"total_customers": 1200,
"new_customers": 150,
"churned_customers": 45,
"total_mrr": 89500.00,
"arpu": 74.58,
"gross_margin": 0.82,
"sales_marketing_spend": 45000.00,
"monthly_churn_rate": 0.0375
}
Healthy SaaS Benchmarks
| Metric |
Concerning |
Acceptable |
Strong |
| Monthly Churn |
> 5% |
2-5% |
< 2% |
| Net Revenue Retention |
< 90% |
90-110% |
> 120% |
| LTV:CAC |
< 1:1 |
1:1-3:1 |
> 3:1 |
| CAC Payback |
> 24 mo |
12-18 mo |
< 12 mo |
| Gross Margin |
< 60% |
60-75% |
> 75% |
1---
2name: saas-metrics-coach
3description: >
4 This skill should be used when the user asks to "calculate MRR", "analyze churn",
5 "compute SaaS metrics", "do cohort retention analysis", "calculate LTV or CAC",
6 "evaluate unit economics", or "track subscription revenue growth".
7license: MIT + Commons Clause
8metadata:
9 source: https://skillmd.com/skills/aaaaqwq/saas-metrics-coach
10 version: 1.0.0
11 author: borghei
12 category: finance
13 domain: saas-metrics
14 updated: 2026-04-02
15 tags: [saas, mrr, arr, churn, cohort-analysis, ltv, cac, unit-economics]
16---
17
18# SaaS Metrics Coach Skill
19
20## Overview
21
22Production-ready SaaS metrics toolkit for calculating MRR/ARR, analyzing cohort retention, and evaluating unit economics. Designed for SaaS founders, finance teams, and growth operators who need precise subscription revenue analysis without spreadsheet gymnastics.
23
24## Quick Start
25
26```bash
27# Calculate MRR, ARR, growth rate, and churn from subscription data
28python scripts/mrr_calculator.py subscriptions.csv
29
30# Run cohort retention analysis
31python scripts/cohort_analyzer.py users.csv --cohort-period monthly
32
33# Calculate LTV, CAC, LTV:CAC ratio, and payback period
34python scripts/unit_economics.py metrics.json
35```
36
37## Tools Overview
38
39| Tool | Purpose | Input | Output |
40|------|---------|-------|--------|
41| `mrr_calculator.py` | MRR, ARR, growth rate, churn | CSV with subscription data | Revenue metrics + trends |
42| `cohort_analyzer.py` | Cohort retention analysis | CSV with user signup/activity data | Retention matrix + curves |
43| `unit_economics.py` | LTV, CAC, LTV:CAC, payback | JSON with acquisition/revenue data | Unit economics dashboard |
44
45## Workflows
46
47### Workflow 1: Monthly SaaS Health Check
48
491. Export subscription data as CSV (columns: customer_id, plan, mrr, start_date, end_date)
502. Run `mrr_calculator.py` to get current MRR, ARR, net new MRR, churn rate
513. Run `cohort_analyzer.py` on user activity data to identify retention trends
524. Run `unit_economics.py` to validate LTV:CAC ratio stays above 3:1
535. Review output for warning flags (churn > 5%, LTV:CAC < 3, payback > 18 months)
54
55### Workflow 2: Investor Deck Preparation
56
571. Run `mrr_calculator.py --format json` to get growth metrics for charts
582. Run `cohort_analyzer.py --format json` for retention curves
593. Run `unit_economics.py --format json` for unit economics summary
604. Use JSON output to populate investor deck data points
61
62### Workflow 3: Churn Investigation
63
641. Run `mrr_calculator.py` with `--breakdown` to see churn by plan tier
652. Run `cohort_analyzer.py` to identify which cohorts churn fastest
663. Cross-reference cohort drop-off periods with product changes
674. Identify if churn is concentrated in specific segments or time windows
68
69## Reference Documentation
70
71### Key SaaS Metrics Definitions
72
73- **MRR (Monthly Recurring Revenue):** Sum of all active subscription revenue normalized to monthly
74- **ARR (Annual Recurring Revenue):** MRR x 12
75- **Net New MRR:** New MRR + Expansion MRR - Churned MRR - Contraction MRR
76- **Gross Churn Rate:** Lost MRR / Beginning MRR for the period
77- **Net Revenue Retention (NRR):** (Beginning MRR + Expansion - Churn - Contraction) / Beginning MRR
78- **LTV (Lifetime Value):** ARPU / Monthly Churn Rate (simplified) or ARPU x Gross Margin / Churn
79- **CAC (Customer Acquisition Cost):** Total Sales & Marketing Spend / New Customers Acquired
80- **LTV:CAC Ratio:** Target 3:1 or higher for healthy SaaS
81- **CAC Payback Period:** CAC / (ARPU x Gross Margin) in months
82
83See `references/saas-metrics-guide.md` for comprehensive framework details.
84
85## Common Patterns
86
87### Pattern: Subscription CSV Format
88```csv
89customer_id,plan,mrr,start_date,end_date,status
90C001,pro,99.00,2025-01-15,,active
91C002,basic,29.00,2025-02-01,2025-08-15,churned
92C003,enterprise,499.00,2025-03-10,,active
93```
94
95### Pattern: User Activity CSV Format
96```csv
97user_id,signup_date,last_active_date,activity_month
98U001,2025-01-05,2025-06-15,2025-06
99U002,2025-01-12,2025-03-20,2025-03
100```
101
102### Pattern: Unit Economics JSON Format
103```json
104{
105 "period": "2025-Q4",
106 "total_customers": 1200,
107 "new_customers": 150,
108 "churned_customers": 45,
109 "total_mrr": 89500.00,
110 "arpu": 74.58,
111 "gross_margin": 0.82,
112 "sales_marketing_spend": 45000.00,
113 "monthly_churn_rate": 0.0375
114}
115```
116
117### Healthy SaaS Benchmarks
118
119| Metric | Concerning | Acceptable | Strong |
120|--------|-----------|------------|--------|
121| Monthly Churn | > 5% | 2-5% | < 2% |
122| Net Revenue Retention | < 90% | 90-110% | > 120% |
123| LTV:CAC | < 1:1 | 1:1-3:1 | > 3:1 |
124| CAC Payback | > 24 mo | 12-18 mo | < 12 mo |
125| Gross Margin | < 60% | 60-75% | > 75% |