Sales AI Skill

Revenue Operations Analytics

Build revenue operations analytics infrastructure that connects sales, marketing, and customer success data for unified revenue visibility and forecasting. Use when creating revenue dashboards, building forecasting models, analyzing pipeline health, measuri...

Revenue Operations (RevOps) Analytics

Build revenue operations analytics infrastructure — connecting sales, marketing, and customer success data into unified revenue visibility, forecasting, and optimization.

Workflow

Define revenue metrics framework: leading indicators, lagging indicators, efficiency metrics.
Build data infrastructure: unified data model, ETL pipelines, data warehouse.
Create revenue dashboards: executive, sales management, individual rep views.
Implement forecasting methodology: statistical, AI-assisted, consensus.
Analyze pipeline health: coverage, velocity, conversion rates, bottlenecks.
Measure revenue efficiency: CAC, LTV, payback period, magic number.
Optimize processes: identify and fix revenue leaks across the funnel.
Report to leadership: monthly revenue reviews, quarterly business reviews.

Revenue Metrics Framework

REVENUE OPERATIONS METRIC CATEGORIES
======================================

Category 1 — Pipeline Metrics:
  ════════════════════════════════════════════════════════════════════════
  Metric                        | Formula                           | Target
  ════════════════════════════════════════════════════════════════════════
  Pipeline value                | Sum of all opportunity values     | 3–5× quota
  Pipeline coverage             | Pipeline value / quota            | > 3.0x
  Weighted pipeline             | Sum of (value × stage probability)| 1.5–2× quota
  New pipeline this month       | New opportunities created         | 2× monthly quota
  Pipeline velocity             | (Ops × Avg Deal × Win Rate) / Sales Cycle | Increasing
  Pipeline stagnation           | % of deals with no activity > 30 days | < 20%
  ════════════════════════════════════════════════════════════════════════

Category 2 — Conversion Metrics:
  ════════════════════════════════════════════════════════════════════════
  Metric                        | Formula                           | Target
  ════════════════════════════════════════════════════════════════════════
  Lead-to-opportunity rate      | Opportunities / leads             | > 15%
  Opportunity-to-won rate       | Won deals / total opportunities   | > 25%
  Stage-to-stage conversion     | Deals advancing / deals in stage  | Varies by stage
  Average deal size             | Total revenue / number of deals   | Increasing
  Sales cycle length            | Avg days from opp to close        | < 90 days
  ════════════════════════════════════════════════════════════════════════

Category 3 — Performance Metrics:
  ════════════════════════════════════════════════════════════════════════
  Metric                        | Formula                           | Target
  ════════════════════════════════════════════════════════════════════════
  Quota attainment              | Actual revenue / quota            | > 100%
  Rep activity metrics          | Calls, emails, meetings / day     | Varies
  Forecast accuracy             | |Actual - Forecast| / Actual      | < 10%
  Win rate                      | Won deals / closed deals          | > 25%
  Average discount rate         | Discounted amount / list price    | < 15%
  ════════════════════════════════════════════════════════════════════════

Category 4 — Efficiency Metrics:
  ════════════════════════════════════════════════════════════════════════
  Metric                        | Formula                           | Target
  ════════════════════════════════════════════════════════════════════════
  CAC                           | Total sales + marketing cost / new customers | Decreasing
  LTV                           | Avg revenue × gross margin × lifetime | Increasing
  LTV:CAC ratio                 | LTV / CAC                         | > 3.0
  CAC payback period            | CAC / monthly gross profit per customer| < 12 months
  Magic number                  | (New ARR + Expansion ARR) / Prior marketing + sales spend | > 1.0
  Revenue per rep               | Total revenue / number of reps    | Increasing
  ════════════════════════════════════════════════════════════════════════

Revenue Dashboards

EXECUTIVE REVENUE DASHBOARD
=============================

Revenue Overview:
  ════════════════════════════════════════════════════════════════════════
  Metric                      | This Month | YTD       | Run Rate   | vs Target
  ════════════════════════════════════════════════════════════════════════
  New ARR                     | $450K      | $3.2M     | $5.4M      | +8%
  Expansion ARR               | $120K      | $850K     | $1.4M      | +12%
  Net Revenue Retention       | —          | —         | 118%       | +3%
  Churned ARR                 | $45K       | $280K     | $0.5M      | -5%
  Net New ARR                 | $525K      | $3.77M    | $6.3M      | +9%
  ════════════════════════════════════════════════════════════════════════

Pipeline Health:
  → Total pipeline: $12.5M (4.2× quarterly quota)
  → Weighted pipeline: $4.8M (1.6× quarterly quota)
  → Forecast: $3.1M (103% of quota)
  → Deals at risk: $650K (12 deals with low health score)
  → Stale deals: $420K (18 deals, no activity > 30 days)

Sales Cycle Trends:
  → Average sales cycle: 67 days (↓ 5 days from last quarter)
  → Median sales cycle: 52 days
  → Fastest close: 14 days (industry benchmark: 21 days)
  → Slowest stage: Negotiation (18 days average)

CONVERSION FUNNEL:
  ════════════════════════════════════════════════════════════════════════
  Stage              | Count    | Value     | Conversion | Velocity
  ════════════════════════════════════════════════════════════════════════
  Leads              | 4,500    | —         | —          | —
  MQLs               | 1,350    | —         | 30%        | 3 days
  SQLs               | 675      | —         | 50%        | 5 days
  Opportunities      | 338      | $8.5M     | 50%        | 7 days
  Proposals          | 135      | $4.2M     | 40%        | 10 days
  Negotiation        | 68       | $2.8M     | 50%        | 18 days
  Closed Won         | 45       | $1.8M     | 66%        | 3 days
  ════════════════════════════════════════════════════════════════════════

Forecasting Methodology

SALES FORECASTING APPROACH
============================

Method 1 — Pipeline-Based Forecast:
  → For each opportunity: Value × Probability of closing this quarter
  → Probability based on: Deal stage × deal health score × historical conversion
  → Total forecast = Sum of all weighted opportunities
  → Accuracy: ±10–15% (baseline method)

Method 2 — Statistical Forecast:
  → Historical close rates by deal stage and time in stage
  → Regression model: Past performance → future predictions
  → Factors: Seasonality, market conditions, team experience
  → Accuracy: ±8–12% (with 2+ years of data)

Method 3 — AI-Assisted Forecast:
  → Machine learning model trained on historical deal outcomes
  → Features: Deal attributes, engagement signals, firmographic data
  → Platform: Salesforce Einstein, Clari, Laguna, Gong
  → Accuracy: ±5–8% (with sufficient data)

Method 4 — Consensus Forecast:
  → Individual rep forecasts: Each rep provides their prediction
  → Manager adjustment: Manager adjusts based on deal knowledge
  → VP review: VP adjusts based on market context
  → Executive alignment: Final forecast approved by leadership
  → Accuracy: ±10–15% (but highest accountability)

FORECAST CONFIDENCE BANDS:
  ════════════════════════════════════════════════════════════════════════
  Scenario    | Revenue    | Probability | Assumptions
  ════════════════════════════════════════════════════════════════════════
  Best case   | $3.8M      | 20%         | All healthy deals close, expansion strong
  Commit      | $3.1M      | 70%         | Most likely outcome based on pipeline
  Best guess  | $3.4M      | —           | Weighted pipeline + manager adjustment
  Stretch     | $3.6M      | 30%         | Requires closing at-risk deals
  ════════════════════════════════════════════════════════════════════════

FORECAST ACCURACY TRACKING:
  → Monthly: |Actual - Commit| / Actual → Target < 10%
  → Quarterly: Trend analysis (improving or declining accuracy)
  → Rep-level: Individual forecast accuracy (coach poor forecasters)
  → Root cause: Why were forecasts wrong? (over-optimism, deal slippage?)

Integration Points

CRM (Salesforce, HubSpot): Opportunity data, pipeline, deal stages, forecasting
Data Warehouse (Snowflake, BigQuery): Unified data model, cross-system analytics
ETL Tools (Fivetran, Stitch, Airbyte): Data pipeline automation, sync scheduling
BI Platform (Tableau, Looker, Power BI): Dashboard creation, self-service analytics
Revenue Intelligence (Gong, Clari, Legrand): Deal intelligence, forecast accuracy, revenue insights
Marketing Automation (HubSpot, Marketo): Lead data, marketing attribution, campaign performance
Customer Success (Gainsight, Totango): Expansion revenue, churn data, health scores
Finance Systems (NetSuite, QuickBooks): Revenue recognition, billing data, financial reporting

Edge Cases

Forecast accuracy declining: ±15% → ±25% over 3 months
Root cause: Reps gaming forecast, market changes, new product uncertainty
Action: Review individual rep forecast accuracy; coach or adjust methodology
Process: Implement "commit" forecast (what reps are confident will close)
Technology: AI-assisted forecasting to reduce human bias
Accountability: Manager sign-off on forecast with justification

Pipeline coverage drops below 2x: Insufficient pipeline for quota
Diagnosis: Lead generation issue? Conversion problem? Seasonal pattern?
Action: Increase prospecting activity by 30%; activate dormant leads
Marketing: Accelerate campaigns; increase content and events
Management: Weekly pipeline review; focus on advancing existing deals
Timeline: Recovery takes 30–60 days (lead-to-opportunity lag)

Revenue leak in conversion funnel: High leads but low closed-won
Analysis: Identify weakest conversion stage
If MQL→SQL low: Lead quality issue → marketing alignment meeting
If SQL→Opp low: Qualification issue → BANT enforcement training
If Opp→Proposal low: Discovery/demo issue → sales enablement
If Proposal→Negotiation low: Value proposition issue → pricing review
If Negotiation→Won low: Closing/negotiation issue → deal review process

Revenue attribution complexity: Multiple touchpoints across marketing, sales, CS
Model selection: First-touch, last-touch, linear, or multi-touch attribution
Implementation: UTM tracking, CRM integration, marketing automation
Reporting: Show contribution of each touchpoint to revenue
Optimization: Allocate budget to highest-contributing channels
Acceptance: No model is perfect; use multiple models for perspective