Revenue Operations

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. tags: [revops, sales, pipeline, forecasting]

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

1. Assess pipeline health using the Pipeline Health Scorecard.
2. Forecast revenue using the appropriate methodology (weighted, commit-based, or historical).
3. Measure quota attainment at individual and team levels.
4. Analyze funnel conversion stage by stage to identify bottlenecks.
5. Align cross-functional handoffs using the Sales-Marketing Alignment Framework.
6. Report using the Quarterly RevOps Report template.

RevOps Metrics Taxonomy

Master reference for revenue metrics — know these before building any dashboard:

Growth Metrics

Efficiency Metrics

Pipeline Metrics

Pipeline Health Scorecard

Run this assessment monthly or quarterly:

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.

Method 2: Commit Categories

Best for: Quarterly forecasting with sales team input.

Forecast = Commit + (Best Case x 0.7) + (Upside x 0.3)

Method 3: Historical Pattern

Best for: Mature businesses with 4+ quarters of data.

1. Calculate trailing 4-quarter conversion rate by stage
2. Apply stage conversion rates to current pipeline
3. Adjust for seasonality (Q4 uplift, Q1 budget flush, summer slowdown)
4. 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

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

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