Comprehensive SaaS Metrics & KPI Dashboard Builder

## ROLE
You are a SaaS finance and analytics leader who has built metrics frameworks for companies from $100K to $100M ARR. You have deep expertise in subscription business modeling, cohort analysis, and the specific KPIs that drive SaaS valuation multiples. You are well-versed in the benchmarking data from OpenView, Bessemer, KeyBanc, and SaaS Capital.

## OBJECTIVE
Design a comprehensive SaaS metrics and KPI dashboard framework for [COMPANY_NAME] that gives leadership a clear, real-time view of business health across revenue, retention, efficiency, and growth. Each metric must include a precise definition, calculation formula, benchmark target, and strategic interpretation guide.

## CONTEXT
- **Company:** [COMPANY_NAME]
- **Current ARR:** [CURRENT_ARR]
- **Stage:** [STAGE] (e.g., Pre-Seed to Series D)
- **Pricing Model:** [PRICING_MODEL] (e.g., per-seat, usage-based, flat-rate, hybrid)
- **Contract Type:** [CONTRACT_TYPE] (e.g., monthly, annual, multi-year)
- **Target Segment:** [PRIMARY_SEGMENT] (SMB, Mid-Market, Enterprise)
- **Current Team Size:** [HEADCOUNT]
- **Primary Growth Motion:** [GROWTH_MOTION] (Product-Led, Sales-Led, Hybrid)

## TASK

### Category 1: Revenue Metrics

**Monthly Recurring Revenue (MRR)**
- **Definition:** The normalized monthly revenue from all active subscriptions
- **Formula:** Sum of (each customer's monthly subscription value)
- **Components:** New MRR + Expansion MRR + Reactivation MRR - Contraction MRR - Churn MRR = Net New MRR
- **Benchmark:** MoM growth rate of 10-20% for early stage, 5-10% for growth stage
- **Strategic Use:** Primary pulse check on business momentum; decompose into components to understand growth drivers

**Annual Recurring Revenue (ARR)**
- **Definition:** MRR × 12; represents the annualized value of recurring revenue
- **Formula:** Current MRR × 12
- **Benchmark:** Growth rate varies by stage — see the T2D3 framework (Triple, Triple, Double, Double, Double)
- **Strategic Use:** Headline metric for board reporting, fundraising, and valuation conversations

**Average Revenue Per Account (ARPA)**
- **Definition:** Total MRR divided by total number of paying customers
- **Formula:** Total MRR / Total Paying Customers
- **Benchmark:** Highly industry-dependent; track trend over time — rising ARPA indicates successful upselling
- **Strategic Use:** Indicates whether you're moving upmarket or downmarket; informs pricing decisions

**Revenue Growth Rate (YoY)**
- **Definition:** Year-over-year revenue growth percentage
- **Formula:** (Current Period ARR - Prior Year ARR) / Prior Year ARR × 100
- **Benchmark by ARR scale:** $1-5M ARR: 100-200%, $5-20M: 60-100%, $20-50M: 40-60%, $50M+: 30-40%
- **Strategic Use:** The single most important metric for SaaS valuation multiples

### Category 2: Retention & Expansion Metrics

**Net Revenue Retention (NRR)**
- **Definition:** Revenue retained from existing customers including expansion, contraction, and churn
- **Formula:** (Starting MRR + Expansion - Contraction - Churn) / Starting MRR × 100
- **Benchmark:** Best-in-class >130%, Good >110%, Concerning <100%
- **Strategic Use:** NRR >100% means you grow even without new customers; the single best predictor of long-term health

**Gross Revenue Retention (GRR)**
- **Definition:** Revenue retained from existing customers excluding expansion (only contraction and churn)
- **Formula:** (Starting MRR - Contraction - Churn) / Starting MRR × 100
- **Benchmark:** Best-in-class >95%, Good >90%, Concerning <85%
- **Strategic Use:** Measures the "floor" of your retention — how much revenue you keep before any upselling

**Logo Churn Rate**
- **Definition:** Percentage of customers lost in a given period
- **Formula:** Customers Lost in Period / Customers at Start of Period × 100
- **Benchmark:** Monthly: <2% for SMB, <1% for Mid-Market, <0.5% for Enterprise
- **Strategic Use:** Pair with revenue churn — high logo churn with low revenue churn means you're losing small accounts

**Customer Lifetime Value (LTV)**
- **Definition:** Total revenue expected from a customer over their entire relationship
- **Formula:** ARPA × Gross Margin % × (1 / Monthly Churn Rate)
- **Alternative:** ARPA × Gross Margin % × Average Customer Lifetime (in months)
- **Benchmark:** Meaningfully higher than CAC (see LTV:CAC ratio below)
- **Strategic Use:** Determines maximum rational spend on customer acquisition

### Category 3: Sales Efficiency Metrics

**Customer Acquisition Cost (CAC)**
- **Definition:** Total cost to acquire one new customer
- **Formula:** (Total Sales & Marketing Spend in Period) / New Customers Acquired in Period
- **Refinement:** Separate into Blended CAC (all spend) vs. Paid CAC (only paid channels)
- **Benchmark:** Context-dependent — meaningless without LTV comparison
- **Strategic Use:** Track by channel and segment to optimize spend allocation

**LTV:CAC Ratio**
- **Definition:** Ratio of customer lifetime value to acquisition cost
- **Formula:** LTV / CAC
- **Benchmark:** 3:1 is healthy, >5:1 means you should invest more aggressively, <3:1 means unit economics need work
- **Strategic Use:** The fundamental indicator of business model sustainability

**CAC Payback Period**
- **Definition:** Months required to recoup the cost of acquiring a customer
- **Formula:** CAC / (ARPA × Gross Margin %)
- **Benchmark:** <12 months for SMB, <18 months for Mid-Market, <24 months for Enterprise
- **Strategic Use:** Determines cash efficiency and how quickly growth investments recycle

**Magic Number**
- **Definition:** Revenue efficiency metric measuring the return on sales and marketing spend
- **Formula:** (Current Quarter ARR - Previous Quarter ARR) / Previous Quarter Sales & Marketing Spend
- **Benchmark:** >0.75 = invest more aggressively, 0.5-0.75 = steady growth, <0.5 = optimize before scaling
- **Strategic Use:** Tells you whether adding more sales and marketing spend will generate proportional returns

### Category 4: Product & Engagement Metrics

**DAU/MAU Ratio**
- **Definition:** Daily Active Users divided by Monthly Active Users — measures engagement stickiness
- **Formula:** Average DAU in Month / MAU in Month × 100
- **Benchmark:** 20-25% is good for B2B SaaS, 50%+ is exceptional (daily use product)
- **Strategic Use:** Predicts retention — highly engaged users rarely churn

**Activation Rate**
- **Definition:** Percentage of new signups that reach the "aha moment" or first value event
- **Formula:** Users Completing Activation Milestone / Total New Signups × 100
- **Define Activation as:** [ACTIVATION_EVENT] (e.g., "completed first project," "invited a team member," "processed first transaction")
- **Benchmark:** 20-40% for freemium, 40-60% for free trial, 60-80% for paid only
- **Strategic Use:** The highest-leverage metric for PLG companies — small activation improvements compound dramatically

**Feature Adoption Rate**
- **Definition:** Percentage of users actively using a specific feature
- **Formula:** Users Who Used Feature X in Period / Total Active Users in Period × 100
- **Benchmark:** Core features >60%, secondary features >25%, new features >10% in first month
- **Strategic Use:** Identifies underutilized features (improve or remove) and power features (promote more)

### Category 5: Operational Efficiency Metrics

**Burn Multiple**
- **Definition:** How much cash you burn to generate each dollar of net new ARR
- **Formula:** Net Burn / Net New ARR
- **Benchmark:** <1x = exceptional, 1-1.5x = great, 1.5-2x = good, 2-3x = concerning, >3x = poor
- **Strategic Use:** The modern replacement for the Rule of 40 at earlier stages — measures capital efficiency

**Rule of 40**
- **Definition:** Combined revenue growth rate and profit margin should exceed 40%
- **Formula:** Revenue Growth Rate (%) + EBITDA Margin (%) ≥ 40
- **Benchmark:** >40% is healthy, >60% is best-in-class, <20% is concerning
- **Strategic Use:** Balances the growth-vs-profitability tradeoff; used by public market investors for valuation

**Revenue per Employee**
- **Definition:** Total ARR divided by total headcount
- **Formula:** ARR / Total Full-Time Employees
- **Benchmark:** $100K-$200K for early stage, $200K-$300K for growth, $300K+ for scaled/efficient
- **Strategic Use:** Operational efficiency measure — should increase as the company scales

### Dashboard Layout Recommendation
Design the executive dashboard with these views:

**Top-Level View (CEO/Board):**
- ARR with trendline (12-month)
- MRR waterfall (new, expansion, contraction, churn)
- NRR and GRR (trailing 12-month)
- Cash position and runway
- Rule of 40 or Burn Multiple

**Sales View (CRO/VP Sales):**
- Pipeline value and coverage ratio
- Win rate by segment and deal size
- CAC, LTV:CAC, and payback by channel
- Magic Number trend
- Quota attainment distribution

**Product View (CPO/VP Product):**
- DAU/MAU with cohort overlay
- Activation rate with funnel breakdown
- Feature adoption heatmap
- NPS trend with verbatim highlights
- Support ticket volume and resolution time

**Finance View (CFO):**
- Cash flow forecast (13-week)
- Burn rate with scenario analysis
- Revenue per employee trend
- Gross margin by product line
- Deferred revenue and billing schedule

## OUTPUT FORMAT
Deliver as a comprehensive metrics playbook with:
- Complete metric definitions table (Metric | Formula | Benchmark | Owner | Cadence)
- Recommended dashboard layout with widget specifications
- Data source mapping: which system provides which metric
- Alert thresholds: when to flag a metric as needing attention
- Quarterly board deck template showing how to present these metrics