Mailchimp: Lists

Description

• Each record represents a list in Mailchimp, enriched with campaign metrics, (optionally) automation metrics and information about members.

Supported Data Sources

• Mailchimp

Columns

Type	Name	Description
STRING	list_id	The unique ID of a list.
DATETIME	date_created	The date and time that a list was created.
STRING	name	The name of a list.
DECIMAL	list_rating	An auto-generated activity score for the list (0-5).
STRING	beamer_address	The list's email beamer address.
STRING	contact_address_1	The street address for the list contact.
INTEGER	contact_address_2	The street address for the list contact.
STRING	contact_city	The city for the list contact.
STRING	contact_company	The company name for the list.
STRING	contact_country	A two-character ISO3166 country code. Defaults to US if invalid.
STRING	contact_state	The state for the list contact.
STRING	contact_zip	The postal or zip code for the list contact.
STRING	default_from_email	The default from email for campaigns sent to a list.
STRING	default_from_name	The default from name for campaigns sent to a list.
STRING	default_language	The default language for a lists's forms.
INTEGER	default_subject	The default subject line for campaigns sent to a list.
BOOLEAN	email_type_option	Whether the list supports multiple formats for emails. When set to true, subscribers can choose whether they want to receive HTML or plain-text emails. When set to false, subscribers will receive HTML emails, with a plain-text alternative backup.
INTEGER	notify_on_subscribe	The email address to send subscribe notifications to.
INTEGER	notify_on_unsubscribe	The email address to send unsubscribe notifications to.
STRING	permission_reminder	The permission reminder for a list.
STRING	subscribe_url_long	The full version of a list's subscribe form (host will vary).
STRING	subscribe_url_short	Mailchimp's EepURL shortened version of a list's subscribe form.
BOOLEAN	use_archive_bar	Whether campaigns for this list use the Archive Bar in archives by default.
STRING	visibility	Whether this list is public or private.
INTEGER	count_members	The number of members in a list.
DATETIME	most_recent_signup_timestamp	The date of the most recent signup to a list.
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.