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; Media cost divided by Clicks | |
CPM | cpm | met | Cost per mille; Media cost divided by Impressions x 1000 | |
CPE | cpe | met | Cost per click; Media cost divided by Engagement | |
eCPCL | ecpcl | met | Effective cost per completed listen. Calculated by Media cost / Audio completed | |
Frequency | frequency | met | Impressions per unique impression | |
Third-party CPC cost | tpcpc_cost | met | Third-party CPC cost | |
Third-party CPM cost | tpcpm_cost | met | Third-party CPM cost | |
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 | Media cost divided by Conversions | |
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 | |
Cookie conversions | cookie_conversions | met | Cookie conversions | |
IP conversions | ip_conversions | met | IP conversions | |
Secondary conversions | secondary_conversions | met | Secondary conversions | |
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 | |
Average time on site | atos | met | Average time on site (seconds) | |
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. Calculated by Video completed / Video started | |
AUDIO | Audio started | audio_starts | met | Audio started |
Audio completed | audio_completions | met | Audio completed | |
Audio completion rate | audio_completion_rate | met | Listen through rate, calculated by Audio completed / Audio started | |
REVENUE | rCPA | rcpa | met | Revenue cost per action. Calculated by Revenue / Conversions |
rCPC | rcpc | met | Revenue cost per click. Calculated by Revenue / Click | |
rCPCL | rcpcl | met | Revenue cost per completed listen. Calculated by Revenue / Audio completed | |
rCPE | rcpe | met | Revenue cost per engagement. Calculated by Revenue / 15s Engagements (LP) | |
rCPM | rcpm | met | Revenue cost per mile. Calculated by (Revenue / Impressions) * 1000 | |
ROAS | roas | met | Return on ad spend. Calculated by Revenue / Media cost |