Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| Time | Year | campaign_year | dim | |
| Year of week (Sun-Sat) | campaign_year_of_week | dim | ||
| Year of week (Mon-Sun) | campaign_year_of_week_iso | dim | ||
| Year & month | campaign_year_month | dim | ||
| Month | campaign_month | dim | ||
| Year & week (Sun-Sat) | campaign_year_week | dim | ||
| Year & week (Mon-Sun) | campaign_year_week_iso | dim | ||
| Week (Sun-Sat) | campaign_week | dim | ||
| Week (Mon-Sun) | campaign_week_iso | dim | ||
| Day of month | campaign_day_of_month | dim | ||
| Day of week (Sun-Sat) | campaign_day_of_week_name | dim | ||
| Day of week (Mon-Sun) | campaign_day_of_week_name_iso | dim | ||
| Date | campaign_date | dim | ||
| Datetime | campaign_atom | dim | ||
| CAMPAIGN | Campaign ID | campaign_campaign_id | dim | Campaign_id. |
| Campaign name | campaign_campaign_name | dim | Name of the campaign. | |
| Subject | campaign_subject | dim | Subject of the campaign. | |
| Sender name | campaign_from_name | dim | Name of the campaign sender. | |
| Type | campaign_type | dim | The campaign type. | |
| Status | campaign_status | dim | The status of the campaign. | |
| URL | campaign_url | dim | The URL of the campaign. | |
| Sent to all subscribers | campaign_all_contacts | dim | Whether or not the campaign was sent to all subscribers instead of specific segments. | |
| Segments | campaign_segments | dim | The segments the campaign was sent to. | |
| Creation date | campaign_created_at | dim | The date when the campaign was created. | |
| Creation datetime | campaign_created_at_datetime | dim | The datetime when the campaign was created. | |
| Last updated date | campaign_updated_at | dim | The date when the campaign was last updated. | |
| Last updated datetime | campaign_updated_at_datetime | dim | The datetime when the campaign was last updated. | |
| Start date | campaign_start_date | dim | The date when the campaign started. | |
| Start datetime | campaign_start_datetime | dim | The datetime when the campaign started. | |
| End date | campaign_end_date | dim | The date when the campaign ended. | |
| End datetime | campaign_end_datetime | dim | The datetime when the campaign ended. | |
| Sends | campaign_campaign_details__sent | met | The amount of times the campaign email has been sent. | |
| Opens | campaign_campaign_details__opened | met | The amount of times the campaign email has been opened. | |
| Open rate | campaign_campaign_details__open_rate | met | The amount of opened emails divided by the amount sent | |
| Clicks | campaign_campaign_details__clicks | met | The amount of times the campaign email links have been clicked. | |
| Click rate | campaign_campaign_details__click_rate | met | The amount of link clicks divided by the amount sent | |
| Bounces | campaign_campaign_details__bounces | met | The amount of times the campaign email has bounced. | |
| Bounce rate | campaign_campaign_details__bounce_rate | met | The amount of bounces divided by the amount sent | |
| Complaints | campaign_campaign_details__complaints | met | The amount of complaints the campaign has received. | |
| Complaint rate | campaign_campaign_details__complaint_rate | met | The amount of complaints divided by the amount sent | |
| Unsubscribes | campaign_campaign_details__unsubscribes | met | The amount of contacts who have unsubscribed from the campaign | |
| Unsubscribe rate | campaign_campaign_details__unsubscribe_rate | met | The amount of unsubscribed contacts divided by the amount sent | |
| Number of campaigns | campaign_campaign_details__number_of_campaigns | met | Total number of campaigns. | |
| Opens (mobile) | campaign_campaign_details__opened_mobile | met | The amount of times the campaign email has been opened on mobile devices. | |
| Opens (desktop) | campaign_campaign_details__opened_desktop | met | The amount of times the campaign email has been opened on desktop devices. | |
| Opens (tablet) | campaign_campaign_details__opened_tablet | met | The amount of times the campaign email has been opened on tablet devices. | |
| Open rate (mobile) | campaign_campaign_details__open_rate_mobile | met | The amount of opened emails on mobile devices divided by the amount sent | |
| Open rate (desktop) | campaign_campaign_details__open_rate_desktop | met | The amount of opened emails on desktop devices divided by the amount sent | |
| Open rate (tablet) | campaign_campaign_details__open_rate_tablet | met | The amount of opened emails on tablet devices divided by the amount sent | |
| Clicks (mobile) | campaign_campaign_details__clicks_mobile | met | The amount of times the campaign email links have been clicked on mobile devices. | |
| Clicks (desktop) | campaign_campaign_details__clicks_desktop | met | The amount of times the campaign email links have been clicked on desktop devices. | |
| Clicks (tablet) | campaign_campaign_details__clicks_tablet | met | The amount of times the campaign email links have been clicked on tablet devices. | |
| Click rate (mobile) | campaign_campaign_details__click_rate_mobile | met | The amount of link clicks on mobile devices divided by the amount sent | |
| Click rate (desktop) | campaign_campaign_details__click_rate_desktop | met | The amount of link clicks on desktop devices divided by the amount sent | |
| Click rate (tablet) | campaign_campaign_details__click_rate_tablet | met | The amount of link clicks on tablet devices divided by the amount sent | |
| Time | Year | ab_test_year | dim | |
| Year of week (Sun-Sat) | ab_test_year_of_week | dim | ||
| Year of week (Mon-Sun) | ab_test_year_of_week_iso | dim | ||
| Year & month | ab_test_year_month | dim | ||
| Month | ab_test_month | dim | ||
| Year & week (Sun-Sat) | ab_test_year_week | dim | ||
| Year & week (Mon-Sun) | ab_test_year_week_iso | dim | ||
| Week (Sun-Sat) | ab_test_week | dim | ||
| Week (Mon-Sun) | ab_test_week_iso | dim | ||
| Day of month | ab_test_day_of_month | dim | ||
| Day of week (Sun-Sat) | ab_test_day_of_week_name | dim | ||
| Day of week (Mon-Sun) | ab_test_day_of_week_name_iso | dim | ||
| Date | ab_test_date | dim | ||
| Datetime | ab_test_atom | dim | ||
| A/B TEST DETAILS | Campaign ID | ab_test_id | dim | Campaign ID. |
| Campaign name | ab_test_campaign_name | dim | Name of the campaign. | |
| A/B test start date | ab_test_start_date | dim | The start date of the A/B test. | |
| A/B test start datetime | ab_test_start_datetime | dim | The start datetime of the A/B test. | |
| A/B test end date | ab_test_end_date | dim | The end date of the A/B test. | |
| A/B test end datetime | ab_test_end_datetime | dim | The end datetime of the A/B test. | |
| A/B test sender name | ab_test_ab_test_details__from_name | dim | The name of the sender of the A/B test. | |
| A/B test subject | ab_test_ab_test_details__subject | dim | The subject of the A/B test. | |
| Is the winning A/B test | ab_test_ab_test_details__is_winner | dim | Whether or not this is the winning A/B test variant. | |
| A/B test sends | ab_test_ab_test_details__sent | met | The amount of times the A/B test email has been sent. | |
| A/B test opens | ab_test_ab_test_details__opened | met | The amount of times the A/B test email has been opened. | |
| A/B test open rate | ab_test_ab_test_details__open_rate | met | The amount of opened emails divided by the amount sent | |
| A/B test clicks | ab_test_ab_test_details__clicks | met | The amount of times the A/B test email links have been clicked. | |
| A/B test click rate | ab_test_ab_test_details__click_rate | met | The amount of link clicks divided by the amount sent | |
| A/B test bounces | ab_test_ab_test_details__bounces | met | The amount of times the A/B test email has bounced. | |
| A/B test bounce rate | ab_test_ab_test_details__bounce_rate | met | The amount of bounces divided by the amount sent | |
| A/B test complaints | ab_test_ab_test_details__complaints | met | The amount of complaints the A/B test has received. | |
| A/B test complaint rate | ab_test_ab_test_details__complaint_rate | met | The amount of complaints divided by the amount sent | |
| A/B test unsubscribes | ab_test_ab_test_details__unsubscribes | met | The amount of contacts who have unsubscribed from the A/B test | |
| A/B test unsubscribe rate | ab_test_ab_test_details__unsubscribe_rate | met | The amount of unsubscribed contacts divided by the amount sent |