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

# claudia_csat

> Satisfaction scores for ClaudIA conversations, with the raw answer kept alongside the normalized score.

Satisfaction scores for ClaudIA conversations, with the raw answer kept alongside the normalized score.

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

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

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

## Where it lands

```text theme={null}
s3://<YOUR_BUCKET>/v1/datamart_claudia/claudia_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 — join on `csat_id` instead.
</ResponseField>

<ResponseField name="project_name" type="varchar(50)">
  Project the conversation belongs to.
</ResponseField>

<ResponseField name="csat_id" type="varchar(50)">
  **Join key.** Unique id of the survey answer.
</ResponseField>

<ResponseField name="cloudchat_id" type="varchar(510)">
  **Join key.** Conversation the answer belongs to. Matches `cloudchat_id` on [`claudia_conversation`](/data-export/catalog/claudia/claudia_conversation).
</ResponseField>

<ResponseField name="helpdesk_id" type="varchar(50)">
  Identifier of the conversation in whichever helpdesk served it, matching `helpdesk_id` on [`claudia_conversation`](/data-export/catalog/claudia/claudia_conversation).
</ResponseField>

<ResponseField name="csat_raw_value" type="varchar(50)">
  The customer's answer exactly as collected. Survey wording differs per project, which is why the normalized `csat_value` exists.
</ResponseField>

<ResponseField name="csat_value" type="smallint">
  The answer normalized to a 1 to 5 score, comparable across projects.
</ResponseField>

<ResponseField name="creation_date" type="timestamp">
  When the survey was sent.
</ResponseField>

<ResponseField name="comment_text" type="varchar(8000)">
  Free-text comment the customer left with the score.
</ResponseField>

<ResponseField name="collect_date" type="timestamp">
  When the customer answered. The gap from `creation_date` tells you how long they took.
</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="snapshot_date" type="date">
  Partition column. Date of the delivery that wrote this file, in `YYYY-MM-DD`.
</ResponseField>