Automations
A summary of the automations within an account.
Table Specific Information
Select
The add-in will use the Mailchimp API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the add-in.
- Id supports the '=' operator.
- CreateTime supports the '=,<,>,<=,>=' operator.
- StartTime supports the '=,<,>,<=,>=' operator.
- Status supports the '=' operator.
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 | 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 | The id of the list. |
| Recipients_ListName | String | List Name |
| Recipients_SegmentOpts | String | Segment options. |
| 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 | Use MailChimp's Conversations feature to manage out of office replies. |
| Settings_ToName | String | The automation's custom 'to' name. Typically something like the first name merge var. |
| Settings_Authenticate | Boolean | Whether or not the automation is authenticated by MailChimp. Defaults to 'true'. |
| Settings_AutoFooter | Boolean | Automatically append MailChimp's default footer to the automation. |
| Settings_InlineCss | Boolean | Automatically inline the CSS included with the automation content. |
| Tracking_Opens | Boolean | Whether to track opens. Defaults to 'true'. |
| Tracking_HtmlClicks | Boolean | Whether to track clicks in the HTML version of the automation. Defaults to 'true'. |
| Tracking_TextClicks | Boolean | Whether to track clicks in the plain-text version of the automation. Defaults to 'true'. |
| Tracking_GoalTracking | Boolean | Whether to enable Goal tracking. For more information, see this Knowledge Base article: http://eepurl.com/GPMdH |
| Tracking_Ecomm360 | Boolean | Whether to enable eCommerce360 tracking. |
| 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 | The status of the list used, namely if it's deleted or disabled. |
| Recipients_StoreId | String | The id of the store. |