Mailchimp: Automations

Description

• Each record represents an automation in Mailchimp, enriched with click, open and unsubscribe metrics. (Enabled if you are using automations.)

Supported Data Sources

• Mailchimp

Columns

Type	Name	Description
STRING	automation_id	The ID of the automation in Mailchimp.
STRING	list_id	The ID of the List an automation was sent to.
INTEGER	segment_id	The ID of the Segment an automation was sent to.
INTEGER	segment_text	Description of the segment. Formatted as a string marked up with HTML.
DATETIME	started_timestamp	The date and time the Automation was started.
DATETIME	created_timestamp	The date and time the Automation was created.
STRING	status	The current status of the Automation. Possible Values: save, paused, sending
STRING	title	The title of the Automation.
STRING	trigger_settings	Available triggers for Automation workflows.
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.