Dialogflow CX Bigquery Export Not Working for Conv...

swimmerART

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.

xavidop

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
);

swimmerART

Yes, I did.

xavidop

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) ], "sentimentScore": number, "sentimentMagnitude": number }

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

Dialogflow CX Bigquery Export Not Working for Conversation Signal