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.

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: 1 = yes 0 = no
	hasVideo	Value indicating whether the conversation contains video. The following system information is displayed: 1 = yes 0 = no
	hasScreen	Value indicating whether the conversation contains screen content. The following system information is displayed: 1 = yes 0 = no
	size	Function currently unavailable. The following system information is displayed: 0
	transcript	Value indicating whether a transcript of the conversation is available. The following system information is displayed: 1 = yes 0 = no
	errorMessage	Error description in case of data processing errors, otherwise empty. The following system information is displayed: No transcript but user with transcript rule! Audio stream not processed. Total Loss with no metadata Conversation awaiting transcript

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.

KPI		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: true = yes false = no
	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: true = yes false = no

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.

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: No = no error TotalLoss AudioLoss NoTranscript OtherUser OnlySilence
	Recorded	Value indicating whether the conversation has been recorded. The following system information is displayed: Yes Error = no
	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: No transcript but user with transcript rule! Audio stream not processed. Total Loss with no metadata
	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.

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: Recording User Analysis
	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: ConversationId User ID GroupId
	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.