Ads Data Hub table format - Advertisers

Affinity segment

affinity
affinity_categorystring
Affinity category.
affinity_idint
Affinity identifier.
affinity_namestring
Affinity name.

Age group

age_group
age_group_idint
Age group identifier.
age_group_namestring
Age group name.

Browser

browser
browser_idint
Browser identifier.
browser_namestring
Browser name.
major_versionstring
Major version of the browser (whole number version).
minor_versionstring
Minor version of the browser (incremental or decimal version).

City

city
city_idint
Unique ID of the city.
city_namestring
City name.
country_codestring
Two character country code.
latitudeint
Latitude in degrees.
longitudeint
Longitude in degrees.
metro_codestring
Metropolitan area code.
region_codestring
The multi character code of the region

Campaign Manager Data Transfer account info

cm_dt_account_info
account_idint
Unique ID of the account.
timezone_namestring
Timezone of the account.

Campaign Manager Data Transfer Active View plus

cm_dt_active_view_plus
device_id_md5string
MD5-hashed device ID; a utility may be provided to hash raw device IDs to match.
eventstruct
event.active_view_audible_impressionsint
Active View: Impressions Audible
event.active_view_audible_time_msecint
Active View: Play Time Audible (Seconds)
event.active_view_audible_visible_time_msecint
Active View: Play Time Audible and Visible (Seconds)
event.active_view_background_countint
Active View: Impressions In Background
event.active_view_complete_viewable_impressionsint
Active View: Impressions Visible at Completion
event.active_view_eligible_impressionsint
Active View: Eligible Impressions
event.active_view_first_quartile_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at First Quartile
event.active_view_first_quartile_viewable_impressionsint
Active View: Impressions Visible at First Quartile
event.active_view_fullscreen_countint
Active View: Impressions Full-Screen
event.active_view_impressions_audible_and_visible_at_completionint
Active View: Impressions Audible and Visible at Completion
event.active_view_impressions_visible10_secondsint
Active View: Impressions Visible 10 Seconds
event.active_view_measurable_impressionsint
Active View: Measurable Impressions
event.active_view_midpoint_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Midpoint
event.active_view_midpoint_viewable_impressionsint
Active View: Impressions Visible at Midpoint
event.active_view_plus_measurable_countint
Active View Plus: Measurable Impressions
event.active_view_start_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Start
event.active_view_start_viewable_impressionsint
Active View: Impressions Visible at Start
event.active_view_third_quartile_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Third Quartile
event.active_view_third_quartile_viewable_impressionsint
Active View: Impressions Visible at Third Quartile
event.active_view_tos_msecint
Active View: Time on Screen (Seconds)
event.active_view_viewable_impressionsint
Active View: Viewable Impressions
event.active_view_visible_time_msecint
Active View: Video Visible Time (Seconds)
event.activity_countint
Activity Quantity
event.activity_idint
Activity ID
event.activity_revenuedouble
Activity Revenue
event.ad_idint
Ad ID
event.advertiser_idint
Advertiser ID
event.audience_segment_idint
event.browser_platform_idstring
Browser/Platform ID
event.browser_versionstring
Browser/Platform Version
event.campaign_idint
Campaign ID
event.city_idint
City ID
event.conversion_idint
Conversion ID
event.country_codestring
Country
event.creative_versionstring
Creative Version
event.dma_region_idint
Designated Market Area (DMA) ID
event.dv360_ad_positionint
DV360 Ad Position
event.dv360_advertiser_idint
DV360 Advertiser ID
event.dv360_adx_page_categoriesstring
DV360 Adx Page Categories
event.dv360_attributed_inventory_source_external_idstring
DV360 Attributed Inventory Source External ID
event.dv360_attributed_inventory_source_is_publicstring
DV360 Attributed Inventory Source Is Public
event.dv360_auction_idstring
DV360 Auction ID
event.dv360_bid_price_advertiser_currencyint
DV360 Bid Price (Advertiser Currency)
event.dv360_bid_price_partner_currencyint
DV360 Bid Price (Partner Currency)
event.dv360_bid_price_usdint
DV360 Bid Price (USD)
event.dv360_billable_cost_advertiser_currencyint
DV360 Billable Cost (Advertiser Currency)
event.dv360_billable_cost_partner_currencyint
DV360 Billable Cost (Partner Currency)
event.dv360_billable_cost_usdint
DV360 Billable Cost (USD)
event.dv360_browser_idint
DV360 Browser/Platform ID
event.dv360_browser_timezone_offset_minutesint
DV360 Browser Timezone Offset Minutes
event.dv360_campaign_idint
DV360 Campaign ID
event.dv360_city_idint
DV360 City ID
event.dv360_country_codestring
DV360 Country Code
event.dv360_cpm_fee_1_advertiser_currencyint
event.dv360_cpm_fee_1_partner_currencyint
event.dv360_cpm_fee_1_usdint
event.dv360_cpm_fee_2_advertiser_currencyint
event.dv360_cpm_fee_2_partner_currencyint
event.dv360_cpm_fee_2_usdint
event.dv360_cpm_fee_3_advertiser_currencyint
event.dv360_cpm_fee_3_partner_currencyint
event.dv360_cpm_fee_3_usdint
event.dv360_cpm_fee_4_advertiser_currencyint
event.dv360_cpm_fee_4_partner_currencyint
event.dv360_cpm_fee_4_usdint
event.dv360_cpm_fee_5_advertiser_currencyint
event.dv360_cpm_fee_5_partner_currencyint
event.dv360_cpm_fee_5_usdint
event.dv360_creative_idint
DV360 Creative ID
event.dv360_data_fees_advertiser_currencyint
event.dv360_data_fees_partner_currencyint
event.dv360_data_fees_usdint
event.dv360_device_typeint
DV360 Device Type
event.dv360_exchange_idstring
DV360 Exchange ID
event.dv360_insertion_order_idint
DV360 Insertion Order ID
event.dv360_isp_idint
DV360 ISP ID
event.dv360_languagestring
DV360 Language
event.dv360_line_item_idint
DV360 Line Item ID
event.dv360_matching_targeted_keywordsstring
DV360 Matching Targeted Keywords
event.dv360_matching_targeted_segmentsstring
DV360 Matching Targeted Segments
event.dv360_media_cost_advertiser_currencyint
DV360 Media Cost (Advertiser Currency)
event.dv360_media_cost_partner_currencyint
DV360 Media Cost (Partner Currency)
event.dv360_media_cost_usdint
DV360 Media Cost (USD)
event.dv360_media_fee_1_advertiser_currencyint
event.dv360_media_fee_1_partner_currencyint
event.dv360_media_fee_1_usdint
event.dv360_media_fee_2_advertiser_currencyint
event.dv360_media_fee_2_partner_currencyint
event.dv360_media_fee_2_usdint
event.dv360_media_fee_3_advertiser_currencyint
event.dv360_media_fee_3_partner_currencyint
event.dv360_media_fee_3_usdint
event.dv360_media_fee_4_advertiser_currencyint
event.dv360_media_fee_4_partner_currencyint
event.dv360_media_fee_4_usdint
event.dv360_media_fee_5_advertiser_currencyint
event.dv360_media_fee_5_partner_currencyint
event.dv360_media_fee_5_usdint
event.dv360_mobile_make_idint
DV360 Mobile Make ID
event.dv360_mobile_model_idint
DV360 Mobile Model ID
event.dv360_net_speedint
DV360 Net Speed
event.dv360_operating_system_idint
Operating System ID.
event.dv360_request_timeint
DV360 Request Time
event.dv360_revenue_advertiser_currencyint
DV360 Revenue (Advertiser Currency)
event.dv360_revenue_partner_currencyint
DV360 Revenue (Partner Currency)
event.dv360_revenue_usdint
DV360 Revenue (USD)
event.dv360_site_idint
DV360 Site ID
event.dv360_state_region_idint
DV360 Region ID
event.dv360_urlstring
DV360 URL
event.dv360_view_statestring
DV360 View State
event.dv360_zip_postal_codestring
DV360 ZIP/Postal Code
event.event_sub_typestring
Event Sub-Type
event.event_timeint
Event Time
event.event_typestring
Event Type
event.floodlight_config_idint
Floodlight Configuration
event.impression_idstring
Impression ID
event.interaction_time_utc_secondsstring
Interaction Time
event.landing_page_url_idint
Landing Page URL ID
event.operating_system_idint
Operating System ID
event.ord_valuestring
ORD Value
event.other_datastring
Other Data
event.placement_idint
Placement ID
event.platform_type_idint
event.referrer_urlstring
Referrer URL
event.rendering_idint
Rendering ID
event.rich_media_event_countersint
Event Counters
event.rich_media_event_idint
Rich Media Event ID
event.rich_media_event_timersdouble
Event Timers
event.rich_media_event_type_idint
Rich Media Event Type ID
event.segment_value_1int
Segment Value 1
event.site_idint
Site ID (Campaign Manager)
event.statestring
State/Region
event.tran_valuestring
TRAN Value
event.u_valuestring
U Value
event.zip_codestring
Zip Code
is_in_rdid_projectboolean
True if this event is also in the _rdid table. Used for deduplication of events.
network_idint
The network ID.
user_idstring
User ID

Campaign Manager Data Transfer activities

cm_dt_activities
device_id_md5string
MD5-hashed device ID; a utility may be provided to hash raw device IDs to match.
eventstruct
event.active_view_audible_impressionsint
Active View: Impressions Audible
event.active_view_audible_time_msecint
Active View: Play Time Audible (Seconds)
event.active_view_audible_visible_time_msecint
Active View: Play Time Audible and Visible (Seconds)
event.active_view_background_countint
Active View: Impressions In Background
event.active_view_complete_viewable_impressionsint
Active View: Impressions Visible at Completion
event.active_view_eligible_impressionsint
Active View: Eligible Impressions
event.active_view_first_quartile_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at First Quartile
event.active_view_first_quartile_viewable_impressionsint
Active View: Impressions Visible at First Quartile
event.active_view_fullscreen_countint
Active View: Impressions Full-Screen
event.active_view_impressions_audible_and_visible_at_completionint
Active View: Impressions Audible and Visible at Completion
event.active_view_impressions_visible10_secondsint
Active View: Impressions Visible 10 Seconds
event.active_view_measurable_impressionsint
Active View: Measurable Impressions
event.active_view_midpoint_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Midpoint
event.active_view_midpoint_viewable_impressionsint
Active View: Impressions Visible at Midpoint
event.active_view_plus_measurable_countint
Active View Plus: Measurable Impressions
event.active_view_start_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Start
event.active_view_start_viewable_impressionsint
Active View: Impressions Visible at Start
event.active_view_third_quartile_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Third Quartile
event.active_view_third_quartile_viewable_impressionsint
Active View: Impressions Visible at Third Quartile
event.active_view_tos_msecint
Active View: Time on Screen (Seconds)
event.active_view_viewable_impressionsint
Active View: Viewable Impressions
event.active_view_visible_time_msecint
Active View: Video Visible Time (Seconds)
event.activity_countint
Activity Quantity
event.activity_idint
Activity ID
event.activity_revenuedouble
Activity Revenue
event.ad_idint
Ad ID
event.advertiser_idint
Advertiser ID
event.audience_segment_idint
event.browser_platform_idstring
Browser/Platform ID
event.browser_versionstring
Browser/Platform Version
event.campaign_idint
Campaign ID
event.city_idint
City ID
event.conversion_idint
Conversion ID
event.country_codestring
Country
event.creative_versionstring
Creative Version
event.dma_region_idint
Designated Market Area (DMA) ID
event.dv360_ad_positionint
DV360 Ad Position
event.dv360_advertiser_idint
DV360 Advertiser ID
event.dv360_adx_page_categoriesstring
DV360 Adx Page Categories
event.dv360_attributed_inventory_source_external_idstring
DV360 Attributed Inventory Source External ID
event.dv360_attributed_inventory_source_is_publicstring
DV360 Attributed Inventory Source Is Public
event.dv360_auction_idstring
DV360 Auction ID
event.dv360_bid_price_advertiser_currencyint
DV360 Bid Price (Advertiser Currency)
event.dv360_bid_price_partner_currencyint
DV360 Bid Price (Partner Currency)
event.dv360_bid_price_usdint
DV360 Bid Price (USD)
event.dv360_billable_cost_advertiser_currencyint
DV360 Billable Cost (Advertiser Currency)
event.dv360_billable_cost_partner_currencyint
DV360 Billable Cost (Partner Currency)
event.dv360_billable_cost_usdint
DV360 Billable Cost (USD)
event.dv360_browser_idint
DV360 Browser/Platform ID
event.dv360_browser_timezone_offset_minutesint
DV360 Browser Timezone Offset Minutes
event.dv360_campaign_idint
DV360 Campaign ID
event.dv360_city_idint
DV360 City ID
event.dv360_country_codestring
DV360 Country Code
event.dv360_cpm_fee_1_advertiser_currencyint
event.dv360_cpm_fee_1_partner_currencyint
event.dv360_cpm_fee_1_usdint
event.dv360_cpm_fee_2_advertiser_currencyint
event.dv360_cpm_fee_2_partner_currencyint
event.dv360_cpm_fee_2_usdint
event.dv360_cpm_fee_3_advertiser_currencyint
event.dv360_cpm_fee_3_partner_currencyint
event.dv360_cpm_fee_3_usdint
event.dv360_cpm_fee_4_advertiser_currencyint
event.dv360_cpm_fee_4_partner_currencyint
event.dv360_cpm_fee_4_usdint
event.dv360_cpm_fee_5_advertiser_currencyint
event.dv360_cpm_fee_5_partner_currencyint
event.dv360_cpm_fee_5_usdint
event.dv360_creative_idint
DV360 Creative ID
event.dv360_data_fees_advertiser_currencyint
event.dv360_data_fees_partner_currencyint
event.dv360_data_fees_usdint
event.dv360_device_typeint
DV360 Device Type
event.dv360_exchange_idstring
DV360 Exchange ID
event.dv360_insertion_order_idint
DV360 Insertion Order ID
event.dv360_isp_idint
DV360 ISP ID
event.dv360_languagestring
DV360 Language
event.dv360_line_item_idint
DV360 Line Item ID
event.dv360_matching_targeted_keywordsstring
DV360 Matching Targeted Keywords
event.dv360_matching_targeted_segmentsstring
DV360 Matching Targeted Segments
event.dv360_media_cost_advertiser_currencyint
DV360 Media Cost (Advertiser Currency)
event.dv360_media_cost_partner_currencyint
DV360 Media Cost (Partner Currency)
event.dv360_media_cost_usdint
DV360 Media Cost (USD)
event.dv360_media_fee_1_advertiser_currencyint
event.dv360_media_fee_1_partner_currencyint
event.dv360_media_fee_1_usdint
event.dv360_media_fee_2_advertiser_currencyint
event.dv360_media_fee_2_partner_currencyint
event.dv360_media_fee_2_usdint
event.dv360_media_fee_3_advertiser_currencyint
event.dv360_media_fee_3_partner_currencyint
event.dv360_media_fee_3_usdint
event.dv360_media_fee_4_advertiser_currencyint
event.dv360_media_fee_4_partner_currencyint
event.dv360_media_fee_4_usdint
event.dv360_media_fee_5_advertiser_currencyint
event.dv360_media_fee_5_partner_currencyint
event.dv360_media_fee_5_usdint
event.dv360_mobile_make_idint
DV360 Mobile Make ID
event.dv360_mobile_model_idint
DV360 Mobile Model ID
event.dv360_net_speedint
DV360 Net Speed
event.dv360_operating_system_idint
Operating System ID.
event.dv360_request_timeint
DV360 Request Time
event.dv360_revenue_advertiser_currencyint
DV360 Revenue (Advertiser Currency)
event.dv360_revenue_partner_currencyint
DV360 Revenue (Partner Currency)
event.dv360_revenue_usdint
DV360 Revenue (USD)
event.dv360_site_idint
DV360 Site ID
event.dv360_state_region_idint
DV360 Region ID
event.dv360_urlstring
DV360 URL
event.dv360_view_statestring
DV360 View State
event.dv360_zip_postal_codestring
DV360 ZIP/Postal Code
event.event_sub_typestring
Event Sub-Type
event.event_timeint
Event Time
event.event_typestring
Event Type
event.floodlight_config_idint
Floodlight Configuration
event.impression_idstring
Impression ID
event.interaction_time_utc_secondsstring
Interaction Time
event.landing_page_url_idint
Landing Page URL ID
event.operating_system_idint
Operating System ID
event.ord_valuestring
ORD Value
event.other_datastring
Other Data
event.placement_idint
Placement ID
event.platform_type_idint
event.referrer_urlstring
Referrer URL
event.rendering_idint
Rendering ID
event.rich_media_event_countersint
Event Counters
event.rich_media_event_idint
Rich Media Event ID
event.rich_media_event_timersdouble
Event Timers
event.rich_media_event_type_idint
Rich Media Event Type ID
event.segment_value_1int
Segment Value 1
event.site_idint
Site ID (Campaign Manager)
event.statestring
State/Region
event.tran_valuestring
TRAN Value
event.u_valuestring
U Value
event.zip_codestring
Zip Code
is_in_rdid_projectboolean
True if this event is also in the _rdid table. Used for deduplication of events.
network_idint
The network ID.
user_idstring
User ID

Campaign Manager Data Transfer activity category

cm_dt_activity_category
account_idint
Unique ID of the account.
activitystring
User defined category report interface name for floodlight tags.
activity_group_idint
ID of the group to which this advertiser belongs. An advertiser may be a member of only one group.
activity_idint
Unique ID of the Floodlight activity.
activity_sub_typestring
User defined string corresponding to cat= value from Floodlight tag.
activity_typestring
User defined string corresponding to type= value from Floodlight tag.
advertiser_idint
Unique ID of the advertiser.
floodlight_config_idint
Unique ID of the floodlight configuration.
tag_counting_method_idint
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_idint
Unique ID of the account.
activity_groupstring
Name for this activity group.
activity_group_idint
ID of the group to which this advertiser belongs. An advertiser may be a member of only one group.
activity_typestring
User defined string corresponding to type= value from Floodlight tag.
advertiser_idint
Unique ID of the advertiser.
floodlight_config_idint
Unique ID of the floodlight configuration.

Campaign Manager Data Transfer ad

cm_dt_ad
account_idint
Unique ID of the account.
adstring
User defined ad name.
ad_click_urlstring
Click through URL of Click Ad type creatives only (aka Click Commands)
ad_commentsstring
User defined ad level comments.
ad_idint
Unique ID of the ad.
ad_typestring
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_idint
Unique ID of the ad type.
advertiser_idint
Unique ID of the advertiser.
campaign_idint
Unique ID of the campaign.
creative_sizestring
The creative size in pixels: width x height. Empty size is represented by "0X0".
floodlight_config_idint
Unique ID of the floodlight configuration.

Campaign Manager Data Transfer Ad placement assignments

cm_dt_ad_placement_assignment
account_idint
Unique ID of the account.
ad_idint
Unique ID of the ad.
advertiser_idint
Unique ID of the advertiser.
floodlight_config_idint
Unique ID of the floodlight configuration.
placement_idint

Campaign Manager Data Transfer Advertiser

cm_dt_advertiser
account_idint
Unique ID of the account.
advertiserstring
User entered name of the advertiser.
advertiser_groupstring
User specified group to which this advertiser belongs. An advertiser may be a member of only one group.
advertiser_group_idint
Group ID to which this advertiser belongs. An advertiser may be a member of only one group.
advertiser_idint
Unique ID of the advertiser.
floodlight_config_idint
Unique ID of the floodlight configuration.

Campaign Manager Data Transfer asset

cm_dt_asset
account_idint
Unique ID of the account.
assetstring
Name of the creative asset.
asset_categorystring
Category of the creative asset.
asset_idint
Unique ID of the asset.
asset_orientationstring
Screen orientation of the asset.

Campaign Manager Data Transfer audience segments

cm_dt_audience_segments
account_idint
Unique ID of the account.
advertiser_idint
Unique ID of the advertiser.
audience_segmentstring
Name of the audience segment.
audience_segment_idint
Unique ID of the audience segment.
floodlight_config_idint
Unique ID of the floodlight configuration.

Campaign Manager Data Transfer browser

cm_dt_browser
browser_platformstring
browser_platform_idint
Browser / Platform ID

Campaign Manager Data Transfer campaign

cm_dt_campaign
account_idint
Unique ID of the account.
advertiser_idint
Unique ID of the advertiser.
billing_invoice_codestring
The code entered in the billing invoice.
campaignstring
User entered campaign name.
campaign_end_dateint
Campaign end date as YYYYMMDD.
campaign_idint
Unique ID of the campaign.
campaign_start_dateint
Campaign start date as YYYYMMDD.
floodlight_config_idint
Unique ID of the floodlight configuration.

Campaign Manager Data Transfer city

cm_dt_city
citystring
The city name
city_idint
Unique ID of the city.

Campaign Manager Data Transfer clicks

cm_dt_clicks
device_id_md5string
MD5-hashed device ID; a utility may be provided to hash raw device IDs to match.
eventstruct
event.active_view_audible_impressionsint
Active View: Impressions Audible
event.active_view_audible_time_msecint
Active View: Play Time Audible (Seconds)
event.active_view_audible_visible_time_msecint
Active View: Play Time Audible and Visible (Seconds)
event.active_view_background_countint
Active View: Impressions In Background
event.active_view_complete_viewable_impressionsint
Active View: Impressions Visible at Completion
event.active_view_eligible_impressionsint
Active View: Eligible Impressions
event.active_view_first_quartile_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at First Quartile
event.active_view_first_quartile_viewable_impressionsint
Active View: Impressions Visible at First Quartile
event.active_view_fullscreen_countint
Active View: Impressions Full-Screen
event.active_view_impressions_audible_and_visible_at_completionint
Active View: Impressions Audible and Visible at Completion
event.active_view_impressions_visible10_secondsint
Active View: Impressions Visible 10 Seconds
event.active_view_measurable_impressionsint
Active View: Measurable Impressions
event.active_view_midpoint_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Midpoint
event.active_view_midpoint_viewable_impressionsint
Active View: Impressions Visible at Midpoint
event.active_view_plus_measurable_countint
Active View Plus: Measurable Impressions
event.active_view_start_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Start
event.active_view_start_viewable_impressionsint
Active View: Impressions Visible at Start
event.active_view_third_quartile_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Third Quartile
event.active_view_third_quartile_viewable_impressionsint
Active View: Impressions Visible at Third Quartile
event.active_view_tos_msecint
Active View: Time on Screen (Seconds)
event.active_view_viewable_impressionsint
Active View: Viewable Impressions
event.active_view_visible_time_msecint
Active View: Video Visible Time (Seconds)
event.activity_countint
Activity Quantity
event.activity_idint
Activity ID
event.activity_revenuedouble
Activity Revenue
event.ad_idint
Ad ID
event.advertiser_idint
Advertiser ID
event.audience_segment_idint
event.browser_platform_idstring
Browser/Platform ID
event.browser_versionstring
Browser/Platform Version
event.campaign_idint
Campaign ID
event.city_idint
City ID
event.conversion_idint
Conversion ID
event.country_codestring
Country
event.creative_versionstring
Creative Version
event.dma_region_idint
Designated Market Area (DMA) ID
event.dv360_ad_positionint
DV360 Ad Position
event.dv360_advertiser_idint
DV360 Advertiser ID
event.dv360_adx_page_categoriesstring
DV360 Adx Page Categories
event.dv360_attributed_inventory_source_external_idstring
DV360 Attributed Inventory Source External ID
event.dv360_attributed_inventory_source_is_publicstring
DV360 Attributed Inventory Source Is Public
event.dv360_auction_idstring
DV360 Auction ID
event.dv360_bid_price_advertiser_currencyint
DV360 Bid Price (Advertiser Currency)
event.dv360_bid_price_partner_currencyint
DV360 Bid Price (Partner Currency)
event.dv360_bid_price_usdint
DV360 Bid Price (USD)
event.dv360_billable_cost_advertiser_currencyint
DV360 Billable Cost (Advertiser Currency)
event.dv360_billable_cost_partner_currencyint
DV360 Billable Cost (Partner Currency)
event.dv360_billable_cost_usdint
DV360 Billable Cost (USD)
event.dv360_browser_idint
DV360 Browser/Platform ID
event.dv360_browser_timezone_offset_minutesint
DV360 Browser Timezone Offset Minutes
event.dv360_campaign_idint
DV360 Campaign ID
event.dv360_city_idint
DV360 City ID
event.dv360_country_codestring
DV360 Country Code
event.dv360_cpm_fee_1_advertiser_currencyint
event.dv360_cpm_fee_1_partner_currencyint
event.dv360_cpm_fee_1_usdint
event.dv360_cpm_fee_2_advertiser_currencyint
event.dv360_cpm_fee_2_partner_currencyint
event.dv360_cpm_fee_2_usdint
event.dv360_cpm_fee_3_advertiser_currencyint
event.dv360_cpm_fee_3_partner_currencyint
event.dv360_cpm_fee_3_usdint
event.dv360_cpm_fee_4_advertiser_currencyint
event.dv360_cpm_fee_4_partner_currencyint
event.dv360_cpm_fee_4_usdint
event.dv360_cpm_fee_5_advertiser_currencyint
event.dv360_cpm_fee_5_partner_currencyint
event.dv360_cpm_fee_5_usdint
event.dv360_creative_idint
DV360 Creative ID
event.dv360_data_fees_advertiser_currencyint
event.dv360_data_fees_partner_currencyint
event.dv360_data_fees_usdint
event.dv360_device_typeint
DV360 Device Type
event.dv360_exchange_idstring
DV360 Exchange ID
event.dv360_insertion_order_idint
DV360 Insertion Order ID
event.dv360_isp_idint
DV360 ISP ID
event.dv360_languagestring
DV360 Language
event.dv360_line_item_idint
DV360 Line Item ID
event.dv360_matching_targeted_keywordsstring
DV360 Matching Targeted Keywords
event.dv360_matching_targeted_segmentsstring
DV360 Matching Targeted Segments
event.dv360_media_cost_advertiser_currencyint
DV360 Media Cost (Advertiser Currency)
event.dv360_media_cost_partner_currencyint
DV360 Media Cost (Partner Currency)
event.dv360_media_cost_usdint
DV360 Media Cost (USD)
event.dv360_media_fee_1_advertiser_currencyint
event.dv360_media_fee_1_partner_currencyint
event.dv360_media_fee_1_usdint
event.dv360_media_fee_2_advertiser_currencyint
event.dv360_media_fee_2_partner_currencyint
event.dv360_media_fee_2_usdint
event.dv360_media_fee_3_advertiser_currencyint
event.dv360_media_fee_3_partner_currencyint
event.dv360_media_fee_3_usdint
event.dv360_media_fee_4_advertiser_currencyint
event.dv360_media_fee_4_partner_currencyint
event.dv360_media_fee_4_usdint
event.dv360_media_fee_5_advertiser_currencyint
event.dv360_media_fee_5_partner_currencyint
event.dv360_media_fee_5_usdint
event.dv360_mobile_make_idint
DV360 Mobile Make ID
event.dv360_mobile_model_idint
DV360 Mobile Model ID
event.dv360_net_speedint
DV360 Net Speed
event.dv360_operating_system_idint
DV60 operating system ID
event.dv360_request_timeint
DV360 Request Time
event.dv360_revenue_advertiser_currencyint
DV360 Revenue (Advertiser Currency)
event.dv360_revenue_partner_currencyint
DV360 Revenue (Partner Currency)
event.dv360_revenue_usdint
DV360 Revenue (USD)
event.dv360_site_idint
DV360 Site ID
event.dv360_state_region_idint
DV360 Region ID
event.dv360_urlstring
DV360 URL
event.dv360_view_statestring
DV360 View State
event.dv360_zip_postal_codestring
DV360 ZIP/Postal Code
event.event_sub_typestring
Event Sub-Type
event.event_timeint
Event Time
event.event_typestring
Event Type
event.floodlight_config_idint
Floodlight Configuration
event.impression_idstring
Impression ID
event.interaction_time_utc_secondsstring
Interaction Time
event.landing_page_url_idint
Landing Page URL ID
event.operating_system_idint
Operating System ID
event.ord_valuestring
ORD Value
event.other_datastring
Other Data
event.placement_idint
Placement ID
event.platform_type_idint
event.referrer_urlstring
Referrer URL
event.rendering_idint
Rendering ID
event.rich_media_event_countersint
Event Counters
event.rich_media_event_idint
Rich Media Event ID
event.rich_media_event_timersdouble
Event Timers
event.rich_media_event_type_idint
Rich Media Event Type ID
event.segment_value_1int
Segment Value 1
event.site_idint
Site ID (Campaign Manager)
event.statestring
State/Region
event.tran_valuestring
TRAN Value
event.u_valuestring
U Value
event.zip_codestring
Zip Code
is_in_rdid_projectboolean
True if this event is also in the _rdid table. Used for deduplication of events.
network_idint
The network ID.
user_idstring
User ID

Campaign Manager Data Transfer creative

cm_dt_creative
account_idint
Unique ID of the account.
advertiser_idint
Unique ID of the advertiser.
creativestring
Creative Name as entered into the Campaign Manager interface.
creative_idint
The Creative ID in Campaign Manager UI.
creative_image_urlstring
Location of creative image (Does not apply to rich media).
creative_last_modified_dateint
Unix epoch timestamp (milliseconds) of the last time this creative was modified.
creative_sizestring
The creative size in pixels: width x height. Empty size is represented by "0X0".
creative_typestring
The type of creative.
creative_type_idint
creative_versionint
Used for change management to capture different versions
floodlight_config_idint
Unique ID of the floodlight configuration.
rendering_idint
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_idint
Unique ID of the account.
ad_click_urlstring
Click through URL of Click Ad type creatives only (aka Click Commands)
ad_idint
Unique ID of the ad.
advertiser_idint
Unique ID of the advertiser.
creative_end_dateint
Rotation end date and time in milliseconds since 1970-01-01 00:00:00 UTC.
creative_group1string
User defined value from creative group 1.
creative_group1_idint
Unique ID of creative group 1.
creative_group2string
User defined value from creative group 2.
creative_group2_idint
Unique ID of creative group 2.
creative_idint
The Creative ID in Campaign Manager UI.
creative_rotation_typestring
Rotation type.
creative_rotation_type_idint
Id of the rotation type.
creative_start_dateint
Rotation start date and time in Unix epoch time (milliseconds).
floodlight_config_idint
Unique ID of the floodlight configuration.

Campaign Manager Data Transfer custom creative field

cm_dt_custom_creative_field
account_idint
Unique ID of the account.
advertiser_idint
Unique ID of the advertiser.
creative_field_idint
The Creative ID in Campaign Manager UI.
creative_field_namestring
User defined name associated to a particular custom creative field.
creative_field_numberint
Slot ID assigned to this custom creative field (typically IDs from 1-20).
creative_field_valuestring
User defined value as available option to named field.
creative_field_value_idint
ID of the user defined creative value.
creative_idint
The Creative ID in Campaign Manager UI.
floodlight_config_idint
Unique ID of the floodlight configuration.

Campaign Manager Data Transfer custom floodlight variable

cm_dt_custom_floodlight_variable
account_idint
Unique ID of the account.
advertiser_idint
Unique ID of the advertiser.
floodlight_config_idint
Unique ID of the floodlight configuration.
floodlight_variable_idint
Unique ID of the floodlight variable.
floodlight_variable_namestring
User defined name of the custom floodlight variable.

Campaign Manager Data Transfer custom rich media

cm_dt_custom_rich_media
account_idint
Unique ID of the account.
advertiser_idint
Unique ID of the advertiser.
floodlight_config_idint
Unique ID of the floodlight configuration.
rich_media_event_idint
ID of the rich media event.
rich_media_event_namestring
Name of the rich media event.
rich_media_event_typestring
Possible values are: "Timer", "Exit", or "Counter".
rich_media_event_type_idint
ID of the rich media event type.

Campaign Manager Data Transfer designated market area

cm_dt_designated_market_area
dma_regionstring
dma_region_idint

Campaign Manager Data Transfer events

cm_dt_events
device_id_md5string
MD5-hashed device ID; a utility may be provided to hash raw device IDs to match.
eventstruct
event.active_view_audible_impressionsint
Active View: Impressions Audible
event.active_view_audible_time_msecint
Active View: Play Time Audible (Seconds)
event.active_view_audible_visible_time_msecint
Active View: Play Time Audible and Visible (Seconds)
event.active_view_background_countint
Active View: Impressions In Background
event.active_view_complete_viewable_impressionsint
Active View: Impressions Visible at Completion
event.active_view_eligible_impressionsint
Active View: Eligible Impressions
event.active_view_first_quartile_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at First Quartile
event.active_view_first_quartile_viewable_impressionsint
Active View: Impressions Visible at First Quartile
event.active_view_fullscreen_countint
Active View: Impressions Full-Screen
event.active_view_impressions_audible_and_visible_at_completionint
Active View: Impressions Audible and Visible at Completion
event.active_view_impressions_visible10_secondsint
Active View: Impressions Visible 10 Seconds
event.active_view_measurable_impressionsint
Active View: Measurable Impressions
event.active_view_midpoint_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Midpoint
event.active_view_midpoint_viewable_impressionsint
Active View: Impressions Visible at Midpoint
event.active_view_plus_measurable_countint
Active View Plus: Measurable Impressions
event.active_view_start_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Start
event.active_view_start_viewable_impressionsint
Active View: Impressions Visible at Start
event.active_view_third_quartile_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Third Quartile
event.active_view_third_quartile_viewable_impressionsint
Active View: Impressions Visible at Third Quartile
event.active_view_tos_msecint
Active View: Time on Screen (Seconds)
event.active_view_viewable_impressionsint
Active View: Viewable Impressions
event.active_view_visible_time_msecint
Active View: Video Visible Time (Seconds)
event.activity_countint
Activity Quantity
event.activity_idint
Activity ID
event.activity_revenuedouble
Activity Revenue
event.ad_idint
Ad ID
event.advertiser_idint
Advertiser ID
event.audience_segment_idint
event.browser_platform_idstring
Browser/Platform ID
event.browser_versionstring
Browser/Platform Version
event.campaign_idint
Campaign ID
event.city_idint
City ID
event.conversion_idint
Conversion ID
event.country_codestring
Country
event.creative_versionstring
Creative Version
event.dma_region_idint
Designated Market Area (DMA) ID
event.dv360_ad_positionint
DV360 Ad Position
event.dv360_advertiser_idint
DV360 Advertiser ID
event.dv360_adx_page_categoriesstring
DV360 Adx Page Categories
event.dv360_attributed_inventory_source_external_idstring
DV360 Attributed Inventory Source External ID
event.dv360_attributed_inventory_source_is_publicstring
DV360 Attributed Inventory Source Is Public
event.dv360_auction_idstring
DV360 Auction ID
event.dv360_bid_price_advertiser_currencyint
DV360 Bid Price (Advertiser Currency)
event.dv360_bid_price_partner_currencyint
DV360 Bid Price (Partner Currency)
event.dv360_bid_price_usdint
DV360 Bid Price (USD)
event.dv360_billable_cost_advertiser_currencyint
DV360 Billable Cost (Advertiser Currency)
event.dv360_billable_cost_partner_currencyint
DV360 Billable Cost (Partner Currency)
event.dv360_billable_cost_usdint
DV360 Billable Cost (USD)
event.dv360_browser_idint
DV360 Browser/Platform ID
event.dv360_browser_timezone_offset_minutesint
DV360 Browser Timezone Offset Minutes
event.dv360_campaign_idint
DV360 Campaign ID
event.dv360_city_idint
DV360 City ID
event.dv360_country_codestring
DV360 Country Code
event.dv360_cpm_fee_1_advertiser_currencyint
event.dv360_cpm_fee_1_partner_currencyint
event.dv360_cpm_fee_1_usdint
event.dv360_cpm_fee_2_advertiser_currencyint
event.dv360_cpm_fee_2_partner_currencyint
event.dv360_cpm_fee_2_usdint
event.dv360_cpm_fee_3_advertiser_currencyint
event.dv360_cpm_fee_3_partner_currencyint
event.dv360_cpm_fee_3_usdint
event.dv360_cpm_fee_4_advertiser_currencyint
event.dv360_cpm_fee_4_partner_currencyint
event.dv360_cpm_fee_4_usdint
event.dv360_cpm_fee_5_advertiser_currencyint
event.dv360_cpm_fee_5_partner_currencyint
event.dv360_cpm_fee_5_usdint
event.dv360_creative_idint
DV360 Creative ID
event.dv360_data_fees_advertiser_currencyint
event.dv360_data_fees_partner_currencyint
event.dv360_data_fees_usdint
event.dv360_device_typeint
DV360 Device Type
event.dv360_exchange_idstring
DV360 Exchange ID
event.dv360_insertion_order_idint
DV360 Insertion Order ID
event.dv360_isp_idint
DV360 ISP ID
event.dv360_languagestring
DV360 Language
event.dv360_line_item_idint
DV360 Line Item ID
event.dv360_matching_targeted_keywordsstring
DV360 Matching Targeted Keywords
event.dv360_matching_targeted_segmentsstring
DV360 Matching Targeted Segments
event.dv360_media_cost_advertiser_currencyint
DV360 Media Cost (Advertiser Currency)
event.dv360_media_cost_partner_currencyint
DV360 Media Cost (Partner Currency)
event.dv360_media_cost_usdint
DV360 Media Cost (USD)
event.dv360_media_fee_1_advertiser_currencyint
event.dv360_media_fee_1_partner_currencyint
event.dv360_media_fee_1_usdint
event.dv360_media_fee_2_advertiser_currencyint
event.dv360_media_fee_2_partner_currencyint
event.dv360_media_fee_2_usdint
event.dv360_media_fee_3_advertiser_currencyint
event.dv360_media_fee_3_partner_currencyint
event.dv360_media_fee_3_usdint
event.dv360_media_fee_4_advertiser_currencyint
event.dv360_media_fee_4_partner_currencyint
event.dv360_media_fee_4_usdint
event.dv360_media_fee_5_advertiser_currencyint
event.dv360_media_fee_5_partner_currencyint
event.dv360_media_fee_5_usdint
event.dv360_mobile_make_idint
DV360 Mobile Make ID
event.dv360_mobile_model_idint
DV360 Mobile Model ID
event.dv360_net_speedint
DV360 Net Speed
event.dv360_operating_system_idint
event.dv360_request_timeint
DV360 Request Time
event.dv360_revenue_advertiser_currencyint
DV360 Revenue (Advertiser Currency)
event.dv360_revenue_partner_currencyint
DV360 Revenue (Partner Currency)
event.dv360_revenue_usdint
DV360 Revenue (USD)
event.dv360_site_idint
DV360 Site ID
event.dv360_state_region_idint
DV360 Region ID
event.dv360_urlstring
DV360 URL
event.dv360_view_statestring
DV360 View State
event.dv360_zip_postal_codestring
DV360 ZIP/Postal Code
event.event_sub_typestring
Event Sub-Type
event.event_timeint
Event Time
event.event_typestring
Event Type
event.floodlight_config_idint
Floodlight Configuration
event.impression_idstring
Impression ID
event.interaction_time_utc_secondsstring
Interaction Time
event.landing_page_url_idint
Landing Page URL ID
event.operating_system_idint
Operating System ID
event.ord_valuestring
ORD Value
event.other_datastring
Other Data
event.placement_idint
Placement ID
event.platform_type_idint
event.referrer_urlstring
Referrer URL
event.rendering_idint
Rendering ID
event.rich_media_event_countersint
Event Counters
event.rich_media_event_idint
Rich Media Event ID
event.rich_media_event_timersdouble
Event Timers
event.rich_media_event_type_idint
Rich Media Event Type ID
event.segment_value_1int
Segment Value 1
event.site_idint
Site ID (Campaign Manager)
event.statestring
State/Region
event.tran_valuestring
TRAN Value
event.u_valuestring
U Value
event.zip_codestring
Zip Code
is_in_rdid_projectboolean
True if this event is also in the _rdid table. Used for deduplication of events.
network_idint
The network ID.
user_idstring
User ID

Campaign Manager Data Transfer floodlight

cm_dt_floodlight
device_id_md5string
MD5-hashed device ID. Utility will be provided to hash raw device IDs to match.
eventstruct
event.active_view_audible_impressionsint
Active View: Impressions Audible
event.active_view_audible_time_msecint
Active View: Play Time Audible (Seconds)
event.active_view_audible_visible_time_msecint
Active View: Play Time Audible and Visible (Seconds)
event.active_view_background_countint
Active View: Impressions In Background
event.active_view_complete_viewable_impressionsint
Active View: Impressions Visible at Completion
event.active_view_eligible_impressionsint
Active View: Eligible Impressions
event.active_view_first_quartile_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at First Quartile
event.active_view_first_quartile_viewable_impressionsint
Active View: Impressions Visible at First Quartile
event.active_view_fullscreen_countint
Active View: Impressions Full-Screen
event.active_view_impressions_audible_and_visible_at_completionint
Active View: Impressions Audible and Visible at Completion
event.active_view_impressions_visible10_secondsint
Active View: Impressions Visible 10 Seconds
event.active_view_measurable_impressionsint
Active View: Measurable Impressions
event.active_view_midpoint_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Midpoint
event.active_view_midpoint_viewable_impressionsint
Active View: Impressions Visible at Midpoint
event.active_view_plus_measurable_countint
Active View Plus: Measurable Impressions
event.active_view_start_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Start
event.active_view_start_viewable_impressionsint
Active View: Impressions Visible at Start
event.active_view_third_quartile_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Third Quartile
event.active_view_third_quartile_viewable_impressionsint
Active View: Impressions Visible at Third Quartile
event.active_view_tos_msecint
Active View: Time on Screen (Seconds)
event.active_view_viewable_impressionsint
Active View: Viewable Impressions
event.active_view_visible_time_msecint
Active View: Video Visible Time (Seconds)
event.activity_countint
Activity Quantity
event.activity_idint
Activity ID
event.activity_revenuedouble
Activity Revenue
event.ad_idint
Ad ID
event.advertiser_idint
Advertiser ID
event.audience_segment_idint
event.browser_platform_idstring
Browser/Platform ID
event.browser_versionstring
Browser/Platform Version
event.campaign_idint
Campaign ID
event.city_idint
City ID
event.conversion_idint
Conversion ID
event.country_codestring
Country
event.creative_versionstring
Creative Version
event.dma_region_idint
Designated Market Area (DMA) ID
event.dv360_ad_positionint
DV360 Ad Position
event.dv360_advertiser_idint
DV360 Advertiser ID
event.dv360_adx_page_categoriesstring
DV360 Adx Page Categories
event.dv360_attributed_inventory_source_external_idstring
DV360 Attributed Inventory Source External ID
event.dv360_attributed_inventory_source_is_publicstring
DV360 Attributed Inventory Source Is Public
event.dv360_auction_idstring
DV360 Auction ID
event.dv360_bid_price_advertiser_currencyint
DV360 Bid Price (Advertiser Currency)
event.dv360_bid_price_partner_currencyint
DV360 Bid Price (Partner Currency)
event.dv360_bid_price_usdint
DV360 Bid Price (USD)
event.dv360_billable_cost_advertiser_currencyint
DV360 Billable Cost (Advertiser Currency)
event.dv360_billable_cost_partner_currencyint
DV360 Billable Cost (Partner Currency)
event.dv360_billable_cost_usdint
DV360 Billable Cost (USD)
event.dv360_browser_idint
DV360 Browser/Platform ID
event.dv360_browser_timezone_offset_minutesint
DV360 Browser Timezone Offset Minutes
event.dv360_campaign_idint
DV360 Campaign ID
event.dv360_city_idint
DV360 City ID
event.dv360_country_codestring
DV360 Country Code
event.dv360_cpm_fee_1_advertiser_currencyint
event.dv360_cpm_fee_1_partner_currencyint
event.dv360_cpm_fee_1_usdint
event.dv360_cpm_fee_2_advertiser_currencyint
event.dv360_cpm_fee_2_partner_currencyint
event.dv360_cpm_fee_2_usdint
event.dv360_cpm_fee_3_advertiser_currencyint
event.dv360_cpm_fee_3_partner_currencyint
event.dv360_cpm_fee_3_usdint
event.dv360_cpm_fee_4_advertiser_currencyint
event.dv360_cpm_fee_4_partner_currencyint
event.dv360_cpm_fee_4_usdint
event.dv360_cpm_fee_5_advertiser_currencyint
event.dv360_cpm_fee_5_partner_currencyint
event.dv360_cpm_fee_5_usdint
event.dv360_creative_idint
DV360 Creative ID
event.dv360_data_fees_advertiser_currencyint
event.dv360_data_fees_partner_currencyint
event.dv360_data_fees_usdint
event.dv360_device_typeint
DV360 Device Type
event.dv360_exchange_idstring
DV360 Exchange ID
event.dv360_insertion_order_idint
DV360 Insertion Order ID
event.dv360_isp_idint
DV360 ISP ID
event.dv360_languagestring
DV360 Language
event.dv360_line_item_idint
DV360 Line Item ID
event.dv360_matching_targeted_keywordsstring
DV360 Matching Targeted Keywords
event.dv360_matching_targeted_segmentsstring
DV360 Matching Targeted Segments
event.dv360_media_cost_advertiser_currencyint
DV360 Media Cost (Advertiser Currency)
event.dv360_media_cost_partner_currencyint
DV360 Media Cost (Partner Currency)
event.dv360_media_cost_usdint
DV360 Media Cost (USD)
event.dv360_media_fee_1_advertiser_currencyint
event.dv360_media_fee_1_partner_currencyint
event.dv360_media_fee_1_usdint
event.dv360_media_fee_2_advertiser_currencyint
event.dv360_media_fee_2_partner_currencyint
event.dv360_media_fee_2_usdint
event.dv360_media_fee_3_advertiser_currencyint
event.dv360_media_fee_3_partner_currencyint
event.dv360_media_fee_3_usdint
event.dv360_media_fee_4_advertiser_currencyint
event.dv360_media_fee_4_partner_currencyint
event.dv360_media_fee_4_usdint
event.dv360_media_fee_5_advertiser_currencyint
event.dv360_media_fee_5_partner_currencyint
event.dv360_media_fee_5_usdint
event.dv360_mobile_make_idint
DV360 Mobile Make ID
event.dv360_mobile_model_idint
DV360 Mobile Model ID
event.dv360_net_speedint
DV360 Net Speed
event.dv360_operating_system_idint
event.dv360_request_timeint
DV360 Request Time
event.dv360_revenue_advertiser_currencyint
DV360 Revenue (Advertiser Currency)
event.dv360_revenue_partner_currencyint
DV360 Revenue (Partner Currency)
event.dv360_revenue_usdint
DV360 Revenue (USD)
event.dv360_site_idint
DV360 Site ID
event.dv360_state_region_idint
DV360 Region ID
event.dv360_urlstring
DV360 URL
event.dv360_view_statestring
DV360 View State
event.dv360_zip_postal_codestring
DV360 ZIP/Postal Code
event.event_sub_typestring
Event Sub-Type
event.event_timeint
Event Time
event.event_typestring
Event Type
event.floodlight_config_idint
Floodlight Configuration
event.impression_idstring
Impression ID
event.interaction_time_utc_secondsstring
Interaction Time
event.landing_page_url_idint
Landing Page URL ID
event.operating_system_idint
Operating System ID
event.ord_valuestring
ORD Value
event.other_datastring
Other Data
event.placement_idint
Placement ID
event.platform_type_idint
event.referrer_urlstring
Referrer URL
event.rendering_idint
Rendering ID
event.rich_media_event_countersint
Event Counters
event.rich_media_event_idint
Rich Media Event ID
event.rich_media_event_timersdouble
Event Timers
event.rich_media_event_type_idint
Rich Media Event Type ID
event.segment_value_1int
Segment Value 1
event.site_idint
Site ID (Campaign Manager)
event.statestring
State/Region
event.tran_valuestring
TRAN Value
event.u_valuestring
U Value
event.zip_codestring
Zip Code
is_in_rdid_projectboolean
True if this event is also in the _rdid table. Used for deduplication of events.
network_idint
The network ID.
user_idstring
User ID

Campaign Manager Data Transfer impressions

cm_dt_impressions
device_id_md5string
MD5-hashed device ID. Utility will be provided to hash raw device IDs to match.
eventstruct
event.active_view_audible_impressionsint
Active View: Impressions Audible
event.active_view_audible_time_msecint
Active View: Play Time Audible (Seconds)
event.active_view_audible_visible_time_msecint
Active View: Play Time Audible and Visible (Seconds)
event.active_view_background_countint
Active View: Impressions In Background
event.active_view_complete_viewable_impressionsint
Active View: Impressions Visible at Completion
event.active_view_eligible_impressionsint
Active View: Eligible Impressions
event.active_view_first_quartile_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at First Quartile
event.active_view_first_quartile_viewable_impressionsint
Active View: Impressions Visible at First Quartile
event.active_view_fullscreen_countint
Active View: Impressions Full-Screen
event.active_view_impressions_audible_and_visible_at_completionint
Active View: Impressions Audible and Visible at Completion
event.active_view_impressions_visible10_secondsint
Active View: Impressions Visible 10 Seconds
event.active_view_measurable_impressionsint
Active View: Measurable Impressions
event.active_view_midpoint_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Midpoint
event.active_view_midpoint_viewable_impressionsint
Active View: Impressions Visible at Midpoint
event.active_view_plus_measurable_countint
Active View Plus: Measurable Impressions
event.active_view_start_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Start
event.active_view_start_viewable_impressionsint
Active View: Impressions Visible at Start
event.active_view_third_quartile_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Third Quartile
event.active_view_third_quartile_viewable_impressionsint
Active View: Impressions Visible at Third Quartile
event.active_view_tos_msecint
Active View: Time on Screen (Seconds)
event.active_view_viewable_impressionsint
Active View: Viewable Impressions
event.active_view_visible_time_msecint
Active View: Video Visible Time (Seconds)
event.activity_countint
Activity Quantity
event.activity_idint
Activity ID
event.activity_revenuedouble
Activity Revenue
event.ad_idint
Ad ID
event.advertiser_idint
Advertiser ID
event.audience_segment_idint
event.browser_platform_idstring
Browser/Platform ID
event.browser_versionstring
Browser/Platform Version
event.campaign_idint
Campaign ID
event.city_idint
City ID
event.conversion_idint
Conversion ID
event.country_codestring
Country
event.creative_versionstring
Creative Version
event.dma_region_idint
Designated Market Area (DMA) ID
event.dv360_ad_positionint
DV360 Ad Position
event.dv360_advertiser_idint
DV360 Advertiser ID
event.dv360_adx_page_categoriesstring
DV360 Adx Page Categories
event.dv360_attributed_inventory_source_external_idstring
DV360 Attributed Inventory Source External ID
event.dv360_attributed_inventory_source_is_publicstring
DV360 Attributed Inventory Source Is Public
event.dv360_auction_idstring
DV360 Auction ID
event.dv360_bid_price_advertiser_currencyint
DV360 Bid Price (Advertiser Currency)
event.dv360_bid_price_partner_currencyint
DV360 Bid Price (Partner Currency)
event.dv360_bid_price_usdint
DV360 Bid Price (USD)
event.dv360_billable_cost_advertiser_currencyint
DV360 Billable Cost (Advertiser Currency)
event.dv360_billable_cost_partner_currencyint
DV360 Billable Cost (Partner Currency)
event.dv360_billable_cost_usdint
DV360 Billable Cost (USD)
event.dv360_browser_idint
DV360 Browser/Platform ID
event.dv360_browser_timezone_offset_minutesint
DV360 Browser Timezone Offset Minutes
event.dv360_campaign_idint
DV360 Campaign ID
event.dv360_city_idint
DV360 City ID
event.dv360_country_codestring
DV360 Country Code
event.dv360_cpm_fee_1_advertiser_currencyint
event.dv360_cpm_fee_1_partner_currencyint
event.dv360_cpm_fee_1_usdint
event.dv360_cpm_fee_2_advertiser_currencyint
event.dv360_cpm_fee_2_partner_currencyint
event.dv360_cpm_fee_2_usdint
event.dv360_cpm_fee_3_advertiser_currencyint
event.dv360_cpm_fee_3_partner_currencyint
event.dv360_cpm_fee_3_usdint
event.dv360_cpm_fee_4_advertiser_currencyint
event.dv360_cpm_fee_4_partner_currencyint
event.dv360_cpm_fee_4_usdint
event.dv360_cpm_fee_5_advertiser_currencyint
event.dv360_cpm_fee_5_partner_currencyint
event.dv360_cpm_fee_5_usdint
event.dv360_creative_idint
DV360 Creative ID
event.dv360_data_fees_advertiser_currencyint
event.dv360_data_fees_partner_currencyint
event.dv360_data_fees_usdint
event.dv360_device_typeint
DV360 Device Type
event.dv360_exchange_idstring
DV360 Exchange ID
event.dv360_insertion_order_idint
DV360 Insertion Order ID
event.dv360_isp_idint
DV360 ISP ID
event.dv360_languagestring
DV360 Language
event.dv360_line_item_idint
DV360 Line Item ID
event.dv360_matching_targeted_keywordsstring
DV360 Matching Targeted Keywords
event.dv360_matching_targeted_segmentsstring
DV360 Matching Targeted Segments
event.dv360_media_cost_advertiser_currencyint
DV360 Media Cost (Advertiser Currency)
event.dv360_media_cost_partner_currencyint
DV360 Media Cost (Partner Currency)
event.dv360_media_cost_usdint
DV360 Media Cost (USD)
event.dv360_media_fee_1_advertiser_currencyint
event.dv360_media_fee_1_partner_currencyint
event.dv360_media_fee_1_usdint
event.dv360_media_fee_2_advertiser_currencyint
event.dv360_media_fee_2_partner_currencyint
event.dv360_media_fee_2_usdint
event.dv360_media_fee_3_advertiser_currencyint
event.dv360_media_fee_3_partner_currencyint
event.dv360_media_fee_3_usdint
event.dv360_media_fee_4_advertiser_currencyint
event.dv360_media_fee_4_partner_currencyint
event.dv360_media_fee_4_usdint
event.dv360_media_fee_5_advertiser_currencyint
event.dv360_media_fee_5_partner_currencyint
event.dv360_media_fee_5_usdint
event.dv360_mobile_make_idint
DV360 Mobile Make ID
event.dv360_mobile_model_idint
DV360 Mobile Model ID
event.dv360_net_speedint
DV360 Net Speed
event.dv360_operating_system_idint
event.dv360_request_timeint
DV360 Request Time
event.dv360_revenue_advertiser_currencyint
DV360 Revenue (Advertiser Currency)
event.dv360_revenue_partner_currencyint
DV360 Revenue (Partner Currency)
event.dv360_revenue_usdint
DV360 Revenue (USD)
event.dv360_site_idint
DV360 Site ID
event.dv360_state_region_idint
DV360 Region ID
event.dv360_urlstring
DV360 URL
event.dv360_view_statestring
DV360 View State
event.dv360_zip_postal_codestring
DV360 ZIP/Postal Code
event.event_sub_typestring
Event Sub-Type
event.event_timeint
Event Time
event.event_typestring
Event Type
event.floodlight_config_idint
Floodlight Configuration
event.impression_idstring
Impression ID
event.interaction_time_utc_secondsstring
Interaction Time
event.landing_page_url_idint
Landing Page URL ID
event.operating_system_idint
Operating System ID
event.ord_valuestring
ORD Value
event.other_datastring
Other Data
event.placement_idint
Placement ID
event.platform_type_idint
event.referrer_urlstring
Referrer URL
event.rendering_idint
Rendering ID
event.rich_media_event_countersint
Event Counters
event.rich_media_event_idint
Rich Media Event ID
event.rich_media_event_timersdouble
Event Timers
event.rich_media_event_type_idint
Rich Media Event Type ID
event.segment_value_1int
Segment Value 1
event.site_idint
Site ID (Campaign Manager)
event.statestring
State/Region
event.tran_valuestring
TRAN Value
event.u_valuestring
U Value
event.zip_codestring
Zip Code
is_in_rdid_projectboolean
True if this event is also in the _rdid table. Used for deduplication of events.
network_idint
The network ID.
user_idstring
User ID

Campaign Manager Data Transfer keyword value

cm_dt_keyword_value
account_idint
Unique ID of the account.
ad_idint
Unique ID of the ad.
advertiser_idint
Unique ID of the advertiser.
floodlight_config_idint
Unique ID of the floodlight configuration.
keywordstring
Targeted key/value pair.

Campaign Manager Data Transfer landing page url

cm_dt_landing_page_url
account_idint
Unique ID of the account.
landing_page_urlstring
The URL a user was sent to when they clicked on an ad.
landing_page_url_idint
Unique ID of the landing page URL.

Campaign Manager Data Transfer operating system

cm_dt_operating_system
operating_systemstring
operating_system_idint
Unique ID of OS just for Data Transfer.

Campaign Manager Data Transfer paid search

cm_dt_paid_search
ad_idint
Unique ID of the ad.
advertiser_idint
Unique ID of the advertiser.
campaign_idint
Unique ID of the campaign.
floodlight_config_idint
Unique ID of the floodlight configuration.
paid_search_ad_groupstring
User defined keyword group.
paid_search_ad_group_idint
Unique ID of the keyword group.
paid_search_ad_idint
Unique ID associated with a Search Ads 360 ad.
paid_search_bid_strategystring
User defined keyword bid strategy. Returns a value of "(not set)" if empty.
paid_search_bid_strategy_idint
ID of the keyword bid strategy.
paid_search_campaignstring
User defined name of campaign as entered into Search Ads 360.
paid_search_campaign_idint
ID of the Search Ads 360 campaign.
paid_search_keywordstring
User defined keyword value as entered into Search Ads 360.
paid_search_keyword_idint
Unique ID from Search Ads 360. Uses the “long” format
paid_search_landing_page_urlstring
User defined landing page URL as entered into Search Ads 360.
paid_search_legacy_keyword_idint
Unique ID from Search Ads 360. Uses the "short" format in which the leading 43* is removed.
paid_search_match_typestring
User selected

Campaign Manager Data Transfer placement

cm_dt_placement
account_idint
Unique ID of the account.
activity_idint
Unique ID of the Floodlight activity.
advertiser_idint
Unique ID of the advertiser.
campaign_idint
Unique ID of the campaign.
content_categorystring
User defined content category.
content_category_idint
ID of content category.
flighting_activatedboolean
Indicates whether this is a flighted (billing) placement.
floodlight_config_idint
Unique ID of the floodlight configuration.
package_roadblock_idint
package_roadblock_typestring
package_roadblock_type_idint
placementstring
placement_cap_cost_optionint
User entered cost capping amount.
placement_cost_structurestring
placement_end_dateint
End date of the flight in 'YYYYMMDD' format.
placement_idint
placement_start_dateint
Start date of the flight in 'YYYYMMDD' format.
placement_strategystring
User defined placement strategy.
placement_strategy_idint
ID of the placement strategy.
site_idint
Unique ID of the site.
site_keynamestring

Campaign Manager Data Transfer placement cost

cm_dt_placement_cost
account_idint
Unique ID of the account.
advertiser_idint
Unique ID of the advertiser.
floodlight_config_idint
Unique ID of the floodlight configuration.
placement_commentsstring
User entered placement pricing comments.
placement_end_dateint
End date of the flight in 'YYYYMMDD' format.
placement_idint
Placement ID
placement_rateint
Purchased rate expressed in nanos of the network's currency. 1 nano = 1 billionth. 1 nano USD = $0.000000001.
placement_start_dateint
Start date of the flight in 'YYYYMMDD' format.
placement_total_booked_unitsint
The number of purchased units.

Campaign Manager Data Transfer rich media

cm_dt_rich_media
device_id_md5string
MD5-hashed device ID; a utility may be provided to hash raw device IDs to match.
eventstruct
event.active_view_audible_impressionsint
Active View: Impressions Audible
event.active_view_audible_time_msecint
Active View: Play Time Audible (Seconds)
event.active_view_audible_visible_time_msecint
Active View: Play Time Audible and Visible (Seconds)
event.active_view_background_countint
Active View: Impressions In Background
event.active_view_complete_viewable_impressionsint
Active View: Impressions Visible at Completion
event.active_view_eligible_impressionsint
Active View: Eligible Impressions
event.active_view_first_quartile_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at First Quartile
event.active_view_first_quartile_viewable_impressionsint
Active View: Impressions Visible at First Quartile
event.active_view_fullscreen_countint
Active View: Impressions Full-Screen
event.active_view_impressions_audible_and_visible_at_completionint
Active View: Impressions Audible and Visible at Completion
event.active_view_impressions_visible10_secondsint
Active View: Impressions Visible 10 Seconds
event.active_view_measurable_impressionsint
Active View: Measurable Impressions
event.active_view_midpoint_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Midpoint
event.active_view_midpoint_viewable_impressionsint
Active View: Impressions Visible at Midpoint
event.active_view_plus_measurable_countint
Active View Plus: Measurable Impressions
event.active_view_start_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Start
event.active_view_start_viewable_impressionsint
Active View: Impressions Visible at Start
event.active_view_third_quartile_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Third Quartile
event.active_view_third_quartile_viewable_impressionsint
Active View: Impressions Visible at Third Quartile
event.active_view_tos_msecint
Active View: Time on Screen (Seconds)
event.active_view_viewable_impressionsint
Active View: Viewable Impressions
event.active_view_visible_time_msecint
Active View: Video Visible Time (Seconds)
event.activity_countint
Activity Quantity
event.activity_idint
Activity ID
event.activity_revenuedouble
Activity Revenue
event.ad_idint
Ad ID
event.advertiser_idint
Advertiser ID
event.audience_segment_idint
event.browser_platform_idstring
Browser/Platform ID
event.browser_versionstring
Browser/Platform Version
event.campaign_idint
Campaign ID
event.city_idint
City ID
event.conversion_idint
Conversion ID
event.country_codestring
Country
event.creative_versionstring
Creative Version
event.dma_region_idint
Designated Market Area (DMA) ID
event.dv360_ad_positionint
DV360 Ad Position
event.dv360_advertiser_idint
DV360 Advertiser ID
event.dv360_adx_page_categoriesstring
DV360 Adx Page Categories
event.dv360_attributed_inventory_source_external_idstring
DV360 Attributed Inventory Source External ID
event.dv360_attributed_inventory_source_is_publicstring
DV360 Attributed Inventory Source Is Public
event.dv360_auction_idstring
DV360 Auction ID
event.dv360_bid_price_advertiser_currencyint
DV360 Bid Price (Advertiser Currency)
event.dv360_bid_price_partner_currencyint
DV360 Bid Price (Partner Currency)
event.dv360_bid_price_usdint
DV360 Bid Price (USD)
event.dv360_billable_cost_advertiser_currencyint
DV360 Billable Cost (Advertiser Currency)
event.dv360_billable_cost_partner_currencyint
DV360 Billable Cost (Partner Currency)
event.dv360_billable_cost_usdint
DV360 Billable Cost (USD)
event.dv360_browser_idint
DV360 Browser/Platform ID
event.dv360_browser_timezone_offset_minutesint
DV360 Browser Timezone Offset Minutes
event.dv360_campaign_idint
DV360 Campaign ID
event.dv360_city_idint
DV360 City ID
event.dv360_country_codestring
DV360 Country Code
event.dv360_cpm_fee_1_advertiser_currencyint
event.dv360_cpm_fee_1_partner_currencyint
event.dv360_cpm_fee_1_usdint
event.dv360_cpm_fee_2_advertiser_currencyint
event.dv360_cpm_fee_2_partner_currencyint
event.dv360_cpm_fee_2_usdint
event.dv360_cpm_fee_3_advertiser_currencyint
event.dv360_cpm_fee_3_partner_currencyint
event.dv360_cpm_fee_3_usdint
event.dv360_cpm_fee_4_advertiser_currencyint
event.dv360_cpm_fee_4_partner_currencyint
event.dv360_cpm_fee_4_usdint
event.dv360_cpm_fee_5_advertiser_currencyint
event.dv360_cpm_fee_5_partner_currencyint
event.dv360_cpm_fee_5_usdint
event.dv360_creative_idint
DV360 Creative ID
event.dv360_data_fees_advertiser_currencyint
event.dv360_data_fees_partner_currencyint
event.dv360_data_fees_usdint
event.dv360_device_typeint
DV360 Device Type
event.dv360_exchange_idstring
DV360 Exchange ID
event.dv360_insertion_order_idint
DV360 Insertion Order ID
event.dv360_isp_idint
DV360 ISP ID
event.dv360_languagestring
DV360 Language
event.dv360_line_item_idint
DV360 Line Item ID
event.dv360_matching_targeted_keywordsstring
DV360 Matching Targeted Keywords
event.dv360_matching_targeted_segmentsstring
DV360 Matching Targeted Segments
event.dv360_media_cost_advertiser_currencyint
DV360 Media Cost (Advertiser Currency)
event.dv360_media_cost_partner_currencyint
DV360 Media Cost (Partner Currency)
event.dv360_media_cost_usdint
DV360 Media Cost (USD)
event.dv360_media_fee_1_advertiser_currencyint
event.dv360_media_fee_1_partner_currencyint
event.dv360_media_fee_1_usdint
event.dv360_media_fee_2_advertiser_currencyint
event.dv360_media_fee_2_partner_currencyint
event.dv360_media_fee_2_usdint
event.dv360_media_fee_3_advertiser_currencyint
event.dv360_media_fee_3_partner_currencyint
event.dv360_media_fee_3_usdint
event.dv360_media_fee_4_advertiser_currencyint
event.dv360_media_fee_4_partner_currencyint
event.dv360_media_fee_4_usdint
event.dv360_media_fee_5_advertiser_currencyint
event.dv360_media_fee_5_partner_currencyint
event.dv360_media_fee_5_usdint
event.dv360_mobile_make_idint
DV360 Mobile Make ID
event.dv360_mobile_model_idint
DV360 Mobile Model ID
event.dv360_net_speedint
DV360 Net Speed
event.dv360_operating_system_idint
event.dv360_request_timeint
DV360 Request Time
event.dv360_revenue_advertiser_currencyint
DV360 Revenue (Advertiser Currency)
event.dv360_revenue_partner_currencyint
DV360 Revenue (Partner Currency)
event.dv360_revenue_usdint
DV360 Revenue (USD)
event.dv360_site_idint
DV360 Site ID
event.dv360_state_region_idint
DV360 Region ID
event.dv360_urlstring
DV360 URL
event.dv360_view_statestring
DV360 View State
event.dv360_zip_postal_codestring
DV360 ZIP/Postal Code
event.event_sub_typestring
Event Sub-Type
event.event_timeint
Event Time
event.event_typestring
Event Type
event.floodlight_config_idint
Floodlight Configuration
event.impression_idstring
Impression ID
event.interaction_time_utc_secondsstring
Interaction Time
event.landing_page_url_idint
Landing Page URL ID
event.operating_system_idint
Operating System ID
event.ord_valuestring
ORD Value
event.other_datastring
Other Data
event.placement_idint
Placement ID
event.platform_type_idint
event.referrer_urlstring
Referrer URL
event.rendering_idint
Rendering ID
event.rich_media_event_countersint
Event Counters
event.rich_media_event_idint
Rich Media Event ID
event.rich_media_event_timersdouble
Event Timers
event.rich_media_event_type_idint
Rich Media Event Type ID
event.segment_value_1int
Segment Value 1
event.site_idint
Site ID (Campaign Manager)
event.statestring
State/Region
event.tran_valuestring
TRAN Value
event.u_valuestring
U Value
event.zip_codestring
Zip Code
is_in_rdid_projectboolean
True if this event is also in the _rdid table. Used for deduplication of events.
network_idint
The network ID.
user_idstring
User ID

Campaign Manager Data Transfer site

cm_dt_site
account_idint
Unique ID of the account.
sitestring
The name of the site.
site_directorystring
Global unique name for this site.
site_directory_idint
Global unique ID for this site.
site_idint
Unique ID of the site.

Campaign Manager Data Transfer state

cm_dt_state
regionstring
Abbreviated state/province name.
region_full_namestring
Region name in English.

Campaign Manager paths

cm_paths
cm_paths.user_idstring
User ID.
cm_paths.network_idint
The network ID.
cm_paths.partner_idint
Unique ID of the partner.
cm_paths.pathrecord
Row containing event path for a given user.
cm_paths.eventsrepeated struct
cm_paths.events.event_timeint
Event time
cm_paths.events.advertiser_idint
Advertiser ID
cm_paths.events.campaign_idint
Campaign ID
cm_paths.events.ad_idint
Ad ID
cm_paths.events.rendering_idint
Rendering ID
cm_paths.events.creative_versionstring
Creative version
cm_paths.events.site_idint
Site ID
cm_paths.events.country_codestring
Country code
cm_paths.events.statestring
State
cm_paths.events.browser_platform_idstring
Browser platform ID
cm_paths.events.browser_versionstring
Browser version
cm_paths.events.dma_region_idint
DMA region ID
cm_paths.events.city_idint
City ID
cm_paths.events.zip_codestring
Zip code
cm_paths.events.u_valuestring
U value
cm_paths.events.event_typestring
Event type
cm_paths.events.event_sub_typestring
Event sub type
cm_paths.events.dv360_auction_idstring
DV360 auction ID
cm_paths.events.dv360_request_timeint
DV360 request time
cm_paths.events.dv360_advertiser_idint
DV360 advertiser ID
cm_paths.events.dv360_insertion_order_idint
DV360 insertion order ID
cm_paths.events.dv360_line_item_idint
DV360 line item ID
cm_paths.events.dv360_creative_idint
DV360 creative ID
cm_paths.events.dv360_bid_price_usdint
DV360 bid price usd
cm_paths.events.dv360_bid_price_partner_currencyint
DV360 bid price partner currency
cm_paths.events.dv360_bid_price_advertiser_currencyint
DV360 bid price advertiser currency
cm_paths.events.dv360_urlstring
DV360 url
cm_paths.events.dv360_site_idint
DV360 site ID
cm_paths.events.dv360_languagestring
DV360 language
cm_paths.events.dv360_adx_page_categoriesstring
DV360 Ad Exchange page categories
cm_paths.events.dv360_matching_targeted_keywordsstring
DV360 matching targeted keywords
cm_paths.events.dv360_exchange_idstring
DV360 exchange ID
cm_paths.events.dv360_attributed_inventory_source_external_idstring
DV360 attributed inventory source external ID
cm_paths.events.dv360_attributed_inventory_source_is_publicstring
DV360 attributed inventory source is public
cm_paths.events.dv360_ad_positionint
DV360 ad position
cm_paths.events.dv360_country_codestring
DV360 country code
cm_paths.events.dv360_zip_postal_codestring
DV360 zip postal code
cm_paths.events.dv360_browser_timezone_offset_minutesint
DV360 browser timezone offset minutes
cm_paths.events.dv360_net_speedint
DV360 net speed
cm_paths.events.dv360_matching_targeted_segmentsstring
DV360 matching targeted segments
cm_paths.events.dv360_isp_idint
DV360 isp ID
cm_paths.events.dv360_device_typeint
DV360 device type
cm_paths.events.dv360_mobile_model_idint
DV360 mobile model ID
cm_paths.events.placement_idint
Placement ID
cm_paths.events.operating_system_idint
Operating system ID
cm_paths.events.segment_value_1int
Segment value 1
cm_paths.events.dv360_state_region_idint
DV360 state region ID
cm_paths.events.dv360_city_idint
DV360 city ID
cm_paths.events.dv360_browser_idint
DV360 browser ID
cm_paths.events.activity_idint
Activity ID
cm_paths.events.ord_valuestring
Ord value
cm_paths.events.conversion_idint
Conversion ID
cm_paths.events.floodlight_config_idint
Floodlight configuration ID
cm_paths.events.interaction_time_utc_secondsstring
Interaction time utc seconds
cm_paths.events.rich_media_event_idint
Rich media event ID
cm_paths.events.rich_media_event_type_idint
Rich media event type ID
cm_paths.events.impression_idstring
Impression ID
cm_paths.events.other_datastring
Other data
cm_paths.events.referrer_urlstring
Referrer url
cm_paths.events.tran_valuestring
Tran value
cm_paths.events.dv360_view_statestring
DV360 view state
cm_paths.events.landing_page_url_idint
Landing page url ID
cm_paths.events.audience_segment_idint
Audience segment ID
cm_paths.events.dv360_media_cost_usdint
DV360 media cost usd
cm_paths.events.dv360_media_cost_partner_currencyint
DV360 media cost partner currency
cm_paths.events.dv360_media_cost_advertiser_currencyint
DV360 media cost advertiser currency
cm_paths.events.dv360_revenue_usdint
DV360 revenue usd
cm_paths.events.dv360_revenue_partner_currencyint
DV360 revenue partner currency
cm_paths.events.dv360_revenue_advertiser_currencyint
DV360 revenue advertiser currency
cm_paths.events.dv360_cpm_fee_1_usdint
DV360 CPM fee 1 usd
cm_paths.events.dv360_cpm_fee_1_partner_currencyint
DV360 CPM fee 1 partner currency
cm_paths.events.dv360_cpm_fee_1_advertiser_currencyint
DV360 CPM fee 1 advertiser currency
cm_paths.events.dv360_cpm_fee_2_usdint
DV360 CPM fee 2 usd
cm_paths.events.dv360_cpm_fee_2_partner_currencyint
DV360 CPM fee 2 partner currency
cm_paths.events.dv360_cpm_fee_2_advertiser_currencyint
DV360 CPM fee 2 advertiser currency
cm_paths.events.dv360_cpm_fee_3_usdint
DV360 CPM fee 3 usd
cm_paths.events.dv360_cpm_fee_3_partner_currencyint
DV360 CPM fee 3 partner currency
cm_paths.events.dv360_cpm_fee_3_advertiser_currencyint
DV360 CPM fee 3 advertiser currency
cm_paths.events.dv360_cpm_fee_4_usdint
DV360 CPM fee 4 usd
cm_paths.events.dv360_cpm_fee_4_partner_currencyint
DV360 CPM fee 4 partner currency
cm_paths.events.dv360_cpm_fee_4_advertiser_currencyint
DV360 CPM fee 4 advertiser currency
cm_paths.events.dv360_cpm_fee_5_usdint
DV360 CPM fee 5 usd
cm_paths.events.dv360_cpm_fee_5_partner_currencyint
DV360 CPM fee 5 partner currency
cm_paths.events.dv360_cpm_fee_5_advertiser_currencyint
DV360 CPM fee 5 advertiser currency
cm_paths.events.dv360_media_fee_1_usdint
DV360 media fee 1 usd
cm_paths.events.dv360_media_fee_1_partner_currencyint
DV360 media fee 1 partner currency
cm_paths.events.dv360_media_fee_1_advertiser_currencyint
DV360 media fee 1 advertiser currency
cm_paths.events.dv360_media_fee_2_usdint
DV360 media fee 2 usd
cm_paths.events.dv360_media_fee_2_partner_currencyint
DV360 media fee 2 partner currency
cm_paths.events.dv360_media_fee_2_advertiser_currencyint
DV360 media fee 2 advertiser currency
cm_paths.events.dv360_media_fee_3_usdint
DV360 media fee 3 usd
cm_paths.events.dv360_media_fee_3_partner_currencyint
DV360 media fee 3 partner currency
cm_paths.events.dv360_media_fee_3_advertiser_currencyint
DV360 media fee 3 advertiser currency
cm_paths.events.dv360_media_fee_4_usdint
DV360 media fee 4 usd
cm_paths.events.dv360_media_fee_4_partner_currencyint
DV360 media fee 4 partner currency
cm_paths.events.dv360_media_fee_4_advertiser_currencyint
DV360 media fee 4 advertiser currency
cm_paths.events.dv360_media_fee_5_usdint
DV360 media fee 5 usd
cm_paths.events.dv360_media_fee_5_partner_currencyint
DV360 media fee 5 partner currency
cm_paths.events.dv360_media_fee_5_advertiser_currencyint
DV360 media fee 5 advertiser currency
cm_paths.events.dv360_data_fees_usdint
DV360 data fees usd
cm_paths.events.dv360_data_fees_partner_currencyint
DV360 data fees partner currency
cm_paths.events.dv360_data_fees_advertiser_currencyint
DV360 data fees advertiser currency
cm_paths.events.activity_countint
Activity count
cm_paths.events.activity_revenuedouble
Activity revenue
cm_paths.events.active_view_eligible_impressionsint
Active View eligible impressions
cm_paths.events.active_view_viewable_impressionsint
Active View viewable impressions
cm_paths.events.dv360_billable_cost_usdint
DV360 billable cost usd
cm_paths.events.dv360_billable_cost_partner_currencyint
DV360 billable cost partner currency
cm_paths.events.dv360_billable_cost_advertiser_currencyint
DV360 billable cost advertiser currency
cm_paths.events.active_view_measurable_impressionsint
Active View measurable impressions
cm_paths.events.rich_media_event_countersint
Rich media event counters
cm_paths.events.rich_media_event_timersdouble
Rich media event timers
cm_paths.floodlight_config_idint
Floodlight configuration ID

DV360 Data Transfer Active View plus

dv360_dt_active_view_plus
device_id_md5string
MD5-hashed device ID. Utility will be provided to hash raw device IDs to match.
eventstruct
event.active_view_audible_impressionsint
Active View: Impressions Audible
event.active_view_audible_time_msecint
Active View: Play Time Audible (Seconds)
event.active_view_audible_visible_time_msecint
Active View: Play Time Audible and Visible (Seconds)
event.active_view_background_countint
Active View: Impressions In Background
event.active_view_complete_viewable_impressionsint
Active View: Impressions Visible at Completion
event.active_view_eligible_impressionsint
Active View: Eligible Impressions
event.active_view_first_quartile_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at First Quartile
event.active_view_first_quartile_viewable_impressionsint
Active View: Impressions Visible at First Quartile
event.active_view_fullscreen_countint
Active View: Impressions Full-Screen
event.active_view_impressions_audible_and_visible_at_completionint
Active View: Impressions Audible and Visible at Completion
event.active_view_impressions_visible10_secondsint
Active View: Impressions Visible 10 Seconds
event.active_view_measurable_impressionsint
Active View: Measurable Impressions
event.active_view_midpoint_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Midpoint
event.active_view_midpoint_viewable_impressionsint
Active View: Impressions Visible at Midpoint
event.active_view_plus_measurable_countint
Active View Plus: Measurable Impressions
event.active_view_start_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Start
event.active_view_start_viewable_impressionsint
Active View: Impressions Visible at Start
event.active_view_third_quartile_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Third Quartile
event.active_view_third_quartile_viewable_impressionsint
Active View: Impressions Visible at Third Quartile
event.active_view_tos_msecint
Active View: Time on Screen (Seconds)
event.active_view_viewable_impressionsint
Active View: Viewable Impressions
event.active_view_visible_time_msecint
Active View: Video Visible Time (Seconds)
event.activity_countint
Activity Quantity
event.activity_idint
Activity ID
event.activity_revenuedouble
Activity Revenue
event.ad_idint
Ad ID
event.advertiser_idint
Advertiser ID
event.audience_segment_idint
event.browser_platform_idstring
Browser/Platform ID
event.browser_versionstring
Browser/Platform Version
event.campaign_idint
Campaign ID
event.city_idint
City ID
event.conversion_idint
Conversion ID
event.country_codestring
Country
event.creative_versionstring
Creative Version
event.dma_region_idint
Designated Market Area (DMA) ID
event.dv360_ad_positionint
DV360 Ad Position
event.dv360_advertiser_idint
DV360 Advertiser ID
event.dv360_adx_page_categoriesstring
DV360 Adx Page Categories
event.dv360_attributed_inventory_source_external_idstring
DV360 Attributed Inventory Source External ID
event.dv360_attributed_inventory_source_is_publicstring
DV360 Attributed Inventory Source Is Public
event.dv360_auction_idstring
DV360 Auction ID
event.dv360_bid_price_advertiser_currencyint
DV360 Bid Price (Advertiser Currency)
event.dv360_bid_price_partner_currencyint
DV360 Bid Price (Partner Currency)
event.dv360_bid_price_usdint
DV360 Bid Price (USD)
event.dv360_billable_cost_advertiser_currencyint
DV360 Billable Cost (Advertiser Currency)
event.dv360_billable_cost_partner_currencyint
DV360 Billable Cost (Partner Currency)
event.dv360_billable_cost_usdint
DV360 Billable Cost (USD)
event.dv360_browser_idint
DV360 Browser/Platform ID
event.dv360_browser_timezone_offset_minutesint
DV360 Browser Timezone Offset Minutes
event.dv360_campaign_idint
DV360 Campaign ID
event.dv360_city_idint
DV360 City ID
event.dv360_country_codestring
DV360 Country Code
event.dv360_cpm_fee_1_advertiser_currencyint
event.dv360_cpm_fee_1_partner_currencyint
event.dv360_cpm_fee_1_usdint
event.dv360_cpm_fee_2_advertiser_currencyint
event.dv360_cpm_fee_2_partner_currencyint
event.dv360_cpm_fee_2_usdint
event.dv360_cpm_fee_3_advertiser_currencyint
event.dv360_cpm_fee_3_partner_currencyint
event.dv360_cpm_fee_3_usdint
event.dv360_cpm_fee_4_advertiser_currencyint
event.dv360_cpm_fee_4_partner_currencyint
event.dv360_cpm_fee_4_usdint
event.dv360_cpm_fee_5_advertiser_currencyint
event.dv360_cpm_fee_5_partner_currencyint
event.dv360_cpm_fee_5_usdint
event.dv360_creative_idint
DV360 Creative ID
event.dv360_data_fees_advertiser_currencyint
event.dv360_data_fees_partner_currencyint
event.dv360_data_fees_usdint
event.dv360_device_typeint
DV360 Device Type
event.dv360_exchange_idstring
DV360 Exchange ID
event.dv360_insertion_order_idint
DV360 Insertion Order ID
event.dv360_isp_idint
DV360 ISP ID
event.dv360_languagestring
DV360 Language
event.dv360_line_item_idint
DV360 Line Item ID
event.dv360_matching_targeted_keywordsstring
DV360 Matching Targeted Keywords
event.dv360_matching_targeted_segmentsstring
DV360 Matching Targeted Segments
event.dv360_media_cost_advertiser_currencyint
DV360 Media Cost (Advertiser Currency)
event.dv360_media_cost_partner_currencyint
DV360 Media Cost (Partner Currency)
event.dv360_media_cost_usdint
DV360 Media Cost (USD)
event.dv360_media_fee_1_advertiser_currencyint
event.dv360_media_fee_1_partner_currencyint
event.dv360_media_fee_1_usdint
event.dv360_media_fee_2_advertiser_currencyint
event.dv360_media_fee_2_partner_currencyint
event.dv360_media_fee_2_usdint
event.dv360_media_fee_3_advertiser_currencyint
event.dv360_media_fee_3_partner_currencyint
event.dv360_media_fee_3_usdint
event.dv360_media_fee_4_advertiser_currencyint
event.dv360_media_fee_4_partner_currencyint
event.dv360_media_fee_4_usdint
event.dv360_media_fee_5_advertiser_currencyint
event.dv360_media_fee_5_partner_currencyint
event.dv360_media_fee_5_usdint
event.dv360_mobile_make_idint
DV360 Mobile Make ID
event.dv360_mobile_model_idint
DV360 Mobile Model ID
event.dv360_net_speedint
DV360 Net Speed
event.dv360_operating_system_idint
event.dv360_request_timeint
DV360 Request Time
event.dv360_revenue_advertiser_currencyint
DV360 Revenue (Advertiser Currency)
event.dv360_revenue_partner_currencyint
DV360 Revenue (Partner Currency)
event.dv360_revenue_usdint
DV360 Revenue (USD)
event.dv360_site_idint
DV360 Site ID
event.dv360_state_region_idint
DV360 Region ID
event.dv360_urlstring
DV360 URL
event.dv360_view_statestring
DV360 View State
event.dv360_zip_postal_codestring
DV360 ZIP/Postal Code
event.event_sub_typestring
Event Sub-Type
event.event_timeint
Event Time
event.event_typestring
Event Type
event.floodlight_config_idint
Floodlight Configuration
event.impression_idstring
Impression ID
event.interaction_time_utc_secondsstring
Interaction Time
event.landing_page_url_idint
Landing Page URL ID
event.operating_system_idint
Operating System ID
event.ord_valuestring
ORD Value
event.other_datastring
Other Data
event.placement_idint
Placement ID
event.platform_type_idint
event.referrer_urlstring
Referrer URL
event.rendering_idint
Rendering ID
event.rich_media_event_countersint
Event Counters
event.rich_media_event_idint
Rich Media Event ID
event.rich_media_event_timersdouble
Event Timers
event.rich_media_event_type_idint
Rich Media Event Type ID
event.segment_value_1int
Segment Value 1
event.site_idint
Site ID (Campaign Manager)
event.statestring
State/Region
event.tran_valuestring
TRAN Value
event.u_valuestring
U Value
event.zip_codestring
Zip Code
is_in_rdid_projectboolean
True if this event is also in the _rdid table. Used for deduplication of events.
network_idint
The network ID.
user_idstring
User ID

DV360 Data Transfer activities

dv360_dt_activities
device_id_md5string
MD5-hashed device ID. Utility will be provided to hash raw device IDs to match.
eventstruct
event.active_view_audible_impressionsint
Active View: Impressions Audible
event.active_view_audible_time_msecint
Active View: Play Time Audible (Seconds)
event.active_view_audible_visible_time_msecint
Active View: Play Time Audible and Visible (Seconds)
event.active_view_background_countint
Active View: Impressions In Background
event.active_view_complete_viewable_impressionsint
Active View: Impressions Visible at Completion
event.active_view_eligible_impressionsint
Active View: Eligible Impressions
event.active_view_first_quartile_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at First Quartile
event.active_view_first_quartile_viewable_impressionsint
Active View: Impressions Visible at First Quartile
event.active_view_fullscreen_countint
Active View: Impressions Full-Screen
event.active_view_impressions_audible_and_visible_at_completionint
Active View: Impressions Audible and Visible at Completion
event.active_view_impressions_visible10_secondsint
Active View: Impressions Visible 10 Seconds
event.active_view_measurable_impressionsint
Active View: Measurable Impressions
event.active_view_midpoint_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Midpoint
event.active_view_midpoint_viewable_impressionsint
Active View: Impressions Visible at Midpoint
event.active_view_plus_measurable_countint
Active View Plus: Measurable Impressions
event.active_view_start_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Start
event.active_view_start_viewable_impressionsint
Active View: Impressions Visible at Start
event.active_view_third_quartile_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Third Quartile
event.active_view_third_quartile_viewable_impressionsint
Active View: Impressions Visible at Third Quartile
event.active_view_tos_msecint
Active View: Time on Screen (Seconds)
event.active_view_viewable_impressionsint
Active View: Viewable Impressions
event.active_view_visible_time_msecint
Active View: Video Visible Time (Seconds)
event.activity_countint
Activity Quantity
event.activity_idint
Activity ID
event.activity_revenuedouble
Activity Revenue
event.ad_idint
Ad ID
event.advertiser_idint
Advertiser ID
event.audience_segment_idint
event.browser_platform_idstring
Browser/Platform ID
event.browser_versionstring
Browser/Platform Version
event.campaign_idint
Campaign ID
event.city_idint
City ID
event.conversion_idint
Conversion ID
event.country_codestring
Country
event.creative_versionstring
Creative Version
event.dma_region_idint
Designated Market Area (DMA) ID
event.dv360_ad_positionint
DV360 Ad Position
event.dv360_advertiser_idint
DV360 Advertiser ID
event.dv360_adx_page_categoriesstring
DV360 Adx Page Categories
event.dv360_attributed_inventory_source_external_idstring
DV360 Attributed Inventory Source External ID
event.dv360_attributed_inventory_source_is_publicstring
DV360 Attributed Inventory Source Is Public
event.dv360_auction_idstring
DV360 Auction ID
event.dv360_bid_price_advertiser_currencyint
DV360 Bid Price (Advertiser Currency)
event.dv360_bid_price_partner_currencyint
DV360 Bid Price (Partner Currency)
event.dv360_bid_price_usdint
DV360 Bid Price (USD)
event.dv360_billable_cost_advertiser_currencyint
DV360 Billable Cost (Advertiser Currency)
event.dv360_billable_cost_partner_currencyint
DV360 Billable Cost (Partner Currency)
event.dv360_billable_cost_usdint
DV360 Billable Cost (USD)
event.dv360_browser_idint
DV360 Browser/Platform ID
event.dv360_browser_timezone_offset_minutesint
DV360 Browser Timezone Offset Minutes
event.dv360_campaign_idint
DV360 Campaign ID
event.dv360_city_idint
DV360 City ID
event.dv360_country_codestring
DV360 Country Code
event.dv360_cpm_fee_1_advertiser_currencyint
event.dv360_cpm_fee_1_partner_currencyint
event.dv360_cpm_fee_1_usdint
event.dv360_cpm_fee_2_advertiser_currencyint
event.dv360_cpm_fee_2_partner_currencyint
event.dv360_cpm_fee_2_usdint
event.dv360_cpm_fee_3_advertiser_currencyint
event.dv360_cpm_fee_3_partner_currencyint
event.dv360_cpm_fee_3_usdint
event.dv360_cpm_fee_4_advertiser_currencyint
event.dv360_cpm_fee_4_partner_currencyint
event.dv360_cpm_fee_4_usdint
event.dv360_cpm_fee_5_advertiser_currencyint
event.dv360_cpm_fee_5_partner_currencyint
event.dv360_cpm_fee_5_usdint
event.dv360_creative_idint
DV360 Creative ID
event.dv360_data_fees_advertiser_currencyint
event.dv360_data_fees_partner_currencyint
event.dv360_data_fees_usdint
event.dv360_device_typeint
DV360 Device Type
event.dv360_exchange_idstring
DV360 Exchange ID
event.dv360_insertion_order_idint
DV360 Insertion Order ID
event.dv360_isp_idint
DV360 ISP ID
event.dv360_languagestring
DV360 Language
event.dv360_line_item_idint
DV360 Line Item ID
event.dv360_matching_targeted_keywordsstring
DV360 Matching Targeted Keywords
event.dv360_matching_targeted_segmentsstring
DV360 Matching Targeted Segments
event.dv360_media_cost_advertiser_currencyint
DV360 Media Cost (Advertiser Currency)
event.dv360_media_cost_partner_currencyint
DV360 Media Cost (Partner Currency)
event.dv360_media_cost_usdint
DV360 Media Cost (USD)
event.dv360_media_fee_1_advertiser_currencyint
event.dv360_media_fee_1_partner_currencyint
event.dv360_media_fee_1_usdint
event.dv360_media_fee_2_advertiser_currencyint
event.dv360_media_fee_2_partner_currencyint
event.dv360_media_fee_2_usdint
event.dv360_media_fee_3_advertiser_currencyint
event.dv360_media_fee_3_partner_currencyint
event.dv360_media_fee_3_usdint
event.dv360_media_fee_4_advertiser_currencyint
event.dv360_media_fee_4_partner_currencyint
event.dv360_media_fee_4_usdint
event.dv360_media_fee_5_advertiser_currencyint
event.dv360_media_fee_5_partner_currencyint
event.dv360_media_fee_5_usdint
event.dv360_mobile_make_idint
DV360 Mobile Make ID
event.dv360_mobile_model_idint
DV360 Mobile Model ID
event.dv360_net_speedint
DV360 Net Speed
event.dv360_operating_system_idint
event.dv360_request_timeint
DV360 Request Time
event.dv360_revenue_advertiser_currencyint
DV360 Revenue (Advertiser Currency)
event.dv360_revenue_partner_currencyint
DV360 Revenue (Partner Currency)
event.dv360_revenue_usdint
DV360 Revenue (USD)
event.dv360_site_idint
DV360 Site ID
event.dv360_state_region_idint
DV360 Region ID
event.dv360_urlstring
DV360 URL
event.dv360_view_statestring
DV360 View State
event.dv360_zip_postal_codestring
DV360 ZIP/Postal Code
event.event_sub_typestring
Event Sub-Type
event.event_timeint
Event Time
event.event_typestring
Event Type
event.floodlight_config_idint
Floodlight Configuration
event.impression_idstring
Impression ID
event.interaction_time_utc_secondsstring
Interaction Time
event.landing_page_url_idint
Landing Page URL ID
event.operating_system_idint
Operating System ID
event.ord_valuestring
ORD Value
event.other_datastring
Other Data
event.placement_idint
Placement ID
event.platform_type_idint
event.referrer_urlstring
Referrer URL
event.rendering_idint
Rendering ID
event.rich_media_event_countersint
Event Counters
event.rich_media_event_idint
Rich Media Event ID
event.rich_media_event_timersdouble
Event Timers
event.rich_media_event_type_idint
Rich Media Event Type ID
event.segment_value_1int
Segment Value 1
event.site_idint
Site ID (Campaign Manager)
event.statestring
State/Region
event.tran_valuestring
TRAN Value
event.u_valuestring
U Value
event.zip_codestring
Zip Code
is_in_rdid_projectboolean
True if this event is also in the _rdid table. Used for deduplication of events.
network_idint
The network ID.
user_idstring
User ID

DV360 Data Transfer advertiser

dv360_dt_advertiser
dv360_advertiserstring
Name of the advertiser.
dv360_advertiser_idint
Unique ID of the advertiser.
dv360_partner_idint
Unique ID of the partner.

DV360 Data Transfer campaign

dv360_dt_campaign
dv360_advertiser_idint
Unique ID of the advertiser.
dv360_campaignstring
Name of the campaign
dv360_campaign_idint
Unique ID of the campaign.
dv360_partner_idint
Unique ID of the partner.

DV360 Data Transfer clicks

dv360_dt_clicks
device_id_md5string
MD5-hashed device ID. Utility will be provided to hash raw device IDs to match.
eventstruct
event.active_view_audible_impressionsint
Active View: Impressions Audible
event.active_view_audible_time_msecint
Active View: Play Time Audible (Seconds)
event.active_view_audible_visible_time_msecint
Active View: Play Time Audible and Visible (Seconds)
event.active_view_background_countint
Active View: Impressions In Background
event.active_view_complete_viewable_impressionsint
Active View: Impressions Visible at Completion
event.active_view_eligible_impressionsint
Active View: Eligible Impressions
event.active_view_first_quartile_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at First Quartile
event.active_view_first_quartile_viewable_impressionsint
Active View: Impressions Visible at First Quartile
event.active_view_fullscreen_countint
Active View: Impressions Full-Screen
event.active_view_impressions_audible_and_visible_at_completionint
Active View: Impressions Audible and Visible at Completion
event.active_view_impressions_visible10_secondsint
Active View: Impressions Visible 10 Seconds
event.active_view_measurable_impressionsint
Active View: Measurable Impressions
event.active_view_midpoint_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Midpoint
event.active_view_midpoint_viewable_impressionsint
Active View: Impressions Visible at Midpoint
event.active_view_plus_measurable_countint
Active View Plus: Measurable Impressions
event.active_view_start_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Start
event.active_view_start_viewable_impressionsint
Active View: Impressions Visible at Start
event.active_view_third_quartile_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Third Quartile
event.active_view_third_quartile_viewable_impressionsint
Active View: Impressions Visible at Third Quartile
event.active_view_tos_msecint
Active View: Time on Screen (Seconds)
event.active_view_viewable_impressionsint
Active View: Viewable Impressions
event.active_view_visible_time_msecint
Active View: Video Visible Time (Seconds)
event.activity_countint
Activity Quantity
event.activity_idint
Activity ID
event.activity_revenuedouble
Activity Revenue
event.ad_idint
Ad ID
event.advertiser_idint
Advertiser ID
event.audience_segment_idint
event.browser_platform_idstring
Browser/Platform ID
event.browser_versionstring
Browser/Platform Version
event.campaign_idint
Campaign ID
event.city_idint
City ID
event.conversion_idint
Conversion ID
event.country_codestring
Country
event.creative_versionstring
Creative Version
event.dma_region_idint
Designated Market Area (DMA) ID
event.dv360_ad_positionint
DV360 Ad Position
event.dv360_advertiser_idint
DV360 Advertiser ID
event.dv360_adx_page_categoriesstring
DV360 Adx Page Categories
event.dv360_attributed_inventory_source_external_idstring
DV360 Attributed Inventory Source External ID
event.dv360_attributed_inventory_source_is_publicstring
DV360 Attributed Inventory Source Is Public
event.dv360_auction_idstring
DV360 Auction ID
event.dv360_bid_price_advertiser_currencyint
DV360 Bid Price (Advertiser Currency)
event.dv360_bid_price_partner_currencyint
DV360 Bid Price (Partner Currency)
event.dv360_bid_price_usdint
DV360 Bid Price (USD)
event.dv360_billable_cost_advertiser_currencyint
DV360 Billable Cost (Advertiser Currency)
event.dv360_billable_cost_partner_currencyint
DV360 Billable Cost (Partner Currency)
event.dv360_billable_cost_usdint
DV360 Billable Cost (USD)
event.dv360_browser_idint
DV360 Browser/Platform ID
event.dv360_browser_timezone_offset_minutesint
DV360 Browser Timezone Offset Minutes
event.dv360_campaign_idint
DV360 Campaign ID
event.dv360_city_idint
DV360 City ID
event.dv360_country_codestring
DV360 Country Code
event.dv360_cpm_fee_1_advertiser_currencyint
event.dv360_cpm_fee_1_partner_currencyint
event.dv360_cpm_fee_1_usdint
event.dv360_cpm_fee_2_advertiser_currencyint
event.dv360_cpm_fee_2_partner_currencyint
event.dv360_cpm_fee_2_usdint
event.dv360_cpm_fee_3_advertiser_currencyint
event.dv360_cpm_fee_3_partner_currencyint
event.dv360_cpm_fee_3_usdint
event.dv360_cpm_fee_4_advertiser_currencyint
event.dv360_cpm_fee_4_partner_currencyint
event.dv360_cpm_fee_4_usdint
event.dv360_cpm_fee_5_advertiser_currencyint
event.dv360_cpm_fee_5_partner_currencyint
event.dv360_cpm_fee_5_usdint
event.dv360_creative_idint
DV360 Creative ID
event.dv360_data_fees_advertiser_currencyint
event.dv360_data_fees_partner_currencyint
event.dv360_data_fees_usdint
event.dv360_device_typeint
DV360 Device Type
event.dv360_exchange_idstring
DV360 Exchange ID
event.dv360_insertion_order_idint
DV360 Insertion Order ID
event.dv360_isp_idint
DV360 ISP ID
event.dv360_languagestring
DV360 Language
event.dv360_line_item_idint
DV360 Line Item ID
event.dv360_matching_targeted_keywordsstring
DV360 Matching Targeted Keywords
event.dv360_matching_targeted_segmentsstring
DV360 Matching Targeted Segments
event.dv360_media_cost_advertiser_currencyint
DV360 Media Cost (Advertiser Currency)
event.dv360_media_cost_partner_currencyint
DV360 Media Cost (Partner Currency)
event.dv360_media_cost_usdint
DV360 Media Cost (USD)
event.dv360_media_fee_1_advertiser_currencyint
event.dv360_media_fee_1_partner_currencyint
event.dv360_media_fee_1_usdint
event.dv360_media_fee_2_advertiser_currencyint
event.dv360_media_fee_2_partner_currencyint
event.dv360_media_fee_2_usdint
event.dv360_media_fee_3_advertiser_currencyint
event.dv360_media_fee_3_partner_currencyint
event.dv360_media_fee_3_usdint
event.dv360_media_fee_4_advertiser_currencyint
event.dv360_media_fee_4_partner_currencyint
event.dv360_media_fee_4_usdint
event.dv360_media_fee_5_advertiser_currencyint
event.dv360_media_fee_5_partner_currencyint
event.dv360_media_fee_5_usdint
event.dv360_mobile_make_idint
DV360 Mobile Make ID
event.dv360_mobile_model_idint
DV360 Mobile Model ID
event.dv360_net_speedint
DV360 Net Speed
event.dv360_operating_system_idint
event.dv360_request_timeint
DV360 Request Time
event.dv360_revenue_advertiser_currencyint
DV360 Revenue (Advertiser Currency)
event.dv360_revenue_partner_currencyint
DV360 Revenue (Partner Currency)
event.dv360_revenue_usdint
DV360 Revenue (USD)
event.dv360_site_idint
DV360 Site ID
event.dv360_state_region_idint
DV360 Region ID
event.dv360_urlstring
DV360 URL
event.dv360_view_statestring
DV360 View State
event.dv360_zip_postal_codestring
DV360 ZIP/Postal Code
event.event_sub_typestring
Event Sub-Type
event.event_timeint
Event Time
event.event_typestring
Event Type
event.floodlight_config_idint
Floodlight Configuration
event.impression_idstring
Impression ID
event.interaction_time_utc_secondsstring
Interaction Time
event.landing_page_url_idint
Landing Page URL ID
event.operating_system_idint
Operating System ID
event.ord_valuestring
ORD Value
event.other_datastring
Other Data
event.placement_idint
Placement ID
event.platform_type_idint
event.referrer_urlstring
Referrer URL
event.rendering_idint
Rendering ID
event.rich_media_event_countersint
Event Counters
event.rich_media_event_idint
Rich Media Event ID
event.rich_media_event_timersdouble
Event Timers
event.rich_media_event_type_idint
Rich Media Event Type ID
event.segment_value_1int
Segment Value 1
event.site_idint
Site ID (Campaign Manager)
event.statestring
State/Region
event.tran_valuestring
TRAN Value
event.u_valuestring
U Value
event.zip_codestring
Zip Code
is_in_rdid_projectboolean
True if this event is also in the _rdid table. Used for deduplication of events.
network_idint
The network ID.
user_idstring
User ID

DV360 Data Transfer impressions

dv360_dt_impressions
device_id_md5string
MD5-hashed device ID. Utility will be provided to hash raw device IDs to match.
eventstruct
event.active_view_audible_impressionsint
Active View: Impressions Audible
event.active_view_audible_time_msecint
Active View: Play Time Audible (Seconds)
event.active_view_audible_visible_time_msecint
Active View: Play Time Audible and Visible (Seconds)
event.active_view_background_countint
Active View: Impressions In Background
event.active_view_complete_viewable_impressionsint
Active View: Impressions Visible at Completion
event.active_view_eligible_impressionsint
Active View: Eligible Impressions
event.active_view_first_quartile_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at First Quartile
event.active_view_first_quartile_viewable_impressionsint
Active View: Impressions Visible at First Quartile
event.active_view_fullscreen_countint
Active View: Impressions Full-Screen
event.active_view_impressions_audible_and_visible_at_completionint
Active View: Impressions Audible and Visible at Completion
event.active_view_impressions_visible10_secondsint
Active View: Impressions Visible 10 Seconds
event.active_view_measurable_impressionsint
Active View: Measurable Impressions
event.active_view_midpoint_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Midpoint
event.active_view_midpoint_viewable_impressionsint
Active View: Impressions Visible at Midpoint
event.active_view_plus_measurable_countint
Active View Plus: Measurable Impressions
event.active_view_start_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Start
event.active_view_start_viewable_impressionsint
Active View: Impressions Visible at Start
event.active_view_third_quartile_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Third Quartile
event.active_view_third_quartile_viewable_impressionsint
Active View: Impressions Visible at Third Quartile
event.active_view_tos_msecint
Active View: Time on Screen (Seconds)
event.active_view_viewable_impressionsint
Active View: Viewable Impressions
event.active_view_visible_time_msecint
Active View: Video Visible Time (Seconds)
event.activity_countint
Activity Quantity
event.activity_idint
Activity ID
event.activity_revenuedouble
Activity Revenue
event.ad_idint
Ad ID
event.advertiser_idint
Advertiser ID
event.audience_segment_idint
event.browser_platform_idstring
Browser/Platform ID
event.browser_versionstring
Browser/Platform Version
event.campaign_idint
Campaign ID
event.city_idint
City ID
event.conversion_idint
Conversion ID
event.country_codestring
Country
event.creative_versionstring
Creative Version
event.dma_region_idint
Designated Market Area (DMA) ID
event.dv360_ad_positionint
DV360 Ad Position
event.dv360_advertiser_idint
DV360 Advertiser ID
event.dv360_adx_page_categoriesstring
DV360 Adx Page Categories
event.dv360_attributed_inventory_source_external_idstring
DV360 Attributed Inventory Source External ID
event.dv360_attributed_inventory_source_is_publicstring
DV360 Attributed Inventory Source Is Public
event.dv360_auction_idstring
DV360 Auction ID
event.dv360_bid_price_advertiser_currencyint
DV360 Bid Price (Advertiser Currency)
event.dv360_bid_price_partner_currencyint
DV360 Bid Price (Partner Currency)
event.dv360_bid_price_usdint
DV360 Bid Price (USD)
event.dv360_billable_cost_advertiser_currencyint
DV360 Billable Cost (Advertiser Currency)
event.dv360_billable_cost_partner_currencyint
DV360 Billable Cost (Partner Currency)
event.dv360_billable_cost_usdint
DV360 Billable Cost (USD)
event.dv360_browser_idint
DV360 Browser/Platform ID
event.dv360_browser_timezone_offset_minutesint
DV360 Browser Timezone Offset Minutes
event.dv360_campaign_idint
DV360 Campaign ID
event.dv360_city_idint
DV360 City ID
event.dv360_country_codestring
DV360 Country Code
event.dv360_cpm_fee_1_advertiser_currencyint
event.dv360_cpm_fee_1_partner_currencyint
event.dv360_cpm_fee_1_usdint
event.dv360_cpm_fee_2_advertiser_currencyint
event.dv360_cpm_fee_2_partner_currencyint
event.dv360_cpm_fee_2_usdint
event.dv360_cpm_fee_3_advertiser_currencyint
event.dv360_cpm_fee_3_partner_currencyint
event.dv360_cpm_fee_3_usdint
event.dv360_cpm_fee_4_advertiser_currencyint
event.dv360_cpm_fee_4_partner_currencyint
event.dv360_cpm_fee_4_usdint
event.dv360_cpm_fee_5_advertiser_currencyint
event.dv360_cpm_fee_5_partner_currencyint
event.dv360_cpm_fee_5_usdint
event.dv360_creative_idint
DV360 Creative ID
event.dv360_data_fees_advertiser_currencyint
event.dv360_data_fees_partner_currencyint
event.dv360_data_fees_usdint
event.dv360_device_typeint
DV360 Device Type
event.dv360_exchange_idstring
DV360 Exchange ID
event.dv360_insertion_order_idint
DV360 Insertion Order ID
event.dv360_isp_idint
DV360 ISP ID
event.dv360_languagestring
DV360 Language
event.dv360_line_item_idint
DV360 Line Item ID
event.dv360_matching_targeted_keywordsstring
DV360 Matching Targeted Keywords
event.dv360_matching_targeted_segmentsstring
DV360 Matching Targeted Segments
event.dv360_media_cost_advertiser_currencyint
DV360 Media Cost (Advertiser Currency)
event.dv360_media_cost_partner_currencyint
DV360 Media Cost (Partner Currency)
event.dv360_media_cost_usdint
DV360 Media Cost (USD)
event.dv360_media_fee_1_advertiser_currencyint
event.dv360_media_fee_1_partner_currencyint
event.dv360_media_fee_1_usdint
event.dv360_media_fee_2_advertiser_currencyint
event.dv360_media_fee_2_partner_currencyint
event.dv360_media_fee_2_usdint
event.dv360_media_fee_3_advertiser_currencyint
event.dv360_media_fee_3_partner_currencyint
event.dv360_media_fee_3_usdint
event.dv360_media_fee_4_advertiser_currencyint
event.dv360_media_fee_4_partner_currencyint
event.dv360_media_fee_4_usdint
event.dv360_media_fee_5_advertiser_currencyint
event.dv360_media_fee_5_partner_currencyint
event.dv360_media_fee_5_usdint
event.dv360_mobile_make_idint
DV360 Mobile Make ID
event.dv360_mobile_model_idint
DV360 Mobile Model ID
event.dv360_net_speedint
DV360 Net Speed
event.dv360_operating_system_idint
event.dv360_request_timeint
DV360 Request Time
event.dv360_revenue_advertiser_currencyint
DV360 Revenue (Advertiser Currency)
event.dv360_revenue_partner_currencyint
DV360 Revenue (Partner Currency)
event.dv360_revenue_usdint
DV360 Revenue (USD)
event.dv360_site_idint
DV360 Site ID
event.dv360_state_region_idint
DV360 Region ID
event.dv360_urlstring
DV360 URL
event.dv360_view_statestring
DV360 View State
event.dv360_zip_postal_codestring
DV360 ZIP/Postal Code
event.event_sub_typestring
Event Sub-Type
event.event_timeint
Event Time
event.event_typestring
Event Type
event.floodlight_config_idint
Floodlight Configuration
event.impression_idstring
Impression ID
event.interaction_time_utc_secondsstring
Interaction Time
event.landing_page_url_idint
Landing Page URL ID
event.operating_system_idint
Operating System ID
event.ord_valuestring
ORD Value
event.other_datastring
Other Data
event.placement_idint
Placement ID
event.platform_type_idint
event.referrer_urlstring
Referrer URL
event.rendering_idint
Rendering ID
event.rich_media_event_countersint
Event Counters
event.rich_media_event_idint
Rich Media Event ID
event.rich_media_event_timersdouble
Event Timers
event.rich_media_event_type_idint
Rich Media Event Type ID
event.segment_value_1int
Segment Value 1
event.site_idint
Site ID (Campaign Manager)
event.statestring
State/Region
event.tran_valuestring
TRAN Value
event.u_valuestring
U Value
event.zip_codestring
Zip Code
is_in_rdid_projectboolean
True if this event is also in the _rdid table. Used for deduplication of events.
network_idint
The network ID.
user_idstring
User ID

DV360 Data Transfer insertion order

dv360_dt_insertion_order
dv360_advertiser_idint
Unique ID of the advertiser.
dv360_campaign_idint
Unique ID of the campaign.
dv360_insertion_orderstring
Name of the insertion order.
dv360_insertion_order_idint
Unique ID of the insertion order.
dv360_partner_idint
Unique ID of the partner.

DV360 Data Transfer line item

dv360_dt_line_item
dv360_advertiser_idint
Unique ID of the advertiser.
dv360_campaign_idint
Unique ID of the campaign.
dv360_insertion_order_idint
Unique ID of the insertion order.
dv360_line_itemstring
Name of the line item.
dv360_line_item_idint
Unique ID of the line item.
dv360_partner_idint
Unique ID of the partner.

DV360 paths

dv360_paths
dv360_paths.user_idstring
User ID.
dv360_paths.network_idint
The network ID.
dv360_paths.partner_idint
Unique ID of the partner.
dv360_paths.pathrecord
Row containing event path for a given user.
dv360_paths.eventsrepeated struct
dv360_paths.events.event_timeint
Event time
dv360_paths.events.advertiser_idint
Advertiser ID
dv360_paths.events.campaign_idint
Campaign ID
dv360_paths.events.ad_idint
Ad ID
dv360_paths.events.rendering_idint
Rendering ID
dv360_paths.events.creative_versionstring
Creative version
dv360_paths.events.site_idint
Site ID
dv360_paths.events.country_codestring
Country code
dv360_paths.events.statestring
State
dv360_paths.events.browser_platform_idstring
Browser platform ID
dv360_paths.events.browser_versionstring
Browser version
dv360_paths.events.dma_region_idint
DMA region ID
dv360_paths.events.city_idint
City ID
dv360_paths.events.zip_codestring
Zip code
dv360_paths.events.u_valuestring
U value
dv360_paths.events.event_typestring
Event type
dv360_paths.events.event_sub_typestring
Event sub type
dv360_paths.events.dv360_auction_idstring
DV360 auction ID
dv360_paths.events.dv360_request_timeint
DV360 request time
dv360_paths.events.dv360_advertiser_idint
DV360 advertiser ID
dv360_paths.events.dv360_insertion_order_idint
DV360 insertion order ID
dv360_paths.events.dv360_line_item_idint
DV360 line item ID
dv360_paths.events.dv360_creative_idint
DV360 creative ID
dv360_paths.events.dv360_bid_price_usdint
DV360 bid price usd
dv360_paths.events.dv360_bid_price_partner_currencyint
DV360 bid price partner currency
dv360_paths.events.dv360_bid_price_advertiser_currencyint
DV360 bid price advertiser currency
dv360_paths.events.dv360_urlstring
DV360 url
dv360_paths.events.dv360_site_idint
DV360 site ID
dv360_paths.events.dv360_languagestring
DV360 language
dv360_paths.events.dv360_adx_page_categoriesstring
DV360 Ad Exchange page categories
dv360_paths.events.dv360_matching_targeted_keywordsstring
DV360 matching targeted keywords
dv360_paths.events.dv360_exchange_idstring
DV360 exchange ID
dv360_paths.events.dv360_attributed_inventory_source_external_idstring
DV360 attributed inventory source external ID
dv360_paths.events.dv360_attributed_inventory_source_is_publicstring
DV360 attributed inventory source is public
dv360_paths.events.dv360_ad_positionint
DV360 ad position
dv360_paths.events.dv360_country_codestring
DV360 country code
dv360_paths.events.dv360_zip_postal_codestring
DV360 zip postal code
dv360_paths.events.dv360_browser_timezone_offset_minutesint
DV360 browser timezone offset minutes
dv360_paths.events.dv360_net_speedint
DV360 net speed
dv360_paths.events.dv360_matching_targeted_segmentsstring
DV360 matching targeted segments
dv360_paths.events.dv360_isp_idint
DV360 isp ID
dv360_paths.events.dv360_device_typeint
DV360 device type
dv360_paths.events.dv360_mobile_model_idint
DV360 mobile model ID
dv360_paths.events.placement_idint
Placement ID
dv360_paths.events.operating_system_idint
Operating system ID
dv360_paths.events.segment_value_1int
Segment value 1
dv360_paths.events.dv360_state_region_idint
DV360 state region ID
dv360_paths.events.dv360_city_idint
DV360 city ID
dv360_paths.events.dv360_browser_idint
DV360 browser ID
dv360_paths.events.activity_idint
Activity ID
dv360_paths.events.ord_valuestring
Ord value
dv360_paths.events.conversion_idint
Conversion ID
dv360_paths.events.floodlight_config_idint
Floodlight configuration ID
dv360_paths.events.interaction_time_utc_secondsstring
Interaction time utc seconds
dv360_paths.events.rich_media_event_idint
Rich media event ID
dv360_paths.events.rich_media_event_type_idint
Rich media event type ID
dv360_paths.events.impression_idstring
Impression ID
dv360_paths.events.other_datastring
Other data
dv360_paths.events.referrer_urlstring
Referrer url
dv360_paths.events.tran_valuestring
Tran value
dv360_paths.events.dv360_view_statestring
DV360 view state
dv360_paths.events.landing_page_url_idint
Landing page url ID
dv360_paths.events.audience_segment_idint
Audience segment ID
dv360_paths.events.dv360_media_cost_usdint
DV360 media cost usd
dv360_paths.events.dv360_media_cost_partner_currencyint
DV360 media cost partner currency
dv360_paths.events.dv360_media_cost_advertiser_currencyint
DV360 media cost advertiser currency
dv360_paths.events.dv360_revenue_usdint
DV360 revenue usd
dv360_paths.events.dv360_revenue_partner_currencyint
DV360 revenue partner currency
dv360_paths.events.dv360_revenue_advertiser_currencyint
DV360 revenue advertiser currency
dv360_paths.events.dv360_cpm_fee_1_usdint
DV360 CPM fee 1 usd
dv360_paths.events.dv360_cpm_fee_1_partner_currencyint
DV360 CPM fee 1 partner currency
dv360_paths.events.dv360_cpm_fee_1_advertiser_currencyint
DV360 CPM fee 1 advertiser currency
dv360_paths.events.dv360_cpm_fee_2_usdint
DV360 CPM fee 2 usd
dv360_paths.events.dv360_cpm_fee_2_partner_currencyint
DV360 CPM fee 2 partner currency
dv360_paths.events.dv360_cpm_fee_2_advertiser_currencyint
DV360 CPM fee 2 advertiser currency
dv360_paths.events.dv360_cpm_fee_3_usdint
DV360 CPM fee 3 usd
dv360_paths.events.dv360_cpm_fee_3_partner_currencyint
DV360 CPM fee 3 partner currency
dv360_paths.events.dv360_cpm_fee_3_advertiser_currencyint
DV360 CPM fee 3 advertiser currency
dv360_paths.events.dv360_cpm_fee_4_usdint
DV360 CPM fee 4 usd
dv360_paths.events.dv360_cpm_fee_4_partner_currencyint
DV360 CPM fee 4 partner currency
dv360_paths.events.dv360_cpm_fee_4_advertiser_currencyint
DV360 CPM fee 4 advertiser currency
dv360_paths.events.dv360_cpm_fee_5_usdint
DV360 CPM fee 5 usd
dv360_paths.events.dv360_cpm_fee_5_partner_currencyint
DV360 CPM fee 5 partner currency
dv360_paths.events.dv360_cpm_fee_5_advertiser_currencyint
DV360 CPM fee 5 advertiser currency
dv360_paths.events.dv360_media_fee_1_usdint
DV360 media fee 1 usd
dv360_paths.events.dv360_media_fee_1_partner_currencyint
DV360 media fee 1 partner currency
dv360_paths.events.dv360_media_fee_1_advertiser_currencyint
DV360 media fee 1 advertiser currency
dv360_paths.events.dv360_media_fee_2_usdint
DV360 media fee 2 usd
dv360_paths.events.dv360_media_fee_2_partner_currencyint
DV360 media fee 2 partner currency
dv360_paths.events.dv360_media_fee_2_advertiser_currencyint
DV360 media fee 2 advertiser currency
dv360_paths.events.dv360_media_fee_3_usdint
DV360 media fee 3 usd
dv360_paths.events.dv360_media_fee_3_partner_currencyint
DV360 media fee 3 partner currency
dv360_paths.events.dv360_media_fee_3_advertiser_currencyint
DV360 media fee 3 advertiser currency
dv360_paths.events.dv360_media_fee_4_usdint
DV360 media fee 4 usd
dv360_paths.events.dv360_media_fee_4_partner_currencyint
DV360 media fee 4 partner currency
dv360_paths.events.dv360_media_fee_4_advertiser_currencyint
DV360 media fee 4 advertiser currency
dv360_paths.events.dv360_media_fee_5_usdint
DV360 media fee 5 usd
dv360_paths.events.dv360_media_fee_5_partner_currencyint
DV360 media fee 5 partner currency
dv360_paths.events.dv360_media_fee_5_advertiser_currencyint
DV360 media fee 5 advertiser currency
dv360_paths.events.dv360_data_fees_usdint
DV360 data fees usd
dv360_paths.events.dv360_data_fees_partner_currencyint
DV360 data fees partner currency
dv360_paths.events.dv360_data_fees_advertiser_currencyint
DV360 data fees advertiser currency
dv360_paths.events.activity_countint
Activity count
dv360_paths.events.activity_revenuedouble
Activity revenue
dv360_paths.events.active_view_eligible_impressionsint
Active View eligible impressions
dv360_paths.events.active_view_viewable_impressionsint
Active View viewable impressions
dv360_paths.events.dv360_billable_cost_usdint
DV360 billable cost usd
dv360_paths.events.dv360_billable_cost_partner_currencyint
DV360 billable cost partner currency
dv360_paths.events.dv360_billable_cost_advertiser_currencyint
DV360 billable cost advertiser currency
dv360_paths.events.active_view_measurable_impressionsint
Active View measurable impressions
dv360_paths.events.rich_media_event_countersint
Rich media event counters
dv360_paths.events.rich_media_event_timersdouble
Rich media event timers
dv360_paths.floodlight_config_idint
Floodlight configuration ID

DV360 YouTube Active View

dv360_youtube_active_views
num_active_view_viewable_impressionint
1 when impression is active view eligible; 0 when impression is not active view eligible.
query_idstruct
Unique identifier for query has multiple parts. Joins with query_id in any adh.dv360_youtube table.
query_id.process_idint
The processing ID.
query_id.server_ipint
The processing server.
query_id.time_usecint
The query time in microseconds.
view_idstruct
Unique identifier for view_id has multiple parts.
view_id.process_idint
Time in microseconds.
view_id.server_ipint
The processing server.
view_id.time_usecint
The processing process.
partner_idint
Unique ID of the partner.
advertiser_idint
Unique ID of the advertiser.
campaign_idint
Unique ID of the campaign.
insertion_order_idint
Unique ID of the insertion order.
lineitem_idint
Unique ID of the line item.
adgroup_idint
ID of DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table.
creative_idint
Joins with creative_id in any adh.dv360_youtube table.

DV360 YouTube ad group

dv360_youtube_adgroup
adgroup_idint
ID of DV360 ad group. Joins with adgroup_id in any adh.dv360_youtube table.
adgroup_namestring
Ad group name.
adgroup_statusstring
The ad group. Possible values are: "status", "paused", or "enabled".
adgroup_typestring
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_idint
Unique ID of the advertiser.
line_item_idint
Unique ID of the line item.
partner_idint
Unique ID of the partner.
campaign_idint
Unique ID of the campaign.
insertion_order_idint
Unique ID of the insertion order.
lineitem_idint
Unique ID of the line item.

DV360 YouTube advertiser

dv360_youtube_advertiser
advertiser_namestring
Name of the advertiser.
advertiser_idint
Unique ID of the advertiser.
partner_idint
Unique ID of the partner.

DV360 YouTube campaign

dv360_youtube_campaign
advertiser_idint
Unique ID of the advertiser.
campaign_namestring
Name of the campaign
campaign_idint
Unique ID of the campaign.
partner_idint
Unique ID of the partner.

DV360 YouTube clicks

dv360_youtube_clicks
advertiser_click_cost_local_microsdouble
The advertiser's cost in local currency micros.
advertiser_click_cost_usddouble
The advertiser's click cost in dollars.
click_idstruct
Unique identifier for click has multiple parts. Joins with click_id in any adh.dv360_youtube table.
click_id.process_idint
The processing process.
click_id.server_ipint
The processing server.
click_id.time_usecint
Time in microseconds.
click_typeint
The click type.
is_in_rdid_projectboolean
true if this event is also in the _rdid table. Used for deduplication of events.
query_idstruct
Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
query_id.process_idint
The processing process.
query_id.server_ipint
The processing server.
query_id.time_usecint
Time in microseconds.
user_idstring
User ID
partner_idint
Unique ID of the partner.
advertiser_idint
Unique ID of the advertiser.
campaign_idint
Unique ID of the campaign.
insertion_order_idint
Unique ID of the insertion order.
lineitem_idint
Unique ID of the line item.
adgroup_idint
ID of DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table.
creative_idint
Joins with creative_id in any adh.dv360_youtube table.

DV360 YouTube conversions

dv360_youtube_conversions
click_idstruct
Unique identifier for click has multiple parts. Joins with click_id in any adh.yt table.
click_id.process_idint
The processing process.
click_id.server_ipint
The processing server.
click_id.time_usecint
Time in microseconds.
conversion_idstruct
Unique identifier for conversion has multiple parts.
conversion_id.process_idint
The processing process.
conversion_id.server_ipint
The processing server.
conversion_id.time_usecint
Time in microseconds.
conversion_typeint
The type of conversion.
is_in_rdid_projectboolean
true if this event is also in the _rdid table. Used for deduplication of events.
labelstring
Name of conversion event.
query_idstruct
Unique identifier for query has multiple parts. Joins with query_id in any adh.yt table.
query_id.process_idint
The processing process.
query_id.server_ipint
The processing server.
query_id.time_usecint
Time in microseconds.
user_idstring
User ID
partner_idint
Unique ID of the partner.
advertiser_idint
Unique ID of the advertiser.
campaign_idint
Unique ID of the campaign.
insertion_order_idint
Unique ID of the insertion order.
lineitem_idint
Unique ID of the line item.
adgroup_idint
ID of DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table.
creative_idint
Joins with creative_id in any adh.dv360_youtube table.

DV360 YouTube creative

dv360_youtube_creative
partner_idint
Unique ID of the partner.
advertiser_idint
Unique ID of the advertiser.
campaign_idint
Unique ID of the campaign.
insertion_order_idint
Unique ID of the insertion order.
lineitem_idint
Unique ID of the line item.
adgroup_idint
ID of DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table.
creative_idint
Joins with creative_id in any adh.dv360_youtube table.
creative_namestring
Creative name.
creative_typeint
Creative type.
video_messagestruct
Multipart identifier for video data.
video_message.video_ad_durationint
Duration of the video in milliseconds.
video_message.youtube_video_idstring
Video id string representation as it appears on YouTube watch url.

DV360 YouTube impressions

dv360_youtube_impressions
active_view_dataint
Whether the impression was enabled for active view measurement.
advertiser_impression_cost_local_microsdouble
The advertiser's local currency in micros.
advertiser_impression_cost_usddouble
The advertiser's impression cost in dollars.
affinityarray
ID of affinity group. Joins with affinity_id in adh.affinity table. Does not support TrueView line items.
campaign_idint
Unique ID of the campaign.
content_urlstring
URL of the page on which ad appeared. Part of the url is removed for privacy.
demographicsstruct
demographics.age_groupint
Code for age group. Joins with age_group_id in adh.age_group table.
demographics.genderint
Code for gender. Joins with gender_id in adh.gender table.
device_heightint
Device height in px.
device_widthint
Device width in px.
in_marketarray
ID of in-market group. Joins with in_market_id in adh.in_market table. Does not support TrueView line items.
is_in_rdid_projectboolean
true if this event is also in the _rdid table. Used for deduplication of events.
locationstruct
Unique identifier for location has multiple parts
location.countrystring
location.geo_city_idint
Code for city. Joins with city_id in adh.city table.
location.geo_metroint
Code for metro region. Joins with metro_id in adh.metro table.
location.geo_regionstring
Region as string e.g. US-CA.
mobile_browser_classint
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_impressionint
1 when impression is active view eligible; 0 when impression is not active view eligible.
num_active_view_measurable_impressionint
1 when impression is active view measurable; 0 when impression is not active view measurable.
operating_system_version_idsarray
ID of OS. Joins with operating_system_version_id in adh.os_version table.
physical_screen_heightint
Device screen height in mm.
physical_screen_widthint
Device screen width in mm.
publisher_domainstring
Domain of the page on which ad appeared.
query_idstruct
Unique identifier for query has multiple parts. Joins with query_id in any adh.dv360_youtube table.
query_id.process_idint
The processing ID.
query_id.server_ipint
The processing server.
query_id.time_usecint
The query time in microseconds.
query_languagestring
Language used by user.
user_idstring
User ID
is_app_trafficboolean
true if the event happened in a native app.
partner_idint
Unique ID of the partner.
advertiser_idint
Unique ID of the advertiser.
insertion_order_idint
Unique ID of the insertion order.
lineitem_idint
Unique ID of the line item.
adgroup_idint
ID of DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table.
creative_idint
Joins with creative_id in any adh.dv360_youtube table.

DV360 YouTube insertion order

dv360_youtube_insertion_order
advertiser_idint
Unique ID of the advertiser.
campaign_idint
Unique ID of the campaign.
insertion_order_namestring
Name of the insertion order.
insertion_order_idint
Unique ID of the insertion order.
partner_idint
Unique ID of the partner.

DV360 YouTube line item

dv360_youtube_line_item
advertiser_idint
Unique ID of the advertiser.
campaign_idint
Unique ID of the campaign.
insertion_order_idint
Unique ID of the insertion order.
line_item_namestring
Name of the line item.
line_item_idint
Unique ID of the line item.
partner_idint
Unique ID of the partner.

Gender

gender
gender_idint
Gender identifier.
gender_namestring
Gender name. Possible values are: "male", "female", or "unknown".

Google Ads Active Views

google_ads_active_views
num_active_view_viewable_impressionint
1 when impression is active view eligible; 0 when impression is not active view eligible.
query_idstruct
Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
query_id.process_idint
The processing ID.
query_id.server_ipint
The processing server.
query_id.time_usecint
The query time in microseconds.
view_idstruct
Unique identifier for view_id has multiple parts.
view_id.process_idint
Time in microseconds.
view_id.server_ipint
The processing server.
view_id.time_usecint
The processing process.
impression_data.customer_idint
ID of Google Ads customer. Joins with customer_id in any adh.google_ads table.
impression_data.campaign_idint
Unique ID of the campaign.
impression_data.adgroup_idint
ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table.
impression_data.ad_group_creative_idint
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_idint
ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table.
adgroup_namestring
Ad group name.
adgroup_statusstring
The ad group. Possible values are: "status", "paused", or "enabled".
adgroup_typestring
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_idint
Unique ID of the campaign.
customer_idint
Joins with customer_id in any adh.google_ads table.
label_idsarray
Joins with label_id in the adh.google_ads_label table.

Google Ads campaign

google_ads_campaign
advertising_channel_typestring
Advertising channel type. Possible values are: SEARCH, DISPLAY, VIDEO, or OTHER.
campaign_idint
Unique ID of the campaign.
campaign_namestring
Campaign name.
campaign_statusint
Campaign status. 3 = ACTIVE. 5 = PAUSED. 7 = DELETED.
customer_idint
Joins with customer_id in any adh.google_ads table.
end_timeint
Timestamp when the campaign ends in milliseconds.
label_idsarray
Joins with label_id in the adh.google_ads_label table.
start_timeint
Timestamp when the campaign begins in milliseconds.

Google Ads clicks

google_ads_clicks
advertiser_click_cost_local_microsdouble
The advertiser's cost in local currency micros.
advertiser_click_cost_usddouble
The advertiser's click cost in dollars.
click_idstruct
Unique identifier for click has multiple parts. Joins with click_id in any adh.google_ads table.
click_id.process_idint
The processing process.
click_id.server_ipint
The processing server.
click_id.time_usecint
Time in microseconds.
click_typeint
The click type.
is_in_rdid_projectboolean
True if this event is also in the _rdid table. Used for deduplication of events.
query_idstruct
Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
query_id.process_idint
The processing process.
query_id.server_ipint
The processing server.
query_id.time_usecint
Time in microseconds.
user_idstring
User ID
impression_data.customer_idint
ID of Google Ads customer. Joins with customer_id in any adh.google_ads table.
impression_data.campaign_idint
Unique ID of the campaign.
impression_data.adgroup_idint
ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table.
impression_data.ad_group_creative_idint
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_microsdouble
The advertiser's cost in local currency micros.
advertiser_click_cost_usddouble
The advertiser's click cost in dollars.
click_idstruct
Unique identifier for click has multiple parts. Joins with click_id in any adh.yt table.
click_id.process_idint
The processing process.
click_id.server_ipint
The processing server.
click_id.time_usecint
Time in microseconds.
click_typeint
The click type.
is_in_rdid_projectboolean
True if this event is also in the _rdid table. Used for deduplication of events.
query_idstruct
Unique identifier for query has multiple parts. Joins with query_id in any adh.yt table.
query_id.process_idint
The processing process.
query_id.server_ipint
The processing server.
query_id.time_usecint
Time in microseconds.
user_idstring
User ID

Google Ads conversions

google_ads_conversions
click_idstruct
Unique identifier for click has multiple parts. Joins with click_id in any adh.yt table.
click_id.process_idint
The processing process.
click_id.server_ipint
The processing server.
click_id.time_usecint
Time in microseconds.
conversion_idstruct
Unique identifier for conversion has multiple parts.
conversion_id.process_idint
The processing process.
conversion_id.server_ipint
The processing server.
conversion_id.time_usecint
Time in microseconds.
conversion_typeint
The type of conversion.
is_in_rdid_projectboolean
True if this event is also in the _rdid table. Used for deduplication of events.
labelstring
Name of conversion event.
query_idstruct
Unique identifier for query has multiple parts. Joins with query_id in any adh.yt table.
query_id.process_idint
The processing process.
query_id.server_ipint
The processing server.
query_id.time_usecint
Time in microseconds.
user_idstring
User ID
impression_data.customer_idint
ID of Google Ads customer. Joins with customer_id in any adh.google_ads table.
impression_data.campaign_idint
Unique ID of the campaign.
impression_data.adgroup_idint
ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table.
impression_data.ad_group_creative_idint
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_idstruct
Unique identifier for click has multiple parts. Joins with click_id in any adh.yt table.
click_id.process_idint
The processing process.
click_id.server_ipint
The processing server.
click_id.time_usecint
Time in microseconds.
conversion_idstruct
Unique identifier for conversion has multiple parts.
conversion_id.process_idint
The processing process.
conversion_id.server_ipint
The processing server.
conversion_id.time_usecint
Time in microseconds.
conversion_typeint
The type of conversion.
is_in_rdid_projectboolean
True if this event is also in the _rdid table. Used for deduplication of events.
labelstring
Name of conversion event.
query_idstruct
Unique identifier for query has multiple parts. Joins with query_id in any adh.yt table.
query_id.process_idint
The processing process.
query_id.server_ipint
The processing server.
query_id.time_usecint
Time in microseconds.
user_idstring
User ID

Google Ads creative

google_ads_creative
beacon_urlarray
Multipart identifier for third-party ad trafficked by Campaign Manager.
creative_idint
Joins with creative_id in any adh.google_ads table.
creative_namestring
Creative name.
creative_typeint
Creative type.
customer_idint
Joins with customer_id in any adh.google_ads table.
snippet_urlstruct
Multipart identifier for third-party ad served by Campaign Manager
snippet_url.advertiser_idint
ID for Campaign Manager advertiser of ad being served.
snippet_url.campaign_idint
Joins with campaign_id in any adh.google_ads table.
snippet_url.content_url_datastruct
Multipart record for content URL.
snippet_url.content_url_data.indexint
Index of content URL.
snippet_url.content_url_data.url_typestring
The type of URL.
snippet_url.networkint
ID for Campaign Manager network of ad being served.
snippet_url.placement_idint
Unique ID for Campaign Manager placement of ad being served.
snippet_url.placement_keystring
Full string identifying Campaign Manager placement of ad being served.
snippet_url.site_idint
ID for Campaign Manager site of ad being served.
template_idint
Template ID of the creative.
video_messagestruct
Multipart identifier for video data.
video_message.video_ad_durationint
Duration of the video in milliseconds.
video_message.youtube_video_idstring
Video id string representation as it appears on YouTube watch url.

Google Ads creative vendor metadata

google_ads_creative_vendor_metadata
creative_idint
The Creative ID in Campaign Manager UI.
legacy_pixelstring
vendor_stringstring

Google Ads customer

google_ads_customer
customer_company_namestring
Company name.
customer_idint
Joins with customer_id in any adh.google_ads table.
customer_namestring
Customer name.
external_customer_idint
Joins with customer_id in any adh.google_ads table.
mcc_idsarray
My Client Center Ids in Google Ads that this ADH customer is associated with.

Google Ads impressions

google_ads_impressions
active_view_dataint
Whether the impression was enabled for active view measurement.
ad_group_creative_idint
ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table.
adgroup_idint
ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table.
advertiser_impression_cost_local_microsdouble
The advertiser's local currency in micros.
advertiser_impression_cost_usddouble
The advertiser's impression cost in dollars.
affinityarray
ID of affinity group. Joins with affinity_id in adh.affinity table. Does not support TrueView line items.
campaign_idint
Unique ID of the campaign.
content_urlstring
URL of the page on which ad appeared. Part of the url is removed for privacy.
customer_idint
ID of Google Ads customer.Joins with customer_id in any adh.google_ads table.
demographicsstruct
demographics.age_groupint
Code for age group. Joins with age_group_id in adh.age_group table.
demographics.genderint
Code for gender. Joins with gender_id in adh.gender table.
device_heightint
Device height in px.
device_widthint
Device width in px.
in_marketarray
ID of in-market group. Joins with in_market_id in adh.in_market table. Does not support TrueView line items.
is_in_rdid_projectboolean
True if this event is also in the _rdid table. Used for deduplication of events.
locationstruct
Unique identifier for location has multiple parts
location.countrystring
location.geo_city_idint
Code for city. Joins with city_id in adh.city table.
location.geo_metroint
Code for metro region. Joins with metro_id in adh.metro table.
location.geo_regionstring
Region as string e.g. US-CA.
mobile_browser_classint
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_impressionint
1 when impression is active view eligible; 0 when impression is not active view eligible.
num_active_view_measurable_impressionint
1 when impression is active view measurable; 0 when impression is not active view measurable.
operating_system_version_idsarray
ID of OS. Joins with operating_system_version_id in adh.os_version table.
physical_screen_heightint
Device screen height in mm.
physical_screen_widthint
Device screen width in mm.
publisher_domainstring
Domain of the page on which ad appeared.
query_idstruct
Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
query_id.process_idint
The processing ID.
query_id.server_ipint
The processing server.
query_id.time_usecint
The query time in microseconds.
query_languagestring
Language used by user.
user_idstring
User ID
is_app_trafficboolean
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_idint
Joins with customer_id in any adh.google_ads table.
descriptionstring
Label description.
label_idint
Joins with label_id in adh.google_ads tables that contain label_ids.
label_namestring
Label name.
statusint
Label status. 1 = ENABLED. 2 = DELETED.

Google Ads view through conversions

google_ads_view_through_conversions
click_idstruct
Unique identifier for click has multiple parts. Joins with click_id in any adh.yt table.
click_id.process_idint
The processing process.
click_id.server_ipint
The processing server.
click_id.time_usecint
Time in microseconds.
conversion_idstruct
Unique identifier for conversion has multiple parts.
conversion_id.process_idint
The processing process.
conversion_id.server_ipint
The processing server.
conversion_id.time_usecint
Time in microseconds.
conversion_typeint
The type of conversion.
device_id_md5string
MD5-hashed device ID. Utility will be provided to hash raw device IDs to match.
is_in_rdid_projectboolean
True if this event is also in the _rdid table. Used for deduplication of events.
labelstring
Name of conversion event.
query_idstruct
Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
query_id.process_idint
The processing ID.
query_id.server_ipint
The processing server.
query_id.time_usecint
The query time in microseconds.
user_idstring
User ID

In-market segment

in_market
in_market_categorystring
The category of market vertical.
in_market_idint
In-market identifier.
in_market_namestring
A more specific in-market name based on category.

Metro

metro
country_codestring
Two character country code.
metro_abbrevstring
Abbreviated version of metro name.
metro_codestring
The metropolitan area code.
metro_idint
Metro identifier.
metro_namestring
Metro name.

Mobile browser class

mobile_browser_class
mobile_browser_class_idint
Mobile browser class identifier.
mobile_browser_class_namestring
Name of the mobile browser class.

Operating system

operating_system
mobileboolean
True if the operating system is mobile.
operating_system_idint
Operating system identifier.
operating_system_namestring
Operating system name.

Operating system version

os_version
major_versionint
The major version number of the operating system.
minor_versionint
The minor version of the operating system.
operating_system_idint
Unique ID of OS just for Data Transfer.
operating_system_version_idint
Operating system version identifier.
operator_typestring
Possible values are OPERATOR_TYPE_EQUAL_TO, or OPERATOR_TYPE_GREATER_THAN_EQUAL_TO.
platform_namestring
The platform name in English.

Region

region
country_codestring
Two character country code.
region_codestring
Region code.
region_idint
Region identifier.
region_namestring
Region name.

YouTube Reserve Active Views

yt_reserve_active_views
num_active_view_viewable_impressionint
1 when impression is active view viewable; 0 when impression is not active view viewable.
query_idstruct
Unique identifier for query has multiple parts.
query_id.process_idint
The processing process.
query_id.server_ipint
The processing server.
query_id.time_usecint
Time in microseconds.
view_idstruct
Unique identifier for view has multiple parts.
view_id.process_idint
The processing process.
view_id.server_ipint
The processing server.
view_id.time_usecint
Time in microseconds.
impression_data.order_idint
impression_data.line_item_idint
Line item id for this impression.
impression_data.creative_idint
The Creative ID in Campaign Manager UI.
impression_data.media_plan_idint
ID of the YouTube Reserve media plan.

YouTube Reserve clicks

yt_reserve_clicks
click_idstruct
Unique identifier for click has multiple parts.
click_id.process_idint
The processing process.
click_id.server_ipint
The processing server.
click_id.time_usecint
Time in microseconds.
click_typeint
The click type.
is_in_rdid_projectboolean
True if this event is also in the _rdid table. Used for deduplication of events.
query_idstruct
Unique identifier for query has multiple parts.
query_id.process_idint
The processing process.
query_id.server_ipint
The processing server.
query_id.time_usecint
Time in microseconds.
user_idstring
User ID
impression_data.order_idint
impression_data.line_item_idint
Line item id for this impression.
impression_data.creative_idint
The Creative ID in Campaign Manager UI.
impression_data.media_plan_idint
ID of the YouTube Reserve media plan.

YouTube Reserve conversions

yt_reserve_conversions
click_idstruct
Unique identifier for click has multiple parts.
click_id.process_idint
The processing process.
click_id.server_ipint
The processing server.
click_id.time_usecint
Time in microseconds.
conversion_idstruct
Unique identifier for conversion has multiple parts.
conversion_id.process_idint
The processing process.
conversion_id.server_ipint
The processing server.
conversion_id.time_usecint
Time in microseconds.
conversion_typeint
The type of conversion.
is_in_rdid_projectboolean
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.
labelstring
Name of conversion event.
query_idstruct
Unique identifier for query has multiple parts.
query_id.process_idint
The processing process.
query_id.server_ipint
The processing server.
query_id.time_usecint
Time in microseconds.
user_idstring
User ID
impression_data.order_idint
impression_data.line_item_idint
Line item id for this impression.
impression_data.creative_idint
The Creative ID in Campaign Manager UI.
impression_data.media_plan_idint
ID of the YouTube Reserve media plan.

YouTube Reserve creative

yt_reserve_creative
creative_format_typestring
Some formats map directly to a type. Other types have multiple formats like: html, image, or video.
creative_idint
The Creative ID in Campaign Manager UI.
creative_namestring
Name of the creative.
creative_typestring
The type of creative.
dcm_beaconsarray
Multipart identifier for Campaign Manager tracking pixel for ad.
is_mastheadboolean
True if this is a masthead creative.
third_party_vast_urlstring
VAST url of the creative if the creative is a third party hosted video. Does not support creatives from programmatic items.
video_messagestruct
Multipart identifier for video data.
video_message.video_ad_durationint
Duration of the video in milliseconds.
video_message.youtube_channel_idstring
Id of the channel that provides this video.
video_message.youtube_video_idstring
Video id string representation as it appears on YouTube watch url.

YouTube Reserve impressions

yt_reserve_impressions
active_view_dataint
Whether the impression was enabled for active view measurement.
content_urlstring
RL of the page on which ad appeared. Part of the url is removed for privacy.
creative_idint
The Creative ID in Campaign Manager UI.
demographicsstruct
Unique identifier for demographics has multiple parts
demographics.age_groupint
Code for age group. Joins with age_group_id in adh.age_group table.
demographics.genderint
Code for gender. Joins with gender_id in adh.gender table.
device_heightint
Device height in px.
device_widthint
Device width in px.
is_in_rdid_projectboolean
True if this event is also in the _rdid table. Used for deduplication of events.
line_item_idint
Line item id for this impression.
locationstruct
Unique identifier for location has multiple parts.
location.countrystring
location.geo_city_idint
Code for city. Joins with city_id in adh.city table.
location.geo_metroint
Code for metro region. Joins with metro_id in adh.metro table.
location.geo_regionstring
Region as string, e.g. US-CA.
mobile_browser_classint
Desktop, tablet, smart tv consoles, or mobile. Joins with mobile_browser_class_id in adh.mobile_browser_class table.
num_active_view_eligible_impressionint
when impression is active view eligible; 0 when impression is not active view eligible.
num_active_view_measurable_impressionint
1 when impression is active view measurable; 0 when impression is not active view measurable.
operating_system_version_idsarray
ID of OS. Joins with operating_system_version_id in adh.os_version table.
order_idint
physical_screen_heightint
Device screen height in mm.
physical_screen_widthint
Device screen width in mm.
publisher_domainstring
Domain of page on which ad appeared.
query_idstruct
Unique identifier for query has multiple parts.
query_id.process_idint
The processing process.
query_id.server_ipint
The processing server.
query_id.time_usecint
Time in microseconds.
query_languagestring
Language used by user.
user_idstring
User ID
is_app_trafficboolean
TRUE if the event happened in a native app. FALSE if the event happened in HTML5 app or webview.
media_plan_idint
ID of the YouTube Reserve media plan.

YouTube Reserve line item

yt_reserve_lineitem
cost_per_unitint
Cost per unit served in micros
cost_typestring
Cost per click, conversion, impression, and Active View.
creative_idarray
Array of creative ids for this line item. Joins with creative_id in any adh.yt table.
end_timetimestamp
Time the line item stopped being served.
line_item_idint
Ad Manager line item serving.
line_item_namestring
Ad Manager line item name.
order_idint
Ad Manager Order identifier used for serving.
order_namestring
Name of the insertion order.
programmaticboolean
True if the line item was programmatic.
skippable_ad_typestring
Possible values are: "skippable", "not skippable", or "selectable".
start_timetimestamp
Time the line item started to be served.
value_cost_per_unitint
The value cost per unit of the line item.

YouTube Reserve order

yt_reserve_order
order_idint
Ad Manager Order identifier used for serving.
order_namestring
Name of Ad Manager order
advertiser_idint
Unique ID of the advertiser.
advertiser_namestring
User entered name of the advertiser.
media_plan_idint
ID of the YouTube Reserve media plan.
media_plan_namestring
Name of the YouTube Reserve media plan.