# Mailchimp: Automations

## Description

* Each record represents an automation in Mailchimp, enriched with click, open and unsubscribe metrics. (Enabled if you are using automations.)

## Supported Data Sources

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

## Columns

| Type     | Name               | Description                                                                                                                                                                                                            |
| -------- | ------------------ | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| STRING   | automation\_id     | The ID of the automation in Mailchimp.                                                                                                                                                                                 |
| STRING   | list\_id           | The ID of the List an automation was sent to.                                                                                                                                                                          |
| INTEGER  | segment\_id        | The ID of the Segment an automation was sent to.                                                                                                                                                                       |
| INTEGER  | segment\_text      | Description of the segment. Formatted as a string marked up with HTML.                                                                                                                                                 |
| DATETIME | started\_timestamp | The date and time the Automation was started.                                                                                                                                                                          |
| DATETIME | created\_timestamp | The date and time the Automation was created.                                                                                                                                                                          |
| STRING   | status             | The current status of the Automation. Possible Values: save, paused, sending                                                                                                                                           |
| STRING   | title              | The title of the Automation.                                                                                                                                                                                           |
| STRING   | trigger\_settings  | Available triggers for Automation workflows.                                                                                                                                                                           |
| INTEGER  | sends              | The number of sent emails from automations.                                                                                                                                                                            |
| INTEGER  | opens              | The number of open events from automation emails. The same email being opened multiple times is included in this metric.                                                                                               |
| INTEGER  | clicks             | The number of click events from automation emails. The same email being clicked multiple times is included in this metric.                                                                                             |
| INTEGER  | 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  | 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  | 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-automations.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.