Dialogflow CX Bigquery Export Not Working for Conversation Signal

Google Cloud Build with AI Conversational Agents (Dialogflow CX)
1

Hello,

I have been having a problem with exporting Dialogflow cx data to big query. While all the columns are returning, Conversation Signals column is returning null. Is there a way to fix that issue? If you can help out, I would appreciate it.

2

did you create the table with this command?

CREATE TABLE <your_dataset_name>.dialogflow_bigquery_export_data(
  project_id STRING,
  agent_id STRING,
  conversation_name STRING,
  turn_position INTEGER,
  request_time TIMESTAMP,
  language_code STRING,
  request JSON,
  response JSON,
  partial_responses JSON,
  derived_data JSON,
  conversation_signals JSON,
  bot_answer_feedback JSON
);
3

Yes, I did.

4

I think it will be populated only if there are nlu events. here is the JSON Schema of that column:

{
  "noMatch": boolean,
  "noUserInput": boolean,
  "dtmfUsed": boolean,
  "userEscalated": boolean,
  "agentEscalated": boolean,
  "reachedEndPage": boolean,
  "webhookStatuses": [
    string
  ],
  "failureReasons": [
    enum ([FailureReason](https://cloud.google.com/dialogflow/cx/docs/reference/rest/v3/FailureReason)) ], "sentimentScore": number, "sentimentMagnitude": number }

you can find the docs here: https://cloud.google.com/dialogflow/cx/docs/reference/rest/v3/ConversationSignals