Automations
Returns a summary of the automations within an account.
View-Specific Information
Select
The driver uses the Mailchimp API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the driver.
| Column | Supported Operators |
| Id | = |
| CreateTime | =, <, >, <=, >= |
| StartTime | =, <, >, <=, >= |
| Status | = |
SELECT * FROM Automations WHERE Id = '1245'
SELECT * FROM Automations WHERE Status = 'save'
SELECT * FROM Automations WHERE CreateTime = '2024-02-07 00:00:37.0'
SELECT * FROM Automations WHERE CreateTime >= '2024-02-07 00:00:37.0'
SELECT * FROM Automations WHERE CreateTime <= '2024-02-07 00:00:37.0'
SELECT * FROM Automations WHERE CreateTime > '2024-02-07 00:00:37.0'
SELECT * FROM Automations WHERE CreateTime < '2024-02-07 00:00:37.0'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
A string that identifies this automation. | |
| CreateTime | Datetime | True |
The date and time the automation was created. | |
| StartTime | Datetime | True |
The date and time the automation was started. | |
| Status | String | True |
The current status of the automation ('save', 'paused', 'sending'). The allowed values are save, paused, sending. | |
| EmailsSent | Integer | True |
The total number of emails sent for this automation. | |
| Recipients_ListId | String | False |
Lists.Id |
The Id of the list associated with this automation. |
| Recipients_ListName | String | True |
The name of the list associated with this automation. | |
| Recipients_SegmentOpts | String | True |
The segment options applied to the automation's recipient list. | |
| Settings_Title | String | True |
The title of the automation. | |
| Settings_FromName | String | False |
The 'from' name on the automation (not an email address). | |
| Settings_ReplyTo | String | False |
The reply-to email address for the automation. | |
| Settings_UseConversation | Boolean | True |
Indicates whether Mailchimp's Conversations feature is used to manage out-of-office replies. | |
| Settings_ToName | String | True |
The automation's custom 'to' name, such as the first name merge variable. | |
| Settings_Authenticate | Boolean | True |
Indicates whether the automation is authenticated by Mailchimp. Defaults to 'true'. | |
| Settings_AutoFooter | Boolean | True |
Indicates whether Mailchimp's default footer is automatically appended to the automation. | |
| Settings_InlineCss | Boolean | True |
Indicates whether the CSS included with the automation content is automatically inlined. | |
| Tracking_Opens | Boolean | True |
Indicates whether opens are tracked. Defaults to 'true'. | |
| Tracking_HtmlClicks | Boolean | True |
Indicates whether clicks in the HTML version of the automation are tracked. Defaults to 'true'. | |
| Tracking_TextClicks | Boolean | True |
Indicates whether clicks in the plain-text version of the automation are tracked. Defaults to 'true'. | |
| Tracking_GoalTracking | Boolean | True |
Indicates whether Goal tracking is enabled. For more information, see this Knowledge Base article: http://eepurl.com/GPMdH | |
| Tracking_Ecomm360 | Boolean | True |
Indicates whether eCommerce360 tracking is enabled. | |
| Tracking_GoogleAnalytics | String | True |
The custom slug for Google Analytics tracking (max of 50 bytes). | |
| Tracking_Clicktale | String | True |
The custom slug for ClickTale Analytics tracking (max of 50 bytes). | |
| Tracking_Salesforce | String | True |
Salesforce tracking options for an automation. Must be using MailChimp's built-in Salesforce integration. | |
| Tracking_Capsule | String | True |
Capsule tracking options for an automation. Must be using MailChimp's built-in Capsule integration. | |
| TriggerSettings | String | False |
A summary of an automation workflow's trigger settings. | |
| ReportSummary | String | True |
A summary of open and click activity for an automation workflow. | |
| Recipients_ListIsActive | Boolean | True |
Indicates whether the list associated with the automation is active. A value of false indicates the list is deleted or disabled. | |
| Recipients_StoreId | String | False |
The Id of the store associated with this automation. |