AutomationEmails
A summary of the emails in an automation workflow.
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.
- 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. |