AutomationEmails
A summary of the emails in an automation workflow.
Table Specific Information
SELECT is supported for AutomationEmails.
Select
A WorkflowId is required to retrieve data from this table. If none is specified in the WHERE clause, the first one available for your account will be used.
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_Highrise | String | Highrise tracking options for a campaign. Must be using MailChimp's built-in Highrise 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. |