> For the complete documentation index, see [llms.txt](https://docs.askyazi.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.askyazi.com/integrations-and-api/data-enrichment.md).

# Data enrichment

Upload information you already hold about participants and join it to their study responses for filtering, charts and cross-tabs.

Data enrichment adds information you already have about your participants (for example region, customer tier or a screener answer) to their study responses. You upload a spreadsheet, Yazi matches each row to a participant by phone number, and the extra columns appear next to their answers. This keeps your study shorter, because you do not have to ask what you already know.

{% hint style="info" %}
**In short:**

* Upload a CSV or Excel file from **Responses > Table Data > Data Actions > Enrich Data**. It must have a phone number column.
* Every other column becomes an extra field in Table Data and your exports, and a chart and cross-tab option in Graph Data.
* Uploaded data stays with your team: it never appears on share links and is never sent to the AI.
  {% endhint %}

## When to use it

| Situation            | What you upload                            | What you gain                                      |
| -------------------- | ------------------------------------------ | -------------------------------------------------- |
| Recruitment screener | Age, gender, region, segment or quota cell | Analyse by group without asking again in the study |
| Customer research    | Customer tier, tenure, product held        | Compare satisfaction across customer value         |
| Panel study          | Panel ID, profile data                     | Reconcile panel records and incentives             |
| Repeat wave          | Key answers from an earlier wave           | Compare individual change over time                |
| Quota tracking       | The quota cell each person belongs to      | Chart completes per cell in Graph Data             |

## Prepare your file

* **Format**: CSV or Excel. The first row holds the column headings.
* **Phone number column (required)**: a column of phone numbers with a clear heading, such as `phone`. This is how rows are matched to participants.
* **Country code included**: write numbers in full international form, the same way they appear in the study, for example `+27821234567`. A number written locally (starting with 0) will not match.
* **Other columns**: every other column is imported as a field. The column heading becomes the field name, so use clear headings such as `region` or `customer_tier`.

| phone         | region  | customer\_tier |
| ------------- | ------- | -------------- |
| +27821234567  | Gauteng | Premium        |
| +254712345678 | Nairobi | Standard       |

## Upload the file

{% stepper %}
{% step %}

### Open Table Data

Go to the study's **Responses > Table Data**.
{% endstep %}

{% step %}

### Choose Data Actions > Enrich Data

Click **Data Actions**, then **Enrich Data**.
{% endstep %}

{% step %}

### Upload your file

Drag the file onto the upload box or choose it, then follow the steps on screen.
{% endstep %}

{% step %}

### Check the new columns

The uploaded fields appear as extra columns in Table Data. Spot-check a few participants to confirm they matched.
{% endstep %}
{% endstepper %}

## Use the data

* **Table Data**: filter and search on the new columns. They are included in CSV, Excel and SPSS exports, and in Google Sheets and Excel syncs.
* **Graph Data**: each uploaded column gets its own chart, and you can use it as the break-by question in a cross-tab. This works on surveys and AI interviews. Columns where nearly every value is different (such as names or email addresses) are skipped, because a chart of them would be meaningless.
* **Quota tracking**: upload each participant's quota cell to see completes per cell. For caps that screen people out during fieldwork, use [Quotas](https://docs.askyazi.com/build-a-study/quotas.md).

## Enrichment versus other ways to bring in data

| Method                                | Use it when                                                                                                                                                                                               |
| ------------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Enrich Data** (this page)           | You want to add fields to people who are already in a study, for analysis.                                                                                                                                |
| **People** import with custom columns | You want the fields stored on the contact, before you invite them. See [People and contacts](https://docs.askyazi.com/reach-participants/people-and-contacts.md).                                         |
| **Transaction ID** in a study link    | You need to carry one identifier (such as a panel respondent ID) in through a link. Only one value can be passed this way. See [Study links](https://docs.askyazi.com/reach-participants/study-links.md). |

## Limits and things to know

* **Phone number is the only matching key.** If someone took part from a different number than the one in your file, they will not match.
* **Per study.** Enrichment applies to the study you upload it to. It does not carry across to other studies.
* **No automatic refresh.** If your source data changes, upload the file again.
* **Only people who took part.** You can only enrich participants who are in the study. Data about people who never took part cannot be added to the study's results.
* **Researcher-only.** Uploaded fields never appear on share links, are never sent to the AI for analysis, and are never used in AI-written reports or themes.
* **Privacy-protected studies and WhatsApp usernames.** Matching relies on phone numbers. If your study uses Privacy Protection, or some participants join with a WhatsApp username instead of a visible number, contact support before you rely on enrichment.
* **Your data, your basis.** Uploading customer data into a study is processing personal data. Make sure you have a lawful basis and that participants were told how their data is used. See [Participant privacy](https://docs.askyazi.com/security-and-privacy/participant-privacy.md).

## Related

* [Table Data](https://docs.askyazi.com/results-and-reporting/table-data.md)
* [Graph Data and cross-tabs](https://docs.askyazi.com/results-and-reporting/graph-data-and-cross-tabs.md)
* [People and contacts](https://docs.askyazi.com/reach-participants/people-and-contacts.md)
* [Quotas](https://docs.askyazi.com/build-a-study/quotas.md)
