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 | |
| Query | Start date | system_metadata.query_date_range_start | The start date of the requested query |
| End date | system_metadata.query_date_range_end | The end date of the requested query | |
| Timezone | system_metadata.query_timezone | The timezone that is supplied to the query | |
| Filters | system_metadata.query_filters | All filters used in the query | |
| Start | system_metadata.query_date_start | When the query was started | |
| End | system_metadata.query_date_end | When the query completed | |
| Duration | system_metadata.query_duration | The duration in seconds of the query | |
| Accounts | system_metadata.query_accounts | A list of accounts of which the data was pulled from | |
| Datasource | Data source logins | system_metadata.data_source_logins | The data source login accounts that were used to authenticate against the data source |
| Data source login owners | system_metadata.data_source_login_owners | The Supermetrics users that created the data source login connections |