The playbook
Sales Forecasting: Metrics and Measurement
Measure sales forecasting by defining forecast error by period precisely enough that two people can reproduce the result from the same records. Keep the reporting unit, date basis, and scope visible. Without those definitions, a change in the report may reflect a changed calculation rather than a changed customer outcome.
Put the task in context
For each included deal, review the expected close period and the evidence behind its stage. Compare forecast assumptions with historical outcomes, while allowing for changes in deal mix. Keep committed revenue separate from weighted estimates and upside scenarios.
Create a metric definition
| Definition field | What it must explain |
|---|---|
| Measure | forecast error by period |
| Unit | What one customer or opportunity record or completed outcome represents |
| Included records | The scope identified by opportunity and value |
| Date basis | The event date or period used to include a record |
| Exclusions | Tests, duplicates, or other records outside the agreed definition |
| Source owner | sales manager |
Separate delivery checks from outcome measures
A delivery check asks whether the team completed a specific task, such as define the forecast period and included opportunities. An outcome measure asks what happened for the user or business afterward. Keep both visible. Completing the task is useful evidence of execution, but it does not by itself prove that the broader outcome improved.
Worked arithmetic example
Suppose an illustrative review includes 80 eligible records, and 60 satisfy the explicitly defined completion condition. The completion share is 60 ÷ 80 × 100 = 75%. This is hypothetical arithmetic, not an industry benchmark or a predicted improvement. It describes only the population and condition you defined.
For sales forecasting, explain the condition before applying that calculation. If the question is whether the team can compare forecasts with actual closed outcomes, a record counts only when the evidence demonstrates that condition. Do not replace missing outcomes with successful ones just to complete a report.
Compare like with like
Keep the scope, date basis, and exclusions consistent between observations. If value changes meaning between periods, note the change and rebuild a comparable view where possible. A rate can also move because the composition of the underlying group changed, even when individual performance did not.
Investigate an unexpected result
- Check whether the underlying opportunity records are complete.
- Look for this known failure: treating every open deal's full value as expected revenue.
- Verify that the process still includes: review stage evidence close dates and historical conversion.
- Reconcile a sample with the original record before changing the operating plan.
Use the report to choose an action
If the evidence supports a correction, use realistic assumptions and disclose uncertainty. Record when the change occurred and what should be checked next. Keep uncertainty visible when the sample is small or the observation period is incomplete. The purpose of measurement is a better decision about forecast error by period, not a favorable-looking number.
Review a small sample of underlying records before trusting a summary. Duplicates, stale close dates, and missing outcomes can make a dashboard misleading even when the calculation is correct. Correct the record-level cause.
Skip the manual steps. Let AgentixCRM run this for every client.
Start now