One row is
one agent assignment
Delivery
Rewritten daily
Columns
34
Where it lands
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 row is identified by
conversation_id plus assignment_sequence.Join key. Conversation that was assigned. Joins to
cloud_chat_conversations. Not unique here: one row per assignment.Position of this assignment in the conversation, starting at 1. Filter to
1 for the first handler; the highest value is the last.Whether this assignment happened after an AI agent handed the conversation over. Use it to measure response time only on conversations a person inherited.
When it ended.
NULL while the agent is still assigned, which is why assignment_duration_seconds can be NULL on open conversations.Whether the agent replied at all during the assignment.
false marks assignments that were reassigned before anyone answered.The same interval in minutes. This is the fairest measure of an agent’s response time.
Seconds from the moment the conversation became available to answer to the first reply, in wall-clock time.