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 of week (Sun-Sat) | yearOfWeek | dim | Year of week for US-style Sunday-Saturday weeks, e.g. 2017 | |
| Year of week (Mon-Sun) | yearOfWeekIso | dim | Year of week for ISO standard Monday-Sunday weeks, 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-style Sunday-Saturday weeks, e.g. 2017|08 | |
| Year & week (Mon-Sun) | yearWeekIso | dim | Year and week for ISO standard Monday-Sunday 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 month | dayOfMonth | dim | Day of month, e.g. 2 | |
| Day of week (Sun-Sat) | dayOfWeekName | dim | Day of week number & name for US-style Sunday-Saturday weeks, e.g. 0 Sunday | |
| Day of week (Mon-Sun) | dayOfWeekNameIso | dim | Day of week number & name for ISO standard Monday to Sunday weeks, e.g. 1 Sunday | |
| Date | date | dim | Date, e.g. 2017-01-31 | |
| ADVERTISER | Advertiser | advertiser | dim | Name of advertiser, typically an agency or brand |
| Advertiser ID | advertiser_id | dim | Unique ID of the advertiser | |
| CAMPAIGN | Campaign group | line_item | dim | Name of the campaign group, which organizes campaigns into one marketing initiative |
| Campaign | campaign | dim | Name of the campaign, which consists of creatives, targeting, and technical parameters to drive objectives | |
| Campaign ID | campaign_id | dim | Unique ID of the campaign | |
| Campaign type | campaign_type | dim | Describes the type of campaign, native or video | |
| NATIVE AD | Creative ad | native_ad | dim | Name of ad creative |
| Creative ad ID | native_ad_id | dim | Unique ID of ad creative | |
| Heading | heading | dim | Heading text used in ad creative | |
| Tagline | tagline | dim | Tagline text used in ad creative | |
| Click URL | click_url | dim | URL used in ad creative to drive users to a specific site | |
| BASIC | Impressions | impressions | met | Total number of Impressions served |
| Unique impressions | impressions_unique | met | Total number of unique people who were shown an ad | |
| Clicks | clicks | met | Total number of clicks registered | |
| CTR | ctr | met | Click-through rate; Clicks divided by impressions | |
| Media cost | cost | met | Total budget spent on campaign | |
| CPC | cpc | met | Cost per click; Cost divided by clicks | |
| CPM | cpm | met | Cost per mille; Cost divided by impressions x 1000 | |
| CPE | cpe | met | Cost per engagement; Cost divided by engagement | |
| CONVERSIONS | Conversions | conversions | met | Total number of times conversion event took place |
| Conversion rate | cvr | met | Conversions divided by clicks | |
| Cost per conversion | cpa | met | Cost divided by clicks | |
| Impression conversions | impression_conversions | met | Number of impression conversions | |
| Click conversions | click_conversions | met | Number of click conversions | |
| Conversion revenue | conversion_revenue | met | Revenue generated through conversions | |
| Revenue | revenue | met | Total budget spent including margin | |
| Profit | profit | met | Margin kept from total budget | |
| View-through conversions | viewthrough_conversions | met | Number of view-through conversions | |
| Unique conversions | unique_conversions | met | Number of times a unique conversion event took place | |
| ENGAGEMENT | Page starts | page_starts | met | Number of times user spent least 2 seconds on site |
| 15s Engagements (LP) | page_time_15s | met | Number of times user has spent at least 15 seconds on the advertiser's domain after clicking the ad | |
| Total time on page | page_time | met | Total time spent on site | |
| Engagement rate | engagement_rate | met | Engagement divided by clicks | |
| VIDEO | Video started | vcomp_0 | met | Video views started |
| Video completed to 25 % | vcomp_25 | met | Video watched to at least 25 % | |
| Video completed to 50 % | vcomp_50 | met | Video watched to at least 50 % | |
| Video completed to 75 % | vcomp_75 | met | Video watched to at least 75 % | |
| Video completed | vcomp_95 | met | Video watched to at least 95 % | |
| Completion rate | vcomp_rate | met | Video completion rate |