Mailchimp Data Studio Connector Fields Reference
Account Email
The email associated with the Mailchimp account
Field Type:Dimension
Data Views:Campaigns, Automations, List Growth, Members, Campaign Timeseries, Campaign Link Clicks
Account Name
The name of the Mailchimp account
Field Type:Dimension
Data Views:Campaigns, Automations, List Growth, Members, Campaign Timeseries, Campaign Link Clicks
Automation Date Created
The date and time the Automation was created
Field Type:Dimension
Data Views:Automations
Automation Date Started
The date and time the Automation was started
Field Type:Dimension
Data Views:Automations
Automation ID
A string that identifies the Automation
Field Type:Dimension
Data Views:Automations
Automation Status
The current status of the Automation. Possible values: "save", "paused", or "sending
Field Type:Dimension
Data Views:Automations
Automation Title
The title of the Automation
Field Type:Dimension
Data Views:Automations
Automation Total Click Rate
The all-time total click rate for the Automation
Field Type:Metric
Data Views:Automations
Automation Total Clicks
The all-time total clicks for the Automation
Field Type:Metric
Data Views:Automations
Automation Total Emails Sent
The all-time total number of emails sent for the Automation
Field Type:Metric
Data Views:Automations
Automation Total Open Rate
The all-time total open rate for the Automation
Field Type:Metric
Data Views:Automations
Automation Total Opens
The all-time total opens for the Automation
Field Type:Metric
Data Views:Automations
Automation Total Subscriber Opens
The all-time total unique subscriber clicks for the Automation
Field Type:Metric
Data Views:Automations
Automation Total Unique Opens
The all-time total of unique opens for the Automation
Field Type:Metric
Data Views:Automations
Automation Type
The type of Automation workflow. Possible values: "abandonedBrowse", "abandonedCart", "api", "bestCustomers", "categoryFollowup", "dateAdded", "emailFollowup", "emailSeries", "groupAdd", "groupRemove", "mandrill", "productFollowup", "purchaseFollowup", "recurringEvent", "specialEvent", "visitUrl", or "welcomeSeries
Field Type:Dimension
Data Views:Automations
Campaign Abuse Reports
The number of abuse reports generated for a campaign
Field Type:Metric
Data Views:Campaigns
Campaign Currency Code
The currency code for Campaign Revenue and Campaign Spent metrics
Field Type:Dimension
Data Views:Campaigns
Campaign Emails Sent
The total number of emails sent for the campaign
Field Type:Metric
Data Views:Campaigns
Campaign Facebook Likes
The number of Facebook likes for the campaign
Field Type:Metric
Data Views:Campaigns
Campaign Facebook Recipient Likes
The number of recipients who liked the campaign on Facebook
Field Type:Metric
Data Views:Campaigns
Campaign Facebook Unique Likes
The number of unique Facebook likes for the campaign
Field Type:Metric
Data Views:Campaigns
Campaign Forwarded Opens
How many times the forwarded campaign has been opened
Field Type:Metric
Data Views:Campaigns
Campaign Forwards
How many times the campaign has been forwarded
Field Type:Metric
Data Views:Campaigns
Campaign Hard Bounces
The total number of hard bounced email addresses for the campaign
Field Type:Metric
Data Views:Campaigns
Campaign ID
The string that uniquely identifies a campaign
Field Type:Dimension
Data Views:Campaigns, Campaign Timeseries, Campaign Link Clicks
Campaign Last Click Date
The date of the last recorded click for the campaign
Field Type:Dimension
Data Views:Campaigns
Campaign Last Open Date
The date of the last recorded open for the campaign
Field Type:Dimension
Data Views:Campaigns
Campaign Last Sent
The date a campaign was last sent
Field Type:Dimension
Data Views:Campaigns
Campaign Link ID
The unique ID of the campaign link
Field Type:Dimension
Data Views:Campaign Link Clicks
Campaign Link Last Click Time
The date and hour for the last recorded click for a campaign link
Field Type:Dimension
Data Views:Campaign Link Clicks
Campaign Link Total Click Percentage
The percentage of total clicks a link generated for a campaign
Field Type:Metric
Data Views:Campaign Link Clicks
Campaign Link Total Clicks
The number of total clicks for a campaign link
Field Type:Metric
Data Views:Campaign Link Clicks
Campaign Link Unique Click Percentage
The percentage of unique clicks a link generated for a campaign
Field Type:Metric
Data Views:Campaign Link Clicks
Campaign Link Unique Clicks
The number of unique clicks for a campaign link
Field Type:Metric
Data Views:Campaign Link Clicks
Campaign Link URL
The url of the campaign link
Field Type:Dimension
Data Views:Campaign Link Clicks
Campaign Opens
The total number of opens for the campaign
Field Type:Metric
Data Views:Campaigns
Campaign Orders
The total orders for the campaign
Field Type:Metric
Data Views:Campaigns
Campaign Preview Text
The preview text for the campaign
Field Type:Dimension
Data Views:Campaigns, Campaign Timeseries, Campaign Link Clicks
Campaign Revenue
The total revenue for the campaign. Calculated as the sum of all order totals minus shipping and tax totals
Field Type:Metric
Data Views:Campaigns
Campaign RSS Last Sent
For RSS campaigns, the date of the last send
Field Type:Dimension
Data Views:Campaigns
Campaign Soft Bounces
The total number of soft bounced email addresses for the campaign
Field Type:Metric
Data Views:Campaigns
Campaign Spent
The total spent for the campaign. Calculated as the sum of all order totals with no deductions
Field Type:Metric
Data Views:Campaigns
Campaign Subject Line
The subject line for the campaign
Field Type:Dimension
Data Views:Campaigns, Campaign Timeseries, Campaign Link Clicks
Campaign Subscriber Clicks
The total number of subscribers who clicked on a campaign
Field Type:Metric
Data Views:Campaigns
Campaign Syntax Errors
The total number of addresses that were syntax-related bounces for the campaign
Field Type:Metric
Data Views:Campaigns
Campaign Title
The title of the campaign
Field Type:Dimension
Data Views:Campaigns, Campaign Timeseries, Campaign Link Clicks
Campaign Total Clicks
The total number of clicks for the campaign
Field Type:Metric
Data Views:Campaigns
Campaign Type
The campaign type. Possible values: "regular", "plaintext", "absplit", "rss", or "variate
Field Type:Dimension
Data Views:Campaigns, Campaign Timeseries, Campaign Link Clicks
Campaign Unique Click Rate
The number of unique clicks divided by the total number of successful deliveries for the campaign
Field Type:Metric
Data Views:Campaigns
Campaign Unique Clicks
The total number of unique clicks for links across a campaign
Field Type:Metric
Data Views:Campaigns
Campaign Unique Open Rate
The number of unique opens divided by the total number of successful deliveries for the campaign
Field Type:Metric
Data Views:Campaigns
Campaign Unique Opens
The total number of unique opens for the campaign
Field Type:Metric
Data Views:Campaigns
Campaign Unsubscribes
The total number of unsubscribed members for the campaign
Field Type:Metric
Data Views:Campaigns
List Avg. Click Rate
The average click rate (a percentage represented as a number between 0 and 100) per campaign for the list
Field Type:Metric
Data Views:Campaigns, Automations
List Avg. Open Rate
The average open rate per campaign for the list
Field Type:Metric
Data Views:Campaigns, Automations
List Avg. Subs per Month
The average number of subscriptions per month for the list
Field Type:Metric
Data Views:Campaigns, Automations
List Avg. Unsubscribes per Month
The average number of unsubscriptions per month for the list
Field Type:Metric
Data Views:Campaigns, Automations
List Created Date
The date this list was created
Field Type:Dimension
Data Views:Campaigns, Automations, List Growth, Members, Campaign Timeseries, Campaign Link Clicks
List Growth Cleaned
Newly cleaned (hard-bounced) members on the list for a specific month
Field Type:Metric
Data Views:List Growth
List Growth Deleted
Newly deleted members on the list for a specific month
Field Type:Metric
Data Views:List Growth
List Growth Month
The month that the growth history is describing
Field Type:Dimension
Data Views:List Growth
List Growth Pending
Pending members on the list for a specific month
Field Type:Metric
Data Views:List Growth
List Growth Reconfirmed
Newly reconfirmed members on the list for a specific month
Field Type:Metric
Data Views:List Growth
List Growth Total Subscribers
Total subscribed members on the list at the end of the month
Field Type:Metric
Data Views:List Growth
List Growth Transactional Emails
Subscribers that have been sent transactional emails via Mandrill
Field Type:Metric
Data Views:List Growth
List Growth Unsubscribed
Newly unsubscribed members on the list for a specific month
Field Type:Metric
Data Views:List Growth
List Has Double Optin
Whether or not the subscriber has to confirm subscription to the list via email
Field Type:Dimension
Data Views:Campaigns, Automations, List Growth, Members, Campaign Timeseries, Campaign Link Clicks
List Has Welcome
Whether or not this list has a welcome automation connected. Welcome Automations: welcomeSeries, singleWelcome, emailFollowup
Field Type:Dimension
Data Views:Campaigns, Automations, List Growth, Members, Campaign Timeseries, Campaign Link Clicks
List ID
A string that uniquely identifies the list
Field Type:Dimension
Data Views:Campaigns, Automations, List Growth, Members, Campaign Timeseries, Campaign Link Clicks
List is Active
The status of the list used, namely if it's deleted or disabled
Field Type:Dimension
Data Views:Campaigns, Automations
List Last Campaign Sent Date
The date the last campaign was sent to this list
Field Type:Dimension
Data Views:Campaigns, Automations, List Growth, Members, Campaign Timeseries, Campaign Link Clicks
List Last Sub Date
The date of the last time someone subscribed to the list
Field Type:Dimension
Data Views:Campaigns, Automations, List Growth, Members, Campaign Timeseries, Campaign Link Clicks
List Last Unsubscribe Date
The date of the last time someone unsubscribed from the list
Field Type:Dimension
Data Views:Campaigns, Automations, List Growth, Members, Campaign Timeseries, Campaign Link Clicks
List Members
The number of active members in the list
Field Type:Metric
Data Views:Campaigns, Automations
List Members Cleaned
The number of members cleaned from the list
Field Type:Metric
Data Views:Campaigns, Automations
List Members Cleaned Since Last Send
The number of members cleaned from the list since the last campaign was sent
Field Type:Metric
Data Views:Campaigns, Automations
List Merge Variables
The number of merge vars for this list (not EMAIL, which is required)
Field Type:Metric
Data Views:Campaigns, Automations
List Name
The name of the list
Field Type:Dimension
Data Views:Campaigns, Automations, List Growth, Members, Campaign Timeseries, Campaign Link Clicks
List New Members Since Last Send
The number of active members in the list since the last campaign was sent
Field Type:Metric
Data Views:Campaigns, Automations
List Number of Campaigns
The number of campaigns in any status that use this list
Field Type:Metric
Data Views:Campaigns, Automations
List Rating
An auto-generated activity score for the list (0-5)
Field Type:Dimension
Data Views:Campaigns, Automations, List Growth, Members, Campaign Timeseries, Campaign Link Clicks
List Target Subs per Month
The target number of subscriptions per month for the list to keep it growing
Field Type:Metric
Data Views:Campaigns, Automations
List Unsubscribes
The number of members who have unsubscribed from the list
Field Type:Metric
Data Views:Campaigns, Automations
List Unsubscribes Since Last Send
The number of members who have unsubscribed since the last campaign was sent
Field Type:Metric
Data Views:Campaigns, Automations
Member Avg. Click Rate
A subscriber's average clickthrough rate
Field Type:Metric
Data Views:Members
Member Avg. Open Rate
A subscriber's average open rate
Field Type:Metric
Data Views:Members
Member Consents to 1-to-1 Messaging
Indicates whether a contact consents to 1:1 messaging
Field Type:Dimension
Data Views:Members
Member Contact ID
As Mailchimp evolves beyond email, you may eventually have contacts without email addresses. While the id is the MD5 hash of their email address, this contact_id is agnostic of contact’s inclusion of an email address
Field Type:Dimension
Data Views:Members
Member Email
Email address for a subscriber
Field Type:Dimension
Data Views:Members
Member Email Client
The list member's email client
Field Type:Dimension
Data Views:Members
Member Email Type
Type of email this member asked to get ('html' or 'text')
Field Type:Dimension
Data Views:Members
Member Full Name
The contact's full name
Field Type:Dimension
Data Views:Members
Member ID
The MD5 hash of the lowercase version of the list member's email address
Field Type:Dimension
Data Views:Members
Member Interest Groups
Interest groups that subscriber is currently subscribed to
Field Type:Dimension
Data Views:Members
Member is VIP
Mailchimp VIP status for a subscriber
Field Type:Dimension
Data Views:Members
Member Language
If set/detected by Mailchimp, the subscriber's language
Field Type:Dimension
Data Views:Members
Member Location Country Code
The unique code for the location country of a member
Field Type:Dimension
Data Views:Members
Member Location DST Offset
The offset for timezones where daylight saving time is observed for a member
Field Type:Dimension
Data Views:Members
Member Location GMT Offset
The time difference in hours from GMT for a member
Field Type:Dimension
Data Views:Members
Member Location Lat/Long
The combined location latitude and longitude of a member in ISO 6709 format
Field Type:Dimension
Data Views:Members
Member Location Latitude
The location latitude of a member
Field Type:Dimension
Data Views:Members
Member Location Longitude
The location longitude of a member
Field Type:Dimension
Data Views:Members
Member Location Timezone
The timezone for the location of a member
Field Type:Dimension
Data Views:Members
Member Opt-in IP Address
The IP address the subscriber used to confirm their opt-in status
Field Type:Dimension
Data Views:Members
Member Rating
Mailchimp generated star rating for this member, between 1 and 5
Field Type:Dimension
Data Views:Members
Member Signup IP Address
IP address the subscriber signed up from
Field Type:Dimension
Data Views:Members
Member Source
The source from which the member was added to this list
Field Type:Dimension
Data Views:Members
Member Status
Subscriber's current status. Possible values: 'subscribed', 'unsubscribed', 'cleaned', 'pending', 'transactional', or 'archived'
Field Type:Dimension
Data Views:Members
Member Tags
Tags that are applied to the member (supports up to 50 tags)
Field Type:Dimension
Data Views:Members
Member Time Last Changed
The date and time the member's info was last changed in ISO 8601 format
Field Type:Dimension
Data Views:Members
Member Time of Opt-in
The date and time the subscribe confirmed their opt-in status in ISO 8601 format
Field Type:Dimension
Data Views:Members
Member Time of Signup
The date and time the subscriber signed up for the list in ISO 8601 format
Field Type:Dimension
Data Views:Members
Member Total Orders
The total number of orders placed by the list member
Field Type:Metric
Data Views:Members
Member Total Revenue
The total revenue the list member has brought in
Field Type:Metric
Data Views:Members
Member Total Revenue Currency Code
The three-letter ISO 4217 code for the currency that the store accepts
Field Type:Dimension
Data Views:Members
Member Unique ID
An identifier for the address across all of Mailchimp
Field Type:Dimension
Data Views:Members
Member Unsubscribe Reason
A subscriber's reason for unsubscribing
Field Type:Dimension
Data Views:Members
Member Web ID
The ID used in the Mailchimp web application. View this member in your Mailchimp account at https://{dc}.admin.mailchimp.com/lists/members/view?id={web_id}.
Field Type:Dimension
Data Views:Members
Timeseries Clicks
The number of clicks by hour of a campaign
Field Type:Metric
Data Views:Campaign Timeseries
Timeseries Date
The date for the 24 hour timeseries after a campaign is started
Field Type:Dimension
Data Views:Campaign Timeseries
Timeseries Date and Hour
The date and hour for the 24 hour timeseries after a campaign is started
Field Type:Dimension
Data Views:Campaign Timeseries
Timeseries Emails Sent
The number of emails sent in by hour of a campaign
Field Type:Dimension
Data Views:Campaign Timeseries
Timeseries Hour of Campaign
The number of hours after a campaign started
Field Type:Dimension
Data Views:Campaign Timeseries
Timeseries Hour of Day
The hour of the day for the 24 hour timeseries after a campaign is started
Field Type:Dimension
Data Views:Campaign Timeseries
Timeseries Unique Opens
The number of unique opens by hour of a campaign
Field Type:Dimension
Data Views:Campaign Timeseries