Sales Forecast Accuracy Tracker
Track forecast vs. actual monthly and identify which reps consistently miss targets for coaching
Salesforce integration that compares monthly forecasted revenue (opp.forecast_amount) to actual closed revenue, flags misses, and suggests coaching actions.
Nora pulls forecasted revenue per rep each month (sum of all their opportunities' forecast amounts and probabilities) and compares to actual closed revenue. Example: Sarah forecasted $500k for Jan, actually closed $420k (84% accuracy, 16% miss). John forecasted $300k, closed $295k (98% accuracy). Over 12 months, you see patterns: Sarah consistently misses high; John is accurate but conservative. Nora flags: 'Sarah's forecast miss is 12% YTD average. Suggest reviewing how she estimates probabilities. John's forecast is accurate but 15% below potential—could set stretch goals.' Forecast accuracy is critical for business planning—if you miss forecasts by 20% each month, planning becomes unreliable. Nora identifies root causes: Is Sarah overconfident in pipeline? Does she have visibility issues (losing deals late-stage)? Is John being conservative to avoid miss targets? The automation helps sales leaders coach reps on forecasting discipline and pipeline management. You can also use forecast accuracy to inform commission structures—reward accurate forecasting, not just closes.
How it works
- Pull forecasted revenue per rep (prior month)
- Pull actual closed revenue per rep (prior month)
- Calculate forecast accuracy percentage
- Identify forecast misses and overachievements
- Analyze rep-specific trends (patterns over 12 months)
- Suggest coaching actions based on miss analysis
- Send forecast accuracy report to sales leadership
Frequently asked questions
What does "Sales Forecast Accuracy Tracker" do?
Salesforce integration that compares monthly forecasted revenue (opp.forecast_amount) to actual closed revenue, flags misses, and suggests coaching actions.
How long does setup take?
Under 5 minutes. Connect your tools and Nora handles the rest.
Which tools does this use?
Uses Salesforce, run by your Sales Dev Rep.
How much time does this save?
Saves approximately 4 hours/month, running first day of each month at 8:00 am.