Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| Time | Year | standard_year | dim | |
| Year of week (Sun-Sat) | standard_year_of_week | dim | ||
| Year of week (Mon-Sun) | standard_year_of_week_iso | dim | ||
| Year & month | standard_year_month | dim | ||
| Month | standard_month | dim | ||
| Year & week (Sun-Sat) | standard_year_week | dim | ||
| Year & week (Mon-Sun) | standard_year_week_iso | dim | ||
| Week (Sun-Sat) | standard_week | dim | ||
| Week (Mon-Sun) | standard_week_iso | dim | ||
| Day of month | standard_day_of_month | dim | ||
| Day of week (Sun-Sat) | standard_day_of_week_name | dim | ||
| Day of week (Mon-Sun) | standard_day_of_week_name_iso | dim | ||
| Date | standard_date | dim | ||
| Datetime | standard_atom | dim | ||
| Advertiser | Advertiser name | standard_advertiser_name | dim | The name of the advertiser. |
| Brand | Brand | standard_brand | dim | The name of the brand. |
| Brand market | standard_brand_market | dim | The market of the brand. | |
| Brand region | standard_brand_region | dim | The region of the brand. | |
| Campaign | Campaign | standard_campaign | dim | The name of the campaign. |
| Media | Media property | standard_media_property | dim | Media property. |
| Media type | standard_media_type | dim | Media type. | |
| Delivery | Delivery site | standard_delivery_site | dim | Delivery site. |
| Placement | Placement name | standard_placement_name | dim | Placement name where the product is being promoted. |
| Placement code | standard_placement_code | dim | Ad Server Placement code. | |
| Placement size | standard_placement_size | dim | Placement size. | |
| Geo | Delivery country | standard_delivery_country | dim | Delivery country. Only compatible with 'geo' metrics |
| DMA/MMA | standard_dma_mma | dim | Designated market area. Only compatible with 'geo' metrics | |
| State/Region | standard_state_region | dim | State/Region. Only compatible with 'geo' metrics. | |
| Device | Device delivery type | standard_device_delivery_typ | dim | Device delivery type. |
| App | App ID | standard_app_id | dim | ID of the app. |
| App name | standard_app_name | dim | Name of the app. | |
| App store | standard_app_store | dim | Name of the app store. | |
| App store category | standard_app_store_category | dim | Category of the app store. | |
| App developer | standard_app_developer | dim | App developer name. | |
| App bundle | standard_app_bundle | dim | App bundle. | |
| App age rating | standard_app_age_rating | dim | App age rating. | |
| CTV app | CTV app ID | standard_ctv_app_id | dim | CTV app ID. |
| CTV app name | standard_ctv_app_name | dim | CTV app name. | |
| CTV app store | standard_ctv_app_store | dim | CTV app store name. | |
| CTV app store category | standard_ctv_app_store_category | dim | CTV app store category. | |
| CTV app developer | standard_ctv_app_developer | dim | CTV app developer. | |
| CTV device name | standard_ctv_device_name | dim | CTV device name. | |
| CTV app bundle | standard_ctv_app_bundle | dim | CTV app bundle name. | |
| CTV app age rating | standard_ctv_app_age_rating | dim | CTB app age rating. | |
| Requests | standard_requests | met | The count of requests received by the blocking tag when the blocking service is used. | |
| Blocks | standard_blocks | met | The count of requests that are blocked because they do not meet the blocking criteria for a DV digital IQ campaign. | |
| Block rate | standard_block_rate | met | The percentage of requests that are blocked because they do not meet the blocking criteria for a DV digital IQ campaign. Blocks / requests | |
| Allowed ads | standard_allowed_ads | met | Unique count of requests that were allowed because they met the blocking criteria for your DV Digital IQ campaign and had no violations. | |
| Allowed ad rate | standard_allowed_rate | met | Percentage of unique count of requests that were allowed because they met the blocking criteria for your DV Digital IQ campaign and had no violations. Allowed ads / monitored ads | |
| Allowed evaluations | standard_allowed_evaluations | met | The number of Evaluations that were determined to be compliant based on your Brand Suitability Geo, or Fraud profiles. | |
| Evaluations | standard_evaluations | met | The total number of non-GIVT video ad calls that Video Filtering assessed. | |
| Monitored ads | standard_monitored_ads | met | The total count of ads served where the DV monitoring services were applied. | |
| Authentic ads | standard_authentic_ads | met | Ads served in a brand-specific, high-quality environment that meets the settings of your DV Digital IQ profile, improving the performance of your campaigns. | |
| Authentic rate | standard_authentic_rate | met | The percentage of ads served in a brand-specific, high-quality environment that meets the settings of your DV Digital IQ profile, improving the performance of your campaigns. Authentic ads / monitored ads | |
| Measured impressions | standard_measured_impressions | met | The count of impressions where the DV successfully measured the ad. | |
| Measurement Rate | standard_measurement_rate | met | The Measurement Rate provides a confidence level for each of the viewability dimensions so you can assess the broadness of the data used to determine a dimension. | |
| Viewable impressions | standard_viewable_impressions | met | Impressions across desktop, mobile web and mobile in-app delivery that were measured as viewable according to the IAB viewability guideline. | |
| Viewable rate | standard_viewable_rate | met | Impressions percentage across desktop, mobile web and mobile in-app delivery that were measured as viewable according to the IAB viewability guideline. | |
| Custom Viewable Impressions | standard_custom_viewable_impressions | met | The total time of viewable impressions in hours. | |
| Incidents | standard_unique_incidents | met | The deduplicated count of all incidents found when ads in your campaign did not meet the criteria of your DV digital IQ profile. | |
| Incident rate | standard_incident_rate | met | Percentage of all incidents found when ads in your campaign did not meet the criteria of your DV Digital IQ profile. Unique incidents / monitored ads | |
| Brand suitable ads | standard_brand_suitable_ads | met | Ads that were served on pages, sites or app free from brand suitability and brand safety floor incidents. | |
| Brand suitability blocks | standard_brand_suitability_blocks | met | Represents the count of filters, incidents and requests from apps, sites or pages that served or were prevented from being served because they did not meet one or more of the brand suitability settings. | |
| Brand suitable rate | standard_brand_suitable_rate | met | Percentage of which the ads that were served on pages, sites or app free from brand suitability and brand safety floor incidents. Brand suitable ads / monitored ads | |
| Brand suitability incidents | standard_brand_suitability_incidents | met | Count of incidents from apps, sites or pages that served or were prevented from being served because they did not meet one or more of the brand suitability settings. | |
| Brand suitability incident rate | standard_brand_suitability_incident_rate | met | Percentage of incidents from apps, sites or pages that served or were prevented from being served because they did not meet one or more of the brand suitability settings. Brand suitability incidents / monitored ads | |
| UC app incidents | standard_uc_app_incidents | met | The number of app impressions that triggered a brand suitability incident due to a client's unsuitable content category settings. | |
| Site & app list incidents | standard_site_and_app_list_incidents | met | Site and app list violations represent the deduplicated count of incidents on or from sites and/or apps listed in your site and/or app exclusion list or not on your site and/or app inclusion in your brand suitability profile(s). | |
| Authentic completed fully on-screen impressions | standard_authentic_completed_fully_on_screen_impressions | met | The count of video authentic ads for which DV was able to obtain the information needed to determine whether the creative was fully within the visible portion of the browser and to receive the signals that indicate the end of the quartile. | |
| Fraud/SIVT blocks | standard_fraud_sivt_blocks | met | Count of blocks recorded as bot fraud, site fraud, nonhuman data center traffic and injected ad events. | |
| Fraud blocks | standard_fraud_blocks | met | The deduplicated count of requests that are blocked for any form of fraud. | |
| Fraud/SIVT block rate | standard_fraud_sivt_rate | met | Percentage of filters, incidents or blocks recorded as bot fraud, site fraud, nonhuman data center traffic and injected ad events. Fraud/SIVT blocks / monitored ads | |
| Fraud/SIVT free ads | standard_fraud_sivt_free_ads | met | The unique count of ads free from bot fraud, site fraud, nonhuman data center traffic, hijacked devices, and injected ads. | |
| Fraud/SIVT free rate | standard_fraud_sivt_free_rate | met | Percentage of unique count of ads free from bot fraud, site fraud, nonhuman data center traffic, hijacked devices, and injected ads. Fraud/SIVT free ads / monitored ads | |
| Fraud/SIVT incidents | standard_fraud_sivt_incidents | met | Count of incidents recorded as bot fraud, site fraud, nonhuman data center traffic and injected ad events. | |
| In geo ads | standard_in_geo_ads | met | Ads served inside the designated geographic targeting area. | |
| In geo rate | standard_in_geo_rate | met | Percentage of ads served inside the designated geographic targeting area. In geo ads / monitored ads | |
| Out of geo blocks | standard_out_of_geo_blocks | met | Show the number of blocks for requests from outside the designated geographic targeting area. | |
| Out of geo rate | standard_out_of_geo_rate | met | Percentage of ads served outside the designated geographic targeting area. out of geo incidents / monitored ads | |
| Out of geo incidents | standard_out_of_geo_incidents | met | Show the number of ads served outside the designated geographic targeting area. | |
| Display measured impressions | standard_display_measured_impressions | met | Impressions for which DV was able to obtain the information needed to make decisions about viewability. | |
| Display measurement rate | standard_display_measurement_rate | met | percentage of impressions for which DV was able to obtain the information needed to make decisions about viewability. Display measured impressions / display eligible impressions | |
| Display viewable impressions | standard_display_viewable_impressions | met | The count of impressions that met the IAB guideline for viewability. | |
| Display viewable rate | standard_display_viewable_rate | met | Percentage of impressions that met the IAB guideline for viewability. Display viewable impressions / display measured impressions | |
| Display eligible impression | standard_display_eligible_impressions | met | Impressions that had the potential to be measured for display viewability. | |
| Eligible impression | standard_eligible_impressions | met | Impressions that had the potential to be measured for display viewability. | |
| Authentic Viewable impressions | standard_authentic_display_viewable_impressions | met | An authentic Viewable impression includes an additional layer of analysis that shows when an authentic impression also met the IAB viewability guideline. | |
| Authentic Viewable Rate | standard_authentic_display_viewable_rate | met | percentage of authentic Viewable impressions that include an additional layer of analysis that shows when an authentic impression also met the IAB viewability guideline. Authentic Viewable impressions / measured impressions | |
| Custom display viewable impressions | standard_custom_display_viewable_impressions | met | Impressions (desktop delivery only) that were in view as determined using the custom viewability measurement definition for the profile. | |
| Custom display viewable rate | standard_custom_display_viewable_rate | met | Percentage of impressions (desktop delivery only) that were in view as determined using the custom viewability measurement definition for the profile. Custom display viewable impressions / display measured impressions | |
| 100% display Viewable impressions | standard_impressions_100_percent_display_viewable | met | The number of impressions where 100% of the creative was in the viewable portion of the browser for at least one second. | |
| 100% display viewable rate | standard_rate_100_percent_display_viewable | met | Percentage of impressions where 100% of the creative was in the viewable portion of the browser for at least one second. 100% display viewable impressions / display measured impressions | |
| 1-5 seconds view rate | standard_rate_1_to_5_seconds_view | met | The percentage of Measured Impressions for which 50% or more of the ad creative was in view for 1-4.9 seconds. 1-5 seconds view impressions / display measured impressions | |
| 50% Display Viewable 1 - 5 secs impressions | standard_impressions_1_to_5_seconds_view | met | Impressions for which 50% or more of the ad creative was in view for 1-4.9 seconds. | |
| 5-15 seconds view rate | standard_rate_5_to_15_seconds_view | met | The percentage of Measured Impressions for which 50% or more of the ad creative was in view for 5-14.9 seconds. 5-15 seconds view impressions / display measured impressions | |
| 50% Display Viewable 5-15 Secs Impressions | standard_impressions_5_to_15_seconds_view | met | Impressions for which 50% or more of the ad creative was in view for 5-14.9 seconds. | |
| >15 seconds view rate | standard_greater_than_15_seconds_view_rate | met | Percentage of Measured Impressions for which 50% or more of the ad creative was in view for greater than or equal to 15 seconds. Greater than 15 seconds view impressions / display measured impressions | |
| 50% Display Viewable >15 Secs Impressions | standard_greater_than_15_seconds_view_impressions | met | Impressions for which 50% or more of the ad creative was in view for 15 seconds. | |
| Total Viewable Time (s) | standard_total_viewable_time_s | met | The total time of viewable impressions in hours. | |
| Average time (s) - Viewable impressions | standard_average_time_s_display_viewable_impressions | met | The average time, in seconds, of viewable impressions. | |
| Total time (hr) - Viewable impressions | standard_total_time_hr_display_viewable_impressions | met | The total time of viewable impressions in hours. | |
| Video eligible impressions | standard_video_eligible_impressions | met | Impressions that had the potential to be measured for video viewability, which is the count of all impressions that include DV viewability measurement technology. | |
| Authentic video viewable impressions | standard_authentic_video_viewable_impressions | met | An authentic viewable impression includes an additional premium layer of analysis that shows when an authentic ads also meets the IAB standard for viewability | |
| Video viewable impressions | standard_video_viewable_impressions | met | Impressions across desktop, mobile web and mobile in-app delivery that were measured as viewable according to the IAB viewability guideline | |
| Video measured impressions | standard_video_measured_impressions | met | Impressions for which DV was able to obtain the information needed to make decisions about viewability | |
| Video measurement rate | standard_video_measurement_rate | met | Percentage for which DV was able to obtain the information needed to make decisions about viewability. Video measured impressions / video eligible impressions | |
| Video viewable rate | standard_video_viewable_rate | met | Percentage of impressions across desktop, mobile web and mobile in-app delivery that were measured as viewable according to the IAB viewability guideline. Video viewable impressions / measured impressions | |
| Authentic Q1 fully on-screen impressions | standard_authentic_q_1_fully_on_screen_impressions | met | The number of authentic ads for which the creative was fully within the visible portion of the browser and the signal at the end of the quartile was received for the specified quartile. | |
| Authentic Q1 fully on-screen rate | standard_authentic_q_1_fully_on_screen_rate | met | The percentage of authentic ads for which the creative was fully within the visible portion of the browser and the signal at the end of the quartile was received for the specified quartile. Authentic Q1 Fully On-Screen Impressions / Fully On-Screen Measured Impressions | |
| Authentic Q2 fully on-screen impressions | standard_authentic_q_2_fully_on_screen_impressions | met | The number of authentic ads for which the creative was fully within the visible portion of the browser and the signal at the end of the quartile was received for the specified quartile. | |
| Authentic Q2 fully on-screen rate | standard_authentic_q_2_fully_on_screen_rate | met | The percentage of authentic ads for which the creative was fully within the visible portion of the browser and the signal at the end of the quartile was received for the specified quartile. Authentic Q2 Fully On-Screen Impressions / Fully On-Screen Measured Impressions | |
| Authentic Q3 fully on-screen impressions | standard_authentic_q_3_fully_on_screen_impressions | met | The number of authentic ads for which the creative was fully within the visible portion of the browser and the signal at the end of the quartile was received for the specified quartile. | |
| Authentic Q3 fully on-screen rate | standard_authentic_q_3_fully_on_screen_rate | met | The percentage of Authentic Ads for which the creative was fully within the visible portion of the browser and the signal at the end of the quartile was received for the specified quartile. Authentic Q3 Fully On-Screen Impressions / Fully On-Screen Measured Impressions | |
| Authentic completed fully on-screen impressions | standard_authentic_completed_fully_on_screen_impressions | met | The number of authentic ads for which the creative was fully within the visible portion of the browser and the signal at the end of the quartile was received for the specified quartile. | |
| Authentic completed fully on-screen rate | standard_authentic_completed_fully_on_screen_rate | met | The percentage of authentic ads for which the creative was fully within the visible portion of the browser and the signal at the end of the quartile was received for the specified quartile. Authentic Completed Fully On-Screen Impressions / Fully On-Screen Measured Impressions | |
| Fully on screen measured impressions | standard_fully_on_screen_measured_impressions | met | The count of video impressions for which DV was able to obtain the information needed to determine whether the creative was fully within the visible portion of the browser and to receive the signals that indicate the end of the quartile. | |
| Fully on-screen measurement rate | standard_fully_on_screen_measurement_rate | met | The rate of video impressions for which DV was able to obtain the information needed to determine whether the creative was fully within the visible portion of the browser and to receive the signals that indicate the end of the quartile. Fully On-Screen Measured Impressions / Monitored Ads |