WFM Queue Stats dataset

The WFM Queue Stats dataset contains the following data:

Queue

Data field Definition
Queue ID The Workforce Optimization database ID for the queue.
Queue Log Data Source The source of data for the queue log details. For example, an ACD or other systems.
Queue Name A queue is where calls are placed as they are handled by the ACD/CTI platform and holds the calls until an agent is available. Data from the platform is used by the WFM system as a basis for workloads.

Queue Stats

Data field Definition
Abandon Rate (%) The percentage of the calls that are abandoned compared to calls offered.
Abandon Rate excl Short Calls (%) The percentage of calls that were abandoned but waited in the queue for more than the threshold for short calls.
Abandoned Calls A call where the caller hung up and abandoned the queue.

Abandoned Calls After SL

Calls that have been abandoned after the service level target set in the ACD/CTI platform.

Abandoned Calls Within SL

Calls that have been abandoned within the service level target set in the ACD/CTI platform.

Abandoned Short Calls

Short calls or abandoned short calls are calls that are abandoned (meaning the caller hangs up) when they have only been in queue for a very short time period. The threshold is set in the ACD/CTI platform.

After Call Work (s)

After call work (ACW) is the total time in seconds the agent spends on a customer contact, after they have finished talking to the customer.

Answer Rate (%)

Percentage value of answered calls / offered calls on queue.

Answered Volume

Total number of answered calls/chats/emails in a queue.

Answered Volume After SL

Total number of answered calls/chats/emails/backoffice tasks in a queue after a service level value set in ACD/CTI platform.

Answered Volume Within SL

Total number of answered calls/chats/emails/backoffice tasks in a queue before a service level value set in ACD/CTI platform.

Avg After Call Work (s)

The time agents spend on calls after they have finished talking to the customer, divided by all answered calls on queue.

Avg Handling Time (s)

The amount of time it takes on average to handle a contact to completion, including talk time plus after call work time calculated by total handling time/answered calls on queue.

Avg Hold Time (s)

The average hold time calculated as total hold time / total number of answered calls on queue level.

Avg Speed of Answer (s)

The time it takes in seconds for a call/task/email to be answered/handled in an ACD/CTI queue for a specified period.

Avg Talk Time (s)

The time in seconds agents spend talking to customers divided by the number of answered calls on queue.

Avg Time to Abandon (s)

The time in seconds a caller waits before hanging up on the call divided by the number of abandoned calls on queue.

Handling Time (s)

Total time that agents spend on a call or task including the after call work on queue level.

Hold Time (s)

Total time in seconds that calls are put on hold on queue level.

Longest Delay In Queue Abandoned (s)

The longest time a call has been in queue before being abandoned, for the selected time period.

Longest Delay In Queue Answered (s)

The longest time a call has been in queue before being answered, for the selected time period.

Offered Volume

Total number of calls/chats/emails that have been placed in a queue by the ACD/CTI platform, which can then either be answered by a resource (handled) or abandoned.

Overflow In Calls

The number of calls that have been routed in from another queue in the ACD/CTI platform.

Overflow Out Calls

The number of calls that have been routed out to another queue in the ACD/CTI platform.

Schedule Date Interval

The base level interval marker that underlies all schedules. Format is MMDDYYHHMM.

Service Level (%) - Ans in SL / Answered

The service level target is usually expressed as a combination of a percentage and a unit of time. Service level is the given percentage, and the Service time is the given unit of time. The percentage is calculated according to the formula in the name.

Service Level (%) - Ans in SL + Abd in SL) / (Answered + Abandoned)

The service level target is usually expressed as a combination of a percentage and a unit of time. Service level is the given percentage, and the Service time is the given unit of time. The percentage is calculated according to the formula in the name.

Service Level (%) - (Ans in SL + Abd in SL) / Offered

The service level target is usually expressed as a combination of a percentage and a unit of time. Service level is the given percentage, and the Service time is the given unit of time. The percentage is calculated according to the formula in the name.

Service Level (%) - Ans in SL / Offered

The service level target is usually expressed as a combination of a percentage and a unit of time. Service level is the given percentage, and the Service time is the given unit of time. The percentage is calculated according to the formula in the name.

Speed of Answer (s)

The total time it takes for a call/task/email to be answered/handled in an ACD/CTI queue for a specified period.

Talk Time (s)

The time agents spend talking to customers measured on queue level. Hold time is usually included in the talk time, but this depends on how the integration is set up.

Time to Abandon (s)

The time a caller waits before hanging up on the call.

Skill

Data field Definition
Skill Code The Workforce Optimization database GUID for a skill.
Skill Name

A skill is a staffing forecast that defines a resource need to be fulfilled during scheduling. In order to be scheduled, agents must be assigned to at least one skill. The Skill status shows if the skill is active or deleted in the system.

System

Data field Definition
system_realm_id

The Workforce Optimization database ID for the Provider realm that the tenant is in.

system_tenant_id

The Workforce Optimization database ID for the tenant.

Workload

Data field Definition
Workload Code

The Workforce Optimization database ID for a workload.

Workload Name A workload is a set of data (historical or simulated) indicating the volume of calls, emails, or other work that is to be performed by agents and scheduled in WFM. A workload may be associated with a number of queues that share the same open hours and follow a common pattern. A workload must be connected to a skill.