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. |