- Contents
Interaction Reporter Help
Agent Performance Detail for Queue by Interval Report
The Agent Performance Detail for Queue by Interval report displays a detail of agent information by interval for a specified date/time/interval range for selected agents. You can select the agents individually or by a workgroup. This report shows the summary for each agent by queue, by day, and by interval. It shows the number of ACD interactions, after call work, and time available for ACD interactions.
This report is intended for use by a supervisor to review the agents’ ACD interaction activity on a detailed level.
Flexible Fields
This report also has two Flexible Fields, which are the last two columns of the report.
By default, IC displays Local Disconnect in the first flexible field, but you can easily change this flexible field in Interaction Administrator, to show the other values:
· Local Disconnect = 1 (default)
· Flowed Out = 2
· Entered = 3
· Transferred = 4
· Ring Time = 5
· Custom value 1 = 6
· Custom value 2 = 7
· Internal to Internal = 8
· Internal to Internal ACD = 9
· Supervisor Requests = 10
The second flexible field shows Load Ratio by default. You may change this default to show these other values:
· % Service Level 1 = 1
· % Service Level 2 = 2
· % Service Level 3 = 3
· % Service Level 4 = 4
· % Service Level 5 = 5
· % Service Level 6 = 6
· Load Ratio = 7
· Load - Hold Ratio = 8
Parameters
You specify a range of agents, dates, times, site IDs, and shifts to report on. IC sorts this report by agent, date, queue, and then by interaction type in ascending order.
Report Log Tables |
Interaction Administrator Unique Report Identifier |
IAgentQueueStat |
QUEUE_PERIOD_AGENT_PERF_DETAIL_INTERVAL_NAME |
Sample report
Click on the image below to view a sample of this report.
Report Element |
Report Field or Value |
Field or Value Description |
{none} |
cName |
The agent identifier of the agents. |
Date |
DIntervalStart |
The date or time as specified in the range selection. This could be an interval, hour, day, week, day of week, month or year. |
{none) |
CReportGroup |
The name of the queues for the selected agents. All Queues in the summary information and is represented in the database by an asterisks. |
(none) |
InteractionType |
The type of ACD interaction. Possible values are calls, chats and emails. This information |
Int |
NAnsweredACD |
The number of ACD Interactions that were answered. |
Avg. Talk |
tTalkACD/nAnsweredACD |
The average amount of time spent on the incoming ACD interactions. |
Total Talk |
tTalkACD |
The amount of time spent on the incoming ACD interactions. Note tTalkACD is the time an interaction is active with an agent, including any Hold time with the agent during the interaction. |
Avg ACW |
TACW/nAnsweredACD |
The average amount of time spent on after call work. |
Total ACW |
TACW |
The amount of time spent on after call work. |
Avg Speed Ans |
TAnsweredACD/nAnsweredACD |
The average amount of time the interactions spent alerting before they were answered by the agent. |
Disconnect
|
NLocalDisconnectACD
|
Default Flexible Field - The number of ACD interactions that were disconnected locally. |
Ring Total |
TAlertedACD |
Flexible Field - The amount of time the interactions spent alerting the agent. |
Flow Out
|
NFlowOutACD
|
Flexible Field - The number of items in the queue that were removed before connecting to an agent.
|
Entered
|
NEnteredACD
|
Flexible Field - The number of interactions that entered the queue.
|
Transfer |
NTransferredACD |
Flexible Field - The number of interactions that were transferred while in this queue. |
% Srv Level 1
|
(nAnsweredACDSvcLvl1 / nAnsweredACD) * 100 Levels 1 through 6: The total number of ACD interactions that were answered within the selected service level divided by the total number of ACD interactions that were answered for the specified range. This number is multiplied by 100 to get the percentage. |
Flexible Field – The percentage of interactions that were answered within the first service level. You setup the service level interval in Interaction Administrator. Please keep in mind you setup these service levels for queue expectations, not agents, although IC applies the same service level settings to agents. For example, if IC sends the caller to voice mail or transfers the caller to another available age, there may be no information above % service level 3. |
% Srv Level 2 |
(nAnsweredACDSvcLvl2 / nAnsweredACD) * 100
|
Flexible Field - The percentage of interactions that were answered within the second service level. The default second service level is 20 seconds. |
% Srv Level 3 |
(nAnsweredACDSvcLvl3 / nAnsweredACD) * 100 |
Flexible Field - The percentage of interactions that were answered within the third service level. |
% Srv Level 4 |
(nAnsweredACDSvcLvl4 / nAnsweredACD) * 100 |
Flexible Field - The percentage of interactions that were answered within the fourth service level. |
% Srv Level 5 |
(nAnsweredACDSvcLvl5 / nAnsweredACD) * 100 |
Flexible Field - The percentage of interactions that were answered within the fifth service level. |
% Srv Level 6 |
(nAnsweredACDSvcLvl6 / nAnsweredACD) * 100 |
Flexible Field - The percentage of interactions that were answered within the sixth service level. |
Load Ratio
|
tTalkACD/ tAgentOnACDCall
|
Default Flexible Field - The ratio of total ACD talk time to the amount of time actually worked during the selected interval. This ratio is most meaningful when agents are allowed to take multiple interactions at the same time.
|
Load – Hold |
(tTalkACD – tHoldACD)/(tAgentOnACDCall+tAgentInACW) |
Flexible Field - The ratio of total ACD talk time minus the time the interactions were on hold to the amount of time actually worked during the selected interval. This ratio is most meaningful when agents are allowed to take multiple interactions at the same time. |
Available |
TAgentAvailable |
The total amount of time the agent was in an ACD available state. |
In Ints |
(nExternToInternCalls - nExternToInternAcdCalls) + (nInternToInternCalls}-nInternToInternAcdCalls) |
The number of incoming non-ACD interactions. |
Avg In Talk |
((tExternToInternCalls - tExternToInternAcdCalls) + (tInternToInternCalls}-tInternToInternAcdCalls)) / Incoming Interactions |
The average amount of time spent on incoming non-ACD interactions. |
Total Time In |
(tExternToInternCalls - tExternToInternAcdCalls) + (tInternToInternCalls}-tInternToInternAcdCalls) |
The total amount of time spent on incoming non-ACD interactions |
Out Ints |
NInternToExternCalls - nInternToExternAcdCalls |
The number of outgoing non-ACD interactions. |
Avg Out Talk |
(tInternToExternCalls – tInternToExternAcdCalls) / Outgoing Interactions |
The average amount of time spent on outgoing non-ACD interactions. |
Total Time Out |
tInternToExternCalls – tInternToExternAcdCalls |
The total amount of time spent on outgoing non-ACD interactions. |
Record selection criteria for this report includes:
//Rec Select
{AgentQueueStats.dIntervalStart} in {?DateTime}
and
{@StatusTime} in {?ShiftTime}
and
{AgentQueueStats.cType} = "A"
and
{AgentQueueStats.cName} in {?Agent}
and
{AgentQueueStats.SiteId} in {?SiteId}
//
and
{ALLAgentQueueStats.cReportGroup} ="*"
and
(
if {?ReportNumber}=2 or{?ReportNumber}=4 then
// Following filters out affects of cHKey3 and cHKey4 in IC 2.0
{AgentQueueStats.cReportGroup} <> "-"
and
{AgentQueueStats.cReportGroup} <> "*"
and
( IsNull({AgentQueueStats.cHKey3}) or {AgentQueueStats.cHKey3} = "*" or {AgentQueueStats.cHKey3} = "" )
and
( IsNull({AgentQueueStats.cHKey4}) or {AgentQueueStats.cHKey4} = "*" or {AgentQueueStats.cHKey4} = "" )
Else if {?ReportNumber}=1 then
{AgentQueueStats.cReportGroup} <> "*"
and
( IsNull({AgentQueueStats.cHKey3}) or {AgentQueueStats.cHKey3} = "*" or {AgentQueueStats.cHKey3} = "" )
and
( IsNull({AgentQueueStats.cHKey4}) or {AgentQueueStats.cHKey4} = "*" or {AgentQueueStats.cHKey4} = "" )
Else
(
// Following filters out affects of cHKey3 and cHKey4 in IC 2.0
{AgentQueueStats.cReportGroup} <> "-"
and
{AgentQueueStats.cReportGroup} <> "*"
and
( IsNull({AgentQueueStats.cHKey3}) or {AgentQueueStats.cHKey3} <> "*" or {AgentQueueStats.cHKey3} = "" )
and
( IsNull({AgentQueueStats.cHKey4}) or {AgentQueueStats.cHKey4} <> "*" or {AgentQueueStats.cHKey4} = "" )
)
)
Formulas:
All times are expressed as hh:mm:ss. This formula is used throughout the report to convert seconds to hh:mm:ss. This formula is external to the report file.
Ints = The sum of ACD interactions answered.
Avg Talk = The total agent incoming ACD talk time divided by the number of ACD interactions answered.
Avg Speed Ans = The total amount of time the interactions were alerting the agents divided by the total number of ACD interactions answered.
Avg ACW = The total amount of time the agents spent on after call work divided by the total number of ACD interactions answered.
Srv Levels 1 – 6 = The total number of ACD interactions that were answered within the selected service level divided by the total number of ACD interactions that were answered. This number is then multiplied by 100 to give the percentage.
Load Ratio = The total amount of time an agent spent on ACD related interactions divided by the amount of time the agent was on an ACD interaction. In a multiple interaction environment, an agent’s total talk time can exceed the time of the interval. This ratio is the amount of total talk time during an interval divided by the actual amount of time in the interval the agent spent on ACD related activities. Note: If you use multiple interaction handling, you can be on more than one ACD action at a time. The result can be a load ratio greater than 100%.
Load – Hold = The total amount of time an agent spent on ACD related interactions minus the amount of the ACD interactions that were on hold divided by the amount of time the agent was on an ACD interaction plus the amount of time the agent was in an ACW state. In a multiple interaction environment, an agent’s total talk time can exceed the time of the interval. This ratio is the amount of total talk time during an interval divided by the actual amount of time in the interval the agent spent on ACD related activities.
Disconnect = The sum of the ACD interactions that were disconnected locally.
Flow Out = The sum of the ACD interactions that were removed from the queue that were never answered by an agent.
Entered = The sum of the interactions that entered the ACD queue.
Transfer = The sum of the interactions that were transferred while in this queue.
In Ints = The sum of all incoming interactions minus the incoming ACD interactions.
Avg In Talk = The total amount of time spent on incoming interactions minus the total amount of time spent on incoming ACD interactions all divided by incoming interactions.
Total Time In = The total amount of time spent on incoming interactions minus the total amount of time spent on incoming ACD interactions.
Out Ints = The sum of all outgoing interactions minus the outgoing ACD interactions.
Avg Out Talk = The total amount of time spent on outgoing interactions minus the total amount of time spent on outgoing ACD interactions all divided by Outgoing Interactions.
Total Time Out = The total amount of time spent on outgoing interactions minus the total amount of time spent on outgoing ACD interactions.