Windsor brings all your Google Display & Video 360 (DV360) data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
Google Display & Video 360 (DV360) Field Reference
Sample
https://connectors.windsor.ai/dv360?api_key=[your API key]&date_preset=last_7d&fields=campaign,clicks,spend,impressions,date,source&_renderer=csv
Fields
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| account_id | TEXT | Account ID | Your DV360 advertiser ID | General |
| account_name | TEXT | Account Name | Your DV360 advertiser name | General |
| active_view_audible_fully_on_screen_half_of_duration_trueview_impressions | NUMERIC | Active View: Audible & Fully On-Screen for Half of Duration (TrueView) Impressions | Active View: Audible & Fully On-Screen for Half of Duration (TrueView) Impressions | General |
| active_view_audible_fully_on_screen_half_of_duration_trueview_measurable_impressions | NUMERIC | Active View: Audible & Fully On-Screen for Half of Duration (TrueView) Measurable Impressions | Active View: Audible & Fully On-Screen for Half of Duration (TrueView) Measurable Impressions | General |
| active_view_audible_fully_on_screen_half_of_duration_trueview_rate | NUMERIC | Active View: Audible & Fully On-Screen for Half of Duration (TrueView - Youtube) Rate | Active View: Audible & Fully On-Screen for Half of Duration (TrueView) Rate | General |
| age | TEXT | Age | Age | General |
| app_url | TEXT | App/URL | App/URL | General |
| app_url_excluded | TEXT | App/URL Excluded | App/URL Excluded | General |
| attribution_model | TEXT | Attribution Model | Attribution Model | General |
| audio_mutes_audio | NUMERIC | Audio Mutes (Audio) | Audio Mutes (Audio) | General |
| audio_unmutes_audio | NUMERIC | Audio Unmutes (Audio) | Audio Unmutes (Audio) | General |
| campaign | TEXT | Campaign | The Campaign Name | General |
| campaign_budget_id | TEXT | Campaign Budget ID | The unique ID of the campaign budget. Assigned by the system. Do not set for new budgets. | Campaigns |
| campaign_budget_name | TEXT | Campaign Budget Name | The display name of the budget. | Campaigns |
| campaign_budget_unit | TEXT | Campaign Budget Unit | Specifies whether the budget is measured in currency or impressions. | Campaigns |
| campaign_goal_type | TEXT | Campaign Goal Type | The type of the campaign goal. | Campaigns |
| campaign_id | TEXT | Campaign ID | The Campaign ID | General |
| campaign_performance_goal_amount | NUMERIC | Campaign Performance Goal Amount | The goal amount, in micros of the advertiser's currency. | Campaigns |
| campaign_performance_goal_perc | NUMERIC | Campaign Perfomance Goal Percentage | The decimal representation of the goal percentage in micros. | Campaigns |
| campaign_performance_goal_type | TEXT | Campaign Performance Goal Type | The type of the campaign perfomance goal. | Campaigns |
| campaign_planned_end_date | NUMERIC | Campaign Planned End Date | End date that the campaign is expected to run. They are resolved relative to the parent advertiser's time zone. | Campaigns |
| campaign_planned_spend | NUMERIC | Campaign Planned Spend | The amount the campaign is expected to spend for its given plannedDates. | Campaigns |
| campaign_planned_start_date | NUMERIC | Campaign Planned Start Date | Start date that the campaign is expected to run. They are resolved relative to the parent advertiser's time zone. | Campaigns |
| campaign_update_time | TIMESTAMP | Campaign Update Time | The timestamp when the campaign was last updated. Assigned by the system. | Campaigns |
| city | CITY | City | City Name | General |
| cityid | TEXT | City ID | City ID | General |
| clicks | NUMERIC | Clicks | The Number of Clicks | General |
| clicks_lead_conv_perc | NUMERIC | Clicks Lead Conv Percentage | Clicks Leading to Conversions % | General |
| cm_ad_id | TEXT | CM Ad ID | The Campaign Manager 360 tracking ad associated with the creative. | Creatives |
| cm_placement_id | TEXT | CM Placement ID | The unique ID of the Campaign Manager 360 placement associated with the creative. | General |
| cm_post_click_revenue | NUMERIC | CM360 Post-Click Revenue | CM360 Post-Click Revenue. | General |
| cm_post_view_revenue | NUMERIC | CM360 Post-View Revenue | CM360 Post-View Revenue. | General |
| companion_clicks_audio | NUMERIC | Companion Clicks (Audio) | Companion Clicks (Audio) | General |
| companion_impressions_audio | NUMERIC | Companion Views (Audio) | Companion Views (Audio) | General |
| complete_listens_audio | NUMERIC | Complete Listens (Audio) | Complete Listens (Audio) | General |
| complete_views_video | NUMERIC | Complete Views (Video) | Complete Views (Video) | General |
| completion_rate_audio | PERCENT | Completion Rate (Audio) | Completion Rate (Audio) | General |
| conversions | NUMERIC | Conversions | Total conversions | General |
| country | COUNTRY | Country | Country | General |
| cpm_fee1_advertiser | NUMERIC | CPM Fee 1 (Advertiser Currency) | CPM Fee 1 (Advertiser Currency) | CPM |
| cpm_fee1_partner | NUMERIC | CPM Fee 1 (Partner Currency) | CPM Fee 1 (Partner Currency) | CPM |
| cpm_fee1_usd | NUMERIC | CPM Fee 1 (USD) | CPM Fee 1 (USD) | CPM |
| cpm_fee2_advertiser | NUMERIC | CPM Fee 2 (Advertiser Currency) | CPM Fee 2 (Advertiser Currency) | CPM |
| cpm_fee2_partner | NUMERIC | CPM Fee 2 (Partner Currency) | CPM Fee 2 (Partner Currency) | CPM |
| cpm_fee2_usd | NUMERIC | CPM Fee 2 (USD) | CPM Fee 2 (USD) | CPM |
| cpm_fee3_advertiser | NUMERIC | CPM Fee 3 (Advertiser Currency) | CPM Fee 3 (Advertiser Currency) | CPM |
| cpm_fee3_partner | NUMERIC | CPM Fee 3 (Partner Currency) | CPM Fee 3 (Partner Currency) | CPM |
| cpm_fee3_usd | NUMERIC | CPM Fee 3 (USD) | CPM Fee 3 (USD) | CPM |
| cpm_fee4_advertiser | NUMERIC | CPM Fee 4 (Advertiser Currency) | CPM Fee 4 (Advertiser Currency) | CPM |
| cpm_fee4_partner | NUMERIC | CPM Fee 4 (Partner Currency) | CPM Fee 4 (Partner Currency) | CPM |
| cpm_fee4_usd | NUMERIC | CPM Fee 4 (USD) | CPM Fee 4 (USD) | CPM |
| cpm_fee5_advertiser | NUMERIC | CPM Fee 5 (Advertiser Currency) | CPM Fee 5 (Advertiser Currency) | CPM |
| cpm_fee5_partner | NUMERIC | CPM Fee 5 (Partner Currency) | CPM Fee 5 (Partner Currency) | CPM |
| cpm_fee5_usd | NUMERIC | CPM Fee 5 (USD) | CPM Fee 5 (USD) | CPM |
| creative | TEXT | Creative | Creative | General |
| creative_create_time | TIMESTAMP | Creative Create Time | The timestamp when the creative was created. Assigned by the system. | Creatives |
| creative_hosting_source | TEXT | Creative Hosting Source | Indicates where the creative is hosted. | Creatives |
| creative_id | TEXT | Creative ID | Creative ID | General |
| creative_size | TEXT | Creative Size | Creative Size | General |
| creative_update_time | TIMESTAMP | Creative Update Time | The timestamp when the creative was last updated. Assigned by the system. | Creatives |
| creativetype | TEXT | Creative Type | The type of the creative. | General |
| currency_advertiser | TEXT | Advertiser Currency | Advertiser currency | General |
| currency_partner | TEXT | Partner Currency | Partner currency | General |
| data_manager_platform_fee_advertiser | NUMERIC | Data Management Platform Fee (Advertiser Currency) | Data Management Platform Fee (Advertiser Currency) | Fees |
| data_manager_platform_fee_partner | NUMERIC | Data Management Platform Fee (Partner Currency) | Data Management Platform Fee (Partner Currency) | Fees |
| data_manager_platform_fee_usd | NUMERIC | Data Management Platform Fee (USD) | Data Management Platform Fee (USD) | Fees |
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| date | DATE | Date | The Date | General |
| day_of_month | TEXT | Day of month | Day of the month | |
| demo_composition_impression | NUMERIC | % Composition Impressions (Unique Reach Audience) | % Composition Impressions (Unique Reach Audience) | UniqueReachAudience |
| demo_composition_impression_coviewed | NUMERIC | % Composition Impressions (Co-Viewed) (Unique Reach Audience) | % Composition Impressions (Co-Viewed) (Unique Reach Audience) | UniqueReachAudience |
| demo_population | NUMERIC | Population | Population | Demo |
| device | TEXT | Device | Device | General |
| device_make | TEXT | Device Make (DV360) | Device Make (DV360) | General |
| device_model | TEXT | Device Model | Device Model | General |
| device_type | TEXT | Device Type | Device Type | General |
| first_quartile_audio | NUMERIC | First-Quartile (Audio) | First-Quartile (Audio) | General |
| first_quartile_views_video | NUMERIC | First-Quartile Views (Video) | First-Quartile Views (Video) | General |
| floodlight_activity | TEXT | Floodlight Activity Name | Floodlight Activity Name | General |
| floodlight_activity_id | TEXT | Floodlight Activity ID | Floodlight Activity ID | General |
| floodlight_impressions | NUMERIC | Floodlight Impressions | Floodlight Impressions | General |
| fullscreens_video | NUMERIC | Fullscreens (Video) | Fullscreens (Video) | General |
| gender | TEXT | Gender | Gender | General |
| grp_corrected_viewable_impressions | NUMERIC | Viewable Impressions (Unique Reach Audience) | Viewable Impressions (Unique Reach Audience) | UniqueReachAudience |
| grp_corrected_viewable_impressions_share_percent | NUMERIC | % Viewable Composition Impressions (Unique Reach Audience) | % Viewable Composition Impressions (Unique Reach Audience) | UniqueReachAudience |
| impressions | NUMERIC | Impressions | The Number of Impressions Served | General |
| impressions_coviewed | NUMERIC | Impressions (Co-Viewed) | Impressions (Co-Viewed) | General |
| insertion_order | TEXT | Insertion Order | The Insertion Order Name | General |
| insertion_order_id | TEXT | Insertion Order ID | The Insertion Order ID | General |
| inventory_commitment_type | TEXT | Inventory Commitment Type | Inventory Commitment Type | Inventory |
| inventory_delivery_method | TEXT | Inventory Delivery Method | Inventory Delivery Method | Inventory |
| inventory_format | TEXT | Inventory Format | Inventory Format | Inventory |
| inventory_media_cost_type | TEXT | Inventory Media Cost Type | Inventory Media Cost Type | Inventory |
| inventory_rate_type | TEXT | Inventory Rate Type | Inventory Rate Type | Inventory |
| inventory_source_group | TEXT | Inventory Source Group | Inventory Source Group | Inventory |
| inventory_source_group_id | TEXT | Inventory Source Group ID | Inventory Source Group ID | Inventory |
| inventory_source_id | TEXT | Inventory Source ID | Inventory Source ID | Inventory |
| inventory_source_id_external | TEXT | Inventory Source ID (external) | Inventory Source ID (external) | Inventory |
| inventory_source_name | TEXT | Inventory Source | Inventory Source | Inventory |
| inventory_source_type | TEXT | Inventory Source Type | Inventory Source Type | Inventory |
| inventory_sources_permissions | TEXT | Inventory Sources Permissions | Inventory Sources Permissions | Inventory |
| last_touch_click_through_conversions | NUMERIC | Last Touch Click-through Conversions | Click-through Conversions | Last Touch |
| last_touch_view_through_conversions | NUMERIC | Last Touch View-through Conversions | View-through Conversions | Last Touch |
| line_item | TEXT | Line Item Name | The Line Item Name | General |
| line_item_budget | TEXT | Line Item Budget | The Line Item Budget | General |
| line_item_daily_frequency | TEXT | Line Item Daily Frequency | The Line Item Frequency | General |
| line_item_end_date | DATE | Line Item End Date | The Line Item End Date | General |
| line_item_id | TEXT | Line Item ID | The Line Item ID | General |
| line_item_integration_code | TEXT | Line Item Integration Code | The Line Item Integration Code | General |
| line_item_lifetime_frequency | TEXT | Line Item Lifetime Frequency | The Line Item Lifetime Frequency | General |
| line_item_pacing_percentage | TEXT | Line Item Pacing Percentage | The Line Item Pacing Percentage | General |
| line_item_start_date | DATE | Line Item Start Date | The Line Item Start Date | General |
| line_item_status | TEXT | Line Item Status | The Line Item Status | General |
| line_item_type | TEXT | Line Item Type | The Line Item Type | General |
| media_cost_advertiser_currency | NUMERIC | Media Cost (Advertiser Currency) | Media Cost (Advertiser Currency) | General |
| media_cost_ecpc_advertiser | NUMERIC | Media Cost eCPC (Advertiser Currency) | Media Cost eCPC (Advertiser Currency) | CPC |
| media_cost_ecpc_partner | NUMERIC | Media Cost eCPC (Partner Currency) | Media Cost eCPC (Partner Currency) | CPC |
| media_cost_ecpc_usd | NUMERIC | Media Cost eCPC (USD) | Media Cost eCPC (USD) | CPC |
| media_cost_ecpcv_advertiser | NUMERIC | Video Media Cost eCPCV (Advertiser Currency) | Video Media Cost eCPCV (Advertiser Currency) | CPC |
| media_cost_ecpcv_partner | NUMERIC | Video Media Cost eCPCV (Partner Currency) | Video Media Cost eCPCV (Partner Currency) | CPC |
| media_cost_ecpcv_usd | NUMERIC | Video Media Cost eCPCV (USD) | Video Media Cost eCPCV (USD) | CPC |
| media_fee1_advertiser | NUMERIC | Media Fee 1 (Advertiser Currency) | Media Fee 1 (Advertiser Currency) | MediaFee |
| media_fee1_partner | NUMERIC | Media Fee 1 (Partner Currency) | Media Fee 1 (Partner Currency) | MediaFee |
| media_fee1_usd | NUMERIC | Media Fee 1 (USD) | Media Fee 1 (USD) | MediaFee |
| media_fee2_advertiser | NUMERIC | Media Fee 2 (Advertiser Currency) | Media Fee 2 (Advertiser Currency) | MediaFee |
| media_fee2_partner | NUMERIC | Media Fee 2 (Partner Currency) | Media Fee 2 (Partner Currency) | MediaFee |
| media_fee2_usd | NUMERIC | Media Fee 2 (USD) | Media Fee 2 (USD) | MediaFee |
| media_fee3_advertiser | NUMERIC | Media Fee 3 (Advertiser Currency) | Media Fee 3 (Advertiser Currency) | MediaFee |
| media_fee3_partner | NUMERIC | Media Fee 3 (Partner Currency) | Media Fee 3 (Partner Currency) | MediaFee |
| media_fee3_usd | NUMERIC | Media Fee 3 (USD) | Media Fee 3 (USD) | MediaFee |
| media_fee4_advertiser | NUMERIC | Media Fee 4 (Advertiser Currency) | Media Fee 4 (Advertiser Currency) | MediaFee |
| media_fee4_partner | NUMERIC | Media Fee 4 (Partner Currency) | Media Fee 4 (Partner Currency) | MediaFee |
| media_fee4_usd | NUMERIC | Media Fee 4 (USD) | Media Fee 4 (USD) | MediaFee |
| media_fee5_advertiser | NUMERIC | Media Fee 5 (Advertiser Currency) | Media Fee 5 (Advertiser Currency) | MediaFee |
| media_fee5_partner | NUMERIC | Media Fee 5 (Partner Currency) | Media Fee 5 (Partner Currency) | MediaFee |
| media_fee5_usd | NUMERIC | Media Fee 5 (USD) | Media Fee 5 (USD) | MediaFee |
| midpoint_audio | NUMERIC | Midpoint (Audio) | Midpoint (Audio) | General |
| midpoint_views_video | NUMERIC | Midpoint Views (Video) | Midpoint Views (Video) | General |
| month | TEXT | Month | Month (yyyy/mm) | General |
| partner | TEXT | Partner (DV360) | Partner | General |
| partner_id | TEXT | Partner ID | Partner ID | General |
| pauses_audio | NUMERIC | Pauses (Audio) | Pauses (Audio) | General |
| platform_fee_advertiser | NUMERIC | Platform Fee (Advertiser Currency) | Platform Fee (Advertiser Currency) | Fees |
| platform_fee_partner | NUMERIC | Platform Fee (Partner Currency) | Platform Fee (Partner Currency) | Fees |
| platform_fee_rate | NUMERIC | Platform Fee Rate | Platform Fee Rate | Fees |
| platform_fee_usd | NUMERIC | Platform Fee (USD) | Platform Fee (USD) | Fees |
| post_click_conversions | NUMERIC | Post-Click Conversions | Post-Click Conversions | General |
| post_view_conversions | NUMERIC | Post-View Conversions | Post-View Conversions | General |
| region | REGION | Region | Region Name | General |
| regionid | TEXT | Region ID | Region ID | General |
| revenue_advertiser | NUMERIC | Revenue (Advertiser Currency) | Revenue (Advertiser Currency) | General |
| revenue_ecpc_advertiser | NUMERIC | Revenue eCPC (Advertiser Currency) | Revenue eCPC (Advertiser Currency) | CPC |
| revenue_ecpc_partner | NUMERIC | Revenue eCPC (Partner Currency) | Revenue eCPC (Partner Currency) | CPC |
| revenue_ecpc_usd | NUMERIC | Revenue eCPC (USD) | Revenue eCPC (USD) | CPC |
| revenue_ecpcv_advertiser | NUMERIC | Video Revenue eCPCV (Advertiser Currency) | Video Revenue eCPCV (Advertiser Currency) | CPC |
| revenue_ecpcv_partner | NUMERIC | Video Revenue eCPCV (Partner Currency) | Video Revenue eCPCV (Partner Currency) | CPC |
| revenue_ecpcv_usd | NUMERIC | Video Revenue eCPCV (USD) | Video Revenue eCPCV (USD) | CPC |
| revenue_partner | NUMERIC | Revenue (Partner Currency) | Revenue (Partner Currency) | General |
| revenue_usd | NUMERIC | Revenue (USD) | Revenue (USD) | General |
| skips_video | NUMERIC | Skips (Video) | Skips (Video) | General |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| spend | NUMERIC | Spend in Advertiser Currency | The Media Spend in the Advertiser Currency | General |
| spend_partner | NUMERIC | Spend in Partner Currency | The Media Spend in the Partner Currency | General |
| spend_usd | NUMERIC | Spend in USD | The Media Spend in USD | General |
| starts_audio | NUMERIC | Starts (Audio) | Starts (Audio) | General |
| starts_video | NUMERIC | Starts (Video) | Starts (Video) | General |
| stops_audio | NUMERIC | Stops (Audio) | Stops (Audio) | General |
| target_rating_points | NUMERIC | Target Rating Points | Target Rating Points | UniqueReachAudience |
| target_rating_points_coviewed | NUMERIC | Target Rating Points (Co-Viewed) | Target Rating Points (Co-Viewed) | UniqueReachAudience |
| tea_trueview_impressions | NUMERIC | Potential Impressions | Potential Impressions | General |
| tea_trueview_unique_cookies | NUMERIC | Unique Cookies with Impressions | Unique Cookies with Impressions | General |
| third_quartile_audio | NUMERIC | Third-Quartile (Audio) | Third-Quartile (Audio) | General |
| third_quartile_views_video | NUMERIC | Third-Quartile Views (Video) | Third-Quartile Views (Video) | General |
| time_of_day | TEXT | Time of Day | Time of Day (hour, 0-23) | General |
| today | DATE | Today | Today's date | |
| total_conversions | NUMERIC | Total Conversions | Total Conversions | General |
| total_display_time | NUMERIC | Total Display Time | Total Display Time | General |
| total_media_cost_ecpc_advertiser | NUMERIC | Total Media Cost eCPC (Advertiser Currency) | Total Media Cost eCPC (Advertiser Currency) | CPC |
| total_media_cost_ecpc_partner | NUMERIC | Total Media Cost eCPC (Partner Currency) | Total Media Cost eCPC (Partner Currency) | CPC |
| total_media_cost_ecpc_usd | NUMERIC | Total Media Cost eCPC (USD) | Total Media Cost eCPC (USD) | CPC |
| total_media_cost_ecpcv_advertiser | NUMERIC | Total Video Media Cost eCPCV (Advertiser Currency) | Total Video Media Cost eCPCV (Advertiser Currency) | CPC |
| total_media_cost_ecpcv_partner | NUMERIC | Total Video Media Cost eCPCV (Partner Currency) | Total Video Media Cost eCPCV (Partner Currency) | CPC |
| total_media_cost_ecpcv_usd | NUMERIC | Total Video Media Cost eCPCV (USD) | Total Video Media Cost eCPCV (USD) | CPC |
| totalcost | NUMERIC | Total Cost in Advertiser Currency | The Media Spend in the Advertiser Currency (Duplicate) | General |
| totalcost_usd | NUMERIC | Total Cost USD | The Media Spend in USD (Duplicate) | General |
| trueview_ad | TEXT | YouTube Ad | YouTube Ad | TrueView Dim. Additional |
| trueview_ad_group | TEXT | YouTube Ad Group | YouTube Ad Group | TrueView Dim. General |
| trueview_ad_group_ad_id | TEXT | YouTube Ad ID | YouTube Ad ID | TrueView Dim. Additional |
| trueview_ad_group_id | TEXT | YouTube Ad Group ID | YouTube Ad Group ID | TrueView Dim. General |
| trueview_ad_type_name | TEXT | YouTube Ad Type | YouTube Ad Type | TrueView Dim. General |
| trueview_age | TEXT | Youtube Age | Age | TrueView Dim. Other. Can't be used as preset |
| trueview_all_ad_sequence_impressions | NUMERIC | All YouTube Sequence Impressions | All YouTube Sequence Impressions | TrueView Metr. Other. Can't be used as preset |
| trueview_average_cpe_advertiser | NUMERIC | Revenue eCPE (Advertiser Currency) | Revenue eCPE (Advertiser Currency) | TrueView Metr. Interactions |
| trueview_average_cpe_partner | NUMERIC | Revenue eCPE (Partner Currency) | Revenue eCPE (Partner Currency) | TrueView Metr. Other. Can't be used as preset |
| trueview_average_cpe_usd | NUMERIC | Revenue eCPE (USD) | Revenue eCPE (USD) | TrueView Metr. Other. Can't be used as preset |
| trueview_category | TEXT | Trueview Category ID | Category ID | TrueView Dim. General |
| trueview_city | CITY | City Name | City Name | TrueView Dim. Location |
| trueview_click_type_name | TEXT | Click Type | Click Type | TrueView Dim. General |
| trueview_conversion_cost_many_per_view_advertiser | NUMERIC | Cost / Conversion (Advertiser Currency) | Cost / Conversion (Advertiser Currency) | TrueView Metr. Conversion Performance |
| trueview_conversion_cost_many_per_view_partner | NUMERIC | Cost / Conversion (Partner Currency) | Cost / Conversion (Partner Currency) | TrueView Metr. Other. Can't be used as preset |
| trueview_conversion_cost_many_per_view_usd | NUMERIC | Cost / Conversion (USD) | Cost / Conversion (USD) | TrueView Metr. Other. Can't be used as preset |
| trueview_conversion_many_per_view | NUMERIC | Trueview Conversions | Conversions | TrueView Metr. Conversion Performance |
| trueview_conversion_rate_one_per_view | NUMERIC | View Conversion Rate | View Conversion Rate | TrueView Metr. Conversion Performance |
| trueview_conversion_type | TEXT | Trueview Conversion Type | Conversion Type | TrueView Dim. General |
| trueview_country | COUNTRY | Trueview Country Name | Country Name | TrueView Dim. Location |
| trueview_cpv_advertiser | NUMERIC | Revenue eCPV (Advertiser Currency) | Revenue eCPV (Advertiser Currency) | TrueView Metr. Delivery |
| trueview_cpv_partner | NUMERIC | Revenue eCPV (Partner Currency) | Revenue eCPV (Partner Currency) | TrueView Metr. Other. Can't be used as preset |
| trueview_cpv_usd | NUMERIC | Revenue eCPV (USD) | Revenue eCPV (USD) | TrueView Metr. Other. Can't be used as preset |
| trueview_custom_affinity | TEXT | Custom Affinity ID | Custom Affinity ID | TrueView Dim. Additional Dimensions |
| trueview_detailed_demographics | TEXT | Detailed Demographics | Detailed Demographics | TrueView Dim. Additional |
| trueview_detailed_demographics_id | TEXT | Detailed Demographics ID | Detailed Demographics ID | TrueView Dim. Additional |
| trueview_dma | TEXT | DMA ID | DMA ID | TrueView Dim. Location |
| trueview_dma_name | TEXT | DMA (dv360) | DMA | TrueView Dim. Location |
| trueview_earned_likes | NUMERIC | Earned Likes | Earned Likes | TrueView Metr. Interactions |
| trueview_earned_playlist_additions | NUMERIC | Earned Playlist Additions | Earned Playlist Additions | TrueView Metr. Interactions |
| trueview_earned_shares | NUMERIC | Earned Shares | Earned Shares | TrueView Metr. Interactions |
| trueview_earned_subscribers | NUMERIC | Earned Subscribers | Earned Subscribers | TrueView Metr. Interactions |
| trueview_earned_views | NUMERIC | Earned Views | Earned Views metrics (Interactions) | TrueView Metr. Delivery |
| trueview_engagement_rate | NUMERIC | Engagement Rate (dv360) | Engagement Rate | TrueView Metr. Interactions |
| trueview_engagements | NUMERIC | Trueview Engagements | Engagements | TrueView Metr. Interactions |
| trueview_gender | TEXT | Youtube (Trueview) Gender | Gender | TrueView Dim. Other. Can't be used as preset |
| trueview_general_invalid_traffic_givt_views | NUMERIC | TrueView: General Invalid Traffic (GIVT) Views | TrueView: General Invalid Traffic (GIVT) Views | TrueView Metr. Other. Can't be used as preset |
| trueview_household_income | TEXT | Household Income | Household Income | TrueView Dim. Additional |
| trueview_iar_age | TEXT | Trueview Age | Age | TrueView Dim. Inventory Availability |
| trueview_iar_category | TEXT | Category | Category | TrueView Dim. Inventory Availability |
| trueview_iar_city | CITY | Trueview City | City | TrueView Dim. Inventory Availability |
| trueview_iar_country | COUNTRY | Trueview IAR Country | Country | TrueView Dim. Inventory Availability |
| trueview_iar_country_name | COUNTRY | Trueview IAR Country Name | Country | TrueView Dim. Inventory Availability |
| trueview_iar_gender | TEXT | Trueview Gender | Gender | TrueView Dim. Inventory Availability |
| trueview_iar_interest | TEXT | Trueview Interest | Interest | TrueView Dim. Inventory Availability |
| trueview_iar_language | TEXT | Trueview Language | Language | TrueView Dim. Inventory Availability |
| trueview_iar_parental_status | TEXT | Trueview Parental Status | Parental Status | TrueView Dim. Inventory Availability |
| trueview_iar_region | REGION | Trueview IAR Region | Region | TrueView Dim. Inventory Availability |
| trueview_iar_region_name | REGION | Trueview IAR Region Name | Region | TrueView Dim. Inventory Availability |
| trueview_iar_remarketing_list | TEXT | Trueview Remarketing List ID | Remarketing List ID | TrueView Dim. Inventory Availability |
| trueview_iar_time_of_day | TIMESTAMP | Time of Day (TrueView) | Time of Day (TrueView) | TrueView Dim. Inventory Availability |
| trueview_iar_youtube_channel | TEXT | YouTube Channel | YouTube Channel | TrueView Dim. Inventory Availability |
| trueview_iar_youtube_video | TEXT | YouTube Video | YouTube Video | TrueView Dim. Inventory Availability |
| trueview_iar_zipcode | TEXT | Zip Code | Zip Code | TrueView Dim. Inventory Availability |
| trueview_impression_share | NUMERIC | Impression Share | Impression Share | TrueView Metr. Other. Can't be used as preset |
| trueview_interest | TEXT | Interest | Interest | TrueView Dim. YouTube Inventory Availability |
| trueview_invalid_views | NUMERIC | TrueView: Invalid Views | TrueView: Invalid Views | TrueView Metr. Other. Can't be used as preset |
| trueview_keyword | TEXT | Trueview Keyword | Keyword | TrueView Dim. General |
| trueview_lost_is_budget | NUMERIC | Lost Impression Share (Budget) | Lost Impression Share (Budget) | TrueView Metr. Other. Can't be used as preset |
| trueview_lost_is_rank | NUMERIC | Lost Impression Share (Rank) | Lost Impression Share (Rank) | TrueView Metr. Other. Can't be used as preset |
| trueview_parental_status | TEXT | Parental Status | Parental Status | TrueView Dim. YouTube Inventory Availability |
| trueview_placement | TEXT | Placement (Managed) | Placement (Managed) | TrueView Dim. Additional |
| trueview_placement_id | TEXT | Placement ID (Managed) | Placement ID (Managed) | TrueView Dim. Additional |
| trueview_region | REGION | Trueview Region ID | Region ID | TrueView Dim. Location |
| trueview_region_name | REGION | Trueview Region Name | Region | TrueView Dim. Location |
| trueview_remarketing_list | TEXT | Remarketing List ID | Remarketing List ID | TrueView Dim. Audience |
| trueview_remarketing_list_name | TEXT | Remarketing List | Remarketing List | TrueView Dim. Audience |
| trueview_targeting_expansion | TEXT | Targeting Expansion | Targeting Expansion | TrueView Dim. Other. Can't be used as preset |
| trueview_total_conversion_values_advertiser | NUMERIC | Total Conversion Value (Advertiser Currency) | Total Conversion Value (Advertiser Currency) | TrueView Metr. Conversion Performance |
| trueview_total_conversion_values_partner | NUMERIC | Total Conversion Value (Partner Currency) | Total Conversion Value (Partner Currency) | TrueView Metr. Other. Can't be used as preset |
| trueview_total_conversion_values_usd | NUMERIC | Total Conversion Value (USD) | Total Conversion Value (USD) | TrueView Metr. Other. Can't be used as preset |
| trueview_unique_viewers | NUMERIC | Unique Viewers | Unique Viewers | TrueView Metr. Other. Can't be used as preset |
| trueview_url | TEXT | Placement (All) | Placement (All) | TrueView Dim. Additional |
| trueview_view_rate | NUMERIC | TrueView: View Rate | TrueView: View Rate | TrueView Metr. Delivery |
| trueview_views | NUMERIC | TrueView: Views | TrueView: Views | TrueView Metr. Delivery |
| trueview_zipcode | TEXT | Zipcode Name | Zipcode Name | TrueView Dim. Location |
| unique_reach_average_impression_frequency | NUMERIC | Unique Reach: Average Impression Frequency (Unique Reach) | Unique Reach: Average Impression Frequency (Unique Reach) | UniqueReach |
| unique_reach_average_impression_frequency_coviewed | NUMERIC | Unique Reach: Average Impression Frequency (Co-Viewed) (Unique Reach) | Unique Reach: Average Impression Frequency (Co-Viewed) (Unique Reach) | UniqueReach |
| unique_reach_average_viewable_impression_frequency | NUMERIC | Unique Reach: Average Viewable Impression Frequency (Unique Reach) | Unique Reach: Average Viewable Impression Frequency (Unique Reach) | UniqueReach |
| unique_reach_click_reach | NUMERIC | Unique Reach: Click Reach (Unique Reach) | Unique Reach: Click Reach (Unique Reach) | UniqueReach |
| unique_reach_impression_reach | NUMERIC | Unique Reach: Impression Reach (Unique Reach) | Unique Reach: Impression Reach (Unique Reach) | UniqueReach |
| unique_reach_impression_reach_added_with_cross_stack_fcap | NUMERIC | Unique Reach: Added Impression Reach From Frequency Cap (Unique Reach) | Unique Reach: Added Impression Reach From Frequency Cap (Unique Reach) | UniqueReach |
| unique_reach_impression_reach_added_with_pg_fmgmt | NUMERIC | Programmatic Guaranteed Added Unique Reach: Impressions due to Frequency (Unique Reach) | Programmatic Guaranteed Added Unique Reach: Impressions due to Frequency (Unique Reach) | UniqueReach |
| unique_reach_impression_reach_coviewed | NUMERIC | Unique Reach: Impression Reach (Co-Viewed) (Unique Reach) | Unique Reach: Impression Reach (Co-Viewed) (Unique Reach) | UniqueReach |
| unique_reach_incremental_click_reach | NUMERIC | Unique Reach: Incremental Click Reach (Unique Reach) | Unique Reach: Incremental Click Reach (Unique Reach) | UniqueReach |
| unique_reach_incremental_impression_reach | NUMERIC | Unique Reach: Incremental Impression Reach (Unique Reach) | Unique Reach: Incremental Impression Reach (Unique Reach) | UniqueReach |
| unique_reach_incremental_total_reach | NUMERIC | Unique Reach: Incremental Total Reach (Unique Reach) | Unique Reach: Incremental Total Reach (Unique Reach) | UniqueReach |
| unique_reach_incremental_viewable_impression_reach | NUMERIC | Unique Reach: Incremental Viewable Impression Reach (Unique Reach) | Unique Reach: Incremental Viewable Impression Reach (Unique Reach) | UniqueReach |
| unique_reach_total_reach | NUMERIC | Unique Reach: Total Reach (Unique Reach) | Unique Reach: Total Reach (Unique Reach) | UniqueReach |
| unique_reach_total_reach_coviewed | NUMERIC | Unique Reach: Total Reach (Co-Viewed) (Unique Reach) | Unique Reach: Total Reach (Co-Viewed) (Unique Reach) | UniqueReach |
| unique_reach_viewable_impression_reach | NUMERIC | Unique Reach: Viewable Impression Reach (Unique Reach) | Unique Reach: Viewable Impression Reach (Unique Reach) | UniqueReach |
| viewable_gross_rating_points | NUMERIC | Viewable Target Rating Points | Viewable Target Rating Points | UniqueReachAudience |
| viewable_impressions | NUMERIC | Active View: Viewable Impressions | Active View: Viewable Impressions | General |
| virtual_people_average_impression_frequency_by_demo_coviewed | NUMERIC | Unique Reach: Average Impression Frequency (Co-Viewed) (Unique Reach Audience) | Unique Reach: Average Impression Frequency (Co-Viewed) (Unique Reach Audience) | UniqueReachAudience |
| virtual_people_average_viewable_impression_frequency_by_demo | NUMERIC | Unique Reach: Average Viewable Impression Frequency (Unique Reach Audience) | Unique Reach: Average Viewable Impression Frequency (Unique Reach Audience) | UniqueReachAudience |
| virtual_people_click_reach_by_demo | NUMERIC | Unique Reach: Click Reach (Unique Reach Audience) | Unique Reach: Click Reach (Unique Reach Audience) | UniqueReachAudience |
| virtual_people_duplicate_click_reach | NUMERIC | Unique Reach: Duplicate Click Reach (Unique Reach) | Unique Reach: Duplicate Click Reach (Unique Reach) | UniqueReach |
| virtual_people_duplicate_click_reach_percent | NUMERIC | Unique Reach: Duplicate Click Reach Percent (Unique Reach) | Unique Reach: Duplicate Click Reach Percent (Unique Reach) | UniqueReach |
| virtual_people_duplicate_impression_reach | NUMERIC | Unique Reach: Duplicate Impression Reach (Unique Reach) | Unique Reach: Duplicate Impression Reach (Unique Reach) | UniqueReach |
| virtual_people_duplicate_impression_reach_percent | NUMERIC | Unique Reach: Duplicate Impression Reach Percent (Unique Reach) | Unique Reach: Duplicate Impression Reach Percent (Unique Reach) | UniqueReach |
| virtual_people_duplicate_total_reach | NUMERIC | Unique Reach: Duplicate Total Reach (Unique Reach) | Unique Reach: Duplicate Total Reach (Unique Reach) | UniqueReach |
| virtual_people_duplicate_total_reach_percent | NUMERIC | Unique Reach: Duplicate Total Reach Percent (Unique Reach) | Unique Reach: Duplicate Total Reach Percent (Unique Reach) | UniqueReach |
| virtual_people_duplicate_viewable_impression_reach | NUMERIC | Unique Reach: Duplicate Viewable Impression Reach (Unique Reach) | Unique Reach: Duplicate Viewable Impression Reach (Unique Reach) | UniqueReach |
| virtual_people_duplicate_viewable_impression_reach_percent | NUMERIC | Unique Reach: Duplicate Viewable Impression Reach Percent (Unique Reach) | Unique Reach: Duplicate Viewable Impression Reach Percent (Unique Reach) | UniqueReach |
| virtual_people_exclusive_click_reach | NUMERIC | Unique Reach: Exclusive Click Reach (Unique Reach) | Unique Reach: Exclusive Click Reach (Unique Reach) | UniqueReach |
| virtual_people_exclusive_click_reach_percent | NUMERIC | Unique Reach: Exclusive Click Reach Percent (Unique Reach) | Unique Reach: Exclusive Click Reach Percent (Unique Reach) | UniqueReach |
| virtual_people_exclusive_impression_reach | NUMERIC | Unique Reach: Exclusive Impression Reach (Unique Reach) | Unique Reach: Exclusive Impression Reach (Unique Reach) | UniqueReach |
| virtual_people_exclusive_impression_reach_percent | NUMERIC | Unique Reach: Exclusive Impression Reach Percent (Unique Reach) | Unique Reach: Exclusive Impression Reach Percent (Unique Reach) | UniqueReach |
| virtual_people_exclusive_total_reach | NUMERIC | Unique Reach: Exclusive Total Reach (Unique Reach) | Unique Reach: Exclusive Total Reach (Unique Reach) | UniqueReach |
| virtual_people_exclusive_total_reach_percent | NUMERIC | Unique Reach: Exclusive Total Reach Percent | Unique Reach: Exclusive Total Reach Percent | UniqueReach |
| virtual_people_exclusive_viewable_impression_reach | NUMERIC | Unique Reach: Exclusive Viewable Impression Reach | Unique Reach: Exclusive Viewable Impression Reach | UniqueReach |
| virtual_people_exclusive_viewable_impression_reach_percent | NUMERIC | Unique Reach: Exclusive Viewable Impression Reach Percent | Unique Reach: Exclusive Viewable Impression Reach Percent | UniqueReach |
| virtual_people_impression_reach_by_demo | NUMERIC | Unique Reach: Impression Reach | Unique Reach: Impression Reach | UniqueReach |
| virtual_people_impression_reach_by_demo_coviewed | NUMERIC | Unique Reach: Impression Reach (Co-Viewed) (Unique Reach Audience) | Unique Reach: Impression Reach (Co-Viewed) (Unique Reach Audience) | UniqueReachAudience |
| virtual_people_impression_reach_percent | NUMERIC | % Population Reach | % Population Reach | UniqueReachAudience |
| virtual_people_impression_reach_percent_coviewed | NUMERIC | % Population Reach (Co-Viewed) (Unique Reach Audience) | % Population Reach (Co-Viewed) (Unique Reach Audience) | UniqueReachAudience |
| virtual_people_impression_reach_share_percent | NUMERIC | % Composition Reach | % Composition Reach | UniqueReachAudience |
| virtual_people_impression_reach_share_percent_covieved | NUMERIC | % Composition Reach (Co-Viewed) | % Composition Reach (Co-Viewed) | UniqueReachAudience |
| virtual_people_overlap_click_reach | NUMERIC | Unique Reach: Overlap Click Reach | Unique Reach: Overlap Click Reach | UniqueReach |
| virtual_people_overlap_click_reach_percent | NUMERIC | Unique Reach: Overlap Click Reach Percent | Unique Reach: Overlap Click Reach Percent | UniqueReach |
| virtual_people_overlap_impression_reach | NUMERIC | Unique Reach: Overlap Impression Reach | Unique Reach: Overlap Impression Reach | UniqueReach |
| virtual_people_overlap_impression_reach_percent | NUMERIC | Unique Reach: Overlap Impression Reach Percent | Unique Reach: Overlap Impression Reach Percent | UniqueReach |
| virtual_people_overlap_total_reach | NUMERIC | Unique Reach: Overlap Total Reach | Unique Reach: Overlap Total Reach | UniqueReach |
| virtual_people_overlap_total_reach_percent | NUMERIC | Unique Reach: Overlap Total Reach Percent | Unique Reach: Overlap Total Reach Percent | UniqueReach |
| virtual_people_overlap_viewable_impression_reach | NUMERIC | Unique Reach: Overlap Viewable Impression Reach | Unique Reach: Overlap Viewable Impression Reach | UniqueReach |
| virtual_people_overlap_viewable_impression_reach_percent | NUMERIC | Unique Reach: Overlap Viewable Impression Reach Percent | Unique Reach: Overlap Viewable Impression Reach Percent | UniqueReach |
| virtual_people_viewable_impression_reach_by_demo | NUMERIC | Unique Reach: Viewable Impression Reach | Unique Reach: Viewable Impression Reach | UniqueReach |
| virtual_people_viewable_impression_reach_percent | NUMERIC | % Viewable Population Reach | % Viewable Population Reach | UniqueReachAudience |
| virtual_people_viewable_impression_reach_share_percent | NUMERIC | % Viewable Composition Reach | % Viewable Composition Reach | UniqueReachAudience |
| week | TEXT | Week | Week (Sunday - Saturday, yyyy/mm/dd - yyyy/mm/dd) | General |
| week_day | TEXT | Day of week and day number | Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday. | |
| week_day_iso | TEXT | Day of week and day number, ISO | Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7 | |
| week_iso | TEXT | Week ISO | Week, ISO format (Mon-Sun). | |
| year | TEXT | Year | Year (yyyy) | General |
| year_month | TEXT | Yearmonth | Year and month, e.g. 2024|3 | |
| year_of_week | TEXT | Year of week | The year that contains first day of the week (Sun-Sat). | |
| year_of_week_iso | TEXT | Year of week, ISO | The year that contains first day of the ISO week (Mon-Sun). | |
| year_week | TEXT | Year week | Year and week for US weeks (Sun-Sat), e.g. 2024|15 | |
| year_week_iso | TEXT | Year week ISO | Year and week for ISO weeks (Mon-Sun), e.g. 2024|20 |