Mailchimp: Automation Emails

Description

• Each record represents an automation email (that make up automations), enriched with click, open and unsubscribe metrics. (Enabled if you are using automations.)

Supported Data Sources

• Mailchimp

Columns

Type	Name	Description
STRING	automation_email_id
STRING	automation_id	The ID of the automation an email relates to.
DATETIME	created_timestamp	The date and time the automation email was created.
DATETIME	started_timestamp	The date and time the automation email was started.
DATETIME	send_timestamp	The date and time the automation email was sent.
STRING	from_name	The 'from' name on the automation email (not an email address).
STRING	reply_to	The reply-to email address for the automation.
STRING	status	The current status of the automation email.
STRING	subject_line	The subject line for the automation email.
STRING	title	The title of the automation email.
INTEGER	to_name	The automation email's custom 'To' name. Typically the first name merge field.
STRING	archive_url	The link to the automation email's archive version in ISO 8601 format.
BOOLEAN	authenticate	Whether Mailchimp authenticated the automation email. Defaults to true.
BOOLEAN	auto_footer	Automatically append Mailchimp's default footer to the automation email.
BOOLEAN	auto_tweet	Automatically tweet a link to the automation email archive page when the automation email is sent.
INTEGER	clicktale	The custom slug for ClickTale tracking (max of 50 bytes).
STRING	content_type	How the automation email's content is put together ('template', 'drag_and_drop', 'html', 'url').
STRING	delay_action	The action that triggers the delay of an Automation email.
STRING	delay_action_description	The user-friendly description of the action that triggers an Automation email.
INTEGER	delay_amount	The delay amount for an Automation email.
INTEGER	delay_direction	Whether the delay settings describe before or after the delay action of an Automation email.
STRING	delay_full_description	The user-friendly description of the delay and trigger action settings for an Automation email.
STRING	delay_type	The type of delay for an Automation email.
BOOLEAN	drag_and_drop	Whether the automation email uses the drag-and-drop editor.
BOOLEAN	fb_comments	Allows Facebook comments on the automation email (also force-enables the Campaign Archive toolbar). Defaults to true.
INTEGER	folder_id	If the automation email is listed in a folder, the ID for that folder.
STRING	google_analytics	The custom slug for Google Analytics tracking (max of 50 bytes).
BOOLEAN	inline_css	Automatically inline the CSS included with the automation email content.
INTEGER	position	The position of an Automation email in a workflow.
INTEGER	template_id	The ID for the template used in this automation email.
INTEGER	timewarp	Send this automation email using Timewarpe_this
BOOLEAN	track_ecomm_360	Whether to enable eCommerce360 tracking.
BOOLEAN	track_goals	Whether to enable Goal tracking.
BOOLEAN	track_html_clicks	Whether to track clicks in the HTML version of the automation email. Defaults to true. Cannot be set to false for variate campaigns.
BOOLEAN	track_opens	Whether to track opens. Defaults to true. Cannot be set to false for variate automation emails.
BOOLEAN	track_text_clicks	Whether to track clicks in the plain-text version of the automation email. Defaults to true. Cannot be set to false for variate campaigns.
INTEGER	use_conversation	Use Mailchimp Conversation feature to manage out-of-office replies.
STRING	list_id	The ID of the List this automation email is being sent to.
INTEGER	segment_id	The ID of the Segment this automation email is being sent to.
INTEGER	sends	The number of sent emails from automations.
INTEGER	opens	The number of open events from automation emails. The same email being opened multiple times is included in this metric.
INTEGER	clicks	The number of click events from automation emails. The same email being clicked multiple times is included in this metric.
INTEGER	unique_opens	The unique number of emails opened from automation emails. If a given email to a user was opened multiple times, it will only count once in this metric.This is the metric for opens that is reported by Mailchimp.
INTEGER	unique_clicks	The unique number of emails clicked from automation emails. If a given email to a user was clicked multiple times, it will only count once in this metric.This is the metric for clicks that is reported by Mailchimp.
INTEGER	unsubscribes	The number of users who have unsubscribed from automation emails.