Mailchimp Data Studio Connector Fields Reference

Automation Date Created

The date and time the Automation was created

Field Type:Dimension

Data Views:Automations

Plans:All

Automation Date Started

The date and time the Automation was started

Field Type:Dimension

Data Views:Automations

Plans:All

Automation ID

A string that identifies the Automation

Field Type:Dimension

Data Views:Automations

Plans:All

Automation Status

The current status of the Automation. Possible values: "save", "paused", or "sending

Field Type:Dimension

Data Views:Automations

Plans:All

Automation Title

The title of the Automation

Field Type:Dimension

Data Views:Automations

Plans:All

Automation Total Click Rate

The all-time total click rate for the Automation

Field Type:Metric

Data Views:Automations

Plans:All

Automation Total Clicks

The all-time total clicks for the Automation

Field Type:Metric

Data Views:Automations

Plans:All

Automation Total Emails Sent

The all-time total number of emails sent for the Automation

Field Type:Metric

Data Views:Automations

Plans:All

Automation Total Open Rate

The all-time total open rate for the Automation

Field Type:Metric

Data Views:Automations

Plans:All

Automation Total Opens

The all-time total opens for the Automation

Field Type:Metric

Data Views:Automations

Plans:All

Automation Total Subscriber Opens

The all-time total unique subscriber clicks for the Automation

Field Type:Metric

Data Views:Automations

Plans:All

Automation Total Unique Opens

The all-time total of unique opens for the Automation

Field Type:Metric

Data Views:Automations

Plans:All

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

Plans:All

Campaign Abuse Reports

The number of abuse reports generated for a campaign

Field Type:Metric

Data Views:Campaigns

Plans:All

Campaign Currency Code

The currency code for Campaign Revenue and Campaign Spent metrics

Field Type:Dimension

Data Views:Campaigns

Plans:All

Campaign Emails Sent

The total number of emails sent for the campaign

Field Type:Metric

Data Views:Campaigns

Plans:All

Campaign Facebook Likes

The number of Facebook likes for the campaign

Field Type:Metric

Data Views:Campaigns

Plans:All

Campaign Facebook Recipient Likes

The number of recipients who liked the campaign on Facebook

Field Type:Metric

Data Views:Campaigns

Plans:All

Campaign Facebook Unique Likes

The number of unique Facebook likes for the campaign

Field Type:Metric

Data Views:Campaigns

Plans:All

Campaign Forwarded Opens

How many times the forwarded campaign has been opened

Field Type:Metric

Data Views:Campaigns

Plans:All

Campaign Forwards

How many times the campaign has been forwarded

Field Type:Metric

Data Views:Campaigns

Plans:All

Campaign Hard Bounces

The total number of hard bounced email addresses for the campaign

Field Type:Metric

Data Views:Campaigns

Plans:All

Campaign ID

The string that uniquely identifies a campaign

Field Type:Dimension

Data Views:Campaigns, Campaign Timeseries (Pro), Campaign Link Clicks (Pro)

Plans:All

Campaign Last Click Date

The date of the last recorded click for the campaign

Field Type:Dimension

Data Views:Campaigns

Plans:All

Campaign Last Open Date

The date of the last recorded open for the campaign

Field Type:Dimension

Data Views:Campaigns

Plans:All

Campaign Last Sent

The date a campaign was last sent

Field Type:Dimension

Data Views:Campaigns

Plans:All

Campaign Link ID

The unique ID of the campaign link

Field Type:Dimension

Data Views:Campaign Link Clicks

Plans:Pro

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

Plans:Pro

Campaign Link Total Click Percentage

The percentage of total clicks a link generated for a campaign

Field Type:Metric

Data Views:Campaign Link Clicks

Plans:Pro

Campaign Link Total Clicks

The number of total clicks for a campaign link

Field Type:Metric

Data Views:Campaign Link Clicks

Plans:Pro

Campaign Link Unique Click Percentage

The percentage of unique clicks a link generated for a campaign

Field Type:Metric

Data Views:Campaign Link Clicks

Plans:Pro

Campaign Link Unique Clicks

The number of unique clicks for a campaign link

Field Type:Metric

Data Views:Campaign Link Clicks

Plans:Pro

Campaign Link URL

The url of the campaign link

Field Type:Dimension

Data Views:Campaign Link Clicks

Plans:Pro

Campaign Opens

The total number of opens for the campaign

Field Type:Metric

Data Views:Campaigns

Plans:All

Campaign Orders

The total orders for the campaign

Field Type:Metric

Data Views:Campaigns

Plans:All

Campaign Preview Text

The preview text for the campaign

Field Type:Dimension

Data Views:Campaigns, Campaign Timeseries (Pro), Campaign Link Clicks (Pro)

Plans:All

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

Plans:All

Campaign RSS Last Sent

For RSS campaigns, the date of the last send

Field Type:Dimension

Data Views:Campaigns

Plans:All

Campaign Soft Bounces

The total number of soft bounced email addresses for the campaign

Field Type:Metric

Data Views:Campaigns

Plans:All

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

Plans:All

Campaign Subject Line

The subject line for the campaign

Field Type:Dimension

Data Views:Campaigns, Campaign Timeseries (Pro), Campaign Link Clicks (Pro)

Plans:All

Campaign Subscriber Clicks

The total number of subscribers who clicked on a campaign

Field Type:Metric

Data Views:Campaigns

Plans:All

Campaign Syntax Errors

The total number of addresses that were syntax-related bounces for the campaign

Field Type:Metric

Data Views:Campaigns

Plans:All

Campaign Title

The title of the campaign

Field Type:Dimension

Data Views:Campaigns, Campaign Timeseries (Pro), Campaign Link Clicks (Pro)

Plans:All

Campaign Total Clicks

The total number of clicks for the campaign

Field Type:Metric

Data Views:Campaigns

Plans:All

Campaign Type

The campaign type. Possible values: "regular", "plaintext", "absplit", "rss", or "variate

Field Type:Dimension

Data Views:Campaigns, Campaign Timeseries (Pro), Campaign Link Clicks (Pro)

Plans:All

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

Plans:All

Campaign Unique Clicks

The total number of unique clicks for links across a campaign

Field Type:Metric

Data Views:Campaigns

Plans:All

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

Plans:All

Campaign Unique Opens

The total number of unique opens for the campaign

Field Type:Metric

Data Views:Campaigns

Plans:All

Campaign Unsubscribes

The total number of unsubscribed members for the campaign

Field Type:Metric

Data Views:Campaigns

Plans:All

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

Plans:All

List Avg. Open Rate

The average open rate per campaign for the list

Field Type:Metric

Data Views:Campaigns, Automations

Plans:All

List Avg. Subs per Month

The average number of subscriptions per month for the list

Field Type:Metric

Data Views:Campaigns, Automations

Plans:All

List Avg. Unsubscribes per Month

The average number of unsubscriptions per month for the list

Field Type:Metric

Data Views:Campaigns, Automations

Plans:All

List Created Date

The date this list was created

Field Type:Dimension

Data Views:Campaigns, Automations, List Growth, Members (Pro), Campaign Timeseries (Pro), Campaign Link Clicks (Pro)

Plans:All

List Growth Cleaned

Newly cleaned (hard-bounced) members on the list for a specific month

Field Type:Metric

Data Views:List Growth

Plans:All

List Growth Deleted

Newly deleted members on the list for a specific month

Field Type:Metric

Data Views:List Growth

Plans:All

List Growth Month

The month that the growth history is describing

Field Type:Dimension

Data Views:List Growth

Plans:All

List Growth Pending

Pending members on the list for a specific month

Field Type:Metric

Data Views:List Growth

Plans:All

List Growth Reconfirmed

Newly reconfirmed members on the list for a specific month

Field Type:Metric

Data Views:List Growth

Plans:All

List Growth Total Subscribers

Total subscribed members on the list at the end of the month

Field Type:Metric

Data Views:List Growth

Plans:All

List Growth Transactional Emails

Subscribers that have been sent transactional emails via Mandrill

Field Type:Metric

Data Views:List Growth

Plans:All

List Growth Unsubscribed

Newly unsubscribed members on the list for a specific month

Field Type:Metric

Data Views:List Growth

Plans:All

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 (Pro), Campaign Timeseries (Pro), Campaign Link Clicks (Pro)

Plans:All

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 (Pro), Campaign Timeseries (Pro), Campaign Link Clicks (Pro)

Plans:All

List ID

A string that uniquely identifies the list

Field Type:Dimension

Data Views:Campaigns, Automations, List Growth, Members (Pro), Campaign Timeseries (Pro), Campaign Link Clicks (Pro)

Plans:All

List is Active

The status of the list used, namely if it's deleted or disabled

Field Type:Dimension

Data Views:Campaigns, Automations

Plans:All

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 (Pro), Campaign Timeseries (Pro), Campaign Link Clicks (Pro)

Plans:All

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 (Pro), Campaign Timeseries (Pro), Campaign Link Clicks (Pro)

Plans:All

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 (Pro), Campaign Timeseries (Pro), Campaign Link Clicks (Pro)

Plans:All

List Members

The number of active members in the list

Field Type:Metric

Data Views:Campaigns, Automations

Plans:All

List Members Cleaned

The number of members cleaned from the list

Field Type:Metric

Data Views:Campaigns, Automations

Plans:All

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

Plans:All

List Merge Variables

The number of merge vars for this list (not EMAIL, which is required)

Field Type:Metric

Data Views:Campaigns, Automations

Plans:All

List Name

The name of the list

Field Type:Dimension

Data Views:Campaigns, Automations, List Growth, Members (Pro), Campaign Timeseries (Pro), Campaign Link Clicks (Pro)

Plans:All

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

Plans:All

List Number of Campaigns

The number of campaigns in any status that use this list

Field Type:Metric

Data Views:Campaigns, Automations

Plans:All

List Rating

An auto-generated activity score for the list (0-5)

Field Type:Dimension

Data Views:Campaigns, Automations, List Growth, Members (Pro), Campaign Timeseries (Pro), Campaign Link Clicks (Pro)

Plans:All

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

Plans:All

List Unsubscribes

The number of members who have unsubscribed from the list

Field Type:Metric

Data Views:Campaigns, Automations

Plans:All

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

Plans:All

Member Avg. Click Rate

A subscriber's average clickthrough rate

Field Type:Metric

Data Views:Members

Plans:Pro

Member Avg. Open Rate

A subscriber's average open rate

Field Type:Metric

Data Views:Members

Plans:Pro

Member Consents to 1-to-1 Messaging

Indicates whether a contact consents to 1:1 messaging

Field Type:Dimension

Data Views:Members

Plans:Pro

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

Plans:Pro

Member Email

Email address for a subscriber

Field Type:Dimension

Data Views:Members

Plans:Pro

Member Email Client

The list member's email client

Field Type:Dimension

Data Views:Members

Plans:Pro

Member Email Type

Type of email this member asked to get ('html' or 'text')

Field Type:Dimension

Data Views:Members

Plans:Pro

Member Full Name

The contact's full name

Field Type:Dimension

Data Views:Members

Plans:Pro

Member ID

The MD5 hash of the lowercase version of the list member's email address

Field Type:Dimension

Data Views:Members

Plans:Pro

Member Interest Groups

Interest groups that subscriber is currently subscribed to

Field Type:Dimension

Data Views:Members

Plans:Pro

Member is VIP

Mailchimp VIP status for a subscriber

Field Type:Dimension

Data Views:Members

Plans:Pro

Member Language

If set/detected by Mailchimp, the subscriber's language

Field Type:Dimension

Data Views:Members

Plans:Pro

Member Location Country Code

The unique code for the location country of a member

Field Type:Dimension

Data Views:Members

Plans:Pro

Member Location DST Offset

The offset for timezones where daylight saving time is observed for a member

Field Type:Dimension

Data Views:Members

Plans:Pro

Member Location GMT Offset

The time difference in hours from GMT for a member

Field Type:Dimension

Data Views:Members

Plans:Pro

Member Location Lat/Long

The combined location latitude and longitude of a member in ISO 6709 format

Field Type:Dimension

Data Views:Members

Plans:Pro

Member Location Latitude

The location latitude of a member

Field Type:Dimension

Data Views:Members

Plans:Pro

Member Location Longitude

The location longitude of a member

Field Type:Dimension

Data Views:Members

Plans:Pro

Member Location Timezone

The timezone for the location of a member

Field Type:Dimension

Data Views:Members

Plans:Pro

Member Opt-in IP Address

The IP address the subscriber used to confirm their opt-in status

Field Type:Dimension

Data Views:Members

Plans:Pro

Member Rating

Mailchimp generated star rating for this member, between 1 and 5

Field Type:Dimension

Data Views:Members

Plans:Pro

Member Signup IP Address

IP address the subscriber signed up from

Field Type:Dimension

Data Views:Members

Plans:Pro

Member Source

The source from which the member was added to this list

Field Type:Dimension

Data Views:Members

Plans:Pro

Member Status

Subscriber's current status. Possible values: 'subscribed', 'unsubscribed', 'cleaned', 'pending', 'transactional', or 'archived'

Field Type:Dimension

Data Views:Members

Plans:Pro

Member Tags

Tags that are applied to the member (supports up to 50 tags)

Field Type:Dimension

Data Views:Members

Plans:Pro

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

Plans:Pro

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

Plans:Pro

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

Plans:Pro

Member Total Orders

The total number of orders placed by the list member

Field Type:Metric

Data Views:Members

Plans:Pro

Member Total Revenue

The total revenue the list member has brought in

Field Type:Metric

Data Views:Members

Plans:Pro

Member Total Revenue Currency Code

The three-letter ISO 4217 code for the currency that the store accepts

Field Type:Dimension

Data Views:Members

Plans:Pro

Member Unique ID

An identifier for the address across all of Mailchimp

Field Type:Dimension

Data Views:Members

Plans:Pro

Member Unsubscribe Reason

A subscriber's reason for unsubscribing

Field Type:Dimension

Data Views:Members

Plans:Pro

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

Plans:Pro

Timeseries Clicks

The number of clicks by hour of a campaign

Field Type:Metric

Data Views:Campaign Timeseries

Plans:Pro

Timeseries Date

The date for the 24 hour timeseries after a campaign is started

Field Type:Dimension

Data Views:Campaign Timeseries

Plans:Pro

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

Plans:Pro

Timeseries Emails Sent

The number of emails sent in by hour of a campaign

Field Type:Dimension

Data Views:Campaign Timeseries

Plans:Pro

Timeseries Hour of Campaign

The number of hours after a campaign started

Field Type:Dimension

Data Views:Campaign Timeseries

Plans:Pro

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

Plans:Pro

Timeseries Unique Opens

The number of unique opens by hour of a campaign

Field Type:Dimension

Data Views:Campaign Timeseries

Plans:Pro