The output schema and column definitions can be found in the table below.
| Name | Type | Definition |
|---|---|---|
| conversationName | STRING | Name of the conversation resource. |
| audioFileUri | STRING | Location of the audio file on Google Cloud Storage. |
| languageCode | STRING | Language code of the conversation. |
| medium | STRING | Medium of the conversation. |
| agentId | STRING | The user-provided identifier for the agent who handled the conversation. |
| startTimestampUtc | INTEGER | The time in seconds at which the conversation started. |
| loadTimestampUtc | INTEGER | The time in seconds at which the conversation was loaded into Insights. |
| 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 abolute 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 abolute 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. |
| issues | REPEATED RECORD | The list of all issues. |
| issues.name | STRING | The name of the issue. |
| issues.score | DOUBLE | Score indicating the likelihood of the issue assignment, between 0 and 1.0. |
| 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 abolute 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 user-provided metadata. |
| labels.key | STRING | User-provided metadata key. |
| labels.value | STRING | User-provided metadata 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 abolute 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.record | STRING | The suggestion content returned from CCAI, serialised as JSON. |
| 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.intentMatchData | REPEATED RECORD | The list of matched intents. |
| sentences.intentMatchData.intentId | STRING | Unique id of the intent. |
| sentences.intentMatchData.displayName | STRING | Name of the intent. |
| sentences.intentMatchData.maxConfidence | FLOAT | The confidence score for the intent match, between 0 and 1.0. |
| sentences.phraseMatchData | REPEATED RECORD | The list of custom phrase match data. |
| sentences.phraseMatchData.phraseMatcherId | STRING | Unique id of the custom phrase matcher. |
| sentences.phraseMatchData.revisionId | STRING | Unique id of a revision of the custom phrase matcher. |
| sentences.phraseMatchData.displayName | STRING | Name of the custom phrase matcher. |
| sentences.dialogflowIntentMatchData | REPEATED RECORD | The list of matched Dialogflow intents. |
| sentences.dialogflowIntentMatchData.intentName | STRING | The resource name of the intent in Dialogflow. |
| sentences.dialogflowIntentMatchData.displayName | STRING | Name of the intent. |
| sentences.dialogflowIntentMatchData.maxConfidence | FLOAT | The maximum confidence score for the intent match, between 0 and 1.0. |