Browser
browser | |
---|---|
browser_id | int Browser identifier. |
browser_name | string Browser name. |
major_version | string Major version of the browser (whole number version). |
minor_version | string Minor version of the browser (incremental or decimal version). |
City
city | |
---|---|
city_id | int Unique ID of the city. |
city_name | string City name. |
country_code | string Two character country code. |
latitude | int (Deprecated) Use city or metro instead. Latitude in degrees. |
longitude | int (Deprecated) Use city or metro instead. Longitude in degrees. |
metro_code | string Metropolitan area code. |
region_code | string (Deprecated) Use region_name instead. The multi character code of the region |
Campaign Manager 360 Data Transfer activities attributed
cm_dt_activities_attributed | |
---|---|
event.dv360_bid_request_publisher_id | string The publisher id in the publisher.id field of bid request. |
event.dv360_supply_chain_complete | boolean Indicates whether the DV360 supply chain object is complete in the bid request. |
event.dv360_supply_chain_domain | array The domain in the DV360 supply path, the order is the same as the order in the supply chain JSON. |
event.dv360_supply_chain_seller_id | array Array of strings. The seller ID in the DV360 supply path, the order is the same as the order in the supply chain JSON. |
Campaign Manager 360 Data Transfer clicks
cm_dt_clicks | |
---|---|
event.dv360_bid_request_publisher_id | string The publisher id in the publisher.id field of bid request. |
event.dv360_supply_chain_complete | boolean Indicates whether the DV360 supply chain object is complete in the bid request. |
event.dv360_supply_chain_domain | array The domain in the DV360 supply path, the order is the same as the order in the supply chain JSON. |
event.dv360_supply_chain_seller_id | array Array of strings. The seller ID in the DV360 supply path, the order is the same as the order in the supply chain JSON. |
Campaign Manager 360 Data Transfer impressions
cm_dt_impressions | |
---|---|
event.dv360_bid_request_publisher_id | string The publisher id in the publisher.id field of bid request. |
event.dv360_supply_chain_complete | boolean Indicates whether the DV360 supply chain object is complete in the bid request. |
event.dv360_supply_chain_domain | array The domain in the DV360 supply path, the order is the same as the order in the supply chain JSON. |
event.dv360_supply_chain_seller_id | array Array of strings. The seller ID in the DV360 supply path, the order is the same as the order in the supply chain JSON. |
DV360 Data Transfer activities attributed
dv360_dt_activities_attributed | |
---|---|
event.dv360_bid_request_publisher_id | string The publisher id in the publisher.id field of bid request. |
event.dv360_supply_chain_complete | boolean Indicates whether the supply chain object is complete in the bid request. |
event.dv360_supply_chain_domain | array The domain in the supply path, the order is the same as the order in the supply chain JSON. |
event.dv360_supply_chain_seller_id | array Array of strings. The seller ID in the supply path, the order is the same as the order in the supply chain JSON. |
DV360 Data Transfer clicks
dv360_dt_clicks | |
---|---|
event.dv360_bid_request_publisher_id | string The publisher id in the publisher.id field of bid request. |
event.dv360_supply_chain_complete | boolean Indicates whether the supply chain object is complete in the bid request. |
event.dv360_supply_chain_domain | array The domain in the supply path, the order is the same as the order in the supply chain JSON. |
event.dv360_supply_chain_seller_id | array Array of strings. The seller ID in the supply path, the order is the same as the order in the supply chain JSON. |
DV360 Data Transfer impressions
dv360_dt_impressions | |
---|---|
event.dv360_bid_request_publisher_id | string The publisher id in the publisher.id field of bid request. |
event.dv360_supply_chain_complete | boolean Indicates whether the supply chain object is complete in the bid request. |
event.dv360_supply_chain_domain | array The domain in the supply path, the order is the same as the order in the supply chain JSON. |
event.dv360_supply_chain_seller_id | array Array of strings. The seller ID in the supply path, the order is the same as the order in the supply chain JSON. |
DV360 YouTube Active View
dv360_youtube_active_views | |
---|---|
adgroup_id | int ID of DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table. |
advertiser_id | int Unique ID of the advertiser. |
campaign_id | int Unique ID of the campaign. |
creative_id | int Joins with creative_id in any adh.dv360_youtube table. |
impression_id | string Unique identifier for impression. |
insertion_order_id | int Unique ID of the insertion order. |
line_item_id | int Unique ID of the line item. |
num_active_view_viewable_impression | int 1 when impression is active view eligible; 0 when impression is not active view eligible. |
partner_id | int Unique ID of the partner. |
query_id | struct Unique identifier for query has multiple parts. Joins with query_id in any adh.dv360_youtube table. |
query_id.process_id | int The processing ID. |
query_id.server_ip | int The processing server. |
query_id.time_usec | int The query time in microseconds. |
view_id | struct Unique identifier for view_id has multiple parts. |
view_id.process_id | int Time in microseconds. |
view_id.server_ip | int The processing server. |
view_id.time_usec | int The processing process. |
DV360 YouTube ad group
dv360_youtube_adgroup | |
---|---|
adgroup_id | int ID of DV360 ad group. Joins with adgroup_id in any adh.dv360_youtube table. |
adgroup_name | string Ad group name. |
adgroup_status | string The ad group. Possible values are: "status", "paused", or "enabled". |
adgroup_type | string The ad group type. Possible values are: VIDEO_TRUE_VIEW_IN_STREAM, VIDEO_NON_SKIPPABLE_IN_STREAM, VIDEO_BUMPER, VIDEO_TRUE_VIEW_IN_DISPLAY. |
advertiser_id | int Unique ID of the advertiser. |
campaign_id | int Unique ID of the campaign. |
insertion_order_id | int Unique ID of the insertion order. |
line_item_id | int Unique ID of the line item. |
partner_id | int Unique ID of the partner. |
DV360 YouTube advertiser
dv360_youtube_advertiser | |
---|---|
advertiser_id | int Unique ID of the advertiser. |
advertiser_name | string Name of the advertiser. |
partner_id | int Unique ID of the partner. |
DV360 YouTube campaign
dv360_youtube_campaign | |
---|---|
advertiser_id | int Unique ID of the advertiser. |
campaign_id | int Unique ID of the campaign. |
campaign_name | string Name of the campaign |
partner_id | int Unique ID of the partner. |
DV360 YouTube clicks
dv360_youtube_clicks | |
---|---|
adgroup_id | int ID of DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table. |
advertiser_id | int Unique ID of the advertiser. |
campaign_id | int Unique ID of the campaign. |
click_id | struct Unique identifier for click has multiple parts. Joins with click_id in any adh.dv360_youtube table. |
click_id.process_id | int The processing process. |
click_id.server_ip | int The processing server. |
click_id.time_usec | int Time in microseconds. |
click_type | int The click type. |
creative_id | int Joins with creative_id in any adh.dv360_youtube table. |
impression_id | string Unique identifier for impression. |
insertion_order_id | int Unique ID of the insertion order. |
is_in_rdid_project | boolean true if this event is also in the _rdid table. Used for deduplication of events. |
line_item_id | int Unique ID of the line item. |
partner_id | int Unique ID of the partner. |
query_id | struct Unique identifier for query has multiple parts. Joins with query_id in any adh.dv360_youtube table. |
query_id.process_id | int The processing process. |
query_id.server_ip | int The processing server. |
query_id.time_usec | int Time in microseconds. |
user_id | opaque User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes. |
DV360 YouTube conversions
dv360_youtube_conversions | |
---|---|
click_id | struct Unique identifier for click has multiple parts. Joins with click_id in any adh.dv360_youtube table. |
click_id.process_id | int The processing process. |
click_id.server_ip | int The processing server. |
click_id.time_usec | int Time in microseconds. |
conversion_id | struct Unique identifier for conversion has multiple parts. |
conversion_id.process_id | int The processing process. |
conversion_id.server_ip | int The processing server. |
conversion_id.time_usec | int Time in microseconds. |
conversion_type | int The type of conversion. |
impression_data.adgroup_id | int ID of DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table. |
impression_data.advertiser_id | int Unique ID of the advertiser. |
impression_data.campaign_id | int Unique ID of the campaign. |
impression_data.creative_id | int Joins with creative_id in any adh.dv360_youtube table. |
impression_data.insertion_order_id | int Unique ID of the insertion order. |
impression_data.line_item_id | int Unique ID of the line item. |
impression_data.partner_id | int Unique ID of the partner. |
impression_id | string Unique identifier for impression. |
is_in_rdid_project | boolean true if this event is also in the _rdid table. Used for deduplication of events. |
label | string Name of conversion event. |
partner_id | int Unique ID of the partner. |
query_id | struct Unique identifier for query has multiple parts. Joins with query_id in any adh.dv360_youtube table. |
query_id.process_id | int The processing process. |
query_id.server_ip | int The processing server. |
query_id.time_usec | int Time in microseconds. |
user_id | opaque User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes. |
DV360 YouTube creative
dv360_youtube_creative | |
---|---|
adgroup_id | int ID of DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table. |
advertiser_id | int Unique ID of the advertiser. |
campaign_id | int Unique ID of the campaign. |
creative_id | int Joins with creative_id in any adh.dv360_youtube table. |
creative_name | string Creative name. |
creative_type | int Creative type. |
insertion_order_id | int Unique ID of the insertion order. |
is_masthead | boolean True if this is a masthead creative. |
line_item_id | int Unique ID of the line item. |
partner_id | int Unique ID of the partner. |
third_party_vast_url | string VAST url of the creative if the creative is a third party hosted video. |
video_message | struct Multipart identifier for video data. |
video_message.video_ad_duration | int Duration of the video in milliseconds. |
video_message.youtube_video_id | string Video id string representation as it appears on YouTube watch url. |
DV360 YouTube creative conversions
dv360_youtube_creative_conversions | |
---|---|
click_id | struct Unique identifier for click has multiple parts. Joins with click_id in any adh.dv360_youtube table. |
click_id.process_id | int The processing process. |
click_id.server_ip | int The processing server. |
click_id.time_usec | int Time in microseconds. |
conversion_id | struct Unique identifier for conversion has multiple parts. |
conversion_id.process_id | int The processing process. |
conversion_id.server_ip | int The processing server. |
conversion_id.time_usec | int Time in microseconds. |
conversion_type | int The type of conversion. |
impression_data.adgroup_id | int ID of the DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table. |
impression_data.advertiser_id | int Unique ID of the advertiser. |
impression_data.campaign_id | int Unique ID of the campaign. |
impression_data.creative_id | int Joins with creative_id in any adh.dv360_youtube table. |
impression_data.insertion_order_id | int Unique ID of the insertion order. |
impression_data.line_item_id | int Unique ID of the line item. |
impression_data.partner_id | int Unique ID of the partner. |
impression_id | string Unique identifier for impression. |
is_in_rdid_project | boolean trueif this event is also in the _rdid table. Used for deduplication of events. |
label | string Name of conversion event. |
query_id | struct Unique identifier for query has multiple parts. Joins with query_id in any adh.dv360_youtube table. |
query_id.process_id | int The processing process. |
query_id.server_ip | int The processing server. |
query_id.time_usec | int Time in microseconds. |
user_id | opaque User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes. |
DV360 YouTube impressions
dv360_youtube_impressions | |
---|---|
adgroup_id | int ID of DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table. |
advertiser_id | int Unique ID of the advertiser. |
browser | string Possible values are: "Chrome", "Cobalt", "Dalvik", "Edge", "Firefox", "IE", "Opera", "Other", "Safari", "Samsung Browser", "Roku", "Silk", "Unknown", "Yandex" |
campaign_id | int Unique ID of the campaign. |
content_url | string URL of the page on which ad appeared. Part of the url is removed for privacy. |
device_height | int Device height in px. |
device_width | int Device width in px. |
impression_id | string Unique identifier for impression. |
insertion_order_id | int Unique ID of the insertion order. |
inventory_type | enum The inventory type. Possible values: YOUTUBE, YOUTUBE TV, SEARCH, GMAIL, OTHER. Other refers to either the Google Display or Video network. |
is_app_traffic | boolean true if the event happened in a native app. |
is_in_rdid_project | boolean true if this event is also in the _rdid table. Used for deduplication of events. |
line_item_id | int Unique ID of the line item. |
location | struct Unique identifier for location has multiple parts |
location.country | string |
location.geo_city_id | int Code for city. Joins with city_id in adh.city table. |
location.geo_metro | int Code for metro region. Joins with metro_id in adh.metro table. |
location.geo_region | string Region as string e.g. US-CA. |
mobile_browser_class | int Type of browser. Possible values are: desktop, tablet, smart tv consoles, or mobile. Joins with mobile_browser_class_id in adh.mobile_browser_cltable. |
num_active_view_eligible_impression | int 1 when impression is active view eligible; 0 when impression is not active view eligible. |
num_active_view_measurable_impression | int 1 when impression is active view measurable; 0 when impression is not active view measurable. |
operating_system | string Possible values are: "Android", "AppleTV", "Chrome OS", "Fire OS", "Google TV", "iOS", "Linux", "Mac", "Unknown", "PlayStation", "Roku", "Tizen", "Xbox", "Windows", "Windows Phone" |
operating_system_version_ids | array (Deprecated) Use operating_system instead. ID of OS. Joins with operating_system_version_id in adh.os_version table. |
partner_id | int Unique ID of the partner. |
physical_screen_height | int Device screen height in mm. |
physical_screen_width | int Device screen width in mm. |
publisher_domain | string Domain of the page on which ad appeared. |
query_id | struct Unique identifier for query has multiple parts. Joins with query_id in any adh.dv360_youtube table. |
query_id.process_id | int The processing ID. |
query_id.server_ip | int The processing server. |
query_id.time_usec | int The query time in microseconds. |
query_language | string Language used by user. |
user_id | opaque User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes. |
DV360 YouTube insertion order
dv360_youtube_insertion_order | |
---|---|
advertiser_id | int Unique ID of the advertiser. |
campaign_id | int Unique ID of the campaign. |
insertion_order_id | int Unique ID of the insertion order. |
insertion_order_name | string Name of the insertion order. |
partner_id | int Unique ID of the partner. |
DV360 YouTube line item
dv360_youtube_lineitem | |
---|---|
advertiser_id | int Unique ID of the advertiser. |
campaign_id | int Unique ID of the campaign. |
insertion_order_id | int Unique ID of the insertion order. |
line_item_end_time | int Unix timestamp in microseconds (1/1,000,000 second) for when the line item ended, i.e. 1330403779608570 |
line_item_id | int Unique ID of the line item. |
line_item_name | string Name of the line item. |
line_item_reservation_type | enum The type of the reservation. Can be either "Programmatic", "InstantReserve" or "None" (meaning standard auction). |
line_item_start_time | int Unix timestamp in microseconds (1/1,000,000 second) for when the line item started, i.e. 1330403779608570 |
line_item_status | int Line item status. 3 = ACTIVE. 5 = PAUSED. 7 = DELETED. |
partner_id | int Unique ID of the partner. |
Freewheel Active Views
freewheel_active_views | |
---|---|
active_view | record Active view |
ad_current_time_ms | int The current time of the ad video playback in milliseconds |
ad_id | string VAST ad_id |
freewheel_event_id | record Unique identifier for query has multiple parts. Joins with event_id. |
freewheel_event_id.process_id | int The processing process. |
freewheel_event_id.server_ip | int The processing server. |
freewheel_event_id.time_usec | int Time in microseconds. |
label | string Name of conversion event. |
user_id | opaque User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.. |
user_language | string A three-letter ISO 639-2/bibliographic language code |
Freewheel clicks
freewheel_clicks | |
---|---|
ad_current_time_ms | int The current time of the ad video playback in milliseconds |
ad_id | string VAST ad_id |
freewheel_event_id | record Unique identifier for query has multiple parts. Joins with event_id. |
freewheel_event_id.process_id | int The processing process. |
freewheel_event_id.server_ip | int The processing server. |
freewheel_event_id.time_usec | int Time in microseconds. |
label | string Name of conversion event. |
user_id | opaque User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.. |
user_language | string A three-letter ISO 639-2/bibliographic language code |
Freewheel creative pixels
freewheel_creative_pixels | |
---|---|
ad_id | string Vast Ad ID. |
pixel_url | string pixel URL. |
Freewheel impressions
freewheel_impressions | |
---|---|
ad_current_time_ms | int The current time of the ad video playback in milliseconds |
ad_id | string VAST ad_id |
browser | string Possible values are: "Chrome", "Cobalt", "Dalvik", "Edge", "Firefox", "IE", "Opera", "Other", "Safari", "Samsung Browser", "Roku", "Silk", "Unknown", "Yandex" |
content_url | string URL of the page on which ad appeared. Part of the url is removed for privacy. |
freewheel_event_id | record Unique identifier for query has multiple parts. Joins with event_id. |
freewheel_event_id.process_id | int The processing process. |
freewheel_event_id.server_ip | int The processing server. |
freewheel_event_id.time_usec | int Time in microseconds. |
inventory_type | enum The inventory type. Possible values: YOUTUBE, YOUTUBE TV, SEARCH, GMAIL, OTHER. Other refers to either the Google Display or Video network. |
is_app_traffic | bool True if the event happened in a native app. FALSE if the event happened in HTML5 app or webview. |
label | string Name of conversion event. |
location | struct Unique identifier for location has multiple parts. |
location.country | string Two character country code. |
location.geo_city_id | int Code for city. Joins with city_id in adh.city table. |
location.geo_country_id | int |
location.geo_region_id | int Code for region. |
mobile_browser_class | int Type of device. Possible values are: desktop, tablet, smart tv consoles, or mobile. Joins with mobile_browser_class_id in adh.mobile_browser_cltable. |
operating_system | string Possible values are: "Android", "AppleTV", "Chrome OS", "Fire OS", "Google TV", "iOS", "Linux", "Mac", "Unknown", "PlayStation", "Roku", "Tizen", "Xbox", "Windows", "Windows Phone" |
publisher_domain | string Domain of the page on which ad appeared. |
user_id | opaque User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.. |
user_language | string A three-letter ISO 639-2/bibliographic language code |
Freewheel pixel
freewheel_pixel | |
---|---|
pixel_url | string The pixel URL. |
Google Ads Active Views
google_ads_active_views | |
---|---|
impression_data.ad_group_creative_id | int ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table. |
impression_data.adgroup_id | int ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table. |
impression_data.campaign_id | int Unique ID of the campaign. |
impression_data.customer_id | int ID of Google Ads customer. Joins with customer_id in any adh.google_ads table. |
impression_id | string Unique identifier for impression. |
num_active_view_viewable_impression | int 1 when impression is active view eligible; 0 when impression is not active view eligible. |
query_id | struct Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table. |
query_id.process_id | int The processing ID. |
query_id.server_ip | int The processing server. |
query_id.time_usec | int The query time in microseconds. |
view_id | struct Unique identifier for view_id has multiple parts. |
view_id.process_id | int Time in microseconds. |
view_id.server_ip | int The processing server. |
view_id.time_usec | int The processing process. |
Google Ads ad group
google_ads_adgroup | |
---|---|
adgroup_id | int ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table. |
adgroup_name | string Ad group name. |
adgroup_status | string The ad group. Possible values are: "status", "paused", or "enabled". |
adgroup_type | string The ad group type. Possible values are: VIDEO_TRUE_VIEW_IN_STREAM, VIDEO_OUTSTREAM, VIDEO_TRUE_VIEW_IN_DISPLAY, VIDEO_BUMPER_IN_STREAM, VIDEO_NON_SKIPPABLE_IN_STREAM, DISPLAY, SEARCH, or OTHER. |
campaign_id | int Unique ID of the campaign. |
customer_id | int Joins with customer_id in any adh.google_ads table. |
label_ids | array Joins with label_id in the adh.google_ads_label table. |
Google Ads ad group creative
google_ads_adgroupcreative | |
---|---|
ad_group_creative_id | INT64 ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table. |
adgroup_creative_status | STRING The status of the creative within the ad group. |
adgroup_id | INT64 ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table. |
creative_id | INT64 A unique identifier for the creative, specific to the ad group containing it. Joins with creative_id in any adh.google_ads table. |
customer_id | INT64 Joins with customer_id in any adh.google_ads table. |
label_ids | INT64 Joins with label_id in adh.google_ads tables that contain label_ids. |
Google Ads campaign
google_ads_campaign | |
---|---|
advertising_channel_type | string Advertising channel type. Possible values are: SEARCH, DISPLAY, VIDEO, or OTHER. |
campaign_id | int Unique ID of the campaign. |
campaign_name | string Campaign name. |
campaign_status | int Campaign status. 3 = ACTIVE. 5 = PAUSED. 7 = DELETED. |
customer_id | int Joins with customer_id in any adh.google_ads table. |
end_time | int Timestamp when the campaign ends in milliseconds. |
label_ids | array Joins with label_id in the adh.google_ads_label table. |
reservation_type | enum The type of the reservation. Can be either "InstantReserve" or "None" (meaning standard auction). |
start_time | int Timestamp when the campaign begins in milliseconds. |
Google Ads clicks
google_ads_clicks | |
---|---|
click_id | struct Unique identifier for click has multiple parts. Joins with click_id in any adh.google_ads table. |
click_id.process_id | int The processing process. |
click_id.server_ip | int The processing server. |
click_id.time_usec | int Time in microseconds. |
click_type | int The click type. |
impression_data.ad_group_creative_id | int ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table. |
impression_data.adgroup_id | int ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table. |
impression_data.campaign_id | int Unique ID of the campaign. |
impression_data.customer_id | int ID of Google Ads customer. Joins with customer_id in any adh.google_ads table. |
impression_id | string Unique identifier for impression. |
is_in_rdid_project | boolean true if this event is also in the _rdid table. Used for deduplication of events. |
query_id | struct Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table. |
query_id.process_id | int The processing process. |
query_id.server_ip | int The processing server. |
query_id.time_usec | int Time in microseconds. |
user_id | opaque User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes. |
Google Ads clicks audience
google_ads_clicks_audience | |
---|---|
click_id | struct Unique identifier for click has multiple parts. Joins with click_id in any adh.google_ads table. |
click_id.process_id | int The processing process. |
click_id.server_ip | int The processing server. |
click_id.time_usec | int Time in microseconds. |
click_type | int The click type. |
impression_id | string Unique identifier for impression. |
is_in_rdid_project | boolean true if this event is also in the _rdid table. Used for deduplication of events. |
query_id | struct Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table. |
query_id.process_id | int The processing process. |
query_id.server_ip | int The processing server. |
query_id.time_usec | int Time in microseconds. |
user_id | opaque User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes. |
Google Ads conversions
google_ads_conversions | |
---|---|
click_id | struct Unique identifier for click has multiple parts. Joins with click_id in any adh.google_ads table. |
click_id.process_id | int The processing process. |
click_id.server_ip | int The processing server. |
click_id.time_usec | int Time in microseconds. |
conversion_id | struct Unique identifier for conversion has multiple parts. |
conversion_id.process_id | int The processing process. |
conversion_id.server_ip | int The processing server. |
conversion_id.time_usec | int Time in microseconds. |
conversion_type | int The type of conversion. |
impression_data.ad_group_creative_id | int ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table. |
impression_data.adgroup_id | int ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table. |
impression_data.campaign_id | int Unique ID of the campaign. |
impression_data.customer_id | int ID of Google Ads customer. Joins with customer_id in any adh.google_ads table. |
impression_id | string Unique identifier for impression. |
is_in_rdid_project | boolean true if this event is also in the _rdid table. Used for deduplication of events. |
label | string Name of conversion event. |
query_id | struct Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table. |
query_id.process_id | int The processing process. |
query_id.server_ip | int The processing server. |
query_id.time_usec | int Time in microseconds. |
user_id | opaque User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes. |
Google Ads conversions audience
google_ads_conversions_audience | |
---|---|
click_id | struct Unique identifier for click has multiple parts. Joins with click_id in any adh.google_ads table. |
click_id.process_id | int The processing process. |
click_id.server_ip | int The processing server. |
click_id.time_usec | int Time in microseconds. |
conversion_id | struct Unique identifier for conversion has multiple parts. |
conversion_id.process_id | int The processing process. |
conversion_id.server_ip | int The processing server. |
conversion_id.time_usec | int Time in microseconds. |
conversion_type | int The type of conversion. |
impression_id | string Unique identifier for impression. |
is_in_rdid_project | boolean true if this event is also in the _rdid table. Used for deduplication of events. |
label | string Name of conversion event. |
query_id | struct Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table. |
query_id.process_id | int The processing process. |
query_id.server_ip | int The processing server. |
query_id.time_usec | int Time in microseconds. |
user_id | opaque User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes. |
Google Ads creative
google_ads_creative | |
---|---|
creative_id | int Joins with creative_id in any adh.google_ads table. |
creative_name | string Creative name. |
creative_type | int Creative type. |
customer_id | int Joins with customer_id in any adh.google_ads table. |
template_id | int Template ID of the creative. |
third_party_url | int The VAST tag URL string, as seen in Google products. |
video_message | struct Multipart identifier for video data. |
video_message.video_ad_duration | int Duration of the video in milliseconds. |
video_message.youtube_video_id | string Video id string representation as it appears on YouTube watch url. |
Google Ads creative conversions
google_ads_creative_conversions | |
---|---|
click_id | struct Unique identifier for click has multiple parts. Joins with click_id in any adh.google_ads table. |
click_id.process_id | int The processing process. |
click_id.server_ip | int The processing server. |
click_id.time_usec | int Time in microseconds. |
conversion_id | struct Unique identifier for conversion has multiple parts. |
conversion_id.process_id | int The processing process. |
conversion_id.server_ip | int The processing server. |
conversion_id.time_usec | int Time in microseconds. |
conversion_type | int The type of conversion. |
impression_data.ad_group_creative_id | int ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table. |
impression_data.adgroup_id | int ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table. |
impression_data.campaign_id | int Unique ID of the campaign. |
impression_data.customer_id | int ID of Google Ads customer. Joins with customer_id in any adh.google_ads table. |
impression_id | string Unique identifier for impression. |
is_in_rdid_project | boolean true if this event is also in the _rdid table. Used for deduplication of events. |
label | string Name of conversion event. |
query_id | struct Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table. |
query_id.process_id | int The processing process. |
query_id.server_ip | int The processing server. |
query_id.time_usec | int Time in microseconds. |
user_id | opaque User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes. |
Google Ads creative vendor metadata
google_ads_creative_vendor_metadata | |
---|---|
creative_id | int The Creative ID in Campaign Manager 360 UI. |
legacy_pixel | string |
vendor_string | string |
Google Ads customer
google_ads_customer | |
---|---|
customer_company_name | string Company name. |
customer_id | int Joins with customer_id in any adh.google_ads table. |
customer_name | string Customer name. |
external_customer_id | int Joins with customer_id in any adh.google_ads table. |
mcc_ids | array My Client Center Ids in Google Ads that this ADH customer is associated with. |
Google Ads impressions
google_ads_impressions | |
---|---|
ad_group_creative_id | int ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table. |
adgroup_id | int ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table. |
browser | string Possible values are: "Chrome", "Cobalt", "Dalvik", "Edge", "Firefox", "IE", "Opera", "Other", "Safari", "Samsung Browser", "Roku", "Silk", "Unknown", "Yandex" |
campaign_id | int Unique ID of the campaign. |
content_url | string URL of the page on which ad appeared. Part of the url is removed for privacy. |
customer_id | int ID of Google Ads customer.Joins with customer_id in any adh.google_ads table. |
device_height | int Device height in px. |
device_width | int Device width in px. |
impression_id | string Unique identifier for impression. |
inventory_type | enum The inventory type. Possible values: YOUTUBE, YOUTUBE TV, SEARCH, GMAIL, OTHER. Other refers to either the Google Display or Video network. |
is_app_traffic | boolean true if the event happened in a native app. FALSE if the event happened in HTML5 app or webview. |
is_in_rdid_project | boolean true if this event is also in the _rdid table. Used for deduplication of events. |
location | struct Unique identifier for location has multiple parts |
location.country | string |
location.geo_city_id | int Code for city. Joins with city_id in adh.city table. |
location.geo_metro | int Code for metro region. Joins with metro_id in adh.metro table. |
location.geo_region | string Region as string e.g. US-CA. |
mobile_browser_class | int Type of device. Possible values are: desktop, tablet, smart tv consoles, or mobile. Joins with mobile_browser_class_id in adh.mobile_browser_cltable. |
num_active_view_eligible_impression | int 1 when impression is active view eligible; 0 when impression is not active view eligible. |
num_active_view_measurable_impression | int 1 when impression is active view measurable; 0 when impression is not active view measurable. |
operating_system | string Possible values are: "Android", "AppleTV", "Chrome OS", "Fire OS", "Google TV", "iOS", "Linux", "Mac", "Unknown", "PlayStation", "Roku", "Tizen", "Xbox", "Windows", "Windows Phone" |
operating_system_version_ids | array (Deprecated) Use operating_system instead. ID of OS. Joins with operating_system_version_id in adh.os_version table. |
physical_screen_height | int Device screen height in mm. |
physical_screen_width | int Device screen width in mm. |
publisher_domain | string Domain of the page on which ad appeared. |
query_id | struct Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table. |
query_id.process_id | int The processing ID. |
query_id.server_ip | int The processing server. |
query_id.time_usec | int The query time in microseconds. |
query_language | string Language used by user. |
user_id | opaque User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes. |
Google Ads label
google_ads_label | |
---|---|
customer_id | int Joins with customer_id in any adh.google_ads table. |
description | string Label description. |
label_id | int Joins with label_id in adh.google_ads tables that contain label_ids. |
label_name | string Label name. |
status | int Label status. 1 = ENABLED. 2 = DELETED. |
Metro
metro | |
---|---|
country_code | string Two character country code. |
metro_abbrev | string (Deprecated) Use metro_name instead. Abbreviated version of metro name. |
metro_code | string (Deprecated) Use metro_name instead. The metropolitan area code. |
metro_id | int Metro identifier. |
metro_name | string Metro name. |
Mobile browser class
mobile_browser_class | |
---|---|
mobile_browser_class_id | int Mobile browser class identifier. |
mobile_browser_class_name | string Name of the mobile browser class. |
Operating system
operating_system | |
---|---|
mobile | boolean True if the operating system is mobile. |
operating_system_id | int Operating system identifier. |
operating_system_name | string Operating system name. |
Operating system version
os_version | |
---|---|
major_version | int The major version number of the operating system. |
minor_version | int The minor version of the operating system. |
operating_system_id | int Unique ID of OS just for Data Transfer. |
operating_system_version_id | int Operating system version identifier. |
operator_type | string Possible values are OPERATOR_TYPE_EQUAL_TO, or OPERATOR_TYPE_GREATER_THAN_EQUAL_TO. |
platform_name | string The platform name in English. |
Partner Sold - Cross Sell Active Views
partner_sold_cross_sell_active_views | |
---|---|
impression_id | string Unique identifier for impression. |
num_active_view_viewable_impression | int 1 when impression is active view eligible; 0 when impression is not active view eligible. |
query_id | struct Unique identifier for query has multiple parts. Joins with query_id. |
query_id.process_id | int The processing ID. |
query_id.server_ip | int The processing server. |
query_id.time_usec | int The query time in microseconds. |
view_id | struct Unique identifier for view has multiple parts. |
view_id.process_id | int The processing ID. |
view_id.server_ip | int The processing server. |
view_id.time_usec | int The query time in microseconds. |
Partner Sold - Cross Sell clicks
partner_sold_cross_sell_clicks | |
---|---|
click_id | struct Unique identifier for click has multiple parts. Joins with click_id. |
click_id.process_id | int The processing ID. |
click_id.server_ip | int The processing server. |
click_id.time_usec | int The query time in microseconds. |
click_type | int The click type. |
impression_id | string Unique identifier for impression. |
is_in_rdid_project | boolean true if this event is also in the _rdid table. Used for deduplication of events. |
query_id | struct Unique identifier for query has multiple parts. Joins with query_id. |
query_id.process_id | int The processing ID. |
query_id.server_ip | int The processing server. |
query_id.time_usec | int The query time in microseconds. |
user_id | opaque User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes. |
Partner Sold - Cross Sell conversions
partner_sold_cross_sell_conversions | |
---|---|
click_id | struct Unique identifier for click has multiple parts. Joins with click_id. |
click_id.process_id | int The processing ID. |
click_id.server_ip | int The processing server. |
click_id.time_usec | int The query time in microseconds. |
conversion_id | struct Unique identifier for conversion has multiple parts. |
conversion_id.process_id | int The processing ID. |
conversion_id.server_ip | int The processing server. |
conversion_id.time_usec | int The query time in microseconds. |
conversion_type | int The conversion type. |
impression_id | string Unique identifier for impression. |
is_in_rdid_project | boolean true if this event is also in the _rdid table. Used for deduplication of events. |
label | string Name of conversion event. |
query_id | struct Unique identifier for query has multiple parts. |
query_id.process_id | int The processing ID. |
query_id.server_ip | int The processing server. |
query_id.time_usec | int The query time in microseconds. |
user_id | opaque User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes. |
Partner Sold - Cross Sell creative
partner_sold_cross_sell_creative | |
---|---|
creative_format_type | string Some formats map directly to a type. Other types have multiple formats like: html, image, or video. |
creative_id | int The ID of the creative. |
creative_name | string Name of the creative. |
creative_type | string The type of creative. |
third_party_vast_url | string VAST url of the creative if the creative is a third party hosted video. Does not support creatives from programmatic items. |
video_message | struct Multipart identifier for video data. |
video_message.video_ad_duration | int Duration of the video in milliseconds. |
video_message.youtube_video_id | string Video id string representation as it appears on YouTube watch url. |
Partner Sold - Cross Sell creative pixels
partner_sold_cross_sell_creative_pixels | |
---|---|
ad_id | string Unique ID of the ad. |
pixel_url | string The pixel URL. |
Partner Sold - Cross Sell GAM pixels
partner_sold_cross_sell_gam_pixels | |
---|---|
ad_id | string Unique ID of the ad. |
pixel_url | string |
Partner Sold - Cross Sell impressions
partner_sold_cross_sell_impressions | |
---|---|
browser | string Possible values are: "Chrome", "Cobalt", "Dalvik", "Edge", "Firefox", "IE", "Opera", "Other", "Safari", "Samsung Browser", "Roku", "Silk", "Unknown", "Yandex" |
content_url | string URL of the page on which ad appeared. Part of the url is removed for privacy. |
creative_id | int Joins with creative_id in any adh.yt table. |
device_height | int Device height in pixels. |
device_width | int Device width in pixels. |
gfp_placements | array Ad Manager placement ID for this impression. Does not represent Campaign Manager 360 placement. |
impression_id | string Unique identifier for impression. |
inventory_type | enum The inventory type. Possible values: YOUTUBE, YOUTUBE TV, SEARCH, GMAIL, OTHER. Other refers to either the Google Display or Video network. |
is_in_rdid_project | boolean true if this event is also in the _rdid table. Used for deduplication of events. |
line_item_id | int Line item id for this impression. |
location | struct Unique identifier for location has multiple parts. |
location.country | string Code for country. |
location.geo_city_id | int Code for city. Joins with city_id in adh.city table. |
location.geo_metro | int Code for metrio region. Joins with metro_id in adh.metro table. |
location.geo_region | string Region as a string (e.g. US-CA) |
mobile_browser_class | int Type of device. Possible values are: desktop, tablet, smart tv consoles, or mobile. Joins with mobile_browser_class_id in adh.mobile_browser_cltable. |
num_active_view_eligible_impression | int 1 when impression is active view eligible; 0 when impression is not active view eligible. |
num_active_view_measurable_impression | int 1 when impression is active view measurable; 0 when impression is not active view measurable. |
operating_system | string Possible values are: "Android", "AppleTV", "Chrome OS", "Fire OS", "Google TV", "iOS", "Linux", "Mac", "Unknown", "PlayStation", "Roku", "Tizen", "Xbox", "Windows", "Windows Phone" |
operating_system_version_ids | array (Deprecated) Use operating_system instead. ID of operating system. Joins with operating_system_version_id in adh.os_version table. |
order_id | int Order ID for the impression. |
physical_screen_height | int Device height in mm. |
physical_screen_width | int Device screen width in mm. |
publisher_domain | string Domain of page on which ad appeared. |
query_id | struct Unique identifier for query has multiple parts. |
query_id.process_id | int The processing ID. |
query_id.server_ip | int The processing server. |
query_id.time_usec | int The query time in microseconds. |
query_language | string Language used by user. |
user_id | opaque User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes. |
Partner Sold - Cross Sell line item
partner_sold_cross_sell_lineitem | |
---|---|
end_time | timestamp Time the line item stopped being served. |
line_item_id | int Ad Manager line item serving. |
line_item_name | string Ad Manager line item name. |
order_id | int Ad Manager Order identifier used for serving. |
order_name | string Name of the insertion order. |
programmatic | boolean true if the line item was programmatic. |
skippable_ad_type | string Possible values are: "skippable", "not skippable", or "selectable". |
start_time | timestamp Time the line item started to be served. |
Partner Sold - Cross Sell order
partner_sold_cross_sell_order | |
---|---|
advertiser_id | int Unique ID of the advertiser. |
advertiser_name | string Publisher entered name. |
network_code | int Ad Manager Publisher network code. |
order_id | int Ad Manager Order identifier used for serving. |
order_name | string Name of Ad Manager order. |
Region
region | |
---|---|
country_code | string Two character country code. |
region_code | string Region code. |
region_id | int Region identifier. |
region_name | string Region name. |
YouTube Reserve Active Views
yt_reserve_active_views | |
---|---|
impression_data.creative_id | int The ID of the creative. |
impression_data.line_item_id | int Line item id for this impression. |
impression_data.media_plan_id | int ID of the YouTube Reserve media plan. |
impression_data.order_id | int |
impression_id | string Unique identifier for impression. |
num_active_view_viewable_impression | int 1 when impression is active view viewable; 0 when impression is not active view viewable. |
query_id | struct Unique identifier for query has multiple parts. |
query_id.process_id | int The processing process. |
query_id.server_ip | int The processing server. |
query_id.time_usec | int Time in microseconds. |
view_id | struct Unique identifier for view has multiple parts. |
view_id.process_id | int The processing process. |
view_id.server_ip | int The processing server. |
view_id.time_usec | int Time in microseconds. |
YouTube Reserve clicks
yt_reserve_clicks | |
---|---|
click_id | struct Unique identifier for click has multiple parts. |
click_id.process_id | int The processing process. |
click_id.server_ip | int The processing server. |
click_id.time_usec | int Time in microseconds. |
click_type | int The click type. |
impression_data.creative_id | int The ID of the creative. |
impression_data.line_item_id | int Line item id for this impression. |
impression_data.media_plan_id | int ID of the YouTube Reserve media plan. |
impression_data.order_id | int |
impression_id | string Unique identifier for impression. |
is_in_rdid_project | boolean true if this event is also in the _rdid table. Used for deduplication of events. |
query_id | struct Unique identifier for query has multiple parts. |
query_id.process_id | int The processing process. |
query_id.server_ip | int The processing server. |
query_id.time_usec | int Time in microseconds. |
user_id | opaque User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes. |
YouTube Reserve conversions
yt_reserve_conversions | |
---|---|
click_id | struct Unique identifier for click has multiple parts. |
click_id.process_id | int The processing process. |
click_id.server_ip | int The processing server. |
click_id.time_usec | int Time in microseconds. |
conversion_id | struct Unique identifier for conversion has multiple parts. |
conversion_id.process_id | int The processing process. |
conversion_id.server_ip | int The processing server. |
conversion_id.time_usec | int Time in microseconds. |
conversion_type | int The type of conversion. |
impression_data.creative_id | int The ID of the creative. |
impression_data.line_item_id | int Line item id for this impression. |
impression_data.media_plan_id | int ID of the YouTube Reserve media plan. |
impression_data.order_id | int |
impression_id | string Unique identifier for impression. |
is_in_rdid_project | boolean true if this event is also in the _rdid table. Used for deduplication of events.True if this event is also in the _rdid tabUsed for deduplication of events. |
label | string Name of conversion event. |
query_id | struct Unique identifier for query has multiple parts. |
query_id.process_id | int The processing process. |
query_id.server_ip | int The processing server. |
query_id.time_usec | int Time in microseconds. |
user_id | opaque User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes. |
YouTube Reserve creative
yt_reserve_creative | |
---|---|
creative_format_type | string Some formats map directly to a type. Other types have multiple formats like: html, image, or video. |
creative_id | int The ID of the creative. |
creative_name | string Name of the creative. |
creative_type | string The type of creative. |
dcm_beacons | array Multipart identifier for Campaign Manager 360 tracking pixel for ad. |
is_masthead | boolean True if this is a masthead creative. |
third_party_vast_url | string VAST url of the creative if the creative is a third party hosted video. Does not support creatives from programmatic items. |
video_message | struct Multipart identifier for video data. |
video_message.video_ad_duration | int Duration of the video in milliseconds. |
video_message.youtube_channel_id | string Id of the channel that provides this video. |
video_message.youtube_video_id | string Video id string representation as it appears on YouTube watch url. |
YouTube Reserve creative conversions
yt_reserve_creative_conversions | |
---|---|
click_id | struct Unique identifier for click has multiple parts. |
click_id.process_id | int The processing process. |
click_id.server_ip | int The processing server. |
click_id.time_usec | int Time in microseconds. |
conversion_id | struct Unique identifier for conversion has multiple parts. |
conversion_id.process_id | int The processing process. |
conversion_id.server_ip | int The processing server. |
conversion_id.time_usec | int Time in microseconds. |
conversion_type | int The type of conversion. |
impression_data.creative_id | int ID of the creative. |
impression_data.line_item_id | int Line item ID for this impression. |
impression_data.media_plan_id | int ID of the YouTube Reserve media plan. |
impression_data.order_id | int ID of Display and Video 360 customer. Joins with customer_id in any adh.dv360 table. |
is_in_rdid_project | boolean true if this event is also in the _rdid table. Used for deduplication of events.True if this event is also in the _rdid tabUsed for deduplication of events. |
label | string Name of conversion event. |
query_id | struct Unique identifier for query has multiple parts. |
query_id.process_id | int The processing process. |
query_id.server_ip | int The processing server. |
query_id.time_usec | int Time in microseconds. |
user_id | opaque User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes. |
YouTube Reserve impressions
yt_reserve_impressions | |
---|---|
browser | string Possible values are: "Chrome", "Cobalt", "Dalvik", "Edge", "Firefox", "IE", "Opera", "Other", "Safari", "Samsung Browser", "Roku", "Silk", "Unknown", "Yandex" |
content_url | string URL of the page on which ad appeared. Part of the url is removed for privacy. |
creative_id | int The ID of the creative. |
device_height | int Device height in px. |
device_width | int Device width in px. |
impression_id | string Unique identifier for impression. |
inventory_type | enum The inventory type. Possible values: YOUTUBE, YOUTUBE TV, SEARCH, GMAIL, OTHER. Other refers to either the Google Display or Video network. |
is_app_traffic | boolean true if the event happened in a native app. FALSE if the event happened in HTML5 app or webview. |
is_in_rdid_project | boolean true if this event is also in the _rdid table. Used for deduplication of events. |
line_item_id | int Line item id for this impression. |
location | struct Unique identifier for location has multiple parts. |
location.country | string |
location.geo_city_id | int Code for city. Joins with city_id in adh.city table. |
location.geo_metro | int Code for metro region. Joins with metro_id in adh.metro table. |
location.geo_region | string Region as string, e.g. US-CA. |
media_plan_id | int ID of the YouTube Reserve media plan. |
mobile_browser_class | int Type of device. Possible values are: desktop, tablet, smart tv consoles, or mobile. Joins with mobile_browser_class_id in adh.mobile_browser_class table. |
num_active_view_eligible_impression | int when impression is active view eligible; 0 when impression is not active view eligible. |
num_active_view_measurable_impression | int 1 when impression is active view measurable; 0 when impression is not active view measurable. |
operating_system | string Possible values are: "Android", "AppleTV", "Chrome OS", "Fire OS", "Google TV", "iOS", "Linux", "Mac", "Unknown", "PlayStation", "Roku", "Tizen", "Xbox", "Windows", "Windows Phone" |
operating_system_version_ids | array (Deprecated) Use operating_system instead. ID of OS. Joins with operating_system_version_id in adh.os_version table. |
order_id | int |
physical_screen_height | int Device screen height in mm. |
physical_screen_width | int Device screen width in mm. |
publisher_domain | string Domain of page on which ad appeared. |
query_id | struct Unique identifier for query has multiple parts. |
query_id.process_id | int The processing process. |
query_id.server_ip | int The processing server. |
query_id.time_usec | int Time in microseconds. |
query_language | string Language used by user. |
user_id | opaque User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes. |
YouTube Reserve line item
yt_reserve_lineitem | |
---|---|
creative_id | array Array of creative ids for this line item. Joins with creative_id in any adh.yt table. |
end_time | timestamp Time the line item stopped being served. |
line_item_id | int Ad Manager line item serving. |
line_item_name | string Ad Manager line item name. |
order_id | int Ad Manager Order identifier used for serving. |
order_name | string Name of the insertion order. |
programmatic | boolean true if the line item was programmatic. |
skippable_ad_type | string Possible values are: "skippable", "not skippable", or "selectable". |
start_time | timestamp Time the line item started to be served. |
YouTube Reserve order
yt_reserve_order | |
---|---|
advertiser_id | int Unique ID of the advertiser. |
advertiser_name | string User entered name of the advertiser. |
media_plan_id | int ID of the YouTube Reserve media plan. |
media_plan_name | string Name of the YouTube Reserve media plan. |
order_id | int Ad Manager Order identifier used for serving. |
order_name | string Name of Ad Manager order |