One row is
one survey response
Delivery
Rewritten daily
Columns
26
Where it lands
snapshot_date= partition only, and check for _SUCCESS before you do, as
described in bucket layout.
Columns
bigint
Internal warehouse key. Not stable between deliveries — the response is identified by
conversation_id.varchar(36)
Identifier of the workspace the response belongs to.
varchar(256)
Id of the tenant.
NULL for rows with no tenant mapping.varchar(256)
Name of the tenant.
NULL for rows with no tenant mapping.integer
Account the conversation belongs to.
integer
Instance the workspace is served from.
integer
Join key. Conversation the response is about. Joins to
cloud_chat_conversations.bigint
Number shown to agents for that conversation.
timestamp
When the conversation was created.
bigint
Internal warehouse key for the conversation. Use
conversation_id.timestamp
When the customer submitted the response.
integer
The score, from 1 to 5.
varchar(65535)
Free-text comment the customer left. May contain personal data they typed themselves.
varchar(1024)
Tags on the conversation at the time of the response, as a delimited string.
integer
Agent assigned when the survey was answered.
varchar(255)
Name of that agent.
bigint
Inbox of the conversation.
varchar(65535)
Name of that inbox.
bigint
Team of the conversation.
varchar(255)
Name of that team.
integer
Contact who answered. Joins to
cloud_chat_contacts.varchar(255)
Name of that contact. Personal data of your customer.
varchar(255)
Phone number of that contact. Personal data of your customer.
timestamp
When the response record was last modified.
timestamp
When the datamart last wrote this row.
date
Partition column. Date of the delivery that wrote this file, in
YYYY-MM-DD.