One row is
one Cloud Chat conversation
Delivery
Rewritten daily
Columns
64
Where it lands
snapshot_date= partition only, and check for _SUCCESS before you do, as
described in bucket layout.
Columns
Join key. Unique id of the conversation. Every other Cloud Chat table joins back to this column.
Agent assigned when the snapshot was taken. This is the current assignee, not every agent who touched the conversation — for that, use
cloud_chat_conversations_first_reply_metrics.Number shown to agents in the workspace. Use
conversation_id for joins: the display number is only unique within an account.Contact on the customer side. Joins to
cloud_chat_contacts.Join key. Stable identifier of the conversation across systems. Matches
cloudchat_id on claudia_conversation — this is how you connect the agent’s view to the workspace’s view.Identifier of the workspace the conversation belongs to. Each
customer_id maps to exactly one tenant_id, but a tenant can have several.Conversation status as a numeric code stored as text:
0 open, 1 resolved, 2 pending, 3 snoozed. Higher codes appear as the product adds statuses, so prefer resolved_flag for resolution logic rather than comparing to 1.Priority as a numeric code stored as text, ascending. Empty string and
NULL both mean no priority was set — check for both.Tags applied, as a single delimited string, truncated at the column length. Use
cloud_chat_conversations_tags whenever you need to group or filter by tag.The customer’s first message. Differs from
created_at on conversations the workspace started.Minutes to the first reply, counting only the operation’s working hours. Use this one against an SLA — the wall-clock version penalizes overnight arrivals.
Whether the customer came back about the same subject shortly after this conversation was resolved.
The contact’s custom fields, serialized as JSON. Parse on your side, or use the long-format columns on
cloud_chat_conversations_custom_fields.When the datamart last wrote this row. Use it to spot conversations that changed since your previous load.