Understand pipeline, forecast, ARR, bookings, and GTM efficiency in one review. — Claude Skill
Um Skill Claude para Claude Code por Alireza Rezvani — executar /revenue-operations no Claude·Atualizado em 12 de jun. de 2026·vmain@4a3c05b
Connects CRM and finance exports to pipeline health, forecast accuracy, ARR, TCV, bookings, CAC payback, NDR, and board-ready next actions.
- Reviews pipeline coverage, stage conversion, deal age, concentration risk, and next-step quality.
- Checks forecast accuracy, bias, trend, and category-level misses.
- Connects ARR, TCV, bookings, gross margin, CAC payback, NDR, and spend to GTM efficiency.
- Turns raw CRM and finance exports into risks, questions, and actions for pipeline reviews or QBRs.
RevOps builds spreadsheet packs by hand and reconciles CRM, finance, forecast, and board metrics late in the cycle.
Run /revenue-operations to calculate pipeline health, forecast accuracy, and GTM efficiency with templates and benchmarks.
Para quem é
O que faz
Find coverage gaps, stale deals, aging risk, stage imbalance, and next-step problems.
Measure forecast accuracy, bias, and repeated misses by segment, product, region, or owner.
Connect ARR, bookings, CAC payback, NDR, Magic Number, and burn to operating decisions.
Como funciona
Collect CRM pipeline, forecast history, bookings, ARR, CAC, churn, expansion, and spend inputs.
Choose the review type: weekly pipeline, forecast accuracy, GTM efficiency, QBR, or board pack.
Calculate the key signals and compare them to targets or prior periods.
Return risks, owner questions, recommended actions, and a clean executive summary.
Opções de entrada
Deals, stages, values, close dates, owners, next steps, forecast categories, and history.
Exemplo
Quarter target: $1.2M new ARR. Open pipeline: $3.1M. Commit forecast: $820k. Best case: $1.4M. Last quarter forecast accuracy: 71%. Risks: - 38% of pipeline closes in the last 10 days. - 12 deals have no next step. - Enterprise segment slipped twice. Need: what to discuss in Monday pipeline review and what leadership should know.
The skill separates headline pipeline size from real forecast risk. A big pipeline is not enough if close dates, next steps, or prior forecast accuracy are weak.
Pipeline coverage is 2.6x target, but late-quarter concentration and missing next steps make the pipeline less reliable than it looks.
Commit forecast covers 68% of target. With last quarter accuracy at 71%, the quarter should be treated as at risk unless enterprise slips are resolved.
Which 12 deals need next steps today? Which enterprise slips are real customer delays versus forecast hygiene issues? Which best-case deals can move to commit?
“Pipeline is large enough on paper, but forecast confidence is weak. The immediate focus is next-step cleanup, enterprise slip review, and commit gap recovery.”
Métricas que melhora
Funciona com
Quer usar Revenue Operations?
Escolha como começar.
Instale e execute este skill localmente no seu computador.
Abra um terminal no seu computador e cole este comando:
Isto descarrega o skill com todos os ficheiros para o seu computador:
Adicione -g no fim para o tornar disponível em todos os seus projetos.
Inicie o Claude Code, depois escreva o comando:
Revenue Operations
Pipeline analysis, forecast accuracy tracking, and GTM efficiency measurement for SaaS revenue teams.
Output formats: All scripts support
--format text(human-readable) and--format json(dashboards/integrations).
Quick Start
# Analyze pipeline health and coverage
python scripts/pipeline_analyzer.py --input assets/sample_pipeline_data.json --format text
# Track forecast accuracy over multiple periods
python scripts/forecast_accuracy_tracker.py assets/sample_forecast_data.json --format text
# Calculate GTM efficiency metrics
python scripts/gtm_efficiency_calculator.py assets/sample_gtm_data.json --format text
Tools Overview
1. Pipeline Analyzer
Analyzes sales pipeline health including coverage ratios, stage conversion rates, deal velocity, aging risks, and concentration risks.
Input: JSON file with deals, quota, and stage configuration Output: Coverage ratios, conversion rates, velocity metrics, aging flags, risk assessment
Usage:
python scripts/pipeline_analyzer.py --input pipeline.json --format text
Key Metrics Calculated:
- Pipeline Coverage Ratio -- Total pipeline value / quota target (healthy: 3-4x)
- Stage Conversion Rates -- Stage-to-stage progression rates
- Sales Velocity -- (Opportunities x Avg Deal Size x Win Rate) / Avg Sales Cycle
- Deal Aging -- Flags deals exceeding 2x average cycle time per stage
- Concentration Risk -- Warns when >40% of pipeline is in a single deal
- Coverage Gap Analysis -- Identifies quarters with insufficient pipeline
Input Schema:
{
"quota": 500000,
"stages": ["Discovery", "Qualification", "Proposal", "Negotiation", "Closed Won"],
"average_cycle_days": 45,
"deals": [
{
"id": "D001",
"name": "Acme Corp",
"stage": "Proposal",
"value": 85000,
"age_days": 32,
"close_date": "2025-03-15",
"owner": "rep_1"
}
]
}
2. Forecast Accuracy Tracker
Tracks forecast accuracy over time using MAPE, detects systematic bias, analyzes trends, and provides category-level breakdowns.
Input: JSON file with forecast periods and optional category breakdowns Output: MAPE score, bias analysis, trends, category breakdown, accuracy rating
Usage:
python scripts/forecast_accuracy_tracker.py forecast_data.json --format text
Key Metrics Calculated:
- MAPE -- mean(|actual - forecast| / |actual|) x 100
- Forecast Bias -- Over-forecasting (positive) vs under-forecasting (negative) tendency
- Weighted Accuracy -- MAPE weighted by deal value for materiality
- Period Trends -- Improving, stable, or declining accuracy over time
- Category Breakdown -- Accuracy by rep, product, segment, or any custom dimension
Accuracy Ratings:
| Rating | MAPE Range | Interpretation |
|---|---|---|
| Excellent | <10% | Highly predictable, data-driven process |
| Good | 10-15% | Reliable forecasting with minor variance |
| Fair | 15-25% | Needs process improvement |
| Poor | >25% | Significant forecasting methodology gaps |
Input Schema:
{
"forecast_periods": [
{"period": "2025-Q1", "forecast": 480000, "actual": 520000},
{"period": "2025-Q2", "forecast": 550000, "actual": 510000}
],
"category_breakdowns": {
"by_rep": [
{"category": "Rep A", "forecast": 200000, "actual": 210000},
{"category": "Rep B", "forecast": 280000, "actual": 310000}
]
}
}
3. GTM Efficiency Calculator
Calculates core SaaS GTM efficiency metrics with industry benchmarking, ratings, and improvement recommendations.
Input: JSON file with revenue, cost, and customer metrics Output: Magic Number, LTV:CAC, CAC Payback, Burn Multiple, Rule of 40, NDR with ratings
Usage:
python scripts/gtm_efficiency_calculator.py gtm_data.json --format text
Key Metrics Calculated:
| Metric | Formula | Target |
|---|---|---|
| Magic Number | Net New ARR / Prior Period S&M Spend | >0.75 |
| LTV:CAC | (ARPA x Gross Margin / Churn Rate) / CAC | >3:1 |
| CAC Payback | CAC / (ARPA x Gross Margin) months | <18 months |
| Burn Multiple | Net Burn / Net New ARR | <2x |
| Rule of 40 | Revenue Growth % + FCF Margin % | >40% |
| Net Dollar Retention | (Begin ARR + Expansion - Contraction - Churn) / Begin ARR | >110% |
Input Schema:
{
"revenue": {
"current_arr": 5000000,
"prior_arr": 3800000,
"net_new_arr": 1200000,
"arpa_monthly": 2500,
"revenue_growth_pct": 31.6
},
"costs": {
"sales_marketing_spend": 1800000,
"cac": 18000,
"gross_margin_pct": 78,
"total_operating_expense": 6500000,
"net_burn": 1500000,
"fcf_margin_pct": 8.4
},
"customers": {
"beginning_arr": 3800000,
"expansion_arr": 600000,
"contraction_arr": 100000,
"churned_arr": 300000,
"annual_churn_rate_pct": 8
}
}
Revenue Operations Workflows
Weekly Pipeline Review
Use this workflow for your weekly pipeline inspection cadence.
-
Verify input data: Confirm pipeline export is current and all required fields (stage, value, close_date, owner) are populated before proceeding.
-
Generate pipeline report:
python scripts/pipeline_analyzer.py --input current_pipeline.json --format text -
Cross-check output totals against your CRM source system to confirm data integrity.
-
Review key indicators:
- Pipeline coverage ratio (is it above 3x quota?)
- Deals aging beyond threshold (which deals need intervention?)
- Concentration risk (are we over-reliant on a few large deals?)
- Stage distribution (is there a healthy funnel shape?)
-
Document using template: Use
assets/pipeline_review_template.md -
Action items: Address aging deals, redistribute pipeline concentration, fill coverage gaps
Forecast Accuracy Review
Use monthly or quarterly to evaluate and improve forecasting discipline.
-
Verify input data: Confirm all forecast periods have corresponding actuals and no periods are missing before running.
-
Generate accuracy report:
python scripts/forecast_accuracy_tracker.py forecast_history.json --format text -
Cross-check actuals against closed-won records in your CRM before drawing conclusions.
-
Analyze patterns:
- Is MAPE trending down (improving)?
- Which reps or segments have the highest error rates?
- Is there systematic over- or under-forecasting?
-
Document using template: Use
assets/forecast_report_template.md -
Improvement actions: Coach high-bias reps, adjust methodology, improve data hygiene
GTM Efficiency Audit
Use quarterly or during board prep to evaluate go-to-market efficiency.
-
Verify input data: Confirm revenue, cost, and customer figures reconcile with finance records before running.
-
Calculate efficiency metrics:
python scripts/gtm_efficiency_calculator.py quarterly_data.json --format text -
Cross-check computed ARR and spend totals against your finance system before sharing results.
-
Benchmark against targets:
- Magic Number (>0.75)
- LTV:CAC (>3:1)
- CAC Payback (<18 months)
- Rule of 40 (>40%)
-
Document using template: Use
assets/gtm_dashboard_template.md -
Strategic decisions: Adjust spend allocation, optimize channels, improve retention
Quarterly Business Review
Combine all three tools for a comprehensive QBR analysis.
- Run pipeline analyzer for forward-looking coverage
- Run forecast tracker for backward-looking accuracy
- Run GTM calculator for efficiency benchmarks
- Cross-reference pipeline health with forecast accuracy
- Align GTM efficiency metrics with growth targets
Reference Documentation
| Reference | Description |
|---|---|
| RevOps Metrics Guide | Complete metrics hierarchy, definitions, formulas, and interpretation |
| Pipeline Management Framework | Pipeline best practices, stage definitions, conversion benchmarks |
| GTM Efficiency Benchmarks | SaaS benchmarks by stage, industry standards, improvement strategies |
Templates
| Template | Use Case |
|---|---|
| Pipeline Review Template | Weekly/monthly pipeline inspection documentation |
| Forecast Report Template | Forecast accuracy reporting and trend analysis |
| GTM Dashboard Template | GTM efficiency dashboard for leadership review |
| Sample Pipeline Data | Example input for pipeline_analyzer.py |
| Expected Output | Reference output from pipeline_analyzer.py |
Documentos de referência
name: "revenue-operations" description: Analyzes sales pipeline health, revenue forecasting accuracy, and go-to-market efficiency metrics for SaaS revenue optimization. Use when analyzing sales pipeline coverage, forecasting revenue, evaluating go-to-market performance, reviewing sales metrics, assessing pipeline analysis, tracking forecast accuracy with MAPE, calculating GTM efficiency, or measuring sales efficiency and unit economics for SaaS teams.
Revenue Operations
Pipeline analysis, forecast accuracy tracking, and GTM efficiency measurement for SaaS revenue teams.
Output formats: All scripts support
--format text(human-readable) and--format json(dashboards/integrations).
Quick Start
# Analyze pipeline health and coverage
python scripts/pipeline_analyzer.py --input assets/sample_pipeline_data.json --format text
# Track forecast accuracy over multiple periods
python scripts/forecast_accuracy_tracker.py assets/sample_forecast_data.json --format text
# Calculate GTM efficiency metrics
python scripts/gtm_efficiency_calculator.py assets/sample_gtm_data.json --format text
Tools Overview
1. Pipeline Analyzer
Analyzes sales pipeline health including coverage ratios, stage conversion rates, deal velocity, aging risks, and concentration risks.
Input: JSON file with deals, quota, and stage configuration Output: Coverage ratios, conversion rates, velocity metrics, aging flags, risk assessment
Usage:
python scripts/pipeline_analyzer.py --input pipeline.json --format text
Key Metrics Calculated:
- Pipeline Coverage Ratio -- Total pipeline value / quota target (healthy: 3-4x)
- Stage Conversion Rates -- Stage-to-stage progression rates
- Sales Velocity -- (Opportunities x Avg Deal Size x Win Rate) / Avg Sales Cycle
- Deal Aging -- Flags deals exceeding 2x average cycle time per stage
- Concentration Risk -- Warns when >40% of pipeline is in a single deal
- Coverage Gap Analysis -- Identifies quarters with insufficient pipeline
Input Schema:
{
"quota": 500000,
"stages": ["Discovery", "Qualification", "Proposal", "Negotiation", "Closed Won"],
"average_cycle_days": 45,
"deals": [
{
"id": "D001",
"name": "Acme Corp",
"stage": "Proposal",
"value": 85000,
"age_days": 32,
"close_date": "2025-03-15",
"owner": "rep_1"
}
]
}
2. Forecast Accuracy Tracker
Tracks forecast accuracy over time using MAPE, detects systematic bias, analyzes trends, and provides category-level breakdowns.
Input: JSON file with forecast periods and optional category breakdowns Output: MAPE score, bias analysis, trends, category breakdown, accuracy rating
Usage:
python scripts/forecast_accuracy_tracker.py forecast_data.json --format text
Key Metrics Calculated:
- MAPE -- mean(|actual - forecast| / |actual|) x 100
- Forecast Bias -- Over-forecasting (positive) vs under-forecasting (negative) tendency
- Weighted Accuracy -- MAPE weighted by deal value for materiality
- Period Trends -- Improving, stable, or declining accuracy over time
- Category Breakdown -- Accuracy by rep, product, segment, or any custom dimension
Accuracy Ratings:
| Rating | MAPE Range | Interpretation |
|---|---|---|
| Excellent | <10% | Highly predictable, data-driven process |
| Good | 10-15% | Reliable forecasting with minor variance |
| Fair | 15-25% | Needs process improvement |
| Poor | >25% | Significant forecasting methodology gaps |
Input Schema:
{
"forecast_periods": [
{"period": "2025-Q1", "forecast": 480000, "actual": 520000},
{"period": "2025-Q2", "forecast": 550000, "actual": 510000}
],
"category_breakdowns": {
"by_rep": [
{"category": "Rep A", "forecast": 200000, "actual": 210000},
{"category": "Rep B", "forecast": 280000, "actual": 310000}
]
}
}
3. GTM Efficiency Calculator
Calculates core SaaS GTM efficiency metrics with industry benchmarking, ratings, and improvement recommendations.
Input: JSON file with revenue, cost, and customer metrics Output: Magic Number, LTV:CAC, CAC Payback, Burn Multiple, Rule of 40, NDR with ratings
Usage:
python scripts/gtm_efficiency_calculator.py gtm_data.json --format text
Key Metrics Calculated:
| Metric | Formula | Target |
|---|---|---|
| Magic Number | Net New ARR / Prior Period S&M Spend | >0.75 |
| LTV:CAC | (ARPA x Gross Margin / Churn Rate) / CAC | >3:1 |
| CAC Payback | CAC / (ARPA x Gross Margin) months | <18 months |
| Burn Multiple | Net Burn / Net New ARR | <2x |
| Rule of 40 | Revenue Growth % + FCF Margin % | >40% |
| Net Dollar Retention | (Begin ARR + Expansion - Contraction - Churn) / Begin ARR | >110% |
Input Schema:
{
"revenue": {
"current_arr": 5000000,
"prior_arr": 3800000,
"net_new_arr": 1200000,
"arpa_monthly": 2500,
"revenue_growth_pct": 31.6
},
"costs": {
"sales_marketing_spend": 1800000,
"cac": 18000,
"gross_margin_pct": 78,
"total_operating_expense": 6500000,
"net_burn": 1500000,
"fcf_margin_pct": 8.4
},
"customers": {
"beginning_arr": 3800000,
"expansion_arr": 600000,
"contraction_arr": 100000,
"churned_arr": 300000,
"annual_churn_rate_pct": 8
}
}
Revenue Operations Workflows
Weekly Pipeline Review
Use this workflow for your weekly pipeline inspection cadence.
-
Verify input data: Confirm pipeline export is current and all required fields (stage, value, close_date, owner) are populated before proceeding.
-
Generate pipeline report:
python scripts/pipeline_analyzer.py --input current_pipeline.json --format text -
Cross-check output totals against your CRM source system to confirm data integrity.
-
Review key indicators:
- Pipeline coverage ratio (is it above 3x quota?)
- Deals aging beyond threshold (which deals need intervention?)
- Concentration risk (are we over-reliant on a few large deals?)
- Stage distribution (is there a healthy funnel shape?)
-
Document using template: Use
assets/pipeline_review_template.md -
Action items: Address aging deals, redistribute pipeline concentration, fill coverage gaps
Forecast Accuracy Review
Use monthly or quarterly to evaluate and improve forecasting discipline.
-
Verify input data: Confirm all forecast periods have corresponding actuals and no periods are missing before running.
-
Generate accuracy report:
python scripts/forecast_accuracy_tracker.py forecast_history.json --format text -
Cross-check actuals against closed-won records in your CRM before drawing conclusions.
-
Analyze patterns:
- Is MAPE trending down (improving)?
- Which reps or segments have the highest error rates?
- Is there systematic over- or under-forecasting?
-
Document using template: Use
assets/forecast_report_template.md -
Improvement actions: Coach high-bias reps, adjust methodology, improve data hygiene
GTM Efficiency Audit
Use quarterly or during board prep to evaluate go-to-market efficiency.
-
Verify input data: Confirm revenue, cost, and customer figures reconcile with finance records before running.
-
Calculate efficiency metrics:
python scripts/gtm_efficiency_calculator.py quarterly_data.json --format text -
Cross-check computed ARR and spend totals against your finance system before sharing results.
-
Benchmark against targets:
- Magic Number (>0.75)
- LTV:CAC (>3:1)
- CAC Payback (<18 months)
- Rule of 40 (>40%)
-
Document using template: Use
assets/gtm_dashboard_template.md -
Strategic decisions: Adjust spend allocation, optimize channels, improve retention
Quarterly Business Review
Combine all three tools for a comprehensive QBR analysis.
- Run pipeline analyzer for forward-looking coverage
- Run forecast tracker for backward-looking accuracy
- Run GTM calculator for efficiency benchmarks
- Cross-reference pipeline health with forecast accuracy
- Align GTM efficiency metrics with growth targets
Reference Documentation
| Reference | Description |
|---|---|
| RevOps Metrics Guide | Complete metrics hierarchy, definitions, formulas, and interpretation |
| Pipeline Management Framework | Pipeline best practices, stage definitions, conversion benchmarks |
| GTM Efficiency Benchmarks | SaaS benchmarks by stage, industry standards, improvement strategies |
Templates
| Template | Use Case |
|---|---|
| Pipeline Review Template | Weekly/monthly pipeline inspection documentation |
| Forecast Report Template | Forecast accuracy reporting and trend analysis |
| GTM Dashboard Template | GTM efficiency dashboard for leadership review |
| Sample Pipeline Data | Example input for pipeline_analyzer.py |
| Expected Output | Reference output from pipeline_analyzer.py |
RevOps Metrics Guide
Complete reference for Revenue Operations metrics hierarchy, definitions, formulas, interpretation guidelines, and common mistakes.
Metrics Hierarchy
Revenue Operations metrics are organized in a hierarchy from leading indicators (pipeline activity) through lagging indicators (efficiency outcomes):
Level 1: Activity Metrics (Leading)
├── Pipeline created ($, #)
├── Meetings booked
├── Proposals sent
└── Demo completion rate
Level 2: Pipeline Metrics (Mid-funnel)
├── Pipeline coverage ratio
├── Stage conversion rates
├── Sales velocity
├── Deal aging
└── Pipeline hygiene score
Level 3: Revenue Metrics (Outcomes)
├── Bookings (new, expansion, renewal)
├── Revenue (ARR, MRR, TCV)
├── Win rate
└── Average deal size
Level 4: Efficiency Metrics (Unit Economics)
├── Magic Number
├── LTV:CAC Ratio
├── CAC Payback Period
├── Burn Multiple
├── Rule of 40
└── Net Dollar Retention
Level 5: Strategic Metrics (Board-Level)
├── Revenue per employee
├── Gross margin trend
├── NRR cohort analysis
└── Customer health score
Core Metric Definitions
Pipeline Coverage Ratio
Formula: Total Weighted Pipeline / Quota Target
What it measures: Whether there is sufficient pipeline to meet revenue targets.
Interpretation:
- 4x+: Strong coverage, selective deal pursuit possible
- 3-4x: Healthy coverage, standard operations
- 2-3x: At risk, accelerate pipeline generation
- <2x: Critical, immediate pipeline intervention needed
Common Mistakes:
- Including closed-won deals in the pipeline total
- Not weighting by stage probability
- Using annual quota against quarterly pipeline
- Ignoring deal quality in favor of quantity
Best Practice: Measure coverage ratio weekly. Track by quarter to identify seasonal gaps early.
Stage Conversion Rates
Formula: # Deals advancing to Stage N+1 / # Deals entering Stage N
What it measures: Efficiency of progression through each pipeline stage.
Typical SaaS Conversion Benchmarks:
| Stage Transition | Median Rate | Top Quartile |
|---|---|---|
| Lead to Qualification | 15-25% | 30%+ |
| Qualification to Proposal | 40-50% | 60%+ |
| Proposal to Negotiation | 50-60% | 70%+ |
| Negotiation to Close | 60-70% | 80%+ |
| Overall Win Rate | 15-25% | 30%+ |
Common Mistakes:
- Not standardizing stage exit criteria (subjective stages)
- Comparing conversion rates across different sales motions (PLG vs enterprise)
- Ignoring stage skipping (deals that jump stages inflate later conversion rates)
- Not segmenting by deal size or segment
Sales Velocity
Formula: (# Opportunities x Avg Deal Size x Win Rate) / Avg Sales Cycle Days
What it measures: The rate at which the pipeline generates revenue, measured as revenue per day.
Components:
- # Opportunities -- Volume of qualified deals in pipeline
- Avg Deal Size -- Average contract value of won deals
- Win Rate -- Percentage of deals that close
- Avg Sales Cycle -- Days from opportunity creation to close
Optimization levers:
- Increase opportunity volume (marketing/SDR investment)
- Increase deal size (pricing, packaging, upsell)
- Increase win rate (sales enablement, competitive positioning)
- Decrease cycle length (champion building, MEDDPICC adherence)
Common Mistakes:
- Using all pipeline deals instead of qualified opportunities
- Not normalizing for segment (SMB velocity vs Enterprise velocity)
- Conflating calendar time with active selling time
- Ignoring velocity trend in favor of absolute number
MAPE (Mean Absolute Percentage Error)
Formula: mean(|Actual - Forecast| / |Actual|) x 100
What it measures: Average forecast error magnitude as a percentage.
Interpretation:
| MAPE | Rating | Action |
|---|---|---|
| <10% | Excellent | Maintain current methodology |
| 10-15% | Good | Minor calibration adjustments |
| 15-25% | Fair | Methodology review needed |
| >25% | Poor | Fundamental process overhaul |
Common Mistakes:
- Using forecast vs. target instead of forecast vs. actual
- Not distinguishing between bias (systematic) and variance (random)
- Measuring only at the aggregate level (masks individual rep errors)
- Comparing MAPE across different time horizons (monthly vs quarterly)
Forecast Bias
Formula: mean(Forecast - Actual) / mean(Actual) x 100
What it measures: Systematic tendency to over-forecast or under-forecast.
Types:
- Positive bias (over-forecasting): Forecast consistently exceeds actual. Often indicates optimistic deal assessment, insufficient qualification, or sandbagging reversal.
- Negative bias (under-forecasting): Actual consistently exceeds forecast. Often indicates conservative call culture, late-stage deals arriving unexpectedly, or poor pipeline visibility.
Healthy Range: Bias within +/- 5% of actual is considered well-calibrated.
Magic Number
Formula: Net New ARR / Prior Period S&M Spend
What it measures: Efficiency of sales & marketing spend in generating new revenue.
Interpretation:
-
1.0: Extremely efficient, consider increasing GTM investment
- 0.75-1.0: Healthy efficiency, optimize and scale
- 0.50-0.75: Acceptable, focus on channel/spend optimization
- <0.50: Inefficient, audit spend allocation and productivity
Common Mistakes:
- Using total revenue instead of net new ARR
- Including expansion ARR (Magic Number measures new logo efficiency)
- Using current period spend instead of prior period (lag effect)
- Not separating sales spend from marketing spend for diagnostics
LTV:CAC Ratio
Formula: Customer Lifetime Value / Customer Acquisition Cost
Where:
- LTV = (ARPA x Gross Margin) / Churn Rate
- ARPA = Average Revenue Per Account (annualized)
- CAC = Total S&M Spend / New Customers Acquired
Target: >3:1 is healthy; >5:1 may indicate under-investment in growth
Common Mistakes:
- Using revenue instead of gross-margin-weighted revenue in LTV
- Not including all acquisition costs (SDR, marketing, sales engineering)
- Using blended churn instead of cohort-specific churn
- Comparing across segments without normalizing (enterprise LTV:CAC is naturally higher)
CAC Payback Period
Formula: CAC / (ARPA_monthly x Gross Margin)
What it measures: Months to recover the cost of acquiring a customer.
Interpretation:
- <12 months: Excellent capital efficiency
- 12-18 months: Healthy, especially for mid-market/enterprise
- 18-24 months: Acceptable for enterprise, concerning for SMB
-
24 months: Capital-intensive, needs optimization
Common Mistakes:
- Using revenue instead of gross-margin contribution
- Ignoring expansion revenue in payback calculation (conservative approach)
- Comparing SMB payback to enterprise payback without context
Burn Multiple
Formula: Net Burn / Net New ARR
What it measures: How much cash is consumed for each dollar of new ARR.
Interpretation (David Sacks framework):
- <1.0x: Amazing -- hyper-efficient growth
- 1.0-1.5x: Great -- strong capital efficiency
- 1.5-2.0x: Good -- healthy burn rate
- 2.0-3.0x: Suspect -- needs attention
-
3.0x: Bad -- unsustainable without course correction
Common Mistakes:
- Using gross burn instead of net burn
- Not annualizing ARR when using quarterly burn
- Ignoring the denominator quality (all new ARR is not equal)
Rule of 40
Formula: Revenue Growth Rate (%) + Free Cash Flow Margin (%)
What it measures: Balance between growth and profitability.
Interpretation:
-
60%: Elite SaaS company
- 40-60%: Strong performance
- 20-40%: Acceptable, optimize one dimension
- <20%: Needs significant improvement
Common Mistakes:
- Using EBITDA margin instead of FCF margin
- Comparing early-stage (growth-heavy) with late-stage (margin-heavy)
- Not considering the composition (80% growth + -40% margin vs 30% + 10%)
Net Dollar Retention (NDR)
Formula: (Beginning ARR + Expansion - Contraction - Churn) / Beginning ARR x 100
What it measures: Revenue retention and expansion from existing customers.
Interpretation:
-
130%: World-class expansion (Snowflake, Datadog)
- 120-130%: Excellent land-and-expand
- 110-120%: Strong retention with moderate expansion
- 100-110%: Stable base, limited expansion
- <100%: Net revenue contraction -- critical concern
Common Mistakes:
- Including new logos in the calculation
- Not normalizing for cohort age (newer cohorts expand differently)
- Confusing gross retention with net retention
- Using logo retention as a proxy for dollar retention
Metric Interdependencies
Understanding how metrics relate prevents conflicting optimizations:
-
Magic Number and LTV:CAC -- Both use S&M spend but measure different horizons. Magic Number is period-specific; LTV:CAC is lifetime.
-
Burn Multiple and Rule of 40 -- Both measure efficiency but from different angles. Burn Multiple is cash-focused; Rule of 40 balances growth with profitability.
-
Pipeline Coverage and Sales Velocity -- High coverage with low velocity means pipeline is stagnating. Both must be healthy.
-
NDR and LTV -- NDR directly impacts LTV. Improving NDR is the highest-leverage way to improve LTV:CAC.
-
Win Rate and Deal Size -- Often inversely correlated. Moving upmarket increases deal size but may reduce win rate.
Measurement Cadence
| Metric | Cadence | Owner |
|---|---|---|
| Pipeline Coverage | Weekly | Sales Leadership |
| Stage Conversion | Bi-weekly | Sales Ops |
| Sales Velocity | Monthly | RevOps |
| Forecast Accuracy (MAPE) | Monthly/Quarterly | RevOps |
| Magic Number | Quarterly | CRO/CFO |
| LTV:CAC | Quarterly | Finance/RevOps |
| CAC Payback | Quarterly | Finance |
| Burn Multiple | Quarterly | CFO |
| Rule of 40 | Quarterly/Annual | CEO/Board |
| NDR | Quarterly | CS/RevOps |
Pipeline Management Framework
Best practices for pipeline management including stage definitions, conversion benchmarks, velocity optimization, and inspection cadence.
Pipeline Stage Definitions
A well-defined pipeline requires clear, observable exit criteria at each stage. Subjective stages lead to inaccurate forecasting and unreliable conversion data.
Recommended Stage Model (B2B SaaS)
| Stage | Name | Exit Criteria | Probability | Typical Duration |
|---|---|---|---|---|
| S0 | Lead | Contact identified, initial interest signal | 5% | 0-7 days |
| S1 | Discovery | Pain identified, budget confirmed, stakeholder engaged | 10% | 7-14 days |
| S2 | Qualification | MEDDPICC criteria met, mutual action plan created | 20% | 14-21 days |
| S3 | Proposal | Solution presented, pricing delivered, champion confirmed | 40% | 7-14 days |
| S4 | Negotiation | Commercial terms discussed, legal engaged, verbal commitment | 60% | 7-21 days |
| S5 | Commit | Contract redlined, signature timeline confirmed | 80% | 3-7 days |
| S6 | Closed Won | Signed contract received | 100% | -- |
| SL | Closed Lost | Deal disposition recorded with loss reason | 0% | -- |
Stage Exit Criteria Best Practices
Discovery (S1) Exit Criteria:
- Pain point articulated by prospect (not assumed by rep)
- Budget range discussed (even if informal)
- Decision-making process understood
- Next meeting scheduled with clear agenda
Qualification (S2) Exit Criteria:
- MEDDPICC or BANT qualification framework completed
- Economic buyer identified (not just champion)
- Compelling event or timeline identified
- Mutual action plan (MAP) shared and agreed upon
- Technical requirements understood
Proposal (S3) Exit Criteria:
- Solution demo completed and well-received
- Pricing proposal delivered
- Champion validated proposal internally
- Competitive landscape understood
- No unresolved technical blockers
Negotiation (S4) Exit Criteria:
- Commercial terms discussed (not just pricing, but payment terms, SLA, etc.)
- Legal review initiated
- Security/procurement review started
- Verbal agreement on core terms
- Close date confirmed within 30 days
Commit (S5) Exit Criteria:
- Final contract sent for signature
- All legal redlines resolved
- Procurement approval obtained
- Signature expected within 7 business days
Conversion Benchmarks by Segment
SMB (ACV <$25K)
| Transition | Benchmark | Top Quartile |
|---|---|---|
| Lead to Discovery | 20-30% | 35%+ |
| Discovery to Qualification | 40-50% | 55%+ |
| Qualification to Proposal | 50-60% | 65%+ |
| Proposal to Negotiation | 55-65% | 70%+ |
| Negotiation to Close | 65-75% | 80%+ |
| Overall Win Rate | 20-30% | 35%+ |
| Avg Cycle Length | 14-30 days | <14 days |
Mid-Market (ACV $25K-$100K)
| Transition | Benchmark | Top Quartile |
|---|---|---|
| Lead to Discovery | 15-25% | 30%+ |
| Discovery to Qualification | 35-45% | 50%+ |
| Qualification to Proposal | 45-55% | 60%+ |
| Proposal to Negotiation | 50-60% | 65%+ |
| Negotiation to Close | 60-70% | 75%+ |
| Overall Win Rate | 15-25% | 30%+ |
| Avg Cycle Length | 30-60 days | <30 days |
Enterprise (ACV >$100K)
| Transition | Benchmark | Top Quartile |
|---|---|---|
| Lead to Discovery | 10-20% | 25%+ |
| Discovery to Qualification | 30-40% | 45%+ |
| Qualification to Proposal | 40-50% | 55%+ |
| Proposal to Negotiation | 45-55% | 60%+ |
| Negotiation to Close | 55-65% | 70%+ |
| Overall Win Rate | 10-20% | 25%+ |
| Avg Cycle Length | 60-120 days | <60 days |
Sales Velocity Optimization
Sales velocity = (# Opportunities x Avg Deal Size x Win Rate) / Avg Cycle Days
Each component is an optimization lever:
Lever 1: Increase Opportunity Volume
Strategies:
- Invest in inbound marketing (content, SEO, paid)
- Scale outbound SDR capacity
- Develop partner/channel sourcing
- Launch product-led growth (PLG) motion
- Implement customer referral programs
Measurement: Pipeline created ($) per week/month, by source
Lever 2: Increase Average Deal Size
Strategies:
- Multi-product bundling and packaging
- Usage-based pricing with growth triggers
- Land-and-expand with defined expansion playbooks
- Move upmarket with enterprise features
- Value-based pricing tied to customer outcomes
Measurement: ACV trend by quarter, by segment
Lever 3: Increase Win Rate
Strategies:
- Implement MEDDPICC qualification rigor
- Build competitive battle cards and train on them
- Create multi-threaded relationships (not single-threaded)
- Develop ROI/business case tools
- Invest in sales engineering and demo quality
- Win/loss analysis with structured debriefs
Measurement: Win rate by stage entry, by competitor, by rep
Lever 4: Decrease Sales Cycle Length
Strategies:
- Pre-qualify harder at S1/S2 to remove slow deals
- Mutual action plans with milestone dates
- Champion enablement (arm champions with internal selling materials)
- Parallel processing (legal/security review concurrent with evaluation)
- Standardized contracts and pre-approved terms
- Executive sponsor engagement for stuck deals
Measurement: Days in each stage, cycle length trend, stage-specific bottlenecks
Pipeline Inspection Cadence
Daily (Rep Level)
Focus: Deal-level activity and next steps
Questions:
- What is the next step for each deal in S3+?
- Are any deals missing next steps or scheduled meetings?
- Which deals have not been updated in >3 days?
Weekly (Manager/Team Level)
Focus: Pipeline health and forecast accuracy
Review Format (45-60 minutes):
-
Coverage Check (10 min)
- Current pipeline vs. quota -- is coverage >3x?
- Pipeline created this week vs. target
- Net pipeline change (created minus closed minus lost)
-
Deal Inspection (25 min)
- Walk top 10 deals by value in S3+
- MEDDPICC validation for each commit deal
- Identify deals at risk (aging, single-threaded, no next step)
-
Forecast Call (10 min)
- Commit, best case, and pipeline forecast
- Changes from last week's forecast (what moved and why)
- Gaps to plan and remediation
-
Action Items (5 min)
- Deals needing executive engagement
- Pipeline generation actions for next week
- Coaching priorities
Monthly (Leadership Level)
Focus: Pipeline trends, velocity, and efficiency
Review Areas:
- Month-over-month pipeline growth trend
- Conversion rate trends by stage
- Sales velocity trend (improving or declining?)
- Forecast accuracy (MAPE) for the month
- Rep performance distribution (quartile analysis)
- Pipeline source mix health
Quarterly (Executive/Board Level)
Focus: GTM efficiency and strategic pipeline
Review Areas:
- Pipeline coverage for next 2-3 quarters
- LTV:CAC and Magic Number trends
- Sales efficiency ratio trends
- Market segment performance comparison
- New market/product pipeline contribution
- Competitive win/loss trends
Pipeline Hygiene
Deal Hygiene Standards
-
Close date accuracy: Close dates must be based on buyer commitment, not rep hope. Any deal pushed more than twice should be flagged for re-qualification.
-
Stage accuracy: Deals must meet exit criteria to be in a stage. No deal should be in Proposal (S3) without a pricing deliverable sent.
-
Amount accuracy: Deal amounts must reflect the current proposal, not aspirational upsell. Variance between deal value and proposal should be <10%.
-
Contact coverage: Deals >$50K should have 3+ contacts associated. Enterprise deals should have economic buyer, champion, and technical evaluator.
-
Activity recency: No deal should go 7+ days without logged activity. Deals without recent activity signal stalling.
Pipeline Cleanup Triggers
Run cleanup when:
- Pipeline-to-quota ratio drops below 2.5x
- Forecast accuracy (MAPE) exceeds 20%
- More than 15% of pipeline is >90 days old
- Average deal age exceeds 1.5x normal cycle time
Cleanup Process
- Flag all deals with close date in the past
- Flag all deals with no activity in 14+ days
- Flag all deals pushed 3+ times
- Rep self-assessment: keep, push, or close for each flagged deal
- Manager review and disposition
- Update CRM and recalculate metrics
Pipeline Risk Indicators
Concentration Risk
Definition: Over-reliance on a small number of large deals.
Thresholds:
- Single deal >40% of pipeline = HIGH risk
- Single deal >25% of pipeline = MEDIUM risk
- Top 3 deals >70% of pipeline = HIGH risk
Mitigation: Diversify pipeline across segments, deal sizes, and sources. Increase deal count even if average deal size decreases.
Stage Imbalance Risk
Definition: Pipeline is concentrated in early or late stages with gaps in between.
Healthy Distribution:
- Discovery/Qualification: 50-60% of pipeline value
- Proposal: 20-25% of pipeline value
- Negotiation/Commit: 15-20% of pipeline value
Warning Signs:
-
70% in early stages = insufficient progression
-
50% in late stages = insufficient pipeline generation
- Empty stages = broken funnel mechanics
Temporal Risk
Definition: Pipeline is concentrated in a single quarter or lacks coverage for future quarters.
Standard: Maintain 3x coverage for current quarter and 1.5x for next quarter.
Source Risk
Definition: Pipeline is overly dependent on a single source (e.g., 80% outbound, 0% inbound).
Healthy Mix (varies by stage):
- Inbound/Marketing: 30-40%
- Outbound/SDR: 30-40%
- Partner/Channel: 10-20%
- Expansion/Customer: 10-20%
GTM Efficiency Benchmarks
SaaS benchmarks by funding stage, industry standards, and strategies for improving go-to-market efficiency.
Benchmarks by Funding Stage
Seed Stage ($0-$2M ARR)
| Metric | Red | Yellow | Green | Elite |
|---|---|---|---|---|
| Magic Number | <0.3 | 0.3-0.5 | >0.5 | >0.8 |
| LTV:CAC | <1.5:1 | 1.5-2.5:1 | >2.5:1 | >4:1 |
| CAC Payback | >30 mo | 24-30 mo | <24 mo | <15 mo |
| Burn Multiple | >5x | 3-5x | <3x | <2x |
| Rule of 40 | <0% | 0-20% | >20% | >40% |
| NDR | <90% | 90-100% | >100% | >110% |
Context: At seed stage, efficiency metrics are naturally less stable due to small sample sizes. Focus on directional improvement rather than absolute numbers. Burn multiple is the most critical metric -- investors want to see capital-efficient growth.
Series A ($2M-$10M ARR)
| Metric | Red | Yellow | Green | Elite |
|---|---|---|---|---|
| Magic Number | <0.4 | 0.4-0.6 | >0.6 | >0.9 |
| LTV:CAC | <2:1 | 2-3:1 | >3:1 | >5:1 |
| CAC Payback | >24 mo | 18-24 mo | <18 mo | <12 mo |
| Burn Multiple | >4x | 2.5-4x | <2.5x | <1.5x |
| Rule of 40 | <10% | 10-30% | >30% | >50% |
| NDR | <95% | 95-105% | >105% | >115% |
Context: Series A is where unit economics must prove out. LTV:CAC >3:1 validates product-market fit in the revenue model. Investors will scrutinize CAC payback to understand capital requirements.
Series B ($10M-$50M ARR)
| Metric | Red | Yellow | Green | Elite |
|---|---|---|---|---|
| Magic Number | <0.5 | 0.5-0.75 | >0.75 | >1.0 |
| LTV:CAC | <2.5:1 | 2.5-3.5:1 | >3.5:1 | >5:1 |
| CAC Payback | >22 mo | 15-22 mo | <15 mo | <10 mo |
| Burn Multiple | >3x | 2-3x | <2x | <1.5x |
| Rule of 40 | <20% | 20-35% | >35% | >50% |
| NDR | <100% | 100-110% | >110% | >120% |
Context: At Series B, the GTM machine should be scaling predictably. Magic Number >0.75 demonstrates that adding GTM spend produces proportional returns. NDR >110% proves land-and-expand motion works.
Series C+ ($50M-$200M ARR)
| Metric | Red | Yellow | Green | Elite |
|---|---|---|---|---|
| Magic Number | <0.5 | 0.5-0.75 | >0.75 | >1.0 |
| LTV:CAC | <3:1 | 3-4:1 | >4:1 | >6:1 |
| CAC Payback | >20 mo | 14-20 mo | <14 mo | <10 mo |
| Burn Multiple | >2.5x | 1.5-2.5x | <1.5x | <1x |
| Rule of 40 | <25% | 25-40% | >40% | >60% |
| NDR | <105% | 105-115% | >115% | >130% |
Context: Growth efficiency and path to profitability become paramount. The Rule of 40 is the primary board-level metric. Companies approaching IPO should target Rule of 40 >40% consistently.
Growth / Pre-IPO ($200M+ ARR)
| Metric | Red | Yellow | Green | Elite |
|---|---|---|---|---|
| Magic Number | <0.6 | 0.6-0.8 | >0.8 | >1.0 |
| LTV:CAC | <3:1 | 3-5:1 | >5:1 | >7:1 |
| CAC Payback | >18 mo | 12-18 mo | <12 mo | <8 mo |
| Burn Multiple | >2x | 1-2x | <1x | <0.5x |
| Rule of 40 | <30% | 30-45% | >45% | >65% |
| NDR | <110% | 110-120% | >120% | >140% |
Context: Pre-IPO and public companies are measured on absolute efficiency. FCF margin matters as much as growth rate. Best-in-class companies demonstrate both growth and profitability.
Industry Vertical Benchmarks
Horizontal SaaS (CRM, HR, Finance, Marketing)
| Metric | Median | Top Quartile |
|---|---|---|
| Magic Number | 0.65 | 0.90+ |
| LTV:CAC | 3.2:1 | 5.5:1+ |
| CAC Payback | 17 months | 11 months |
| Gross Margin | 72% | 80%+ |
| NDR | 108% | 120%+ |
| Win Rate | 22% | 32%+ |
Vertical SaaS (Healthcare, FinTech, PropTech)
| Metric | Median | Top Quartile |
|---|---|---|
| Magic Number | 0.55 | 0.80+ |
| LTV:CAC | 3.8:1 | 6.0:1+ |
| CAC Payback | 15 months | 10 months |
| Gross Margin | 68% | 76%+ |
| NDR | 112% | 125%+ |
| Win Rate | 25% | 38%+ |
Note: Vertical SaaS often has higher NDR (deeper embedding) and higher win rates (less competition) but lower gross margins (more services).
Infrastructure / DevTools
| Metric | Median | Top Quartile |
|---|---|---|
| Magic Number | 0.70 | 1.0+ |
| LTV:CAC | 4.0:1 | 7.0:1+ |
| CAC Payback | 14 months | 9 months |
| Gross Margin | 75% | 85%+ |
| NDR | 118% | 140%+ |
| Win Rate | 18% | 28%+ |
Note: Usage-based pricing in infrastructure drives exceptional NDR but more volatile revenue patterns.
Security / Compliance
| Metric | Median | Top Quartile |
|---|---|---|
| Magic Number | 0.60 | 0.85+ |
| LTV:CAC | 3.5:1 | 5.8:1+ |
| CAC Payback | 16 months | 11 months |
| Gross Margin | 74% | 82%+ |
| NDR | 115% | 130%+ |
| Win Rate | 20% | 30%+ |
Efficiency Improvement Strategies
Improving Magic Number
Current: <0.5 (Red) -- Target: >0.75 (Green)
-
Channel ROI analysis: Audit spend by channel (paid, outbound, events, content). Cut bottom 20% performing channels and reallocate.
-
Sales productivity: Measure revenue per rep. Identify bottom-quartile performers for coaching or role change. Top performers should be studied and their practices systematized.
-
Funnel efficiency: Improve MQL-to-SQL conversion through better lead scoring. Fewer, higher-quality leads reduce wasted sales capacity.
-
Ramp time reduction: Accelerate new rep ramp from average 6 months to 4 months through structured onboarding, shadowing, and certification.
-
Territory optimization: Ensure territories are balanced by opportunity (not just geography). Over-served territories waste capacity.
Improving LTV:CAC
Current: <3:1 (Yellow) -- Target: >5:1 (Green)
Increase LTV:
- Reduce churn through proactive health scoring and intervention
- Build expansion playbooks for cross-sell and upsell
- Increase pricing through value-based packaging
- Improve product stickiness with integrations and workflows
Decrease CAC:
- Invest in organic channels (content, SEO, community)
- Implement product-led growth (PLG) motion
- Optimize paid spend through better targeting and attribution
- Leverage customer referrals and case studies
Improving CAC Payback
Current: >18 months (Yellow) -- Target: <12 months (Green)
-
Increase ARPA: Package features to drive higher initial contract values. Annual prepay discounts accelerate cash collection.
-
Improve gross margin: Reduce COGS through automation, self-serve onboarding, and tech-touch customer success.
-
Reduce CAC: Same strategies as LTV:CAC improvement on the CAC side.
-
Contract structure: Annual or multi-year contracts with upfront payment reduce effective payback period.
Improving Burn Multiple
Current: >2x (Yellow) -- Target: <1.5x (Green)
-
Revenue efficiency: Focus on the highest ROI growth activities. Not all ARR is equal -- expansion ARR is typically much cheaper than new logo ARR.
-
Operational efficiency: Automate repeatable processes (billing, provisioning, basic support). Reduce headcount growth rate relative to revenue growth rate.
-
Spending discipline: Implement zero-based budgeting for non-essential spend. Every dollar of burn should connect to revenue generation.
-
Revenue acceleration: Sometimes the best way to improve burn multiple is not cutting costs but accelerating revenue. If you can accelerate revenue growth by 20% with 5% more spend, the burn multiple improves.
Improving NDR
Current: 100-110% (Yellow) -- Target: >120% (Green)
-
Expansion playbooks: Define trigger events for upsell (usage thresholds, team growth, feature requests). Arm CSMs with expansion talk tracks.
-
Usage-based pricing: Align pricing with customer value creation. As customers use more, they pay more -- naturally drives expansion.
-
Product-led expansion: Build in-product prompts for upgrades. Feature gating that shows value of next tier.
-
Reduce contraction: Identify reasons for downgrades. Often related to poor adoption of features customers are paying for.
-
Reduce churn: Implement early warning system (health scores). Intervene before renewal, not at renewal.
-
Multi-product strategy: Cross-sell additional products to existing customers. Second product adoption reduces churn by 30-50%.
Metric Relationships and Trade-offs
Growth vs. Efficiency
The fundamental tension in SaaS is between growth rate and capital efficiency:
High Growth + High Burn = Blitzscaling (risky but fast)
High Growth + Low Burn = Efficient Growth (ideal)
Low Growth + Low Burn = Cash Cow (sustainable but limited)
Low Growth + High Burn = Trouble (restructure immediately)
Rule of 40 captures this balance: growth rate + margin should exceed 40%.
CAC Payback vs. Growth Rate
Shorter CAC payback enables faster reinvestment in growth. A company with 12-month payback can reinvest recovered CAC into new customer acquisition sooner than one with 24-month payback, creating a compounding advantage.
NDR vs. New Logo Acquisition
High NDR reduces dependence on new logo acquisition for growth:
- NDR of 120% means 20% growth from existing base before any new customers
- NDR of 100% means all growth must come from new customers (expensive)
- NDR of 80% means the company is shrinking and must acquire even more new customers just to replace lost revenue
Strategic implication: Invest in NDR improvement before scaling new logo acquisition. Every dollar spent improving NDR has higher ROI than acquiring new customers.
Benchmark Data Sources
The benchmarks in this guide are compiled from:
- Bessemer Cloud Index -- Public cloud company financial data
- KeyBanc SaaS Survey -- Annual survey of private SaaS companies
- OpenView SaaS Benchmarks -- Product-led growth focused benchmarks
- Iconiq Growth Analytics -- Private company growth and efficiency data
- SaaStr Annual Surveys -- Community-sourced SaaS metrics
- Battery Ventures Software Report -- Enterprise software metrics
Note: Benchmarks shift over time. In capital-constrained environments (higher interest rates), efficiency metrics (burn multiple, Rule of 40) receive more weight. In growth-oriented environments (lower interest rates), growth rate and market share gain importance.
Quarterly Board Reporting Template
When presenting GTM efficiency to the board, organize metrics as follows:
- Growth: ARR, net new ARR, growth rate, NDR
- Efficiency: Magic Number, LTV:CAC, CAC Payback, Burn Multiple
- Balance: Rule of 40 score and composition
- Pipeline: Coverage ratio, velocity, forecast accuracy
- Trends: Quarter-over-quarter change for each metric with directional indicators
- Benchmarks: How the company compares to stage-appropriate benchmarks
- Actions: Top 3 initiatives to improve weakest metrics
Pipeline Review - [Date]
Review Period
- Review Type: Weekly / Monthly (circle one)
- Prepared By: [Name]
- Review Date: [YYYY-MM-DD]
- Period Covered: [Start Date] to [End Date]
Executive Summary
| Metric | Current | Last Period | Target | Status |
|---|---|---|---|---|
| Pipeline Coverage | _x | _x | 3-4x | |
| Total Pipeline Value | $_ | $_ | $_ | |
| Net Pipeline Change | $_ | $_ | >$0 | |
| Deals in Pipeline | _ | _ | _ | |
| Avg Deal Size | $_ | $_ | $_ | |
| Sales Velocity ($/mo) | $_ | $_ | $_ |
Overall Assessment: [1-2 sentence summary of pipeline health]
Coverage Analysis
By Quarter
| Quarter | Pipeline | Target | Coverage | Status |
|---|---|---|---|---|
| Current Quarter | $_ | $_ | _x | |
| Next Quarter | $_ | $_ | _x | |
| Q+2 | $_ | $_ | _x |
By Segment
| Segment | Pipeline | Target | Coverage | Notes |
|---|---|---|---|---|
| Enterprise | $_ | $_ | _x | |
| Mid-Market | $_ | $_ | _x | |
| SMB | $_ | $_ | _x |
Stage Distribution
| Stage | # Deals | Value | % of Pipeline | Conversion Rate |
|---|---|---|---|---|
| Discovery | _ | $_ | _% | _% |
| Qualification | _ | $_ | _% | _% |
| Proposal | _ | $_ | _% | _% |
| Negotiation | _ | $_ | _% | _% |
Funnel Health: [Healthy / Top-heavy / Bottom-heavy / Gaps identified]
Top Deals Review (S3+)
| Deal | Stage | Value | Age | Close Date | Risk | Next Step |
|---|---|---|---|---|---|---|
| $_ | _d | |||||
| $_ | _d | |||||
| $_ | _d | |||||
| $_ | _d | |||||
| $_ | _d |
Risk Assessment
Concentration Risk
- Largest deal as % of pipeline: _%
- Top 3 deals as % of pipeline: _%
- Risk Level: [Low / Medium / High]
- Mitigation: [Actions to diversify]
Aging Deals
| Deal | Stage | Age | Threshold | Days Over | Action Required |
|---|---|---|---|---|---|
| _d | _d | +_d | |||
| _d | _d | +_d |
Deals Pushed from Last Period
| Deal | Original Close | New Close | Times Pushed | Reason |
|---|---|---|---|---|
Pipeline Movement
Created This Period
| Deal | Source | Value | Stage | Expected Close |
|---|---|---|---|---|
| $_ | ||||
| $_ | ||||
| Total Created: $_ |
Advanced This Period
| Deal | From Stage | To Stage | Value |
|---|---|---|---|
| $_ | |||
| $_ |
Closed Won This Period
| Deal | Value | Cycle Days | Source |
|---|---|---|---|
| $_ | _d | ||
| $_ | _d | ||
| Total Closed Won: $_ |
Closed Lost This Period
| Deal | Value | Stage Lost | Loss Reason |
|---|---|---|---|
| $_ | |||
| $_ | |||
| Total Closed Lost: $_ |
Action Items
| # | Action | Owner | Due Date | Priority |
|---|---|---|---|---|
| 1 | ||||
| 2 | ||||
| 3 | ||||
| 4 | ||||
| 5 |
Notes
[Additional context, observations, or discussion points for the review meeting]