# Mailchimp: Campaign Recipients

## Description

* Each record represents the send of a campaign email, enriched with click, open and unsubscribe metrics.

## Supported Data Sources

* <img src="https://fivetran.com/integrations/mailchimp/resources/mailchimp.svg" alt="" data-size="line"> Mailchimp

## Columns

| Type     | Name                    | Description                                                                                                                                                                                                          |
| -------- | ----------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| STRING   | campaign\_id            | The ID of the campaign a sent email is from.                                                                                                                                                                         |
| STRING   | member\_id              | The ID of the member an email was sent to.                                                                                                                                                                           |
| INTEGER  | combination\_id         | The ID of the combination the member was part of for a campaign.                                                                                                                                                     |
| STRING   | list\_id                | The ID of the list the campaign was sent to.                                                                                                                                                                         |
| STRING   | email\_id               | The ID of the email sent. Surrogate key generated in dbt from 'campaign\_id' and 'member\_id'.                                                                                                                       |
| INTEGER  | segment\_id             | The ID of the segment the campaign was sent to.                                                                                                                                                                      |
| DATETIME | send\_timestamp         | The date and time a campaign was sent.                                                                                                                                                                               |
| INTEGER  | opens                   | The number of open events from campaign emails. The same email being opened multiple times is included in this metric.                                                                                               |
| INTEGER  | unique\_opens           | The unique number of emails opened from campaign emails. If a given email to a user was opened multiple times, it will only count once in this metric.This is the metric for opens that is reported by Mailchimp.    |
| INTEGER  | clicks                  | The number of click events from campaign emails. The same email being clicked multiple times is included in this metric.                                                                                             |
| INTEGER  | unique\_clicks          | The unique number of emails clicked from campaign emails. If a given email to a user was clicked multiple times, it will only count once in this metric.This is the metric for clicks that is reported by Mailchimp. |
| BOOLEAN  | was\_opened             | Whether the email sent was opened.                                                                                                                                                                                   |
| BOOLEAN  | was\_clicked            | Whether the email sent was clicked.                                                                                                                                                                                  |
| DATETIME | first\_open\_timestamp  | The timestamp of the first open for an email.                                                                                                                                                                        |
| INTEGER  | time\_to\_open\_minutes | The time from send to open in minutes.                                                                                                                                                                               |
| INTEGER  | time\_to\_open\_hours   | The time from send to open in hours.                                                                                                                                                                                 |
| INTEGER  | time\_to\_open\_days    | The time from send to open in days.                                                                                                                                                                                  |
| BOOLEAN  | was\_unsubscribed       | Whether the user unsubscribed via the sent email.                                                                                                                                                                    |


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://endash-guidance-docs.gitbook.io/cigro-data-templates/data-model-templates/mailchimp-campaign-recipients.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.