Agent Answers Analytics Report
The Agent Answers Analytics report helps you understand the impact of the Agent Answers services on an agent's performance. It allows you to compare an agent's handle time when Agent Answers was enabled vs. when Agent Answers was disabled. You can select Agent Answers views to display the data in a monthly report.
Note |
The report is built on the Termination Call Detail table. The report response time can be more than 10 minutes based on the Termination Call Detail table's data size. For this reason, it has to be run as a scheduled report on HDS-DDS when the call volume is less. |
Note |
To improve the query performance, you can create additional indexes on the Termination Call Detail table. Use the following queries to create the index:
Adding the indexes consume additional database space. For this reason, include the space consumed by the new indexes in your overall database size allocation. Create these indexes only on the HDS-DDS from where you run this report.
|
Query: This report data is built from a Database Query.
Views: This report has the following views:
-
Agent Answers Analytics report (Grid view)
-
Agent Answers Analytics Handled Time (Line Chart)
-
Agent Answers Analytics Call Type (Column Chart)
-
Agent Answers Analytics Agent (Column Chart)
Grouping: This report is grouped by DateTime, Agent, Agent Team and Call Type.
Value List: Call Type and Agent Team
Database Schema Tables from which data is retrieved:
-
Person
-
Agent
-
Agent_Team
-
Termination_Call_Details
-
Call_Type
Available Fields in the Agent Answers Analytics Grid View
Available Fields in the Agent Answers Analytics Report
Current fields are those fields that appear by default in a report generated from the stock template. The following current fields are listed in the order (left to right) in which they appear by default in the stock template.
Column (Field) |
Description |
---|---|
Interval |
The date and time of the data for a selected row in the MMM-YYYY format. Derived from: Termination_Call_Details.DateTime |
Team |
The enterprise name of the Agent Team. Derived from Termination_Call_Details.AgentTeamID. |
Agent |
The last name and first name of the agent. This field is a calculated field, derived from Person.LastName + ", " + Person.FirstName. |
Call Type |
The enterprise name of the call type used by calls handled in the selected interval (month).
Derived from: Termination_Call_Details.CallTypeID |
Total contacts handled |
Total number of contacts handled in the selected interval. This is a calculated field derived from: Total Contacts Handled when Agent Answers Services were Enabled + Total Contacts Handled when Agent Answers Services were Disabled. |
Total contacts handled when Agent Answers Services were Disabled |
The total number of contacts handled in the selected interval when the Agent Answers services were disabled. Derived from Termination_Call_Details.AgentAnswersEnabled='N' or Termination_Call_Details.AgentAnswersEnabled is NULL |
Average Handled Time when Agent Answers Services were Disabled |
The average time an agent spent handling calls in the selected interval while the Agent Answers services were disabled. This field is a calculated field, derived from Total Duration (Termination_Call_Details.TalkTime + Termination_Call_Details.HoldTime + Termination_Call_Details.WorkTime) when Agent Answers Services were Disabled/Total Contacts Handled by Agent Answers Service were Disabled. |
Total contacts handled when Agent Answers Services were Enabled |
The total number of contacts handled in the selected interval when the Agent Answers services were enabled. Derived from Termination_Call_Details.AgentAnswersEnabled='Y' |
Average Handled Time when Agent Answers Services were Enabled |
The average time an agent spent handling calls in the selected interval while the Agent Answers services were enabled. This field is a calculated field, derived from Total Duration (Termination_Call_Details.TalkTime + Termination_Call_Details.HoldTime + Termination_Call_Details.WorkTime) when Agent Answers Services were Enabled/Total Contacts Handled when Agent Answers Services were Enabled. |
Available Fields in the Agent Answers Analytics Grid View
Available Fields in the Agent Answers Analytics Report
Current fields are those fields that appear by default in a report generated from the stock template. The following current fields are listed in the order (left to right) in which they appear by default in the stock template.
Column (Field) |
Description |
---|---|
Interval |
The date and time of the data for a selected row in the MMM-YYYY format. Derived from: Termination_Call_Details.DateTime |
Team |
The enterprise name of the Agent Team. Derived from Termination_Call_Details.AgentTeamID. |
Agent |
The last name and first name of the agent. This field is a calculated field, derived from Person.LastName + ", " + Person.FirstName. |
Call Type |
The enterprise name of the call type used by calls handled in the selected interval (month).
Derived from: Termination_Call_Details.CallTypeID |
Total contacts handled |
Total number of contacts handled in the selected interval. This is a calculated field derived from: Total Contacts Handled when Agent Answers Services were Enabled + Total Contacts Handled when Agent Answers Services were Disabled. |
Total contacts handled when Agent Answers Services were Disabled |
The total number of contacts handled in the selected interval when the Agent Answers services were disabled. Derived from Termination_Call_Details.AgentAnswersEnabled='N' or Termination_Call_Details.AgentAnswersEnabled is NULL |
Average Handled Time when Agent Answers Services were Disabled |
The average time an agent spent handling calls in the selected interval while the Agent Answers services were disabled. This field is a calculated field, derived from Total Duration (Termination_Call_Details.TalkTime + Termination_Call_Details.HoldTime + Termination_Call_Details.WorkTime) when Agent Answers Services were Disabled/Total Contacts Handled by Agent Answers Service were Disabled. |
Total contacts handled when Agent Answers Services were Enabled |
The total number of contacts handled in the selected interval when the Agent Answers services were enabled. Derived from Termination_Call_Details.AgentAnswersEnabled='Y' |
Average Handled Time when Agent Answers Services were Enabled |
The average time an agent spent handling calls in the selected interval while the Agent Answers services were enabled. This field is a calculated field, derived from Total Duration (Termination_Call_Details.TalkTime + Termination_Call_Details.HoldTime + Termination_Call_Details.WorkTime) when Agent Answers Services were Enabled/Total Contacts Handled when Agent Answers Services were Enabled. |