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