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.

DV360 YouTube Active Views

dv360_youtube_active_views
Beginning in March 2024, use the Google service tables in place of dv360_youtube_active_views:
  • dv360_video_active_views_youtube
  • dv360_video_active_views_network
content_url string
URL of the page on which ad appeared. Part of the url is removed for privacy.
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_VIEW, VIDEO_REACH, VIDEO_ACTION, VIDEO_TRUE_VIEW_IN_STREAM, VIDEO_NON_SKIPPABLE_IN_STREAM,VIDEO_BUMPER, or 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.
advertiser_timezone string
The DV360 advertiser time zone default set in account settings.
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 (deprecated - use dv360_youtube_creative_conversions)

dv360_youtube_clicks
Beginning in March 2024, use the Google service tables in place of dv360_youtube_clicks:
  • dv360_video_clicks_youtube
  • dv360_video_clicks_network
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.
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.
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.
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 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.
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
Beginning in March 2024, use the Google service tables in place of dv360_youtube_creative_conversions:
  • dv360_video_creative_conversions_youtube
  • dv360_video_creative_conversions_network
advertiser_cost_local_micros double
The advertiser's cost in local currency micros.
advertiser_cost_usd double
The advertiser's click cost in dollars.
click_id struct
Unique identifier for click has multiple parts. Joins with click_id in any adh.dv360_youtube table.
click_id.process_id int
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.
content_url string
URL of the page on which ad appeared. Part of the url is removed for privacy.
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.
label string
Name of conversion event.
num_video_views int
Number of video views.
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
Beginning in March 2024, use the Google service tables in place of dv360_youtube_impressions:
  • dv360_video_impressions_youtube
  • dv360_video_impressions_network
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.
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_store_id int64
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.
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.
format_category string
YouTube ad format. Possible values are AUDIO, DISPLAY, VIDEO, UNSPECIFIED.
impression_id string
Unique identifier for impression.
insertion_order_id int
Unique ID of the insertion order.
inventory_type string
The inventory type. Possible values: YOUTUBE, YOUTUBE_TV, YOUTUBE_MUSIC, 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.
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.
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
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.
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_page_type string
Page type. Possible values are YOUTUBE_WATCH, YOUTUBE_HOME, YOUTUBE_SEARCH, or YOUTUBE_SHORTS.

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.

DV360 YouTube vendor reporting metadata

dv360_youtube_vendor_reporting_data
line_item_id int
Unique ID of the line item.
vendor_client_id string
All lower-case formatted vendor client id (VCID).
vendor_metric string
Measurement type.
vendor_reporting_id string
Customer-provided identifier to slice their data by.

Freewheel Active Views

freewheel_active_views
Beginning in March 2024, use the Google service tables in place of freewheel_active_views:
  • freewheel_active_views_youtube
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
Integer that identifies the process on the machine that generated the event.
freewheel_event_id.server_ip int
The IPv4 address of the server that generated this event.
freewheel_event_id.time_usec int
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
impression_id string
Unique identifier for an impression.
label string
Name of conversion event.
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..

Freewheel clicks

freewheel_clicks
Beginning in March 2024, use the Google service tables in place of freewheel_clicks:
  • freewheel_clicks_youtube
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
Integer that identifies the process on the machine that generated the event.
freewheel_event_id.server_ip int
The IPv4 address of the server that generated this event.
freewheel_event_id.time_usec int
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
impression_id string
Unique identifier for an impression.
label string
Name of conversion event.
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..

Freewheel creative pixels

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

Freewheel impressions

freewheel_impressions
Beginning in March 2024, use the Google service tables in place of freewheel_impressions:
  • freewheel_impressions_youtube
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.
format_category string
YouTube ad format. Possible values are AUDIO, DISPLAY, VIDEO, UNSPECIFIED.
freewheel_event_id record
Unique identifier for query has multiple parts. Joins with event_id.
freewheel_event_id.process_id int
Integer that identifies the process on the machine that generated the event.
freewheel_event_id.server_ip int
The IPv4 address of the server that generated this event.
freewheel_event_id.time_usec int
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
impression_id string
Unique identifier for an 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 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_class table.
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.
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_page_type enum
Page type. Possible values are YOUTUBE_WATCH, YOUTUBE_HOME, YOUTUBE_SEARCH, or YOUTUBE_SHORTS.

Freewheel pixel

freewheel_pixel
pixel_url string
The pixel URL.
google_ads_active_views
Beginning in March 2024, use the Google service tables in place of google_ads_active_views:
  • google_ads_active_views_youtube
  • google_ads_active_views_network
content_url string
URL of the page on which ad appeared. Part of the url is removed for privacy.
impression_data struct
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 bytes
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
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_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_adgroup
adgroup_id int
ID of Google Ads ad group. Joins with adgroup_id in any 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_VIEW, VIDEO_REACH, VIDEO_ACTION, 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<int64>
Label IDs. Joins with label_id in the adh.google_ads_label table.
google_ads_adgroupcreative
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_creative_status STRING
The status of the creative within the ad group.
adgroup_id int
ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table.
creative_id int
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 int
Google Ads account ID. Joins with customer_id in any adh.google_ads table.
label_ids array<int64>
Label IDs. Joins with label_id in the adh.google_ads_label table.
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
Google Ads account ID. Joins with customer_id in any adh.google_ads table.
end_time int
Timestamp when the campaign ends in milliseconds.
label_ids array<int64>
Label IDs. Joins with label_id in the adh.google_ads_label table.
reservation_type string
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
Beginning in March 2024, use the Google service tables in place of google_ads_clicks:
  • google_ads_clicks_youtube
  • google_ads_clicks_network
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 struct
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 bytes
Unique identifier for impression.
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
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 struct
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 bytes
Unique identifier for impression.
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
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 bytes
Unique identifier for impression.
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
creative_id int
A unique identifier for the creative, specific to the ad group containing it. 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
Beginning in March 2024, use the Google service tables in place of google_ads_creative_conversions:
  • google_ads_creative_conversions_youtube
  • google_ads_creative_conversions_network
advertiser_cost_local_micros double
The advertiser's cost in local currency micros.
advertiser_cost_usd double
The advertiser's click cost in dollars.
click_id struct
Unique identifier for click has multiple parts. Joins with click_id in any adh.google_ads table.
click_id.process_id int
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.
content_url string
URL of the page on which ad appeared. Part of the url is removed for privacy.
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 struct
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 bytes
Unique identifier for impression.
label string
Name of conversion event.
num_video_views int
Number of video views.
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
creative_id int
A unique identifier for the creative, specific to the ad group containing it. Joins with creative_id in any adh.google_ads table.
legacy_pixel string
vendor_string string
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.
customer_timezone string
Google Ads account setting for time zone.
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
Beginning in March 2024, use the Google service tables in place of google_ads_impressions:
  • google_ads_impressions_youtube
  • google_ads_impressions_network
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.
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_store_id int64
'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.'
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
Google Ads account ID. Joins with customer_id in any adh.google_ads table.
device_height int
Device height in px.
device_width int
Device width in px.
format_category string
"YouTube ad format. Possible values are AUDIO, DISPLAY, VIDEO, or UNSPECIFIED. Display includes infeed and masthead."
impression_id bytes
Unique identifier for impression.
inventory_type string
"The inventory type. Possible values: YOUTUBE, YOUTUBE_TV, YOUTUBE_MUSIC, 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.
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_country_id int
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.
location.geo_region_id int
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"
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
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.
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_page_type enum
Page type. Possible values are YOUTUBE_WATCH, YOUTUBE_HOME, YOUTUBE_SEARCH, or YOUTUBE_SHORTS.
google_ads_label
customer_id int
Google Ads account ID. Joins with customer_id in any adh.google_ads table.
description string
Label description.
label_id int64
Label ID. Joins with label_ids in adh.google_ads tables that contain label_ids.
label_name string
Label name.
status int
Label status. 1 = ENABLED. 2 = DELETED.
google_ads_vendor_reporting_data
campaign_id int
Unique ID of the campaign.
vendor_client_id string
All lower-case formatted vendor client id (VCID).
vendor_metric string
Measurement type.
vendor_reporting_id string
Customer-provided identifier to slice their data by.

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 int64
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
Beginning in March 2024, use the Google service tables in place of partner_sold_cross_sell_active_views:
  • partner_sold_cross_sell_active_views_youtube
content_url string
URL of the page on which ad appeared. Part of the url is removed for privacy.
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
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.

Partner Sold - Cross Sell clicks

partner_sold_cross_sell_clicks
Beginning in March 2024, use the Google service tables in place of partner_sold_cross_sell_clicks:
  • partner_sold_cross_sell_clicks_youtube
click_id struct
Unique identifier for click has multiple parts. Joins with click_id.
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.
query_id struct
Unique identifier for query has multiple parts. Joins with query_id.
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.

Partner Sold - Cross Sell conversions

partner_sold_cross_sell_conversions
Beginning in March 2024, use the Google service tables in place of partner_sold_cross_sell_conversions:
  • partner_sold_cross_sell_conversions_youtube
click_id struct
Unique identifier for click has multiple parts. Joins with click_id.
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 conversion type.
impression_id string
Unique identifier for impression.
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.

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.
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. 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 conversions

partner_sold_cross_sell_creative_conversions
Beginning in March 2024, use the Google service tables in place of partner_sold_cross_sell_creative_conversions:
  • partner_sold_cross_sell_creative_conversions_youtube
content_url string
URL of the page on which ad appeared. Part of the url is removed for privacy.

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 impressions

partner_sold_cross_sell_impressions
Beginning in March 2024, use the Google service tables in place of partner_sold_cross_sell_impressions:
  • partner_sold_cross_sell_impressions_youtube
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.
format_category string
YouTube ad format. Possible values are AUDIO, DISPLAY, VIDEO, UNSPECIFIED.
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.
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_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
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
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.
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_page_type enum
Page type. Possible values are YOUTUBE_WATCH, YOUTUBE_HOME, YOUTUBE_SEARCH, or YOUTUBE_SHORTS.

Partner Sold - Cross Sell line item

partner_sold_cross_sell_lineitem
creative_id int
The ID of the creative.
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.

Partner Sold - Cross Sell order

partner_sold_cross_sell_order
advertiser_id int
Unique ID of the advertiser.
advertiser_name string
Publisher entered name.
advertiser_timezone string
The Partner Sold time zone default in the Ad Manager network settings.
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.

Partner Sold - Cross Sell vendor reporting data.

partner_sold_cross_sell_vendor_reporting_data
line_item_id int
Unique ID of the line item.
vendor_client_id string
All lower-case formatted vendor client id (VCID).
vendor_metric string
Measurement type.
vendor_reporting_id string
Customer-provided identifier to slice their data by.

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
Beginning in March 2024, use the Google service tables in place of yt_reserve_active_views:
  • yt_reserve_active_views_youtube
content_url string
URL of the page on which ad appeared. Part of the url is removed for privacy.
impression_data struct
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 bytes
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
Beginning in March 2024, use the Google service tables in place of yt_reserve_clicks:
  • yt_reserve_clicks_youtube
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 struct
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 bytes
Unique identifier for impression.
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 struct
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 bytes
Unique identifier for impression.
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
Beginning in March 2024, use the Google service tables in place of yt_reserve_creative_conversions:
  • yt_reserve_creative_conversions_youtube
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.
content_url string
URL of the page on which ad appeared. Part of the url is removed for privacy.
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 struct
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 & Video 360 customer. Joins with customer_id in any adh.dv360 table.
impression_id bytes
Unique identifier for impression.
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
Beginning in March 2024, use the Google service tables in place of yt_reserve_impressions:
  • yt_reserve_impressions_youtube
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.
format_category string
YouTube ad format. Possible values are AUDIO, DISPLAY, VIDEO, UNSPECIFIED.
impression_id bytes
Unique identifier for impression.
inventory_type string
The inventory type. Possible values: YOUTUBE, YOUTUBE_TV, YOUTUBE_MUSIC, 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.
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_page_type enum
Page type. Possible values are YOUTUBE_WATCH, YOUTUBE_HOME, YOUTUBE_SEARCH, or YOUTUBE_SHORTS.

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.
advertiser_timezone string
The YouTube Reserve advertiser time zone default set in account settings.
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

YouTube Reserve vendor reporting metadata

yt_reserve_vendor_reporting_data
line_item_id int
Unique ID of the line item.
vendor_client_id string
All lower-case formatted vendor client id (VCID).
vendor_metric string
Measurement type.
vendor_reporting_id string
Customer-provided identifier to slice their data by.