Map Opportunity Stages to Forecast Categories
Mapping is an important step of setting up forecasting. Forecast figures can look very different and can completely change how you use the data if opportunity stages are not mapped as expected to forecast categories.
Because all stages, except Closed Won and Closed Lost, are mapped to the Pipeline forecast category, you need to define which opportunity stages map to each forecast category based on the different thresholds that increase the likelihood an opportunity will be won.
Create the Mappings
The sales department at Ursa Major has specific guidelines for how they want to measure probability at the various stages of their sales pipeline. Go ahead and create the mappings in accordance with the approved guidelines.
- From Setup, click Object Manager.
- Under Label, click Opportunity, and then click Fields & Relationships.
- Under Field Label, click Stage.
- For the Stage Name entitled Value Proposition, click Edit.
- Click the Forecast Category menu and select Best Case.
- In the Probability field, if the value is not 50, enter
50
. - Click Save.
- Repeat for these remaining stage names:
Stage Name
Forecast Category
Probability (%)
Id. Decision Makers
Best Case
50
Perception Analysis
Best Case
70
Proposal/Price Quote
Commit
75
Negotiation/Review
Commit
90
- Ensure that your opportunity stage mapping looks like this:
View the Impact of Mapping Opportunity Stages to Forecast Categories
After you change a forecast category and/or probability, you receive an email letting you know that the update is done. After you receive all five emails, view the Forecasts tab and look at Alek’s forecast again. Compare the forecast now to the forecast prior to updating the stages.
- On the Sales app screen, click the Forecasts tab.
- Click the View my forecasts menu.
- In the search field, enter
Alek
and select Alek Wozniak. The opportunity revenue forecast for Alek Wozniak is displayed. - Notice that the values have changed since mapping the opportunity stages to the forecast categories. (You may need to hit the refresh button multiple times until the system displays the updated information.)
- In the Commit column, click the value USD 329,318.18.
- On the All Forecast Categories below, under Opportunity Name, click the opportunity Koleje - 60 GreenSun Ground.
- Click Edit and change the stage to Closed Won.
- Click Save.
- Click Forecasts tab.
- From the View my forecast menu, search for and select Alek Wozniak again. You are viewing Alek’s forecast again but with the change you just implemented. (You many need to hit the refresh button to see the changes.)
- Notice that the opportunity value moved from Commit to Closed and the total for the four quarters changed.
Adjusting the mappings of opportunity stages to forecast categories changes the way the forecasts are displayed for Ian, allowing him to ensure forecast accuracy, better manage his sales team, and be in compliance with corporate guidelines.
Now that you’ve created the correct mappings, move on to assign forecast managers.