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.
Last updated