# Mailchimp: Automation Emails ## Description * Each record represents an automation email (that make up automations), enriched with click, open and unsubscribe metrics. (Enabled if you are using automations.) ## Supported Data Sources * Mailchimp ## Columns | Type | Name | Description | | -------- | -------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | STRING | automation\_email\_id | | | STRING | automation\_id | The ID of the automation an email relates to. | | DATETIME | created\_timestamp | The date and time the automation email was created. | | DATETIME | started\_timestamp | The date and time the automation email was started. | | DATETIME | send\_timestamp | The date and time the automation email was sent. | | STRING | from\_name | The 'from' name on the automation email (not an email address). | | STRING | reply\_to | The reply-to email address for the automation. | | STRING | status | The current status of the automation email. | | STRING | subject\_line | The subject line for the automation email. | | STRING | title | The title of the automation email. | | INTEGER | to\_name | The automation email's custom 'To' name. Typically the first name merge field. | | STRING | archive\_url | The link to the automation email's archive version in ISO 8601 format. | | BOOLEAN | authenticate | Whether Mailchimp authenticated the automation email. Defaults to true. | | BOOLEAN | auto\_footer | Automatically append Mailchimp's default footer to the automation email. | | BOOLEAN | auto\_tweet | Automatically tweet a link to the automation email archive page when the automation email is sent. | | INTEGER | clicktale | The custom slug for ClickTale tracking (max of 50 bytes). | | STRING | content\_type | How the automation email's content is put together ('template', 'drag\_and\_drop', 'html', 'url'). | | STRING | delay\_action | The action that triggers the delay of an Automation email. | | STRING | delay\_action\_description | The user-friendly description of the action that triggers an Automation email. | | INTEGER | delay\_amount | The delay amount for an Automation email. | | INTEGER | delay\_direction | Whether the delay settings describe before or after the delay action of an Automation email. | | STRING | delay\_full\_description | The user-friendly description of the delay and trigger action settings for an Automation email. | | STRING | delay\_type | The type of delay for an Automation email. | | BOOLEAN | drag\_and\_drop | Whether the automation email uses the drag-and-drop editor. | | BOOLEAN | fb\_comments | Allows Facebook comments on the automation email (also force-enables the Campaign Archive toolbar). Defaults to true. | | INTEGER | folder\_id | If the automation email is listed in a folder, the ID for that folder. | | STRING | google\_analytics | The custom slug for Google Analytics tracking (max of 50 bytes). | | BOOLEAN | inline\_css | Automatically inline the CSS included with the automation email content. | | INTEGER | position | The position of an Automation email in a workflow. | | INTEGER | template\_id | The ID for the template used in this automation email. | | INTEGER | timewarp | Send this automation email using Timewarpe\_this | | BOOLEAN | track\_ecomm\_360 | Whether to enable eCommerce360 tracking. | | BOOLEAN | track\_goals | Whether to enable Goal tracking. | | BOOLEAN | track\_html\_clicks | Whether to track clicks in the HTML version of the automation email. Defaults to true. Cannot be set to false for variate campaigns. | | BOOLEAN | track\_opens | Whether to track opens. Defaults to true. Cannot be set to false for variate automation emails. | | BOOLEAN | track\_text\_clicks | Whether to track clicks in the plain-text version of the automation email. Defaults to true. Cannot be set to false for variate campaigns. | | INTEGER | use\_conversation | Use Mailchimp Conversation feature to manage out-of-office replies. | | STRING | list\_id | The ID of the List this automation email is being sent to. | | INTEGER | segment\_id | The ID of the Segment this automation email is being sent to. | | 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-automation-emails.md?ask= ``` 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.