Workspace-side satisfaction responses, denormalized with the agent, team and inbox that handled the conversation.
One row is
one survey response
Where it lands
The partition delivered today holds the whole table. Read the latest
snapshot_date= partition only, and check for _SUCCESS before you do, as
described in bucket layout.
Columns
Internal warehouse key. Not stable between deliveries — the response is identified by conversation_id.
Identifier of the workspace the response belongs to.
Id of the tenant. NULL for rows with no tenant mapping.
Name of the tenant. NULL for rows with no tenant mapping.
Account the conversation belongs to.
Instance the workspace is served from.
Number shown to agents for that conversation.
When the conversation was created.
Internal warehouse key for the conversation. Use conversation_id.
When the customer submitted the response.
Free-text comment the customer left. May contain personal data they typed themselves.
Tags on the conversation at the time of the response, as a delimited string.
Agent assigned when the survey was answered.
Inbox of the conversation.
Team of the conversation.
Name of that contact. Personal data of your customer.
Phone number of that contact. Personal data of your customer.
When the response record was last modified.
When the datamart last wrote this row.
Partition column. Date of the delivery that wrote this file, in YYYY-MM-DD.