Manage Forecast Scenarios

Updated 

The Forecast Scenario is an entity in Sprinklr Service’s Workforce Management (WFM) module that predicts inbound traffic volume (Volume Forecast) for a specified time interval along with agents required to maintain the service level based on the Volume Forecast.

With integrated Forecasting and Capacity Planning, Forecast Scenario enables you to make more precise predictions and align staffing levels closely with actual needs. This reduces the risk of overstaffing or understaffing, which leads to lower labor costs and optimal volume handling. It also supports Daylight Saving Time (DST).

This section outlines the essential steps for managing Forecast Scenarios, including:

  1. Understanding Forecast Scenario Record Manager

  2. Creating Forecast Scenarios

  3. Publishing Forecast Scenarios

  4. Editing Forecast Scenarios

  5. Sharing Forecast Scenarios

  6. Deleting Forecast Scenarios.

Note: This feature is Dynamic Property (DP) controlled. Contact your Success Manager to enable this feature for your environment.

Note: The steps and information provided in this article pertain to Sprinklr WFM Version 2 (v2), which is the latest version. For information on Sprinklr WFM Version 1 (v1), please refer to the Version 1 section.

Understanding Forecast Scenario Record Manager

The Forecast Scenario Record Manager shows the list of all the Forecast Scenarios currently available, along with their overview. This page is a versatile hub where you can perform various actions on Forecast Scenarios, including creating, editing, changing release status, and viewing the type of Forecast Scenario.

Navigate to Forecast Scenario Record Manager

Follow these steps to navigate to Forecast Scenario Record Manager:

  1. Go to the Workforce Manager Persona App on the Launchpad.

  2. Select Forecast from the Left Pane to open the Forecast Scenario Record Manager.

The Forecast Scenario Record Manager has multiple columns that can be hidden or rearranged depending on your requirements or preferences. You can search for Forecast Scenarios by their names, and they can also be filtered based on Workloads, Type, Granularity, Status, and forecast Date Range. The Forecast Scenarios can be sorted by Creation Date and Last Modified in either ascending or descending order.

The following columns are available on the Forecast Scenario Record Manager:

Column Name

Description

Name

This column shows the name of the Forecast Scenario.

Workloads

This column shows the Workload(s) used for the Forecast Scenario.

Type

This column shows the Type of the Forecast Scenario. It can be Run-time Model, Pre-trained Model, or Import.

Granularity

This column shows the granularity at which the Forecast Scenario is generated.

Status

This column shows the current status Forecast Scenario. It can be a Draft, Failed, or Released.

Forecast Date Range

This column shows the date range for which the Forecast Scenario is generated.

Creation Date

This column shows when the Forecast Scenario was created.

Last Modified On

This column shows when the Forecast Scenario was last edited.

Creator

This column shows which user created the Forecast Scenario.

When viewing a Forecast Scenario in the tabular view, data can be displayed using various rounding options to suit your needs. You can choose to round up, round down, or round off values. These options allow for flexible and precise data presentation.

Note: The columns can be configured to display data using various rounding options at the customer level only.

  • Round-Up: This function always rounds a number up to the nearest specified increment, regardless of the value of the decimal part. For example, rounding up 2.3 to the nearest whole number results in 3.

  • Round-Down: This function always rounds a number down to the nearest specified increment, regardless of the value of the decimal part. For example, rounding down 2.7 to the nearest whole number results in 2.

  • Round-Off: This function rounds a number to the nearest specified increment based on the value of the decimal part. If the decimal part is 0.5 or higher, it rounds up; otherwise, it rounds down. For example, rounding off 2.5 to the nearest whole number results in 3, while rounding off 2.4 results in 2.

Column Level Actions

Each column can be configured independently with any of these configurations. Additionally, the data can also be configured to show up to a maximum of 2 decimal places in decimal format.

Provides support to apply column level actions such as Aggregate by Sum, (Mean or Average) and Maximum for Metric Type columns in the Tabular Visualization of Forecast Scenario Planning:

This feature helps you to apply aggregate by mean, max , sum respectively at the column level for the following columns:

  • Volume 

  • AHT 

  • Abandonment Rate 

  • Shrinkage 

  • Max Occupancy 

  • Min Service Level Goal 

  • Min Service Level Time 

  • Required FTEs 

  • Predicted SL 

  • Predicted Occupancy 

Definition of Functions

  • Sum: Adds individual values across granular intervals. 

  • Mean or Average: Calculates the average by dividing the sum of all individual values by the number of granular records. 

  • Maximum: Identifies the maximum value from granular intervals in the dataset. 

  • Aggregation for FTEs: Calculates the ratio of the sum of FTEs across granular intervals to the product of (60 / Partner Level Granularity Definition) and Shift Length, where Shift Length defaults to 9 but can be configured from the backend. 

Functions to Column Mapping

Column Name 

Function 

Volume 

Sum, Average, Maximum 

AHT 

Average 

Abandonment Rate 

No Aggregation Functions (Column to be Removed post its availability in Schedule Scenario Module) 

Min Service Level Goal 

Average, Maximum 

Min Service Level Time 

Average, Maximum 

Shrinkage 

Maximum 

Maximum Occupancy 

No Aggregation Functions 

Required FTEs 

(Label: Sum; Logic: Aggregation for FTEs) 

Predicted SL and Occupancy 

No Aggregation Functions (Column to be Removed post its availability in Schedule Scenario Module) 

​Scenarios where column level actions helps:

As a Forecaster, you should be able to:

  • Aggregate the Volume column by Sum to track case flow on a weekly or monthly basis (based on the selected date range).

  • Aggregate the AHT column by Average to measure the average handling time across agents and departments.

  • Aggregate the Shrinkage column by Max to determine the maximum shrinkage for a day or week.

  • Aggregate the Required FTEs column by Sum to calculate the required number of agents for the period.

  • Apply these aggregations simultaneously on different columns in the tabular view.

You can also adjust the width of the column.

Navigation Steps

  1. Click Forecast in the left pane.

  2. Go to Forecast Scenarios.

  3. Hover on the specific column to access the drop-down option to look for aggregate.

    The aggregate will be available in the footer.


Create Forecast Scenario

Forecast Scenarios can be created using the Run-Time Model, Pre-Trained Model, or imported. The Run-time Model is suitable if your contact center already uses the Sprinklr Service module for on-the-fly forecasting using historical data. The Pre-trained Model is suitable for generating Forecast Scenarios using an existing custom-trained model.

Create Forecast Scenario Using Run-Time Model

Prerequisites for creating Forecast Scenarios:

  • Sprinklr WFM should be enabled for the environment.

  • You must have access to the Workforce Manager Persona App.

Follow these steps to create a Forecast Scenario using Run-Time Model:

  1. Go to the the Workforce Manager Persona App on the Launchpad.

  2. Select Forecast from the Left Pane to open the Forecast Scenario Record Manager.

  3. Click the Create Forecast Scenario button at the top right of the page to open the Forecast Scenario creation page.

  4. Fill in the required fields on the Forecast Scenario creation page. Fields marked with a red dot are mandatory. Below are the descriptions of the fields on this page:

    1. Forecast Name: Enter a unique and descriptive name for the Forecast Scenario. This name will be used to identify the Forecast Scenario within the system. (Required)

    2. Description: Provide a summary or explanation of the Forecast Scenario.

    3. Type: Select Run-time model. (Required)

    4. Parameters: Select parameter(s) for your Forecast Scenario. (Required)

    5. Workload(s): Select the Workload(s) associated with the selected parameter(s). You can only select a Workload if a parameter is selected. The available Workload(s) in this list will be those that include the selected parameter(s) as their constituent. (Required)

      Note: Only Parent Workloads and Independent Workloads are available for selection in the list.

    6. Forecast Date Range: Enter the beginning and ending date and time for which the Forecast Scenario will be generated. (Required)

    7. Historical Date Range: Enter a historical date and time range based on which the Forecast Scenario will be created. For optimal accuracy, a minimum duration of two weeks is required. (Required)

    8. Excluded Date Ranges: Enter the date and time range to be excluded from the above historical date range. Click the ‘+’ symbol to enter more than one date range to exclude.

    9. Forecast Algorithm: Select from the available algorithm options. By default, Auto Select is pre-selected. (Required)

      1. Prophet: Prophet is based on an additive model where non-linear trends are fit with yearly, weekly, and daily seasonality, plus holiday effects. It works best with time series with strong seasonal effects and several seasons of historical data.

      2. ARIMA: ARIMA combines elements of Differencing, Moving Average, and Auto-Regression. In time-series data, it works well for capturing seasonality and linear patterns.

      3. SARIMAX: SARIMAX extends the capabilities of the ARIMA model by incorporating exogenous variables, making it a versatile choice for forecasting.

      4. Seasonal Naive: The Seasonal Naive algorithm is useful when there is clear seasonality in the data, and you expect that patterns from previous seasons will repeat without much change.

      5. Triple Exponential Smoothing: Triple Exponential Smoothing (TES), also known as Holt-Winters Exponential Smoothing, is used to forecast seasonal and trend-based data. It is suitable for complex and fluctuating patterns in customer support requests.

      6. Simple Exponential Smoothing: The Simple Exponential Smoothing (SES) algorithm is used for data that assumes no trend or seasonality. It is useful for short-term forecasting where the data does not exhibit strong seasonal patterns.

        Note: The Seasonal Naive, Triple Exponential Smoothing, and Simple Exponential Smoothing algorithms are used only when the Auto Select option is selected. You cannot explicitly select these algorithms for your Forecast Scenario.

    10. View Template: Select a view to visualize the parameters. (Required)

  5. Click the Next button at the bottom right of the page to open the Detect Event page.

  6. Click the Next button at the bottom right of the page to open the Detect Event page.

  7. Select any pre-existing Event(s) on the Detect Events page that you want to consider in the Forecast Scenario.

  8. Click the Save button at the bottom right of the page to create the Forecast Scenario.

This completes the Forecast Scenario creation process using Run-Time Model.

Create Forecast Scenario Using Pre-Trained Model

Prerequisites for creating Forecast Scenarios:

  • Sprinklr WFM should be enabled for the environment.

  • You must have access to the Workforce Manager Persona App.

Follow these steps to create a Forecast Scenario using Pre-Trained Model:

  1. Go to the Workforce Manager Persona App on the Launchpad.

  2. Select Forecast from the Left Pane to open the Forecast Scenario Record Manager.

  3. Click the Create Forecast Scenario button at the top right of the page to open the Forecast Scenario creation page.

  4. Fill in the required fields on the Forecast Scenario creation page. Fields marked with a red dot are mandatory. Below are the descriptions of the fields on this page:

    1. Forecast Name: Enter a unique and descriptive name for the Forecast Scenario. This name will be used to identify the Forecast Scenario within the system. (Required)

    2. Description: Provide a summary or explanation of the Forecast Scenario.

    3. Type: Select the Pre-trained model option. (Required)

    4. Parameters: Select parameter(s) for your Forecast Scenario. (Required)

    5. Workload(s): Select the Workload(s) associated with the selected parameter(s). You can only select a Workload if a parameter is selected. The available Workload(s) in this list will be those that include the selected parameter(s) as their constituent. (Required)

    6. Forecast Date Range: Enter the beginning and ending date and time for which the Forecast Scenario will be generated. (Required)

    7. View Template: Select a view to visualize the parameters. (Required)

  5. Click the Save button at the bottom right of the page to create the Forecast Scenario.

This completes the Forecast Scenario creation process using Pre-Trained Model.


Import Forecast Scenario

Prerequisites for creating Forecast Scenarios:

  • Sprinklr WFM should be enabled for the environment.

  • You must have access to the Workforce Manager Persona App.

Follow these steps to import a Forecast Scenario:

  1. Go to the Workforce Manager Persona App on the Launchpad.

  2. Select Forecast from the Left Pane to open the Forecast Scenario Record Manager.

  3. Click the Create Forecast Scenario button at the top right of the page to open the Forecast Scenario creation page.

  4. Fill in the required fields on the Forecast Scenario creation page. Fields marked with a red dot are mandatory. Below are the descriptions of the fields on this page:

    1. Forecast Name: Enter a unique and descriptive name for the Forecast Scenario. This name will be used to identify the Forecast Scenario within the system. (Required)

    2. Description: Provide a summary or explanation of the Forecast Scenario.

    3. Type: Select the Import option. (Required)

    4. Upload Forecast: Upload the Template file with details of the Forecast Scenario. Refer to the Important Considerations for Importing Forecast Scenario section below for details on the headers of the data import template. (Required)

    5. Timezone: Select the time zone of the start date and time value entered in the “startTime” header in the import template.

    6. View Template: Select a view to visualize the parameters

    7. Date Pattern: Select the date and time value format entered in the “startTime” header in the import template, such as MM/DD/YYYY, MM-DD-YYYY, or DD/MM/YYYY.

  5. Click the Save button at the bottom right of the page to import the Forecast Scenario.

Important Considerations for Importing Forecast Scenario

  • CSV, XLS, and XLSX are the approved file formats.

  • A Workload ID can be the exact ID, the Name, or any alphanumeric value. Once imported, the system will ask for the Workload ID to be mapped exactly to the already existing Workloads.

  • You must create the Workloads as per your naming convention.

  • Ensure no duplicate values are present for the same ‘timestamp’ and ‘workloadIds’ in the file.

  • Verify all forecast values are present for each ‘timestamp’ and ‘workloadId’ according to the specified granularity. For example, with a 30-minute granularity over 30 days, there should be exactly 1440 rows for each ‘workloadId’.

  • Confirm the epoch is in GMT, like other models, and ensure the granularity is not less than 15 minutes.

The following headers are mandatory in the file (Do not modify the header, including their case):

Parameter

Header

Remarks

Start Date and Time

startTime

Recommended format:
DD/MM/YYYY HH:MM:SS (Other date and time formats are also supported)

Workload ID

workloadId

Does not support decimal points; requires whole numbers.

Average Handling Time (AHT)

averageHandleTime

The unit of this header is seconds. It must be a numeric value greater than 0.

Inbound Volume

volume

Should be >=0. Supports decimal point.

Service Level Goal

ServiceLevelGoal

It must be a percentage value, that is greater than 0 and less than 100.

Service Time

ServiceTime

The unit of this is header is seconds. The value must be greater than 0.

Maximum Occupancy

maxOccupancy

It must be a percentage value, that is greater than 0 and less than 100.

In-office Shrinkage

inOfficeShrinkage

Percentage value. It must be greater than 0 and less than 100.

Out-of-Ofice Shrinkage

outOfOfficeShrinkage

Percentage value. It must be greater than 0 and less than 100.

Required Full Time Equivalents (FTEs)

requiredFTEs

The value must be greater than 0.

This completes the process of importing a Forecast Scenario.


Publish Forecast Scenario

Prerequisites for publishing Forecast Scenarios:

  • Sprinklr WFM should be enabled for the environment.

  • You must have access to the Workforce Manager Persona App.

  • Existing Forecast Scenario.

Follow these steps to publish a Forecast Scenario:

  1. Go to the Workforce Manager Persona App on the Launchpad.

  2. Select Forecast from the Left Pane to open the Forecast Scenario Record Manager.

  3. Click the View Forecast (eye icon) button corresponding to the Forecast Scenario to be published. This will open a detailed view of the Forecast Scenario.

  4. Click the Publish button at the top right of the page.

This completes the process of publishing a Forecast Scenario.


Edit Forecast Scenario

Prerequisites for editing Forecast Scenarios:

  • Sprinklr WFM should be enabled for the environment.

  • You must have access to the Workforce Manager Persona App.

  • Existing Forecast Scenario.

Follow these steps to share a Forecast Scenario:

  1. Go to the Workforce Manager Persona App on the Launchpad.

  2. Select Forecast from the Left Pane to open the Forecast Scenario Record Manager.

  3. Hover over the vertical ellipsis (⋮) icon corresponding to the Forecast Scenario you want to edit. This will show a list of options.

  4. Select Edit from the list of options to open the Forecast Scenario editing page.

  5. Update the necessary details for the selected Forecast Scenario. The fields are the same as those used when creating a Forecast Scenario.

  6. After entering the updated details, click the Save button at the bottom right of the page to save the Forecast Scenario with new details. Depending on the Type of the Forecast Scenario, the Save button will be on the Overview page (Pre-trained model and imported) or the Detect Events page (Run-time model).

This compeletes the process of editing a Forecast Scenario.


Share Forecast Scenario

Prerequisites for sharing Forecast Scenarios:

  • Sprinklr WFM should be enabled for the environment.

  • You must have access to the Workforce Manager Persona App.

  • Existing Forecast Scenario.

Follow these steps to share a Forecast Scenario:

  1. Go to the Workforce Manager Persona App on the Launchpad.

  2. Select Forecast from the Left Pane to open the Forecast Scenario Record Manager.

  3. Hover over the vertical ellipsis (⋮) icon corresponding to the Forecast Scenario you want to share. This will show a list of options.

  4. Select Share from the list of options to open the Share With dialog box.

  5. Fill in the required fields. Below are the descriptions of the fields on this dialog box:

    1. Visible in all workspaces: Select this checkbox to share the Forecast Scenario with all available Workspaces.

    2. Workspaces: Select the Workspace(s) you want to share the Forecast Scenario with. This field is accessible only if the Visible in all workspaces field is not selected.

    3. User/User Groups: Select the User(s)/User Group(s) you want to share the Forecast Scenario with. This field is accessible only if the Visible in all workspaces field is not selected.

  6. Click the Share button located at the bottom right of the dialog box. This will share the Forecast with the selected Workspace(s) and User(s)/User Group(s).

This completes the process of sharing a Forecast Scenario.


Delete Forecast Scenario

Prerequisites for deleting Forecast Scenarios:

  • Sprinklr WFM should be enabled for the environment.

  • You must have access to the Workforce Manager Persona App.

  • Existing Forecast Scenario.

Follow these steps to delete a Forecast Scenario:

  1. Go to the Workforce Manager Persona App on the Launchpad.

  2. Select Forecast from the Left Pane to open the Forecast Scenario Record Manager.

  3. Hover over the vertical ellipsis (⋮) icon corresponding to the Forecast Scenario you want to delete. This will show a list of options.

  4. Select Delete from the list of options to open the Delete Forecast dialog box.

  5. Select Submit to delete the Forecast Scenario. This action cannot be undone.

Note: This would delete all the associated Split Profiles and Child Forecast Scenarios.

This completes the process of deleting a Forecast Scenario.


Export Forecast Scenario Data

Exporting Forecast Scenario data allows you to save and analyze data outside the application. Once exported, the data can be used for further analysis, reporting, or sharing with stakeholders, providing flexibility and convenience in managing your Forecast Scenarios.

Follow these steps to export Forecast Scenario data from the tabular view:

  1. Navigate to the Forecast Scenarios Record Manager.

  2. Click the View Forecast (eye icon) button corresponding to the Forecast Scenario that you want to export. This will open a page with details of the Forecast Scenario.

  3. Click the Switch to Table View button to view the Forecast Scenario data in tabular format.

  4. Click the Export button at the top right of the page. This will open the Export Forecast dialog box.

  5. Fill in the required fields on the Export Forecast dialog box. Fields marked with a red dot are mandatory. Below are the descriptions of the fields on this dialog box:

    1. File Name: Enter a unique and descriptive name for the exported file. (Required)

    2. Format: Excel is selected by default. (Required)

    3. Date Range: Select the date range for exporting data. This range must fall within the Forecast Period. (Required)

  6. Click the Submit button at the bottom right of the dialog box to submit the export request.

You will receive a system notification confirming your export request. A link to download a zip folder containing the Forecast Scenario data will be provided shortly after.


Inline Updates to Forecast Scenario Data

Inline updates to Forecast Scenario data allow you to update forecasted entries, like volume, Average Handling Time (AHT), or any other input parameter in real time. Making inline changes also updates the related parameters in real-time according to the changes made.

Follow these steps to make inline updates to Forecast Scenario data:

  1. Navigate to Forecast Scenarios Record Manager.

  2. Click the View Forecast (eye icon) button corresponding to the Forecast Scenario for which you want to modify the data. This will open a page with details of the Forecast Scenario.

  3. Click the Switch to Table View button to view the Forecast Scenario data in tabular form.

This page shows the Forecast Scenario data according to the Workload and the forecast's time stamp (Date, Day, Interval). Each row displays denotes the default granularity (15 or 30 minutes) configured for your Workspace. The columns provide details on the Forecast Scenario parameters, such as volume, Average Handle Time (AHT), predicted occupancy, and more. This means each cell contains the parameter (column) details for the specific time stamp (row).

Note: The Intervals column shows the time in 24-hour format.

Depending on the parameter and time stamp for which you want to update the data, double-click on the required cell corresponding to the time stamp. For example, if you want to update the volume for 10:15 AM on November 21, 2024, scroll down to the row for 10:15 on that date. The cell under the Volume column in this row is the one you need to update.

Note: The Volume column cannot be updated inline for Split Forecast Scenarios.

Double-click it to edit the data once you have identified the correct cell. Enter the updated information and press Enter on your keyboard to save the changes. This will also update the data in any other related cells.

The value of a cell can be copied and pasted to any other cell as long as it adheres to the column's constraints. For example, cells in the Minimum Service Goal column cannot have a value greater than 100.

Note: You can quickly copy a cell's data to other cells in the same column by clicking and dragging the bottom right corner of the cell up or down.

This completes the process of inline editing Forecast Scenario data.


Audit Trail for Forecast Scenario

The Audit Trail feature allows you to track all changes within the Forecasting and Scenario Planning modules. It logs every activity, from minor updates to major changes, complete with date and time stamps along with details of the user who has made changes for full transparency and traceability.

Prerequisites for Audit Trail Support:

  • Sprinklr WFM should be enabled for the environment.

  • You must have access to the Workforce Manager Persona App.

  • Existing Forecast Scenario.

Follow these steps to access Audit Trail for Forecast Scenario:

  1. Go to the Workforce Manager Persona App on the Launchpad.

  2. Select Forecasting from the Left Pane to open the Forecast Scenario Record Manager.

  3. Hover over the Vertical Ellipsis (⋮) icon corresponding to the Forecast Scenario for which you want to view the Audit Trail. 

  4. Select View Audit

    Audit Trail will open in the right pane.