One row is
one CSAT answer
Delivery
Rewritten daily
Columns
13
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 — join on
csat_id instead.varchar(50)
Project the conversation belongs to.
varchar(50)
Join key. Unique id of the survey answer.
varchar(510)
Join key. Conversation the answer belongs to. Matches
cloudchat_id on claudia_conversation.varchar(50)
Identifier of the conversation in whichever helpdesk served it, matching
helpdesk_id on claudia_conversation.varchar(50)
The customer’s answer exactly as collected. Survey wording differs per project, which is why the normalized
csat_value exists.smallint
The answer normalized to a 1 to 5 score, comparable across projects.
timestamp
When the survey was sent.
varchar(8000)
Free-text comment the customer left with the score.
timestamp
When the customer answered. The gap from
creation_date tells you how long they took.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.date
Partition column. Date of the delivery that wrote this file, in
YYYY-MM-DD.