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 Cloud Storage. |
|
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 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. |
|
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.record
|
STRING | The annotation record returned from Dialogflow, serialized 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 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. |
