One row is
one agent, one day
Delivery
Rewritten daily
Columns
25
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
agent_id plus metric_date.Join key. The agent. Matches
assignee_id on cloud_chat_conversations.The day the metrics cover, in the operation’s local calendar. Together with
agent_id this is the grain of the table.Conversations this agent resolved that day. Not a subset of
tickets_created_assigned: a conversation can be created one day and resolved the next.Total wall-clock minutes to resolution across
tickets_resolved_assigned. Divide by that count for an average.Of the conversations resolved that day, how many the customer came back about within 24 hours. A resolution quality signal.
Conversations where this agent sent the first reply. The denominator for
sum_first_reply_minutes.Conversations where this agent sent the first reply after an AI agent handed the conversation over.