Ads Data Hub table schema- Vendors

Browser

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

City

city
city_idint
Unique ID of the city.
city_namestring
City name.
country_codestring
Two character country code.
latitudeint
(Deprecated) Use city or metro instead. Latitude in degrees.
longitudeint
(Deprecated) Use city or metro instead. Longitude in degrees.
metro_codestring
Metropolitan area code.
region_codestring
(Deprecated) Use region_name instead. The multi character code of the region

Campaign Manager 360 Data Transfer activities attributed

cm_dt_activities_attributed
event.dv360_bid_request_publisher_idstring
The publisher id in the publisher.id field of bid request.
event.dv360_supply_chain_completeboolean
Indicates whether the DV360 supply chain object is complete in the bid request.
event.dv360_supply_chain_domainarray
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_idarray
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_idstring
The publisher id in the publisher.id field of bid request.
event.dv360_supply_chain_completeboolean
Indicates whether the DV360 supply chain object is complete in the bid request.
event.dv360_supply_chain_domainarray
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_idarray
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_idstring
The publisher id in the publisher.id field of bid request.
event.dv360_supply_chain_completeboolean
Indicates whether the DV360 supply chain object is complete in the bid request.
event.dv360_supply_chain_domainarray
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_idarray
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_idstring
The publisher id in the publisher.id field of bid request.
event.dv360_supply_chain_completeboolean
Indicates whether the supply chain object is complete in the bid request.
event.dv360_supply_chain_domainarray
The domain in the supply path, the order is the same as the order in the supply chain JSON.
event.dv360_supply_chain_seller_idarray
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_idstring
The publisher id in the publisher.id field of bid request.
event.dv360_supply_chain_completeboolean
Indicates whether the supply chain object is complete in the bid request.
event.dv360_supply_chain_domainarray
The domain in the supply path, the order is the same as the order in the supply chain JSON.
event.dv360_supply_chain_seller_idarray
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_idstring
The publisher id in the publisher.id field of bid request.
event.dv360_supply_chain_completeboolean
Indicates whether the supply chain object is complete in the bid request.
event.dv360_supply_chain_domainarray
The domain in the supply path, the order is the same as the order in the supply chain JSON.
event.dv360_supply_chain_seller_idarray
Array of strings. The seller ID in the supply path, the order is the same as the order in the supply chain JSON.

DV360 YouTube Active View

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

DV360 YouTube ad group

dv360_youtube_adgroup
adgroup_idint
ID of DV360 ad group. Joins with adgroup_id in any adh.dv360_youtube table.
adgroup_namestring
Ad group name.
adgroup_statusstring
The ad group. Possible values are: "status", "paused", or "enabled".
adgroup_typestring
The ad group type. Possible values are: VIDEO_TRUE_VIEW_IN_STREAM, VIDEO_NON_SKIPPABLE_IN_STREAM, VIDEO_BUMPER, VIDEO_TRUE_VIEW_IN_DISPLAY.
advertiser_idint
Unique ID of the advertiser.
campaign_idint
Unique ID of the campaign.
insertion_order_idint
Unique ID of the insertion order.
line_item_idint
Unique ID of the line item.
partner_idint
Unique ID of the partner.

DV360 YouTube advertiser

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

DV360 YouTube campaign

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

DV360 YouTube clicks

dv360_youtube_clicks
adgroup_idint
ID of DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table.
advertiser_idint
Unique ID of the advertiser.
campaign_idint
Unique ID of the campaign.
click_idstruct
Unique identifier for click has multiple parts. Joins with click_id in any adh.dv360_youtube table.
click_id.process_idint
The processing process.
click_id.server_ipint
The processing server.
click_id.time_usecint
Time in microseconds.
click_typeint
The click type.
creative_idint
Joins with creative_id in any adh.dv360_youtube table.
impression_idstring
Unique identifier for impression.
insertion_order_idint
Unique ID of the insertion order.
is_in_rdid_projectboolean
true if this event is also in the _rdid table. Used for deduplication of events.
line_item_idint
Unique ID of the line item.
partner_idint
Unique ID of the partner.
query_idstruct
Unique identifier for query has multiple parts. Joins with query_id in any adh.dv360_youtube table.
query_id.process_idint
The processing process.
query_id.server_ipint
The processing server.
query_id.time_usecint
Time in microseconds.
user_idopaque
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_idstruct
Unique identifier for click has multiple parts. Joins with click_id in any adh.dv360_youtube table.
click_id.process_idint
The processing process.
click_id.server_ipint
The processing server.
click_id.time_usecint
Time in microseconds.
conversion_idstruct
Unique identifier for conversion has multiple parts.
conversion_id.process_idint
The processing process.
conversion_id.server_ipint
The processing server.
conversion_id.time_usecint
Time in microseconds.
conversion_typeint
The type of conversion.
impression_data.adgroup_idint
ID of DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table.
impression_data.advertiser_idint
Unique ID of the advertiser.
impression_data.campaign_idint
Unique ID of the campaign.
impression_data.creative_idint
Joins with creative_id in any adh.dv360_youtube table.
impression_data.insertion_order_idint
Unique ID of the insertion order.
impression_data.line_item_idint
Unique ID of the line item.
impression_data.partner_idint
Unique ID of the partner.
impression_idstring
Unique identifier for impression.
is_in_rdid_projectboolean
true if this event is also in the _rdid table. Used for deduplication of events.
labelstring
Name of conversion event.
partner_idint
Unique ID of the partner.
query_idstruct
Unique identifier for query has multiple parts. Joins with query_id in any adh.dv360_youtube table.
query_id.process_idint
The processing process.
query_id.server_ipint
The processing server.
query_id.time_usecint
Time in microseconds.
user_idopaque
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_idint
ID of DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table.
advertiser_idint
Unique ID of the advertiser.
campaign_idint
Unique ID of the campaign.
creative_idint
Joins with creative_id in any adh.dv360_youtube table.
creative_namestring
Creative name.
creative_typeint
Creative type.
insertion_order_idint
Unique ID of the insertion order.
is_mastheadboolean
True if this is a masthead creative.
line_item_idint
Unique ID of the line item.
partner_idint
Unique ID of the partner.
third_party_vast_urlstring
VAST url of the creative if the creative is a third party hosted video.
video_messagestruct
Multipart identifier for video data.
video_message.video_ad_durationint
Duration of the video in milliseconds.
video_message.youtube_video_idstring
Video id string representation as it appears on YouTube watch url.

DV360 YouTube creative conversions

dv360_youtube_creative_conversions
click_idstruct
Unique identifier for click has multiple parts. Joins with click_id in any adh.dv360_youtube table.
click_id.process_idint
The processing process.
click_id.server_ipint
The processing server.
click_id.time_usecint
Time in microseconds.
conversion_idstruct
Unique identifier for conversion has multiple parts.
conversion_id.process_idint
The processing process.
conversion_id.server_ipint
The processing server.
conversion_id.time_usecint
Time in microseconds.
conversion_typeint
The type of conversion.
impression_data.adgroup_idint
ID of the DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table.
impression_data.advertiser_idint
Unique ID of the advertiser.
impression_data.campaign_idint
Unique ID of the campaign.
impression_data.creative_idint
Joins with creative_id in any adh.dv360_youtube table.
impression_data.insertion_order_idint
Unique ID of the insertion order.
impression_data.line_item_idint
Unique ID of the line item.
impression_data.partner_idint
Unique ID of the partner.
impression_idstring
Unique identifier for impression.
is_in_rdid_projectboolean
trueif this event is also in the _rdid table. Used for deduplication of events.
labelstring
Name of conversion event.
query_idstruct
Unique identifier for query has multiple parts. Joins with query_id in any adh.dv360_youtube table.
query_id.process_idint
The processing process.
query_id.server_ipint
The processing server.
query_id.time_usecint
Time in microseconds.
user_idopaque
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_idint
ID of DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table.
advertiser_idint
Unique ID of the advertiser.
browserstring
Possible values are: "Chrome", "Cobalt", "Dalvik", "Edge", "Firefox", "IE", "Opera", "Other", "Safari", "Samsung Browser", "Roku", "Silk", "Unknown", "Yandex"
campaign_idint
Unique ID of the campaign.
content_urlstring
URL of the page on which ad appeared. Part of the url is removed for privacy.
device_heightint
Device height in px.
device_widthint
Device width in px.
impression_idstring
Unique identifier for impression.
insertion_order_idint
Unique ID of the insertion order.
inventory_typeenum
The inventory type. Possible values: YOUTUBE, YOUTUBE TV, SEARCH, GMAIL, OTHER. Other refers to either the Google Display or Video network.
is_app_trafficboolean
true if the event happened in a native app.
is_in_rdid_projectboolean
true if this event is also in the _rdid table. Used for deduplication of events.
line_item_idint
Unique ID of the line item.
locationstruct
Unique identifier for location has multiple parts
location.countrystring
location.geo_city_idint
Code for city. Joins with city_id in adh.city table.
location.geo_metroint
Code for metro region. Joins with metro_id in adh.metro table.
location.geo_regionstring
Region as string e.g. US-CA.
mobile_browser_classint
Type of browser. Possible values are: desktop, tablet, smart tv consoles, or mobile. Joins with mobile_browser_class_id in adh.mobile_browser_cltable.
num_active_view_eligible_impressionint
1 when impression is active view eligible; 0 when impression is not active view eligible.
num_active_view_measurable_impressionint
1 when impression is active view measurable; 0 when impression is not active view measurable.
operating_systemstring
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_idsarray
(Deprecated) Use operating_system instead. ID of OS. Joins with operating_system_version_id in adh.os_version table.
partner_idint
Unique ID of the partner.
physical_screen_heightint
Device screen height in mm.
physical_screen_widthint
Device screen width in mm.
publisher_domainstring
Domain of the page on which ad appeared.
query_idstruct
Unique identifier for query has multiple parts. Joins with query_id in any adh.dv360_youtube table.
query_id.process_idint
The processing ID.
query_id.server_ipint
The processing server.
query_id.time_usecint
The query time in microseconds.
query_languagestring
Language used by user.
user_idopaque
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_idint
Unique ID of the advertiser.
campaign_idint
Unique ID of the campaign.
insertion_order_idint
Unique ID of the insertion order.
insertion_order_namestring
Name of the insertion order.
partner_idint
Unique ID of the partner.

DV360 YouTube line item

dv360_youtube_lineitem
advertiser_idint
Unique ID of the advertiser.
campaign_idint
Unique ID of the campaign.
insertion_order_idint
Unique ID of the insertion order.
line_item_end_timeint
Unix timestamp in microseconds (1/1,000,000 second) for when the line item ended, i.e. 1330403779608570
line_item_idint
Unique ID of the line item.
line_item_namestring
Name of the line item.
line_item_reservation_typeenum
The type of the reservation. Can be either "Programmatic", "InstantReserve" or "None" (meaning standard auction).
line_item_start_timeint
Unix timestamp in microseconds (1/1,000,000 second) for when the line item started, i.e. 1330403779608570
line_item_statusint
Line item status. 3 = ACTIVE. 5 = PAUSED. 7 = DELETED.
partner_idint
Unique ID of the partner.

Freewheel Active Views

freewheel_active_views
active_viewrecord
Active view
ad_current_time_msint
The current time of the ad video playback in milliseconds
ad_idstring
VAST ad_id
freewheel_event_idrecord
Unique identifier for query has multiple parts. Joins with event_id.
freewheel_event_id.process_idint
The processing process.
freewheel_event_id.server_ipint
The processing server.
freewheel_event_id.time_usecint
Time in microseconds.
labelstring
Name of conversion event.
user_idopaque
User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes..
user_languagestring
A three-letter ISO 639-2/bibliographic language code

Freewheel clicks

freewheel_clicks
ad_current_time_msint
The current time of the ad video playback in milliseconds
ad_idstring
VAST ad_id
freewheel_event_idrecord
Unique identifier for query has multiple parts. Joins with event_id.
freewheel_event_id.process_idint
The processing process.
freewheel_event_id.server_ipint
The processing server.
freewheel_event_id.time_usecint
Time in microseconds.
labelstring
Name of conversion event.
user_idopaque
User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes..
user_languagestring
A three-letter ISO 639-2/bibliographic language code

Freewheel creative pixels

freewheel_creative_pixels
ad_idstring
Vast Ad ID.
pixel_urlstring
pixel URL.

Freewheel impressions

freewheel_impressions
ad_current_time_msint
The current time of the ad video playback in milliseconds
ad_idstring
VAST ad_id
browserstring
Possible values are: "Chrome", "Cobalt", "Dalvik", "Edge", "Firefox", "IE", "Opera", "Other", "Safari", "Samsung Browser", "Roku", "Silk", "Unknown", "Yandex"
content_urlstring
URL of the page on which ad appeared. Part of the url is removed for privacy.
freewheel_event_idrecord
Unique identifier for query has multiple parts. Joins with event_id.
freewheel_event_id.process_idint
The processing process.
freewheel_event_id.server_ipint
The processing server.
freewheel_event_id.time_usecint
Time in microseconds.
inventory_typeenum
The inventory type. Possible values: YOUTUBE, YOUTUBE TV, SEARCH, GMAIL, OTHER. Other refers to either the Google Display or Video network.
is_app_trafficbool
True if the event happened in a native app. FALSE if the event happened in HTML5 app or webview.
labelstring
Name of conversion event.
locationstruct
Unique identifier for location has multiple parts.
location.countrystring
Two character country code.
location.geo_city_idint
Code for city. Joins with city_id in adh.city table.
location.geo_country_idint
location.geo_region_idint
Code for region.
mobile_browser_classint
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_systemstring
Possible values are: "Android", "AppleTV", "Chrome OS", "Fire OS", "Google TV", "iOS", "Linux", "Mac", "Unknown", "PlayStation", "Roku", "Tizen", "Xbox", "Windows", "Windows Phone"
publisher_domainstring
Domain of the page on which ad appeared.
user_idopaque
User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes..
user_languagestring
A three-letter ISO 639-2/bibliographic language code

Freewheel pixel

freewheel_pixel
pixel_urlstring
The pixel URL.
google_ads_active_views
impression_data.ad_group_creative_idint
ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table.
impression_data.adgroup_idint
ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table.
impression_data.campaign_idint
Unique ID of the campaign.
impression_data.customer_idint
ID of Google Ads customer. Joins with customer_id in any adh.google_ads table.
impression_idstring
Unique identifier for impression.
num_active_view_viewable_impressionint
1 when impression is active view eligible; 0 when impression is not active view eligible.
query_idstruct
Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
query_id.process_idint
The processing ID.
query_id.server_ipint
The processing server.
query_id.time_usecint
The query time in microseconds.
view_idstruct
Unique identifier for view_id has multiple parts.
view_id.process_idint
Time in microseconds.
view_id.server_ipint
The processing server.
view_id.time_usecint
The processing process.
google_ads_adgroup
adgroup_idint
ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table.
adgroup_namestring
Ad group name.
adgroup_statusstring
The ad group. Possible values are: "status", "paused", or "enabled".
adgroup_typestring
The ad group type. Possible values are: VIDEO_TRUE_VIEW_IN_STREAM, VIDEO_OUTSTREAM, VIDEO_TRUE_VIEW_IN_DISPLAY, VIDEO_BUMPER_IN_STREAM, VIDEO_NON_SKIPPABLE_IN_STREAM, DISPLAY, SEARCH, or OTHER.
campaign_idint
Unique ID of the campaign.
customer_idint
Joins with customer_id in any adh.google_ads table.
label_idsarray
Joins with label_id in the adh.google_ads_label table.
google_ads_adgroupcreative
ad_group_creative_idINT64
ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table.
adgroup_creative_statusSTRING
The status of the creative within the ad group.
adgroup_idINT64
ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table.
creative_idINT64
A unique identifier for the creative, specific to the ad group containing it. Joins with creative_id in any adh.google_ads table.
customer_idINT64
Joins with customer_id in any adh.google_ads table.
label_idsINT64
Joins with label_id in adh.google_ads tables that contain label_ids.
google_ads_campaign
advertising_channel_typestring
Advertising channel type. Possible values are: SEARCH, DISPLAY, VIDEO, or OTHER.
campaign_idint
Unique ID of the campaign.
campaign_namestring
Campaign name.
campaign_statusint
Campaign status. 3 = ACTIVE. 5 = PAUSED. 7 = DELETED.
customer_idint
Joins with customer_id in any adh.google_ads table.
end_timeint
Timestamp when the campaign ends in milliseconds.
label_idsarray
Joins with label_id in the adh.google_ads_label table.
reservation_typeenum
The type of the reservation. Can be either "InstantReserve" or "None" (meaning standard auction).
start_timeint
Timestamp when the campaign begins in milliseconds.
google_ads_clicks
click_idstruct
Unique identifier for click has multiple parts. Joins with click_id in any adh.google_ads table.
click_id.process_idint
The processing process.
click_id.server_ipint
The processing server.
click_id.time_usecint
Time in microseconds.
click_typeint
The click type.
impression_data.ad_group_creative_idint
ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table.
impression_data.adgroup_idint
ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table.
impression_data.campaign_idint
Unique ID of the campaign.
impression_data.customer_idint
ID of Google Ads customer. Joins with customer_id in any adh.google_ads table.
impression_idstring
Unique identifier for impression.
is_in_rdid_projectboolean
true if this event is also in the _rdid table. Used for deduplication of events.
query_idstruct
Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
query_id.process_idint
The processing process.
query_id.server_ipint
The processing server.
query_id.time_usecint
Time in microseconds.
user_idopaque
User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.
google_ads_clicks_audience
click_idstruct
Unique identifier for click has multiple parts. Joins with click_id in any adh.google_ads table.
click_id.process_idint
The processing process.
click_id.server_ipint
The processing server.
click_id.time_usecint
Time in microseconds.
click_typeint
The click type.
impression_idstring
Unique identifier for impression.
is_in_rdid_projectboolean
true if this event is also in the _rdid table. Used for deduplication of events.
query_idstruct
Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
query_id.process_idint
The processing process.
query_id.server_ipint
The processing server.
query_id.time_usecint
Time in microseconds.
user_idopaque
User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.
google_ads_conversions
click_idstruct
Unique identifier for click has multiple parts. Joins with click_id in any adh.google_ads table.
click_id.process_idint
The processing process.
click_id.server_ipint
The processing server.
click_id.time_usecint
Time in microseconds.
conversion_idstruct
Unique identifier for conversion has multiple parts.
conversion_id.process_idint
The processing process.
conversion_id.server_ipint
The processing server.
conversion_id.time_usecint
Time in microseconds.
conversion_typeint
The type of conversion.
impression_data.ad_group_creative_idint
ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table.
impression_data.adgroup_idint
ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table.
impression_data.campaign_idint
Unique ID of the campaign.
impression_data.customer_idint
ID of Google Ads customer. Joins with customer_id in any adh.google_ads table.
impression_idstring
Unique identifier for impression.
is_in_rdid_projectboolean
true if this event is also in the _rdid table. Used for deduplication of events.
labelstring
Name of conversion event.
query_idstruct
Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
query_id.process_idint
The processing process.
query_id.server_ipint
The processing server.
query_id.time_usecint
Time in microseconds.
user_idopaque
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_idstruct
Unique identifier for click has multiple parts. Joins with click_id in any adh.google_ads table.
click_id.process_idint
The processing process.
click_id.server_ipint
The processing server.
click_id.time_usecint
Time in microseconds.
conversion_idstruct
Unique identifier for conversion has multiple parts.
conversion_id.process_idint
The processing process.
conversion_id.server_ipint
The processing server.
conversion_id.time_usecint
Time in microseconds.
conversion_typeint
The type of conversion.
impression_idstring
Unique identifier for impression.
is_in_rdid_projectboolean
true if this event is also in the _rdid table. Used for deduplication of events.
labelstring
Name of conversion event.
query_idstruct
Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
query_id.process_idint
The processing process.
query_id.server_ipint
The processing server.
query_id.time_usecint
Time in microseconds.
user_idopaque
User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.
google_ads_creative
creative_idint
Joins with creative_id in any adh.google_ads table.
creative_namestring
Creative name.
creative_typeint
Creative type.
customer_idint
Joins with customer_id in any adh.google_ads table.
template_idint
Template ID of the creative.
third_party_urlint
The VAST tag URL string, as seen in Google products.
video_messagestruct
Multipart identifier for video data.
video_message.video_ad_durationint
Duration of the video in milliseconds.
video_message.youtube_video_idstring
Video id string representation as it appears on YouTube watch url.
google_ads_creative_conversions
click_idstruct
Unique identifier for click has multiple parts. Joins with click_id in any adh.google_ads table.
click_id.process_idint
The processing process.
click_id.server_ipint
The processing server.
click_id.time_usecint
Time in microseconds.
conversion_idstruct
Unique identifier for conversion has multiple parts.
conversion_id.process_idint
The processing process.
conversion_id.server_ipint
The processing server.
conversion_id.time_usecint
Time in microseconds.
conversion_typeint
The type of conversion.
impression_data.ad_group_creative_idint
ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table.
impression_data.adgroup_idint
ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table.
impression_data.campaign_idint
Unique ID of the campaign.
impression_data.customer_idint
ID of Google Ads customer. Joins with customer_id in any adh.google_ads table.
impression_idstring
Unique identifier for impression.
is_in_rdid_projectboolean
true if this event is also in the _rdid table. Used for deduplication of events.
labelstring
Name of conversion event.
query_idstruct
Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
query_id.process_idint
The processing process.
query_id.server_ipint
The processing server.
query_id.time_usecint
Time in microseconds.
user_idopaque
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_idint
The Creative ID in Campaign Manager 360 UI.
legacy_pixelstring
vendor_stringstring
google_ads_customer
customer_company_namestring
Company name.
customer_idint
Joins with customer_id in any adh.google_ads table.
customer_namestring
Customer name.
external_customer_idint
Joins with customer_id in any adh.google_ads table.
mcc_idsarray
My Client Center Ids in Google Ads that this ADH customer is associated with.
google_ads_impressions
ad_group_creative_idint
ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table.
adgroup_idint
ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table.
browserstring
Possible values are: "Chrome", "Cobalt", "Dalvik", "Edge", "Firefox", "IE", "Opera", "Other", "Safari", "Samsung Browser", "Roku", "Silk", "Unknown", "Yandex"
campaign_idint
Unique ID of the campaign.
content_urlstring
URL of the page on which ad appeared. Part of the url is removed for privacy.
customer_idint
ID of Google Ads customer.Joins with customer_id in any adh.google_ads table.
device_heightint
Device height in px.
device_widthint
Device width in px.
impression_idstring
Unique identifier for impression.
inventory_typeenum
The inventory type. Possible values: YOUTUBE, YOUTUBE TV, SEARCH, GMAIL, OTHER. Other refers to either the Google Display or Video network.
is_app_trafficboolean
true if the event happened in a native app. FALSE if the event happened in HTML5 app or webview.
is_in_rdid_projectboolean
true if this event is also in the _rdid table. Used for deduplication of events.
locationstruct
Unique identifier for location has multiple parts
location.countrystring
location.geo_city_idint
Code for city. Joins with city_id in adh.city table.
location.geo_metroint
Code for metro region. Joins with metro_id in adh.metro table.
location.geo_regionstring
Region as string e.g. US-CA.
mobile_browser_classint
Type of 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_impressionint
1 when impression is active view eligible; 0 when impression is not active view eligible.
num_active_view_measurable_impressionint
1 when impression is active view measurable; 0 when impression is not active view measurable.
operating_systemstring
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_idsarray
(Deprecated) Use operating_system instead. ID of OS. Joins with operating_system_version_id in adh.os_version table.
physical_screen_heightint
Device screen height in mm.
physical_screen_widthint
Device screen width in mm.
publisher_domainstring
Domain of the page on which ad appeared.
query_idstruct
Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
query_id.process_idint
The processing ID.
query_id.server_ipint
The processing server.
query_id.time_usecint
The query time in microseconds.
query_languagestring
Language used by user.
user_idopaque
User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.
google_ads_label
customer_idint
Joins with customer_id in any adh.google_ads table.
descriptionstring
Label description.
label_idint
Joins with label_id in adh.google_ads tables that contain label_ids.
label_namestring
Label name.
statusint
Label status. 1 = ENABLED. 2 = DELETED.

Metro

metro
country_codestring
Two character country code.
metro_abbrevstring
(Deprecated) Use metro_name instead. Abbreviated version of metro name.
metro_codestring
(Deprecated) Use metro_name instead. The metropolitan area code.
metro_idint
Metro identifier.
metro_namestring
Metro name.

Mobile browser class

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

Operating system

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

Operating system version

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

Partner Sold - Cross Sell Active Views

partner_sold_cross_sell_active_views
impression_idstring
Unique identifier for impression.
num_active_view_viewable_impressionint
1 when impression is active view eligible; 0 when impression is not active view eligible.
query_idstruct
Unique identifier for query has multiple parts. Joins with query_id.
query_id.process_idint
The processing ID.
query_id.server_ipint
The processing server.
query_id.time_usecint
The query time in microseconds.
view_idstruct
Unique identifier for view has multiple parts.
view_id.process_idint
The processing ID.
view_id.server_ipint
The processing server.
view_id.time_usecint
The query time in microseconds.

Partner Sold - Cross Sell clicks

partner_sold_cross_sell_clicks
click_idstruct
Unique identifier for click has multiple parts. Joins with click_id.
click_id.process_idint
The processing ID.
click_id.server_ipint
The processing server.
click_id.time_usecint
The query time in microseconds.
click_typeint
The click type.
impression_idstring
Unique identifier for impression.
is_in_rdid_projectboolean
true if this event is also in the _rdid table. Used for deduplication of events.
query_idstruct
Unique identifier for query has multiple parts. Joins with query_id.
query_id.process_idint
The processing ID.
query_id.server_ipint
The processing server.
query_id.time_usecint
The query time in microseconds.
user_idopaque
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_idstruct
Unique identifier for click has multiple parts. Joins with click_id.
click_id.process_idint
The processing ID.
click_id.server_ipint
The processing server.
click_id.time_usecint
The query time in microseconds.
conversion_idstruct
Unique identifier for conversion has multiple parts.
conversion_id.process_idint
The processing ID.
conversion_id.server_ipint
The processing server.
conversion_id.time_usecint
The query time in microseconds.
conversion_typeint
The conversion type.
impression_idstring
Unique identifier for impression.
is_in_rdid_projectboolean
true if this event is also in the _rdid table. Used for deduplication of events.
labelstring
Name of conversion event.
query_idstruct
Unique identifier for query has multiple parts.
query_id.process_idint
The processing ID.
query_id.server_ipint
The processing server.
query_id.time_usecint
The query time in microseconds.
user_idopaque
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_typestring
Some formats map directly to a type. Other types have multiple formats like: html, image, or video.
creative_idint
The ID of the creative.
creative_namestring
Name of the creative.
creative_typestring
The type of creative.
third_party_vast_urlstring
VAST url of the creative if the creative is a third party hosted video. Does not support creatives from programmatic items.
video_messagestruct
Multipart identifier for video data.
video_message.video_ad_durationint
Duration of the video in milliseconds.
video_message.youtube_video_idstring
Video id string representation as it appears on YouTube watch url.

Partner Sold - Cross Sell creative pixels

partner_sold_cross_sell_creative_pixels
ad_idstring
Unique ID of the ad.
pixel_urlstring
The pixel URL.

Partner Sold - Cross Sell GAM pixels

partner_sold_cross_sell_gam_pixels
ad_idstring
Unique ID of the ad.
pixel_urlstring

Partner Sold - Cross Sell impressions

partner_sold_cross_sell_impressions
browserstring
Possible values are: "Chrome", "Cobalt", "Dalvik", "Edge", "Firefox", "IE", "Opera", "Other", "Safari", "Samsung Browser", "Roku", "Silk", "Unknown", "Yandex"
content_urlstring
URL of the page on which ad appeared. Part of the url is removed for privacy.
creative_idint
Joins with creative_id in any adh.yt table.
device_heightint
Device height in pixels.
device_widthint
Device width in pixels.
gfp_placementsarray
Ad Manager placement ID for this impression. Does not represent Campaign Manager 360 placement.
impression_idstring
Unique identifier for impression.
inventory_typeenum
The inventory type. Possible values: YOUTUBE, YOUTUBE TV, SEARCH, GMAIL, OTHER. Other refers to either the Google Display or Video network.
is_in_rdid_projectboolean
true if this event is also in the _rdid table. Used for deduplication of events.
line_item_idint
Line item id for this impression.
locationstruct
Unique identifier for location has multiple parts.
location.countrystring
Code for country.
location.geo_city_idint
Code for city. Joins with city_id in adh.city table.
location.geo_metroint
Code for metrio region. Joins with metro_id in adh.metro table.
location.geo_regionstring
Region as a string (e.g. US-CA)
mobile_browser_classint
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_impressionint
1 when impression is active view eligible; 0 when impression is not active view eligible.
num_active_view_measurable_impressionint
1 when impression is active view measurable; 0 when impression is not active view measurable.
operating_systemstring
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_idsarray
(Deprecated) Use operating_system instead. ID of operating system. Joins with operating_system_version_id in adh.os_version table.
order_idint
Order ID for the impression.
physical_screen_heightint
Device height in mm.
physical_screen_widthint
Device screen width in mm.
publisher_domainstring
Domain of page on which ad appeared.
query_idstruct
Unique identifier for query has multiple parts.
query_id.process_idint
The processing ID.
query_id.server_ipint
The processing server.
query_id.time_usecint
The query time in microseconds.
query_languagestring
Language used by user.
user_idopaque
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_timetimestamp
Time the line item stopped being served.
line_item_idint
Ad Manager line item serving.
line_item_namestring
Ad Manager line item name.
order_idint
Ad Manager Order identifier used for serving.
order_namestring
Name of the insertion order.
programmaticboolean
true if the line item was programmatic.
skippable_ad_typestring
Possible values are: "skippable", "not skippable", or "selectable".
start_timetimestamp
Time the line item started to be served.

Partner Sold - Cross Sell order

partner_sold_cross_sell_order
advertiser_idint
Unique ID of the advertiser.
advertiser_namestring
Publisher entered name.
network_codeint
Ad Manager Publisher network code.
order_idint
Ad Manager Order identifier used for serving.
order_namestring
Name of Ad Manager order.

Region

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

YouTube Reserve Active Views

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

YouTube Reserve clicks

yt_reserve_clicks
click_idstruct
Unique identifier for click has multiple parts.
click_id.process_idint
The processing process.
click_id.server_ipint
The processing server.
click_id.time_usecint
Time in microseconds.
click_typeint
The click type.
impression_data.creative_idint
The ID of the creative.
impression_data.line_item_idint
Line item id for this impression.
impression_data.media_plan_idint
ID of the YouTube Reserve media plan.
impression_data.order_idint
impression_idstring
Unique identifier for impression.
is_in_rdid_projectboolean
true if this event is also in the _rdid table. Used for deduplication of events.
query_idstruct
Unique identifier for query has multiple parts.
query_id.process_idint
The processing process.
query_id.server_ipint
The processing server.
query_id.time_usecint
Time in microseconds.
user_idopaque
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_idstruct
Unique identifier for click has multiple parts.
click_id.process_idint
The processing process.
click_id.server_ipint
The processing server.
click_id.time_usecint
Time in microseconds.
conversion_idstruct
Unique identifier for conversion has multiple parts.
conversion_id.process_idint
The processing process.
conversion_id.server_ipint
The processing server.
conversion_id.time_usecint
Time in microseconds.
conversion_typeint
The type of conversion.
impression_data.creative_idint
The ID of the creative.
impression_data.line_item_idint
Line item id for this impression.
impression_data.media_plan_idint
ID of the YouTube Reserve media plan.
impression_data.order_idint
impression_idstring
Unique identifier for impression.
is_in_rdid_projectboolean
true if this event is also in the _rdid table. Used for deduplication of events.True if this event is also in the _rdid tabUsed for deduplication of events.
labelstring
Name of conversion event.
query_idstruct
Unique identifier for query has multiple parts.
query_id.process_idint
The processing process.
query_id.server_ipint
The processing server.
query_id.time_usecint
Time in microseconds.
user_idopaque
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_typestring
Some formats map directly to a type. Other types have multiple formats like: html, image, or video.
creative_idint
The ID of the creative.
creative_namestring
Name of the creative.
creative_typestring
The type of creative.
dcm_beaconsarray
Multipart identifier for Campaign Manager 360 tracking pixel for ad.
is_mastheadboolean
True if this is a masthead creative.
third_party_vast_urlstring
VAST url of the creative if the creative is a third party hosted video. Does not support creatives from programmatic items.
video_messagestruct
Multipart identifier for video data.
video_message.video_ad_durationint
Duration of the video in milliseconds.
video_message.youtube_channel_idstring
Id of the channel that provides this video.
video_message.youtube_video_idstring
Video id string representation as it appears on YouTube watch url.

YouTube Reserve creative conversions

yt_reserve_creative_conversions
click_idstruct
Unique identifier for click has multiple parts.
click_id.process_idint
The processing process.
click_id.server_ipint
The processing server.
click_id.time_usecint
Time in microseconds.
conversion_idstruct
Unique identifier for conversion has multiple parts.
conversion_id.process_idint
The processing process.
conversion_id.server_ipint
The processing server.
conversion_id.time_usecint
Time in microseconds.
conversion_typeint
The type of conversion.
impression_data.creative_idint
ID of the creative.
impression_data.line_item_idint
Line item ID for this impression.
impression_data.media_plan_idint
ID of the YouTube Reserve media plan.
impression_data.order_idint
ID of Display and Video 360 customer. Joins with customer_id in any adh.dv360 table.
is_in_rdid_projectboolean
true if this event is also in the _rdid table. Used for deduplication of events.True if this event is also in the _rdid tabUsed for deduplication of events.
labelstring
Name of conversion event.
query_idstruct
Unique identifier for query has multiple parts.
query_id.process_idint
The processing process.
query_id.server_ipint
The processing server.
query_id.time_usecint
Time in microseconds.
user_idopaque
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
browserstring
Possible values are: "Chrome", "Cobalt", "Dalvik", "Edge", "Firefox", "IE", "Opera", "Other", "Safari", "Samsung Browser", "Roku", "Silk", "Unknown", "Yandex"
content_urlstring
URL of the page on which ad appeared. Part of the url is removed for privacy.
creative_idint
The ID of the creative.
device_heightint
Device height in px.
device_widthint
Device width in px.
impression_idstring
Unique identifier for impression.
inventory_typeenum
The inventory type. Possible values: YOUTUBE, YOUTUBE TV, SEARCH, GMAIL, OTHER. Other refers to either the Google Display or Video network.
is_app_trafficboolean
true if the event happened in a native app. FALSE if the event happened in HTML5 app or webview.
is_in_rdid_projectboolean
true if this event is also in the _rdid table. Used for deduplication of events.
line_item_idint
Line item id for this impression.
locationstruct
Unique identifier for location has multiple parts.
location.countrystring
location.geo_city_idint
Code for city. Joins with city_id in adh.city table.
location.geo_metroint
Code for metro region. Joins with metro_id in adh.metro table.
location.geo_regionstring
Region as string, e.g. US-CA.
media_plan_idint
ID of the YouTube Reserve media plan.
mobile_browser_classint
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_impressionint
when impression is active view eligible; 0 when impression is not active view eligible.
num_active_view_measurable_impressionint
1 when impression is active view measurable; 0 when impression is not active view measurable.
operating_systemstring
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_idsarray
(Deprecated) Use operating_system instead. ID of OS. Joins with operating_system_version_id in adh.os_version table.
order_idint
physical_screen_heightint
Device screen height in mm.
physical_screen_widthint
Device screen width in mm.
publisher_domainstring
Domain of page on which ad appeared.
query_idstruct
Unique identifier for query has multiple parts.
query_id.process_idint
The processing process.
query_id.server_ipint
The processing server.
query_id.time_usecint
Time in microseconds.
query_languagestring
Language used by user.
user_idopaque
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_idarray
Array of creative ids for this line item. Joins with creative_id in any adh.yt table.
end_timetimestamp
Time the line item stopped being served.
line_item_idint
Ad Manager line item serving.
line_item_namestring
Ad Manager line item name.
order_idint
Ad Manager Order identifier used for serving.
order_namestring
Name of the insertion order.
programmaticboolean
true if the line item was programmatic.
skippable_ad_typestring
Possible values are: "skippable", "not skippable", or "selectable".
start_timetimestamp
Time the line item started to be served.

YouTube Reserve order

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