name: revenue-operations
description: Analyze sales pipeline health, forecast revenue, measure quota attainment, and optimize funnel conversion. Use when building RevOps dashboards, diagnosing pipeline gaps, forecasting quarterly revenue, or aligning sales-marketing-CS handoffs.
Revenue Operations
End-to-end RevOps framework for pipeline analytics, revenue forecasting, quota management, and cross-functional alignment between Sales, Marketing, and Customer Success.
Use this skill when
- Building or reviewing a RevOps dashboard
- Diagnosing pipeline coverage gaps or stage bottlenecks
- Forecasting quarterly or annual revenue
- Analyzing quota attainment at individual, team, or org level
- Designing sales-marketing-CS handoff processes
- Calculating key revenue metrics (ARR, NRR, Magic Number, LTV:CAC)
Do not use this skill when
- Designing pricing tiers or packaging (use
pricing-strategy)
- Analyzing early-stage startup metrics with no pipeline (use
startup-metrics-framework)
- Running individual A/B tests on sales emails (use
ab-test-analysis)
- Building the actual dashboard infrastructure (use data engineering skills)
Instructions
- Assess pipeline health using the Pipeline Health Scorecard.
- Forecast revenue using the appropriate methodology (weighted, commit-based, or historical).
- Measure quota attainment at individual and team levels.
- Analyze funnel conversion stage by stage to identify bottlenecks.
- Align cross-functional handoffs using the Sales-Marketing Alignment Framework.
- Report using the Quarterly RevOps Report template.
RevOps Metrics Taxonomy
Master reference for revenue metrics — know these before building any dashboard:
Growth Metrics
| Metric |
Formula |
Benchmark (SaaS) |
| ARR |
MRR x 12 |
Growth target: 2-3x <$10M, 1.5-2x >$10M |
| MRR |
Sum of all monthly recurring revenue |
Track net new, expansion, contraction, churn |
| Net Revenue Retention (NRR) |
(Starting MRR + Expansion - Contraction - Churn) / Starting MRR |
>120% = elite, >100% = healthy |
| Gross Revenue Retention (GRR) |
(Starting MRR - Contraction - Churn) / Starting MRR |
>90% = healthy, <85% = problem |
Efficiency Metrics
| Metric |
Formula |
Benchmark |
| Magic Number |
Net New ARR (QoQ) / S&M Spend (prev Q) |
>0.75 = efficient, invest more |
| CAC Payback |
CAC / (ARR per customer x Gross Margin) |
<18 months = healthy |
| LTV:CAC |
Customer LTV / CAC |
>3:1 = healthy, >5:1 = underinvesting |
| Sales Efficiency |
Net New ARR / Total Sales Cost |
>1.0 = self-funding |
Pipeline Metrics
| Metric |
Formula |
Benchmark |
| Pipeline Coverage |
Total Pipeline Value / Revenue Target |
3-4x = healthy |
| Win Rate |
Closed Won / (Closed Won + Closed Lost) |
20-30% = typical B2B SaaS |
| Average Deal Size |
Total Revenue / Number of Deals |
Track trend, not absolute |
| Sales Cycle Length |
Avg days from opportunity created to closed won |
Varies by segment (SMB: 30d, Mid: 60d, Enterprise: 90-180d) |
Pipeline Health Scorecard
Run this assessment monthly or quarterly:
| Dimension |
Metric |
Target |
Actual |
Status |
| Coverage |
Pipeline / Target |
3-4x |
|
|
| Quality |
Win rate (trailing 2Q) |
>25% |
|
|
| Velocity |
Avg cycle length vs. benchmark |
Within 20% |
|
|
| Balance |
Stage distribution (no stage >40%) |
Even spread |
|
|
| Freshness |
% pipeline <90 days old |
>60% |
|
|
| Source Mix |
No single source >50% |
Diversified |
|
|
Interpretation:
- 5-6 green: Pipeline is healthy — focus on execution
- 3-4 green: Pipeline has gaps — targeted intervention needed
- 0-2 green: Pipeline is at risk — immediate action required
Revenue Forecasting Methods
Method 1: Weighted Pipeline
Best for: Mid-market and enterprise with defined sales stages.
| Stage |
Probability |
Pipeline Value |
Weighted Value |
| Discovery |
10% |
|
|
| Qualification |
20% |
|
|
| Demo/Evaluation |
40% |
|
|
| Proposal |
60% |
|
|
| Negotiation |
80% |
|
|
| Verbal Commit |
90% |
|
|
| Total Weighted |
|
|
$ |
Method 2: Commit Categories
Best for: Quarterly forecasting with sales team input.
| Category |
Definition |
Example |
| Commit |
Rep stakes their quota on it closing this quarter |
Signed MSA, verbal PO |
| Best Case |
High confidence but with known risk |
Champion engaged, budget approved, timeline unclear |
| Upside |
Could close but significant unknowns |
Early stage, multi-threaded but no champion |
Forecast = Commit + (Best Case x 0.7) + (Upside x 0.3)
Method 3: Historical Pattern
Best for: Mature businesses with 4+ quarters of data.
- Calculate trailing 4-quarter conversion rate by stage
- Apply stage conversion rates to current pipeline
- Adjust for seasonality (Q4 uplift, Q1 budget flush, summer slowdown)
- Layer in known macro factors (market expansion, new product launch)
Funnel Conversion Analysis
Stage-by-stage diagnostic to find bottlenecks:
## Funnel Conversion Report — [Quarter]
| Stage Transition | Volume | Conversion Rate | Benchmark | Delta | Action |
|-----------------|--------|-----------------|-----------|-------|--------|
| Lead → MQL | | % | 30-40% | | |
| MQL → SQL | | % | 40-60% | | |
| SQL → Opportunity | | % | 50-70% | | |
| Opportunity → Demo | | % | 60-80% | | |
| Demo → Proposal | | % | 40-60% | | |
| Proposal → Closed Won | | % | 20-40% | | |
| **End-to-end** | | **%** | **2-5%** | | |
### Bottleneck Analysis
- **Biggest drop-off:** [Stage] at [X]% vs. [Y]% benchmark
- **Root cause hypothesis:** [...]
- **Recommended intervention:** [...]
Quota Attainment Dashboard
| Rep / Team |
Quota |
Closed |
Attainment |
Pipeline |
Coverage |
Forecast |
|
$ |
$ |
% |
$ |
Xx |
$ |
| Team Total |
$ |
$ |
% |
$ |
Xx |
$ |
Ramp-Adjusted Quotas:
- Month 1-3: 25% quota (ramp)
- Month 4-6: 50% quota
- Month 7+: 100% quota
- New hires should be excluded from full attainment calculations for first 6 months
Sales-Marketing Alignment Framework
| Handoff Point |
SLA |
Metric |
Owner |
| Marketing → SDR (MQL) |
Respond within 5 min |
Lead response time |
Marketing Ops |
| SDR → AE (SQL) |
Complete BANT qualification |
MQL-to-SQL conversion |
SDR Manager |
| AE → CS (Closed Won) |
Handoff call within 5 days |
Time-to-onboard |
AE + CS |
| CS → AE (Expansion) |
Flag expansion signal |
Expansion pipeline |
CS Manager |
Output Template: Quarterly RevOps Report
# RevOps Report — Q[X] [Year]
## Executive Summary
- Revenue: $[X] vs. $[Y] target ([Z]% attainment)
- Pipeline coverage: [X]x (target: 3-4x)
- Key risk: [summary]
## Revenue Performance
[Actual vs. forecast vs. target waterfall]
## Pipeline Health
[Scorecard results]
## Funnel Conversion
[Stage-by-stage analysis with bottleneck callout]
## Forecast — Next Quarter
[Commit + Best Case + Upside breakdown]
## Actions Required
1. [Action] — Owner — Deadline
2. [Action] — Owner — Deadline
Common Mistakes
- Forecasting on pipeline value without weighting — $1M in Discovery is not the same as $1M in Negotiation
- Ignoring deal aging — opportunities older than 2x average cycle are likely dead; clean the pipeline
- Conflating bookings with revenue — bookings = contract signed; revenue = recognized per ASC 606
- Single-source pipeline dependency — if >50% of pipeline comes from one channel, diversify immediately
- Not segmenting metrics — SMB, mid-market, and enterprise have fundamentally different benchmarks
- Treating coverage as a static number — 4x coverage means nothing if 60% is stale deals
Additional Resources
- Related skills:
startup-metrics-framework (early-stage metrics), pricing-strategy (pricing impact on pipeline)
- SaaStr benchmarks for SaaS RevOps metrics
- Winning by Design — revenue architecture frameworks
1---2name: revenue-operations-53description: <!-- AUTO-GENERATED by export-skills.py — DO NOT EDIT -->4---5<!-- AUTO-GENERATED by export-skills.py — DO NOT EDIT -->6---7name: revenue-operations8description: Analyze sales pipeline health, forecast revenue, measure quota attainment, and optimize funnel conversion. Use when building RevOps dashboards, diagnosing pipeline gaps, forecasting quarterly revenue, or aligning sales-marketing-CS handoffs.9---1011# Revenue Operations1213End-to-end RevOps framework for pipeline analytics, revenue forecasting, quota management, and cross-functional alignment between Sales, Marketing, and Customer Success.1415## Use this skill when1617- Building or reviewing a RevOps dashboard18- Diagnosing pipeline coverage gaps or stage bottlenecks19- Forecasting quarterly or annual revenue20- Analyzing quota attainment at individual, team, or org level21- Designing sales-marketing-CS handoff processes22- Calculating key revenue metrics (ARR, NRR, Magic Number, LTV:CAC)2324## Do not use this skill when2526- Designing pricing tiers or packaging (use `pricing-strategy`)27- Analyzing early-stage startup metrics with no pipeline (use `startup-metrics-framework`)28- Running individual A/B tests on sales emails (use `ab-test-analysis`)29- Building the actual dashboard infrastructure (use data engineering skills)3031## Instructions32331. **Assess pipeline health** using the Pipeline Health Scorecard.342. **Forecast revenue** using the appropriate methodology (weighted, commit-based, or historical).353. **Measure quota attainment** at individual and team levels.364. **Analyze funnel conversion** stage by stage to identify bottlenecks.375. **Align cross-functional handoffs** using the Sales-Marketing Alignment Framework.386. **Report using** the Quarterly RevOps Report template.3940---4142## RevOps Metrics Taxonomy4344Master reference for revenue metrics — know these before building any dashboard:4546### Growth Metrics4748| Metric | Formula | Benchmark (SaaS) |49|--------|---------|-------------------|50| **ARR** | MRR x 12 | Growth target: 2-3x <$10M, 1.5-2x >$10M |51| **MRR** | Sum of all monthly recurring revenue | Track net new, expansion, contraction, churn |52| **Net Revenue Retention (NRR)** | (Starting MRR + Expansion - Contraction - Churn) / Starting MRR | >120% = elite, >100% = healthy |53| **Gross Revenue Retention (GRR)** | (Starting MRR - Contraction - Churn) / Starting MRR | >90% = healthy, <85% = problem |5455### Efficiency Metrics5657| Metric | Formula | Benchmark |58|--------|---------|-----------|59| **Magic Number** | Net New ARR (QoQ) / S&M Spend (prev Q) | >0.75 = efficient, invest more |60| **CAC Payback** | CAC / (ARR per customer x Gross Margin) | <18 months = healthy |61| **LTV:CAC** | Customer LTV / CAC | >3:1 = healthy, >5:1 = underinvesting |62| **Sales Efficiency** | Net New ARR / Total Sales Cost | >1.0 = self-funding |6364### Pipeline Metrics6566| Metric | Formula | Benchmark |67|--------|---------|-----------|68| **Pipeline Coverage** | Total Pipeline Value / Revenue Target | 3-4x = healthy |69| **Win Rate** | Closed Won / (Closed Won + Closed Lost) | 20-30% = typical B2B SaaS |70| **Average Deal Size** | Total Revenue / Number of Deals | Track trend, not absolute |71| **Sales Cycle Length** | Avg days from opportunity created to closed won | Varies by segment (SMB: 30d, Mid: 60d, Enterprise: 90-180d) |7273---7475## Pipeline Health Scorecard7677Run this assessment monthly or quarterly:7879| Dimension | Metric | Target | Actual | Status |80|-----------|--------|--------|--------|--------|81| **Coverage** | Pipeline / Target | 3-4x | | |82| **Quality** | Win rate (trailing 2Q) | >25% | | |83| **Velocity** | Avg cycle length vs. benchmark | Within 20% | | |84| **Balance** | Stage distribution (no stage >40%) | Even spread | | |85| **Freshness** | % pipeline <90 days old | >60% | | |86| **Source Mix** | No single source >50% | Diversified | | |8788**Interpretation:**89- 5-6 green: Pipeline is healthy — focus on execution90- 3-4 green: Pipeline has gaps — targeted intervention needed91- 0-2 green: Pipeline is at risk — immediate action required9293---9495## Revenue Forecasting Methods9697### Method 1: Weighted Pipeline9899Best for: Mid-market and enterprise with defined sales stages.100101| Stage | Probability | Pipeline Value | Weighted Value |102|-------|-------------|---------------|----------------|103| Discovery | 10% | | |104| Qualification | 20% | | |105| Demo/Evaluation | 40% | | |106| Proposal | 60% | | |107| Negotiation | 80% | | |108| Verbal Commit | 90% | | |109| **Total Weighted** | | | **$** |110111### Method 2: Commit Categories112113Best for: Quarterly forecasting with sales team input.114115| Category | Definition | Example |116|----------|-----------|---------|117| **Commit** | Rep stakes their quota on it closing this quarter | Signed MSA, verbal PO |118| **Best Case** | High confidence but with known risk | Champion engaged, budget approved, timeline unclear |119| **Upside** | Could close but significant unknowns | Early stage, multi-threaded but no champion |120121**Forecast = Commit + (Best Case x 0.7) + (Upside x 0.3)**122123### Method 3: Historical Pattern124125Best for: Mature businesses with 4+ quarters of data.1261271. Calculate trailing 4-quarter conversion rate by stage1282. Apply stage conversion rates to current pipeline1293. Adjust for seasonality (Q4 uplift, Q1 budget flush, summer slowdown)1304. Layer in known macro factors (market expansion, new product launch)131132---133134## Funnel Conversion Analysis135136Stage-by-stage diagnostic to find bottlenecks:137138```markdown139## Funnel Conversion Report — [Quarter]140141| Stage Transition | Volume | Conversion Rate | Benchmark | Delta | Action |142|-----------------|--------|-----------------|-----------|-------|--------|143| Lead → MQL | | % | 30-40% | | |144| MQL → SQL | | % | 40-60% | | |145| SQL → Opportunity | | % | 50-70% | | |146| Opportunity → Demo | | % | 60-80% | | |147| Demo → Proposal | | % | 40-60% | | |148| Proposal → Closed Won | | % | 20-40% | | |149| **End-to-end** | | **%** | **2-5%** | | |150151### Bottleneck Analysis152- **Biggest drop-off:** [Stage] at [X]% vs. [Y]% benchmark153- **Root cause hypothesis:** [...]154- **Recommended intervention:** [...]155```156157---158159## Quota Attainment Dashboard160161| Rep / Team | Quota | Closed | Attainment | Pipeline | Coverage | Forecast |162|-----------|-------|--------|------------|----------|----------|----------|163| | $ | $ | % | $ | Xx | $ |164| **Team Total** | **$** | **$** | **%** | **$** | **Xx** | **$** |165166**Ramp-Adjusted Quotas:**167- Month 1-3: 25% quota (ramp)168- Month 4-6: 50% quota169- Month 7+: 100% quota170- New hires should be excluded from full attainment calculations for first 6 months171172---173174## Sales-Marketing Alignment Framework175176| Handoff Point | SLA | Metric | Owner |177|--------------|-----|--------|-------|178| Marketing → SDR (MQL) | Respond within 5 min | Lead response time | Marketing Ops |179| SDR → AE (SQL) | Complete BANT qualification | MQL-to-SQL conversion | SDR Manager |180| AE → CS (Closed Won) | Handoff call within 5 days | Time-to-onboard | AE + CS |181| CS → AE (Expansion) | Flag expansion signal | Expansion pipeline | CS Manager |182183---184185## Output Template: Quarterly RevOps Report186187```markdown188# RevOps Report — Q[X] [Year]189190## Executive Summary191- Revenue: $[X] vs. $[Y] target ([Z]% attainment)192- Pipeline coverage: [X]x (target: 3-4x)193- Key risk: [summary]194195## Revenue Performance196[Actual vs. forecast vs. target waterfall]197198## Pipeline Health199[Scorecard results]200201## Funnel Conversion202[Stage-by-stage analysis with bottleneck callout]203204## Forecast — Next Quarter205[Commit + Best Case + Upside breakdown]206207## Actions Required2081. [Action] — Owner — Deadline2092. [Action] — Owner — Deadline210```211212---213214## Common Mistakes215216- **Forecasting on pipeline value without weighting** — $1M in Discovery is not the same as $1M in Negotiation217- **Ignoring deal aging** — opportunities older than 2x average cycle are likely dead; clean the pipeline218- **Conflating bookings with revenue** — bookings = contract signed; revenue = recognized per ASC 606219- **Single-source pipeline dependency** — if >50% of pipeline comes from one channel, diversify immediately220- **Not segmenting metrics** — SMB, mid-market, and enterprise have fundamentally different benchmarks221- **Treating coverage as a static number** — 4x coverage means nothing if 60% is stale deals222223---224225## Additional Resources226227- Related skills: `startup-metrics-framework` (early-stage metrics), `pricing-strategy` (pricing impact on pipeline)228- SaaStr benchmarks for SaaS RevOps metrics229- Winning by Design — revenue architecture frameworks230231<!-- Source: .faos/custom/skills/business/revenue-operations/SKILL.md -->