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. |
DV360 YouTube Active Views
dv360_youtube_active_views |
|
---|---|
Beginning in March 2024, use the Google service tables in place of dv360_youtube_active_views :
|
|
content_url |
string URL of the page on which the ad appeared. Part of the URL is removed for privacy. |
impression_data.adgroup_id |
int ID of the Display & Video 360 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 Unique ID of the creative. Joins with creative_id in any adh.dv360_youtube table. |
impression_data.insertion_order_id |
int The Display & Video 360 numerical ID for the insertion order related to the event, e.g. 1079941. |
impression_data.line_item_id |
int The Display & Video 360 numerical ID for the line item related to the event, e.g. 1155785. |
impression_data.partner_id |
int Unique ID of the partner. |
impression_id |
string Unique identifier for impression. |
num_active_view_viewable_impression |
int 1 = impression is active view eligible, 0 = impression isn't active view eligible. |
query_id |
struct Unique identifier for query has multiple parts. Joins with query_id in any adh.dv360_youtube table. |
query_id.process_id |
int Integer that identifies the process on the machine that generated the event. |
query_id.server_ip |
int The IPv4 address of the server that managed the ad request. Used to identify unique events for joins. |
query_id.time_usec |
int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds. |
view_id |
struct Unique ID for view has multiple parts. |
view_id.process_id |
int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds. |
view_id.server_ip |
int The IPv4 address of the server that generated this event. |
view_id.time_usec |
int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds. |
viewability_metrics |
struct Summable viewability metrics intended for Core and Advanced tiers of viewability. Metrics are organized by measurability pools. For each measurability pool, there is a sub-field containing the number of impressions that were measurable and the metrics that are available. |
viewability_metrics.active_view_plus_metrics |
struct Measures a variety of viewability metrics (including quartiles) that share a common measurability denominator. |
viewability_metrics.active_view_plus_metrics.ad_duration_msec |
int Total ad duration in milliseconds. |
viewability_metrics.active_view_plus_metrics.audible_and_fully_visible_watchtime_msec |
int Total audible (volume > 0%) and fully visible (100% on screen) watchtime in milliseconds. |
viewability_metrics.active_view_plus_metrics.audible_and_visible_watchtime_msec |
int Total audible (volume > 0%) and visible (at least 50% on screen) watchtime in milliseconds. |
viewability_metrics.active_view_plus_metrics.audible_count |
int Number of impressions that were audible (volume > 0%) at any point during playback. |
viewability_metrics.active_view_plus_metrics.audible_watchtime_msec |
int Total audible (volume > 0%) watchtime, in milliseconds. |
viewability_metrics.active_view_plus_metrics.background_count |
int Number of backgrounded impressions. |
viewability_metrics.active_view_plus_metrics.fullscreen_count |
int Number of fullscreened impressions. Note that this count only increments on YouTube platforms that have a toggle between normal/fullscreen state. YouTube Platforms that are always in fullscreen (like YouTube CTV Apps) will show up as 0. |
viewability_metrics.active_view_plus_metrics.fully_visible_watchtime_msec |
int Total fully visible (100% on screen) watchtime in milliseconds. |
viewability_metrics.active_view_plus_metrics.measurable_count |
int Number of impressions where Active View Plus metrics were able to be measured. |
viewability_metrics.active_view_plus_metrics.viewable_10_sec_count |
int Number of impressions that were at least 50% on screen for at least 10 seconds (cumulative). |
viewability_metrics.active_view_plus_metrics.visible_watchtime_msec |
int Total visible (at least 50% on screen) watchtime, in milliseconds. |
viewability_metrics.active_view_plus_metrics.watchtime_msec |
int Total watchtime in milliseconds. This may differ from the value reported in Google Ads, as it is only populated when Ads Data Hub is able to measure Active View metrics. |
viewability_metrics.active_view_plus_metrics.{start, q1, q2, q3, q4}.audible |
int Number of impressions that were audible (volume > 0%) at this point. |
viewability_metrics.active_view_plus_metrics.{start, q1, q2, q3, q4}.audible_and_visible |
int Number of impressions that were audible (volume > 0%) and 50% on screen at this point. |
viewability_metrics.active_view_plus_metrics.{start, q1, q2, q3, q4}.reached |
int Number of impressions that reached this point. |
viewability_metrics.active_view_plus_metrics.{start, q1, q2, q3, q4}.visible |
int Number of impressions that were at least 50% on screen at this point. |
viewability_metrics.enabled_count |
int 1 if Active View was enabled, else 0. To get the total number of impressions with Active View enabled, sum this field. |
viewability_metrics.groupm_trueview_viewable_impressions |
struct (Video only) Similar to groupm_viewable_impressions, but with an additional requirement on playback time for measurability. Impressions must reach the GroupM threshold of 15 seconds or 50% duration in addition to being GroupM measurable to be considered GroupM TrueView measurable. |
viewability_metrics.groupm_trueview_viewable_impressions.measureable_count |
int 1 if GroupM viewability was able to be measured and the impression reached the GroupM playback threshold, else 0. To get the total number of impressions where GroupM viewability was able to be measured and that reached the GroupM playback threshold, sum this field. |
viewability_metrics.groupm_trueview_viewable_impressions.viewable_count |
int 1 if the impression met the GroupM standard, else 0. To get the total number of impressions that met the GroupM standard, sum this field. |
viewability_metrics.groupm_viewable_impressions |
struct (Video only) Measures video ads playing 100% pixels on screen with audio volume > 0% for playback of at least 15 seconds or 50% of the ad duration, whichever is shorter. |
viewability_metrics.groupm_viewable_impressions.measureable_count |
int 1 if GroupM viewability was able to be measured, else 0. To get the total number of impressions where GroupM viewability was able to be measured, sum this field. |
viewability_metrics.groupm_viewable_impressions.viewable_count |
int 1 if the impression met the GroupM standard, else 0. To get the total number of impressions that met the GroupM standard, sum this field. |
viewability_metrics.mrc_cross_media_viewable_impressions |
struct (Video only) Measures video ads playing 100% on screen for 2 continuous seconds. |
viewability_metrics.mrc_cross_media_viewable_impressions.measureable_count |
int 1 if Cross-Media MRC viewability was able to be measured, else 0. To get the total number of impressions where Cross-Media MRC viewability was able to be measured, sum this field. |
viewability_metrics.mrc_cross_media_viewable_impressions.viewable_count |
int 1 if the impression met the Cross-Media MRC viewable standard, else 0. To get the total number of impressions that met the Cross-Media MRC viewable standard, sum this field. |
viewability_metrics.mrc_viewable_impressions |
struct Viewability metrics based on the MRC standard. That is, whether a video ad showed 50% pixels on screen for 2 continuous seconds of playback, or a display ad showed 50% pixels on screen for 1 continuous second. |
viewability_metrics.mrc_viewable_impressions.measureable_count |
int 1 if MRC viewability was able to be measured, else 0. To get the total number of impressions where MRC viewability was able to be measured, sum this field. |
viewability_metrics.mrc_viewable_impressions.viewable_count |
int 1 if the impression met the MRC standard, else 0. To get the total number of impressions that met the MRC viewable standard, sum this field. |
viewability_metrics.time_on_screen |
struct Measures the total time on screen for viewable impressions as determined by the MRC standard. The measurable count for impressions in this metric is zero for impressions that do not meet the MRC viewability threshold. |
viewability_metrics.time_on_screen.measureable_count |
int 1 if Time On Screen was able to be measured and met the MRC viewable standard, else 0. To get the total number of impressions where Time On Screen was able to be measured and met the MRC viewable standard, sum this field. |
viewability_metrics.time_on_screen.msec |
int Visible (at least 50% on screen) watchtime, in milliseconds, for impressions that met the MRC viewable standard. |
DV360 YouTube ad group
dv360_youtube_adgroup |
|
---|---|
adgroup_id |
int ID of DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table. |
adgroup_name |
string Ad group name. |
adgroup_status |
string The ad group. Possible values are: "status", "paused", or "enabled". |
adgroup_type |
string The ad group type. Possible values are: VIDEO_VIEW, VIDEO_REACH, VIDEO_ACTION, VIDEO_TRUE_VIEW_IN_STREAM, VIDEO_NON_SKIPPABLE_IN_STREAM,VIDEO_BUMPER, or VIDEO_TRUE_VIEW_IN_DISPLAY. |
advertiser_id |
int Unique ID of the advertiser. |
campaign_id |
int Unique ID of the campaign. |
insertion_order_id |
int The Display & Video 360 numerical ID for the insertion order related to the event, e.g. 1079941. |
line_item_id |
int The Display & Video 360 numerical ID for the line item related to the event, e.g. 1155785. |
partner_id |
int Unique ID of the partner. |
DV360 YouTube advertiser
dv360_youtube_advertiser |
|
---|---|
advertiser_id |
int Unique ID of the advertiser. |
advertiser_name |
string Name of the advertiser. |
advertiser_timezone |
string The DV360 advertiser time zone default set in account settings. |
partner_id |
int Unique ID of the partner. |
DV360 YouTube campaign
dv360_youtube_campaign |
|
---|---|
advertiser_id |
int Unique ID of the advertiser. |
campaign_id |
int Unique ID of the campaign. |
campaign_name |
string Name of the campaign |
partner_id |
int Unique ID of the partner. |
DV360 YouTube clicks (deprecated - use dv360_youtube_creative_conversions)
dv360_youtube_clicks |
|
---|---|
click_id |
struct Unique identifier for click has multiple parts. Joins with click_id in any adh.dv360_youtube table. |
click_id.process_id |
int Integer that identifies the process on the machine that generated the event. |
click_id.server_ip |
int The IPv4 address of the server that generated this event. |
click_id.time_usec |
int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds. |
click_type |
int The click type. |
impression_data.adgroup_id |
int ID of the Display & Video 360 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 Unique ID of the creative. Joins with creative_id in any adh.dv360_youtube table. |
impression_data.insertion_order_id |
int The Display & Video 360 numerical ID for the insertion order related to the event, e.g. 1079941. |
impression_data.line_item_id |
int The Display & Video 360 numerical ID for the line item related to the event, e.g. 1155785. |
impression_data.partner_id |
int Unique ID of the partner. |
impression_id |
string Unique identifier for impression. |
query_id |
struct Unique identifier for query has multiple parts. Joins with query_id in any adh.dv360_youtube table. |
query_id.process_id |
int Integer that identifies the process on the machine that generated the event. |
query_id.server_ip |
int The IPv4 address of the server that managed the ad request. Used to identify unique events for joins. |
query_id.time_usec |
int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds. |
user_id |
opaque User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes. |
DV360 YouTube conversions
dv360_youtube_conversions |
|
---|---|
click_id |
struct Unique identifier for click has multiple parts. Joins with click_id in any adh.dv360_youtube table. |
click_id.process_id |
int Integer that identifies the process on the machine that generated the event. |
click_id.server_ip |
int The IPv4 address of the server that generated this event. |
click_id.time_usec |
int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds. |
conversion_id |
struct Unique identifier for conversion has multiple parts. |
conversion_id.process_id |
int Integer that identifies the process on the machine that generated the event. |
conversion_id.server_ip |
int The IPv4 address of the server that generated this event. |
conversion_id.time_usec |
int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds. |
conversion_type |
int The type of conversion. |
impression_data.adgroup_id |
int ID of the Display & Video 360 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 Unique ID of the creative. 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 The Display & Video 360 numerical ID for the line item related to the event, e.g. 1155785. |
impression_data.partner_id |
int Unique ID of the partner. |
impression_id |
string Unique identifier for impression. |
label |
string Name of conversion event. |
query_id |
struct Unique identifier for query has multiple parts. Joins with query_id in any adh.dv360_youtube table. |
query_id.process_id |
int Integer that identifies the process on the machine that generated the event. |
query_id.server_ip |
int The IPv4 address of the server that managed the ad request. Used to identify unique events for joins. |
query_id.time_usec |
int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds. |
user_id |
opaque User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes. |
DV360 YouTube creative
dv360_youtube_creative |
|
---|---|
adgroup_id |
int ID of DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table. |
advertiser_id |
int Multiple Display & Video 360 "advertisers" generally exist underneath a single partner. Vendor client IDs are saved here. |
campaign_id |
int Unique ID of the campaign. |
creative_id |
int Vendor client IDs are saved here. |
creative_name |
string The name of the Display & Video 360 creative. |
creative_type |
int Enum corresponding to the creative type. |
insertion_order_id |
int Group of line item IDs. Frequency caps, pacing settings, partner costs, and default targeting criteria for line items. |
line_item_id |
int The Display & Video 360 numerical ID for the line item related to the event, e.g. 1155785. |
partner_id |
int Unique ID of the partner. |
third_party_vast_url |
string URL used for VAST (Video Ad Serving Template) redirect creatives. Formatting doesn't match yt_reserve_creative.third_party_vast_url. |
video_message |
struct Multipart identifier for video data. |
video_message.video_ad_duration |
int Duration of the video in milliseconds. |
video_message.youtube_video_id |
string Video ID string representation as it appears on YouTube watch url. |
DV360 YouTube creative conversions
dv360_youtube_creative_conversions |
|
---|---|
Beginning in March 2024, use the Google service tables in place of dv360_youtube_creative_conversions :
|
|
advertiser_cost_local_micros |
double The advertiser's cost in local currency micros. |
advertiser_cost_usd |
double The advertiser's click cost in dollars. |
click_id |
struct Unique identifier for click has multiple parts. Joins with click_id in any adh.dv360_youtube table. |
click_id.process_id |
int Integer that identifies the process on the machine that generated the event. |
click_id.server_ip |
int The IPv4 address of the server that generated this event. |
click_id.time_usec |
int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds. |
content_url |
string URL of the page on which the ad appeared. Part of the URL is removed for privacy. |
conversion_id |
struct Unique identifier for conversion has multiple parts. |
conversion_id.process_id |
int Integer that identifies the process on the machine that generated the event. |
conversion_id.server_ip |
int The IPv4 address of the server that generated this event. |
conversion_id.time_usec |
int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds. |
conversion_type |
int The type of conversion. |
impression_data.adgroup_id |
int ID of the Display & Video 360 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 Unique ID of the creative. Joins with creative_id in any adh.dv360_youtube table. |
impression_data.insertion_order_id |
int The Display & Video 360 numerical ID for the insertion order related to the event, e.g. 1079941. |
impression_data.line_item_id |
int The Display & Video 360 numerical ID for the line item related to the event, e.g. 1155785. |
impression_data.partner_id |
int Unique ID of the partner. |
impression_id |
string Unique identifier for impression. |
label |
string Name of conversion event. |
num_video_views |
int Number of video views. |
query_id |
struct Unique identifier for query has multiple parts. Joins with query_id in any adh.dv360_youtube table. |
query_id.process_id |
int Integer that identifies the process on the machine that generated the event. |
query_id.server_ip |
int The IPv4 address of the server that managed the ad request. Used to identify unique events for joins. |
query_id.time_usec |
int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds. |
user_id |
opaque User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes. |
viewability_metrics |
struct Summable viewability metrics intended for Core and Advanced tiers of viewability. Metrics are organized by measurability pools. For each measurability pool, there is a sub-field containing the number of impressions that were measurable and the metrics that are available. |
viewability_metrics.active_view_plus_metrics |
struct Measures a variety of viewability metrics (including quartiles) that share a common measurability denominator. |
viewability_metrics.active_view_plus_metrics.ad_duration_msec |
int Total ad duration in milliseconds. |
viewability_metrics.active_view_plus_metrics.audible_and_fully_visible_watchtime_msec |
int Total audible (volume > 0%) and fully visible (100% on screen) watchtime in milliseconds. |
viewability_metrics.active_view_plus_metrics.audible_and_visible_watchtime_msec |
int Total audible (volume > 0%) and visible (at least 50% on screen) watchtime in milliseconds. |
viewability_metrics.active_view_plus_metrics.audible_count |
int Number of impressions that were audible (volume > 0%) at any point during playback. |
viewability_metrics.active_view_plus_metrics.audible_watchtime_msec |
int Total audible (volume > 0%) watchtime, in milliseconds. |
viewability_metrics.active_view_plus_metrics.background_count |
int Number of backgrounded impressions. |
viewability_metrics.active_view_plus_metrics.fullscreen_count |
int Number of fullscreened impressions. Note that this count only increments on YouTube platforms that have a toggle between normal/fullscreen state. YouTube Platforms that are always in fullscreen (like YouTube CTV Apps) will show up as 0. |
viewability_metrics.active_view_plus_metrics.fully_visible_watchtime_msec |
int Total fully visible (100% on screen) watchtime in milliseconds. |
viewability_metrics.active_view_plus_metrics.measurable_count |
int Number of impressions where Active View Plus metrics were able to be measured. |
viewability_metrics.active_view_plus_metrics.viewable_10_sec_count |
int Number of impressions that were at least 50% on screen for at least 10 seconds (cumulative). |
viewability_metrics.active_view_plus_metrics.visible_watchtime_msec |
int Total visible (at least 50% on screen) watchtime, in milliseconds. |
viewability_metrics.active_view_plus_metrics.watchtime_msec |
int Total watchtime in milliseconds. This may differ from the value reported in Google Ads, as it is only populated when Ads Data Hub is able to measure Active View metrics. |
viewability_metrics.active_view_plus_metrics.{start, q1, q2, q3, q4}.audible |
int Number of impressions that were audible (volume > 0%) at this point. |
viewability_metrics.active_view_plus_metrics.{start, q1, q2, q3, q4}.audible_and_visible |
int Number of impressions that were audible (volume > 0%) and 50% on screen at this point. |
viewability_metrics.active_view_plus_metrics.{start, q1, q2, q3, q4}.reached |
int Number of impressions that reached this point. |
viewability_metrics.active_view_plus_metrics.{start, q1, q2, q3, q4}.visible |
int Number of impressions that were at least 50% on screen at this point. |
viewability_metrics.enabled_count |
int 1 if Active View was enabled, else 0. To get the total number of impressions with Active View enabled, sum this field. |
viewability_metrics.groupm_trueview_viewable_impressions |
struct (Video only) Similar to groupm_viewable_impressions, but with an additional requirement on playback time for measurability. Impressions must reach the GroupM threshold of 15 seconds or 50% duration in addition to being GroupM measurable to be considered GroupM TrueView measurable. |
viewability_metrics.groupm_trueview_viewable_impressions.measureable_count |
int 1 if GroupM viewability was able to be measured and the impression reached the GroupM playback threshold, else 0. To get the total number of impressions where GroupM viewability was able to be measured and that reached the GroupM playback threshold, sum this field. |
viewability_metrics.groupm_trueview_viewable_impressions.viewable_count |
int 1 if the impression met the GroupM standard, else 0. To get the total number of impressions that met the GroupM standard, sum this field. |
viewability_metrics.groupm_viewable_impressions |
struct (Video only) Measures video ads playing 100% pixels on screen with audio volume > 0% for playback of at least 15 seconds or 50% of the ad duration, whichever is shorter. |
viewability_metrics.groupm_viewable_impressions.measureable_count |
int 1 if GroupM viewability was able to be measured, else 0. To get the total number of impressions where GroupM viewability was able to be measured, sum this field. |
viewability_metrics.groupm_viewable_impressions.viewable_count |
int 1 if the impression met the GroupM standard, else 0. To get the total number of impressions that met the GroupM standard, sum this field. |
viewability_metrics.mrc_cross_media_viewable_impressions |
struct (Video only) Measures video ads playing 100% on screen for 2 continuous seconds. |
viewability_metrics.mrc_cross_media_viewable_impressions.measureable_count |
int 1 if Cross-Media MRC viewability was able to be measured, else 0. To get the total number of impressions where Cross-Media MRC viewability was able to be measured, sum this field. |
viewability_metrics.mrc_cross_media_viewable_impressions.viewable_count |
int 1 if the impression met the Cross-Media MRC viewable standard, else 0. To get the total number of impressions that met the Cross-Media MRC viewable standard, sum this field. |
viewability_metrics.mrc_viewable_impressions |
struct Viewability metrics based on the MRC standard. That is, whether a video ad showed 50% pixels on screen for 2 continuous seconds of playback, or a display ad showed 50% pixels on screen for 1 continuous second. |
viewability_metrics.mrc_viewable_impressions.measureable_count |
int 1 if MRC viewability was able to be measured, else 0. To get the total number of impressions where MRC viewability was able to be measured, sum this field. |
viewability_metrics.mrc_viewable_impressions.viewable_count |
int 1 if the impression met the MRC standard, else 0. To get the total number of impressions that met the MRC viewable standard, sum this field. |
viewability_metrics.time_on_screen |
struct Measures the total time on screen for viewable impressions as determined by the MRC standard. The measurable count for impressions in this metric is zero for impressions that do not meet the MRC viewability threshold. |
viewability_metrics.time_on_screen.measureable_count |
int 1 if Time On Screen was able to be measured and met the MRC viewable standard, else 0. To get the total number of impressions where Time On Screen was able to be measured and met the MRC viewable standard, sum this field. |
viewability_metrics.time_on_screen.msec |
int Visible (at least 50% on screen) watchtime, in milliseconds, for impressions that met the MRC viewable standard. |
DV360 YouTube impressions
dv360_youtube_impressions |
|
---|---|
Beginning in March 2024, use the Google service tables in place of 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. |
app_id |
string Numerical identifier for the app's ID. Combined with the app_store_id, users can look up more information about the app. For example, 284815942 is the ID of Google's search app on Apple's App store. It only populates for Google Display Network (GDN) and Google Video Partner (GVP), which can be identified as INVENTORY_TYPE = OTHER. You can look up the app name by joining with the mobile_app_info table. |
app_store_id |
int64 Numerical identifier corresponding to the app store which the app belongs to. e.g. 1 = "Apple App Store", 2 = "Google Play", or 8 = "PlayStation Store". It only populates for Google Display Network (GDN) and Google Video Partner (GVP), which can be identified as INVENTORY_TYPE = OTHER. You can look up the app store name by joining with the mobile_app_info table. |
browser |
string Possible values are: "Chrome", "Cobalt", "Dalvik", "Edge", "Firefox", "IE", "Opera", "Other", "Safari", "Samsung Browser", "Roku", "Silk", "Unknown", "Yandex" |
campaign_id |
int Unique ID of the campaign. |
content_url |
string URL of the page on which the ad appeared. Part of the URL is removed for privacy. |
device_height |
int Device height in px. |
device_width |
int Device width in px. |
format_category |
string YouTube ad format. Possible values are AUDIO, DISPLAY, VIDEO, UNSPECIFIED. |
impression_id |
string Unique identifier for impression. |
insertion_order_id |
int The Display & Video 360 numerical ID for the insertion order related to the event, e.g. 1079941. |
inventory_type |
string The inventory type. Possible values: YOUTUBE, YOUTUBE_TV, YOUTUBE_MUSIC, SEARCH, GMAIL, OTHER. Other refers to either the Google Display or Video network. |
is_app_traffic |
boolean true if the event happened in a native app. |
line_item_id |
int The Display & Video 360 numerical ID for the line item related to the event, e.g. 1155785. |
location |
struct Unique identifier for location has multiple parts |
location.country |
string |
location.geo_city_id |
int Code for city. Joins with city_id in adh.city table. |
location.geo_metro |
int Code for metro region. Joins with metro_id in adh.metro table. |
location.geo_region |
string Region as string e.g. US-CA. |
mobile_browser_class |
int Type of browser. Possible values are: desktop, tablet, smart tv consoles, or mobile. Joins with mobile_browser_class_id in adh.mobile_browser table. |
num_active_view_eligible_impression |
int 1 when impression is active view eligible; 0 when impression is not active view eligible. |
operating_system |
string Possible values are: "Android", "AppleTV", "Chrome OS", "Fire OS", "Google TV", "iOS", "Linux", "Mac", "Unknown", "PlayStation", "Roku", "Tizen", "Xbox", "Windows", "Windows Phone" |
partner_id |
int Unique ID of the partner. |
physical_screen_height |
int Device screen height in mm. |
physical_screen_width |
int Device screen width in mm. |
publisher_domain |
string Domain of the page on which ad appeared. |
query_id |
struct Unique identifier for query has multiple parts. Joins with query_id in any adh.dv360_youtube table. |
query_id.process_id |
int Integer that identifies the process on the machine that generated the event. |
query_id.server_ip |
int The IPv4 address of the server that managed the ad request. Used to identify unique events for joins. |
query_id.time_usec |
int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds. |
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. |
viewability_metrics |
struct Summable viewability metrics intended for Core and Advanced tiers of viewability. Metrics are organized by measurability pools. For each measurability pool, there is a sub-field containing the number of impressions that were measurable and the metrics that are available. |
viewability_metrics.active_view_plus_metrics |
struct Measures a variety of viewability metrics (including quartiles) that share a common measurability denominator. |
viewability_metrics.active_view_plus_metrics.ad_duration_msec |
int Total ad duration in milliseconds. |
viewability_metrics.active_view_plus_metrics.audible_and_fully_visible_watchtime_msec |
int Total audible (volume > 0%) and fully visible (100% on screen) watchtime in milliseconds. |
viewability_metrics.active_view_plus_metrics.audible_and_visible_watchtime_msec |
int Total audible (volume > 0%) and visible (at least 50% on screen) watchtime in milliseconds. |
viewability_metrics.active_view_plus_metrics.audible_count |
int Number of impressions that were audible (volume > 0%) at any point during playback. |
viewability_metrics.active_view_plus_metrics.audible_watchtime_msec |
int Total audible (volume > 0%) watchtime, in milliseconds. |
viewability_metrics.active_view_plus_metrics.background_count |
int Number of backgrounded impressions. |
viewability_metrics.active_view_plus_metrics.fullscreen_count |
int Number of fullscreened impressions. Note that this count only increments on YouTube platforms that have a toggle between normal/fullscreen state. YouTube Platforms that are always in fullscreen (like YouTube CTV Apps) will show up as 0. |
viewability_metrics.active_view_plus_metrics.fully_visible_watchtime_msec |
int Total fully visible (100% on screen) watchtime in milliseconds. |
viewability_metrics.active_view_plus_metrics.measurable_count |
int Number of impressions where Active View Plus metrics were able to be measured. |
viewability_metrics.active_view_plus_metrics.viewable_10_sec_count |
int Number of impressions that were at least 50% on screen for at least 10 seconds (cumulative). |
viewability_metrics.active_view_plus_metrics.visible_watchtime_msec |
int Total visible (at least 50% on screen) watchtime, in milliseconds. |
viewability_metrics.active_view_plus_metrics.watchtime_msec |
int Total watchtime in milliseconds. This may differ from the value reported in Google Ads, as it is only populated when Ads Data Hub is able to measure Active View metrics. |
viewability_metrics.active_view_plus_metrics.{start, q1, q2, q3, q4}.audible |
int Number of impressions that were audible (volume > 0%) at this point. |
viewability_metrics.active_view_plus_metrics.{start, q1, q2, q3, q4}.audible_and_visible |
int Number of impressions that were audible (volume > 0%) and 50% on screen at this point. |
viewability_metrics.active_view_plus_metrics.{start, q1, q2, q3, q4}.reached |
int Number of impressions that reached this point. |
viewability_metrics.active_view_plus_metrics.{start, q1, q2, q3, q4}.visible |
int Number of impressions that were at least 50% on screen at this point. |
viewability_metrics.enabled_count |
int 1 if Active View was enabled, else 0. To get the total number of impressions with Active View enabled, sum this field. |
viewability_metrics.groupm_trueview_viewable_impressions |
struct (Video only) Similar to groupm_viewable_impressions, but with an additional requirement on playback time for measurability. Impressions must reach the GroupM threshold of 15 seconds or 50% duration in addition to being GroupM measurable to be considered GroupM TrueView measurable. |
viewability_metrics.groupm_trueview_viewable_impressions.measureable_count |
int 1 if GroupM viewability was able to be measured and the impression reached the GroupM playback threshold, else 0. To get the total number of impressions where GroupM viewability was able to be measured and that reached the GroupM playback threshold, sum this field. |
viewability_metrics.groupm_trueview_viewable_impressions.viewable_count |
int 1 if the impression met the GroupM standard, else 0. To get the total number of impressions that met the GroupM standard, sum this field. |
viewability_metrics.groupm_viewable_impressions |
struct (Video only) Measures video ads playing 100% pixels on screen with audio volume > 0% for playback of at least 15 seconds or 50% of the ad duration, whichever is shorter. |
viewability_metrics.groupm_viewable_impressions.measureable_count |
int 1 if GroupM viewability was able to be measured, else 0. To get the total number of impressions where GroupM viewability was able to be measured, sum this field. |
viewability_metrics.groupm_viewable_impressions.viewable_count |
int 1 if the impression met the GroupM standard, else 0. To get the total number of impressions that met the GroupM standard, sum this field. |
viewability_metrics.mrc_cross_media_viewable_impressions |
struct (Video only) Measures video ads playing 100% on screen for 2 continuous seconds. |
viewability_metrics.mrc_cross_media_viewable_impressions.measureable_count |
int 1 if Cross-Media MRC viewability was able to be measured, else 0. To get the total number of impressions where Cross-Media MRC viewability was able to be measured, sum this field. |
viewability_metrics.mrc_cross_media_viewable_impressions.viewable_count |
int 1 if the impression met the Cross-Media MRC viewable standard, else 0. To get the total number of impressions that met the Cross-Media MRC viewable standard, sum this field. |
viewability_metrics.mrc_viewable_impressions |
struct Viewability metrics based on the MRC standard. That is, whether a video ad showed 50% pixels on screen for 2 continuous seconds of playback, or a display ad showed 50% pixels on screen for 1 continuous second. |
viewability_metrics.mrc_viewable_impressions.measureable_count |
int 1 if MRC viewability was able to be measured, else 0. To get the total number of impressions where MRC viewability was able to be measured, sum this field. |
viewability_metrics.mrc_viewable_impressions.viewable_count |
int 1 if the impression met the MRC standard, else 0. To get the total number of impressions that met the MRC viewable standard, sum this field. |
viewability_metrics.time_on_screen |
struct Measures the total time on screen for viewable impressions as determined by the MRC standard. The measurable count for impressions in this metric is zero for impressions that do not meet the MRC viewability threshold. |
viewability_metrics.time_on_screen.measureable_count |
int 1 if Time On Screen was able to be measured and met the MRC viewable standard, else 0. To get the total number of impressions where Time On Screen was able to be measured and met the MRC viewable standard, sum this field. |
viewability_metrics.time_on_screen.msec |
int Visible (at least 50% on screen) watchtime, in milliseconds, for impressions that met the MRC viewable standard. |
youtube_page_type |
string Page type. Possible values are YOUTUBE_WATCH, YOUTUBE_HOME, YOUTUBE_SEARCH, or YOUTUBE_SHORTS. |
DV360 YouTube insertion order
dv360_youtube_insertion_order |
|
---|---|
advertiser_id |
int Unique ID of the advertiser. |
campaign_id |
int Unique ID of the campaign. |
insertion_order_id |
int The Display & Video 360 numerical ID for the insertion order related to the event, e.g. 1079941. |
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. |
advertising_channel_type |
string The primary serving target for ads within the line item. Possible values are: "VIDEO" or "DEMAND_GEN". |
campaign_id |
int Unique ID of the campaign. |
insertion_order_id |
int The Display & Video 360 numerical ID for the insertion order related to the event, e.g. 1079941. |
line_item_end_time |
int Unix timestamp in microseconds (1/1,000,000 second) for when the line item ended, e.g. 1330403779608570 |
line_item_id |
int The Display & Video 360 numerical ID for the line item related to the event, e.g. 1155785. |
line_item_name |
string The Display & Video 360 name for the line item related to the event, e.g. 164332. |
line_item_reservation_type |
enum Reservation type for a Display & Video 360 line item. Can be one of "Programmatic", "InstantReserve", or "None" (meaning standard auction). |
line_item_start_time |
int Unix timestamp in microseconds (1/1,000,000 second) for when the line item started, e.g. 1330403779608570 |
line_item_status |
int Integer indicating the status of the line item. 3 = ACTIVE. 5 = PAUSED. 7 = DELETED. |
partner_id |
int Unique ID of the partner. |
DV360 YouTube vendor reporting metadata
dv360_youtube_vendor_reporting_data |
|
---|---|
line_item_id |
int Unique ID of the line item. |
vendor_client_id |
string All lower-case formatted vendor client id (VCID). |
vendor_metric |
string Measurement type. |
vendor_reporting_id |
string Customer-provided identifier to slice their data by. |
Freewheel Active Views
freewheel_active_views |
|
---|---|
Beginning in March 2024, use the Google service tables in place of freewheel_active_views :
|
|
active_view |
record Active view |
ad_current_time_ms |
int The current time of the ad video playback in milliseconds |
ad_id |
string VAST ad_id |
freewheel_event_id |
record Unique identifier for query has multiple parts. Joins with event_id. |
freewheel_event_id.process_id |
int Integer that identifies the process on the machine that generated the event. |
freewheel_event_id.server_ip |
int The IPv4 address of the server that generated this event. |
freewheel_event_id.time_usec |
int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds. |
impression_id |
string Unique identifier for an impression. |
label |
string Name of conversion event. |
query_language |
string Language used by user. |
user_id |
opaque User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.. |
Freewheel clicks
freewheel_clicks |
|
---|---|
Beginning in March 2024, use the Google service tables in place of freewheel_clicks :
|
|
ad_current_time_ms |
int The current time of the ad video playback in milliseconds |
ad_id |
string VAST ad_id |
freewheel_event_id |
record Unique identifier for query has multiple parts. Joins with event_id. |
freewheel_event_id.process_id |
int Integer that identifies the process on the machine that generated the event. |
freewheel_event_id.server_ip |
int The IPv4 address of the server that generated this event. |
freewheel_event_id.time_usec |
int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds. |
impression_id |
string Unique identifier for an impression. |
label |
string Name of conversion event. |
query_language |
string Language used by user. |
user_id |
opaque User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.. |
Freewheel creative pixels
freewheel_creative_pixels |
|
---|---|
ad_id |
string Vast Ad ID. |
pixel_url |
string pixel URL. |
Freewheel impressions
freewheel_impressions |
|
---|---|
Beginning in March 2024, use the Google service tables in place of freewheel_impressions :
|
|
ad_current_time_ms |
int The current time of the ad video playback in milliseconds |
ad_id |
string VAST ad_id |
browser |
string Possible values are: "Chrome", "Cobalt", "Dalvik", "Edge", "Firefox", "IE", "Opera", "Other", "Safari", "Samsung Browser", "Roku", "Silk", "Unknown", "Yandex" |
content_url |
string URL of the page on which ad appeared. Part of the url is removed for privacy. |
format_category |
string YouTube ad format. Possible values are AUDIO, DISPLAY, VIDEO, UNSPECIFIED. |
freewheel_event_id |
record Unique identifier for query has multiple parts. Joins with event_id. |
freewheel_event_id.process_id |
int Integer that identifies the process on the machine that generated the event. |
freewheel_event_id.server_ip |
int The IPv4 address of the server that generated this event. |
freewheel_event_id.time_usec |
int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds. |
impression_id |
string Unique identifier for an impression. |
inventory_type |
enum The inventory type. Possible values: YOUTUBE, YOUTUBE TV, SEARCH, GMAIL, OTHER. Other refers to either the Google Display or Video network. |
is_app_traffic |
bool True if the event happened in a native app. FALSE if the event happened in HTML5 app or webview. |
label |
string Name of conversion event. |
location |
struct Unique identifier for location has multiple parts. |
location.country |
string Two character country code. |
location.geo_city_id |
int Code for city. Joins with city_id in adh.city table. |
location.geo_country_id |
int |
location.geo_region_id |
int Code for region. |
mobile_browser_class |
int Type of device. Possible values are: desktop, tablet, smart tv consoles, or mobile. Joins with mobile_browser_class_id in adh.mobile_browser_class table. |
operating_system |
string Possible values are: "Android", "AppleTV", "Chrome OS", "Fire OS", "Google TV", "iOS", "Linux", "Mac", "Unknown", "PlayStation", "Roku", "Tizen", "Xbox", "Windows", "Windows Phone" |
publisher_domain |
string Domain of the page on which ad appeared. |
query_language |
string Language used by user. |
user_id |
opaque User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.. |
youtube_page_type |
enum Page type. Possible values are YOUTUBE_WATCH, YOUTUBE_HOME, YOUTUBE_SEARCH, or YOUTUBE_SHORTS. |
Freewheel pixel
freewheel_pixel |
|
---|---|
pixel_url |
string The pixel URL. |
Google Ads Active Views
google_ads_active_views |
|
---|---|
Beginning in March 2024, use the Google service tables in place of google_ads_active_views :
|
|
content_url |
string URL of the page on which the ad appeared. Part of the URL is removed for privacy. |
impression_data |
struct |
impression_data.ad_group_creative_id |
int ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table. |
impression_data.adgroup_id |
int ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table. |
impression_data.campaign_id |
int Unique ID of the campaign. |
impression_data.customer_id |
int Google Ads account ID. Joins with customer_id in any adh.google_ads table. |
impression_id |
bytes Unique identifier for impression. |
num_active_view_viewable_impression |
int 1 when impression is active view eligible; 0 when impression is not active view eligible. |
query_id |
struct Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table. |
query_id.process_id |
int Integer that identifies the process on the machine that generated the event. |
query_id.server_ip |
int The IPv4 address of the server that managed the ad request. Used to identify unique events for joins. |
query_id.time_usec |
int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds. |
view_id |
struct Unique identifier for view_id has multiple parts. |
view_id.process_id |
int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds. |
view_id.server_ip |
int The IPv4 address of the server that generated this event. |
view_id.time_usec |
int Integer that identifies the process on the machine that generated the event. |
viewability_metrics |
struct Summable viewability metrics intended for Core and Advanced tiers of viewability. Metrics are organized by measurability pools. For each measurability pool, there is a sub-field containing the number of impressions that were measurable and the metrics that are available. |
viewability_metrics.active_view_plus_metrics |
struct Measures a variety of viewability metrics (including quartiles) that share a common measurability denominator. |
viewability_metrics.active_view_plus_metrics.ad_duration_msec |
int Total ad duration in milliseconds. |
viewability_metrics.active_view_plus_metrics.audible_and_fully_visible_watchtime_msec |
int Total audible (volume > 0%) and fully visible (100% on screen) watchtime in milliseconds. |
viewability_metrics.active_view_plus_metrics.audible_and_visible_watchtime_msec |
int Total audible (volume > 0%) and visible (at least 50% on screen) watchtime in milliseconds. |
viewability_metrics.active_view_plus_metrics.audible_count |
int Number of impressions that were audible (volume > 0%) at any point during playback. |
viewability_metrics.active_view_plus_metrics.audible_watchtime_msec |
int Total audible (volume > 0%) watchtime, in milliseconds. |
viewability_metrics.active_view_plus_metrics.background_count |
int Number of backgrounded impressions. |
viewability_metrics.active_view_plus_metrics.fullscreen_count |
int Number of fullscreened impressions. Note that this count only increments on YouTube platforms that have a toggle between normal/fullscreen state. YouTube Platforms that are always in fullscreen (like YouTube CTV Apps) will show up as 0. |
viewability_metrics.active_view_plus_metrics.fully_visible_watchtime_msec |
int Total fully visible (100% on screen) watchtime in milliseconds. |
viewability_metrics.active_view_plus_metrics.measurable_count |
int Number of impressions where Active View Plus metrics were able to be measured. |
viewability_metrics.active_view_plus_metrics.viewable_10_sec_count |
int Number of impressions that were at least 50% on screen for at least 10 seconds (cumulative). |
viewability_metrics.active_view_plus_metrics.visible_watchtime_msec |
int Total visible (at least 50% on screen) watchtime, in milliseconds. |
viewability_metrics.active_view_plus_metrics.watchtime_msec |
int Total watchtime in milliseconds. This may differ from the value reported in Google Ads, as it is only populated when Ads Data Hub is able to measure Active View metrics. |
viewability_metrics.active_view_plus_metrics.{start, q1, q2, q3, q4}.audible |
int Number of impressions that were audible (volume > 0%) at this point. |
viewability_metrics.active_view_plus_metrics.{start, q1, q2, q3, q4}.audible_and_visible |
int Number of impressions that were audible (volume > 0%) and 50% on screen at this point. |
viewability_metrics.active_view_plus_metrics.{start, q1, q2, q3, q4}.reached |
int Number of impressions that reached this point. |
viewability_metrics.active_view_plus_metrics.{start, q1, q2, q3, q4}.visible |
int Number of impressions that were at least 50% on screen at this point. |
viewability_metrics.enabled_count |
int 1 if Active View was enabled, else 0. To get the total number of impressions with Active View enabled, sum this field. |
viewability_metrics.groupm_trueview_viewable_impressions |
struct (Video only) Similar to groupm_viewable_impressions, but with an additional requirement on playback time for measurability. Impressions must reach the GroupM threshold of 15 seconds or 50% duration in addition to being GroupM measurable to be considered GroupM TrueView measurable. |
viewability_metrics.groupm_trueview_viewable_impressions.measureable_count |
int 1 if GroupM viewability was able to be measured and the impression reached the GroupM playback threshold, else 0. To get the total number of impressions where GroupM viewability was able to be measured and that reached the GroupM playback threshold, sum this field. |
viewability_metrics.groupm_trueview_viewable_impressions.viewable_count |
int 1 if the impression met the GroupM standard, else 0. To get the total number of impressions that met the GroupM standard, sum this field. |
viewability_metrics.groupm_viewable_impressions |
struct (Video only) Measures video ads playing 100% pixels on screen with audio volume > 0% for playback of at least 15 seconds or 50% of the ad duration, whichever is shorter. |
viewability_metrics.groupm_viewable_impressions.measureable_count |
int 1 if GroupM viewability was able to be measured, else 0. To get the total number of impressions where GroupM viewability was able to be measured, sum this field. |
viewability_metrics.groupm_viewable_impressions.viewable_count |
int 1 if the impression met the GroupM standard, else 0. To get the total number of impressions that met the GroupM standard, sum this field. |
viewability_metrics.mrc_cross_media_viewable_impressions |
struct (Video only) Measures video ads playing 100% on screen for 2 continuous seconds. |
viewability_metrics.mrc_cross_media_viewable_impressions.measureable_count |
int 1 if Cross-Media MRC viewability was able to be measured, else 0. To get the total number of impressions where Cross-Media MRC viewability was able to be measured, sum this field. |
viewability_metrics.mrc_cross_media_viewable_impressions.viewable_count |
int 1 if the impression met the Cross-Media MRC viewable standard, else 0. To get the total number of impressions that met the Cross-Media MRC viewable standard, sum this field. |
viewability_metrics.mrc_viewable_impressions |
struct Viewability metrics based on the MRC standard. That is, whether a video ad showed 50% pixels on screen for 2 continuous seconds of playback, or a display ad showed 50% pixels on screen for 1 continuous second. |
viewability_metrics.mrc_viewable_impressions.measureable_count |
int 1 if MRC viewability was able to be measured, else 0. To get the total number of impressions where MRC viewability was able to be measured, sum this field. |
viewability_metrics.mrc_viewable_impressions.viewable_count |
int 1 if the impression met the MRC standard, else 0. To get the total number of impressions that met the MRC viewable standard, sum this field. |
viewability_metrics.time_on_screen |
struct Measures the total time on screen for viewable impressions as determined by the MRC standard. The measurable count for impressions in this metric is zero for impressions that do not meet the MRC viewability threshold. |
viewability_metrics.time_on_screen.measureable_count |
int 1 if Time On Screen was able to be measured and met the MRC viewable standard, else 0. To get the total number of impressions where Time On Screen was able to be measured and met the MRC viewable standard, sum this field. |
viewability_metrics.time_on_screen.msec |
int Visible (at least 50% on screen) watchtime, in milliseconds, for impressions that met the MRC viewable standard. |
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 Name of the ad group in Google Ads. |
adgroup_status |
string The ad group. Possible values are: "status", "paused", or "enabled". |
adgroup_type |
string The ad group type. Possible values are: VIDEO_VIEW, VIDEO_REACH, VIDEO_ACTION, VIDEO_TRUE_VIEW_IN_STREAM, VIDEO_OUTSTREAM, VIDEO_TRUE_VIEW_IN_DISPLAY, VIDEO_BUMPER_IN_STREAM, VIDEO_NON_SKIPPABLE_IN_STREAM, DISPLAY, SEARCH, YOUTUBE_AUDIO, or OTHER. |
campaign_id |
int Unique ID of the campaign. |
customer_id |
int Google Ads account ID. Joins with customer_id in any adh.google_ads table. |
label_ids |
array Label IDs. Joins with label_id in the adh.google_ads_label table. |
Google Ads ad group creative
google_ads_adgroupcreative |
|
---|---|
ad_group_creative_id |
int ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table. |
adgroup_creative_status |
STRING The status of the creative within the ad group. |
adgroup_id |
int ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table. |
creative_id |
int A unique identifier for the creative, specific to the ad group containing it. Joins with creative_id in any adh.google_ads table. |
customer_id |
int Google Ads account ID. Joins with customer_id in any adh.google_ads table. |
label_ids |
array Label IDs. Joins with label_id in the adh.google_ads_label table. |
Google Ads campaign
google_ads_campaign |
|
---|---|
advertising_channel_type |
string The primary serving target for ads within the campaign. It can be set only when a campaign is newly created in Google Ads. Possible values are: "SEARCH", "DISPLAY", "VIDEO", "DEMAND_GEN" or "OTHER". |
campaign_id |
int Unique ID of the campaign. |
campaign_name |
string Campaign name. |
campaign_status |
int Campaign status. 3 = ACTIVE. 5 = PAUSED. 7 = DELETED. |
customer_id |
int Google Ads account ID. Joins with customer_id in any adh.google_ads table. |
end_time |
int Timestamp when the campaign ends in milliseconds. |
label_ids |
array Label IDs. Joins with label_id in the adh.google_ads_label table. |
reservation_type |
string The type of the reservation. Can be either "InstantReserve" or "None" (meaning standard auction). |
start_time |
int Timestamp when the campaign begins in milliseconds. |
Google Ads clicks (deprecated - use google_ads_creative_conversions)
google_ads_clicks |
|
---|---|
Beginning in March 2024, use the Google service tables in place of google_ads_clicks :
|
|
click_id |
struct Unique identifier for click has multiple parts. Joins with click_id in any adh.google_ads table. |
click_id.process_id |
int Integer that identifies the process on the machine that generated the event. |
click_id.server_ip |
int The IPv4 address of the server that generated this event. |
click_id.time_usec |
int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds. |
click_type |
int The click type. |
impression_data |
struct |
impression_data.ad_group_creative_id |
int ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table. |
impression_data.adgroup_id |
int ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table. |
impression_data.campaign_id |
int Unique ID of the campaign. |
impression_data.customer_id |
int Google Ads account ID. Joins with customer_id in any adh.google_ads table. |
impression_id |
bytes Unique identifier for impression. |
query_id |
struct Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table. |
query_id.process_id |
int Integer that identifies the process on the machine that generated the event. |
query_id.server_ip |
int The IPv4 address of the server that managed the ad request. Used to identify unique events for joins. |
query_id.time_usec |
int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds. |
user_id |
opaque The tracking ID (it is based on, but does not expose the user's browser cookie or mobile device ID). This field may be zeroed out for privacy reasons. User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes. |
Google Ads conversions
google_ads_conversions |
|
---|---|
click_id |
struct Unique identifier for click has multiple parts. Joins with click_id in any adh.google_ads table. |
click_id.process_id |
int Integer that identifies the process on the machine that generated the event. |
click_id.server_ip |
int The IPv4 address of the server that generated this event. |
click_id.time_usec |
int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds. |
conversion_id |
struct Unique identifier for conversion has multiple parts. |
conversion_id.process_id |
int Integer that identifies the process on the machine that generated the event. |
conversion_id.server_ip |
int The IPv4 address of the server that generated this event. |
conversion_id.time_usec |
int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds. |
conversion_type |
int The type of conversion. |
impression_data |
struct |
impression_data.ad_group_creative_id |
int ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table. |
impression_data.adgroup_id |
int ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table. |
impression_data.campaign_id |
int Unique ID of the campaign. |
impression_data.customer_id |
int Google Ads account ID. Joins with customer_id in any adh.google_ads table. |
impression_id |
bytes Unique identifier for impression. |
label |
string Name of conversion event. |
query_id |
struct Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table. |
query_id.process_id |
int Integer that identifies the process on the machine that generated the event. |
query_id.server_ip |
int The IPv4 address of the server that managed the ad request. Used to identify unique events for joins. |
query_id.time_usec |
int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds. |
user_id |
opaque The tracking ID (it is based on, but does not expose the user's browser cookie or mobile device ID). This field may be zeroed out for privacy reasons. User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes. |
Google Ads conversions audience
google_ads_conversions_audience |
|
---|---|
click_id |
struct Unique identifier for click has multiple parts. Joins with click_id in any adh.google_ads table. |
click_id.process_id |
int Integer that identifies the process on the machine that generated the event. |
click_id.server_ip |
int The IPv4 address of the server that generated this event. |
click_id.time_usec |
int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds. |
conversion_id |
struct Unique identifier for conversion has multiple parts. |
conversion_id.process_id |
int Integer that identifies the process on the machine that generated the event. |
conversion_id.server_ip |
int The IPv4 address of the server that generated this event. |
conversion_id.time_usec |
int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds. |
conversion_type |
int The type of conversion. |
impression_id |
bytes Unique identifier for impression. |
label |
string Name of conversion event. |
query_id |
struct Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table. |
query_id.process_id |
int Integer that identifies the process on the machine that generated the event. |
query_id.server_ip |
int The IPv4 address of the server that managed the ad request. Used to identify unique events for joins. |
query_id.time_usec |
int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds. |
user_id |
opaque The tracking ID (it is based on, but does not expose the user's browser cookie or mobile device ID). This field may be zeroed out for privacy reasons. 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 A unique identifier for the creative, specific to the ad group containing it. Joins with creative_id in any adh.google_ads table. |
creative_name |
string Creative name. |
creative_type |
int Creative type. |
customer_id |
int Google Ads account ID. Joins with customer_id in any adh.google_ads table. |
template_id |
int Template ID of the creative. |
third_party_url |
int The VAST tag URL string, as seen in Google products. |
video_message |
struct Multipart identifier for video data. |
video_message.video_ad_duration |
int Duration of the video in milliseconds. |
video_message.youtube_video_id |
string Video id string representation as it appears on YouTube watch url. |
Google Ads creative conversions
google_ads_creative_conversions |
|
---|---|
Beginning in March 2024, use the Google service tables in place of google_ads_creative_conversions :
|
|
advertiser_cost_local_micros |
double The advertiser's cost in local currency micros. |
advertiser_cost_usd |
double The advertiser's click cost in dollars. |
click_id |
struct Unique identifier for click has multiple parts. Joins with click_id in any adh.google_ads table. |
click_id.process_id |
int Integer that identifies the process on the machine that generated the event. |
click_id.server_ip |
int The IPv4 address of the server that generated this event. |
click_id.time_usec |
int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds. |
content_url |
string URL of the page on which the ad appeared. Part of the URL is removed for privacy. |
conversion_id |
struct Unique identifier for conversion has multiple parts. |
conversion_id.process_id |
int Integer that identifies the process on the machine that generated the event. |
conversion_id.server_ip |
int The IPv4 address of the server that generated this event. |
conversion_id.time_usec |
int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds. |
conversion_type |
int The type of conversion. |
impression_data |
struct |
impression_data.ad_group_creative_id |
int ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table. |
impression_data.adgroup_id |
int ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table. |
impression_data.campaign_id |
int Unique ID of the campaign. |
impression_data.customer_id |
int Google Ads account ID. Joins with customer_id in any adh.google_ads table. |
impression_id |
bytes Unique identifier for impression. |
label |
string Name of conversion event. |
num_video_views |
int Number of video views. |
query_id |
struct Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table. |
query_id.process_id |
int Integer that identifies the process on the machine that generated the event. |
query_id.server_ip |
int The IPv4 address of the server that managed the ad request. Used to identify unique events for joins. |
query_id.time_usec |
int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds. |
user_id |
opaque The tracking ID (it is based on, but does not expose the user's browser cookie or mobile device ID). This field may be zeroed out for privacy reasons. User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes. |
viewability_metrics |
struct Summable viewability metrics intended for Core and Advanced tiers of viewability. Metrics are organized by measurability pools. For each measurability pool, there is a sub-field containing the number of impressions that were measurable and the metrics that are available. |
viewability_metrics.active_view_plus_metrics |
struct Measures a variety of viewability metrics (including quartiles) that share a common measurability denominator. |
viewability_metrics.active_view_plus_metrics.ad_duration_msec |
int Total ad duration in milliseconds. |
viewability_metrics.active_view_plus_metrics.audible_and_fully_visible_watchtime_msec |
int Total audible (volume > 0%) and fully visible (100% on screen) watchtime in milliseconds. |
viewability_metrics.active_view_plus_metrics.audible_and_visible_watchtime_msec |
int Total audible (volume > 0%) and visible (at least 50% on screen) watchtime in milliseconds. |
viewability_metrics.active_view_plus_metrics.audible_count |
int Number of impressions that were audible (volume > 0%) at any point during playback. |
viewability_metrics.active_view_plus_metrics.audible_watchtime_msec |
int Total audible (volume > 0%) watchtime, in milliseconds. |
viewability_metrics.active_view_plus_metrics.background_count |
int Number of backgrounded impressions. |
viewability_metrics.active_view_plus_metrics.fullscreen_count |
int Number of fullscreened impressions. Note that this count only increments on YouTube platforms that have a toggle between normal/fullscreen state. YouTube Platforms that are always in fullscreen (like YouTube CTV Apps) will show up as 0. |
viewability_metrics.active_view_plus_metrics.fully_visible_watchtime_msec |
int Total fully visible (100% on screen) watchtime in milliseconds. |
viewability_metrics.active_view_plus_metrics.measurable_count |
int Number of impressions where Active View Plus metrics were able to be measured. |
viewability_metrics.active_view_plus_metrics.viewable_10_sec_count |
int Number of impressions that were at least 50% on screen for at least 10 seconds (cumulative). |
viewability_metrics.active_view_plus_metrics.visible_watchtime_msec |
int Total visible (at least 50% on screen) watchtime, in milliseconds. |
viewability_metrics.active_view_plus_metrics.watchtime_msec |
int Total watchtime in milliseconds. This may differ from the value reported in Google Ads, as it is only populated when Ads Data Hub is able to measure Active View metrics. |
viewability_metrics.active_view_plus_metrics.{start, q1, q2, q3, q4}.audible |
int Number of impressions that were audible (volume > 0%) at this point. |
viewability_metrics.active_view_plus_metrics.{start, q1, q2, q3, q4}.audible_and_visible |
int Number of impressions that were audible (volume > 0%) and 50% on screen at this point. |
viewability_metrics.active_view_plus_metrics.{start, q1, q2, q3, q4}.reached |
int Number of impressions that reached this point. |
viewability_metrics.active_view_plus_metrics.{start, q1, q2, q3, q4}.visible |
int Number of impressions that were at least 50% on screen at this point. |
viewability_metrics.enabled_count |
int 1 if Active View was enabled, else 0. To get the total number of impressions with Active View enabled, sum this field. |
viewability_metrics.groupm_trueview_viewable_impressions |
struct (Video only) Similar to groupm_viewable_impressions, but with an additional requirement on playback time for measurability. Impressions must reach the GroupM threshold of 15 seconds or 50% duration in addition to being GroupM measurable to be considered GroupM TrueView measurable. |
viewability_metrics.groupm_trueview_viewable_impressions.measureable_count |
int 1 if GroupM viewability was able to be measured and the impression reached the GroupM playback threshold, else 0. To get the total number of impressions where GroupM viewability was able to be measured and that reached the GroupM playback threshold, sum this field. |
viewability_metrics.groupm_trueview_viewable_impressions.viewable_count |
int 1 if the impression met the GroupM standard, else 0. To get the total number of impressions that met the GroupM standard, sum this field. |
viewability_metrics.groupm_viewable_impressions |
struct (Video only) Measures video ads playing 100% pixels on screen with audio volume > 0% for playback of at least 15 seconds or 50% of the ad duration, whichever is shorter. |
viewability_metrics.groupm_viewable_impressions.measureable_count |
int 1 if GroupM viewability was able to be measured, else 0. To get the total number of impressions where GroupM viewability was able to be measured, sum this field. |
viewability_metrics.groupm_viewable_impressions.viewable_count |
int 1 if the impression met the GroupM standard, else 0. To get the total number of impressions that met the GroupM standard, sum this field. |
viewability_metrics.mrc_cross_media_viewable_impressions |
struct (Video only) Measures video ads playing 100% on screen for 2 continuous seconds. |
viewability_metrics.mrc_cross_media_viewable_impressions.measureable_count |
int 1 if Cross-Media MRC viewability was able to be measured, else 0. To get the total number of impressions where Cross-Media MRC viewability was able to be measured, sum this field. |
viewability_metrics.mrc_cross_media_viewable_impressions.viewable_count |
int 1 if the impression met the Cross-Media MRC viewable standard, else 0. To get the total number of impressions that met the Cross-Media MRC viewable standard, sum this field. |
viewability_metrics.mrc_viewable_impressions |
struct Viewability metrics based on the MRC standard. That is, whether a video ad showed 50% pixels on screen for 2 continuous seconds of playback, or a display ad showed 50% pixels on screen for 1 continuous second. |
viewability_metrics.mrc_viewable_impressions.measureable_count |
int 1 if MRC viewability was able to be measured, else 0. To get the total number of impressions where MRC viewability was able to be measured, sum this field. |
viewability_metrics.mrc_viewable_impressions.viewable_count |
int 1 if the impression met the MRC standard, else 0. To get the total number of impressions that met the MRC viewable standard, sum this field. |
viewability_metrics.time_on_screen |
struct Measures the total time on screen for viewable impressions as determined by the MRC standard. The measurable count for impressions in this metric is zero for impressions that do not meet the MRC viewability threshold. |
viewability_metrics.time_on_screen.measureable_count |
int 1 if Time On Screen was able to be measured and met the MRC viewable standard, else 0. To get the total number of impressions where Time On Screen was able to be measured and met the MRC viewable standard, sum this field. |
viewability_metrics.time_on_screen.msec |
int Visible (at least 50% on screen) watchtime, in milliseconds, for impressions that met the MRC viewable standard. |
Google Ads creative vendor metadata
google_ads_creative_vendor_metadata |
|
---|---|
creative_id |
int A unique identifier for the creative, specific to the ad group containing it. Joins with creative_id in any adh.google_ads table. |
legacy_pixel |
string |
vendor_string |
string |
Google Ads customer
google_ads_customer |
|
---|---|
customer_company_name |
string Company name. |
customer_id |
int Google Ads account ID. Joins with customer_id in any adh.google_ads table. |
customer_name |
string Google Ads account name. |
customer_timezone |
string Google Ads account configured timezone, in IANA TZ Database Name format. |
external_customer_id |
int Google Ads account ID. |
mcc_ids |
array My Client Center: dashboard view in Google Ads that is provided to large advertisers and third-party agencies who manage and optimize multiple Google Ads accounts. |
Google Ads impressions
google_ads_impressions |
|
---|---|
Beginning in March 2024, use the Google service tables in place of 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. |
app_id |
string "Numerical identifier for the app's ID. Combined with the app_store_id, users can look up more information about the app. For example, 284815942 is the ID of Google's search app on Apple's App store. It only populates for Google Display Network (GDN) and Google Video Partner (GVP), which can be identified as INVENTORY_TYPE = OTHER. You can look up the app name by joining with the mobile_app_info table." |
app_store_id |
int64 'Numerical identifier corresponding to the app store which the app belongs to. e.g. 1 = "Apple App Store", 2 = "Google Play", or 8 = "PlayStation Store". It only populates for Google Display Network (GDN) and Google Video Partner (GVP), which can be identified as INVENTORY_TYPE = OTHER. You can look up the app store name by joining with the mobile_app_info table.' |
browser |
string Possible values are: "Chrome", "Cobalt", "Dalvik", "Edge", "Firefox", "IE", "Opera", "Other", "Safari", "Samsung Browser", "Roku", "Silk", "Unknown", "Yandex" |
campaign_id |
int Unique ID of the campaign. |
content_url |
string URL of the page on which the ad appeared. Part of the URL is removed for privacy. |
customer_id |
int Google Ads account ID. Joins with customer_id in any adh.google_ads table. |
device_height |
int Device height in px. |
device_width |
int Device width in px. |
format_category |
string "YouTube ad format. Possible values are AUDIO, DISPLAY, VIDEO, or UNSPECIFIED. Display includes infeed and masthead." |
impression_id |
bytes Unique identifier for impression. |
inventory_type |
string "The inventory type. Possible values: YOUTUBE, YOUTUBE_TV, YOUTUBE_MUSIC, SEARCH, GMAIL, OTHER. Other refers to either the Google Display or Video network." |
is_app_traffic |
boolean true if the event happened in a native app. FALSE if the event happened in HTML5 app or webview. |
location |
struct Unique identifier for location has multiple parts |
location.country |
string |
location.geo_city_id |
int Code for city. Joins with city_id in adh.city table. |
location.geo_country_id |
int |
location.geo_metro |
int Code for metro region. Joins with metro_id in adh.metro table. |
location.geo_region |
string Region as string e.g. US-CA. |
location.geo_region_id |
int |
mobile_browser_class |
int Type of device. Possible values are: desktop, tablet, smart tv consoles, or mobile. Joins with mobile_browser_class_id in adh.mobile_browser_class table. |
num_active_view_eligible_impression |
int 1 when impression is active view eligible; 0 when impression is not active view eligible. |
num_active_view_measurable_impression |
int 1 when impression is active view measurable; 0 when impression is not active view measurable. |
operating_system |
string Possible values are: "Android", "AppleTV", "Chrome OS", "Fire OS", "Google TV", "iOS", "Linux", "Mac", "Unknown", "PlayStation", "Roku", "Tizen", "Xbox", "Windows", "Windows Phone" |
operating_system_version_ids |
array (Deprecated) Use operating_system instead. ID of OS. Joins with operating_system_version_id in adh.os_version table. |
physical_screen_height |
int Device screen height in mm. |
physical_screen_width |
int Device screen width in mm. |
publisher_domain |
string Domain of the page on which ad appeared. |
query_id |
struct Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table. |
query_id.process_id |
int Integer that identifies the process on the machine that generated the event. |
query_id.server_ip |
int The IPv4 address of the server that managed the ad request. Used to identify unique events for joins. |
query_id.time_usec |
int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds. |
query_language |
string Language used by user. |
user_id |
opaque The tracking ID (it is based on, but does not expose the user's browser cookie or mobile device ID). This field may be zeroed out for privacy reasons. User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes. |
viewability_metrics |
struct Summable viewability metrics intended for Core and Advanced tiers of viewability. Metrics are organized by measurability pools. For each measurability pool, there is a sub-field containing the number of impressions that were measurable and the metrics that are available. |
viewability_metrics.active_view_plus_metrics |
struct Measures a variety of viewability metrics (including quartiles) that share a common measurability denominator. |
viewability_metrics.active_view_plus_metrics.ad_duration_msec |
int Total ad duration in milliseconds. |
viewability_metrics.active_view_plus_metrics.audible_and_fully_visible_watchtime_msec |
int Total audible (volume > 0%) and fully visible (100% on screen) watchtime in milliseconds. |
viewability_metrics.active_view_plus_metrics.audible_and_visible_watchtime_msec |
int Total audible (volume > 0%) and visible (at least 50% on screen) watchtime in milliseconds. |
viewability_metrics.active_view_plus_metrics.audible_count |
int Number of impressions that were audible (volume > 0%) at any point during playback. |
viewability_metrics.active_view_plus_metrics.audible_watchtime_msec |
int Total audible (volume > 0%) watchtime, in milliseconds. |
viewability_metrics.active_view_plus_metrics.background_count |
int Number of backgrounded impressions. |
viewability_metrics.active_view_plus_metrics.fullscreen_count |
int Number of fullscreened impressions. Note that this count only increments on YouTube platforms that have a toggle between normal/fullscreen state. YouTube Platforms that are always in fullscreen (like YouTube CTV Apps) will show up as 0. |
viewability_metrics.active_view_plus_metrics.fully_visible_watchtime_msec |
int Total fully visible (100% on screen) watchtime in milliseconds. |
viewability_metrics.active_view_plus_metrics.measurable_count |
int Number of impressions where Active View Plus metrics were able to be measured. |
viewability_metrics.active_view_plus_metrics.viewable_10_sec_count |
int Number of impressions that were at least 50% on screen for at least 10 seconds (cumulative). |
viewability_metrics.active_view_plus_metrics.visible_watchtime_msec |
int Total visible (at least 50% on screen) watchtime, in milliseconds. |
viewability_metrics.active_view_plus_metrics.watchtime_msec |
int Total watchtime in milliseconds. This may differ from the value reported in Google Ads, as it is only populated when Ads Data Hub is able to measure Active View metrics. |
viewability_metrics.active_view_plus_metrics.{start, q1, q2, q3, q4}.audible |
int Number of impressions that were audible (volume > 0%) at this point. |
viewability_metrics.active_view_plus_metrics.{start, q1, q2, q3, q4}.audible_and_visible |
int Number of impressions that were audible (volume > 0%) and 50% on screen at this point. |
viewability_metrics.active_view_plus_metrics.{start, q1, q2, q3, q4}.reached |
int Number of impressions that reached this point. |
viewability_metrics.active_view_plus_metrics.{start, q1, q2, q3, q4}.visible |
int Number of impressions that were at least 50% on screen at this point. |
viewability_metrics.enabled_count |
int 1 if Active View was enabled, else 0. To get the total number of impressions with Active View enabled, sum this field. |
viewability_metrics.groupm_trueview_viewable_impressions |
struct (Video only) Similar to groupm_viewable_impressions, but with an additional requirement on playback time for measurability. Impressions must reach the GroupM threshold of 15 seconds or 50% duration in addition to being GroupM measurable to be considered GroupM TrueView measurable. |
viewability_metrics.groupm_trueview_viewable_impressions.measureable_count |
int 1 if GroupM viewability was able to be measured and the impression reached the GroupM playback threshold, else 0. To get the total number of impressions where GroupM viewability was able to be measured and that reached the GroupM playback threshold, sum this field. |
viewability_metrics.groupm_trueview_viewable_impressions.viewable_count |
int 1 if the impression met the GroupM standard, else 0. To get the total number of impressions that met the GroupM standard, sum this field. |
viewability_metrics.groupm_viewable_impressions |
struct (Video only) Measures video ads playing 100% pixels on screen with audio volume > 0% for playback of at least 15 seconds or 50% of the ad duration, whichever is shorter. |
viewability_metrics.groupm_viewable_impressions.measureable_count |
int 1 if GroupM viewability was able to be measured, else 0. To get the total number of impressions where GroupM viewability was able to be measured, sum this field. |
viewability_metrics.groupm_viewable_impressions.viewable_count |
int 1 if the impression met the GroupM standard, else 0. To get the total number of impressions that met the GroupM standard, sum this field. |
viewability_metrics.mrc_cross_media_viewable_impressions |
struct (Video only) Measures video ads playing 100% on screen for 2 continuous seconds. |
viewability_metrics.mrc_cross_media_viewable_impressions.measureable_count |
int 1 if Cross-Media MRC viewability was able to be measured, else 0. To get the total number of impressions where Cross-Media MRC viewability was able to be measured, sum this field. |
viewability_metrics.mrc_cross_media_viewable_impressions.viewable_count |
int 1 if the impression met the Cross-Media MRC viewable standard, else 0. To get the total number of impressions that met the Cross-Media MRC viewable standard, sum this field. |
viewability_metrics.mrc_viewable_impressions |
struct Viewability metrics based on the MRC standard. That is, whether a video ad showed 50% pixels on screen for 2 continuous seconds of playback, or a display ad showed 50% pixels on screen for 1 continuous second. |
viewability_metrics.mrc_viewable_impressions.measureable_count |
int 1 if MRC viewability was able to be measured, else 0. To get the total number of impressions where MRC viewability was able to be measured, sum this field. |
viewability_metrics.mrc_viewable_impressions.viewable_count |
int 1 if the impression met the MRC standard, else 0. To get the total number of impressions that met the MRC viewable standard, sum this field. |
viewability_metrics.time_on_screen |
struct Measures the total time on screen for viewable impressions as determined by the MRC standard. The measurable count for impressions in this metric is zero for impressions that do not meet the MRC viewability threshold. |
viewability_metrics.time_on_screen.measureable_count |
int 1 if Time On Screen was able to be measured and met the MRC viewable standard, else 0. To get the total number of impressions where Time On Screen was able to be measured and met the MRC viewable standard, sum this field. |
viewability_metrics.time_on_screen.msec |
int Visible (at least 50% on screen) watchtime, in milliseconds, for impressions that met the MRC viewable standard. |
youtube_page_type |
enum Page type. Possible values are YOUTUBE_WATCH, YOUTUBE_HOME, YOUTUBE_SEARCH, or YOUTUBE_SHORTS. |
Google Ads label
google_ads_label |
|
---|---|
customer_id |
int Google Ads account ID. Joins with customer_id in any adh.google_ads table. |
description |
string Label description. |
label_id |
int64 Label ID. Joins with label_ids in adh.google_ads tables that contain label_ids. |
label_name |
string Label name. |
status |
int Label status. 1 = ENABLED. 2 = DELETED. |
Google Ads vendor reporting metadata
google_ads_vendor_reporting_data |
|
---|---|
campaign_id |
int Unique ID of the campaign. |
vendor_client_id |
string All lower-case formatted vendor client id (VCID). |
vendor_metric |
string Measurement type. |
vendor_reporting_id |
string Customer-provided identifier to slice their data by. |
Metro
metro |
|
---|---|
country_code |
string Two character country code. |
metro_id |
int Metro identifier. |
metro_name |
string Metro name. |
Mobile app info
mobile_app_info |
|
---|---|
app_id |
string Numerical identifier for the app's ID. Combined with the app_store_id, users can look up more information about the app. For example, 284815942 is the ID of Google's search app on Apple's App store. It only populates for Google Display Network (GDN) and Google Video Partner (GVP), which can be identified as INVENTORY_TYPE = OTHER. You can look up the app name by joining with the mobile_app_info table. |
app_name |
string The name of the app as it appears in the app store. |
app_store_id |
int64 Numerical identifier corresponding to the app store which the app belongs to. e.g. 1 = "Apple App Store", 2 = "Google Play", or 8 = "PlayStation Store". It only populates for Google Display Network (GDN) and Google Video Partner (GVP), which can be identified as INVENTORY_TYPE = OTHER. You can look up the app store name by joining with the mobile_app_info table. |
app_store_name |
string The name of the app store. |
Mobile browser class
mobile_browser_class |
|
---|---|
mobile_browser_class_id |
int Mobile browser class identifier. |
mobile_browser_class_name |
string Name of the mobile browser class. |
Partner Sold - Cross Sell Active Views
partner_sold_cross_sell_active_views |
|
---|---|
Beginning in March 2024, use the Google service tables in place of partner_sold_cross_sell_active_views :
|
|
content_url |
string URL of the page on which ad appeared. Part of the url is removed for privacy. |
impression_id |
string Unique identifier for impression. |
num_active_view_viewable_impression |
int 1 when impression is active view eligible; 0 when impression is not active view eligible. |
query_id |
struct Unique identifier for query has multiple parts. Joins with query_id. |
query_id.process_id |
int Integer that identifies the process on the machine that generated the event. |
query_id.server_ip |
int The IPv4 address of the server that generated this event. |
query_id.time_usec |
int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds. |
view_id |
struct Unique identifier for view has multiple parts. |
view_id.process_id |
int Integer that identifies the process on the machine that generated the event. |
view_id.server_ip |
int The IPv4 address of the server that generated this event. |
view_id.time_usec |
int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds. |
Partner Sold - Cross Sell clicks
partner_sold_cross_sell_clicks |
|
---|---|
Beginning in March 2024, use the Google service tables in place of partner_sold_cross_sell_clicks :
|
|
click_id |
struct Unique identifier for click has multiple parts. Joins with click_id. |
click_id.process_id |
int Integer that identifies the process on the machine that generated the event. |
click_id.server_ip |
int The IPv4 address of the server that generated this event. |
click_id.time_usec |
int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds. |
click_type |
int The click type. |
impression_id |
string Unique identifier for impression. |
query_id |
struct Unique identifier for query has multiple parts. Joins with query_id. |
query_id.process_id |
int Integer that identifies the process on the machine that generated the event. |
query_id.server_ip |
int The IPv4 address of the server that generated this event. |
query_id.time_usec |
int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds. |
user_id |
opaque User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes. |
Partner Sold - Cross Sell conversions
partner_sold_cross_sell_conversions |
|
---|---|
Beginning in March 2024, use the Google service tables in place of partner_sold_cross_sell_conversions :
|
|
click_id |
struct Unique identifier for click has multiple parts. Joins with click_id. |
click_id.process_id |
int Integer that identifies the process on the machine that generated the event. |
click_id.server_ip |
int The IPv4 address of the server that generated this event. |
click_id.time_usec |
int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds. |
conversion_id |
struct Unique identifier for conversion has multiple parts. |
conversion_id.process_id |
int Integer that identifies the process on the machine that generated the event. |
conversion_id.server_ip |
int The IPv4 address of the server that generated this event. |
conversion_id.time_usec |
int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds. |
conversion_type |
int The conversion type. |
impression_id |
string Unique identifier for impression. |
label |
string Name of conversion event. |
query_id |
struct Unique identifier for query has multiple parts. |
query_id.process_id |
int Integer that identifies the process on the machine that generated the event. |
query_id.server_ip |
int The IPv4 address of the server that generated this event. |
query_id.time_usec |
int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds. |
user_id |
opaque User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes. |
Partner Sold - Cross Sell creative
partner_sold_cross_sell_creative |
|
---|---|
creative_format_type |
string Some formats map directly to a type. Other types have multiple formats like: html, image, or video. |
creative_id |
int The ID of the creative. |
creative_name |
string Name of the creative. |
creative_type |
string The type of creative. |
skippable_ad_type |
string Possible values are: "SKIPPABLE", "NOT_SKIPPABLE", "UNKNOWN", or "OTHER". |
third_party_vast_url |
string VAST url of the creative if the creative is a third party hosted video. Does not support creatives from programmatic items. |
video_message |
struct Multipart identifier for video data. |
video_message.video_ad_duration |
int Duration of the video in milliseconds. |
video_message.youtube_video_id |
string Video id string representation as it appears on YouTube watch url. |
Partner Sold - Cross Sell creative conversions
partner_sold_cross_sell_creative_conversions |
|
---|---|
Beginning in March 2024, use the Google service tables in place of partner_sold_cross_sell_creative_conversions :
|
|
content_url |
string URL of the page on which ad appeared. Part of the url is removed for privacy. |
Partner Sold - Cross Sell creative pixels
partner_sold_cross_sell_creative_pixels |
|
---|---|
ad_id |
string Unique ID of the ad. |
pixel_url |
string The pixel URL. |
Partner Sold - Cross Sell impressions
partner_sold_cross_sell_impressions |
|
---|---|
Beginning in March 2024, use the Google service tables in place of partner_sold_cross_sell_impressions :
|
|
browser |
string Possible values are: "Chrome", "Cobalt", "Dalvik", "Edge", "Firefox", "IE", "Opera", "Other", "Safari", "Samsung Browser", "Roku", "Silk", "Unknown", "Yandex" |
content_url |
string URL of the page on which ad appeared. Part of the url is removed for privacy. |
creative_id |
int Joins with creative_id in any adh.yt table. |
device_height |
int Device height in pixels. |
device_width |
int Device width in pixels. |
format_category |
string YouTube ad format. Possible values are AUDIO, DISPLAY, VIDEO, UNSPECIFIED. |
gfp_placements |
array Ad Manager placement ID for this impression. Does not represent Campaign Manager 360 placement. |
impression_id |
string Unique identifier for impression. |
inventory_type |
enum The inventory type. Possible values: YOUTUBE, YOUTUBE TV, SEARCH, GMAIL, OTHER. Other refers to either the Google Display or Video network. |
line_item_id |
int Line item id for this impression. |
location |
struct Unique identifier for location has multiple parts. |
location.country |
string Code for country. |
location.geo_city_id |
int Code for city. Joins with city_id in adh.city table. |
location.geo_metro |
int Code for metrio region. Joins with metro_id in adh.metro table. |
location.geo_region |
string Region as a string (e.g. US-CA) |
mobile_browser_class |
int Type of device. Possible values are: desktop, tablet, smart tv consoles, or mobile. Joins with mobile_browser_class_id in adh.mobile_browser_class table. |
num_active_view_eligible_impression |
int 1 when impression is active view eligible; 0 when impression is not active view eligible. |
num_active_view_measurable_impression |
int 1 when impression is active view measurable; 0 when impression is not active view measurable. |
operating_system |
string Possible values are: "Android", "AppleTV", "Chrome OS", "Fire OS", "Google TV", "iOS", "Linux", "Mac", "Unknown", "PlayStation", "Roku", "Tizen", "Xbox", "Windows", "Windows Phone" |
order_id |
int Order ID for the impression. |
physical_screen_height |
int Device height in mm. |
physical_screen_width |
int Device screen width in mm. |
publisher_domain |
string Domain of page on which ad appeared. |
query_id |
struct Unique identifier for query has multiple parts. |
query_id.process_id |
int Integer that identifies the process on the machine that generated the event. |
query_id.server_ip |
int The IPv4 address of the server that generated this event. |
query_id.time_usec |
int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds. |
query_language |
string Language used by user. |
user_id |
opaque User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes. |
youtube_page_type |
enum Page type. Possible values are YOUTUBE_WATCH, YOUTUBE_HOME, YOUTUBE_SEARCH, or YOUTUBE_SHORTS. |
Partner Sold - Cross Sell line item
partner_sold_cross_sell_lineitem |
|
---|---|
creative_id |
int The ID of the creative. |
end_time |
timestamp Time the line item stopped being served. |
line_item_id |
int Ad Manager line item serving. |
line_item_name |
string Ad Manager line item name. |
order_id |
int Ad Manager Order identifier used for serving. |
order_name |
string Name of the insertion order. |
programmatic |
boolean true if the line item was programmatic. |
start_time |
timestamp Time the line item started to be served. |
Partner Sold - Cross Sell order
partner_sold_cross_sell_order |
|
---|---|
advertiser_id |
int Unique ID of the advertiser. |
advertiser_name |
string Publisher entered name. |
advertiser_timezone |
string The Partner Sold time zone default in the Ad Manager network settings. |
network_code |
int Ad Manager Publisher network code. |
order_id |
int Ad Manager Order identifier used for serving. |
order_name |
string Name of Ad Manager order. |
Partner Sold - Cross Sell vendor reporting data.
partner_sold_cross_sell_vendor_reporting_data |
|
---|---|
line_item_id |
int Unique ID of the line item. |
vendor_client_id |
string All lower-case formatted vendor client id (VCID). |
vendor_metric |
string Measurement type. |
vendor_reporting_id |
string Customer-provided identifier to slice their data by. |
Region
region |
|
---|---|
country_code |
string Two character country code. |
region_id |
int Region identifier. |
region_name |
string Region name. |
YouTube Reserve Active Views
yt_reserve_active_views |
|
---|---|
Beginning in March 2024, use the Google service tables in place of yt_reserve_active_views :
|
|
content_url |
string URL of the page on which ad appeared. Part of the url is removed for privacy. |
impression_data |
struct |
impression_data.creative_id |
int The ID of the creative. |
impression_data.line_item_id |
int Line item id for this impression. |
impression_data.media_plan_id |
int ID of the YouTube Reserve media plan. |
impression_data.order_id |
int |
impression_id |
bytes Unique identifier for impression. |
num_active_view_viewable_impression |
int 1 when impression is active view viewable; 0 when impression is not active view viewable. |
query_id |
struct Unique identifier for query has multiple parts. |
query_id.process_id |
int Integer that identifies the process on the machine that generated the event. |
query_id.server_ip |
int The IPv4 address of the server that generated this event. |
query_id.time_usec |
int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds. |
view_id |
struct Unique identifier for view has multiple parts. |
view_id.process_id |
int Integer that identifies the process on the machine that generated the event. |
view_id.server_ip |
int The IPv4 address of the server that generated this event. |
view_id.time_usec |
int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds. |
viewability_metrics |
struct Summable viewability metrics intended for Core and Advanced tiers of viewability. Metrics are organized by measurability pools. For each measurability pool, there is a sub-field containing the number of impressions that were measurable and the metrics that are available. |
viewability_metrics.active_view_plus_metrics |
struct Measures a variety of viewability metrics (including quartiles) that share a common measurability denominator. |
viewability_metrics.active_view_plus_metrics.ad_duration_msec |
int Total ad duration in milliseconds. |
viewability_metrics.active_view_plus_metrics.audible_and_fully_visible_watchtime_msec |
int Total audible (volume > 0%) and fully visible (100% on screen) watchtime in milliseconds. |
viewability_metrics.active_view_plus_metrics.audible_and_visible_watchtime_msec |
int Total audible (volume > 0%) and visible (at least 50% on screen) watchtime in milliseconds. |
viewability_metrics.active_view_plus_metrics.audible_count |
int Number of impressions that were audible (volume > 0%) at any point during playback. |
viewability_metrics.active_view_plus_metrics.audible_watchtime_msec |
int Total audible (volume > 0%) watchtime, in milliseconds. |
viewability_metrics.active_view_plus_metrics.background_count |
int Number of backgrounded impressions. |
viewability_metrics.active_view_plus_metrics.fullscreen_count |
int Number of fullscreened impressions. Note that this count only increments on YouTube platforms that have a toggle between normal/fullscreen state. YouTube Platforms that are always in fullscreen (like YouTube CTV Apps) will show up as 0. |
viewability_metrics.active_view_plus_metrics.fully_visible_watchtime_msec |
int Total fully visible (100% on screen) watchtime in milliseconds. |
viewability_metrics.active_view_plus_metrics.measurable_count |
int Number of impressions where Active View Plus metrics were able to be measured. |
viewability_metrics.active_view_plus_metrics.viewable_10_sec_count |
int Number of impressions that were at least 50% on screen for at least 10 seconds (cumulative). |
viewability_metrics.active_view_plus_metrics.visible_watchtime_msec |
int Total visible (at least 50% on screen) watchtime, in milliseconds. |
viewability_metrics.active_view_plus_metrics.watchtime_msec |
int Total watchtime in milliseconds. This may differ from the value reported in Google Ads, as it is only populated when Ads Data Hub is able to measure Active View metrics. |
viewability_metrics.active_view_plus_metrics.{start, q1, q2, q3, q4}.audible |
int Number of impressions that were audible (volume > 0%) at this point. |
viewability_metrics.active_view_plus_metrics.{start, q1, q2, q3, q4}.audible_and_visible |
int Number of impressions that were audible (volume > 0%) and 50% on screen at this point. |
viewability_metrics.active_view_plus_metrics.{start, q1, q2, q3, q4}.reached |
int Number of impressions that reached this point. |
viewability_metrics.active_view_plus_metrics.{start, q1, q2, q3, q4}.visible |
int Number of impressions that were at least 50% on screen at this point. |
viewability_metrics.enabled_count |
int 1 if Active View was enabled, else 0. To get the total number of impressions with Active View enabled, sum this field. |
viewability_metrics.groupm_trueview_viewable_impressions |
struct (Video only) Similar to groupm_viewable_impressions, but with an additional requirement on playback time for measurability. Impressions must reach the GroupM threshold of 15 seconds or 50% duration in addition to being GroupM measurable to be considered GroupM TrueView measurable. |
viewability_metrics.groupm_trueview_viewable_impressions.measureable_count |
int 1 if GroupM viewability was able to be measured and the impression reached the GroupM playback threshold, else 0. To get the total number of impressions where GroupM viewability was able to be measured and that reached the GroupM playback threshold, sum this field. |
viewability_metrics.groupm_trueview_viewable_impressions.viewable_count |
int 1 if the impression met the GroupM standard, else 0. To get the total number of impressions that met the GroupM standard, sum this field. |
viewability_metrics.groupm_viewable_impressions |
struct (Video only) Measures video ads playing 100% pixels on screen with audio volume > 0% for playback of at least 15 seconds or 50% of the ad duration, whichever is shorter. |
viewability_metrics.groupm_viewable_impressions.measureable_count |
int 1 if GroupM viewability was able to be measured, else 0. To get the total number of impressions where GroupM viewability was able to be measured, sum this field. |
viewability_metrics.groupm_viewable_impressions.viewable_count |
int 1 if the impression met the GroupM standard, else 0. To get the total number of impressions that met the GroupM standard, sum this field. |
viewability_metrics.mrc_cross_media_viewable_impressions |
struct (Video only) Measures video ads playing 100% on screen for 2 continuous seconds. |
viewability_metrics.mrc_cross_media_viewable_impressions.measureable_count |
int 1 if Cross-Media MRC viewability was able to be measured, else 0. To get the total number of impressions where Cross-Media MRC viewability was able to be measured, sum this field. |
viewability_metrics.mrc_cross_media_viewable_impressions.viewable_count |
int 1 if the impression met the Cross-Media MRC viewable standard, else 0. To get the total number of impressions that met the Cross-Media MRC viewable standard, sum this field. |
viewability_metrics.mrc_viewable_impressions |
struct Viewability metrics based on the MRC standard. That is, whether a video ad showed 50% pixels on screen for 2 continuous seconds of playback, or a display ad showed 50% pixels on screen for 1 continuous second. |
viewability_metrics.mrc_viewable_impressions.measureable_count |
int 1 if MRC viewability was able to be measured, else 0. To get the total number of impressions where MRC viewability was able to be measured, sum this field. |
viewability_metrics.mrc_viewable_impressions.viewable_count |
int 1 if the impression met the MRC standard, else 0. To get the total number of impressions that met the MRC viewable standard, sum this field. |
viewability_metrics.time_on_screen |
struct Measures the total time on screen for viewable impressions as determined by the MRC standard. The measurable count for impressions in this metric is zero for impressions that do not meet the MRC viewability threshold. |
viewability_metrics.time_on_screen.measureable_count |
int 1 if Time On Screen was able to be measured and met the MRC viewable standard, else 0. To get the total number of impressions where Time On Screen was able to be measured and met the MRC viewable standard, sum this field. |
viewability_metrics.time_on_screen.msec |
int Visible (at least 50% on screen) watchtime, in milliseconds, for impressions that met the MRC viewable standard. |
YouTube Reserve clicks
yt_reserve_clicks |
|
---|---|
Beginning in March 2024, use the Google service tables in place of yt_reserve_clicks :
|
|
click_id |
struct Unique identifier for click has multiple parts. |
click_id.process_id |
int Integer that identifies the process on the machine that generated the event. |
click_id.server_ip |
int The IPv4 address of the server that generated this event. |
click_id.time_usec |
int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds. |
click_type |
int The click type. |
impression_data |
struct |
impression_data.creative_id |
int The ID of the creative. |
impression_data.line_item_id |
int Line item id for this impression. |
impression_data.media_plan_id |
int ID of the YouTube Reserve media plan. |
impression_data.order_id |
int |
impression_id |
bytes Unique identifier for impression. |
query_id |
struct Unique identifier for query has multiple parts. |
query_id.process_id |
int Integer that identifies the process on the machine that generated the event. |
query_id.server_ip |
int The IPv4 address of the server that generated this event. |
query_id.time_usec |
int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds. |
user_id |
opaque User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes. |
YouTube Reserve conversions
yt_reserve_conversions |
|
---|---|
click_id |
struct Unique identifier for click has multiple parts. |
click_id.process_id |
int Integer that identifies the process on the machine that generated the event. |
click_id.server_ip |
int The IPv4 address of the server that generated this event. |
click_id.time_usec |
int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds. |
conversion_id |
struct Unique identifier for conversion has multiple parts. |
conversion_id.process_id |
int Integer that identifies the process on the machine that generated the event. |
conversion_id.server_ip |
int The IPv4 address of the server that generated this event. |
conversion_id.time_usec |
int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds. |
conversion_type |
int The type of conversion. |
impression_data |
struct |
impression_data.creative_id |
int The ID of the creative. |
impression_data.line_item_id |
int Line item id for this impression. |
impression_data.media_plan_id |
int ID of the YouTube Reserve media plan. |
impression_data.order_id |
int |
impression_id |
bytes Unique identifier for impression. |
label |
string Name of conversion event. |
query_id |
struct Unique identifier for query has multiple parts. |
query_id.process_id |
int Integer that identifies the process on the machine that generated the event. |
query_id.server_ip |
int The IPv4 address of the server that generated this event. |
query_id.time_usec |
int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds. |
user_id |
opaque User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes. |
YouTube Reserve creative
yt_reserve_creative |
|
---|---|
creative_format_type |
string Some formats map directly to a type. Other types have multiple formats like: html, image, or video. |
creative_id |
int The ID of the creative. |
creative_name |
string Name of the creative. |
creative_type |
string The type of creative. |
dcm_beacons |
array Multipart identifier for Campaign Manager 360 tracking pixel for ad. |
is_masthead |
boolean True if this is a masthead creative. |
skippable_ad_type |
string Possible values are: "SKIPPABLE", "NOT_SKIPPABLE", "UNKNOWN", or "OTHER". |
third_party_vast_url |
string VAST url of the creative if the creative is a third party hosted video. Doesn't support creatives from programmatic items. Formatting doesn't match dv360_youtube_creative.third_party_vast_url |
video_message |
struct Multipart identifier for video data. |
video_message.video_ad_duration |
int Duration of the video in milliseconds. |
video_message.youtube_channel_id |
string Id of the channel that provides this video. |
video_message.youtube_video_id |
string Video id string representation as it appears on YouTube watch url. |
YouTube Reserve creative conversions
yt_reserve_creative_conversions |
|
---|---|
Beginning in March 2024, use the Google service tables in place of yt_reserve_creative_conversions :
|
|
click_id |
struct Unique identifier for click has multiple parts. |
click_id.process_id |
int Integer that identifies the process on the machine that generated the event. |
click_id.server_ip |
int The IPv4 address of the server that generated this event. |
click_id.time_usec |
int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds. |
content_url |
string URL of the page on which ad appeared. Part of the url is removed for privacy. |
conversion_id |
struct Unique identifier for conversion has multiple parts. |
conversion_id.process_id |
int Integer that identifies the process on the machine that generated the event. |
conversion_id.server_ip |
int The IPv4 address of the server that generated this event. |
conversion_id.time_usec |
int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds. |
conversion_type |
int The type of conversion. |
impression_data |
struct |
impression_data.creative_id |
int ID of the creative. |
impression_data.line_item_id |
int Line item ID for this impression. |
impression_data.media_plan_id |
int ID of the YouTube Reserve media plan. |
impression_data.order_id |
int ID of Display & Video 360 customer. Joins with customer_id in any adh.dv360 table. |
impression_id |
bytes Unique identifier for impression. |
label |
string Name of conversion event. |
query_id |
struct Unique identifier for query has multiple parts. |
query_id.process_id |
int Integer that identifies the process on the machine that generated the event. |
query_id.server_ip |
int The IPv4 address of the server that generated this event. |
query_id.time_usec |
int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds. |
user_id |
opaque User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes. |
viewability_metrics |
struct Summable viewability metrics intended for Core and Advanced tiers of viewability. Metrics are organized by measurability pools. For each measurability pool, there is a sub-field containing the number of impressions that were measurable and the metrics that are available. |
viewability_metrics.active_view_plus_metrics |
struct Measures a variety of viewability metrics (including quartiles) that share a common measurability denominator. |
viewability_metrics.active_view_plus_metrics.ad_duration_msec |
int Total ad duration in milliseconds. |
viewability_metrics.active_view_plus_metrics.audible_and_fully_visible_watchtime_msec |
int Total audible (volume > 0%) and fully visible (100% on screen) watchtime in milliseconds. |
viewability_metrics.active_view_plus_metrics.audible_and_visible_watchtime_msec |
int Total audible (volume > 0%) and visible (at least 50% on screen) watchtime in milliseconds. |
viewability_metrics.active_view_plus_metrics.audible_count |
int Number of impressions that were audible (volume > 0%) at any point during playback. |
viewability_metrics.active_view_plus_metrics.audible_watchtime_msec |
int Total audible (volume > 0%) watchtime, in milliseconds. |
viewability_metrics.active_view_plus_metrics.background_count |
int Number of backgrounded impressions. |
viewability_metrics.active_view_plus_metrics.fullscreen_count |
int Number of fullscreened impressions. Note that this count only increments on YouTube platforms that have a toggle between normal/fullscreen state. YouTube Platforms that are always in fullscreen (like YouTube CTV Apps) will show up as 0. |
viewability_metrics.active_view_plus_metrics.fully_visible_watchtime_msec |
int Total fully visible (100% on screen) watchtime in milliseconds. |
viewability_metrics.active_view_plus_metrics.measurable_count |
int Number of impressions where Active View Plus metrics were able to be measured. |
viewability_metrics.active_view_plus_metrics.viewable_10_sec_count |
int Number of impressions that were at least 50% on screen for at least 10 seconds (cumulative). |
viewability_metrics.active_view_plus_metrics.visible_watchtime_msec |
int Total visible (at least 50% on screen) watchtime, in milliseconds. |
viewability_metrics.active_view_plus_metrics.watchtime_msec |
int Total watchtime in milliseconds. This may differ from the value reported in Google Ads, as it is only populated when Ads Data Hub is able to measure Active View metrics. |
viewability_metrics.active_view_plus_metrics.{start, q1, q2, q3, q4}.audible |
int Number of impressions that were audible (volume > 0%) at this point. |
viewability_metrics.active_view_plus_metrics.{start, q1, q2, q3, q4}.audible_and_visible |
int Number of impressions that were audible (volume > 0%) and 50% on screen at this point. |
viewability_metrics.active_view_plus_metrics.{start, q1, q2, q3, q4}.reached |
int Number of impressions that reached this point. |
viewability_metrics.active_view_plus_metrics.{start, q1, q2, q3, q4}.visible |
int Number of impressions that were at least 50% on screen at this point. |
viewability_metrics.enabled_count |
int 1 if Active View was enabled, else 0. To get the total number of impressions with Active View enabled, sum this field. |
viewability_metrics.groupm_trueview_viewable_impressions |
struct (Video only) Similar to groupm_viewable_impressions, but with an additional requirement on playback time for measurability. Impressions must reach the GroupM threshold of 15 seconds or 50% duration in addition to being GroupM measurable to be considered GroupM TrueView measurable. |
viewability_metrics.groupm_trueview_viewable_impressions.measureable_count |
int 1 if GroupM viewability was able to be measured and the impression reached the GroupM playback threshold, else 0. To get the total number of impressions where GroupM viewability was able to be measured and that reached the GroupM playback threshold, sum this field. |
viewability_metrics.groupm_trueview_viewable_impressions.viewable_count |
int 1 if the impression met the GroupM standard, else 0. To get the total number of impressions that met the GroupM standard, sum this field. |
viewability_metrics.groupm_viewable_impressions |
struct (Video only) Measures video ads playing 100% pixels on screen with audio volume > 0% for playback of at least 15 seconds or 50% of the ad duration, whichever is shorter. |
viewability_metrics.groupm_viewable_impressions.measureable_count |
int 1 if GroupM viewability was able to be measured, else 0. To get the total number of impressions where GroupM viewability was able to be measured, sum this field. |
viewability_metrics.groupm_viewable_impressions.viewable_count |
int 1 if the impression met the GroupM standard, else 0. To get the total number of impressions that met the GroupM standard, sum this field. |
viewability_metrics.mrc_cross_media_viewable_impressions |
struct (Video only) Measures video ads playing 100% on screen for 2 continuous seconds. |
viewability_metrics.mrc_cross_media_viewable_impressions.measureable_count |
int 1 if Cross-Media MRC viewability was able to be measured, else 0. To get the total number of impressions where Cross-Media MRC viewability was able to be measured, sum this field. |
viewability_metrics.mrc_cross_media_viewable_impressions.viewable_count |
int 1 if the impression met the Cross-Media MRC viewable standard, else 0. To get the total number of impressions that met the Cross-Media MRC viewable standard, sum this field. |
viewability_metrics.mrc_viewable_impressions |
struct Viewability metrics based on the MRC standard. That is, whether a video ad showed 50% pixels on screen for 2 continuous seconds of playback, or a display ad showed 50% pixels on screen for 1 continuous second. |
viewability_metrics.mrc_viewable_impressions.measureable_count |
int 1 if MRC viewability was able to be measured, else 0. To get the total number of impressions where MRC viewability was able to be measured, sum this field. |
viewability_metrics.mrc_viewable_impressions.viewable_count |
int 1 if the impression met the MRC standard, else 0. To get the total number of impressions that met the MRC viewable standard, sum this field. |
viewability_metrics.time_on_screen |
struct Measures the total time on screen for viewable impressions as determined by the MRC standard. The measurable count for impressions in this metric is zero for impressions that do not meet the MRC viewability threshold. |
viewability_metrics.time_on_screen.measureable_count |
int 1 if Time On Screen was able to be measured and met the MRC viewable standard, else 0. To get the total number of impressions where Time On Screen was able to be measured and met the MRC viewable standard, sum this field. |
viewability_metrics.time_on_screen.msec |
int Visible (at least 50% on screen) watchtime, in milliseconds, for impressions that met the MRC viewable standard. |
YouTube Reserve impressions
yt_reserve_impressions |
|
---|---|
Beginning in March 2024, use the Google service tables in place of 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. |
format_category |
string YouTube ad format. Possible values are AUDIO, DISPLAY, VIDEO, UNSPECIFIED. |
impression_id |
bytes Unique identifier for impression. |
inventory_type |
string The inventory type. Possible values: YOUTUBE, YOUTUBE_TV, YOUTUBE_MUSIC, SEARCH, GMAIL, OTHER. Other refers to either the Google Display or Video network. |
is_app_traffic |
boolean TRUE if the event happened in a native app. FALSE if the event happened in HTML5 app or webview. |
line_item_id |
int Line item id for this impression. |
location |
struct Unique identifier for location, which has multiple parts: geo_city_id, geo_metro, geo_region. |
location.country |
string Two-letter code for country, for example "US". |
location.geo_city_id |
int Code for city. Joins with city_id in adh.city table. |
location.geo_metro |
int Code for metro region. Joins with metro_id in adh.metro table. |
location.geo_region |
string Region as string, e.g. US-CA. |
media_plan_id |
int ID of the YouTube Reserve media plan. |
mobile_browser_class |
int Type of device. Possible values are: desktop, tablet, smart tv consoles, or mobile. Joins with mobile_browser_class_id in adh.mobile_browser_class table. |
num_active_view_eligible_impression |
int 1 when impression is active view eligible; 0 when impression is not active view eligible. |
num_active_view_measurable_impression |
int 1 when impression is active view measurable; 0 when impression is not active view measurable. |
operating_system |
string Possible values are: "Android", "AppleTV", "Chrome OS", "Fire OS", "Google TV", "iOS", "Linux", "Mac", "Unknown", "PlayStation", "Roku", "Tizen", "Xbox", "Windows", "Windows Phone" |
order_id |
int ID of the Google Ad Manager order. |
physical_screen_height |
int Device screen height in mm. |
physical_screen_width |
int Device screen width in mm. |
publisher_domain |
string Domain of page on which ad appeared. |
query_id |
struct Unique identifier for query, which has multiple parts: process_id, server_ip, time_usec. |
query_id.process_id |
int ID of the process on the machine that generated the event. |
query_id.server_ip |
int IP address of the server that generated the event. |
query_id.time_usec |
int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds. |
query_language |
string Language used by user. |
user_id |
opaque User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes. |
viewability_metrics |
struct Summable viewability metrics intended for Core and Advanced tiers of viewability. Metrics are organized by measurability pools. For each measurability pool, there is a sub-field containing the number of impressions that were measurable and the metrics that are available. |
viewability_metrics.active_view_plus_metrics |
struct Measures a variety of viewability metrics (including quartiles) that share a common measurability denominator. |
viewability_metrics.active_view_plus_metrics.ad_duration_msec |
int Total ad duration in milliseconds. |
viewability_metrics.active_view_plus_metrics.audible_and_fully_visible_watchtime_msec |
int Total audible (volume > 0%) and fully visible (100% on screen) watchtime in milliseconds. |
viewability_metrics.active_view_plus_metrics.audible_and_visible_watchtime_msec |
int Total audible (volume > 0%) and visible (at least 50% on screen) watchtime in milliseconds. |
viewability_metrics.active_view_plus_metrics.audible_count |
int Number of impressions that were audible (volume > 0%) at any point during playback. |
viewability_metrics.active_view_plus_metrics.audible_watchtime_msec |
int Total audible (volume > 0%) watchtime, in milliseconds. |
viewability_metrics.active_view_plus_metrics.background_count |
int Number of backgrounded impressions. |
viewability_metrics.active_view_plus_metrics.fullscreen_count |
int Number of fullscreened impressions. Note that this count only increments on YouTube platforms that have a toggle between normal/fullscreen state. YouTube Platforms that are always in fullscreen (like YouTube CTV Apps) will show up as 0. |
viewability_metrics.active_view_plus_metrics.fully_visible_watchtime_msec |
int Total fully visible (100% on screen) watchtime in milliseconds. |
viewability_metrics.active_view_plus_metrics.measurable_count |
int Number of impressions where Active View Plus metrics were able to be measured. |
viewability_metrics.active_view_plus_metrics.viewable_10_sec_count |
int Number of impressions that were at least 50% on screen for at least 10 seconds (cumulative). |
viewability_metrics.active_view_plus_metrics.visible_watchtime_msec |
int Total visible (at least 50% on screen) watchtime, in milliseconds. |
viewability_metrics.active_view_plus_metrics.watchtime_msec |
int Total watchtime in milliseconds. This may differ from the value reported in Google Ads, as it is only populated when Ads Data Hub is able to measure Active View metrics. |
viewability_metrics.active_view_plus_metrics.{start, q1, q2, q3, q4}.audible |
int Number of impressions that were audible (volume > 0%) at this point. |
viewability_metrics.active_view_plus_metrics.{start, q1, q2, q3, q4}.audible_and_visible |
int Number of impressions that were audible (volume > 0%) and 50% on screen at this point. |
viewability_metrics.active_view_plus_metrics.{start, q1, q2, q3, q4}.reached |
int Number of impressions that reached this point. |
viewability_metrics.active_view_plus_metrics.{start, q1, q2, q3, q4}.visible |
int Number of impressions that were at least 50% on screen at this point. |
viewability_metrics.enabled_count |
int 1 if Active View was enabled, else 0. To get the total number of impressions with Active View enabled, sum this field. |
viewability_metrics.groupm_trueview_viewable_impressions |
struct (Video only) Similar to groupm_viewable_impressions, but with an additional requirement on playback time for measurability. Impressions must reach the GroupM threshold of 15 seconds or 50% duration in addition to being GroupM measurable to be considered GroupM TrueView measurable. |
viewability_metrics.groupm_trueview_viewable_impressions.measureable_count |
int 1 if GroupM viewability was able to be measured and the impression reached the GroupM playback threshold, else 0. To get the total number of impressions where GroupM viewability was able to be measured and that reached the GroupM playback threshold, sum this field. |
viewability_metrics.groupm_trueview_viewable_impressions.viewable_count |
int 1 if the impression met the GroupM standard, else 0. To get the total number of impressions that met the GroupM standard, sum this field. |
viewability_metrics.groupm_viewable_impressions |
struct (Video only) Measures video ads playing 100% pixels on screen with audio volume > 0% for playback of at least 15 seconds or 50% of the ad duration, whichever is shorter. |
viewability_metrics.groupm_viewable_impressions.measureable_count |
int 1 if GroupM viewability was able to be measured, else 0. To get the total number of impressions where GroupM viewability was able to be measured, sum this field. |
viewability_metrics.groupm_viewable_impressions.viewable_count |
int 1 if the impression met the GroupM standard, else 0. To get the total number of impressions that met the GroupM standard, sum this field. |
viewability_metrics.mrc_cross_media_viewable_impressions |
struct (Video only) Measures video ads playing 100% on screen for 2 continuous seconds. |
viewability_metrics.mrc_cross_media_viewable_impressions.measureable_count |
int 1 if Cross-Media MRC viewability was able to be measured, else 0. To get the total number of impressions where Cross-Media MRC viewability was able to be measured, sum this field. |
viewability_metrics.mrc_cross_media_viewable_impressions.viewable_count |
int 1 if the impression met the Cross-Media MRC viewable standard, else 0. To get the total number of impressions that met the Cross-Media MRC viewable standard, sum this field. |
viewability_metrics.mrc_viewable_impressions |
struct Viewability metrics based on the MRC standard. That is, whether a video ad showed 50% pixels on screen for 2 continuous seconds of playback, or a display ad showed 50% pixels on screen for 1 continuous second. |
viewability_metrics.mrc_viewable_impressions.measureable_count |
int 1 if MRC viewability was able to be measured, else 0. To get the total number of impressions where MRC viewability was able to be measured, sum this field. |
viewability_metrics.mrc_viewable_impressions.viewable_count |
int 1 if the impression met the MRC standard, else 0. To get the total number of impressions that met the MRC viewable standard, sum this field. |
viewability_metrics.time_on_screen |
struct Measures the total time on screen for viewable impressions as determined by the MRC standard. The measurable count for impressions in this metric is zero for impressions that do not meet the MRC viewability threshold. |
viewability_metrics.time_on_screen.measureable_count |
int 1 if Time On Screen was able to be measured and met the MRC viewable standard, else 0. To get the total number of impressions where Time On Screen was able to be measured and met the MRC viewable standard, sum this field. |
viewability_metrics.time_on_screen.msec |
int Visible (at least 50% on screen) watchtime, in milliseconds, for impressions that met the MRC viewable standard. |
youtube_page_type |
enum Page type. Possible values are YOUTUBE_WATCH, YOUTUBE_HOME, YOUTUBE_SEARCH, or YOUTUBE_SHORTS. |
YouTube Reserve line item
yt_reserve_lineitem |
|
---|---|
creative_id |
array Array of creative ids for this line item. Joins with creative_id in any adh.yt table. |
end_time |
timestamp Time the line item stopped being served. |
line_item_id |
int Ad Manager line item serving. |
line_item_name |
string Ad Manager line item name. |
order_id |
int Ad Manager Order identifier used for serving. |
order_name |
string Name of the insertion order. |
programmatic |
boolean True if the line item was programmatic. |
start_time |
timestamp Time the line item started to be served. |
YouTube Reserve order
yt_reserve_order |
|
---|---|
advertiser_id |
int Unique ID of the advertiser. |
advertiser_name |
string User entered name of the advertiser. |
advertiser_timezone |
string The YouTube Reserve advertiser time zone default set in account settings. |
media_plan_id |
int ID of the YouTube Reserve media plan. |
media_plan_name |
string Name of the YouTube Reserve media plan. |
order_id |
int Ad Manager Order identifier used for serving. |
order_name |
string Name of Ad Manager order |
YouTube Reserve vendor reporting metadata
yt_reserve_vendor_reporting_data |
|
---|---|
line_item_id |
int Unique ID of the line item. |
vendor_client_id |
string All lower-case formatted vendor client id (VCID). |
vendor_metric |
string Measurement type. |
vendor_reporting_id |
string Customer-provided identifier to slice their data by. |