Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
Category | Field | Code | Description |
---|---|---|---|
TIME | Year | year | Year, e.g. 2017 |
Year & month | yearmonth | Year and month, e.g. 2017|06 | |
Month | month | Month, e.g. 6 | |
Year & week (Sun-Sat) | yearweek | Year and week for US weeks, e.g. 2017|08 | |
Year & week (Mon-Sun) | yearweekiso | Year and week for ISO weeks, e.g. 2017|08 | |
Week (Sun-Sat) | week | US week number, e.g. 51 | |
Week (Mon-Sun) | weekiso | ISO week number, e.g. 51 | |
Day of week | dayofweek | Day of week name for US fields, e.g. 0 Sunday | |
Date | date | Date, e.g. 2017-01-31 | |
Hour | hour | Hour of the day, e.g. 21 | |
CAMPAIGN | Campaign ID | campaign_id | A string that uniquely identifies the campaign |
Campaign name | campaign_name | ||
Campaign type | campaign_type | The type of the campaign, e.g. variate | |
Campaign folder ID | campaign_folder_id | The ID of the campaign folder | |
Campaign folder name | campaign_folder_name | The name of the campaign folder | |
Campaign status | campaign_status | Current status of the campaign | |
Campaign created | campaign_created_date | The date and time the campaign was created in ISO 8601 format | |
Campaign last sent | campaign_last_sent_date | ||
Campaign last open | campaign_last_open | The date and time of the last open for this campaign in ISO 8601 format | |
Campaign last click | campaign_last_click | ||
RSS | Feed URL | rss_feed_url | The URL of the RSS feed |
Frequency | rss_frequency | The frequency of the RSS campaign | |
RSS last sent | rss_last_sent | The date the campaign was last sent | |
Content type | content_type | How the campaign's content is put together | |
Subject line | subject_line | The subject line of the campaign | |
From name | from_name | The 'from' name on the campaign (not an email address) | |
Reply to | reply_to | The reply-to email address for the campaign | |
To name | to_name | The campaign's custom 'To' name | |
Authenticate | authenticate | Whether Mailchimp authenticated the campaign | |
Auto footer | auto_footer | Automatically append Mailchimp' default footer to the campaign | |
Inline CSS | inline_css | Automatically inline the CSS included with the campaign content | |
Auto post to FB | auto_fb_post | A list of Facebook page ids the campaign posts to automatically | |
Auto tweet | auto_tweet | Automatically tweet a link to the campaign archive page when the campaign is sent | |
Facebook comments | fb_comments | Allows Facebook comments on the campaign | |
Timewarp | timewarp | An hourly breakdown of sends, opens, and clicks if a campaign is sent using timewarp | |
Template ID | template_id | The individual id for the template | |
Use conversation | use_conversation | Use Mailchimp Conversation feature to manage out-of-office replies | |
EEPURL | First tweet | eepurl_first_tweet | The day and time of the first recorded tweet with a link to the campaign |
Last tweet | eepurl_last_tweet | The day and time of the last recorded tweet with a link to the campaign | |
First click | eepurl_first_click | The timestamp for the first click to the URL | |
Last click | eepurl_last_click | The timestamp for the last click to the URL | |
DELIVERY STATUS | Status enabled | delivery_status_enabled | Whether Campaign Delivery Status is enabled for this account and campaign |
Delivery status | delivery_status_name | Updates on campaigns in the process of sending | |
Can be canceled | delivery_status_can_cancel | Whether a campaign send can be canceled | |
TRACKING | Tracking opens | tracking_opens | Whether to track opens |
Tracking HTML clicks | tracking_html_clicks | Whether to track clicks in the HTML version of the campaign | |
Tracking text clicks | tracking_text_clicks | Whether to track clicks in the plain-text version of the campaign | |
Goal tracking | goal_tracking | Whether to enable Goal tracking | |
Google Analytics tracking | tracking_google_analytics | The custom slug for Google Analytics tracking | |
eCommerce360 tracking | tracking_ecomm360 | Whether to enable eCommerce360 tracking | |
ClickTale tracking | tracking_clicktale | The custom slug for ClickTale tracking | |
Salesforce tracking | tracking_salesforce | Salesforce tracking options for a campaign | |
Capsule tracking | tracking_capsule | Capsule tracking options for a campaign | |
LIST | List ID | list_id | The unique id for the list |
List name | list_name | The name of the list | |
Subscribe URL (short) | subscribe_url_short | Mailchimp's EepURL shortened version of this list's subscribe form | |
Subscribe URL (long) | subscribe_url_long | The full version of the list's subscribe form | |
Permission reminder | permission_reminder | The permission reminder for the list | |
Notify email on subscribe | list_notify_on_subscribe | The email address to send subscribe notifications to | |
Notify email on unsubscribe | list_notify_on_unsubscribe | The email address to send unsubscribe notifications to | |
List rating | list_rating | An auto-generated activity score for the list (0-5) | |
Multiple email formats | list_email_type_option | Whether the list supports multiple formats for emails | |
Beamer URL | beamer_address | The list's Email Beamer address | |
List visibility | list_visibility | Whether the list is public or private | |
List modules | list_modules | Any list-specific modules installed for the list | |
List campaign defaults | campaign_defaults | Default values for campaigns created for the list | |
List created | list_created_date | The date and time that the list was created in ISO 8601 format | |
Last list subscribed | list_last_sub_date | ||
Last list unsubscribed | list_last_unsub_date | ||
LIST CONTACT | Contact details | contact | Contact information displayed in campaign footers |
Company | contact_company | The company name for the list | |
Address 1 | contact_address_1 | The street address for the list contact | |
Address 2 | contact_address_2 | The street address for the list contact | |
City | contact_city | The city for the list contact | |
State | contact_state | The state for the list contact | |
Zip code | contact_zip | The postal or zip code for the list contact | |
Contact country | contact_country | A two-character ISO 3166 country code | |
Phone | contact_phone | The phone number for the list contact | |
LIST MEMBERS | Member ID | member_id | |
Member email | member_email | Email address for a subscriber | |
Member status | member_status | Subscriber's current status | |
Full name | member_name | ||
First name | member_fname | ||
Last name | member_lname | ||
Member fields | member_fields | ||
Member rating | member_rating | Star rating for the member, between 1 and 5 | |
Member VIP | member_vip | VIP status for the subscriber | |
Member language | member_language | The subscriber's language | |
Member latitude | member_latitude | The location latitude | |
Member longitude | member_longitude | The location longitude | |
Member country | member_country | ||
Member GMT offset (hours) | member_gmtoff | The time difference in hours from GMT | |
Member timezone | member_timezone | The timezone for the location | |
Member email client | member_email_client | The list member's email client | |
Member email type | member_email_type | Type of email the member asked to get | |
Signup date | member_signup_date | The date and time the subscriber signed up for the list in ISO 8601 format | |
Signup IP | member_signup_ip | IP address the subscriber signed up from | |
Opt-in IP | member_opt_ip | The IP address the subscriber used to confirm their opt-in status | |
Opt-in date | member_opt_date | The date and time the subscribe confirmed their opt-in status in ISO 8601 format | |
Unsubscribe reason | member_unsubscribe_reason | A subscriber's reason for unsubscribing | |
Last changed | member_last_changed_date | The date and time the member's info was last changed in ISO 8601 format | |
LIST LOCATIONS | Location country | list_country_name | The name of the country |
Location country code | list_country_code | The ISO 3166 2 digit country code | |
AUTOMATION | Workflow email ID | workflow_email_id | A string that uniquely identifies the Automation email |
Automation ID | automation_id | A string that identifies the Automation | |
Automation name | automation_name | ||
Automation type | automation_type | An absolute URI that identifies the problem type | |
Automation created | automation_created_date | The date and time the Automation was created in ISO 8601 format | |
Automation started | automation_date_started | The date and time the Automation was started in ISO 8601 format | |
Automation status | automation_status | The current status of the Automation | |
Send immediately | send_immediately | ||
Trigger on import | trigger_on_import | ||
Run time | runtime | ||
INDUSTRY | Industry type | industry_type | |
A/B TESTING | AB test type | ab_test_type | |
AB test size | ab_test_size | The percentage of recipients to send the test combinations to | |
AB winner criteria | ab_winner_criteria | The combination that performs the best | |
AB winner wait time (min) | ab_wait_time | The number of minutes to wait before choosing the winning campaign | |
AB winner campaign id | ab_winner_campaign_id | ||
AB winner campaign name | ab_winner_campaign_name | ||
AB test A sent | ab_send_date_a | ||
AB test A last open | last_open_a | The last open for Campaign A | |
AB test B sent | ab_send_date_b | ||
AB test B last open | last_open_b | The last open for Campaign B |