# Mailchimp: Segments

## Description

* Each record represents a segment in Mailchimp, enriched with campaign metrics and (optionally) automation metrics. (Enabled if you are using segments.)

## Supported Data Sources

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

## Columns

| Type     | Name                       | Description                                                                                                                                                                                                            |
| -------- | -------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| INTEGER  | segment\_id                | The ID for the Segment from Mailchimp                                                                                                                                                                                  |
| STRING   | list\_id                   | The ID of the List the segment is part of.                                                                                                                                                                             |
| INTEGER  | member\_count              | The number of members in the segment.                                                                                                                                                                                  |
| STRING   | segment\_name              | The name of the segment.                                                                                                                                                                                               |
| STRING   | segment\_type              | The type of segment                                                                                                                                                                                                    |
| DATETIME | updated\_timestamp         | The date and time the segment was last updated.                                                                                                                                                                        |
| DATETIME | created\_timestamp         | The date and time the segment was created.                                                                                                                                                                             |
| 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.                                                                                                                                                        |
| STRING   | list\_name                 | The name of the List the segment is part of.                                                                                                                                                                           |
| 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-segments.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.