Export report as XLSX file
Conversation details
This group contains information about the basic details of the communication as well as information about the participants. It includes data such as date, start time, duration, participants and UserID/UserLogin. You are provided with an overview of the structured data contained in the communication recordings and allows you to take a detailed look at the calls and their participants.
![Conversation details XLSX file](../Images/png/2580344715__en-US__Web.png)
Columns XLSX file | Description | |
Conversation ID | Unambiguous ID of the conversation, see Detail view tab Metadata. | |
ConversationType | Assignment of the conversation type, see Conversation type. | |
Header | Header of the conversation, see Detail view tab Metadata. | |
Date | Date when the conversation took place, see Detail view tab Metadata. | |
Start | Start time of the conversation. The time is displayed in 12 hours for AM and PM, see Detail view tab Metadata. | |
Duration | Duration of the conversation. The time format 00:00:00 for hours, minutes, and seconds is used, see Detail view tab Metadata. | |
Participants | Number and user ID of the participants, see Detail view tab Metadata. | |
User Login | Name of the user for whom the recording has been created based on the corresponding recording rule, see Detail view tab Metadata. | |
User ID | Unambiguous ID of the user for whom the recording has been created based on the corresponding recording rule, see Detail view tab Metadata. | |
BotApp ID | Bot cluster that has received the invitation to join this call. | |
hasAudio | Value indicating whether the conversation contains audio. The following system information is displayed:
| |
hasVideo | Value indicating whether the conversation contains video. The following system information is displayed:
| |
hasScreen | Value indicating whether the conversation contains screen content. The following system information is displayed:
| |
size |
Function currently unavailable. The following system information is displayed:
| |
transcript | Value indicating whether a transcript of the conversation is available. The following system information is displayed:
| |
errorMessage | Error description in case of data processing errors, otherwise empty. The following system information is displayed:
|
Conversation details with errors and losses
This group contains the same content as the group Conversation Details; however it contains further information depending in the KPI. In the following, the additional information is listed in connection with the selected KPI.
![Conversation details with errors and losses XLSX file](../Images/png/2580350091__en-US__Web.png)
Additional columns | Description | ||
Not Exported, see Audit logs. | none | ||
Not Imported, see Audit logs. | none | ||
Policy compared, see Analytics reports. | PolicyCompared Hit | Information indicating whether the conversation complied with the policy, see Detail view tab Metadata. The following system information is displayed:
| |
Category compared, see Analytics reports. | CategoryCompared Hit | Information indicating whether the category has been assigned or complied with in the conversation, see Detail view tab Metadata. The following system information is displayed:
|
User and scenario details
This group provides information about the users and scenarios of the conversations. Among those are user IDs, user logins, scenario IDs and group memberships.
![User and scenario details](../Images/png/2580347403__en-US__Web.png)
Columns XLSX file | Description | |
User ID | Unambiguous ID of the recording owner for whom the recording has been created, see Detail view tab Metadata. | |
User Login | User login of the recording owner. | |
Conversation ID | Unambiguous ID of the conversation, see Detail view tab Metadata. | |
BotApp ID | Bot cluster that has received the invitation to join this call. | |
Tenant ID | Unambiguous ID of the tenant, see Detail view tab Metadata. | |
Call ID | Unambiguous ID of the call, see Detail view tab Metadata. | |
Loss Type | Losses and errors. The following system information is displayed:
| |
Recorded | Value indicating whether the conversation has been recorded. The following system information is displayed:
| |
Conversation Type | Assignment of the conversation type, see Conversation type. | |
Header | Name of the meeting in Microsoft Teams; if no name is available labelled as Meeting. For conversations with 2 participants, the Microsoft Teams login name of the participants is displayed. | |
Date | Date when the conversation took place, see Detail view tab Metadata. | |
Start | Start time of the conversation. The time is displayed in 12 hours for AM and PM, see Detail view tab Metadata. | |
Duration | Duration of the conversation. The time format 00:00:00 for hours, minutes, and seconds is used, see Detail view tab Metadata. | |
Error | Detailed description of the loss type, if available. The following system information is displayed:
| |
Participants | Number and user ID of the participants, see Detail view tab Metadata. | |
notes | Notes added in the details view of the conversation, see Detail view tab Notes |
Audit log
This group provides you with information about audit logs and log details that are used to monitor events and activities related to the communication recordings, see Audit events to create an audit log.
![Audit log XLSX file](../Images/png/2580352779__en-US__Web.png)
Columns XLSX file | Description | |
created | Date and time when the audit log was requested. The time is displayed in 12 hours for AM and PM. The date is displayed in the date format TT.MM.YYYY, see Detail view tab Metadata. | |
User Login | User login of the user who requested the audit log, see Detail view tab Metadata. | |
UserId | Unambiguous ID of the user who requested the audit log, see Detail view tab Metadata. | |
type | Type of the audit event, e. g.: event, error, task, etc., see Audit events to create an audit log. | |
name | Name linked with the entry. This may be a task name, and event name or any other identification, see Audit events to create an audit log. | |
title | Title of the audit log, see Detail view tab Metadata. | |
group | Group or category that the audit log belongs to. The following system information is displayed:
| |
text | Short overview of the relevant audit log entries including information about changes as well as date and time of the changes. The time is displayed in 12 hours for AM and PM. | |
IdType | Type of the ID of the resource data set that has been changed. The following system information is displayed:
| |
itemId | ID of the resource data set that has been changed or that is affected. | |
scenarioId | Scenario ID of the call, see Detail view tab Metadata. | |
details | Detailed.js of the resource data set after the change. |