Demand Forecast in Workforce Optimization for Customer Service
Summarize
Summary of Demand Forecast in Workforce Optimization for Customer Service
Demand Forecast in Workforce Optimization for Customer Service helps managers predict and visualize agent staffing needs at 15-, 30-, and 60-minute intervals on the team calendar. The feature uses color-coded intervals to indicate understaffing (red), overstaffing (yellow), well-staffed (green), and no staffing required (grey). Managers can adjust schedules, breaks, and tasks based on these forecasts to maintain service objectives without disruption.
Show less
This capability allows managers to proactively allocate resources to meet fluctuating demand, ensuring optimal staffing across teams and individual agents.
Key Features
- Time-Interval Staffing Views: Detailed forecast views at 15-, 30-, and 60-minute intervals provide granular visibility into staffing requirements.
- Color-Coded Staffing Status: Visual indicators highlight understaffed, overstaffed, and well-staffed slots for quick assessment.
- Forecast Metrics: The application uses MetricBase to generate two key metrics — Staffing Forecast (number of agents needed) and Volume Forecast (historical and predicted contact volumes).
- Forecast Configuration: Managers with forecast admin roles can create, modify, and manually adjust forecasting parameters and formulas to tailor predictions to specific business scenarios.
- Data Collection Definitions: Define and schedule data collection for cases, interactions, and any other relevant tables to build accurate forecasting models using historical data.
- Resource Conversion Formulas: Convert volume forecasts into staffing requirements using customizable formulas associated with assignment groups.
- Interactive Calendar Views: Demand forecasts are integrated into team calendars to support daily, weekly, and monthly planning.
How It Works
The Demand Forecast application collects historical data at 15-minute granularity via scheduled jobs, storing it in MetricBase. Using the Seasonal Trend Loess (STL) algorithm by default, it generates volume forecasts which can be converted into staffing forecasts by applying formulas. Managers can manually adjust forecasts to accommodate special events or expected demand changes.
Assignment groups are linked with these formulas to translate case and interaction volumes into agent requirements. Managers then use the team calendar to monitor predicted staffing levels and make real-time scheduling adjustments.
Practical Benefits for ServiceNow Customers
- Improved Staffing Accuracy: Use historical data and advanced forecasting algorithms to prevent understaffing and overstaffing, thereby maintaining service quality.
- Proactive Resource Management: Schedule breaks, meetings, and tasks without impacting service goals, optimizing agent productivity.
- Flexible Forecast Adjustments: Manually tweak forecasts to reflect business-specific events like holidays or promotions.
- Comprehensive Data Integration: Leverage data from various tables beyond cases and interactions to refine forecasts.
- Role-Based Access: Forecast creation and adjustments are controlled by roles ensuring secure and accurate forecasting management.
Configuration and Usage Notes
- Data collection and forecasting apply only to Workforce Optimization (WFO) assignment groups.
- Admins must provision the snwfocfgws.manager role to managers for access to forecast features.
- When adding new assignment groups after running data collection jobs, update data collection definitions and rerun historical data collection to ensure forecast accuracy.
- Default forecast components and configurations are included with Workforce Optimization for Customer Service.
Demand Forecast enables managers to view their agent staffing forecast at 15-, 30-, and 60-minute intervals on the team calendar. This feature enables managers to adjust and prioritize schedules, tasks, breaks, and meetings for their agents without impacting service objectives. Learn how you can use Demand Forecast to predict resources based on historical data.
Overview of the Demand Forecast application.
The 15-, 30-, and 60-minute intervals are color-coded to display the status of agent staffing such as understaffing, overstaffing, and well staffed. Understaffed slots are color-coded red, overstaffed slots are color-coded yellow, and well-staffed slots are color-coded green. Slots that do not need staffing are color-coded grey. Managers must ensure adequate staffing in understaffed slots and optimize the resources in overstaffed slots.
For example, a manager of the Service Support group can see that the slot between 07:00 and 07:15 is color-coded red and is understaffed. The demand is for nine resources and the coverage is eight resources. The slot is understaffed by one resource. That slot displays 9 and -1. To avoid the understaffing of that slot, the manager allocates a resource who is on a break. The manager reschedules the break of that resource from 07:00 to 07:30. The 07:00 to 07:15 slot is now well staffed and color-coded green.
The manager of all the teams can view the staffing forecast of the teams and at the individual level in the 15-, 30-, and 60-minute intervals according to the requirement. This view helps managers to staff their teams adequately.
The Demand Forecast application uses MetricBase to forecast the demand for teams.
- Staffing forecast: The forecast on the number of agents that a manager must handle cases and interactions in 15-, 30-, and 60-minute intervals.
- Volume forecast: The historical data and the forecast of the contact volumes (cases and interactions) at 15-minute intervals.
Analyzing Demand Forecast resource prediction
As a manager with the forecast admin role, you can create forecast parameters in the Manager Workspace. Modify forecast parameters to visualize forecast data and preview time-series data before publishing it. You can create any number of forecasts to preview the time-series data in real time.
You can also make manual adjustments to tweak the forecast and analyze the forecast pattern. Overlay the manual adjustments on the visualized forecast data and view the time-series data to analyze the forecast model. For example, you have a specific pattern for the upcoming week that has a national holiday in the middle of the week where you need more agents. Because you expect the sales to go up, you can manually tweak the forecast to increase it by 10% and analyze that data.
Demand Forecast
| Module Name | Description |
|---|---|
| Data Collection Definitions | Set conditions to define the data that you want to collect for cases, interactions, or any table. |
| Formula Parameters | Add the parameters to be defined in the formula to calculate the resources from the forecast. |
| Resource Conversion Formula | Add formulas to convert forecast to resources at 15-, 30-, and 60-minute intervals. |
| Group Forecast Configuration | Associate the configured formula for resource conversion to groups. |
As a user with the sn_agent_forecast.admin role, you can forecast the number of agents that you need for a shift.
- Collect data by defining data collection definitions.
- Set values for forecast parameters and generate volume forecasts.
- Create formulas to convert volume forecasts into the number of resources that you need at 15-, 30-, and 60-minute intervals.
- Associate the formulas to assignment groups.
- View the predicted demand on the calendar.
Collect data by defining data collection definitions
- Use the Collect daily data for automated forecast configurations scheduled job to gather data for the metrics defined in the data collection definitions. The scheduled job fetches the records from the
previous day for every 15-minute interval for all assignment groups and stores it in the MetricBase.
You can access the time series for the collected data using the MetricBase
listin the Group [sys_user_group] table. For more information on accessing MetricBase data, see Access MetricBase data using the list command. - Use the Collect historical data for automated forecast configurations on-demand job to collect historical data at 15-minute intervals. This job collects data for the past three years.
- Use the Forecast resources for future scheduled job to forecast the resources based on the collected data and stores the data in the Agent Forecast metric in MetricBase. See Forecast properties to set the collection frequency such as the number of days that you must collect the data to calculate the forecast or the time period that you want to store the data for.
Create forecast parameters
Managers can collect historical data at 15-minute granularity for generating accurate forecasts. The forecasts generated show the patterns in cases and interaction volume at 15-minute intervals. By default, the application uses the Seasonal Trend Loess (STL) algorithm.
For example, a manager can generate the volume forecast at 15-minutes intervals by providing the appropriate forecast parameters. Forecast parameters consist of the period length and periods to forecast that are most suitable for the pattern observed in the contact volumes.
Create formula parameters
Use numeric values or a script to be defined in the formula to calculate the resources from forecasts. Units in formula parameters can be specified in hours, minutes, or absolute numbers. See Formula parameters for the parameters that are available by default.
Create formulas to convert forecast to resources
Build formulas to convert the volume forecast to the staffing forecast at 15-, 30-, and 60-minute intervals. See Resource Conversion Formula for the configured resource forecast formulas that are available by default.
Associate formulas to assignment groups
Associate assignment groups with the resource conversion formula to convert the number of cases and interactions to the number of agents.
View the predicted demand on the calendar
The data collected by the Agent Forecast metric in MetricBase is used to forecast the agents that you need for each 15-, 30-, and 60-minute interval in a day on the team calendar. In the Week and Month views for the calendar, it displays the staffing levels for a given week and month respectively.