Automations
A summary of the automations within an account.
Table Specific Information
Select
The connector 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 connector.
- 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. |