KPI Tree

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 benchmarks

Forecast 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

Forecast Accuracy = (1 - |Forecasted Revenue - Actual Revenue| / Actual Revenue) x 100

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

Data Warehouse
SnowflakeBigQueryDatabricksRedshift

Connect your existing warehouse where Salesforce data already lands.

Professional Services
FivetranSnowflakedbt

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

CRM

Metric 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.

View metric

Win Rate

CRM

Metric 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.

View metric

Deal Stage Progression

CRM

Metric 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.

View metric

Quota Attainment

CRM

Metric 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.

View metric

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.

Experience That Matters

Built by a team that's been in your shoes

Our team brings deep experience from leading Data, Growth and People teams at some of the fastest growing scaleups in Europe through to IPO and beyond. We've faced the same challenges you're facing now.

Checkout.com
Planet
UK Government
Travelex
BT
Sainsbury's
Goldman Sachs
Dojo
Redpin
Farfetch
Just Eat for Business