> ## 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_csat

> Workspace-side satisfaction responses, denormalized with the agent, team and inbox that handled the conversation.

Workspace-side satisfaction responses, denormalized with the agent, team and inbox that handled the conversation.

<Columns cols={3}>
  <Card title="One row is">
    one survey response
  </Card>

  <Card title="Delivery">
    Rewritten daily
  </Card>

  <Card title="Columns">
    26
  </Card>
</Columns>

## Where it lands

```text theme={null}
s3://<YOUR_BUCKET>/v1/datamart_cloudchat_saas/cloud_chat_csat/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](/data-export/bucket-layout#how-to-tell-if-a-partition-is-ready).

## Columns

<ResponseField name="csat_sk" type="bigint">
  Internal warehouse key. Not stable between deliveries — the response is identified by `conversation_id`.
</ResponseField>

<ResponseField name="customer_id" type="varchar(36)">
  Identifier of the workspace the response belongs to.
</ResponseField>

<ResponseField name="tenant_id" type="varchar(256)">
  Id of the tenant. `NULL` for rows with no tenant mapping.
</ResponseField>

<ResponseField name="tenant_name" type="varchar(256)">
  Name of the tenant. `NULL` for rows with no tenant mapping.
</ResponseField>

<ResponseField name="account_id" type="integer">
  Account the conversation belongs to.
</ResponseField>

<ResponseField name="instance_id" type="integer">
  Instance the workspace is served from.
</ResponseField>

<ResponseField name="conversation_id" type="integer">
  **Join key.** Conversation the response is about. Joins to [`cloud_chat_conversations`](/data-export/catalog/cloud-chat/cloud_chat_conversations).
</ResponseField>

<ResponseField name="conversation_display_id" type="bigint">
  Number shown to agents for that conversation.
</ResponseField>

<ResponseField name="conversation_created_at" type="timestamp">
  When the conversation was created.
</ResponseField>

<ResponseField name="conversation_sk" type="bigint">
  Internal warehouse key for the conversation. Use `conversation_id`.
</ResponseField>

<ResponseField name="response_submitted_at" type="timestamp">
  When the customer submitted the response.
</ResponseField>

<ResponseField name="csat_value" type="integer">
  The score, from 1 to 5.
</ResponseField>

<ResponseField name="feedback_message" type="varchar(65535)">
  Free-text comment the customer left. May contain personal data they typed themselves.
</ResponseField>

<ResponseField name="tags_list" type="varchar(1024)">
  Tags on the conversation at the time of the response, as a delimited string.
</ResponseField>

<ResponseField name="assigned_agent_id" type="integer">
  Agent assigned when the survey was answered.
</ResponseField>

<ResponseField name="assigned_agent_name" type="varchar(255)">
  Name of that agent.
</ResponseField>

<ResponseField name="inbox_id" type="bigint">
  Inbox of the conversation.
</ResponseField>

<ResponseField name="inbox_name" type="varchar(65535)">
  Name of that inbox.
</ResponseField>

<ResponseField name="team_id" type="bigint">
  Team of the conversation.
</ResponseField>

<ResponseField name="team_name" type="varchar(255)">
  Name of that team.
</ResponseField>

<ResponseField name="contact_id" type="integer">
  Contact who answered. Joins to [`cloud_chat_contacts`](/data-export/catalog/cloud-chat/cloud_chat_contacts).
</ResponseField>

<ResponseField name="contact_name" type="varchar(255)">
  Name of that contact. Personal data of your customer.
</ResponseField>

<ResponseField name="contact_phone_number" type="varchar(255)">
  Phone number of that contact. Personal data of your customer.
</ResponseField>

<ResponseField name="updated_at" type="timestamp">
  When the response record was last modified.
</ResponseField>

<ResponseField name="etl_updated_at" type="timestamp">
  When the datamart last wrote this row.
</ResponseField>

<ResponseField name="snapshot_date" type="date">
  Partition column. Date of the delivery that wrote this file, in `YYYY-MM-DD`.
</ResponseField>