Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| TIME | Year | year | dim | Year, e.g. 2017 |
| Year & month | yearmonth | dim | Year and month, e.g. 2017|06 | |
| Month | month | dim | Month, e.g. 6 | |
| Year & week (Sun-Sat) | yearweek | dim | Year and week for US weeks, e.g. 2017|08 | |
| Year & week (Mon-Sun) | yearweekiso | dim | Year and week for ISO weeks, e.g. 2017|08 | |
| Week (Sun-Sat) | week | dim | US week number, e.g. 51 | |
| Week (Mon-Sun) | weekiso | dim | ISO week number, e.g. 51 | |
| Day of week | dayofweek | dim | Day of week name for US fields, e.g. 0 Sunday | |
| Date | date | dim | Date, e.g. 2017-01-31 | |
| Hour | hour | dim | Hour of the day, e.g. 21 | |
| CAMPAIGN | Campaign ID | campaign_id | dim | A string that uniquely identifies the campaign |
| Campaign name | campaign_name | dim | ||
| Campaign type | campaign_type | dim | The type of the campaign, e.g. variate | |
| Campaign folder ID | campaign_folder_id | dim | The ID of the campaign folder | |
| Campaign folder name | campaign_folder_name | dim | The name of the campaign folder | |
| Campaign status | campaign_status | dim | Current status of the campaign | |
| Campaign created | campaign_created_date | dim | The date and time the campaign was created in ISO 8601 format | |
| Campaign last sent | campaign_last_sent_date | dim | ||
| Campaign last open | campaign_last_open | dim | The date and time of the last open for this campaign in ISO 8601 format | |
| Campaign last click | campaign_last_click | dim | ||
| RSS | Feed URL | rss_feed_url | dim | The URL of the RSS feed |
| Frequency | rss_frequency | dim | The frequency of the RSS campaign | |
| RSS last sent | rss_last_sent | dim | The date the campaign was last sent | |
| Content type | content_type | dim | How the campaign's content is put together | |
| Subject line | subject_line | dim | The subject line of the campaign | |
| From name | from_name | dim | The 'from' name on the campaign (not an email address) | |
| Reply to | reply_to | dim | The reply-to email address for the campaign | |
| To name | to_name | dim | The campaign's custom 'To' name | |
| Authenticate | authenticate | dim | Whether Mailchimp authenticated the campaign | |
| Auto footer | auto_footer | dim | Automatically append Mailchimp' default footer to the campaign | |
| Inline CSS | inline_css | dim | Automatically inline the CSS included with the campaign content | |
| Auto post to FB | auto_fb_post | dim | A list of Facebook page ids the campaign posts to automatically | |
| Auto tweet | auto_tweet | dim | Automatically tweet a link to the campaign archive page when the campaign is sent | |
| Facebook comments | fb_comments | dim | Allows Facebook comments on the campaign | |
| Timewarp | timewarp | dim | An hourly breakdown of sends, opens, and clicks if a campaign is sent using timewarp | |
| Template ID | template_id | dim | The individual id for the template | |
| Use conversation | use_conversation | dim | Use Mailchimp Conversation feature to manage out-of-office replies | |
| EEPURL | First tweet | eepurl_first_tweet | dim | The day and time of the first recorded tweet with a link to the campaign |
| Last tweet | eepurl_last_tweet | dim | The day and time of the last recorded tweet with a link to the campaign | |
| First click | eepurl_first_click | dim | The timestamp for the first click to the URL | |
| Last click | eepurl_last_click | dim | The timestamp for the last click to the URL | |
| DELIVERY STATUS | Status enabled | delivery_status_enabled | dim | Whether Campaign Delivery Status is enabled for this account and campaign |
| Delivery status | delivery_status_name | dim | Updates on campaigns in the process of sending | |
| Can be canceled | delivery_status_can_cancel | dim | Whether a campaign send can be canceled | |
| TRACKING | Tracking opens | tracking_opens | dim | Whether to track opens |
| Tracking HTML clicks | tracking_html_clicks | dim | Whether to track clicks in the HTML version of the campaign | |
| Tracking text clicks | tracking_text_clicks | dim | Whether to track clicks in the plain-text version of the campaign | |
| Goal tracking | goal_tracking | dim | Whether to enable Goal tracking | |
| Google Analytics tracking | tracking_google_analytics | dim | The custom slug for Google Analytics tracking | |
| eCommerce360 tracking | tracking_ecomm360 | dim | Whether to enable eCommerce360 tracking | |
| ClickTale tracking | tracking_clicktale | dim | The custom slug for ClickTale tracking | |
| Salesforce tracking | tracking_salesforce | dim | Salesforce tracking options for a campaign | |
| Capsule tracking | tracking_capsule | dim | Capsule tracking options for a campaign | |
| LIST | List ID | list_id | dim | The unique id for the list |
| List name | list_name | dim | The name of the list | |
| Subscribe URL (short) | subscribe_url_short | dim | Mailchimp's EepURL shortened version of this list's subscribe form | |
| Subscribe URL (long) | subscribe_url_long | dim | The full version of the list's subscribe form | |
| Permission reminder | permission_reminder | dim | The permission reminder for the list | |
| Notify email on subscribe | list_notify_on_subscribe | dim | The email address to send subscribe notifications to | |
| Notify email on unsubscribe | list_notify_on_unsubscribe | dim | The email address to send unsubscribe notifications to | |
| List rating | list_rating | dim | An auto-generated activity score for the list (0-5) | |
| Multiple email formats | list_email_type_option | dim | Whether the list supports multiple formats for emails | |
| Beamer URL | beamer_address | dim | The list's Email Beamer address | |
| List visibility | list_visibility | dim | Whether the list is public or private | |
| List modules | list_modules | dim | Any list-specific modules installed for the list | |
| List campaign defaults | campaign_defaults | dim | Default values for campaigns created for the list | |
| List created | list_created_date | dim | The date and time that the list was created in ISO 8601 format | |
| Last list subscribed | list_last_sub_date | dim | ||
| Last list unsubscribed | list_last_unsub_date | dim | ||
| LIST CONTACT | Contact details | contact | dim | Contact information displayed in campaign footers |
| Company | contact_company | dim | The company name for the list | |
| Address 1 | contact_address_1 | dim | The street address for the list contact | |
| Address 2 | contact_address_2 | dim | The street address for the list contact | |
| City | contact_city | dim | The city for the list contact | |
| State | contact_state | dim | The state for the list contact | |
| Zip code | contact_zip | dim | The postal or zip code for the list contact | |
| Contact country | contact_country | dim | A two-character ISO 3166 country code | |
| Phone | contact_phone | dim | The phone number for the list contact | |
| LIST MEMBERS | Member ID | member_id | dim | |
| Member email | member_email | dim | Email address for a subscriber | |
| Member status | member_status | dim | Subscriber's current status | |
| Full name | member_name | dim | ||
| First name | member_fname | dim | ||
| Last name | member_lname | dim | ||
| Member fields | member_fields | dim | ||
| Member rating | member_rating | dim | Star rating for the member, between 1 and 5 | |
| Member VIP | member_vip | dim | VIP status for the subscriber | |
| Member language | member_language | dim | The subscriber's language | |
| Member latitude | member_latitude | dim | The location latitude | |
| Member longitude | member_longitude | dim | The location longitude | |
| Member country | member_country | dim | ||
| Member GMT offset (hours) | member_gmtoff | dim | The time difference in hours from GMT | |
| Member timezone | member_timezone | dim | The timezone for the location | |
| Member email client | member_email_client | dim | The list member's email client | |
| Member email type | member_email_type | dim | Type of email the member asked to get | |
| Signup date | member_signup_date | dim | The date and time the subscriber signed up for the list in ISO 8601 format | |
| Signup IP | member_signup_ip | dim | IP address the subscriber signed up from | |
| Opt-in IP | member_opt_ip | dim | The IP address the subscriber used to confirm their opt-in status | |
| Opt-in date | member_opt_date | dim | The date and time the subscribe confirmed their opt-in status in ISO 8601 format | |
| Unsubscribe reason | member_unsubscribe_reason | dim | A subscriber's reason for unsubscribing | |
| Last changed | member_last_changed_date | dim | The date and time the member's info was last changed in ISO 8601 format | |
| LIST LOCATIONS | Location country | list_country_name | dim | The name of the country |
| Location country code | list_country_code | dim | The ISO 3166 2 digit country code | |
| AUTOMATION | Workflow email ID | workflow_email_id | dim | A string that uniquely identifies the Automation email |
| Automation ID | automation_id | dim | A string that identifies the Automation | |
| Automation name | automation_name | dim | ||
| Automation type | automation_type | dim | An absolute URI that identifies the problem type | |
| Automation created | automation_created_date | dim | The date and time the Automation was created in ISO 8601 format | |
| Automation started | automation_date_started | dim | The date and time the Automation was started in ISO 8601 format | |
| Automation status | automation_status | dim | The current status of the Automation | |
| Send immediately | send_immediately | dim | ||
| Trigger on import | trigger_on_import | dim | ||
| Run time | runtime | dim | ||
| INDUSTRY | Industry type | industry_type | dim | |
| A/B TESTING | AB test type | ab_test_type | dim | |
| AB test size | ab_test_size | dim | The percentage of recipients to send the test combinations to | |
| AB winner criteria | ab_winner_criteria | dim | The combination that performs the best | |
| AB winner wait time (min) | ab_wait_time | dim | The number of minutes to wait before choosing the winning campaign | |
| AB winner campaign id | ab_winner_campaign_id | dim | ||
| AB winner campaign name | ab_winner_campaign_name | dim | ||
| AB test A sent | ab_send_date_a | dim | ||
| AB test A last open | last_open_a | dim | The last open for Campaign A | |
| AB test B sent | ab_send_date_b | dim | ||
| AB test B last open | last_open_b | dim | The last open for Campaign B | |
| SENT & OPENED | Emails sent | emails_sent | met | The total number of emails sent for this campaign |
| Emails delivered | emails_delivered | met | The total number of emails confirmed sent for this campaign so far | |
| Emails cancelled | emails_cancelled | met | The total number of emails canceled for this campaign | |
| Delivery rate (%) | delivery_rate_perc | met | ||
| Unique opens | unique_opens | met | The total number of unique opens | |
| Total opens | opens_total | met | The total number of opens for a campaign | |
| Open rate (%) | open_rate_perc | met | The number of unique opens divided by the total number of successful deliveries | |
| BOUNCES | Bounces | bounces | met | The bounce summary for the campaign |
| Bounce rate (%) | bounce_rate_perc | met | ||
| Hard bounces | hard_bounces | met | The total number of hard bounced email addresses | |
| Soft bounces | soft_bounces | met | The total number of soft bounced email addresses | |
| Hard bounce rate (%) | hard_bounce_rate_perc | met | ||
| Soft bounce rate (%) | soft_bounce_rate_perc | met | ||
| Syntax errors | syntax_errors | met | The total number of addresses that were syntax-related bounces | |
| FORWARDS | Forwards | forwards_count | met | The forwards and forward activity for the campaign |
| Forward opens | forwards_opens | met | How many times the forwarded campaign has been opened | |
| ABUSE REPORTS | Abuse reports | abuse_reports | met | The number of abuse reports generated for this campaign |
| Abuse report rate (%) | abuse_rate_perc | met | The industry abuse rate | |
| UNSUBSCRIPTIONS | Unsubscribes | unsubscribes | met | A list of members who unsubscribed from a campaign |
| Unsubscription rate (%) | unsubscription_rate_perc | met | The average number of unsubscriptions per month for the list | |
| CLICKS | Unique clicks | unique_clicks | met | The total number of unique clicks for links across a campaign |
| Total clicks | clicks_total | met | The total number of clicks for the campaign | |
| Unique subscriber clicks | unique_subscriber_clicks | met | The total number of subscribers who clicked on a campaign | |
| Click rate (%) | click_rate_perc | met | The number of unique clicks divided by the total number of successful deliveries | |
| LIKES | Facebook likes | facebook_likes | met | The number of Facebook likes for the campaign |
| Unique likes | unique_likes | met | The number of unique likes | |
| Recipient likes | recipient_likes | met | The number of recipients who liked the campaign on Facebook | |
| ECOMMERCE | Total orders | ecommerce_total_orders | met | The total orders for a campaign |
| Total spent | ecommerce_total_spent | met | The total amount the customer has spent | |
| Total revenue | ecommerce_total_revenue | met | The total revenue for a campaign | |
| EEPURL | Twitter tweets | eepurl_tweets | met | The number of tweets including a link to the campaign |
| Retweets | eepurl_reweets | met | The number of retweets that include a link to the campaign | |
| EepURL clicks | eepurl_clicks | met | The total number of clicks to the campaign's URL | |
| A/B TESTING | Unique opens A | unique_opens_a | met | Unique opens for Campaign A |
| Unique opens B | unique_opens_b | met | Unique opens for Campaign B | |
| Total opens A | opens_a | met | Opens for Campaign A | |
| Total opens B | opens_b | met | Opens for Campaign B | |
| Bounces A | bounces_a | met | Bounces for Campaign A | |
| Bounces B | bounces_b | met | Bounces for Campaign B | |
| Forwards A | forwards_a | met | Forwards for Campaign A | |
| Forwards B | forwards_b | met | Forwards for Campaign B | |
| Forward opens A | forwards_opens_a | met | Opens from forwards for Campaign A | |
| Forward opens B | forwards_opens_b | met | Opens from forwards for Campaign B | |
| Abuse reports A | abuse_reports_a | met | Abuse reports for Campaign A | |
| Abuse reports B | abuse_reports_b | met | Abuse reports for Campaign B | |
| Unsubscriptions A | unsubs_a | met | Unsubscribes for Campaign A | |
| Unsubscriptions B | unsubs_b | met | Unsubscribes for Campaign B | |
| Recipient clicks A | recipients_click_a | met | Recipient Clicks for Campaign A | |
| Recipient clicks B | recipients_click_b | met | Recipient Clicks for Campaign B | |
| LIST ALL-TIME TOTALS | Campaign count | campaign_count | met | The number of campaigns in the folder |
| Member count | member_count | met | The number of active members in the list | |
| Member count since last send | member_count_since_send | met | The number of active members in the list since the last campaign was sent | |
| Cleaned count | cleaned_count | met | The number of members cleaned from the list | |
| Cleaned count since last send | cleaned_count_since_send | met | The number of members cleaned from the list since the last campaign was sent | |
| List unsubscribe count | list_unsubscribe_count | met | The number of members who have unsubscribed from the list | |
| List unsubscribe count since last send | unsubscribe_count_since_send | met | The number of members who have unsubscribed since the last campaign was sent | |
| List open rate (%) | list_open_rate_perc | met | The average open rate per campaign for the list | |
| List click rate (%) | list_click_rate_perc | met | The average click rate per campaign for the list | |
| List subscription rate (%) | list_avg_sub_rate_perc | met | The average number of subscriptions per month for the list | |
| List unsubscription rate (%) | list_avg_unsub_rate_perc | met | The average number of unsubscriptions per month for the list | |
| Target subscription rate (%) | list_target_sub_rate_perc | met | The target number of subscriptions per month for the list to keep it growing | |
| LIST METRICS BY TIME | Opt-in members | optins | met | Newly opted-in members on the list for a specific month |
| Imported members | imports | met | Imported members on the list for a specific month | |
| Removed members | removes | met | ||
| Subscribed members | subscribed | met | Newly subscribed members on the list for a specific month | |
| Unsubscribed members | unsubscribed | met | Newly unsubscribed members on the list for a specific month | |
| Reconfirmed members | reconfirmed | met | Newly reconfirmed members on the list for a specific month | |
| Cleaned members | cleaned | met | Newly cleaned (hard-bounced) members on the list for a specific month | |
| Pending members | pending | met | Pending members on the list for a specific month | |
| Deleted members | deleted | met | Newly deleted members on the list for a specific month | |
| Transactional subscribers | transactional | met | Subscribers that have been sent transactional emails via Mandrill | |
| LIST MEMBERS | Member avg. open rate (%) | member_avg_open_rate_perc | met | A subscriber's average open rate |
| Member avg. click rate (%) | member_avg_click_rate_perc | met | A subscriber's average clickthrough rate | |
| LIST LOCATIONS | Subscriber percent in country | list_location_subspercent | met | The percent of subscribers in the country |
| Total subscribers in country | list_location_substotal | met | The total number of subscribers in the country | |
| AUTOMATION ALL-TIME TOTALS | Automation open rate (%) | automation_open_rate_perc | met | The number of unique opens divided by the total number of successful deliveries |
| Automation click rate (%) | automation_click_rate_perc | met | The number of unique clicks, divided by the total number of successful deliveries | |
| INDUSTRY | Industry open rate (%) | industry_open_rate_perc | met | The industry open rate |
| Industry click rate (%) | industry_click_rate_perc | met | The industry click rate | |
| Industry bounce rate (%) | industry_bounce_rate_perc | met | The industry bounce rate | |
| Industry unopen rate (%) | industry_unopen_rate_perc | met | The industry unopened rate | |
| Industry unsubscription rate (%) | industry_unsub_rate_perc | met | The industry unsubscribe rate | |
| Industry abuse report rate (%) | industry_abuse_rate_perc | met | The industry abuse rate | |
| DEPRECATED | Existing members | existing | met | Existing members on the list for a specific month. Please note that this field will be removed on 2020-03-24 |