Ads Data Hub table schema- Advertisers

Affinity segment

affinity
affinity_category	string Affinity category.
affinity_id	int Affinity identifier.
affinity_name	string Affinity name.

Age group

age_group
age_group_id	int Age group identifier.
age_group_name	string Age group name.

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 under publisher's control), 'No consent' (rejected due to lack of user consent for the vendor), 'Publisher blocked' (rejected due to publisher settings, such as product category filtering), 'Unidentified vendor'(rejected due to unidentifiable GDPR ad technology provider), 'Optimized pricing'(rejected due to reserve price optimization), or 'Other' (rejected for some other reason).
bid.source	string The source of this bid. Can either be 'Ad Exchange' (a bid from an authorized buyer) or 'Open Bidding' (a bid from a third-party exchange).
bid.upr_floor_cpm	double The unified pricing rule-based floor price that applied to this bid.
bid.yield_group_ids	int The IDs of the yield groups that allowed this source of demand to place this bid.
bid.yield_partner_id	int The ID of the company placing this bid. Joins to am360_match_company.company_id.
event_time_usec	timestamp The timestamp of the specific event.
metadata	struct A group of fields containing metadata about the event.
metadata.child_network_code	string Identifies the Multiple Customer Management (MCM) child network who operates the property requesting the ad.
metadata.event_id	string A unique ID for this event across all tables.
metadata.network_code	string Identifies the publisher network that controls the inventory being filled by the ad query.
metadata.request_id	string An identifier shared by all events related to a request to fill a single ad block (aka ad slot). Shared among all queries and later events related to a Single Request Architecture (SRA) or Video Pod request.
request_time_usec	timestamp The timestamp of the initial request to Google that became the ad query.
user_id	string Google-assigned ID of the browser that sent the ad event. Cannot be extracted.
user_ppid	string Encoded Publisher Provided ID (PPID) from the ad query. Cannot be decoded. Cannot be extracted.

Ad Manager 360 conversions

am360_conversions
activity_id	int The ID of the activity that was performed, from the Spotlight tag.
activity_trigger	string The user action that led to this activity. One of 'Impression' or 'Click'.
click_id	string The ID of the click that led to this activity, if there was one. Joins to am360_interactions.metadata.event_id.
delivery	struct A group of fields describing the ad delivered to fill the query.
delivery.advertiser_company_id	int The ID of the company associated with this order. Can also be found through the order metadata table. Reservation-only. Joins to am360_match_company.company_id.
delivery.auction_id	string If an auction ran to fill the creative serve related to this event, the ID of the auction record. Joins to am360_auctions.metadata.event_id.
delivery.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.

Campaign Manager 360 Data Transfer account info

cm_dt_account_info
account_id	int Unique ID of the account.
timezone_name	string Timezone of the account.

Campaign Manager 360 Data Transfer Active View plus

cm_dt_active_view_plus
event	struct
event.active_view_audible_impressions	int Active View: Impressions Audible
event.active_view_audible_time_msec	int Active View: Play Time Audible (milliseconds)
event.active_view_audible_visible_time_msec	int Active View: Play Time Audible and Visible (milliseconds)
event.active_view_background_count	int Active View: Impressions In Background
event.active_view_complete_viewable_impressions	int Active View: Impressions Visible at Completion
event.active_view_eligible_impressions	int Whether the impression was eligible to measure viewability. An impression is eligible if (a) the ad's creative has an Active View tag and (b) the tag successfully communicates with Google Marketing Platform servers at the time of the impression.
event.active_view_first_quartile_viewable_audible_impressions	int Active View: Impressions Visible and Audible at First Quartile
event.active_view_first_quartile_viewable_impressions	int Active View: Impressions Visible at First Quartile
event.active_view_fullscreen_count	int Active View: Impressions Full-Screen
event.active_view_impressions_audible_and_visible_at_completion	int Active View: Impressions Audible and Visible at Completion
event.active_view_impressions_visible10_seconds	int Active View: Impressions Visible 10 Seconds
event.active_view_measurable_impressions	int Whether the impression was measurable with Active View.
event.active_view_midpoint_viewable_audible_impressions	int Active View: Impressions Visible and Audible at Midpoint
event.active_view_midpoint_viewable_impressions	int Active View: Impressions Visible at Midpoint
event.active_view_plus_measurable_count	int Active View Plus: Measurable Impressions
event.active_view_start_viewable_audible_impressions	int Active View: Impressions Visible and Audible at Start
event.active_view_start_viewable_impressions	int Active View: Impressions Visible at Start
event.active_view_third_quartile_viewable_audible_impressions	int Active View: Impressions Visible and Audible at Third Quartile
event.active_view_third_quartile_viewable_impressions	int Active View: Impressions Visible at Third Quartile
event.active_view_tos_msec	int Active View: Time on Screen (milliseconds)
event.active_view_viewable_impressions	int Whether the impression was viewable.
event.active_view_visible_time_msec	int Active View: Video Visible Time (milliseconds)
event.activity_count	int Activity Quantity
event.activity_id	int The ID of the Floodlight tag related to the conversion event.
event.ad_id	int Unique ID of the ad placement.
event.advertiser_id	int Unique ID of the advertiser
event.browser_platform_id	string ID of the browser type.
event.browser_version	string Browser/Platform Version
event.campaign_id	int The unique ID of the Campaign Manager 360 campaign
event.city_id	int City ID
event.conversion_id	int Indicates whether an activity has been matched as a post-click (value of 1) or post-impression (value of 2), or unmatched (value of 0).
event.country_code	string Country
event.creative_version	string Creative version number.
event.dma_region_id	int Designated Market Area ID (US/Canada).
event.dv360_ad_position	int Specifies the position of the ad on the page if known. 1 represents above the fold, 2 represents below the fold.
event.dv360_advertiser_id	int The Display & Video 360 numerical ID for the advertiser related to the event, for example 164332.
event.dv360_adx_page_categories	string DV360 Adx Page Categories
event.dv360_attributed_inventory_source_external_id	string The external ID of the attributed inventory source that Display & Video 360 selected as the best match from those accessible to the advertiser related to the view event based on floor price and auction type.
event.dv360_attributed_inventory_source_is_public	string True if inventory source is available to all buyers. False otherwise.
event.dv360_auction_id	string A string used to join events among view/click/conversion types, for example"ABCDEFGH_abcdefgh-0123456789". Do not assume any ordering, structure or meaning to the auction_id value.
event.dv360_bid_price_advertiser_currency	int The bid price sent to the exchange in advertiser currency nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics.
event.dv360_bid_price_partner_currency	int The bid price sent to the exchange in partner currency nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics.
event.dv360_bid_price_usd	int The bid price sent to the exchange in USD nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics..
event.dv360_billable_cost_advertiser_currency	int The total amount of money billed to the partner, including the media cost and partner costs, in advertiser currency nanos.
event.dv360_billable_cost_partner_currency	int The total amount of money billed to the partner, including the media cost and partner costs, in partner currency nanos.
event.dv360_billable_cost_usd	int The total amount of money billed to the partner, including the media cost and partner costs, in USD nanos.
event.dv360_browser_timezone_offset_minutes	int The difference in minutes between the active timezone on the user's browser and GMT-12, for example 1320 represents a browser timezone of GMT+10.
event.dv360_campaign_id	int The unique ID of the linked Display & Video 360 campaign.
event.dv360_city_id	int The Display & Video 360 numerical ID identifying the best-guess city of the impression.
event.dv360_country_code	string 2-letter ISO 3166-1 country code identifying the best-guess country of the impression, for example "US".
event.dv360_cpm_fee_1_advertiser_currency	int
event.dv360_cpm_fee_1_partner_currency	int
event.dv360_cpm_fee_1_usd	int
event.dv360_cpm_fee_2_advertiser_currency	int
event.dv360_cpm_fee_2_partner_currency	int
event.dv360_cpm_fee_2_usd	int
event.dv360_cpm_fee_3_advertiser_currency	int
event.dv360_cpm_fee_3_partner_currency	int
event.dv360_cpm_fee_3_usd	int
event.dv360_cpm_fee_4_advertiser_currency	int
event.dv360_cpm_fee_4_partner_currency	int
event.dv360_cpm_fee_4_usd	int
event.dv360_cpm_fee_5_advertiser_currency	int
event.dv360_cpm_fee_5_partner_currency	int
event.dv360_cpm_fee_5_usd	int
event.dv360_creative_id	int The Display & Video 360 numerical ID for the creative related to the event, for example 367487.
event.dv360_data_fees_advertiser_currency	int
event.dv360_data_fees_partner_currency	int
event.dv360_data_fees_usd	int
event.dv360_device_type	int The numerical value of the identified device type. 0 = Computer, 1 = Other, 2 = Smart Phone, 3 = Tablet, 4 = Smart TV, 5 = Connected TV, 6 = Set Top Box, 7 = Connected Device.
event.dv360_exchange_id	string The Display & Video 360 numerical ID for the exchange that requested the ad.
event.dv360_insertion_order_id	int The Display & Video 360 numerical ID for the insertion order related to the event, for example 1079941.
event.dv360_isp_id	int The Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.
event.dv360_language	string The ISO-639-1 code or "zh_CN" (Chinese (simplified)), "zh_TW" (Chinese (traditional)) or "other" representing the language related to the view event.
event.dv360_line_item_id	int The Display & Video 360 numerical ID for the line item related to the event, for example 1155785.
event.dv360_matching_targeted_keywords	string A comma separated string containing a list of targeted keywords matching the page related to the view event, for example "apple,orange,banana". Although the page related to the view event may match many keywords, only those which were targeted will be included; if the list of keywords is large we may impose a limit to the number of keywords returned.
event.dv360_matching_targeted_segments	string Space-separated IDs of targeted user lists that match the visitor, for example "-4 456". If the visitor is in a user list that is not targeted by the ad associated with this event it will not be included here.
event.dv360_media_cost_advertiser_currency	int The amount paid for the impression in advertiser currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
event.dv360_media_cost_partner_currency	int The amount paid for the impression in the partner currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
event.dv360_media_cost_usd	int The amount paid for the impression in USD nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
event.dv360_media_fee_1_advertiser_currency	int
event.dv360_media_fee_1_partner_currency	int
event.dv360_media_fee_1_usd	int
event.dv360_media_fee_2_advertiser_currency	int
event.dv360_media_fee_2_partner_currency	int
event.dv360_media_fee_2_usd	int
event.dv360_media_fee_3_advertiser_currency	int
event.dv360_media_fee_3_partner_currency	int
event.dv360_media_fee_3_usd	int
event.dv360_media_fee_4_advertiser_currency	int
event.dv360_media_fee_4_partner_currency	int
event.dv360_media_fee_4_usd	int
event.dv360_media_fee_5_advertiser_currency	int
event.dv360_media_fee_5_partner_currency	int
event.dv360_media_fee_5_usd	int
event.dv360_mobile_make_id	int The numerical ID for the mobile make. This value may be missing.
event.dv360_mobile_model_id	int The numerical ID for the mobile model. This value may be missing.
event.dv360_net_speed	int The Display & Video 360 numerical ID representing the network speed related to the view event. 1=Dial-up, 2=EDGE/2G, 3=UMTS/3G, 4=Basic DSL, 5=HSDPA/3.5G, 6=Broadband/4G, 7=Unknown.
event.dv360_operating_system_id	int Operating System ID.
event.dv360_request_time	int A Unix timestamp in microseconds (1/1,000,000 second) for when we received the ad request, for example1330403779608570 represents Tuesday February 28th 2012 04:36:19.608570. Although this value is consistent across the view, click and conversion even it is not guaranteed to be unique - use auction_id to join events
event.dv360_revenue_advertiser_currency	int The total amount in advertiser currency nanos made by the partner account for the view event. This value may be zero.
event.dv360_revenue_partner_currency	int The total amount in partner currency nanos made by the partner account for the view event. This value may be zero.
event.dv360_revenue_usd	int The total amount in USD nanos made by the partner account for the view event. This value may be zero.
event.dv360_site_id	int The Display & Video 360 numerical ID for the most specific universal site that matches the url.
event.dv360_state_region_id	int DV360 Region ID
event.dv360_url	string The raw URL taken from the bid request received from the exchange, for example "http://www.example.com". As some exchanges mask the URL in their bid requests this value may be: "source_url_hidden"
event.dv360_view_state	string Populated for wrapped tags. (Two impression records when both events occur.) Possible values are: "OUTER", DV360 returned wrapped tag; "INNER", ad served post wrapped tag; "3PAS_MERGED", wrapped tag tracked by CM; "3PAS_OUTER", tracking ping sent to CM but no response, 3rd party blocked ad serving.
event.dv360_zip_postal_code	string DV360 ZIP/Postal Code
event.event_sub_type	string Contains further details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "POSTVIEW", "POSTCLICK" or blank for conversion events.
event.event_time	int Time in microseconds since 1970-01-01 00:00:00 UTC.
event.event_type	string Contains "VIDEO_ACTIVE_VIEW_SESSION".
event.floodlight_config_id	int Unique ID of the floodlight configuration.
event.impression_id	string Impression ID
event.interaction_time_utc_seconds	string Interaction Time
event.landing_page_url_id	int Unique ID of the landing page URL.
event.operating_system_id	int ID of the operating system.
event.ord_value	string The advertiser's ordinal ID, if relevant for a given activity type. Passed in the 'ord=' key-value (also used for storing the client's Order-ID in sales tags)
event.other_data	string Stores key-value data from the activity string which is not otherwise labeled. (Any key-value that is NOT "src=", "type=", "cat=", "ord=", "u=", "cost=", "qty=", "tran=", "a=", or "b="). (Can be used for further product breakdown aka "Custom Floodlight Variables")
event.placement_id	int Unique ID for the site page / placement where the ad ran.
event.platform_type_id	int Identifier that maps to the platform on which the event occured. Possible values are: 30000: desktop, 30001: high-end smartphone, 30002: tablet, 30003: mid-range smartphone, 30004: connected TV, 30005: unknown, 30006: set top box.
event.rendering_id	int Unique ID of the creative for Data Transfer. Does not correspond to the UI-Creative-ID.
event.rich_media_event_counters	int MET Counter Value (the ecn= value).
event.rich_media_event_id	int MET Event ID for the Rich Media ad.
event.rich_media_event_timers	double Time in microseconds since 1970-01-01 00:00:00 UTC.rs
event.rich_media_event_type_id	int ID of Rich Media Event Type.
event.segment_value_1	int Segment Value 1
event.site_id	int Unique ID for the site where the ad ran.
event.state	string ID for user's state or province (US/Canada)
event.tran_value	string TRAN Value
event.u_value	string U Value
event.zip_code	string Postal-Code (US/Canada).
network_id	int The network ID.
user_id	opaque The tracking ID (it is based on, but does not expose the user's browser cookie or mobile device ID). This field may be zeroed out for privacy reasons. User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

Campaign Manager 360 Data Transfer activities (deprecated)

cm_dt_activities
device_id_md5	string MD5-hashed device ID; a utility may be provided to hash raw device IDs to match.
event	struct
event.active_view_audible_impressions	int Active View: Impressions Audible
event.active_view_audible_time_msec	int Active View: Play Time Audible (milliseconds)
event.active_view_audible_visible_time_msec	int Active View: Play Time Audible and Visible (milliseconds)
event.active_view_background_count	int Active View: Impressions In Background
event.active_view_complete_viewable_impressions	int Active View: Impressions Visible at Completion
event.active_view_eligible_impressions	int Whether the impression was eligible to measure viewability. An impression is eligible if (a) the ad's creative has an Active View tag and (b) the tag successfully communicates with Google Marketing Platform servers at the time of the impression.
event.active_view_first_quartile_viewable_audible_impressions	int Active View: Impressions Visible and Audible at First Quartile
event.active_view_first_quartile_viewable_impressions	int Active View: Impressions Visible at First Quartile
event.active_view_fullscreen_count	int Active View: Impressions Full-Screen
event.active_view_impressions_audible_and_visible_at_completion	int Active View: Impressions Audible and Visible at Completion
event.active_view_impressions_visible10_seconds	int Active View: Impressions Visible 10 Seconds
event.active_view_measurable_impressions	int Whether the impression was measurable with Active View.
event.active_view_midpoint_viewable_audible_impressions	int Active View: Impressions Visible and Audible at Midpoint
event.active_view_midpoint_viewable_impressions	int Active View: Impressions Visible at Midpoint
event.active_view_plus_measurable_count	int Active View Plus: Measurable Impressions
event.active_view_start_viewable_audible_impressions	int Active View: Impressions Visible and Audible at Start
event.active_view_start_viewable_impressions	int Active View: Impressions Visible at Start
event.active_view_third_quartile_viewable_audible_impressions	int Active View: Impressions Visible and Audible at Third Quartile
event.active_view_third_quartile_viewable_impressions	int Active View: Impressions Visible at Third Quartile
event.active_view_tos_msec	int Active View: Time on Screen (milliseconds)
event.active_view_viewable_impressions	int Whether the impression was viewable.
event.active_view_visible_time_msec	int Active View: Video Visible Time (milliseconds)
event.activity_count	int Activity Quantity
event.activity_id	int The ID of the Floodlight tag related to the conversion event.
event.activity_revenue	double Activity Revenue
event.ad_id	int Unique ID of the ad placement.
event.advertiser_id	int Unique ID of the advertiser
event.browser_platform_id	string ID of the browser type.
event.browser_version	string Browser/Platform Version
event.campaign_id	int The unique ID of the Campaign Manager 360 campaign
event.city_id	int City ID
event.conversion_id	int Indicates whether an activity has been matched as a post-click (value of 1) or post-impression (value of 2), or unmatched (value of 0).
event.country_code	string Country
event.creative_version	string Creative version number.
event.dma_region_id	int Designated Market Area ID (US/Canada).
event.dv360_ad_position	int Specifies the position of the ad on the page if known. 1 represents above the fold, 2 represents below the fold.
event.dv360_advertiser_id	int The Display & Video 360 numerical ID for the advertiser related to the event, for example 164332.
event.dv360_adx_page_categories	string DV360 Adx Page Categories
event.dv360_attributed_inventory_source_external_id	string The external ID of the attributed inventory source that Display & Video 360 selected as the best match from those accessible to the advertiser related to the view event based on floor price and auction type.
event.dv360_attributed_inventory_source_is_public	string True if inventory source is available to all buyers. False otherwise.
event.dv360_auction_id	string A string used to join events among view/click/conversion types, for example"ABCDEFGH_abcdefgh-0123456789". Do not assume any ordering, structure or meaning to the auction_id value.
event.dv360_bid_price_advertiser_currency	int The bid price sent to the exchange in advertiser currency nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics.
event.dv360_bid_price_partner_currency	int The bid price sent to the exchange in partner currency nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics.
event.dv360_bid_price_usd	int The bid price sent to the exchange in USD nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics..
event.dv360_billable_cost_advertiser_currency	int The total amount of money billed to the partner, including the media cost and partner costs, in advertiser currency nanos.
event.dv360_billable_cost_partner_currency	int The total amount of money billed to the partner, including the media cost and partner costs, in partner currency nanos.
event.dv360_billable_cost_usd	int The total amount of money billed to the partner, including the media cost and partner costs, in USD nanos.
event.dv360_browser_id	int The Display & Video 360 numerical ID identifying the browser related to this event.
event.dv360_browser_timezone_offset_minutes	int The difference in minutes between the active timezone on the user's browser and GMT-12, for example 1320 represents a browser timezone of GMT+10.
event.dv360_campaign_id	int The unique ID of the linked Display & Video 360 campaign.
event.dv360_city_id	int The Display & Video 360 numerical ID identifying the best-guess city of the impression.
event.dv360_country_code	string 2-letter ISO 3166-1 country code identifying the best-guess country of the impression, for example "US".
event.dv360_cpm_fee_1_advertiser_currency	int
event.dv360_cpm_fee_1_partner_currency	int
event.dv360_cpm_fee_1_usd	int
event.dv360_cpm_fee_2_advertiser_currency	int
event.dv360_cpm_fee_2_partner_currency	int
event.dv360_cpm_fee_2_usd	int
event.dv360_cpm_fee_3_advertiser_currency	int
event.dv360_cpm_fee_3_partner_currency	int
event.dv360_cpm_fee_3_usd	int
event.dv360_cpm_fee_4_advertiser_currency	int
event.dv360_cpm_fee_4_partner_currency	int
event.dv360_cpm_fee_4_usd	int
event.dv360_cpm_fee_5_advertiser_currency	int
event.dv360_cpm_fee_5_partner_currency	int
event.dv360_cpm_fee_5_usd	int
event.dv360_creative_id	int The Display & Video 360 numerical ID for the creative related to the event, for example 367487.
event.dv360_data_fees_advertiser_currency	int
event.dv360_data_fees_partner_currency	int
event.dv360_data_fees_usd	int
event.dv360_device_type	int The numerical value of the identified device type. 0 = Computer, 1 = Other, 2 = Smart Phone, 3 = Tablet, 4 = Smart TV, 5 = Connected TV, 6 = Set Top Box, 7 = Connected Device.
event.dv360_exchange_id	string The Display & Video 360 numerical ID for the exchange that requested the ad.
event.dv360_insertion_order_id	int The Display & Video 360 numerical ID for the insertion order related to the event, for example 1079941.
event.dv360_isp_id	int The Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.
event.dv360_language	string The ISO-639-1 code or "zh_CN" (Chinese (simplified)), "zh_TW" (Chinese (traditional)) or "other" representing the language related to the view event.
event.dv360_line_item_id	int The Display & Video 360 numerical ID for the line item related to the event, for example 1155785.
event.dv360_matching_targeted_keywords	string A comma separated string containing a list of targeted keywords matching the page related to the view event, for example "apple,orange,banana". Although the page related to the view event may match many keywords, only those which were targeted will be included; if the list of keywords is large we may impose a limit to the number of keywords returned.
event.dv360_matching_targeted_segments	string Space-separated IDs of targeted user lists that match the visitor, for example "-4 456". If the visitor is in a user list that is not targeted by the ad associated with this event it will not be included here.
event.dv360_media_cost_advertiser_currency	int The amount paid for the impression in advertiser currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
event.dv360_media_cost_partner_currency	int The amount paid for the impression in the partner currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
event.dv360_media_cost_usd	int The amount paid for the impression in USD nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
event.dv360_media_fee_1_advertiser_currency	int
event.dv360_media_fee_1_partner_currency	int
event.dv360_media_fee_1_usd	int
event.dv360_media_fee_2_advertiser_currency	int
event.dv360_media_fee_2_partner_currency	int
event.dv360_media_fee_2_usd	int
event.dv360_media_fee_3_advertiser_currency	int
event.dv360_media_fee_3_partner_currency	int
event.dv360_media_fee_3_usd	int
event.dv360_media_fee_4_advertiser_currency	int
event.dv360_media_fee_4_partner_currency	int
event.dv360_media_fee_4_usd	int
event.dv360_media_fee_5_advertiser_currency	int
event.dv360_media_fee_5_partner_currency	int
event.dv360_media_fee_5_usd	int
event.dv360_mobile_make_id	int The numerical ID for the mobile make. This value may be missing.
event.dv360_mobile_model_id	int The numerical ID for the mobile model. This value may be missing.
event.dv360_net_speed	int The Display & Video 360 numerical ID representing the network speed related to the view event. 1=Dial-up, 2=EDGE/2G, 3=UMTS/3G, 4=Basic DSL, 5=HSDPA/3.5G, 6=Broadband/4G, 7=Unknown.
event.dv360_operating_system_id	int Operating System ID.
event.dv360_request_time	int A Unix timestamp in microseconds (1/1,000,000 second) for when we received the ad request, for example1330403779608570 represents Tuesday February 28th 2012 04:36:19.608570. Although this value is consistent across the view, click and conversion even it is not guaranteed to be unique - use auction_id to join events
event.dv360_revenue_advertiser_currency	int The total amount in advertiser currency nanos made by the partner account for the view event. This value may be zero.
event.dv360_revenue_partner_currency	int The total amount in partner currency nanos made by the partner account for the view event. This value may be zero.
event.dv360_revenue_usd	int The total amount in USD nanos made by the partner account for the view event. This value may be zero.
event.dv360_site_id	int The Display & Video 360 numerical ID for the most specific universal site that matches the url.
event.dv360_state_region_id	int DV360 Region ID
event.dv360_url	string The raw URL taken from the bid request received from the exchange, for example "http://www.example.com". As some exchanges mask the URL in their bid requests this value may be: "source_url_hidden"
event.dv360_view_state	string Populated for wrapped tags. (Two impression records when both events occur.) Possible values are: "OUTER", DV360 returned wrapped tag; "INNER", ad served post wrapped tag; "3PAS_MERGED", wrapped tag tracked by CM; "3PAS_OUTER", tracking ping sent to CM but no response, 3rd party blocked ad serving.
event.dv360_zip_postal_code	string DV360 ZIP/Postal Code
event.event_sub_type	string Contains further details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "POSTVIEW", "POSTCLICK" or blank for conversion events.
event.event_time	int Time in microseconds since 1970-01-01 00:00:00 UTC.
event.event_type	string Contains details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "CONVERSION" or blank for conversion events.
event.floodlight_config_id	int Unique ID of the floodlight configuration.
event.impression_id	string Impression ID
event.interaction_time_utc_seconds	string Interaction Time
event.landing_page_url_id	int Unique ID of the landing page URL.
event.operating_system_id	int ID of the operating system.
event.ord_value	string The advertiser's ordinal ID, if relevant for a given activity type. Passed in the 'ord=' key-value (also used for storing the client's Order-ID in sales tags)
event.other_data	string Stores key-value data from the activity string which is not otherwise labeled. (Any key-value that is NOT "src=", "type=", "cat=", "ord=", "u=", "cost=", "qty=", "tran=", "a=", or "b="). (Can be used for further product breakdown aka "Custom Floodlight Variables")
event.placement_id	int Unique ID for the site page / placement where the ad ran.
event.rendering_id	int Unique ID of the creative for Data Transfer. Does not correspond to the UI-Creative-ID.
event.rich_media_event_counters	int MET Counter Value (the ecn= value).
event.rich_media_event_id	int MET Event ID for the Rich Media ad.
event.rich_media_event_timers	double Time in microseconds since 1970-01-01 00:00:00 UTC.rs
event.rich_media_event_type_id	int ID of Rich Media Event Type.
event.segment_value_1	int Segment Value 1
event.site_id	int Unique ID for the site where the ad ran.
event.state	string ID for user's state or province (US/Canada)
event.tran_value	string TRAN Value
event.u_value	string U Value
event.zip_code	string Postal-Code (US/Canada).
network_id	int The network ID.
user_id	opaque The tracking ID (it is based on, but does not expose the user's browser cookie or mobile device ID). This field may be zeroed out for privacy reasons. User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

Campaign Manager 360 Data Transfer activities attributed

cm_dt_activities_attributed
event	struct
event.activity_id	int The ID of the Floodlight tag related to the conversion event.
event.ad_id	int Unique ID of the ad placement.
event.advertiser_id	int Unique ID of the advertiser
event.attribution_model_config_id	int Attribution model ID as displayed in CM UI.
event.browser_platform_id	string ID of the browser type.
event.browser_version	string Browser/Platform Version
event.campaign_id	int The unique ID of the Campaign Manager 360 campaign
event.city_id	int City ID
event.conversion_event_id	string Unique ID of the conversion event.
event.country_code	string Country
event.creative_version	string Creative version number.
event.dma_region_id	int Designated Market Area ID (US/Canada).
event.dv360_ad_position	int Specifies the position of the ad on the page if known. 1 represents above the fold, 2 represents below the fold.
event.dv360_advertiser_id	int The Display & Video 360 numerical ID for the advertiser related to the event, for example 164332.
event.dv360_adx_page_categories	string DV360 Adx Page Categories
event.dv360_attributed_inventory_source_external_id	string The external ID of the attributed inventory source that Display & Video 360 selected as the best match from those accessible to the advertiser related to the view event based on floor price and auction type.
event.dv360_attributed_inventory_source_is_public	string True if inventory source is available to all buyers. False otherwise.
event.dv360_auction_id	string A string used to join events among view/click/conversion types, for example"ABCDEFGH_abcdefgh-0123456789". Do not assume any ordering, structure or meaning to the auction_id value.
event.dv360_bid_price_advertiser_currency	int The bid price sent to the exchange in advertiser currency nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics.
event.dv360_bid_price_partner_currency	int The bid price sent to the exchange in partner currency nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics.
event.dv360_bid_price_usd	int The bid price sent to the exchange in USD nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics..
event.dv360_billable_cost_advertiser_currency	int The total amount of money billed to the partner, including the media cost and partner costs, in advertiser currency nanos.
event.dv360_billable_cost_partner_currency	int The total amount of money billed to the partner, including the media cost and partner costs, in partner currency nanos.
event.dv360_billable_cost_usd	int The total amount of money billed to the partner, including the media cost and partner costs, in USD nanos.
event.dv360_browser_id	int The Display & Video 360 numerical ID identifying the browser related to this event.
event.dv360_browser_timezone_offset_minutes	int The difference in minutes between the active timezone on the user's browser and GMT-12, for example 1320 represents a browser timezone of GMT+10.
event.dv360_campaign_id	int The unique ID of the linked Display & Video 360 campaign.
event.dv360_city_id	int The Display & Video 360 numerical ID identifying the best-guess city of the impression.
event.dv360_country_code	string 2-letter ISO 3166-1 country code identifying the best-guess country of the impression, for example "US".
event.dv360_cpm_fee_1_advertiser_currency	int
event.dv360_cpm_fee_1_partner_currency	int
event.dv360_cpm_fee_1_usd	int
event.dv360_cpm_fee_2_advertiser_currency	int
event.dv360_cpm_fee_2_partner_currency	int
event.dv360_cpm_fee_2_usd	int
event.dv360_cpm_fee_3_advertiser_currency	int
event.dv360_cpm_fee_3_partner_currency	int
event.dv360_cpm_fee_3_usd	int
event.dv360_cpm_fee_4_advertiser_currency	int
event.dv360_cpm_fee_4_partner_currency	int
event.dv360_cpm_fee_4_usd	int
event.dv360_cpm_fee_5_advertiser_currency	int
event.dv360_cpm_fee_5_partner_currency	int
event.dv360_cpm_fee_5_usd	int
event.dv360_creative_id	int The Display & Video 360 numerical ID for the creative related to the event, for example 367487.
event.dv360_data_fees_advertiser_currency	int
event.dv360_data_fees_partner_currency	int
event.dv360_data_fees_usd	int
event.dv360_device_type	int The numerical value of the identified device type. 0 = Computer, 1 = Other, 2 = Smart Phone, 3 = Tablet, 4 = Smart TV, 5 = Connected TV, 6 = Set Top Box, 7 = Connected Device.
event.dv360_exchange_id	string The Display & Video 360 numerical ID for the exchange that requested the ad.
event.dv360_insertion_order_id	int The Display & Video 360 numerical ID for the insertion order related to the event, for example 1079941.
event.dv360_isp_id	int The Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.
event.dv360_language	string The ISO-639-1 code or "zh_CN" (Chinese (simplified)), "zh_TW" (Chinese (traditional)) or "other" representing the language related to the view event.
event.dv360_line_item_id	int The Display & Video 360 numerical ID for the line item related to the event, for example 1155785.
event.dv360_matching_targeted_keywords	string A comma separated string containing a list of targeted keywords matching the page related to the view event, for example "apple,orange,banana". Although the page related to the view event may match many keywords, only those which were targeted will be included; if the list of keywords is large we may impose a limit to the number of keywords returned.
event.dv360_matching_targeted_segments	string Space-separated IDs of targeted user lists that match the visitor, for example "-4 456". If the visitor is in a user list that is not targeted by the ad associated with this event it will not be included here.
event.dv360_media_cost_advertiser_currency	int The amount paid for the impression in advertiser currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
event.dv360_media_cost_partner_currency	int The amount paid for the impression in the partner currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
event.dv360_media_cost_usd	int The amount paid for the impression in USD nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
event.dv360_media_fee_1_advertiser_currency	int
event.dv360_media_fee_1_partner_currency	int
event.dv360_media_fee_1_usd	int
event.dv360_media_fee_2_advertiser_currency	int
event.dv360_media_fee_2_partner_currency	int
event.dv360_media_fee_2_usd	int
event.dv360_media_fee_3_advertiser_currency	int
event.dv360_media_fee_3_partner_currency	int
event.dv360_media_fee_3_usd	int
event.dv360_media_fee_4_advertiser_currency	int
event.dv360_media_fee_4_partner_currency	int
event.dv360_media_fee_4_usd	int
event.dv360_media_fee_5_advertiser_currency	int
event.dv360_media_fee_5_partner_currency	int
event.dv360_media_fee_5_usd	int
event.dv360_mobile_make_id	int The numerical ID for the mobile make. This value may be missing.
event.dv360_mobile_model_id	int The numerical ID for the mobile model. This value may be missing.
event.dv360_net_speed	int The Display & Video 360 numerical ID representing the network speed related to the view event. 1=Dial-up, 2=EDGE/2G, 3=UMTS/3G, 4=Basic DSL, 5=HSDPA/3.5G, 6=Broadband/4G, 7=Unknown.
event.dv360_operating_system_id	int Operating System ID.
event.dv360_request_time	int A Unix timestamp in microseconds (1/1,000,000 second) for when we received the ad request, for example1330403779608570 represents Tuesday February 28th 2012 04:36:19.608570. Although this value is consistent across the view, click and conversion even it is not guaranteed to be unique - use auction_id to join events
event.dv360_revenue_advertiser_currency	int The total amount in advertiser currency nanos made by the partner account for the view event. This value may be zero.
event.dv360_revenue_partner_currency	int The total amount in partner currency nanos made by the partner account for the view event. This value may be zero.
event.dv360_revenue_usd	int The total amount in USD nanos made by the partner account for the view event. This value may be zero.
event.dv360_site_id	int The Display & Video 360 numerical ID for the most specific universal site that matches the url.
event.dv360_state_region_id	int DV360 Region ID
event.dv360_url	string The raw URL taken from the bid request received from the exchange, for example "http://www.example.com". As some exchanges mask the URL in their bid requests this value may be: "source_url_hidden"
event.dv360_view_state	string Populated for wrapped tags. (Two impression records when both events occur.) Possible values are: "OUTER", DV360 returned wrapped tag; "INNER", ad served post wrapped tag; "3PAS_MERGED", wrapped tag tracked by CM; "3PAS_OUTER", tracking ping sent to CM but no response, 3rd party blocked ad serving.
event.dv360_zip_postal_code	string DV360 ZIP/Postal Code
event.event_sub_type	string Contains further details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "POSTVIEW", "POSTCLICK" or blank for conversion events.
event.event_time	int Time in microseconds since 1970-01-01 00:00:00 UTC.
event.event_type	string Contains "CONVERSION" or "MODELED_CONVERSION" for conversion events.
event.floodlight_config_id	int Unique ID of the floodlight configuration.
event.interaction_time_utc_seconds	string Interaction Time
event.landing_page_url_id	int Unique ID of the landing page URL.
event.operating_system_id	int ID of the operating system.
event.ord_value	string The advertiser's ordinal ID, if relevant for a given activity type. Passed in the 'ord=' key-value (also used for storing the client's Order-ID in sales tags)
event.other_data	string Stores key-value data from the activity string which is not otherwise labeled. (Any key-value that is NOT "src=", "type=", "cat=", "ord=", "u=", "cost=", "qty=", "tran=", "a=", or "b="). (Can be used for further product breakdown aka "Custom Floodlight Variables")
event.placement_id	int Unique ID for the site page / placement where the ad ran.
event.rendering_id	int Unique ID of the creative for Data Transfer. Does not correspond to the UI-Creative-ID.
event.rich_media_event_counters	int MET Counter Value (the ecn= value).
event.rich_media_event_id	int MET Event ID for the Rich Media ad.
event.rich_media_event_timers	double Time in microseconds since 1970-01-01 00:00:00 UTC.rs
event.rich_media_event_type_id	int ID of Rich Media Event Type.
event.segment_value_1	int Segment Value 1
event.site_id	int Unique ID for the site where the ad ran.
event.state	string ID for user's state or province (US/Canada)
event.total_conversions	double The amount of conversion credit in nanos credited to the attributed event. For sales activities, Floodlight might count more than one conversion per event. For example, you can set up Floodlight to count the number of items purchased as the number of conversions for a single event. (The double value of the int event.activity_count in activities_events)
event.total_conversions_revenue	double The amount of revenue in USD megas credited to the attributed. You can multiply by 1,000,000 to see it as a dollar amount. (The attributed version of event.activity_revenue in activities_events)
event.total_transaction_count	double The number of transactions or activity tag fires in nanos credited to the attributed event.
event.tran_value	string TRAN Value
event.u_value	string U Value
event.zip_code	string Postal-Code (US/Canada).
network_id	int The network ID.
user_id	opaque The tracking ID (it is based on, but does not expose the user's browser cookie or mobile device ID). This field may be zeroed out for privacy reasons. User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

Campaign Manager 360 Data Transfer activities events

cm_dt_activities_events
event.activity_count	int
event.activity_id	int The ID of the Floodlight tag related to the conversion event.
event.activity_revenue	double
event.browser_platform_id	string ID of the browser type.
event.browser_version	string Browser/Platform Version
event.conversion_event_id	int Unique ID of the conversion event.
event.cookie_consented_floodlight_impressions	int The number of Floodlight impressions in which users have consented to cookie tracking.
event.country_code	string Country
event.duplicate_floodlight_impressions	int The number of duplicate Floodlight impressions. Impressions may be duplicated when users consent on the conversion page.
event.event_time	int Time in microseconds since 1970-01-01 00:00:00 UTC.
event.floodlight_config_id	int Unique ID of the floodlight configuration.
event.ord_value	string The advertiser's ordinal ID, if relevant for a given activity type. Passed in the 'ord=' key-value (also used for storing the client's Order-ID in sales tags)
event.other_data	string Stores key-value data from the activity string which is not otherwise labeled. (Any key-value that is NOT "src=", "type=", "cat=", "ord=", "u=", "cost=", "qty=", "tran=", "a=", or "b="). (Can be used for further product breakdown aka "Custom Floodlight Variables")
event.state	string ID for user's state or province (US/Canada)
network_id	int The network ID.
user_id	opaque The tracking ID (it is based on, but does not expose the user's browser cookie or mobile device ID). This field may be zeroed out for privacy reasons. User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

Campaign Manager 360 Data Transfer activity category

cm_dt_activity_category
account_id	int Unique ID of the account.
activity	string User defined category report interface name for floodlight tags.
activity_group_id	int ID of the group to which this advertiser belongs. An advertiser may be a member of only one group.
activity_id	int Unique ID of the Floodlight activity.
activity_sub_type	string User defined string corresponding to cat= value from Floodlight tag.
activity_type	string User defined string corresponding to type= value from Floodlight tag.
advertiser_id	int Unique ID of the advertiser.
floodlight_config_id	int Unique ID of the floodlight configuration.
tag_counting_method_id	int User defined type - describing Floodlight tag type. Key: 1 - standard, 2 - unique, 3 - custom, 4 - integer of transactionfor sales tags only, 5 - integer of items sold.

Campaign Manager 360 Data Transfer activity type

cm_dt_activity_type
account_id	int Unique ID of the account.
activity_group	string Name for this activity group.
activity_group_id	int ID of the group to which this advertiser belongs. An advertiser may be a member of only one group.
activity_type	string User defined string corresponding to type= value from Floodlight tag.
advertiser_id	int Unique ID of the advertiser.
floodlight_config_id	int Unique ID of the floodlight configuration.

Campaign Manager 360 Data Transfer ad

cm_dt_ad
account_id	int Unique ID of the account.
ad	string User defined ad name.
ad_click_url	string Click through URL of Click Ad type creatives only (aka Click Commands)
ad_comments	string User defined ad level comments.
ad_id	int Unique ID of the ad.
ad_type	string Type of ad. Possible values are: Standard, Interstitial, Static Click, Dynamic Click, Tracking, In-Steam Video, DART Search, Affiliate, PInclusion, Product feeds, Natural Search, Default, Interstitial Default, InStream Default, Ad Brand-neutral
ad_type_id	int Unique ID of the ad type.
advertiser_id	int Unique ID of the advertiser.
campaign_id	int The unique ID of the Campaign Manager 360 campaign.
creative_size	string The creative size in pixels: width x height. Empty size is represented by "0X0".
floodlight_config_id	int Unique ID of the floodlight configuration.

Campaign Manager 360 Data Transfer Ad placement assignments

cm_dt_ad_placement_assignment
account_id	int Unique ID of the account.
ad_id	int Unique ID of the ad.
advertiser_id	int Unique ID of the advertiser.
floodlight_config_id	int Unique ID of the floodlight configuration.
placement_id	int

Campaign Manager 360 Data Transfer Advertiser

cm_dt_advertiser
account_id	int Unique ID of the account.
advertiser	string User entered name of the advertiser.
advertiser_group	string User specified group to which this advertiser belongs. An advertiser may be a member of only one group.
advertiser_group_id	int Group ID to which this advertiser belongs. An advertiser may be a member of only one group.
advertiser_id	int Unique ID of the advertiser.
floodlight_config_id	int Unique ID of the floodlight configuration.

Campaign Manager 360 Data Transfer asset

cm_dt_asset
account_id	int Unique ID of the account.
asset	string Name of the creative asset.
asset_category	string Category of the creative asset.
asset_id	int Unique ID of the asset.
asset_orientation	string Screen orientation of the asset.

Campaign Manager 360 Data Transfer audience segments

cm_dt_audience_segments
account_id	int Unique ID of the account.
advertiser_id	int Unique ID of the advertiser.
audience_segment	string Name of the audience segment.
audience_segment_id	int Unique ID of the audience segment.
floodlight_config_id	int Unique ID of the floodlight configuration.

Campaign Manager 360 Data Transfer browser

cm_dt_browser
browser_platform	string
browser_platform_id	int Browser / Platform ID

Campaign Manager 360 Data Transfer campaign

cm_dt_campaign
account_id	int Unique ID of the account.
advertiser_id	int Unique ID of the advertiser.
billing_invoice_code	string The code entered in the billing invoice.
campaign	string User entered campaign name.
campaign_end_date	int Campaign end date as YYYYMMDD.
campaign_id	int The unique ID of the Campaign Manager 360 campaign.
campaign_start_date	int Campaign start date as YYYYMMDD.
floodlight_config_id	int Unique ID of the floodlight configuration.

Campaign Manager 360 Data Transfer city

cm_dt_city
city	string The city name
city_id	int Unique ID of the city.

Campaign Manager 360 Data Transfer clicks

cm_dt_clicks
event.operating_system_id	int ID of the operating system.
event	struct
event.active_view_audible_impressions	int Active View: Impressions Audible
event.active_view_audible_time_msec	int Active View: Play Time Audible (milliseconds)
event.active_view_audible_visible_time_msec	int Active View: Play Time Audible and Visible (milliseconds)
event.active_view_background_count	int Active View: Impressions In Background
event.active_view_complete_viewable_impressions	int Active View: Impressions Visible at Completion
event.active_view_eligible_impressions	int Whether the impression was eligible to measure viewability. An impression is eligible if (a) the ad's creative has an Active View tag and (b) the tag successfully communicates with Google Marketing Platform servers at the time of the impression.
event.active_view_first_quartile_viewable_audible_impressions	int Active View: Impressions Visible and Audible at First Quartile
event.active_view_first_quartile_viewable_impressions	int Active View: Impressions Visible at First Quartile
event.active_view_fullscreen_count	int Active View: Impressions Full-Screen
event.active_view_impressions_audible_and_visible_at_completion	int Active View: Impressions Audible and Visible at Completion
event.active_view_impressions_visible10_seconds	int Active View: Impressions Visible 10 Seconds
event.active_view_measurable_impressions	int Whether the impression was measurable with Active View.
event.active_view_midpoint_viewable_audible_impressions	int Active View: Impressions Visible and Audible at Midpoint
event.active_view_midpoint_viewable_impressions	int Active View: Impressions Visible at Midpoint
event.active_view_plus_measurable_count	int Active View Plus: Measurable Impressions
event.active_view_start_viewable_audible_impressions	int Active View: Impressions Visible and Audible at Start
event.active_view_start_viewable_impressions	int Active View: Impressions Visible at Start
event.active_view_third_quartile_viewable_audible_impressions	int Active View: Impressions Visible and Audible at Third Quartile
event.active_view_third_quartile_viewable_impressions	int Active View: Impressions Visible at Third Quartile
event.active_view_tos_msec	int Active View: Time on Screen (milliseconds)
event.active_view_visible_time_msec	int Active View: Video Visible Time (milliseconds)
event.activity_count	int Activity Quantity
event.activity_id	int The ID of the Floodlight tag related to the conversion event.
event.activity_revenue	double Activity Revenue
event.ad_id	int Unique ID of the ad placement.
event.advertiser_id	int Unique ID of the advertiser
event.audience_segment_id	int Unique ID of the audience segment.
event.browser_platform_id	string ID of the browser type.
event.browser_version	string Browser/Platform Version
event.campaign_id	int The unique ID of the Campaign Manager 360 campaign
event.city_id	int City ID
event.conversion_id	int Indicates whether an activity has been matched as a post-click (value of 1) or post-impression (value of 2), or unmatched (value of 0).
event.country_code	string Country
event.creative_version	string Creative version number.
event.dma_region_id	int Designated Market Area ID (US/Canada).
event.dv360_ad_position	int Specifies the position of the ad on the page if known. 1 represents above the fold, 2 represents below the fold.
event.dv360_advertiser_id	int The Display & Video 360 numerical ID for the advertiser related to the event, for example 164332.
event.dv360_adx_page_categories	string DV360 Adx Page Categories
event.dv360_attributed_inventory_source_external_id	string The external ID of the attributed inventory source that Display & Video 360 selected as the best match from those accessible to the advertiser related to the view event based on floor price and auction type.
event.dv360_attributed_inventory_source_is_public	string True if inventory source is available to all buyers. False otherwise.
event.dv360_auction_id	string A string used to join events among view/click/conversion types, for example"ABCDEFGH_abcdefgh-0123456789". Do not assume any ordering, structure or meaning to the auction_id value.
event.dv360_bid_price_advertiser_currency	int The bid price sent to the exchange in advertiser currency nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics.
event.dv360_bid_price_partner_currency	int The bid price sent to the exchange in partner currency nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics.
event.dv360_bid_price_usd	int The bid price sent to the exchange in USD nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics..
event.dv360_billable_cost_advertiser_currency	int The total amount of money billed to the partner, including the media cost and partner costs, in advertiser currency nanos.
event.dv360_billable_cost_partner_currency	int The total amount of money billed to the partner, including the media cost and partner costs, in partner currency nanos.
event.dv360_billable_cost_usd	int The total amount of money billed to the partner, including the media cost and partner costs, in USD nanos.
event.dv360_browser_id	int The Display & Video 360 numerical ID identifying the browser related to this event.
event.dv360_browser_timezone_offset_minutes	int The difference in minutes between the active timezone on the user's browser and GMT-12, for example 1320 represents a browser timezone of GMT+10.
event.dv360_campaign_id	int The unique ID of the linked Display & Video 360 campaign.
event.dv360_city_id	int The Display & Video 360 numerical ID identifying the best-guess city of the impression.
event.dv360_country_code	string 2-letter ISO 3166-1 country code identifying the best-guess country of the impression, for example "US".
event.dv360_cpm_fee_1_advertiser_currency	int
event.dv360_cpm_fee_1_partner_currency	int
event.dv360_cpm_fee_1_usd	int
event.dv360_cpm_fee_2_advertiser_currency	int
event.dv360_cpm_fee_2_partner_currency	int
event.dv360_cpm_fee_2_usd	int
event.dv360_cpm_fee_3_advertiser_currency	int
event.dv360_cpm_fee_3_partner_currency	int
event.dv360_cpm_fee_3_usd	int
event.dv360_cpm_fee_4_advertiser_currency	int
event.dv360_cpm_fee_4_partner_currency	int
event.dv360_cpm_fee_4_usd	int
event.dv360_cpm_fee_5_advertiser_currency	int
event.dv360_cpm_fee_5_partner_currency	int
event.dv360_cpm_fee_5_usd	int
event.dv360_creative_id	int The Display & Video 360 numerical ID for the creative related to the event, for example 367487.
event.dv360_data_fees_advertiser_currency	int
event.dv360_data_fees_partner_currency	int
event.dv360_data_fees_usd	int
event.dv360_device_type	int The numerical value of the identified device type. 0 = Computer, 1 = Other, 2 = Smart Phone, 3 = Tablet, 4 = Smart TV, 5 = Connected TV, 6 = Set Top Box, 7 = Connected Device.
event.dv360_exchange_id	string The Display & Video 360 numerical ID for the exchange that requested the ad.
event.dv360_insertion_order_id	int The Display & Video 360 numerical ID for the insertion order related to the event, for example 1079941.
event.dv360_isp_id	int The Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.
event.dv360_language	string The ISO-639-1 code or "zh_CN" (Chinese (simplified)), "zh_TW" (Chinese (traditional)) or "other" representing the language related to the view event.
event.dv360_line_item_id	int The Display & Video 360 numerical ID for the line item related to the event, for example 1155785.
event.dv360_matching_targeted_keywords	string A comma separated string containing a list of targeted keywords matching the page related to the view event, for example "apple,orange,banana". Although the page related to the view event may match many keywords, only those which were targeted will be included; if the list of keywords is large we may impose a limit to the number of keywords returned.
event.dv360_matching_targeted_segments	string Space-separated IDs of targeted user lists that match the visitor, for example "-4 456". If the visitor is in a user list that is not targeted by the ad associated with this event it will not be included here.
event.dv360_media_cost_advertiser_currency	int The amount paid for the impression in advertiser currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
event.dv360_media_cost_partner_currency	int The amount paid for the impression in the partner currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
event.dv360_media_cost_usd	int The amount paid for the impression in USD nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
event.dv360_media_fee_1_advertiser_currency	int
event.dv360_media_fee_1_partner_currency	int
event.dv360_media_fee_1_usd	int
event.dv360_media_fee_2_advertiser_currency	int
event.dv360_media_fee_2_partner_currency	int
event.dv360_media_fee_2_usd	int
event.dv360_media_fee_3_advertiser_currency	int
event.dv360_media_fee_3_partner_currency	int
event.dv360_media_fee_3_usd	int
event.dv360_media_fee_4_advertiser_currency	int
event.dv360_media_fee_4_partner_currency	int
event.dv360_media_fee_4_usd	int
event.dv360_media_fee_5_advertiser_currency	int
event.dv360_media_fee_5_partner_currency	int
event.dv360_media_fee_5_usd	int
event.dv360_mobile_make_id	int The numerical ID for the mobile make. This value may be missing.
event.dv360_mobile_model_id	int The numerical ID for the mobile model. This value may be missing.
event.dv360_net_speed	int The Display & Video 360 numerical ID representing the network speed related to the view event. 1=Dial-up, 2=EDGE/2G, 3=UMTS/3G, 4=Basic DSL, 5=HSDPA/3.5G, 6=Broadband/4G, 7=Unknown.
event.dv360_operating_system_id	int DV60 operating system ID
event.dv360_request_time	int A Unix timestamp in microseconds (1/1,000,000 second) for when we received the ad request, for example1330403779608570 represents Tuesday February 28th 2012 04:36:19.608570. Although this value is consistent across the view, click and conversion even it is not guaranteed to be unique - use auction_id to join events
event.dv360_revenue_advertiser_currency	int The total amount in advertiser currency nanos made by the partner account for the view event. This value may be zero.
event.dv360_revenue_partner_currency	int The total amount in partner currency nanos made by the partner account for the view event. This value may be zero.
event.dv360_revenue_usd	int The total amount in USD nanos made by the partner account for the view event. This value may be zero.
event.dv360_site_id	int The Display & Video 360 numerical ID for the most specific universal site that matches the url.
event.dv360_state_region_id	int DV360 Region ID
event.dv360_url	string The raw URL taken from the bid request received from the exchange, for example "http://www.example.com". As some exchanges mask the URL in their bid requests this value may be: "source_url_hidden"
event.dv360_view_state	string Populated for wrapped tags. (Two impression records when both events occur.) Possible values are: "OUTER", DV360 returned wrapped tag; "INNER", ad served post wrapped tag; "3PAS_MERGED", wrapped tag tracked by CM; "3PAS_OUTER", tracking ping sent to CM but no response, 3rd party blocked ad serving.
event.dv360_zip_postal_code	string DV360 ZIP/Postal Code
event.dynamic_profile	string Studio dynamic profile name.
event.dynamic_profile_id	int Studio dynamic profile ID.
event.event_sub_type	string Contains further details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "POSTVIEW", "POSTCLICK" or blank for conversion events.
event.event_time	int Time in microseconds since 1970-01-01 00:00:00 UTC.
event.event_type	string Contains "CLICK".
event.feed	array Feed ID.
event.feed_reporting_dimension1	array
event.feed_reporting_dimension2	array
event.feed_reporting_dimension3	array
event.feed_reporting_dimension4	array
event.feed_reporting_dimension5	array
event.feed_reporting_dimension6	array
event.feed_reporting_label	array Dynamic Feed Reporting Label.
event.floodlight_config_id	int Unique ID of the floodlight configuration.
event.impression_id	string Impression ID
event.interaction_time_utc_seconds	string Interaction Time
event.landing_page_url_id	int Unique ID of the landing page URL.
event.operating_system_id	int ID of the operating system.
event.ord_value	string The advertiser's ordinal ID, if relevant for a given activity type. Passed in the 'ord=' key-value (also used for storing the client's Order-ID in sales tags)
event.other_data	string Stores key-value data from the activity string which is not otherwise labeled. (Any key-value that is NOT "src=", "type=", "cat=", "ord=", "u=", "cost=", "qty=", "tran=", "a=", or "b="). (Can be used for further product breakdown aka "Custom Floodlight Variables")
event.placement_id	int Unique ID for the site page / placement where the ad ran.
event.platform_type_id	int Identifier that maps to the platform on which the event occured. Possible values are: 30000: desktop, 30001: high-end smartphone, 30002: tablet, 30003: mid-range smartphone, 30004: connected TV, 30005: unknown, 30006: set top box.
event.rendering_id	int Unique ID of the creative for Data Transfer. Does not correspond to the UI-Creative-ID.
event.rich_media_event_counters	int MET Counter Value (the ecn= value).
event.rich_media_event_id	int MET Event ID for the Rich Media ad.
event.rich_media_event_timers	double Time in microseconds since 1970-01-01 00:00:00 UTC.rs
event.rich_media_event_type_id	int ID of Rich Media Event Type.
event.segment_value_1	int Segment Value 1
event.site_id	int Unique ID for the site where the ad ran.
event.state	string ID for user's state or province (US/Canada)
event.tran_value	string TRAN Value
event.u_value	string U Value
event.zip_code	string Postal-Code (US/Canada).
network_id	int The network ID.
user_id	opaque The tracking ID (it is based on, but does not expose the user's browser cookie or mobile device ID). This field may be zeroed out for privacy reasons. User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

Campaign Manager 360 Data Transfer creative

cm_dt_creative
account_id	int Unique ID of the account.
advertiser_id	int Unique ID of the advertiser.
creative	string Creative Name as entered into the Campaign Manager 360 interface.
creative_id	int The Creative ID in Campaign Manager 360 UI.
creative_image_url	string Location of creative image (Does not apply to rich media).
creative_last_modified_date	int Unix epoch timestamp (milliseconds) of the last time this creative was modified.
creative_size	string The creative size in pixels: width x height. Empty size is represented by "0X0".
creative_type	string The type of creative.
creative_type_id	int
creative_version	int Used for change management to capture different versions
floodlight_config_id	int Unique ID of the floodlight configuration.
rendering_id	int Unique ID of the creative for Data Transfer. This isn't the creative ID in the Campaign Manager 360 UI.

Campaign Manager 360 Data Transfer creative ad assignment

cm_dt_creative_ad_assignment
account_id	int Unique ID of the account.
ad_click_url	string Click through URL of Click Ad type creatives only (aka Click Commands)
ad_id	int Unique ID of the ad.
advertiser_id	int Unique ID of the advertiser.
creative_end_date	int Rotation end date and time in milliseconds since 1970-01-01 00:00:00 UTC.
creative_group1	string User defined value from creative group 1.
creative_group1_id	int Unique ID of creative group 1.
creative_group2	string User defined value from creative group 2.
creative_group2_id	int Unique ID of creative group 2.
creative_id	int The Creative ID in Campaign Manager 360 UI.
creative_rotation_type	string Rotation type.
creative_rotation_type_id	int Id of the rotation type.
creative_start_date	int Rotation start date and time in Unix epoch time (milliseconds).
floodlight_config_id	int Unique ID of the floodlight configuration.

Campaign Manager 360 Data Transfer custom creative field

cm_dt_custom_creative_field
account_id	int Unique ID of the account.
advertiser_id	int Unique ID of the advertiser.
creative_field_id	int The Creative ID in Campaign Manager 360 UI.
creative_field_name	string User defined name associated to a particular custom creative field.
creative_field_number	int Slot ID assigned to this custom creative field (typically IDs from 1-20).
creative_field_value	string User defined value as available option to named field.
creative_field_value_id	int ID of the user defined creative value.
creative_id	int The Creative ID in Campaign Manager 360 UI.
floodlight_config_id	int Unique ID of the floodlight configuration.

Campaign Manager 360 Data Transfer custom floodlight variable

cm_dt_custom_floodlight_variable
account_id	int Unique ID of the account.
advertiser_id	int Unique ID of the advertiser.
floodlight_config_id	int Unique ID of the floodlight configuration.
floodlight_variable_id	int Unique ID of the floodlight variable.
floodlight_variable_name	string User defined name of the custom floodlight variable.

Campaign Manager 360 Data Transfer custom rich media

cm_dt_custom_rich_media
account_id	int Unique ID of the account.
advertiser_id	int Unique ID of the advertiser.
floodlight_config_id	int Unique ID of the floodlight configuration.
rich_media_event_id	int ID of the rich media event.
rich_media_event_name	string Name of the rich media event.
rich_media_event_type	string Possible values are: "Timer", "Exit", or "Counter".
rich_media_event_type_id	int ID of the rich media event type.

Campaign Manager 360 Data Transfer designated market area

cm_dt_designated_market_area
dma_region	string
dma_region_id	int

Campaign Manager 360 Data Transfer impressions

cm_dt_impressions
event	struct
event.active_view_audible_impressions	int Active View: Impressions Audible
event.active_view_audible_time_msec	int Active View: Play Time Audible (milliseconds)
event.active_view_audible_visible_time_msec	int Active View: Play Time Audible and Visible (milliseconds)
event.active_view_background_count	int Active View: Impressions In Background
event.active_view_complete_viewable_impressions	int Active View: Impressions Visible at Completion
event.active_view_eligible_impressions	int Whether the impression was eligible to measure viewability. An impression is eligible if (a) the ad's creative has an Active View tag and (b) the tag successfully communicates with Google Marketing Platform servers at the time of the impression.
event.active_view_first_quartile_viewable_audible_impressions	int Active View: Impressions Visible and Audible at First Quartile
event.active_view_first_quartile_viewable_impressions	int Active View: Impressions Visible at First Quartile
event.active_view_fullscreen_count	int Active View: Impressions Full-Screen
event.active_view_impressions_audible_and_visible_at_completion	int Active View: Impressions Audible and Visible at Completion
event.active_view_impressions_visible10_seconds	int Active View: Impressions Visible 10 Seconds
event.active_view_measurable_impressions	int Whether the impression was measurable with Active View.
event.active_view_midpoint_viewable_audible_impressions	int Active View: Impressions Visible and Audible at Midpoint
event.active_view_midpoint_viewable_impressions	int Active View: Impressions Visible at Midpoint
event.active_view_plus_measurable_count	int Active View Plus: Measurable Impressions
event.active_view_start_viewable_audible_impressions	int Active View: Impressions Visible and Audible at Start
event.active_view_start_viewable_impressions	int Active View: Impressions Visible at Start
event.active_view_third_quartile_viewable_audible_impressions	int Active View: Impressions Visible and Audible at Third Quartile
event.active_view_third_quartile_viewable_impressions	int Active View: Impressions Visible at Third Quartile
event.active_view_tos_msec	int Active View: Time on Screen (milliseconds)
event.active_view_visible_time_msec	int Active View: Video Visible Time (milliseconds)
event.activity_count	int Activity Quantity
event.activity_id	int The ID of the Floodlight tag related to the conversion event.
event.activity_revenue	double Activity Revenue
event.ad_id	int Unique ID of the ad placement.
event.advertiser_id	int Unique ID of the advertiser
event.audience_segment_id	int Unique ID of the audience segment
event.browser_platform_id	string ID of the browser type.
event.browser_version	string Browser/Platform Version
event.campaign_id	int The unique ID of the Campaign Manager 360 campaign
event.city_id	int City ID
event.conversion_id	int Indicates whether an activity has been matched as a post-click (value of 1) or post-impression (value of 2), or unmatched (value of 0).
event.country_code	string Country
event.creative_version	string Creative version number.
event.dma_region_id	int Designated Market Area ID (US/Canada).
event.dv360_ad_position	int Specifies the position of the ad on the page if known. 1 represents above the fold, 2 represents below the fold.
event.dv360_advertiser_id	int The Display & Video 360 numerical ID for the advertiser related to the event, for example 164332.
event.dv360_adx_page_categories	string DV360 Adx Page Categories
event.dv360_attributed_inventory_source_external_id	string The external ID of the attributed inventory source that Display & Video 360 selected as the best match from those accessible to the advertiser related to the view event based on floor price and auction type.
event.dv360_attributed_inventory_source_is_public	string True if inventory source is available to all buyers. False otherwise.
event.dv360_auction_id	string A string used to join events among view/click/conversion types, for example"ABCDEFGH_abcdefgh-0123456789". Do not assume any ordering, structure or meaning to the auction_id value.
event.dv360_bid_price_advertiser_currency	int The bid price sent to the exchange in advertiser currency nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics.
event.dv360_bid_price_partner_currency	int The bid price sent to the exchange in partner currency nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics.
event.dv360_bid_price_usd	int The bid price sent to the exchange in USD nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics..
event.dv360_bid_request_publisher_id	string The publisher id in the publisher.id field of bid request.
event.dv360_billable_cost_advertiser_currency	int The total amount of money billed to the partner, including the media cost and partner costs, in advertiser currency nanos.
event.dv360_billable_cost_partner_currency	int The total amount of money billed to the partner, including the media cost and partner costs, in partner currency nanos.
event.dv360_billable_cost_usd	int The total amount of money billed to the partner, including the media cost and partner costs, in USD nanos.
event.dv360_browser_id	int The Display & Video 360 numerical ID identifying the browser related to this event.
event.dv360_browser_timezone_offset_minutes	int The difference in minutes between the active timezone on the user's browser and GMT-12, for example 1320 represents a browser timezone of GMT+10.
event.dv360_campaign_id	int The unique ID of the linked Display & Video 360 campaign.
event.dv360_city_id	int The Display & Video 360 numerical ID identifying the best-guess city of the impression.
event.dv360_country_code	string 2-letter ISO 3166-1 country code identifying the best-guess country of the impression, for example "US".
event.dv360_cpm_fee_1_advertiser_currency	int
event.dv360_cpm_fee_1_partner_currency	int
event.dv360_cpm_fee_1_usd	int
event.dv360_cpm_fee_2_advertiser_currency	int
event.dv360_cpm_fee_2_partner_currency	int
event.dv360_cpm_fee_2_usd	int
event.dv360_cpm_fee_3_advertiser_currency	int
event.dv360_cpm_fee_3_partner_currency	int
event.dv360_cpm_fee_3_usd	int
event.dv360_cpm_fee_4_advertiser_currency	int
event.dv360_cpm_fee_4_partner_currency	int
event.dv360_cpm_fee_4_usd	int
event.dv360_cpm_fee_5_advertiser_currency	int
event.dv360_cpm_fee_5_partner_currency	int
event.dv360_cpm_fee_5_usd	int
event.dv360_creative_id	int The Display & Video 360 numerical ID for the creative related to the event, for example 367487.
event.dv360_data_fees_advertiser_currency	int
event.dv360_data_fees_partner_currency	int
event.dv360_data_fees_usd	int
event.dv360_device_type	int The numerical value of the identified device type. 0 = Computer, 1 = Other, 2 = Smart Phone, 3 = Tablet, 4 = Smart TV, 5 = Connected TV, 6 = Set Top Box, 7 = Connected Device.
event.dv360_exchange_id	string The Display & Video 360 numerical ID for the exchange that requested the ad.
event.dv360_insertion_order_id	int The Display & Video 360 numerical ID for the insertion order related to the event, for example 1079941.
event.dv360_isp_id	int The Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.
event.dv360_language	string The ISO-639-1 code or "zh_CN" (Chinese (simplified)), "zh_TW" (Chinese (traditional)) or "other" representing the language related to the view event.
event.dv360_line_item_id	int The Display & Video 360 numerical ID for the line item related to the event, for example 1155785.
event.dv360_matching_targeted_keywords	string A comma separated string containing a list of targeted keywords matching the page related to the view event, for example "apple,orange,banana". Although the page related to the view event may match many keywords, only those which were targeted will be included; if the list of keywords is large we may impose a limit to the number of keywords returned.
event.dv360_matching_targeted_segments	string Space-separated IDs of targeted user lists that match the visitor, for example "-4 456". If the visitor is in a user list that is not targeted by the ad associated with this event it will not be included here.
event.dv360_media_cost_advertiser_currency	int The amount paid for the impression in advertiser currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
event.dv360_media_cost_partner_currency	int The amount paid for the impression in the partner currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
event.dv360_media_cost_usd	int The amount paid for the impression in USD nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
event.dv360_media_fee_1_advertiser_currency	int
event.dv360_media_fee_1_partner_currency	int
event.dv360_media_fee_1_usd	int
event.dv360_media_fee_2_advertiser_currency	int
event.dv360_media_fee_2_partner_currency	int
event.dv360_media_fee_2_usd	int
event.dv360_media_fee_3_advertiser_currency	int
event.dv360_media_fee_3_partner_currency	int
event.dv360_media_fee_3_usd	int
event.dv360_media_fee_4_advertiser_currency	int
event.dv360_media_fee_4_partner_currency	int
event.dv360_media_fee_4_usd	int
event.dv360_media_fee_5_advertiser_currency	int
event.dv360_media_fee_5_partner_currency	int
event.dv360_media_fee_5_usd	int
event.dv360_mobile_make_id	int The numerical ID for the mobile make. This value may be missing.
event.dv360_mobile_model_id	int The numerical ID for the mobile model. This value may be missing.
event.dv360_net_speed	int The Display & Video 360 numerical ID representing the network speed related to the view event. 1=Dial-up, 2=EDGE/2G, 3=UMTS/3G, 4=Basic DSL, 5=HSDPA/3.5G, 6=Broadband/4G, 7=Unknown.
event.dv360_operating_system_id	int
event.dv360_request_time	int A Unix timestamp in microseconds (1/1,000,000 second) for when we received the ad request, for example1330403779608570 represents Tuesday February 28th 2012 04:36:19.608570. Although this value is consistent across the view, click and conversion even it is not guaranteed to be unique - use auction_id to join events
event.dv360_revenue_advertiser_currency	int The total amount in advertiser currency nanos made by the partner account for the view event. This value may be zero.
event.dv360_revenue_partner_currency	int The total amount in partner currency nanos made by the partner account for the view event. This value may be zero.
event.dv360_revenue_usd	int The total amount in USD nanos made by the partner account for the view event. This value may be zero.
event.dv360_site_id	int The Display & Video 360 numerical ID for the most specific universal site that matches the url.
event.dv360_state_region_id	int DV360 Region ID
event.dv360_supply_chain_complete	boolean Indicates whether the DV360 supply chain object is complete in the bid request.
event.dv360_supply_chain_domain	array The domain in the DV360 supply path, the order is the same as the order in the supply chain JSON.
event.dv360_supply_chain_seller_id	array Array of strings. The seller ID in the DV360 supply path, the order is the same as the order in the supply chain JSON.
event.dv360_url	string The raw URL taken from the bid request received from the exchange, for example "http://www.example.com". As some exchanges mask the URL in their bid requests this value may be: "source_url_hidden"
event.dv360_view_state	string Populated for wrapped tags. (Two impression records when both events occur.) Possible values are: "OUTER", DV360 returned wrapped tag; "INNER", ad served post wrapped tag; "3PAS_MERGED", wrapped tag tracked by CM; "3PAS_OUTER", tracking ping sent to CM but no response, 3rd party blocked ad serving.
event.dv360_zip_postal_code	string DV360 ZIP/Postal Code
event.dynamic_profile	string Studio dynamic profile name.
event.dynamic_profile_id	int Studio dynamic profile ID.
event.event_sub_type	string Contains further details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "POSTVIEW", "POSTCLICK" or blank for conversion events.
event.event_time	int Time in microseconds since 1970-01-01 00:00:00 UTC.
event.event_type	string Contains "VIEW".
event.feed	array Feed ID.
event.feed_reporting_dimension1	array
event.feed_reporting_dimension2	array
event.feed_reporting_dimension3	array
event.feed_reporting_dimension4	array
event.feed_reporting_dimension5	array
event.feed_reporting_dimension6	array
event.feed_reporting_label	array Dynamic Feed ID.
event.floodlight_config_id	int Unique ID of the floodlight configuration.
event.impression_id	string Impression ID
event.interaction_time_utc_seconds	string Interaction Time
event.landing_page_url_id	int Unique ID of the landing page URL.
event.operating_system_id	int ID of the operating system.
event.ord_value	string The advertiser's ordinal ID, if relevant for a given activity type. Passed in the 'ord=' key-value (also used for storing the client's Order-ID in sales tags)
event.other_data	string Stores key-value data from the activity string which is not otherwise labeled. (Any key-value that is NOT "src=", "type=", "cat=", "ord=", "u=", "cost=", "qty=", "tran=", "a=", or "b="). (Can be used for further product breakdown aka "Custom Floodlight Variables")
event.placement_id	int Unique ID for the site page / placement where the ad ran.
event.platform_type_id	int Identifier that maps to the platform on which the event occured. Possible values are: 30000: desktop, 30001: high-end smartphone, 30002: tablet, 30003: mid-range smartphone, 30004: connected TV, 30005: unknown, 30006: set top box.
event.referrer_url	string Contains the URL on which the ad appeared, when possible. May also be empty, or return ad server URLs.
event.rendering_id	int Unique ID of the creative for Data Transfer. Does not correspond to the UI-Creative-ID.
event.rich_media_event_counters	int MET Counter Value (the ecn= value).
event.rich_media_event_id	int MET Event ID for the Rich Media ad.
event.rich_media_event_timers	double Time in microseconds since 1970-01-01 00:00:00 UTC.rs
event.rich_media_event_type_id	int ID of Rich Media Event Type.
event.segment_value_1	int Segment Value 1
event.site_id	int Unique ID for the site where the ad ran.
event.state	string ID for user's state or province (US/Canada)
event.tran_value	string TRAN Value
event.u_value	string U Value
event.zip_code	string Postal-Code (US/Canada).
network_id	int The network ID.
user_id	opaque The tracking ID (it is based on, but does not expose the user's browser cookie or mobile device ID). This field may be zeroed out for privacy reasons. User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

Campaign Manager 360 Data Transfer keyword value

cm_dt_keyword_value
account_id	int Unique ID of the account.
ad_id	int Unique ID of the ad.
advertiser_id	int Unique ID of the advertiser.
floodlight_config_id	int Unique ID of the floodlight configuration.
keyword	string Targeted key/value pair.

Campaign Manager 360 Data Transfer landing page url

cm_dt_landing_page_url
account_id	int Unique ID of the account.
landing_page_url	string The URL a user was sent to when they clicked on an ad.
landing_page_url_id	int Unique ID of the landing page URL.

Campaign Manager 360 Data Transfer operating system

cm_dt_operating_system
operating_system	string
operating_system_id	int Unique ID of OS just for Data Transfer. Operating System IDs in DT files that are greater than 22 have a direct match in this table. For DT file Operating System IDs less than 23, you must raise 2 to the power of the Operating System ID in the Data Transfer file to find its corresponding match in this table. Match Table Operating System ID = 2 ^ DT file operating system ID. For example 2 ^ 12 = 8192 (Linux).

Campaign Manager 360 Data Transfer paid search

cm_dt_paid_search
ad_id	int Unique ID of the ad.
advertiser_id	int Unique ID of the advertiser.
campaign_id	int The unique ID of the Campaign Manager 360 campaign.
floodlight_config_id	int Unique ID of the floodlight configuration.
paid_search_ad_group	string User defined keyword group.
paid_search_ad_group_id	int Unique ID of the keyword group.
paid_search_ad_id	int Unique ID associated with a Search Ads 360 ad.
paid_search_bid_strategy	string User defined keyword bid strategy. Returns a value of "(not set)" if empty.
paid_search_bid_strategy_id	int ID of the keyword bid strategy.
paid_search_campaign	string User defined name of campaign as entered into Search Ads 360.
paid_search_campaign_id	int ID of the Search Ads 360 campaign.
paid_search_keyword	string User defined keyword value as entered into Search Ads 360.
paid_search_keyword_id	int Unique ID from Search Ads 360. Uses the "long" format
paid_search_landing_page_url	string User defined landing page URL as entered into Search Ads 360.
paid_search_legacy_keyword_id	int Unique ID from Search Ads 360. Uses the "short" format in which the leading 43* is removed.
paid_search_match_type	string User selected

Campaign Manager 360 Data Transfer placement

cm_dt_placement
account_id	int Unique ID of the account.
activity_id	int Unique ID of the Floodlight activity.
advertiser_id	int Unique ID of the advertiser.
campaign_id	int The unique ID of the Campaign Manager 360 campaign.
content_category	string User defined content category.
content_category_id	int ID of content category.
flighting_activated	boolean Indicates whether this is a flighted (billing) placement.
floodlight_config_id	int Unique ID of the floodlight configuration.
package_roadblock_id	int
package_roadblock_type	string
package_roadblock_type_id	int
placement	string
placement_cap_cost_option	int User entered cost capping amount.
placement_cost_structure	string
placement_end_date	int End date of the flight in 'YYYYMMDD' format.
placement_id	int
placement_start_date	int Start date of the flight in 'YYYYMMDD' format.
placement_strategy	string User defined placement strategy.
placement_strategy_id	int ID of the placement strategy.
site_id	int Unique ID of the site.
site_keyname	string

Campaign Manager 360 Data Transfer placement cost

cm_dt_placement_cost
account_id	int Unique ID of the account.
advertiser_id	int Unique ID of the advertiser.
floodlight_config_id	int Unique ID of the floodlight configuration.
placement_comments	string User entered placement pricing comments.
placement_end_date	int End date of the flight in 'YYYYMMDD' format.
placement_id	int Placement ID
placement_rate	int Purchased rate expressed in nanos of the network's currency. 1 nano = 1 billionth. 1 nano USD = $0.000000001.
placement_start_date	int Start date of the flight in 'YYYYMMDD' format.
placement_total_booked_units	int The number of purchased units.

Campaign Manager 360 Data Transfer rich media

cm_dt_rich_media
event	struct
event.active_view_audible_impressions	int Active View: Impressions Audible
event.active_view_audible_time_msec	int Active View: Play Time Audible (milliseconds)
event.active_view_audible_visible_time_msec	int Active View: Play Time Audible and Visible (milliseconds)
event.active_view_background_count	int Active View: Impressions In Background
event.active_view_complete_viewable_impressions	int Active View: Impressions Visible at Completion
event.active_view_eligible_impressions	int Whether the impression was eligible to measure viewability. An impression is eligible if (a) the ad's creative has an Active View tag and (b) the tag successfully communicates with Google Marketing Platform servers at the time of the impression.
event.active_view_first_quartile_viewable_audible_impressions	int Active View: Impressions Visible and Audible at First Quartile
event.active_view_first_quartile_viewable_impressions	int Active View: Impressions Visible at First Quartile
event.active_view_fullscreen_count	int Active View: Impressions Full-Screen
event.active_view_impressions_audible_and_visible_at_completion	int Active View: Impressions Audible and Visible at Completion
event.active_view_impressions_visible10_seconds	int Active View: Impressions Visible 10 Seconds
event.active_view_measurable_impressions	int Whether the impression was measurable with Active View.
event.active_view_midpoint_viewable_audible_impressions	int Active View: Impressions Visible and Audible at Midpoint
event.active_view_midpoint_viewable_impressions	int Active View: Impressions Visible at Midpoint
event.active_view_plus_measurable_count	int Active View Plus: Measurable Impressions
event.active_view_start_viewable_audible_impressions	int Active View: Impressions Visible and Audible at Start
event.active_view_start_viewable_impressions	int Active View: Impressions Visible at Start
event.active_view_third_quartile_viewable_audible_impressions	int Active View: Impressions Visible and Audible at Third Quartile
event.active_view_third_quartile_viewable_impressions	int Active View: Impressions Visible at Third Quartile
event.active_view_tos_msec	int Active View: Time on Screen (milliseconds)
event.active_view_viewable_impressions	int Whether the impression was viewable.
event.active_view_visible_time_msec	int Active View: Video Visible Time (milliseconds)
event.activity_count	int Activity Quantity
event.activity_id	int The ID of the Floodlight tag related to the conversion event.
event.activity_revenue	double Activity Revenue
event.ad_id	int Unique ID of the ad placement.
event.advertiser_id	int Unique ID of the advertiser
event.browser_platform_id	string ID of the browser type.
event.browser_version	string Browser/Platform Version
event.campaign_id	int The unique ID of the Campaign Manager 360 campaign
event.city_id	int City ID
event.conversion_id	int Indicates whether an activity has been matched as a post-click (value of 1) or post-impression (value of 2), or unmatched (value of 0).
event.country_code	string Country
event.creative_version	string Creative version number.
event.dma_region_id	int Designated Market Area ID (US/Canada).
event.dv360_ad_position	int Specifies the position of the ad on the page if known. 1 represents above the fold, 2 represents below the fold.
event.dv360_advertiser_id	int The Display & Video 360 numerical ID for the advertiser related to the event, for example 164332.
event.dv360_adx_page_categories	string DV360 Adx Page Categories
event.dv360_attributed_inventory_source_external_id	string The external ID of the attributed inventory source that Display & Video 360 selected as the best match from those accessible to the advertiser related to the view event based on floor price and auction type.
event.dv360_attributed_inventory_source_is_public	string True if inventory source is available to all buyers. False otherwise.
event.dv360_auction_id	string A string used to join events among view/click/conversion types, for example"ABCDEFGH_abcdefgh-0123456789". Do not assume any ordering, structure or meaning to the auction_id value.
event.dv360_bid_price_advertiser_currency	int The bid price sent to the exchange in advertiser currency nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics.
event.dv360_bid_price_partner_currency	int The bid price sent to the exchange in partner currency nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics.
event.dv360_bid_price_usd	int The bid price sent to the exchange in USD nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics..
event.dv360_billable_cost_advertiser_currency	int The total amount of money billed to the partner, including the media cost and partner costs, in advertiser currency nanos.
event.dv360_billable_cost_partner_currency	int The total amount of money billed to the partner, including the media cost and partner costs, in partner currency nanos.
event.dv360_billable_cost_usd	int The total amount of money billed to the partner, including the media cost and partner costs, in USD nanos.
event.dv360_browser_id	int The Display & Video 360 numerical ID identifying the browser related to this event.
event.dv360_browser_timezone_offset_minutes	int The difference in minutes between the active timezone on the user's browser and GMT-12, for example 1320 represents a browser timezone of GMT+10.
event.dv360_campaign_id	int The unique ID of the linked Display & Video 360 campaign.
event.dv360_city_id	int The Display & Video 360 numerical ID identifying the best-guess city of the impression.
event.dv360_country_code	string 2-letter ISO 3166-1 country code identifying the best-guess country of the impression, for example "US".
event.dv360_cpm_fee_1_advertiser_currency	int
event.dv360_cpm_fee_1_partner_currency	int
event.dv360_cpm_fee_1_usd	int
event.dv360_cpm_fee_2_advertiser_currency	int
event.dv360_cpm_fee_2_partner_currency	int
event.dv360_cpm_fee_2_usd	int
event.dv360_cpm_fee_3_advertiser_currency	int
event.dv360_cpm_fee_3_partner_currency	int
event.dv360_cpm_fee_3_usd	int
event.dv360_cpm_fee_4_advertiser_currency	int
event.dv360_cpm_fee_4_partner_currency	int
event.dv360_cpm_fee_4_usd	int
event.dv360_cpm_fee_5_advertiser_currency	int
event.dv360_cpm_fee_5_partner_currency	int
event.dv360_cpm_fee_5_usd	int
event.dv360_creative_id	int The Display & Video 360 numerical ID for the creative related to the event, for example 367487.
event.dv360_data_fees_advertiser_currency	int
event.dv360_data_fees_partner_currency	int
event.dv360_data_fees_usd	int
event.dv360_device_type	int The numerical value of the identified device type. 0 = Computer, 1 = Other, 2 = Smart Phone, 3 = Tablet, 4 = Smart TV, 5 = Connected TV, 6 = Set Top Box, 7 = Connected Device.
event.dv360_exchange_id	string The Display & Video 360 numerical ID for the exchange that requested the ad.
event.dv360_insertion_order_id	int The Display & Video 360 numerical ID for the insertion order related to the event, for example 1079941.
event.dv360_isp_id	int The Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.
event.dv360_language	string The ISO-639-1 code or "zh_CN" (Chinese (simplified)), "zh_TW" (Chinese (traditional)) or "other" representing the language related to the view event.
event.dv360_line_item_id	int The Display & Video 360 numerical ID for the line item related to the event, for example 1155785.
event.dv360_matching_targeted_keywords	string A comma separated string containing a list of targeted keywords matching the page related to the view event, for example "apple,orange,banana". Although the page related to the view event may match many keywords, only those which were targeted will be included; if the list of keywords is large we may impose a limit to the number of keywords returned.
event.dv360_matching_targeted_segments	string Space-separated IDs of targeted user lists that match the visitor, for example "-4 456". If the visitor is in a user list that is not targeted by the ad associated with this event it will not be included here.
event.dv360_media_cost_advertiser_currency	int The amount paid for the impression in advertiser currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
event.dv360_media_cost_partner_currency	int The amount paid for the impression in the partner currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
event.dv360_media_cost_usd	int The amount paid for the impression in USD nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
event.dv360_media_fee_1_advertiser_currency	int
event.dv360_media_fee_1_partner_currency	int
event.dv360_media_fee_1_usd	int
event.dv360_media_fee_2_advertiser_currency	int
event.dv360_media_fee_2_partner_currency	int
event.dv360_media_fee_2_usd	int
event.dv360_media_fee_3_advertiser_currency	int
event.dv360_media_fee_3_partner_currency	int
event.dv360_media_fee_3_usd	int
event.dv360_media_fee_4_advertiser_currency	int
event.dv360_media_fee_4_partner_currency	int
event.dv360_media_fee_4_usd	int
event.dv360_media_fee_5_advertiser_currency	int
event.dv360_media_fee_5_partner_currency	int
event.dv360_media_fee_5_usd	int
event.dv360_mobile_make_id	int The numerical ID for the mobile make. This value may be missing.
event.dv360_mobile_model_id	int The numerical ID for the mobile model. This value may be missing.
event.dv360_net_speed	int The Display & Video 360 numerical ID representing the network speed related to the view event. 1=Dial-up, 2=EDGE/2G, 3=UMTS/3G, 4=Basic DSL, 5=HSDPA/3.5G, 6=Broadband/4G, 7=Unknown.
event.dv360_operating_system_id	int
event.dv360_request_time	int A Unix timestamp in microseconds (1/1,000,000 second) for when we received the ad request, for example1330403779608570 represents Tuesday February 28th 2012 04:36:19.608570. Although this value is consistent across the view, click and conversion even it is not guaranteed to be unique - use auction_id to join events
event.dv360_revenue_advertiser_currency	int The total amount in advertiser currency nanos made by the partner account for the view event. This value may be zero.
event.dv360_revenue_partner_currency	int The total amount in partner currency nanos made by the partner account for the view event. This value may be zero.
event.dv360_revenue_usd	int The total amount in USD nanos made by the partner account for the view event. This value may be zero.
event.dv360_site_id	int The Display & Video 360 numerical ID for the most specific universal site that matches the url.
event.dv360_state_region_id	int DV360 Region ID
event.dv360_url	string The raw URL taken from the bid request received from the exchange, for example "http://www.example.com". As some exchanges mask the URL in their bid requests this value may be: "source_url_hidden"
event.dv360_view_state	string Populated for wrapped tags. (Two impression records when both events occur.) Possible values are: "OUTER", DV360 returned wrapped tag; "INNER", ad served post wrapped tag; "3PAS_MERGED", wrapped tag tracked by CM; "3PAS_OUTER", tracking ping sent to CM but no response, 3rd party blocked ad serving.
event.dv360_zip_postal_code	string DV360 ZIP/Postal Code
event.event_sub_type	string Contains further details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "POSTVIEW", "POSTCLICK" or blank for conversion events.
event.event_time	int Time in microseconds since 1970-01-01 00:00:00 UTC.
event.event_type	string Contains "RICH_MEDIA_INTERACTION".
event.floodlight_config_id	int Unique ID of the floodlight configuration.
event.impression_id	string Impression ID
event.interaction_time_utc_seconds	string Interaction Time
event.landing_page_url_id	int Unique ID of the landing page URL.
event.operating_system_id	int ID of the operating system.
event.ord_value	string The advertiser's ordinal ID, if relevant for a given activity type. Passed in the 'ord=' key-value (also used for storing the client's Order-ID in sales tags)
event.other_data	string Stores key-value data from the activity string which is not otherwise labeled. (Any key-value that is NOT "src=", "type=", "cat=", "ord=", "u=", "cost=", "qty=", "tran=", "a=", or "b="). (Can be used for further product breakdown aka "Custom Floodlight Variables")
event.placement_id	int Unique ID for the site page / placement where the ad ran.
event.platform_type_id	int Identifier that maps to the platform on which the event occured. Possible values are: 30000: desktop, 30001: high-end smartphone, 30002: tablet, 30003: mid-range smartphone, 30004: connected TV, 30005: unknown, 30006: set top box.
event.rendering_id	int Unique ID of the creative for Data Transfer. Does not correspond to the UI-Creative-ID.
event.rich_media_event_counters	int MET Counter Value (the ecn= value).
event.rich_media_event_id	int MET Event ID for the Rich Media ad.
event.rich_media_event_timers	double Time in microseconds since 1970-01-01 00:00:00 UTC.rs
event.rich_media_event_type_id	int ID of Rich Media Event Type.
event.segment_value_1	int Segment Value 1
event.site_id	int Unique ID for the site where the ad ran.
event.state	string ID for user's state or province (US/Canada)
event.tran_value	string TRAN Value
event.u_value	string U Value
event.zip_code	string Postal-Code (US/Canada).
network_id	int The network ID.
user_id	opaque The tracking ID (it is based on, but does not expose the user's browser cookie or mobile device ID). This field may be zeroed out for privacy reasons. User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

Campaign Manager 360 Data Transfer site

cm_dt_site
account_id	int Unique ID of the account.
site	string The name of the site.
site_directory	string Global unique name for this site.
site_directory_id	int Global unique ID for this site.
site_id	int Unique ID of the site.

Campaign Manager 360 Data Transfer state

cm_dt_state
region	string Abbreviated state/province name.
region_full_name	string Region name in English.

Campaign Manager 360 paths

cm_paths
floodlight_config_id	int Unique ID of the floodlight configuration. ID
network_id	int The network ID.
partner_id	int Unique ID of the partner.
path	record Row containing event path for a given user.
path.events	repeated struct
path.events.active_view_eligible_impressions	int Active View eligible impressions
path.events.active_view_measurable_impressions	int Active View measurable impressions
path.events.active_view_viewable_impressions	int Active View viewable impressions
path.events.activity_count	int Activity count
path.events.activity_id	int The ID of the Floodlight tag related to the conversion event.
path.events.activity_revenue	double Activity revenue
path.events.ad_id	int Unique ID of the ad placement.
path.events.advertiser_id	int Unique ID of the advertiser
path.events.audience_segment_id	int Unique ID of the audience segment.
path.events.browser_platform_id	string Browser platform ID
path.events.browser_version	string Browser version
path.events.campaign_id	int The unique ID of the Campaign Manager 360 campaign
path.events.city_id	int City ID
path.events.conversion_id	int Indicates whether an activity has been matched as a post-click (value of 1) or post-impression (value of 2), or unmatched (value of 0).
path.events.country_code	string 2-letter ISO 3166-1 country code.
path.events.creative_version	string Creative version number.
path.events.dma_region_id	int DMA region ID
path.events.dv360_ad_position	int Specifies the position of the ad on the page if known. 1 represents above the fold, 2 represents below the fold.
path.events.dv360_advertiser_id	int The Display & Video 360 numerical ID for the advertiser related to the event, for example 164332.
path.events.dv360_adx_page_categories	string Contains the Ad Exchange page category IDs separated by a space, for example "65 189". The categories may not be mutually exclusive.
path.events.dv360_attributed_inventory_source_external_id	string The external ID of the attributed inventory source that Display & Video 360 selected as the best match from those accessible to the advertiser related to the view event based on floor price and auction type.
path.events.dv360_attributed_inventory_source_is_public	string True if inventory source is available to all buyers. False otherwise.
path.events.dv360_auction_id	string A string used to join events among view/click/conversion types, for example"ABCDEFGH_abcdefgh-0123456789". Do not assume any ordering, structure or meaning to the auction_id value.
path.events.dv360_bid_price_advertiser_currency	int The bid price sent to the exchange in advertiser currency nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics.
path.events.dv360_bid_price_partner_currency	int The bid price sent to the exchange in partner currency nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics.
path.events.dv360_bid_price_usd	int The bid price sent to the exchange in USD nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics.
path.events.dv360_billable_cost_advertiser_currency	int The total amount of money billed to the partner, including the media cost and partner costs, in advertiser currency nanos.
path.events.dv360_billable_cost_partner_currency	int The total amount of money billed to the partner, including the media cost and partner costs, in partner currency nanos.
path.events.dv360_billable_cost_usd	int The total amount of money billed to the partner, including the media cost and partner costs, in USD nanos.
path.events.dv360_browser_id	int DV360 browser ID
path.events.dv360_browser_timezone_offset_minutes	int The difference in minutes between the active timezone on the user's browser and GMT-12, for example 1320 represents a browser timezone of GMT+10.
path.events.dv360_city_id	int The Display & Video 360 numerical ID identifying the best-guess city of the impression.
path.events.dv360_country_code	string 2-letter ISO 3166-1 country code identifying the best-guess country of the impression, for example "US".
path.events.dv360_cpm_fee_1_advertiser_currency	int The CPM 1 fee in advertiser currency nanos. This value may be zero.
path.events.dv360_cpm_fee_1_partner_currency	int The CPM 1 fee in partner currency nanos. This value may be zero.
path.events.dv360_cpm_fee_1_usd	int The CPM 1 fee in USD nanos. This value may be zero.
path.events.dv360_cpm_fee_2_advertiser_currency	int The CPM 2 fee in advertiser currency nanos. This value may be zero.
path.events.dv360_cpm_fee_2_partner_currency	int The CPM 2 fee in partner currency nanos. This value may be zero.
path.events.dv360_cpm_fee_2_usd	int The CPM 2 fee in USD nanos. This value may be zero.
path.events.dv360_cpm_fee_3_advertiser_currency	int The CPM 3 fee in advertiser currency nanos. This value may be zero.
path.events.dv360_cpm_fee_3_partner_currency	int The CPM 3 fee in partner currency nanos. This value may be zero.
path.events.dv360_cpm_fee_3_usd	int The CPM 3 fee in USD nanos. This value may be zero.
path.events.dv360_cpm_fee_4_advertiser_currency	int The CPM 4 fee in advertiser currency nanos. This value may be zero.
path.events.dv360_cpm_fee_4_partner_currency	int The CPM 4 fee in partner currency nanos. This value may be zero.
path.events.dv360_cpm_fee_4_usd	int The CPM 4 fee in USD nanos. This value may be zero.
path.events.dv360_cpm_fee_5_advertiser_currency	int The CPM 5 fee in advertiser currency nanos. This value may be zero.
path.events.dv360_cpm_fee_5_partner_currency	int The CPM 5 fee in partner currency nanos. This value may be zero.
path.events.dv360_cpm_fee_5_usd	int The CPM 5 fee in USD nanos. This value may be zero.
path.events.dv360_creative_id	int The Display & Video 360 numerical ID for the creative related to the event, for example 367487.
path.events.dv360_data_fees_advertiser_currency	int The cost of any data that was used to target this impression, in advertiser currency nanos.
path.events.dv360_data_fees_partner_currency	int The cost of any data that was used to target this impression, in partner currency nanos.
path.events.dv360_data_fees_usd	int The cost of any data that was used to target this impression, in USD nanos
path.events.dv360_device_type	int The numerical value of the identified device type. 0 = Computer, 1 = Other, 2 = Smart Phone, 3 = Tablet, 4 = Smart TV, 5 = Connected TV, 6 = Set Top Box, 7 = Connected Device.
path.events.dv360_exchange_id	string The Display & Video 360 numerical ID for the exchange that requested the ad.
path.events.dv360_insertion_order_id	int The Display & Video 360 numerical ID for the insertion order related to the event, for example 1079941.
path.events.dv360_isp_id	int The Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.
path.events.dv360_language	string The ISO-639-1 code or "zh_CN" (Chinese (simplified)), "zh_TW" (Chinese (traditional)) or "other" representing the language related to the view event.
path.events.dv360_line_item_id	int The Display & Video 360 numerical ID for the line item related to the event, for example 1155785.
path.events.dv360_matching_targeted_keywords	string A comma separated string containing a list of targeted keywords matching the page related to the view event, for example "apple,orange,banana". Although the page related to the view event may match many keywords, only those which were targeted will be included; if the list of keywords is large we may impose a limit to the number of keywords returned.
path.events.dv360_matching_targeted_segments	string Space-separated IDs of targeted user lists that match the visitor, for example "-4 456". If the visitor is in a user list that is not targeted by the ad associated with this event it will not be included here.
path.events.dv360_media_cost_advertiser_currency	int The amount paid for the impression in advertiser currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
path.events.dv360_media_cost_partner_currency	int The amount paid for the impression in the partner currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
path.events.dv360_media_cost_usd	int The amount paid for the impression in USD nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
path.events.dv360_media_fee_1_advertiser_currency	int The Media Fee 1 fee in advertiser currency nanos. This value may be zero.
path.events.dv360_media_fee_1_partner_currency	int The Media Fee 1 fee in partner currency nanos. This value may be zero.
path.events.dv360_media_fee_1_usd	int The Media Fee 1 fee in USD nanos. This value may be zero.
path.events.dv360_media_fee_2_advertiser_currency	int The Media Fee 2 fee in advertiser currency nanos. This value may be zero.
path.events.dv360_media_fee_2_partner_currency	int The Media Fee 2 fee in partner currency nanos. This value may be zero.
path.events.dv360_media_fee_2_usd	int The Media Fee 2 fee in USD nanos. This value may be zero.
path.events.dv360_media_fee_3_advertiser_currency	int The Media Fee 3 fee in advertiser currency nanos. This value may be zero.
path.events.dv360_media_fee_3_partner_currency	int The Media Fee 3 fee in partner currency nanos. This value may be zero.
path.events.dv360_media_fee_3_usd	int The Media Fee 3 fee in USD nanos. This value may be zero.
path.events.dv360_media_fee_4_advertiser_currency	int The Media Fee 4 fee in advertiser currency nanos. This value may be zero.
path.events.dv360_media_fee_4_partner_currency	int The Media Fee 4 fee in partner currency nanos. This value may be zero.
path.events.dv360_media_fee_4_usd	int The Media Fee 4 fee in USD nanos. This value may be zero.
path.events.dv360_media_fee_5_advertiser_currency	int The Media Fee 5 fee in advertiser currency nanos. This value may be zero.
path.events.dv360_media_fee_5_partner_currency	int The Media Fee 5 fee in partner currency nanos. This value may be zero.
path.events.dv360_media_fee_5_usd	int The Media Fee 5 fee in USD nanos. This value may be zero.
path.events.dv360_mobile_model_id	int The numerical ID for the mobile model. This value may be missing.
path.events.dv360_net_speed	int The Display & Video 360 numerical ID representing the network speed related to the view event. 1=Dial-up, 2=EDGE/2G, 3=UMTS/3G, 4=Basic DSL, 5=HSDPA/3.5G, 6=Broadband/4G, 7=Unknown.
path.events.dv360_request_time	int A Unix timestamp in microseconds (1/1,000,000 second) for when we received the ad request, for example1330403779608570 represents Tuesday February 28th 2012 04:36:19.608570. Although this value is consistent across the view, click and conversion even it is not guaranteed to be unique - use auction_id to join events
path.events.dv360_revenue_advertiser_currency	int DV360 revenue advertiser currency
path.events.dv360_revenue_partner_currency	int DV360 revenue partner currency
path.events.dv360_revenue_usd	int DV360 revenue usd
path.events.dv360_site_id	int The Display & Video 360 numerical ID for the most specific universal site that matches the url.
path.events.dv360_state_region_id	int An integer matching the state/region integer available in reporting and targeting.
path.events.dv360_url	string The raw URL taken from the bid request received from the exchange, for example "http://www.example.com". As some exchanges mask the URL in their bid requests this value may be: "source_url_hidden"
path.events.dv360_view_state	string Populated for wrapped tags. (Two impression records when both events occur.) Possible values are: "OUTER", DV360 returned wrapped tag; "INNER", ad served post wrapped tag; "3PAS_MERGED", wrapped tag tracked by CM; "3PAS_OUTER", tracking ping sent to CM but no response, 3rd party blocked ad serving.
path.events.dv360_zip_postal_code	string The postal code identifying the best-guess postal area of the impression if known, for example "98033". Do not assume uniqueness across different countries.
path.events.event_sub_type	string Event sub type
path.events.event_time	int Time in microseconds since 1970-01-01 00:00:00 UTC.
path.events.event_type	string Contains details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "CONVERSION" or "MODELED_CONVERSION" for conversion events.
path.events.floodlight_config_id	int Unique ID of the floodlight configuration. ID
path.events.impression_id	string Impression ID
path.events.interaction_time_utc_seconds	string The activity's associated (aka 'matched') click or impression time in microseconds since 1970-01-01 00:00:00 UTC.
path.events.landing_page_url_id	int Landing page url ID
path.events.operating_system_id	int ID of the operating system.
path.events.ord_value	string The advertiser's ordinal ID, if relevant for a given activity type. Passed in the 'ord=' key-value (also used for storing the client's Order-ID in sales tags)
path.events.other_data	string Stores key-value data from the activity string which is not otherwise labeled. (Any key-value that is NOT "src=", "type=", "cat=", "ord=", "u=", "cost=", "qty=", "tran=", "a=", or "b="). (Can be used for further product breakdown aka "Custom Floodlight Variables")
path.events.placement_id	int Unique ID for the site page / placement where the ad ran.
path.events.referrer_url	string Contains the URL on which the ad appeared, when possible. May also be empty, or return ad server URLs.
path.events.rendering_id	int Unique ID of the creative for Data Transfer. Does not correspond to the UI-Creative-ID.
path.events.rich_media_event_counters	int Rich media event counters
path.events.rich_media_event_id	int MET Event ID for the Rich Media ad.
path.events.rich_media_event_timers	double Rich media event timers
path.events.rich_media_event_type_id	int ID of Rich Media Event Type.
path.events.segment_value_1	int Segment value 1
path.events.site_id	int Site ID
path.events.state	string State
path.events.tran_value	string Tran value
path.events.u_value	string U value
path.events.zip_code	string Postal-Code (US/Canada).
user_id	opaque The tracking ID (it is based on, but does not expose the user's browser cookie or mobile device ID). This field may be zeroed out for privacy reasons. User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

DV360 Data Transfer Active View plus

dv360_dt_active_view_plus
event	struct
event.active_view_audible_impressions	int Active View: Impressions Audible
event.active_view_audible_time_msec	int Active View: Play Time Audible (milliseconds)
event.active_view_audible_visible_time_msec	int Active View: Play Time Audible and Visible (milliseconds)
event.active_view_background_count	int Active View: Impressions In Background
event.active_view_complete_viewable_impressions	int Active View: Impressions Visible at Completion
event.active_view_eligible_impressions	int Whether the impression was eligible to measure viewability. An impression is eligible if (a) the ad's creative has an Active View tag and (b) the tag successfully communicates with Google Marketing Platform servers at the time of the impression.
event.active_view_first_quartile_viewable_audible_impressions	int Active View: Impressions Visible and Audible at First Quartile
event.active_view_first_quartile_viewable_impressions	int Active View: Impressions Visible at First Quartile
event.active_view_fullscreen_count	int Active View: Impressions Full-Screen
event.active_view_impressions_audible_and_visible_at_completion	int Active View: Impressions Audible and Visible at Completion
event.active_view_impressions_visible10_seconds	int Active View: Impressions Visible 10 Seconds
event.active_view_measurable_impressions	int Whether the impression was measurable with Active View.
event.active_view_midpoint_viewable_audible_impressions	int Active View: Impressions Visible and Audible at Midpoint
event.active_view_midpoint_viewable_impressions	int Active View: Impressions Visible at Midpoint
event.active_view_plus_measurable_count	int Active View Plus: Measurable Impressions
event.active_view_start_viewable_audible_impressions	int Active View: Impressions Visible and Audible at Start
event.active_view_start_viewable_impressions	int Active View: Impressions Visible at Start
event.active_view_third_quartile_viewable_audible_impressions	int Active View: Impressions Visible and Audible at Third Quartile
event.active_view_third_quartile_viewable_impressions	int Active View: Impressions Visible at Third Quartile
event.active_view_tos_msec	int Active View: Time on Screen (milliseconds)
event.active_view_viewable_impressions	int Whether the impression was viewable.
event.active_view_visible_time_msec	int Active View: Video Visible Time (milliseconds)
event.activity_count	int Activity Quantity
event.activity_id	int The ID of the Floodlight tag related to the conversion event.
event.activity_revenue	double Activity Revenue
event.ad_id	int Unique ID of the ad placement.
event.advertiser_id	int Unique ID of the advertiser
event.browser_platform_id	string ID of the browser type.
event.browser_version	string Browser/Platform Version
event.campaign_id	int The unique ID of the Campaign Manager 360 campaign
event.city_id	int City ID
event.conversion_id	int Indicates whether an activity has been matched as a post-click (value of 1) or post-impression (value of 2), or unmatched (value of 0).
event.country_code	string Country
event.creative_version	string Creative version number.
event.dma_region_id	int Designated Market Area ID (US/Canada).
event.dv360_ad_position	int Specifies the position of the ad on the page if known. 1 represents above the fold, 2 represents below the fold.
event.dv360_advertiser_id	int The Display & Video 360 numerical ID for the advertiser related to the event, for example 164332.
event.dv360_adx_page_categories	string DV360 Adx Page Categories
event.dv360_attributed_inventory_source_external_id	string The external ID of the attributed inventory source that Display & Video 360 selected as the best match from those accessible to the advertiser related to the view event based on floor price and auction type.
event.dv360_attributed_inventory_source_is_public	string True if inventory source is available to all buyers. False otherwise.
event.dv360_auction_id	string A string used to join events among view/click/conversion types, for example"ABCDEFGH_abcdefgh-0123456789". Do not assume any ordering, structure or meaning to the auction_id value.
event.dv360_bid_price_advertiser_currency	int The bid price sent to the exchange in advertiser currency nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics.
event.dv360_bid_price_partner_currency	int The bid price sent to the exchange in partner currency nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics.
event.dv360_bid_price_usd	int The bid price sent to the exchange in USD nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics..
event.dv360_billable_cost_advertiser_currency	int The total amount of money billed to the partner, including the media cost and partner costs, in advertiser currency nanos.
event.dv360_billable_cost_partner_currency	int The total amount of money billed to the partner, including the media cost and partner costs, in partner currency nanos.
event.dv360_billable_cost_usd	int The total amount of money billed to the partner, including the media cost and partner costs, in USD nanos.
event.dv360_browser_id	int The Display & Video 360 numerical ID identifying the browser related to this event.
event.dv360_browser_timezone_offset_minutes	int The difference in minutes between the active timezone on the user's browser and GMT-12, for example 1320 represents a browser timezone of GMT+10.
event.dv360_campaign_id	int The unique ID of the linked Display & Video 360 campaign.
event.dv360_city_id	int The Display & Video 360 numerical ID identifying the best-guess city of the impression.
event.dv360_country_code	string 2-letter ISO 3166-1 country code identifying the best-guess country of the impression, for example "US".
event.dv360_cpm_fee_1_advertiser_currency	int
event.dv360_cpm_fee_1_partner_currency	int
event.dv360_cpm_fee_1_usd	int
event.dv360_cpm_fee_2_advertiser_currency	int
event.dv360_cpm_fee_2_partner_currency	int
event.dv360_cpm_fee_2_usd	int
event.dv360_cpm_fee_3_advertiser_currency	int
event.dv360_cpm_fee_3_partner_currency	int
event.dv360_cpm_fee_3_usd	int
event.dv360_cpm_fee_4_advertiser_currency	int
event.dv360_cpm_fee_4_partner_currency	int
event.dv360_cpm_fee_4_usd	int
event.dv360_cpm_fee_5_advertiser_currency	int
event.dv360_cpm_fee_5_partner_currency	int
event.dv360_cpm_fee_5_usd	int
event.dv360_creative_id	int The Display & Video 360 numerical ID for the creative related to the event, for example 367487.
event.dv360_data_fees_advertiser_currency	int
event.dv360_data_fees_partner_currency	int
event.dv360_data_fees_usd	int
event.dv360_device_type	int The numerical value of the identified device type. 0 = Computer, 1 = Other, 2 = Smart Phone, 3 = Tablet, 4 = Smart TV, 5 = Connected TV, 6 = Set Top Box, 7 = Connected Device.
event.dv360_exchange_id	string The Display & Video 360 numerical ID for the exchange that requested the ad.
event.dv360_insertion_order_id	int The Display & Video 360 numerical ID for the insertion order related to the event, for example 1079941.
event.dv360_isp_id	int The Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.
event.dv360_language	string The ISO-639-1 code or "zh_CN" (Chinese (simplified)), "zh_TW" (Chinese (traditional)) or "other" representing the language related to the view event.
event.dv360_line_item_id	int The Display & Video 360 numerical ID for the line item related to the event, for example 1155785.
event.dv360_matching_targeted_keywords	string A comma separated string containing a list of targeted keywords matching the page related to the view event, for example "apple,orange,banana". Although the page related to the view event may match many keywords, only those which were targeted will be included; if the list of keywords is large we may impose a limit to the number of keywords returned.
event.dv360_matching_targeted_segments	string Space-separated IDs of targeted user lists that match the visitor, for example "-4 456". If the visitor is in a user list that is not targeted by the ad associated with this event it will not be included here.
event.dv360_media_cost_advertiser_currency	int The amount paid for the impression in advertiser currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
event.dv360_media_cost_partner_currency	int The amount paid for the impression in the partner currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
event.dv360_media_cost_usd	int The amount paid for the impression in USD nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
event.dv360_media_fee_1_advertiser_currency	int
event.dv360_media_fee_1_partner_currency	int
event.dv360_media_fee_1_usd	int
event.dv360_media_fee_2_advertiser_currency	int
event.dv360_media_fee_2_partner_currency	int
event.dv360_media_fee_2_usd	int
event.dv360_media_fee_3_advertiser_currency	int
event.dv360_media_fee_3_partner_currency	int
event.dv360_media_fee_3_usd	int
event.dv360_media_fee_4_advertiser_currency	int
event.dv360_media_fee_4_partner_currency	int
event.dv360_media_fee_4_usd	int
event.dv360_media_fee_5_advertiser_currency	int
event.dv360_media_fee_5_partner_currency	int
event.dv360_media_fee_5_usd	int
event.dv360_mobile_make_id	int The numerical ID for the mobile make. This value may be missing.
event.dv360_mobile_model_id	int The numerical ID for the mobile model. This value may be missing.
event.dv360_net_speed	int The Display & Video 360 numerical ID representing the network speed related to the view event. 1=Dial-up, 2=EDGE/2G, 3=UMTS/3G, 4=Basic DSL, 5=HSDPA/3.5G, 6=Broadband/4G, 7=Unknown.
event.dv360_operating_system_id	int
event.dv360_request_time	int A Unix timestamp in microseconds (1/1,000,000 second) for when we received the ad request, for example1330403779608570 represents Tuesday February 28th 2012 04:36:19.608570. Although this value is consistent across the view, click and conversion even it is not guaranteed to be unique - use auction_id to join events
event.dv360_revenue_advertiser_currency	int The total amount in advertiser currency nanos made by the partner account for the view event. This value may be zero.
event.dv360_revenue_partner_currency	int The total amount in partner currency nanos made by the partner account for the view event. This value may be zero.
event.dv360_revenue_usd	int The total amount in USD nanos made by the partner account for the view event. This value may be zero.
event.dv360_site_id	int The Display & Video 360 numerical ID for the most specific universal site that matches the url.
event.dv360_state_region_id	int DV360 Region ID
event.dv360_url	string The raw URL taken from the bid request received from the exchange, for example "http://www.example.com". As some exchanges mask the URL in their bid requests this value may be: "source_url_hidden"
event.dv360_view_state	string Populated for wrapped tags. (Two impression records when both events occur.) Possible values are: "OUTER", DV360 returned wrapped tag; "INNER", ad served post wrapped tag; "3PAS_MERGED", wrapped tag tracked by CM; "3PAS_OUTER", tracking ping sent to CM but no response, 3rd party blocked ad serving.
event.dv360_zip_postal_code	string DV360 ZIP/Postal Code
event.event_sub_type	string Contains further details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "POSTVIEW", "POSTCLICK" or blank for conversion events.
event.event_time	int Time in microseconds since 1970-01-01 00:00:00 UTC.
event.event_type	string Contains "VIDEO_ACTIVE_VIEW_SESSION".
event.floodlight_config_id	int Unique ID of the floodlight configuration.
event.impression_id	string Impression ID
event.interaction_time_utc_seconds	string Interaction Time
event.landing_page_url_id	int Unique ID of the landing page URL.
event.operating_system_id	int ID of the operating system.
event.ord_value	string The advertiser's ordinal ID, if relevant for a given activity type. Passed in the 'ord=' key-value (also used for storing the client's Order-ID in sales tags)
event.other_data	string Stores key-value data from the activity string which is not otherwise labeled. (Any key-value that is NOT "src=", "type=", "cat=", "ord=", "u=", "cost=", "qty=", "tran=", "a=", or "b="). (Can be used for further product breakdown aka "Custom Floodlight Variables")
event.placement_id	int Unique ID for the site page / placement where the ad ran.
event.platform_type_id	int Identifier that maps to the platform on which the event occured. Possible values are: 30000: desktop, 30001: high-end smartphone, 30002: tablet, 30003: mid-range smartphone, 30004: connected TV, 30005: unknown, 30006: set top box.
event.rendering_id	int Unique ID of the creative for Data Transfer. Does not correspond to the UI-Creative-ID.
event.rich_media_event_counters	int MET Counter Value (the ecn= value).
event.rich_media_event_id	int MET Event ID for the Rich Media ad.
event.rich_media_event_timers	double Time in microseconds since 1970-01-01 00:00:00 UTC.rs
event.rich_media_event_type_id	int ID of Rich Media Event Type.
event.segment_value_1	int Segment Value 1
event.site_id	int Unique ID for the site where the ad ran.
event.state	string ID for user's state or province (US/Canada)
event.tran_value	string TRAN Value
event.u_value	string U Value
event.zip_code	string Postal-Code (US/Canada).
network_id	int The network ID.
user_id	opaque The tracking ID (it is based on, but does not expose the user's browser cookie or mobile device ID). This field may be zeroed out for privacy reasons. User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

DV360 Data Transfer activities (deprecated)

dv360_dt_activities
device_id_md5	string MD5-hashed device ID. Utility will be provided to hash raw device IDs to match.
event	struct
event.active_view_audible_impressions	int Active View: Impressions Audible
event.active_view_audible_time_msec	int Active View: Play Time Audible (milliseconds)
event.active_view_audible_visible_time_msec	int Active View: Play Time Audible and Visible (milliseconds)
event.active_view_background_count	int Active View: Impressions In Background
event.active_view_complete_viewable_impressions	int Active View: Impressions Visible at Completion
event.active_view_eligible_impressions	int Whether the impression was eligible to measure viewability. An impression is eligible if (a) the ad's creative has an Active View tag and (b) the tag successfully communicates with Google Marketing Platform servers at the time of the impression.
event.active_view_first_quartile_viewable_audible_impressions	int Active View: Impressions Visible and Audible at First Quartile
event.active_view_first_quartile_viewable_impressions	int Active View: Impressions Visible at First Quartile
event.active_view_fullscreen_count	int Active View: Impressions Full-Screen
event.active_view_impressions_audible_and_visible_at_completion	int Active View: Impressions Audible and Visible at Completion
event.active_view_impressions_visible10_seconds	int Active View: Impressions Visible 10 Seconds
event.active_view_measurable_impressions	int Whether the impression was measurable with Active View.
event.active_view_midpoint_viewable_audible_impressions	int Active View: Impressions Visible and Audible at Midpoint
event.active_view_midpoint_viewable_impressions	int Active View: Impressions Visible at Midpoint
event.active_view_plus_measurable_count	int Active View Plus: Measurable Impressions
event.active_view_start_viewable_audible_impressions	int Active View: Impressions Visible and Audible at Start
event.active_view_start_viewable_impressions	int Active View: Impressions Visible at Start
event.active_view_third_quartile_viewable_audible_impressions	int Active View: Impressions Visible and Audible at Third Quartile
event.active_view_third_quartile_viewable_impressions	int Active View: Impressions Visible at Third Quartile
event.active_view_tos_msec	int Active View: Time on Screen (milliseconds)
event.active_view_viewable_impressions	int Whether the impression was viewable.
event.active_view_visible_time_msec	int Active View: Video Visible Time (milliseconds)
event.activity_count	int Activity Quantity
event.activity_id	int The ID of the Floodlight tag related to the conversion event.
event.activity_revenue	double Activity Revenue
event.ad_id	int Unique ID of the ad placement.
event.advertiser_id	int Unique ID of the advertiser
event.browser_platform_id	string ID of the browser type.
event.browser_version	string Browser/Platform Version
event.campaign_id	int The unique ID of the Campaign Manager 360 campaign
event.city_id	int City ID
event.conversion_id	int Indicates whether an activity has been matched as a post-click (value of 1) or post-impression (value of 2), or unmatched (value of 0).
event.country_code	string Country
event.creative_version	string Creative version number.
event.dma_region_id	int Designated Market Area ID (US/Canada).
event.dv360_ad_position	int Specifies the position of the ad on the page if known. 1 represents above the fold, 2 represents below the fold.
event.dv360_advertiser_id	int The Display & Video 360 numerical ID for the advertiser related to the event, for example 164332.
event.dv360_adx_page_categories	string DV360 Adx Page Categories
event.dv360_attributed_inventory_source_external_id	string The external ID of the attributed inventory source that Display & Video 360 selected as the best match from those accessible to the advertiser related to the view event based on floor price and auction type.
event.dv360_attributed_inventory_source_is_public	string True if inventory source is available to all buyers. False otherwise.
event.dv360_auction_id	string A string used to join events among view/click/conversion types, for example"ABCDEFGH_abcdefgh-0123456789". Do not assume any ordering, structure or meaning to the auction_id value.
event.dv360_bid_price_advertiser_currency	int The bid price sent to the exchange in advertiser currency nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics.
event.dv360_bid_price_partner_currency	int The bid price sent to the exchange in partner currency nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics.
event.dv360_bid_price_usd	int The bid price sent to the exchange in USD nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics..
event.dv360_billable_cost_advertiser_currency	int The total amount of money billed to the partner, including the media cost and partner costs, in advertiser currency nanos.
event.dv360_billable_cost_partner_currency	int The total amount of money billed to the partner, including the media cost and partner costs, in partner currency nanos.
event.dv360_billable_cost_usd	int The total amount of money billed to the partner, including the media cost and partner costs, in USD nanos.
event.dv360_browser_id	int The Display & Video 360 numerical ID identifying the browser related to this event.
event.dv360_browser_timezone_offset_minutes	int The difference in minutes between the active timezone on the user's browser and GMT-12, for example 1320 represents a browser timezone of GMT+10.
event.dv360_campaign_id	int The unique ID of the linked Display & Video 360 campaign.
event.dv360_city_id	int The Display & Video 360 numerical ID identifying the best-guess city of the impression.
event.dv360_country_code	string 2-letter ISO 3166-1 country code identifying the best-guess country of the impression, for example "US".
event.dv360_cpm_fee_1_advertiser_currency	int
event.dv360_cpm_fee_1_partner_currency	int
event.dv360_cpm_fee_1_usd	int
event.dv360_cpm_fee_2_advertiser_currency	int
event.dv360_cpm_fee_2_partner_currency	int
event.dv360_cpm_fee_2_usd	int
event.dv360_cpm_fee_3_advertiser_currency	int
event.dv360_cpm_fee_3_partner_currency	int
event.dv360_cpm_fee_3_usd	int
event.dv360_cpm_fee_4_advertiser_currency	int
event.dv360_cpm_fee_4_partner_currency	int
event.dv360_cpm_fee_4_usd	int
event.dv360_cpm_fee_5_advertiser_currency	int
event.dv360_cpm_fee_5_partner_currency	int
event.dv360_cpm_fee_5_usd	int
event.dv360_creative_id	int The Display & Video 360 numerical ID for the creative related to the event, for example 367487.
event.dv360_data_fees_advertiser_currency	int
event.dv360_data_fees_partner_currency	int
event.dv360_data_fees_usd	int
event.dv360_device_type	int The numerical value of the identified device type. 0 = Computer, 1 = Other, 2 = Smart Phone, 3 = Tablet, 4 = Smart TV, 5 = Connected TV, 6 = Set Top Box, 7 = Connected Device.
event.dv360_exchange_id	string The Display & Video 360 numerical ID for the exchange that requested the ad.
event.dv360_insertion_order_id	int The Display & Video 360 numerical ID for the insertion order related to the event, for example 1079941.
event.dv360_isp_id	int The Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.
event.dv360_language	string The ISO-639-1 code or "zh_CN" (Chinese (simplified)), "zh_TW" (Chinese (traditional)) or "other" representing the language related to the view event.
event.dv360_line_item_id	int The Display & Video 360 numerical ID for the line item related to the event, for example 1155785.
event.dv360_matching_targeted_keywords	string A comma separated string containing a list of targeted keywords matching the page related to the view event, for example "apple,orange,banana". Although the page related to the view event may match many keywords, only those which were targeted will be included; if the list of keywords is large we may impose a limit to the number of keywords returned.
event.dv360_matching_targeted_segments	string Space-separated IDs of targeted user lists that match the visitor, for example "-4 456". If the visitor is in a user list that is not targeted by the ad associated with this event it will not be included here.
event.dv360_media_cost_advertiser_currency	int The amount paid for the impression in advertiser currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
event.dv360_media_cost_partner_currency	int The amount paid for the impression in the partner currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
event.dv360_media_cost_usd	int The amount paid for the impression in USD nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
event.dv360_media_fee_1_advertiser_currency	int
event.dv360_media_fee_1_partner_currency	int
event.dv360_media_fee_1_usd	int
event.dv360_media_fee_2_advertiser_currency	int
event.dv360_media_fee_2_partner_currency	int
event.dv360_media_fee_2_usd	int
event.dv360_media_fee_3_advertiser_currency	int
event.dv360_media_fee_3_partner_currency	int
event.dv360_media_fee_3_usd	int
event.dv360_media_fee_4_advertiser_currency	int
event.dv360_media_fee_4_partner_currency	int
event.dv360_media_fee_4_usd	int
event.dv360_media_fee_5_advertiser_currency	int
event.dv360_media_fee_5_partner_currency	int
event.dv360_media_fee_5_usd	int
event.dv360_mobile_make_id	int The numerical ID for the mobile make. This value may be missing.
event.dv360_mobile_model_id	int The numerical ID for the mobile model. This value may be missing.
event.dv360_net_speed	int The Display & Video 360 numerical ID representing the network speed related to the view event. 1=Dial-up, 2=EDGE/2G, 3=UMTS/3G, 4=Basic DSL, 5=HSDPA/3.5G, 6=Broadband/4G, 7=Unknown.
event.dv360_operating_system_id	int
event.dv360_request_time	int A Unix timestamp in microseconds (1/1,000,000 second) for when we received the ad request, for example1330403779608570 represents Tuesday February 28th 2012 04:36:19.608570. Although this value is consistent across the view, click and conversion even it is not guaranteed to be unique - use auction_id to join events
event.dv360_revenue_advertiser_currency	int The total amount in advertiser currency nanos made by the partner account for the view event. This value may be zero.
event.dv360_revenue_partner_currency	int The total amount in partner currency nanos made by the partner account for the view event. This value may be zero.
event.dv360_revenue_usd	int The total amount in USD nanos made by the partner account for the view event. This value may be zero.
event.dv360_site_id	int The Display & Video 360 numerical ID for the most specific universal site that matches the url.
event.dv360_state_region_id	int DV360 Region ID
event.dv360_url	string The raw URL taken from the bid request received from the exchange, for example "http://www.example.com". As some exchanges mask the URL in their bid requests this value may be: "source_url_hidden"
event.dv360_view_state	string Populated for wrapped tags. (Two impression records when both events occur.) Possible values are: "OUTER", DV360 returned wrapped tag; "INNER", ad served post wrapped tag; "3PAS_MERGED", wrapped tag tracked by CM; "3PAS_OUTER", tracking ping sent to CM but no response, 3rd party blocked ad serving.
event.dv360_zip_postal_code	string DV360 ZIP/Postal Code
event.event_sub_type	string Contains further details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "POSTVIEW", "POSTCLICK" or blank for conversion events.
event.event_time	int Time in microseconds since 1970-01-01 00:00:00 UTC.
event.event_type	string Contains details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "CONVERSION" or blank for conversion events.
event.floodlight_config_id	int Unique ID of the floodlight configuration.
event.impression_id	string Impression ID
event.interaction_time_utc_seconds	string Interaction Time
event.landing_page_url_id	int Unique ID of the landing page URL.
event.operating_system_id	int ID of the operating system.
event.ord_value	string The advertiser's ordinal ID, if relevant for a given activity type. Passed in the 'ord=' key-value (also used for storing the client's Order-ID in sales tags)
event.other_data	string Stores key-value data from the activity string which is not otherwise labeled. (Any key-value that is NOT "src=", "type=", "cat=", "ord=", "u=", "cost=", "qty=", "tran=", "a=", or "b="). (Can be used for further product breakdown aka "Custom Floodlight Variables")
event.placement_id	int Unique ID for the site page / placement where the ad ran.
event.rendering_id	int Unique ID of the creative for Data Transfer. Does not correspond to the UI-Creative-ID.
event.rich_media_event_counters	int MET Counter Value (the ecn= value).
event.rich_media_event_id	int MET Event ID for the Rich Media ad.
event.rich_media_event_timers	double Time in microseconds since 1970-01-01 00:00:00 UTC.rs
event.rich_media_event_type_id	int ID of Rich Media Event Type.
event.segment_value_1	int Segment Value 1
event.site_id	int Unique ID for the site where the ad ran.
event.state	string ID for user's state or province (US/Canada)
event.tran_value	string TRAN Value
event.u_value	string U Value
event.zip_code	string Postal-Code (US/Canada).
network_id	int The network ID.
user_id	opaque The tracking ID (it is based on, but does not expose the user's browser cookie or mobile device ID). This field may be zeroed out for privacy reasons. User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

DV360 Data Transfer activities attributed

dv360_dt_activities_attributed
event	struct
event.activity_id	int The ID of the Floodlight tag related to the conversion event.
event.ad_id	int Unique ID of the ad placement.
event.advertiser_id	int Unique ID of the advertiser
event.attribution_model_config_id	int Attribution model ID as displayed in DV360 UI.
event.browser_platform_id	string ID of the browser type.
event.browser_version	string Browser/Platform Version
event.campaign_id	int The unique ID of the Campaign Manager 360 campaign
event.city_id	int City ID
event.conversion_event_id	string Unique ID of the conversion event.
event.country_code	string Country
event.creative_version	string Creative version number.
event.dma_region_id	int Designated Market Area ID (US/Canada).
event.dv360_ad_position	int Specifies the position of the ad on the page if known. 1 represents above the fold, 2 represents below the fold.
event.dv360_advertiser_id	int The Display & Video 360 numerical ID for the advertiser related to the event, for example 164332.
event.dv360_adx_page_categories	string DV360 Adx Page Categories
event.dv360_attributed_inventory_source_external_id	string The external ID of the attributed inventory source that Display & Video 360 selected as the best match from those accessible to the advertiser related to the view event based on floor price and auction type.
event.dv360_attributed_inventory_source_is_public	string True if inventory source is available to all buyers. False otherwise.
event.dv360_auction_id	string A string used to join events among view/click/conversion types, for example"ABCDEFGH_abcdefgh-0123456789". Do not assume any ordering, structure or meaning to the auction_id value.
event.dv360_bid_price_advertiser_currency	int The bid price sent to the exchange in advertiser currency nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics.
event.dv360_bid_price_partner_currency	int The bid price sent to the exchange in partner currency nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics.
event.dv360_bid_price_usd	int The bid price sent to the exchange in USD nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics..
event.dv360_billable_cost_advertiser_currency	int The total amount of money billed to the partner, including the media cost and partner costs, in advertiser currency nanos.
event.dv360_billable_cost_partner_currency	int The total amount of money billed to the partner, including the media cost and partner costs, in partner currency nanos.
event.dv360_billable_cost_usd	int The total amount of money billed to the partner, including the media cost and partner costs, in USD nanos.
event.dv360_browser_id	int The Display & Video 360 numerical ID identifying the browser related to this event.
event.dv360_browser_timezone_offset_minutes	int The difference in minutes between the active timezone on the user's browser and GMT-12, for example 1320 represents a browser timezone of GMT+10.
event.dv360_campaign_id	int The unique ID of the linked Display & Video 360 campaign.
event.dv360_city_id	int The Display & Video 360 numerical ID identifying the best-guess city of the impression.
event.dv360_country_code	string 2-letter ISO 3166-1 country code identifying the best-guess country of the impression, for example "US".
event.dv360_cpm_fee_1_advertiser_currency	int
event.dv360_cpm_fee_1_partner_currency	int
event.dv360_cpm_fee_1_usd	int
event.dv360_cpm_fee_2_advertiser_currency	int
event.dv360_cpm_fee_2_partner_currency	int
event.dv360_cpm_fee_2_usd	int
event.dv360_cpm_fee_3_advertiser_currency	int
event.dv360_cpm_fee_3_partner_currency	int
event.dv360_cpm_fee_3_usd	int
event.dv360_cpm_fee_4_advertiser_currency	int
event.dv360_cpm_fee_4_partner_currency	int
event.dv360_cpm_fee_4_usd	int
event.dv360_cpm_fee_5_advertiser_currency	int
event.dv360_cpm_fee_5_partner_currency	int
event.dv360_cpm_fee_5_usd	int
event.dv360_creative_id	int The Display & Video 360 numerical ID for the creative related to the event, for example 367487.
event.dv360_data_fees_advertiser_currency	int
event.dv360_data_fees_partner_currency	int
event.dv360_data_fees_usd	int
event.dv360_device_type	int The numerical value of the identified device type. 0 = Computer, 1 = Other, 2 = Smart Phone, 3 = Tablet, 4 = Smart TV, 5 = Connected TV, 6 = Set Top Box, 7 = Connected Device.
event.dv360_exchange_id	string The Display & Video 360 numerical ID for the exchange that requested the ad.
event.dv360_insertion_order_id	int The Display & Video 360 numerical ID for the insertion order related to the event, for example 1079941.
event.dv360_isp_id	int The Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.
event.dv360_language	string The ISO-639-1 code or "zh_CN" (Chinese (simplified)), "zh_TW" (Chinese (traditional)) or "other" representing the language related to the view event.
event.dv360_line_item_id	int The Display & Video 360 numerical ID for the line item related to the event, for example 1155785.
event.dv360_matching_targeted_keywords	string A comma separated string containing a list of targeted keywords matching the page related to the view event, for example "apple,orange,banana". Although the page related to the view event may match many keywords, only those which were targeted will be included; if the list of keywords is large we may impose a limit to the number of keywords returned.
event.dv360_matching_targeted_segments	string Space-separated IDs of targeted user lists that match the visitor, for example "-4 456". If the visitor is in a user list that is not targeted by the ad associated with this event it will not be included here.
event.dv360_media_cost_advertiser_currency	int The amount paid for the impression in advertiser currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
event.dv360_media_cost_partner_currency	int The amount paid for the impression in the partner currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
event.dv360_media_cost_usd	int The amount paid for the impression in USD nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
event.dv360_media_fee_1_advertiser_currency	int
event.dv360_media_fee_1_partner_currency	int
event.dv360_media_fee_1_usd	int
event.dv360_media_fee_2_advertiser_currency	int
event.dv360_media_fee_2_partner_currency	int
event.dv360_media_fee_2_usd	int
event.dv360_media_fee_3_advertiser_currency	int
event.dv360_media_fee_3_partner_currency	int
event.dv360_media_fee_3_usd	int
event.dv360_media_fee_4_advertiser_currency	int
event.dv360_media_fee_4_partner_currency	int
event.dv360_media_fee_4_usd	int
event.dv360_media_fee_5_advertiser_currency	int
event.dv360_media_fee_5_partner_currency	int
event.dv360_media_fee_5_usd	int
event.dv360_mobile_make_id	int The numerical ID for the mobile make. This value may be missing.
event.dv360_mobile_model_id	int The numerical ID for the mobile model. This value may be missing.
event.dv360_net_speed	int The Display & Video 360 numerical ID representing the network speed related to the view event. 1=Dial-up, 2=EDGE/2G, 3=UMTS/3G, 4=Basic DSL, 5=HSDPA/3.5G, 6=Broadband/4G, 7=Unknown.
event.dv360_operating_system_id	int Operating System ID.
event.dv360_request_time	int A Unix timestamp in microseconds (1/1,000,000 second) for when we received the ad request, for example1330403779608570 represents Tuesday February 28th 2012 04:36:19.608570. Although this value is consistent across the view, click and conversion even it is not guaranteed to be unique - use auction_id to join events
event.dv360_revenue_advertiser_currency	int The total amount in advertiser currency nanos made by the partner account for the view event. This value may be zero.
event.dv360_revenue_partner_currency	int The total amount in partner currency nanos made by the partner account for the view event. This value may be zero.
event.dv360_revenue_usd	int The total amount in USD nanos made by the partner account for the view event. This value may be zero.
event.dv360_site_id	int The Display & Video 360 numerical ID for the most specific universal site that matches the url.
event.dv360_state_region_id	int DV360 Region ID
event.dv360_url	string The raw URL taken from the bid request received from the exchange, for example "http://www.example.com". As some exchanges mask the URL in their bid requests this value may be: "source_url_hidden"
event.dv360_view_state	string Populated for wrapped tags. (Two impression records when both events occur.) Possible values are: "OUTER", DV360 returned wrapped tag; "INNER", ad served post wrapped tag; "3PAS_MERGED", wrapped tag tracked by CM; "3PAS_OUTER", tracking ping sent to CM but no response, 3rd party blocked ad serving.
event.dv360_zip_postal_code	string DV360 ZIP/Postal Code
event.event_sub_type	string Contains further details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "POSTVIEW", "POSTCLICK" or blank for conversion events.
event.event_time	int Time in microseconds since 1970-01-01 00:00:00 UTC.
event.event_type	string Contains "CONVERSION" or "MODELED_CONVERSION".
event.floodlight_config_id	int Unique ID of the floodlight configuration.
event.interaction_time_utc_seconds	string Interaction Time
event.landing_page_url_id	int Unique ID of the landing page URL.
event.operating_system_id	int ID of the operating system.
event.ord_value	string The advertiser's ordinal ID, if relevant for a given activity type. Passed in the 'ord=' key-value (also used for storing the client's Order-ID in sales tags)
event.other_data	string Stores key-value data from the activity string which is not otherwise labeled. (Any key-value that is NOT "src=", "type=", "cat=", "ord=", "u=", "cost=", "qty=", "tran=", "a=", or "b="). (Can be used for further product breakdown aka "Custom Floodlight Variables")
event.placement_id	int Unique ID for the site page / placement where the ad ran.
event.rendering_id	int Unique ID of the creative for Data Transfer. Does not correspond to the UI-Creative-ID.
event.rich_media_event_counters	int MET Counter Value (the ecn= value).
event.rich_media_event_id	int MET Event ID for the Rich Media ad.
event.rich_media_event_timers	double Time in microseconds since 1970-01-01 00:00:00 UTC.rs
event.rich_media_event_type_id	int ID of Rich Media Event Type.
event.segment_value_1	int Segment Value 1
event.site_id	int Unique ID for the site where the ad ran.
event.state	string ID for user's state or province (US/Canada)
event.total_conversions	double The amount of conversion credit in nanos credited to the attributed event. For sales activities, Floodlight might count more than one conversion per event. For example, you can set up Floodlight to count the number of items purchased as the number of conversions for a single event. (The double value of the int event.activity_count in activities_events)
event.total_conversions_revenue	double The amount of revenue in USD megas credited to the attributed. You can multiply by 1,000,000 to see it as a dollar amount. (The attributed version of event.activity_revenue in activities_events)
event.total_transaction_count	double The number of transactions or activity tag fires in nanos credited to the attributed event.
event.tran_value	string TRAN Value
event.u_value	string U Value
event.zip_code	string Postal-Code (US/Canada).
network_id	int The network ID.
user_id	opaque The tracking ID (it is based on, but does not expose the user's browser cookie or mobile device ID). This field may be zeroed out for privacy reasons. User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

DV360 Data Transfer advertiser

dv360_dt_advertiser
dv360_advertiser	string Name of the advertiser.
dv360_advertiser_id	int Unique ID of the advertiser.
dv360_partner_id	int Unique ID of the partner.

DV360 Data Transfer campaign

dv360_dt_campaign
dv360_advertiser_id	int Unique ID of the advertiser.
dv360_campaign	string Name of the campaign
dv360_campaign_id	int The unique ID of the Display & Video 360 campaign.
dv360_partner_id	int Unique ID of the partner.

DV360 Data Transfer clicks

dv360_dt_clicks
event	struct
event.active_view_audible_impressions	int Active View: Impressions Audible
event.active_view_audible_time_msec	int Active View: Play Time Audible (milliseconds)
event.active_view_audible_visible_time_msec	int Active View: Play Time Audible and Visible (milliseconds)
event.active_view_background_count	int Active View: Impressions In Background
event.active_view_complete_viewable_impressions	int Active View: Impressions Visible at Completion
event.active_view_eligible_impressions	int Whether the impression was eligible to measure viewability. An impression is eligible if (a) the ad's creative has an Active View tag and (b) the tag successfully communicates with Google Marketing Platform servers at the time of the impression.
event.active_view_first_quartile_viewable_audible_impressions	int Active View: Impressions Visible and Audible at First Quartile
event.active_view_first_quartile_viewable_impressions	int Active View: Impressions Visible at First Quartile
event.active_view_fullscreen_count	int Active View: Impressions Full-Screen
event.active_view_impressions_audible_and_visible_at_completion	int Active View: Impressions Audible and Visible at Completion
event.active_view_impressions_visible10_seconds	int Active View: Impressions Visible 10 Seconds
event.active_view_measurable_impressions	int Whether the impression was measurable with Active View.
event.active_view_midpoint_viewable_audible_impressions	int Active View: Impressions Visible and Audible at Midpoint
event.active_view_midpoint_viewable_impressions	int Active View: Impressions Visible at Midpoint
event.active_view_plus_measurable_count	int Active View Plus: Measurable Impressions
event.active_view_start_viewable_audible_impressions	int Active View: Impressions Visible and Audible at Start
event.active_view_start_viewable_impressions	int Active View: Impressions Visible at Start
event.active_view_third_quartile_viewable_audible_impressions	int Active View: Impressions Visible and Audible at Third Quartile
event.active_view_third_quartile_viewable_impressions	int Active View: Impressions Visible at Third Quartile
event.active_view_tos_msec	int Active View: Time on Screen (milliseconds)
event.active_view_viewable_impressions	int Whether the impression was viewable.
event.active_view_visible_time_msec	int Active View: Video Visible Time (milliseconds)
event.activity_count	int Activity Quantity
event.activity_id	int The ID of the Floodlight tag related to the conversion event.
event.activity_revenue	double Activity Revenue
event.ad_id	int Unique ID of the ad placement.
event.advertiser_id	int Unique ID of the advertiser
event.audience_segment_id	int Unique ID of the audience segment.
event.browser_platform_id	string ID of the browser type.
event.browser_version	string Browser/Platform Version
event.campaign_id	int The unique ID of the Campaign Manager 360 campaign
event.city_id	int City ID
event.conversion_id	int Indicates whether an activity has been matched as a post-click (value of 1) or post-impression (value of 2), or unmatched (value of 0).
event.country_code	string Country
event.creative_version	string Creative version number.
event.dma_region_id	int Designated Market Area ID (US/Canada).
event.dv360_ad_position	int Specifies the position of the ad on the page if known. 1 represents above the fold, 2 represents below the fold.
event.dv360_advertiser_id	int The Display & Video 360 numerical ID for the advertiser related to the event, for example 164332.
event.dv360_adx_page_categories	string DV360 Adx Page Categories
event.dv360_attributed_inventory_source_external_id	string The external ID of the attributed inventory source that Display & Video 360 selected as the best match from those accessible to the advertiser related to the view event based on floor price and auction type.
event.dv360_attributed_inventory_source_is_public	string True if inventory source is available to all buyers. False otherwise.
event.dv360_auction_id	string A string used to join events among view/click/conversion types, for example"ABCDEFGH_abcdefgh-0123456789". Do not assume any ordering, structure or meaning to the auction_id value.
event.dv360_bid_price_advertiser_currency	int The bid price sent to the exchange in advertiser currency nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics.
event.dv360_bid_price_partner_currency	int The bid price sent to the exchange in partner currency nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics.
event.dv360_bid_price_usd	int The bid price sent to the exchange in USD nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics..
event.dv360_billable_cost_advertiser_currency	int The total amount of money billed to the partner, including the media cost and partner costs, in advertiser currency nanos.
event.dv360_billable_cost_partner_currency	int The total amount of money billed to the partner, including the media cost and partner costs, in partner currency nanos.
event.dv360_billable_cost_usd	int The total amount of money billed to the partner, including the media cost and partner costs, in USD nanos.
event.dv360_browser_id	int The Display & Video 360 numerical ID identifying the browser related to this event.
event.dv360_browser_timezone_offset_minutes	int The difference in minutes between the active timezone on the user's browser and GMT-12, for example 1320 represents a browser timezone of GMT+10.
event.dv360_campaign_id	int The unique ID of the linked Display & Video 360 campaign.
event.dv360_city_id	int The Display & Video 360 numerical ID identifying the best-guess city of the impression.
event.dv360_country_code	string 2-letter ISO 3166-1 country code identifying the best-guess country of the impression, for example "US".
event.dv360_cpm_fee_1_advertiser_currency	int
event.dv360_cpm_fee_1_partner_currency	int
event.dv360_cpm_fee_1_usd	int
event.dv360_cpm_fee_2_advertiser_currency	int
event.dv360_cpm_fee_2_partner_currency	int
event.dv360_cpm_fee_2_usd	int
event.dv360_cpm_fee_3_advertiser_currency	int
event.dv360_cpm_fee_3_partner_currency	int
event.dv360_cpm_fee_3_usd	int
event.dv360_cpm_fee_4_advertiser_currency	int
event.dv360_cpm_fee_4_partner_currency	int
event.dv360_cpm_fee_4_usd	int
event.dv360_cpm_fee_5_advertiser_currency	int
event.dv360_cpm_fee_5_partner_currency	int
event.dv360_cpm_fee_5_usd	int
event.dv360_creative_id	int The Display & Video 360 numerical ID for the creative related to the event, for example 367487.
event.dv360_data_fees_advertiser_currency	int
event.dv360_data_fees_partner_currency	int
event.dv360_data_fees_usd	int
event.dv360_device_type	int The numerical value of the identified device type. 0 = Computer, 1 = Other, 2 = Smart Phone, 3 = Tablet, 4 = Smart TV, 5 = Connected TV, 6 = Set Top Box, 7 = Connected Device.
event.dv360_exchange_id	string The Display & Video 360 numerical ID for the exchange that requested the ad.
event.dv360_insertion_order_id	int The Display & Video 360 numerical ID for the insertion order related to the event, for example 1079941.
event.dv360_isp_id	int The Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.
event.dv360_language	string The ISO-639-1 code or "zh_CN" (Chinese (simplified)), "zh_TW" (Chinese (traditional)) or "other" representing the language related to the view event.
event.dv360_line_item_id	int The Display & Video 360 numerical ID for the line item related to the event, for example 1155785.
event.dv360_matching_targeted_keywords	string A comma separated string containing a list of targeted keywords matching the page related to the view event, for example "apple,orange,banana". Although the page related to the view event may match many keywords, only those which were targeted will be included; if the list of keywords is large we may impose a limit to the number of keywords returned.
event.dv360_matching_targeted_segments	string Space-separated IDs of targeted user lists that match the visitor, for example "-4 456". If the visitor is in a user list that is not targeted by the ad associated with this event it will not be included here.
event.dv360_media_cost_advertiser_currency	int The amount paid for the impression in advertiser currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
event.dv360_media_cost_partner_currency	int The amount paid for the impression in the partner currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
event.dv360_media_cost_usd	int The amount paid for the impression in USD nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
event.dv360_media_fee_1_advertiser_currency	int
event.dv360_media_fee_1_partner_currency	int
event.dv360_media_fee_1_usd	int
event.dv360_media_fee_2_advertiser_currency	int
event.dv360_media_fee_2_partner_currency	int
event.dv360_media_fee_2_usd	int
event.dv360_media_fee_3_advertiser_currency	int
event.dv360_media_fee_3_partner_currency	int
event.dv360_media_fee_3_usd	int
event.dv360_media_fee_4_advertiser_currency	int
event.dv360_media_fee_4_partner_currency	int
event.dv360_media_fee_4_usd	int
event.dv360_media_fee_5_advertiser_currency	int
event.dv360_media_fee_5_partner_currency	int
event.dv360_media_fee_5_usd	int
event.dv360_mobile_make_id	int The numerical ID for the mobile make. This value may be missing.
event.dv360_mobile_model_id	int The numerical ID for the mobile model. This value may be missing.
event.dv360_net_speed	int The Display & Video 360 numerical ID representing the network speed related to the view event. 1=Dial-up, 2=EDGE/2G, 3=UMTS/3G, 4=Basic DSL, 5=HSDPA/3.5G, 6=Broadband/4G, 7=Unknown.
event.dv360_operating_system_id	int
event.dv360_request_time	int A Unix timestamp in microseconds (1/1,000,000 second) for when we received the ad request, for example1330403779608570 represents Tuesday February 28th 2012 04:36:19.608570. Although this value is consistent across the view, click and conversion even it is not guaranteed to be unique - use auction_id to join events
event.dv360_revenue_advertiser_currency	int The total amount in advertiser currency nanos made by the partner account for the view event. This value may be zero.
event.dv360_revenue_partner_currency	int The total amount in partner currency nanos made by the partner account for the view event. This value may be zero.
event.dv360_revenue_usd	int The total amount in USD nanos made by the partner account for the view event. This value may be zero.
event.dv360_site_id	int The Display & Video 360 numerical ID for the most specific universal site that matches the url.
event.dv360_state_region_id	int DV360 Region ID
event.dv360_url	string The raw URL taken from the bid request received from the exchange, for example "http://www.example.com". As some exchanges mask the URL in their bid requests this value may be: "source_url_hidden"
event.dv360_view_state	string Populated for wrapped tags. (Two impression records when both events occur.) Possible values are: "OUTER", DV360 returned wrapped tag; "INNER", ad served post wrapped tag; "3PAS_MERGED", wrapped tag tracked by CM; "3PAS_OUTER", tracking ping sent to CM but no response, 3rd party blocked ad serving.
event.dv360_zip_postal_code	string DV360 ZIP/Postal Code
event.event_sub_type	string Contains further details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "POSTVIEW", "POSTCLICK" or blank for conversion events.
event.event_time	int Time in microseconds since 1970-01-01 00:00:00 UTC.
event.event_type	string Contains "CLICK".
event.floodlight_config_id	int Unique ID of the floodlight configuration.
event.impression_id	string Impression ID
event.interaction_time_utc_seconds	string Interaction Time
event.landing_page_url_id	int Unique ID of the landing page URL.
event.operating_system_id	int ID of the operating system.
event.ord_value	string The advertiser's ordinal ID, if relevant for a given activity type. Passed in the 'ord=' key-value (also used for storing the client's Order-ID in sales tags)
event.other_data	string Stores key-value data from the activity string which is not otherwise labeled. (Any key-value that is NOT "src=", "type=", "cat=", "ord=", "u=", "cost=", "qty=", "tran=", "a=", or "b="). (Can be used for further product breakdown aka "Custom Floodlight Variables")
event.placement_id	int Unique ID for the site page / placement where the ad ran.
event.platform_type_id	int Identifier that maps to the platform on which the event occured. Possible values are: 30000: desktop, 30001: high-end smartphone, 30002: tablet, 30003: mid-range smartphone, 30004: connected TV, 30005: unknown, 30006: set top box.
event.rendering_id	int Unique ID of the creative for Data Transfer. Does not correspond to the UI-Creative-ID.
event.rich_media_event_counters	int MET Counter Value (the ecn= value).
event.rich_media_event_id	int MET Event ID for the Rich Media ad.
event.rich_media_event_timers	double Time in microseconds since 1970-01-01 00:00:00 UTC.rs
event.rich_media_event_type_id	int ID of Rich Media Event Type.
event.segment_value_1	int Segment Value 1
event.site_id	int Unique ID for the site where the ad ran.
event.state	string ID for user's state or province (US/Canada)
event.tran_value	string TRAN Value
event.u_value	string U Value
event.zip_code	string Postal-Code (US/Canada).
network_id	int The network ID.
user_id	opaque The tracking ID (it is based on, but does not expose the user's browser cookie or mobile device ID). This field may be zeroed out for privacy reasons. User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

DV360 Data Transfer impressions

dv360_dt_impressions
event	struct
event.active_view_audible_impressions	int Active View: Impressions Audible
event.active_view_audible_time_msec	int Active View: Play Time Audible (milliseconds)
event.active_view_audible_visible_time_msec	int Active View: Play Time Audible and Visible (milliseconds)
event.active_view_background_count	int Active View: Impressions In Background
event.active_view_complete_viewable_impressions	int Active View: Impressions Visible at Completion
event.active_view_eligible_impressions	int Whether the impression was eligible to measure viewability. An impression is eligible if (a) the ad's creative has an Active View tag and (b) the tag successfully communicates with Google Marketing Platform servers at the time of the impression.
event.active_view_first_quartile_viewable_audible_impressions	int Active View: Impressions Visible and Audible at First Quartile
event.active_view_first_quartile_viewable_impressions	int Active View: Impressions Visible at First Quartile
event.active_view_fullscreen_count	int Active View: Impressions Full-Screen
event.active_view_impressions_audible_and_visible_at_completion	int Active View: Impressions Audible and Visible at Completion
event.active_view_impressions_visible10_seconds	int Active View: Impressions Visible 10 Seconds
event.active_view_measurable_impressions	int Whether the impression was measurable with Active View.
event.active_view_midpoint_viewable_audible_impressions	int Active View: Impressions Visible and Audible at Midpoint
event.active_view_midpoint_viewable_impressions	int Active View: Impressions Visible at Midpoint
event.active_view_plus_measurable_count	int Active View Plus: Measurable Impressions
event.active_view_start_viewable_audible_impressions	int Active View: Impressions Visible and Audible at Start
event.active_view_start_viewable_impressions	int Active View: Impressions Visible at Start
event.active_view_third_quartile_viewable_audible_impressions	int Active View: Impressions Visible and Audible at Third Quartile
event.active_view_third_quartile_viewable_impressions	int Active View: Impressions Visible at Third Quartile
event.active_view_tos_msec	int Active View: Time on Screen (milliseconds)
event.active_view_viewable_impressions	int Whether the impression was viewable.
event.active_view_visible_time_msec	int Active View: Video Visible Time (milliseconds)
event.activity_count	int Activity Quantity
event.activity_id	int The ID of the Floodlight tag related to the conversion event.
event.activity_revenue	double Activity Revenue
event.ad_id	int Unique ID of the ad placement.
event.advertiser_id	int Unique ID of the advertiser
event.audience_segment_id	int Unique ID of the audience segment.
event.browser_platform_id	string ID of the browser type.
event.browser_version	string Browser/Platform Version
event.campaign_id	int The unique ID of the Campaign Manager 360 campaign
event.city_id	int City ID
event.conversion_id	int Indicates whether an activity has been matched as a post-click (value of 1) or post-impression (value of 2), or unmatched (value of 0).
event.country_code	string Country
event.creative_version	string Creative version number.
event.dma_region_id	int Designated Market Area ID (US/Canada).
event.dv360_ad_position	int Specifies the position of the ad on the page if known. 1 represents above the fold, 2 represents below the fold.
event.dv360_advertiser_id	int The Display & Video 360 numerical ID for the advertiser related to the event, for example 164332.
event.dv360_adx_page_categories	string DV360 Adx Page Categories
event.dv360_attributed_inventory_source_external_id	string The external ID of the attributed inventory source that Display & Video 360 selected as the best match from those accessible to the advertiser related to the view event based on floor price and auction type.
event.dv360_attributed_inventory_source_is_public	string True if inventory source is available to all buyers. False otherwise.
event.dv360_auction_id	string A string used to join events among view/click/conversion types, for example"ABCDEFGH_abcdefgh-0123456789". Do not assume any ordering, structure or meaning to the auction_id value.
event.dv360_bid_price_advertiser_currency	int The bid price sent to the exchange in advertiser currency nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics.
event.dv360_bid_price_partner_currency	int The bid price sent to the exchange in partner currency nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics.
event.dv360_bid_price_usd	int The bid price sent to the exchange in USD nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics..
event.dv360_bid_request_publisher_id	string The publisher id in the publisher.id field of bid request.
event.dv360_billable_cost_advertiser_currency	int The total amount of money billed to the partner, including the media cost and partner costs, in advertiser currency nanos.
event.dv360_billable_cost_partner_currency	int The total amount of money billed to the partner, including the media cost and partner costs, in partner currency nanos.
event.dv360_billable_cost_usd	int The total amount of money billed to the partner, including the media cost and partner costs, in USD nanos.
event.dv360_browser_id	int The Display & Video 360 numerical ID identifying the browser related to this event.
event.dv360_browser_timezone_offset_minutes	int The difference in minutes between the active timezone on the user's browser and GMT-12, for example 1320 represents a browser timezone of GMT+10.
event.dv360_campaign_id	int The unique ID of the linked Display & Video 360 campaign.
event.dv360_city_id	int The Display & Video 360 numerical ID identifying the best-guess city of the impression.
event.dv360_country_code	string 2-letter ISO 3166-1 country code identifying the best-guess country of the impression, for example "US".
event.dv360_cpm_fee_1_advertiser_currency	int
event.dv360_cpm_fee_1_partner_currency	int
event.dv360_cpm_fee_1_usd	int
event.dv360_cpm_fee_2_advertiser_currency	int
event.dv360_cpm_fee_2_partner_currency	int
event.dv360_cpm_fee_2_usd	int
event.dv360_cpm_fee_3_advertiser_currency	int
event.dv360_cpm_fee_3_partner_currency	int
event.dv360_cpm_fee_3_usd	int
event.dv360_cpm_fee_4_advertiser_currency	int
event.dv360_cpm_fee_4_partner_currency	int
event.dv360_cpm_fee_4_usd	int
event.dv360_cpm_fee_5_advertiser_currency	int
event.dv360_cpm_fee_5_partner_currency	int
event.dv360_cpm_fee_5_usd	int
event.dv360_creative_id	int The Display & Video 360 numerical ID for the creative related to the event, for example 367487.
event.dv360_data_fees_advertiser_currency	int
event.dv360_data_fees_partner_currency	int
event.dv360_data_fees_usd	int
event.dv360_device_type	int The numerical value of the identified device type. 0 = Computer, 1 = Other, 2 = Smart Phone, 3 = Tablet, 4 = Smart TV, 5 = Connected TV, 6 = Set Top Box, 7 = Connected Device.
event.dv360_exchange_id	string The Display & Video 360 numerical ID for the exchange that requested the ad.
event.dv360_insertion_order_id	int The Display & Video 360 numerical ID for the insertion order related to the event, for example 1079941.
event.dv360_isp_id	int The Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.
event.dv360_language	string The ISO-639-1 code or "zh_CN" (Chinese (simplified)), "zh_TW" (Chinese (traditional)) or "other" representing the language related to the view event.
event.dv360_line_item_id	int The Display & Video 360 numerical ID for the line item related to the event, for example 1155785.
event.dv360_matching_targeted_keywords	string A comma separated string containing a list of targeted keywords matching the page related to the view event, for example "apple,orange,banana". Although the page related to the view event may match many keywords, only those which were targeted will be included; if the list of keywords is large we may impose a limit to the number of keywords returned.
event.dv360_matching_targeted_segments	string Space-separated IDs of targeted user lists that match the visitor, for example "-4 456". If the visitor is in a user list that is not targeted by the ad associated with this event it will not be included here.
event.dv360_media_cost_advertiser_currency	int The amount paid for the impression in advertiser currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
event.dv360_media_cost_partner_currency	int The amount paid for the impression in the partner currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
event.dv360_media_cost_usd	int The amount paid for the impression in USD nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
event.dv360_media_fee_1_advertiser_currency	int
event.dv360_media_fee_1_partner_currency	int
event.dv360_media_fee_1_usd	int
event.dv360_media_fee_2_advertiser_currency	int
event.dv360_media_fee_2_partner_currency	int
event.dv360_media_fee_2_usd	int
event.dv360_media_fee_3_advertiser_currency	int
event.dv360_media_fee_3_partner_currency	int
event.dv360_media_fee_3_usd	int
event.dv360_media_fee_4_advertiser_currency	int
event.dv360_media_fee_4_partner_currency	int
event.dv360_media_fee_4_usd	int
event.dv360_media_fee_5_advertiser_currency	int
event.dv360_media_fee_5_partner_currency	int
event.dv360_media_fee_5_usd	int
event.dv360_mobile_make_id	int The numerical ID for the mobile make. This value may be missing.
event.dv360_mobile_model_id	int The numerical ID for the mobile model. This value may be missing.
event.dv360_net_speed	int The Display & Video 360 numerical ID representing the network speed related to the view event. 1=Dial-up, 2=EDGE/2G, 3=UMTS/3G, 4=Basic DSL, 5=HSDPA/3.5G, 6=Broadband/4G, 7=Unknown.
event.dv360_operating_system_id	int
event.dv360_request_time	int A Unix timestamp in microseconds (1/1,000,000 second) for when we received the ad request, for example1330403779608570 represents Tuesday February 28th 2012 04:36:19.608570. Although this value is consistent across the view, click and conversion even it is not guaranteed to be unique - use auction_id to join events
event.dv360_revenue_advertiser_currency	int The total amount in advertiser currency nanos made by the partner account for the view event. This value may be zero.
event.dv360_revenue_partner_currency	int The total amount in partner currency nanos made by the partner account for the view event. This value may be zero.
event.dv360_revenue_usd	int The total amount in USD nanos made by the partner account for the view event. This value may be zero.
event.dv360_site_id	int The Display & Video 360 numerical ID for the most specific universal site that matches the url.
event.dv360_state_region_id	int DV360 Region ID
event.dv360_supply_chain_complete	boolean Indicates whether the supply chain object is complete in the bid request.
event.dv360_supply_chain_domain	array The domain in the supply path, the order is the same as the order in the supply chain JSON.
event.dv360_supply_chain_seller_id	array Array of strings. The seller ID in the supply path, the order is the same as the order in the supply chain JSON.
event.dv360_url	string The raw URL taken from the bid request received from the exchange, for example "http://www.example.com". As some exchanges mask the URL in their bid requests this value may be: "source_url_hidden"
event.dv360_view_state	string Populated for wrapped tags. (Two impression records when both events occur.) Possible values are: "OUTER", DV360 returned wrapped tag; "INNER", ad served post wrapped tag; "3PAS_MERGED", wrapped tag tracked by CM; "3PAS_OUTER", tracking ping sent to CM but no response, 3rd party blocked ad serving.
event.dv360_zip_postal_code	string DV360 ZIP/Postal Code
event.event_sub_type	string Contains further details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "POSTVIEW", "POSTCLICK" or blank for conversion events.
event.event_time	int Time in microseconds since 1970-01-01 00:00:00 UTC.
event.event_type	string Contains "VIEW".
event.floodlight_config_id	int Unique ID of the floodlight configuration.
event.impression_id	string Impression ID
event.interaction_time_utc_seconds	string Interaction Time
event.landing_page_url_id	int Unique ID of the landing page URL.
event.operating_system_id	int ID of the operating system.
event.ord_value	string The advertiser's ordinal ID, if relevant for a given activity type. Passed in the 'ord=' key-value (also used for storing the client's Order-ID in sales tags)
event.other_data	string Stores key-value data from the activity string which is not otherwise labeled. (Any key-value that is NOT "src=", "type=", "cat=", "ord=", "u=", "cost=", "qty=", "tran=", "a=", or "b="). (Can be used for further product breakdown aka "Custom Floodlight Variables")
event.placement_id	int Unique ID for the site page / placement where the ad ran.
event.rendering_id	int Unique ID of the creative for Data Transfer. Does not correspond to the UI-Creative-ID.
event.rich_media_event_counters	int MET Counter Value (the ecn= value).
event.rich_media_event_id	int MET Event ID for the Rich Media ad.
event.rich_media_event_timers	double Time in microseconds since 1970-01-01 00:00:00 UTC.rs
event.rich_media_event_type_id	int ID of Rich Media Event Type.
event.segment_value_1	int Segment Value 1
event.site_id	int Unique ID for the site where the ad ran.
event.state	string ID for user's state or province (US/Canada)
event.tran_value	string TRAN Value
event.u_value	string U Value
event.zip_code	string Postal-Code (US/Canada).
network_id	int The network ID.
user_id	opaque The tracking ID (it is based on, but does not expose the user's browser cookie or mobile device ID). This field may be zeroed out for privacy reasons. User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

DV360 Data Transfer insertion order

dv360_dt_insertion_order
dv360_advertiser_id	int Unique ID of the advertiser.
dv360_campaign_id	int The unique ID of the Display & Video 360 campaign.
dv360_insertion_order	string Name of the insertion order.
dv360_insertion_order_id	int Unique ID of the insertion order.
dv360_partner_id	int Unique ID of the partner.

DV360 Data Transfer line item

dv360_dt_line_item
dv360_advertiser_id	int Unique ID of the advertiser.
dv360_campaign_id	int The unique ID of the Display & Video 360 campaign.
dv360_insertion_order_id	int Unique ID of the insertion order.
dv360_line_item	string Name of the line item.
dv360_line_item_id	int Unique ID of the line item.
dv360_partner_id	int Unique ID of the partner.

DV360 paths

dv360_paths
dv360_paths.floodlight_config_id	int Unique ID of the floodlight configuration. ID
network_id	int The network ID.
partner_id	int Unique ID of the partner.
path	record Row containing event path for a given user.
path.events	repeated struct
path.events.active_view_eligible_impressions	int Active View eligible impressions
path.events.active_view_measurable_impressions	int Active View measurable impressions
path.events.active_view_viewable_impressions	int Active View viewable impressions
path.events.activity_count	int Activity count
path.events.activity_id	int The ID of the Floodlight tag related to the conversion event.
path.events.activity_revenue	double Activity revenue
path.events.ad_id	int Unique ID of the ad placement.
path.events.advertiser_id	int Unique ID of the advertiser
path.events.audience_segment_id	int Unique ID of the audience segment.
path.events.browser_platform_id	string Browser platform ID
path.events.browser_version	string Browser version
path.events.campaign_id	int The unique ID of the Campaign Manager 360 campaign
path.events.city_id	int City ID
path.events.conversion_id	int Indicates whether an activity has been matched as a post-click (value of 1) or post-impression (value of 2), or unmatched (value of 0).
path.events.country_code	string 2-letter ISO 3166-1 country code.
path.events.creative_version	string Creative version number.
path.events.dma_region_id	int DMA region ID
path.events.dv360_ad_position	int Specifies the position of the ad on the page if known. 1 represents above the fold, 2 represents below the fold.
path.events.dv360_advertiser_id	int The Display & Video 360 numerical ID for the advertiser related to the event, for example 164332.
path.events.dv360_adx_page_categories	string Contains the Ad Exchange page category IDs separated by a space, for example "65 189". The categories may not be mutually exclusive.
path.events.dv360_attributed_inventory_source_external_id	string The external ID of the attributed inventory source that Display & Video 360 selected as the best match from those accessible to the advertiser related to the view event based on floor price and auction type.
path.events.dv360_attributed_inventory_source_is_public	string True if inventory source is available to all buyers. False otherwise.
path.events.dv360_auction_id	string A string used to join events among view/click/conversion types, for example"ABCDEFGH_abcdefgh-0123456789". Do not assume any ordering, structure or meaning to the auction_id value.
path.events.dv360_bid_price_advertiser_currency	int The bid price sent to the exchange in advertiser currency nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics.
path.events.dv360_bid_price_partner_currency	int The bid price sent to the exchange in partner currency nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics.
path.events.dv360_bid_price_usd	int The bid price sent to the exchange in USD nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics.
path.events.dv360_billable_cost_advertiser_currency	int The total amount of money billed to the partner, including the media cost and partner costs, in advertiser currency nanos.
path.events.dv360_billable_cost_partner_currency	int The total amount of money billed to the partner, including the media cost and partner costs, in partner currency nanos.
path.events.dv360_billable_cost_usd	int The total amount of money billed to the partner, including the media cost and partner costs, in USD nanos.
path.events.dv360_browser_id	int DV360 browser ID
path.events.dv360_browser_timezone_offset_minutes	int The difference in minutes between the active timezone on the user's browser and GMT-12, for example 1320 represents a browser timezone of GMT+10.
path.events.dv360_city_id	int The Display & Video 360 numerical ID identifying the best-guess city of the impression.
path.events.dv360_country_code	string 2-letter ISO 3166-1 country code identifying the best-guess country of the impression, for example "US".
path.events.dv360_cpm_fee_1_advertiser_currency	int The CPM 1 fee in advertiser currency nanos. This value may be zero.
path.events.dv360_cpm_fee_1_partner_currency	int The CPM 1 fee in partner currency nanos. This value may be zero.
path.events.dv360_cpm_fee_1_usd	int The CPM 1 fee in USD nanos. This value may be zero.
path.events.dv360_cpm_fee_2_advertiser_currency	int The CPM 2 fee in advertiser currency nanos. This value may be zero.
path.events.dv360_cpm_fee_2_partner_currency	int The CPM 2 fee in partner currency nanos. This value may be zero.
path.events.dv360_cpm_fee_2_usd	int The CPM 2 fee in USD nanos. This value may be zero.
path.events.dv360_cpm_fee_3_advertiser_currency	int The CPM 3 fee in advertiser currency nanos. This value may be zero.
path.events.dv360_cpm_fee_3_partner_currency	int The CPM 3 fee in partner currency nanos. This value may be zero.
path.events.dv360_cpm_fee_3_usd	int The CPM 3 fee in USD nanos. This value may be zero.
path.events.dv360_cpm_fee_4_advertiser_currency	int The CPM 4 fee in advertiser currency nanos. This value may be zero.
path.events.dv360_cpm_fee_4_partner_currency	int The CPM 4 fee in partner currency nanos. This value may be zero.
path.events.dv360_cpm_fee_4_usd	int The CPM 4 fee in USD nanos. This value may be zero.
path.events.dv360_cpm_fee_5_advertiser_currency	int The CPM 5 fee in advertiser currency nanos. This value may be zero.
path.events.dv360_cpm_fee_5_partner_currency	int The CPM 5 fee in partner currency nanos. This value may be zero.
path.events.dv360_cpm_fee_5_usd	int The CPM 5 fee in USD nanos. This value may be zero.
path.events.dv360_creative_id	int The Display & Video 360 numerical ID for the creative related to the event, for example 367487.
path.events.dv360_data_fees_advertiser_currency	int The cost of any data that was used to target this impression, in advertiser currency nanos.
path.events.dv360_data_fees_partner_currency	int The cost of any data that was used to target this impression, in partner currency nanos.
path.events.dv360_data_fees_usd	int The cost of any data that was used to target this impression, in USD nanos
path.events.dv360_device_type	int The numerical value of the identified device type. 0 = Computer, 1 = Other, 2 = Smart Phone, 3 = Tablet, 4 = Smart TV, 5 = Connected TV, 6 = Set Top Box, 7 = Connected Device.
path.events.dv360_exchange_id	string The Display & Video 360 numerical ID for the exchange that requested the ad.
path.events.dv360_insertion_order_id	int The Display & Video 360 numerical ID for the insertion order related to the event, for example 1079941.
path.events.dv360_isp_id	int The Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.
path.events.dv360_language	string The ISO-639-1 code or "zh_CN" (Chinese (simplified)), "zh_TW" (Chinese (traditional)) or "other" representing the language related to the view event.
path.events.dv360_line_item_id	int The Display & Video 360 numerical ID for the line item related to the event, for example 1155785.
path.events.dv360_matching_targeted_keywords	string A comma separated string containing a list of targeted keywords matching the page related to the view event, for example "apple,orange,banana". Although the page related to the view event may match many keywords, only those which were targeted will be included; if the list of keywords is large we may impose a limit to the number of keywords returned.
path.events.dv360_matching_targeted_segments	string Space-separated IDs of targeted user lists that match the visitor, for example "-4 456". If the visitor is in a user list that is not targeted by the ad associated with this event it will not be included here.
path.events.dv360_media_cost_advertiser_currency	int The amount paid for the impression in advertiser currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
path.events.dv360_media_cost_partner_currency	int The amount paid for the impression in the partner currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
path.events.dv360_media_cost_usd	int The amount paid for the impression in USD nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
path.events.dv360_media_fee_1_advertiser_currency	int The Media Fee 1 fee in advertiser currency nanos. This value may be zero.
path.events.dv360_media_fee_1_partner_currency	int The Media Fee 1 fee in partner currency nanos. This value may be zero.
path.events.dv360_media_fee_1_usd	int The Media Fee 1 fee in USD nanos. This value may be zero.
path.events.dv360_media_fee_2_advertiser_currency	int The Media Fee 2 fee in advertiser currency nanos. This value may be zero.
path.events.dv360_media_fee_2_partner_currency	int The Media Fee 2 fee in partner currency nanos. This value may be zero.
path.events.dv360_media_fee_2_usd	int The Media Fee 2 fee in USD nanos. This value may be zero.
path.events.dv360_media_fee_3_advertiser_currency	int The Media Fee 3 fee in advertiser currency nanos. This value may be zero.
path.events.dv360_media_fee_3_partner_currency	int The Media Fee 3 fee in partner currency nanos. This value may be zero.
path.events.dv360_media_fee_3_usd	int The Media Fee 3 fee in USD nanos. This value may be zero.
path.events.dv360_media_fee_4_advertiser_currency	int The Media Fee 4 fee in advertiser currency nanos. This value may be zero.
path.events.dv360_media_fee_4_partner_currency	int The Media Fee 4 fee in partner currency nanos. This value may be zero.
path.events.dv360_media_fee_4_usd	int The Media Fee 4 fee in USD nanos. This value may be zero.
path.events.dv360_media_fee_5_advertiser_currency	int The Media Fee 5 fee in advertiser currency nanos. This value may be zero.
path.events.dv360_media_fee_5_partner_currency	int The Media Fee 5 fee in partner currency nanos. This value may be zero.
path.events.dv360_media_fee_5_usd	int The Media Fee 5 fee in USD nanos. This value may be zero.
path.events.dv360_mobile_model_id	int The numerical ID for the mobile model. This value may be missing.
path.events.dv360_net_speed	int The Display & Video 360 numerical ID representing the network speed related to the view event. 1=Dial-up, 2=EDGE/2G, 3=UMTS/3G, 4=Basic DSL, 5=HSDPA/3.5G, 6=Broadband/4G, 7=Unknown.
path.events.dv360_request_time	int A Unix timestamp in microseconds (1/1,000,000 second) for when we received the ad request, for example1330403779608570 represents Tuesday February 28th 2012 04:36:19.608570. Although this value is consistent across the view, click and conversion even it is not guaranteed to be unique - use auction_id to join events
path.events.dv360_revenue_advertiser_currency	int DV360 revenue advertiser currency
path.events.dv360_revenue_partner_currency	int DV360 revenue partner currency
path.events.dv360_revenue_usd	int DV360 revenue usd
path.events.dv360_site_id	int The Display & Video 360 numerical ID for the most specific universal site that matches the url.
path.events.dv360_state_region_id	int An integer matching the state/region integer available in reporting and targeting.
path.events.dv360_url	string The raw URL taken from the bid request received from the exchange, for example "http://www.example.com". As some exchanges mask the URL in their bid requests this value may be: "source_url_hidden"
path.events.dv360_view_state	string Populated for wrapped tags. (Two impression records when both events occur.) Possible values are: "OUTER", DV360 returned wrapped tag; "INNER", ad served post wrapped tag; "3PAS_MERGED", wrapped tag tracked by CM; "3PAS_OUTER", tracking ping sent to CM but no response, 3rd party blocked ad serving.
path.events.dv360_zip_postal_code	string The postal code identifying the best-guess postal area of the impression if known, for example "98033". Do not assume uniqueness across different countries.
path.events.event_sub_type	string Event sub type
events.event_time	int Time in microseconds since 1970-01-01 00:00:00 UTC.
path.events.event_type	string Contains details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "CONVERSION" or "MODELED_CONVERSION" for conversion events.
path.events.floodlight_config_id	int Unique ID of the floodlight configuration. ID
path.events.impression_id	string Impression ID
path.events.interaction_time_utc_seconds	string The activity's associated (aka 'matched') click or impression time in microseconds since 1970-01-01 00:00:00 UTC.
path.events.landing_page_url_id	int Landing page url ID
path.events.operating_system_id	int ID of the operating system.
path.events.ord_value	string The advertiser's ordinal ID, if relevant for a given activity type. Passed in the 'ord=' key-value (also used for storing the client's Order-ID in sales tags)
path.events.other_data	string Stores key-value data from the activity string which is not otherwise labeled. (Any key-value that is NOT "src=", "type=", "cat=", "ord=", "u=", "cost=", "qty=", "tran=", "a=", or "b="). (Can be used for further product breakdown aka "Custom Floodlight Variables")
path.events.placement_id	int Unique ID for the site page / placement where the ad ran.
path.events.referrer_url	string Contains the URL on which the ad appeared, when possible. May also be empty, or return ad server URLs.
path.events.rendering_id	int Unique ID of the creative for Data Transfer. Does not correspond to the UI-Creative-ID.
path.events.rich_media_event_counters	int Rich media event counters
path.events.rich_media_event_id	int MET Event ID for the Rich Media ad.
path.events.rich_media_event_timers	double Rich media event timers
path.events.rich_media_event_type_id	int ID of Rich Media Event Type.
path.events.segment_value_1	int Segment value 1
path.events.site_id	int Site ID
path.events.state	string State
path.events.tran_value	string Tran value
path.events.u_value	string U value
path.events.zip_code	string Postal-Code (US/Canada).
user_id	opaque The tracking ID (it is based on, but does not expose the user's browser cookie or mobile device ID). This field may be zeroed out for privacy reasons. User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

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
advertiser_click_cost_local_micros	double The advertiser's cost in local currency micros.
advertiser_click_cost_usd	double The advertiser's click cost in dollars.
click_id	struct Unique identifier for click has multiple parts. Joins with click_id in any adh.dv360_youtube table.
click_id.process_id	int Integer that identifies the process on the machine that generated the event.
click_id.server_ip	int The IPv4 address of the server that generated this event.
click_id.time_usec	int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
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.
is_trueview	bool True if the event was a TrueView view. False if the event was not a TrueView view.
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 impressions

dv360_youtube_impressions
active_view_data	int Whether the impression was enabled for active view measurement.
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.
advertiser_impression_cost_local_micros	double The advertiser's local currency in micros.
advertiser_impression_cost_usd	double The advertiser's impression cost in dollars.
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.
creative_id	int Joins with creative_id in any adh.dv360_youtube table.
demographics	struct
demographics.age_group	int Code for age group. Joins with age_group_id in adh.age_group table.
demographics.gender	int Code for gender. Joins with gender_id in adh.gender table.
device_height	int Device height in px.
device_width	int Device width in px.
format_category	string YouTube ad format. Possible values are AUDIO, DISPLAY, VIDEO, UNSPECIFIED.
impression_id	string Unique identifier for impression.
in_market	array ID of in-market group. Joins with in_market_id in adh.in_market table. Does not support TrueView line items.
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.

Freewheel impressions

freewheel_impressions
browser	string Possible values are: "Chrome", "Cobalt", "Dalvik", "Edge", "Firefox", "IE", "Opera", "Other", "Safari", "Samsung Browser", "Roku", "Silk", "Unknown", "Yandex"
format_category	string YouTube ad format. Possible values are AUDIO, DISPLAY, VIDEO, UNSPECIFIED.
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"

Gender

gender
gender_id	int Gender identifier.
gender_name	string Gender name. Possible values are: "male", "female", or "unknown".

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
advertiser_click_cost_local_micros	double The advertiser's cost in local currency micros.
advertiser_click_cost_usd	double The advertiser's click cost in dollars.
click_id	struct Unique identifier for click has multiple parts. Joins with click_id in any adh.google_ads table.
click_id.process_id	int Integer that identifies the process on the machine that generated the event.
click_id.server_ip	int The IPv4 address of the server that generated this event.
click_id.time_usec	int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
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.
is_trueview	bool True if the event was a TrueView view. False if the event was not a TrueView view.
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
advertiser_click_cost_local_micros	double The advertiser's cost in local currency micros.
advertiser_click_cost_usd	double The advertiser's click cost in dollars.
click_id	struct Unique identifier for click has multiple parts. Joins with click_id in any adh.google_ads table.
click_id.process_id	int Integer that identifies the process on the machine that generated the event.
click_id.server_ip	int The IPv4 address of the server that generated this event.
click_id.time_usec	int The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
click_type	int The click type.
impression_id	string Unique identifier for impression.
is_trueview	bool True if the event was a TrueView view. False if the event was not a TrueView view.
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.
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
impression_id	string Unique identifier for impression.

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
active_view_data	int Whether the impression was enabled for active view measurement.
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.
advertiser_impression_cost_local_micros	double The advertiser's local currency in micros.
advertiser_impression_cost_usd	double The advertiser's impression cost in dollars.
affinity	array ID of affinity group. Joins with affinity_id in adh.affinity table. Does not support TrueView line items.
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.
demographics	struct
demographics.age_group	int Code for age group. Joins with age_group_id in adh.age_group table.
demographics.gender	int Code for gender. Joins with gender_id in adh.gender table.
device_height	int Device height in px.
device_width	int Device width in px.
format_category	string YouTube ad format. Possible values are AUDIO, DISPLAY, VIDEO, UNSPECIFIED.
impression_id	string Unique identifier for impression.
in_market	array ID of in-market group. Joins with in_market_id in adh.in_market table. Does not support TrueView line items.
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.

In-market segment

in_market
in_market_category	string The category of market vertical.
in_market_id	int In-market identifier.
in_market_name	string A more specific in-market name based on category.

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.

Partner Sold - Cross Sell clicks

partner_sold_cross_sell_clicks
impression_id	string Unique identifier for impression.

Partner Sold - Cross Sell conversions

partner_sold_cross_sell_conversions
impression_id	string Unique identifier for impression.

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"
format_category	string YouTube ad format. Possible values are AUDIO, DISPLAY, VIDEO, UNSPECIFIED.
impression_id	string Unique identifier for impression.
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"

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 impressions

yt_reserve_impressions
active_view_data	int Whether the impression was enabled for active view measurement.
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.
demographics	struct Unique identifier for demographics, which has multiple parts: age_group, gender.
demographics.age_group	int Code for age group. Joins with age_group_id in adh.age_group table.
demographics.gender	int Code for gender. Joins with gender_id in adh.gender table.
device_height	int Device height in px.
device_width	int Device width in px.
format_category	string YouTube ad format. Possible values are AUDIO, DISPLAY, VIDEO, UNSPECIFIED.
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
cost_per_unit	int Cost per unit served in micros
cost_type	string Cost per click, conversion, impression, and Active View.
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.
value_cost_per_unit	int The value cost per unit of the line item.

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