Ads Data Hub table schema- Vendors

Browser

browser
`browser_id`	`int` Browser identifier.
`browser_name`	`string` Browser name.
`major_version`	`string` Major version of the browser (whole number version).
`minor_version`	`string` Minor version of the browser (incremental or decimal version).

City

city
`city_id`	`int` Unique ID of the city.
`city_name`	`string` City name.
`country_code`	`string` Two character country code.
`latitude`	`int` (Deprecated) Use city or metro instead. Latitude in degrees.
`longitude`	`int` (Deprecated) Use city or metro instead. Longitude in degrees.
`metro_code`	`string` Metropolitan area code.
`region_code`	`string` (Deprecated) Use region_name instead. The multi character code of the region

Campaign Manager 360 Data Transfer activities attributed

cm_dt_activities_attributed
`event.dv360_bid_request_publisher_id`	`string` The publisher id in the publisher.id field of bid request.
`event.dv360_supply_chain_complete`	`boolean` Indicates whether the DV360 supply chain object is complete in the bid request.
`event.dv360_supply_chain_domain`	`array` The domain in the DV360 supply path, the order is the same as the order in the supply chain JSON.
`event.dv360_supply_chain_seller_id`	`array` Array of strings. The seller ID in the DV360 supply path, the order is the same as the order in the supply chain JSON.

Campaign Manager 360 Data Transfer clicks

cm_dt_clicks
`event.dv360_bid_request_publisher_id`	`string` The publisher id in the publisher.id field of bid request.
`event.dv360_supply_chain_complete`	`boolean` Indicates whether the DV360 supply chain object is complete in the bid request.
`event.dv360_supply_chain_domain`	`array` The domain in the DV360 supply path, the order is the same as the order in the supply chain JSON.
`event.dv360_supply_chain_seller_id`	`array` Array of strings. The seller ID in the DV360 supply path, the order is the same as the order in the supply chain JSON.

Campaign Manager 360 Data Transfer impressions

cm_dt_impressions
`event.dv360_bid_request_publisher_id`	`string` The publisher id in the publisher.id field of bid request.
`event.dv360_supply_chain_complete`	`boolean` Indicates whether the DV360 supply chain object is complete in the bid request.
`event.dv360_supply_chain_domain`	`array` The domain in the DV360 supply path, the order is the same as the order in the supply chain JSON.
`event.dv360_supply_chain_seller_id`	`array` Array of strings. The seller ID in the DV360 supply path, the order is the same as the order in the supply chain JSON.

DV360 Data Transfer activities attributed

dv360_dt_activities_attributed
`event.dv360_bid_request_publisher_id`	`string` The publisher id in the publisher.id field of bid request.
`event.dv360_supply_chain_complete`	`boolean` Indicates whether the supply chain object is complete in the bid request.
`event.dv360_supply_chain_domain`	`array` The domain in the supply path, the order is the same as the order in the supply chain JSON.
`event.dv360_supply_chain_seller_id`	`array` Array of strings. The seller ID in the supply path, the order is the same as the order in the supply chain JSON.

DV360 Data Transfer clicks

dv360_dt_clicks
`event.dv360_bid_request_publisher_id`	`string` The publisher id in the publisher.id field of bid request.
`event.dv360_supply_chain_complete`	`boolean` Indicates whether the supply chain object is complete in the bid request.
`event.dv360_supply_chain_domain`	`array` The domain in the supply path, the order is the same as the order in the supply chain JSON.
`event.dv360_supply_chain_seller_id`	`array` Array of strings. The seller ID in the supply path, the order is the same as the order in the supply chain JSON.

DV360 Data Transfer impressions

dv360_dt_impressions
`event.dv360_bid_request_publisher_id`	`string` The publisher id in the publisher.id field of bid request.
`event.dv360_supply_chain_complete`	`boolean` Indicates whether the supply chain object is complete in the bid request.
`event.dv360_supply_chain_domain`	`array` The domain in the supply path, the order is the same as the order in the supply chain JSON.
`event.dv360_supply_chain_seller_id`	`array` Array of strings. The seller ID in the supply path, the order is the same as the order in the supply chain JSON.

DV360 YouTube Active View

dv360_youtube_active_views
`adgroup_id`	`int` ID of DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table.
`advertiser_id`	`int` Unique ID of the advertiser.
`campaign_id`	`int` Unique ID of the campaign.
`creative_id`	`int` Joins with creative_id in any adh.dv360_youtube table.
`impression_id`	`string` Unique identifier for impression.
`insertion_order_id`	`int` Unique ID of the insertion order.
`line_item_id`	`int` Unique ID of the line item.
`num_active_view_viewable_impression`	`int` 1 when impression is active view eligible; 0 when impression is not active view eligible.
`partner_id`	`int` Unique ID of the partner.
`query_id`	`struct` Unique identifier for query has multiple parts. Joins with query_id in any adh.dv360_youtube table.
`query_id.process_id`	`int` The processing ID.
`query_id.server_ip`	`int` The processing server.
`query_id.time_usec`	`int` The query time in microseconds.
`view_id`	`struct` Unique identifier for view_id has multiple parts.
`view_id.process_id`	`int` Time in microseconds.
`view_id.server_ip`	`int` The processing server.
`view_id.time_usec`	`int` The processing process.

DV360 YouTube ad group

dv360_youtube_adgroup
`adgroup_id`	`int` ID of DV360 ad group. Joins with adgroup_id in any adh.dv360_youtube table.
`adgroup_name`	`string` Ad group name.
`adgroup_status`	`string` The ad group. Possible values are: "status", "paused", or "enabled".
`adgroup_type`	`string` The ad group type. Possible values are: VIDEO_TRUE_VIEW_IN_STREAM, VIDEO_NON_SKIPPABLE_IN_STREAM, VIDEO_BUMPER, VIDEO_TRUE_VIEW_IN_DISPLAY.
`advertiser_id`	`int` Unique ID of the advertiser.
`campaign_id`	`int` Unique ID of the campaign.
`insertion_order_id`	`int` Unique ID of the insertion order.
`line_item_id`	`int` Unique ID of the line item.
`partner_id`	`int` Unique ID of the partner.

DV360 YouTube advertiser

dv360_youtube_advertiser
`advertiser_id`	`int` Unique ID of the advertiser.
`advertiser_name`	`string` Name of the advertiser.
`partner_id`	`int` Unique ID of the partner.

DV360 YouTube campaign

dv360_youtube_campaign
`advertiser_id`	`int` Unique ID of the advertiser.
`campaign_id`	`int` Unique ID of the campaign.
`campaign_name`	`string` Name of the campaign
`partner_id`	`int` Unique ID of the partner.

DV360 YouTube clicks

dv360_youtube_clicks
`adgroup_id`	`int` ID of DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table.
`advertiser_id`	`int` Unique ID of the advertiser.
`campaign_id`	`int` Unique ID of the campaign.
`click_id`	`struct` Unique identifier for click has multiple parts. Joins with click_id in any adh.dv360_youtube table.
`click_id.process_id`	`int` The processing process.
`click_id.server_ip`	`int` The processing server.
`click_id.time_usec`	`int` Time in microseconds.
`click_type`	`int` The click type.
`creative_id`	`int` Joins with creative_id in any adh.dv360_youtube table.
`impression_id`	`string` Unique identifier for impression.
`insertion_order_id`	`int` Unique ID of the insertion order.
`is_in_rdid_project`	`boolean` true if this event is also in the _rdid table. Used for deduplication of events.
`line_item_id`	`int` Unique ID of the line item.
`partner_id`	`int` Unique ID of the partner.
`query_id`	`struct` Unique identifier for query has multiple parts. Joins with query_id in any adh.dv360_youtube table.
`query_id.process_id`	`int` The processing process.
`query_id.server_ip`	`int` The processing server.
`query_id.time_usec`	`int` Time in microseconds.
`user_id`	`opaque` User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

DV360 YouTube conversions

dv360_youtube_conversions
`click_id`	`struct` Unique identifier for click has multiple parts. Joins with click_id in any adh.dv360_youtube table.
`click_id.process_id`	`int` The processing process.
`click_id.server_ip`	`int` The processing server.
`click_id.time_usec`	`int` Time in microseconds.
`conversion_id`	`struct` Unique identifier for conversion has multiple parts.
`conversion_id.process_id`	`int` The processing process.
`conversion_id.server_ip`	`int` The processing server.
`conversion_id.time_usec`	`int` Time in microseconds.
`conversion_type`	`int` The type of conversion.
`impression_data.adgroup_id`	`int` ID of DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table.
`impression_data.advertiser_id`	`int` Unique ID of the advertiser.
`impression_data.campaign_id`	`int` Unique ID of the campaign.
`impression_data.creative_id`	`int` Joins with creative_id in any adh.dv360_youtube table.
`impression_data.insertion_order_id`	`int` Unique ID of the insertion order.
`impression_data.line_item_id`	`int` Unique ID of the line item.
`impression_data.partner_id`	`int` Unique ID of the partner.
`impression_id`	`string` Unique identifier for impression.
`is_in_rdid_project`	`boolean` true if this event is also in the _rdid table. Used for deduplication of events.
`label`	`string` Name of conversion event.
`partner_id`	`int` Unique ID of the partner.
`query_id`	`struct` Unique identifier for query has multiple parts. Joins with query_id in any adh.dv360_youtube table.
`query_id.process_id`	`int` The processing process.
`query_id.server_ip`	`int` The processing server.
`query_id.time_usec`	`int` Time in microseconds.
`user_id`	`opaque` User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

DV360 YouTube creative

dv360_youtube_creative
`adgroup_id`	`int` ID of DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table.
`advertiser_id`	`int` Unique ID of the advertiser.
`campaign_id`	`int` Unique ID of the campaign.
`creative_id`	`int` Joins with creative_id in any adh.dv360_youtube table.
`creative_name`	`string` Creative name.
`creative_type`	`int` Creative type.
`insertion_order_id`	`int` Unique ID of the insertion order.
`is_masthead`	`boolean` True if this is a masthead creative.
`line_item_id`	`int` Unique ID of the line item.
`partner_id`	`int` Unique ID of the partner.
`third_party_vast_url`	`string` VAST url of the creative if the creative is a third party hosted video.
`video_message`	`struct` Multipart identifier for video data.
`video_message.video_ad_duration`	`int` Duration of the video in milliseconds.
`video_message.youtube_video_id`	`string` Video id string representation as it appears on YouTube watch url.

DV360 YouTube creative conversions

dv360_youtube_creative_conversions
`click_id`	`struct` Unique identifier for click has multiple parts. Joins with click_id in any adh.dv360_youtube table.
`click_id.process_id`	`int` The processing process.
`click_id.server_ip`	`int` The processing server.
`click_id.time_usec`	`int` Time in microseconds.
`conversion_id`	`struct` Unique identifier for conversion has multiple parts.
`conversion_id.process_id`	`int` The processing process.
`conversion_id.server_ip`	`int` The processing server.
`conversion_id.time_usec`	`int` Time in microseconds.
`conversion_type`	`int` The type of conversion.
`impression_data.adgroup_id`	`int` ID of the DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table.
`impression_data.advertiser_id`	`int` Unique ID of the advertiser.
`impression_data.campaign_id`	`int` Unique ID of the campaign.
`impression_data.creative_id`	`int` Joins with creative_id in any adh.dv360_youtube table.
`impression_data.insertion_order_id`	`int` Unique ID of the insertion order.
`impression_data.line_item_id`	`int` Unique ID of the line item.
`impression_data.partner_id`	`int` Unique ID of the partner.
`impression_id`	`string` Unique identifier for impression.
`is_in_rdid_project`	`boolean` trueif this event is also in the _rdid table. Used for deduplication of events.
`label`	`string` Name of conversion event.
`query_id`	`struct` Unique identifier for query has multiple parts. Joins with query_id in any adh.dv360_youtube table.
`query_id.process_id`	`int` The processing process.
`query_id.server_ip`	`int` The processing server.
`query_id.time_usec`	`int` Time in microseconds.
`user_id`	`opaque` User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

DV360 YouTube impressions

dv360_youtube_impressions
`adgroup_id`	`int` ID of DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table.
`advertiser_id`	`int` Unique ID of the advertiser.
`browser`	`string` Possible values are: "Chrome", "Cobalt", "Dalvik", "Edge", "Firefox", "IE", "Opera", "Other", "Safari", "Samsung Browser", "Roku", "Silk", "Unknown", "Yandex"
`campaign_id`	`int` Unique ID of the campaign.
`content_url`	`string` URL of the page on which ad appeared. Part of the url is removed for privacy.
`device_height`	`int` Device height in px.
`device_width`	`int` Device width in px.
`impression_id`	`string` Unique identifier for impression.
`insertion_order_id`	`int` Unique ID of the insertion order.
`inventory_type`	`enum` The inventory type. Possible values: YOUTUBE, YOUTUBE TV, SEARCH, GMAIL, OTHER. Other refers to either the Google Display or Video network.
`is_app_traffic`	`boolean` true if the event happened in a native app.
`is_in_rdid_project`	`boolean` true if this event is also in the _rdid table. Used for deduplication of events.
`line_item_id`	`int` Unique ID of the line item.
`location`	`struct` Unique identifier for location has multiple parts
`location.country`	`string`
`location.geo_city_id`	`int` Code for city. Joins with city_id in adh.city table.
`location.geo_metro`	`int` Code for metro region. Joins with metro_id in adh.metro table.
`location.geo_region`	`string` Region as string e.g. US-CA.
`mobile_browser_class`	`int` Type of browser. Possible values are: desktop, tablet, smart tv consoles, or mobile. Joins with mobile_browser_class_id in adh.mobile_browser_cltable.
`num_active_view_eligible_impression`	`int` 1 when impression is active view eligible; 0 when impression is not active view eligible.
`num_active_view_measurable_impression`	`int` 1 when impression is active view measurable; 0 when impression is not active view measurable.
`operating_system`	`string` Possible values are: "Android", "AppleTV", "Chrome OS", "Fire OS", "Google TV", "iOS", "Linux", "Mac", "Unknown", "PlayStation", "Roku", "Tizen", "Xbox", "Windows", "Windows Phone"
`operating_system_version_ids`	`array` (Deprecated) Use operating_system instead. ID of OS. Joins with operating_system_version_id in adh.os_version table.
`partner_id`	`int` Unique ID of the partner.
`physical_screen_height`	`int` Device screen height in mm.
`physical_screen_width`	`int` Device screen width in mm.
`publisher_domain`	`string` Domain of the page on which ad appeared.
`query_id`	`struct` Unique identifier for query has multiple parts. Joins with query_id in any adh.dv360_youtube table.
`query_id.process_id`	`int` The processing ID.
`query_id.server_ip`	`int` The processing server.
`query_id.time_usec`	`int` The query time in microseconds.
`query_language`	`string` Language used by user.
`user_id`	`opaque` User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

DV360 YouTube insertion order

dv360_youtube_insertion_order
`advertiser_id`	`int` Unique ID of the advertiser.
`campaign_id`	`int` Unique ID of the campaign.
`insertion_order_id`	`int` Unique ID of the insertion order.
`insertion_order_name`	`string` Name of the insertion order.
`partner_id`	`int` Unique ID of the partner.

DV360 YouTube line item

dv360_youtube_lineitem
`advertiser_id`	`int` Unique ID of the advertiser.
`campaign_id`	`int` Unique ID of the campaign.
`insertion_order_id`	`int` Unique ID of the insertion order.
`line_item_end_time`	`int` Unix timestamp in microseconds (1/1,000,000 second) for when the line item ended, i.e. 1330403779608570
`line_item_id`	`int` Unique ID of the line item.
`line_item_name`	`string` Name of the line item.
`line_item_reservation_type`	`enum` The type of the reservation. Can be either "Programmatic", "InstantReserve" or "None" (meaning standard auction).
`line_item_start_time`	`int` Unix timestamp in microseconds (1/1,000,000 second) for when the line item started, i.e. 1330403779608570
`line_item_status`	`int` Line item status. 3 = ACTIVE. 5 = PAUSED. 7 = DELETED.
`partner_id`	`int` Unique ID of the partner.

Freewheel Active Views

freewheel_active_views
`active_view`	`record` Active view
`ad_current_time_ms`	`int` The current time of the ad video playback in milliseconds
`ad_id`	`string` VAST ad_id
`freewheel_event_id`	`record` Unique identifier for query has multiple parts. Joins with event_id.
`freewheel_event_id.process_id`	`int` The processing process.
`freewheel_event_id.server_ip`	`int` The processing server.
`freewheel_event_id.time_usec`	`int` Time in microseconds.
`label`	`string` Name of conversion event.
`user_id`	`opaque` User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes..
`user_language`	`string` A three-letter ISO 639-2/bibliographic language code

Freewheel clicks

freewheel_clicks
`ad_current_time_ms`	`int` The current time of the ad video playback in milliseconds
`ad_id`	`string` VAST ad_id
`freewheel_event_id`	`record` Unique identifier for query has multiple parts. Joins with event_id.
`freewheel_event_id.process_id`	`int` The processing process.
`freewheel_event_id.server_ip`	`int` The processing server.
`freewheel_event_id.time_usec`	`int` Time in microseconds.
`label`	`string` Name of conversion event.
`user_id`	`opaque` User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes..
`user_language`	`string` A three-letter ISO 639-2/bibliographic language code

Freewheel creative pixels

freewheel_creative_pixels
`ad_id`	`string` Vast Ad ID.
`pixel_url`	`string` pixel URL.

Freewheel impressions

freewheel_impressions
`ad_current_time_ms`	`int` The current time of the ad video playback in milliseconds
`ad_id`	`string` VAST ad_id
`browser`	`string` Possible values are: "Chrome", "Cobalt", "Dalvik", "Edge", "Firefox", "IE", "Opera", "Other", "Safari", "Samsung Browser", "Roku", "Silk", "Unknown", "Yandex"
`content_url`	`string` URL of the page on which ad appeared. Part of the url is removed for privacy.
`freewheel_event_id`	`record` Unique identifier for query has multiple parts. Joins with event_id.
`freewheel_event_id.process_id`	`int` The processing process.
`freewheel_event_id.server_ip`	`int` The processing server.
`freewheel_event_id.time_usec`	`int` Time in microseconds.
`inventory_type`	`enum` The inventory type. Possible values: YOUTUBE, YOUTUBE TV, SEARCH, GMAIL, OTHER. Other refers to either the Google Display or Video network.
`is_app_traffic`	`bool` True if the event happened in a native app. FALSE if the event happened in HTML5 app or webview.
`label`	`string` Name of conversion event.
`location`	`struct` Unique identifier for location has multiple parts.
`location.country`	`string` Two character country code.
`location.geo_city_id`	`int` Code for city. Joins with city_id in adh.city table.
`location.geo_country_id`	`int`
`location.geo_region_id`	`int` Code for region.
`mobile_browser_class`	`int` Type of device. Possible values are: desktop, tablet, smart tv consoles, or mobile. Joins with mobile_browser_class_id in adh.mobile_browser_cltable.
`operating_system`	`string` Possible values are: "Android", "AppleTV", "Chrome OS", "Fire OS", "Google TV", "iOS", "Linux", "Mac", "Unknown", "PlayStation", "Roku", "Tizen", "Xbox", "Windows", "Windows Phone"
`publisher_domain`	`string` Domain of the page on which ad appeared.
`user_id`	`opaque` User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes..
`user_language`	`string` A three-letter ISO 639-2/bibliographic language code

Freewheel pixel

freewheel_pixel
`pixel_url`	`string` The pixel URL.

Google Ads Active Views

google_ads_active_views
`impression_data.ad_group_creative_id`	`int` ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table.
`impression_data.adgroup_id`	`int` ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table.
`impression_data.campaign_id`	`int` Unique ID of the campaign.
`impression_data.customer_id`	`int` ID of Google Ads customer. Joins with customer_id in any adh.google_ads table.
`impression_id`	`string` Unique identifier for impression.
`num_active_view_viewable_impression`	`int` 1 when impression is active view eligible; 0 when impression is not active view eligible.
`query_id`	`struct` Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
`query_id.process_id`	`int` The processing ID.
`query_id.server_ip`	`int` The processing server.
`query_id.time_usec`	`int` The query time in microseconds.
`view_id`	`struct` Unique identifier for view_id has multiple parts.
`view_id.process_id`	`int` Time in microseconds.
`view_id.server_ip`	`int` The processing server.
`view_id.time_usec`	`int` The processing process.

Google Ads ad group

google_ads_adgroup
`adgroup_id`	`int` ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table.
`adgroup_name`	`string` Ad group name.
`adgroup_status`	`string` The ad group. Possible values are: "status", "paused", or "enabled".
`adgroup_type`	`string` The ad group type. Possible values are: VIDEO_TRUE_VIEW_IN_STREAM, VIDEO_OUTSTREAM, VIDEO_TRUE_VIEW_IN_DISPLAY, VIDEO_BUMPER_IN_STREAM, VIDEO_NON_SKIPPABLE_IN_STREAM, DISPLAY, SEARCH, or OTHER.
`campaign_id`	`int` Unique ID of the campaign.
`customer_id`	`int` Joins with customer_id in any adh.google_ads table.
`label_ids`	`array` Joins with label_id in the adh.google_ads_label table.

Google Ads ad group creative

google_ads_adgroupcreative
`ad_group_creative_id`	`INT64` ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table.
`adgroup_creative_status`	`STRING` The status of the creative within the ad group.
`adgroup_id`	`INT64` ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table.
`creative_id`	`INT64` A unique identifier for the creative, specific to the ad group containing it. Joins with creative_id in any adh.google_ads table.
`customer_id`	`INT64` Joins with customer_id in any adh.google_ads table.
`label_ids`	`INT64` Joins with label_id in adh.google_ads tables that contain label_ids.

Google Ads campaign

google_ads_campaign
`advertising_channel_type`	`string` Advertising channel type. Possible values are: SEARCH, DISPLAY, VIDEO, or OTHER.
`campaign_id`	`int` Unique ID of the campaign.
`campaign_name`	`string` Campaign name.
`campaign_status`	`int` Campaign status. 3 = ACTIVE. 5 = PAUSED. 7 = DELETED.
`customer_id`	`int` Joins with customer_id in any adh.google_ads table.
`end_time`	`int` Timestamp when the campaign ends in milliseconds.
`label_ids`	`array` Joins with label_id in the adh.google_ads_label table.
`reservation_type`	`enum` The type of the reservation. Can be either "InstantReserve" or "None" (meaning standard auction).
`start_time`	`int` Timestamp when the campaign begins in milliseconds.

Google Ads clicks

google_ads_clicks
`click_id`	`struct` Unique identifier for click has multiple parts. Joins with click_id in any adh.google_ads table.
`click_id.process_id`	`int` The processing process.
`click_id.server_ip`	`int` The processing server.
`click_id.time_usec`	`int` Time in microseconds.
`click_type`	`int` The click type.
`impression_data.ad_group_creative_id`	`int` ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table.
`impression_data.adgroup_id`	`int` ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table.
`impression_data.campaign_id`	`int` Unique ID of the campaign.
`impression_data.customer_id`	`int` ID of Google Ads customer. Joins with customer_id in any adh.google_ads table.
`impression_id`	`string` Unique identifier for impression.
`is_in_rdid_project`	`boolean` true if this event is also in the _rdid table. Used for deduplication of events.
`query_id`	`struct` Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
`query_id.process_id`	`int` The processing process.
`query_id.server_ip`	`int` The processing server.
`query_id.time_usec`	`int` Time in microseconds.
`user_id`	`opaque` User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

Google Ads clicks audience

google_ads_clicks_audience
`click_id`	`struct` Unique identifier for click has multiple parts. Joins with click_id in any adh.google_ads table.
`click_id.process_id`	`int` The processing process.
`click_id.server_ip`	`int` The processing server.
`click_id.time_usec`	`int` Time in microseconds.
`click_type`	`int` The click type.
`impression_id`	`string` Unique identifier for impression.
`is_in_rdid_project`	`boolean` true if this event is also in the _rdid table. Used for deduplication of events.
`query_id`	`struct` Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
`query_id.process_id`	`int` The processing process.
`query_id.server_ip`	`int` The processing server.
`query_id.time_usec`	`int` Time in microseconds.
`user_id`	`opaque` User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

Google Ads conversions

google_ads_conversions
`click_id`	`struct` Unique identifier for click has multiple parts. Joins with click_id in any adh.google_ads table.
`click_id.process_id`	`int` The processing process.
`click_id.server_ip`	`int` The processing server.
`click_id.time_usec`	`int` Time in microseconds.
`conversion_id`	`struct` Unique identifier for conversion has multiple parts.
`conversion_id.process_id`	`int` The processing process.
`conversion_id.server_ip`	`int` The processing server.
`conversion_id.time_usec`	`int` Time in microseconds.
`conversion_type`	`int` The type of conversion.
`impression_data.ad_group_creative_id`	`int` ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table.
`impression_data.adgroup_id`	`int` ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table.
`impression_data.campaign_id`	`int` Unique ID of the campaign.
`impression_data.customer_id`	`int` ID of Google Ads customer. Joins with customer_id in any adh.google_ads table.
`impression_id`	`string` Unique identifier for impression.
`is_in_rdid_project`	`boolean` true if this event is also in the _rdid table. Used for deduplication of events.
`label`	`string` Name of conversion event.
`query_id`	`struct` Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
`query_id.process_id`	`int` The processing process.
`query_id.server_ip`	`int` The processing server.
`query_id.time_usec`	`int` Time in microseconds.
`user_id`	`opaque` User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

Google Ads conversions audience

google_ads_conversions_audience
`click_id`	`struct` Unique identifier for click has multiple parts. Joins with click_id in any adh.google_ads table.
`click_id.process_id`	`int` The processing process.
`click_id.server_ip`	`int` The processing server.
`click_id.time_usec`	`int` Time in microseconds.
`conversion_id`	`struct` Unique identifier for conversion has multiple parts.
`conversion_id.process_id`	`int` The processing process.
`conversion_id.server_ip`	`int` The processing server.
`conversion_id.time_usec`	`int` Time in microseconds.
`conversion_type`	`int` The type of conversion.
`impression_id`	`string` Unique identifier for impression.
`is_in_rdid_project`	`boolean` true if this event is also in the _rdid table. Used for deduplication of events.
`label`	`string` Name of conversion event.
`query_id`	`struct` Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
`query_id.process_id`	`int` The processing process.
`query_id.server_ip`	`int` The processing server.
`query_id.time_usec`	`int` Time in microseconds.
`user_id`	`opaque` User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

Google Ads creative

google_ads_creative
`creative_id`	`int` Joins with creative_id in any adh.google_ads table.
`creative_name`	`string` Creative name.
`creative_type`	`int` Creative type.
`customer_id`	`int` Joins with customer_id in any adh.google_ads table.
`template_id`	`int` Template ID of the creative.
`third_party_url`	`int` The VAST tag URL string, as seen in Google products.
`video_message`	`struct` Multipart identifier for video data.
`video_message.video_ad_duration`	`int` Duration of the video in milliseconds.
`video_message.youtube_video_id`	`string` Video id string representation as it appears on YouTube watch url.

Google Ads creative conversions

google_ads_creative_conversions
`click_id`	`struct` Unique identifier for click has multiple parts. Joins with click_id in any adh.google_ads table.
`click_id.process_id`	`int` The processing process.
`click_id.server_ip`	`int` The processing server.
`click_id.time_usec`	`int` Time in microseconds.
`conversion_id`	`struct` Unique identifier for conversion has multiple parts.
`conversion_id.process_id`	`int` The processing process.
`conversion_id.server_ip`	`int` The processing server.
`conversion_id.time_usec`	`int` Time in microseconds.
`conversion_type`	`int` The type of conversion.
`impression_data.ad_group_creative_id`	`int` ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table.
`impression_data.adgroup_id`	`int` ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table.
`impression_data.campaign_id`	`int` Unique ID of the campaign.
`impression_data.customer_id`	`int` ID of Google Ads customer. Joins with customer_id in any adh.google_ads table.
`impression_id`	`string` Unique identifier for impression.
`is_in_rdid_project`	`boolean` true if this event is also in the _rdid table. Used for deduplication of events.
`label`	`string` Name of conversion event.
`query_id`	`struct` Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
`query_id.process_id`	`int` The processing process.
`query_id.server_ip`	`int` The processing server.
`query_id.time_usec`	`int` Time in microseconds.
`user_id`	`opaque` User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

Google Ads creative vendor metadata

google_ads_creative_vendor_metadata
`creative_id`	`int` The Creative ID in Campaign Manager 360 UI.
`legacy_pixel`	`string`
`vendor_string`	`string`

Google Ads customer

google_ads_customer
`customer_company_name`	`string` Company name.
`customer_id`	`int` Joins with customer_id in any adh.google_ads table.
`customer_name`	`string` Customer name.
`external_customer_id`	`int` Joins with customer_id in any adh.google_ads table.
`mcc_ids`	`array` My Client Center Ids in Google Ads that this ADH customer is associated with.

Google Ads impressions

google_ads_impressions
`ad_group_creative_id`	`int` ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table.
`adgroup_id`	`int` ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table.
`browser`	`string` Possible values are: "Chrome", "Cobalt", "Dalvik", "Edge", "Firefox", "IE", "Opera", "Other", "Safari", "Samsung Browser", "Roku", "Silk", "Unknown", "Yandex"
`campaign_id`	`int` Unique ID of the campaign.
`content_url`	`string` URL of the page on which ad appeared. Part of the url is removed for privacy.
`customer_id`	`int` ID of Google Ads customer.Joins with customer_id in any adh.google_ads table.
`device_height`	`int` Device height in px.
`device_width`	`int` Device width in px.
`impression_id`	`string` Unique identifier for impression.
`inventory_type`	`enum` The inventory type. Possible values: YOUTUBE, YOUTUBE TV, SEARCH, GMAIL, OTHER. Other refers to either the Google Display or Video network.
`is_app_traffic`	`boolean` true if the event happened in a native app. FALSE if the event happened in HTML5 app or webview.
`is_in_rdid_project`	`boolean` true if this event is also in the _rdid table. Used for deduplication of events.
`location`	`struct` Unique identifier for location has multiple parts
`location.country`	`string`
`location.geo_city_id`	`int` Code for city. Joins with city_id in adh.city table.
`location.geo_metro`	`int` Code for metro region. Joins with metro_id in adh.metro table.
`location.geo_region`	`string` Region as string e.g. US-CA.
`mobile_browser_class`	`int` Type of device. Possible values are: desktop, tablet, smart tv consoles, or mobile. Joins with mobile_browser_class_id in adh.mobile_browser_cltable.
`num_active_view_eligible_impression`	`int` 1 when impression is active view eligible; 0 when impression is not active view eligible.
`num_active_view_measurable_impression`	`int` 1 when impression is active view measurable; 0 when impression is not active view measurable.
`operating_system`	`string` Possible values are: "Android", "AppleTV", "Chrome OS", "Fire OS", "Google TV", "iOS", "Linux", "Mac", "Unknown", "PlayStation", "Roku", "Tizen", "Xbox", "Windows", "Windows Phone"
`operating_system_version_ids`	`array` (Deprecated) Use operating_system instead. ID of OS. Joins with operating_system_version_id in adh.os_version table.
`physical_screen_height`	`int` Device screen height in mm.
`physical_screen_width`	`int` Device screen width in mm.
`publisher_domain`	`string` Domain of the page on which ad appeared.
`query_id`	`struct` Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
`query_id.process_id`	`int` The processing ID.
`query_id.server_ip`	`int` The processing server.
`query_id.time_usec`	`int` The query time in microseconds.
`query_language`	`string` Language used by user.
`user_id`	`opaque` User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

Google Ads label

google_ads_label
`customer_id`	`int` Joins with customer_id in any adh.google_ads table.
`description`	`string` Label description.
`label_id`	`int` Joins with label_id in adh.google_ads tables that contain label_ids.
`label_name`	`string` Label name.
`status`	`int` Label status. 1 = ENABLED. 2 = DELETED.

Metro

metro
`country_code`	`string` Two character country code.
`metro_abbrev`	`string` (Deprecated) Use metro_name instead. Abbreviated version of metro name.
`metro_code`	`string` (Deprecated) Use metro_name instead. The metropolitan area code.
`metro_id`	`int` Metro identifier.
`metro_name`	`string` Metro name.

Mobile browser class

mobile_browser_class
`mobile_browser_class_id`	`int` Mobile browser class identifier.
`mobile_browser_class_name`	`string` Name of the mobile browser class.

Operating system

operating_system
`mobile`	`boolean` True if the operating system is mobile.
`operating_system_id`	`int` Operating system identifier.
`operating_system_name`	`string` Operating system name.

Operating system version

os_version
`major_version`	`int` The major version number of the operating system.
`minor_version`	`int` The minor version of the operating system.
`operating_system_id`	`int` Unique ID of OS just for Data Transfer.
`operating_system_version_id`	`int` Operating system version identifier.
`operator_type`	`string` Possible values are OPERATOR_TYPE_EQUAL_TO, or OPERATOR_TYPE_GREATER_THAN_EQUAL_TO.
`platform_name`	`string` The platform name in English.

Partner Sold - Cross Sell Active Views

partner_sold_cross_sell_active_views
`impression_id`	`string` Unique identifier for impression.
`num_active_view_viewable_impression`	`int` 1 when impression is active view eligible; 0 when impression is not active view eligible.
`query_id`	`struct` Unique identifier for query has multiple parts. Joins with query_id.
`query_id.process_id`	`int` The processing ID.
`query_id.server_ip`	`int` The processing server.
`query_id.time_usec`	`int` The query time in microseconds.
`view_id`	`struct` Unique identifier for view has multiple parts.
`view_id.process_id`	`int` The processing ID.
`view_id.server_ip`	`int` The processing server.
`view_id.time_usec`	`int` The query time in microseconds.

Partner Sold - Cross Sell clicks

partner_sold_cross_sell_clicks
`click_id`	`struct` Unique identifier for click has multiple parts. Joins with click_id.
`click_id.process_id`	`int` The processing ID.
`click_id.server_ip`	`int` The processing server.
`click_id.time_usec`	`int` The query time in microseconds.
`click_type`	`int` The click type.
`impression_id`	`string` Unique identifier for impression.
`is_in_rdid_project`	`boolean` true if this event is also in the _rdid table. Used for deduplication of events.
`query_id`	`struct` Unique identifier for query has multiple parts. Joins with query_id.
`query_id.process_id`	`int` The processing ID.
`query_id.server_ip`	`int` The processing server.
`query_id.time_usec`	`int` The query time in microseconds.
`user_id`	`opaque` User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

Partner Sold - Cross Sell conversions

partner_sold_cross_sell_conversions
`click_id`	`struct` Unique identifier for click has multiple parts. Joins with click_id.
`click_id.process_id`	`int` The processing ID.
`click_id.server_ip`	`int` The processing server.
`click_id.time_usec`	`int` The query time in microseconds.
`conversion_id`	`struct` Unique identifier for conversion has multiple parts.
`conversion_id.process_id`	`int` The processing ID.
`conversion_id.server_ip`	`int` The processing server.
`conversion_id.time_usec`	`int` The query time in microseconds.
`conversion_type`	`int` The conversion type.
`impression_id`	`string` Unique identifier for impression.
`is_in_rdid_project`	`boolean` true if this event is also in the _rdid table. Used for deduplication of events.
`label`	`string` Name of conversion event.
`query_id`	`struct` Unique identifier for query has multiple parts.
`query_id.process_id`	`int` The processing ID.
`query_id.server_ip`	`int` The processing server.
`query_id.time_usec`	`int` The query time in microseconds.
`user_id`	`opaque` User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

Partner Sold - Cross Sell creative

partner_sold_cross_sell_creative
`creative_format_type`	`string` Some formats map directly to a type. Other types have multiple formats like: html, image, or video.
`creative_id`	`int` The ID of the creative.
`creative_name`	`string` Name of the creative.
`creative_type`	`string` The type of creative.
`third_party_vast_url`	`string` VAST url of the creative if the creative is a third party hosted video. Does not support creatives from programmatic items.
`video_message`	`struct` Multipart identifier for video data.
`video_message.video_ad_duration`	`int` Duration of the video in milliseconds.
`video_message.youtube_video_id`	`string` Video id string representation as it appears on YouTube watch url.

Partner Sold - Cross Sell creative pixels

partner_sold_cross_sell_creative_pixels
`ad_id`	`string` Unique ID of the ad.
`pixel_url`	`string` The pixel URL.

Partner Sold - Cross Sell GAM pixels

partner_sold_cross_sell_gam_pixels
`ad_id`	`string` Unique ID of the ad.
`pixel_url`	`string`

Partner Sold - Cross Sell impressions

partner_sold_cross_sell_impressions
`browser`	`string` Possible values are: "Chrome", "Cobalt", "Dalvik", "Edge", "Firefox", "IE", "Opera", "Other", "Safari", "Samsung Browser", "Roku", "Silk", "Unknown", "Yandex"
`content_url`	`string` URL of the page on which ad appeared. Part of the url is removed for privacy.
`creative_id`	`int` Joins with creative_id in any adh.yt table.
`device_height`	`int` Device height in pixels.
`device_width`	`int` Device width in pixels.
`gfp_placements`	`array` Ad Manager placement ID for this impression. Does not represent Campaign Manager 360 placement.
`impression_id`	`string` Unique identifier for impression.
`inventory_type`	`enum` The inventory type. Possible values: YOUTUBE, YOUTUBE TV, SEARCH, GMAIL, OTHER. Other refers to either the Google Display or Video network.
`is_in_rdid_project`	`boolean` true if this event is also in the _rdid table. Used for deduplication of events.
`line_item_id`	`int` Line item id for this impression.
`location`	`struct` Unique identifier for location has multiple parts.
`location.country`	`string` Code for country.
`location.geo_city_id`	`int` Code for city. Joins with city_id in adh.city table.
`location.geo_metro`	`int` Code for metrio region. Joins with metro_id in adh.metro table.
`location.geo_region`	`string` Region as a string (e.g. US-CA)
`mobile_browser_class`	`int` Type of device. Possible values are: desktop, tablet, smart tv consoles, or mobile. Joins with mobile_browser_class_id in adh.mobile_browser_cltable.
`num_active_view_eligible_impression`	`int` 1 when impression is active view eligible; 0 when impression is not active view eligible.
`num_active_view_measurable_impression`	`int` 1 when impression is active view measurable; 0 when impression is not active view measurable.
`operating_system`	`string` Possible values are: "Android", "AppleTV", "Chrome OS", "Fire OS", "Google TV", "iOS", "Linux", "Mac", "Unknown", "PlayStation", "Roku", "Tizen", "Xbox", "Windows", "Windows Phone"
`operating_system_version_ids`	`array` (Deprecated) Use operating_system instead. ID of operating system. Joins with operating_system_version_id in adh.os_version table.
`order_id`	`int` Order ID for the impression.
`physical_screen_height`	`int` Device height in mm.
`physical_screen_width`	`int` Device screen width in mm.
`publisher_domain`	`string` Domain of page on which ad appeared.
`query_id`	`struct` Unique identifier for query has multiple parts.
`query_id.process_id`	`int` The processing ID.
`query_id.server_ip`	`int` The processing server.
`query_id.time_usec`	`int` The query time in microseconds.
`query_language`	`string` Language used by user.
`user_id`	`opaque` User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

Partner Sold - Cross Sell line item

partner_sold_cross_sell_lineitem
`end_time`	`timestamp` Time the line item stopped being served.
`line_item_id`	`int` Ad Manager line item serving.
`line_item_name`	`string` Ad Manager line item name.
`order_id`	`int` Ad Manager Order identifier used for serving.
`order_name`	`string` Name of the insertion order.
`programmatic`	`boolean` true if the line item was programmatic.
`skippable_ad_type`	`string` Possible values are: "skippable", "not skippable", or "selectable".
`start_time`	`timestamp` Time the line item started to be served.

Partner Sold - Cross Sell order

partner_sold_cross_sell_order
`advertiser_id`	`int` Unique ID of the advertiser.
`advertiser_name`	`string` Publisher entered name.
`network_code`	`int` Ad Manager Publisher network code.
`order_id`	`int` Ad Manager Order identifier used for serving.
`order_name`	`string` Name of Ad Manager order.

Region

region
`country_code`	`string` Two character country code.
`region_code`	`string` Region code.
`region_id`	`int` Region identifier.
`region_name`	`string` Region name.

YouTube Reserve Active Views

yt_reserve_active_views
`impression_data.creative_id`	`int` The ID of the creative.
`impression_data.line_item_id`	`int` Line item id for this impression.
`impression_data.media_plan_id`	`int` ID of the YouTube Reserve media plan.
`impression_data.order_id`	`int`
`impression_id`	`string` Unique identifier for impression.
`num_active_view_viewable_impression`	`int` 1 when impression is active view viewable; 0 when impression is not active view viewable.
`query_id`	`struct` Unique identifier for query has multiple parts.
`query_id.process_id`	`int` The processing process.
`query_id.server_ip`	`int` The processing server.
`query_id.time_usec`	`int` Time in microseconds.
`view_id`	`struct` Unique identifier for view has multiple parts.
`view_id.process_id`	`int` The processing process.
`view_id.server_ip`	`int` The processing server.
`view_id.time_usec`	`int` Time in microseconds.

YouTube Reserve clicks

yt_reserve_clicks
`click_id`	`struct` Unique identifier for click has multiple parts.
`click_id.process_id`	`int` The processing process.
`click_id.server_ip`	`int` The processing server.
`click_id.time_usec`	`int` Time in microseconds.
`click_type`	`int` The click type.
`impression_data.creative_id`	`int` The ID of the creative.
`impression_data.line_item_id`	`int` Line item id for this impression.
`impression_data.media_plan_id`	`int` ID of the YouTube Reserve media plan.
`impression_data.order_id`	`int`
`impression_id`	`string` Unique identifier for impression.
`is_in_rdid_project`	`boolean` true if this event is also in the _rdid table. Used for deduplication of events.
`query_id`	`struct` Unique identifier for query has multiple parts.
`query_id.process_id`	`int` The processing process.
`query_id.server_ip`	`int` The processing server.
`query_id.time_usec`	`int` Time in microseconds.
`user_id`	`opaque` User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

YouTube Reserve conversions

yt_reserve_conversions
`click_id`	`struct` Unique identifier for click has multiple parts.
`click_id.process_id`	`int` The processing process.
`click_id.server_ip`	`int` The processing server.
`click_id.time_usec`	`int` Time in microseconds.
`conversion_id`	`struct` Unique identifier for conversion has multiple parts.
`conversion_id.process_id`	`int` The processing process.
`conversion_id.server_ip`	`int` The processing server.
`conversion_id.time_usec`	`int` Time in microseconds.
`conversion_type`	`int` The type of conversion.
`impression_data.creative_id`	`int` The ID of the creative.
`impression_data.line_item_id`	`int` Line item id for this impression.
`impression_data.media_plan_id`	`int` ID of the YouTube Reserve media plan.
`impression_data.order_id`	`int`
`impression_id`	`string` Unique identifier for impression.
`is_in_rdid_project`	`boolean` true if this event is also in the _rdid table. Used for deduplication of events.True if this event is also in the _rdid tabUsed for deduplication of events.
`label`	`string` Name of conversion event.
`query_id`	`struct` Unique identifier for query has multiple parts.
`query_id.process_id`	`int` The processing process.
`query_id.server_ip`	`int` The processing server.
`query_id.time_usec`	`int` Time in microseconds.
`user_id`	`opaque` User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

YouTube Reserve creative

yt_reserve_creative
`creative_format_type`	`string` Some formats map directly to a type. Other types have multiple formats like: html, image, or video.
`creative_id`	`int` The ID of the creative.
`creative_name`	`string` Name of the creative.
`creative_type`	`string` The type of creative.
`dcm_beacons`	`array` Multipart identifier for Campaign Manager 360 tracking pixel for ad.
`is_masthead`	`boolean` True if this is a masthead creative.
`third_party_vast_url`	`string` VAST url of the creative if the creative is a third party hosted video. Does not support creatives from programmatic items.
`video_message`	`struct` Multipart identifier for video data.
`video_message.video_ad_duration`	`int` Duration of the video in milliseconds.
`video_message.youtube_channel_id`	`string` Id of the channel that provides this video.
`video_message.youtube_video_id`	`string` Video id string representation as it appears on YouTube watch url.

YouTube Reserve creative conversions

yt_reserve_creative_conversions
`click_id`	`struct` Unique identifier for click has multiple parts.
`click_id.process_id`	`int` The processing process.
`click_id.server_ip`	`int` The processing server.
`click_id.time_usec`	`int` Time in microseconds.
`conversion_id`	`struct` Unique identifier for conversion has multiple parts.
`conversion_id.process_id`	`int` The processing process.
`conversion_id.server_ip`	`int` The processing server.
`conversion_id.time_usec`	`int` Time in microseconds.
`conversion_type`	`int` The type of conversion.
`impression_data.creative_id`	`int` ID of the creative.
`impression_data.line_item_id`	`int` Line item ID for this impression.
`impression_data.media_plan_id`	`int` ID of the YouTube Reserve media plan.
`impression_data.order_id`	`int` ID of Display and Video 360 customer. Joins with customer_id in any adh.dv360 table.
`is_in_rdid_project`	`boolean` true if this event is also in the _rdid table. Used for deduplication of events.True if this event is also in the _rdid tabUsed for deduplication of events.
`label`	`string` Name of conversion event.
`query_id`	`struct` Unique identifier for query has multiple parts.
`query_id.process_id`	`int` The processing process.
`query_id.server_ip`	`int` The processing server.
`query_id.time_usec`	`int` Time in microseconds.
`user_id`	`opaque` User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

YouTube Reserve impressions

yt_reserve_impressions
`browser`	`string` Possible values are: "Chrome", "Cobalt", "Dalvik", "Edge", "Firefox", "IE", "Opera", "Other", "Safari", "Samsung Browser", "Roku", "Silk", "Unknown", "Yandex"
`content_url`	`string` URL of the page on which ad appeared. Part of the url is removed for privacy.
`creative_id`	`int` The ID of the creative.
`device_height`	`int` Device height in px.
`device_width`	`int` Device width in px.
`impression_id`	`string` Unique identifier for impression.
`inventory_type`	`enum` The inventory type. Possible values: YOUTUBE, YOUTUBE TV, SEARCH, GMAIL, OTHER. Other refers to either the Google Display or Video network.
`is_app_traffic`	`boolean` true if the event happened in a native app. FALSE if the event happened in HTML5 app or webview.
`is_in_rdid_project`	`boolean` true if this event is also in the _rdid table. Used for deduplication of events.
`line_item_id`	`int` Line item id for this impression.
`location`	`struct` Unique identifier for location has multiple parts.
`location.country`	`string`
`location.geo_city_id`	`int` Code for city. Joins with city_id in adh.city table.
`location.geo_metro`	`int` Code for metro region. Joins with metro_id in adh.metro table.
`location.geo_region`	`string` Region as string, e.g. US-CA.
`media_plan_id`	`int` ID of the YouTube Reserve media plan.
`mobile_browser_class`	`int` Type of device. Possible values are: desktop, tablet, smart tv consoles, or mobile. Joins with mobile_browser_class_id in adh.mobile_browser_class table.
`num_active_view_eligible_impression`	`int` when impression is active view eligible; 0 when impression is not active view eligible.
`num_active_view_measurable_impression`	`int` 1 when impression is active view measurable; 0 when impression is not active view measurable.
`operating_system`	`string` Possible values are: "Android", "AppleTV", "Chrome OS", "Fire OS", "Google TV", "iOS", "Linux", "Mac", "Unknown", "PlayStation", "Roku", "Tizen", "Xbox", "Windows", "Windows Phone"
`operating_system_version_ids`	`array` (Deprecated) Use operating_system instead. ID of OS. Joins with operating_system_version_id in adh.os_version table.
`order_id`	`int`
`physical_screen_height`	`int` Device screen height in mm.
`physical_screen_width`	`int` Device screen width in mm.
`publisher_domain`	`string` Domain of page on which ad appeared.
`query_id`	`struct` Unique identifier for query has multiple parts.
`query_id.process_id`	`int` The processing process.
`query_id.server_ip`	`int` The processing server.
`query_id.time_usec`	`int` Time in microseconds.
`query_language`	`string` Language used by user.
`user_id`	`opaque` User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

YouTube Reserve line item

yt_reserve_lineitem
`creative_id`	`array` Array of creative ids for this line item. Joins with creative_id in any adh.yt table.
`end_time`	`timestamp` Time the line item stopped being served.
`line_item_id`	`int` Ad Manager line item serving.
`line_item_name`	`string` Ad Manager line item name.
`order_id`	`int` Ad Manager Order identifier used for serving.
`order_name`	`string` Name of the insertion order.
`programmatic`	`boolean` true if the line item was programmatic.
`skippable_ad_type`	`string` Possible values are: "skippable", "not skippable", or "selectable".
`start_time`	`timestamp` Time the line item started to be served.

YouTube Reserve order

yt_reserve_order
`advertiser_id`	`int` Unique ID of the advertiser.
`advertiser_name`	`string` User entered name of the advertiser.
`media_plan_id`	`int` ID of the YouTube Reserve media plan.
`media_plan_name`	`string` Name of the YouTube Reserve media plan.
`order_id`	`int` Ad Manager Order identifier used for serving.
`order_name`	`string` Name of Ad Manager order