Forecast Hierarchy Management allows you to control how forecasting data is shared across roles in your organization. For example, if you place sales managers above sales reps in the hierarchy, sales managers automatically see all forecast data owned or viewed by sales reps.
If your hierarchy already exists in Salesforce or another source system, you can import it into Backstory using a CSV file so there is no need to re-build it manually. You can also make small adjustments directly in the Forecasting Hierarchies Admin UI.
Note: Forecast Hierarchy Management requires a Backstory administrator account.
Create a Forecast Hierarchy
Export a CSV from Salesforce or your source system, then format it to meet Backstory’s requirements. To get the correct template for your system, work with your CSM or contact support@backstory.ai.
Log into app.backstory.ai as an administrator.
Click the grid icon in the top left corner.
Select Admin Panel.
In the left-hand menu panel, click the + icon next to FORECAST HIERARCHIES.
In the pop-up window, enter the name of your hierarchy and select “User” or “Territory” based on the type of CSV file you exported from Salesforce.
Update Your Forecast Hierarchy
You can edit your hierarchy name and add or edit territories directly in the Forecasting Admin UI. Alternatively, you can make updates to an existing CSV or export an updated CSV from Salesforce.
Update Using the Existing CSV
This is the best option if you have not made any changes to your forecast hierarchy in Salesforce since last importing it to Backstory.
Open your forecast hierarchy in the Forecasting Hierarchies Admin UI.
Click Update with CSV in the top right corner.
When the pop-up window appears, click Download CSV.
Open the file, make your changes, and save it.
Return to the pop-up window, click Browse, and upload the updated file.
Update Using a New CSV From Salesforce
This is the best option if you have made changes to your forecast hierarchy in Salesforce since last importing it to Backstory.
Export an updated CSV file from Salesforce, then format it to meet Backstory’s requirements. To get the correct template for your system, work with your CSM or contact support@backstory.ai.
Open your forecast hierarchy in Forecasting Hierarchies Admin UI.
Click Update with CSV.
In the pop-up window, click Browse, select your updated file, and import it.
Frequently Asked Questions
Do updates in Salesforce automatically sync to Backstory?
No. You must manually update or import user assignment changes into Backstory.
Can we assign one user to multiple hierarchy levels?
Yes. A user can be assigned to multiple levels with different permission settings.
Can we manage assignments entirely via CSV?
Yes. You can both export and re-import user assignments for faster updates.
Need Help?
Contact your Customer Success Manager or support@backstory.ai.