Mailchimp: Members

Description

• Each record represents a member in Mailchimp, enriched with campaign metrics and (optionally) automation metrics.

Supported Data Sources

• Mailchimp

Columns

Type	Name	Description
STRING	member_id	The ID of the member.
STRING	email_address	Email address for a subscriber.
STRING	email_client	The list member's email client.
STRING	email_type	Type of email this member asked to get ('html' or 'text').
STRING	status	Subscriber's current status. Possible Values: subscribed, unsubscribed, cleaned, pending, transactional, archived
STRING	list_id	The ID of the list the member belongs to.
DATETIME	signup_timestamp	The date and time the subscriber signed up for the list.
DATETIME	opt_in_timestamp	The date and time the subscribe confirmed their opt-in status.
DATETIME	last_changed_timestamp	The date and time the member's info was last changed.
STRING	country_code	The member's unique code for the location country.
DECIMAL	dstoff	The member's offset for timezones where daylight saving time is observed.
DECIMAL	gmtoff	The member's time difference in hours from GMT.
STRING	opt_in_ip_address	The IP address the subscriber used to confirm their opt-in status.
STRING	signup_ip_address	IP address the subscriber signed up from.
STRING	language	If set/detected, the subscriber's language.
DECIMAL	latitude	The member's location latitude.
DECIMAL	longitude	The member's location longitude.
INTEGER	member_rating	Star rating for this member, between 1 and 5.
STRING	timezone	The timezone for the member's location.
STRING	unique_email_id	An identifier for the address across all of Mailchimp.
BOOLEAN	vip	VIP status for subscriber.
INTEGER	campaign_sends	The number of sent emails from campaigns.
INTEGER	campaign_opens	The number of open events from campaign emails. The same email being opened multiple times is included in this metric.
INTEGER	campaign_clicks	The number of click events from campaign emails. The same email being clicked multiple times is included in this metric.
INTEGER	campaign_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	campaign_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.
INTEGER	campaign_unsubscribes	The number of users who have unsubscribed from campaign emails.
INTEGER	automation_sends	The number of sent emails from automations.
INTEGER	automation_opens	The number of open events from automation emails. The same email being opened multiple times is included in this metric.
INTEGER	automation_clicks	The number of click events from automation emails. The same email being clicked multiple times is included in this metric.
INTEGER	automation_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	automation_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	automation_unsubscribes	The number of users who have unsubscribed from automation emails.