BigQuery schema data dictionary

The current 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.