Mailchimp: Campaign Recipients

Description

• Each record represents the send of a campaign email, enriched with click, open and unsubscribe metrics.

Supported Data Sources

• Mailchimp

Columns

Type	Name	Description
STRING	campaign_id	The ID of the campaign a sent email is from.
STRING	member_id	The ID of the member an email was sent to.
INTEGER	combination_id	The ID of the combination the member was part of for a campaign.
STRING	list_id	The ID of the list the campaign was sent to.
STRING	email_id	The ID of the email sent. Surrogate key generated in dbt from 'campaign_id' and 'member_id'.
INTEGER	segment_id	The ID of the segment the campaign was sent to.
DATETIME	send_timestamp	The date and time a campaign was sent.
INTEGER	opens	The number of open events from campaign emails. The same email being opened multiple times is included in this metric.
INTEGER	unique_opens	The unique number of emails opened from campaign 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	clicks	The number of click events from campaign emails. The same email being clicked multiple times is included in this metric.
INTEGER	unique_clicks	The unique number of emails clicked from campaign 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.
BOOLEAN	was_opened	Whether the email sent was opened.
BOOLEAN	was_clicked	Whether the email sent was clicked.
DATETIME	first_open_timestamp	The timestamp of the first open for an email.
INTEGER	time_to_open_minutes	The time from send to open in minutes.
INTEGER	time_to_open_hours	The time from send to open in hours.
INTEGER	time_to_open_days	The time from send to open in days.
BOOLEAN	was_unsubscribed	Whether the user unsubscribed via the sent email.