Affinity segment
affinity | |
---|---|
affinity_category | string Affinity category. |
affinity_id | int Affinity identifier. |
affinity_name | string Affinity name. |
Age group
age_group | |
---|---|
age_group_id | int Age group identifier. |
age_group_name | string Age group name. |
Browser
browser | |
---|---|
browser_id | int Browser identifier. |
browser_name | string Browser name. |
major_version | string Major version of the browser (whole number version). |
minor_version | string Minor version of the browser (incremental or decimal version). |
City
city | |
---|---|
city_id | int Unique ID of the city. |
city_name | string City name. |
country_code | string Two character country code. |
latitude | int Latitude in degrees. |
longitude | int Longitude in degrees. |
metro_code | string Metropolitan area code. |
region_code | string The multi character code of the region |
Campaign Manager Data Transfer account info
cm_dt_account_info | |
---|---|
account_id | int Unique ID of the account. |
timezone_name | string Timezone of the account. |
Campaign Manager Data Transfer Active View plus
cm_dt_active_view_plus | |
---|---|
device_id_md5 | string MD5-hashed device ID; a utility may be provided to hash raw device IDs to match. |
event | struct |
event.active_view_audible_impressions | int Active View: Impressions Audible |
event.active_view_audible_time_msec | int Active View: Play Time Audible (Seconds) |
event.active_view_audible_visible_time_msec | int Active View: Play Time Audible and Visible (Seconds) |
event.active_view_background_count | int Active View: Impressions In Background |
event.active_view_complete_viewable_impressions | int Active View: Impressions Visible at Completion |
event.active_view_eligible_impressions | int Active View: Eligible Impressions |
event.active_view_first_quartile_viewable_audible_impressions | int Active View: Impressions Visible and Audible at First Quartile |
event.active_view_first_quartile_viewable_impressions | int Active View: Impressions Visible at First Quartile |
event.active_view_fullscreen_count | int Active View: Impressions Full-Screen |
event.active_view_impressions_audible_and_visible_at_completion | int Active View: Impressions Audible and Visible at Completion |
event.active_view_impressions_visible10_seconds | int Active View: Impressions Visible 10 Seconds |
event.active_view_measurable_impressions | int Active View: Measurable Impressions |
event.active_view_midpoint_viewable_audible_impressions | int Active View: Impressions Visible and Audible at Midpoint |
event.active_view_midpoint_viewable_impressions | int Active View: Impressions Visible at Midpoint |
event.active_view_plus_measurable_count | int Active View Plus: Measurable Impressions |
event.active_view_start_viewable_audible_impressions | int Active View: Impressions Visible and Audible at Start |
event.active_view_start_viewable_impressions | int Active View: Impressions Visible at Start |
event.active_view_third_quartile_viewable_audible_impressions | int Active View: Impressions Visible and Audible at Third Quartile |
event.active_view_third_quartile_viewable_impressions | int Active View: Impressions Visible at Third Quartile |
event.active_view_tos_msec | int Active View: Time on Screen (Seconds) |
event.active_view_viewable_impressions | int Active View: Viewable Impressions |
event.active_view_visible_time_msec | int Active View: Video Visible Time (Seconds) |
event.activity_count | int Activity Quantity |
event.activity_id | int Activity ID |
event.activity_revenue | double Activity Revenue |
event.ad_id | int Ad ID |
event.advertiser_id | int Advertiser ID |
event.audience_segment_id | int |
event.browser_platform_id | string Browser/Platform ID |
event.browser_version | string Browser/Platform Version |
event.campaign_id | int Campaign ID |
event.city_id | int City ID |
event.conversion_id | int Conversion ID |
event.country_code | string Country |
event.creative_version | string Creative Version |
event.dma_region_id | int Designated Market Area (DMA) ID |
event.dv360_ad_position | int DV360 Ad Position |
event.dv360_advertiser_id | int DV360 Advertiser ID |
event.dv360_adx_page_categories | string DV360 Adx Page Categories |
event.dv360_attributed_inventory_source_external_id | string DV360 Attributed Inventory Source External ID |
event.dv360_attributed_inventory_source_is_public | string DV360 Attributed Inventory Source Is Public |
event.dv360_auction_id | string DV360 Auction ID |
event.dv360_bid_price_advertiser_currency | int DV360 Bid Price (Advertiser Currency) |
event.dv360_bid_price_partner_currency | int DV360 Bid Price (Partner Currency) |
event.dv360_bid_price_usd | int DV360 Bid Price (USD) |
event.dv360_billable_cost_advertiser_currency | int DV360 Billable Cost (Advertiser Currency) |
event.dv360_billable_cost_partner_currency | int DV360 Billable Cost (Partner Currency) |
event.dv360_billable_cost_usd | int DV360 Billable Cost (USD) |
event.dv360_browser_id | int DV360 Browser/Platform ID |
event.dv360_browser_timezone_offset_minutes | int DV360 Browser Timezone Offset Minutes |
event.dv360_campaign_id | int DV360 Campaign ID |
event.dv360_city_id | int DV360 City ID |
event.dv360_country_code | string DV360 Country Code |
event.dv360_cpm_fee_1_advertiser_currency | int |
event.dv360_cpm_fee_1_partner_currency | int |
event.dv360_cpm_fee_1_usd | int |
event.dv360_cpm_fee_2_advertiser_currency | int |
event.dv360_cpm_fee_2_partner_currency | int |
event.dv360_cpm_fee_2_usd | int |
event.dv360_cpm_fee_3_advertiser_currency | int |
event.dv360_cpm_fee_3_partner_currency | int |
event.dv360_cpm_fee_3_usd | int |
event.dv360_cpm_fee_4_advertiser_currency | int |
event.dv360_cpm_fee_4_partner_currency | int |
event.dv360_cpm_fee_4_usd | int |
event.dv360_cpm_fee_5_advertiser_currency | int |
event.dv360_cpm_fee_5_partner_currency | int |
event.dv360_cpm_fee_5_usd | int |
event.dv360_creative_id | int DV360 Creative ID |
event.dv360_data_fees_advertiser_currency | int |
event.dv360_data_fees_partner_currency | int |
event.dv360_data_fees_usd | int |
event.dv360_device_type | int DV360 Device Type |
event.dv360_exchange_id | string DV360 Exchange ID |
event.dv360_insertion_order_id | int DV360 Insertion Order ID |
event.dv360_isp_id | int DV360 ISP ID |
event.dv360_language | string DV360 Language |
event.dv360_line_item_id | int DV360 Line Item ID |
event.dv360_matching_targeted_keywords | string DV360 Matching Targeted Keywords |
event.dv360_matching_targeted_segments | string DV360 Matching Targeted Segments |
event.dv360_media_cost_advertiser_currency | int DV360 Media Cost (Advertiser Currency) |
event.dv360_media_cost_partner_currency | int DV360 Media Cost (Partner Currency) |
event.dv360_media_cost_usd | int DV360 Media Cost (USD) |
event.dv360_media_fee_1_advertiser_currency | int |
event.dv360_media_fee_1_partner_currency | int |
event.dv360_media_fee_1_usd | int |
event.dv360_media_fee_2_advertiser_currency | int |
event.dv360_media_fee_2_partner_currency | int |
event.dv360_media_fee_2_usd | int |
event.dv360_media_fee_3_advertiser_currency | int |
event.dv360_media_fee_3_partner_currency | int |
event.dv360_media_fee_3_usd | int |
event.dv360_media_fee_4_advertiser_currency | int |
event.dv360_media_fee_4_partner_currency | int |
event.dv360_media_fee_4_usd | int |
event.dv360_media_fee_5_advertiser_currency | int |
event.dv360_media_fee_5_partner_currency | int |
event.dv360_media_fee_5_usd | int |
event.dv360_mobile_make_id | int DV360 Mobile Make ID |
event.dv360_mobile_model_id | int DV360 Mobile Model ID |
event.dv360_net_speed | int DV360 Net Speed |
event.dv360_operating_system_id | int Operating System ID. |
event.dv360_request_time | int DV360 Request Time |
event.dv360_revenue_advertiser_currency | int DV360 Revenue (Advertiser Currency) |
event.dv360_revenue_partner_currency | int DV360 Revenue (Partner Currency) |
event.dv360_revenue_usd | int DV360 Revenue (USD) |
event.dv360_site_id | int DV360 Site ID |
event.dv360_state_region_id | int DV360 Region ID |
event.dv360_url | string DV360 URL |
event.dv360_view_state | string DV360 View State |
event.dv360_zip_postal_code | string DV360 ZIP/Postal Code |
event.event_sub_type | string Event Sub-Type |
event.event_time | int Event Time |
event.event_type | string Event Type |
event.floodlight_config_id | int Floodlight Configuration |
event.impression_id | string Impression ID |
event.interaction_time_utc_seconds | string Interaction Time |
event.landing_page_url_id | int Landing Page URL ID |
event.operating_system_id | int Operating System ID |
event.ord_value | string ORD Value |
event.other_data | string Other Data |
event.placement_id | int Placement ID |
event.platform_type_id | int |
event.referrer_url | string Referrer URL |
event.rendering_id | int Rendering ID |
event.rich_media_event_counters | int Event Counters |
event.rich_media_event_id | int Rich Media Event ID |
event.rich_media_event_timers | double Event Timers |
event.rich_media_event_type_id | int Rich Media Event Type ID |
event.segment_value_1 | int Segment Value 1 |
event.site_id | int Site ID (Campaign Manager) |
event.state | string State/Region |
event.tran_value | string TRAN Value |
event.u_value | string U Value |
event.zip_code | string Zip Code |
is_in_rdid_project | boolean True if this event is also in the _rdid table. Used for deduplication of events. |
network_id | int The network ID. |
user_id | string User ID |
Campaign Manager Data Transfer activities
cm_dt_activities | |
---|---|
device_id_md5 | string MD5-hashed device ID; a utility may be provided to hash raw device IDs to match. |
event | struct |
event.active_view_audible_impressions | int Active View: Impressions Audible |
event.active_view_audible_time_msec | int Active View: Play Time Audible (Seconds) |
event.active_view_audible_visible_time_msec | int Active View: Play Time Audible and Visible (Seconds) |
event.active_view_background_count | int Active View: Impressions In Background |
event.active_view_complete_viewable_impressions | int Active View: Impressions Visible at Completion |
event.active_view_eligible_impressions | int Active View: Eligible Impressions |
event.active_view_first_quartile_viewable_audible_impressions | int Active View: Impressions Visible and Audible at First Quartile |
event.active_view_first_quartile_viewable_impressions | int Active View: Impressions Visible at First Quartile |
event.active_view_fullscreen_count | int Active View: Impressions Full-Screen |
event.active_view_impressions_audible_and_visible_at_completion | int Active View: Impressions Audible and Visible at Completion |
event.active_view_impressions_visible10_seconds | int Active View: Impressions Visible 10 Seconds |
event.active_view_measurable_impressions | int Active View: Measurable Impressions |
event.active_view_midpoint_viewable_audible_impressions | int Active View: Impressions Visible and Audible at Midpoint |
event.active_view_midpoint_viewable_impressions | int Active View: Impressions Visible at Midpoint |
event.active_view_plus_measurable_count | int Active View Plus: Measurable Impressions |
event.active_view_start_viewable_audible_impressions | int Active View: Impressions Visible and Audible at Start |
event.active_view_start_viewable_impressions | int Active View: Impressions Visible at Start |
event.active_view_third_quartile_viewable_audible_impressions | int Active View: Impressions Visible and Audible at Third Quartile |
event.active_view_third_quartile_viewable_impressions | int Active View: Impressions Visible at Third Quartile |
event.active_view_tos_msec | int Active View: Time on Screen (Seconds) |
event.active_view_viewable_impressions | int Active View: Viewable Impressions |
event.active_view_visible_time_msec | int Active View: Video Visible Time (Seconds) |
event.activity_count | int Activity Quantity |
event.activity_id | int Activity ID |
event.activity_revenue | double Activity Revenue |
event.ad_id | int Ad ID |
event.advertiser_id | int Advertiser ID |
event.audience_segment_id | int |
event.browser_platform_id | string Browser/Platform ID |
event.browser_version | string Browser/Platform Version |
event.campaign_id | int Campaign ID |
event.city_id | int City ID |
event.conversion_id | int Conversion ID |
event.country_code | string Country |
event.creative_version | string Creative Version |
event.dma_region_id | int Designated Market Area (DMA) ID |
event.dv360_ad_position | int DV360 Ad Position |
event.dv360_advertiser_id | int DV360 Advertiser ID |
event.dv360_adx_page_categories | string DV360 Adx Page Categories |
event.dv360_attributed_inventory_source_external_id | string DV360 Attributed Inventory Source External ID |
event.dv360_attributed_inventory_source_is_public | string DV360 Attributed Inventory Source Is Public |
event.dv360_auction_id | string DV360 Auction ID |
event.dv360_bid_price_advertiser_currency | int DV360 Bid Price (Advertiser Currency) |
event.dv360_bid_price_partner_currency | int DV360 Bid Price (Partner Currency) |
event.dv360_bid_price_usd | int DV360 Bid Price (USD) |
event.dv360_billable_cost_advertiser_currency | int DV360 Billable Cost (Advertiser Currency) |
event.dv360_billable_cost_partner_currency | int DV360 Billable Cost (Partner Currency) |
event.dv360_billable_cost_usd | int DV360 Billable Cost (USD) |
event.dv360_browser_id | int DV360 Browser/Platform ID |
event.dv360_browser_timezone_offset_minutes | int DV360 Browser Timezone Offset Minutes |
event.dv360_campaign_id | int DV360 Campaign ID |
event.dv360_city_id | int DV360 City ID |
event.dv360_country_code | string DV360 Country Code |
event.dv360_cpm_fee_1_advertiser_currency | int |
event.dv360_cpm_fee_1_partner_currency | int |
event.dv360_cpm_fee_1_usd | int |
event.dv360_cpm_fee_2_advertiser_currency | int |
event.dv360_cpm_fee_2_partner_currency | int |
event.dv360_cpm_fee_2_usd | int |
event.dv360_cpm_fee_3_advertiser_currency | int |
event.dv360_cpm_fee_3_partner_currency | int |
event.dv360_cpm_fee_3_usd | int |
event.dv360_cpm_fee_4_advertiser_currency | int |
event.dv360_cpm_fee_4_partner_currency | int |
event.dv360_cpm_fee_4_usd | int |
event.dv360_cpm_fee_5_advertiser_currency | int |
event.dv360_cpm_fee_5_partner_currency | int |
event.dv360_cpm_fee_5_usd | int |
event.dv360_creative_id | int DV360 Creative ID |
event.dv360_data_fees_advertiser_currency | int |
event.dv360_data_fees_partner_currency | int |
event.dv360_data_fees_usd | int |
event.dv360_device_type | int DV360 Device Type |
event.dv360_exchange_id | string DV360 Exchange ID |
event.dv360_insertion_order_id | int DV360 Insertion Order ID |
event.dv360_isp_id | int DV360 ISP ID |
event.dv360_language | string DV360 Language |
event.dv360_line_item_id | int DV360 Line Item ID |
event.dv360_matching_targeted_keywords | string DV360 Matching Targeted Keywords |
event.dv360_matching_targeted_segments | string DV360 Matching Targeted Segments |
event.dv360_media_cost_advertiser_currency | int DV360 Media Cost (Advertiser Currency) |
event.dv360_media_cost_partner_currency | int DV360 Media Cost (Partner Currency) |
event.dv360_media_cost_usd | int DV360 Media Cost (USD) |
event.dv360_media_fee_1_advertiser_currency | int |
event.dv360_media_fee_1_partner_currency | int |
event.dv360_media_fee_1_usd | int |
event.dv360_media_fee_2_advertiser_currency | int |
event.dv360_media_fee_2_partner_currency | int |
event.dv360_media_fee_2_usd | int |
event.dv360_media_fee_3_advertiser_currency | int |
event.dv360_media_fee_3_partner_currency | int |
event.dv360_media_fee_3_usd | int |
event.dv360_media_fee_4_advertiser_currency | int |
event.dv360_media_fee_4_partner_currency | int |
event.dv360_media_fee_4_usd | int |
event.dv360_media_fee_5_advertiser_currency | int |
event.dv360_media_fee_5_partner_currency | int |
event.dv360_media_fee_5_usd | int |
event.dv360_mobile_make_id | int DV360 Mobile Make ID |
event.dv360_mobile_model_id | int DV360 Mobile Model ID |
event.dv360_net_speed | int DV360 Net Speed |
event.dv360_operating_system_id | int Operating System ID. |
event.dv360_request_time | int DV360 Request Time |
event.dv360_revenue_advertiser_currency | int DV360 Revenue (Advertiser Currency) |
event.dv360_revenue_partner_currency | int DV360 Revenue (Partner Currency) |
event.dv360_revenue_usd | int DV360 Revenue (USD) |
event.dv360_site_id | int DV360 Site ID |
event.dv360_state_region_id | int DV360 Region ID |
event.dv360_url | string DV360 URL |
event.dv360_view_state | string DV360 View State |
event.dv360_zip_postal_code | string DV360 ZIP/Postal Code |
event.event_sub_type | string Event Sub-Type |
event.event_time | int Event Time |
event.event_type | string Event Type |
event.floodlight_config_id | int Floodlight Configuration |
event.impression_id | string Impression ID |
event.interaction_time_utc_seconds | string Interaction Time |
event.landing_page_url_id | int Landing Page URL ID |
event.operating_system_id | int Operating System ID |
event.ord_value | string ORD Value |
event.other_data | string Other Data |
event.placement_id | int Placement ID |
event.platform_type_id | int |
event.referrer_url | string Referrer URL |
event.rendering_id | int Rendering ID |
event.rich_media_event_counters | int Event Counters |
event.rich_media_event_id | int Rich Media Event ID |
event.rich_media_event_timers | double Event Timers |
event.rich_media_event_type_id | int Rich Media Event Type ID |
event.segment_value_1 | int Segment Value 1 |
event.site_id | int Site ID (Campaign Manager) |
event.state | string State/Region |
event.tran_value | string TRAN Value |
event.u_value | string U Value |
event.zip_code | string Zip Code |
is_in_rdid_project | boolean True if this event is also in the _rdid table. Used for deduplication of events. |
network_id | int The network ID. |
user_id | string User ID |
Campaign Manager Data Transfer activity category
cm_dt_activity_category | |
---|---|
account_id | int Unique ID of the account. |
activity | string User defined category report interface name for floodlight tags. |
activity_group_id | int ID of the group to which this advertiser belongs. An advertiser may be a member of only one group. |
activity_id | int Unique ID of the Floodlight activity. |
activity_sub_type | string User defined string corresponding to cat= value from Floodlight tag. |
activity_type | string User defined string corresponding to type= value from Floodlight tag. |
advertiser_id | int Unique ID of the advertiser. |
floodlight_config_id | int Unique ID of the floodlight configuration. |
tag_counting_method_id | int User defined type - describing Floodlight tag type. Key: 1 - standard, 2 - unique, 3 - custom, 4 - integer of transactionfor sales tags only, 5 - integer of items sold. |
Campaign Manager Data Transfer activity type
cm_dt_activity_type | |
---|---|
account_id | int Unique ID of the account. |
activity_group | string Name for this activity group. |
activity_group_id | int ID of the group to which this advertiser belongs. An advertiser may be a member of only one group. |
activity_type | string User defined string corresponding to type= value from Floodlight tag. |
advertiser_id | int Unique ID of the advertiser. |
floodlight_config_id | int Unique ID of the floodlight configuration. |
Campaign Manager Data Transfer ad
cm_dt_ad | |
---|---|
account_id | int Unique ID of the account. |
ad | string User defined ad name. |
ad_click_url | string Click through URL of Click Ad type creatives only (aka Click Commands) |
ad_comments | string User defined ad level comments. |
ad_id | int Unique ID of the ad. |
ad_type | string Type of ad. Possible values are: Standard, Interstitial, Static Click, Dynamic Click, Tracking, In-Steam Video, DART Search, Affiliate, PInclusion, Product feeds, Natural Search, Default, Interstitial Default, InStream Default, Ad Brand-neutral |
ad_type_id | int Unique ID of the ad type. |
advertiser_id | int Unique ID of the advertiser. |
campaign_id | int Unique ID of the campaign. |
creative_size | string The creative size in pixels: width x height. Empty size is represented by "0X0". |
floodlight_config_id | int Unique ID of the floodlight configuration. |
Campaign Manager Data Transfer Ad placement assignments
cm_dt_ad_placement_assignment | |
---|---|
account_id | int Unique ID of the account. |
ad_id | int Unique ID of the ad. |
advertiser_id | int Unique ID of the advertiser. |
floodlight_config_id | int Unique ID of the floodlight configuration. |
placement_id | int |
Campaign Manager Data Transfer Advertiser
cm_dt_advertiser | |
---|---|
account_id | int Unique ID of the account. |
advertiser | string User entered name of the advertiser. |
advertiser_group | string User specified group to which this advertiser belongs. An advertiser may be a member of only one group. |
advertiser_group_id | int Group ID to which this advertiser belongs. An advertiser may be a member of only one group. |
advertiser_id | int Unique ID of the advertiser. |
floodlight_config_id | int Unique ID of the floodlight configuration. |
Campaign Manager Data Transfer asset
cm_dt_asset | |
---|---|
account_id | int Unique ID of the account. |
asset | string Name of the creative asset. |
asset_category | string Category of the creative asset. |
asset_id | int Unique ID of the asset. |
asset_orientation | string Screen orientation of the asset. |
Campaign Manager Data Transfer audience segments
cm_dt_audience_segments | |
---|---|
account_id | int Unique ID of the account. |
advertiser_id | int Unique ID of the advertiser. |
audience_segment | string Name of the audience segment. |
audience_segment_id | int Unique ID of the audience segment. |
floodlight_config_id | int Unique ID of the floodlight configuration. |
Campaign Manager Data Transfer browser
cm_dt_browser | |
---|---|
browser_platform | string |
browser_platform_id | int Browser / Platform ID |
Campaign Manager Data Transfer campaign
cm_dt_campaign | |
---|---|
account_id | int Unique ID of the account. |
advertiser_id | int Unique ID of the advertiser. |
billing_invoice_code | string The code entered in the billing invoice. |
campaign | string User entered campaign name. |
campaign_end_date | int Campaign end date as YYYYMMDD. |
campaign_id | int Unique ID of the campaign. |
campaign_start_date | int Campaign start date as YYYYMMDD. |
floodlight_config_id | int Unique ID of the floodlight configuration. |
Campaign Manager Data Transfer city
cm_dt_city | |
---|---|
city | string The city name |
city_id | int Unique ID of the city. |
Campaign Manager Data Transfer clicks
cm_dt_clicks | |
---|---|
device_id_md5 | string MD5-hashed device ID; a utility may be provided to hash raw device IDs to match. |
event | struct |
event.active_view_audible_impressions | int Active View: Impressions Audible |
event.active_view_audible_time_msec | int Active View: Play Time Audible (Seconds) |
event.active_view_audible_visible_time_msec | int Active View: Play Time Audible and Visible (Seconds) |
event.active_view_background_count | int Active View: Impressions In Background |
event.active_view_complete_viewable_impressions | int Active View: Impressions Visible at Completion |
event.active_view_eligible_impressions | int Active View: Eligible Impressions |
event.active_view_first_quartile_viewable_audible_impressions | int Active View: Impressions Visible and Audible at First Quartile |
event.active_view_first_quartile_viewable_impressions | int Active View: Impressions Visible at First Quartile |
event.active_view_fullscreen_count | int Active View: Impressions Full-Screen |
event.active_view_impressions_audible_and_visible_at_completion | int Active View: Impressions Audible and Visible at Completion |
event.active_view_impressions_visible10_seconds | int Active View: Impressions Visible 10 Seconds |
event.active_view_measurable_impressions | int Active View: Measurable Impressions |
event.active_view_midpoint_viewable_audible_impressions | int Active View: Impressions Visible and Audible at Midpoint |
event.active_view_midpoint_viewable_impressions | int Active View: Impressions Visible at Midpoint |
event.active_view_plus_measurable_count | int Active View Plus: Measurable Impressions |
event.active_view_start_viewable_audible_impressions | int Active View: Impressions Visible and Audible at Start |
event.active_view_start_viewable_impressions | int Active View: Impressions Visible at Start |
event.active_view_third_quartile_viewable_audible_impressions | int Active View: Impressions Visible and Audible at Third Quartile |
event.active_view_third_quartile_viewable_impressions | int Active View: Impressions Visible at Third Quartile |
event.active_view_tos_msec | int Active View: Time on Screen (Seconds) |
event.active_view_viewable_impressions | int Active View: Viewable Impressions |
event.active_view_visible_time_msec | int Active View: Video Visible Time (Seconds) |
event.activity_count | int Activity Quantity |
event.activity_id | int Activity ID |
event.activity_revenue | double Activity Revenue |
event.ad_id | int Ad ID |
event.advertiser_id | int Advertiser ID |
event.audience_segment_id | int |
event.browser_platform_id | string Browser/Platform ID |
event.browser_version | string Browser/Platform Version |
event.campaign_id | int Campaign ID |
event.city_id | int City ID |
event.conversion_id | int Conversion ID |
event.country_code | string Country |
event.creative_version | string Creative Version |
event.dma_region_id | int Designated Market Area (DMA) ID |
event.dv360_ad_position | int DV360 Ad Position |
event.dv360_advertiser_id | int DV360 Advertiser ID |
event.dv360_adx_page_categories | string DV360 Adx Page Categories |
event.dv360_attributed_inventory_source_external_id | string DV360 Attributed Inventory Source External ID |
event.dv360_attributed_inventory_source_is_public | string DV360 Attributed Inventory Source Is Public |
event.dv360_auction_id | string DV360 Auction ID |
event.dv360_bid_price_advertiser_currency | int DV360 Bid Price (Advertiser Currency) |
event.dv360_bid_price_partner_currency | int DV360 Bid Price (Partner Currency) |
event.dv360_bid_price_usd | int DV360 Bid Price (USD) |
event.dv360_billable_cost_advertiser_currency | int DV360 Billable Cost (Advertiser Currency) |
event.dv360_billable_cost_partner_currency | int DV360 Billable Cost (Partner Currency) |
event.dv360_billable_cost_usd | int DV360 Billable Cost (USD) |
event.dv360_browser_id | int DV360 Browser/Platform ID |
event.dv360_browser_timezone_offset_minutes | int DV360 Browser Timezone Offset Minutes |
event.dv360_campaign_id | int DV360 Campaign ID |
event.dv360_city_id | int DV360 City ID |
event.dv360_country_code | string DV360 Country Code |
event.dv360_cpm_fee_1_advertiser_currency | int |
event.dv360_cpm_fee_1_partner_currency | int |
event.dv360_cpm_fee_1_usd | int |
event.dv360_cpm_fee_2_advertiser_currency | int |
event.dv360_cpm_fee_2_partner_currency | int |
event.dv360_cpm_fee_2_usd | int |
event.dv360_cpm_fee_3_advertiser_currency | int |
event.dv360_cpm_fee_3_partner_currency | int |
event.dv360_cpm_fee_3_usd | int |
event.dv360_cpm_fee_4_advertiser_currency | int |
event.dv360_cpm_fee_4_partner_currency | int |
event.dv360_cpm_fee_4_usd | int |
event.dv360_cpm_fee_5_advertiser_currency | int |
event.dv360_cpm_fee_5_partner_currency | int |
event.dv360_cpm_fee_5_usd | int |
event.dv360_creative_id | int DV360 Creative ID |
event.dv360_data_fees_advertiser_currency | int |
event.dv360_data_fees_partner_currency | int |
event.dv360_data_fees_usd | int |
event.dv360_device_type | int DV360 Device Type |
event.dv360_exchange_id | string DV360 Exchange ID |
event.dv360_insertion_order_id | int DV360 Insertion Order ID |
event.dv360_isp_id | int DV360 ISP ID |
event.dv360_language | string DV360 Language |
event.dv360_line_item_id | int DV360 Line Item ID |
event.dv360_matching_targeted_keywords | string DV360 Matching Targeted Keywords |
event.dv360_matching_targeted_segments | string DV360 Matching Targeted Segments |
event.dv360_media_cost_advertiser_currency | int DV360 Media Cost (Advertiser Currency) |
event.dv360_media_cost_partner_currency | int DV360 Media Cost (Partner Currency) |
event.dv360_media_cost_usd | int DV360 Media Cost (USD) |
event.dv360_media_fee_1_advertiser_currency | int |
event.dv360_media_fee_1_partner_currency | int |
event.dv360_media_fee_1_usd | int |
event.dv360_media_fee_2_advertiser_currency | int |
event.dv360_media_fee_2_partner_currency | int |
event.dv360_media_fee_2_usd | int |
event.dv360_media_fee_3_advertiser_currency | int |
event.dv360_media_fee_3_partner_currency | int |
event.dv360_media_fee_3_usd | int |
event.dv360_media_fee_4_advertiser_currency | int |
event.dv360_media_fee_4_partner_currency | int |
event.dv360_media_fee_4_usd | int |
event.dv360_media_fee_5_advertiser_currency | int |
event.dv360_media_fee_5_partner_currency | int |
event.dv360_media_fee_5_usd | int |
event.dv360_mobile_make_id | int DV360 Mobile Make ID |
event.dv360_mobile_model_id | int DV360 Mobile Model ID |
event.dv360_net_speed | int DV360 Net Speed |
event.dv360_operating_system_id | int DV60 operating system ID |
event.dv360_request_time | int DV360 Request Time |
event.dv360_revenue_advertiser_currency | int DV360 Revenue (Advertiser Currency) |
event.dv360_revenue_partner_currency | int DV360 Revenue (Partner Currency) |
event.dv360_revenue_usd | int DV360 Revenue (USD) |
event.dv360_site_id | int DV360 Site ID |
event.dv360_state_region_id | int DV360 Region ID |
event.dv360_url | string DV360 URL |
event.dv360_view_state | string DV360 View State |
event.dv360_zip_postal_code | string DV360 ZIP/Postal Code |
event.event_sub_type | string Event Sub-Type |
event.event_time | int Event Time |
event.event_type | string Event Type |
event.floodlight_config_id | int Floodlight Configuration |
event.impression_id | string Impression ID |
event.interaction_time_utc_seconds | string Interaction Time |
event.landing_page_url_id | int Landing Page URL ID |
event.operating_system_id | int Operating System ID |
event.ord_value | string ORD Value |
event.other_data | string Other Data |
event.placement_id | int Placement ID |
event.platform_type_id | int |
event.referrer_url | string Referrer URL |
event.rendering_id | int Rendering ID |
event.rich_media_event_counters | int Event Counters |
event.rich_media_event_id | int Rich Media Event ID |
event.rich_media_event_timers | double Event Timers |
event.rich_media_event_type_id | int Rich Media Event Type ID |
event.segment_value_1 | int Segment Value 1 |
event.site_id | int Site ID (Campaign Manager) |
event.state | string State/Region |
event.tran_value | string TRAN Value |
event.u_value | string U Value |
event.zip_code | string Zip Code |
is_in_rdid_project | boolean True if this event is also in the _rdid table. Used for deduplication of events. |
network_id | int The network ID. |
user_id | string User ID |
Campaign Manager Data Transfer creative
cm_dt_creative | |
---|---|
account_id | int Unique ID of the account. |
advertiser_id | int Unique ID of the advertiser. |
creative | string Creative Name as entered into the Campaign Manager interface. |
creative_id | int The Creative ID in Campaign Manager UI. |
creative_image_url | string Location of creative image (Does not apply to rich media). |
creative_last_modified_date | int Unix epoch timestamp (milliseconds) of the last time this creative was modified. |
creative_size | string The creative size in pixels: width x height. Empty size is represented by "0X0". |
creative_type | string The type of creative. |
creative_type_id | int |
creative_version | int Used for change management to capture different versions |
floodlight_config_id | int Unique ID of the floodlight configuration. |
rendering_id | int Unique ID of the creative for Data Transfer. This isn't the creative ID in the Campaign Manager UI. |
Campaign Manager Data Transfer creative ad assignment
cm_dt_creative_ad_assignment | |
---|---|
account_id | int Unique ID of the account. |
ad_click_url | string Click through URL of Click Ad type creatives only (aka Click Commands) |
ad_id | int Unique ID of the ad. |
advertiser_id | int Unique ID of the advertiser. |
creative_end_date | int Rotation end date and time in milliseconds since 1970-01-01 00:00:00 UTC. |
creative_group1 | string User defined value from creative group 1. |
creative_group1_id | int Unique ID of creative group 1. |
creative_group2 | string User defined value from creative group 2. |
creative_group2_id | int Unique ID of creative group 2. |
creative_id | int The Creative ID in Campaign Manager UI. |
creative_rotation_type | string Rotation type. |
creative_rotation_type_id | int Id of the rotation type. |
creative_start_date | int Rotation start date and time in Unix epoch time (milliseconds). |
floodlight_config_id | int Unique ID of the floodlight configuration. |
Campaign Manager Data Transfer custom creative field
cm_dt_custom_creative_field | |
---|---|
account_id | int Unique ID of the account. |
advertiser_id | int Unique ID of the advertiser. |
creative_field_id | int The Creative ID in Campaign Manager UI. |
creative_field_name | string User defined name associated to a particular custom creative field. |
creative_field_number | int Slot ID assigned to this custom creative field (typically IDs from 1-20). |
creative_field_value | string User defined value as available option to named field. |
creative_field_value_id | int ID of the user defined creative value. |
creative_id | int The Creative ID in Campaign Manager UI. |
floodlight_config_id | int Unique ID of the floodlight configuration. |
Campaign Manager Data Transfer custom floodlight variable
cm_dt_custom_floodlight_variable | |
---|---|
account_id | int Unique ID of the account. |
advertiser_id | int Unique ID of the advertiser. |
floodlight_config_id | int Unique ID of the floodlight configuration. |
floodlight_variable_id | int Unique ID of the floodlight variable. |
floodlight_variable_name | string User defined name of the custom floodlight variable. |
Campaign Manager Data Transfer custom rich media
cm_dt_custom_rich_media | |
---|---|
account_id | int Unique ID of the account. |
advertiser_id | int Unique ID of the advertiser. |
floodlight_config_id | int Unique ID of the floodlight configuration. |
rich_media_event_id | int ID of the rich media event. |
rich_media_event_name | string Name of the rich media event. |
rich_media_event_type | string Possible values are: "Timer", "Exit", or "Counter". |
rich_media_event_type_id | int ID of the rich media event type. |
Campaign Manager Data Transfer designated market area
cm_dt_designated_market_area | |
---|---|
dma_region | string |
dma_region_id | int |
Campaign Manager Data Transfer events
cm_dt_events | |
---|---|
device_id_md5 | string MD5-hashed device ID; a utility may be provided to hash raw device IDs to match. |
event | struct |
event.active_view_audible_impressions | int Active View: Impressions Audible |
event.active_view_audible_time_msec | int Active View: Play Time Audible (Seconds) |
event.active_view_audible_visible_time_msec | int Active View: Play Time Audible and Visible (Seconds) |
event.active_view_background_count | int Active View: Impressions In Background |
event.active_view_complete_viewable_impressions | int Active View: Impressions Visible at Completion |
event.active_view_eligible_impressions | int Active View: Eligible Impressions |
event.active_view_first_quartile_viewable_audible_impressions | int Active View: Impressions Visible and Audible at First Quartile |
event.active_view_first_quartile_viewable_impressions | int Active View: Impressions Visible at First Quartile |
event.active_view_fullscreen_count | int Active View: Impressions Full-Screen |
event.active_view_impressions_audible_and_visible_at_completion | int Active View: Impressions Audible and Visible at Completion |
event.active_view_impressions_visible10_seconds | int Active View: Impressions Visible 10 Seconds |
event.active_view_measurable_impressions | int Active View: Measurable Impressions |
event.active_view_midpoint_viewable_audible_impressions | int Active View: Impressions Visible and Audible at Midpoint |
event.active_view_midpoint_viewable_impressions | int Active View: Impressions Visible at Midpoint |
event.active_view_plus_measurable_count | int Active View Plus: Measurable Impressions |
event.active_view_start_viewable_audible_impressions | int Active View: Impressions Visible and Audible at Start |
event.active_view_start_viewable_impressions | int Active View: Impressions Visible at Start |
event.active_view_third_quartile_viewable_audible_impressions | int Active View: Impressions Visible and Audible at Third Quartile |
event.active_view_third_quartile_viewable_impressions | int Active View: Impressions Visible at Third Quartile |
event.active_view_tos_msec | int Active View: Time on Screen (Seconds) |
event.active_view_viewable_impressions | int Active View: Viewable Impressions |
event.active_view_visible_time_msec | int Active View: Video Visible Time (Seconds) |
event.activity_count | int Activity Quantity |
event.activity_id | int Activity ID |
event.activity_revenue | double Activity Revenue |
event.ad_id | int Ad ID |
event.advertiser_id | int Advertiser ID |
event.audience_segment_id | int |
event.browser_platform_id | string Browser/Platform ID |
event.browser_version | string Browser/Platform Version |
event.campaign_id | int Campaign ID |
event.city_id | int City ID |
event.conversion_id | int Conversion ID |
event.country_code | string Country |
event.creative_version | string Creative Version |
event.dma_region_id | int Designated Market Area (DMA) ID |
event.dv360_ad_position | int DV360 Ad Position |
event.dv360_advertiser_id | int DV360 Advertiser ID |
event.dv360_adx_page_categories | string DV360 Adx Page Categories |
event.dv360_attributed_inventory_source_external_id | string DV360 Attributed Inventory Source External ID |
event.dv360_attributed_inventory_source_is_public | string DV360 Attributed Inventory Source Is Public |
event.dv360_auction_id | string DV360 Auction ID |
event.dv360_bid_price_advertiser_currency | int DV360 Bid Price (Advertiser Currency) |
event.dv360_bid_price_partner_currency | int DV360 Bid Price (Partner Currency) |
event.dv360_bid_price_usd | int DV360 Bid Price (USD) |
event.dv360_billable_cost_advertiser_currency | int DV360 Billable Cost (Advertiser Currency) |
event.dv360_billable_cost_partner_currency | int DV360 Billable Cost (Partner Currency) |
event.dv360_billable_cost_usd | int DV360 Billable Cost (USD) |
event.dv360_browser_id | int DV360 Browser/Platform ID |
event.dv360_browser_timezone_offset_minutes | int DV360 Browser Timezone Offset Minutes |
event.dv360_campaign_id | int DV360 Campaign ID |
event.dv360_city_id | int DV360 City ID |
event.dv360_country_code | string DV360 Country Code |
event.dv360_cpm_fee_1_advertiser_currency | int |
event.dv360_cpm_fee_1_partner_currency | int |
event.dv360_cpm_fee_1_usd | int |
event.dv360_cpm_fee_2_advertiser_currency | int |
event.dv360_cpm_fee_2_partner_currency | int |
event.dv360_cpm_fee_2_usd | int |
event.dv360_cpm_fee_3_advertiser_currency | int |
event.dv360_cpm_fee_3_partner_currency | int |
event.dv360_cpm_fee_3_usd | int |
event.dv360_cpm_fee_4_advertiser_currency | int |
event.dv360_cpm_fee_4_partner_currency | int |
event.dv360_cpm_fee_4_usd | int |
event.dv360_cpm_fee_5_advertiser_currency | int |
event.dv360_cpm_fee_5_partner_currency | int |
event.dv360_cpm_fee_5_usd | int |
event.dv360_creative_id | int DV360 Creative ID |
event.dv360_data_fees_advertiser_currency | int |
event.dv360_data_fees_partner_currency | int |
event.dv360_data_fees_usd | int |
event.dv360_device_type | int DV360 Device Type |
event.dv360_exchange_id | string DV360 Exchange ID |
event.dv360_insertion_order_id | int DV360 Insertion Order ID |
event.dv360_isp_id | int DV360 ISP ID |
event.dv360_language | string DV360 Language |
event.dv360_line_item_id | int DV360 Line Item ID |
event.dv360_matching_targeted_keywords | string DV360 Matching Targeted Keywords |
event.dv360_matching_targeted_segments | string DV360 Matching Targeted Segments |
event.dv360_media_cost_advertiser_currency | int DV360 Media Cost (Advertiser Currency) |
event.dv360_media_cost_partner_currency | int DV360 Media Cost (Partner Currency) |
event.dv360_media_cost_usd | int DV360 Media Cost (USD) |
event.dv360_media_fee_1_advertiser_currency | int |
event.dv360_media_fee_1_partner_currency | int |
event.dv360_media_fee_1_usd | int |
event.dv360_media_fee_2_advertiser_currency | int |
event.dv360_media_fee_2_partner_currency | int |
event.dv360_media_fee_2_usd | int |
event.dv360_media_fee_3_advertiser_currency | int |
event.dv360_media_fee_3_partner_currency | int |
event.dv360_media_fee_3_usd | int |
event.dv360_media_fee_4_advertiser_currency | int |
event.dv360_media_fee_4_partner_currency | int |
event.dv360_media_fee_4_usd | int |
event.dv360_media_fee_5_advertiser_currency | int |
event.dv360_media_fee_5_partner_currency | int |
event.dv360_media_fee_5_usd | int |
event.dv360_mobile_make_id | int DV360 Mobile Make ID |
event.dv360_mobile_model_id | int DV360 Mobile Model ID |
event.dv360_net_speed | int DV360 Net Speed |
event.dv360_operating_system_id | int |
event.dv360_request_time | int DV360 Request Time |
event.dv360_revenue_advertiser_currency | int DV360 Revenue (Advertiser Currency) |
event.dv360_revenue_partner_currency | int DV360 Revenue (Partner Currency) |
event.dv360_revenue_usd | int DV360 Revenue (USD) |
event.dv360_site_id | int DV360 Site ID |
event.dv360_state_region_id | int DV360 Region ID |
event.dv360_url | string DV360 URL |
event.dv360_view_state | string DV360 View State |
event.dv360_zip_postal_code | string DV360 ZIP/Postal Code |
event.event_sub_type | string Event Sub-Type |
event.event_time | int Event Time |
event.event_type | string Event Type |
event.floodlight_config_id | int Floodlight Configuration |
event.impression_id | string Impression ID |
event.interaction_time_utc_seconds | string Interaction Time |
event.landing_page_url_id | int Landing Page URL ID |
event.operating_system_id | int Operating System ID |
event.ord_value | string ORD Value |
event.other_data | string Other Data |
event.placement_id | int Placement ID |
event.platform_type_id | int |
event.referrer_url | string Referrer URL |
event.rendering_id | int Rendering ID |
event.rich_media_event_counters | int Event Counters |
event.rich_media_event_id | int Rich Media Event ID |
event.rich_media_event_timers | double Event Timers |
event.rich_media_event_type_id | int Rich Media Event Type ID |
event.segment_value_1 | int Segment Value 1 |
event.site_id | int Site ID (Campaign Manager) |
event.state | string State/Region |
event.tran_value | string TRAN Value |
event.u_value | string U Value |
event.zip_code | string Zip Code |
is_in_rdid_project | boolean True if this event is also in the _rdid table. Used for deduplication of events. |
network_id | int The network ID. |
user_id | string User ID |
Campaign Manager Data Transfer floodlight
cm_dt_floodlight | |
---|---|
device_id_md5 | string MD5-hashed device ID. Utility will be provided to hash raw device IDs to match. |
event | struct |
event.active_view_audible_impressions | int Active View: Impressions Audible |
event.active_view_audible_time_msec | int Active View: Play Time Audible (Seconds) |
event.active_view_audible_visible_time_msec | int Active View: Play Time Audible and Visible (Seconds) |
event.active_view_background_count | int Active View: Impressions In Background |
event.active_view_complete_viewable_impressions | int Active View: Impressions Visible at Completion |
event.active_view_eligible_impressions | int Active View: Eligible Impressions |
event.active_view_first_quartile_viewable_audible_impressions | int Active View: Impressions Visible and Audible at First Quartile |
event.active_view_first_quartile_viewable_impressions | int Active View: Impressions Visible at First Quartile |
event.active_view_fullscreen_count | int Active View: Impressions Full-Screen |
event.active_view_impressions_audible_and_visible_at_completion | int Active View: Impressions Audible and Visible at Completion |
event.active_view_impressions_visible10_seconds | int Active View: Impressions Visible 10 Seconds |
event.active_view_measurable_impressions | int Active View: Measurable Impressions |
event.active_view_midpoint_viewable_audible_impressions | int Active View: Impressions Visible and Audible at Midpoint |
event.active_view_midpoint_viewable_impressions | int Active View: Impressions Visible at Midpoint |
event.active_view_plus_measurable_count | int Active View Plus: Measurable Impressions |
event.active_view_start_viewable_audible_impressions | int Active View: Impressions Visible and Audible at Start |
event.active_view_start_viewable_impressions | int Active View: Impressions Visible at Start |
event.active_view_third_quartile_viewable_audible_impressions | int Active View: Impressions Visible and Audible at Third Quartile |
event.active_view_third_quartile_viewable_impressions | int Active View: Impressions Visible at Third Quartile |
event.active_view_tos_msec | int Active View: Time on Screen (Seconds) |
event.active_view_viewable_impressions | int Active View: Viewable Impressions |
event.active_view_visible_time_msec | int Active View: Video Visible Time (Seconds) |
event.activity_count | int Activity Quantity |
event.activity_id | int Activity ID |
event.activity_revenue | double Activity Revenue |
event.ad_id | int Ad ID |
event.advertiser_id | int Advertiser ID |
event.audience_segment_id | int |
event.browser_platform_id | string Browser/Platform ID |
event.browser_version | string Browser/Platform Version |
event.campaign_id | int Campaign ID |
event.city_id | int City ID |
event.conversion_id | int Conversion ID |
event.country_code | string Country |
event.creative_version | string Creative Version |
event.dma_region_id | int Designated Market Area (DMA) ID |
event.dv360_ad_position | int DV360 Ad Position |
event.dv360_advertiser_id | int DV360 Advertiser ID |
event.dv360_adx_page_categories | string DV360 Adx Page Categories |
event.dv360_attributed_inventory_source_external_id | string DV360 Attributed Inventory Source External ID |
event.dv360_attributed_inventory_source_is_public | string DV360 Attributed Inventory Source Is Public |
event.dv360_auction_id | string DV360 Auction ID |
event.dv360_bid_price_advertiser_currency | int DV360 Bid Price (Advertiser Currency) |
event.dv360_bid_price_partner_currency | int DV360 Bid Price (Partner Currency) |
event.dv360_bid_price_usd | int DV360 Bid Price (USD) |
event.dv360_billable_cost_advertiser_currency | int DV360 Billable Cost (Advertiser Currency) |
event.dv360_billable_cost_partner_currency | int DV360 Billable Cost (Partner Currency) |
event.dv360_billable_cost_usd | int DV360 Billable Cost (USD) |
event.dv360_browser_id | int DV360 Browser/Platform ID |
event.dv360_browser_timezone_offset_minutes | int DV360 Browser Timezone Offset Minutes |
event.dv360_campaign_id | int DV360 Campaign ID |
event.dv360_city_id | int DV360 City ID |
event.dv360_country_code | string DV360 Country Code |
event.dv360_cpm_fee_1_advertiser_currency | int |
event.dv360_cpm_fee_1_partner_currency | int |
event.dv360_cpm_fee_1_usd | int |
event.dv360_cpm_fee_2_advertiser_currency | int |
event.dv360_cpm_fee_2_partner_currency | int |
event.dv360_cpm_fee_2_usd | int |
event.dv360_cpm_fee_3_advertiser_currency | int |
event.dv360_cpm_fee_3_partner_currency | int |
event.dv360_cpm_fee_3_usd | int |
event.dv360_cpm_fee_4_advertiser_currency | int |
event.dv360_cpm_fee_4_partner_currency | int |
event.dv360_cpm_fee_4_usd | int |
event.dv360_cpm_fee_5_advertiser_currency | int |
event.dv360_cpm_fee_5_partner_currency | int |
event.dv360_cpm_fee_5_usd | int |
event.dv360_creative_id | int DV360 Creative ID |
event.dv360_data_fees_advertiser_currency | int |
event.dv360_data_fees_partner_currency | int |
event.dv360_data_fees_usd | int |
event.dv360_device_type | int DV360 Device Type |
event.dv360_exchange_id | string DV360 Exchange ID |
event.dv360_insertion_order_id | int DV360 Insertion Order ID |
event.dv360_isp_id | int DV360 ISP ID |
event.dv360_language | string DV360 Language |
event.dv360_line_item_id | int DV360 Line Item ID |
event.dv360_matching_targeted_keywords | string DV360 Matching Targeted Keywords |
event.dv360_matching_targeted_segments | string DV360 Matching Targeted Segments |
event.dv360_media_cost_advertiser_currency | int DV360 Media Cost (Advertiser Currency) |
event.dv360_media_cost_partner_currency | int DV360 Media Cost (Partner Currency) |
event.dv360_media_cost_usd | int DV360 Media Cost (USD) |
event.dv360_media_fee_1_advertiser_currency | int |
event.dv360_media_fee_1_partner_currency | int |
event.dv360_media_fee_1_usd | int |
event.dv360_media_fee_2_advertiser_currency | int |
event.dv360_media_fee_2_partner_currency | int |
event.dv360_media_fee_2_usd | int |
event.dv360_media_fee_3_advertiser_currency | int |
event.dv360_media_fee_3_partner_currency | int |
event.dv360_media_fee_3_usd | int |
event.dv360_media_fee_4_advertiser_currency | int |
event.dv360_media_fee_4_partner_currency | int |
event.dv360_media_fee_4_usd | int |
event.dv360_media_fee_5_advertiser_currency | int |
event.dv360_media_fee_5_partner_currency | int |
event.dv360_media_fee_5_usd | int |
event.dv360_mobile_make_id | int DV360 Mobile Make ID |
event.dv360_mobile_model_id | int DV360 Mobile Model ID |
event.dv360_net_speed | int DV360 Net Speed |
event.dv360_operating_system_id | int |
event.dv360_request_time | int DV360 Request Time |
event.dv360_revenue_advertiser_currency | int DV360 Revenue (Advertiser Currency) |
event.dv360_revenue_partner_currency | int DV360 Revenue (Partner Currency) |
event.dv360_revenue_usd | int DV360 Revenue (USD) |
event.dv360_site_id | int DV360 Site ID |
event.dv360_state_region_id | int DV360 Region ID |
event.dv360_url | string DV360 URL |
event.dv360_view_state | string DV360 View State |
event.dv360_zip_postal_code | string DV360 ZIP/Postal Code |
event.event_sub_type | string Event Sub-Type |
event.event_time | int Event Time |
event.event_type | string Event Type |
event.floodlight_config_id | int Floodlight Configuration |
event.impression_id | string Impression ID |
event.interaction_time_utc_seconds | string Interaction Time |
event.landing_page_url_id | int Landing Page URL ID |
event.operating_system_id | int Operating System ID |
event.ord_value | string ORD Value |
event.other_data | string Other Data |
event.placement_id | int Placement ID |
event.platform_type_id | int |
event.referrer_url | string Referrer URL |
event.rendering_id | int Rendering ID |
event.rich_media_event_counters | int Event Counters |
event.rich_media_event_id | int Rich Media Event ID |
event.rich_media_event_timers | double Event Timers |
event.rich_media_event_type_id | int Rich Media Event Type ID |
event.segment_value_1 | int Segment Value 1 |
event.site_id | int Site ID (Campaign Manager) |
event.state | string State/Region |
event.tran_value | string TRAN Value |
event.u_value | string U Value |
event.zip_code | string Zip Code |
is_in_rdid_project | boolean True if this event is also in the _rdid table. Used for deduplication of events. |
network_id | int The network ID. |
user_id | string User ID |
Campaign Manager Data Transfer impressions
cm_dt_impressions | |
---|---|
device_id_md5 | string MD5-hashed device ID. Utility will be provided to hash raw device IDs to match. |
event | struct |
event.active_view_audible_impressions | int Active View: Impressions Audible |
event.active_view_audible_time_msec | int Active View: Play Time Audible (Seconds) |
event.active_view_audible_visible_time_msec | int Active View: Play Time Audible and Visible (Seconds) |
event.active_view_background_count | int Active View: Impressions In Background |
event.active_view_complete_viewable_impressions | int Active View: Impressions Visible at Completion |
event.active_view_eligible_impressions | int Active View: Eligible Impressions |
event.active_view_first_quartile_viewable_audible_impressions | int Active View: Impressions Visible and Audible at First Quartile |
event.active_view_first_quartile_viewable_impressions | int Active View: Impressions Visible at First Quartile |
event.active_view_fullscreen_count | int Active View: Impressions Full-Screen |
event.active_view_impressions_audible_and_visible_at_completion | int Active View: Impressions Audible and Visible at Completion |
event.active_view_impressions_visible10_seconds | int Active View: Impressions Visible 10 Seconds |
event.active_view_measurable_impressions | int Active View: Measurable Impressions |
event.active_view_midpoint_viewable_audible_impressions | int Active View: Impressions Visible and Audible at Midpoint |
event.active_view_midpoint_viewable_impressions | int Active View: Impressions Visible at Midpoint |
event.active_view_plus_measurable_count | int Active View Plus: Measurable Impressions |
event.active_view_start_viewable_audible_impressions | int Active View: Impressions Visible and Audible at Start |
event.active_view_start_viewable_impressions | int Active View: Impressions Visible at Start |
event.active_view_third_quartile_viewable_audible_impressions | int Active View: Impressions Visible and Audible at Third Quartile |
event.active_view_third_quartile_viewable_impressions | int Active View: Impressions Visible at Third Quartile |
event.active_view_tos_msec | int Active View: Time on Screen (Seconds) |
event.active_view_viewable_impressions | int Active View: Viewable Impressions |
event.active_view_visible_time_msec | int Active View: Video Visible Time (Seconds) |
event.activity_count | int Activity Quantity |
event.activity_id | int Activity ID |
event.activity_revenue | double Activity Revenue |
event.ad_id | int Ad ID |
event.advertiser_id | int Advertiser ID |
event.audience_segment_id | int |
event.browser_platform_id | string Browser/Platform ID |
event.browser_version | string Browser/Platform Version |
event.campaign_id | int Campaign ID |
event.city_id | int City ID |
event.conversion_id | int Conversion ID |
event.country_code | string Country |
event.creative_version | string Creative Version |
event.dma_region_id | int Designated Market Area (DMA) ID |
event.dv360_ad_position | int DV360 Ad Position |
event.dv360_advertiser_id | int DV360 Advertiser ID |
event.dv360_adx_page_categories | string DV360 Adx Page Categories |
event.dv360_attributed_inventory_source_external_id | string DV360 Attributed Inventory Source External ID |
event.dv360_attributed_inventory_source_is_public | string DV360 Attributed Inventory Source Is Public |
event.dv360_auction_id | string DV360 Auction ID |
event.dv360_bid_price_advertiser_currency | int DV360 Bid Price (Advertiser Currency) |
event.dv360_bid_price_partner_currency | int DV360 Bid Price (Partner Currency) |
event.dv360_bid_price_usd | int DV360 Bid Price (USD) |
event.dv360_billable_cost_advertiser_currency | int DV360 Billable Cost (Advertiser Currency) |
event.dv360_billable_cost_partner_currency | int DV360 Billable Cost (Partner Currency) |
event.dv360_billable_cost_usd | int DV360 Billable Cost (USD) |
event.dv360_browser_id | int DV360 Browser/Platform ID |
event.dv360_browser_timezone_offset_minutes | int DV360 Browser Timezone Offset Minutes |
event.dv360_campaign_id | int DV360 Campaign ID |
event.dv360_city_id | int DV360 City ID |
event.dv360_country_code | string DV360 Country Code |
event.dv360_cpm_fee_1_advertiser_currency | int |
event.dv360_cpm_fee_1_partner_currency | int |
event.dv360_cpm_fee_1_usd | int |
event.dv360_cpm_fee_2_advertiser_currency | int |
event.dv360_cpm_fee_2_partner_currency | int |
event.dv360_cpm_fee_2_usd | int |
event.dv360_cpm_fee_3_advertiser_currency | int |
event.dv360_cpm_fee_3_partner_currency | int |
event.dv360_cpm_fee_3_usd | int |
event.dv360_cpm_fee_4_advertiser_currency | int |
event.dv360_cpm_fee_4_partner_currency | int |
event.dv360_cpm_fee_4_usd | int |
event.dv360_cpm_fee_5_advertiser_currency | int |
event.dv360_cpm_fee_5_partner_currency | int |
event.dv360_cpm_fee_5_usd | int |
event.dv360_creative_id | int DV360 Creative ID |
event.dv360_data_fees_advertiser_currency | int |
event.dv360_data_fees_partner_currency | int |
event.dv360_data_fees_usd | int |
event.dv360_device_type | int DV360 Device Type |
event.dv360_exchange_id | string DV360 Exchange ID |
event.dv360_insertion_order_id | int DV360 Insertion Order ID |
event.dv360_isp_id | int DV360 ISP ID |
event.dv360_language | string DV360 Language |
event.dv360_line_item_id | int DV360 Line Item ID |
event.dv360_matching_targeted_keywords | string DV360 Matching Targeted Keywords |
event.dv360_matching_targeted_segments | string DV360 Matching Targeted Segments |
event.dv360_media_cost_advertiser_currency | int DV360 Media Cost (Advertiser Currency) |
event.dv360_media_cost_partner_currency | int DV360 Media Cost (Partner Currency) |
event.dv360_media_cost_usd | int DV360 Media Cost (USD) |
event.dv360_media_fee_1_advertiser_currency | int |
event.dv360_media_fee_1_partner_currency | int |
event.dv360_media_fee_1_usd | int |
event.dv360_media_fee_2_advertiser_currency | int |
event.dv360_media_fee_2_partner_currency | int |
event.dv360_media_fee_2_usd | int |
event.dv360_media_fee_3_advertiser_currency | int |
event.dv360_media_fee_3_partner_currency | int |
event.dv360_media_fee_3_usd | int |
event.dv360_media_fee_4_advertiser_currency | int |
event.dv360_media_fee_4_partner_currency | int |
event.dv360_media_fee_4_usd | int |
event.dv360_media_fee_5_advertiser_currency | int |
event.dv360_media_fee_5_partner_currency | int |
event.dv360_media_fee_5_usd | int |
event.dv360_mobile_make_id | int DV360 Mobile Make ID |
event.dv360_mobile_model_id | int DV360 Mobile Model ID |
event.dv360_net_speed | int DV360 Net Speed |
event.dv360_operating_system_id | int |
event.dv360_request_time | int DV360 Request Time |
event.dv360_revenue_advertiser_currency | int DV360 Revenue (Advertiser Currency) |
event.dv360_revenue_partner_currency | int DV360 Revenue (Partner Currency) |
event.dv360_revenue_usd | int DV360 Revenue (USD) |
event.dv360_site_id | int DV360 Site ID |
event.dv360_state_region_id | int DV360 Region ID |
event.dv360_url | string DV360 URL |
event.dv360_view_state | string DV360 View State |
event.dv360_zip_postal_code | string DV360 ZIP/Postal Code |
event.event_sub_type | string Event Sub-Type |
event.event_time | int Event Time |
event.event_type | string Event Type |
event.floodlight_config_id | int Floodlight Configuration |
event.impression_id | string Impression ID |
event.interaction_time_utc_seconds | string Interaction Time |
event.landing_page_url_id | int Landing Page URL ID |
event.operating_system_id | int Operating System ID |
event.ord_value | string ORD Value |
event.other_data | string Other Data |
event.placement_id | int Placement ID |
event.platform_type_id | int |
event.referrer_url | string Referrer URL |
event.rendering_id | int Rendering ID |
event.rich_media_event_counters | int Event Counters |
event.rich_media_event_id | int Rich Media Event ID |
event.rich_media_event_timers | double Event Timers |
event.rich_media_event_type_id | int Rich Media Event Type ID |
event.segment_value_1 | int Segment Value 1 |
event.site_id | int Site ID (Campaign Manager) |
event.state | string State/Region |
event.tran_value | string TRAN Value |
event.u_value | string U Value |
event.zip_code | string Zip Code |
is_in_rdid_project | boolean True if this event is also in the _rdid table. Used for deduplication of events. |
network_id | int The network ID. |
user_id | string User ID |
Campaign Manager Data Transfer keyword value
cm_dt_keyword_value | |
---|---|
account_id | int Unique ID of the account. |
ad_id | int Unique ID of the ad. |
advertiser_id | int Unique ID of the advertiser. |
floodlight_config_id | int Unique ID of the floodlight configuration. |
keyword | string Targeted key/value pair. |
Campaign Manager Data Transfer landing page url
cm_dt_landing_page_url | |
---|---|
account_id | int Unique ID of the account. |
landing_page_url | string The URL a user was sent to when they clicked on an ad. |
landing_page_url_id | int Unique ID of the landing page URL. |
Campaign Manager Data Transfer operating system
cm_dt_operating_system | |
---|---|
operating_system | string |
operating_system_id | int Unique ID of OS just for Data Transfer. |
Campaign Manager Data Transfer paid search
cm_dt_paid_search | |
---|---|
ad_id | int Unique ID of the ad. |
advertiser_id | int Unique ID of the advertiser. |
campaign_id | int Unique ID of the campaign. |
floodlight_config_id | int Unique ID of the floodlight configuration. |
paid_search_ad_group | string User defined keyword group. |
paid_search_ad_group_id | int Unique ID of the keyword group. |
paid_search_ad_id | int Unique ID associated with a Search Ads 360 ad. |
paid_search_bid_strategy | string User defined keyword bid strategy. Returns a value of "(not set)" if empty. |
paid_search_bid_strategy_id | int ID of the keyword bid strategy. |
paid_search_campaign | string User defined name of campaign as entered into Search Ads 360. |
paid_search_campaign_id | int ID of the Search Ads 360 campaign. |
paid_search_keyword | string User defined keyword value as entered into Search Ads 360. |
paid_search_keyword_id | int Unique ID from Search Ads 360. Uses the “long” format |
paid_search_landing_page_url | string User defined landing page URL as entered into Search Ads 360. |
paid_search_legacy_keyword_id | int Unique ID from Search Ads 360. Uses the "short" format in which the leading 43* is removed. |
paid_search_match_type | string User selected |
Campaign Manager Data Transfer placement
cm_dt_placement | |
---|---|
account_id | int Unique ID of the account. |
activity_id | int Unique ID of the Floodlight activity. |
advertiser_id | int Unique ID of the advertiser. |
campaign_id | int Unique ID of the campaign. |
content_category | string User defined content category. |
content_category_id | int ID of content category. |
flighting_activated | boolean Indicates whether this is a flighted (billing) placement. |
floodlight_config_id | int Unique ID of the floodlight configuration. |
package_roadblock_id | int |
package_roadblock_type | string |
package_roadblock_type_id | int |
placement | string |
placement_cap_cost_option | int User entered cost capping amount. |
placement_cost_structure | string |
placement_end_date | int End date of the flight in 'YYYYMMDD' format. |
placement_id | int |
placement_start_date | int Start date of the flight in 'YYYYMMDD' format. |
placement_strategy | string User defined placement strategy. |
placement_strategy_id | int ID of the placement strategy. |
site_id | int Unique ID of the site. |
site_keyname | string |
Campaign Manager Data Transfer placement cost
cm_dt_placement_cost | |
---|---|
account_id | int Unique ID of the account. |
advertiser_id | int Unique ID of the advertiser. |
floodlight_config_id | int Unique ID of the floodlight configuration. |
placement_comments | string User entered placement pricing comments. |
placement_end_date | int End date of the flight in 'YYYYMMDD' format. |
placement_id | int Placement ID |
placement_rate | int Purchased rate expressed in nanos of the network's currency. 1 nano = 1 billionth. 1 nano USD = $0.000000001. |
placement_start_date | int Start date of the flight in 'YYYYMMDD' format. |
placement_total_booked_units | int The number of purchased units. |
Campaign Manager Data Transfer rich media
cm_dt_rich_media | |
---|---|
device_id_md5 | string MD5-hashed device ID; a utility may be provided to hash raw device IDs to match. |
event | struct |
event.active_view_audible_impressions | int Active View: Impressions Audible |
event.active_view_audible_time_msec | int Active View: Play Time Audible (Seconds) |
event.active_view_audible_visible_time_msec | int Active View: Play Time Audible and Visible (Seconds) |
event.active_view_background_count | int Active View: Impressions In Background |
event.active_view_complete_viewable_impressions | int Active View: Impressions Visible at Completion |
event.active_view_eligible_impressions | int Active View: Eligible Impressions |
event.active_view_first_quartile_viewable_audible_impressions | int Active View: Impressions Visible and Audible at First Quartile |
event.active_view_first_quartile_viewable_impressions | int Active View: Impressions Visible at First Quartile |
event.active_view_fullscreen_count | int Active View: Impressions Full-Screen |
event.active_view_impressions_audible_and_visible_at_completion | int Active View: Impressions Audible and Visible at Completion |
event.active_view_impressions_visible10_seconds | int Active View: Impressions Visible 10 Seconds |
event.active_view_measurable_impressions | int Active View: Measurable Impressions |
event.active_view_midpoint_viewable_audible_impressions | int Active View: Impressions Visible and Audible at Midpoint |
event.active_view_midpoint_viewable_impressions | int Active View: Impressions Visible at Midpoint |
event.active_view_plus_measurable_count | int Active View Plus: Measurable Impressions |
event.active_view_start_viewable_audible_impressions | int Active View: Impressions Visible and Audible at Start |
event.active_view_start_viewable_impressions | int Active View: Impressions Visible at Start |
event.active_view_third_quartile_viewable_audible_impressions | int Active View: Impressions Visible and Audible at Third Quartile |
event.active_view_third_quartile_viewable_impressions | int Active View: Impressions Visible at Third Quartile |
event.active_view_tos_msec | int Active View: Time on Screen (Seconds) |
event.active_view_viewable_impressions | int Active View: Viewable Impressions |
event.active_view_visible_time_msec | int Active View: Video Visible Time (Seconds) |
event.activity_count | int Activity Quantity |
event.activity_id | int Activity ID |
event.activity_revenue | double Activity Revenue |
event.ad_id | int Ad ID |
event.advertiser_id | int Advertiser ID |
event.audience_segment_id | int |
event.browser_platform_id | string Browser/Platform ID |
event.browser_version | string Browser/Platform Version |
event.campaign_id | int Campaign ID |
event.city_id | int City ID |
event.conversion_id | int Conversion ID |
event.country_code | string Country |
event.creative_version | string Creative Version |
event.dma_region_id | int Designated Market Area (DMA) ID |
event.dv360_ad_position | int DV360 Ad Position |
event.dv360_advertiser_id | int DV360 Advertiser ID |
event.dv360_adx_page_categories | string DV360 Adx Page Categories |
event.dv360_attributed_inventory_source_external_id | string DV360 Attributed Inventory Source External ID |
event.dv360_attributed_inventory_source_is_public | string DV360 Attributed Inventory Source Is Public |
event.dv360_auction_id | string DV360 Auction ID |
event.dv360_bid_price_advertiser_currency | int DV360 Bid Price (Advertiser Currency) |
event.dv360_bid_price_partner_currency | int DV360 Bid Price (Partner Currency) |
event.dv360_bid_price_usd | int DV360 Bid Price (USD) |
event.dv360_billable_cost_advertiser_currency | int DV360 Billable Cost (Advertiser Currency) |
event.dv360_billable_cost_partner_currency | int DV360 Billable Cost (Partner Currency) |
event.dv360_billable_cost_usd | int DV360 Billable Cost (USD) |
event.dv360_browser_id | int DV360 Browser/Platform ID |
event.dv360_browser_timezone_offset_minutes | int DV360 Browser Timezone Offset Minutes |
event.dv360_campaign_id | int DV360 Campaign ID |
event.dv360_city_id | int DV360 City ID |
event.dv360_country_code | string DV360 Country Code |
event.dv360_cpm_fee_1_advertiser_currency | int |
event.dv360_cpm_fee_1_partner_currency | int |
event.dv360_cpm_fee_1_usd | int |
event.dv360_cpm_fee_2_advertiser_currency | int |
event.dv360_cpm_fee_2_partner_currency | int |
event.dv360_cpm_fee_2_usd | int |
event.dv360_cpm_fee_3_advertiser_currency | int |
event.dv360_cpm_fee_3_partner_currency | int |
event.dv360_cpm_fee_3_usd | int |
event.dv360_cpm_fee_4_advertiser_currency | int |
event.dv360_cpm_fee_4_partner_currency | int |
event.dv360_cpm_fee_4_usd | int |
event.dv360_cpm_fee_5_advertiser_currency | int |
event.dv360_cpm_fee_5_partner_currency | int |
event.dv360_cpm_fee_5_usd | int |
event.dv360_creative_id | int DV360 Creative ID |
event.dv360_data_fees_advertiser_currency | int |
event.dv360_data_fees_partner_currency | int |
event.dv360_data_fees_usd | int |
event.dv360_device_type | int DV360 Device Type |
event.dv360_exchange_id | string DV360 Exchange ID |
event.dv360_insertion_order_id | int DV360 Insertion Order ID |
event.dv360_isp_id | int DV360 ISP ID |
event.dv360_language | string DV360 Language |
event.dv360_line_item_id | int DV360 Line Item ID |
event.dv360_matching_targeted_keywords | string DV360 Matching Targeted Keywords |
event.dv360_matching_targeted_segments | string DV360 Matching Targeted Segments |
event.dv360_media_cost_advertiser_currency | int DV360 Media Cost (Advertiser Currency) |
event.dv360_media_cost_partner_currency | int DV360 Media Cost (Partner Currency) |
event.dv360_media_cost_usd | int DV360 Media Cost (USD) |
event.dv360_media_fee_1_advertiser_currency | int |
event.dv360_media_fee_1_partner_currency | int |
event.dv360_media_fee_1_usd | int |
event.dv360_media_fee_2_advertiser_currency | int |
event.dv360_media_fee_2_partner_currency | int |
event.dv360_media_fee_2_usd | int |
event.dv360_media_fee_3_advertiser_currency | int |
event.dv360_media_fee_3_partner_currency | int |
event.dv360_media_fee_3_usd | int |
event.dv360_media_fee_4_advertiser_currency | int |
event.dv360_media_fee_4_partner_currency | int |
event.dv360_media_fee_4_usd | int |
event.dv360_media_fee_5_advertiser_currency | int |
event.dv360_media_fee_5_partner_currency | int |
event.dv360_media_fee_5_usd | int |
event.dv360_mobile_make_id | int DV360 Mobile Make ID |
event.dv360_mobile_model_id | int DV360 Mobile Model ID |
event.dv360_net_speed | int DV360 Net Speed |
event.dv360_operating_system_id | int |
event.dv360_request_time | int DV360 Request Time |
event.dv360_revenue_advertiser_currency | int DV360 Revenue (Advertiser Currency) |
event.dv360_revenue_partner_currency | int DV360 Revenue (Partner Currency) |
event.dv360_revenue_usd | int DV360 Revenue (USD) |
event.dv360_site_id | int DV360 Site ID |
event.dv360_state_region_id | int DV360 Region ID |
event.dv360_url | string DV360 URL |
event.dv360_view_state | string DV360 View State |
event.dv360_zip_postal_code | string DV360 ZIP/Postal Code |
event.event_sub_type | string Event Sub-Type |
event.event_time | int Event Time |
event.event_type | string Event Type |
event.floodlight_config_id | int Floodlight Configuration |
event.impression_id | string Impression ID |
event.interaction_time_utc_seconds | string Interaction Time |
event.landing_page_url_id | int Landing Page URL ID |
event.operating_system_id | int Operating System ID |
event.ord_value | string ORD Value |
event.other_data | string Other Data |
event.placement_id | int Placement ID |
event.platform_type_id | int |
event.referrer_url | string Referrer URL |
event.rendering_id | int Rendering ID |
event.rich_media_event_counters | int Event Counters |
event.rich_media_event_id | int Rich Media Event ID |
event.rich_media_event_timers | double Event Timers |
event.rich_media_event_type_id | int Rich Media Event Type ID |
event.segment_value_1 | int Segment Value 1 |
event.site_id | int Site ID (Campaign Manager) |
event.state | string State/Region |
event.tran_value | string TRAN Value |
event.u_value | string U Value |
event.zip_code | string Zip Code |
is_in_rdid_project | boolean True if this event is also in the _rdid table. Used for deduplication of events. |
network_id | int The network ID. |
user_id | string User ID |
Campaign Manager Data Transfer site
cm_dt_site | |
---|---|
account_id | int Unique ID of the account. |
site | string The name of the site. |
site_directory | string Global unique name for this site. |
site_directory_id | int Global unique ID for this site. |
site_id | int Unique ID of the site. |
Campaign Manager Data Transfer state
cm_dt_state | |
---|---|
region | string Abbreviated state/province name. |
region_full_name | string Region name in English. |
Campaign Manager paths
cm_paths | |
---|---|
cm_paths.user_id | string User ID. |
cm_paths.network_id | int The network ID. |
cm_paths.partner_id | int Unique ID of the partner. |
cm_paths.path | record Row containing event path for a given user. |
cm_paths.events | repeated struct |
cm_paths.events.event_time | int Event time |
cm_paths.events.advertiser_id | int Advertiser ID |
cm_paths.events.campaign_id | int Campaign ID |
cm_paths.events.ad_id | int Ad ID |
cm_paths.events.rendering_id | int Rendering ID |
cm_paths.events.creative_version | string Creative version |
cm_paths.events.site_id | int Site ID |
cm_paths.events.country_code | string Country code |
cm_paths.events.state | string State |
cm_paths.events.browser_platform_id | string Browser platform ID |
cm_paths.events.browser_version | string Browser version |
cm_paths.events.dma_region_id | int DMA region ID |
cm_paths.events.city_id | int City ID |
cm_paths.events.zip_code | string Zip code |
cm_paths.events.u_value | string U value |
cm_paths.events.event_type | string Event type |
cm_paths.events.event_sub_type | string Event sub type |
cm_paths.events.dv360_auction_id | string DV360 auction ID |
cm_paths.events.dv360_request_time | int DV360 request time |
cm_paths.events.dv360_advertiser_id | int DV360 advertiser ID |
cm_paths.events.dv360_insertion_order_id | int DV360 insertion order ID |
cm_paths.events.dv360_line_item_id | int DV360 line item ID |
cm_paths.events.dv360_creative_id | int DV360 creative ID |
cm_paths.events.dv360_bid_price_usd | int DV360 bid price usd |
cm_paths.events.dv360_bid_price_partner_currency | int DV360 bid price partner currency |
cm_paths.events.dv360_bid_price_advertiser_currency | int DV360 bid price advertiser currency |
cm_paths.events.dv360_url | string DV360 url |
cm_paths.events.dv360_site_id | int DV360 site ID |
cm_paths.events.dv360_language | string DV360 language |
cm_paths.events.dv360_adx_page_categories | string DV360 Ad Exchange page categories |
cm_paths.events.dv360_matching_targeted_keywords | string DV360 matching targeted keywords |
cm_paths.events.dv360_exchange_id | string DV360 exchange ID |
cm_paths.events.dv360_attributed_inventory_source_external_id | string DV360 attributed inventory source external ID |
cm_paths.events.dv360_attributed_inventory_source_is_public | string DV360 attributed inventory source is public |
cm_paths.events.dv360_ad_position | int DV360 ad position |
cm_paths.events.dv360_country_code | string DV360 country code |
cm_paths.events.dv360_zip_postal_code | string DV360 zip postal code |
cm_paths.events.dv360_browser_timezone_offset_minutes | int DV360 browser timezone offset minutes |
cm_paths.events.dv360_net_speed | int DV360 net speed |
cm_paths.events.dv360_matching_targeted_segments | string DV360 matching targeted segments |
cm_paths.events.dv360_isp_id | int DV360 isp ID |
cm_paths.events.dv360_device_type | int DV360 device type |
cm_paths.events.dv360_mobile_model_id | int DV360 mobile model ID |
cm_paths.events.placement_id | int Placement ID |
cm_paths.events.operating_system_id | int Operating system ID |
cm_paths.events.segment_value_1 | int Segment value 1 |
cm_paths.events.dv360_state_region_id | int DV360 state region ID |
cm_paths.events.dv360_city_id | int DV360 city ID |
cm_paths.events.dv360_browser_id | int DV360 browser ID |
cm_paths.events.activity_id | int Activity ID |
cm_paths.events.ord_value | string Ord value |
cm_paths.events.conversion_id | int Conversion ID |
cm_paths.events.floodlight_config_id | int Floodlight configuration ID |
cm_paths.events.interaction_time_utc_seconds | string Interaction time utc seconds |
cm_paths.events.rich_media_event_id | int Rich media event ID |
cm_paths.events.rich_media_event_type_id | int Rich media event type ID |
cm_paths.events.impression_id | string Impression ID |
cm_paths.events.other_data | string Other data |
cm_paths.events.referrer_url | string Referrer url |
cm_paths.events.tran_value | string Tran value |
cm_paths.events.dv360_view_state | string DV360 view state |
cm_paths.events.landing_page_url_id | int Landing page url ID |
cm_paths.events.audience_segment_id | int Audience segment ID |
cm_paths.events.dv360_media_cost_usd | int DV360 media cost usd |
cm_paths.events.dv360_media_cost_partner_currency | int DV360 media cost partner currency |
cm_paths.events.dv360_media_cost_advertiser_currency | int DV360 media cost advertiser currency |
cm_paths.events.dv360_revenue_usd | int DV360 revenue usd |
cm_paths.events.dv360_revenue_partner_currency | int DV360 revenue partner currency |
cm_paths.events.dv360_revenue_advertiser_currency | int DV360 revenue advertiser currency |
cm_paths.events.dv360_cpm_fee_1_usd | int DV360 CPM fee 1 usd |
cm_paths.events.dv360_cpm_fee_1_partner_currency | int DV360 CPM fee 1 partner currency |
cm_paths.events.dv360_cpm_fee_1_advertiser_currency | int DV360 CPM fee 1 advertiser currency |
cm_paths.events.dv360_cpm_fee_2_usd | int DV360 CPM fee 2 usd |
cm_paths.events.dv360_cpm_fee_2_partner_currency | int DV360 CPM fee 2 partner currency |
cm_paths.events.dv360_cpm_fee_2_advertiser_currency | int DV360 CPM fee 2 advertiser currency |
cm_paths.events.dv360_cpm_fee_3_usd | int DV360 CPM fee 3 usd |
cm_paths.events.dv360_cpm_fee_3_partner_currency | int DV360 CPM fee 3 partner currency |
cm_paths.events.dv360_cpm_fee_3_advertiser_currency | int DV360 CPM fee 3 advertiser currency |
cm_paths.events.dv360_cpm_fee_4_usd | int DV360 CPM fee 4 usd |
cm_paths.events.dv360_cpm_fee_4_partner_currency | int DV360 CPM fee 4 partner currency |
cm_paths.events.dv360_cpm_fee_4_advertiser_currency | int DV360 CPM fee 4 advertiser currency |
cm_paths.events.dv360_cpm_fee_5_usd | int DV360 CPM fee 5 usd |
cm_paths.events.dv360_cpm_fee_5_partner_currency | int DV360 CPM fee 5 partner currency |
cm_paths.events.dv360_cpm_fee_5_advertiser_currency | int DV360 CPM fee 5 advertiser currency |
cm_paths.events.dv360_media_fee_1_usd | int DV360 media fee 1 usd |
cm_paths.events.dv360_media_fee_1_partner_currency | int DV360 media fee 1 partner currency |
cm_paths.events.dv360_media_fee_1_advertiser_currency | int DV360 media fee 1 advertiser currency |
cm_paths.events.dv360_media_fee_2_usd | int DV360 media fee 2 usd |
cm_paths.events.dv360_media_fee_2_partner_currency | int DV360 media fee 2 partner currency |
cm_paths.events.dv360_media_fee_2_advertiser_currency | int DV360 media fee 2 advertiser currency |
cm_paths.events.dv360_media_fee_3_usd | int DV360 media fee 3 usd |
cm_paths.events.dv360_media_fee_3_partner_currency | int DV360 media fee 3 partner currency |
cm_paths.events.dv360_media_fee_3_advertiser_currency | int DV360 media fee 3 advertiser currency |
cm_paths.events.dv360_media_fee_4_usd | int DV360 media fee 4 usd |
cm_paths.events.dv360_media_fee_4_partner_currency | int DV360 media fee 4 partner currency |
cm_paths.events.dv360_media_fee_4_advertiser_currency | int DV360 media fee 4 advertiser currency |
cm_paths.events.dv360_media_fee_5_usd | int DV360 media fee 5 usd |
cm_paths.events.dv360_media_fee_5_partner_currency | int DV360 media fee 5 partner currency |
cm_paths.events.dv360_media_fee_5_advertiser_currency | int DV360 media fee 5 advertiser currency |
cm_paths.events.dv360_data_fees_usd | int DV360 data fees usd |
cm_paths.events.dv360_data_fees_partner_currency | int DV360 data fees partner currency |
cm_paths.events.dv360_data_fees_advertiser_currency | int DV360 data fees advertiser currency |
cm_paths.events.activity_count | int Activity count |
cm_paths.events.activity_revenue | double Activity revenue |
cm_paths.events.active_view_eligible_impressions | int Active View eligible impressions |
cm_paths.events.active_view_viewable_impressions | int Active View viewable impressions |
cm_paths.events.dv360_billable_cost_usd | int DV360 billable cost usd |
cm_paths.events.dv360_billable_cost_partner_currency | int DV360 billable cost partner currency |
cm_paths.events.dv360_billable_cost_advertiser_currency | int DV360 billable cost advertiser currency |
cm_paths.events.active_view_measurable_impressions | int Active View measurable impressions |
cm_paths.events.rich_media_event_counters | int Rich media event counters |
cm_paths.events.rich_media_event_timers | double Rich media event timers |
cm_paths.floodlight_config_id | int Floodlight configuration ID |
DV360 Data Transfer Active View plus
dv360_dt_active_view_plus | |
---|---|
device_id_md5 | string MD5-hashed device ID. Utility will be provided to hash raw device IDs to match. |
event | struct |
event.active_view_audible_impressions | int Active View: Impressions Audible |
event.active_view_audible_time_msec | int Active View: Play Time Audible (Seconds) |
event.active_view_audible_visible_time_msec | int Active View: Play Time Audible and Visible (Seconds) |
event.active_view_background_count | int Active View: Impressions In Background |
event.active_view_complete_viewable_impressions | int Active View: Impressions Visible at Completion |
event.active_view_eligible_impressions | int Active View: Eligible Impressions |
event.active_view_first_quartile_viewable_audible_impressions | int Active View: Impressions Visible and Audible at First Quartile |
event.active_view_first_quartile_viewable_impressions | int Active View: Impressions Visible at First Quartile |
event.active_view_fullscreen_count | int Active View: Impressions Full-Screen |
event.active_view_impressions_audible_and_visible_at_completion | int Active View: Impressions Audible and Visible at Completion |
event.active_view_impressions_visible10_seconds | int Active View: Impressions Visible 10 Seconds |
event.active_view_measurable_impressions | int Active View: Measurable Impressions |
event.active_view_midpoint_viewable_audible_impressions | int Active View: Impressions Visible and Audible at Midpoint |
event.active_view_midpoint_viewable_impressions | int Active View: Impressions Visible at Midpoint |
event.active_view_plus_measurable_count | int Active View Plus: Measurable Impressions |
event.active_view_start_viewable_audible_impressions | int Active View: Impressions Visible and Audible at Start |
event.active_view_start_viewable_impressions | int Active View: Impressions Visible at Start |
event.active_view_third_quartile_viewable_audible_impressions | int Active View: Impressions Visible and Audible at Third Quartile |
event.active_view_third_quartile_viewable_impressions | int Active View: Impressions Visible at Third Quartile |
event.active_view_tos_msec | int Active View: Time on Screen (Seconds) |
event.active_view_viewable_impressions | int Active View: Viewable Impressions |
event.active_view_visible_time_msec | int Active View: Video Visible Time (Seconds) |
event.activity_count | int Activity Quantity |
event.activity_id | int Activity ID |
event.activity_revenue | double Activity Revenue |
event.ad_id | int Ad ID |
event.advertiser_id | int Advertiser ID |
event.audience_segment_id | int |
event.browser_platform_id | string Browser/Platform ID |
event.browser_version | string Browser/Platform Version |
event.campaign_id | int Campaign ID |
event.city_id | int City ID |
event.conversion_id | int Conversion ID |
event.country_code | string Country |
event.creative_version | string Creative Version |
event.dma_region_id | int Designated Market Area (DMA) ID |
event.dv360_ad_position | int DV360 Ad Position |
event.dv360_advertiser_id | int DV360 Advertiser ID |
event.dv360_adx_page_categories | string DV360 Adx Page Categories |
event.dv360_attributed_inventory_source_external_id | string DV360 Attributed Inventory Source External ID |
event.dv360_attributed_inventory_source_is_public | string DV360 Attributed Inventory Source Is Public |
event.dv360_auction_id | string DV360 Auction ID |
event.dv360_bid_price_advertiser_currency | int DV360 Bid Price (Advertiser Currency) |
event.dv360_bid_price_partner_currency | int DV360 Bid Price (Partner Currency) |
event.dv360_bid_price_usd | int DV360 Bid Price (USD) |
event.dv360_billable_cost_advertiser_currency | int DV360 Billable Cost (Advertiser Currency) |
event.dv360_billable_cost_partner_currency | int DV360 Billable Cost (Partner Currency) |
event.dv360_billable_cost_usd | int DV360 Billable Cost (USD) |
event.dv360_browser_id | int DV360 Browser/Platform ID |
event.dv360_browser_timezone_offset_minutes | int DV360 Browser Timezone Offset Minutes |
event.dv360_campaign_id | int DV360 Campaign ID |
event.dv360_city_id | int DV360 City ID |
event.dv360_country_code | string DV360 Country Code |
event.dv360_cpm_fee_1_advertiser_currency | int |
event.dv360_cpm_fee_1_partner_currency | int |
event.dv360_cpm_fee_1_usd | int |
event.dv360_cpm_fee_2_advertiser_currency | int |
event.dv360_cpm_fee_2_partner_currency | int |
event.dv360_cpm_fee_2_usd | int |
event.dv360_cpm_fee_3_advertiser_currency | int |
event.dv360_cpm_fee_3_partner_currency | int |
event.dv360_cpm_fee_3_usd | int |
event.dv360_cpm_fee_4_advertiser_currency | int |
event.dv360_cpm_fee_4_partner_currency | int |
event.dv360_cpm_fee_4_usd | int |
event.dv360_cpm_fee_5_advertiser_currency | int |
event.dv360_cpm_fee_5_partner_currency | int |
event.dv360_cpm_fee_5_usd | int |
event.dv360_creative_id | int DV360 Creative ID |
event.dv360_data_fees_advertiser_currency | int |
event.dv360_data_fees_partner_currency | int |
event.dv360_data_fees_usd | int |
event.dv360_device_type | int DV360 Device Type |
event.dv360_exchange_id | string DV360 Exchange ID |
event.dv360_insertion_order_id | int DV360 Insertion Order ID |
event.dv360_isp_id | int DV360 ISP ID |
event.dv360_language | string DV360 Language |
event.dv360_line_item_id | int DV360 Line Item ID |
event.dv360_matching_targeted_keywords | string DV360 Matching Targeted Keywords |
event.dv360_matching_targeted_segments | string DV360 Matching Targeted Segments |
event.dv360_media_cost_advertiser_currency | int DV360 Media Cost (Advertiser Currency) |
event.dv360_media_cost_partner_currency | int DV360 Media Cost (Partner Currency) |
event.dv360_media_cost_usd | int DV360 Media Cost (USD) |
event.dv360_media_fee_1_advertiser_currency | int |
event.dv360_media_fee_1_partner_currency | int |
event.dv360_media_fee_1_usd | int |
event.dv360_media_fee_2_advertiser_currency | int |
event.dv360_media_fee_2_partner_currency | int |
event.dv360_media_fee_2_usd | int |
event.dv360_media_fee_3_advertiser_currency | int |
event.dv360_media_fee_3_partner_currency | int |
event.dv360_media_fee_3_usd | int |
event.dv360_media_fee_4_advertiser_currency | int |
event.dv360_media_fee_4_partner_currency | int |
event.dv360_media_fee_4_usd | int |
event.dv360_media_fee_5_advertiser_currency | int |
event.dv360_media_fee_5_partner_currency | int |
event.dv360_media_fee_5_usd | int |
event.dv360_mobile_make_id | int DV360 Mobile Make ID |
event.dv360_mobile_model_id | int DV360 Mobile Model ID |
event.dv360_net_speed | int DV360 Net Speed |
event.dv360_operating_system_id | int |
event.dv360_request_time | int DV360 Request Time |
event.dv360_revenue_advertiser_currency | int DV360 Revenue (Advertiser Currency) |
event.dv360_revenue_partner_currency | int DV360 Revenue (Partner Currency) |
event.dv360_revenue_usd | int DV360 Revenue (USD) |
event.dv360_site_id | int DV360 Site ID |
event.dv360_state_region_id | int DV360 Region ID |
event.dv360_url | string DV360 URL |
event.dv360_view_state | string DV360 View State |
event.dv360_zip_postal_code | string DV360 ZIP/Postal Code |
event.event_sub_type | string Event Sub-Type |
event.event_time | int Event Time |
event.event_type | string Event Type |
event.floodlight_config_id | int Floodlight Configuration |
event.impression_id | string Impression ID |
event.interaction_time_utc_seconds | string Interaction Time |
event.landing_page_url_id | int Landing Page URL ID |
event.operating_system_id | int Operating System ID |
event.ord_value | string ORD Value |
event.other_data | string Other Data |
event.placement_id | int Placement ID |
event.platform_type_id | int |
event.referrer_url | string Referrer URL |
event.rendering_id | int Rendering ID |
event.rich_media_event_counters | int Event Counters |
event.rich_media_event_id | int Rich Media Event ID |
event.rich_media_event_timers | double Event Timers |
event.rich_media_event_type_id | int Rich Media Event Type ID |
event.segment_value_1 | int Segment Value 1 |
event.site_id | int Site ID (Campaign Manager) |
event.state | string State/Region |
event.tran_value | string TRAN Value |
event.u_value | string U Value |
event.zip_code | string Zip Code |
is_in_rdid_project | boolean True if this event is also in the _rdid table. Used for deduplication of events. |
network_id | int The network ID. |
user_id | string User ID |
DV360 Data Transfer activities
dv360_dt_activities | |
---|---|
device_id_md5 | string MD5-hashed device ID. Utility will be provided to hash raw device IDs to match. |
event | struct |
event.active_view_audible_impressions | int Active View: Impressions Audible |
event.active_view_audible_time_msec | int Active View: Play Time Audible (Seconds) |
event.active_view_audible_visible_time_msec | int Active View: Play Time Audible and Visible (Seconds) |
event.active_view_background_count | int Active View: Impressions In Background |
event.active_view_complete_viewable_impressions | int Active View: Impressions Visible at Completion |
event.active_view_eligible_impressions | int Active View: Eligible Impressions |
event.active_view_first_quartile_viewable_audible_impressions | int Active View: Impressions Visible and Audible at First Quartile |
event.active_view_first_quartile_viewable_impressions | int Active View: Impressions Visible at First Quartile |
event.active_view_fullscreen_count | int Active View: Impressions Full-Screen |
event.active_view_impressions_audible_and_visible_at_completion | int Active View: Impressions Audible and Visible at Completion |
event.active_view_impressions_visible10_seconds | int Active View: Impressions Visible 10 Seconds |
event.active_view_measurable_impressions | int Active View: Measurable Impressions |
event.active_view_midpoint_viewable_audible_impressions | int Active View: Impressions Visible and Audible at Midpoint |
event.active_view_midpoint_viewable_impressions | int Active View: Impressions Visible at Midpoint |
event.active_view_plus_measurable_count | int Active View Plus: Measurable Impressions |
event.active_view_start_viewable_audible_impressions | int Active View: Impressions Visible and Audible at Start |
event.active_view_start_viewable_impressions | int Active View: Impressions Visible at Start |
event.active_view_third_quartile_viewable_audible_impressions | int Active View: Impressions Visible and Audible at Third Quartile |
event.active_view_third_quartile_viewable_impressions | int Active View: Impressions Visible at Third Quartile |
event.active_view_tos_msec | int Active View: Time on Screen (Seconds) |
event.active_view_viewable_impressions | int Active View: Viewable Impressions |
event.active_view_visible_time_msec | int Active View: Video Visible Time (Seconds) |
event.activity_count | int Activity Quantity |
event.activity_id | int Activity ID |
event.activity_revenue | double Activity Revenue |
event.ad_id | int Ad ID |
event.advertiser_id | int Advertiser ID |
event.audience_segment_id | int |
event.browser_platform_id | string Browser/Platform ID |
event.browser_version | string Browser/Platform Version |
event.campaign_id | int Campaign ID |
event.city_id | int City ID |
event.conversion_id | int Conversion ID |
event.country_code | string Country |
event.creative_version | string Creative Version |
event.dma_region_id | int Designated Market Area (DMA) ID |
event.dv360_ad_position | int DV360 Ad Position |
event.dv360_advertiser_id | int DV360 Advertiser ID |
event.dv360_adx_page_categories | string DV360 Adx Page Categories |
event.dv360_attributed_inventory_source_external_id | string DV360 Attributed Inventory Source External ID |
event.dv360_attributed_inventory_source_is_public | string DV360 Attributed Inventory Source Is Public |
event.dv360_auction_id | string DV360 Auction ID |
event.dv360_bid_price_advertiser_currency | int DV360 Bid Price (Advertiser Currency) |
event.dv360_bid_price_partner_currency | int DV360 Bid Price (Partner Currency) |
event.dv360_bid_price_usd | int DV360 Bid Price (USD) |
event.dv360_billable_cost_advertiser_currency | int DV360 Billable Cost (Advertiser Currency) |
event.dv360_billable_cost_partner_currency | int DV360 Billable Cost (Partner Currency) |
event.dv360_billable_cost_usd | int DV360 Billable Cost (USD) |
event.dv360_browser_id | int DV360 Browser/Platform ID |
event.dv360_browser_timezone_offset_minutes | int DV360 Browser Timezone Offset Minutes |
event.dv360_campaign_id | int DV360 Campaign ID |
event.dv360_city_id | int DV360 City ID |
event.dv360_country_code | string DV360 Country Code |
event.dv360_cpm_fee_1_advertiser_currency | int |
event.dv360_cpm_fee_1_partner_currency | int |
event.dv360_cpm_fee_1_usd | int |
event.dv360_cpm_fee_2_advertiser_currency | int |
event.dv360_cpm_fee_2_partner_currency | int |
event.dv360_cpm_fee_2_usd | int |
event.dv360_cpm_fee_3_advertiser_currency | int |
event.dv360_cpm_fee_3_partner_currency | int |
event.dv360_cpm_fee_3_usd | int |
event.dv360_cpm_fee_4_advertiser_currency | int |
event.dv360_cpm_fee_4_partner_currency | int |
event.dv360_cpm_fee_4_usd | int |
event.dv360_cpm_fee_5_advertiser_currency | int |
event.dv360_cpm_fee_5_partner_currency | int |
event.dv360_cpm_fee_5_usd | int |
event.dv360_creative_id | int DV360 Creative ID |
event.dv360_data_fees_advertiser_currency | int |
event.dv360_data_fees_partner_currency | int |
event.dv360_data_fees_usd | int |
event.dv360_device_type | int DV360 Device Type |
event.dv360_exchange_id | string DV360 Exchange ID |
event.dv360_insertion_order_id | int DV360 Insertion Order ID |
event.dv360_isp_id | int DV360 ISP ID |
event.dv360_language | string DV360 Language |
event.dv360_line_item_id | int DV360 Line Item ID |
event.dv360_matching_targeted_keywords | string DV360 Matching Targeted Keywords |
event.dv360_matching_targeted_segments | string DV360 Matching Targeted Segments |
event.dv360_media_cost_advertiser_currency | int DV360 Media Cost (Advertiser Currency) |
event.dv360_media_cost_partner_currency | int DV360 Media Cost (Partner Currency) |
event.dv360_media_cost_usd | int DV360 Media Cost (USD) |
event.dv360_media_fee_1_advertiser_currency | int |
event.dv360_media_fee_1_partner_currency | int |
event.dv360_media_fee_1_usd | int |
event.dv360_media_fee_2_advertiser_currency | int |
event.dv360_media_fee_2_partner_currency | int |
event.dv360_media_fee_2_usd | int |
event.dv360_media_fee_3_advertiser_currency | int |
event.dv360_media_fee_3_partner_currency | int |
event.dv360_media_fee_3_usd | int |
event.dv360_media_fee_4_advertiser_currency | int |
event.dv360_media_fee_4_partner_currency | int |
event.dv360_media_fee_4_usd | int |
event.dv360_media_fee_5_advertiser_currency | int |
event.dv360_media_fee_5_partner_currency | int |
event.dv360_media_fee_5_usd | int |
event.dv360_mobile_make_id | int DV360 Mobile Make ID |
event.dv360_mobile_model_id | int DV360 Mobile Model ID |
event.dv360_net_speed | int DV360 Net Speed |
event.dv360_operating_system_id | int |
event.dv360_request_time | int DV360 Request Time |
event.dv360_revenue_advertiser_currency | int DV360 Revenue (Advertiser Currency) |
event.dv360_revenue_partner_currency | int DV360 Revenue (Partner Currency) |
event.dv360_revenue_usd | int DV360 Revenue (USD) |
event.dv360_site_id | int DV360 Site ID |
event.dv360_state_region_id | int DV360 Region ID |
event.dv360_url | string DV360 URL |
event.dv360_view_state | string DV360 View State |
event.dv360_zip_postal_code | string DV360 ZIP/Postal Code |
event.event_sub_type | string Event Sub-Type |
event.event_time | int Event Time |
event.event_type | string Event Type |
event.floodlight_config_id | int Floodlight Configuration |
event.impression_id | string Impression ID |
event.interaction_time_utc_seconds | string Interaction Time |
event.landing_page_url_id | int Landing Page URL ID |
event.operating_system_id | int Operating System ID |
event.ord_value | string ORD Value |
event.other_data | string Other Data |
event.placement_id | int Placement ID |
event.platform_type_id | int |
event.referrer_url | string Referrer URL |
event.rendering_id | int Rendering ID |
event.rich_media_event_counters | int Event Counters |
event.rich_media_event_id | int Rich Media Event ID |
event.rich_media_event_timers | double Event Timers |
event.rich_media_event_type_id | int Rich Media Event Type ID |
event.segment_value_1 | int Segment Value 1 |
event.site_id | int Site ID (Campaign Manager) |
event.state | string State/Region |
event.tran_value | string TRAN Value |
event.u_value | string U Value |
event.zip_code | string Zip Code |
is_in_rdid_project | boolean True if this event is also in the _rdid table. Used for deduplication of events. |
network_id | int The network ID. |
user_id | string User ID |
DV360 Data Transfer advertiser
dv360_dt_advertiser | |
---|---|
dv360_advertiser | string Name of the advertiser. |
dv360_advertiser_id | int Unique ID of the advertiser. |
dv360_partner_id | int Unique ID of the partner. |
DV360 Data Transfer campaign
dv360_dt_campaign | |
---|---|
dv360_advertiser_id | int Unique ID of the advertiser. |
dv360_campaign | string Name of the campaign |
dv360_campaign_id | int Unique ID of the campaign. |
dv360_partner_id | int Unique ID of the partner. |
DV360 Data Transfer clicks
dv360_dt_clicks | |
---|---|
device_id_md5 | string MD5-hashed device ID. Utility will be provided to hash raw device IDs to match. |
event | struct |
event.active_view_audible_impressions | int Active View: Impressions Audible |
event.active_view_audible_time_msec | int Active View: Play Time Audible (Seconds) |
event.active_view_audible_visible_time_msec | int Active View: Play Time Audible and Visible (Seconds) |
event.active_view_background_count | int Active View: Impressions In Background |
event.active_view_complete_viewable_impressions | int Active View: Impressions Visible at Completion |
event.active_view_eligible_impressions | int Active View: Eligible Impressions |
event.active_view_first_quartile_viewable_audible_impressions | int Active View: Impressions Visible and Audible at First Quartile |
event.active_view_first_quartile_viewable_impressions | int Active View: Impressions Visible at First Quartile |
event.active_view_fullscreen_count | int Active View: Impressions Full-Screen |
event.active_view_impressions_audible_and_visible_at_completion | int Active View: Impressions Audible and Visible at Completion |
event.active_view_impressions_visible10_seconds | int Active View: Impressions Visible 10 Seconds |
event.active_view_measurable_impressions | int Active View: Measurable Impressions |
event.active_view_midpoint_viewable_audible_impressions | int Active View: Impressions Visible and Audible at Midpoint |
event.active_view_midpoint_viewable_impressions | int Active View: Impressions Visible at Midpoint |
event.active_view_plus_measurable_count | int Active View Plus: Measurable Impressions |
event.active_view_start_viewable_audible_impressions | int Active View: Impressions Visible and Audible at Start |
event.active_view_start_viewable_impressions | int Active View: Impressions Visible at Start |
event.active_view_third_quartile_viewable_audible_impressions | int Active View: Impressions Visible and Audible at Third Quartile |
event.active_view_third_quartile_viewable_impressions | int Active View: Impressions Visible at Third Quartile |
event.active_view_tos_msec | int Active View: Time on Screen (Seconds) |
event.active_view_viewable_impressions | int Active View: Viewable Impressions |
event.active_view_visible_time_msec | int Active View: Video Visible Time (Seconds) |
event.activity_count | int Activity Quantity |
event.activity_id | int Activity ID |
event.activity_revenue | double Activity Revenue |
event.ad_id | int Ad ID |
event.advertiser_id | int Advertiser ID |
event.audience_segment_id | int |
event.browser_platform_id | string Browser/Platform ID |
event.browser_version | string Browser/Platform Version |
event.campaign_id | int Campaign ID |
event.city_id | int City ID |
event.conversion_id | int Conversion ID |
event.country_code | string Country |
event.creative_version | string Creative Version |
event.dma_region_id | int Designated Market Area (DMA) ID |
event.dv360_ad_position | int DV360 Ad Position |
event.dv360_advertiser_id | int DV360 Advertiser ID |
event.dv360_adx_page_categories | string DV360 Adx Page Categories |
event.dv360_attributed_inventory_source_external_id | string DV360 Attributed Inventory Source External ID |
event.dv360_attributed_inventory_source_is_public | string DV360 Attributed Inventory Source Is Public |
event.dv360_auction_id | string DV360 Auction ID |
event.dv360_bid_price_advertiser_currency | int DV360 Bid Price (Advertiser Currency) |
event.dv360_bid_price_partner_currency | int DV360 Bid Price (Partner Currency) |
event.dv360_bid_price_usd | int DV360 Bid Price (USD) |
event.dv360_billable_cost_advertiser_currency | int DV360 Billable Cost (Advertiser Currency) |
event.dv360_billable_cost_partner_currency | int DV360 Billable Cost (Partner Currency) |
event.dv360_billable_cost_usd | int DV360 Billable Cost (USD) |
event.dv360_browser_id | int DV360 Browser/Platform ID |
event.dv360_browser_timezone_offset_minutes | int DV360 Browser Timezone Offset Minutes |
event.dv360_campaign_id | int DV360 Campaign ID |
event.dv360_city_id | int DV360 City ID |
event.dv360_country_code | string DV360 Country Code |
event.dv360_cpm_fee_1_advertiser_currency | int |
event.dv360_cpm_fee_1_partner_currency | int |
event.dv360_cpm_fee_1_usd | int |
event.dv360_cpm_fee_2_advertiser_currency | int |
event.dv360_cpm_fee_2_partner_currency | int |
event.dv360_cpm_fee_2_usd | int |
event.dv360_cpm_fee_3_advertiser_currency | int |
event.dv360_cpm_fee_3_partner_currency | int |
event.dv360_cpm_fee_3_usd | int |
event.dv360_cpm_fee_4_advertiser_currency | int |
event.dv360_cpm_fee_4_partner_currency | int |
event.dv360_cpm_fee_4_usd | int |
event.dv360_cpm_fee_5_advertiser_currency | int |
event.dv360_cpm_fee_5_partner_currency | int |
event.dv360_cpm_fee_5_usd | int |
event.dv360_creative_id | int DV360 Creative ID |
event.dv360_data_fees_advertiser_currency | int |
event.dv360_data_fees_partner_currency | int |
event.dv360_data_fees_usd | int |
event.dv360_device_type | int DV360 Device Type |
event.dv360_exchange_id | string DV360 Exchange ID |
event.dv360_insertion_order_id | int DV360 Insertion Order ID |
event.dv360_isp_id | int DV360 ISP ID |
event.dv360_language | string DV360 Language |
event.dv360_line_item_id | int DV360 Line Item ID |
event.dv360_matching_targeted_keywords | string DV360 Matching Targeted Keywords |
event.dv360_matching_targeted_segments | string DV360 Matching Targeted Segments |
event.dv360_media_cost_advertiser_currency | int DV360 Media Cost (Advertiser Currency) |
event.dv360_media_cost_partner_currency | int DV360 Media Cost (Partner Currency) |
event.dv360_media_cost_usd | int DV360 Media Cost (USD) |
event.dv360_media_fee_1_advertiser_currency | int |
event.dv360_media_fee_1_partner_currency | int |
event.dv360_media_fee_1_usd | int |
event.dv360_media_fee_2_advertiser_currency | int |
event.dv360_media_fee_2_partner_currency | int |
event.dv360_media_fee_2_usd | int |
event.dv360_media_fee_3_advertiser_currency | int |
event.dv360_media_fee_3_partner_currency | int |
event.dv360_media_fee_3_usd | int |
event.dv360_media_fee_4_advertiser_currency | int |
event.dv360_media_fee_4_partner_currency | int |
event.dv360_media_fee_4_usd | int |
event.dv360_media_fee_5_advertiser_currency | int |
event.dv360_media_fee_5_partner_currency | int |
event.dv360_media_fee_5_usd | int |
event.dv360_mobile_make_id | int DV360 Mobile Make ID |
event.dv360_mobile_model_id | int DV360 Mobile Model ID |
event.dv360_net_speed | int DV360 Net Speed |
event.dv360_operating_system_id | int |
event.dv360_request_time | int DV360 Request Time |
event.dv360_revenue_advertiser_currency | int DV360 Revenue (Advertiser Currency) |
event.dv360_revenue_partner_currency | int DV360 Revenue (Partner Currency) |
event.dv360_revenue_usd | int DV360 Revenue (USD) |
event.dv360_site_id | int DV360 Site ID |
event.dv360_state_region_id | int DV360 Region ID |
event.dv360_url | string DV360 URL |
event.dv360_view_state | string DV360 View State |
event.dv360_zip_postal_code | string DV360 ZIP/Postal Code |
event.event_sub_type | string Event Sub-Type |
event.event_time | int Event Time |
event.event_type | string Event Type |
event.floodlight_config_id | int Floodlight Configuration |
event.impression_id | string Impression ID |
event.interaction_time_utc_seconds | string Interaction Time |
event.landing_page_url_id | int Landing Page URL ID |
event.operating_system_id | int Operating System ID |
event.ord_value | string ORD Value |
event.other_data | string Other Data |
event.placement_id | int Placement ID |
event.platform_type_id | int |
event.referrer_url | string Referrer URL |
event.rendering_id | int Rendering ID |
event.rich_media_event_counters | int Event Counters |
event.rich_media_event_id | int Rich Media Event ID |
event.rich_media_event_timers | double Event Timers |
event.rich_media_event_type_id | int Rich Media Event Type ID |
event.segment_value_1 | int Segment Value 1 |
event.site_id | int Site ID (Campaign Manager) |
event.state | string State/Region |
event.tran_value | string TRAN Value |
event.u_value | string U Value |
event.zip_code | string Zip Code |
is_in_rdid_project | boolean True if this event is also in the _rdid table. Used for deduplication of events. |
network_id | int The network ID. |
user_id | string User ID |
DV360 Data Transfer impressions
dv360_dt_impressions | |
---|---|
device_id_md5 | string MD5-hashed device ID. Utility will be provided to hash raw device IDs to match. |
event | struct |
event.active_view_audible_impressions | int Active View: Impressions Audible |
event.active_view_audible_time_msec | int Active View: Play Time Audible (Seconds) |
event.active_view_audible_visible_time_msec | int Active View: Play Time Audible and Visible (Seconds) |
event.active_view_background_count | int Active View: Impressions In Background |
event.active_view_complete_viewable_impressions | int Active View: Impressions Visible at Completion |
event.active_view_eligible_impressions | int Active View: Eligible Impressions |
event.active_view_first_quartile_viewable_audible_impressions | int Active View: Impressions Visible and Audible at First Quartile |
event.active_view_first_quartile_viewable_impressions | int Active View: Impressions Visible at First Quartile |
event.active_view_fullscreen_count | int Active View: Impressions Full-Screen |
event.active_view_impressions_audible_and_visible_at_completion | int Active View: Impressions Audible and Visible at Completion |
event.active_view_impressions_visible10_seconds | int Active View: Impressions Visible 10 Seconds |
event.active_view_measurable_impressions | int Active View: Measurable Impressions |
event.active_view_midpoint_viewable_audible_impressions | int Active View: Impressions Visible and Audible at Midpoint |
event.active_view_midpoint_viewable_impressions | int Active View: Impressions Visible at Midpoint |
event.active_view_plus_measurable_count | int Active View Plus: Measurable Impressions |
event.active_view_start_viewable_audible_impressions | int Active View: Impressions Visible and Audible at Start |
event.active_view_start_viewable_impressions | int Active View: Impressions Visible at Start |
event.active_view_third_quartile_viewable_audible_impressions | int Active View: Impressions Visible and Audible at Third Quartile |
event.active_view_third_quartile_viewable_impressions | int Active View: Impressions Visible at Third Quartile |
event.active_view_tos_msec | int Active View: Time on Screen (Seconds) |
event.active_view_viewable_impressions | int Active View: Viewable Impressions |
event.active_view_visible_time_msec | int Active View: Video Visible Time (Seconds) |
event.activity_count | int Activity Quantity |
event.activity_id | int Activity ID |
event.activity_revenue | double Activity Revenue |
event.ad_id | int Ad ID |
event.advertiser_id | int Advertiser ID |
event.audience_segment_id | int |
event.browser_platform_id | string Browser/Platform ID |
event.browser_version | string Browser/Platform Version |
event.campaign_id | int Campaign ID |
event.city_id | int City ID |
event.conversion_id | int Conversion ID |
event.country_code | string Country |
event.creative_version | string Creative Version |
event.dma_region_id | int Designated Market Area (DMA) ID |
event.dv360_ad_position | int DV360 Ad Position |
event.dv360_advertiser_id | int DV360 Advertiser ID |
event.dv360_adx_page_categories | string DV360 Adx Page Categories |
event.dv360_attributed_inventory_source_external_id | string DV360 Attributed Inventory Source External ID |
event.dv360_attributed_inventory_source_is_public | string DV360 Attributed Inventory Source Is Public |
event.dv360_auction_id | string DV360 Auction ID |
event.dv360_bid_price_advertiser_currency | int DV360 Bid Price (Advertiser Currency) |
event.dv360_bid_price_partner_currency | int DV360 Bid Price (Partner Currency) |
event.dv360_bid_price_usd | int DV360 Bid Price (USD) |
event.dv360_billable_cost_advertiser_currency | int DV360 Billable Cost (Advertiser Currency) |
event.dv360_billable_cost_partner_currency | int DV360 Billable Cost (Partner Currency) |
event.dv360_billable_cost_usd | int DV360 Billable Cost (USD) |
event.dv360_browser_id | int DV360 Browser/Platform ID |
event.dv360_browser_timezone_offset_minutes | int DV360 Browser Timezone Offset Minutes |
event.dv360_campaign_id | int DV360 Campaign ID |
event.dv360_city_id | int DV360 City ID |
event.dv360_country_code | string DV360 Country Code |
event.dv360_cpm_fee_1_advertiser_currency | int |
event.dv360_cpm_fee_1_partner_currency | int |
event.dv360_cpm_fee_1_usd | int |
event.dv360_cpm_fee_2_advertiser_currency | int |
event.dv360_cpm_fee_2_partner_currency | int |
event.dv360_cpm_fee_2_usd | int |
event.dv360_cpm_fee_3_advertiser_currency | int |
event.dv360_cpm_fee_3_partner_currency | int |
event.dv360_cpm_fee_3_usd | int |
event.dv360_cpm_fee_4_advertiser_currency | int |
event.dv360_cpm_fee_4_partner_currency | int |
event.dv360_cpm_fee_4_usd | int |
event.dv360_cpm_fee_5_advertiser_currency | int |
event.dv360_cpm_fee_5_partner_currency | int |
event.dv360_cpm_fee_5_usd | int |
event.dv360_creative_id | int DV360 Creative ID |
event.dv360_data_fees_advertiser_currency | int |
event.dv360_data_fees_partner_currency | int |
event.dv360_data_fees_usd | int |
event.dv360_device_type | int DV360 Device Type |
event.dv360_exchange_id | string DV360 Exchange ID |
event.dv360_insertion_order_id | int DV360 Insertion Order ID |
event.dv360_isp_id | int DV360 ISP ID |
event.dv360_language | string DV360 Language |
event.dv360_line_item_id | int DV360 Line Item ID |
event.dv360_matching_targeted_keywords | string DV360 Matching Targeted Keywords |
event.dv360_matching_targeted_segments | string DV360 Matching Targeted Segments |
event.dv360_media_cost_advertiser_currency | int DV360 Media Cost (Advertiser Currency) |
event.dv360_media_cost_partner_currency | int DV360 Media Cost (Partner Currency) |
event.dv360_media_cost_usd | int DV360 Media Cost (USD) |
event.dv360_media_fee_1_advertiser_currency | int |
event.dv360_media_fee_1_partner_currency | int |
event.dv360_media_fee_1_usd | int |
event.dv360_media_fee_2_advertiser_currency | int |
event.dv360_media_fee_2_partner_currency | int |
event.dv360_media_fee_2_usd | int |
event.dv360_media_fee_3_advertiser_currency | int |
event.dv360_media_fee_3_partner_currency | int |
event.dv360_media_fee_3_usd | int |
event.dv360_media_fee_4_advertiser_currency | int |
event.dv360_media_fee_4_partner_currency | int |
event.dv360_media_fee_4_usd | int |
event.dv360_media_fee_5_advertiser_currency | int |
event.dv360_media_fee_5_partner_currency | int |
event.dv360_media_fee_5_usd | int |
event.dv360_mobile_make_id | int DV360 Mobile Make ID |
event.dv360_mobile_model_id | int DV360 Mobile Model ID |
event.dv360_net_speed | int DV360 Net Speed |
event.dv360_operating_system_id | int |
event.dv360_request_time | int DV360 Request Time |
event.dv360_revenue_advertiser_currency | int DV360 Revenue (Advertiser Currency) |
event.dv360_revenue_partner_currency | int DV360 Revenue (Partner Currency) |
event.dv360_revenue_usd | int DV360 Revenue (USD) |
event.dv360_site_id | int DV360 Site ID |
event.dv360_state_region_id | int DV360 Region ID |
event.dv360_url | string DV360 URL |
event.dv360_view_state | string DV360 View State |
event.dv360_zip_postal_code | string DV360 ZIP/Postal Code |
event.event_sub_type | string Event Sub-Type |
event.event_time | int Event Time |
event.event_type | string Event Type |
event.floodlight_config_id | int Floodlight Configuration |
event.impression_id | string Impression ID |
event.interaction_time_utc_seconds | string Interaction Time |
event.landing_page_url_id | int Landing Page URL ID |
event.operating_system_id | int Operating System ID |
event.ord_value | string ORD Value |
event.other_data | string Other Data |
event.placement_id | int Placement ID |
event.platform_type_id | int |
event.referrer_url | string Referrer URL |
event.rendering_id | int Rendering ID |
event.rich_media_event_counters | int Event Counters |
event.rich_media_event_id | int Rich Media Event ID |
event.rich_media_event_timers | double Event Timers |
event.rich_media_event_type_id | int Rich Media Event Type ID |
event.segment_value_1 | int Segment Value 1 |
event.site_id | int Site ID (Campaign Manager) |
event.state | string State/Region |
event.tran_value | string TRAN Value |
event.u_value | string U Value |
event.zip_code | string Zip Code |
is_in_rdid_project | boolean True if this event is also in the _rdid table. Used for deduplication of events. |
network_id | int The network ID. |
user_id | string User ID |
DV360 Data Transfer insertion order
dv360_dt_insertion_order | |
---|---|
dv360_advertiser_id | int Unique ID of the advertiser. |
dv360_campaign_id | int Unique ID of the campaign. |
dv360_insertion_order | string Name of the insertion order. |
dv360_insertion_order_id | int Unique ID of the insertion order. |
dv360_partner_id | int Unique ID of the partner. |
DV360 Data Transfer line item
dv360_dt_line_item | |
---|---|
dv360_advertiser_id | int Unique ID of the advertiser. |
dv360_campaign_id | int Unique ID of the campaign. |
dv360_insertion_order_id | int Unique ID of the insertion order. |
dv360_line_item | string Name of the line item. |
dv360_line_item_id | int Unique ID of the line item. |
dv360_partner_id | int Unique ID of the partner. |
DV360 paths
dv360_paths | |
---|---|
dv360_paths.user_id | string User ID. |
dv360_paths.network_id | int The network ID. |
dv360_paths.partner_id | int Unique ID of the partner. |
dv360_paths.path | record Row containing event path for a given user. |
dv360_paths.events | repeated struct |
dv360_paths.events.event_time | int Event time |
dv360_paths.events.advertiser_id | int Advertiser ID |
dv360_paths.events.campaign_id | int Campaign ID |
dv360_paths.events.ad_id | int Ad ID |
dv360_paths.events.rendering_id | int Rendering ID |
dv360_paths.events.creative_version | string Creative version |
dv360_paths.events.site_id | int Site ID |
dv360_paths.events.country_code | string Country code |
dv360_paths.events.state | string State |
dv360_paths.events.browser_platform_id | string Browser platform ID |
dv360_paths.events.browser_version | string Browser version |
dv360_paths.events.dma_region_id | int DMA region ID |
dv360_paths.events.city_id | int City ID |
dv360_paths.events.zip_code | string Zip code |
dv360_paths.events.u_value | string U value |
dv360_paths.events.event_type | string Event type |
dv360_paths.events.event_sub_type | string Event sub type |
dv360_paths.events.dv360_auction_id | string DV360 auction ID |
dv360_paths.events.dv360_request_time | int DV360 request time |
dv360_paths.events.dv360_advertiser_id | int DV360 advertiser ID |
dv360_paths.events.dv360_insertion_order_id | int DV360 insertion order ID |
dv360_paths.events.dv360_line_item_id | int DV360 line item ID |
dv360_paths.events.dv360_creative_id | int DV360 creative ID |
dv360_paths.events.dv360_bid_price_usd | int DV360 bid price usd |
dv360_paths.events.dv360_bid_price_partner_currency | int DV360 bid price partner currency |
dv360_paths.events.dv360_bid_price_advertiser_currency | int DV360 bid price advertiser currency |
dv360_paths.events.dv360_url | string DV360 url |
dv360_paths.events.dv360_site_id | int DV360 site ID |
dv360_paths.events.dv360_language | string DV360 language |
dv360_paths.events.dv360_adx_page_categories | string DV360 Ad Exchange page categories |
dv360_paths.events.dv360_matching_targeted_keywords | string DV360 matching targeted keywords |
dv360_paths.events.dv360_exchange_id | string DV360 exchange ID |
dv360_paths.events.dv360_attributed_inventory_source_external_id | string DV360 attributed inventory source external ID |
dv360_paths.events.dv360_attributed_inventory_source_is_public | string DV360 attributed inventory source is public |
dv360_paths.events.dv360_ad_position | int DV360 ad position |
dv360_paths.events.dv360_country_code | string DV360 country code |
dv360_paths.events.dv360_zip_postal_code | string DV360 zip postal code |
dv360_paths.events.dv360_browser_timezone_offset_minutes | int DV360 browser timezone offset minutes |
dv360_paths.events.dv360_net_speed | int DV360 net speed |
dv360_paths.events.dv360_matching_targeted_segments | string DV360 matching targeted segments |
dv360_paths.events.dv360_isp_id | int DV360 isp ID |
dv360_paths.events.dv360_device_type | int DV360 device type |
dv360_paths.events.dv360_mobile_model_id | int DV360 mobile model ID |
dv360_paths.events.placement_id | int Placement ID |
dv360_paths.events.operating_system_id | int Operating system ID |
dv360_paths.events.segment_value_1 | int Segment value 1 |
dv360_paths.events.dv360_state_region_id | int DV360 state region ID |
dv360_paths.events.dv360_city_id | int DV360 city ID |
dv360_paths.events.dv360_browser_id | int DV360 browser ID |
dv360_paths.events.activity_id | int Activity ID |
dv360_paths.events.ord_value | string Ord value |
dv360_paths.events.conversion_id | int Conversion ID |
dv360_paths.events.floodlight_config_id | int Floodlight configuration ID |
dv360_paths.events.interaction_time_utc_seconds | string Interaction time utc seconds |
dv360_paths.events.rich_media_event_id | int Rich media event ID |
dv360_paths.events.rich_media_event_type_id | int Rich media event type ID |
dv360_paths.events.impression_id | string Impression ID |
dv360_paths.events.other_data | string Other data |
dv360_paths.events.referrer_url | string Referrer url |
dv360_paths.events.tran_value | string Tran value |
dv360_paths.events.dv360_view_state | string DV360 view state |
dv360_paths.events.landing_page_url_id | int Landing page url ID |
dv360_paths.events.audience_segment_id | int Audience segment ID |
dv360_paths.events.dv360_media_cost_usd | int DV360 media cost usd |
dv360_paths.events.dv360_media_cost_partner_currency | int DV360 media cost partner currency |
dv360_paths.events.dv360_media_cost_advertiser_currency | int DV360 media cost advertiser currency |
dv360_paths.events.dv360_revenue_usd | int DV360 revenue usd |
dv360_paths.events.dv360_revenue_partner_currency | int DV360 revenue partner currency |
dv360_paths.events.dv360_revenue_advertiser_currency | int DV360 revenue advertiser currency |
dv360_paths.events.dv360_cpm_fee_1_usd | int DV360 CPM fee 1 usd |
dv360_paths.events.dv360_cpm_fee_1_partner_currency | int DV360 CPM fee 1 partner currency |
dv360_paths.events.dv360_cpm_fee_1_advertiser_currency | int DV360 CPM fee 1 advertiser currency |
dv360_paths.events.dv360_cpm_fee_2_usd | int DV360 CPM fee 2 usd |
dv360_paths.events.dv360_cpm_fee_2_partner_currency | int DV360 CPM fee 2 partner currency |
dv360_paths.events.dv360_cpm_fee_2_advertiser_currency | int DV360 CPM fee 2 advertiser currency |
dv360_paths.events.dv360_cpm_fee_3_usd | int DV360 CPM fee 3 usd |
dv360_paths.events.dv360_cpm_fee_3_partner_currency | int DV360 CPM fee 3 partner currency |
dv360_paths.events.dv360_cpm_fee_3_advertiser_currency | int DV360 CPM fee 3 advertiser currency |
dv360_paths.events.dv360_cpm_fee_4_usd | int DV360 CPM fee 4 usd |
dv360_paths.events.dv360_cpm_fee_4_partner_currency | int DV360 CPM fee 4 partner currency |
dv360_paths.events.dv360_cpm_fee_4_advertiser_currency | int DV360 CPM fee 4 advertiser currency |
dv360_paths.events.dv360_cpm_fee_5_usd | int DV360 CPM fee 5 usd |
dv360_paths.events.dv360_cpm_fee_5_partner_currency | int DV360 CPM fee 5 partner currency |
dv360_paths.events.dv360_cpm_fee_5_advertiser_currency | int DV360 CPM fee 5 advertiser currency |
dv360_paths.events.dv360_media_fee_1_usd | int DV360 media fee 1 usd |
dv360_paths.events.dv360_media_fee_1_partner_currency | int DV360 media fee 1 partner currency |
dv360_paths.events.dv360_media_fee_1_advertiser_currency | int DV360 media fee 1 advertiser currency |
dv360_paths.events.dv360_media_fee_2_usd | int DV360 media fee 2 usd |
dv360_paths.events.dv360_media_fee_2_partner_currency | int DV360 media fee 2 partner currency |
dv360_paths.events.dv360_media_fee_2_advertiser_currency | int DV360 media fee 2 advertiser currency |
dv360_paths.events.dv360_media_fee_3_usd | int DV360 media fee 3 usd |
dv360_paths.events.dv360_media_fee_3_partner_currency | int DV360 media fee 3 partner currency |
dv360_paths.events.dv360_media_fee_3_advertiser_currency | int DV360 media fee 3 advertiser currency |
dv360_paths.events.dv360_media_fee_4_usd | int DV360 media fee 4 usd |
dv360_paths.events.dv360_media_fee_4_partner_currency | int DV360 media fee 4 partner currency |
dv360_paths.events.dv360_media_fee_4_advertiser_currency | int DV360 media fee 4 advertiser currency |
dv360_paths.events.dv360_media_fee_5_usd | int DV360 media fee 5 usd |
dv360_paths.events.dv360_media_fee_5_partner_currency | int DV360 media fee 5 partner currency |
dv360_paths.events.dv360_media_fee_5_advertiser_currency | int DV360 media fee 5 advertiser currency |
dv360_paths.events.dv360_data_fees_usd | int DV360 data fees usd |
dv360_paths.events.dv360_data_fees_partner_currency | int DV360 data fees partner currency |
dv360_paths.events.dv360_data_fees_advertiser_currency | int DV360 data fees advertiser currency |
dv360_paths.events.activity_count | int Activity count |
dv360_paths.events.activity_revenue | double Activity revenue |
dv360_paths.events.active_view_eligible_impressions | int Active View eligible impressions |
dv360_paths.events.active_view_viewable_impressions | int Active View viewable impressions |
dv360_paths.events.dv360_billable_cost_usd | int DV360 billable cost usd |
dv360_paths.events.dv360_billable_cost_partner_currency | int DV360 billable cost partner currency |
dv360_paths.events.dv360_billable_cost_advertiser_currency | int DV360 billable cost advertiser currency |
dv360_paths.events.active_view_measurable_impressions | int Active View measurable impressions |
dv360_paths.events.rich_media_event_counters | int Rich media event counters |
dv360_paths.events.rich_media_event_timers | double Rich media event timers |
dv360_paths.floodlight_config_id | int Floodlight configuration ID |
DV360 YouTube Active View
dv360_youtube_active_views | |
---|---|
num_active_view_viewable_impression | int 1 when impression is active view eligible; 0 when impression is not active view eligible. |
query_id | struct Unique identifier for query has multiple parts. Joins with query_id in any adh.dv360_youtube table. |
query_id.process_id | int The processing ID. |
query_id.server_ip | int The processing server. |
query_id.time_usec | int The query time in microseconds. |
view_id | struct Unique identifier for view_id has multiple parts. |
view_id.process_id | int Time in microseconds. |
view_id.server_ip | int The processing server. |
view_id.time_usec | int The processing process. |
partner_id | int Unique ID of the partner. |
advertiser_id | int Unique ID of the advertiser. |
campaign_id | int Unique ID of the campaign. |
insertion_order_id | int Unique ID of the insertion order. |
lineitem_id | int Unique ID of the line item. |
adgroup_id | int ID of DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table. |
creative_id | int Joins with creative_id in any adh.dv360_youtube table. |
DV360 YouTube ad group
dv360_youtube_adgroup | |
---|---|
adgroup_id | int ID of DV360 ad group. Joins with adgroup_id in any adh.dv360_youtube table. |
adgroup_name | string Ad group name. |
adgroup_status | string The ad group. Possible values are: "status", "paused", or "enabled". |
adgroup_type | string The ad group type. Possible values are: VIDEO_TRUE_VIEW_IN_STREAM, VIDEO_NON_SKIPPABLE_IN_STREAM, VIDEO_BUMPER, VIDEO_TRUE_VIEW_IN_DISPLAY. |
advertiser_id | int Unique ID of the advertiser. |
line_item_id | int Unique ID of the line item. |
partner_id | int Unique ID of the partner. |
campaign_id | int Unique ID of the campaign. |
insertion_order_id | int Unique ID of the insertion order. |
lineitem_id | int Unique ID of the line item. |
DV360 YouTube advertiser
dv360_youtube_advertiser | |
---|---|
advertiser_name | string Name of the advertiser. |
advertiser_id | int Unique ID of the advertiser. |
partner_id | int Unique ID of the partner. |
DV360 YouTube campaign
dv360_youtube_campaign | |
---|---|
advertiser_id | int Unique ID of the advertiser. |
campaign_name | string Name of the campaign |
campaign_id | int Unique ID of the campaign. |
partner_id | int Unique ID of the partner. |
DV360 YouTube clicks
dv360_youtube_clicks | |
---|---|
advertiser_click_cost_local_micros | double The advertiser's cost in local currency micros. |
advertiser_click_cost_usd | double The advertiser's click cost in dollars. |
click_id | struct Unique identifier for click has multiple parts. Joins with click_id in any adh.dv360_youtube table. |
click_id.process_id | int The processing process. |
click_id.server_ip | int The processing server. |
click_id.time_usec | int Time in microseconds. |
click_type | int The click type. |
is_in_rdid_project | boolean true if this event is also in the _rdid table. Used for deduplication of events. |
query_id | struct Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table. |
query_id.process_id | int The processing process. |
query_id.server_ip | int The processing server. |
query_id.time_usec | int Time in microseconds. |
user_id | string User ID |
partner_id | int Unique ID of the partner. |
advertiser_id | int Unique ID of the advertiser. |
campaign_id | int Unique ID of the campaign. |
insertion_order_id | int Unique ID of the insertion order. |
lineitem_id | int Unique ID of the line item. |
adgroup_id | int ID of DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table. |
creative_id | int Joins with creative_id in any adh.dv360_youtube table. |
DV360 YouTube conversions
dv360_youtube_conversions | |
---|---|
click_id | struct Unique identifier for click has multiple parts. Joins with click_id in any adh.yt table. |
click_id.process_id | int The processing process. |
click_id.server_ip | int The processing server. |
click_id.time_usec | int Time in microseconds. |
conversion_id | struct Unique identifier for conversion has multiple parts. |
conversion_id.process_id | int The processing process. |
conversion_id.server_ip | int The processing server. |
conversion_id.time_usec | int Time in microseconds. |
conversion_type | int The type of conversion. |
is_in_rdid_project | boolean true if this event is also in the _rdid table. Used for deduplication of events. |
label | string Name of conversion event. |
query_id | struct Unique identifier for query has multiple parts. Joins with query_id in any adh.yt table. |
query_id.process_id | int The processing process. |
query_id.server_ip | int The processing server. |
query_id.time_usec | int Time in microseconds. |
user_id | string User ID |
partner_id | int Unique ID of the partner. |
advertiser_id | int Unique ID of the advertiser. |
campaign_id | int Unique ID of the campaign. |
insertion_order_id | int Unique ID of the insertion order. |
lineitem_id | int Unique ID of the line item. |
adgroup_id | int ID of DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table. |
creative_id | int Joins with creative_id in any adh.dv360_youtube table. |
DV360 YouTube creative
dv360_youtube_creative | |
---|---|
partner_id | int Unique ID of the partner. |
advertiser_id | int Unique ID of the advertiser. |
campaign_id | int Unique ID of the campaign. |
insertion_order_id | int Unique ID of the insertion order. |
lineitem_id | int Unique ID of the line item. |
adgroup_id | int ID of DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table. |
creative_id | int Joins with creative_id in any adh.dv360_youtube table. |
creative_name | string Creative name. |
creative_type | int Creative type. |
video_message | struct Multipart identifier for video data. |
video_message.video_ad_duration | int Duration of the video in milliseconds. |
video_message.youtube_video_id | string Video id string representation as it appears on YouTube watch url. |
DV360 YouTube impressions
dv360_youtube_impressions | |
---|---|
active_view_data | int Whether the impression was enabled for active view measurement. |
advertiser_impression_cost_local_micros | double The advertiser's local currency in micros. |
advertiser_impression_cost_usd | double The advertiser's impression cost in dollars. |
affinity | array ID of affinity group. Joins with affinity_id in adh.affinity table. Does not support TrueView line items. |
campaign_id | int Unique ID of the campaign. |
content_url | string URL of the page on which ad appeared. Part of the url is removed for privacy. |
demographics | struct |
demographics.age_group | int Code for age group. Joins with age_group_id in adh.age_group table. |
demographics.gender | int Code for gender. Joins with gender_id in adh.gender table. |
device_height | int Device height in px. |
device_width | int Device width in px. |
in_market | array ID of in-market group. Joins with in_market_id in adh.in_market table. Does not support TrueView line items. |
is_in_rdid_project | boolean true if this event is also in the _rdid table. Used for deduplication of events. |
location | struct Unique identifier for location has multiple parts |
location.country | string |
location.geo_city_id | int Code for city. Joins with city_id in adh.city table. |
location.geo_metro | int Code for metro region. Joins with metro_id in adh.metro table. |
location.geo_region | string Region as string e.g. US-CA. |
mobile_browser_class | int Type of browser. Possible values are: desktop, tablet, smart tv consoles, or mobile. Joins with mobile_browser_class_id in adh.mobile_browser_cltable. |
num_active_view_eligible_impression | int 1 when impression is active view eligible; 0 when impression is not active view eligible. |
num_active_view_measurable_impression | int 1 when impression is active view measurable; 0 when impression is not active view measurable. |
operating_system_version_ids | array ID of OS. Joins with operating_system_version_id in adh.os_version table. |
physical_screen_height | int Device screen height in mm. |
physical_screen_width | int Device screen width in mm. |
publisher_domain | string Domain of the page on which ad appeared. |
query_id | struct Unique identifier for query has multiple parts. Joins with query_id in any adh.dv360_youtube table. |
query_id.process_id | int The processing ID. |
query_id.server_ip | int The processing server. |
query_id.time_usec | int The query time in microseconds. |
query_language | string Language used by user. |
user_id | string User ID |
is_app_traffic | boolean true if the event happened in a native app. |
partner_id | int Unique ID of the partner. |
advertiser_id | int Unique ID of the advertiser. |
insertion_order_id | int Unique ID of the insertion order. |
lineitem_id | int Unique ID of the line item. |
adgroup_id | int ID of DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table. |
creative_id | int Joins with creative_id in any adh.dv360_youtube table. |
DV360 YouTube insertion order
dv360_youtube_insertion_order | |
---|---|
advertiser_id | int Unique ID of the advertiser. |
campaign_id | int Unique ID of the campaign. |
insertion_order_name | string Name of the insertion order. |
insertion_order_id | int Unique ID of the insertion order. |
partner_id | int Unique ID of the partner. |
DV360 YouTube line item
dv360_youtube_line_item | |
---|---|
advertiser_id | int Unique ID of the advertiser. |
campaign_id | int Unique ID of the campaign. |
insertion_order_id | int Unique ID of the insertion order. |
line_item_name | string Name of the line item. |
line_item_id | int Unique ID of the line item. |
partner_id | int Unique ID of the partner. |
Gender
gender | |
---|---|
gender_id | int Gender identifier. |
gender_name | string Gender name. Possible values are: "male", "female", or "unknown". |
Google Ads Active Views
google_ads_active_views | |
---|---|
num_active_view_viewable_impression | int 1 when impression is active view eligible; 0 when impression is not active view eligible. |
query_id | struct Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table. |
query_id.process_id | int The processing ID. |
query_id.server_ip | int The processing server. |
query_id.time_usec | int The query time in microseconds. |
view_id | struct Unique identifier for view_id has multiple parts. |
view_id.process_id | int Time in microseconds. |
view_id.server_ip | int The processing server. |
view_id.time_usec | int The processing process. |
impression_data.customer_id | int ID of Google Ads customer. Joins with customer_id in any adh.google_ads table. |
impression_data.campaign_id | int Unique ID of the campaign. |
impression_data.adgroup_id | int ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table. |
impression_data.ad_group_creative_id | int ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table. |
Google Ads ad group
google_ads_adgroup | |
---|---|
adgroup_id | int ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table. |
adgroup_name | string Ad group name. |
adgroup_status | string The ad group. Possible values are: "status", "paused", or "enabled". |
adgroup_type | string The ad group type. Possible values are: VIDEO_TRUE_VIEW_IN_STREAM, VIDEO_TRUE_VIEW_IN_DISPLAY, VIDEO_BUMPER_IN_STREAM, VIDEO_NON_SKIPPABLE_IN_STREAM, DISPLAY, SEARCH, or OTHER. |
campaign_id | int Unique ID of the campaign. |
customer_id | int Joins with customer_id in any adh.google_ads table. |
label_ids | array Joins with label_id in the adh.google_ads_label table. |
Google Ads campaign
google_ads_campaign | |
---|---|
advertising_channel_type | string Advertising channel type. Possible values are: SEARCH, DISPLAY, VIDEO, or OTHER. |
campaign_id | int Unique ID of the campaign. |
campaign_name | string Campaign name. |
campaign_status | int Campaign status. 3 = ACTIVE. 5 = PAUSED. 7 = DELETED. |
customer_id | int Joins with customer_id in any adh.google_ads table. |
end_time | int Timestamp when the campaign ends in milliseconds. |
label_ids | array Joins with label_id in the adh.google_ads_label table. |
start_time | int Timestamp when the campaign begins in milliseconds. |
Google Ads clicks
google_ads_clicks | |
---|---|
advertiser_click_cost_local_micros | double The advertiser's cost in local currency micros. |
advertiser_click_cost_usd | double The advertiser's click cost in dollars. |
click_id | struct Unique identifier for click has multiple parts. Joins with click_id in any adh.google_ads table. |
click_id.process_id | int The processing process. |
click_id.server_ip | int The processing server. |
click_id.time_usec | int Time in microseconds. |
click_type | int The click type. |
is_in_rdid_project | boolean True if this event is also in the _rdid table. Used for deduplication of events. |
query_id | struct Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table. |
query_id.process_id | int The processing process. |
query_id.server_ip | int The processing server. |
query_id.time_usec | int Time in microseconds. |
user_id | string User ID |
impression_data.customer_id | int ID of Google Ads customer. Joins with customer_id in any adh.google_ads table. |
impression_data.campaign_id | int Unique ID of the campaign. |
impression_data.adgroup_id | int ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table. |
impression_data.ad_group_creative_id | int ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table. |
Google Ads clicks audience
google_ads_clicks_audience | |
---|---|
advertiser_click_cost_local_micros | double The advertiser's cost in local currency micros. |
advertiser_click_cost_usd | double The advertiser's click cost in dollars. |
click_id | struct Unique identifier for click has multiple parts. Joins with click_id in any adh.yt table. |
click_id.process_id | int The processing process. |
click_id.server_ip | int The processing server. |
click_id.time_usec | int Time in microseconds. |
click_type | int The click type. |
is_in_rdid_project | boolean True if this event is also in the _rdid table. Used for deduplication of events. |
query_id | struct Unique identifier for query has multiple parts. Joins with query_id in any adh.yt table. |
query_id.process_id | int The processing process. |
query_id.server_ip | int The processing server. |
query_id.time_usec | int Time in microseconds. |
user_id | string User ID |
Google Ads conversions
google_ads_conversions | |
---|---|
click_id | struct Unique identifier for click has multiple parts. Joins with click_id in any adh.yt table. |
click_id.process_id | int The processing process. |
click_id.server_ip | int The processing server. |
click_id.time_usec | int Time in microseconds. |
conversion_id | struct Unique identifier for conversion has multiple parts. |
conversion_id.process_id | int The processing process. |
conversion_id.server_ip | int The processing server. |
conversion_id.time_usec | int Time in microseconds. |
conversion_type | int The type of conversion. |
is_in_rdid_project | boolean True if this event is also in the _rdid table. Used for deduplication of events. |
label | string Name of conversion event. |
query_id | struct Unique identifier for query has multiple parts. Joins with query_id in any adh.yt table. |
query_id.process_id | int The processing process. |
query_id.server_ip | int The processing server. |
query_id.time_usec | int Time in microseconds. |
user_id | string User ID |
impression_data.customer_id | int ID of Google Ads customer. Joins with customer_id in any adh.google_ads table. |
impression_data.campaign_id | int Unique ID of the campaign. |
impression_data.adgroup_id | int ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table. |
impression_data.ad_group_creative_id | int ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table. |
Google Ads conversions audience
google_ads_conversions_audience | |
---|---|
click_id | struct Unique identifier for click has multiple parts. Joins with click_id in any adh.yt table. |
click_id.process_id | int The processing process. |
click_id.server_ip | int The processing server. |
click_id.time_usec | int Time in microseconds. |
conversion_id | struct Unique identifier for conversion has multiple parts. |
conversion_id.process_id | int The processing process. |
conversion_id.server_ip | int The processing server. |
conversion_id.time_usec | int Time in microseconds. |
conversion_type | int The type of conversion. |
is_in_rdid_project | boolean True if this event is also in the _rdid table. Used for deduplication of events. |
label | string Name of conversion event. |
query_id | struct Unique identifier for query has multiple parts. Joins with query_id in any adh.yt table. |
query_id.process_id | int The processing process. |
query_id.server_ip | int The processing server. |
query_id.time_usec | int Time in microseconds. |
user_id | string User ID |
Google Ads creative
google_ads_creative | |
---|---|
beacon_url | array Multipart identifier for third-party ad trafficked by Campaign Manager. |
creative_id | int Joins with creative_id in any adh.google_ads table. |
creative_name | string Creative name. |
creative_type | int Creative type. |
customer_id | int Joins with customer_id in any adh.google_ads table. |
snippet_url | struct Multipart identifier for third-party ad served by Campaign Manager |
snippet_url.advertiser_id | int ID for Campaign Manager advertiser of ad being served. |
snippet_url.campaign_id | int Joins with campaign_id in any adh.google_ads table. |
snippet_url.content_url_data | struct Multipart record for content URL. |
snippet_url.content_url_data.index | int Index of content URL. |
snippet_url.content_url_data.url_type | string The type of URL. |
snippet_url.network | int ID for Campaign Manager network of ad being served. |
snippet_url.placement_id | int Unique ID for Campaign Manager placement of ad being served. |
snippet_url.placement_key | string Full string identifying Campaign Manager placement of ad being served. |
snippet_url.site_id | int ID for Campaign Manager site of ad being served. |
template_id | int Template ID of the creative. |
video_message | struct Multipart identifier for video data. |
video_message.video_ad_duration | int Duration of the video in milliseconds. |
video_message.youtube_video_id | string Video id string representation as it appears on YouTube watch url. |
Google Ads creative vendor metadata
google_ads_creative_vendor_metadata | |
---|---|
creative_id | int The Creative ID in Campaign Manager UI. |
legacy_pixel | string |
vendor_string | string |
Google Ads customer
google_ads_customer | |
---|---|
customer_company_name | string Company name. |
customer_id | int Joins with customer_id in any adh.google_ads table. |
customer_name | string Customer name. |
external_customer_id | int Joins with customer_id in any adh.google_ads table. |
mcc_ids | array My Client Center Ids in Google Ads that this ADH customer is associated with. |
Google Ads impressions
google_ads_impressions | |
---|---|
active_view_data | int Whether the impression was enabled for active view measurement. |
ad_group_creative_id | int ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table. |
adgroup_id | int ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table. |
advertiser_impression_cost_local_micros | double The advertiser's local currency in micros. |
advertiser_impression_cost_usd | double The advertiser's impression cost in dollars. |
affinity | array ID of affinity group. Joins with affinity_id in adh.affinity table. Does not support TrueView line items. |
campaign_id | int Unique ID of the campaign. |
content_url | string URL of the page on which ad appeared. Part of the url is removed for privacy. |
customer_id | int ID of Google Ads customer.Joins with customer_id in any adh.google_ads table. |
demographics | struct |
demographics.age_group | int Code for age group. Joins with age_group_id in adh.age_group table. |
demographics.gender | int Code for gender. Joins with gender_id in adh.gender table. |
device_height | int Device height in px. |
device_width | int Device width in px. |
in_market | array ID of in-market group. Joins with in_market_id in adh.in_market table. Does not support TrueView line items. |
is_in_rdid_project | boolean True if this event is also in the _rdid table. Used for deduplication of events. |
location | struct Unique identifier for location has multiple parts |
location.country | string |
location.geo_city_id | int Code for city. Joins with city_id in adh.city table. |
location.geo_metro | int Code for metro region. Joins with metro_id in adh.metro table. |
location.geo_region | string Region as string e.g. US-CA. |
mobile_browser_class | int Type of browser. Possible values are: desktop, tablet, smart tv consoles, or mobile. Joins with mobile_browser_class_id in adh.mobile_browser_cltable. |
num_active_view_eligible_impression | int 1 when impression is active view eligible; 0 when impression is not active view eligible. |
num_active_view_measurable_impression | int 1 when impression is active view measurable; 0 when impression is not active view measurable. |
operating_system_version_ids | array ID of OS. Joins with operating_system_version_id in adh.os_version table. |
physical_screen_height | int Device screen height in mm. |
physical_screen_width | int Device screen width in mm. |
publisher_domain | string Domain of the page on which ad appeared. |
query_id | struct Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table. |
query_id.process_id | int The processing ID. |
query_id.server_ip | int The processing server. |
query_id.time_usec | int The query time in microseconds. |
query_language | string Language used by user. |
user_id | string User ID |
is_app_traffic | boolean TRUE if the event happened in a native app. FALSE if the event happened in HTML5 app or webview. |
Google Ads label
google_ads_label | |
---|---|
customer_id | int Joins with customer_id in any adh.google_ads table. |
description | string Label description. |
label_id | int Joins with label_id in adh.google_ads tables that contain label_ids. |
label_name | string Label name. |
status | int Label status. 1 = ENABLED. 2 = DELETED. |
Google Ads view through conversions
google_ads_view_through_conversions | |
---|---|
click_id | struct Unique identifier for click has multiple parts. Joins with click_id in any adh.yt table. |
click_id.process_id | int The processing process. |
click_id.server_ip | int The processing server. |
click_id.time_usec | int Time in microseconds. |
conversion_id | struct Unique identifier for conversion has multiple parts. |
conversion_id.process_id | int The processing process. |
conversion_id.server_ip | int The processing server. |
conversion_id.time_usec | int Time in microseconds. |
conversion_type | int The type of conversion. |
device_id_md5 | string MD5-hashed device ID. Utility will be provided to hash raw device IDs to match. |
is_in_rdid_project | boolean True if this event is also in the _rdid table. Used for deduplication of events. |
label | string Name of conversion event. |
query_id | struct Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table. |
query_id.process_id | int The processing ID. |
query_id.server_ip | int The processing server. |
query_id.time_usec | int The query time in microseconds. |
user_id | string User ID |
In-market segment
in_market | |
---|---|
in_market_category | string The category of market vertical. |
in_market_id | int In-market identifier. |
in_market_name | string A more specific in-market name based on category. |
Metro
metro | |
---|---|
country_code | string Two character country code. |
metro_abbrev | string Abbreviated version of metro name. |
metro_code | string The metropolitan area code. |
metro_id | int Metro identifier. |
metro_name | string Metro name. |
Mobile browser class
mobile_browser_class | |
---|---|
mobile_browser_class_id | int Mobile browser class identifier. |
mobile_browser_class_name | string Name of the mobile browser class. |
Operating system
operating_system | |
---|---|
mobile | boolean True if the operating system is mobile. |
operating_system_id | int Operating system identifier. |
operating_system_name | string Operating system name. |
Operating system version
os_version | |
---|---|
major_version | int The major version number of the operating system. |
minor_version | int The minor version of the operating system. |
operating_system_id | int Unique ID of OS just for Data Transfer. |
operating_system_version_id | int Operating system version identifier. |
operator_type | string Possible values are OPERATOR_TYPE_EQUAL_TO, or OPERATOR_TYPE_GREATER_THAN_EQUAL_TO. |
platform_name | string The platform name in English. |
Region
region | |
---|---|
country_code | string Two character country code. |
region_code | string Region code. |
region_id | int Region identifier. |
region_name | string Region name. |
YouTube Reserve Active Views
yt_reserve_active_views | |
---|---|
num_active_view_viewable_impression | int 1 when impression is active view viewable; 0 when impression is not active view viewable. |
query_id | struct Unique identifier for query has multiple parts. |
query_id.process_id | int The processing process. |
query_id.server_ip | int The processing server. |
query_id.time_usec | int Time in microseconds. |
view_id | struct Unique identifier for view has multiple parts. |
view_id.process_id | int The processing process. |
view_id.server_ip | int The processing server. |
view_id.time_usec | int Time in microseconds. |
impression_data.order_id | int |
impression_data.line_item_id | int Line item id for this impression. |
impression_data.creative_id | int The Creative ID in Campaign Manager UI. |
impression_data.media_plan_id | int ID of the YouTube Reserve media plan. |
YouTube Reserve clicks
yt_reserve_clicks | |
---|---|
click_id | struct Unique identifier for click has multiple parts. |
click_id.process_id | int The processing process. |
click_id.server_ip | int The processing server. |
click_id.time_usec | int Time in microseconds. |
click_type | int The click type. |
is_in_rdid_project | boolean True if this event is also in the _rdid table. Used for deduplication of events. |
query_id | struct Unique identifier for query has multiple parts. |
query_id.process_id | int The processing process. |
query_id.server_ip | int The processing server. |
query_id.time_usec | int Time in microseconds. |
user_id | string User ID |
impression_data.order_id | int |
impression_data.line_item_id | int Line item id for this impression. |
impression_data.creative_id | int The Creative ID in Campaign Manager UI. |
impression_data.media_plan_id | int ID of the YouTube Reserve media plan. |
YouTube Reserve conversions
yt_reserve_conversions | |
---|---|
click_id | struct Unique identifier for click has multiple parts. |
click_id.process_id | int The processing process. |
click_id.server_ip | int The processing server. |
click_id.time_usec | int Time in microseconds. |
conversion_id | struct Unique identifier for conversion has multiple parts. |
conversion_id.process_id | int The processing process. |
conversion_id.server_ip | int The processing server. |
conversion_id.time_usec | int Time in microseconds. |
conversion_type | int The type of conversion. |
is_in_rdid_project | boolean True if this event is also in the _rdid table. Used for deduplication of events.True if this event is also in the _rdid tabUsed for deduplication of events. |
label | string Name of conversion event. |
query_id | struct Unique identifier for query has multiple parts. |
query_id.process_id | int The processing process. |
query_id.server_ip | int The processing server. |
query_id.time_usec | int Time in microseconds. |
user_id | string User ID |
impression_data.order_id | int |
impression_data.line_item_id | int Line item id for this impression. |
impression_data.creative_id | int The Creative ID in Campaign Manager UI. |
impression_data.media_plan_id | int ID of the YouTube Reserve media plan. |
YouTube Reserve creative
yt_reserve_creative | |
---|---|
creative_format_type | string Some formats map directly to a type. Other types have multiple formats like: html, image, or video. |
creative_id | int The Creative ID in Campaign Manager UI. |
creative_name | string Name of the creative. |
creative_type | string The type of creative. |
dcm_beacons | array Multipart identifier for Campaign Manager tracking pixel for ad. |
is_masthead | boolean True if this is a masthead creative. |
third_party_vast_url | string VAST url of the creative if the creative is a third party hosted video. Does not support creatives from programmatic items. |
video_message | struct Multipart identifier for video data. |
video_message.video_ad_duration | int Duration of the video in milliseconds. |
video_message.youtube_channel_id | string Id of the channel that provides this video. |
video_message.youtube_video_id | string Video id string representation as it appears on YouTube watch url. |
YouTube Reserve impressions
yt_reserve_impressions | |
---|---|
active_view_data | int Whether the impression was enabled for active view measurement. |
content_url | string RL of the page on which ad appeared. Part of the url is removed for privacy. |
creative_id | int The Creative ID in Campaign Manager UI. |
demographics | struct Unique identifier for demographics has multiple parts |
demographics.age_group | int Code for age group. Joins with age_group_id in adh.age_group table. |
demographics.gender | int Code for gender. Joins with gender_id in adh.gender table. |
device_height | int Device height in px. |
device_width | int Device width in px. |
is_in_rdid_project | boolean True if this event is also in the _rdid table. Used for deduplication of events. |
line_item_id | int Line item id for this impression. |
location | struct Unique identifier for location has multiple parts. |
location.country | string |
location.geo_city_id | int Code for city. Joins with city_id in adh.city table. |
location.geo_metro | int Code for metro region. Joins with metro_id in adh.metro table. |
location.geo_region | string Region as string, e.g. US-CA. |
mobile_browser_class | int Desktop, tablet, smart tv consoles, or mobile. Joins with mobile_browser_class_id in adh.mobile_browser_class table. |
num_active_view_eligible_impression | int when impression is active view eligible; 0 when impression is not active view eligible. |
num_active_view_measurable_impression | int 1 when impression is active view measurable; 0 when impression is not active view measurable. |
operating_system_version_ids | array ID of OS. Joins with operating_system_version_id in adh.os_version table. |
order_id | int |
physical_screen_height | int Device screen height in mm. |
physical_screen_width | int Device screen width in mm. |
publisher_domain | string Domain of page on which ad appeared. |
query_id | struct Unique identifier for query has multiple parts. |
query_id.process_id | int The processing process. |
query_id.server_ip | int The processing server. |
query_id.time_usec | int Time in microseconds. |
query_language | string Language used by user. |
user_id | string User ID |
is_app_traffic | boolean TRUE if the event happened in a native app. FALSE if the event happened in HTML5 app or webview. |
media_plan_id | int ID of the YouTube Reserve media plan. |
YouTube Reserve line item
yt_reserve_lineitem | |
---|---|
cost_per_unit | int Cost per unit served in micros |
cost_type | string Cost per click, conversion, impression, and Active View. |
creative_id | array Array of creative ids for this line item. Joins with creative_id in any adh.yt table. |
end_time | timestamp Time the line item stopped being served. |
line_item_id | int Ad Manager line item serving. |
line_item_name | string Ad Manager line item name. |
order_id | int Ad Manager Order identifier used for serving. |
order_name | string Name of the insertion order. |
programmatic | boolean True if the line item was programmatic. |
skippable_ad_type | string Possible values are: "skippable", "not skippable", or "selectable". |
start_time | timestamp Time the line item started to be served. |
value_cost_per_unit | int The value cost per unit of the line item. |
YouTube Reserve order
yt_reserve_order | |
---|---|
order_id | int Ad Manager Order identifier used for serving. |
order_name | string Name of Ad Manager order |
advertiser_id | int Unique ID of the advertiser. |
advertiser_name | string User entered name of the advertiser. |
media_plan_id | int ID of the YouTube Reserve media plan. |
media_plan_name | string Name of the YouTube Reserve media plan. |