Fields Reference · Mailchimp

Mailchimp Fields List

204 fields · 0 dimensions · 0 metrics · 18 groups

Data Studio

Google Sheets

BigQuery

View Mailchimp connector →

204 of 204

Field name	Label	Category	Description
`automatic_tweet`	Automatic tweet	Campaign	Automatically tweet a link to the campaign archive page when the campaign is sent.
`campaign_archive_url`	Campaign archive URL	Campaign	The link to the campaign’s archive version in ISO 8601 format.
`campaign_resendable`	Campaign resendable	Campaign	Determines if the campaign qualifies to be resent to non-openers.
`can_be_canceled`	Can be canceled	Campaign	Whether a campaign send can be canceled.
`currency_code`	Currency code	Campaign	Currency code.
`emails_sent`	E-mails sent	Campaign	The total number of emails sent for this campaign.
`facebook_likes`	Facebook likes	Campaign	The number of Facebook likes for the campaign.
`preview_text`	Preview text	Campaign	The preview text for the campaign.
`recipient_likes`	Recipient likes	Campaign	The number of recipients who liked the campaign on Facebook.
`rss_last_send`	RSS last send	Campaign	For RSS campaigns, the date and time of the last send.
`send_time`	Send time	Campaign	The date and time a campaign was sent.
`total_spent`	Total spent	Campaign	The total spent for a campaign. Calculated as the sum of all order totals with no deductions.
`track_clicktale`	Track ClickTale	Campaign	The custom slug for ClickTale tracking (max of 50 bytes).
`track_ecommerce`	Track E-commerce	Campaign	Whether to enable e-commerce tracking.
`track_google_analytics`	Track Google Analytics	Campaign	The custom slug for Google Analytics tracking (max of 50 bytes).
`track_html_clicks`	Track HTML clicks	Campaign	Whether to track clicks in the HTML version of the campaign. Defaults to true. Cannot be set to false for variate campaigns.
`track_opens`	Track opens	Campaign	Whether to track opens. Defaults to true. Cannot be set to false for variate campaigns.
`track_text_clicks`	Track text clicks	Campaign	Whether to track clicks in the plain-text version of the campaign. Defaults to true. Cannot be set to false for variate campaigns.
`unique_likes`	Unique likes	Campaign	The number of unique likes.
`unsubscribed`	Unsubscribed	Campaign	The total number of unsubscribed members for this campaign.
`date`	Date	Time	Date.
`day_of_week`	Day of week (Mon – Sun)	Time	Day of week (Mon – Sun)
`hour_of_day`	Hour of day	Time	Hour of the day.
`month`	Month	Time	Month.
`month_day`	Month day	Time	Month and day.
`quarter`	Quarter	Time	Quarter.
`week`	Week	Time	Week.
`year`	Year	Time	Year.
`year_month`	Month and year	Time	Month and year.
`year_quarter`	Quarter and year	Time	Quarter and year.
`year_week`	Week and year	Time	Week and year.
`address1`	Address 1	List	The street address for the list contact.
`address2`	Address 2	List	The street address for the list contact.
`city`	City	List	The city for the list contact.
`company`	Company	List	The company name for the list.
`country`	Country	List	A two-character ISO3166 country code. Defaults to US if invalid.
`default_from_email`	Default from email	List	The default from email for campaigns sent to this list.
`default_from_name`	Default from name	List	The default from name for campaigns sent to this list.
`default_language`	Default language	List	The default language for this lists’s forms.
`default_subject`	Default subject	List	The default subject line for campaigns sent to this list.
`double_optin`	Double optin	List	Whether or not to require the subscriber to confirm subscription via email.
`has_marketing_permissions`	Has marketing permissions	List	Whether or not the list has marketing permissions (eg. GDPR) enabled.
`has_welcome`	Has welcome	List	Whether or not this list has a welcome automation connected. Welcome Automations: welcomeSeries, singleWelcome, emailFollowup.
`list_all_time_open_rate`	List all-time open rate	List	The average open rate (a percentage represented as a number between 0 and 100) per campaign for the list. This won’t be present if Mailchimp haven’t calculated it yet for this list.
`list_average_unsubscriptions_per_month`	List average unsubscriptions per month	List	The average number of unsubscriptions per month for the list. This won’t be present if Mailchimp haven’t calculated it yet for this list.
`list_campaign_last_sent_date`	List campaign last sent date	List	The date and time the last campaign was sent to this list. This is updated when a campaign is sent to 10 or more recipients.
`list_cleaned_count_since_send`	List cleaned count since send	List	The number of members cleaned from the list since the last campaign was sent.
`list_click_rate`	List click rate	List	The average click rate (a percentage represented as a number between 0 and 100) per campaign for the list. This won’t be present if Mailchimp haven’t calculated it yet for this list.
`list_creation_date`	List creation date	List	The date and time that this list was created.
`list_hard_bounces`	List hard bounces	List	The total number of hard bounced email addresses for this list.
`list_id`	List ID	List	The unique list id.
`list_last_subscribe_date`	List last subscribe date	List	The date and time of the last time someone subscribed to this list.
`list_last_unsubscribe_date`	List last unsubscribe date	List	The date and time of the last time someone unsubscribed to this list.
`list_member_count_since_send`	List member count since send	List	The number of active members in the list since the last campaign was sent.
`list_merge_field_count`	List merge field count	List	The number of merge fields (audience field) for this list (doesn’t include EMAIL).
`list_modules`	List modules	List	Any list-specific modules installed for this list.
`list_name`	List name	List	The name of the list.
`list_rating_number`	List rating (Number)	List	An auto-generated activity score for the list (0-5).
`list_rating_star`	List rating (Star)	List	An auto-generated activity score for the list (0-5).
`list_signup_form_link`	List signup form link	List	The full version of this list’s subscribe form (host will vary).
`list_soft_bounces`	List soft bounces	List	The total number of soft bounced email addresses for this list.
`list_unique_opens`	List unique opens	List	The total number of unique opens for this list.
`list_unsubscribes_since_send`	List unsubscribes since send	List	The number of members who have unsubscribed since the last campaign was sent.
`list_visibility`	List visibility	List	Legacy – visibility settings are no longer used Possible values: “pub” or “prv”.
`multiple_email_formats`	Multiple email formats	List	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.
`notify_on_subscribe`	Notification email for subscribes	List	The email address to send subscribe notifications to.
`notify_on_unsubscribe`	Notification email for unsubscribes	List	The email address to send unsubscribe notifications to.
`other_adds`	Other adds	List	The number of subscribers who may have been added outside of the double opt-in process, such as imports or API activity.
`other_removes`	Other removes	List	The number of subscribers who may have been removed outside of unsubscribing or reporting an email as spam (for example, deleted subscribers).
`permission_reminder`	Permission reminder	List	The permission reminder for the list.
`phone_number`	Phone number	List	The phone number for the list contact.
`recipient_clicks`	Recipient clicks	List	The number of clicks.
`recipient_count`	Recipient count	List	Count of the recipients on the associated list.
`state`	State	List	The state for the list contact.
`subscribe_url_short`	Subscribe URL (short)	List	URL shortened version of this list’s subscribe form.
`subscribes`	subscribes	List	The number of subscribes.
`use_archive_bar`	Use archive bar	List	Whether campaigns for this list use the Archive Bar in archives by default.
`zip_code`	ZIP code	List	The postal or zip code for the list contact.
`e_commerce_average_orders_revenue_members`	E-commerce average orders revenue members	List members	Calculated as member total revenue/member total orders
`member_average_click_through_rate`	Member average click-through rate	List members	A subscriber’s average clickthrough rate.
`member_consents_to_one_to_one_messaging`	Member consents 1:1 messaging	List members	Indicates whether a contact consents to 1:1 messaging.
`member_contact_id`	Member contact ID	List members	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.
`member_coordinates`	Member coordinates	List members	Member latitude and longitude coordinates.
`member_country`	Member country	List members	The member country.
`member_country_code`	Member country code	List members	The unique code for the location country.
`member_currency_code`	Member currency code	List members	The three-letter ISO 4217 code for the currency that the store accepts.
`member_dst_offset`	Member DST offset	List members	The offset for timezones where daylight saving time is observed.
`member_email`	Member email	List members	The list member’s email client.
`member_email_address`	Member email address	List members	Email address for a subscriber.
`member_email_type`	Member email type	List members	Type of email this member asked to get (‘html’ or ‘text’).
`member_gtm_offset`	Member GTM offset	List members	The time difference in hours from GMT.
`member_id`	Member ID	List members	The MD5 hash of the lowercase version of the list member’s email address.
`member_ip_opt`	Member IP opt	List members	The IP address the subscriber used to confirm their opt-in status.
`member_ip_signup`	Member IP sign up	List members	IP address the subscriber signed up from.
`member_language`	Member language	List members	If set/detected, the subscriber’s language.
`member_last_change_date`	Member last change date	List members	The date and time the member’s info was last changed.
`member_last_note`	Member last note	List members	The content of the note.
`member_last_note_created_by`	Member last note created by	List members	The author of the note.
`member_last_note_creation_date`	Member last note creation date	List members	The date and time the note was created.
`member_last_note_id`	Member last note ID	List members	The note id.
`member_name`	Member name	List members	The contact’s full name.
`member_number_of_orders`	Member number of orders	List members	The total number of orders placed by the list member.
`member_open_rate`	Member open rate	List members	A subscriber’s average open rate.
`member_optin_date`	Member opt-in date	List members	The date and time the subscribe confirmed their opt-in status.
`member_rating_number`	Member rating (Number)	List members	Star rating for this member, between 1 and 5.
`member_rating_star`	Member rating (Star)	List members	Star rating for this member, between 1 and 5.
`member_region`	Member region	List members	The region for the location.
`member_signup_date`	Member signup date	List members	The date and time the subscriber signed up for the list.
`member_source`	Member source	List members	The source from which the subscriber was added to this list.
`member_status`	Member status	List members	Subscriber’s current status. Possible values: “subscribed”, “unsubscribed”, “cleaned”, “pending”, “transactional”, or “archived”.
`member_tags`	Member tags	List members	Returns up to 50 tags applied to this member.
`member_tags_count`	Member tags count	List members	The number of tags applied to this member.
`member_timezone`	Member timezone	List members	The timezone for the location.
`member_total_revenue`	Member total revenue	List members	The total revenue the list member has brought in.
`member_unique_email_id`	Member unique email ID	List members	An identifier for the address across all of Mailchimp.
`member_unsubscribe_reason`	Member unsubscribe reason	List members	A subscriber’s reason for unsubscribing.
`member_vip`	Member VIP	List members	VIP status for subscriber.
`ab_test_send_date`	A/B test send date	A/B testing	The possible send times to test. The times provided should be in the format YYYY-MM-DD HH:MM:SS. If send_times are provided to test, the test_size will be set to 100% and winner_criteria will be ignored.
`ab_test_size`	A/B test size	A/B testing	The percentage of recipients to send the test combinations to, must be a value between 10 and 100.
`ab_test_wait_time`	A/B test wait time	A/B testing	The number of minutes to wait before choosing the winning campaign. The value of wait_time must be greater than 0 and in whole hours, specified in minutes.
`ab_test_winner_campaign_ID`	A/B test winner campaign ID	A/B testing	ID of the campaign that was sent to the remaining recipients based on the winning combination.
`ab_winner_criteria`	A/B winner criteria	A/B testing	The combination that performs the best. This may be determined automatically by click rate, open rate, or total revenue — or you may choose manually based on the reporting data you find the most valuable. For Multivariate Campaigns testing send_time, winner_criteria is ignored. For Multivariate Campaigns with ‘manual’ as the winner_criteria, the winner must be chosen in the Mailchimp web application. Possible values: “opens”, “clicks”, “manual”, or “total_revenue”.
`abuse_reports_a`	Abuse reports A	A/B testing	Abuse reports for Campaign A. Mailchimp does not return information about Multivariate Campaigns.
`abuse_reports_b`	Abuse reports B	A/B testing	Abuse reports for Campaign B. Mailchimp does not return information about Multivariate Campaigns.
`bounces_a`	Bounces A	A/B testing	Bounces for Campaign A. Mailchimp does not return information about Multivariate Campaigns.
`bounces_b`	Bounces B	A/B testing	Bounces for Campaign B. Mailchimp does not return information about Multivariate Campaigns.
`clicks_a`	Clicks A	A/B testing	Recipient clicks for Campaign A. Mailchimp does not return information about Multivariate Campaigns.
`clicks_b`	Clicks B	A/B testing	Recipient clicks for Campaign B. Mailchimp does not return information about Multivariate Campaigns.
`forwards_a`	Forwards A	A/B testing	Forwards for Campaign A. Mailchimp does not return information about Multivariate Campaigns.
`forwards_b`	Forwards B	A/B testing	Forwards for Campaign B. Mailchimp does not return information about Multivariate Campaigns.
`forwards_opens_a`	Forwards opens A	A/B testing	Opens from forwards for Campaign A. Mailchimp does not return information about Multivariate Campaigns.
`forwards_opens_b`	Forwards opens B	A/B testing	Opens from forwards for Campaign B. Mailchimp does not return information about Multivariate Campaigns.
`last_open_date_a`	Last open date A	A/B testing	Last open for Campaign A. Mailchimp does not return information about Multivariate Campaigns.
`last_open_date_b`	Last open date B	A/B testing	Last open for Campaign B. Mailchimp does not return information about Multivariate Campaigns.
`opens_a`	Opens A	A/B testing	Opens for Campaign A. Mailchimp does not return information about Multivariate Campaigns.
`opens_b`	Opens B	A/B testing	Opens for Campaign B. Mailchimp does not return information about Multivariate Campaigns.
`unique_opens_a`	Unique opens A	A/B testing	Unique opens for Campaign A. Mailchimp does not return information about Multivariate Campaigns.
`unique_opens_b`	Unique opens B	A/B testing	Unique opens for Campaign B. Mailchimp does not return information about Multivariate Campaigns.
`unsubs_a`	Unsubscribes A	A/B testing	Unsubscribes for Campaign A. Mailchimp does not return information about Multivariate Campaigns.
`unsubs_b`	Unsubscribes B	A/B testing	Unsubscribes for Campaign B. Mailchimp does not return information about Multivariate Campaigns.
`campaign_creation_date`	Campaign creation date	Campaign details	The date and time the campaign was created.
`campaign_folder_id`	Campaign folder ID	Campaign details	If the campaign is listed in a folder, the id for that folder.
`campaign_id`	Campaign ID	Campaign details	A string that uniquely identifies this campaign.
`campaign_last_click_date`	Campaign last click date	Campaign details	The date and time of the last recorded click for the campaign.
`campaign_last_open_date`	Campaign last open date	Campaign details	The date and time of the last recorded open.
`campaign_name`	Campaign name	Campaign details	The title of the campaign.
`campaign_status`	Campaign status	Campaign details	The current status of the campaign. Possible values: “save”, “paused”, “schedule”, “sending”, “sent”, “canceled”, “canceling”, or “archived”.
`campaign_type`	Campaign type	Campaign details	The type of campaign (regular, plain-text, ab_split, rss, automation, variate, or auto).
`delivery_status_enabled`	Delivery status enabled	Campaign details	Whether Campaign Delivery Status is enabled for this account and campaign.
`delivery_status_name`	Delivery status name	Campaign details	The current state of a campaign delivery. Possible values: “delivering”, “delivered”, “canceling”, or “canceled”.
`authenticate`	Authenticate	Email content	Whether Mailchimp authenticated the campaign. Defaults to true.
`campaign_hour_of_the_day`	Campaign hour of the day	Email content	The hour of the day a campaign was sent.
`content_type`	Content type	Email content	How the campaign’s content is put together. Possible values: “template”, “html”, “url”, or “multichannel”.
`from_name`	From name	Email content	The ‘from’ name on the campaign (not an email address).
`reply_to`	Reply to	Email content	The reply-to email address for the campaign.
`subject_line`	Subject line	Email content	The subject line for the campaign.
`to_name`	To name	Email content	The campaign’s custom ‘To’ name. Typically the first name audience field.
`use_of_auto_footer`	Use of auto footer	Email content	Automatically append Mailchimp’s default footer to the campaign.
`use_of_conversation`	Use of conversation	Email content	Use Mailchimp Conversation feature to manage out-of-office replies.
`campaign_bounce_rate`	Campaign bounce rate	Bounces	Calculated as Campaign bounces / Emails sent.
`campaign_bounces`	Campaign bounces	Bounces	The total number of bounced email addresses.
`campaign_hard_bounce_rate`	Campaign hard bounce rate	Bounces	Calculated as Campaign hard bounces / Emails sent.
`campaign_hard_bounces`	Campaign hard bounces	Bounces	The total number of hard bounced email addresses.
`campaign_soft_bounce_rate`	Campaign soft bounce rate	Bounces	Calculated as Campaign soft bounces / Emails sent.
`campaign_soft_bounces`	Campaign soft bounces	Bounces	The total number of soft bounced email addresses.
`campaign_syntax_error_bounces`	Campaign syntax error bounces	Bounces	The total number of addresses that were syntax-related bounces.
`industry_abuse_rate`	Industry abuse rate	Industry benchmarks	The industry abuse rate.
`industry_bounce_rate`	Industry bounce rate	Industry benchmarks	The industry bounce rate.
`industry_click_rate`	Industry click rate	Industry benchmarks	The industry click rate.
`industry_open_rate`	Industry open rate	Industry benchmarks	The industry open rate.
`industry_type`	Industry type	Industry benchmarks	The type of business industry associated with your account. For example: retail, education, etc.
`industry_unopen_rate`	Industry unopen rate	Industry benchmarks	The industry unopen rate.
`industry_unsubscribe_rate`	Industry unsubscribe rate	Industry benchmarks	The industry unsub rate.
`automation_creation_date`	Automation creation date	Automation details	The date and time the Automation was created.
`automation_id`	Automation ID	Automation details	A string that identifies the Automation.
`automation_name`	Automation name	Automation details	The title of the Automation.
`automation_start_date`	Automation start date	Automation details	The date and time the Automation was started.
`automation_status`	Automation status	Automation details	The current status of the Automation. Possible values: “save”, “paused”, or “sending”.
`automation_type`	Automation type	Automation details	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”.
`campaign_delivery_rate`	Campaign delivery rate	Campaign insights	Calculated as Campaign bounces / Emails sent.
`campaign_emails_canceled`	Campaign emails canceled	Campaign insights	The total number of emails canceled for this campaign.
`campaign_open_rate`	Campaign open rate	Campaign insights	The number of unique opens divided by the total number of successful deliveries.
`campaign_opens`	Campaign opens	Campaign insights	The total number of opens for a campaign.
`unique_opens`	Unique opens	Campaign insights	The total number of unique opens.
`list_average_subscriptions_per_month`	List average subscriptions per month	List all-time totals	The average number of subscriptions per month for the list. This won’t be present if Mailchimp haven’t calculated it yet for this list.
`list_target_growth_rate`	List target growth rate	List all-time totals	The target number of subscriptions per month for the list to keep it growing (not returned if Mailchimp hasn’t calculated it yet).
`list_total_campaigns`	List total campaigns	List all-time totals	The number of campaigns in any status that use this list.
`list_total_contacts`	List total contacts	List all-time totals	The number of contacts in the list, including subscribed, unsubscribed, pending, cleaned, deleted, transactional, and those that need to be reconfirmed.
`list_total_members`	List total members	List all-time totals	The number of active members in the list.
`campaign_click_rate`	Campaign click rate	Clicks	The number of unique clicks divided by the total number of successful deliveries.
`campaign_total_clicks`	Campaign total clicks	Clicks	The total number of clicks for the campaign.
`campaign_unique_clicks`	Campaign unique clicks	Clicks	The total number of unique clicks for links across a campaign.
`campaign_unique_subscriber_clicks`	Campaign unique subscriber clicks	Clicks	The total number of subscribers who clicked on a campaign.
`e_commerce_average_orders_revenue_campaign`	E-commerce average orders revenue campaign	E-commerce	Calculated as member total revenue/member total orders
`e_commerce_total_orders`	E-commerce total orders	E-commerce	The total orders for a campaign.
`e_commerce_total_revenue`	E-commerce total revenue	E-commerce	The total revenue for a campaign. Calculated as the sum of all order totals minus shipping and tax totals.
`list_cleaned_members`	List cleaned members	List insights	The number of members cleaned from the list.
`list_emails_sent`	List emails sent	List insights	The total number of emails sent for this list.
`list_unsubscribed_members`	List unsubscribed members	List insights	The number of members who have unsubscribed from the list.
`campaign_abuse_rate`	Campaign abuse rate	Abuse reports	Calculated as Campaign abuse / Emails sent.
`campaign_abuse_reports`	Campaign abuse reports	Abuse reports	The number of abuse reports generated for this campaign.
`campaign_forward_opens`	Campaign forward opens	Campaign forwards	How many times the forwarded campaign has been opened.
`campaign_forwards`	Campaign forwards	Campaign forwards	How many times the campaign has been forwarded.
`workflow_title`	Workflow title	Automation	The title of the workflow type.