Changelog:
- New field
startTimestamp - Deprecated field
updateTimestampUtc
Find the column definitions in the following table.
| Name | Type | Definition |
|---|---|---|
| conversationName | STRING | Name of the conversation resource. |
| audioFileUri | STRING | Location of the audio file on Google Cloud Storage. |
| dialogflowConversationProfileId | STRING | The Dialogflow conversation profile ID of this conversation. |
| startTimestampUtc | INTEGER | The time in seconds at which the conversation started. |
| startTimestamp | TIMESTAMP | The time at which the conversation started. |
| loadTimestampUtc | INTEGER | The time in seconds at which the conversation was loaded into Insights. |
| analysisTimestampUtc | INTEGER | The time in seconds at which the most recent analysis was performed. |
| conversationUpdateTimestampUtc | INTEGER | The time in seconds at which the conversation was last updated. |
| year | INTEGER | Year date part of loadTimestampUtc. |
| month | INTEGER | Month date part of loadTimestampUtc. |
| day | INTEGER | Day date part of loadTimestampUtc. |
| durationNanos | INTEGER | Conversation duration in nanoseconds. |
| silenceNanos | INTEGER | Number of nanoseconds calculated to be in silence. |
| silencePercentage | FLOAT | Percentage of the total conversation spent in silence. |
| agentSpeakingPercentage | FLOAT | Percentage of the conversation with the agent speaking. |
| clientSpeakingPercentage | FLOAT | Percentage of the conversation with the client speaking. |
| agentSentimentScore | FLOAT | Agent sentiment score between -1.0 (negative) and 1.0 (positive). |
| agentSentimentMagnitude | FLOAT | A non-negative number from zero to infinity that represents the absolute magnitude of the agent sentiment regardless of score. |
| clientSentimentScore | FLOAT | Client sentiment score between -1.0 (negative) and 1.0 (positive). |
| clientSentimentMagnitude | FLOAT | A non-negative number from zero to infinity that represents the absolute magnitude of client sentiment regardless of score. |
| transcript | STRING | The complete text transcript of the conversation. |
| turnCount | INTEGER | The number of turns taken in the conversation. |
| languageCode | STRING | Language code of the conversation. |
| medium | STRING | Medium of the conversation. |
| issues | REPEATED RECORD | The list of all issues of the conversation. |
| issues.name | STRING | The name of the issue. |
| issues.score | FLOAT | Score indicating the likelihood of the issue assignment, between 0 and 1.0. |
| issues.issueModelId | STRING | ID of the issue model that generated the issue assignment. |
| issues.issueId | STRING | ID of the assigned issue. |
| entities | REPEATED RECORD | The list of all spoken entities. |
| entities.name | STRING | Name of the entity. |
| entities.type | STRING | Type of the entity. |
| entities.sentimentScore | FLOAT | The entity sentiment score between -1.0 (negative) and 1.0 (positive). |
| entities.sentimentMagnitude | FLOAT | A non-negative number from zero to infinity that represents the absolute magnitude of the entity sentiment regardless of score. |
| entities.salience | FLOAT | Salience score of the entity. |
| entities.speakerTag | INTEGER | The speaker that the entity mention originated from. |
| labels | REPEATED RECORD | The list of all user-provided labels. |
| labels.key | STRING | User-provided label key. |
| labels.value | STRING | User-provided label value. |
| words | REPEATED RECORD | The list of all spoken words. |
| words.word | STRING | The transcribed word. |
| words.startOffsetNanos | INTEGER | Time offset in nanoseconds of the start of this word relative to the beginning of the conversation. |
| words.endOffsetNanos | INTEGER | Time offset in nanoseconds of the end of this word relative to the beginning of the conversation. |
| words.speakerTag | INTEGER | The speaker that the word originated from. |
| words.languageCode | STRING | Language code. |
| sentences | REPEATED RECORD | The list of conversation sentences. |
| sentences.sentence | STRING | The transcribed sentence. |
| sentences.sentimentScore | FLOAT | The sentence sentiment score between -1.0 (negative) and 1.0 (positive). |
| sentences.sentimentMagnitude | FLOAT | A non-negative number from zero to infinity that represents the absolute magnitude of the sentence sentiment regardless of score. |
| sentences.speakerTag | INTEGER | The speaker that the sentence originated from. |
| sentences.languageCode | STRING | Language code. |
| sentences.startOffsetNanos | INTEGER | Time offset in nanoseconds of the start of this sentence relative to the beginning of the conversation. |
| sentences.endOffsetNanos | INTEGER | Time offset in nanoseconds of the end of this sentence relative to the beginning of the conversation. |
| sentences.createTimeNanos | INTEGER | Time in nanoseconds that the conversation message took place, if provided. |
| sentences.participantId | STRING | Participant ID, if provided. |
| sentences.participantRole | STRING | Participant role, if provided. |
| sentences.obfuscatedExternalUserId | STRING | Obfuscated external user ID, if provided. |
| sentences.isCoveredBySmartReplyAllowlist | BOOL | Whether the sentence is covered by a configured smart reply allowlist in Agent Assist. |
| sentences.annotations | REPEATED RECORD | The list of annotations from Dialogflow Runtime Integration. See full list. |
| sentences.annotations.annotationRecord | JSON | The annotation record returned from Dialogflow. |
| sentences.annotations.createTimeNanos | INTEGER | The timestamp when the suggestion was generated. |
| sentences.annotations.type | STRING | The type of suggestion. |
| sentences.annotations.clicked | BOOL | Customer feedback on whether the suggestion was clicked. |
| sentences.annotations.correctnessLevel | STRING | Customer feedback on the correctness level of the suggestion. |
| sentences.annotations.displayed | BOOL | Customer feedback on whether the suggestion was displayed. |
| sentences.annotations.detailedFeedback | JSON | The detailed feedback content returned from Dialogflow. |
| sentences.annotations.userInput | JSON | The explicit user input used to generate this annotation. |
| sentences.intentMatchData | REPEATED RECORD | The list of matched intents for the sentence. |
| sentences.intentMatchData.intentId | STRING | The unique ID of the matched intent. |
| sentences.intentMatchData.displayName | STRING | The human readable name of the matched intent. |
| sentences.phraseMatchData | REPEATED RECORD | The list of phrase match data for the sentence. |
| sentences.phraseMatchData.phraseMatcherId | STRING | The unique ID of the phrase matcher. |
| sentences.phraseMatchData.revisionId | STRING | Indicating the revision of the phrase matcher. |
| sentences.phraseMatchData.displayName | STRING | The human readable name of the phrase matcher. |
| sentences.highlightData | REPEATED RECORD | The list of highlighter data for the sentence. |
| sentences.highlightData.highlighterName | STRING | The unique id of the highlighter. |
| sentences.highlightData.displayName | STRING | The human readable name of the highlighter. |
| sentences.highlightData.type | STRING | The type of the highlighter. |
| sentences.dialogflowIntentMatchData | REPEATED RECORD | The list of Dialogflow intent match data for the sentence. |
| sentences.dialogflowIntentMatchData.intentName | STRING | The resource name of the matched intent. |
| sentences.dialogflowIntentMatchData.displayName | STRING | The human readable name of the matched intent. |
| sentences.dialogflowIntentMatchData.maxConfidence | FLOAT | The confidence score for the intent match, between 0 and 1.0. |
| latestSummary | RECORD | The latest conversation summary. |
| latestSummary.text | STRING | The summarization content that is concatenated into one string. |
| latestSummary.textSections | REPEATED RECORD | The summarization content that is divided into sections. The key is the section's name and the value is the section's content. There is no specific format for the key or value. |
| latestSummary.textSections.key | STRING | The name of the section. |
| latestSummary.textSections.value | STRING | The content of the section. |
| latestSummary.confidence | FLOAT | The confidence score of the summarization. |
| latestSummary.metadata | REPEATED RECORD | A map that contains metadata about the summarization and the document from which it originates. |
| latestSummary.metadata.key | STRING | The key of the metadata. |
| latestSummary.metadata.value | STRING | The value of the metadata. |
| latestSummary.answerRecord | STRING | The name of the answer record. Format: projects/{project}/locations/{location}/answerRecords/{answer_record} |
| latestSummary.conversationModel | STRING | The name of the model that generates this summary. Format: projects/{project}/locations/{location}/conversationModels/{conversation_model} |
| qaScorecardResults | REPEATED RECORD | All QaScorecardResult(s) available for the conversation. |
| qaScorecardResults.qaScorecard | STRING | Fully qualified resource name of the scorecard. Format: projects/{project}/locations/{location}/qaScorecards/{qa_scorecard_id} |
| qaScorecardResults.qaScorecardRevision | STRING | Fully qualified resource name of the scorecard revision. Format: projects/{project}/locations/{location}/qaScorecards/{qa_scorecard_id}/revisions/{revision_id} |
| qaScorecardResults.qaScorecardResult | STRING | Fully qualified resource name of the scorecard result. Format: projects/{project}/locations/{location}/qaScorecards/{qa_scorecard_id}/revisions/{revision_id}/results/{result_id} |
| qaScorecardResults.score | FLOAT | The score assigned to the conversation. |
| qaScorecardResults.potentialScore | FLOAT | The potential score assigned to the conversation. |
| qaScorecardResults.normalizedScore | FLOAT | Normalized score assigned for the conversation. |
| qaScorecardResults.qaTagResults | REPEATED RECORD | |
| qaScorecardResults.qaTagResults.tag | STRING | The tag assigned to question(s) in the scorecard. |
| qaScorecardResults.qaTagResults.score | FLOAT | The score assigned to the tag for this conversation. |
| qaScorecardResults.qaTagResults.potentialScore | FLOAT | The potential score assigned to the tag for this conversation. |
| qaScorecardResults.qaTagResults.normalizedScore | FLOAT | Normalized score for the given tag for this conversation. |
| qaScorecardResults.qaAnswers | REPEATED RECORD | The answers to the questions in the scorecard. |
| qaScorecardResults.qaAnswers.qaQuestion | RECORD | A QaQuestion corresponding to the given QaAnswer. |
| qaScorecardResults.qaAnswers.qaQuestion.qaQuestion | STRING | Resource name of the question. Format: projects/{project}/locations/{location}/qaScorecards/{qa_scorecard_id}/revisions/{revision_id}/qaQuestions/{qa_question_id} |
| qaScorecardResults.qaAnswers.qaQuestion.questionBody | STRING | Question text. For examlpe, "Did the agent greet the customer?" |
| qaScorecardResults.qaAnswers.qaAnswerStringValue | STRING | |
| qaScorecardResults.qaAnswers.qaAnswerNumericValue | FLOAT | |
| qaScorecardResults.qaAnswers.qaAnswerBoolValue | BOOL | |
| qaScorecardResults.qaAnswers.qaAnswerNaValue | BOOL | |
| qaScorecardResults.qaAnswers.score | FLOAT | The score assigned to the answer. |
| qaScorecardResults.qaAnswers.potentialScore | FLOAT | The potential score assigned to the answer. |
| qaScorecardResults.qaAnswers.normalizedScore | FLOAT | The normalized score assigned to the answer. |
| qaScorecardResults.qaAnswers.tags | REPEATED STRING | User defined list of arbitrary tags. |
| agents | REPEATED RECORD | Metadata about the agent dimension. |
| agents.agentId | STRING | A user-specified string representing the agent. This field replaces the agent_id field in the older export versions. |
| agents.agentDisplayName | STRING | The agent's name |
| agents.agentTeam | STRING | A user-specified string representing the agent's team. |