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.