AutomationEmails
A summary of the emails in an automation workflow.
Table Specific Information
Select
The driver 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 driver.
- WorkflowId supports the '=' operator.
SELECT * FROM AutomationEmails WHERE WorkflowId = '1245'
Columns
| Name | Type | Description |
| Id [KEY] | String | A string that uniquely identifies the automation email. |
| WorkflowId [KEY] | String | A string that uniquely identifies an automation workflow. |
| Position | Integer | |
| Delay_Amount | Integer | The delay amount for an automation email. |
| Delay_Type | String | The type of delay for an automation email. |
| Delay_Direction | String | Whether the delay settings describe before or after the delay action of an automation email. |
| Delay_Action | String | The action that triggers the delay of an automation emails. |
| CreateTime | Datetime | The date and time the campaign was created. |
| StartTime | Datetime | The date and time the campaign was started. |
| ArchiveUrl | String | The link to the campaign's archive version. |
| Status | String | The current status of the campaign ('save', 'paused', 'sending'). |
| EmailsSent | Integer | The total number of emails sent for this campaign. |
| SendTime | Datetime | The time and date a campaign was sent. |
| ContentType | String | How the campaign's content is put together ('template', 'drag_and_drop', 'html', 'url'). |
| Recipients_ListId | String | The id of the list. |
| Recipients_SegmentOpts | String | Segment options. |
| Settings_SubjectLine | String | The subject line for the campaign. |
| Settings_Title | String | The title of the campaign. |
| Settings_FromName | String | The 'from' name on the campaign (not an email address). |
| Settings_ReplyTo | String | The reply-to email address for the campaign. |
| Settings_Authenticate | Boolean | Whether or not the campaign was authenticated by MailChimp. Defaults to 'true'. |
| Settings_AutoFooter | Boolean | Automatically append MailChimp's default footer to the campaign. |
| Settings_InlineCss | Boolean | Automatically inline the CSS included with the campaign content. |
| Settings_AutoTweet | Boolean | Automatically tweet a link to the campaign archive page when the campaign is sent. |
| Settings_AutoFbPost | String | An array of Facebook page ids (integers) to auto-post to. |
| Settings_FbComments | Boolean | Allows Facebook comments on the campaign (also force-enables the Campaign Archive toolbar). Defaults to 'true'. |
| Settings_TemplateId | Integer | The id for the template used in this campaign. |
| Settings_DragAndDrop | Boolean | Whether the campaign uses the drag-and-drop editor. |
| Tracking_Opens | Boolean | Whether to track opens. Defaults to 'true'. |
| Tracking_HtmlClicks | Boolean | Whether to track clicks in the HTML version of the campaign. Defaults to 'true'. |
| Tracking_TextClicks | Boolean | Whether to track clicks in the plain-text version of the campaign. Defaults to 'true'. |
| Tracking_GoalTracking | Boolean | Whether to enable Goal racking. 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 a campaign. Must be using MailChimp's built-in Salesforce integration. |
| Tracking_Capsule | String | Capsule tracking option sfor a campaign. Must be using MailChimp's built-in Capsule integration. |
| SocialCard_ImageUrl | String | The url for the header image for the card. |
| SocialCard_Description | String | A short summary of the campaign to display. |
| SocialCard_Title | String | The title for the card. Typically the subject line of the campaign. |
| TriggerSettings_Runtime | String | The advanced scheduling options for an automation email. |
| ReportSummary | String | For sent campaigns, a summary of opens, clicks, and unsubscribes. |
| WebId | Integer | The ID used in the Mailchimp web application. View this campaign in your Mailchimp account at https://{dc}.admin.mailchimp.com/campaigns/show/?id={web_id}. |
| TriggerSettings_WorkflowType | String | The type of Automation workflow.
The allowed values are abandonedBrowse, abandonedCart, api, bestCustomers, categoryFollowup, dateAdded, emailFollowup, emailSeries, groupAdd, groupRemove, mandrill, productFollowup, purchaseFollowup, recurringEvent, specialEvent, visitUrl, welcomeSeries. |
| TriggerSettings_WorkflowTitle | String | The title of the workflow type. |
| TriggerSettings_WorkflowEmailsCount | Integer | The number of emails in the Automation workflow. |
| Delay_ActionDescription | String | The user-friendly description of the action that triggers an Automation email. |
| Delay_FullDescription | String | The user-friendly description of the delay and trigger action settings for an Automation email. |
| NeedsBlockRefresh | Boolean | Determines if the automation email needs its blocks refreshed by opening the web-based campaign editor. |
| HasLogoMergeTag | Boolean | Determines if the campaign contains the |BRAND:LOGO| merge tag |
| Recipients_ListIsActive | Boolean | The status of the list used, namely if it's deleted or disabled. |
| Recipients_ListName | String | The name of the list |
| Recipients_RecipientCount | Integer | Count of the recipients on the associated list. Formatted as an integer. |
| Recipients_SegmentText | String | A description of the segment used for the campaign. Formatted as a string marked up with HTML. |
| Settings_PreviewText | String | The preview text for the campaign. |