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