Pipeline Design
Part of CRM reporting
Defining a CRM sales forecast
Define a CRM sales forecast by period, deal population, amount basis and owner, then make assumptions and adjustments reviewable.
A CRM sales forecast is a dated estimate of the sales value a team expects to close in a specified period. Define the period, eligible work, amount basis and owner of the judgement before publishing the number. Open deals are an input; a list of them does not explain the expected outcome by itself.
Write the definition first
A working definition might read: “For the selected quarter, this forecast estimates the value of deals expected to be marked won by this team, using the agreed deal amount and inclusion rules.”
State the currency, the cut-off for preparing the estimate and whether deals already won during the quarter are included.
Record five decisions beside the definition:
- Period:Which dates belong to the forecast, and when was it prepared?
- Population:Which pipelines, teams and deal types are eligible?
- Amount:Does each deal contribute its full amount, a weighted amount or another approved value?
- Treatment:Which deals are included, excluded or held for review?
- Ownership:Who supplies deal evidence, who may adjust the estimate and who approves it?
Two people can both say “quarterly forecast” while using different rules. The written definition makes that difference visible.
Separate calculation from judgement
A calculated figure can sum eligible deal amounts after applying a defined probability or category rule. A submitted forecast can reflect a manager’s judgement about what will close. Show both when they differ; record the deals or assumptions behind a material adjustment.
HubSpot’s forecast tool illustrates this distinction: it shows open pipeline and either weighted or total pipeline separately from a forecast submission. Its documented tool has subscription, seat and permission conditions.
Dynamics 365 Sales forecast columns and aggregated values depend on the configured fields and hierarchy. Neither product supplies a universal definition for a team’s forecast.
A pipeline stage records sales progress; forecast treatment concerns the estimate for a period. Decide how they interact in the local process without assuming that a stage alone settles the forecast judgement.
Calculated Pipeline vs. Judgement-Based Forecast
- Calculated Pipeline ValueSum of eligible deal amounts using defined probabilities or categories (e.g., HubSpot’s weighted pipeline)
- Judgement-Based ForecastManager’s informed estimate of what will close, reflecting market context, customer signals, and risk assessment
Review the period’s likely outcome
Ask deal owners what supports each proposed amount and decision date. A proposal sent to a customer does not establish that approval will arrive this quarter. If a deal slips, update its expected date and forecast treatment while preserving the record of what happened. Leave an unknown decision date uncertain rather than inventing one to keep the deal in the period.
Review deals already won, open deals near the period boundary, unusually large deals and exclusions. Note dependencies that could change the outcome. Assigned probabilities and categories help organise a review; they do not reliably predict an individual customer’s decision.
Publish a reviewable estimate
Present the forecast with its definition, preparation time, owner, included won value, expected open-deal contribution and material assumptions. Keep a dated submission or copy where the system supports it so a later reviewer can distinguish a changed outlook from a changed rule.
At the next review, compare the earlier estimate with deals actually marked won in that period, using the same amount basis. Trace material differences to slips, changes in value, losses or deals added later. Use the findings to improve the next estimate and its supporting evidence.
Forecast Publishing Requirements
- Forecast Definition
- Must include period, population, amount basis, treatment, and ownership
- Preparation Time
- Recorded and retained for auditability and comparison
- Included Won Value
- Track value of deals already won in the period
- Expected Open-Deal Contribution
- Estimated value from open deals based on current rules
- Material Assumptions
- Documented to enable review and improvement of future forecasts
