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 what makes planning possible; a forecast that misses every month is worse than no forecast at all. 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.
Runs first day of each month at 8:00 am using Salesforce, run by your Sales Dev Rep.
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.
Connects to
Related automations
- Sales Activity Auto-Logger — Automatically log all sales emails (sent, received, replies) into a CRM activity timeline
- Lead Scoring & Qualification — Automatically score leads based on company size, engagement, and fit, surfacing hot prospects
- Deal Pipeline Auto-Advance — Automatically move deals through pipeline stages based on actions (proposal sent, demo completed, etc.)
- Contact Sync from Email & Forms — Automatically create HubSpot contacts from email senders and form submissions, no data entry
- Lead Auto-Assignment by Territory — Automatically assign new leads to sales reps based on territory, account fit, and workload balance
- Email Activity Auto-Sync to Salesforce — Automatically log all sales emails (sent, received, attachments) to Salesforce activities without manual work
- Opportunity Auto-Advance by Milestone — Automatically advance opportunities when milestones occur (proposal sent, demo completed, etc.)
- Inactive Account Re-engagement — Alert you when key accounts go silent (no activity for 30+ days), triggering account review and outreach