Microsoft Teams has become the global leader in communication platforms, offering powerful collaboration tools for chat, file sharing, and video/voice calls both internally and worldwide. To fully leverage this platform, organizations need deep insights into its usage and performance, which are provided through Call Detail Records (CDRs). While Teams offers native reporting, Expo XT UC Analytics expands on these capabilities by not only enhancing Teams' reporting but also extending analytics across multiple unified communications platforms
Microsoft Teams CDR Fact Tables
Below, we provide several tables with detailed description of the fields available from the Microsoft Teams CDR fact tables. These tables capture various aspects of caller activity, call quality performance, and overall Teams utilization, offering a wealth of information for analysis and optimization.
Common Dimensions and Measurements for Microsoft Teams CDR
| Teams CDR Field Name | Type | Microsoft Teams Field Description |
|---|---|---|
| ConferenceId | Text | GUID - Call identifier |
| Date | DateTime | Date of call (UTC) |
| DialogId | Text | GUID - Call identifier |
| DocumentId | Text | GUID - Call identifier |
| Duration | Whole Number | Duration of call, in seconds |
| EndTime | DateTime | Time call ended (UTC) |
| FirstIsCaller | Boolean | First and Second endpoint classification |
| FirstUPN | Text | The user principal name (UPN) of the first endpoint's user |
| Hour | Text | Hour call started (UTC) |
| Minute | Text | Minute call started (UTC) |
| PSTNCallDuration | Whole Number | Duration of the call in PSTN minutes |
| PSTNCallType | Text | Internal/External - Call is coming from within or outside the tenant |
| PSTNConnectivityType1 | Text | CallingPlan or DirectRouting |
| Second | Text | Second call started (UTC) |
| SecondUPN | Text | The user principal name (UPN) of the second endpoint's user |
| TenantId | Text | Tenant ID |
| Timestamp | DateTime | Time record was written (UTC) |
| UserStartTimeUTC | DateTime | Time call started (UTC) |
Auto Attendant Dimensions for Microsoft Teams CDR
| Teams CDR Field Name | Type | Microsoft Teams Field Description |
|---|---|---|
| AutoAttendantCallFlow | Text | States of Auto Attendant call (e.g., abs_search, announcement) |
| AutoAttendantCallResult | Text | Final call result (e.g., failed_to_establish_media, service_declined) |
| AutoAttendantCallerActionCounts | Whole Number | Number of actions performed by the caller during the Auto Attendant call |
| AutoAttendantChainDurationInSecs | Real Number | Duration of the call in the Auto Attendant in seconds |
| AutoAttendantChainIndex | Whole Number | Chain index for calls involving multiple Auto Attendants |
| AutoAttendantChainStartTime | DateTime | Start time of the Auto Attendant call chain |
| AutoAttendantCount | Whole Number | Number of Auto Attendants involved in the call |
| AutoAttendantDirectorySearchMethod | Text | Method used to search the directory in the Auto Attendant (e.g., DTMF, voice) |
| AutoAttendantIdentity | Text | Resource account URI the call arrived on |
| AutoAttendantTransferAction | Text | Call transfer target type (e.g., AA, CQ, external_pstn) |
| HasAA | Boolean | Indicates if the call involved an Auto Attendant |
Call Queue Dimensions
| Teams CDR Field Name | Type | Microsoft Teams Field Description |
|---|---|---|
| CallQueueAgentCount | Whole Number | Number of agents in the Call queue |
| CallQueueAgentOptInCount | Whole Number | Number of agents opted-in to the Call queue |
| CallQueueCallResult | Text | Final state of the call in the Call queue (e.g., agent_joined_conference) |
| CallQueueDurationSeconds | Real Number | Duration of the call in the Call queue in seconds |
| CallQueueFinalStateAction | Text | Final action taken by the Call queue (e.g., disconnect, forward) |
| CallQueueIdentity | Text | Resource account URI the call arrived on |
| CallQueueTargetType | Text | Call redirection target type (e.g., ApplicationEndpoint, Mailbox) |
| HasCQ | Boolean | Indicates if the call involved a Call queue |
| TransferredFromCallQueueIdentity | Text | Resource account URI of the Call queue the call was transferred from |
Call Quality Dashboard (CQD) Dimensions and Measurements
| Teams CDR Field Name | Type | Microsoft Teams Field Description |
|---|---|---|
| AvgAutoAttendantChainDurationSeconds | Real Number | Average duration of calls in the Auto Attendant chain in seconds |
| AvgCallDuration | Real Number | Average duration of calls |
| AvgCallQueueDurationSeconds | Real Number | Average duration of calls in the Call queue in seconds |
| PSTNTotalMinutes | Real Number | Total minutes used in PSTN calls |
| TotalAudioStreamDuration | Real Number | Total duration of audio streams |
| TotalCallCount | Whole Number | Total number of calls |
By leveraging these CDR fields and the advanced analytical capabilities of Expo XT UC Analytics, organizations can gain a deeper understanding of their Microsoft Teams usage, identify areas for improvement, and make data-driven decisions to enhance their unified communications infrastructure. For more information about the comprehensive analytics available for your entire communication network, including Microsoft Teams, explore the full capabilities of Expo XT UC Analytics for Teams.
