--- name: sales-forecasting description: Generate accurate revenue forecasts using AI-powered predictive models. Use when creating quarterly/annual forecasts, calculating deal probabilities, analyzing pipeline coverage, identifying forecast gaps, running scenario simulations, calibrating with sales leadership, tracking forecast accuracy, or presenting to the C-suite. Triggers on phrases like "revenue forecast", "quarterly forecast", "forecast accuracy", "pipeline coverage ratio", "committed forecast", "best case scenario", "revenue gap", "forecast calibration", "deal probability". --- # Sales Forecasting & Revenue Planning Generate accurate, data-driven revenue forecasts using predictive analytics and pipeline intelligence. ## Forecasting Workflow ### Phase 1: Data Aggregation & Model Training Build the foundation for reliable forecasting: 1. **Ingest historical data**: - Won/lost deals with close dates, deal sizes, stages, industries, reps - Pipeline progression patterns (average time in each stage) - Seasonal trends (quarter-over-quarter patterns, month-end spikes) - Rep-level performance history and quota attainment - External factors: economic indicators, industry cycles, market conditions 2. **Train predictive ML model** on: - Deal characteristics that correlate with wins/losses - Stage-to-close probability by deal type, industry, rep - Deal velocity patterns and acceleration signals - Discount impact on close probability - Competitor presence effect on win rate and cycle length 3. **Calculate per-deal predictions**: - Probability of closing (0-100%, color-coded) - Expected close date (with confidence interval) - Likely deal value (adjusted for discount history, expansion potential) - Risk factors flagged per deal ### Phase 2: Forecast Generation Produce multi-tier forecast views: ``` Forecast Categories: ├── Committed (90%+ probability) │ └── Deals reps are confident will close this quarter ├── Best Case (70-89% probability) │ └── Strong deals with some remaining risk ├── Likely (50-69% probability) │ └── Moderate deals progressing as expected ├── Upside (30-49% probability) │ └── Possible deals if everything goes right └── Stretch (<30% probability) └── Long shots; excluded from revenue planning ``` **Forecast views by dimension**: - By rep, team, region, product line, vertical - Rolling 12-month view - Monthly, weekly, and deal-by-deal granularity - Weighted pipeline value vs. unweighted ### Phase 3: Forecast Calibration Ensure forecast credibility through regular reviews: 1. **Weekly forecast review**: - Compare prior week forecast vs. actuals - Adjust probabilities for deals that slipped or accelerated - Reps defend/adjust their individual forecasts - Manager pushes back on overly optimistic/pessimistic entries - Document rationale for major adjustments 2. **Monthly executive forecast**: - CFO reviews with sales leadership - Cross-reference with marketing pipeline generation - Identify gaps vs. quota and revenue targets - Determine if additional pipeline generation is needed - Update board/investor expectations as needed 3. **Quarter-end forecast**: - Final forecast locked 2 weeks before quarter close - Last-chance deals identified and accelerated - Revenue recognition rules applied - Comparison to prior forecast (track accuracy) ### Phase 4: Scenario Planning & Gap Analysis Model different outcomes: 1. **Best-case scenario**: All upside deals close on time at full value 2. **Base-case scenario**: Historical close rates applied to current pipeline 3. **Worst-case scenario**: Only committed deals close, average 15% discount 4. **What-if simulations**: - "If we lose deal X, what happens to forecast?" - "If rep Y leaves, what pipeline is at risk?" - "If product launch delayed, impact on Q3?" 5. **Gap identification**: - Revenue gap = Target - Committed + Best Case - Pipeline gap = Required pipeline - Current pipeline - Suggest specific actions to close gaps ## Templates & Frameworks ### Forecast Accuracy Tracking Template ```markdown ## Forecast Accuracy Report — Q4 2024 ### Overall Accuracy - Forecast: $12.5M | Actual: $11.8M | Accuracy: 94.4% - Variance: -$700K (-5.6%) ### Accuracy by Tier | Tier | Forecast | Actual | Accuracy | |------------|-------------|------------|----------| | Committed | $9.2M | $9.1M | 98.9% | | Best Case | $2.4M | $1.9M | 79.2% | | Upside | $0.9M | $0.8M | 88.9% | ### Accuracy by Rep - Top performer (most accurate): Mike T. (99.1%) - Most over-optimistic: Sarah K. (forecast $200K high) - Most conservative: James L. (forecast $150K low) ### Key Learnings - Deals with competitor involvement: 12% lower accuracy - Enterprise deals >$250K: average 5-day slip on close date - Q4 seasonality: 18% higher close rate in final 2 weeks ``` ### Pipeline Coverage Ratio Framework ``` Coverage Ratio = (Total Pipeline Value) / (Revenue Target) Minimum ratios by stage: - Discovery: 10x coverage - Qualification: 8x coverage - Demo/Proposal: 4x coverage - Negotiation: 2x coverage - Commit: 1.5x coverage Example: $10M quarterly target requires: - $100M in Discovery pipeline - $80M in Qualification pipeline - $40M in Demo/Proposal pipeline - $20M in Negotiation pipeline - $15M in Commit stage ``` ### Sales Velocity Calculator ``` Sales Velocity = (Number of Opportunities × Avg Deal Size × Win Rate %) / Sales Cycle Days Example: - 200 open opportunities - Average deal size: $50,000 - Win rate: 25% - Sales cycle: 60 days Velocity = (200 × $50,000 × 0.25) / 60 = $41,667 per day Monthly revenue run-rate: ~$1.04M ``` ### Forecast Calibration Meeting Agenda ```markdown ## Forecast Calibration — Weekly ### Pre-Read (distributed 24h before) - Current pipeline snapshot by rep - Deals moving in/out of quarter - Variance from last week's forecast ### Meeting Structure (60 min) 1. **Review last week accuracy** (10 min) - Which deals slipped, which closed early? - Update rep accuracy scores 2. **Rep-by-rep forecast defense** (30 min) - Each rep reviews committed + best case deals - Manager challenges assumptions - Adjust probabilities and close dates 3. **Gap analysis** (10 min) - Current forecast vs. quota - Pipeline needed to close gap - Acceleration opportunities 4. **Action items** (10 min) - Assign pipeline generation tasks - Set up executive sponsorship calls - Schedule competitive displacement plays ``` ## Integration Points ### CRM & Forecasting Tools - **Salesforce Forecasting**: Native forecast categories, collaborative forecasting, weighted pipeline - **Clari (formerly Gong.io)**: AI-driven forecast, deal coaching, revenue operations - **Insightly CPQ + Forecasting**: Integrated quote-to-cash forecasting - **Gong.io / Chorus**: Conversation intelligence feeding forecast confidence signals ### BI & Analytics - **Tableau / Looker**: Custom forecast dashboards, variance analysis, trend visualization - **Power BI**: Real-time forecast tracking with embedded analytics - **Excel / Google Sheets**: Lightweight forecasting models for smaller teams ### Revenue Operations - **Revenue.io**: Revenue planning, forecasting, and analytics platform - **Vendavo**: Price optimization and revenue strategy - **DealHub / Salesforce CPQ**: Deal-specific forecasting with pricing context ## Edge Cases ### Forecasting in Uncertain Markets - **Economic downturns**: Adjust historical close rates downward by 10-20%, extend sales cycle estimates by 20% - **New market entry**: Use conservative estimates from comparable market launches; weight heavily on early wins - **Post-M&A**: Separate forecast by acquired vs. acquired entities; track integration impact on pipeline - **Product launches**: Create separate forecast line for new product; use beta customer conversion rates ### Rep-Specific Adjustments - **New reps (ramp period)**: Apply 50% of target deal probability during first 90 days; 75% in second quarter - **Top performers**: Calibrate probabilities upward if historical accuracy >90% - **Chronic over-optimists**: Apply 10-15% downward adjustment to forecasted deal values - **Rep transition**: During handoff, reduce probability of transferred deals by 20% for first 30 days ### Complex Deal Structures - **Multi-year contracts**: Forecast annualized revenue but recognize actual contracted amount per period - **Usage-based pricing**: Use historical consumption data; apply conservative growth factor (5-10% per quarter) - **Marketplace/platform revenue**: Model both sides of market growth; account for network effects - **Government/enterprise RFPs**: Lower probability weights; longer cycle; budget cycle alignment ### Forecast Integrity - **Sandbagging detection**: Flag reps who consistently under-forecast then exceed; adjust culture - **Happy-ear syndrome**: Flag reps who consistently over-forecast; provide coaching and calibration tools - **Stage inflation**: Monitor deals stuck in late stages without real progress; auto-downgrade - **Pipeline padding**: Detect duplicate or inflated deal entries; enforce data quality rules ## Output Dashboards ### Executive Forecast Dashboard - Current quarter forecast: Committed / Best Case / Upside with actuals - Forecast accuracy trend (last 8 quarters) - Pipeline coverage ratio by stage with target thresholds - Top 10 deals by value with status indicators - Revenue gap visualization with bridge chart - Rep attainment vs. quota (rank and file + management) - Monthly book-to-bill ratio - Sales velocity trend with bottleneck alerts - Win/loss rate by product, vertical, and competitor ### Rep-Level Forecast View - Personal quota progress (monthly and quarterly) - Individual deal list with AI-predicted probability and close date - Deals at risk (declining engagement, no activity) - Suggested actions to accelerate deals - Personal forecast accuracy score and trend ### Manager Forecast View - Team forecast summary with drill-down to individual reps - Rep-by-rep pipeline coverage and forecast accuracy - Escalation queue: deals requiring manager intervention - Coaching opportunities: deals where rep skills need support - Cross-rep deal collaboration suggestions ## Trigger Phrases - "run a forecast" - "revenue forecast for Q3" - "what's our pipeline coverage" - "forecast accuracy report" - "committed deals this quarter" - "best case scenario analysis" - "calibrate the forecast" - "revenue gap analysis" - "sales velocity report" - "deal probability adjustment" - "weekly forecast review" - "forecast vs actuals" - "pipeline health check" - "revenue planning scenario"