# Mailchimp: Members

## Description

* Each record represents a member in Mailchimp, enriched with campaign metrics and (optionally) automation metrics.

## Supported Data Sources

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

## Columns

| Type     | Name                       | Description                                                                                                                                                                                                            |
| -------- | -------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| STRING   | member\_id                 | The ID of the member.                                                                                                                                                                                                  |
| STRING   | email\_address             | Email address for a subscriber.                                                                                                                                                                                        |
| STRING   | email\_client              | The list member's email client.                                                                                                                                                                                        |
| STRING   | email\_type                | Type of email this member asked to get ('html' or 'text').                                                                                                                                                             |
| STRING   | status                     | Subscriber's current status. Possible Values: subscribed, unsubscribed, cleaned, pending, transactional, archived                                                                                                      |
| STRING   | list\_id                   | The ID of the list the member belongs to.                                                                                                                                                                              |
| DATETIME | signup\_timestamp          | The date and time the subscriber signed up for the list.                                                                                                                                                               |
| DATETIME | opt\_in\_timestamp         | The date and time the subscribe confirmed their opt-in status.                                                                                                                                                         |
| DATETIME | last\_changed\_timestamp   | The date and time the member's info was last changed.                                                                                                                                                                  |
| STRING   | country\_code              | The member's unique code for the location country.                                                                                                                                                                     |
| DECIMAL  | dstoff                     | The member's offset for timezones where daylight saving time is observed.                                                                                                                                              |
| DECIMAL  | gmtoff                     | The member's time difference in hours from GMT.                                                                                                                                                                        |
| STRING   | opt\_in\_ip\_address       | The IP address the subscriber used to confirm their opt-in status.                                                                                                                                                     |
| STRING   | signup\_ip\_address        | IP address the subscriber signed up from.                                                                                                                                                                              |
| STRING   | language                   | If set/detected, the subscriber's language.                                                                                                                                                                            |
| DECIMAL  | latitude                   | The member's location latitude.                                                                                                                                                                                        |
| DECIMAL  | longitude                  | The member's location longitude.                                                                                                                                                                                       |
| INTEGER  | member\_rating             | Star rating for this member, between 1 and 5.                                                                                                                                                                          |
| STRING   | timezone                   | The timezone for the member's location.                                                                                                                                                                                |
| STRING   | unique\_email\_id          | An identifier for the address across all of Mailchimp.                                                                                                                                                                 |
| BOOLEAN  | vip                        | VIP status for subscriber.                                                                                                                                                                                             |
| INTEGER  | campaign\_sends            | The number of sent emails from campaigns.                                                                                                                                                                              |
| INTEGER  | campaign\_opens            | The number of open events from campaign emails. The same email being opened multiple times is included in this metric.                                                                                                 |
| INTEGER  | campaign\_clicks           | The number of click events from campaign emails. The same email being clicked multiple times is included in this metric.                                                                                               |
| INTEGER  | campaign\_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  | campaign\_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.   |
| INTEGER  | campaign\_unsubscribes     | The number of users who have unsubscribed from campaign emails.                                                                                                                                                        |
| INTEGER  | automation\_sends          | The number of sent emails from automations.                                                                                                                                                                            |
| INTEGER  | automation\_opens          | The number of open events from automation emails. The same email being opened multiple times is included in this metric.                                                                                               |
| INTEGER  | automation\_clicks         | The number of click events from automation emails. The same email being clicked multiple times is included in this metric.                                                                                             |
| INTEGER  | automation\_unique\_opens  | The unique number of emails opened from automation 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  | automation\_unique\_clicks | The unique number of emails clicked from automation 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. |
| INTEGER  | automation\_unsubscribes   | The number of users who have unsubscribed from automation emails.                                                                                                                                                      |


---

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