Google Display & Video 360 (DV360) Connector Reference
https://connectors.windsor.ai/dv360?api_key=[your API key]&date_preset=last_7d&fields=campaign,clicks,spend,impressions,date,source&_renderer=csv
The Google Display & Video 360 (DV360) connector exposes 345 fields (200 metrics, 145 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.
Available options
report_type Report Type
The report type you want to fetch from DV360.
batch_advertisers Batch Advertisers
Fetch report data for advertisers sharing the same credentials, fields and date range in a single Bid Manager report instead of one report per advertiser. Reduces the daily report quota consumed per Google user, which helps accounts with many advertisers.
Google Display & Video 360 (DV360) Fields
Google Display & Video 360 (DV360) Campaigns fields
The Campaigns report of the Google Display & Video 360 (DV360) connector includes 11 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| campaign_budget_id | TEXT | Campaign Budget ID | The unique ID of the campaign budget. Assigned by the system. Do not set for new budgets. |
| campaign_budget_name | TEXT | Campaign Budget Name | The display name of the budget. |
| campaign_budget_unit | TEXT | Campaign Budget Unit | Specifies whether the budget is measured in currency or impressions. |
| campaign_goal_type | TEXT | Campaign Goal Type | The type of the campaign goal. |
| campaign_performance_goal_amount | NUMERIC | Campaign Performance Goal Amount | The goal amount, in micros of the advertiser's currency. |
| campaign_performance_goal_perc | NUMERIC | Campaign Perfomance Goal Percentage | The decimal representation of the goal percentage in micros. |
| campaign_performance_goal_type | TEXT | Campaign Performance Goal Type | The type of the campaign perfomance goal. |
| campaign_planned_end_date | DATE | Campaign Planned End Date | End date that the campaign is expected to run. They are resolved relative to the parent advertiser's time zone. |
| campaign_planned_spend | NUMERIC | Campaign Planned Spend | The amount the campaign is expected to spend for its given plannedDates. |
| campaign_planned_start_date | DATE | Campaign Planned Start Date | Start date that the campaign is expected to run. They are resolved relative to the parent advertiser's time zone. |
| campaign_update_time | Campaign Update Time | The timestamp when the campaign was last updated. Assigned by the system. |
Google Display & Video 360 (DV360) CPC fields
The CPC report of the Google Display & Video 360 (DV360) connector includes 18 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| media_cost_ecpc_advertiser | NUMERIC | Media Cost eCPC (Advertiser Currency) | Media Cost eCPC (Advertiser Currency) |
| media_cost_ecpc_partner | NUMERIC | Media Cost eCPC (Partner Currency) | Media Cost eCPC (Partner Currency) |
| media_cost_ecpc_usd | NUMERIC | Media Cost eCPC (USD) | Media Cost eCPC (USD) |
| media_cost_ecpcv_advertiser | NUMERIC | Video Media Cost eCPCV (Advertiser Currency) | Video Media Cost eCPCV (Advertiser Currency) |
| media_cost_ecpcv_partner | NUMERIC | Video Media Cost eCPCV (Partner Currency) | Video Media Cost eCPCV (Partner Currency) |
| media_cost_ecpcv_usd | NUMERIC | Video Media Cost eCPCV (USD) | Video Media Cost eCPCV (USD) |
| revenue_ecpc_advertiser | NUMERIC | Revenue eCPC (Advertiser Currency) | Revenue eCPC (Advertiser Currency) |
| revenue_ecpc_partner | NUMERIC | Revenue eCPC (Partner Currency) | Revenue eCPC (Partner Currency) |
| revenue_ecpc_usd | NUMERIC | Revenue eCPC (USD) | Revenue eCPC (USD) |
| revenue_ecpcv_advertiser | NUMERIC | Video Revenue eCPCV (Advertiser Currency) | Video Revenue eCPCV (Advertiser Currency) |
| revenue_ecpcv_partner | NUMERIC | Video Revenue eCPCV (Partner Currency) | Video Revenue eCPCV (Partner Currency) |
| revenue_ecpcv_usd | NUMERIC | Video Revenue eCPCV (USD) | Video Revenue eCPCV (USD) |
| total_media_cost_ecpc_advertiser | NUMERIC | Total Media Cost eCPC (Advertiser Currency) | Total Media Cost eCPC (Advertiser Currency) |
| total_media_cost_ecpc_partner | NUMERIC | Total Media Cost eCPC (Partner Currency) | Total Media Cost eCPC (Partner Currency) |
| total_media_cost_ecpc_usd | NUMERIC | Total Media Cost eCPC (USD) | Total Media Cost eCPC (USD) |
| total_media_cost_ecpcv_advertiser | NUMERIC | Total Video Media Cost eCPCV (Advertiser Currency) | Total Video Media Cost eCPCV (Advertiser Currency) |
| total_media_cost_ecpcv_partner | NUMERIC | Total Video Media Cost eCPCV (Partner Currency) | Total Video Media Cost eCPCV (Partner Currency) |
| total_media_cost_ecpcv_usd | NUMERIC | Total Video Media Cost eCPCV (USD) | Total Video Media Cost eCPCV (USD) |
Google Display & Video 360 (DV360) CPM fields
The CPM report of the Google Display & Video 360 (DV360) connector includes 15 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| cpm_fee1_advertiser | NUMERIC | CPM Fee 1 (Advertiser Currency) | CPM Fee 1 (Advertiser Currency) |
| cpm_fee1_partner | NUMERIC | CPM Fee 1 (Partner Currency) | CPM Fee 1 (Partner Currency) |
| cpm_fee1_usd | NUMERIC | CPM Fee 1 (USD) | CPM Fee 1 (USD) |
| cpm_fee2_advertiser | NUMERIC | CPM Fee 2 (Advertiser Currency) | CPM Fee 2 (Advertiser Currency) |
| cpm_fee2_partner | NUMERIC | CPM Fee 2 (Partner Currency) | CPM Fee 2 (Partner Currency) |
| cpm_fee2_usd | NUMERIC | CPM Fee 2 (USD) | CPM Fee 2 (USD) |
| cpm_fee3_advertiser | NUMERIC | CPM Fee 3 (Advertiser Currency) | CPM Fee 3 (Advertiser Currency) |
| cpm_fee3_partner | NUMERIC | CPM Fee 3 (Partner Currency) | CPM Fee 3 (Partner Currency) |
| cpm_fee3_usd | NUMERIC | CPM Fee 3 (USD) | CPM Fee 3 (USD) |
| cpm_fee4_advertiser | NUMERIC | CPM Fee 4 (Advertiser Currency) | CPM Fee 4 (Advertiser Currency) |
| cpm_fee4_partner | NUMERIC | CPM Fee 4 (Partner Currency) | CPM Fee 4 (Partner Currency) |
| cpm_fee4_usd | NUMERIC | CPM Fee 4 (USD) | CPM Fee 4 (USD) |
| cpm_fee5_advertiser | NUMERIC | CPM Fee 5 (Advertiser Currency) | CPM Fee 5 (Advertiser Currency) |
| cpm_fee5_partner | NUMERIC | CPM Fee 5 (Partner Currency) | CPM Fee 5 (Partner Currency) |
| cpm_fee5_usd | NUMERIC | CPM Fee 5 (USD) | CPM Fee 5 (USD) |
Google Display & Video 360 (DV360) Creatives fields
The Creatives report of the Google Display & Video 360 (DV360) connector includes 4 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| cm_ad_id | TEXT | CM Ad ID | The Campaign Manager 360 tracking ad associated with the creative. |
| creative_create_time | Creative Create Time | The timestamp when the creative was created. Assigned by the system. | |
| creative_hosting_source | TEXT | Creative Hosting Source | Indicates where the creative is hosted. |
| creative_update_time | Creative Update Time | The timestamp when the creative was last updated. Assigned by the system. |
Google Display & Video 360 (DV360) Fees fields
The Fees report of the Google Display & Video 360 (DV360) connector includes 7 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| data_manager_platform_fee_advertiser | NUMERIC | Data Management Platform Fee (Advertiser Currency) | Data Management Platform Fee (Advertiser Currency) |
| data_manager_platform_fee_partner | NUMERIC | Data Management Platform Fee (Partner Currency) | Data Management Platform Fee (Partner Currency) |
| data_manager_platform_fee_usd | NUMERIC | Data Management Platform Fee (USD) | Data Management Platform Fee (USD) |
| platform_fee_advertiser | NUMERIC | Platform Fee (Advertiser Currency) | Platform Fee (Advertiser Currency) |
| platform_fee_partner | NUMERIC | Platform Fee (Partner Currency) | Platform Fee (Partner Currency) |
| platform_fee_rate | NUMERIC | Platform Fee Rate | Platform Fee Rate |
| platform_fee_usd | NUMERIC | Platform Fee (USD) | Platform Fee (USD) |
Google Display & Video 360 (DV360) General fields
The General report of the Google Display & Video 360 (DV360) connector includes 110 fields.
Google Display & Video 360 (DV360) General fields (account_id to currency_advertiser)
| ID | Type | Name | Description |
|---|---|---|---|
| account_id | TEXT | Account ID | Your DV360 advertiser ID |
| account_name | TEXT | Account Name | Your DV360 advertiser name |
| 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 |
| 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 |
| 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 |
| advertiser_id | TEXT | Advertiser ID | Advertiser ID |
| advertiser_name | TEXT | Advertiser | Advertiser Name |
| age | TEXT | Age | Age |
| app_url | TEXT | App/URL | App/URL |
| app_url_excluded | TEXT | App/URL Excluded | App/URL Excluded |
| attribution_model | TEXT | Attribution Model | Attribution Model |
| audio_mutes_audio | NUMERIC | Audio Mutes (Audio) | Audio Mutes (Audio) |
| audio_unmutes_audio | NUMERIC | Audio Unmutes (Audio) | Audio Unmutes (Audio) |
| budget_segment_budget | TEXT | Budget Segment Budget | Budget Segment Budget |
| budget_segment_end_date | DATE | Budget Segment End Date | Budget Segment End Date |
| budget_segment_name | TEXT | Budget Segment Name | Budget Segment Name |
| budget_segment_pacing_percentage | TEXT | Budget Segment Pacing Percentage | Budget Segment Pacing Percentage |
| budget_segment_start_date | DATE | Budget Segment Start Date | Budget Segment Start Date |
| budget_segment_type | TEXT | Budget Type (Segment) | Budget Type (Segment) |
| campaign | TEXT | Campaign | The Campaign Name |
| campaign_id | TEXT | Campaign ID | The Campaign ID |
| city | CITY | City | City Name |
| cityid | TEXT | City ID | City ID |
| clicks | NUMERIC | Clicks | The Number of Clicks |
| clicks_lead_conv_perc | NUMERIC | Clicks Lead Conv Percentage | Clicks Leading to Conversions % |
| cm_placement_id | TEXT | CM Placement ID | The unique ID of the Campaign Manager 360 placement associated with the creative. |
| cm_post_click_revenue | NUMERIC | CM360 Post-Click Revenue | CM360 Post-Click Revenue. |
| cm_post_view_revenue | NUMERIC | CM360 Post-View Revenue | CM360 Post-View Revenue. |
| companion_clicks_audio | NUMERIC | Companion Clicks (Audio) | Companion Clicks (Audio) |
| companion_impressions_audio | NUMERIC | Companion Views (Audio) | Companion Views (Audio) |
| complete_listens_audio | NUMERIC | Complete Listens (Audio) | Complete Listens (Audio) |
| complete_views_video | NUMERIC | Complete Views (Video) | Complete Views (Video) |
| completion_rate_audio | PERCENT | Completion Rate (Audio) | Completion Rate (Audio) |
| conversions | NUMERIC | Conversions | Total conversions |
| country | COUNTRY | Country | Country |
| creative | TEXT | Creative | Creative |
| creative_id | TEXT | Creative ID | Creative ID |
| creative_size | TEXT | Creative Size | Creative Size |
| creativetype | TEXT | Creative Type | The type of the creative. |
| currency_advertiser | TEXT | Advertiser Currency | Advertiser currency |
Google Display & Video 360 (DV360) General fields (currency_partner to pauses_audio)
| ID | Type | Name | Description |
|---|---|---|---|
| currency_partner | TEXT | Partner Currency | Partner currency |
| date | DATE | Date | The Date |
| device | TEXT | Device | Device (alias for Device Type) |
| device_make | TEXT | Device Make (DV360) | Device Make (DV360) |
| device_model | TEXT | Device Model | Device Model |
| device_type | TEXT | Device Type | Device Type |
| dma | TEXT | DMA | Designated Market Area (DMA). |
| exchange | TEXT | Exchange | The exchange through which the ad was purchased/served |
| exchange_id | TEXT | Exchange ID | The ID of a specific exchange |
| first_quartile_audio | NUMERIC | First-Quartile (Audio) | First-Quartile (Audio) |
| first_quartile_views_video | NUMERIC | First-Quartile Views (Video) | First-Quartile Views (Video) |
| floodlight_activity | TEXT | Floodlight Activity Name | Floodlight Activity Name |
| floodlight_activity_id | TEXT | Floodlight Activity ID | Floodlight Activity ID |
| floodlight_impressions | NUMERIC | Floodlight Impressions | Floodlight Impressions |
| fullscreens_video | NUMERIC | Fullscreens (Video) | Fullscreens (Video) |
| gender | TEXT | Gender | Gender |
| impressions | NUMERIC | Impressions | The Number of Impressions Served |
| impressions_coviewed | NUMERIC | Impressions (Co-Viewed) | Impressions (Co-Viewed) |
| insertion_order | TEXT | Insertion Order | The Insertion Order Name |
| insertion_order_id | TEXT | Insertion Order ID | The Insertion Order ID |
| interactive_impressions | NUMERIC | Interactive Impressions | The number of impressions that occurred when a user interacted with a Rich Media ad (clicked an exit link, viewed it full-screen, moused over it for at least 1 continuous second, or expanded it). |
| line_item | TEXT | Line Item Name | The Line Item Name |
| line_item_budget | TEXT | Line Item Budget | The Line Item Budget |
| line_item_daily_frequency | TEXT | Line Item Daily Frequency | The Line Item Frequency |
| line_item_end_date | DATE | Line Item End Date | The Line Item End Date |
| line_item_id | TEXT | Line Item ID | The Line Item ID |
| line_item_integration_code | TEXT | Line Item Integration Code | The Line Item Integration Code |
| line_item_lifetime_frequency | TEXT | Line Item Lifetime Frequency | The Line Item Lifetime Frequency |
| line_item_pacing_percentage | TEXT | Line Item Pacing Percentage | The Line Item Pacing Percentage |
| line_item_start_date | DATE | Line Item Start Date | The Line Item Start Date |
| line_item_status | TEXT | Line Item Status | The Line Item Status |
| line_item_type | TEXT | Line Item Type | The Line Item Type |
| measurable_impressions | NUMERIC | Active View: Measurable Impressions | Active View: Measurable Impressions |
| media_cost_advertiser_currency | NUMERIC | Media Cost (Advertiser Currency) | Media Cost (Advertiser Currency) |
| midpoint_audio | NUMERIC | Midpoint (Audio) | Midpoint (Audio) |
| midpoint_views_video | NUMERIC | Midpoint Views (Video) | Midpoint Views (Video) |
| month | TEXT | Month | Month (yyyy/mm) |
| partner | TEXT | Partner (DV360) | Partner |
| partner_id | TEXT | Partner ID | Partner ID |
| pauses_audio | NUMERIC | Pauses (Audio) | Pauses (Audio) |
Google Display & Video 360 (DV360) General fields (post_click_conversions to zip_postal_code)
| ID | Type | Name | Description |
|---|---|---|---|
| post_click_conversions | NUMERIC | Post-Click Conversions | Post-Click Conversions |
| post_view_conversions | NUMERIC | Post-View Conversions | Post-View Conversions |
| region | REGION | Region | Region Name |
| regionid | TEXT | Region ID | Region ID |
| revenue_advertiser | NUMERIC | Revenue (Advertiser Currency) | Revenue (Advertiser Currency) |
| revenue_partner | NUMERIC | Revenue (Partner Currency) | Revenue (Partner Currency) |
| revenue_usd | NUMERIC | Revenue (USD) | Revenue (USD) |
| skips_video | NUMERIC | Skips (Video) | Skips (Video) |
| spend | NUMERIC | Spend in Advertiser Currency | The Media Spend in the Advertiser Currency |
| spend_partner | NUMERIC | Spend in Partner Currency | The Media Spend in the Partner Currency |
| spend_usd | NUMERIC | Spend in USD | The Media Spend in USD |
| starts_audio | NUMERIC | Starts (Audio) | Starts (Audio) |
| starts_video | NUMERIC | Starts (Video) | Starts (Video) |
| stops_audio | NUMERIC | Stops (Audio) | Stops (Audio) |
| tea_trueview_impressions | NUMERIC | (Deprecated) Potential Impressions | Potential Impressions |
| tea_trueview_unique_cookies | NUMERIC | (Deprecated) Unique Cookies with Impressions | Unique Cookies with Impressions |
| third_quartile_audio | NUMERIC | Third-Quartile (Audio) | Third-Quartile (Audio) |
| third_quartile_views_video | NUMERIC | Third-Quartile Views (Video) | Third-Quartile Views (Video) |
| time_of_day | TEXT | Time of Day | Time of Day (hour, 0-23) |
| total_conversions | NUMERIC | Total Conversions | Total Conversions |
| total_display_time | NUMERIC | Total Display Time | Total Display Time |
| total_media_cost_advertiser | NUMERIC | Total Media Cost (Advertiser Currency) | Total Media Cost (Advertiser Currency) |
| total_media_cost_partner | NUMERIC | Total Media Cost (Partner Currency) | Total Media Cost (Partner Currency) |
| total_media_cost_usd | NUMERIC | Total Media Cost (USD) | Total Media Cost (USD) |
| totalcost | NUMERIC | Total Cost in Advertiser Currency | The Media Spend in the Advertiser Currency (Duplicate) |
| totalcost_usd | NUMERIC | Total Cost USD | The Media Spend in USD (Duplicate) |
| viewable_impressions | NUMERIC | Active View: Viewable Impressions | Active View: Viewable Impressions |
| week | TEXT | Week | Week (Sunday - Saturday, yyyy/mm/dd - yyyy/mm/dd) |
| year | TEXT | Year | Year (yyyy) |
| zip_postal_code | TEXT | Zip/Postal Code | Zip/Postal Code. |
Google Display & Video 360 (DV360) Inventory fields
The Inventory report of the Google Display & Video 360 (DV360) connector includes 12 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| inventory_commitment_type | TEXT | Inventory Commitment Type | Inventory Commitment Type |
| inventory_delivery_method | TEXT | Inventory Delivery Method | Inventory Delivery Method |
| inventory_format | TEXT | Inventory Format | Inventory Format |
| inventory_media_cost_type | TEXT | Inventory Media Cost Type | Inventory Media Cost Type |
| inventory_rate_type | TEXT | Inventory Rate Type | Inventory Rate Type |
| inventory_source_group | TEXT | Inventory Source Group | Inventory Source Group |
| inventory_source_group_id | TEXT | Inventory Source Group ID | Inventory Source Group ID |
| inventory_source_id | TEXT | Inventory Source ID | Inventory Source ID |
| inventory_source_id_external | TEXT | Inventory Source ID (external) | Inventory Source ID (external) |
| inventory_source_name | TEXT | Inventory Source | Inventory Source |
| inventory_source_type | TEXT | Inventory Source Type | Inventory Source Type |
| inventory_sources_permissions | TEXT | Inventory Sources Permissions | Inventory Sources Permissions |
Google Display & Video 360 (DV360) MediaFee fields
The MediaFee report of the Google Display & Video 360 (DV360) connector includes 15 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| media_fee1_advertiser | NUMERIC | Media Fee 1 (Advertiser Currency) | Media Fee 1 (Advertiser Currency) |
| media_fee1_partner | NUMERIC | Media Fee 1 (Partner Currency) | Media Fee 1 (Partner Currency) |
| media_fee1_usd | NUMERIC | Media Fee 1 (USD) | Media Fee 1 (USD) |
| media_fee2_advertiser | NUMERIC | Media Fee 2 (Advertiser Currency) | Media Fee 2 (Advertiser Currency) |
| media_fee2_partner | NUMERIC | Media Fee 2 (Partner Currency) | Media Fee 2 (Partner Currency) |
| media_fee2_usd | NUMERIC | Media Fee 2 (USD) | Media Fee 2 (USD) |
| media_fee3_advertiser | NUMERIC | Media Fee 3 (Advertiser Currency) | Media Fee 3 (Advertiser Currency) |
| media_fee3_partner | NUMERIC | Media Fee 3 (Partner Currency) | Media Fee 3 (Partner Currency) |
| media_fee3_usd | NUMERIC | Media Fee 3 (USD) | Media Fee 3 (USD) |
| media_fee4_advertiser | NUMERIC | Media Fee 4 (Advertiser Currency) | Media Fee 4 (Advertiser Currency) |
| media_fee4_partner | NUMERIC | Media Fee 4 (Partner Currency) | Media Fee 4 (Partner Currency) |
| media_fee4_usd | NUMERIC | Media Fee 4 (USD) | Media Fee 4 (USD) |
| media_fee5_advertiser | NUMERIC | Media Fee 5 (Advertiser Currency) | Media Fee 5 (Advertiser Currency) |
| media_fee5_partner | NUMERIC | Media Fee 5 (Partner Currency) | Media Fee 5 (Partner Currency) |
| media_fee5_usd | NUMERIC | Media Fee 5 (USD) | Media Fee 5 (USD) |
Google Display & Video 360 (DV360) TrueView Dim. Additional fields
The TrueView Dim. Additional report of the Google Display & Video 360 (DV360) connector includes 9 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| placement_name_all_youtube_channels | TEXT | Placement Name (All YouTube Channels) | Placement name across all YouTube channels. YouTube-report dimension: request it together with a YouTube/TrueView metric. |
| trueview_ad | TEXT | YouTube Ad | YouTube Ad |
| trueview_ad_group_ad_id | TEXT | YouTube Ad ID | YouTube Ad ID |
| trueview_detailed_demographics | TEXT | Detailed Demographics | Detailed Demographics |
| trueview_detailed_demographics_id | TEXT | Detailed Demographics ID | Detailed Demographics ID |
| trueview_household_income | TEXT | Household Income | Household Income |
| trueview_placement | TEXT | Placement (Managed) | Placement (Managed) |
| trueview_placement_id | TEXT | Placement ID (Managed) | Placement ID (Managed) |
| trueview_url | TEXT | Placement (All) | Placement (All) |
Google Display & Video 360 (DV360) TrueView Dim. General fields
The TrueView Dim. General report of the Google Display & Video 360 (DV360) connector includes 7 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| trueview_ad_group | TEXT | YouTube Ad Group | YouTube Ad Group |
| trueview_ad_group_id | TEXT | YouTube Ad Group ID | YouTube Ad Group ID |
| trueview_ad_type_name | TEXT | YouTube Ad Type | YouTube Ad Type |
| trueview_category | TEXT | Trueview Category ID | Category ID |
| trueview_click_type_name | TEXT | Click Type | Click Type |
| trueview_conversion_type | TEXT | Trueview Conversion Type | Conversion Type |
| trueview_keyword | TEXT | Trueview Keyword | Keyword |
Google Display & Video 360 (DV360) TrueView Dim. Inventory Availability fields
The TrueView Dim. Inventory Availability report of the Google Display & Video 360 (DV360) connector includes 16 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| trueview_iar_age | TEXT | (Deprecated) Trueview Age | Age |
| trueview_iar_category | TEXT | (Deprecated) Category | Category |
| trueview_iar_city | CITY | (Deprecated) Trueview City | City |
| trueview_iar_country | COUNTRY | (Deprecated) Trueview IAR Country | Country |
| trueview_iar_country_name | COUNTRY | (Deprecated) Trueview IAR Country Name | Country |
| trueview_iar_gender | TEXT | (Deprecated) Trueview Gender | Gender |
| trueview_iar_interest | TEXT | (Deprecated) Trueview Interest | Interest |
| trueview_iar_language | TEXT | (Deprecated) Trueview Language | Language |
| trueview_iar_parental_status | TEXT | (Deprecated) Trueview Parental Status | Parental Status |
| trueview_iar_region | REGION | Trueview IAR Region | Region |
| trueview_iar_region_name | REGION | (Deprecated) Trueview IAR Region Name | Region |
| trueview_iar_remarketing_list | TEXT | (Deprecated) Trueview Remarketing List ID | Remarketing List ID |
| trueview_iar_time_of_day | (Deprecated) Time of Day (TrueView) | Time of Day (TrueView) | |
| trueview_iar_youtube_channel | TEXT | (Deprecated) YouTube Channel | YouTube Channel |
| trueview_iar_youtube_video | TEXT | (Deprecated) YouTube Video | YouTube Video |
| trueview_iar_zipcode | TEXT | (Deprecated) Zip Code | Zip Code |
Google Display & Video 360 (DV360) TrueView Dim. Location fields
The TrueView Dim. Location report of the Google Display & Video 360 (DV360) connector includes 7 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| trueview_city | CITY | TrueView City Name | City Name |
| trueview_country | COUNTRY | Trueview Country Name | Country Name |
| trueview_dma | TEXT | TrueView DMA ID | DMA ID |
| trueview_dma_name | TEXT | DMA (dv360) | DMA |
| trueview_region | REGION | Trueview Region ID | Region ID |
| trueview_region_name | REGION | Trueview Region Name | Region |
| trueview_zipcode | TEXT | Zipcode Name | Zipcode Name |
Google Display & Video 360 (DV360) TrueView Dim. Other. Can't be used as preset fields
The TrueView Dim. Other. Can't be used as preset report of the Google Display & Video 360 (DV360) connector includes 3 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| trueview_age | TEXT | Youtube Age | Age |
| trueview_gender | TEXT | Youtube (Trueview) Gender | Gender |
| trueview_targeting_expansion | TEXT | Targeting Expansion | Targeting Expansion |
Google Display & Video 360 (DV360) TrueView Metr. Conversion Performance fields
The TrueView Metr. Conversion Performance report of the Google Display & Video 360 (DV360) connector includes 4 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| trueview_conversion_cost_many_per_view_advertiser | NUMERIC | Cost / Conversion (Advertiser Currency) | Cost / Conversion (Advertiser Currency) |
| trueview_conversion_many_per_view | NUMERIC | Trueview Conversions | Conversions |
| trueview_conversion_rate_one_per_view | NUMERIC | View Conversion Rate | View Conversion Rate |
| trueview_total_conversion_values_advertiser | NUMERIC | Total Conversion Value (Advertiser Currency) | Total Conversion Value (Advertiser Currency) |
Google Display & Video 360 (DV360) TrueView Metr. Delivery fields
The TrueView Metr. Delivery report of the Google Display & Video 360 (DV360) connector includes 4 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| trueview_cpv_advertiser | NUMERIC | Revenue eCPV (Advertiser Currency) | Revenue eCPV (Advertiser Currency) |
| trueview_earned_views | NUMERIC | Earned Views | Earned Views metrics (Interactions) |
| trueview_view_rate | NUMERIC | TrueView: View Rate | TrueView: View Rate |
| trueview_views | NUMERIC | TrueView: Views | TrueView: Views |
Google Display & Video 360 (DV360) TrueView Metr. Interactions fields
The TrueView Metr. Interactions report of the Google Display & Video 360 (DV360) connector includes 7 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| trueview_average_cpe_advertiser | NUMERIC | Revenue eCPE (Advertiser Currency) | Revenue eCPE (Advertiser Currency) |
| trueview_earned_likes | NUMERIC | Earned Likes | Earned Likes |
| trueview_earned_playlist_additions | NUMERIC | Earned Playlist Additions | Earned Playlist Additions |
| trueview_earned_shares | NUMERIC | Earned Shares | Earned Shares |
| trueview_earned_subscribers | NUMERIC | Earned Subscribers | Earned Subscribers |
| trueview_engagement_rate | NUMERIC | Engagement Rate (dv360) | Engagement Rate |
| trueview_engagements | NUMERIC | Trueview Engagements | Engagements |
Google Display & Video 360 (DV360) TrueView Metr. Other. Can't be used as preset fields
The TrueView Metr. Other. Can't be used as preset report of the Google Display & Video 360 (DV360) connector includes 15 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| trueview_all_ad_sequence_impressions | NUMERIC | All YouTube Sequence Impressions | All YouTube Sequence Impressions |
| trueview_average_cpe_partner | NUMERIC | Revenue eCPE (Partner Currency) | Revenue eCPE (Partner Currency) |
| trueview_average_cpe_usd | NUMERIC | Revenue eCPE (USD) | Revenue eCPE (USD) |
| trueview_conversion_cost_many_per_view_partner | NUMERIC | Cost / Conversion (Partner Currency) | Cost / Conversion (Partner Currency) |
| trueview_conversion_cost_many_per_view_usd | NUMERIC | Cost / Conversion (USD) | Cost / Conversion (USD) |
| trueview_cpv_partner | NUMERIC | Revenue eCPV (Partner Currency) | Revenue eCPV (Partner Currency) |
| trueview_cpv_usd | NUMERIC | Revenue eCPV (USD) | Revenue eCPV (USD) |
| trueview_general_invalid_traffic_givt_views | NUMERIC | TrueView: General Invalid Traffic (GIVT) Views | TrueView: General Invalid Traffic (GIVT) Views |
| trueview_impression_share | NUMERIC | Impression Share | Impression Share |
| trueview_invalid_views | NUMERIC | TrueView: Invalid Views | TrueView: Invalid Views |
| trueview_lost_is_budget | NUMERIC | Lost Impression Share (Budget) | Lost Impression Share (Budget) |
| trueview_lost_is_rank | NUMERIC | Lost Impression Share (Rank) | Lost Impression Share (Rank) |
| trueview_total_conversion_values_partner | NUMERIC | Total Conversion Value (Partner Currency) | Total Conversion Value (Partner Currency) |
| trueview_total_conversion_values_usd | NUMERIC | Total Conversion Value (USD) | Total Conversion Value (USD) |
| trueview_unique_viewers | NUMERIC | Unique Viewers | Unique Viewers |
Google Display & Video 360 (DV360) UniqueReach fields
The UniqueReach report of the Google Display & Video 360 (DV360) connector includes 41 fields.
Google Display & Video 360 (DV360) UniqueReach fields (unique_reach_average_impression_frequency to virtual_people_overlap_viewable_impression_reach_percent)
| ID | Type | Name | Description |
|---|---|---|---|
| unique_reach_average_impression_frequency | NUMERIC | Unique Reach: Average Impression Frequency (Unique Reach) | Unique Reach: Average Impression Frequency (Unique Reach) |
| 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) |
| unique_reach_average_viewable_impression_frequency | NUMERIC | Unique Reach: Average Viewable Impression Frequency (Unique Reach) | Unique Reach: Average Viewable Impression Frequency (Unique Reach) |
| unique_reach_click_reach | NUMERIC | Unique Reach: Click Reach (Unique Reach) | Unique Reach: Click Reach (Unique Reach) |
| unique_reach_impression_reach | NUMERIC | Unique Reach: Impression Reach (Unique Reach) | Unique Reach: Impression Reach (Unique Reach) |
| 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) |
| 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) |
| unique_reach_impression_reach_coviewed | NUMERIC | Unique Reach: Impression Reach (Co-Viewed) (Unique Reach) | Unique Reach: Impression Reach (Co-Viewed) (Unique Reach) |
| unique_reach_incremental_click_reach | NUMERIC | Unique Reach: Incremental Click Reach (Unique Reach) | Unique Reach: Incremental Click Reach (Unique Reach) |
| unique_reach_incremental_impression_reach | NUMERIC | Unique Reach: Incremental Impression Reach (Unique Reach) | Unique Reach: Incremental Impression Reach (Unique Reach) |
| unique_reach_incremental_total_reach | NUMERIC | Unique Reach: Incremental Total Reach (Unique Reach) | Unique Reach: Incremental Total Reach (Unique Reach) |
| unique_reach_incremental_viewable_impression_reach | NUMERIC | Unique Reach: Incremental Viewable Impression Reach (Unique Reach) | Unique Reach: Incremental Viewable Impression Reach (Unique Reach) |
| unique_reach_total_reach | NUMERIC | Unique Reach: Total Reach (Unique Reach) | Unique Reach: Total Reach (Unique Reach) |
| unique_reach_total_reach_coviewed | NUMERIC | Unique Reach: Total Reach (Co-Viewed) (Unique Reach) | Unique Reach: Total Reach (Co-Viewed) (Unique Reach) |
| unique_reach_viewable_impression_reach | NUMERIC | Unique Reach: Viewable Impression Reach (Unique Reach) | Unique Reach: Viewable Impression Reach (Unique Reach) |
| virtual_people_duplicate_click_reach | NUMERIC | Unique Reach: Duplicate Click Reach (Unique Reach) | Unique Reach: Duplicate Click Reach (Unique Reach) |
| virtual_people_duplicate_click_reach_percent | NUMERIC | Unique Reach: Duplicate Click Reach Percent (Unique Reach) | Unique Reach: Duplicate Click Reach Percent (Unique Reach) |
| virtual_people_duplicate_impression_reach | NUMERIC | Unique Reach: Duplicate Impression Reach (Unique Reach) | Unique Reach: Duplicate Impression Reach (Unique Reach) |
| virtual_people_duplicate_impression_reach_percent | NUMERIC | Unique Reach: Duplicate Impression Reach Percent (Unique Reach) | Unique Reach: Duplicate Impression Reach Percent (Unique Reach) |
| virtual_people_duplicate_total_reach | NUMERIC | Unique Reach: Duplicate Total Reach (Unique Reach) | Unique Reach: Duplicate Total Reach (Unique Reach) |
| virtual_people_duplicate_total_reach_percent | NUMERIC | Unique Reach: Duplicate Total Reach Percent (Unique Reach) | Unique Reach: Duplicate Total Reach Percent (Unique Reach) |
| virtual_people_duplicate_viewable_impression_reach | NUMERIC | Unique Reach: Duplicate Viewable Impression Reach (Unique Reach) | Unique Reach: Duplicate Viewable Impression Reach (Unique Reach) |
| 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) |
| virtual_people_exclusive_click_reach | NUMERIC | Unique Reach: Exclusive Click Reach (Unique Reach) | Unique Reach: Exclusive Click Reach (Unique Reach) |
| virtual_people_exclusive_click_reach_percent | NUMERIC | Unique Reach: Exclusive Click Reach Percent (Unique Reach) | Unique Reach: Exclusive Click Reach Percent (Unique Reach) |
| virtual_people_exclusive_impression_reach | NUMERIC | Unique Reach: Exclusive Impression Reach (Unique Reach) | Unique Reach: Exclusive Impression Reach (Unique Reach) |
| virtual_people_exclusive_impression_reach_percent | NUMERIC | Unique Reach: Exclusive Impression Reach Percent (Unique Reach) | Unique Reach: Exclusive Impression Reach Percent (Unique Reach) |
| virtual_people_exclusive_total_reach | NUMERIC | Unique Reach: Exclusive Total Reach (Unique Reach) | Unique Reach: Exclusive Total Reach (Unique Reach) |
| virtual_people_exclusive_total_reach_percent | NUMERIC | Unique Reach: Exclusive Total Reach Percent | Unique Reach: Exclusive Total Reach Percent |
| virtual_people_exclusive_viewable_impression_reach | NUMERIC | Unique Reach: Exclusive Viewable Impression Reach | Unique Reach: Exclusive Viewable Impression Reach |
| virtual_people_exclusive_viewable_impression_reach_percent | NUMERIC | Unique Reach: Exclusive Viewable Impression Reach Percent | Unique Reach: Exclusive Viewable Impression Reach Percent |
| virtual_people_impression_reach_by_demo | NUMERIC | Unique Reach: Impression Reach | Unique Reach: Impression Reach |
| virtual_people_overlap_click_reach | NUMERIC | Unique Reach: Overlap Click Reach | Unique Reach: Overlap Click Reach |
| virtual_people_overlap_click_reach_percent | NUMERIC | Unique Reach: Overlap Click Reach Percent | Unique Reach: Overlap Click Reach Percent |
| virtual_people_overlap_impression_reach | NUMERIC | Unique Reach: Overlap Impression Reach | Unique Reach: Overlap Impression Reach |
| virtual_people_overlap_impression_reach_percent | NUMERIC | Unique Reach: Overlap Impression Reach Percent | Unique Reach: Overlap Impression Reach Percent |
| virtual_people_overlap_total_reach | NUMERIC | Unique Reach: Overlap Total Reach | Unique Reach: Overlap Total Reach |
| virtual_people_overlap_total_reach_percent | NUMERIC | Unique Reach: Overlap Total Reach Percent | Unique Reach: Overlap Total Reach Percent |
| virtual_people_overlap_viewable_impression_reach | NUMERIC | Unique Reach: Overlap Viewable Impression Reach | Unique Reach: Overlap Viewable Impression Reach |
| virtual_people_overlap_viewable_impression_reach_percent | NUMERIC | Unique Reach: Overlap Viewable Impression Reach Percent | Unique Reach: Overlap Viewable Impression Reach Percent |
Google Display & Video 360 (DV360) UniqueReach fields (virtual_people_viewable_impression_reach_by_demo to virtual_people_viewable_impression_reach_by_demo)
| ID | Type | Name | Description |
|---|---|---|---|
| virtual_people_viewable_impression_reach_by_demo | NUMERIC | Unique Reach: Viewable Impression Reach | Unique Reach: Viewable Impression Reach |
Google Display & Video 360 (DV360) UniqueReachAudience fields
The UniqueReachAudience report of the Google Display & Video 360 (DV360) connector includes 17 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| demo_composition_impression | NUMERIC | % Composition Impressions (Unique Reach Audience) | % Composition Impressions (Unique Reach Audience) |
| demo_composition_impression_coviewed | NUMERIC | % Composition Impressions (Co-Viewed) (Unique Reach Audience) | % Composition Impressions (Co-Viewed) (Unique Reach Audience) |
| grp_corrected_viewable_impressions | NUMERIC | Viewable Impressions (Unique Reach Audience) | Viewable Impressions (Unique Reach Audience) |
| grp_corrected_viewable_impressions_share_percent | NUMERIC | % Viewable Composition Impressions (Unique Reach Audience) | % Viewable Composition Impressions (Unique Reach Audience) |
| target_rating_points | NUMERIC | Target Rating Points | Target Rating Points |
| target_rating_points_coviewed | NUMERIC | Target Rating Points (Co-Viewed) | Target Rating Points (Co-Viewed) |
| viewable_gross_rating_points | NUMERIC | Viewable Target Rating Points | Viewable Target Rating Points |
| 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) |
| 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) |
| virtual_people_click_reach_by_demo | NUMERIC | Unique Reach: Click Reach (Unique Reach Audience) | Unique Reach: Click Reach (Unique Reach Audience) |
| 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) |
| virtual_people_impression_reach_percent | NUMERIC | % Population Reach | % Population Reach |
| virtual_people_impression_reach_percent_coviewed | NUMERIC | % Population Reach (Co-Viewed) (Unique Reach Audience) | % Population Reach (Co-Viewed) (Unique Reach Audience) |
| virtual_people_impression_reach_share_percent | NUMERIC | % Composition Reach | % Composition Reach |
| virtual_people_impression_reach_share_percent_covieved | NUMERIC | % Composition Reach (Co-Viewed) | % Composition Reach (Co-Viewed) |
| virtual_people_viewable_impression_reach_percent | NUMERIC | % Viewable Population Reach | % Viewable Population Reach |
| virtual_people_viewable_impression_reach_share_percent | NUMERIC | % Viewable Composition Reach | % Viewable Composition Reach |
Google Display & Video 360 (DV360) other fields
The Google Display & Video 360 (DV360) connector has 23 fields that do not belong to a named report, or belong to a report with only one or two fields.
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| data_fetched_at | Data fetched at | UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed. | ||
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| day_of_month | TEXT | Day of month | Day of the month | |
| demo_population | NUMERIC | Population | Population | Demo |
| 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 |
| now | Now | Current timestamp | ||
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date | |
| trueview_custom_affinity | TEXT | Custom Affinity ID | Custom Affinity ID | TrueView Dim. Additional Dimensions |
| trueview_interest | TEXT | Interest | Interest | TrueView Dim. YouTube Inventory Availability |
| trueview_parental_status | TEXT | Parental Status | Parental Status | TrueView Dim. YouTube Inventory Availability |
| 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 |
| 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_month | TEXT | Yearmonth | Year and month, e.g. 2024|3 | |
| year_month_name | TEXT | Year month name | Year and month with the month name written out, e.g. "Jan 2025". | |
| 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 |
