Ads Data Hub table schema- Vendors

Ad Manager 360 auctions

am360_auctions
`bid`	`struct` A repeated field describing each of the bids into the AdX auction.
`bid.buyer_name`	`string` The name of the buyer network or third-party exchange that placed this bid.
`bid.classified_advertiser_name`	`string` The Google-classified name of the advertiser whose ad would be served if this bid won.
`bid.cpm`	`double` The CPM of this bid, in the publisher network’s default currency.
`bid.deal_id`	`string` The ID of the deal that would apply if this bid won.
`bid.deal_type`	`string` 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.outcome`	`string` 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.source`	`string` 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_cpm`	`double` The unified pricing rule-based floor price that applied to this bid.
`bid.yield_group_ids`	`int` The IDs of the yield groups that allowed this source of demand to place this bid.
`bid.yield_partner_id`	`int` The ID of the company placing this bid. Joins to am360_match_company.company_id.
`event_time_usec`	`timestamp` The timestamp of the specific event.
`metadata`	`struct` A group of fields containing metadata about the event.
`metadata.child_network_code`	`string` Identifies the Multiple Customer Management (MCM) child network who operates the property requesting the ad.
`metadata.event_id`	`string` A unique ID for this event across all tables.
`metadata.network_code`	`string` Identifies the publisher network that controls the inventory being filled by the ad query.
`metadata.request_id`	`string` 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_usec`	`timestamp` The timestamp of the initial request to Google that became the ad query.
`user_id`	`string` Google-assigned ID of the browser that sent the ad event. Cannot be extracted.
`user_ppid`	`string` Encoded Publisher Provided ID (PPID) from the ad query. Cannot be decoded. Cannot be extracted.

Ad Manager 360 conversions

am360_conversions
`activity_id`	`int` The ID of the activity that was performed, from the Spotlight tag.
`activity_trigger`	`string` The user action that led to this activity. One of 'Impression' or 'Click'.
`click_id`	`string` The ID of the click that led to this activity, if there was one. Joins to am360_interactions.metadata.event_id.
`delivery`	`struct` A group of fields describing the ad delivered to fill the query.
`delivery.advertiser_company_id`	`int` 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_id`	`string` 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_name`	`string` The name of the buyer network or third-party exchange that filled the ad.
`delivery.classified_advertiser_name`	`string` The Google-classified advertiser name whose ad served.
`delivery.creative_id`	`int` The ID of the publisher's reservation creative that was served. Reservation-only
`delivery.creative_serve_id`	`string` 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_delivered`	`string` The size of the creative that was served.
`delivery.deal_id`	`string` The ID of the direct deal used when choosing this ad.
`delivery.deal_type`	`string` The type of direct deal (e.g. 'Programmatic guaranteed', 'Preferred deal', 'Private auction', etc.).
`delivery.demand_channel`	`string` The demand channel that filled the ad request (e.g. 'Ad Server', 'Open Auction', etc.)
`delivery.estimated_revenue`	`double` 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_id`	`int` The line item that allowed this ad to serve. Joins to am360_match_line_item.line_item_id.
`delivery.optimization_type`	`string` The type of optimization applied when choosing this creative (i.e. 'Optimized competition', 'Target CPM', 'First Look'). May be null
`delivery.order_id`	`int` The order (aka campaign) that contains the line item. Joins to am360_match_order.order_id.
`delivery.query_id`	`string` The ID of the originating query record in the queries table. Joins to am360_queries.metadata.event_id.
`delivery.targeted_audience_segment_ids`	`int` Audience segment (aka user list) IDs used when targeting this creative at the user, both positive and negative matches.
`delivery.targeted_custom_criteria`	`struct` A repeated field describing how the custom_criteria from the inventory was used in targeting this creative.
`delivery.targeted_custom_criteria.is_negative_match`	`bool` Whether this key/value was negatively matched by line item targeting.
`delivery.targeted_custom_criteria.key`	`string` The name of the custom_criteria key.
`delivery.targeted_custom_criteria.match_type`	`string` The type of match that was performed (e.g. 'Broad', 'Exact', 'Prefix', etc.).
`delivery.targeted_custom_criteria.pattern`	`string` The pattern that the value from inventory.custom_criteria matched.
`delivery.video_fallback_index`	`int` The index of this video fallback creative, or null.
`delivery.yield_group_ids`	`int` The IDs of the yield groups that allowed this source of demand to fill this ad.
`delivery.yield_partner_id`	`int` The company ID that filled this ad. Joins to am360_match_company.company_id.
`event_time_usec`	`timestamp` The timestamp of the specific event.
`inventory`	`struct` A group of fields describing the inventory properties from the ad query.
`inventory.ad_unit_id`	`int` 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_path`	`int` 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_sizes`	`string` The requested size(s) of the ad to display in this ad unit. May contain values like '320x250', 'Native', and 'Fluid'.
`inventory.custom_criteria`	`struct` 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.key`	`string` The key of this custom criteria, passed in on the ad query.
`inventory.custom_criteria.value`	`string` The value of this custom criteria value, passed in on the ad query.
`inventory.device`	`struct` A group of fields describing the device that made the ad query.
`inventory.device_category`	`string` The type of device, such as 'Smartphone' or 'Desktop'.
`inventory.geo`	`struct` A group of fields describing the geographical location where the ad query came from.
`inventory.geo.country`	`string` The name of the country where the ad query came from.
`inventory.geo.language`	`string` The language of the query.
`inventory.geo.language_country`	`string` 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.region`	`string` The name of the geographical region where the ad query came from.
`inventory.is_companion`	`bool` 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_ids`	`int` The IDs of audience segments (aka user lists) visible to the publisher network that contain the user ID making the ad query.
`inventory.placement_id`	`int` The ID of the placement (a group of ad units). Joins to am360_match_placement.placement_id.
`inventory.referer_url`	`string` 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_id`	`int` The ID of the video content the ad is displaying against (defined by the publisher).
`inventory.video_position`	`int` 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_property`	`string` The web property code associated with the ad request.
`metadata`	`struct` A group of fields containing metadata about the event.
`metadata.child_network_code`	`string` Identifies the Multiple Customer Management (MCM) child network who operates the property requesting the ad.
`metadata.event_id`	`string` A unique ID for this event across all tables.
`metadata.network_code`	`string` Identifies the publisher network that controls the inventory being filled by the ad query.
`metadata.request_id`	`string` 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_cost`	`int` The amount the user paid the advertiser, as reported in the cost= parameter of the Spotlight tag.
`order_number`	`string` The user's order number with the advertiser reported in the ord= parameter of the Spotlight tag.
`order_quantity`	`int` The quantity of items purchased by the user from the advertiser, as reported in the qty= parameter of the Spotlight tag.
`request_time_usec`	`timestamp` The timestamp of the initial request to Google that became the ad query.
`trigger_usec`	`timestamp` The timestamp of the user action that led to this activity.
`user_id`	`string` Google-assigned ID of the browser that sent the ad event. Cannot be extracted.
`user_ppid`	`string` Encoded Publisher Provided ID (PPID) from the ad query. Cannot be decoded. Cannot be extracted.

Ad Manager 360 creative serves

am360_creative_serves
`delivery`	`struct` A group of fields describing the ad delivered to fill the query.
`delivery.advertiser_company_id`	`int` 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_id`	`string` 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_name`	`string` The name of the buyer network or third-party exchange that filled the ad.
`delivery.classified_advertiser_name`	`string` The Google-classified advertiser name whose ad served.
`delivery.creative_id`	`int` The ID of the publisher's reservation creative that was served. Reservation-only
`delivery.creative_serve_id`	`string` 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_delivered`	`string` The size of the creative that was served.
`delivery.deal_id`	`string` The ID of the direct deal used when choosing this ad.
`delivery.deal_type`	`string` The type of direct deal (e.g. 'Programmatic guaranteed', 'Preferred deal', 'Private auction', etc.).
`delivery.demand_channel`	`string` The demand channel that filled the ad request (e.g. 'Ad Server', 'Open Auction', etc.)
`delivery.estimated_revenue`	`double` 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_id`	`int` The line item that allowed this ad to serve. Joins to am360_match_line_item.line_item_id.
`delivery.optimization_type`	`string` The type of optimization applied when choosing this creative (i.e. 'Optimized competition', 'Target CPM', 'First Look').
`delivery.order_id`	`int` The order (aka campaign) that contains the line item. Joins to am360_match_order.order_id.
`delivery.query_id`	`string` The ID of the originating query record in the queries table. Joins to am360_queries.metadata.event_id.
`delivery.targeted_audience_segment_ids`	`int` Audience segment (aka user list) IDs used when targeting this creative at the user. Includes both positive and negative matches.
`delivery.targeted_custom_criteria`	`struct` A repeated field describing how the custom_criteria from the inventory was used in targeting this creative.
`delivery.targeted_custom_criteria.is_negative_match`	`bool` True if this key/value was targeted negatively.
`delivery.targeted_custom_criteria.key`	`string` The name of the custom_criteria key.
`delivery.targeted_custom_criteria.match_type`	`string` The type of match that was performed (e.g. 'Broad', 'Exact', 'Prefix', etc.).
`delivery.targeted_custom_criteria.pattern`	`string` The pattern that the value from inventory.custom_criteria matched.
`delivery.video_fallback_index`	`int` The index of this video fallback creative, or null.
`delivery.yield_group_ids`	`int` The IDs of the yield groups that allowed this source of demand to serve this ad.
`delivery.yield_partner_id`	`int` The company ID that filled this ad. Joins to am360_match_company.company_id.
`event_time_usec`	`timestamp` The timestamp of the specific event.
`inventory`	`struct` A group of fields describing the inventory properties from the ad query.
`inventory.ad_unit_id`	`int` 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_path`	`int` 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_sizes`	`string` The requested size(s) of the ad to display in this ad unit. May contain values like '320x250', 'Native', and 'Fluid'.
`inventory.custom_criteria`	`struct` 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.key`	`string` The key of this custom criteria, passed in on the ad query.
`inventory.custom_criteria.value`	`string` The value of this custom criteria value, passed in on the ad query.
`inventory.device`	`struct` A group of fields describing the device that made the ad query.
`inventory.device_category`	`string` The type of device, such as 'Smartphone' or 'Desktop'.
`inventory.geo`	`struct` A group of fields describing the geographical location where the ad query came from.
`inventory.geo.country`	`string` The name of the country where the ad query came from.
`inventory.geo.language`	`string` The language of the query.
`inventory.geo.language_country`	`string` 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.region`	`string` The name of the geographical region where the ad query came from.
`inventory.is_companion`	`bool` 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_ids`	`int` The IDs of audience segments (aka user lists) visible to the publisher network that contain the user ID making the ad query.
`inventory.placement_id`	`int` The ID of the placement (a group of ad units). Joins to am360_match_placement.placement_id.
`inventory.referer_url`	`string` 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_id`	`int` The ID of the video content the ad is displaying against (defined by the publisher).
`inventory.video_position`	`int` 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_property`	`string` The web property code associated with the ad request.
`metadata`	`struct` A group of fields containing metadata about the event.
`metadata.child_network_code`	`string` Identifies the Multiple Customer Management (MCM) child network who operates the property requesting the ad.
`metadata.event_id`	`string` A unique ID for this event across all tables.
`metadata.network_code`	`string` Identifies the publisher network that controls the inventory being filled by the ad query.
`metadata.request_id`	`string` 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_usec`	`timestamp` The timestamp of the initial request to Google that became the ad query.
`user_id`	`string` Google-assigned ID of the browser that sent the ad event. Cannot be extracted.
`user_ppid`	`string` Encoded Publisher Provided ID (PPID) from the ad query. Cannot be decoded. Cannot be extracted.

Ad Manager 360 impressions

am360_impressions
`delivery`	`struct` A group of fields describing the ad delivered to fill the query.
`delivery.advertiser_company_id`	`int` 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_id`	`string` 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_name`	`string` The name of the buyer network or third-party exchange that filled the ad.
`delivery.classified_advertiser_name`	`string` The Google-classified advertiser name whose ad served.
`delivery.creative_id`	`int` The ID of the publisher's reservation creative that was served. Reservation-only
`delivery.creative_serve_id`	`string` 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_delivered`	`string` The size of the creative that was served.
`delivery.deal_id`	`string` The ID of the direct deal used when choosing this ad.
`delivery.deal_type`	`string` The type of direct deal (e.g. 'Programmatic guaranteed', 'Preferred deal', 'Private auction', etc.).
`delivery.demand_channel`	`string` The demand channel that filled the ad request (e.g. 'Ad Server', 'Open Auction', etc.)
`delivery.estimated_revenue`	`double` 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_id`	`int` The line item that allowed this ad to serve. Joins to am360_match_line_item.line_item_id.
`delivery.optimization_type`	`string` The type of optimization applied when choosing this creative (i.e. 'Optimized competition', 'Target CPM', 'First Look'). May be null
`delivery.order_id`	`int` The order (aka campaign) that contains the line item. Joins to am360_match_order.order_id.
`delivery.query_id`	`string` The ID of the originating query record in the queries table. Joins to am360_queries.metadata.event_id.
`delivery.targeted_audience_segment_ids`	`int` Audience segment (aka user list) IDs used when targeting this creative at the user, both positive and negative matches.
`delivery.targeted_custom_criteria`	`struct` A repeated field describing how the custom_criteria from the inventory was used in targeting this creative.
`delivery.targeted_custom_criteria.is_negative_match`	`bool` Whether this key/value was negatively matched by line item targeting.
`delivery.targeted_custom_criteria.key`	`string` The name of the custom_criteria key.
`delivery.targeted_custom_criteria.match_type`	`string` The type of match that was performed (e.g. 'Broad', 'Exact', 'Prefix', etc.).
`delivery.targeted_custom_criteria.pattern`	`string` The pattern that the value from inventory.custom_criteria matched.
`delivery.video_fallback_index`	`int` The index of this video fallback creative, or null.
`delivery.yield_group_ids`	`int` The IDs of the yield groups that allowed this source of demand to fill this ad.
`delivery.yield_partner_id`	`int` The company ID that filled this ad. Joins to am360_match_company.company_id.
`event_time_usec`	`timestamp` The timestamp of the specific event.
`inventory`	`struct` A group of fields describing the inventory properties from the ad query.
`inventory.ad_unit_id`	`int` 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_path`	`int` 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_sizes`	`string` The requested size(s) of the ad to display in this ad unit. May contain values like '320x250', 'Native', and 'Fluid'.
`inventory.custom_criteria`	`struct` 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.key`	`string` The key of this custom criteria, passed in on the ad query.
`inventory.custom_criteria.value`	`string` The value of this custom criteria value, passed in on the ad query.
`inventory.device`	`struct` A group of fields describing the device that made the ad query.
`inventory.device_category`	`string` The type of device, such as 'Smartphone' or 'Desktop'.
`inventory.geo`	`struct` A group of fields describing the geographical location where the ad query came from.
`inventory.geo.country`	`string` The name of the country where the ad query came from.
`inventory.geo.language`	`string` The language of the query.
`inventory.geo.language_country`	`string` 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.region`	`string` The name of the geographical region where the ad query came from.
`inventory.is_companion`	`bool` 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_ids`	`int` The IDs of audience segments (aka user lists) visible to the publisher network that contain the user ID making the ad query.
`inventory.placement_id`	`int` The ID of the placement (a group of ad units). Joins to am360_match_placement.placement_id.
`inventory.referer_url`	`string` 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_id`	`int` The ID of the video content the ad is displaying against (defined by the publisher).
`inventory.video_position`	`int` 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_property`	`string` The web property code associated with the ad request.
`metadata`	`struct` A group of fields containing metadata about the event.
`metadata.child_network_code`	`string` Identifies the Multiple Customer Management (MCM) child network who operates the property requesting the ad.
`metadata.event_id`	`string` A unique ID for this event across all tables.
`metadata.network_code`	`string` Identifies the publisher network that controls the inventory being filled by the ad query.
`metadata.request_id`	`string` 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_usec`	`timestamp` The timestamp of the initial request to Google that became the ad query.
`user_id`	`string` Google-assigned ID of the browser that sent the ad event. Cannot be extracted.
`user_ppid`	`string` Encoded Publisher Provided ID (PPID) from the ad query. Cannot be decoded. Cannot be extracted.

Ad Manager 360 interactions

am360_interactions
`action_count`	`int` The number of actions the user made. Always 1 for clicks.
`action_duration_sec`	`double` The duration of those actions. Always 1.0 for clicks.
`action_type`	`string` The type of action (one of 'Click', 'Standard', or 'Custom').
`delivery`	`struct` A group of fields describing the ad delivered to fill the query.
`delivery.advertiser_company_id`	`int` 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_id`	`string` 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_name`	`string` The name of the buyer network or third-party exchange that filled the ad.
`delivery.classified_advertiser_name`	`string` The Google-classified advertiser name whose ad served.
`delivery.creative_id`	`int` The ID of the publisher's reservation creative that was served. Reservation-only
`delivery.creative_serve_id`	`string` 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_delivered`	`string` The size of the creative that was served.
`delivery.deal_id`	`string` The ID of the direct deal used when choosing this ad.
`delivery.deal_type`	`string` The type of direct deal (e.g. 'Programmatic guaranteed', 'Preferred deal', 'Private auction', etc.).
`delivery.demand_channel`	`string` The demand channel that filled the ad request (e.g. 'Ad Server', 'Open Auction., etc.)
`delivery.estimated_revenue`	`double` 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_id`	`int` The line item that allowed this ad to serve. Joins to am360_match_line_item.line_item_id.
`delivery.optimization_type`	`string` The type of optimization applied when choosing this creative (i.e. 'Optimized competition', 'Target CPM', 'First Look'). May be null
`delivery.order_id`	`int` The order (aka campaign) that contains the line item. Joins to am360_match_order.order_id.
`delivery.query_id`	`string` The ID of the originating query record in the queries table. Joins to am360_queries.metadata.event_id.
`delivery.targeted_audience_segment_ids`	`int` Audience segment (aka user list) IDs used when targeting this creative at the user, both positive and negative matches.
`delivery.targeted_custom_criteria`	`struct` A repeated field describing how the custom_criteria from the inventory was used in targeting this creative.
`delivery.targeted_custom_criteria.is_negative_match`	`bool` Whether this key/value was negatively matched by line item targeting.
`delivery.targeted_custom_criteria.key`	`string` The name of the custom_criteria key.
`delivery.targeted_custom_criteria.match_type`	`string` The type of match that was performed (e.g. 'Broad', 'Exact', 'Prefix', etc.).
`delivery.targeted_custom_criteria.pattern`	`string` The pattern that the value from inventory.custom_criteria matched.
`delivery.video_fallback_index`	`int` The index of this video fallback creative, or null.
`delivery.yield_group_ids`	`int` The IDs of the yield groups that allowed this source of demand to fill this ad.
`delivery.yield_partner_id`	`int` The company ID that filled this ad. Joins to am360_match_company.company_id.
`event_time_usec`	`timestamp` The timestamp of the specific event.
`inventory`	`struct` A group of fields describing the inventory properties from the ad query.
`inventory.ad_unit_id`	`int` 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_path`	`int` 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_sizes`	`string` The requested size(s) of the ad to display in this ad unit. May contain values like '320x250', 'Native', and 'Fluid'.
`inventory.custom_criteria`	`struct` 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.key`	`string` The key of this custom criteria, passed in on the ad query.
`inventory.custom_criteria.value`	`string` The value of this custom criteria value, passed in on the ad query.
`inventory.device`	`struct` A group of fields describing the device that made the ad query.
`inventory.device_category`	`string` The type of device, such as 'Smartphone' or 'Desktop'.
`inventory.geo`	`struct` A group of fields describing the geographical location where the ad query came from.
`inventory.geo.country`	`string` The name of the country where the ad query came from.
`inventory.geo.language`	`string` The language of the query.
`inventory.geo.language_country`	`string` 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.region`	`string` The name of the geographical region where the ad query came from.
`inventory.is_companion`	`bool` 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_ids`	`int` The IDs of audience segments (aka user lists) visible to the publisher network that contain the user ID making the ad query.
`inventory.placement_id`	`int` The ID of the placement (a group of ad units). Joins to am360_match_placement.placement_id.
`inventory.referer_url`	`string` 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_id`	`int` The ID of the video content the ad is displaying against (defined by the publisher).
`inventory.video_position`	`int` 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_property`	`string` The web property code associated with the ad request.
`metadata`	`struct` A group of fields containing metadata about the event.
`metadata.child_network_code`	`string` Identifies the Multiple Customer Management (MCM) child network who operates the property requesting the ad.
`metadata.event_id`	`string` A unique ID for this event across all tables.
`metadata.network_code`	`string` Identifies the publisher network that controls the inventory being filled by the ad query.
`metadata.request_id`	`string` 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_usec`	`timestamp` The timestamp of the initial request to Google that became the ad query.
`user_id`	`string` Google-assigned ID of the browser that sent the ad event. Cannot be extracted.
`user_ppid`	`string` 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_days`	`int` 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_ids`	`int` 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_name`	`string` Human-readable display name of the activity group that this activity belongs to.
`activity_group_id`	`int` Unique ID that represents the group of activities that this activity belongs to.
`activity_group_impressions_lookback_days`	`int` The lookback number of days to track view-through conversions for all activities in the activity group that this activity belongs to.
`activity_id`	`int` Unique ID that represents this activity.
`activity_type`	`string` 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_name`	`string` Human-readable display name.
`expected_url`	`string` 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_code`	`string` Publisher-defined or generated string used to identify this ad unit.
`parent_ad_unit_code_hierarchy`	`string` 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_id`	`int` Unique ID that represents this ad unit.
`display_name`	`string` Human-readable display name.
`external_set_top_box_channel_id`	`string` The set top box video on demand channel this ad unit corresponds to in an external set top box ad campaign system.
`is_fluid`	`bool` True if this ad unit supports fluid ads.
`is_interstitial`	`bool` True if this ad unit supports interstitial ads.
`is_native`	`bool` True if this ad unit supports native ads.
`parent_ad_unit_id`	`int` 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_id`	`int` Unique ID that represents this company.
`display_name`	`string` Human-readable name of the company.

Ad Manager 360 match line item

am360_match_line_item
`cost_per_unit`	`double` The cost per delivered unit of this line item, in the publisher network's default currency.
`cost_type`	`string` The method used for billing this LineItem. One of 'CPA', 'CPC', 'CPD', 'CPM', 'CPMAV', or 'CPM_IN_TARGET'
`create_time`	`timestamp` The date and time that the line item was created.
`display_name`	`string` Human-readable display name.
`end_time`	`timestamp` The date and time when the line item will stop serving.
`external_deal_id`	`string` 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_id`	`string` A value set by the publisher that has meaning in external systems.
`line_item_id`	`int` Unique ID that represents this line item.
`missing_creatives`	`bool` True if this line item is missing at least one expected creative specified during setup.
`order_id`	`int` Order (aka campaign) this line item belongs to. Joins to am360_match_order.order_id.
`priority`	`int` The priority for the line item. See https://developers.google.com/ad-manager/api/reference/latest/ForecastService.LineItem#priority.
`start_time`	`timestamp` The date and time when the line item is set to begin serving.

Ad Manager 360 match order

am360_match_order
`advertiser_company_id`	`int` The advertiser which is associated with this order. Joins to am360_match_company.company_id.
`agency_id`	`int` The agency which is associated with this order. Joins to company.company_id.
`display_name`	`string` Human-readable display name.
`end_time_usec`	`timestamp` The date and time when the order will stop delivering.
`external_order_id`	`string` A value set by the publisher that has meaning in external systems.
`is_programmatic`	`bool` Specifies whether or not the order is a programmatic order.
`order_id`	`int` Unique ID that represents this order.
`po_number`	`string` A value set by the publisher meant to hold the purchase order number for this order.
`start_time_usec`	`timestamp` The date and time when the order is set to begin delivering.

Ad Manager 360 match placement

am360_match_placement
`ad_unit_ids`	`int` Collection of ad unit IDs that make up this placement. Joins to am360_match_ad_unit.ad_unit_id.
`display_name`	`string` Human-readable display name.
`placement_code`	`string` Publisher-defined or generated string used to identify this placement.
`placement_id`	`int` Unique ID that represents this placement.

Ad Manager 360 queries

am360_queries
`auction_id`	`string` 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_usec`	`timestamp` The timestamp of the specific event.
`inventory`	`struct` A group of fields describing the inventory properties from the ad query.
`inventory.ad_unit_id`	`int` 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_path`	`int` 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_sizes`	`string` The requested size(s) of the ad to display in this ad unit. May contain values like '320x250', 'Native', and 'Fluid'.
`inventory.custom_criteria`	`struct` 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.key`	`string` The key of this custom criteria, passed in on the ad query.
`inventory.custom_criteria.value`	`string` The value of this custom criteria value, passed in on the ad query.
`inventory.device`	`struct` A group of fields describing the device that made the ad query.
`inventory.device_category`	`string` The type of device, such as 'Smartphone' or 'Desktop'.
`inventory.geo`	`struct` A group of fields describing the geographical location where the ad query came from.
`inventory.geo.country`	`string` The name of the country where the ad query came from.
`inventory.geo.language`	`string` The language of the query.
`inventory.geo.language_country`	`string` 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.region`	`string` The name of the geographical region where the ad query came from.
`inventory.is_companion`	`bool` 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_ids`	`int` The IDs of audience segments (aka user lists) visible to the publisher network that contain the user ID making the ad query.
`inventory.placement_id`	`int` The ID of the placement (a group of ad units). Joins to am360_match_placement.placement_id.
`inventory.referer_url`	`string` 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_id`	`int` The ID of the video content the ad is displaying against.
`inventory.video_position`	`int` 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_property`	`string` The web property code associated with the ad request.
`is_filled`	`bool` True if query is associated with any rows in the am360_creative_serves table.
`is_video_backup`	`bool` True if this query was for a video backup ad. Such queries are not counted by Ad Manager Reports.
`metadata`	`struct` A group of fields containing metadata about the event.
`metadata.child_network_code`	`string` Identifies the Multiple Customer Management (MCM) child network who operates the property requesting the ad.
`metadata.event_id`	`string` A unique ID for this event across all tables. May be referenced by fields in other tables.
`metadata.network_code`	`string` Identifies the publisher network that controls the inventory being filled by the ad query.
`metadata.request_id`	`string` 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_usec`	`timestamp` The timestamp of the initial request to Google that became the ad query.
`user_id`	`string` Google-assigned ID of the browser that sent the ad event. Cannot be extracted.
`user_ppid`	`string` Encoded Publisher Provided ID (PPID) from the ad query. Cannot be decoded. Cannot be extracted.

Browser

browser
`browser_id`	`int` Browser identifier.
`browser_name`	`string` Browser name.
`major_version`	`string` Major version of the browser (whole number version).
`minor_version`	`string` Minor version of the browser (incremental or decimal version).

City

city
`city_id`	`int` Unique ID of the city.
`city_name`	`string` City name.
`country_code`	`string` Two character country code.
`metro_code`	`string` Metropolitan area code.

DV360 YouTube Active View

dv360_youtube_active_views
`impression_data.adgroup_id`	`int` ID of the Display & Video 360 YouTube ad group. Used as a join key in any adh.dv360_youtube_* table.
`impression_data.advertiser_id`	`int` Unique ID of the advertiser.
`impression_data.campaign_id`	`int` Unique ID of the campaign.
`impression_data.creative_id`	`int` Unique ID of the creative.
`impression_data.insertion_order_id`	`int` The Display & Video 360 numerical ID for the insertion order related to the event, e.g. 1079941.
`impression_data.line_item_id`	`int` The Display & Video 360 numerical ID for the line item related to the event, e.g. 1155785.
`impression_data.partner_id`	`int` Unique ID of the partner.
`impression_id`	`string` Unique ID of the impression.
`num_active_view_viewable_impression`	`int` 1 = impression is active view eligible, 0 = impression isn't active view eligible.
`query_id`	`struct` Unique identifier for query has multiple parts.
`query_id.process_id`	`int` Integer that identifies the process on the machine that generated the event.
`query_id.server_ip`	`int` The IPv4 address of the server that managed the ad request. Used to identify unique events for joins.
`query_id.time_usec`	`int` The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
`view_id`	`struct` Unique ID for view has multiple parts.
`view_id.process_id`	`int` The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
`view_id.server_ip`	`int` The IPv4 address of the server that generated this event.
`view_id.time_usec`	`int` The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.

DV360 YouTube ad group

dv360_youtube_adgroup
`adgroup_id`	`int` ID of DV360 ad group. Joins with adgroup_id in any adh.dv360_youtube table.
`adgroup_name`	`string` Ad group name.
`adgroup_status`	`string` The ad group. Possible values are: "status", "paused", or "enabled".
`adgroup_type`	`string` The ad group type. Possible values are: VIDEO_TRUE_VIEW_IN_STREAM, VIDEO_NON_SKIPPABLE_IN_STREAM, VIDEO_BUMPER, VIDEO_TRUE_VIEW_IN_DISPLAY.
`advertiser_id`	`int` Unique ID of the advertiser.
`campaign_id`	`int` Unique ID of the campaign.
`insertion_order_id`	`int` Unique ID of the insertion order.
`line_item_id`	`int` Unique ID of the line item.
`partner_id`	`int` Unique ID of the partner.

DV360 YouTube advertiser

dv360_youtube_advertiser
`advertiser_id`	`int` Unique ID of the advertiser.
`advertiser_name`	`string` Name of the advertiser.
`advertiser_timezone`	`string` The DV360 advertiser time zone default set in account settings.
`partner_id`	`int` Unique ID of the partner.

DV360 YouTube campaign

dv360_youtube_campaign
`advertiser_id`	`int` Unique ID of the advertiser.
`campaign_id`	`int` Unique ID of the campaign.
`campaign_name`	`string` Name of the campaign
`partner_id`	`int` Unique ID of the partner.

DV360 YouTube clicks

dv360_youtube_clicks
`click_id`	`struct` Unique identifier for click has multiple parts. Joins with click_id in any adh.dv360_youtube table.
`click_id.process_id`	`int` Integer that identifies the process on the machine that generated the event.
`click_id.server_ip`	`int` The IPv4 address of the server that generated this event.
`click_id.time_usec`	`int` The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
`click_type`	`int` The click type.
`impression_data.adgroup_id`	`int` ID of DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table.
`impression_data.advertiser_id`	`int` Unique ID of the advertiser.
`impression_data.campaign_id`	`int` Unique ID of the campaign.
`impression_data.creative_id`	`int` Joins with creative_id in any adh.dv360_youtube table.
`impression_data.insertion_order_id`	`int` Unique ID of the insertion order.
`impression_data.line_item_id`	`int` Unique ID of the line item.
`impression_data.partner_id`	`int` Unique ID of the partner.
`impression_id`	`string` Unique identifier for impression.
`query_id`	`struct` Unique identifier for query has multiple parts. Joins with query_id in any adh.dv360_youtube table.
`query_id.process_id`	`int` Integer that identifies the process on the machine that generated the event.
`query_id.server_ip`	`int` The IPv4 address of the server that generated this event.
`query_id.time_usec`	`int` The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
`user_id`	`opaque` User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

DV360 YouTube conversions

dv360_youtube_conversions
`click_id`	`struct` Unique identifier for click has multiple parts. Joins with click_id in any adh.dv360_youtube table.
`click_id.process_id`	`int` Integer that identifies the process on the machine that generated the event.
`click_id.server_ip`	`int` The IPv4 address of the server that generated this event.
`click_id.time_usec`	`int` The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
`conversion_id`	`struct` Unique identifier for conversion has multiple parts.
`conversion_id.process_id`	`int` Integer that identifies the process on the machine that generated the event.
`conversion_id.server_ip`	`int` The IPv4 address of the server that generated this event.
`conversion_id.time_usec`	`int` The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
`conversion_type`	`int` The type of conversion.
`impression_data.adgroup_id`	`int` ID of DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table.
`impression_data.advertiser_id`	`int` Unique ID of the advertiser.
`impression_data.campaign_id`	`int` Unique ID of the campaign.
`impression_data.creative_id`	`int` Joins with creative_id in any adh.dv360_youtube table.
`impression_data.insertion_order_id`	`int` Unique ID of the insertion order.
`impression_data.line_item_id`	`int` Unique ID of the line item.
`impression_data.partner_id`	`int` Unique ID of the partner.
`impression_id`	`string` Unique identifier for impression.
`label`	`string` Name of conversion event.
`query_id`	`struct` Unique identifier for query has multiple parts. Joins with query_id in any adh.dv360_youtube table.
`query_id.process_id`	`int` Integer that identifies the process on the machine that generated the event.
`query_id.server_ip`	`int` The IPv4 address of the server that generated this event.
`query_id.time_usec`	`int` The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
`user_id`	`opaque` User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

DV360 YouTube creative

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

DV360 YouTube creative conversions

dv360_youtube_creative_conversions
`click_id`	`struct` Unique identifier for click has multiple parts. Joins with click_id in any adh.dv360_youtube table.
`click_id.process_id`	`int` Integer that identifies the process on the machine that generated the event.
`click_id.server_ip`	`int` The IPv4 address of the server that generated this event.
`click_id.time_usec`	`int` The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
`conversion_id`	`struct` Unique identifier for conversion has multiple parts.
`conversion_id.process_id`	`int` Integer that identifies the process on the machine that generated the event.
`conversion_id.server_ip`	`int` The IPv4 address of the server that generated this event.
`conversion_id.time_usec`	`int` The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
`conversion_type`	`int` The type of conversion.
`impression_data.adgroup_id`	`int` ID of the DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table.
`impression_data.advertiser_id`	`int` Unique ID of the advertiser.
`impression_data.campaign_id`	`int` Unique ID of the campaign.
`impression_data.creative_id`	`int` Joins with creative_id in any adh.dv360_youtube table.
`impression_data.insertion_order_id`	`int` Unique ID of the insertion order.
`impression_data.line_item_id`	`int` Unique ID of the line item.
`impression_data.partner_id`	`int` Unique ID of the partner.
`impression_id`	`string` Unique identifier for impression.
`label`	`string` Name of conversion event.
`query_id`	`struct` Unique identifier for query has multiple parts. Joins with query_id in any adh.dv360_youtube table.
`query_id.process_id`	`int` Integer that identifies the process on the machine that generated the event.
`query_id.server_ip`	`int` The IPv4 address of the server that generated this event.
`query_id.time_usec`	`int` The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
`user_id`	`opaque` User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

DV360 YouTube impressions

dv360_youtube_impressions
`adgroup_id`	`int` ID of DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table.
`advertiser_id`	`int` Unique ID of the advertiser.
`browser`	`string` Possible values are: "Chrome", "Cobalt", "Dalvik", "Edge", "Firefox", "IE", "Opera", "Other", "Safari", "Samsung Browser", "Roku", "Silk", "Unknown", "Yandex"
`campaign_id`	`int` Unique ID of the campaign.
`content_url`	`string` URL of the page on which ad appeared. Part of the url is removed for privacy.
`device_height`	`int` Device height in px.
`device_width`	`int` Device width in px.
`impression_id`	`string` Unique identifier for impression.
`insertion_order_id`	`int` Unique ID of the insertion order.
`inventory_type`	`enum` The inventory type. Possible values: YOUTUBE, YOUTUBE TV, YOUTUBE_MUSIC, SEARCH, GMAIL, OTHER. Other refers to either the Google Display or Video network.
`is_app_traffic`	`boolean` true if the event happened in a native app.
`line_item_id`	`int` Unique ID of the line item.
`location`	`struct` Unique identifier for location has multiple parts
`location.country`	`string`
`location.geo_city_id`	`int` Code for city. Joins with city_id in adh.city table.
`location.geo_metro`	`int` Code for metro region. Joins with metro_id in adh.metro table.
`location.geo_region`	`string` Region as string e.g. US-CA.
`mobile_browser_class`	`int` Type of browser. Possible values are: desktop, tablet, smart tv consoles, or mobile. Joins with mobile_browser_class_id in adh.mobile_browser table.
`num_active_view_eligible_impression`	`int` 1 when impression is active view eligible; 0 when impression is not active view eligible.
`num_active_view_measurable_impression`	`int` 1 when impression is active view measurable; 0 when impression is not active view measurable.
`operating_system`	`string` Possible values are: "Android", "AppleTV", "Chrome OS", "Fire OS", "Google TV", "iOS", "Linux", "Mac", "Unknown", "PlayStation", "Roku", "Tizen", "Xbox", "Windows", "Windows Phone"
`partner_id`	`int` Unique ID of the partner.
`physical_screen_height`	`int` Device screen height in mm.
`physical_screen_width`	`int` Device screen width in mm.
`publisher_domain`	`string` Domain of the page on which ad appeared.
`query_id`	`struct` Unique identifier for query has multiple parts. Joins with query_id in any adh.dv360_youtube table.
`query_id.process_id`	`int` The processing ID.
`query_id.server_ip`	`int` The IPv4 address of the server that generated this event.
`query_id.time_usec`	`int` The query time in microseconds.
`query_language`	`string` Language used by user.
`user_id`	`opaque` User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

DV360 YouTube insertion order

dv360_youtube_insertion_order
`advertiser_id`	`int` Unique ID of the advertiser.
`campaign_id`	`int` Unique ID of the campaign.
`insertion_order_id`	`int` Unique ID of the insertion order.
`insertion_order_name`	`string` Name of the insertion order.
`partner_id`	`int` Unique ID of the partner.

DV360 YouTube line item

dv360_youtube_lineitem
`advertiser_id`	`int` Unique ID of the advertiser.
`campaign_id`	`int` The Display & Video 360 numerical ID for the campaign related to the event, e.g. 164332.
`insertion_order_id`	`int` The Display & Video 360 numerical ID for the insertion order related to the event, e.g. 1079941.
`line_item_end_time`	`int` Unix timestamp in microseconds (1/1,000,000 second) for when the line item ended, e.g. 1330403779608570
`line_item_id`	`int` The Display & Video 360 numerical ID for the line item related to the event, e.g. 1155785.
`line_item_name`	`string` The Display & Video 360 name for the line item related to the event, e.g. 164332.
`line_item_reservation_type`	`enum` Reservation type for a Display & Video 360 line item. Can be one of "Programmatic", "InstantReserve", or "None" (meaning standard auction).
`line_item_start_time`	`int` Unix timestamp in microseconds (1/1,000,000 second) for when the line item started, e.g. 1330403779608570
`line_item_status`	`int` Integer indicating the status of the line item. 3 = ACTIVE. 5 = PAUSED. 7 = DELETED.
`partner_id`	`int` Unique ID of the partner.

DV360 YouTube vendor reporting metadata

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

Freewheel Active Views

freewheel_active_views
`active_view`	`record` Active view
`ad_current_time_ms`	`int` The current time of the ad video playback in milliseconds
`ad_id`	`string` VAST ad_id
`freewheel_event_id`	`record` Unique identifier for query has multiple parts. Joins with event_id.
`freewheel_event_id.process_id`	`int` The processing process.
`freewheel_event_id.server_ip`	`int` The processing server.
`freewheel_event_id.time_usec`	`int` Time in microseconds.
`label`	`string` Name of conversion event.
`user_id`	`opaque` User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes..
`user_language`	`string` A three-letter ISO 639-2/bibliographic language code

Freewheel clicks

freewheel_clicks
`ad_current_time_ms`	`int` The current time of the ad video playback in milliseconds
`ad_id`	`string` VAST ad_id
`freewheel_event_id`	`record` Unique identifier for query has multiple parts. Joins with event_id.
`freewheel_event_id.process_id`	`int` The processing process.
`freewheel_event_id.server_ip`	`int` The processing server.
`freewheel_event_id.time_usec`	`int` Time in microseconds.
`label`	`string` Name of conversion event.
`user_id`	`opaque` User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes..
`user_language`	`string` A three-letter ISO 639-2/bibliographic language code

Freewheel creative pixels

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

Freewheel impressions

freewheel_impressions
`ad_current_time_ms`	`int` The current time of the ad video playback in milliseconds
`ad_id`	`string` VAST ad_id
`browser`	`string` Possible values are: "Chrome", "Cobalt", "Dalvik", "Edge", "Firefox", "IE", "Opera", "Other", "Safari", "Samsung Browser", "Roku", "Silk", "Unknown", "Yandex"
`content_url`	`string` URL of the page on which ad appeared. Part of the url is removed for privacy.
`freewheel_event_id`	`record` Unique identifier for query has multiple parts. Joins with event_id.
`freewheel_event_id.process_id`	`int` The processing process.
`freewheel_event_id.server_ip`	`int` The processing server.
`freewheel_event_id.time_usec`	`int` Time in microseconds.
`inventory_type`	`enum` The inventory type. Possible values: YOUTUBE, YOUTUBE TV, SEARCH, GMAIL, OTHER. Other refers to either the Google Display or Video network.
`is_app_traffic`	`bool` True if the event happened in a native app. FALSE if the event happened in HTML5 app or webview.
`label`	`string` Name of conversion event.
`location`	`struct` Unique identifier for location has multiple parts.
`location.country`	`string` Two character country code.
`location.geo_city_id`	`int` Code for city. Joins with city_id in adh.city table.
`location.geo_country_id`	`int`
`location.geo_region_id`	`int` Code for region.
`mobile_browser_class`	`int` Type of device. Possible values are: desktop, tablet, smart tv consoles, or mobile. Joins with mobile_browser_class_id in adh.mobile_browser_class table.
`operating_system`	`string` Possible values are: "Android", "AppleTV", "Chrome OS", "Fire OS", "Google TV", "iOS", "Linux", "Mac", "Unknown", "PlayStation", "Roku", "Tizen", "Xbox", "Windows", "Windows Phone"
`publisher_domain`	`string` Domain of the page on which ad appeared.
`user_id`	`opaque` User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes..
`user_language`	`string` A three-letter ISO 639-2/bibliographic language code

Freewheel pixel

freewheel_pixel
`pixel_url`	`string` The pixel URL.

Google Ads Active Views

google_ads_active_views
`impression_data.ad_group_creative_id`	`int` ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table.
`impression_data.adgroup_id`	`int` ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table.
`impression_data.campaign_id`	`int` Unique ID of the campaign.
`impression_data.customer_id`	`int` ID of Google Ads customer. Joins with customer_id in any adh.google_ads table.
`impression_id`	`string` Unique identifier for impression.
`num_active_view_viewable_impression`	`int` 1 when impression is active view eligible; 0 when impression is not active view eligible.
`query_id`	`struct` Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
`query_id.process_id`	`int` The processing ID.
`query_id.server_ip`	`int` The IPv4 address of the server that generated this event.
`query_id.time_usec`	`int` The query time in microseconds.
`view_id`	`struct` Unique identifier for view_id has multiple parts.
`view_id.process_id`	`int` The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
`view_id.server_ip`	`int` The IPv4 address of the server that generated this event.
`view_id.time_usec`	`int` Integer that identifies the process on the machine that generated the event.

Google Ads ad group

google_ads_adgroup
`adgroup_id`	`int` ID of Google Ads ad group. Used as a join key in adh.google_ads table.
`adgroup_name`	`string` Name of the ad group in Google Ads.
`adgroup_status`	`string` The ad group. Possible values are: "status", "paused", or "enabled".
`adgroup_type`	`string` The ad group type. Possible values are: "VIDEO_TRUE_VIEW_IN_STREAM", "VIDEO_OUTSTREAM", "VIDEO_TRUE_VIEW_IN_DISPLAY", "VIDEO_BUMPER_IN_STREAM", "VIDEO_NON_SKIPPABLE_IN_STREAM", "DISPLAY", "SEARCH", "YOUTUBE_AUDIO", or "OTHER".
`campaign_id`	`int` Unique ID of the campaign.
`customer_id`	`int` Google Ads account ID. Joins with customer_id in any adh.google_ads table.
`label_ids`	`array<int64>` Label IDs. Joins with label_id in the adh.google_ads_label table.

Google Ads ad group creative

google_ads_adgroupcreative
`ad_group_creative_id`	`INT64` ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table.
`adgroup_creative_status`	`STRING` The status of the creative within the ad group.
`adgroup_id`	`INT64` ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table.
`creative_id`	`INT64` A unique identifier for the creative, specific to the ad group containing it. Joins with creative_id in any adh.google_ads table.
`customer_id`	`INT64` Google Ads account ID. Joins with customer_id in any adh.google_ads table.
`label_ids`	`array<int64>` Label IDs. Joins with label_id in the adh.google_ads_label table.

Google Ads campaign

google_ads_campaign
`advertising_channel_type`	`string` The primary serving target for ads within the campaign. It can be set only when a campaign is newly created in Google Ads. Possible values are: "SEARCH", "DISPLAY", "VIDEO", or "OTHER".
`campaign_id`	`int` Unique ID of the campaign.
`campaign_name`	`string` Campaign name.
`campaign_status`	`int` Campaign status. 3 = ACTIVE. 5 = PAUSED. 7 = DELETED.
`customer_id`	`int` Joins with customer_id in any adh.google_ads table.
`end_time`	`int` Timestamp when the campaign ends in milliseconds.
`label_ids`	`array<int64>` Label IDs. Joins with label_id in the adh.google_ads_label table.
`reservation_type`	`enum` The type of the reservation. Can be either "InstantReserve" or "None" (meaning standard auction).
`start_time`	`int` Timestamp when the campaign begins in milliseconds.

Google Ads clicks

google_ads_clicks
`click_id`	`struct` Unique identifier for click has multiple parts. Joins with click_id in any adh.google_ads table.
`click_id.process_id`	`int` Integer that identifies the process on the machine that generated the event.
`click_id.server_ip`	`int` The IPv4 address of the server that generated this event.
`click_id.time_usec`	`int` The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
`click_type`	`int` The click type.
`impression_data.ad_group_creative_id`	`int` ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table.
`impression_data.adgroup_id`	`int` ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table.
`impression_data.campaign_id`	`int` Unique ID of the campaign.
`impression_data.customer_id`	`int` ID of Google Ads customer. Joins with customer_id in any adh.google_ads table.
`impression_id`	`string` Unique identifier for impression.
`query_id`	`struct` Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
`query_id.process_id`	`int` Integer that identifies the process on the machine that generated the event.
`query_id.server_ip`	`int` The IPv4 address of the server that generated this event.
`query_id.time_usec`	`int` The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
`user_id`	`opaque` User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

Google Ads clicks audience

google_ads_clicks_audience
`click_id`	`struct` Unique identifier for click has multiple parts. Joins with click_id in any adh.google_ads table.
`click_id.process_id`	`int` Integer that identifies the process on the machine that generated the event.
`click_id.server_ip`	`int` The IPv4 address of the server that generated this event.
`click_id.time_usec`	`int` The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
`click_type`	`int` The click type.
`impression_id`	`string` Unique identifier for impression.
`query_id`	`struct` Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
`query_id.process_id`	`int` Integer that identifies the process on the machine that generated the event.
`query_id.server_ip`	`int` The IPv4 address of the server that generated this event.
`query_id.time_usec`	`int` The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
`user_id`	`opaque` User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

Google Ads conversions

google_ads_conversions
`click_id`	`struct` Unique identifier for click has multiple parts. Joins with click_id in any adh.google_ads table.
`click_id.process_id`	`int` Integer that identifies the process on the machine that generated the event.
`click_id.server_ip`	`int` The IPv4 address of the server that generated this event.
`click_id.time_usec`	`int` The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
`conversion_id`	`struct` Unique identifier for conversion has multiple parts.
`conversion_id.process_id`	`int` Integer that identifies the process on the machine that generated the event.
`conversion_id.server_ip`	`int` The IPv4 address of the server that generated this event.
`conversion_id.time_usec`	`int` The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
`conversion_type`	`int` The type of conversion.
`impression_data.ad_group_creative_id`	`int` ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table.
`impression_data.adgroup_id`	`int` ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table.
`impression_data.campaign_id`	`int` Unique ID of the campaign.
`impression_data.customer_id`	`int` ID of Google Ads customer. Joins with customer_id in any adh.google_ads table.
`impression_id`	`string` Unique identifier for impression.
`label`	`string` Name of conversion event.
`query_id`	`struct` Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
`query_id.process_id`	`int` Integer that identifies the process on the machine that generated the event.
`query_id.server_ip`	`int` The IPv4 address of the server that generated this event.
`query_id.time_usec`	`int` The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
`user_id`	`opaque` User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

Google Ads conversions audience

google_ads_conversions_audience
`click_id`	`struct` Unique identifier for click has multiple parts. Joins with click_id in any adh.google_ads table.
`click_id.process_id`	`int` Integer that identifies the process on the machine that generated the event.
`click_id.server_ip`	`int` The IPv4 address of the server that generated this event.
`click_id.time_usec`	`int` The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
`conversion_id`	`struct` Unique identifier for conversion has multiple parts.
`conversion_id.process_id`	`int` Integer that identifies the process on the machine that generated the event.
`conversion_id.server_ip`	`int` The IPv4 address of the server that generated this event.
`conversion_id.time_usec`	`int` The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
`conversion_type`	`int` The type of conversion.
`impression_id`	`string` Unique identifier for impression.
`label`	`string` Name of conversion event.
`query_id`	`struct` Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
`query_id.process_id`	`int` Integer that identifies the process on the machine that generated the event.
`query_id.server_ip`	`int` The IPv4 address of the server that generated this event.
`query_id.time_usec`	`int` The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
`user_id`	`opaque` User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

Google Ads creative

google_ads_creative
`creative_id`	`int` Joins with creative_id in any adh.google_ads table.
`creative_name`	`string` Creative name.
`creative_type`	`int` Creative type.
`customer_id`	`int` Google Ads account ID. Joins with customer_id in any adh.google_ads table.
`template_id`	`int` Template ID of the creative.
`third_party_url`	`int` The VAST tag URL string, as seen in Google products.
`video_message`	`struct` Multipart identifier for video data.
`video_message.video_ad_duration`	`int` Duration of the video in milliseconds.
`video_message.youtube_video_id`	`string` Video id string representation as it appears on YouTube watch url.

Google Ads creative conversions

google_ads_creative_conversions
`click_id`	`struct` Unique identifier for click has multiple parts. Joins with click_id in any adh.google_ads table.
`click_id.process_id`	`int` Integer that identifies the process on the machine that generated the event.
`click_id.server_ip`	`int` The IPv4 address of the server that generated this event.
`click_id.time_usec`	`int` The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
`conversion_id`	`struct` Unique identifier for conversion has multiple parts.
`conversion_id.process_id`	`int` Integer that identifies the process on the machine that generated the event.
`conversion_id.server_ip`	`int` The IPv4 address of the server that generated this event.
`conversion_id.time_usec`	`int` The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
`conversion_type`	`int` The type of conversion.
`impression_data.ad_group_creative_id`	`int` ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table.
`impression_data.adgroup_id`	`int` ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table.
`impression_data.campaign_id`	`int` Unique ID of the campaign.
`impression_data.customer_id`	`int` ID of Google Ads customer. Joins with customer_id in any adh.google_ads table.
`impression_id`	`string` Unique identifier for impression.
`label`	`string` Name of conversion event.
`query_id`	`struct` Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
`query_id.process_id`	`int` Integer that identifies the process on the machine that generated the event.
`query_id.server_ip`	`int` The IPv4 address of the server that generated this event.
`query_id.time_usec`	`int` The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
`user_id`	`opaque` User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

Google Ads creative vendor metadata

google_ads_creative_vendor_metadata
`creative_id`	`int` The Creative ID in Campaign Manager 360 UI.
`legacy_pixel`	`string`
`vendor_string`	`string`

Google Ads customer

google_ads_customer
`customer_company_name`	`string` Company name.
`customer_id`	`int` Google Ads account ID. Joins with customer_id in any adh.google_ads table.
`customer_name`	`string` Google Ads account name.
`customer_timezone`	`string` Google Ads account setting for time zone.
`external_customer_id`	`int` Google Ads account ID.
`mcc_ids`	`array` My Client Center: dashboard view in Google Ads that is provided to large advertisers and third-party agencies who manage and optimize multiple Google Ads accounts.

Google Ads impressions

google_ads_impressions
`ad_group_creative_id`	`int` ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table.
`adgroup_id`	`int` ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table.
`browser`	`string` Possible values are: "Chrome", "Cobalt", "Dalvik", "Edge", "Firefox", "IE", "Opera", "Other", "Safari", "Samsung Browser", "Roku", "Silk", "Unknown", "Yandex"
`campaign_id`	`int` Unique ID of the campaign.
`content_url`	`string` URL of the page on which ad appeared. Part of the url is removed for privacy.
`customer_id`	`int` ID of Google Ads customer.Joins with customer_id in any adh.google_ads table.
`device_height`	`int` Device height in px.
`device_width`	`int` Device width in px.
`impression_id`	`string` Unique identifier for impression.
`inventory_type`	`enum` The inventory type. Possible values: YOUTUBE, YOUTUBE TV, YOUTUBE_MUSIC, SEARCH, GMAIL, OTHER. Other refers to either the Google Display or Video network.
`is_app_traffic`	`boolean` true if the event happened in a native app. FALSE if the event happened in HTML5 app or webview.
`location`	`struct` Unique identifier for location has multiple parts
`location.country`	`string`
`location.geo_city_id`	`int` Code for city. Joins with city_id in adh.city table.
`location.geo_metro`	`int` Code for metro region. Joins with metro_id in adh.metro table.
`location.geo_region`	`string` Region as string e.g. US-CA.
`mobile_browser_class`	`int` Type of device. Possible values are: desktop, tablet, smart tv consoles, or mobile. Joins with mobile_browser_class_id in adh.mobile_browser_class table.
`num_active_view_eligible_impression`	`int` 1 when impression is active view eligible; 0 when impression is not active view eligible.
`num_active_view_measurable_impression`	`int` 1 when impression is active view measurable; 0 when impression is not active view measurable.
`operating_system`	`string` Possible values are: "Android", "AppleTV", "Chrome OS", "Fire OS", "Google TV", "iOS", "Linux", "Mac", "Unknown", "PlayStation", "Roku", "Tizen", "Xbox", "Windows", "Windows Phone"
`operating_system_version_ids`	`array` (Deprecated) Use operating_system instead. ID of OS. Joins with operating_system_version_id in adh.os_version table.
`physical_screen_height`	`int` Device screen height in mm.
`physical_screen_width`	`int` Device screen width in mm.
`publisher_domain`	`string` Domain of the page on which ad appeared.
`query_id`	`struct` Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
`query_id.process_id`	`int` The processing ID.
`query_id.server_ip`	`int` The IPv4 address of the server that generated this event.
`query_id.time_usec`	`int` The query time in microseconds.
`query_language`	`string` Language used by user.
`user_id`	`opaque` User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

Google Ads label

google_ads_label
`customer_id`	`int` Joins with customer_id in any adh.google_ads table.
`description`	`string` Label description.
`label_id`	`int64` Label ID. Joins with label_ids in adh.google_ads tables that contain label_ids.
`label_name`	`string` Label name.
`status`	`int` Label status. 1 = ENABLED. 2 = DELETED.

Google Ads vendor reporting metadata

google_ads_vendor_reporting_data
`campaign_id`	`int` Unique ID of the campaign.
`reporting_id`	`string` Customer-provided identifier to slice their data by.
`vendor_client_id`	`string` All lower-case formatted vendor client id (VCID).
`vendor_metric`	`string` Measurement type.

Metro

metro
`country_code`	`string` Two character country code.
`metro_id`	`int` Metro identifier.
`metro_name`	`string` Metro name.

Mobile app info

mobile_app_info
`app_id`	`string` Numerical identifier for the app's ID. Combined with the app_store_id, users can look up more information about the app. For example, 284815942 is the ID of Google's search app on Apple's App store. It only populates for Google Display Network (GDN) and Google Video Partner (GVP), which can be identified as INVENTORY_TYPE = OTHER. You can look up the app name by joining with the mobile_app_info table.
`app_name`	`string` The name of the app as it appears in the app store.
`app_store_id`	`int` Numerical identifier corresponding to the app store which the app belongs to. e.g. 1 = "Apple App Store", 2 = "Google Play", or 8 = "PlayStation Store". It only populates for Google Display Network (GDN) and Google Video Partner (GVP), which can be identified as INVENTORY_TYPE = OTHER. You can look up the app store name by joining with the mobile_app_info table.
`app_store_name`	`string` The name of the app store.

Mobile browser class

mobile_browser_class
`mobile_browser_class_id`	`int` Mobile browser class identifier.
`mobile_browser_class_name`	`string` Name of the mobile browser class.

Partner Sold - Cross Sell Active Views

partner_sold_cross_sell_active_views
`impression_id`	`string` Unique identifier for impression.
`num_active_view_viewable_impression`	`int` 1 when impression is active view eligible; 0 when impression is not active view eligible.
`query_id`	`struct` Unique identifier for query has multiple parts. Joins with query_id.
`query_id.process_id`	`int` The processing ID.
`query_id.server_ip`	`int` The processing server.
`query_id.time_usec`	`int` The query time in microseconds.
`view_id`	`struct` Unique identifier for view has multiple parts.
`view_id.process_id`	`int` The processing ID.
`view_id.server_ip`	`int` The processing server.
`view_id.time_usec`	`int` The query time in microseconds.

Partner Sold - Cross Sell clicks

partner_sold_cross_sell_clicks
`click_id`	`struct` Unique identifier for click has multiple parts. Joins with click_id.
`click_id.process_id`	`int` The processing ID.
`click_id.server_ip`	`int` The processing server.
`click_id.time_usec`	`int` The query time in microseconds.
`click_type`	`int` The click type.
`impression_id`	`string` Unique identifier for impression.
`query_id`	`struct` Unique identifier for query has multiple parts. Joins with query_id.
`query_id.process_id`	`int` The processing ID.
`query_id.server_ip`	`int` The processing server.
`query_id.time_usec`	`int` The query time in microseconds.
`user_id`	`opaque` User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

Partner Sold - Cross Sell conversions

partner_sold_cross_sell_conversions
`click_id`	`struct` Unique identifier for click has multiple parts. Joins with click_id.
`click_id.process_id`	`int` The processing ID.
`click_id.server_ip`	`int` The processing server.
`click_id.time_usec`	`int` The query time in microseconds.
`conversion_id`	`struct` Unique identifier for conversion has multiple parts.
`conversion_id.process_id`	`int` The processing ID.
`conversion_id.server_ip`	`int` The processing server.
`conversion_id.time_usec`	`int` The query time in microseconds.
`conversion_type`	`int` The conversion type.
`impression_id`	`string` Unique identifier for impression.
`label`	`string` Name of conversion event.
`query_id`	`struct` Unique identifier for query has multiple parts.
`query_id.process_id`	`int` The processing ID.
`query_id.server_ip`	`int` The processing server.
`query_id.time_usec`	`int` The query time in microseconds.
`user_id`	`opaque` User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

Partner Sold - Cross Sell creative

partner_sold_cross_sell_creative
`creative_format_type`	`string` Some formats map directly to a type. Other types have multiple formats like: html, image, or video.
`creative_id`	`int` The ID of the creative.
`creative_name`	`string` Name of the creative.
`creative_type`	`string` The type of creative.
`third_party_vast_url`	`string` VAST url of the creative if the creative is a third party hosted video. Does not support creatives from programmatic items.
`video_message`	`struct` Multipart identifier for video data.
`video_message.video_ad_duration`	`int` Duration of the video in milliseconds.
`video_message.youtube_video_id`	`string` Video id string representation as it appears on YouTube watch url.

Partner Sold - Cross Sell creative pixels

partner_sold_cross_sell_creative_pixels
`ad_id`	`string` Unique ID of the ad.
`pixel_url`	`string` The pixel URL.

Partner Sold - Cross Sell impressions

partner_sold_cross_sell_impressions
`browser`	`string` Possible values are: "Chrome", "Cobalt", "Dalvik", "Edge", "Firefox", "IE", "Opera", "Other", "Safari", "Samsung Browser", "Roku", "Silk", "Unknown", "Yandex"
`content_url`	`string` URL of the page on which ad appeared. Part of the url is removed for privacy.
`creative_id`	`int` Joins with creative_id in any adh.yt table.
`device_height`	`int` Device height in pixels.
`device_width`	`int` Device width in pixels.
`gfp_placements`	`array` Ad Manager placement ID for this impression. Does not represent Campaign Manager 360 placement.
`impression_id`	`string` Unique identifier for impression.
`inventory_type`	`enum` The inventory type. Possible values: YOUTUBE, YOUTUBE TV, SEARCH, GMAIL, OTHER. Other refers to either the Google Display or Video network.
`line_item_id`	`int` Line item id for this impression.
`location`	`struct` Unique identifier for location has multiple parts.
`location.country`	`string` Code for country.
`location.geo_city_id`	`int` Code for city. Joins with city_id in adh.city table.
`location.geo_metro`	`int` Code for metrio region. Joins with metro_id in adh.metro table.
`location.geo_region`	`string` Region as a string (e.g. US-CA)
`mobile_browser_class`	`int` Type of device. Possible values are: desktop, tablet, smart tv consoles, or mobile. Joins with mobile_browser_class_id in adh.mobile_browser_class table.
`num_active_view_eligible_impression`	`int` 1 when impression is active view eligible; 0 when impression is not active view eligible.
`num_active_view_measurable_impression`	`int` 1 when impression is active view measurable; 0 when impression is not active view measurable.
`operating_system`	`string` Possible values are: "Android", "AppleTV", "Chrome OS", "Fire OS", "Google TV", "iOS", "Linux", "Mac", "Unknown", "PlayStation", "Roku", "Tizen", "Xbox", "Windows", "Windows Phone"
`order_id`	`int` Order ID for the impression.
`physical_screen_height`	`int` Device height in mm.
`physical_screen_width`	`int` Device screen width in mm.
`publisher_domain`	`string` Domain of page on which ad appeared.
`query_id`	`struct` Unique identifier for query has multiple parts.
`query_id.process_id`	`int` The processing ID.
`query_id.server_ip`	`int` The processing server.
`query_id.time_usec`	`int` The query time in microseconds.
`query_language`	`string` Language used by user.
`user_id`	`opaque` User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

Partner Sold - Cross Sell line item

partner_sold_cross_sell_lineitem
`end_time`	`timestamp` Time the line item stopped being served.
`line_item_id`	`int` Ad Manager line item serving.
`line_item_name`	`string` Ad Manager line item name.
`order_id`	`int` Ad Manager Order identifier used for serving.
`order_name`	`string` Name of the insertion order.
`programmatic`	`boolean` true if the line item was programmatic.
`skippable_ad_type`	`string` Possible values are: "skippable", "not skippable", or "selectable".
`start_time`	`timestamp` Time the line item started to be served.

Partner Sold - Cross Sell order

partner_sold_cross_sell_order
`advertiser_id`	`int` Unique ID of the advertiser.
`advertiser_name`	`string` Publisher entered name.
`advertiser_timezone`	`string` The Partner Sold time zone default in the Ad Manager network settings.
`network_code`	`int` Ad Manager Publisher network code.
`order_id`	`int` Ad Manager Order identifier used for serving.
`order_name`	`string` Name of Ad Manager order.

Partner Sold - Cross Sell vendor reporting data.

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

Region

region
`country_code`	`string` Two character country code.
`region_id`	`int` Region identifier.
`region_name`	`string` Region name.

YouTube Reserve Active Views

yt_reserve_active_views
`impression_data.creative_id`	`int` The ID of the creative.
`impression_data.line_item_id`	`int` Line item id for this impression.
`impression_data.media_plan_id`	`int` ID of the YouTube Reserve media plan.
`impression_data.order_id`	`int`
`impression_id`	`string` Unique identifier for impression.
`num_active_view_viewable_impression`	`int` 1 when impression is active view viewable; 0 when impression is not active view viewable.
`query_id`	`struct` Unique identifier for query has multiple parts.
`query_id.process_id`	`int` Integer that identifies the process on the machine that generated the event.
`query_id.server_ip`	`int` The IPv4 address of the server that generated this event.
`query_id.time_usec`	`int` The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
`view_id`	`struct` Unique identifier for view has multiple parts.
`view_id.process_id`	`int` Integer that identifies the process on the machine that generated the event.
`view_id.server_ip`	`int` The IPv4 address of the server that generated this event.
`view_id.time_usec`	`int` The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.

YouTube Reserve clicks

yt_reserve_clicks
`click_id`	`struct` Unique identifier for click has multiple parts.
`click_id.process_id`	`int` Integer that identifies the process on the machine that generated the event.
`click_id.server_ip`	`int` The IPv4 address of the server that generated this event.
`click_id.time_usec`	`int` The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
`click_type`	`int` The click type.
`impression_data.creative_id`	`int` The ID of the creative.
`impression_data.line_item_id`	`int` Line item id for this impression.
`impression_data.media_plan_id`	`int` ID of the YouTube Reserve media plan.
`impression_data.order_id`	`int`
`impression_id`	`string` Unique identifier for impression.
`query_id`	`struct` Unique identifier for query has multiple parts.
`query_id.process_id`	`int` Integer that identifies the process on the machine that generated the event.
`query_id.server_ip`	`int` The IPv4 address of the server that generated this event.
`query_id.time_usec`	`int` The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
`user_id`	`opaque` User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

YouTube Reserve conversions

yt_reserve_conversions
`click_id`	`struct` Unique identifier for click has multiple parts.
`click_id.process_id`	`int` Integer that identifies the process on the machine that generated the event.
`click_id.server_ip`	`int` The IPv4 address of the server that generated this event.
`click_id.time_usec`	`int` The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
`conversion_id`	`struct` Unique identifier for conversion has multiple parts.
`conversion_id.process_id`	`int` Integer that identifies the process on the machine that generated the event.
`conversion_id.server_ip`	`int` The IPv4 address of the server that generated this event.
`conversion_id.time_usec`	`int` The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
`conversion_type`	`int` The type of conversion.
`impression_data.creative_id`	`int` The ID of the creative.
`impression_data.line_item_id`	`int` Line item id for this impression.
`impression_data.media_plan_id`	`int` ID of the YouTube Reserve media plan.
`impression_data.order_id`	`int`
`impression_id`	`string` Unique identifier for impression.
`label`	`string` Name of conversion event.
`query_id`	`struct` Unique identifier for query has multiple parts.
`query_id.process_id`	`int` Integer that identifies the process on the machine that generated the event.
`query_id.server_ip`	`int` The IPv4 address of the server that generated this event.
`query_id.time_usec`	`int` The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
`user_id`	`opaque` User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

YouTube Reserve creative

yt_reserve_creative
`creative_format_type`	`string` Some formats map directly to a type. Other types have multiple formats like: html, image, or video.
`creative_id`	`int` The ID of the creative.
`creative_name`	`string` Name of the creative.
`creative_type`	`string` The type of creative.
`dcm_beacons`	`array` Multipart identifier for Campaign Manager 360 tracking pixel for ad.
`is_masthead`	`boolean` True if this is a masthead creative.
`skippable_ad_type`	`string` Possible values are: "SKIPPABLE", "NOT_SKIPPABLE", "UNKNOWN", or "OTHER".
`third_party_vast_url`	`string` VAST url of the creative if the creative is a third party hosted video. Doesn't support creatives from programmatic items. Formatting doesn't match dv360_youtube_creative.third_party_vast_url
`video_message`	`struct` Multipart identifier for video data.
`video_message.video_ad_duration`	`int` Duration of the video in milliseconds.
`video_message.youtube_channel_id`	`string` Id of the channel that provides this video.
`video_message.youtube_video_id`	`string` Video id string representation as it appears on YouTube watch url.

YouTube Reserve creative conversions

yt_reserve_creative_conversions
`click_id`	`struct` Unique identifier for click has multiple parts.
`click_id.process_id`	`int` Integer that identifies the process on the machine that generated the event.
`click_id.server_ip`	`int` The IPv4 address of the server that generated this event.
`click_id.time_usec`	`int` The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
`conversion_id`	`struct` Unique identifier for conversion has multiple parts.
`conversion_id.process_id`	`int` Integer that identifies the process on the machine that generated the event.
`conversion_id.server_ip`	`int` The IPv4 address of the server that generated this event.
`conversion_id.time_usec`	`int` The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
`conversion_type`	`int` The type of conversion.
`impression_data.creative_id`	`int` ID of the creative.
`impression_data.line_item_id`	`int` Line item ID for this impression.
`impression_data.media_plan_id`	`int` ID of the YouTube Reserve media plan.
`impression_data.order_id`	`int` ID of Display and Video 360 customer. Joins with customer_id in any adh.dv360 table.
`label`	`string` Name of conversion event.
`query_id`	`struct` Unique identifier for query has multiple parts.
`query_id.process_id`	`int` Integer that identifies the process on the machine that generated the event.
`query_id.server_ip`	`int` The IPv4 address of the server that generated this event.
`query_id.time_usec`	`int` The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
`user_id`	`opaque` User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

YouTube Reserve impressions

yt_reserve_impressions
`browser`	`string` Possible values are: "Chrome", "Cobalt", "Dalvik", "Edge", "Firefox", "IE", "Opera", "Other", "Safari", "Samsung Browser", "Roku", "Silk", "Unknown", "Yandex"
`content_url`	`string` URL of the page on which ad appeared. Part of the url is removed for privacy.
`creative_id`	`int` The ID of the creative.
`device_height`	`int` Device height in px.
`device_width`	`int` Device width in px.
`impression_id`	`string` Unique identifier for impression.
`inventory_type`	`enum` The inventory type. Possible values: YOUTUBE, YOUTUBE TV, YOUTUBE_MUSIC, SEARCH, GMAIL, OTHER. Other refers to either the Google Display or Video network.
`is_app_traffic`	`boolean` true if the event happened in a native app. FALSE if the event happened in HTML5 app or webview.
`line_item_id`	`int` Line item id for this impression.
`location`	`struct` Unique identifier for location, which has multiple parts: geo_city_id, geo_metro, geo_region.
`location.country`	`string` Two-letter code for country, for example "US".
`location.geo_city_id`	`int` Code for city. Joins with city_id in adh.city table.
`location.geo_metro`	`int` Code for metro region. Joins with metro_id in adh.metro table.
`location.geo_region`	`string` Region as string, e.g. US-CA.
`media_plan_id`	`int` ID of the YouTube Reserve media plan.
`mobile_browser_class`	`int` Type of device. Possible values are: desktop, tablet, smart tv consoles, or mobile. Joins with mobile_browser_class_id in adh.mobile_browser_class table.
`num_active_view_eligible_impression`	`int` 1 when impression is active view eligible; 0 when impression is not active view eligible.
`num_active_view_measurable_impression`	`int` 1 when impression is active view measurable; 0 when impression is not active view measurable.
`operating_system`	`string` Possible values are: "Android", "AppleTV", "Chrome OS", "Fire OS", "Google TV", "iOS", "Linux", "Mac", "Unknown", "PlayStation", "Roku", "Tizen", "Xbox", "Windows", "Windows Phone"
`order_id`	`int` ID of the Google Ad Manager order.
`physical_screen_height`	`int` Device screen height in mm.
`physical_screen_width`	`int` Device screen width in mm.
`publisher_domain`	`string` Domain of page on which ad appeared.
`query_id`	`struct` Unique identifier for query, which has multiple parts: process_id, server_ip, time_usec.
`query_id.process_id`	`int` ID of the process on the machine that generated the event.
`query_id.server_ip`	`int` IP address of the server that generated the event.
`query_id.time_usec`	`int` The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
`query_language`	`string` Language used by user.
`user_id`	`opaque` User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

YouTube Reserve line item

yt_reserve_lineitem
`creative_id`	`array` Array of creative ids for this line item. Joins with creative_id in any adh.yt table.
`end_time`	`timestamp` Time the line item stopped being served.
`line_item_id`	`int` Ad Manager line item serving.
`line_item_name`	`string` Ad Manager line item name.
`order_id`	`int` Ad Manager Order identifier used for serving.
`order_name`	`string` Name of the insertion order.
`programmatic`	`boolean` true if the line item was programmatic.
`start_time`	`timestamp` Time the line item started to be served.

YouTube Reserve order

yt_reserve_order
`advertiser_id`	`int` Unique ID of the advertiser.
`advertiser_name`	`string` User entered name of the advertiser.
`advertiser_timezone`	`string` The YouTube Reserve advertiser time zone default set in account settings.
`media_plan_id`	`int` ID of the YouTube Reserve media plan.
`media_plan_name`	`string` Name of the YouTube Reserve media plan.
`order_id`	`int` Ad Manager Order identifier used for serving.
`order_name`	`string` Name of Ad Manager order

YouTube Reserve vendor reporting metadata

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