Ads Data Hub table schema- Vendors

Ad Manager 360 auctions

am360_auctions
bidstruct
A repeated field describing each of the bids into the AdX auction.
bid.buyer_namestring
The name of the buyer network or third-party exchange that placed this bid.
bid.classified_advertiser_namestring
The Google-classified name of the advertiser whose ad would be served if this bid won.
bid.cpmdouble
The CPM of this bid, in the publisher network’s default currency.
bid.deal_idstring
The ID of the deal that would apply if this bid won.
bid.deal_typestring
The type of deal associated with this bid. Can be one of 'Private auction', 'Preferred deal', or 'Programmatic guaranteed', or null if no deal applied.
bid.outcomestring
The outcome of this bid. Can be one of 'Winner' (a winning bid), 'Outbid' (lost to another bid or reservation), 'Floor' (rejected due to being below an auction floor), 'Consent' (rejected due to lack of user consent for the vendor), 'Block' (rejected due to publisher settings, such as product category filtering), or 'Other' (rejected for some other reason).
bid.sourcestring
The source of this bid. Can either be 'Ad Exchange' (a bid from an authorized buyer) or 'Open Bidding' (a bid from a third-party exchange).
bid.upr_floor_cpmdouble
The unified pricing rule-based floor price that applied to this bid.
bid.yield_group_idsint
The IDs of the yield groups that allowed this source of demand to place this bid.
bid.yield_partner_idint
The ID of the company placing this bid. Joins to am360_match_company.company_id.
event_time_usectimestamp
The timestamp of the specific event.
metadatastruct
A group of fields containing metadata about the event.
metadata.child_network_codestring
Identifies the Multiple Customer Management (MCM) child network who operates the property requesting the ad.
metadata.event_idstring
A unique ID for this event across all tables.
metadata.network_codestring
Identifies the publisher network that controls the inventory being filled by the ad query.
metadata.request_idstring
An identifier shared by all events related to a request to fill a single ad block (aka ad slot). Shared among all queries and later events related to a Single Request Architecture (SRA) or Video Pod request.
request_time_usectimestamp
The timestamp of the initial request to Google that became the ad query.
user_idstring
Google-assigned ID of the browser that sent the ad event. Cannot be extracted.
user_ppidstring
Encoded Publisher Provided ID (PPID) from the ad query. Cannot be decoded. Cannot be extracted.

Ad Manager 360 conversions

am360_conversions
activity_idint
The ID of the activity that was performed, from the Spotlight tag.
activity_triggerstring
The user action that led to this activity. One of 'Impression' or 'Click'.
click_idstring
The ID of the click that led to this activity, if there was one. Joins to am360_interactions.metadata.event_id.
deliverystruct
A group of fields describing the ad delivered to fill the query.
delivery.advertiser_company_idint
The ID of the company associated with this order. Can also be found through the order metadata table. Reservation-only. Joins to am360_match_company.company_id.
delivery.auction_idstring
If an auction ran to fill the creative serve related to this event, the ID of the auction record. Joins to am360_auctions.metadata.event_id.
delivery.buyer_namestring
The name of the buyer network or third-party exchange that filled the ad.
delivery.classified_advertiser_namestring
The Google-classified advertiser name whose ad served.
delivery.creative_idint
The ID of the publisher's reservation creative that was served. Reservation-only
delivery.creative_serve_idstring
The ID of the served creative. If this event was a creative serve, will be equal to the event_id. Joins to am360_creative_serves.metadata.event_id.
delivery.creative_size_deliveredstring
The size of the creative that was served.
delivery.deal_idstring
The ID of the direct deal used when choosing this ad.
delivery.deal_typestring
The type of direct deal (e.g. 'Programmatic guaranteed', 'Preferred deal', 'Private auction', etc.).
delivery.demand_channelstring
The demand channel that filled the ad request (e.g. 'Ad Server', 'Open Auction', etc.)
delivery.estimated_revenuedouble
An estimate of the revenue this event will cause the publisher to receive, in the publisher network's default currency. These are whole currency units, not CPM.
delivery.line_item_idint
The line item that allowed this ad to serve. Joins to am360_match_line_item.line_item_id.
delivery.optimization_typestring
The type of optimization applied when choosing this creative (i.e. 'Optimized competition', 'Target CPM', 'First Look'). May be null
delivery.order_idint
The order (aka campaign) that contains the line item. Joins to am360_match_order.order_id.
delivery.query_idstring
The ID of the originating query record in the queries table. Joins to am360_queries.metadata.event_id.
delivery.targeted_audience_segment_idsint
Audience segment (aka user list) IDs used when targeting this creative at the user, both positive and negative matches.
delivery.targeted_custom_criteriastruct
A repeated field describing how the custom_criteria from the inventory was used in targeting this creative.
delivery.targeted_custom_criteria.is_negative_matchbool
Whether this key/value was negatively matched by line item targeting.
delivery.targeted_custom_criteria.keystring
The name of the custom_criteria key.
delivery.targeted_custom_criteria.match_typestring
The type of match that was performed (e.g. 'Broad', 'Exact', 'Prefix', etc.).
delivery.targeted_custom_criteria.patternstring
The pattern that the value from inventory.custom_criteria matched.
delivery.video_fallback_indexint
The index of this video fallback creative, or null.
delivery.yield_group_idsint
The IDs of the yield groups that allowed this source of demand to fill this ad.
delivery.yield_partner_idint
The company ID that filled this ad. Joins to am360_match_company.company_id.
event_time_usectimestamp
The timestamp of the specific event.
inventorystruct
A group of fields describing the inventory properties from the ad query.
inventory.ad_unit_idint
The ID of the ad unit (aka inventory unit) where the ad will display. Joins to am360_match_ad_unit.ad_unit_id.
inventory.ad_unit_pathint
The path to the ad unit. Ad units are organized into a hierarchical tree, like 'root/sports/frontpage/top'. The first entry in this list is the root ad unit ID, unique to each publisher network, and the last entry is the leaf. Each entry joins to am360_match_ad_unit.ad_unit_id.
inventory.ad_unit_sizesstring
The requested size(s) of the ad to display in this ad unit. May contain values like '320x250', 'Native', and 'Fluid'.
inventory.custom_criteriastruct
Repeated field containing free-form key values passed through the ad query. If a key is passed multiple times on the ad query, each will appear as its own custom_criteria entry.
inventory.custom_criteria.keystring
The key of this custom criteria, passed in on the ad query.
inventory.custom_criteria.valuestring
The value of this custom criteria value, passed in on the ad query.
inventory.devicestruct
A group of fields describing the device that made the ad query.
inventory.device_categorystring
The type of device, such as 'Smartphone' or 'Desktop'.
inventory.geostruct
A group of fields describing the geographical location where the ad query came from.
inventory.geo.countrystring
The name of the country where the ad query came from.
inventory.geo.languagestring
The language of the query.
inventory.geo.language_countrystring
The country of the language of the query. May be different from the country if, e.g., someone from Seville is visiting the US. Often null.
inventory.geo.regionstring
The name of the geographical region where the ad query came from.
inventory.is_companionbool
True if the query was for a companion to another ad on the page. Such events are not counted by Ad Manager Reports.
inventory.matched_audience_segment_idsint
The IDs of audience segments (aka user lists) visible to the publisher network that contain the user ID making the ad query.
inventory.placement_idint
The ID of the placement (a group of ad units). Joins to am360_match_placement.placement_id.
inventory.referer_urlstring
The sanitized URL of the page that issued the ad query; for web queries, this is approximately the URL of the page that requested the ad; for mobile ad queries, this is an arbitrary string that looks like a URL, but identifies the mobile app.
inventory.video_content_idint
The ID of the video content the ad is displaying against (defined by the publisher).
inventory.video_positionint
The position in the video where the ad will play. 1 is preroll, 3 is postroll, and 4+ are midrolls in consecutive order.
inventory.web_propertystring
The web property code associated with the ad request.
metadatastruct
A group of fields containing metadata about the event.
metadata.child_network_codestring
Identifies the Multiple Customer Management (MCM) child network who operates the property requesting the ad.
metadata.event_idstring
A unique ID for this event across all tables.
metadata.network_codestring
Identifies the publisher network that controls the inventory being filled by the ad query.
metadata.request_idstring
An identifier shared by all events related to a request to fill a single ad block (aka ad slot). Shared among all queries and later events related to a Single Request Architecture (SRA) or Video Pod request.
order_costint
The amount the user paid the advertiser, as reported in the cost= parameter of the Spotlight tag.
order_numberstring
The user's order number with the advertiser reported in the ord= parameter of the Spotlight tag.
order_quantityint
The quantity of items purchased by the user from the advertiser, as reported in the qty= parameter of the Spotlight tag.
request_time_usectimestamp
The timestamp of the initial request to Google that became the ad query.
trigger_usectimestamp
The timestamp of the user action that led to this activity.
user_idstring
Google-assigned ID of the browser that sent the ad event. Cannot be extracted.
user_ppidstring
Encoded Publisher Provided ID (PPID) from the ad query. Cannot be decoded. Cannot be extracted.

Ad Manager 360 creative serves

am360_creative_serves
deliverystruct
A group of fields describing the ad delivered to fill the query.
delivery.advertiser_company_idint
The ID of the company associated with this order. Can also be found through the order metadata table. Reservation-only. Joins to am360_match_company.company_id.
delivery.auction_idstring
If an auction ran to fill the creative serve related to this event, the ID of the auction record. Joins to am360_auctions.metadata.event_id.
delivery.buyer_namestring
The name of the buyer network or third-party exchange that filled the ad.
delivery.classified_advertiser_namestring
The Google-classified advertiser name whose ad served.
delivery.creative_idint
The ID of the publisher's reservation creative that was served. Reservation-only
delivery.creative_serve_idstring
The ID of the served creative. If this event was a creative serve, will be equal to the event_id. Joins to am360_creative_serves.metadata.event_id.
delivery.creative_size_deliveredstring
The size of the creative that was served.
delivery.deal_idstring
The ID of the direct deal used when choosing this ad.
delivery.deal_typestring
The type of direct deal (e.g. 'Programmatic guaranteed', 'Preferred deal', 'Private auction', etc.).
delivery.demand_channelstring
The demand channel that filled the ad request (e.g. 'Ad Server', 'Open Auction', etc.)
delivery.estimated_revenuedouble
An estimate of the revenue this event will cause the publisher to receive, in the publisher network's default currency. These are whole currency units, not CPM.
delivery.line_item_idint
The line item that allowed this ad to serve. Joins to am360_match_line_item.line_item_id.
delivery.optimization_typestring
The type of optimization applied when choosing this creative (i.e. 'Optimized competition', 'Target CPM', 'First Look').
delivery.order_idint
The order (aka campaign) that contains the line item. Joins to am360_match_order.order_id.
delivery.query_idstring
The ID of the originating query record in the queries table. Joins to am360_queries.metadata.event_id.
delivery.targeted_audience_segment_idsint
Audience segment (aka user list) IDs used when targeting this creative at the user. Includes both positive and negative matches.
delivery.targeted_custom_criteriastruct
A repeated field describing how the custom_criteria from the inventory was used in targeting this creative.
delivery.targeted_custom_criteria.is_negative_matchbool
True if this key/value was targeted negatively.
delivery.targeted_custom_criteria.keystring
The name of the custom_criteria key.
delivery.targeted_custom_criteria.match_typestring
The type of match that was performed (e.g. 'Broad', 'Exact', 'Prefix', etc.).
delivery.targeted_custom_criteria.patternstring
The pattern that the value from inventory.custom_criteria matched.
delivery.video_fallback_indexint
The index of this video fallback creative, or null.
delivery.yield_group_idsint
The IDs of the yield groups that allowed this source of demand to serve this ad.
delivery.yield_partner_idint
The company ID that filled this ad. Joins to am360_match_company.company_id.
event_time_usectimestamp
The timestamp of the specific event.
inventorystruct
A group of fields describing the inventory properties from the ad query.
inventory.ad_unit_idint
The ID of the ad unit (aka inventory unit) where the ad will display. Joins to am360_match_ad_unit.ad_unit_id.
inventory.ad_unit_pathint
The path to the ad unit. Ad units are organized into a hierarchical tree, like 'root/sports/frontpage/top'. The first entry in this list is the root ad unit ID, unique to each publisher network, and the last entry is the leaf. Each entry joins to am360_match_ad_unit.ad_unit_id.
inventory.ad_unit_sizesstring
The requested size(s) of the ad to display in this ad unit. May contain values like '320x250', 'Native', and 'Fluid'.
inventory.custom_criteriastruct
Repeated field containing free-form key values passed through the ad query. If a key is passed multiple times on the ad query, each will appear as its own custom_criteria entry.
inventory.custom_criteria.keystring
The key of this custom criteria, passed in on the ad query.
inventory.custom_criteria.valuestring
The value of this custom criteria value, passed in on the ad query.
inventory.devicestruct
A group of fields describing the device that made the ad query.
inventory.device_categorystring
The type of device, such as 'Smartphone' or 'Desktop'.
inventory.geostruct
A group of fields describing the geographical location where the ad query came from.
inventory.geo.countrystring
The name of the country where the ad query came from.
inventory.geo.languagestring
The language of the query.
inventory.geo.language_countrystring
The country of the language of the query. May be different from the country if, e.g., someone from Seville is visiting the US. Often null.
inventory.geo.regionstring
The name of the geographical region where the ad query came from.
inventory.is_companionbool
True if the query was for a companion to another ad on the page. Such events are not counted by Ad Manager Reports.
inventory.matched_audience_segment_idsint
The IDs of audience segments (aka user lists) visible to the publisher network that contain the user ID making the ad query.
inventory.placement_idint
The ID of the placement (a group of ad units). Joins to am360_match_placement.placement_id.
inventory.referer_urlstring
The sanitized URL of the page that issued the ad query; for web queries, this is approximately the URL of the page that requested the ad; for mobile ad queries, this is an arbitrary string that looks like a URL, but identifies the mobile app.
inventory.video_content_idint
The ID of the video content the ad is displaying against (defined by the publisher).
inventory.video_positionint
The position in the video where the ad will play. 1 is preroll, 3 is postroll, and 4+ are midrolls in consecutive order.
inventory.web_propertystring
The web property code associated with the ad request.
metadatastruct
A group of fields containing metadata about the event.
metadata.child_network_codestring
Identifies the Multiple Customer Management (MCM) child network who operates the property requesting the ad.
metadata.event_idstring
A unique ID for this event across all tables.
metadata.network_codestring
Identifies the publisher network that controls the inventory being filled by the ad query.
metadata.request_idstring
An identifier shared by all events related to a request to fill a single ad block (aka ad slot). Shared among all queries and later events related to a Single Request Architecture (SRA) or Video Pod request.
request_time_usectimestamp
The timestamp of the initial request to Google that became the ad query.
user_idstring
Google-assigned ID of the browser that sent the ad event. Cannot be extracted.
user_ppidstring
Encoded Publisher Provided ID (PPID) from the ad query. Cannot be decoded. Cannot be extracted.

Ad Manager 360 impressions

am360_impressions
deliverystruct
A group of fields describing the ad delivered to fill the query.
delivery.advertiser_company_idint
The ID of the company associated with this order. Can also be found through the order metadata table. Reservation-only. Joins to am360_match_company.company_id.
delivery.auction_idstring
If an auction ran to fill the creative serve related to this event, the ID of the auction record. Joins to am360_auctions.metadata.event_id.
delivery.buyer_namestring
The name of the buyer network or third-party exchange that filled the ad.
delivery.classified_advertiser_namestring
The Google-classified advertiser name whose ad served.
delivery.creative_idint
The ID of the publisher's reservation creative that was served. Reservation-only
delivery.creative_serve_idstring
The ID of the served creative. If this event was a creative serve, will be equal to the event_id. Joins to am360_creative_serves.metadata.event_id.
delivery.creative_size_deliveredstring
The size of the creative that was served.
delivery.deal_idstring
The ID of the direct deal used when choosing this ad.
delivery.deal_typestring
The type of direct deal (e.g. 'Programmatic guaranteed', 'Preferred deal', 'Private auction', etc.).
delivery.demand_channelstring
The demand channel that filled the ad request (e.g. 'Ad Server', 'Open Auction', etc.)
delivery.estimated_revenuedouble
An estimate of the revenue this event will cause the publisher to receive, in the publisher network's default currency. These are whole currency units, not CPM.
delivery.line_item_idint
The line item that allowed this ad to serve. Joins to am360_match_line_item.line_item_id.
delivery.optimization_typestring
The type of optimization applied when choosing this creative (i.e. 'Optimized competition', 'Target CPM', 'First Look'). May be null
delivery.order_idint
The order (aka campaign) that contains the line item. Joins to am360_match_order.order_id.
delivery.query_idstring
The ID of the originating query record in the queries table. Joins to am360_queries.metadata.event_id.
delivery.targeted_audience_segment_idsint
Audience segment (aka user list) IDs used when targeting this creative at the user, both positive and negative matches.
delivery.targeted_custom_criteriastruct
A repeated field describing how the custom_criteria from the inventory was used in targeting this creative.
delivery.targeted_custom_criteria.is_negative_matchbool
Whether this key/value was negatively matched by line item targeting.
delivery.targeted_custom_criteria.keystring
The name of the custom_criteria key.
delivery.targeted_custom_criteria.match_typestring
The type of match that was performed (e.g. 'Broad', 'Exact', 'Prefix', etc.).
delivery.targeted_custom_criteria.patternstring
The pattern that the value from inventory.custom_criteria matched.
delivery.video_fallback_indexint
The index of this video fallback creative, or null.
delivery.yield_group_idsint
The IDs of the yield groups that allowed this source of demand to fill this ad.
delivery.yield_partner_idint
The company ID that filled this ad. Joins to am360_match_company.company_id.
event_time_usectimestamp
The timestamp of the specific event.
inventorystruct
A group of fields describing the inventory properties from the ad query.
inventory.ad_unit_idint
The ID of the ad unit (aka inventory unit) where the ad will display. Joins to am360_match_ad_unit.ad_unit_id.
inventory.ad_unit_pathint
The path to the ad unit. Ad units are organized into a hierarchical tree, like 'root/sports/frontpage/top'. The first entry in this list is the root ad unit ID, unique to each publisher network, and the last entry is the leaf. Each entry joins to am360_match_ad_unit.ad_unit_id.
inventory.ad_unit_sizesstring
The requested size(s) of the ad to display in this ad unit. May contain values like '320x250', 'Native', and 'Fluid'.
inventory.custom_criteriastruct
Repeated field containing free-form key values passed through the ad query. If a key is passed multiple times on the ad query, each will appear as its own custom_criteria entry.
inventory.custom_criteria.keystring
The key of this custom criteria, passed in on the ad query.
inventory.custom_criteria.valuestring
The value of this custom criteria value, passed in on the ad query.
inventory.devicestruct
A group of fields describing the device that made the ad query.
inventory.device_categorystring
The type of device, such as 'Smartphone' or 'Desktop'.
inventory.geostruct
A group of fields describing the geographical location where the ad query came from.
inventory.geo.countrystring
The name of the country where the ad query came from.
inventory.geo.languagestring
The language of the query.
inventory.geo.language_countrystring
The country of the language of the query. May be different from the country if, e.g., someone from Seville is visiting the US. Often null.
inventory.geo.regionstring
The name of the geographical region where the ad query came from.
inventory.is_companionbool
True if the query was for a companion to another ad on the page. Such events are not counted by Ad Manager Reports.
inventory.matched_audience_segment_idsint
The IDs of audience segments (aka user lists) visible to the publisher network that contain the user ID making the ad query.
inventory.placement_idint
The ID of the placement (a group of ad units). Joins to am360_match_placement.placement_id.
inventory.referer_urlstring
The sanitized URL of the page that issued the ad query; for web queries, this is approximately the URL of the page that requested the ad; for mobile ad queries, this is an arbitrary string that looks like a URL, but identifies the mobile app.
inventory.video_content_idint
The ID of the video content the ad is displaying against (defined by the publisher).
inventory.video_positionint
The position in the video where the ad will play. 1 is preroll, 3 is postroll, and 4+ are midrolls in consecutive order.
inventory.web_propertystring
The web property code associated with the ad request.
metadatastruct
A group of fields containing metadata about the event.
metadata.child_network_codestring
Identifies the Multiple Customer Management (MCM) child network who operates the property requesting the ad.
metadata.event_idstring
A unique ID for this event across all tables.
metadata.network_codestring
Identifies the publisher network that controls the inventory being filled by the ad query.
metadata.request_idstring
An identifier shared by all events related to a request to fill a single ad block (aka ad slot). Shared among all queries and later events related to a Single Request Architecture (SRA) or Video Pod request.
request_time_usectimestamp
The timestamp of the initial request to Google that became the ad query.
user_idstring
Google-assigned ID of the browser that sent the ad event. Cannot be extracted.
user_ppidstring
Encoded Publisher Provided ID (PPID) from the ad query. Cannot be decoded. Cannot be extracted.

Ad Manager 360 interactions

am360_interactions
action_countint
The number of actions the user made. Always 1 for clicks.
action_duration_secdouble
The duration of those actions. Always 1.0 for clicks.
action_typestring
The type of action (one of 'Click', 'Standard', or 'Custom').
deliverystruct
A group of fields describing the ad delivered to fill the query.
delivery.advertiser_company_idint
The ID of the company associated with this order. Can also be found through the order metadata table. Reservation-only. Joins to am360_match_company.company_id.
delivery.auction_idstring
If an auction ran to fill the creative serve related to this event, the ID of the auction record. Joins to am360_auctions.metadata.event_id.
delivery.buyer_namestring
The name of the buyer network or third-party exchange that filled the ad.
delivery.classified_advertiser_namestring
The Google-classified advertiser name whose ad served.
delivery.creative_idint
The ID of the publisher's reservation creative that was served. Reservation-only
delivery.creative_serve_idstring
The ID of the served creative. If this event was a creative serve, will be equal to the event_id. Joins to am360_creative_serves.metadata.event_id.
delivery.creative_size_deliveredstring
The size of the creative that was served.
delivery.deal_idstring
The ID of the direct deal used when choosing this ad.
delivery.deal_typestring
The type of direct deal (e.g. 'Programmatic guaranteed', 'Preferred deal', 'Private auction', etc.).
delivery.demand_channelstring
The demand channel that filled the ad request (e.g. 'Ad Server', 'Open Auction., etc.)
delivery.estimated_revenuedouble
An estimate of the revenue this event will cause the publisher to receive, in the publisher network's default currency. These are whole currency units, not CPM.
delivery.line_item_idint
The line item that allowed this ad to serve. Joins to am360_match_line_item.line_item_id.
delivery.optimization_typestring
The type of optimization applied when choosing this creative (i.e. 'Optimized competition', 'Target CPM', 'First Look'). May be null
delivery.order_idint
The order (aka campaign) that contains the line item. Joins to am360_match_order.order_id.
delivery.query_idstring
The ID of the originating query record in the queries table. Joins to am360_queries.metadata.event_id.
delivery.targeted_audience_segment_idsint
Audience segment (aka user list) IDs used when targeting this creative at the user, both positive and negative matches.
delivery.targeted_custom_criteriastruct
A repeated field describing how the custom_criteria from the inventory was used in targeting this creative.
delivery.targeted_custom_criteria.is_negative_matchbool
Whether this key/value was negatively matched by line item targeting.
delivery.targeted_custom_criteria.keystring
The name of the custom_criteria key.
delivery.targeted_custom_criteria.match_typestring
The type of match that was performed (e.g. 'Broad', 'Exact', 'Prefix', etc.).
delivery.targeted_custom_criteria.patternstring
The pattern that the value from inventory.custom_criteria matched.
delivery.video_fallback_indexint
The index of this video fallback creative, or null.
delivery.yield_group_idsint
The IDs of the yield groups that allowed this source of demand to fill this ad.
delivery.yield_partner_idint
The company ID that filled this ad. Joins to am360_match_company.company_id.
event_time_usectimestamp
The timestamp of the specific event.
inventorystruct
A group of fields describing the inventory properties from the ad query.
inventory.ad_unit_idint
The ID of the ad unit (aka inventory unit) where the ad will display. Joins to am360_match_ad_unit.ad_unit_id.
inventory.ad_unit_pathint
The path to the ad unit. Ad units are organized into a hierarchical tree, like 'root/sports/frontpage/top'. The first entry in this list is the root ad unit ID, unique to each publisher network, and the last entry is the leaf. Each entry joins to am360_match_ad_unit.ad_unit_id.
inventory.ad_unit_sizesstring
The requested size(s) of the ad to display in this ad unit. May contain values like '320x250', 'Native', and 'Fluid'.
inventory.custom_criteriastruct
Repeated field containing free-form key values passed through the ad query. If a key is passed multiple times on the ad query, each will appear as its own custom_criteria entry.
inventory.custom_criteria.keystring
The key of this custom criteria, passed in on the ad query.
inventory.custom_criteria.valuestring
The value of this custom criteria value, passed in on the ad query.
inventory.devicestruct
A group of fields describing the device that made the ad query.
inventory.device_categorystring
The type of device, such as 'Smartphone' or 'Desktop'.
inventory.geostruct
A group of fields describing the geographical location where the ad query came from.
inventory.geo.countrystring
The name of the country where the ad query came from.
inventory.geo.languagestring
The language of the query.
inventory.geo.language_countrystring
The country of the language of the query. May be different from the country if, e.g., someone from Seville is visiting the US. Often null.
inventory.geo.regionstring
The name of the geographical region where the ad query came from.
inventory.is_companionbool
True if the query was for a companion to another ad on the page. Such events are not counted by Ad Manager Reports.
inventory.matched_audience_segment_idsint
The IDs of audience segments (aka user lists) visible to the publisher network that contain the user ID making the ad query.
inventory.placement_idint
The ID of the placement (a group of ad units). Joins to am360_match_placement.placement_id.
inventory.referer_urlstring
The sanitized URL of the page that issued the ad query; for web queries, this is approximately the URL of the page that requested the ad; for mobile ad queries, this is an arbitrary string that looks like a URL, but identifies the mobile app.
inventory.video_content_idint
The ID of the video content the ad is displaying against (defined by the publisher).
inventory.video_positionint
The position in the video where the ad will play. 1 is preroll, 3 is postroll, and 4+ are midrolls in consecutive order.
inventory.web_propertystring
The web property code associated with the ad request.
metadatastruct
A group of fields containing metadata about the event.
metadata.child_network_codestring
Identifies the Multiple Customer Management (MCM) child network who operates the property requesting the ad.
metadata.event_idstring
A unique ID for this event across all tables.
metadata.network_codestring
Identifies the publisher network that controls the inventory being filled by the ad query.
metadata.request_idstring
An identifier shared by all events related to a request to fill a single ad block (aka ad slot). Shared among all queries and later events related to a Single Request Architecture (SRA) or Video Pod request.
request_time_usectimestamp
The timestamp of the initial request to Google that became the ad query.
user_idstring
Google-assigned ID of the browser that sent the ad event. Cannot be extracted.
user_ppidstring
Encoded Publisher Provided ID (PPID) from the ad query. Cannot be decoded. Cannot be extracted.

Ad Manager 360 match activity

am360_match_activity
activity_group_clicks_lookback_daysint
The lookback number of days to track click-through conversions for all activities in the activity group that this activity belongs to.
activity_group_company_idsint
The company IDs whose ads will be included for conversion tracking on the activities in the activity group that this activity belongs to. Joins to am360_match_company.company_id.
activity_group_display_namestring
Human-readable display name of the activity group that this activity belongs to.
activity_group_idint
Unique ID that represents the group of activities that this activity belongs to.
activity_group_impressions_lookback_daysint
The lookback number of days to track view-through conversions for all activities in the activity group that this activity belongs to.
activity_idint
Unique ID that represents this activity.
activity_typestring
Human-readable string representing the type of activity this activity tracks. Can be one of 'Unspecified', 'Android Application Downloads', 'Custom', 'Daily Visits', 'iOS Application Downloads', 'Items Purchased', 'Page Views', or 'Transactions'.
display_namestring
Human-readable display name.
expected_urlstring
The URL of the webpage where the tags from this activity will be placed.

Ad Manager 360 match ad unit

am360_match_ad_unit
ad_unit_codestring
Publisher-defined or generated string used to identify this ad unit.
parent_ad_unit_code_hierarchystring
Path of ad unit codes leading to this ad unit. The first code in the list is the root, and the last is equal to ad_unit_code.
ad_unit_idint
Unique ID that represents this ad unit.
display_namestring
Human-readable display name.
external_set_top_box_channel_idstring
The set top box video on demand channel this ad unit corresponds to in an external set top box ad campaign system.
is_fluidbool
True if this ad unit supports fluid ads.
is_interstitialbool
True if this ad unit supports interstitial ads.
is_nativebool
True if this ad unit supports native ads.
parent_ad_unit_idint
ID of the ad unit one above this ad unit in the hierarchy. Joins to am360_match_ad_unit.ad_unit_id.

Ad Manager 360 match company

am360_match_company
company_idint
Unique ID that represents this company.
display_namestring
Human-readable name of the company.

Ad Manager 360 match line item

am360_match_line_item
cost_per_unitdouble
The cost per delivered unit of this line item, in the publisher network's default currency.
cost_typestring
The method used for billing this LineItem. One of 'CPA', 'CPC', 'CPD', 'CPM', 'CPMAV', or 'CPM_IN_TARGET'
create_timetimestamp
The date and time that the line item was created.
display_namestring
Human-readable display name.
end_timetimestamp
The date and time when the line item will stop serving.
external_deal_idstring
The external ID shared between the publisher and a buyer for the deal associated with this line item. Only populated for programmatic line items and only when the deal has been finalized.
external_idstring
A value set by the publisher that has meaning in external systems.
line_item_idint
Unique ID that represents this line item.
missing_creativesbool
True if this line item is missing at least one expected creative specified during setup.
order_idint
Order (aka campaign) this line item belongs to. Joins to am360_match_order.order_id.
priorityint
The priority for the line item. See https://developers.google.com/ad-manager/api/reference/latest/ForecastService.LineItem#priority.
start_timetimestamp
The date and time when the line item is set to begin serving.

Ad Manager 360 match order

am360_match_order
advertiser_company_idint
The advertiser which is associated with this order. Joins to am360_match_company.company_id.
agency_idint
The agency which is associated with this order. Joins to company.company_id.
display_namestring
Human-readable display name.
end_time_usectimestamp
The date and time when the order will stop delivering.
external_order_idstring
A value set by the publisher that has meaning in external systems.
is_programmaticbool
Specifies whether or not the order is a programmatic order.
order_idint
Unique ID that represents this order.
po_numberstring
A value set by the publisher meant to hold the purchase order number for this order.
start_time_usectimestamp
The date and time when the order is set to begin delivering.

Ad Manager 360 match placement

am360_match_placement
ad_unit_idsint
Collection of ad unit IDs that make up this placement. Joins to am360_match_ad_unit.ad_unit_id.
display_namestring
Human-readable display name.
placement_codestring
Publisher-defined or generated string used to identify this placement.
placement_idint
Unique ID that represents this placement.

Ad Manager 360 queries

am360_queries
auction_idstring
The ID of the auction that ran for this specific query. Not available on all queries. In some cases, this may point to a non-existent auction. Joins to am360_auctions.metadata.event_id.
event_time_usectimestamp
The timestamp of the specific event.
inventorystruct
A group of fields describing the inventory properties from the ad query.
inventory.ad_unit_idint
The ID of the ad unit (aka inventory unit) where the ad will display. Joins to am360_match_ad_unit.ad_unit_id.
inventory.ad_unit_pathint
The path to the ad unit. Ad units are organized into a hierarchical tree, like 'root/sports/frontpage/top'. The first entry in this list is the root ad unit ID, unique to each publisher network, and the last entry is the leaf. Each entry joins to am360_match_ad_unit.ad_unit_id.
inventory.ad_unit_sizesstring
The requested size(s) of the ad to display in this ad unit. May contain values like '320x250', 'Native', and 'Fluid'.
inventory.custom_criteriastruct
Repeated field containing free-form key values passed through the ad query. If a key is passed multiple times on the ad query, each will appear as its own custom_criteria entry.
inventory.custom_criteria.keystring
The key of this custom criteria, passed in on the ad query.
inventory.custom_criteria.valuestring
The value of this custom criteria value, passed in on the ad query.
inventory.devicestruct
A group of fields describing the device that made the ad query.
inventory.device_categorystring
The type of device, such as 'Smartphone' or 'Desktop'.
inventory.geostruct
A group of fields describing the geographical location where the ad query came from.
inventory.geo.countrystring
The name of the country where the ad query came from.
inventory.geo.languagestring
The language of the query.
inventory.geo.language_countrystring
The country of the language of the query. May be different from the country if, e.g., someone from Seville is visiting the US. Often null.
inventory.geo.regionstring
The name of the geographical region where the ad query came from.
inventory.is_companionbool
True if the query was for a companion to another ad on the page. Such events are not counted by Ad Manager Reports.
inventory.matched_audience_segment_idsint
The IDs of audience segments (aka user lists) visible to the publisher network that contain the user ID making the ad query.
inventory.placement_idint
The ID of the placement (a group of ad units). Joins to am360_match_placement.placement_id.
inventory.referer_urlstring
The sanitized URL of the page that issued the ad query; for web queries, this is approximately the URL of the page that requested the ad; for mobile ad queries, this is an arbitrary string that looks like a URL, but identifies the mobile app.
inventory.video_content_idint
The ID of the video content the ad is displaying against.
inventory.video_positionint
The position in the video where the ad will play. 1 is preroll, 3 is postroll, and 4+ are midrolls in consecutive order.
inventory.web_propertystring
The web property code associated with the ad request.
is_filledbool
True if query is associated with any rows in the am360_creative_serves table.
is_video_backupbool
True if this query was for a video backup ad. Such queries are not counted by Ad Manager Reports.
metadatastruct
A group of fields containing metadata about the event.
metadata.child_network_codestring
Identifies the Multiple Customer Management (MCM) child network who operates the property requesting the ad.
metadata.event_idstring
A unique ID for this event across all tables. May be referenced by fields in other tables.
metadata.network_codestring
Identifies the publisher network that controls the inventory being filled by the ad query.
metadata.request_idstring
An identifier shared by all events related to a request to fill a single ad block (aka ad slot). Shared among all queries and later events related to a Single Request Architecture (SRA) or Video Pod request.
request_time_usectimestamp
The timestamp of the initial request to Google that became the ad query.
user_idstring
Google-assigned ID of the browser that sent the ad event. Cannot be extracted.
user_ppidstring
Encoded Publisher Provided ID (PPID) from the ad query. Cannot be decoded. Cannot be extracted.

Browser

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

City

city
city_idint
Unique ID of the city.
city_namestring
City name.
country_codestring
Two character country code.
metro_codestring
Metropolitan area code.

DV360 YouTube Active View

dv360_youtube_active_views
impression_data.adgroup_idint
ID of the Display & Video 360 YouTube ad group. Used as a join key in any adh.dv360_youtube_* table.
impression_data.advertiser_idint
Unique ID of the advertiser.
impression_data.campaign_idint
Unique ID of the campaign.
impression_data.creative_idint
Unique ID of the creative.
impression_data.insertion_order_idint
The Display & Video 360 numerical ID for the insertion order related to the event, e.g. 1079941.
impression_data.line_item_idint
The Display & Video 360 numerical ID for the line item related to the event, e.g. 1155785.
impression_data.partner_idint
Unique ID of the partner.
impression_idstring
Unique ID of the impression.
num_active_view_viewable_impressionint
1 = impression is active view eligible, 0 = impression isn't active view eligible.
query_idstruct
Unique identifier for query has multiple parts.
query_id.process_idint
Integer that identifies the process on the machine that generated the event.
query_id.server_ipint
The IPv4 address of the server that managed the ad request. Used to identify unique events for joins.
query_id.time_usecint
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
view_idstruct
Unique ID for view has multiple parts.
view_id.process_idint
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
view_id.server_ipint
The IPv4 address of the server that generated this event.
view_id.time_usecint
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.

DV360 YouTube ad group

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

DV360 YouTube advertiser

dv360_youtube_advertiser
advertiser_idint
Unique ID of the advertiser.
advertiser_namestring
Name of the advertiser.
advertiser_timezonestring
The DV360 advertiser time zone default set in account settings.
partner_idint
Unique ID of the partner.

DV360 YouTube campaign

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

DV360 YouTube clicks

dv360_youtube_clicks
click_idstruct
Unique identifier for click has multiple parts. Joins with click_id in any adh.dv360_youtube table.
click_id.process_idint
Integer that identifies the process on the machine that generated the event.
click_id.server_ipint
The IPv4 address of the server that generated this event.
click_id.time_usecint
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
click_typeint
The click type.
impression_data.adgroup_idint
ID of DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table.
impression_data.advertiser_idint
Unique ID of the advertiser.
impression_data.campaign_idint
Unique ID of the campaign.
impression_data.creative_idint
Joins with creative_id in any adh.dv360_youtube table.
impression_data.insertion_order_idint
Unique ID of the insertion order.
impression_data.line_item_idint
Unique ID of the line item.
impression_data.partner_idint
Unique ID of the partner.
impression_idstring
Unique identifier for impression.
query_idstruct
Unique identifier for query has multiple parts. Joins with query_id in any adh.dv360_youtube table.
query_id.process_idint
Integer that identifies the process on the machine that generated the event.
query_id.server_ipint
The IPv4 address of the server that generated this event.
query_id.time_usecint
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
user_idopaque
User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

DV360 YouTube conversions

dv360_youtube_conversions
click_idstruct
Unique identifier for click has multiple parts. Joins with click_id in any adh.dv360_youtube table.
click_id.process_idint
Integer that identifies the process on the machine that generated the event.
click_id.server_ipint
The IPv4 address of the server that generated this event.
click_id.time_usecint
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
conversion_idstruct
Unique identifier for conversion has multiple parts.
conversion_id.process_idint
Integer that identifies the process on the machine that generated the event.
conversion_id.server_ipint
The IPv4 address of the server that generated this event.
conversion_id.time_usecint
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
conversion_typeint
The type of conversion.
impression_data.adgroup_idint
ID of DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table.
impression_data.advertiser_idint
Unique ID of the advertiser.
impression_data.campaign_idint
Unique ID of the campaign.
impression_data.creative_idint
Joins with creative_id in any adh.dv360_youtube table.
impression_data.insertion_order_idint
Unique ID of the insertion order.
impression_data.line_item_idint
Unique ID of the line item.
impression_data.partner_idint
Unique ID of the partner.
impression_idstring
Unique identifier for impression.
labelstring
Name of conversion event.
query_idstruct
Unique identifier for query has multiple parts. Joins with query_id in any adh.dv360_youtube table.
query_id.process_idint
Integer that identifies the process on the machine that generated the event.
query_id.server_ipint
The IPv4 address of the server that generated this event.
query_id.time_usecint
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
user_idopaque
User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

DV360 YouTube creative

dv360_youtube_creative
adgroup_idint
ID of DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table.
advertiser_idint
Multiple Display & Video 360 "advertisers" generally exist underneath a single partner. Vendor client IDs are saved here.
campaign_idint
Group of insertion Orders. Default targeting settings & cross-campaign frequency caps.
creative_idint
Vendor client IDs are saved here.
creative_namestring
The name of the Display & Video 360 creative.
creative_typeint
Enum corresponding to the creative type.
insertion_order_idint
Group of line item IDs. Frequency caps, pacing settings, partner costs, and default targeting criteria for line items.
is_mastheadboolean
True if this is a masthead creative.
line_item_idint
Line items consist of a budget, a bid, and targeting. For YouTube buys, line items are identical to Campaigns in Google Ads. ADH linking happens here. Reporting IDs are saved here.
partner_idint
Represents agencies, trading desks, or large individual advertisers.
third_party_vast_urlstring
URL used for VAST (Video Ad Serving Template) redirect creatives. Formatting doesn't match yt_reserve_creative.third_party_vast_url.
video_messagestruct
Multipart identifier for video data.
video_message.video_ad_durationint
Duration of the video in milliseconds.
video_message.youtube_video_idstring
Video ID string representation as it appears on YouTube watch url.

DV360 YouTube creative conversions

dv360_youtube_creative_conversions
click_idstruct
Unique identifier for click has multiple parts. Joins with click_id in any adh.dv360_youtube table.
click_id.process_idint
Integer that identifies the process on the machine that generated the event.
click_id.server_ipint
The IPv4 address of the server that generated this event.
click_id.time_usecint
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
conversion_idstruct
Unique identifier for conversion has multiple parts.
conversion_id.process_idint
Integer that identifies the process on the machine that generated the event.
conversion_id.server_ipint
The IPv4 address of the server that generated this event.
conversion_id.time_usecint
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
conversion_typeint
The type of conversion.
impression_data.adgroup_idint
ID of the DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table.
impression_data.advertiser_idint
Unique ID of the advertiser.
impression_data.campaign_idint
Unique ID of the campaign.
impression_data.creative_idint
Joins with creative_id in any adh.dv360_youtube table.
impression_data.insertion_order_idint
Unique ID of the insertion order.
impression_data.line_item_idint
Unique ID of the line item.
impression_data.partner_idint
Unique ID of the partner.
impression_idstring
Unique identifier for impression.
labelstring
Name of conversion event.
query_idstruct
Unique identifier for query has multiple parts. Joins with query_id in any adh.dv360_youtube table.
query_id.process_idint
Integer that identifies the process on the machine that generated the event.
query_id.server_ipint
The IPv4 address of the server that generated this event.
query_id.time_usecint
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
user_idopaque
User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

DV360 YouTube impressions

dv360_youtube_impressions
adgroup_idint
ID of DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table.
advertiser_idint
Unique ID of the advertiser.
browserstring
Possible values are: "Chrome", "Cobalt", "Dalvik", "Edge", "Firefox", "IE", "Opera", "Other", "Safari", "Samsung Browser", "Roku", "Silk", "Unknown", "Yandex"
campaign_idint
Unique ID of the campaign.
content_urlstring
URL of the page on which ad appeared. Part of the url is removed for privacy.
device_heightint
Device height in px.
device_widthint
Device width in px.
impression_idstring
Unique identifier for impression.
insertion_order_idint
Unique ID of the insertion order.
inventory_typeenum
The inventory type. Possible values: YOUTUBE, YOUTUBE TV, YOUTUBE_MUSIC, SEARCH, GMAIL, OTHER. Other refers to either the Google Display or Video network.
is_app_trafficboolean
true if the event happened in a native app.
line_item_idint
Unique ID of the line item.
locationstruct
Unique identifier for location has multiple parts
location.countrystring
location.geo_city_idint
Code for city. Joins with city_id in adh.city table.
location.geo_metroint
Code for metro region. Joins with metro_id in adh.metro table.
location.geo_regionstring
Region as string e.g. US-CA.
mobile_browser_classint
Type of browser. Possible values are: desktop, tablet, smart tv consoles, or mobile. Joins with mobile_browser_class_id in adh.mobile_browser table.
num_active_view_eligible_impressionint
1 when impression is active view eligible; 0 when impression is not active view eligible.
num_active_view_measurable_impressionint
1 when impression is active view measurable; 0 when impression is not active view measurable.
operating_systemstring
Possible values are: "Android", "AppleTV", "Chrome OS", "Fire OS", "Google TV", "iOS", "Linux", "Mac", "Unknown", "PlayStation", "Roku", "Tizen", "Xbox", "Windows", "Windows Phone"
partner_idint
Unique ID of the partner.
physical_screen_heightint
Device screen height in mm.
physical_screen_widthint
Device screen width in mm.
publisher_domainstring
Domain of the page on which ad appeared.
query_idstruct
Unique identifier for query has multiple parts. Joins with query_id in any adh.dv360_youtube table.
query_id.process_idint
The processing ID.
query_id.server_ipint
The IPv4 address of the server that generated this event.
query_id.time_usecint
The query time in microseconds.
query_languagestring
Language used by user.
user_idopaque
User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

DV360 YouTube insertion order

dv360_youtube_insertion_order
advertiser_idint
Unique ID of the advertiser.
campaign_idint
Unique ID of the campaign.
insertion_order_idint
Unique ID of the insertion order.
insertion_order_namestring
Name of the insertion order.
partner_idint
Unique ID of the partner.

DV360 YouTube line item

dv360_youtube_lineitem
advertiser_idint
Unique ID of the advertiser.
campaign_idint
The Display & Video 360 numerical ID for the campaign related to the event, e.g. 164332.
insertion_order_idint
The Display & Video 360 numerical ID for the insertion order related to the event, e.g. 1079941.
line_item_end_timeint
Unix timestamp in microseconds (1/1,000,000 second) for when the line item ended, e.g. 1330403779608570
line_item_idint
The Display & Video 360 numerical ID for the line item related to the event, e.g. 1155785.
line_item_namestring
The Display & Video 360 name for the line item related to the event, e.g. 164332.
line_item_reservation_typeenum
Reservation type for a Display & Video 360 line item. Can be one of "Programmatic", "InstantReserve", or "None" (meaning standard auction).
line_item_start_timeint
Unix timestamp in microseconds (1/1,000,000 second) for when the line item started, e.g. 1330403779608570
line_item_statusint
Integer indicating the status of the line item. 3 = ACTIVE. 5 = PAUSED. 7 = DELETED.
partner_idint
Unique ID of the partner.

DV360 YouTube vendor reporting metadata

dv360_youtube_vendor_reporting_data
line_item_idint
Unique ID of the line item.
vendor_client_idstring
All lower-case formatted vendor client id (VCID).
reporting_idstring
Customer-provided identifier to slice their data by.
vendor_metricstring
Measurement type.

Freewheel Active Views

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

Freewheel clicks

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

Freewheel creative pixels

freewheel_creative_pixels
ad_idstring
Vast Ad ID.
pixel_urlstring
pixel URL.

Freewheel impressions

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

Freewheel pixel

freewheel_pixel
pixel_urlstring
The pixel URL.
google_ads_active_views
impression_data.ad_group_creative_idint
ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table.
impression_data.adgroup_idint
ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table.
impression_data.campaign_idint
Unique ID of the campaign.
impression_data.customer_idint
ID of Google Ads customer. Joins with customer_id in any adh.google_ads table.
impression_idstring
Unique identifier for impression.
num_active_view_viewable_impressionint
1 when impression is active view eligible; 0 when impression is not active view eligible.
query_idstruct
Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
query_id.process_idint
The processing ID.
query_id.server_ipint
The IPv4 address of the server that generated this event.
query_id.time_usecint
The query time in microseconds.
view_idstruct
Unique identifier for view_id has multiple parts.
view_id.process_idint
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
view_id.server_ipint
The IPv4 address of the server that generated this event.
view_id.time_usecint
Integer that identifies the process on the machine that generated the event.
google_ads_adgroup
adgroup_idint
ID of Google Ads ad group. Used as a join key in adh.google_ads table.
adgroup_namestring
Name of the ad group in Google Ads.
adgroup_statusstring
The ad group. Possible values are: "status", "paused", or "enabled".
adgroup_typestring
The ad group type. Possible values are: "VIDEO_TRUE_VIEW_IN_STREAM", "VIDEO_OUTSTREAM", "VIDEO_TRUE_VIEW_IN_DISPLAY", "VIDEO_BUMPER_IN_STREAM", "VIDEO_NON_SKIPPABLE_IN_STREAM", "DISPLAY", "SEARCH", "YOUTUBE_AUDIO", or "OTHER".
campaign_idint
Unique ID of the campaign.
customer_idint
Google Ads account ID. Joins with customer_id in any adh.google_ads table.
label_idsarray<int64>
Label IDs. Joins with label_id in the adh.google_ads_label table.
google_ads_adgroupcreative
ad_group_creative_idINT64
ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table.
adgroup_creative_statusSTRING
The status of the creative within the ad group.
adgroup_idINT64
ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table.
creative_idINT64
A unique identifier for the creative, specific to the ad group containing it. Joins with creative_id in any adh.google_ads table.
customer_idINT64
Google Ads account ID. Joins with customer_id in any adh.google_ads table.
label_idsarray<int64>
Label IDs. Joins with label_id in the adh.google_ads_label table.
google_ads_campaign
advertising_channel_typestring
The primary serving target for ads within the campaign. It can be set only when a campaign is newly created in Google Ads. Possible values are: "SEARCH", "DISPLAY", "VIDEO", or "OTHER".
campaign_idint
Unique ID of the campaign.
campaign_namestring
Campaign name.
campaign_statusint
Campaign status. 3 = ACTIVE. 5 = PAUSED. 7 = DELETED.
customer_idint
Joins with customer_id in any adh.google_ads table.
end_timeint
Timestamp when the campaign ends in milliseconds.
label_idsarray<int64>
Label IDs. Joins with label_id in the adh.google_ads_label table.
reservation_typeenum
The type of the reservation. Can be either "InstantReserve" or "None" (meaning standard auction).
start_timeint
Timestamp when the campaign begins in milliseconds.
google_ads_clicks
click_idstruct
Unique identifier for click has multiple parts. Joins with click_id in any adh.google_ads table.
click_id.process_idint
Integer that identifies the process on the machine that generated the event.
click_id.server_ipint
The IPv4 address of the server that generated this event.
click_id.time_usecint
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
click_typeint
The click type.
impression_data.ad_group_creative_idint
ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table.
impression_data.adgroup_idint
ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table.
impression_data.campaign_idint
Unique ID of the campaign.
impression_data.customer_idint
ID of Google Ads customer. Joins with customer_id in any adh.google_ads table.
impression_idstring
Unique identifier for impression.
query_idstruct
Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
query_id.process_idint
Integer that identifies the process on the machine that generated the event.
query_id.server_ipint
The IPv4 address of the server that generated this event.
query_id.time_usecint
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
user_idopaque
User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.
google_ads_clicks_audience
click_idstruct
Unique identifier for click has multiple parts. Joins with click_id in any adh.google_ads table.
click_id.process_idint
Integer that identifies the process on the machine that generated the event.
click_id.server_ipint
The IPv4 address of the server that generated this event.
click_id.time_usecint
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
click_typeint
The click type.
impression_idstring
Unique identifier for impression.
query_idstruct
Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
query_id.process_idint
Integer that identifies the process on the machine that generated the event.
query_id.server_ipint
The IPv4 address of the server that generated this event.
query_id.time_usecint
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
user_idopaque
User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.
google_ads_conversions
click_idstruct
Unique identifier for click has multiple parts. Joins with click_id in any adh.google_ads table.
click_id.process_idint
Integer that identifies the process on the machine that generated the event.
click_id.server_ipint
The IPv4 address of the server that generated this event.
click_id.time_usecint
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
conversion_idstruct
Unique identifier for conversion has multiple parts.
conversion_id.process_idint
Integer that identifies the process on the machine that generated the event.
conversion_id.server_ipint
The IPv4 address of the server that generated this event.
conversion_id.time_usecint
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
conversion_typeint
The type of conversion.
impression_data.ad_group_creative_idint
ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table.
impression_data.adgroup_idint
ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table.
impression_data.campaign_idint
Unique ID of the campaign.
impression_data.customer_idint
ID of Google Ads customer. Joins with customer_id in any adh.google_ads table.
impression_idstring
Unique identifier for impression.
labelstring
Name of conversion event.
query_idstruct
Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
query_id.process_idint
Integer that identifies the process on the machine that generated the event.
query_id.server_ipint
The IPv4 address of the server that generated this event.
query_id.time_usecint
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
user_idopaque
User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.
google_ads_conversions_audience
click_idstruct
Unique identifier for click has multiple parts. Joins with click_id in any adh.google_ads table.
click_id.process_idint
Integer that identifies the process on the machine that generated the event.
click_id.server_ipint
The IPv4 address of the server that generated this event.
click_id.time_usecint
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
conversion_idstruct
Unique identifier for conversion has multiple parts.
conversion_id.process_idint
Integer that identifies the process on the machine that generated the event.
conversion_id.server_ipint
The IPv4 address of the server that generated this event.
conversion_id.time_usecint
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
conversion_typeint
The type of conversion.
impression_idstring
Unique identifier for impression.
labelstring
Name of conversion event.
query_idstruct
Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
query_id.process_idint
Integer that identifies the process on the machine that generated the event.
query_id.server_ipint
The IPv4 address of the server that generated this event.
query_id.time_usecint
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
user_idopaque
User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.
google_ads_creative
creative_idint
Joins with creative_id in any adh.google_ads table.
creative_namestring
Creative name.
creative_typeint
Creative type.
customer_idint
Google Ads account ID. Joins with customer_id in any adh.google_ads table.
template_idint
Template ID of the creative.
third_party_urlint
The VAST tag URL string, as seen in Google products.
video_messagestruct
Multipart identifier for video data.
video_message.video_ad_durationint
Duration of the video in milliseconds.
video_message.youtube_video_idstring
Video id string representation as it appears on YouTube watch url.
google_ads_creative_conversions
click_idstruct
Unique identifier for click has multiple parts. Joins with click_id in any adh.google_ads table.
click_id.process_idint
Integer that identifies the process on the machine that generated the event.
click_id.server_ipint
The IPv4 address of the server that generated this event.
click_id.time_usecint
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
conversion_idstruct
Unique identifier for conversion has multiple parts.
conversion_id.process_idint
Integer that identifies the process on the machine that generated the event.
conversion_id.server_ipint
The IPv4 address of the server that generated this event.
conversion_id.time_usecint
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
conversion_typeint
The type of conversion.
impression_data.ad_group_creative_idint
ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table.
impression_data.adgroup_idint
ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table.
impression_data.campaign_idint
Unique ID of the campaign.
impression_data.customer_idint
ID of Google Ads customer. Joins with customer_id in any adh.google_ads table.
impression_idstring
Unique identifier for impression.
labelstring
Name of conversion event.
query_idstruct
Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
query_id.process_idint
Integer that identifies the process on the machine that generated the event.
query_id.server_ipint
The IPv4 address of the server that generated this event.
query_id.time_usecint
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
user_idopaque
User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.
google_ads_creative_vendor_metadata
creative_idint
The Creative ID in Campaign Manager 360 UI.
legacy_pixelstring
vendor_stringstring
google_ads_customer
customer_company_namestring
Company name.
customer_idint
Google Ads account ID. Joins with customer_id in any adh.google_ads table.
customer_namestring
Google Ads account name.
customer_timezonestring
Google Ads account setting for time zone.
external_customer_idint
Google Ads account ID.
mcc_idsarray
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
ad_group_creative_idint
ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table.
adgroup_idint
ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table.
browserstring
Possible values are: "Chrome", "Cobalt", "Dalvik", "Edge", "Firefox", "IE", "Opera", "Other", "Safari", "Samsung Browser", "Roku", "Silk", "Unknown", "Yandex"
campaign_idint
Unique ID of the campaign.
content_urlstring
URL of the page on which ad appeared. Part of the url is removed for privacy.
customer_idint
ID of Google Ads customer.Joins with customer_id in any adh.google_ads table.
device_heightint
Device height in px.
device_widthint
Device width in px.
impression_idstring
Unique identifier for impression.
inventory_typeenum
The inventory type. Possible values: YOUTUBE, YOUTUBE TV, YOUTUBE_MUSIC, SEARCH, GMAIL, OTHER. Other refers to either the Google Display or Video network.
is_app_trafficboolean
true if the event happened in a native app. FALSE if the event happened in HTML5 app or webview.
locationstruct
Unique identifier for location has multiple parts
location.countrystring
location.geo_city_idint
Code for city. Joins with city_id in adh.city table.
location.geo_metroint
Code for metro region. Joins with metro_id in adh.metro table.
location.geo_regionstring
Region as string e.g. US-CA.
mobile_browser_classint
Type of device. Possible values are: desktop, tablet, smart tv consoles, or mobile. Joins with mobile_browser_class_id in adh.mobile_browser_class table.
num_active_view_eligible_impressionint
1 when impression is active view eligible; 0 when impression is not active view eligible.
num_active_view_measurable_impressionint
1 when impression is active view measurable; 0 when impression is not active view measurable.
operating_systemstring
Possible values are: "Android", "AppleTV", "Chrome OS", "Fire OS", "Google TV", "iOS", "Linux", "Mac", "Unknown", "PlayStation", "Roku", "Tizen", "Xbox", "Windows", "Windows Phone"
operating_system_version_idsarray
(Deprecated) Use operating_system instead. ID of OS. Joins with operating_system_version_id in adh.os_version table.
physical_screen_heightint
Device screen height in mm.
physical_screen_widthint
Device screen width in mm.
publisher_domainstring
Domain of the page on which ad appeared.
query_idstruct
Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
query_id.process_idint
The processing ID.
query_id.server_ipint
The IPv4 address of the server that generated this event.
query_id.time_usecint
The query time in microseconds.
query_languagestring
Language used by user.
user_idopaque
User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.
google_ads_label
customer_idint
Joins with customer_id in any adh.google_ads table.
descriptionstring
Label description.
label_idint64
Label ID. Joins with label_ids in adh.google_ads tables that contain label_ids.
label_namestring
Label name.
statusint
Label status. 1 = ENABLED. 2 = DELETED.
google_ads_vendor_reporting_data
campaign_idint
Unique ID of the campaign.
reporting_idstring
Customer-provided identifier to slice their data by.
vendor_client_idstring
All lower-case formatted vendor client id (VCID).
vendor_metricstring
Measurement type.

Metro

metro
country_codestring
Two character country code.
metro_idint
Metro identifier.
metro_namestring
Metro name.

Mobile app info

mobile_app_info
app_idstring
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_namestring
The name of the app as it appears in the app store.
app_store_idint
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_namestring
The name of the app store.

Mobile browser class

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

Partner Sold - Cross Sell Active Views

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

Partner Sold - Cross Sell clicks

partner_sold_cross_sell_clicks
click_idstruct
Unique identifier for click has multiple parts. Joins with click_id.
click_id.process_idint
The processing ID.
click_id.server_ipint
The processing server.
click_id.time_usecint
The query time in microseconds.
click_typeint
The click type.
impression_idstring
Unique identifier for impression.
query_idstruct
Unique identifier for query has multiple parts. Joins with query_id.
query_id.process_idint
The processing ID.
query_id.server_ipint
The processing server.
query_id.time_usecint
The query time in microseconds.
user_idopaque
User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

Partner Sold - Cross Sell conversions

partner_sold_cross_sell_conversions
click_idstruct
Unique identifier for click has multiple parts. Joins with click_id.
click_id.process_idint
The processing ID.
click_id.server_ipint
The processing server.
click_id.time_usecint
The query time in microseconds.
conversion_idstruct
Unique identifier for conversion has multiple parts.
conversion_id.process_idint
The processing ID.
conversion_id.server_ipint
The processing server.
conversion_id.time_usecint
The query time in microseconds.
conversion_typeint
The conversion type.
impression_idstring
Unique identifier for impression.
labelstring
Name of conversion event.
query_idstruct
Unique identifier for query has multiple parts.
query_id.process_idint
The processing ID.
query_id.server_ipint
The processing server.
query_id.time_usecint
The query time in microseconds.
user_idopaque
User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

Partner Sold - Cross Sell creative

partner_sold_cross_sell_creative
creative_format_typestring
Some formats map directly to a type. Other types have multiple formats like: html, image, or video.
creative_idint
The ID of the creative.
creative_namestring
Name of the creative.
creative_typestring
The type of creative.
third_party_vast_urlstring
VAST url of the creative if the creative is a third party hosted video. Does not support creatives from programmatic items.
video_messagestruct
Multipart identifier for video data.
video_message.video_ad_durationint
Duration of the video in milliseconds.
video_message.youtube_video_idstring
Video id string representation as it appears on YouTube watch url.

Partner Sold - Cross Sell creative pixels

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

Partner Sold - Cross Sell impressions

partner_sold_cross_sell_impressions
browserstring
Possible values are: "Chrome", "Cobalt", "Dalvik", "Edge", "Firefox", "IE", "Opera", "Other", "Safari", "Samsung Browser", "Roku", "Silk", "Unknown", "Yandex"
content_urlstring
URL of the page on which ad appeared. Part of the url is removed for privacy.
creative_idint
Joins with creative_id in any adh.yt table.
device_heightint
Device height in pixels.
device_widthint
Device width in pixels.
gfp_placementsarray
Ad Manager placement ID for this impression. Does not represent Campaign Manager 360 placement.
impression_idstring
Unique identifier for impression.
inventory_typeenum
The inventory type. Possible values: YOUTUBE, YOUTUBE TV, SEARCH, GMAIL, OTHER. Other refers to either the Google Display or Video network.
line_item_idint
Line item id for this impression.
locationstruct
Unique identifier for location has multiple parts.
location.countrystring
Code for country.
location.geo_city_idint
Code for city. Joins with city_id in adh.city table.
location.geo_metroint
Code for metrio region. Joins with metro_id in adh.metro table.
location.geo_regionstring
Region as a string (e.g. US-CA)
mobile_browser_classint
Type of device. Possible values are: desktop, tablet, smart tv consoles, or mobile. Joins with mobile_browser_class_id in adh.mobile_browser_class table.
num_active_view_eligible_impressionint
1 when impression is active view eligible; 0 when impression is not active view eligible.
num_active_view_measurable_impressionint
1 when impression is active view measurable; 0 when impression is not active view measurable.
operating_systemstring
Possible values are: "Android", "AppleTV", "Chrome OS", "Fire OS", "Google TV", "iOS", "Linux", "Mac", "Unknown", "PlayStation", "Roku", "Tizen", "Xbox", "Windows", "Windows Phone"
order_idint
Order ID for the impression.
physical_screen_heightint
Device height in mm.
physical_screen_widthint
Device screen width in mm.
publisher_domainstring
Domain of page on which ad appeared.
query_idstruct
Unique identifier for query has multiple parts.
query_id.process_idint
The processing ID.
query_id.server_ipint
The processing server.
query_id.time_usecint
The query time in microseconds.
query_languagestring
Language used by user.
user_idopaque
User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

Partner Sold - Cross Sell line item

partner_sold_cross_sell_lineitem
end_timetimestamp
Time the line item stopped being served.
line_item_idint
Ad Manager line item serving.
line_item_namestring
Ad Manager line item name.
order_idint
Ad Manager Order identifier used for serving.
order_namestring
Name of the insertion order.
programmaticboolean
true if the line item was programmatic.
skippable_ad_typestring
Possible values are: "skippable", "not skippable", or "selectable".
start_timetimestamp
Time the line item started to be served.

Partner Sold - Cross Sell order

partner_sold_cross_sell_order
advertiser_idint
Unique ID of the advertiser.
advertiser_namestring
Publisher entered name.
advertiser_timezonestring
The Partner Sold time zone default in the Ad Manager network settings.
network_codeint
Ad Manager Publisher network code.
order_idint
Ad Manager Order identifier used for serving.
order_namestring
Name of Ad Manager order.

Partner Sold - Cross Sell vendor reporting data.

partner_sold_cross_sell_vendor_reporting_data
line_item_idint
Unique ID of the line item.
reporting_idstring
Customer-provided identifier to slice their data by.
vendor_client_idstring
All lower-case formatted vendor client id (VCID).
vendor_metricstring
Measurement type.

Region

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

YouTube Reserve Active Views

yt_reserve_active_views
impression_data.creative_idint
The ID of the creative.
impression_data.line_item_idint
Line item id for this impression.
impression_data.media_plan_idint
ID of the YouTube Reserve media plan.
impression_data.order_idint
impression_idstring
Unique identifier for impression.
num_active_view_viewable_impressionint
1 when impression is active view viewable; 0 when impression is not active view viewable.
query_idstruct
Unique identifier for query has multiple parts.
query_id.process_idint
Integer that identifies the process on the machine that generated the event.
query_id.server_ipint
The IPv4 address of the server that generated this event.
query_id.time_usecint
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
view_idstruct
Unique identifier for view has multiple parts.
view_id.process_idint
Integer that identifies the process on the machine that generated the event.
view_id.server_ipint
The IPv4 address of the server that generated this event.
view_id.time_usecint
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.

YouTube Reserve clicks

yt_reserve_clicks
click_idstruct
Unique identifier for click has multiple parts.
click_id.process_idint
Integer that identifies the process on the machine that generated the event.
click_id.server_ipint
The IPv4 address of the server that generated this event.
click_id.time_usecint
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
click_typeint
The click type.
impression_data.creative_idint
The ID of the creative.
impression_data.line_item_idint
Line item id for this impression.
impression_data.media_plan_idint
ID of the YouTube Reserve media plan.
impression_data.order_idint
impression_idstring
Unique identifier for impression.
query_idstruct
Unique identifier for query has multiple parts.
query_id.process_idint
Integer that identifies the process on the machine that generated the event.
query_id.server_ipint
The IPv4 address of the server that generated this event.
query_id.time_usecint
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
user_idopaque
User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

YouTube Reserve conversions

yt_reserve_conversions
click_idstruct
Unique identifier for click has multiple parts.
click_id.process_idint
Integer that identifies the process on the machine that generated the event.
click_id.server_ipint
The IPv4 address of the server that generated this event.
click_id.time_usecint
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
conversion_idstruct
Unique identifier for conversion has multiple parts.
conversion_id.process_idint
Integer that identifies the process on the machine that generated the event.
conversion_id.server_ipint
The IPv4 address of the server that generated this event.
conversion_id.time_usecint
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
conversion_typeint
The type of conversion.
impression_data.creative_idint
The ID of the creative.
impression_data.line_item_idint
Line item id for this impression.
impression_data.media_plan_idint
ID of the YouTube Reserve media plan.
impression_data.order_idint
impression_idstring
Unique identifier for impression.
labelstring
Name of conversion event.
query_idstruct
Unique identifier for query has multiple parts.
query_id.process_idint
Integer that identifies the process on the machine that generated the event.
query_id.server_ipint
The IPv4 address of the server that generated this event.
query_id.time_usecint
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
user_idopaque
User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

YouTube Reserve creative

yt_reserve_creative
creative_format_typestring
Some formats map directly to a type. Other types have multiple formats like: html, image, or video.
creative_idint
The ID of the creative.
creative_namestring
Name of the creative.
creative_typestring
The type of creative.
dcm_beaconsarray
Multipart identifier for Campaign Manager 360 tracking pixel for ad.
is_mastheadboolean
True if this is a masthead creative.
skippable_ad_typestring
Possible values are: "SKIPPABLE", "NOT_SKIPPABLE", "UNKNOWN", or "OTHER".
third_party_vast_urlstring
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_messagestruct
Multipart identifier for video data.
video_message.video_ad_durationint
Duration of the video in milliseconds.
video_message.youtube_channel_idstring
Id of the channel that provides this video.
video_message.youtube_video_idstring
Video id string representation as it appears on YouTube watch url.

YouTube Reserve creative conversions

yt_reserve_creative_conversions
click_idstruct
Unique identifier for click has multiple parts.
click_id.process_idint
Integer that identifies the process on the machine that generated the event.
click_id.server_ipint
The IPv4 address of the server that generated this event.
click_id.time_usecint
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
conversion_idstruct
Unique identifier for conversion has multiple parts.
conversion_id.process_idint
Integer that identifies the process on the machine that generated the event.
conversion_id.server_ipint
The IPv4 address of the server that generated this event.
conversion_id.time_usecint
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
conversion_typeint
The type of conversion.
impression_data.creative_idint
ID of the creative.
impression_data.line_item_idint
Line item ID for this impression.
impression_data.media_plan_idint
ID of the YouTube Reserve media plan.
impression_data.order_idint
ID of Display and Video 360 customer. Joins with customer_id in any adh.dv360 table.
labelstring
Name of conversion event.
query_idstruct
Unique identifier for query has multiple parts.
query_id.process_idint
Integer that identifies the process on the machine that generated the event.
query_id.server_ipint
The IPv4 address of the server that generated this event.
query_id.time_usecint
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
user_idopaque
User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

YouTube Reserve impressions

yt_reserve_impressions
browserstring
Possible values are: "Chrome", "Cobalt", "Dalvik", "Edge", "Firefox", "IE", "Opera", "Other", "Safari", "Samsung Browser", "Roku", "Silk", "Unknown", "Yandex"
content_urlstring
URL of the page on which ad appeared. Part of the url is removed for privacy.
creative_idint
The ID of the creative.
device_heightint
Device height in px.
device_widthint
Device width in px.
impression_idstring
Unique identifier for impression.
inventory_typeenum
The inventory type. Possible values: YOUTUBE, YOUTUBE TV, YOUTUBE_MUSIC, SEARCH, GMAIL, OTHER. Other refers to either the Google Display or Video network.
is_app_trafficboolean
true if the event happened in a native app. FALSE if the event happened in HTML5 app or webview.
line_item_idint
Line item id for this impression.
locationstruct
Unique identifier for location, which has multiple parts: geo_city_id, geo_metro, geo_region.
location.countrystring
Two-letter code for country, for example "US".
location.geo_city_idint
Code for city. Joins with city_id in adh.city table.
location.geo_metroint
Code for metro region. Joins with metro_id in adh.metro table.
location.geo_regionstring
Region as string, e.g. US-CA.
media_plan_idint
ID of the YouTube Reserve media plan.
mobile_browser_classint
Type of device. Possible values are: desktop, tablet, smart tv consoles, or mobile. Joins with mobile_browser_class_id in adh.mobile_browser_class table.
num_active_view_eligible_impressionint
1 when impression is active view eligible; 0 when impression is not active view eligible.
num_active_view_measurable_impressionint
1 when impression is active view measurable; 0 when impression is not active view measurable.
operating_systemstring
Possible values are: "Android", "AppleTV", "Chrome OS", "Fire OS", "Google TV", "iOS", "Linux", "Mac", "Unknown", "PlayStation", "Roku", "Tizen", "Xbox", "Windows", "Windows Phone"
order_idint
ID of the Google Ad Manager order.
physical_screen_heightint
Device screen height in mm.
physical_screen_widthint
Device screen width in mm.
publisher_domainstring
Domain of page on which ad appeared.
query_idstruct
Unique identifier for query, which has multiple parts: process_id, server_ip, time_usec.
query_id.process_idint
ID of the process on the machine that generated the event.
query_id.server_ipint
IP address of the server that generated the event.
query_id.time_usecint
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
query_languagestring
Language used by user.
user_idopaque
User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

YouTube Reserve line item

yt_reserve_lineitem
creative_idarray
Array of creative ids for this line item. Joins with creative_id in any adh.yt table.
end_timetimestamp
Time the line item stopped being served.
line_item_idint
Ad Manager line item serving.
line_item_namestring
Ad Manager line item name.
order_idint
Ad Manager Order identifier used for serving.
order_namestring
Name of the insertion order.
programmaticboolean
true if the line item was programmatic.
start_timetimestamp
Time the line item started to be served.

YouTube Reserve order

yt_reserve_order
advertiser_idint
Unique ID of the advertiser.
advertiser_namestring
User entered name of the advertiser.
advertiser_timezonestring
The YouTube Reserve advertiser time zone default set in account settings.
media_plan_idint
ID of the YouTube Reserve media plan.
media_plan_namestring
Name of the YouTube Reserve media plan.
order_idint
Ad Manager Order identifier used for serving.
order_namestring
Name of Ad Manager order

YouTube Reserve vendor reporting metadata

yt_reserve_vendor_reporting_data
line_item_idint
Unique ID of the line item.
reporting_idstring
Customer-provided identifier to slice their data by.
vendor_client_idstring
All lower-case formatted vendor client id (VCID).
vendor_metricstring
Measurement type.