AutomationEmails
Returns a summary of the emails in an automation workflow.
View-Specific Information
Select
The provider uses 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 provider.
| Column | Supported Operators |
| WorkflowId | = |
SELECT * FROM AutomationEmails WHERE WorkflowId = '1245'
Columns
| Name | Type | References | 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 | The position of the email within the automation workflow sequence. | |
| Delay_Amount | Integer | The delay amount for an automation email. | |
| Delay_Type | String | The type of delay for an automation email. | |
| Delay_Direction | String | The direction of the delay, indicating whether it occurs before or after the delay action of an automation email. | |
| Delay_Action | String | The action that triggers the delay of an automation email. | |
| 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 date and time a campaign was sent. | |
| ContentType | String | How the campaign's content is put together ('template', 'drag_and_drop', 'html', 'url'). | |
| Recipients_ListId | String |
Lists.Id | The Id of the list associated with this automation email. |
| Recipients_SegmentOpts | String | The segmentation options for the recipients of this automation email. | |
| 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 | Indicates whether the campaign was authenticated by Mailchimp. Defaults to 'true'. | |
| Settings_AutoFooter | Boolean | Indicates whether Mailchimp's default footer is automatically appended to the campaign. | |
| Settings_InlineCss | Boolean | Indicates whether the CSS included with the campaign content is automatically inlined. | |
| Settings_AutoTweet | Boolean | Indicates whether a link to the campaign archive page is automatically tweeted when the campaign is sent. | |
| Settings_AutoFbPost | String | An array of Facebook page Ids (integers) to auto-post to. | |
| Settings_FbComments | Boolean | Indicates whether Facebook comments are enabled on the campaign, which also force-enables the Campaign Archive toolbar. Defaults to 'true'. | |
| Settings_TemplateId | Integer |
Templates.Id | The Id of the template used in this campaign. |
| Settings_DragAndDrop | Boolean | Indicates whether the campaign uses the drag-and-drop editor. | |
| Tracking_Opens | Boolean | Indicates whether opens are tracked. Defaults to 'true'. | |
| Tracking_HtmlClicks | Boolean | Indicates whether clicks in the HTML version of the campaign are tracked. Defaults to 'true'. | |
| Tracking_TextClicks | Boolean | Indicates whether clicks in the plain-text version of the campaign are tracked. Defaults to 'true'. | |
| Tracking_GoalTracking | Boolean | Indicates whether Goal Tracking is enabled. For more information, see the Mailchimp Knowledge Base article at 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 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 social 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 | Indicates whether the automation email needs its blocks refreshed by opening the web-based campaign editor. | |
| HasLogoMergeTag | Boolean | Indicates whether the campaign contains the |BRAND:LOGO| merge tag. | |
| Recipients_ListIsActive | Boolean | Indicates whether the list associated with this automation email is active. A value of false indicates the list is 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. |