Ads Data Hub table schema - Publishers

Ad Manager 360 auctions

am360_auctions
`bid`	`struct` A repeated field describing each of the bids into the AdX auction.
`bid.bidder_name`	`string` The name of the bidder account's buyer network or the name of the third-party exchange that placed this bid.
`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 under the publisher's control), 'No consent' (rejected due to lack of user consent for the vendor), 'Publisher blocked' (rejected due to publisher settings, such as product category filtering), 'Unidentified vendor'(rejected due to unidentifiable GDPR ad technology provider), 'Optimized pricing' (rejected due to reserve price optimization), 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.bidder_name`	`string` The name of the bidder account's buyer network or the name of the third-party exchange that filled the ad.
`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.inventory_format`	`bool` The name of the format of the inventory being requested. One of 'Native Custom Rendering', 'In-stream Video', 'In-stream Audio', 'Interstitial', 'Rewarded', 'Rewarded Interstitial', 'App Open', 'Banner', or 'Anchor'. Null if unspecified.
`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.bidder_name`	`string` The name of the bidder account's buyer network or the name of the third-party exchange that filled the ad.
`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.inventory_format`	`bool` The name of the format of the inventory being requested. One of 'Native Custom Rendering', 'In-stream Video', 'In-stream Audio', 'Interstitial', 'Rewarded', 'Rewarded Interstitial', 'App Open', 'Banner', or 'Anchor'. Null if unspecified.
`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.bidder_name`	`string` The name of the bidder account's buyer network or the name of the third-party exchange that filled the ad.
`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.inventory_format`	`bool` The name of the format of the inventory being requested. One of 'Native Custom Rendering', 'In-stream Video', 'In-stream Audio', 'Interstitial', 'Rewarded', 'Rewarded Interstitial', 'App Open', 'Banner', or 'Anchor'. Null if unspecified.
`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.bidder_name`	`string` The name of the bidder account's buyer network or the name of the third-party exchange that filled the ad.
`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.inventory_format`	`bool` The name of the format of the inventory being requested. One of 'Native Custom Rendering', 'In-stream Video', 'In-stream Audio', 'Interstitial', 'Rewarded', 'Rewarded Interstitial', 'App Open', 'Banner', or 'Anchor'. Null if unspecified.
`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.inventory_format`	`bool` The name of the format of the inventory being requested. One of 'Native Custom Rendering', 'In-stream Video', 'In-stream Audio', 'Interstitial', 'Rewarded', 'Rewarded Interstitial', 'App Open', 'Banner', or 'Anchor'. Null if unspecified.
`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.