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.
metro_code	string Metropolitan area code.

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
impression_data.adgroup_id	int ID of the Display & Video 360 YouTube ad group. Used as a join key 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 Unique ID of the creative.
impression_data.insertion_order_id	int The Display & Video 360 numerical ID for the insertion order related to the event, e.g. 1079941.
impression_data.line_item_id	int The Display & Video 360 numerical ID for the line item related to the event, e.g. 1155785.
impression_data.partner_id	int Unique ID of the partner.
impression_id	string Unique ID of the impression.
num_active_view_viewable_impression	int 1 = impression is active view eligible, 0 = impression isn't active view eligible.
query_id	struct Unique identifier for query has multiple parts.
query_id.process_id	int Integer that identifies the process on the machine that generated the event.
query_id.server_ip	int The IPv4 address of the server that managed the ad request. Used to identify unique events for joins.
query_id.time_usec	int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
view_id	struct Unique ID for view has multiple parts.
view_id.process_id	int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
view_id.server_ip	int The IPv4 address of the server that generated this event.
view_id.time_usec	int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.

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 Integer that identifies the process on the machine that generated the event.
click_id.server_ip	int The IPv4 address of the server that generated this event.
click_id.time_usec	int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + 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 (Will be deprecated September 12, 2021) 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 Integer that identifies the process on the machine that generated the event.
query_id.server_ip	int The IPv4 address of the server that generated this event.
query_id.time_usec	int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + 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 Integer that identifies the process on the machine that generated the event.
click_id.server_ip	int The IPv4 address of the server that generated this event.
click_id.time_usec	int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
conversion_id	struct Unique identifier for conversion has multiple parts.
conversion_id.process_id	int Integer that identifies the process on the machine that generated the event.
conversion_id.server_ip	int The IPv4 address of the server that generated this event.
conversion_id.time_usec	int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + 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 Integer that identifies the process on the machine that generated the event.
query_id.server_ip	int The IPv4 address of the server that generated this event.
query_id.time_usec	int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + 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 Multiple Display & Video 360 "advertisers" generally exist underneath a single partner. Vendor client IDs are saved here.
campaign_id	int Group of insertion Orders. Default targeting settings & cross-campaign frequency caps.
creative_id	int Vendor client IDs are saved here.
creative_name	string The name of the Display & Video 360 creative.
creative_type	int Enum corresponding to the creative type.
insertion_order_id	int Group of line item IDs. Frequency caps, pacing settings, partner costs, and default targeting criteria for line items.
is_masthead	boolean True if this is a masthead creative.
line_item_id	int Line items consist of a budget, a bid, and targeting. For YouTube buys, line items are identical to Campaigns in Google Ads. ADH linking happens here. Reporting IDs are saved here.
partner_id	int Represents agencies, trading desks, or large individual advertisers.
third_party_vast_url	string URL used for VAST (Video Ad Serving Template) redirect creatives. Formatting doesn't match yt_reserve_creative.third_party_vast_url.
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 Integer that identifies the process on the machine that generated the event.
click_id.server_ip	int The IPv4 address of the server that generated this event.
click_id.time_usec	int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
conversion_id	struct Unique identifier for conversion has multiple parts.
conversion_id.process_id	int Integer that identifies the process on the machine that generated the event.
conversion_id.server_ip	int The IPv4 address of the server that generated this event.
conversion_id.time_usec	int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + 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 (Will be deprecated September 12, 2021) 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.dv360_youtube table.
query_id.process_id	int Integer that identifies the process on the machine that generated the event.
query_id.server_ip	int The IPv4 address of the server that generated this event.
query_id.time_usec	int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + 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 (Will be deprecated September 12, 2021) 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 table.
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"
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 IPv4 address of the server that generated this event.
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 The Display & Video 360 numerical ID for the campaign related to the event, e.g. 164332.
insertion_order_id	int The Display & Video 360 numerical ID for the insertion order related to the event, e.g. 1079941.
line_item_end_time	int Unix timestamp in microseconds (1/1,000,000 second) for when the line item ended, e.g. 1330403779608570
line_item_id	int The Display & Video 360 numerical ID for the line item related to the event, e.g. 1155785.
line_item_name	string The Display & Video 360 name for the line item related to the event, e.g. 164332.
line_item_reservation_type	enum Reservation type for a Display & Video 360 line item. Can be one of "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, e.g. 1330403779608570
line_item_status	int Integer indicating the status of the line item. 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 IPv4 address of the server that generated this event.
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 The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
view_id.server_ip	int The IPv4 address of the server that generated this event.
view_id.time_usec	int Integer that identifies the process on the machine that generated the event.

Google Ads ad group

google_ads_adgroup
adgroup_id	int ID of Google Ads ad group. Used as a join key in adh.google_ads table.
adgroup_name	string Name of the ad group in Google Ads.
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", "YOUTUBE_AUDIO", or "OTHER".
campaign_id	int Unique ID of the campaign.
customer_id	int Google Ads account ID. Joins with customer_id in any adh.google_ads table.
label_ids	array Google Ads account ID. Joins with customer_id in any adh.google_ads 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 Google Ads account ID. 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 The primary serving target for ads within the campaign. It can be set only when a campaign is newly created in Google Ads. 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 Integer that identifies the process on the machine that generated the event.
click_id.server_ip	int The IPv4 address of the server that generated this event.
click_id.time_usec	int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + 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 (Will be deprecated September 12, 2021) 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 Integer that identifies the process on the machine that generated the event.
query_id.server_ip	int The IPv4 address of the server that generated this event.
query_id.time_usec	int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + 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 Integer that identifies the process on the machine that generated the event.
click_id.server_ip	int The IPv4 address of the server that generated this event.
click_id.time_usec	int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
click_type	int The click type.
impression_id	string Unique identifier for impression.
is_in_rdid_project	boolean (Will be deprecated September 12, 2021) 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 Integer that identifies the process on the machine that generated the event.
query_id.server_ip	int The IPv4 address of the server that generated this event.
query_id.time_usec	int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + 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 Integer that identifies the process on the machine that generated the event.
click_id.server_ip	int The IPv4 address of the server that generated this event.
click_id.time_usec	int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
conversion_id	struct Unique identifier for conversion has multiple parts.
conversion_id.process_id	int Integer that identifies the process on the machine that generated the event.
conversion_id.server_ip	int The IPv4 address of the server that generated this event.
conversion_id.time_usec	int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + 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 (Will be deprecated September 12, 2021) 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 Integer that identifies the process on the machine that generated the event.
query_id.server_ip	int The IPv4 address of the server that generated this event.
query_id.time_usec	int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + 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 Integer that identifies the process on the machine that generated the event.
click_id.server_ip	int The IPv4 address of the server that generated this event.
click_id.time_usec	int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
conversion_id	struct Unique identifier for conversion has multiple parts.
conversion_id.process_id	int Integer that identifies the process on the machine that generated the event.
conversion_id.server_ip	int The IPv4 address of the server that generated this event.
conversion_id.time_usec	int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
conversion_type	int The type of conversion.
impression_id	string Unique identifier for impression.
is_in_rdid_project	boolean (Will be deprecated September 12, 2021) 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 Integer that identifies the process on the machine that generated the event.
query_id.server_ip	int The IPv4 address of the server that generated this event.
query_id.time_usec	int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + 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 Google Ads account ID. 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 Integer that identifies the process on the machine that generated the event.
click_id.server_ip	int The IPv4 address of the server that generated this event.
click_id.time_usec	int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
conversion_id	struct Unique identifier for conversion has multiple parts.
conversion_id.process_id	int Integer that identifies the process on the machine that generated the event.
conversion_id.server_ip	int The IPv4 address of the server that generated this event.
conversion_id.time_usec	int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + 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 (Will be deprecated September 12, 2021) 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 Integer that identifies the process on the machine that generated the event.
query_id.server_ip	int The IPv4 address of the server that generated this event.
query_id.time_usec	int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + 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 Google Ads account ID. Joins with customer_id in any adh.google_ads table.
customer_name	string Google Ads account name.
external_customer_id	int Google Ads account ID.
mcc_ids	array My Client Center: dashboard view in Google Ads that is provided to large advertisers and third-party agencies who manage and optimize multiple Google Ads accounts.

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 (Will be deprecated September 12, 2021) 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 IPv4 address of the server that generated this event.
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_id	int Metro identifier.
metro_name	string Metro name.

Mobile app info

mobile_app_info
app_id	string Numerical identifier for the app's ID. Combined with the app_store_id, users can look up more information about the app. For example, 284815942 is the ID of Google's search app on Apple's App store. It only populates for Google Display Network (GDN) and Google Video Partner (GVP), which can be identified as INVENTORY_TYPE = OTHER. You can look up the app name by joining with the mobile_app_info table.
app_name	string The name of the app as it appears in the app store.
app_store_id	int Numerical identifier corresponding to the app store which the app belongs to. e.g. 1 = "Apple App Store", 2 = "Google Play", or 8 = "PlayStation Store". It only populates for Google Display Network (GDN) and Google Video Partner (GVP), which can be identified as INVENTORY_TYPE = OTHER. You can look up the app store name by joining with the mobile_app_info table.
app_store_name	string The name of the app store.

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.

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 (Will be deprecated September 12, 2021) 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 (Will be deprecated September 12, 2021) 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 (Will be deprecated September 12, 2021) 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"
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_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 Integer that identifies the process on the machine that generated the event.
query_id.server_ip	int The IPv4 address of the server that generated this event.
query_id.time_usec	int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
view_id	struct Unique identifier for view has multiple parts.
view_id.process_id	int Integer that identifies the process on the machine that generated the event.
view_id.server_ip	int The IPv4 address of the server that generated this event.
view_id.time_usec	int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.

YouTube Reserve clicks

yt_reserve_clicks
click_id	struct Unique identifier for click has multiple parts.
click_id.process_id	int Integer that identifies the process on the machine that generated the event.
click_id.server_ip	int The IPv4 address of the server that generated this event.
click_id.time_usec	int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + 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 (Will be deprecated September 12, 2021) 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 Integer that identifies the process on the machine that generated the event.
query_id.server_ip	int The IPv4 address of the server that generated this event.
query_id.time_usec	int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + 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 Integer that identifies the process on the machine that generated the event.
click_id.server_ip	int The IPv4 address of the server that generated this event.
click_id.time_usec	int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
conversion_id	struct Unique identifier for conversion has multiple parts.
conversion_id.process_id	int Integer that identifies the process on the machine that generated the event.
conversion_id.server_ip	int The IPv4 address of the server that generated this event.
conversion_id.time_usec	int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + 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 (Will be deprecated September 12, 2021) 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 Integer that identifies the process on the machine that generated the event.
query_id.server_ip	int The IPv4 address of the server that generated this event.
query_id.time_usec	int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + 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.
skippable_ad_type	string Possible values are: "SKIPPABLE", "NOT_SKIPPABLE", "UNKNOWN", or "OTHER".
third_party_vast_url	string VAST url of the creative if the creative is a third party hosted video. Doesn't support creatives from programmatic items. Formatting doesn't match dv360_youtube_creative.third_party_vast_url
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 Integer that identifies the process on the machine that generated the event.
click_id.server_ip	int The IPv4 address of the server that generated this event.
click_id.time_usec	int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
conversion_id	struct Unique identifier for conversion has multiple parts.
conversion_id.process_id	int Integer that identifies the process on the machine that generated the event.
conversion_id.server_ip	int The IPv4 address of the server that generated this event.
conversion_id.time_usec	int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + 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 (Will be deprecated September 12, 2021) 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 Integer that identifies the process on the machine that generated the event.
query_id.server_ip	int The IPv4 address of the server that generated this event.
query_id.time_usec	int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + 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 (Will be deprecated September 12, 2021) 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, which has multiple parts: geo_city_id, geo_metro, geo_region.
location.country	string Two-letter code for country, for example "US".
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 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"
order_id	int ID of the Google Ad Manager order.
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, which has multiple parts: process_id, server_ip, time_usec.
query_id.process_id	int ID of the process on the machine that generated the event.
query_id.server_ip	int IP address of the server that generated the event.
query_id.time_usec	int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + 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.
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