Improve forecast accuracy
You are a sales operations analyst who helps improve forecast accuracy and pipeline hygiene. Help me analyze my pipeline and create an accurate forecast. MY PIPELINE: [Provide list of opportunities with: - Company name - Deal size - Stage - Expected close date - Days in current stage - Last activity date - Key stakeholders known - Competition (if known)] CURRENT QUARTER: - Quarter ending: [Date] - Days remaining: [Number] - Quota: [If applicable] - Currently forecasted: [Current commit amount] Analyze my pipeline and forecast: 1. PIPELINE HEALTH AUDIT COVERAGE RATIO: - Total pipeline: [Calculate] - Quota: [Amount] - Coverage ratio: [Pipeline ÷ Quota] - Assessment: [Healthy = 3-4x, At risk = 2-3x, Concern = <2x] STAGE DISTRIBUTION: - Discovery: [Amount and % of pipeline] - Demo/Evaluation: [Amount and % of pipeline] - Proposal: [Amount and % of pipeline] - Negotiation: [Amount and % of pipeline] - Assessment: [Is distribution healthy?] 2. DEAL-BY-DEAL ANALYSIS For each deal, assess: [DEAL 1 NAME]: - Current forecast category: [Commit/Best Case/Pipeline] - Recommended category: [Based on analysis] - Risk factors: [List red flags] - Confidence level: [Percentage] - Actions needed: [What to do] [DEAL 2 NAME]: [Same analysis] [Continue for all deals...] 3. FORECAST CATEGORIZATION COMMIT (90%+ confidence): - Deals that qualify: [List] - Total: [Amount] - Why committed: [Evidence for each] BEST CASE (70-89% confidence): - Deals that qualify: [List] - Total: [Amount] - What could go wrong: [Risks] PIPELINE (50-69% confidence): - Deals that qualify: [List] - Total: [Amount] - What needs to happen: [Gaps] UPSIDE (<50% confidence): - Deals that qualify: [List] - Total: [Amount] - Why long shots: [Reality check] 4. DEAL RISK SCORING For each deal, calculate risk score: RELATIONSHIP RISK (1-5): - Single-threaded? [Add points] - Champion weak? [Add points] - No exec access? [Add points] PROCESS RISK (1-5): - Timeline slipping? [Add points] - Process unclear? [Add points] - Stuck in stage? [Add points] VALUE RISK (1-5): - Weak ROI case? [Add points] - No clear pain? [Add points] - Not a priority? [Add points] COMPETITIVE RISK (1-5): - Strong competition? [Add points] - Status quo comfortable? [Add points] TOTAL RISK SCORE: [Sum] - 0-5: Low risk - 6-10: Medium risk - 11-15: High risk - 16+: Critical risk 5. TIMING ANALYSIS DEALS AT RISK OF SLIPPING: - [List deals likely to push] - Why: [Indicators] - Impact on quarter: [Revenue at risk] DEALS THAT COULD PULL IN: - [List deals that might close early] - Why: [Opportunities] - Acceleration tactics: [What to do] 6. PIPELINE GAPS NEAR-TERM GAP (This quarter): - Amount needed to hit quota: [Calculate] - Current commit: [Amount] - Gap: [Shortage] - How to close: [Strategies] MID-TERM GAP (Next quarter): - Required pipeline build: [Amount] - Current early stage: [Amount] - Gap: [Shortage] - How to fill: [Activities needed] 7. FORECASTED SCENARIOS WORST CASE: - Only 'Commit' deals close: [Amount] - % to quota: [Percentage] BASE CASE: - 'Commit' + 50% of 'Best Case': [Amount] - % to quota: [Percentage] BEST CASE: - 'Commit' + 'Best Case' closes: [Amount] - % to quota: [Percentage] UPSIDE: - Everything closes: [Amount] - % to quota: [Percentage] MOST LIKELY: [Which scenario and why] 8. RECOMMENDED ACTIONS IMMEDIATE (This Week): 1. [Deal to focus on] - [Specific action] 2. [Deal to focus on] - [Specific action] 3. [Deal to focus on] - [Specific action] SHORT-TERM (This Month): - Pipeline build activities: [What and how much] - Deal acceleration: [Which deals and tactics] - Risk mitigation: [Which deals need help] DISQUALIFY: - Deals to remove: [Which and why] - Time to reinvest: [In better opportunities] 9. FORECAST ACCURACY IMPROVEMENT How to forecast better: - Use MEDDPICC: [Apply rigorously] - Track leading indicators: [What to measure] - Review weekly: [What to check] - Be honest: [Avoid sandbagging and happy ears] Questions to ask yourself: - [Question to validate commit deals] - [Question to validate best case deals] - [Question to identify at-risk deals] 10. MANAGER REVIEW PREP What to discuss with your manager: - Forecast: [Your submission] - Confidence level: [Honest assessment] - Risks: [What could go wrong] - Help needed: [Resources, escalations] - Pipeline plan: [How you'll build] Provide as a comprehensive forecast analysis with recommendations.
