saas-metrics
Compare original and translation side by side
🇺🇸
Original
English🇨🇳
Translation
ChineseSaaS Metrics
SaaS业务指标
Comprehensive SaaS metrics analysis covering MRR, ARR, Churn, LTV, CAC, cohort analysis, and investor reporting. Essential for SaaS founders, finance teams, and investors.
涵盖MRR、ARR、客户流失率、LTV、CAC、同期群分析及投资者报告的全面SaaS业务指标分析。是SaaS创始人、财务团队和投资者的必备内容。
Overview
概述
This skill enables:
- Revenue metrics calculation (MRR, ARR, NRR)
- Churn and retention analysis
- Unit economics (LTV, CAC, LTV:CAC)
- Cohort analysis and forecasting
- Investor-ready reporting
本技能支持：
- 收入指标计算（MRR、ARR、NRR）
- 客户流失与留存分析
- 单位经济效益（LTV、CAC、LTV:CAC）
- 同期群分析与预测
- 面向投资者的合规报告
Core Metrics Framework
核心指标框架
1. Revenue Metrics
1. 收入指标
┌─────────────────────────────────────────────────────────────┐
│ MRR WATERFALL │
├─────────────────────────────────────────────────────────────┤
│ │
│ Starting MRR $100,000 │
│ + New MRR (new customers) +$15,000 │
│ + Expansion MRR (upgrades) +$8,000 │
│ + Reactivation MRR +$2,000 │
│ - Contraction MRR (downgrades) -$3,000 │
│ - Churn MRR (cancellations) -$7,000 │
│ ───────────────────────────────────────────── │
│ = Ending MRR $115,000 │
│ │
│ Net New MRR = $15,000 │
│ MRR Growth Rate = 15% │
│ │
└─────────────────────────────────────────────────────────────┘Calculations:
yaml
mrr_metrics:
# Monthly Recurring Revenue
MRR: sum(all_active_subscriptions.monthly_value)
# Annual Recurring Revenue
ARR: MRR × 12
# MRR Components
new_mrr: sum(new_subscriptions_this_month)
expansion_mrr: sum(upgrades_this_month)
contraction_mrr: sum(downgrades_this_month)
churn_mrr: sum(cancelled_subscriptions_mrr)
reactivation_mrr: sum(reactivated_subscriptions)
# Net New MRR
net_new_mrr: new_mrr + expansion_mrr + reactivation_mrr - contraction_mrr - churn_mrr
# Growth Rates
mrr_growth_rate: (ending_mrr - starting_mrr) / starting_mrr × 100
mom_growth: (current_mrr - previous_mrr) / previous_mrr × 100┌─────────────────────────────────────────────────────────────┐
│ MRR WATERFALL │
├─────────────────────────────────────────────────────────────┤
│ │
│ Starting MRR $100,000 │
│ + New MRR (new customers) +$15,000 │
│ + Expansion MRR (upgrades) +$8,000 │
│ + Reactivation MRR +$2,000 │
│ - Contraction MRR (downgrades) -$3,000 │
│ - Churn MRR (cancellations) -$7,000 │
│ ───────────────────────────────────────────── │
│ = Ending MRR $115,000 │
│ │
│ Net New MRR = $15,000 │
│ MRR Growth Rate = 15% │
│ │
└─────────────────────────────────────────────────────────────┘计算公式:
yaml
mrr_metrics:
# Monthly Recurring Revenue
MRR: sum(all_active_subscriptions.monthly_value)
# Annual Recurring Revenue
ARR: MRR × 12
# MRR Components
new_mrr: sum(new_subscriptions_this_month)
expansion_mrr: sum(upgrades_this_month)
contraction_mrr: sum(downgrades_this_month)
churn_mrr: sum(cancelled_subscriptions_mrr)
reactivation_mrr: sum(reactivated_subscriptions)
# Net New MRR
net_new_mrr: new_mrr + expansion_mrr + reactivation_mrr - contraction_mrr - churn_mrr
# Growth Rates
mrr_growth_rate: (ending_mrr - starting_mrr) / starting_mrr × 100
mom_growth: (current_mrr - previous_mrr) / previous_mrr × 1002. Churn Metrics
2. 客户流失指标
yaml
churn_metrics:
# Logo Churn (Customer Count)
logo_churn_rate:
formula: customers_lost / customers_start_of_period × 100
benchmark: <5% monthly for SMB, <2% for Enterprise
# Revenue Churn (MRR)
gross_revenue_churn:
formula: churned_mrr / starting_mrr × 100
benchmark: <3% monthly
# Net Revenue Churn (includes expansion)
net_revenue_churn:
formula: (churned_mrr - expansion_mrr) / starting_mrr × 100
target: negative (net expansion)
# Net Revenue Retention (NRR)
nrr:
formula: (starting_mrr - churn + expansion) / starting_mrr × 100
benchmark:
good: 100-110%
great: 110-120%
best_in_class: >120%Churn Analysis Template:
markdown
undefinedyaml
churn_metrics:
# Logo Churn (Customer Count)
logo_churn_rate:
formula: customers_lost / customers_start_of_period × 100
benchmark: <5% monthly for SMB, <2% for Enterprise
# Revenue Churn (MRR)
gross_revenue_churn:
formula: churned_mrr / starting_mrr × 100
benchmark: <3% monthly
# Net Revenue Churn (includes expansion)
net_revenue_churn:
formula: (churned_mrr - expansion_mrr) / starting_mrr × 100
target: negative (net expansion)
# Net Revenue Retention (NRR)
nrr:
formula: (starting_mrr - churn + expansion) / starting_mrr × 100
benchmark:
good: 100-110%
great: 110-120%
best_in_class: >120%客户流失分析模板:
markdown
undefinedChurn Analysis - {Month}
客户流失分析 - {月份}
Summary
摘要
| Metric | Value | Benchmark | Status |
|---|---|---|---|
| Logo Churn | 3.2% | <5% | ✅ |
| Gross Revenue Churn | 2.8% | <3% | ✅ |
| Net Revenue Retention | 108% | >100% | ✅ |
| 指标 | 数值 | 基准值 | 状态 |
|---|---|---|---|
| 客户数量流失率 | 3.2% | <5% | ✅ |
| 总收入流失率 | 2.8% | <3% | ✅ |
| 净收入留存率 | 108% | >100% | ✅ |
Churn Breakdown
流失原因细分
| Reason | Customers | MRR Lost | % of Total |
|---|---|---|---|
| Price | 5 | $2,500 | 35% |
| Competitor | 3 | $1,800 | 25% |
| No longer needed | 4 | $1,500 | 21% |
| Product issues | 2 | $800 | 11% |
| Other | 2 | $600 | 8% |
| 原因 | 客户数量 | 流失MRR | 占比 |
|---|---|---|---|
| 价格因素 | 5 | $2,500 | 35% |
| 竞品吸引 | 3 | $1,800 | 25% |
| 需求消失 | 4 | $1,500 | 21% |
| 产品问题 | 2 | $800 | 11% |
| 其他 | 2 | $600 | 8% |
Cohort Performance
同期群表现
- Q1 2025 cohort: 95% retention at month 6
- Q4 2024 cohort: 88% retention at month 9
- Enterprise segment: 97% retention (best)
---- 2025年Q1同期群：第6个月留存率95%
- 2024年Q4同期群：第9个月留存率88%
- 企业客户细分：留存率97%（最佳）
---3. Unit Economics
3. 单位经济效益
┌─────────────────────────────────────────────────────────────┐
│ UNIT ECONOMICS │
├─────────────────────────────────────────────────────────────┤
│ │
│ Customer Lifetime Value (LTV) │
│ ──────────────────────────── │
│ ARPU × Gross Margin % │
│ ─────────────────────── = LTV │
│ Churn Rate │
│ │
│ Example: │
│ $100 ARPU × 80% margin / 3% churn = $2,667 LTV │
│ │
│ ═══════════════════════════════════════════════════════ │
│ │
│ Customer Acquisition Cost (CAC) │
│ ──────────────────────────────── │
│ Sales & Marketing Spend │
│ ─────────────────────────── = CAC │
│ New Customers Acquired │
│ │
│ Example: │
│ $50,000 S&M / 50 customers = $1,000 CAC │
│ │
│ ═══════════════════════════════════════════════════════ │
│ │
│ LTV:CAC Ratio = $2,667 / $1,000 = 2.67x │
│ CAC Payback = $1,000 / ($100 × 80%) = 12.5 months │
│ │
└─────────────────────────────────────────────────────────────┘Benchmarks:
yaml
unit_economics_benchmarks:
ltv_cac_ratio:
poor: <1x
acceptable: 1-2x
good: 2-3x
great: 3-5x
excellent: >5x
cac_payback_months:
enterprise: <18
mid_market: <12
smb: <6
consumer: <3
gross_margin:
saas_typical: 70-85%
infrastructure: 50-70%
services_heavy: 40-60%┌─────────────────────────────────────────────────────────────┐
│ UNIT ECONOMICS │
├─────────────────────────────────────────────────────────────┤
│ │
│ Customer Lifetime Value (LTV) │
│ ──────────────────────────── │
│ ARPU × Gross Margin % │
│ ─────────────────────── = LTV │
│ Churn Rate │
│ │
│ 示例： │
│ $100 ARPU × 80% 毛利率 / 3% 流失率 = $2,667 LTV │
│ │
│ ═══════════════════════════════════════════════════════ │
│ │
│ Customer Acquisition Cost (CAC) │
│ ──────────────────────────────── │
│ 销售与营销支出 │
│ ─────────────────────────── = CAC │
│ 新增客户数量 │
│ │
│ 示例： │
│ $50,000 销售营销费用 / 50个客户 = $1,000 CAC │
│ │
│ ═══════════════════════════════════════════════════════ │
│ │
│ LTV:CAC 比率 = $2,667 / $1,000 = 2.67x │
│ CAC回收期 = $1,000 / ($100 × 80%) = 12.5个月 │
│ │
└─────────────────────────────────────────────────────────────┘基准值:
yaml
unit_economics_benchmarks:
ltv_cac_ratio:
poor: <1x
acceptable: 1-2x
good: 2-3x
great: 3-5x
excellent: >5x
cac_payback_months:
enterprise: <18
mid_market: <12
smb: <6
consumer: <3
gross_margin:
saas_typical: 70-85%
infrastructure: 50-70%
services_heavy: 40-60%4. Cohort Analysis
4. 同期群分析
yaml
cohort_analysis:
# Define cohorts by signup month
cohort_definition: signup_month
# Track retention over time
retention_matrix:
columns: [Month_0, Month_1, Month_2, ..., Month_12]
rows: [Jan_cohort, Feb_cohort, Mar_cohort, ...]
values: active_customers / initial_customers × 100
# Track revenue retention
revenue_cohort:
values: current_mrr / initial_mrr × 100
# Cohort LTV calculation
cohort_ltv:
formula: sum(all_revenue_from_cohort) / initial_cohort_sizeCohort Table Example:
Retention by Cohort (% of customers still active)
Month 0 Month 1 Month 2 Month 3 Month 6 Month 12
Jan '25 100% 92% 87% 84% 78% 65%
Feb '25 100% 94% 89% 86% 80% -
Mar '25 100% 93% 88% 85% - -
Apr '25 100% 95% 90% - - -
May '25 100% 94% - - - -
Jun '25 100% - - - - -
Average 100% 94% 89% 85% 79% 65%yaml
cohort_analysis:
# Define cohorts by signup month
cohort_definition: signup_month
# Track retention over time
retention_matrix:
columns: [Month_0, Month_1, Month_2, ..., Month_12]
rows: [Jan_cohort, Feb_cohort, Mar_cohort, ...]
values: active_customers / initial_customers × 100
# Track revenue retention
revenue_cohort:
values: current_mrr / initial_mrr × 100
# Cohort LTV calculation
cohort_ltv:
formula: sum(all_revenue_from_cohort) / initial_cohort_size同期群表格示例:
Retention by Cohort (% of customers still active)
Month 0 Month 1 Month 2 Month 3 Month 6 Month 12
Jan '25 100% 92% 87% 84% 78% 65%
Feb '25 100% 94% 89% 86% 80% -
Mar '25 100% 93% 88% 85% - -
Apr '25 100% 95% 90% - - -
May '25 100% 94% - - - -
Jun '25 100% - - - - -
Average 100% 94% 89% 85% 79% 65%Quick Ratio
快速比率
yaml
quick_ratio:
formula: (new_mrr + expansion_mrr) / (contraction_mrr + churn_mrr)
interpretation:
"<1": Shrinking (losing more than gaining)
"1-2": Sustainable growth
"2-4": Good growth efficiency
">4": Excellent (hypergrowth potential)
example:
new_mrr: 15000
expansion_mrr: 8000
contraction_mrr: 3000
churn_mrr: 7000
quick_ratio: (15000 + 8000) / (3000 + 7000) = 2.3yaml
quick_ratio:
formula: (new_mrr + expansion_mrr) / (contraction_mrr + churn_mrr)
interpretation:
"<1": 业务萎缩（流失大于新增）
"1-2": 可持续增长
"2-4": 良好的增长效率
">4": 优秀（具备爆发增长潜力）
example:
new_mrr: 15000
expansion_mrr: 8000
contraction_mrr: 3000
churn_mrr: 7000
quick_ratio: (15000 + 8000) / (3000 + 7000) = 2.3Investor Reporting Template
投资者报告模板
Monthly Metrics Dashboard
月度指标仪表盘
markdown
undefinedmarkdown
undefined{Company} - Monthly Metrics Report
{公司名称} - 月度指标报告
{Month Year}
{年月}
Key Metrics Summary
核心指标摘要
| Metric | Current | Previous | Change | Benchmark |
|---|---|---|---|---|
| ARR | $1.38M | $1.20M | +15% | - |
| MRR | $115K | $100K | +15% | - |
| Net New MRR | $15K | $12K | +25% | - |
| NRR | 108% | 105% | +3pp | >100% ✅ |
| Logo Churn | 3.2% | 3.5% | -0.3pp | <5% ✅ |
| LTV:CAC | 2.7x | 2.5x | +0.2x | >3x ⚠️ |
| CAC Payback | 12.5mo | 13mo | -0.5mo | <12mo ⚠️ |
| 指标 | 当前值 | 上月值 | 变化 | 基准值 |
|---|---|---|---|---|
| ARR | $1.38M | $1.20M | +15% | - |
| MRR | $115K | $100K | +15% | - |
| 净新增MRR | $15K | $12K | +25% | - |
| NRR | 108% | 105% | +3pp | >100% ✅ |
| 客户数量流失率 | 3.2% | 3.5% | -0.3pp | <5% ✅ |
| LTV:CAC | 2.7x | 2.5x | +0.2x | >3x ⚠️ |
| CAC回收期 | 12.5mo | 13mo | -0.5mo | <12mo ⚠️ |
MRR Waterfall
MRR变化瀑布图
Starting MRR: $100,000
+ New: +$15,000 (12 customers)
+ Expansion: +$8,000 (25 upgrades)
+ Reactivation: +$2,000 (5 returns)
- Contraction: -$3,000 (15 downgrades)
- Churn: -$7,000 (18 cancellations)
═════════════════════════════
Ending MRR: $115,000初始MRR: $100,000
+ 新增: +$15,000 (12个客户)
+ 扩容: +$8,000 (25次升级)
+ 重新激活: +$2,000 (5个回流客户)
- 缩容: -$3,000 (15次降级)
- 流失: -$7,000 (18次取消订阅)
═════════════════════════════
期末MRR: $115,000Customer Metrics
客户细分指标
| Segment | Customers | MRR | ARPU | Churn |
|---|---|---|---|---|
| Enterprise | 45 | $45K | $1,000 | 1.5% |
| Mid-Market | 120 | $36K | $300 | 2.8% |
| SMB | 350 | $34K | $97 | 4.5% |
| Total | 515 | $115K | $223 | 3.2% |
| 细分群体 | 客户数量 | MRR | ARPU | 流失率 |
|---|---|---|---|---|
| 企业客户 | 45 | $45K | $1,000 | 1.5% |
| 中端市场 | 120 | $36K | $300 | 2.8% |
| 中小企业 | 350 | $34K | $97 | 4.5% |
| 总计 | 515 | $115K | $223 | 3.2% |
Runway & Burn
现金流 runway 与消耗
- Cash Balance: $2.5M
- Monthly Burn: $85K
- Runway: 29 months
- Revenue/Burn Ratio: 1.35x
- 现金余额: $2.5M
- 月度消耗: $85K
- Runway: 29个月
- 收入/消耗比率: 1.35x
Goals vs Actuals
目标与实际完成情况
| Goal | Target | Actual | Status |
|---|---|---|---|
| New Customers | 15 | 12 | 🔴 80% |
| Net New MRR | $12K | $15K | 🟢 125% |
| NRR | 105% | 108% | 🟢 103% |
| CAC Payback | 12mo | 12.5mo | 🟡 96% |
| 目标 | 指标 | 实际完成 | 状态 |
|---|---|---|---|
| 新增客户 | 15 | 12 | 🔴 80% |
| 净新增MRR | $12K | $15K | 🟢 125% |
| NRR | 105% | 108% | 🟢 103% |
| CAC回收期 | 12mo | 12.5mo | 🟡 96% |
Next Month Outlook
下月展望
- Pipeline: $45K in qualified opportunities
- Expected closes: 8-10 customers
- Projected MRR: $125-130K
- Key risks: Enterprise deal slip, holiday slowdown
---- 销售管道: $45K 合格商机
- 预计成交: 8-10个客户
- 预计MRR: $125-130K
- 主要风险: 企业级交易延期、节假日业务放缓
---Forecasting Model
预测模型
Bottom-Up Revenue Forecast
自下而上的收入预测
yaml
forecast_model:
# Starting point
base_mrr: 115000
# Growth assumptions
assumptions:
new_customers_monthly: 15
avg_new_customer_mrr: 1250
expansion_rate: 2% # of existing MRR
contraction_rate: 0.5%
logo_churn_rate: 3%
# Monthly calculation
monthly_forecast:
new_mrr: new_customers × avg_mrr
expansion_mrr: existing_mrr × expansion_rate
contraction_mrr: existing_mrr × contraction_rate
churn_mrr: existing_mrr × churn_rate
ending_mrr: |
starting_mrr
+ new_mrr
+ expansion_mrr
- contraction_mrr
- churn_mrryaml
forecast_model:
# Starting point
base_mrr: 115000
# Growth assumptions
assumptions:
new_customers_monthly: 15
avg_new_customer_mrr: 1250
expansion_rate: 2% # of existing MRR
contraction_rate: 0.5%
logo_churn_rate: 3%
# Monthly calculation
monthly_forecast:
new_mrr: new_customers × avg_mrr
expansion_mrr: existing_mrr × expansion_rate
contraction_mrr: existing_mrr × contraction_rate
churn_mrr: existing_mrr × churn_rate
ending_mrr: |
starting_mrr
+ new_mrr
+ expansion_mrr
- contraction_mrr
- churn_mrr12-Month Projection
12个月预测
Month Starting New Expansion Churn Ending Growth
Jan $115,000 $18,750 $2,300 $3,450 $132,600 15.3%
Feb $132,600 $18,750 $2,652 $3,978 $150,024 13.1%
Mar $150,024 $18,750 $3,000 $4,501 $167,274 11.5%
...
Dec $285,000 $18,750 $5,700 $8,550 $300,900 5.6%
Annual Summary:
- Starting ARR: $1.38M
- Ending ARR: $3.61M
- Growth: 162%Month Starting New Expansion Churn Ending Growth
Jan $115,000 $18,750 $2,300 $3,450 $132,600 15.3%
Feb $132,600 $18,750 $2,652 $3,978 $150,024 13.1%
Mar $150,024 $18,750 $3,000 $4,501 $167,274 11.5%
...
Dec $285,000 $18,750 $5,700 $8,550 $300,900 5.6%
年度摘要:
- 初始ARR: $1.38M
- 期末ARR: $3.61M
- 增长率: 162%Segmentation Analysis
细分分析
yaml
segment_analysis:
by_plan:
- name: Starter
mrr: 20000
customers: 300
arpu: 67
churn: 6%
- name: Professional
mrr: 45000
customers: 150
arpu: 300
churn: 3%
- name: Enterprise
mrr: 50000
customers: 50
arpu: 1000
churn: 1.5%
by_industry:
- tech: {mrr: 60000, churn: 2.5%}
- finance: {mrr: 30000, churn: 2%}
- retail: {mrr: 25000, churn: 5%}
by_company_size:
- 1-50: {arpu: 100, churn: 5%}
- 51-200: {arpu: 350, churn: 3%}
- 201+: {arpu: 1200, churn: 1.5%}yaml
segment_analysis:
by_plan:
- name: Starter
mrr: 20000
customers: 300
arpu: 67
churn: 6%
- name: Professional
mrr: 45000
customers: 150
arpu: 300
churn: 3%
- name: Enterprise
mrr: 50000
customers: 50
arpu: 1000
churn: 1.5%
by_industry:
- tech: {mrr: 60000, churn: 2.5%}
- finance: {mrr: 30000, churn: 2%}
- retail: {mrr: 25000, churn: 5%}
by_company_size:
- 1-50: {arpu: 100, churn: 5%}
- 51-200: {arpu: 350, churn: 3%}
- 201+: {arpu: 1200, churn: 1.5%}Output Example
输出示例
Request: "Calculate SaaS metrics for my company"
Output:
markdown
undefined请求: "为我的公司计算SaaS业务指标"
输出:
markdown
undefinedSaaS Metrics Analysis
SaaS业务指标分析
Executive Summary
执行摘要
Your SaaS business is showing healthy growth with some areas for optimization.
您的SaaS业务呈现健康增长态势，但仍有部分领域可优化。
Strengths ✅
优势 ✅
- Net Revenue Retention of 108% (above 100% benchmark)
- Quick Ratio of 2.3x (good growth efficiency)
- Enterprise segment showing 97% retention
- 净收入留存率达108%（高于100%的基准值）
- 快速比率为2.3x（增长效率良好）
- 企业客户细分留存率达97%
Areas to Improve ⚠️
待优化领域 ⚠️
- LTV:CAC ratio at 2.7x (target: >3x)
- CAC payback at 12.5 months (target: <12 months)
- SMB segment churn at 4.5% (target: <4%)
- LTV:CAC比率为2.7x（目标: >3x）
- CAC回收期为12.5个月（目标: <12个月）
- 中小企业细分流失率达4.5%（目标: <4%）
Recommendations
建议
- Reduce CAC: Focus on lower-cost acquisition channels
- Improve SMB retention: Add onboarding sequences
- Expand enterprise: Higher ARPU, lower churn
- Increase expansion revenue: Upsell/cross-sell programs
- 降低CAC: 聚焦低成本获客渠道
- 提升中小企业留存: 新增用户引导流程
- 拓展企业客户: 更高ARPU，更低流失率
- 增加扩容收入: 交叉销售/向上销售项目
Key Metrics at a Glance
核心指标概览
| Metric | Value | Status |
|---|---|---|
| ARR | $1.38M | 📈 +15% MoM |
| NRR | 108% | ✅ Healthy |
| LTV:CAC | 2.7x | ⚠️ Improve |
| Runway | 29 months | ✅ Safe |
---
*SaaS Metrics Skill - Part of Claude Office Skills*| 指标 | 数值 | 状态 |
|---|---|---|
| ARR | $1.38M | 📈 月环比+15% |
| NRR | 108% | ✅ 健康 |
| LTV:CAC | 2.7x | ⚠️ 需优化 |
| Runway | 29个月 | ✅ 安全 |
---
*SaaS业务指标技能 - Claude办公技能套件的一部分*