Ads Data Hub table format - Advertisers

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.