Queue Metrics Interval Export report


The Queue Metrics Interval Export report displays detailed statistics about multimedia queue activity for selected queues during a date and time range. This report is similar to the Queue Metrics Interval Report, but the Queue Metrics Interval Export Report also includes columns for queue, date, and media type. The extra columns allow you to more easily export the data to another program, such as Microsoft Excel. The Queue Metrics Interval Report has a Total Hold column, and the Queue Metrics Interval Export Report does not have a Total Hold column. 

Depending on the media type, the report includes the following queue activity:

  • Interactions offered, answered, and abandoned
  • Performance metrics (for example, abandon rate, service level, and average speed of answer)
  • Talk time, after call work, and handle time
  • Hold and transfer data

The details of the report appear in 30-minute intervals (for example, 08:00 through 08:29). The report sorts the information by the queue name, the date of the interaction, and the media type. The report provides totals by day.

For more information about creating a report, see Configure a report.

Note: The .xls and .xlsx file formats of the Queue Metrics Interval Export report do not have a daily total row for each queue or a page footer. The .pdf file format includes a daily total row for each queue and a footer for each page. The exclusions in the .xls and .xlss formats make the data in the report easier to use in spreadsheet software.



Reports support multiple media types, such as chat and email, which can affect reports in several ways:

  • Fields that do not apply to the interaction type are marked "N/A." For example, emails cannot be placed on hold or abandoned. 
  • "Talk time" is the standard term for the time that the agent and customer are connected.
  • Reports show information for all of the media types that are listed in the report's custom parameters. For example, if a queue only handles voice, but you select chat as a report parameter, the report includes chat statistics. Because the queue does not handle chat interactions, the results are blank.


Run this report to determine whether:

  • Some intervals are busier than others.
  • An interval meets your expectations for service level or abandon rate.  
  • There is an increase in talk time or after call work.
  • Transfer rates remain consistent. 

For example, a manager considers the following questions when this report shows that the service level did not meet expectations during four consecutive intervals:   

  • Was the volume of interactions during these intervals higher than expected?
  • Did we plan for more interactions during this interval or was this exception an anomaly?
  • Was a higher number of agents out sick or on break?
  • Did we draft extra resources to cover this time of day?



Queue Metrics Interval Export report

Report column Description
Date The date of the interactions.
Interval The interval of the interactions.
Queue The queue in which the interactions occurred.
Media Type The media type of the interactions.
Offered

The number of interactions routed into the queue for an agent to answer. Offered interactions are either answered, abandoned, or flow-out interactions. 

Answered

A measurement of the number of assigned ACD interactions answered by an agent in a given period. Answered increments when the agent is the first to connect to the interaction.

Abandoned

The number of interactions where a customer disconnects in an ACD queue before connecting with an agent. For example, the customer hangs up before an agent answers, or the system disconnects the interaction.

Abandon %

The percentage of offered interactions in which the customer disconnected before connecting with an agent. The abandon rate can identify queues that require extra staff to handle interactions in a timely manner.

Calculated by: (Abandoned Count / Offered Count) * 100

 
Service Level %

Service level target is a contact center performance statistic expressed as “X percent of contacts answered in Y seconds.” For example, a goal of answering 80% of voice calls within 20 seconds provides a service level target of 80/20. You can set the service level target for each media type in a queue. Analytics uses this service level target to calculate whether you are within the service level % defined by your service level agreement (SLA). For more information about setting the service level target, see Create queues or Edit or delete queues.

The service level percentage is the percentage of interactions that meet your contact center's service level target. Calculated by: (Number of answered interactions - number of answered interactions that miss the service level target) / (Number of answered interactions + number of abandoned interactions)*100

Admins can also choose to include flow-outs in the calculation. For more information, see Configure the service level calculation. If you include flow-outs, the service level calculation is: (Number of answered interactions - number of answered interactions that miss the service level target) / (Number of answered interactions + number of abandoned interactions+ number of flow-outs)*100

Note: Any interactions that leave a queue without an agent handling or transferring the interaction, including callbacks, count as flow-outs. Callbacks do not count as answered within service level, even if the callback was offered before the Service Level Target was reached.

ASA (Average Speed of Answer)

The average amount of time an interaction waits in queue before an agent answers it. This metric does not include interactions that agents do not answer. ASA is directly associated with service level and provides insight into the customer service your company provides. ASA is recorded in the interval in which the agent answered the interaction.

Calculated by: Total Time to Answer / Number Answered 

Avg Talk

The average number of seconds spent interacting on a media type.

Calculated by: Total Talk time/ Count of interactions with Talk time.

Avg ACW (After-call work)

The average amount of time agents spent completing after-call work.

Calculated by: Total ACW / Interactions

Note: ACW for callback interactions is always zero. 

AHT (Average Handle Time)

The average amount of time agents spent handling interactions. This calculation includes talk time, hold time, and after-call work. For outbound calls it also includes dialing and contacting time.

Calculated by: (cumulative talk time + cumulative hold time + cumulative after-call work + cumulative dialing time + cumulative contacting time) / Number of interactions handled.

Avg Hold

The average number of seconds that interactions were placed on hold.

Calculated by: Total Hold Time / Count of interactions with holds

Transferred

A measurement of the number of interactions an agent answered in one queue and then transferred. A transfer counts for the queue in which an agent answers the interaction. This measurement is calculated by the number of interactions blind transferred or consult transferred. 

Transfer %

The number of transfers compared to the total number of interactions answered.

Calculated by: (# of transfers / Interactions Answered) * 100