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