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 | |
| 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 | |
| Domain | domain | dim | Returns the unique Internet address for a website | |
| Package name | package_name | dim | Name of the package | |
| Package ID | package_id | dim | ID of the package | |
| 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 | |
| TARGET AUDIENCE | Target segment group A name | target_segment_groupa_name | dim | Name of the target segment in as defined in target audience group A |
| Target segment group A ID | target_segment_groupa_ID | dim | Id of the target segment in as defined in target audience group A | |
| Target segment group B name | target_segment_groupb_name | dim | Name of the target segment in as defined in target audience group B | |
| Target segment group B ID | target_segment_groupb_ID | dim | Id of the target segment in as defined in target audience group B | |
| LINE | Line ID | line_id | dim | The unique identifier of the line |
| Line | line | dim | The name of the line | |
| Line schedule name | line_schedule_name | dim | Name of line schedule | |
| Line daily budget schedule | line_daily_budget_schedule | dim | The daily budget assigned to a line for a given schedule. This dimension is populated only for a line that has the line schedule and remains null for a line that does not have the schedule | |
| Line current schedule total budget | line_current_schedule_total_budget | dim | The total budget assigned to the current schedule in a line. For past or future schedules, the total budget set to that schedule is shown | |
| 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 | |
| Unique households | unique_households | met | For CTV lines, the number of unique households. EU users may have access to limited data because of privacy restriction | |
| 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 | |
| Query | Start date | system_metadata.query_date_range_start | dim | The start date of the requested query |
| End date | system_metadata.query_date_range_end | dim | The end date of the requested query | |
| Timezone | system_metadata.query_timezone | dim | The timezone that is supplied to the query | |
| Filters | system_metadata.query_filters | dim | All filters used in the query | |
| Start | system_metadata.query_date_start | dim | When the query was started | |
| End | system_metadata.query_date_end | dim | When the query completed | |
| Duration | system_metadata.query_duration | dim | The duration in seconds of the query | |
| Accounts | system_metadata.query_accounts | dim | A list of accounts of which the data was pulled from | |
| Excluded invalid accounts | system_metadata.query_excluded_accounts | dim | A list of unavailable accounts excluded from the query due to the "Exclude invalid accounts" setting | |
| Datasource | Data source logins | system_metadata.data_source_logins | dim | The data source login accounts that were used to authenticate against the data source |
| Data source login owners | system_metadata.data_source_login_owners | dim | The Supermetrics users that created the data source login connections |