> ## Documentation Index
> Fetch the complete documentation index at: https://docs.cloudhumans.com/llms.txt
> Use this file to discover all available pages before exploring further.

# cloud_chat_agent_metrics

> The headline support metrics for a single agent on a single day. Every duration is a sum, not an average — divide by the matching count column to get an average.

The headline support metrics for a single agent on a single day. Every duration is a sum, not an average — divide by the matching count column to get an average.

> [card] One row is
>
> one agent, one day

> [card] Delivery
>
> Rewritten daily

> [card] Columns
>
> 25

## Where it lands

```text theme={null}
s3://<YOUR_BUCKET>/v1/datamart_cloudchat_saas/cloud_chat_agent_metrics/snapshot_date=<DATE>/
```

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](https://docs.cloudhumans.com/data-export/bucket-layout.md#how-to-tell-if-a-partition-is-ready).

## Columns

**cloud\_chat\_agent\_metrics\_sk** `bigint`

Internal warehouse key. Not stable between deliveries — the row is identified by `agent_id` plus `metric_date`.

**customer\_id** `varchar(36)`

Identifier of the workspace the agent belongs to.

**tenant\_id** `varchar(256)`

Id of the tenant. `NULL` for rows with no tenant mapping.

**tenant\_name** `varchar(256)`

Name of the tenant. `NULL` for rows with no tenant mapping.

**agent\_id** `bigint`

**Join key.** The agent. Matches `assignee_id` on [`cloud_chat_conversations`](https://docs.cloudhumans.com/data-export/catalog/cloud-chat/cloud_chat_conversations).

**agent\_name** `varchar(255)`

Name of the agent.

**metric\_date** `date`

The day the metrics cover, in the operation's local calendar. Together with `agent_id` this is the grain of the table.

**tickets\_created\_assigned** `bigint`

Conversations created that day and assigned to this agent.

**tickets\_resolved\_assigned** `bigint`

Conversations this agent resolved that day. Not a subset of `tickets_created_assigned`: a conversation can be created one day and resolved the next.

**sum\_minutes\_to\_solve** `double precision`

Total wall-clock minutes to resolution across `tickets_resolved_assigned`. Divide by that count for an average.

**sum\_working\_minutes\_to\_solve** `double precision`

The same total, counting only working hours.

**sum\_minutes\_in\_service** `double precision`

Total minutes conversations were actively handled.

**sum\_working\_minutes\_in\_service** `double precision`

The same total, within working hours.

**sum\_minutes\_waiting** `double precision`

Total minutes customers spent waiting on this agent.

**sum\_working\_minutes\_waiting** `double precision`

The same total, within working hours.

**tickets\_resolved\_with\_recontact\_24h** `bigint`

Of the conversations resolved that day, how many the customer came back about within 24 hours. A resolution quality signal.

**csat\_responses** `bigint`

Survey responses received on this agent's conversations.

**csat\_positive\_responses** `bigint`

How many of those were positive. Divide by `csat_responses` for a satisfaction rate.

**first\_reply\_tickets\_count** `bigint`

Conversations where this agent sent the first reply. The denominator for `sum_first_reply_minutes`.

**sum\_first\_reply\_minutes** `numeric`

Total minutes to first reply across those conversations.

**first\_reply\_after\_handoff\_tickets\_count** `bigint`

Conversations where this agent sent the first reply after an AI agent handed the conversation over.

**sum\_first\_reply\_after\_handoff\_minutes** `numeric`

Total minutes to first reply on those conversations.

**sum\_working\_first\_reply\_after\_handoff\_minutes** `numeric`

The same total, within working hours.

**etl\_updated\_at** `timestamp`

When the datamart last wrote this row.

**snapshot\_date** `date`

Partition column. Date of the delivery that wrote this file, in `YYYY-MM-DD`.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.