Reporting - Historical Table Field Definitions

  • Applies to: Microsoft Teams

This article is for IT pros and Teams Administrators who want to report on the calls handled by Teams Phone Agents, Auto Attendants, and Call Queues.

Planning and licensing review

Planning

Licensing

Historical reports field definitions

Teams Phone Agent Analytics report

Expand to see the TeamsPhoneAgent table field descriptions

in preview - subject to change.

Auto Attendant Analytics report

Expand to see the AutoAttendant table field descriptions
Name Data Type Description
AACallDurationSeconds Whole number Summarized: Sum
Call duration in seconds
AACallDurationSecondsAVG (Measure) Whole number Average call duration in seconds
AACallerActionCounts Whole number Summarized: Sum
Count of actions selected by caller in Auto Attendant during the call
AACallerActionCountsAVG (Measure) Whole number Average of AACallerActionCount - zero instead of blank
AACallFlowString Text Localized - see AutoAttendantCallFlow in Auto Attendant dimensions -> AutoAttendantCallFlow
AACallResultLegendCode Whole number See AutoAttendantCallResult in Auto Attendant dimensions -> AutoAttendantCallResult - converted to numeric codes
AACallResultLegendString Text Localized string for AACallResultLegendCode
English values are:
  • Terminated (No Caller Action) - Call was disconnected - the caller didn't make any selections
  • Terminated (With Caller Action) - Call was disconnected - the caller made selections
  • Terminated (Disconnected) - Call was disconnected per the auto attendant configuration
  • Terminated (No Operator) - Call was disconnected as there was no operator to transfer the call to
  • Terminated (Transfer Failed) - Call was disconnected as the configured transfer failed
  • Transferred (AA) - Call was transferred to another Auto Attendant
  • Transferred (CQ) - Call was transferred to a Call Queue
  • Transferred (Operator) - Call was transferred to the Operator
  • Transferred (Voicemail) - Call was transferred to Shared Voicemail
  • Transferred (External) - Call was transferred to an External Number
  • Transferred (User) - Call was transferred to a Person in the organization
  • Other - Some other condition occurred
AAChainDuration Decimal number Summarized: Sum
Duration of call in Auto Attendant
AAChainDurationAVG (Measure) Decimal number Average of AAChainDuration - zero instead of blank
AAConnectivityTypeCode Whole number See PSTNConnectivityType in Common dimensions -> AutoAttendantCallResult - converted to numeric codes
AAConnectivityTypeString Text Localized string for AAConnectivityTypeCode
English values are:
  • CallingPlan - Calling Plan
  • DirectRouting - Direct Routing
  • TeamsPhoneMobile - Teams Phone Mobile
  • ACS Call - ACS
AADirectorySearchMethodDTMFCOUNT (Measure) Whole number Count of calls that used DTMF to search the directory - zero instead of blank
AADirectorySearchMethodLegendCode Whole number See AutoAttendantDirectorySearchMethod in Auto Attendant dimensions -> AutoAttendantCallResult - converted to numeric codes
AADirectorySearchMethodLegendString Text Localized string for AADirectorySearchMethodLegendCode
English values are:
  • DTMF - Caller used the telephone dial pad to search for the user's name
  • Voice - Caller used voice input to search for the user's name
AADirectorySearchMethodVoiceCOUNT (Measure) Whole number Count of calls that used Voice to search the directory - zero instead of blank
AAGUID Text Auto Attendant unique identifier
AAPSTNMinutes Whole number Summarized: Sum
Total minute usage
AASlicer Text Admins: AAGUID or Resource account username
Auth Users: Auto attendant name
AAStartHourLocal Whole Number Auto Attendant call start hour - Local (based on selected UTC Offset)
AAStartTimeLocal Date/time Auto Attendant call start time - Local (based on selected UTC Offset)
AAStartTimeUTC Date/time Auto Attendant call start time - UTC
AATotalCallCount Whole number Summarized: Sum
Always 1 - used to provide sum of all calls
AATotalCallCountSUM (Measure) Whole number Sum of TotalCallCount
ConferenceID (Per Day only) Text Used for troubleshooting purposes - provide this information when opening a ticket
DialogID (Per Day only) Text Used for troubleshooting purposes - provide this information when opening a ticket
MM-DD Text Auto Attendant call month-day

Cloud Call Queue Analytics report

Expand to see the CallQueue table field descriptions
Name Data Type Description
ConferenceID (Per Call only) Text Used for troubleshooting purposes - provide this information when opening a ticket
CQAgentCount Whole number Summarized: Sum
Number of agents configured in the Call queue
CQAgentOptInCount Whole number Summarized: Sum
Number of agents opted-in to the Call queue
CQCountAbandoned Whole number Summarized: Sum
Number of abandoned calls
CQCallCountAbandonedSUM (Measure) Whole number Call Count Abandoned - zero instead of blank
CQCallDurationSeconds Decimal number Summarized: Sum
Call duration
CQCallDurationSecondsAVG (Measure) Whole number Average Call Duration Seconds
CQCallResultLegendCode Whole number See CallQueueCallResult in Call Queue dimensions -> AutoAttendantCallResult - converted to numeric codes
CQCallResultLegendString Text Localized string for CQCallResultLegendCode
English values are:
  • Abandoned - the caller hung up before an agent could answer or before timeout occurred
  • Agent Answered - the caller was answered by an agent
  • Overflowed - the call overflow exception occurred
  • Timed Out - the call timeout exception occurred
  • No Agents - the no agents exception occurred
  • Other - some other condition occurred
CQCallStartDateLocal Date Call start date - Local (based on selected UTC Offset)
CQCallStartTimeLocal Date/time Call start time - Local (based on selected UTC Offset)
CQCallStartTimeUTC Date/time Call start time - UTC
CQConnectivityTypeCode Whole number See PSTNConnectivityType in Common dimensions -> AutoAttendantCallResult - converted to numeric codes
CQConnectivityTypeString Text Localized string for CQConnectivityTypeCode
English values are:
  • CallingPlan - Calling Plan
  • DirectRouting - Direct Routing
  • TeamsPhoneMobile - Teams Phone Mobile
  • ACS Call - ACS
CQGUID Text Call Queue unique identifier
CQHour Whole number Summarized: Sum
Call queue call start hour
CQPSTNTotalMinutes Decimal number Summarized: Sum
Total minutes usage for PSTN calls
CQRAIdentity Text Name of resource account attached to Call Queue

If the full Resource Account name is cq_test@microsoft.com, then this value is: cq_test
CQSlicer Text Admins: CQGUID or Resource account username
Auth Users: Call queue name
CQTargetTypeLegendCode Whole number See CallQueueTargetType in Call Queue dimensions -> AutoAttendantCallResult - converted to numeric codes
CQTargetTypeLegendString Text Localized string for CQTargetTypeLegendCode
English values are:
  • Abandoned - the caller hung up before an agent could answer or before timeout occurred
  • Agent Answered (Call) - the caller was answered by an agent
  • Agent Answered (Callback) - the callback was answered by an agent
  • Overflowed (Application) - the call overflow exception occurred - call routed to another application
  • Overflowed (Disconnect) - the call overflow exception occurred - call disconnected
  • Overflowed (External) - the call overflow exception occurred - call was transferred externally
  • Overflowed (User) - the call overflow exception occurred - call was transferred to a Person in the organization
  • Overflowed (Voicemail) - the call overflow exception occurred - call was transferred to shared voicemail
  • Timed Out (Application) - the call timeout exception occurred - call routed to another application
  • Timed Out (Disconnect) - the call timeout exception occurred - call was disconnected
  • Timed Out (External) - the call timeout exception occurred - call was transferred externally
  • Timed Out (User) - the call timeout exception occurred - call was transferred to a Person in the organization
  • Timed Out (Voicemail) - the call timeout exception occurred - call was transferred to shared voicemail
  • No Agents (Application) - the no agents exception occurred - call was routed to another application
  • No Agents (Disconnect) - the no agents exception occurred - call was disconnected
  • No Agents (External) - the no agents exception occurred - call was transferred externally
  • No Agents (User) - the no agents exception occurred - call was transferred to a Person in the organization
  • No Agents (Voicemail) - the no agents exception occurred - call was transferred to shared voicemail
CQTotalCallCount Whole number Summarized: Sum
Number of calls
CQTotalCallCountSUM (Measure) Whole number Call Count Sum - zero instead of blank
DateTimeCQName Text Unique key for filtering on fCallQueueFinalStateAction
DialogID (Per Call only) Text Used for troubleshooting purposes - provide this information when opening a ticket
Expand to see the CallQueueFinalStateAction table field descriptions
Name Data Type Description
CQAvgCallDuration Decimal number Summarized: Sum
Average waiting time in seconds
CQAvgCallDurationSeconds Whole Summarized: Sum
Average waiting time in seconds
CQCallResultLegendCode Whole number See CallQueueCallResult in Call Queue dimensions -> AutoAttendantCallResult - converted to numeric codes
CQCallResultLegendString Text Localized string for CQCallResultLegendCode
English values are:
  • Abandoned - the caller hung up before an agent could answer or before timeout occurred
  • Agent Answered (Call) - the caller was answered by an agent
  • Agent Answered (Callback) - the callback was answered by an agent
  • Overflowed (Disconnect) - the call overflow exception occurred - call disconnected
  • Overflowed (Xferred) - the call overflow exception occurred - call was transferred externally
  • Overflowed (Voicemail) - the call overflow exception occurred - call was transferred to shared voicemail
  • Timed Out (Callback) - the callback timed out - callback didn't occur
  • Timed Out (Disconnect) - the call timeout exception occurred - call was disconnected
  • Timed Out (Xferred) - the call timeout exception occurred - call was transferred externally
  • Timed Out (Voicemail) - the call timeout exception occurred - call was transferred to shared voicemail
  • No Agents (Disconnect) - the no agents exception occurred - call was disconnected
  • No Agents (Xferred) - the no agents exception occurred - call was transferred externally
  • No Agents (Voicemail) - the no agents exception occurred - call was transferred to shared voicemail
CQCallStartTimeLocal Date/time Call start time - Local (based on selected UTC Offset)
CQCallStartTimeUTC Date/time Call start time - UTC
CQSlicer Text Admins: CQGUID or Resource account username
Auth Users: Call queue name
CQTotalCallCount Whole number Summarized: Sum
Number of calls
DateTimeCQName Text Unique key for filtering on fCallQueueFinalStateAction

Cloud Call Queue Agent Timeline report

Expand to see the AgentTimeline and AgentTimelineSummary table field descriptions
Name Data Type Description
AgentCallDurationMinutes Decimal number Summarized: Sum
Total call duration of answered Call queue calls in minutes
AgentCallDurationSeconds Decimal number Summarized: Sum
Total call duration of answered Call queue calls in seconds
AgentCallDurationSecondsAVG (Measure) Decimal number Average of AgentCallDurationSeconds
AgentTimelineAnalyticsSummaryLink Text Used to link with fAgentTimelineAnalyticsSummary for the pop-up tooltip
AgentTotalCallCountSUM (Measure) Whole number Total number of calls answered by agent
Call Duration (HH:MM:SS) Text Call Duration (Minutes) converted to HH:MM:SS
ConferenceID Text Used for troubleshooting purposes - provide this information when opening a ticket
CQAgentName Text User UPN
If the full username is user@microsoft.com, then this value is: user
CQCallStartHour Whole number Call start hour
CQCallStartTimeLocal Date/time Call start time - Local (based on selected UTC Offset)
CQCallStartTimeUTC Date/time Call start time - UTC
CQGUID Text Call Queue unique identifier
CQSlicer Text Admins: CQGUID or Resource account username
Auth Users: Call queue name
CQTotalCallCount Whole number Summarized: Sum
Number of calls presented to agent
Date Date Date of call
DateTime Date/time Date of call
DialogID Text Used for troubleshooting purposes - provide this information when opening a ticket
MM-DD Text Call queue call month-day
Expand to see the AgentTimelineSummary table field descriptions
Name Data Type Description
AgentAverageCallDurationSeconds Decimal number Summarized: Sum
The average duration of answered Call queue calls in seconds
AgentAverageCallDurationSeconds_Formatted (Measure) Decimal number The average duration of answered Call queue calls in seconds - zero instead of blank
AgentAverageCalls (Measure) Decimal number The average number of calls answered by the agent
AgentTimelineAnalyticsLink Text Used to link with fAgentTimelineAnalytics for the pop-up tooltip
CQAgentName Text User UPN
If the full username is user@microsoft.com, then this value is: user
CQSlicer Text Admins: CQRAName
Auth Users: CQName
Date Date/time Date of call
Hour Whole number Hour of call
MM-DD Text Month and day of call
Total Call Duration (HH:MM:SS) Text Call Duration (Minutes) converted to HH:MM:SS
TotalCallCountSUM (Measure) Whole number Total number of calls answered by the agent
  • Last updated on