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 of week (Sun-Sat) | yearOfWeek | dim | ||
Year of week (Mon-Sun) | yearOfWeekIso | dim | ||
Year & month | yearMonth | dim | ||
Month | month | dim | ||
Year & week (Sun-Sat) | yearWeek | dim | ||
Year & week (Mon-Sun) | yearWeekIso | dim | ||
Week (Sun-Sat) | week | dim | ||
Week (Mon-Sun) | weekIso | dim | ||
Day of month | dayOfMonth | dim | ||
Day of week (Sun-Sat) | dayOfWeekName | dim | ||
Day of week (Mon-Sun) | dayOfWeekNameIso | dim | ||
Date | date | dim | ||
Hour | hour | dim | ||
OBJECTS | Publisher ID | publisher_id | dim | The unique identifier of the publisher |
Publisher | publisher_name | dim | The name of the publisher | |
Layout | layout | dim | The name of the layout expressed in terms of its dimensions | |
Advertiser | advertiser | dim | The name of the advertiser | |
Advertiser ID | advertiser_id | dim | The unique identifier of the advertiser | |
Advertiser currency | advertiser_currency | dim | The currency used by the advertiser | |
Campaign | campaign | dim | The name of the campaign | |
Campaign ID | campaign_id | dim | The unique identifier of the campaign | |
Campaign start date | campaign_start_date | dim | The start date of the campaign | |
Campaign end date | campaign_end_date | dim | The end date of the campaign | |
Campaign total budget | campaign_total_budget | dim | The total budget allocated to the campaign for the lifetime of the campaign | |
Line ID | line_id | dim | The unique identifier of the line | |
Line | line | dim | The name of the line | |
Ad | ad | dim | The name of the ad | |
Ad ID | ad_id | dim | The unique identifier of the ad | |
Creative | creative | dim | The name of the creative | |
Creative ID | creative_id | dim | The unique identifier of the creative | |
Media type | media_type | dim | The media type of the creative | |
LOCATION | Country | country | dim | Name of the consumer's country |
Country code | countryCode | dim | Two-letter code of the consumer's country | |
Region | region | dim | Name of the consumer's region or state | |
City | city | dim | Name of the consumer's city | |
Postal code | postal_code | dim | Name of the consumer's zip code or postal code | |
DEVICE | Device category name | device_category_name | dim | The name of the mobile operating system |
Device category ID | device_category_ID | dim | The device category ID | |
Browser type name | browser_type_name | dim | The name of the consumer's browser | |
Browser type ID | browser_type_id | dim | The ID of the consumer's browser | |
Desktop OS name | desktop_OS_name | dim | The name of the consumer's operating system. Possible values: Mac OS X, Windows, Linux, Unknown | |
Desktop OS ID | desktop_OS_ID | dim | The ID of the consumer's operating system | |
AUDIENCE | Age | age | dim | The age group expressed as a range of ages. For example, 25-34 |
Gender | gender | dim | The gender of the segment. Possible values: Male, Female, Unknown | |
PIXEL | Pixel ID | pixel_id | dim | The beacon ID of the conversion rule |
Pixel name | pixel_name | dim | The name of the conversion rule | |
BASIC | Impressions | impressions | met | The total amount of times an ad has been displayed |
Measurable impressions | measurable_impressions | met | Tracks the number of impressions measured for viewability. Note that not all impressions may be measured because of technical limitations or publisher page design | |
Viewable impressions | viewable_impressions | met | The total amount of times an ad has been displayed while in view | |
Clicks | clicks | met | The amount of times an ad has been clicked | |
CTR | ctr | met | Click-through rate | |
Cost | cost | met | ||
Network profit | profit | met | The total profit of the network | |
CPA | cpa | met | Cost per action | |
CPC | cpc | met | Cost per click | |
CPCV | cpcv | met | Cost per completed video view | |
CPM | cpm | met | Cost per a thousand impressions | |
vCPM | vcpm | met | Cost per a thousand viewable impressions | |
Unique Viewers | unique_viewers | met | The number of unique users | |
Moat viewable impressions | moat_viewable_impressions | met | Moat viewable impressions | |
Moat viewability rate | moat_viewability_rate | met | The Moat viewable rate for display metrics. Moat viewable impressions divided by Moat measurable impressions | |
Moat measurable impressions | moat_measurable_impressions | met | Moat measurable impressions for display metrics | |
Moat measurability rate | moat_measurability_rate | met | The Moat measurability rate, the percentage of impressions where Moat viewability was measurable | |
Non-viewable impressions | non_viewable_impressions | met | The number of impressions that were not viewable | |
CONVERSIONS | Conversions | conversions | met | The total amount of conversions |
Conversion rate | cvr | met | Conversions divided by clicks | |
Conversion value | conversion_value | met | The ROAS conversion value | |
Click-through conversions | click_conversions | met | The amount of times a user clicks on an ad impression, and eventually converts on the advertiser’s site who served the ad | |
View-through conversions | view_conversions | met | The amount of times a user views an ad impression | |
Cross-device conversions | cross_device_conversions | met | The amount of cross-device conversions | |
VIDEO | Video view starts | video_views | met | The amount of times a video was started |
Video views 25% | video_completions_25 | met | Number of video starts that resulted in at least a 25% completed video | |
Video views 50% | video_completions_50 | met | Number of video starts that resulted in at least a 50% completed video | |
Video views 75% | video_completions_75 | met | Number of video starts that resulted in at least a 75% completed video | |
Completed views | video_completions | met | Video views that resulted in 100% completion | |
Video view rate 25% | video_completion_rate_25 | met | Percentage of video starts that resulted in at least a 25% completed video | |
Video view rate 50% | video_completion_rate_50 | met | Percentage of video starts that resulted in at least a 50% completed video | |
Video view rate 75% | video_completion_rate_75 | met | Percentage of video starts that resulted in at least a 75% completed video | |
Video completion rate | vcr | met | Percentage of video views that resulted in 100% completion | |
COST | Publisher earnings | publisher_earnings | met | The amount paid to publishers |
Order management fee | order_management_fee | met | The order management fee | |
Seat tech fee | seat_tech_fee | met | The seat tech fee | |
Seat data fee | seat_data_fee | met | The seat data fee | |
Seat management fee | seat_management_fee | met | The seam management fee | |
Yahoo data fees | yahoo_data_fees | met | The Yahoo data fees | |
Third party data fees | third_party_data_fees | met | Third party data fees | |
Estimated billable amount | estimated_billable_amount | met | The costs and fees associated with lines or campaigns |