Salesforce Metric
CRM
Forecast Accuracy = (1 - |Forecasted Revenue - Actual Revenue| / Actual Revenue) x 100
Forecast accuracy measures the percentage deviation between revenue forecasts derived from Salesforce pipeline data and actual closed revenue for a given period. It evaluates the reliability of opportunity stage probabilities, close date predictions, and deal value estimates across the sales organisation.
Full guide: definition, formula, and benchmarksForecast Accuracy
Forecast accuracy measures the percentage deviation between revenue forecasts derived from Salesforce pipeline data and actual closed revenue for a given period. It evaluates the reliability of opportunity stage probabilities, close date predictions, and deal value estimates across the sales organisation.
How to calculate forecast accuracy
Why forecast accuracy matters for Salesforce users
Salesforce is the system of record for pipeline and forecasting in most B2B organisations, making forecast accuracy a direct reflection of CRM data quality and sales process discipline. Inaccurate forecasts create a cascading chain of bad decisions: hiring plans built on over-forecasts lead to over-staffing, budget allocations based on inflated pipeline lead to overspend, and board commitments based on unreliable data erode executive credibility.
Tracking accuracy at the rep level reveals individual forecasting biases that are invisible in aggregate data. A sales team might forecast within 5% overall while individual reps vary by 30-40%, with some chronically over-forecasting and others under-forecasting. Identifying and correcting these individual biases through coaching and process changes is the fastest path to reliable organisational forecasting.
Understand and act on forecast accuracy with KPI Tree
Capture Salesforce pipeline snapshots at regular intervals and compare against actual outcomes in your warehouse. KPI Tree calculates accuracy at the deal, rep, team, and company level with historical trend analysis.
Add forecast accuracy to your metric tree as a strategic reliability metric. Assign ownership to sales managers for their team's accuracy, set alerts for accuracy falling below acceptable thresholds, and track trends period-over-period to determine whether pipeline hygiene and forecasting discipline are improving.
Get started with your Salesforce data
Connect your existing warehouse where Salesforce data already lands.
Our professional services team can build you turn-key AI foundations in a matter of weeks. Data warehouse on Snowflake/BigQuery, ELT with Fivetran, all modelled in dbt with a semantic layer.
Related Salesforce metrics
Pipeline Coverage Ratio
CRMMetric Definition
Pipeline Coverage Ratio = Total Open Pipeline Value / Revenue Target or Quota
Pipeline coverage ratio measures the total value of open pipeline in Salesforce divided by the revenue target or quota for a given period. It indicates whether sufficient pipeline exists to absorb normal loss and slippage rates while still achieving the revenue goal.
Win Rate
CRMMetric Definition
Opportunity Win Rate = (Closed-Won Opportunities / Total Closed Opportunities) x 100
Opportunity win rate measures the percentage of closed opportunities in Salesforce that result in a won outcome. It is the definitive measure of sales effectiveness, capturing the combined impact of qualification, competitive positioning, pricing, negotiation, and execution across the entire pipeline.
Deal Stage Progression
CRMMetric Definition
Deal stage progression measures the rate and pattern of opportunity movement through pipeline stages in Salesforce. It tracks forward progression, stage skipping, regression (deals moving backwards), and stagnation (deals stuck in a stage), providing a comprehensive view of how effectively the sales process advances deals toward close.
Quota Attainment
CRMMetric Definition
Quota Attainment = (Closed-Won Revenue / Assigned Quota) x 100
Quota attainment measures the percentage of assigned revenue quota that a rep, team, or territory has achieved through closed-won opportunities in Salesforce. It is the ultimate accountability metric for sales, directly connecting individual and team performance to the revenue commitments that drive business planning.
Explore forecast accuracy across integrations
All Salesforce metrics
Empower your team to understand and act on Salesforce data
Map what drives your metrics, measure progress at any grain, prove what works statistically, and deliver personalised action plans to every team member.