MRR = Sum of all active monthly subscription values

Components:
- New MRR: Revenue from new customers this month
- Expansion MRR: Revenue increase from upgrades
- Contraction MRR: Revenue decrease from downgrades
- Churned MRR: Revenue lost from cancellations
- Net New MRR: New + Expansion - Contraction - Churned

Annual Recurring Revenue (ARR)

ARR = MRR × 12

Note: For annual subscriptions, ARR = sum of annual values

Revenue Dashboard Output

When queried for metrics, provide:

## Revenue Dashboard

**As of:** [Date]
**Period:** [Month/Quarter]

### MRR Summary

| Metric | Value | vs Last Month |
|--------|-------|---------------|
| **Total MRR** | $[amount] | [+/-]% |
| New MRR | $[amount] | [+/-]% |
| Expansion MRR | $[amount] | [+/-]% |
| Contraction MRR | -$[amount] | [+/-]% |
| Churned MRR | -$[amount] | [+/-]% |
| **Net New MRR** | $[amount] | [+/-]% |

### ARR Projection

**Current ARR:** $[MRR × 12]
**Projected Year-End:** $[projection]

### MRR Trend (Last 6 Months)

Jan: ████████████████████████ $24,500 Feb: █████████████████████████ $25,200 Mar: ██████████████████████████ $26,100 Apr: ███████████████████████████ $27,800 May: ████████████████████████████ $29,200 Jun: █████████████████████████████ $30,500


### Key Metrics

| Metric | Value | Benchmark |
|--------|-------|-----------|
| Revenue Churn | [%] | < 2% good |
| Net Revenue Retention | [%] | > 100% good |
| Customer LTV | $[amount] | |
| CAC Payback | [months] | < 12 good |
| LTV:CAC Ratio | [ratio] | > 3:1 good |

Churn Metrics

Revenue Churn Rate

Monthly Revenue Churn = Churned MRR / Starting MRR × 100

Example:
- Starting MRR: $100,000
- Churned MRR: $2,000
- Revenue Churn: 2%

Net Revenue Retention (NRR)

NRR = (Starting MRR + Expansion - Contraction - Churn) / Starting MRR × 100

Example:
- Starting MRR: $100,000
- Expansion: $5,000
- Contraction: $1,000
- Churn: $2,000
- NRR: ($100k + $5k - $1k - $2k) / $100k = 102%

NRR > 100% = Growing even without new customers

Logo Churn vs Revenue Churn

Metric	Focus	Importance
Logo Churn	Customer count	Product-market fit
Revenue Churn	Dollar value	Business health

Logo Churn = Lost Customers / Starting Customers × 100
Revenue Churn = Churned MRR / Starting MRR × 100

Customer Lifetime Value (LTV)

Basic LTV

LTV = ARPU / Monthly Churn Rate

Example:
- ARPU: $100/month
- Churn: 5%/month
- LTV: $100 / 0.05 = $2,000

LTV with Gross Margin

LTV = (ARPU × Gross Margin) / Monthly Churn Rate

Example:
- ARPU: $100
- Gross Margin: 80%
- Churn: 5%
- LTV: ($100 × 0.8) / 0.05 = $1,600

Revenue by Segment

By Plan Tier

### MRR by Plan

| Plan | Customers | MRR | Avg MRR | % of Total |
|------|-----------|-----|---------|------------|
| Enterprise | 15 | $22,500 | $1,500 | 45% |
| Pro | 120 | $17,880 | $149 | 36% |
| Starter | 450 | $9,450 | $21 | 19% |
| **Total** | 585 | $49,830 | $85 | 100% |

By Cohort

### Cohort Revenue Retention

| Cohort | M0 | M3 | M6 | M12 |
|--------|-----|-----|-----|------|
| Jan 24 | 100% | 92% | 85% | 78% |
| Apr 24 | 100% | 94% | 88% | - |
| Jul 24 | 100% | 95% | - | - |
| Oct 24 | 100% | - | - | - |

MRR Movement Analysis

Monthly Movement Report

### MRR Movement - [Month]

**Starting MRR:** $48,200

#### Additions (+$3,580)
| Type | Amount | Details |
|------|--------|---------|
| New | +$2,400 | 24 new customers |
| Expansion | +$1,180 | 8 upgrades |

#### Reductions (-$1,950)
| Type | Amount | Details |
|------|--------|---------|
| Contraction | -$650 | 4 downgrades |
| Churn | -$1,300 | 6 cancellations |

**Ending MRR:** $49,830
**Net Change:** +$1,630 (+3.4%)

Stripe Data Extraction

Get MRR from Stripe

# List active subscriptions
stripe subscriptions list --status=active --limit=100

# Get specific subscription MRR
stripe subscriptions retrieve sub_xxx \
  --expand items.data.price

Calculate MRR

const subscriptions = await stripe.subscriptions.list({
  status: 'active',
  limit: 100
});

let mrr = 0;
for (const sub of subscriptions.data) {
  for (const item of sub.items.data) {
    const price = item.price;
    const quantity = item.quantity;

    if (price.recurring.interval === 'month') {
      mrr += price.unit_amount * quantity / 100;
    } else if (price.recurring.interval === 'year') {
      mrr += (price.unit_amount * quantity / 100) / 12;
    }
  }
}

Benchmarks

SaaS Benchmarks by Stage

Metric	Seed	Series A	Series B
MRR Growth	15-20%/mo	10-15%/mo	5-8%/mo
Net Revenue Retention	>100%	>110%	>120%
Gross Revenue Retention	>85%	>90%	>95%
Logo Churn	<5%/mo	<3%/mo	<2%/mo

Industry Benchmarks

Metric	Average	Good	Great
Revenue Churn	5%	2%	<1%
NRR	95%	105%	120%+
LTV:CAC	3:1	4:1	5:1+
CAC Payback	18mo	12mo	<9mo

Quick Reference

Metric Formulas

Metric	Formula
MRR	Σ(monthly subscription values)
ARR	MRR × 12
Revenue Churn	Churned MRR / Starting MRR
NRR	(Starting + Expansion - Contraction - Churn) / Starting
LTV	ARPU / Churn Rate
CAC Payback	CAC / (ARPU × Gross Margin)

Healthy Ranges

Metric	Healthy Range
Monthly Revenue Churn	< 2%
Net Revenue Retention	> 100%
Gross Margin	> 70%
LTV:CAC	> 3:1

Integration with Other Skills

Use stripe-webhooks to track real-time changes
Use subscription-lifecycle for detailed sub analysis
Use billing-analysis for pricing optimization
Feed data to customer-health scoring

revenue-recognition

Revenue Recognition & Metrics

Configuration

Core Metrics

Monthly Recurring Revenue (MRR)