Ads Data Hub table format- Holding companies

Affinity segment

affinity
affinity_categorystring
Affinity category.
affinity_idint
Affinity identifier.
affinity_namestring
Affinity name.

Age group

age_group
age_group_idint
Age group identifier.
age_group_namestring
Age group name.

Browser

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

City

city
city_idint
Unique ID of the city.
city_namestring
City name.
country_codestring
Two character country code.
latitudeint
Latitude in degrees.
longitudeint
Longitude in degrees.
metro_codestring
Metropolitan area code.
region_codestring
The multi character code of the region

Campaign Manager Data Transfer account info

cm_dt_account_info
account_idint
Unique ID of the account.
timezone_namestring
Timezone of the account.

Campaign Manager Data Transfer Active View plus

cm_dt_active_view_plus
device_id_md5string
MD5-hashed device ID; a utility may be provided to hash raw device IDs to match.
eventstruct
event.active_view_audible_impressionsint
Active View: Impressions Audible
event.active_view_audible_time_msecint
Active View: Play Time Audible (Seconds)
event.active_view_audible_visible_time_msecint
Active View: Play Time Audible and Visible (Seconds)
event.active_view_background_countint
Active View: Impressions In Background
event.active_view_complete_viewable_impressionsint
Active View: Impressions Visible at Completion
event.active_view_eligible_impressionsint
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_impressionsint
Active View: Impressions Visible and Audible at First Quartile
event.active_view_first_quartile_viewable_impressionsint
Active View: Impressions Visible at First Quartile
event.active_view_fullscreen_countint
Active View: Impressions Full-Screen
event.active_view_impressions_audible_and_visible_at_completionint
Active View: Impressions Audible and Visible at Completion
event.active_view_impressions_visible10_secondsint
Active View: Impressions Visible 10 Seconds
event.active_view_measurable_impressionsint
Whether the impression was measurable with Active View.
event.active_view_midpoint_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Midpoint
event.active_view_midpoint_viewable_impressionsint
Active View: Impressions Visible at Midpoint
event.active_view_plus_measurable_countint
Active View Plus: Measurable Impressions
event.active_view_start_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Start
event.active_view_start_viewable_impressionsint
Active View: Impressions Visible at Start
event.active_view_third_quartile_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Third Quartile
event.active_view_third_quartile_viewable_impressionsint
Active View: Impressions Visible at Third Quartile
event.active_view_tos_msecint
Active View: Time on Screen (Seconds)
event.active_view_viewable_impressionsint
Whether the impression was viewable.
event.active_view_visible_time_msecint
Active View: Video Visible Time (Seconds)
event.activity_countint
Activity Quantity
event.activity_idint
The ID of the Floodlight tag related to the conversion event.
event.activity_revenuedouble
Activity Revenue
event.ad_idint
Unique ID of the ad placement.
event.advertiser_idint
Unique ID of the advertiser
event.audience_segment_idint
event.browser_platform_idstring
ID of the browser type.
event.browser_versionstring
Browser/Platform Version
event.campaign_idint
Unique ID of the campaign
event.city_idint
City ID
event.conversion_idint
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_codestring
Country
event.creative_versionstring
Creative version number.
event.dma_region_idint
Designated Market Area ID (US/Canada).
event.dv360_ad_positionint
Specifies the position of the ad on the page if known. 1 represents above the fold, 2 represents below the fold.
event.dv360_advertiser_idint
The Display & Video 360 numerical ID for the advertiser related to the event, for example 164332.
event.dv360_adx_page_categoriesstring
DV360 Adx Page Categories
event.dv360_attributed_inventory_source_external_idstring
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_publicstring
True if inventory source is available to all buyers. False otherwise.
event.dv360_auction_idstring
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_currencyint
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_currencyint
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_usdint
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_currencyint
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_currencyint
The total amount of money billed to the partner, including the media cost and partner costs, in partner currency nanos.
event.dv360_billable_cost_usdint
The total amount of money billed to the partner, including the media cost and partner costs, in USD nanos.
event.dv360_browser_idint
The Display & Video 360 numerical ID identifying the browser related to this event.
event.dv360_browser_timezone_offset_minutesint
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_idint
The unique ID of the Display & Video 360 campaign.
event.dv360_city_idint
The Display & Video 360 numerical ID identifying the best-guess city of the impression.
event.dv360_country_codestring
2-letter ISO 3166-1 country code identifying the best-guess country of the impression, for example "US".
event.dv360_cpm_fee_1_advertiser_currencyint
event.dv360_cpm_fee_1_partner_currencyint
event.dv360_cpm_fee_1_usdint
event.dv360_cpm_fee_2_advertiser_currencyint
event.dv360_cpm_fee_2_partner_currencyint
event.dv360_cpm_fee_2_usdint
event.dv360_cpm_fee_3_advertiser_currencyint
event.dv360_cpm_fee_3_partner_currencyint
event.dv360_cpm_fee_3_usdint
event.dv360_cpm_fee_4_advertiser_currencyint
event.dv360_cpm_fee_4_partner_currencyint
event.dv360_cpm_fee_4_usdint
event.dv360_cpm_fee_5_advertiser_currencyint
event.dv360_cpm_fee_5_partner_currencyint
event.dv360_cpm_fee_5_usdint
event.dv360_creative_idint
The Display & Video 360 numerical ID for the creative related to the event, for example 367487.
event.dv360_data_fees_advertiser_currencyint
event.dv360_data_fees_partner_currencyint
event.dv360_data_fees_usdint
event.dv360_device_typeint
The numerical value of the identified device type. 0 = COMPUTER, 1 = OTHER, 2 = SMARTPHONE, 3 = TABLET, 4 = SMARTTV, 5 = CONNECTEDTV.
event.dv360_exchange_idstring
The Display & Video 360 numerical ID for the exchange that requested the ad.
event.dv360_insertion_order_idint
The Display & Video 360 numerical ID for the insertion order related to the event, for example 1079941.
event.dv360_isp_idint
The Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.
event.dv360_languagestring
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_idint
The Display & Video 360 numerical ID for the line item related to the event, for example 1155785.
event.dv360_media_cost_advertiser_currencyint
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_currencyint
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_usdint
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_currencyint
event.dv360_media_fee_1_partner_currencyint
event.dv360_media_fee_1_usdint
event.dv360_media_fee_2_advertiser_currencyint
event.dv360_media_fee_2_partner_currencyint
event.dv360_media_fee_2_usdint
event.dv360_media_fee_3_advertiser_currencyint
event.dv360_media_fee_3_partner_currencyint
event.dv360_media_fee_3_usdint
event.dv360_media_fee_4_advertiser_currencyint
event.dv360_media_fee_4_partner_currencyint
event.dv360_media_fee_4_usdint
event.dv360_media_fee_5_advertiser_currencyint
event.dv360_media_fee_5_partner_currencyint
event.dv360_media_fee_5_usdint
event.dv360_mobile_make_idint
The numerical ID for the mobile make. This value may be missing.
event.dv360_mobile_model_idint
The numerical ID for the mobile model. This value may be missing.
event.dv360_net_speedint
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_idint
Operating System ID.
event.dv360_request_timeint
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_currencyint
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_currencyint
The total amount in partner currency nanos made by the partner account for the view event. This value may be zero.
event.dv360_revenue_usdint
The total amount in USD nanos made by the partner account for the view event. This value may be zero.
event.dv360_site_idint
The Display & Video 360 numerical ID for the most specific universal site that matches the url.
event.dv360_state_region_idint
DV360 Region ID
event.dv360_urlstring
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_statestring
DV360 View State
event.dv360_zip_postal_codestring
DV360 ZIP/Postal Code
event.event_sub_typestring
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_timeint
Time in microseconds since 1970-01-01 00:00:00 UTC.
event.event_typestring
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_idint
Unique ID of the floodlight configuration.
event.impression_idstring
Impression ID
event.interaction_time_utc_secondsstring
Interaction Time
event.landing_page_url_idint
Unique ID of the landing page URL.
event.operating_system_idint
ID of the operating system.
event.ord_valuestring
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_datastring
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_idint
Unique ID for the site page / placement where the ad ran.
event.platform_type_idint
event.referrer_urlstring
Contains the URL on which the ad appeared, when possible. May also be empty, or return ad server URLs.
event.rendering_idint
Unique ID of the creative for Data Transfer. Does not correspond to the UI-Creative-ID.
event.rich_media_event_countersint
MET Counter Value (the ecn= value).
event.rich_media_event_idint
MET Event ID for the Rich Media ad.
event.rich_media_event_timersdouble
Time in microseconds since 1970-01-01 00:00:00 UTC.rs
event.rich_media_event_type_idint
ID of Rich Media Event Type.
event.site_idint
Unique ID for the site where the ad ran.
event.statestring
ID for user's state or province (US/Canada)
event.tran_valuestring
TRAN Value
event.u_valuestring
U Value
event.zip_codestring
Postal-Code (US/Canada).
is_in_rdid_projectboolean
true if this event is also in the _rdid table. Used for deduplication of events.
network_idint
The network ID.
user_idstring
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..

Campaign Manager Data Transfer activities

cm_dt_activities
device_id_md5string
MD5-hashed device ID; a utility may be provided to hash raw device IDs to match.
eventstruct
event.active_view_audible_impressionsint
Active View: Impressions Audible
event.active_view_audible_time_msecint
Active View: Play Time Audible (Seconds)
event.active_view_audible_visible_time_msecint
Active View: Play Time Audible and Visible (Seconds)
event.active_view_background_countint
Active View: Impressions In Background
event.active_view_complete_viewable_impressionsint
Active View: Impressions Visible at Completion
event.active_view_eligible_impressionsint
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_impressionsint
Active View: Impressions Visible and Audible at First Quartile
event.active_view_first_quartile_viewable_impressionsint
Active View: Impressions Visible at First Quartile
event.active_view_fullscreen_countint
Active View: Impressions Full-Screen
event.active_view_impressions_audible_and_visible_at_completionint
Active View: Impressions Audible and Visible at Completion
event.active_view_impressions_visible10_secondsint
Active View: Impressions Visible 10 Seconds
event.active_view_measurable_impressionsint
Whether the impression was measurable with Active View.
event.active_view_midpoint_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Midpoint
event.active_view_midpoint_viewable_impressionsint
Active View: Impressions Visible at Midpoint
event.active_view_plus_measurable_countint
Active View Plus: Measurable Impressions
event.active_view_start_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Start
event.active_view_start_viewable_impressionsint
Active View: Impressions Visible at Start
event.active_view_third_quartile_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Third Quartile
event.active_view_third_quartile_viewable_impressionsint
Active View: Impressions Visible at Third Quartile
event.active_view_tos_msecint
Active View: Time on Screen (Seconds)
event.active_view_viewable_impressionsint
Whether the impression was viewable.
event.active_view_visible_time_msecint
Active View: Video Visible Time (Seconds)
event.activity_countint
Activity Quantity
event.activity_idint
The ID of the Floodlight tag related to the conversion event.
event.activity_revenuedouble
Activity Revenue
event.ad_idint
Unique ID of the ad placement.
event.advertiser_idint
Unique ID of the advertiser
event.audience_segment_idint
event.browser_platform_idstring
ID of the browser type.
event.browser_versionstring
Browser/Platform Version
event.campaign_idint
Unique ID of the campaign
event.city_idint
City ID
event.conversion_idint
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_codestring
Country
event.creative_versionstring
Creative version number.
event.dma_region_idint
Designated Market Area ID (US/Canada).
event.dv360_ad_positionint
Specifies the position of the ad on the page if known. 1 represents above the fold, 2 represents below the fold.
event.dv360_advertiser_idint
The Display & Video 360 numerical ID for the advertiser related to the event, for example 164332.
event.dv360_adx_page_categoriesstring
DV360 Adx Page Categories
event.dv360_attributed_inventory_source_external_idstring
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_publicstring
True if inventory source is available to all buyers. False otherwise.
event.dv360_auction_idstring
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_currencyint
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_currencyint
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_usdint
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_currencyint
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_currencyint
The total amount of money billed to the partner, including the media cost and partner costs, in partner currency nanos.
event.dv360_billable_cost_usdint
The total amount of money billed to the partner, including the media cost and partner costs, in USD nanos.
event.dv360_browser_idint
The Display & Video 360 numerical ID identifying the browser related to this event.
event.dv360_browser_timezone_offset_minutesint
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_idint
The unique ID of the Display & Video 360 campaign.
event.dv360_city_idint
The Display & Video 360 numerical ID identifying the best-guess city of the impression.
event.dv360_country_codestring
2-letter ISO 3166-1 country code identifying the best-guess country of the impression, for example "US".
event.dv360_cpm_fee_1_advertiser_currencyint
event.dv360_cpm_fee_1_partner_currencyint
event.dv360_cpm_fee_1_usdint
event.dv360_cpm_fee_2_advertiser_currencyint
event.dv360_cpm_fee_2_partner_currencyint
event.dv360_cpm_fee_2_usdint
event.dv360_cpm_fee_3_advertiser_currencyint
event.dv360_cpm_fee_3_partner_currencyint
event.dv360_cpm_fee_3_usdint
event.dv360_cpm_fee_4_advertiser_currencyint
event.dv360_cpm_fee_4_partner_currencyint
event.dv360_cpm_fee_4_usdint
event.dv360_cpm_fee_5_advertiser_currencyint
event.dv360_cpm_fee_5_partner_currencyint
event.dv360_cpm_fee_5_usdint
event.dv360_creative_idint
The Display & Video 360 numerical ID for the creative related to the event, for example 367487.
event.dv360_data_fees_advertiser_currencyint
event.dv360_data_fees_partner_currencyint
event.dv360_data_fees_usdint
event.dv360_device_typeint
The numerical value of the identified device type. 0 = COMPUTER, 1 = OTHER, 2 = SMARTPHONE, 3 = TABLET, 4 = SMARTTV, 5 = CONNECTEDTV.
event.dv360_exchange_idstring
The Display & Video 360 numerical ID for the exchange that requested the ad.
event.dv360_insertion_order_idint
The Display & Video 360 numerical ID for the insertion order related to the event, for example 1079941.
event.dv360_isp_idint
The Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.
event.dv360_languagestring
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_idint
The Display & Video 360 numerical ID for the line item related to the event, for example 1155785.
event.dv360_media_cost_advertiser_currencyint
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_currencyint
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_usdint
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_currencyint
event.dv360_media_fee_1_partner_currencyint
event.dv360_media_fee_1_usdint
event.dv360_media_fee_2_advertiser_currencyint
event.dv360_media_fee_2_partner_currencyint
event.dv360_media_fee_2_usdint
event.dv360_media_fee_3_advertiser_currencyint
event.dv360_media_fee_3_partner_currencyint
event.dv360_media_fee_3_usdint
event.dv360_media_fee_4_advertiser_currencyint
event.dv360_media_fee_4_partner_currencyint
event.dv360_media_fee_4_usdint
event.dv360_media_fee_5_advertiser_currencyint
event.dv360_media_fee_5_partner_currencyint
event.dv360_media_fee_5_usdint
event.dv360_mobile_make_idint
The numerical ID for the mobile make. This value may be missing.
event.dv360_mobile_model_idint
The numerical ID for the mobile model. This value may be missing.
event.dv360_net_speedint
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_idint
Operating System ID.
event.dv360_request_timeint
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_currencyint
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_currencyint
The total amount in partner currency nanos made by the partner account for the view event. This value may be zero.
event.dv360_revenue_usdint
The total amount in USD nanos made by the partner account for the view event. This value may be zero.
event.dv360_site_idint
The Display & Video 360 numerical ID for the most specific universal site that matches the url.
event.dv360_state_region_idint
DV360 Region ID
event.dv360_urlstring
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_statestring
DV360 View State
event.dv360_zip_postal_codestring
DV360 ZIP/Postal Code
event.event_sub_typestring
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_timeint
Time in microseconds since 1970-01-01 00:00:00 UTC.
event.event_typestring
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_idint
Unique ID of the floodlight configuration.
event.impression_idstring
Impression ID
event.interaction_time_utc_secondsstring
Interaction Time
event.landing_page_url_idint
Unique ID of the landing page URL.
event.operating_system_idint
ID of the operating system.
event.ord_valuestring
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_datastring
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_idint
Unique ID for the site page / placement where the ad ran.
event.referrer_urlstring
Contains the URL on which the ad appeared, when possible. May also be empty, or return ad server URLs.
event.rendering_idint
Unique ID of the creative for Data Transfer. Does not correspond to the UI-Creative-ID.
event.rich_media_event_countersint
MET Counter Value (the ecn= value).
event.rich_media_event_idint
MET Event ID for the Rich Media ad.
event.rich_media_event_timersdouble
Time in microseconds since 1970-01-01 00:00:00 UTC.rs
event.rich_media_event_type_idint
ID of Rich Media Event Type.
event.site_idint
Unique ID for the site where the ad ran.
event.statestring
ID for user's state or province (US/Canada)
event.tran_valuestring
TRAN Value
event.u_valuestring
U Value
event.zip_codestring
Postal-Code (US/Canada).
is_in_rdid_projectboolean
true if this event is also in the _rdid table. Used for deduplication of events.
network_idint
The network ID.
user_idstring
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..

Campaign Manager Data Transfer activity category

cm_dt_activity_category
account_idint
Unique ID of the account.
activitystring
User defined category report interface name for floodlight tags.
activity_group_idint
ID of the group to which this advertiser belongs. An advertiser may be a member of only one group.
activity_idint
Unique ID of the Floodlight activity.
activity_sub_typestring
User defined string corresponding to cat= value from Floodlight tag.
activity_typestring
User defined string corresponding to type= value from Floodlight tag.
advertiser_idint
Unique ID of the advertiser.
floodlight_config_idint
Unique ID of the floodlight configuration.
tag_counting_method_idint
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 Data Transfer activity type

cm_dt_activity_type
account_idint
Unique ID of the account.
activity_groupstring
Name for this activity group.
activity_group_idint
ID of the group to which this advertiser belongs. An advertiser may be a member of only one group.
activity_typestring
User defined string corresponding to type= value from Floodlight tag.
advertiser_idint
Unique ID of the advertiser.
floodlight_config_idint
Unique ID of the floodlight configuration.

Campaign Manager Data Transfer ad

cm_dt_ad
account_idint
Unique ID of the account.
adstring
User defined ad name.
ad_click_urlstring
Click through URL of Click Ad type creatives only (aka Click Commands)
ad_commentsstring
User defined ad level comments.
ad_idint
Unique ID of the ad.
ad_typestring
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_idint
Unique ID of the ad type.
advertiser_idint
Unique ID of the advertiser.
campaign_idint
Unique ID of the campaign.
creative_sizestring
The creative size in pixels: width x height. Empty size is represented by "0X0".
floodlight_config_idint
Unique ID of the floodlight configuration.

Campaign Manager Data Transfer Ad placement assignments

cm_dt_ad_placement_assignment
account_idint
Unique ID of the account.
ad_idint
Unique ID of the ad.
advertiser_idint
Unique ID of the advertiser.
floodlight_config_idint
Unique ID of the floodlight configuration.
placement_idint

Campaign Manager Data Transfer Advertiser

cm_dt_advertiser
account_idint
Unique ID of the account.
advertiserstring
User entered name of the advertiser.
advertiser_groupstring
User specified group to which this advertiser belongs. An advertiser may be a member of only one group.
advertiser_group_idint
Group ID to which this advertiser belongs. An advertiser may be a member of only one group.
advertiser_idint
Unique ID of the advertiser.
floodlight_config_idint
Unique ID of the floodlight configuration.

Campaign Manager Data Transfer asset

cm_dt_asset
account_idint
Unique ID of the account.
assetstring
Name of the creative asset.
asset_categorystring
Category of the creative asset.
asset_idint
Unique ID of the asset.
asset_orientationstring
Screen orientation of the asset.

Campaign Manager Data Transfer audience segments

cm_dt_audience_segments
account_idint
Unique ID of the account.
advertiser_idint
Unique ID of the advertiser.
audience_segmentstring
Name of the audience segment.
audience_segment_idint
Unique ID of the audience segment.
floodlight_config_idint
Unique ID of the floodlight configuration.

Campaign Manager Data Transfer browser

cm_dt_browser
browser_platformstring
browser_platform_idint
Browser / Platform ID

Campaign Manager Data Transfer campaign

cm_dt_campaign
account_idint
Unique ID of the account.
advertiser_idint
Unique ID of the advertiser.
billing_invoice_codestring
The code entered in the billing invoice.
campaignstring
User entered campaign name.
campaign_end_dateint
Campaign end date as YYYYMMDD.
campaign_idint
Unique ID of the campaign.
campaign_start_dateint
Campaign start date as YYYYMMDD.
floodlight_config_idint
Unique ID of the floodlight configuration.

Campaign Manager Data Transfer city

cm_dt_city
citystring
The city name
city_idint
Unique ID of the city.

Campaign Manager Data Transfer clicks

cm_dt_clicks
device_id_md5string
MD5-hashed device ID; a utility may be provided to hash raw device IDs to match.
eventstruct
event.active_view_audible_impressionsint
Active View: Impressions Audible
event.active_view_audible_time_msecint
Active View: Play Time Audible (Seconds)
event.active_view_audible_visible_time_msecint
Active View: Play Time Audible and Visible (Seconds)
event.active_view_background_countint
Active View: Impressions In Background
event.active_view_complete_viewable_impressionsint
Active View: Impressions Visible at Completion
event.active_view_eligible_impressionsint
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_impressionsint
Active View: Impressions Visible and Audible at First Quartile
event.active_view_first_quartile_viewable_impressionsint
Active View: Impressions Visible at First Quartile
event.active_view_fullscreen_countint
Active View: Impressions Full-Screen
event.active_view_impressions_audible_and_visible_at_completionint
Active View: Impressions Audible and Visible at Completion
event.active_view_impressions_visible10_secondsint
Active View: Impressions Visible 10 Seconds
event.active_view_measurable_impressionsint
Whether the impression was measurable with Active View.
event.active_view_midpoint_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Midpoint
event.active_view_midpoint_viewable_impressionsint
Active View: Impressions Visible at Midpoint
event.active_view_plus_measurable_countint
Active View Plus: Measurable Impressions
event.active_view_start_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Start
event.active_view_start_viewable_impressionsint
Active View: Impressions Visible at Start
event.active_view_third_quartile_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Third Quartile
event.active_view_third_quartile_viewable_impressionsint
Active View: Impressions Visible at Third Quartile
event.active_view_tos_msecint
Active View: Time on Screen (Seconds)
event.active_view_visible_time_msecint
Active View: Video Visible Time (Seconds)
event.activity_countint
Activity Quantity
event.activity_idint
The ID of the Floodlight tag related to the conversion event.
event.activity_revenuedouble
Activity Revenue
event.ad_idint
Unique ID of the ad placement.
event.advertiser_idint
Unique ID of the advertiser
event.audience_segment_idint
event.browser_platform_idstring
ID of the browser type.
event.browser_versionstring
Browser/Platform Version
event.campaign_idint
Unique ID of the campaign
event.city_idint
City ID
event.conversion_idint
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_codestring
Country
event.creative_versionstring
Creative version number.
event.dma_region_idint
Designated Market Area ID (US/Canada).
event.dv360_ad_positionint
Specifies the position of the ad on the page if known. 1 represents above the fold, 2 represents below the fold.
event.dv360_advertiser_idint
The Display & Video 360 numerical ID for the advertiser related to the event, for example 164332.
event.dv360_adx_page_categoriesstring
DV360 Adx Page Categories
event.dv360_attributed_inventory_source_external_idstring
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_publicstring
True if inventory source is available to all buyers. False otherwise.
event.dv360_auction_idstring
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_currencyint
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_currencyint
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_usdint
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_currencyint
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_currencyint
The total amount of money billed to the partner, including the media cost and partner costs, in partner currency nanos.
event.dv360_billable_cost_usdint
The total amount of money billed to the partner, including the media cost and partner costs, in USD nanos.
event.dv360_browser_idint
The Display & Video 360 numerical ID identifying the browser related to this event.
event.dv360_browser_timezone_offset_minutesint
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_idint
The unique ID of the Display & Video 360 campaign.
event.dv360_city_idint
The Display & Video 360 numerical ID identifying the best-guess city of the impression.
event.dv360_country_codestring
2-letter ISO 3166-1 country code identifying the best-guess country of the impression, for example "US".
event.dv360_cpm_fee_1_advertiser_currencyint
event.dv360_cpm_fee_1_partner_currencyint
event.dv360_cpm_fee_1_usdint
event.dv360_cpm_fee_2_advertiser_currencyint
event.dv360_cpm_fee_2_partner_currencyint
event.dv360_cpm_fee_2_usdint
event.dv360_cpm_fee_3_advertiser_currencyint
event.dv360_cpm_fee_3_partner_currencyint
event.dv360_cpm_fee_3_usdint
event.dv360_cpm_fee_4_advertiser_currencyint
event.dv360_cpm_fee_4_partner_currencyint
event.dv360_cpm_fee_4_usdint
event.dv360_cpm_fee_5_advertiser_currencyint
event.dv360_cpm_fee_5_partner_currencyint
event.dv360_cpm_fee_5_usdint
event.dv360_creative_idint
The Display & Video 360 numerical ID for the creative related to the event, for example 367487.
event.dv360_data_fees_advertiser_currencyint
event.dv360_data_fees_partner_currencyint
event.dv360_data_fees_usdint
event.dv360_device_typeint
The numerical value of the identified device type. 0 = COMPUTER, 1 = OTHER, 2 = SMARTPHONE, 3 = TABLET, 4 = SMARTTV, 5 = CONNECTEDTV.
event.dv360_exchange_idstring
The Display & Video 360 numerical ID for the exchange that requested the ad.
event.dv360_insertion_order_idint
The Display & Video 360 numerical ID for the insertion order related to the event, for example 1079941.
event.dv360_isp_idint
The Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.
event.dv360_languagestring
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_idint
The Display & Video 360 numerical ID for the line item related to the event, for example 1155785.
event.dv360_media_cost_advertiser_currencyint
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_currencyint
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_usdint
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_currencyint
event.dv360_media_fee_1_partner_currencyint
event.dv360_media_fee_1_usdint
event.dv360_media_fee_2_advertiser_currencyint
event.dv360_media_fee_2_partner_currencyint
event.dv360_media_fee_2_usdint
event.dv360_media_fee_3_advertiser_currencyint
event.dv360_media_fee_3_partner_currencyint
event.dv360_media_fee_3_usdint
event.dv360_media_fee_4_advertiser_currencyint
event.dv360_media_fee_4_partner_currencyint
event.dv360_media_fee_4_usdint
event.dv360_media_fee_5_advertiser_currencyint
event.dv360_media_fee_5_partner_currencyint
event.dv360_media_fee_5_usdint
event.dv360_mobile_make_idint
The numerical ID for the mobile make. This value may be missing.
event.dv360_mobile_model_idint
The numerical ID for the mobile model. This value may be missing.
event.dv360_net_speedint
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_idint
DV60 operating system ID
event.dv360_request_timeint
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_currencyint
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_currencyint
The total amount in partner currency nanos made by the partner account for the view event. This value may be zero.
event.dv360_revenue_usdint
The total amount in USD nanos made by the partner account for the view event. This value may be zero.
event.dv360_site_idint
The Display & Video 360 numerical ID for the most specific universal site that matches the url.
event.dv360_state_region_idint
DV360 Region ID
event.dv360_urlstring
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_statestring
DV360 View State
event.dv360_zip_postal_codestring
DV360 ZIP/Postal Code
event.event_sub_typestring
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_timeint
Time in microseconds since 1970-01-01 00:00:00 UTC.
event.event_typestring
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_idint
Unique ID of the floodlight configuration.
event.impression_idstring
Impression ID
event.interaction_time_utc_secondsstring
Interaction Time
event.landing_page_url_idint
Unique ID of the landing page URL.
event.operating_system_idint
ID of the operating system.
event.ord_valuestring
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_datastring
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_idint
Unique ID for the site page / placement where the ad ran.
event.platform_type_idint
event.referrer_urlstring
Contains the URL on which the ad appeared, when possible. May also be empty, or return ad server URLs.
event.rendering_idint
Unique ID of the creative for Data Transfer. Does not correspond to the UI-Creative-ID.
event.rich_media_event_countersint
MET Counter Value (the ecn= value).
event.rich_media_event_idint
MET Event ID for the Rich Media ad.
event.rich_media_event_timersdouble
Time in microseconds since 1970-01-01 00:00:00 UTC.rs
event.rich_media_event_type_idint
ID of Rich Media Event Type.
event.site_idint
Unique ID for the site where the ad ran.
event.statestring
ID for user's state or province (US/Canada)
event.tran_valuestring
TRAN Value
event.u_valuestring
U Value
event.zip_codestring
Postal-Code (US/Canada).
is_in_rdid_projectboolean
true if this event is also in the _rdid table. Used for deduplication of events.
network_idint
The network ID.
user_idstring
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..

Campaign Manager Data Transfer creative

cm_dt_creative
account_idint
Unique ID of the account.
advertiser_idint
Unique ID of the advertiser.
creativestring
Creative Name as entered into the Campaign Manager interface.
creative_idint
The Creative ID in Campaign Manager UI.
creative_image_urlstring
Location of creative image (Does not apply to rich media).
creative_last_modified_dateint
Unix epoch timestamp (milliseconds) of the last time this creative was modified.
creative_sizestring
The creative size in pixels: width x height. Empty size is represented by "0X0".
creative_typestring
The type of creative.
creative_type_idint
creative_versionint
Used for change management to capture different versions
floodlight_config_idint
Unique ID of the floodlight configuration.
rendering_idint
Unique ID of the creative for Data Transfer. This isn't the creative ID in the Campaign Manager UI.

Campaign Manager Data Transfer creative ad assignment

cm_dt_creative_ad_assignment
account_idint
Unique ID of the account.
ad_click_urlstring
Click through URL of Click Ad type creatives only (aka Click Commands)
ad_idint
Unique ID of the ad.
advertiser_idint
Unique ID of the advertiser.
creative_end_dateint
Rotation end date and time in milliseconds since 1970-01-01 00:00:00 UTC.
creative_group1string
User defined value from creative group 1.
creative_group1_idint
Unique ID of creative group 1.
creative_group2string
User defined value from creative group 2.
creative_group2_idint
Unique ID of creative group 2.
creative_idint
The Creative ID in Campaign Manager UI.
creative_rotation_typestring
Rotation type.
creative_rotation_type_idint
Id of the rotation type.
creative_start_dateint
Rotation start date and time in Unix epoch time (milliseconds).
floodlight_config_idint
Unique ID of the floodlight configuration.

Campaign Manager Data Transfer custom creative field

cm_dt_custom_creative_field
account_idint
Unique ID of the account.
advertiser_idint
Unique ID of the advertiser.
creative_field_idint
The Creative ID in Campaign Manager UI.
creative_field_namestring
User defined name associated to a particular custom creative field.
creative_field_numberint
Slot ID assigned to this custom creative field (typically IDs from 1-20).
creative_field_valuestring
User defined value as available option to named field.
creative_field_value_idint
ID of the user defined creative value.
creative_idint
The Creative ID in Campaign Manager UI.
floodlight_config_idint
Unique ID of the floodlight configuration.

Campaign Manager Data Transfer custom floodlight variable

cm_dt_custom_floodlight_variable
account_idint
Unique ID of the account.
advertiser_idint
Unique ID of the advertiser.
floodlight_config_idint
Unique ID of the floodlight configuration.
floodlight_variable_idint
Unique ID of the floodlight variable.
floodlight_variable_namestring
User defined name of the custom floodlight variable.

Campaign Manager Data Transfer custom rich media

cm_dt_custom_rich_media
account_idint
Unique ID of the account.
advertiser_idint
Unique ID of the advertiser.
floodlight_config_idint
Unique ID of the floodlight configuration.
rich_media_event_idint
ID of the rich media event.
rich_media_event_namestring
Name of the rich media event.
rich_media_event_typestring
Possible values are: "Timer", "Exit", or "Counter".
rich_media_event_type_idint
ID of the rich media event type.

Campaign Manager Data Transfer designated market area

cm_dt_designated_market_area
dma_regionstring
dma_region_idint

Campaign Manager Data Transfer events

cm_dt_events
device_id_md5string
MD5-hashed device ID; a utility may be provided to hash raw device IDs to match.
eventstruct
event.active_view_audible_impressionsint
Active View: Impressions Audible
event.active_view_audible_time_msecint
Active View: Play Time Audible (Seconds)
event.active_view_audible_visible_time_msecint
Active View: Play Time Audible and Visible (Seconds)
event.active_view_background_countint
Active View: Impressions In Background
event.active_view_complete_viewable_impressionsint
Active View: Impressions Visible at Completion
event.active_view_eligible_impressionsint
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_impressionsint
Active View: Impressions Visible and Audible at First Quartile
event.active_view_first_quartile_viewable_impressionsint
Active View: Impressions Visible at First Quartile
event.active_view_fullscreen_countint
Active View: Impressions Full-Screen
event.active_view_impressions_audible_and_visible_at_completionint
Active View: Impressions Audible and Visible at Completion
event.active_view_impressions_visible10_secondsint
Active View: Impressions Visible 10 Seconds
event.active_view_measurable_impressionsint
Whether the impression was measurable with Active View.
event.active_view_midpoint_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Midpoint
event.active_view_midpoint_viewable_impressionsint
Active View: Impressions Visible at Midpoint
event.active_view_plus_measurable_countint
Active View Plus: Measurable Impressions
event.active_view_start_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Start
event.active_view_start_viewable_impressionsint
Active View: Impressions Visible at Start
event.active_view_third_quartile_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Third Quartile
event.active_view_third_quartile_viewable_impressionsint
Active View: Impressions Visible at Third Quartile
event.active_view_tos_msecint
Active View: Time on Screen (Seconds)
event.active_view_viewable_impressionsint
Whether the impression was viewable.
event.active_view_visible_time_msecint
Active View: Video Visible Time (Seconds)
event.activity_countint
Activity Quantity
event.activity_idint
The ID of the Floodlight tag related to the conversion event.
event.activity_revenuedouble
Activity Revenue
event.ad_idint
Unique ID of the ad placement.
event.advertiser_idint
Unique ID of the advertiser
event.audience_segment_idint
event.browser_platform_idstring
ID of the browser type.
event.browser_versionstring
Browser/Platform Version
event.campaign_idint
Unique ID of the campaign
event.city_idint
City ID
event.conversion_idint
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_codestring
Country
event.creative_versionstring
Creative version number.
event.dma_region_idint
Designated Market Area ID (US/Canada).
event.dv360_ad_positionint
Specifies the position of the ad on the page if known. 1 represents above the fold, 2 represents below the fold.
event.dv360_advertiser_idint
The Display & Video 360 numerical ID for the advertiser related to the event, for example 164332.
event.dv360_adx_page_categoriesstring
DV360 Adx Page Categories
event.dv360_attributed_inventory_source_external_idstring
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_publicstring
True if inventory source is available to all buyers. False otherwise.
event.dv360_auction_idstring
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_currencyint
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_currencyint
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_usdint
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_currencyint
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_currencyint
The total amount of money billed to the partner, including the media cost and partner costs, in partner currency nanos.
event.dv360_billable_cost_usdint
The total amount of money billed to the partner, including the media cost and partner costs, in USD nanos.
event.dv360_browser_idint
The Display & Video 360 numerical ID identifying the browser related to this event.
event.dv360_browser_timezone_offset_minutesint
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_idint
The unique ID of the Display & Video 360 campaign.
event.dv360_city_idint
The Display & Video 360 numerical ID identifying the best-guess city of the impression.
event.dv360_country_codestring
2-letter ISO 3166-1 country code identifying the best-guess country of the impression, for example "US".
event.dv360_cpm_fee_1_advertiser_currencyint
event.dv360_cpm_fee_1_partner_currencyint
event.dv360_cpm_fee_1_usdint
event.dv360_cpm_fee_2_advertiser_currencyint
event.dv360_cpm_fee_2_partner_currencyint
event.dv360_cpm_fee_2_usdint
event.dv360_cpm_fee_3_advertiser_currencyint
event.dv360_cpm_fee_3_partner_currencyint
event.dv360_cpm_fee_3_usdint
event.dv360_cpm_fee_4_advertiser_currencyint
event.dv360_cpm_fee_4_partner_currencyint
event.dv360_cpm_fee_4_usdint
event.dv360_cpm_fee_5_advertiser_currencyint
event.dv360_cpm_fee_5_partner_currencyint
event.dv360_cpm_fee_5_usdint
event.dv360_creative_idint
The Display & Video 360 numerical ID for the creative related to the event, for example 367487.
event.dv360_data_fees_advertiser_currencyint
event.dv360_data_fees_partner_currencyint
event.dv360_data_fees_usdint
event.dv360_device_typeint
The numerical value of the identified device type. 0 = COMPUTER, 1 = OTHER, 2 = SMARTPHONE, 3 = TABLET, 4 = SMARTTV, 5 = CONNECTEDTV.
event.dv360_exchange_idstring
The Display & Video 360 numerical ID for the exchange that requested the ad.
event.dv360_insertion_order_idint
The Display & Video 360 numerical ID for the insertion order related to the event, for example 1079941.
event.dv360_isp_idint
The Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.
event.dv360_languagestring
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_idint
The Display & Video 360 numerical ID for the line item related to the event, for example 1155785.
event.dv360_media_cost_advertiser_currencyint
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_currencyint
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_usdint
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_currencyint
event.dv360_media_fee_1_partner_currencyint
event.dv360_media_fee_1_usdint
event.dv360_media_fee_2_advertiser_currencyint
event.dv360_media_fee_2_partner_currencyint
event.dv360_media_fee_2_usdint
event.dv360_media_fee_3_advertiser_currencyint
event.dv360_media_fee_3_partner_currencyint
event.dv360_media_fee_3_usdint
event.dv360_media_fee_4_advertiser_currencyint
event.dv360_media_fee_4_partner_currencyint
event.dv360_media_fee_4_usdint
event.dv360_media_fee_5_advertiser_currencyint
event.dv360_media_fee_5_partner_currencyint
event.dv360_media_fee_5_usdint
event.dv360_mobile_make_idint
The numerical ID for the mobile make. This value may be missing.
event.dv360_mobile_model_idint
The numerical ID for the mobile model. This value may be missing.
event.dv360_net_speedint
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_idint
event.dv360_request_timeint
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_currencyint
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_currencyint
The total amount in partner currency nanos made by the partner account for the view event. This value may be zero.
event.dv360_revenue_usdint
The total amount in USD nanos made by the partner account for the view event. This value may be zero.
event.dv360_site_idint
The Display & Video 360 numerical ID for the most specific universal site that matches the url.
event.dv360_state_region_idint
DV360 Region ID
event.dv360_urlstring
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_statestring
DV360 View State
event.dv360_zip_postal_codestring
DV360 ZIP/Postal Code
event.event_sub_typestring
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_timeint
Time in microseconds since 1970-01-01 00:00:00 UTC.
event.event_typestring
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_idint
Unique ID of the floodlight configuration.
event.impression_idstring
Impression ID
event.interaction_time_utc_secondsstring
Interaction Time
event.landing_page_url_idint
Unique ID of the landing page URL.
event.operating_system_idint
ID of the operating system.
event.ord_valuestring
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_datastring
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_idint
Unique ID for the site page / placement where the ad ran.
event.platform_type_idint
event.referrer_urlstring
Contains the URL on which the ad appeared, when possible. May also be empty, or return ad server URLs.
event.rendering_idint
Unique ID of the creative for Data Transfer. Does not correspond to the UI-Creative-ID.
event.rich_media_event_countersint
MET Counter Value (the ecn= value).
event.rich_media_event_idint
MET Event ID for the Rich Media ad.
event.rich_media_event_timersdouble
Time in microseconds since 1970-01-01 00:00:00 UTC.rs
event.rich_media_event_type_idint
ID of Rich Media Event Type.
event.site_idint
Unique ID for the site where the ad ran.
event.statestring
ID for user's state or province (US/Canada)
event.tran_valuestring
TRAN Value
event.u_valuestring
U Value
event.zip_codestring
Postal-Code (US/Canada).
is_in_rdid_projectboolean
true if this event is also in the _rdid table. Used for deduplication of events.
network_idint
The network ID.
user_idstring
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..

Campaign Manager Data Transfer floodlight

cm_dt_floodlight
device_id_md5string
MD5-hashed device ID. Utility will be provided to hash raw device IDs to match.
eventstruct
event.active_view_audible_impressionsint
Active View: Impressions Audible
event.active_view_audible_time_msecint
Active View: Play Time Audible (Seconds)
event.active_view_audible_visible_time_msecint
Active View: Play Time Audible and Visible (Seconds)
event.active_view_background_countint
Active View: Impressions In Background
event.active_view_complete_viewable_impressionsint
Active View: Impressions Visible at Completion
event.active_view_eligible_impressionsint
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_impressionsint
Active View: Impressions Visible and Audible at First Quartile
event.active_view_first_quartile_viewable_impressionsint
Active View: Impressions Visible at First Quartile
event.active_view_fullscreen_countint
Active View: Impressions Full-Screen
event.active_view_impressions_audible_and_visible_at_completionint
Active View: Impressions Audible and Visible at Completion
event.active_view_impressions_visible10_secondsint
Active View: Impressions Visible 10 Seconds
event.active_view_measurable_impressionsint
Whether the impression was measurable with Active View.
event.active_view_midpoint_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Midpoint
event.active_view_midpoint_viewable_impressionsint
Active View: Impressions Visible at Midpoint
event.active_view_plus_measurable_countint
Active View Plus: Measurable Impressions
event.active_view_start_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Start
event.active_view_start_viewable_impressionsint
Active View: Impressions Visible at Start
event.active_view_third_quartile_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Third Quartile
event.active_view_third_quartile_viewable_impressionsint
Active View: Impressions Visible at Third Quartile
event.active_view_tos_msecint
Active View: Time on Screen (Seconds)
event.active_view_viewable_impressionsint
Whether the impression was viewable.
event.active_view_visible_time_msecint
Active View: Video Visible Time (Seconds)
event.activity_countint
Activity Quantity
event.activity_idint
The ID of the Floodlight tag related to the conversion event.
event.activity_revenuedouble
Activity Revenue
event.ad_idint
Unique ID of the ad placement.
event.advertiser_idint
Unique ID of the advertiser
event.audience_segment_idint
event.browser_platform_idstring
ID of the browser type.
event.browser_versionstring
Browser/Platform Version
event.campaign_idint
Unique ID of the campaign
event.city_idint
City ID
event.conversion_idint
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_codestring
Country
event.creative_versionstring
Creative version number.
event.dma_region_idint
Designated Market Area ID (US/Canada).
event.dv360_ad_positionint
Specifies the position of the ad on the page if known. 1 represents above the fold, 2 represents below the fold.
event.dv360_advertiser_idint
The Display & Video 360 numerical ID for the advertiser related to the event, for example 164332.
event.dv360_adx_page_categoriesstring
DV360 Adx Page Categories
event.dv360_attributed_inventory_source_external_idstring
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_publicstring
True if inventory source is available to all buyers. False otherwise.
event.dv360_auction_idstring
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_currencyint
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_currencyint
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_usdint
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_currencyint
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_currencyint
The total amount of money billed to the partner, including the media cost and partner costs, in partner currency nanos.
event.dv360_billable_cost_usdint
The total amount of money billed to the partner, including the media cost and partner costs, in USD nanos.
event.dv360_browser_idint
The Display & Video 360 numerical ID identifying the browser related to this event.
event.dv360_browser_timezone_offset_minutesint
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_idint
The unique ID of the Display & Video 360 campaign.
event.dv360_city_idint
The Display & Video 360 numerical ID identifying the best-guess city of the impression.
event.dv360_country_codestring
2-letter ISO 3166-1 country code identifying the best-guess country of the impression, for example "US".
event.dv360_cpm_fee_1_advertiser_currencyint
event.dv360_cpm_fee_1_partner_currencyint
event.dv360_cpm_fee_1_usdint
event.dv360_cpm_fee_2_advertiser_currencyint
event.dv360_cpm_fee_2_partner_currencyint
event.dv360_cpm_fee_2_usdint
event.dv360_cpm_fee_3_advertiser_currencyint
event.dv360_cpm_fee_3_partner_currencyint
event.dv360_cpm_fee_3_usdint
event.dv360_cpm_fee_4_advertiser_currencyint
event.dv360_cpm_fee_4_partner_currencyint
event.dv360_cpm_fee_4_usdint
event.dv360_cpm_fee_5_advertiser_currencyint
event.dv360_cpm_fee_5_partner_currencyint
event.dv360_cpm_fee_5_usdint
event.dv360_creative_idint
The Display & Video 360 numerical ID for the creative related to the event, for example 367487.
event.dv360_data_fees_advertiser_currencyint
event.dv360_data_fees_partner_currencyint
event.dv360_data_fees_usdint
event.dv360_device_typeint
The numerical value of the identified device type. 0 = COMPUTER, 1 = OTHER, 2 = SMARTPHONE, 3 = TABLET, 4 = SMARTTV, 5 = CONNECTEDTV.
event.dv360_exchange_idstring
The Display & Video 360 numerical ID for the exchange that requested the ad.
event.dv360_insertion_order_idint
The Display & Video 360 numerical ID for the insertion order related to the event, for example 1079941.
event.dv360_isp_idint
The Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.
event.dv360_languagestring
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_idint
The Display & Video 360 numerical ID for the line item related to the event, for example 1155785.
event.dv360_media_cost_advertiser_currencyint
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_currencyint
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_usdint
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_currencyint
event.dv360_media_fee_1_partner_currencyint
event.dv360_media_fee_1_usdint
event.dv360_media_fee_2_advertiser_currencyint
event.dv360_media_fee_2_partner_currencyint
event.dv360_media_fee_2_usdint
event.dv360_media_fee_3_advertiser_currencyint
event.dv360_media_fee_3_partner_currencyint
event.dv360_media_fee_3_usdint
event.dv360_media_fee_4_advertiser_currencyint
event.dv360_media_fee_4_partner_currencyint
event.dv360_media_fee_4_usdint
event.dv360_media_fee_5_advertiser_currencyint
event.dv360_media_fee_5_partner_currencyint
event.dv360_media_fee_5_usdint
event.dv360_mobile_make_idint
The numerical ID for the mobile make. This value may be missing.
event.dv360_mobile_model_idint
The numerical ID for the mobile model. This value may be missing.
event.dv360_net_speedint
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_idint
event.dv360_request_timeint
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_currencyint
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_currencyint
The total amount in partner currency nanos made by the partner account for the view event. This value may be zero.
event.dv360_revenue_usdint
The total amount in USD nanos made by the partner account for the view event. This value may be zero.
event.dv360_site_idint
The Display & Video 360 numerical ID for the most specific universal site that matches the url.
event.dv360_state_region_idint
DV360 Region ID
event.dv360_urlstring
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_statestring
DV360 View State
event.dv360_zip_postal_codestring
DV360 ZIP/Postal Code
event.event_sub_typestring
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_timeint
Time in microseconds since 1970-01-01 00:00:00 UTC.
event.event_typestring
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_idint
Unique ID of the floodlight configuration.
event.impression_idstring
Impression ID
event.interaction_time_utc_secondsstring
Interaction Time
event.landing_page_url_idint
Unique ID of the landing page URL.
event.operating_system_idint
ID of the operating system.
event.ord_valuestring
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_datastring
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_idint
Unique ID for the site page / placement where the ad ran.
event.platform_type_idint
event.referrer_urlstring
Contains the URL on which the ad appeared, when possible. May also be empty, or return ad server URLs.
event.rendering_idint
Unique ID of the creative for Data Transfer. Does not correspond to the UI-Creative-ID.
event.rich_media_event_countersint
MET Counter Value (the ecn= value).
event.rich_media_event_idint
MET Event ID for the Rich Media ad.
event.rich_media_event_timersdouble
Time in microseconds since 1970-01-01 00:00:00 UTC.rs
event.rich_media_event_type_idint
ID of Rich Media Event Type.
event.site_idint
Unique ID for the site where the ad ran.
event.statestring
ID for user's state or province (US/Canada)
event.tran_valuestring
TRAN Value
event.u_valuestring
U Value
event.zip_codestring
Postal-Code (US/Canada).
is_in_rdid_projectboolean
true if this event is also in the _rdid table. Used for deduplication of events.
network_idint
The network ID.
user_idstring
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..

Campaign Manager Data Transfer impressions

cm_dt_impressions
device_id_md5string
MD5-hashed device ID. Utility will be provided to hash raw device IDs to match.
eventstruct
event.active_view_audible_impressionsint
Active View: Impressions Audible
event.active_view_audible_time_msecint
Active View: Play Time Audible (Seconds)
event.active_view_audible_visible_time_msecint
Active View: Play Time Audible and Visible (Seconds)
event.active_view_background_countint
Active View: Impressions In Background
event.active_view_complete_viewable_impressionsint
Active View: Impressions Visible at Completion
event.active_view_eligible_impressionsint
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_impressionsint
Active View: Impressions Visible and Audible at First Quartile
event.active_view_first_quartile_viewable_impressionsint
Active View: Impressions Visible at First Quartile
event.active_view_fullscreen_countint
Active View: Impressions Full-Screen
event.active_view_impressions_audible_and_visible_at_completionint
Active View: Impressions Audible and Visible at Completion
event.active_view_impressions_visible10_secondsint
Active View: Impressions Visible 10 Seconds
event.active_view_measurable_impressionsint
Whether the impression was measurable with Active View.
event.active_view_midpoint_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Midpoint
event.active_view_midpoint_viewable_impressionsint
Active View: Impressions Visible at Midpoint
event.active_view_plus_measurable_countint
Active View Plus: Measurable Impressions
event.active_view_start_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Start
event.active_view_start_viewable_impressionsint
Active View: Impressions Visible at Start
event.active_view_third_quartile_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Third Quartile
event.active_view_third_quartile_viewable_impressionsint
Active View: Impressions Visible at Third Quartile
event.active_view_tos_msecint
Active View: Time on Screen (Seconds)
event.active_view_visible_time_msecint
Active View: Video Visible Time (Seconds)
event.activity_countint
Activity Quantity
event.activity_idint
The ID of the Floodlight tag related to the conversion event.
event.activity_revenuedouble
Activity Revenue
event.ad_idint
Unique ID of the ad placement.
event.advertiser_idint
Unique ID of the advertiser
event.audience_segment_idint
event.browser_platform_idstring
ID of the browser type.
event.browser_versionstring
Browser/Platform Version
event.campaign_idint
Unique ID of the campaign
event.city_idint
City ID
event.conversion_idint
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_codestring
Country
event.creative_versionstring
Creative version number.
event.dma_region_idint
Designated Market Area ID (US/Canada).
event.dv360_ad_positionint
Specifies the position of the ad on the page if known. 1 represents above the fold, 2 represents below the fold.
event.dv360_advertiser_idint
The Display & Video 360 numerical ID for the advertiser related to the event, for example 164332.
event.dv360_adx_page_categoriesstring
DV360 Adx Page Categories
event.dv360_attributed_inventory_source_external_idstring
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_publicstring
True if inventory source is available to all buyers. False otherwise.
event.dv360_auction_idstring
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_currencyint
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_currencyint
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_usdint
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_currencyint
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_currencyint
The total amount of money billed to the partner, including the media cost and partner costs, in partner currency nanos.
event.dv360_billable_cost_usdint
The total amount of money billed to the partner, including the media cost and partner costs, in USD nanos.
event.dv360_browser_idint
The Display & Video 360 numerical ID identifying the browser related to this event.
event.dv360_browser_timezone_offset_minutesint
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_idint
The unique ID of the Display & Video 360 campaign.
event.dv360_city_idint
The Display & Video 360 numerical ID identifying the best-guess city of the impression.
event.dv360_country_codestring
2-letter ISO 3166-1 country code identifying the best-guess country of the impression, for example "US".
event.dv360_cpm_fee_1_advertiser_currencyint
event.dv360_cpm_fee_1_partner_currencyint
event.dv360_cpm_fee_1_usdint
event.dv360_cpm_fee_2_advertiser_currencyint
event.dv360_cpm_fee_2_partner_currencyint
event.dv360_cpm_fee_2_usdint
event.dv360_cpm_fee_3_advertiser_currencyint
event.dv360_cpm_fee_3_partner_currencyint
event.dv360_cpm_fee_3_usdint
event.dv360_cpm_fee_4_advertiser_currencyint
event.dv360_cpm_fee_4_partner_currencyint
event.dv360_cpm_fee_4_usdint
event.dv360_cpm_fee_5_advertiser_currencyint
event.dv360_cpm_fee_5_partner_currencyint
event.dv360_cpm_fee_5_usdint
event.dv360_creative_idint
The Display & Video 360 numerical ID for the creative related to the event, for example 367487.
event.dv360_data_fees_advertiser_currencyint
event.dv360_data_fees_partner_currencyint
event.dv360_data_fees_usdint
event.dv360_device_typeint
The numerical value of the identified device type. 0 = COMPUTER, 1 = OTHER, 2 = SMARTPHONE, 3 = TABLET, 4 = SMARTTV, 5 = CONNECTEDTV.
event.dv360_exchange_idstring
The Display & Video 360 numerical ID for the exchange that requested the ad.
event.dv360_insertion_order_idint
The Display & Video 360 numerical ID for the insertion order related to the event, for example 1079941.
event.dv360_isp_idint
The Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.
event.dv360_languagestring
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_idint
The Display & Video 360 numerical ID for the line item related to the event, for example 1155785.
event.dv360_media_cost_advertiser_currencyint
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_currencyint
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_usdint
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_currencyint
event.dv360_media_fee_1_partner_currencyint
event.dv360_media_fee_1_usdint
event.dv360_media_fee_2_advertiser_currencyint
event.dv360_media_fee_2_partner_currencyint
event.dv360_media_fee_2_usdint
event.dv360_media_fee_3_advertiser_currencyint
event.dv360_media_fee_3_partner_currencyint
event.dv360_media_fee_3_usdint
event.dv360_media_fee_4_advertiser_currencyint
event.dv360_media_fee_4_partner_currencyint
event.dv360_media_fee_4_usdint
event.dv360_media_fee_5_advertiser_currencyint
event.dv360_media_fee_5_partner_currencyint
event.dv360_media_fee_5_usdint
event.dv360_mobile_make_idint
The numerical ID for the mobile make. This value may be missing.
event.dv360_mobile_model_idint
The numerical ID for the mobile model. This value may be missing.
event.dv360_net_speedint
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_idint
event.dv360_request_timeint
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_currencyint
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_currencyint
The total amount in partner currency nanos made by the partner account for the view event. This value may be zero.
event.dv360_revenue_usdint
The total amount in USD nanos made by the partner account for the view event. This value may be zero.
event.dv360_site_idint
The Display & Video 360 numerical ID for the most specific universal site that matches the url.
event.dv360_state_region_idint
DV360 Region ID
event.dv360_urlstring
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_statestring
DV360 View State
event.dv360_zip_postal_codestring
DV360 ZIP/Postal Code
event.event_sub_typestring
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_timeint
Time in microseconds since 1970-01-01 00:00:00 UTC.
event.event_typestring
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_idint
Unique ID of the floodlight configuration.
event.impression_idstring
Impression ID
event.interaction_time_utc_secondsstring
Interaction Time
event.landing_page_url_idint
Unique ID of the landing page URL.
event.operating_system_idint
ID of the operating system.
event.ord_valuestring
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_datastring
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_idint
Unique ID for the site page / placement where the ad ran.
event.platform_type_idint
event.referrer_urlstring
Contains the URL on which the ad appeared, when possible. May also be empty, or return ad server URLs.
event.rendering_idint
Unique ID of the creative for Data Transfer. Does not correspond to the UI-Creative-ID.
event.rich_media_event_countersint
MET Counter Value (the ecn= value).
event.rich_media_event_idint
MET Event ID for the Rich Media ad.
event.rich_media_event_timersdouble
Time in microseconds since 1970-01-01 00:00:00 UTC.rs
event.rich_media_event_type_idint
ID of Rich Media Event Type.
event.site_idint
Unique ID for the site where the ad ran.
event.statestring
ID for user's state or province (US/Canada)
event.tran_valuestring
TRAN Value
event.u_valuestring
U Value
event.zip_codestring
Postal-Code (US/Canada).
is_in_rdid_projectboolean
true if this event is also in the _rdid table. Used for deduplication of events.
network_idint
The network ID.
user_idstring
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..

Campaign Manager Data Transfer landing page url

cm_dt_landing_page_url
account_idint
Unique ID of the account.
landing_page_urlstring
The URL a user was sent to when they clicked on an ad.
landing_page_url_idint
Unique ID of the landing page URL.

Campaign Manager Data Transfer operating system

cm_dt_operating_system
operating_systemstring
operating_system_idint
Unique ID of OS just for Data Transfer.

Campaign Manager Data Transfer paid search

cm_dt_paid_search
ad_idint
Unique ID of the ad.
advertiser_idint
Unique ID of the advertiser.
campaign_idint
Unique ID of the campaign.
floodlight_config_idint
Unique ID of the floodlight configuration.
paid_search_ad_groupstring
User defined keyword group.
paid_search_ad_group_idint
Unique ID of the keyword group.
paid_search_ad_idint
Unique ID associated with a Search Ads 360 ad.
paid_search_bid_strategystring
User defined keyword bid strategy. Returns a value of "(not set)" if empty.
paid_search_bid_strategy_idint
ID of the keyword bid strategy.
paid_search_campaignstring
User defined name of campaign as entered into Search Ads 360.
paid_search_campaign_idint
ID of the Search Ads 360 campaign.
paid_search_keywordstring
User defined keyword value as entered into Search Ads 360.
paid_search_keyword_idint
Unique ID from Search Ads 360. Uses the “long” format
paid_search_landing_page_urlstring
User defined landing page URL as entered into Search Ads 360.
paid_search_legacy_keyword_idint
Unique ID from Search Ads 360. Uses the "short" format in which the leading 43* is removed.
paid_search_match_typestring
User selected

Campaign Manager Data Transfer placement

cm_dt_placement
account_idint
Unique ID of the account.
activity_idint
Unique ID of the Floodlight activity.
advertiser_idint
Unique ID of the advertiser.
campaign_idint
Unique ID of the campaign.
content_categorystring
User defined content category.
content_category_idint
ID of content category.
flighting_activatedboolean
Indicates whether this is a flighted (billing) placement.
floodlight_config_idint
Unique ID of the floodlight configuration.
package_roadblock_idint
package_roadblock_typestring
package_roadblock_type_idint
placementstring
placement_cap_cost_optionint
User entered cost capping amount.
placement_cost_structurestring
placement_end_dateint
End date of the flight in 'YYYYMMDD' format.
placement_idint
placement_start_dateint
Start date of the flight in 'YYYYMMDD' format.
placement_strategystring
User defined placement strategy.
placement_strategy_idint
ID of the placement strategy.
site_idint
Unique ID of the site.
site_keynamestring

Campaign Manager Data Transfer placement cost

cm_dt_placement_cost
account_idint
Unique ID of the account.
advertiser_idint
Unique ID of the advertiser.
floodlight_config_idint
Unique ID of the floodlight configuration.
placement_commentsstring
User entered placement pricing comments.
placement_end_dateint
End date of the flight in 'YYYYMMDD' format.
placement_idint
Placement ID
placement_rateint
Purchased rate expressed in nanos of the network's currency. 1 nano = 1 billionth. 1 nano USD = $0.000000001.
placement_start_dateint
Start date of the flight in 'YYYYMMDD' format.
placement_total_booked_unitsint
The number of purchased units.

Campaign Manager Data Transfer rich media

cm_dt_rich_media
device_id_md5string
MD5-hashed device ID; a utility may be provided to hash raw device IDs to match.
eventstruct
event.active_view_audible_impressionsint
Active View: Impressions Audible
event.active_view_audible_time_msecint
Active View: Play Time Audible (Seconds)
event.active_view_audible_visible_time_msecint
Active View: Play Time Audible and Visible (Seconds)
event.active_view_background_countint
Active View: Impressions In Background
event.active_view_complete_viewable_impressionsint
Active View: Impressions Visible at Completion
event.active_view_eligible_impressionsint
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_impressionsint
Active View: Impressions Visible and Audible at First Quartile
event.active_view_first_quartile_viewable_impressionsint
Active View: Impressions Visible at First Quartile
event.active_view_fullscreen_countint
Active View: Impressions Full-Screen
event.active_view_impressions_audible_and_visible_at_completionint
Active View: Impressions Audible and Visible at Completion
event.active_view_impressions_visible10_secondsint
Active View: Impressions Visible 10 Seconds
event.active_view_measurable_impressionsint
Whether the impression was measurable with Active View.
event.active_view_midpoint_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Midpoint
event.active_view_midpoint_viewable_impressionsint
Active View: Impressions Visible at Midpoint
event.active_view_plus_measurable_countint
Active View Plus: Measurable Impressions
event.active_view_start_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Start
event.active_view_start_viewable_impressionsint
Active View: Impressions Visible at Start
event.active_view_third_quartile_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Third Quartile
event.active_view_third_quartile_viewable_impressionsint
Active View: Impressions Visible at Third Quartile
event.active_view_tos_msecint
Active View: Time on Screen (Seconds)
event.active_view_viewable_impressionsint
Whether the impression was viewable.
event.active_view_visible_time_msecint
Active View: Video Visible Time (Seconds)
event.activity_countint
Activity Quantity
event.activity_idint
The ID of the Floodlight tag related to the conversion event.
event.activity_revenuedouble
Activity Revenue
event.ad_idint
Unique ID of the ad placement.
event.advertiser_idint
Unique ID of the advertiser
event.audience_segment_idint
event.browser_platform_idstring
ID of the browser type.
event.browser_versionstring
Browser/Platform Version
event.campaign_idint
Unique ID of the campaign
event.city_idint
City ID
event.conversion_idint
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_codestring
Country
event.creative_versionstring
Creative version number.
event.dma_region_idint
Designated Market Area ID (US/Canada).
event.dv360_ad_positionint
Specifies the position of the ad on the page if known. 1 represents above the fold, 2 represents below the fold.
event.dv360_advertiser_idint
The Display & Video 360 numerical ID for the advertiser related to the event, for example 164332.
event.dv360_adx_page_categoriesstring
DV360 Adx Page Categories
event.dv360_attributed_inventory_source_external_idstring
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_publicstring
True if inventory source is available to all buyers. False otherwise.
event.dv360_auction_idstring
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_currencyint
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_currencyint
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_usdint
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_currencyint
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_currencyint
The total amount of money billed to the partner, including the media cost and partner costs, in partner currency nanos.
event.dv360_billable_cost_usdint
The total amount of money billed to the partner, including the media cost and partner costs, in USD nanos.
event.dv360_browser_idint
The Display & Video 360 numerical ID identifying the browser related to this event.
event.dv360_browser_timezone_offset_minutesint
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_idint
The unique ID of the Display & Video 360 campaign.
event.dv360_city_idint
The Display & Video 360 numerical ID identifying the best-guess city of the impression.
event.dv360_country_codestring
2-letter ISO 3166-1 country code identifying the best-guess country of the impression, for example "US".
event.dv360_cpm_fee_1_advertiser_currencyint
event.dv360_cpm_fee_1_partner_currencyint
event.dv360_cpm_fee_1_usdint
event.dv360_cpm_fee_2_advertiser_currencyint
event.dv360_cpm_fee_2_partner_currencyint
event.dv360_cpm_fee_2_usdint
event.dv360_cpm_fee_3_advertiser_currencyint
event.dv360_cpm_fee_3_partner_currencyint
event.dv360_cpm_fee_3_usdint
event.dv360_cpm_fee_4_advertiser_currencyint
event.dv360_cpm_fee_4_partner_currencyint
event.dv360_cpm_fee_4_usdint
event.dv360_cpm_fee_5_advertiser_currencyint
event.dv360_cpm_fee_5_partner_currencyint
event.dv360_cpm_fee_5_usdint
event.dv360_creative_idint
The Display & Video 360 numerical ID for the creative related to the event, for example 367487.
event.dv360_data_fees_advertiser_currencyint
event.dv360_data_fees_partner_currencyint
event.dv360_data_fees_usdint
event.dv360_device_typeint
The numerical value of the identified device type. 0 = COMPUTER, 1 = OTHER, 2 = SMARTPHONE, 3 = TABLET, 4 = SMARTTV, 5 = CONNECTEDTV.
event.dv360_exchange_idstring
The Display & Video 360 numerical ID for the exchange that requested the ad.
event.dv360_insertion_order_idint
The Display & Video 360 numerical ID for the insertion order related to the event, for example 1079941.
event.dv360_isp_idint
The Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.
event.dv360_languagestring
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_idint
The Display & Video 360 numerical ID for the line item related to the event, for example 1155785.
event.dv360_media_cost_advertiser_currencyint
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_currencyint
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_usdint
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_currencyint
event.dv360_media_fee_1_partner_currencyint
event.dv360_media_fee_1_usdint
event.dv360_media_fee_2_advertiser_currencyint
event.dv360_media_fee_2_partner_currencyint
event.dv360_media_fee_2_usdint
event.dv360_media_fee_3_advertiser_currencyint
event.dv360_media_fee_3_partner_currencyint
event.dv360_media_fee_3_usdint
event.dv360_media_fee_4_advertiser_currencyint
event.dv360_media_fee_4_partner_currencyint
event.dv360_media_fee_4_usdint
event.dv360_media_fee_5_advertiser_currencyint
event.dv360_media_fee_5_partner_currencyint
event.dv360_media_fee_5_usdint
event.dv360_mobile_make_idint
The numerical ID for the mobile make. This value may be missing.
event.dv360_mobile_model_idint
The numerical ID for the mobile model. This value may be missing.
event.dv360_net_speedint
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_idint
event.dv360_request_timeint
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_currencyint
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_currencyint
The total amount in partner currency nanos made by the partner account for the view event. This value may be zero.
event.dv360_revenue_usdint
The total amount in USD nanos made by the partner account for the view event. This value may be zero.
event.dv360_site_idint
The Display & Video 360 numerical ID for the most specific universal site that matches the url.
event.dv360_state_region_idint
DV360 Region ID
event.dv360_urlstring
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_statestring
DV360 View State
event.dv360_zip_postal_codestring
DV360 ZIP/Postal Code
event.event_sub_typestring
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_timeint
Time in microseconds since 1970-01-01 00:00:00 UTC.
event.event_typestring
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_idint
Unique ID of the floodlight configuration.
event.impression_idstring
Impression ID
event.interaction_time_utc_secondsstring
Interaction Time
event.landing_page_url_idint
Unique ID of the landing page URL.
event.operating_system_idint
ID of the operating system.
event.ord_valuestring
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_datastring
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_idint
Unique ID for the site page / placement where the ad ran.
event.platform_type_idint
event.referrer_urlstring
Contains the URL on which the ad appeared, when possible. May also be empty, or return ad server URLs.
event.rendering_idint
Unique ID of the creative for Data Transfer. Does not correspond to the UI-Creative-ID.
event.rich_media_event_countersint
MET Counter Value (the ecn= value).
event.rich_media_event_idint
MET Event ID for the Rich Media ad.
event.rich_media_event_timersdouble
Time in microseconds since 1970-01-01 00:00:00 UTC.rs
event.rich_media_event_type_idint
ID of Rich Media Event Type.
event.site_idint
Unique ID for the site where the ad ran.
event.statestring
ID for user's state or province (US/Canada)
event.tran_valuestring
TRAN Value
event.u_valuestring
U Value
event.zip_codestring
Postal-Code (US/Canada).
is_in_rdid_projectboolean
true if this event is also in the _rdid table. Used for deduplication of events.
network_idint
The network ID.
user_idstring
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..

Campaign Manager Data Transfer site

cm_dt_site
account_idint
Unique ID of the account.
sitestring
The name of the site.
site_directorystring
Global unique name for this site.
site_directory_idint
Global unique ID for this site.
site_idint
Unique ID of the site.

Campaign Manager Data Transfer state

cm_dt_state
regionstring
Abbreviated state/province name.
region_full_namestring
Region name in English.

Campaign Manager paths

cm_paths
cm_paths.user_idstring
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...
cm_paths.network_idint
The network ID.
cm_paths.partner_idint
Unique ID of the partner.
cm_paths.pathrecord
Row containing event path for a given user.
cm_paths.eventsrepeated struct
cm_paths.events.event_timeint
Time in microseconds since 1970-01-01 00:00:00 UTC.
cm_paths.events.advertiser_idint
Unique ID of the advertiser
cm_paths.events.campaign_idint
Unique ID of the campaign
cm_paths.events.ad_idint
Unique ID of the ad placement.
cm_paths.events.rendering_idint
Unique ID of the creative for Data Transfer. Does not correspond to the UI-Creative-ID.
cm_paths.events.creative_versionstring
Creative version number.
cm_paths.events.site_idint
Site ID
cm_paths.events.country_codestring
2-letter ISO 3166-1 country code.
cm_paths.events.statestring
State
cm_paths.events.browser_platform_idstring
Browser platform ID
cm_paths.events.browser_versionstring
Browser version
cm_paths.events.dma_region_idint
DMA region ID
cm_paths.events.city_idint
City ID
cm_paths.events.zip_codestring
Postal-Code (US/Canada).
cm_paths.events.u_valuestring
U value
cm_paths.events.event_typestring
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.
cm_paths.events.event_sub_typestring
Event sub type
cm_paths.events.dv360_auction_idstring
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.
cm_paths.events.dv360_request_timeint
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
cm_paths.events.dv360_advertiser_idint
The Display & Video 360 numerical ID for the advertiser related to the event, for example 164332.
cm_paths.events.dv360_insertion_order_idint
The Display & Video 360 numerical ID for the insertion order related to the event, for example 1079941.
cm_paths.events.dv360_line_item_idint
The Display & Video 360 numerical ID for the line item related to the event, for example 1155785.
cm_paths.events.dv360_creative_idint
The Display & Video 360 numerical ID for the creative related to the event, for example 367487.
cm_paths.events.dv360_bid_price_usdint
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.
cm_paths.events.dv360_bid_price_partner_currencyint
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.
cm_paths.events.dv360_bid_price_advertiser_currencyint
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.
cm_paths.events.dv360_urlstring
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"
cm_paths.events.dv360_site_idint
The Display & Video 360 numerical ID for the most specific universal site that matches the url.
cm_paths.events.dv360_languagestring
The ISO-639-1 code or "zh_CN" (Chinese (simplified)), "zh_TW" (Chinese (traditional)) or "other" representing the language related to the view event.
cm_paths.events.dv360_adx_page_categoriesstring
Contains the Ad Exchange page category IDs separated by a space, for example "65 189". The categories may not be mutually exclusive.
cm_paths.events.dv360_matching_targeted_keywordsstring
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.
cm_paths.events.dv360_exchange_idstring
The Display & Video 360 numerical ID for the exchange that requested the ad.
cm_paths.events.dv360_attributed_inventory_source_external_idstring
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.
cm_paths.events.dv360_attributed_inventory_source_is_publicstring
True if inventory source is available to all buyers. False otherwise.
cm_paths.events.dv360_ad_positionint
Specifies the position of the ad on the page if known. 1 represents above the fold, 2 represents below the fold.
cm_paths.events.dv360_country_codestring
2-letter ISO 3166-1 country code identifying the best-guess country of the impression, for example "US".
cm_paths.events.dv360_zip_postal_codestring
The postal code identifying the best-guess postal area of the impression if known, for example "98033". Do not assume uniqueness across different countries.
cm_paths.events.dv360_browser_timezone_offset_minutesint
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.
cm_paths.events.dv360_net_speedint
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.
cm_paths.events.dv360_matching_targeted_segmentsstring
The names of targeted user lists that match the visitor separated by a space, 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.
cm_paths.events.dv360_isp_idint
The Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.
cm_paths.events.dv360_device_typeint
The numerical value of the identified device type. 0 = COMPUTER, 1 = OTHER, 2 = SMARTPHONE, 3 = TABLET, 4 = SMARTTV, 5 = CONNECTEDTV.
cm_paths.events.dv360_mobile_model_idint
The numerical ID for the mobile model. This value may be missing.
cm_paths.events.placement_idint
Unique ID for the site page / placement where the ad ran.
cm_paths.events.operating_system_idint
ID of the operating system.
cm_paths.events.segment_value_1int
Segment value 1
cm_paths.events.dv360_state_region_idint
An integer matching the state/region integer available in reporting and targeting.
cm_paths.events.dv360_city_idint
The Display & Video 360 numerical ID identifying the best-guess city of the impression.
cm_paths.events.dv360_browser_idint
DV360 browser ID
cm_paths.events.activity_idint
The ID of the Floodlight tag related to the conversion event.
cm_paths.events.ord_valuestring
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)
cm_paths.events.conversion_idint
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).
cm_paths.events.floodlight_config_idint
Unique ID of the floodlight configuration. ID
cm_paths.events.interaction_time_utc_secondsstring
The activity’s associated (aka "matched") click or impression time in microseconds since 1970-01-01 00:00:00 UTC.
cm_paths.events.rich_media_event_idint
MET Event ID for the Rich Media ad.
cm_paths.events.rich_media_event_type_idint
ID of Rich Media Event Type.
cm_paths.events.impression_idstring
Impression ID
cm_paths.events.other_datastring
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")
cm_paths.events.referrer_urlstring
Contains the URL on which the ad appeared, when possible. May also be empty, or return ad server URLs.
cm_paths.events.tran_valuestring
Tran value
cm_paths.events.dv360_view_statestring
DV360 view state
cm_paths.events.landing_page_url_idint
Landing page url ID
cm_paths.events.audience_segment_idint
Audience segment ID
cm_paths.events.dv360_media_cost_usdint
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.
cm_paths.events.dv360_media_cost_partner_currencyint
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.
cm_paths.events.dv360_media_cost_advertiser_currencyint
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.
cm_paths.events.dv360_revenue_usdint
DV360 revenue usd
cm_paths.events.dv360_revenue_partner_currencyint
DV360 revenue partner currency
cm_paths.events.dv360_revenue_advertiser_currencyint
DV360 revenue advertiser currency
cm_paths.events.dv360_cpm_fee_1_usdint
The CPM 1 fee in USD nanos. This value may be zero.
cm_paths.events.dv360_cpm_fee_1_partner_currencyint
The CPM 1 fee in partner currency nanos. This value may be zero.
cm_paths.events.dv360_cpm_fee_1_advertiser_currencyint
The CPM 1 fee in advertiser currency nanos. This value may be zero.
cm_paths.events.dv360_cpm_fee_2_usdint
The CPM 2 fee in USD nanos. This value may be zero.
cm_paths.events.dv360_cpm_fee_2_partner_currencyint
The CPM 2 fee in partner currency nanos. This value may be zero.
cm_paths.events.dv360_cpm_fee_2_advertiser_currencyint
The CPM 2 fee in advertiser currency nanos. This value may be zero.
cm_paths.events.dv360_cpm_fee_3_usdint
The CPM 3 fee in USD nanos. This value may be zero.
cm_paths.events.dv360_cpm_fee_3_partner_currencyint
The CPM 3 fee in partner currency nanos. This value may be zero.
cm_paths.events.dv360_cpm_fee_3_advertiser_currencyint
The CPM 3 fee in advertiser currency nanos. This value may be zero.
cm_paths.events.dv360_cpm_fee_4_usdint
The CPM 4 fee in USD nanos. This value may be zero.
cm_paths.events.dv360_cpm_fee_4_partner_currencyint
The CPM 4 fee in partner currency nanos. This value may be zero.
cm_paths.events.dv360_cpm_fee_4_advertiser_currencyint
The CPM 4 fee in advertiser currency nanos. This value may be zero.
cm_paths.events.dv360_cpm_fee_5_usdint
The CPM 5 fee in USD nanos. This value may be zero.
cm_paths.events.dv360_cpm_fee_5_partner_currencyint
The CPM 5 fee in partner currency nanos. This value may be zero.
cm_paths.events.dv360_cpm_fee_5_advertiser_currencyint
The CPM 5 fee in advertiser currency nanos. This value may be zero.
cm_paths.events.dv360_media_fee_1_usdint
The Media Fee 1 fee in USD nanos. This value may be zero.
cm_paths.events.dv360_media_fee_1_partner_currencyint
The Media Fee 1 fee in partner currency nanos. This value may be zero.
cm_paths.events.dv360_media_fee_1_advertiser_currencyint
The Media Fee 1 fee in advertiser currency nanos. This value may be zero.
cm_paths.events.dv360_media_fee_2_usdint
The Media Fee 2 fee in USD nanos. This value may be zero.
cm_paths.events.dv360_media_fee_2_partner_currencyint
The Media Fee 2 fee in partner currency nanos. This value may be zero.
cm_paths.events.dv360_media_fee_2_advertiser_currencyint
The Media Fee 2 fee in advertiser currency nanos. This value may be zero.
cm_paths.events.dv360_media_fee_3_usdint
The Media Fee 3 fee in USD nanos. This value may be zero.
cm_paths.events.dv360_media_fee_3_partner_currencyint
The Media Fee 3 fee in partner currency nanos. This value may be zero.
cm_paths.events.dv360_media_fee_3_advertiser_currencyint
The Media Fee 3 fee in advertiser currency nanos. This value may be zero.
cm_paths.events.dv360_media_fee_4_usdint
The Media Fee 4 fee in USD nanos. This value may be zero.
cm_paths.events.dv360_media_fee_4_partner_currencyint
The Media Fee 4 fee in partner currency nanos. This value may be zero.
cm_paths.events.dv360_media_fee_4_advertiser_currencyint
The Media Fee 4 fee in advertiser currency nanos. This value may be zero.
cm_paths.events.dv360_media_fee_5_usdint
The Media Fee 5 fee in USD nanos. This value may be zero.
cm_paths.events.dv360_media_fee_5_partner_currencyint
The Media Fee 5 fee in partner currency nanos. This value may be zero.
cm_paths.events.dv360_media_fee_5_advertiser_currencyint
The Media Fee 5 fee in advertiser currency nanos. This value may be zero.
cm_paths.events.dv360_data_fees_usdint
The cost of any data that was used to target this impression, in USD nanos
cm_paths.events.dv360_data_fees_partner_currencyint
The cost of any data that was used to target this impression, in partner currency nanos.
cm_paths.events.dv360_data_fees_advertiser_currencyint
The cost of any data that was used to target this impression, in advertiser currency nanos.
cm_paths.events.activity_countint
Activity count
cm_paths.events.activity_revenuedouble
Activity revenue
cm_paths.events.active_view_eligible_impressionsint
Active View eligible impressions
cm_paths.events.active_view_viewable_impressionsint
Active View viewable impressions
cm_paths.events.dv360_billable_cost_usdint
The total amount of money billed to the partner, including the media cost and partner costs, in USD nanos.
cm_paths.events.dv360_billable_cost_partner_currencyint
The total amount of money billed to the partner, including the media cost and partner costs, in partner currency nanos.
cm_paths.events.dv360_billable_cost_advertiser_currencyint
The total amount of money billed to the partner, including the media cost and partner costs, in advertiser currency nanos.
cm_paths.events.active_view_measurable_impressionsint
Active View measurable impressions
cm_paths.events.rich_media_event_countersint
Rich media event counters
cm_paths.events.rich_media_event_timersdouble
Rich media event timers
cm_paths.floodlight_config_idint
Unique ID of the floodlight configuration. ID

DV360 Data Transfer Active View plus

dv360_dt_active_view_plus
device_id_md5string
MD5-hashed device ID. Utility will be provided to hash raw device IDs to match.
eventstruct
event.active_view_audible_impressionsint
Active View: Impressions Audible
event.active_view_audible_time_msecint
Active View: Play Time Audible (Seconds)
event.active_view_audible_visible_time_msecint
Active View: Play Time Audible and Visible (Seconds)
event.active_view_background_countint
Active View: Impressions In Background
event.active_view_complete_viewable_impressionsint
Active View: Impressions Visible at Completion
event.active_view_eligible_impressionsint
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_impressionsint
Active View: Impressions Visible and Audible at First Quartile
event.active_view_first_quartile_viewable_impressionsint
Active View: Impressions Visible at First Quartile
event.active_view_fullscreen_countint
Active View: Impressions Full-Screen
event.active_view_impressions_audible_and_visible_at_completionint
Active View: Impressions Audible and Visible at Completion
event.active_view_impressions_visible10_secondsint
Active View: Impressions Visible 10 Seconds
event.active_view_measurable_impressionsint
Whether the impression was measurable with Active View.
event.active_view_midpoint_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Midpoint
event.active_view_midpoint_viewable_impressionsint
Active View: Impressions Visible at Midpoint
event.active_view_plus_measurable_countint
Active View Plus: Measurable Impressions
event.active_view_start_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Start
event.active_view_start_viewable_impressionsint
Active View: Impressions Visible at Start
event.active_view_third_quartile_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Third Quartile
event.active_view_third_quartile_viewable_impressionsint
Active View: Impressions Visible at Third Quartile
event.active_view_tos_msecint
Active View: Time on Screen (Seconds)
event.active_view_viewable_impressionsint
Whether the impression was viewable.
event.active_view_visible_time_msecint
Active View: Video Visible Time (Seconds)
event.activity_countint
Activity Quantity
event.activity_idint
The ID of the Floodlight tag related to the conversion event.
event.activity_revenuedouble
Activity Revenue
event.ad_idint
Unique ID of the ad placement.
event.advertiser_idint
Unique ID of the advertiser
event.audience_segment_idint
event.browser_platform_idstring
ID of the browser type.
event.browser_versionstring
Browser/Platform Version
event.campaign_idint
Unique ID of the campaign
event.city_idint
City ID
event.conversion_idint
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_codestring
Country
event.creative_versionstring
Creative version number.
event.dma_region_idint
Designated Market Area ID (US/Canada).
event.dv360_ad_positionint
Specifies the position of the ad on the page if known. 1 represents above the fold, 2 represents below the fold.
event.dv360_advertiser_idint
The Display & Video 360 numerical ID for the advertiser related to the event, for example 164332.
event.dv360_adx_page_categoriesstring
DV360 Adx Page Categories
event.dv360_attributed_inventory_source_external_idstring
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_publicstring
True if inventory source is available to all buyers. False otherwise.
event.dv360_auction_idstring
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_currencyint
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_currencyint
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_usdint
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_currencyint
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_currencyint
The total amount of money billed to the partner, including the media cost and partner costs, in partner currency nanos.
event.dv360_billable_cost_usdint
The total amount of money billed to the partner, including the media cost and partner costs, in USD nanos.
event.dv360_browser_idint
The Display & Video 360 numerical ID identifying the browser related to this event.
event.dv360_browser_timezone_offset_minutesint
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_idint
The unique ID of the Display & Video 360 campaign.
event.dv360_city_idint
The Display & Video 360 numerical ID identifying the best-guess city of the impression.
event.dv360_country_codestring
2-letter ISO 3166-1 country code identifying the best-guess country of the impression, for example "US".
event.dv360_cpm_fee_1_advertiser_currencyint
event.dv360_cpm_fee_1_partner_currencyint
event.dv360_cpm_fee_1_usdint
event.dv360_cpm_fee_2_advertiser_currencyint
event.dv360_cpm_fee_2_partner_currencyint
event.dv360_cpm_fee_2_usdint
event.dv360_cpm_fee_3_advertiser_currencyint
event.dv360_cpm_fee_3_partner_currencyint
event.dv360_cpm_fee_3_usdint
event.dv360_cpm_fee_4_advertiser_currencyint
event.dv360_cpm_fee_4_partner_currencyint
event.dv360_cpm_fee_4_usdint
event.dv360_cpm_fee_5_advertiser_currencyint
event.dv360_cpm_fee_5_partner_currencyint
event.dv360_cpm_fee_5_usdint
event.dv360_creative_idint
The Display & Video 360 numerical ID for the creative related to the event, for example 367487.
event.dv360_data_fees_advertiser_currencyint
event.dv360_data_fees_partner_currencyint
event.dv360_data_fees_usdint
event.dv360_device_typeint
The numerical value of the identified device type. 0 = COMPUTER, 1 = OTHER, 2 = SMARTPHONE, 3 = TABLET, 4 = SMARTTV, 5 = CONNECTEDTV.
event.dv360_exchange_idstring
The Display & Video 360 numerical ID for the exchange that requested the ad.
event.dv360_insertion_order_idint
The Display & Video 360 numerical ID for the insertion order related to the event, for example 1079941.
event.dv360_isp_idint
The Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.
event.dv360_languagestring
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_idint
The Display & Video 360 numerical ID for the line item related to the event, for example 1155785.
event.dv360_media_cost_advertiser_currencyint
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_currencyint
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_usdint
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_currencyint
event.dv360_media_fee_1_partner_currencyint
event.dv360_media_fee_1_usdint
event.dv360_media_fee_2_advertiser_currencyint
event.dv360_media_fee_2_partner_currencyint
event.dv360_media_fee_2_usdint
event.dv360_media_fee_3_advertiser_currencyint
event.dv360_media_fee_3_partner_currencyint
event.dv360_media_fee_3_usdint
event.dv360_media_fee_4_advertiser_currencyint
event.dv360_media_fee_4_partner_currencyint
event.dv360_media_fee_4_usdint
event.dv360_media_fee_5_advertiser_currencyint
event.dv360_media_fee_5_partner_currencyint
event.dv360_media_fee_5_usdint
event.dv360_mobile_make_idint
The numerical ID for the mobile make. This value may be missing.
event.dv360_mobile_model_idint
The numerical ID for the mobile model. This value may be missing.
event.dv360_net_speedint
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_idint
event.dv360_request_timeint
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_currencyint
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_currencyint
The total amount in partner currency nanos made by the partner account for the view event. This value may be zero.
event.dv360_revenue_usdint
The total amount in USD nanos made by the partner account for the view event. This value may be zero.
event.dv360_site_idint
The Display & Video 360 numerical ID for the most specific universal site that matches the url.
event.dv360_state_region_idint
DV360 Region ID
event.dv360_urlstring
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_statestring
DV360 View State
event.dv360_zip_postal_codestring
DV360 ZIP/Postal Code
event.event_sub_typestring
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_timeint
Time in microseconds since 1970-01-01 00:00:00 UTC.
event.event_typestring
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_idint
Unique ID of the floodlight configuration.
event.impression_idstring
Impression ID
event.interaction_time_utc_secondsstring
Interaction Time
event.landing_page_url_idint
Unique ID of the landing page URL.
event.operating_system_idint
ID of the operating system.
event.ord_valuestring
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_datastring
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_idint
Unique ID for the site page / placement where the ad ran.
event.platform_type_idint
event.referrer_urlstring
Contains the URL on which the ad appeared, when possible. May also be empty, or return ad server URLs.
event.rendering_idint
Unique ID of the creative for Data Transfer. Does not correspond to the UI-Creative-ID.
event.rich_media_event_countersint
MET Counter Value (the ecn= value).
event.rich_media_event_idint
MET Event ID for the Rich Media ad.
event.rich_media_event_timersdouble
Time in microseconds since 1970-01-01 00:00:00 UTC.rs
event.rich_media_event_type_idint
ID of Rich Media Event Type.
event.site_idint
Unique ID for the site where the ad ran.
event.statestring
ID for user's state or province (US/Canada)
event.tran_valuestring
TRAN Value
event.u_valuestring
U Value
event.zip_codestring
Postal-Code (US/Canada).
is_in_rdid_projectboolean
true if this event is also in the _rdid table. Used for deduplication of events.
network_idint
The network ID.
user_idstring
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..

DV360 Data Transfer activities

dv360_dt_activities
device_id_md5string
MD5-hashed device ID. Utility will be provided to hash raw device IDs to match.
eventstruct
event.active_view_audible_impressionsint
Active View: Impressions Audible
event.active_view_audible_time_msecint
Active View: Play Time Audible (Seconds)
event.active_view_audible_visible_time_msecint
Active View: Play Time Audible and Visible (Seconds)
event.active_view_background_countint
Active View: Impressions In Background
event.active_view_complete_viewable_impressionsint
Active View: Impressions Visible at Completion
event.active_view_eligible_impressionsint
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_impressionsint
Active View: Impressions Visible and Audible at First Quartile
event.active_view_first_quartile_viewable_impressionsint
Active View: Impressions Visible at First Quartile
event.active_view_fullscreen_countint
Active View: Impressions Full-Screen
event.active_view_impressions_audible_and_visible_at_completionint
Active View: Impressions Audible and Visible at Completion
event.active_view_impressions_visible10_secondsint
Active View: Impressions Visible 10 Seconds
event.active_view_measurable_impressionsint
Whether the impression was measurable with Active View.
event.active_view_midpoint_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Midpoint
event.active_view_midpoint_viewable_impressionsint
Active View: Impressions Visible at Midpoint
event.active_view_plus_measurable_countint
Active View Plus: Measurable Impressions
event.active_view_start_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Start
event.active_view_start_viewable_impressionsint
Active View: Impressions Visible at Start
event.active_view_third_quartile_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Third Quartile
event.active_view_third_quartile_viewable_impressionsint
Active View: Impressions Visible at Third Quartile
event.active_view_tos_msecint
Active View: Time on Screen (Seconds)
event.active_view_viewable_impressionsint
Whether the impression was viewable.
event.active_view_visible_time_msecint
Active View: Video Visible Time (Seconds)
event.activity_countint
Activity Quantity
event.activity_idint
The ID of the Floodlight tag related to the conversion event.
event.activity_revenuedouble
Activity Revenue
event.ad_idint
Unique ID of the ad placement.
event.advertiser_idint
Unique ID of the advertiser
event.audience_segment_idint
event.browser_platform_idstring
ID of the browser type.
event.browser_versionstring
Browser/Platform Version
event.campaign_idint
Unique ID of the campaign
event.city_idint
City ID
event.conversion_idint
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_codestring
Country
event.creative_versionstring
Creative version number.
event.dma_region_idint
Designated Market Area ID (US/Canada).
event.dv360_ad_positionint
Specifies the position of the ad on the page if known. 1 represents above the fold, 2 represents below the fold.
event.dv360_advertiser_idint
The Display & Video 360 numerical ID for the advertiser related to the event, for example 164332.
event.dv360_adx_page_categoriesstring
DV360 Adx Page Categories
event.dv360_attributed_inventory_source_external_idstring
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_publicstring
True if inventory source is available to all buyers. False otherwise.
event.dv360_auction_idstring
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_currencyint
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_currencyint
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_usdint
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_currencyint
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_currencyint
The total amount of money billed to the partner, including the media cost and partner costs, in partner currency nanos.
event.dv360_billable_cost_usdint
The total amount of money billed to the partner, including the media cost and partner costs, in USD nanos.
event.dv360_browser_idint
The Display & Video 360 numerical ID identifying the browser related to this event.
event.dv360_browser_timezone_offset_minutesint
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_idint
The unique ID of the Display & Video 360 campaign.
event.dv360_city_idint
The Display & Video 360 numerical ID identifying the best-guess city of the impression.
event.dv360_country_codestring
2-letter ISO 3166-1 country code identifying the best-guess country of the impression, for example "US".
event.dv360_cpm_fee_1_advertiser_currencyint
event.dv360_cpm_fee_1_partner_currencyint
event.dv360_cpm_fee_1_usdint
event.dv360_cpm_fee_2_advertiser_currencyint
event.dv360_cpm_fee_2_partner_currencyint
event.dv360_cpm_fee_2_usdint
event.dv360_cpm_fee_3_advertiser_currencyint
event.dv360_cpm_fee_3_partner_currencyint
event.dv360_cpm_fee_3_usdint
event.dv360_cpm_fee_4_advertiser_currencyint
event.dv360_cpm_fee_4_partner_currencyint
event.dv360_cpm_fee_4_usdint
event.dv360_cpm_fee_5_advertiser_currencyint
event.dv360_cpm_fee_5_partner_currencyint
event.dv360_cpm_fee_5_usdint
event.dv360_creative_idint
The Display & Video 360 numerical ID for the creative related to the event, for example 367487.
event.dv360_data_fees_advertiser_currencyint
event.dv360_data_fees_partner_currencyint
event.dv360_data_fees_usdint
event.dv360_device_typeint
The numerical value of the identified device type. 0 = COMPUTER, 1 = OTHER, 2 = SMARTPHONE, 3 = TABLET, 4 = SMARTTV, 5 = CONNECTEDTV.
event.dv360_exchange_idstring
The Display & Video 360 numerical ID for the exchange that requested the ad.
event.dv360_insertion_order_idint
The Display & Video 360 numerical ID for the insertion order related to the event, for example 1079941.
event.dv360_isp_idint
The Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.
event.dv360_languagestring
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_idint
The Display & Video 360 numerical ID for the line item related to the event, for example 1155785.
event.dv360_media_cost_advertiser_currencyint
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_currencyint
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_usdint
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_currencyint
event.dv360_media_fee_1_partner_currencyint
event.dv360_media_fee_1_usdint
event.dv360_media_fee_2_advertiser_currencyint
event.dv360_media_fee_2_partner_currencyint
event.dv360_media_fee_2_usdint
event.dv360_media_fee_3_advertiser_currencyint
event.dv360_media_fee_3_partner_currencyint
event.dv360_media_fee_3_usdint
event.dv360_media_fee_4_advertiser_currencyint
event.dv360_media_fee_4_partner_currencyint
event.dv360_media_fee_4_usdint
event.dv360_media_fee_5_advertiser_currencyint
event.dv360_media_fee_5_partner_currencyint
event.dv360_media_fee_5_usdint
event.dv360_mobile_make_idint
The numerical ID for the mobile make. This value may be missing.
event.dv360_mobile_model_idint
The numerical ID for the mobile model. This value may be missing.
event.dv360_net_speedint
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_idint
event.dv360_request_timeint
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_currencyint
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_currencyint
The total amount in partner currency nanos made by the partner account for the view event. This value may be zero.
event.dv360_revenue_usdint
The total amount in USD nanos made by the partner account for the view event. This value may be zero.
event.dv360_site_idint
The Display & Video 360 numerical ID for the most specific universal site that matches the url.
event.dv360_state_region_idint
DV360 Region ID
event.dv360_urlstring
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_statestring
DV360 View State
event.dv360_zip_postal_codestring
DV360 ZIP/Postal Code
event.event_sub_typestring
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_timeint
Time in microseconds since 1970-01-01 00:00:00 UTC.
event.event_typestring
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_idint
Unique ID of the floodlight configuration.
event.impression_idstring
Impression ID
event.interaction_time_utc_secondsstring
Interaction Time
event.landing_page_url_idint
Unique ID of the landing page URL.
event.operating_system_idint
ID of the operating system.
event.ord_valuestring
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_datastring
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_idint
Unique ID for the site page / placement where the ad ran.
event.platform_type_idint
event.referrer_urlstring
Contains the URL on which the ad appeared, when possible. May also be empty, or return ad server URLs.
event.rendering_idint
Unique ID of the creative for Data Transfer. Does not correspond to the UI-Creative-ID.
event.rich_media_event_countersint
MET Counter Value (the ecn= value).
event.rich_media_event_idint
MET Event ID for the Rich Media ad.
event.rich_media_event_timersdouble
Time in microseconds since 1970-01-01 00:00:00 UTC.rs
event.rich_media_event_type_idint
ID of Rich Media Event Type.
event.site_idint
Unique ID for the site where the ad ran.
event.statestring
ID for user's state or province (US/Canada)
event.tran_valuestring
TRAN Value
event.u_valuestring
U Value
event.zip_codestring
Postal-Code (US/Canada).
is_in_rdid_projectboolean
true if this event is also in the _rdid table. Used for deduplication of events.
network_idint
The network ID.
user_idstring
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..

DV360 Data Transfer advertiser

dv360_dt_advertiser
dv360_advertiserstring
Name of the advertiser.
dv360_advertiser_idint
Unique ID of the advertiser.
dv360_partner_idint
Unique ID of the partner.

DV360 Data Transfer campaign

dv360_dt_campaign
dv360_advertiser_idint
Unique ID of the advertiser.
dv360_campaignstring
Name of the campaign
dv360_campaign_idint
Unique ID of the campaign.
dv360_partner_idint
Unique ID of the partner.

DV360 Data Transfer clicks

dv360_dt_clicks
device_id_md5string
MD5-hashed device ID. Utility will be provided to hash raw device IDs to match.
eventstruct
event.active_view_audible_impressionsint
Active View: Impressions Audible
event.active_view_audible_time_msecint
Active View: Play Time Audible (Seconds)
event.active_view_audible_visible_time_msecint
Active View: Play Time Audible and Visible (Seconds)
event.active_view_background_countint
Active View: Impressions In Background
event.active_view_complete_viewable_impressionsint
Active View: Impressions Visible at Completion
event.active_view_eligible_impressionsint
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_impressionsint
Active View: Impressions Visible and Audible at First Quartile
event.active_view_first_quartile_viewable_impressionsint
Active View: Impressions Visible at First Quartile
event.active_view_fullscreen_countint
Active View: Impressions Full-Screen
event.active_view_impressions_audible_and_visible_at_completionint
Active View: Impressions Audible and Visible at Completion
event.active_view_impressions_visible10_secondsint
Active View: Impressions Visible 10 Seconds
event.active_view_measurable_impressionsint
Whether the impression was measurable with Active View.
event.active_view_midpoint_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Midpoint
event.active_view_midpoint_viewable_impressionsint
Active View: Impressions Visible at Midpoint
event.active_view_plus_measurable_countint
Active View Plus: Measurable Impressions
event.active_view_start_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Start
event.active_view_start_viewable_impressionsint
Active View: Impressions Visible at Start
event.active_view_third_quartile_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Third Quartile
event.active_view_third_quartile_viewable_impressionsint
Active View: Impressions Visible at Third Quartile
event.active_view_tos_msecint
Active View: Time on Screen (Seconds)
event.active_view_viewable_impressionsint
Whether the impression was viewable.
event.active_view_visible_time_msecint
Active View: Video Visible Time (Seconds)
event.activity_countint
Activity Quantity
event.activity_idint
The ID of the Floodlight tag related to the conversion event.
event.activity_revenuedouble
Activity Revenue
event.ad_idint
Unique ID of the ad placement.
event.advertiser_idint
Unique ID of the advertiser
event.audience_segment_idint
event.browser_platform_idstring
ID of the browser type.
event.browser_versionstring
Browser/Platform Version
event.campaign_idint
Unique ID of the campaign
event.city_idint
City ID
event.conversion_idint
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_codestring
Country
event.creative_versionstring
Creative version number.
event.dma_region_idint
Designated Market Area ID (US/Canada).
event.dv360_ad_positionint
Specifies the position of the ad on the page if known. 1 represents above the fold, 2 represents below the fold.
event.dv360_advertiser_idint
The Display & Video 360 numerical ID for the advertiser related to the event, for example 164332.
event.dv360_adx_page_categoriesstring
DV360 Adx Page Categories
event.dv360_attributed_inventory_source_external_idstring
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_publicstring
True if inventory source is available to all buyers. False otherwise.
event.dv360_auction_idstring
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_currencyint
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_currencyint
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_usdint
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_currencyint
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_currencyint
The total amount of money billed to the partner, including the media cost and partner costs, in partner currency nanos.
event.dv360_billable_cost_usdint
The total amount of money billed to the partner, including the media cost and partner costs, in USD nanos.
event.dv360_browser_idint
The Display & Video 360 numerical ID identifying the browser related to this event.
event.dv360_browser_timezone_offset_minutesint
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_idint
The unique ID of the Display & Video 360 campaign.
event.dv360_city_idint
The Display & Video 360 numerical ID identifying the best-guess city of the impression.
event.dv360_country_codestring
2-letter ISO 3166-1 country code identifying the best-guess country of the impression, for example "US".
event.dv360_cpm_fee_1_advertiser_currencyint
event.dv360_cpm_fee_1_partner_currencyint
event.dv360_cpm_fee_1_usdint
event.dv360_cpm_fee_2_advertiser_currencyint
event.dv360_cpm_fee_2_partner_currencyint
event.dv360_cpm_fee_2_usdint
event.dv360_cpm_fee_3_advertiser_currencyint
event.dv360_cpm_fee_3_partner_currencyint
event.dv360_cpm_fee_3_usdint
event.dv360_cpm_fee_4_advertiser_currencyint
event.dv360_cpm_fee_4_partner_currencyint
event.dv360_cpm_fee_4_usdint
event.dv360_cpm_fee_5_advertiser_currencyint
event.dv360_cpm_fee_5_partner_currencyint
event.dv360_cpm_fee_5_usdint
event.dv360_creative_idint
The Display & Video 360 numerical ID for the creative related to the event, for example 367487.
event.dv360_data_fees_advertiser_currencyint
event.dv360_data_fees_partner_currencyint
event.dv360_data_fees_usdint
event.dv360_device_typeint
The numerical value of the identified device type. 0 = COMPUTER, 1 = OTHER, 2 = SMARTPHONE, 3 = TABLET, 4 = SMARTTV, 5 = CONNECTEDTV.
event.dv360_exchange_idstring
The Display & Video 360 numerical ID for the exchange that requested the ad.
event.dv360_insertion_order_idint
The Display & Video 360 numerical ID for the insertion order related to the event, for example 1079941.
event.dv360_isp_idint
The Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.
event.dv360_languagestring
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_idint
The Display & Video 360 numerical ID for the line item related to the event, for example 1155785.
event.dv360_media_cost_advertiser_currencyint
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_currencyint
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_usdint
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_currencyint
event.dv360_media_fee_1_partner_currencyint
event.dv360_media_fee_1_usdint
event.dv360_media_fee_2_advertiser_currencyint
event.dv360_media_fee_2_partner_currencyint
event.dv360_media_fee_2_usdint
event.dv360_media_fee_3_advertiser_currencyint
event.dv360_media_fee_3_partner_currencyint
event.dv360_media_fee_3_usdint
event.dv360_media_fee_4_advertiser_currencyint
event.dv360_media_fee_4_partner_currencyint
event.dv360_media_fee_4_usdint
event.dv360_media_fee_5_advertiser_currencyint
event.dv360_media_fee_5_partner_currencyint
event.dv360_media_fee_5_usdint
event.dv360_mobile_make_idint
The numerical ID for the mobile make. This value may be missing.
event.dv360_mobile_model_idint
The numerical ID for the mobile model. This value may be missing.
event.dv360_net_speedint
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_idint
event.dv360_request_timeint
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_currencyint
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_currencyint
The total amount in partner currency nanos made by the partner account for the view event. This value may be zero.
event.dv360_revenue_usdint
The total amount in USD nanos made by the partner account for the view event. This value may be zero.
event.dv360_site_idint
The Display & Video 360 numerical ID for the most specific universal site that matches the url.
event.dv360_state_region_idint
DV360 Region ID
event.dv360_urlstring
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_statestring
DV360 View State
event.dv360_zip_postal_codestring
DV360 ZIP/Postal Code
event.event_sub_typestring
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_timeint
Time in microseconds since 1970-01-01 00:00:00 UTC.
event.event_typestring
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_idint
Unique ID of the floodlight configuration.
event.impression_idstring
Impression ID
event.interaction_time_utc_secondsstring
Interaction Time
event.landing_page_url_idint
Unique ID of the landing page URL.
event.operating_system_idint
ID of the operating system.
event.ord_valuestring
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_datastring
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_idint
Unique ID for the site page / placement where the ad ran.
event.platform_type_idint
event.referrer_urlstring
Contains the URL on which the ad appeared, when possible. May also be empty, or return ad server URLs.
event.rendering_idint
Unique ID of the creative for Data Transfer. Does not correspond to the UI-Creative-ID.
event.rich_media_event_countersint
MET Counter Value (the ecn= value).
event.rich_media_event_idint
MET Event ID for the Rich Media ad.
event.rich_media_event_timersdouble
Time in microseconds since 1970-01-01 00:00:00 UTC.rs
event.rich_media_event_type_idint
ID of Rich Media Event Type.
event.site_idint
Unique ID for the site where the ad ran.
event.statestring
ID for user's state or province (US/Canada)
event.tran_valuestring
TRAN Value
event.u_valuestring
U Value
event.zip_codestring
Postal-Code (US/Canada).
is_in_rdid_projectboolean
true if this event is also in the _rdid table. Used for deduplication of events.
network_idint
The network ID.
user_idstring
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..

DV360 Data Transfer impressions

dv360_dt_impressions
device_id_md5string
MD5-hashed device ID. Utility will be provided to hash raw device IDs to match.
eventstruct
event.active_view_audible_impressionsint
Active View: Impressions Audible
event.active_view_audible_time_msecint
Active View: Play Time Audible (Seconds)
event.active_view_audible_visible_time_msecint
Active View: Play Time Audible and Visible (Seconds)
event.active_view_background_countint
Active View: Impressions In Background
event.active_view_complete_viewable_impressionsint
Active View: Impressions Visible at Completion
event.active_view_eligible_impressionsint
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_impressionsint
Active View: Impressions Visible and Audible at First Quartile
event.active_view_first_quartile_viewable_impressionsint
Active View: Impressions Visible at First Quartile
event.active_view_fullscreen_countint
Active View: Impressions Full-Screen
event.active_view_impressions_audible_and_visible_at_completionint
Active View: Impressions Audible and Visible at Completion
event.active_view_impressions_visible10_secondsint
Active View: Impressions Visible 10 Seconds
event.active_view_measurable_impressionsint
Whether the impression was measurable with Active View.
event.active_view_midpoint_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Midpoint
event.active_view_midpoint_viewable_impressionsint
Active View: Impressions Visible at Midpoint
event.active_view_plus_measurable_countint
Active View Plus: Measurable Impressions
event.active_view_start_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Start
event.active_view_start_viewable_impressionsint
Active View: Impressions Visible at Start
event.active_view_third_quartile_viewable_audible_impressionsint
Active View: Impressions Visible and Audible at Third Quartile
event.active_view_third_quartile_viewable_impressionsint
Active View: Impressions Visible at Third Quartile
event.active_view_tos_msecint
Active View: Time on Screen (Seconds)
event.active_view_viewable_impressionsint
Whether the impression was viewable.
event.active_view_visible_time_msecint
Active View: Video Visible Time (Seconds)
event.activity_countint
Activity Quantity
event.activity_idint
The ID of the Floodlight tag related to the conversion event.
event.activity_revenuedouble
Activity Revenue
event.ad_idint
Unique ID of the ad placement.
event.advertiser_idint
Unique ID of the advertiser
event.audience_segment_idint
event.browser_platform_idstring
ID of the browser type.
event.browser_versionstring
Browser/Platform Version
event.campaign_idint
Unique ID of the campaign
event.city_idint
City ID
event.conversion_idint
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_codestring
Country
event.creative_versionstring
Creative version number.
event.dma_region_idint
Designated Market Area ID (US/Canada).
event.dv360_ad_positionint
Specifies the position of the ad on the page if known. 1 represents above the fold, 2 represents below the fold.
event.dv360_advertiser_idint
The Display & Video 360 numerical ID for the advertiser related to the event, for example 164332.
event.dv360_adx_page_categoriesstring
DV360 Adx Page Categories
event.dv360_attributed_inventory_source_external_idstring
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_publicstring
True if inventory source is available to all buyers. False otherwise.
event.dv360_auction_idstring
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_currencyint
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_currencyint
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_usdint
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_currencyint
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_currencyint
The total amount of money billed to the partner, including the media cost and partner costs, in partner currency nanos.
event.dv360_billable_cost_usdint
The total amount of money billed to the partner, including the media cost and partner costs, in USD nanos.
event.dv360_browser_idint
The Display & Video 360 numerical ID identifying the browser related to this event.
event.dv360_browser_timezone_offset_minutesint
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_idint
The unique ID of the Display & Video 360 campaign.
event.dv360_city_idint
The Display & Video 360 numerical ID identifying the best-guess city of the impression.
event.dv360_country_codestring
2-letter ISO 3166-1 country code identifying the best-guess country of the impression, for example "US".
event.dv360_cpm_fee_1_advertiser_currencyint
event.dv360_cpm_fee_1_partner_currencyint
event.dv360_cpm_fee_1_usdint
event.dv360_cpm_fee_2_advertiser_currencyint
event.dv360_cpm_fee_2_partner_currencyint
event.dv360_cpm_fee_2_usdint
event.dv360_cpm_fee_3_advertiser_currencyint
event.dv360_cpm_fee_3_partner_currencyint
event.dv360_cpm_fee_3_usdint
event.dv360_cpm_fee_4_advertiser_currencyint
event.dv360_cpm_fee_4_partner_currencyint
event.dv360_cpm_fee_4_usdint
event.dv360_cpm_fee_5_advertiser_currencyint
event.dv360_cpm_fee_5_partner_currencyint
event.dv360_cpm_fee_5_usdint
event.dv360_creative_idint
The Display & Video 360 numerical ID for the creative related to the event, for example 367487.
event.dv360_data_fees_advertiser_currencyint
event.dv360_data_fees_partner_currencyint
event.dv360_data_fees_usdint
event.dv360_device_typeint
The numerical value of the identified device type. 0 = COMPUTER, 1 = OTHER, 2 = SMARTPHONE, 3 = TABLET, 4 = SMARTTV, 5 = CONNECTEDTV.
event.dv360_exchange_idstring
The Display & Video 360 numerical ID for the exchange that requested the ad.
event.dv360_insertion_order_idint
The Display & Video 360 numerical ID for the insertion order related to the event, for example 1079941.
event.dv360_isp_idint
The Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.
event.dv360_languagestring
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_idint
The Display & Video 360 numerical ID for the line item related to the event, for example 1155785.
event.dv360_media_cost_advertiser_currencyint
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_currencyint
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_usdint
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_currencyint
event.dv360_media_fee_1_partner_currencyint
event.dv360_media_fee_1_usdint
event.dv360_media_fee_2_advertiser_currencyint
event.dv360_media_fee_2_partner_currencyint
event.dv360_media_fee_2_usdint
event.dv360_media_fee_3_advertiser_currencyint
event.dv360_media_fee_3_partner_currencyint
event.dv360_media_fee_3_usdint
event.dv360_media_fee_4_advertiser_currencyint
event.dv360_media_fee_4_partner_currencyint
event.dv360_media_fee_4_usdint
event.dv360_media_fee_5_advertiser_currencyint
event.dv360_media_fee_5_partner_currencyint
event.dv360_media_fee_5_usdint
event.dv360_mobile_make_idint
The numerical ID for the mobile make. This value may be missing.
event.dv360_mobile_model_idint
The numerical ID for the mobile model. This value may be missing.
event.dv360_net_speedint
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_idint
event.dv360_request_timeint
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_currencyint
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_currencyint
The total amount in partner currency nanos made by the partner account for the view event. This value may be zero.
event.dv360_revenue_usdint
The total amount in USD nanos made by the partner account for the view event. This value may be zero.
event.dv360_site_idint
The Display & Video 360 numerical ID for the most specific universal site that matches the url.
event.dv360_state_region_idint
DV360 Region ID
event.dv360_urlstring
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_statestring
DV360 View State
event.dv360_zip_postal_codestring
DV360 ZIP/Postal Code
event.event_sub_typestring
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_timeint
Time in microseconds since 1970-01-01 00:00:00 UTC.
event.event_typestring
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_idint
Unique ID of the floodlight configuration.
event.impression_idstring
Impression ID
event.interaction_time_utc_secondsstring
Interaction Time
event.landing_page_url_idint
Unique ID of the landing page URL.
event.operating_system_idint
ID of the operating system.
event.ord_valuestring
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_datastring
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_idint
Unique ID for the site page / placement where the ad ran.
event.platform_type_idint
event.referrer_urlstring
Contains the URL on which the ad appeared, when possible. May also be empty, or return ad server URLs.
event.rendering_idint
Unique ID of the creative for Data Transfer. Does not correspond to the UI-Creative-ID.
event.rich_media_event_countersint
MET Counter Value (the ecn= value).
event.rich_media_event_idint
MET Event ID for the Rich Media ad.
event.rich_media_event_timersdouble
Time in microseconds since 1970-01-01 00:00:00 UTC.rs
event.rich_media_event_type_idint
ID of Rich Media Event Type.
event.site_idint
Unique ID for the site where the ad ran.
event.statestring
ID for user's state or province (US/Canada)
event.tran_valuestring
TRAN Value
event.u_valuestring
U Value
event.zip_codestring
Postal-Code (US/Canada).
is_in_rdid_projectboolean
true if this event is also in the _rdid table. Used for deduplication of events.
network_idint
The network ID.
user_idstring
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..

DV360 Data Transfer insertion order

dv360_dt_insertion_order
dv360_advertiser_idint
Unique ID of the advertiser.
dv360_campaign_idint
Unique ID of the campaign.
dv360_insertion_orderstring
Name of the insertion order.
dv360_insertion_order_idint
Unique ID of the insertion order.
dv360_partner_idint
Unique ID of the partner.

DV360 Data Transfer line item

dv360_dt_line_item
dv360_advertiser_idint
Unique ID of the advertiser.
dv360_campaign_idint
Unique ID of the campaign.
dv360_insertion_order_idint
Unique ID of the insertion order.
dv360_line_itemstring
Name of the line item.
dv360_line_item_idint
Unique ID of the line item.
dv360_partner_idint
Unique ID of the partner.

DV360 paths

dv360_paths
dv360_paths.user_idstring
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...
dv360_paths.network_idint
The network ID.
dv360_paths.partner_idint
Unique ID of the partner.
dv360_paths.pathrecord
Row containing event path for a given user.
dv360_paths.eventsrepeated struct
dv360_paths.events.event_timeint
Time in microseconds since 1970-01-01 00:00:00 UTC.
dv360_paths.events.advertiser_idint
Unique ID of the advertiser
dv360_paths.events.campaign_idint
Unique ID of the campaign
dv360_paths.events.ad_idint
Unique ID of the ad placement.
dv360_paths.events.rendering_idint
Unique ID of the creative for Data Transfer. Does not correspond to the UI-Creative-ID.
dv360_paths.events.creative_versionstring
Creative version number.
dv360_paths.events.site_idint
Site ID
dv360_paths.events.country_codestring
2-letter ISO 3166-1 country code.
dv360_paths.events.statestring
State
dv360_paths.events.browser_platform_idstring
Browser platform ID
dv360_paths.events.browser_versionstring
Browser version
dv360_paths.events.dma_region_idint
DMA region ID
dv360_paths.events.city_idint
City ID
dv360_paths.events.zip_codestring
Postal-Code (US/Canada).
dv360_paths.events.u_valuestring
U value
dv360_paths.events.event_typestring
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.
dv360_paths.events.event_sub_typestring
Event sub type
dv360_paths.events.dv360_auction_idstring
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.
dv360_paths.events.dv360_request_timeint
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
dv360_paths.events.dv360_advertiser_idint
The Display & Video 360 numerical ID for the advertiser related to the event, for example 164332.
dv360_paths.events.dv360_insertion_order_idint
The Display & Video 360 numerical ID for the insertion order related to the event, for example 1079941.
dv360_paths.events.dv360_line_item_idint
The Display & Video 360 numerical ID for the line item related to the event, for example 1155785.
dv360_paths.events.dv360_creative_idint
The Display & Video 360 numerical ID for the creative related to the event, for example 367487.
dv360_paths.events.dv360_bid_price_usdint
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.
dv360_paths.events.dv360_bid_price_partner_currencyint
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.
dv360_paths.events.dv360_bid_price_advertiser_currencyint
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.
dv360_paths.events.dv360_urlstring
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"
dv360_paths.events.dv360_site_idint
The Display & Video 360 numerical ID for the most specific universal site that matches the url.
dv360_paths.events.dv360_languagestring
The ISO-639-1 code or "zh_CN" (Chinese (simplified)), "zh_TW" (Chinese (traditional)) or "other" representing the language related to the view event.
dv360_paths.events.dv360_adx_page_categoriesstring
Contains the Ad Exchange page category IDs separated by a space, for example "65 189". The categories may not be mutually exclusive.
dv360_paths.events.dv360_matching_targeted_keywordsstring
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.
dv360_paths.events.dv360_exchange_idstring
The Display & Video 360 numerical ID for the exchange that requested the ad.
dv360_paths.events.dv360_attributed_inventory_source_external_idstring
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.
dv360_paths.events.dv360_attributed_inventory_source_is_publicstring
True if inventory source is available to all buyers. False otherwise.
dv360_paths.events.dv360_ad_positionint
Specifies the position of the ad on the page if known. 1 represents above the fold, 2 represents below the fold.
dv360_paths.events.dv360_country_codestring
2-letter ISO 3166-1 country code identifying the best-guess country of the impression, for example "US".
dv360_paths.events.dv360_zip_postal_codestring
The postal code identifying the best-guess postal area of the impression if known, for example "98033". Do not assume uniqueness across different countries.
dv360_paths.events.dv360_browser_timezone_offset_minutesint
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.
dv360_paths.events.dv360_net_speedint
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.
dv360_paths.events.dv360_matching_targeted_segmentsstring
The names of targeted user lists that match the visitor separated by a space, 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.
dv360_paths.events.dv360_isp_idint
The Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.
dv360_paths.events.dv360_device_typeint
The numerical value of the identified device type. 0 = COMPUTER, 1 = OTHER, 2 = SMARTPHONE, 3 = TABLET, 4 = SMARTTV, 5 = CONNECTEDTV.
dv360_paths.events.dv360_mobile_model_idint
The numerical ID for the mobile model. This value may be missing.
dv360_paths.events.placement_idint
Unique ID for the site page / placement where the ad ran.
dv360_paths.events.operating_system_idint
ID of the operating system.
dv360_paths.events.segment_value_1int
Segment value 1
dv360_paths.events.dv360_state_region_idint
An integer matching the state/region integer available in reporting and targeting.
dv360_paths.events.dv360_city_idint
The Display & Video 360 numerical ID identifying the best-guess city of the impression.
dv360_paths.events.dv360_browser_idint
DV360 browser ID
dv360_paths.events.activity_idint
The ID of the Floodlight tag related to the conversion event.
dv360_paths.events.ord_valuestring
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)
dv360_paths.events.conversion_idint
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).
dv360_paths.events.floodlight_config_idint
Unique ID of the floodlight configuration. ID
dv360_paths.events.interaction_time_utc_secondsstring
The activity’s associated (aka "matched") click or impression time in microseconds since 1970-01-01 00:00:00 UTC.
dv360_paths.events.rich_media_event_idint
MET Event ID for the Rich Media ad.
dv360_paths.events.rich_media_event_type_idint
ID of Rich Media Event Type.
dv360_paths.events.impression_idstring
Impression ID
dv360_paths.events.other_datastring
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")
dv360_paths.events.referrer_urlstring
Contains the URL on which the ad appeared, when possible. May also be empty, or return ad server URLs.
dv360_paths.events.tran_valuestring
Tran value
dv360_paths.events.dv360_view_statestring
DV360 view state
dv360_paths.events.landing_page_url_idint
Landing page url ID
dv360_paths.events.audience_segment_idint
Audience segment ID
dv360_paths.events.dv360_media_cost_usdint
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.
dv360_paths.events.dv360_media_cost_partner_currencyint
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.
dv360_paths.events.dv360_media_cost_advertiser_currencyint
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.
dv360_paths.events.dv360_revenue_usdint
DV360 revenue usd
dv360_paths.events.dv360_revenue_partner_currencyint
DV360 revenue partner currency
dv360_paths.events.dv360_revenue_advertiser_currencyint
DV360 revenue advertiser currency
dv360_paths.events.dv360_cpm_fee_1_usdint
The CPM 1 fee in USD nanos. This value may be zero.
dv360_paths.events.dv360_cpm_fee_1_partner_currencyint
The CPM 1 fee in partner currency nanos. This value may be zero.
dv360_paths.events.dv360_cpm_fee_1_advertiser_currencyint
The CPM 1 fee in advertiser currency nanos. This value may be zero.
dv360_paths.events.dv360_cpm_fee_2_usdint
The CPM 2 fee in USD nanos. This value may be zero.
dv360_paths.events.dv360_cpm_fee_2_partner_currencyint
The CPM 2 fee in partner currency nanos. This value may be zero.
dv360_paths.events.dv360_cpm_fee_2_advertiser_currencyint
The CPM 2 fee in advertiser currency nanos. This value may be zero.
dv360_paths.events.dv360_cpm_fee_3_usdint
The CPM 3 fee in USD nanos. This value may be zero.
dv360_paths.events.dv360_cpm_fee_3_partner_currencyint
The CPM 3 fee in partner currency nanos. This value may be zero.
dv360_paths.events.dv360_cpm_fee_3_advertiser_currencyint
The CPM 3 fee in advertiser currency nanos. This value may be zero.
dv360_paths.events.dv360_cpm_fee_4_usdint
The CPM 4 fee in USD nanos. This value may be zero.
dv360_paths.events.dv360_cpm_fee_4_partner_currencyint
The CPM 4 fee in partner currency nanos. This value may be zero.
dv360_paths.events.dv360_cpm_fee_4_advertiser_currencyint
The CPM 4 fee in advertiser currency nanos. This value may be zero.
dv360_paths.events.dv360_cpm_fee_5_usdint
The CPM 5 fee in USD nanos. This value may be zero.
dv360_paths.events.dv360_cpm_fee_5_partner_currencyint
The CPM 5 fee in partner currency nanos. This value may be zero.
dv360_paths.events.dv360_cpm_fee_5_advertiser_currencyint
The CPM 5 fee in advertiser currency nanos. This value may be zero.
dv360_paths.events.dv360_media_fee_1_usdint
The Media Fee 1 fee in USD nanos. This value may be zero.
dv360_paths.events.dv360_media_fee_1_partner_currencyint
The Media Fee 1 fee in partner currency nanos. This value may be zero.
dv360_paths.events.dv360_media_fee_1_advertiser_currencyint
The Media Fee 1 fee in advertiser currency nanos. This value may be zero.
dv360_paths.events.dv360_media_fee_2_usdint
The Media Fee 2 fee in USD nanos. This value may be zero.
dv360_paths.events.dv360_media_fee_2_partner_currencyint
The Media Fee 2 fee in partner currency nanos. This value may be zero.
dv360_paths.events.dv360_media_fee_2_advertiser_currencyint
The Media Fee 2 fee in advertiser currency nanos. This value may be zero.
dv360_paths.events.dv360_media_fee_3_usdint
The Media Fee 3 fee in USD nanos. This value may be zero.
dv360_paths.events.dv360_media_fee_3_partner_currencyint
The Media Fee 3 fee in partner currency nanos. This value may be zero.
dv360_paths.events.dv360_media_fee_3_advertiser_currencyint
The Media Fee 3 fee in advertiser currency nanos. This value may be zero.
dv360_paths.events.dv360_media_fee_4_usdint
The Media Fee 4 fee in USD nanos. This value may be zero.
dv360_paths.events.dv360_media_fee_4_partner_currencyint
The Media Fee 4 fee in partner currency nanos. This value may be zero.
dv360_paths.events.dv360_media_fee_4_advertiser_currencyint
The Media Fee 4 fee in advertiser currency nanos. This value may be zero.
dv360_paths.events.dv360_media_fee_5_usdint
The Media Fee 5 fee in USD nanos. This value may be zero.
dv360_paths.events.dv360_media_fee_5_partner_currencyint
The Media Fee 5 fee in partner currency nanos. This value may be zero.
dv360_paths.events.dv360_media_fee_5_advertiser_currencyint
The Media Fee 5 fee in advertiser currency nanos. This value may be zero.
dv360_paths.events.dv360_data_fees_usdint
The cost of any data that was used to target this impression, in USD nanos
dv360_paths.events.dv360_data_fees_partner_currencyint
The cost of any data that was used to target this impression, in partner currency nanos.
dv360_paths.events.dv360_data_fees_advertiser_currencyint
The cost of any data that was used to target this impression, in advertiser currency nanos.
dv360_paths.events.activity_countint
Activity count
dv360_paths.events.activity_revenuedouble
Activity revenue
dv360_paths.events.active_view_eligible_impressionsint
Active View eligible impressions
dv360_paths.events.active_view_viewable_impressionsint
Active View viewable impressions
dv360_paths.events.dv360_billable_cost_usdint
The total amount of money billed to the partner, including the media cost and partner costs, in USD nanos.
dv360_paths.events.dv360_billable_cost_partner_currencyint
The total amount of money billed to the partner, including the media cost and partner costs, in partner currency nanos.
dv360_paths.events.dv360_billable_cost_advertiser_currencyint
The total amount of money billed to the partner, including the media cost and partner costs, in advertiser currency nanos.
dv360_paths.events.active_view_measurable_impressionsint
Active View measurable impressions
dv360_paths.events.rich_media_event_countersint
Rich media event counters
dv360_paths.events.rich_media_event_timersdouble
Rich media event timers
dv360_paths.floodlight_config_idint
Unique ID of the floodlight configuration. ID

DV360 YouTube Active View

dv360_youtube_active_views
num_active_view_viewable_impressionint
1 when impression is active view eligible; 0 when impression is not active view eligible.
query_idstruct
Unique identifier for query has multiple parts. Joins with query_id in any adh.dv360_youtube table.
query_id.process_idint
The processing ID.
query_id.server_ipint
The processing server.
query_id.time_usecint
The query time in microseconds.
view_idstruct
Unique identifier for view_id has multiple parts.
view_id.process_idint
Time in microseconds.
view_id.server_ipint
The processing server.
view_id.time_usecint
The processing process.
partner_idint
Unique ID of the partner.
advertiser_idint
Unique ID of the advertiser.
campaign_idint
Unique ID of the campaign.
insertion_order_idint
Unique ID of the insertion order.
lineitem_idint
Unique ID of the line item.
adgroup_idint
ID of DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table.
creative_idint
Joins with creative_id in any adh.dv360_youtube table.

DV360 YouTube ad group

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

DV360 YouTube advertiser

dv360_youtube_advertiser
advertiser_namestring
Name of the advertiser.
advertiser_idint
Unique ID of the advertiser.
partner_idint
Unique ID of the partner.

DV360 YouTube campaign

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

DV360 YouTube clicks

dv360_youtube_clicks
advertiser_click_cost_local_microsdouble
The advertiser's cost in local currency micros.
advertiser_click_cost_usddouble
The advertiser's click cost in dollars.
click_idstruct
Unique identifier for click has multiple parts. Joins with click_id in any adh.dv360_youtube table.
click_id.process_idint
The processing process.
click_id.server_ipint
The processing server.
click_id.time_usecint
Time in microseconds.
click_typeint
The click type.
is_in_rdid_projectboolean
true if this event is also in the _rdid table. Used for deduplication of events.
query_idstruct
Unique identifier for query has multiple parts. Joins with query_id in any adh.dv360_youtube table.
query_id.process_idint
The processing process.
query_id.server_ipint
The processing server.
query_id.time_usecint
Time in microseconds.
user_idstring
User ID
partner_idint
Unique ID of the partner.
advertiser_idint
Unique ID of the advertiser.
campaign_idint
Unique ID of the campaign.
insertion_order_idint
Unique ID of the insertion order.
lineitem_idint
Unique ID of the line item.
adgroup_idint
ID of DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table.
creative_idint
Joins with creative_id in any adh.dv360_youtube table.

DV360 YouTube conversions

dv360_youtube_conversions
click_idstruct
Unique identifier for click has multiple parts. Joins with click_id in any adh.dv360_youtube table.
click_id.process_idint
The processing process.
click_id.server_ipint
The processing server.
click_id.time_usecint
Time in microseconds.
conversion_idstruct
Unique identifier for conversion has multiple parts.
conversion_id.process_idint
The processing process.
conversion_id.server_ipint
The processing server.
conversion_id.time_usecint
Time in microseconds.
conversion_typeint
The type of conversion.
is_in_rdid_projectboolean
true if this event is also in the _rdid table. Used for deduplication of events.
labelstring
Name of conversion event.
query_idstruct
Unique identifier for query has multiple parts. Joins with query_id in any adh.dv360_youtube table.
query_id.process_idint
The processing process.
query_id.server_ipint
The processing server.
query_id.time_usecint
Time in microseconds.
user_idstring
User ID
partner_idint
Unique ID of the partner.
impression_data.partner_idint
Unique ID of the partner.
impression_data.advertiser_idint
Unique ID of the advertiser.
impression_data.campaign_idint
Unique ID of the campaign.
impression_data.insertion_order_idint
Unique ID of the insertion order.
impression_data.lineitem_idint
Unique ID of the line item.
impression_data.adgroup_idint
ID of DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table.
impression_data.creative_idint
Joins with creative_id in any adh.dv360_youtube table.

DV360 YouTube creative

dv360_youtube_creative
partner_idint
Unique ID of the partner.
advertiser_idint
Unique ID of the advertiser.
campaign_idint
Unique ID of the campaign.
insertion_order_idint
Unique ID of the insertion order.
lineitem_idint
Unique ID of the line item.
adgroup_idint
ID of DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table.
creative_idint
Joins with creative_id in any adh.dv360_youtube table.
creative_namestring
Creative name.
creative_typeint
Creative type.
video_messagestruct
Multipart identifier for video data.
video_message.video_ad_durationint
Duration of the video in milliseconds.
video_message.youtube_video_idstring
Video id string representation as it appears on YouTube watch url.

DV360 YouTube impressions

dv360_youtube_impressions
active_view_dataint
Whether the impression was enabled for active view measurement.
advertiser_impression_cost_local_microsdouble
The advertiser's local currency in micros.
advertiser_impression_cost_usddouble
The advertiser's impression cost in dollars.
campaign_idint
Unique ID of the campaign.
content_urlstring
URL of the page on which ad appeared. Part of the url is removed for privacy.
demographicsstruct
demographics.age_groupint
Code for age group. Joins with age_group_id in adh.age_group table.
demographics.genderint
Code for gender. Joins with gender_id in adh.gender table.
device_heightint
Device height in px.
device_widthint
Device width in px.
in_marketarray
ID of in-market group. Joins with in_market_id in adh.in_market table. Does not support TrueView line items.
inventory_typeenum
The inventory type. Possible values: YOUTUBE, YOUTUBE TV, SEARCH, GMAIL, OTHER. Other refers to either the Google Display or Video network.
is_in_rdid_projectboolean
true if this event is also in the _rdid table. Used for deduplication of events.
locationstruct
Unique identifier for location has multiple parts
location.countrystring
location.geo_city_idint
Code for city. Joins with city_id in adh.city table.
location.geo_metroint
Code for metro region. Joins with metro_id in adh.metro table.
location.geo_regionstring
Region as string e.g. US-CA.
mobile_browser_classint
Type of browser. Possible values are: desktop, tablet, smart tv consoles, or mobile. Joins with mobile_browser_class_id in adh.mobile_browser_cltable.
num_active_view_eligible_impressionint
1 when impression is active view eligible; 0 when impression is not active view eligible.
num_active_view_measurable_impressionint
1 when impression is active view measurable; 0 when impression is not active view measurable.
operating_system_version_idsarray
ID of OS. Joins with operating_system_version_id in adh.os_version table.
physical_screen_heightint
Device screen height in mm.
physical_screen_widthint
Device screen width in mm.
publisher_domainstring
Domain of the page on which ad appeared.
query_idstruct
Unique identifier for query has multiple parts. Joins with query_id in any adh.dv360_youtube table.
query_id.process_idint
The processing ID.
query_id.server_ipint
The processing server.
query_id.time_usecint
The query time in microseconds.
query_languagestring
Language used by user.
user_idstring
User ID
is_app_trafficboolean
true if the event happened in a native app.
partner_idint
Unique ID of the partner.
advertiser_idint
Unique ID of the advertiser.
insertion_order_idint
Unique ID of the insertion order.
lineitem_idint
Unique ID of the line item.
adgroup_idint
ID of DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table.
creative_idint
Joins with creative_id in any adh.dv360_youtube table.

DV360 YouTube insertion order

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

DV360 YouTube line item

dv360_youtube_lineitem
advertiser_idint
Unique ID of the advertiser.
campaign_idint
Unique ID of the campaign.
insertion_order_idint
Unique ID of the insertion order.
line_item_namestring
Name of the line item.
line_item_idint
Unique ID of the line item.
partner_idint
Unique ID of the partner.
line_item_reservation_typeenum
The type of the reservation. Can be either "PROGRAMMATIC", "INSTANTRESERVE" or "NONE" (meaning standard auction).

Gender

gender
gender_idint
Gender identifier.
gender_namestring
Gender name. Possible values are: "male", "female", or "unknown".

Google Ads Active Views

google_ads_active_views
num_active_view_viewable_impressionint
1 when impression is active view eligible; 0 when impression is not active view eligible.
query_idstruct
Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
query_id.process_idint
The processing ID.
query_id.server_ipint
The processing server.
query_id.time_usecint
The query time in microseconds.
view_idstruct
Unique identifier for view_id has multiple parts.
view_id.process_idint
Time in microseconds.
view_id.server_ipint
The processing server.
view_id.time_usecint
The processing process.
impression_data.customer_idint
ID of Google Ads customer. Joins with customer_id in any adh.google_ads table.
impression_data.campaign_idint
Unique ID of the campaign.
impression_data.adgroup_idint
ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table.
impression_data.ad_group_creative_idint
ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table.

Google Ads ad group

google_ads_adgroup
adgroup_idint
ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table.
adgroup_namestring
Ad group name.
adgroup_statusstring
The ad group. Possible values are: "status", "paused", or "enabled".
adgroup_typestring
The ad group type. Possible values are: VIDEO_TRUE_VIEW_IN_STREAM, VIDEO_TRUE_VIEW_IN_DISPLAY, VIDEO_BUMPER_IN_STREAM, VIDEO_NON_SKIPPABLE_IN_STREAM, DISPLAY, SEARCH, or OTHER.
campaign_idint
Unique ID of the campaign.
customer_idint
Joins with customer_id in any adh.google_ads table.
label_idsarray
Joins with label_id in the adh.google_ads_label table.

Google Ads ad group creative

google_ads_adgroup_creative
customer_idINT64
Joins with customer_id in any adh.google_ads table.
ad_group_creative_idINT64
ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table.
creative_idINT64
A unique identifier for the creative, specific to the ad group containing it. Joins with creative_id in any adh.google_ads table.
adgroup_idINT64
ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table.
adgroup_creative_statusSTRING
The status of the creative within the ad group.
label_idsINT64
Joins with label_id in adh.google_ads tables that contain label_ids.

Google Ads campaign

google_ads_campaign
advertising_channel_typestring
Advertising channel type. Possible values are: SEARCH, DISPLAY, VIDEO, or OTHER.
campaign_idint
Unique ID of the campaign.
campaign_namestring
Campaign name.
campaign_statusint
Campaign status. 3 = ACTIVE. 5 = PAUSED. 7 = DELETED.
customer_idint
Joins with customer_id in any adh.google_ads table.
end_timeint
Timestamp when the campaign ends in milliseconds.
label_idsarray
Joins with label_id in the adh.google_ads_label table.
reservation_typeenum
The type of the reservation. Can be either "INSTANTRESERVE" or "NONE" (meaning standard auction).
start_timeint
Timestamp when the campaign begins in milliseconds.

Google Ads clicks

google_ads_clicks
advertiser_click_cost_local_microsdouble
The advertiser's cost in local currency micros.
advertiser_click_cost_usddouble
The advertiser's click cost in dollars.
click_idstruct
Unique identifier for click has multiple parts. Joins with click_id in any adh.google_ads table.
click_id.process_idint
The processing process.
click_id.server_ipint
The processing server.
click_id.time_usecint
Time in microseconds.
click_typeint
The click type.
is_in_rdid_projectboolean
true if this event is also in the _rdid table. Used for deduplication of events.
query_idstruct
Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
query_id.process_idint
The processing process.
query_id.server_ipint
The processing server.
query_id.time_usecint
Time in microseconds.
user_idstring
User ID
impression_data.customer_idint
ID of Google Ads customer. Joins with customer_id in any adh.google_ads table.
impression_data.campaign_idint
Unique ID of the campaign.
impression_data.adgroup_idint
ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table.
impression_data.ad_group_creative_idint
ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table.

Google Ads clicks audience

google_ads_clicks_audience
advertiser_click_cost_local_microsdouble
The advertiser's cost in local currency micros.
advertiser_click_cost_usddouble
The advertiser's click cost in dollars.
click_idstruct
Unique identifier for click has multiple parts. Joins with click_id in any adh.google_ads table.
click_id.process_idint
The processing process.
click_id.server_ipint
The processing server.
click_id.time_usecint
Time in microseconds.
click_typeint
The click type.
is_in_rdid_projectboolean
true if this event is also in the _rdid table. Used for deduplication of events.
query_idstruct
Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
query_id.process_idint
The processing process.
query_id.server_ipint
The processing server.
query_id.time_usecint
Time in microseconds.
user_idstring
User ID

Google Ads conversions

google_ads_conversions
click_idstruct
Unique identifier for click has multiple parts. Joins with click_id in any adh.google_ads table.
click_id.process_idint
The processing process.
click_id.server_ipint
The processing server.
click_id.time_usecint
Time in microseconds.
conversion_idstruct
Unique identifier for conversion has multiple parts.
conversion_id.process_idint
The processing process.
conversion_id.server_ipint
The processing server.
conversion_id.time_usecint
Time in microseconds.
conversion_typeint
The type of conversion.
is_in_rdid_projectboolean
true if this event is also in the _rdid table. Used for deduplication of events.
labelstring
Name of conversion event.
query_idstruct
Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
query_id.process_idint
The processing process.
query_id.server_ipint
The processing server.
query_id.time_usecint
Time in microseconds.
user_idstring
User ID
impression_data.customer_idint
ID of Google Ads customer. Joins with customer_id in any adh.google_ads table.
impression_data.campaign_idint
Unique ID of the campaign.
impression_data.adgroup_idint
ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table.
impression_data.ad_group_creative_idint
ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table.

Google Ads conversions audience

google_ads_conversions_audience
click_idstruct
Unique identifier for click has multiple parts. Joins with click_id in any adh.google_ads table.
click_id.process_idint
The processing process.
click_id.server_ipint
The processing server.
click_id.time_usecint
Time in microseconds.
conversion_idstruct
Unique identifier for conversion has multiple parts.
conversion_id.process_idint
The processing process.
conversion_id.server_ipint
The processing server.
conversion_id.time_usecint
Time in microseconds.
conversion_typeint
The type of conversion.
is_in_rdid_projectboolean
true if this event is also in the _rdid table. Used for deduplication of events.
labelstring
Name of conversion event.
query_idstruct
Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
query_id.process_idint
The processing process.
query_id.server_ipint
The processing server.
query_id.time_usecint
Time in microseconds.
user_idstring
User ID

Google Ads creative

google_ads_creative
beacon_urlarray
Multipart identifier for third-party ad trafficked by Campaign Manager.
creative_idint
Joins with creative_id in any adh.google_ads table.
creative_namestring
Creative name.
creative_typeint
Creative type.
customer_idint
Joins with customer_id in any adh.google_ads table.
snippet_urlstruct
Multipart identifier for third-party ad served by Campaign Manager
snippet_url.advertiser_idint
ID for Campaign Manager advertiser of ad being served.
snippet_url.campaign_idint
Joins with campaign_id in any adh.google_ads table.
snippet_url.content_url_datastruct
Multipart record for content URL.
snippet_url.content_url_data.indexint
Index of content URL.
snippet_url.content_url_data.url_typestring
The type of URL.
snippet_url.networkint
ID for Campaign Manager network of ad being served.
snippet_url.placement_idint
Unique ID for Campaign Manager placement of ad being served.
snippet_url.placement_keystring
Full string identifying Campaign Manager placement of ad being served.
snippet_url.site_idint
ID for Campaign Manager site of ad being served.
template_idint
Template ID of the creative.
video_messagestruct
Multipart identifier for video data.
video_message.video_ad_durationint
Duration of the video in milliseconds.
video_message.youtube_video_idstring
Video id string representation as it appears on YouTube watch url.

Google Ads creative vendor metadata

google_ads_creative_vendor_metadata
creative_idint
The Creative ID in Campaign Manager UI.
legacy_pixelstring
vendor_stringstring

Google Ads customer

google_ads_customer
customer_company_namestring
Company name.
customer_idint
Joins with customer_id in any adh.google_ads table.
customer_namestring
Customer name.
external_customer_idint
Joins with customer_id in any adh.google_ads table.
mcc_idsarray
My Client Center Ids in Google Ads that this ADH customer is associated with.

Google Ads impressions

google_ads_impressions
active_view_dataint
Whether the impression was enabled for active view measurement.
ad_group_creative_idint
ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table.
adgroup_idint
ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table.
advertiser_impression_cost_local_microsdouble
The advertiser's local currency in micros.
advertiser_impression_cost_usddouble
The advertiser's impression cost in dollars.
affinityarray
ID of affinity group. Joins with affinity_id in adh.affinity table. Does not support TrueView line items.
campaign_idint
Unique ID of the campaign.
content_urlstring
URL of the page on which ad appeared. Part of the url is removed for privacy.
customer_idint
ID of Google Ads customer.Joins with customer_id in any adh.google_ads table.
demographics.age_groupint
Code for age group. Joins with age_group_id in adh.age_group table.
demographics.genderint
Code for gender. Joins with gender_id in adh.gender table.
device_heightint
Device height in px.
device_widthint
Device width in px.
in_marketarray
ID of in-market group. Joins with in_market_id in adh.in_market table. Does not support TrueView line items.
inventory_typeenum
The inventory type. Possible values: YOUTUBE, YOUTUBE TV, SEARCH, GMAIL, OTHER. Other refers to either the Google Display or Video network.
is_in_rdid_projectboolean
true if this event is also in the _rdid table. Used for deduplication of events.
locationstruct
Unique identifier for location has multiple parts
location.countrystring
location.geo_city_idint
Code for city. Joins with city_id in adh.city table.
location.geo_metroint
Code for metro region. Joins with metro_id in adh.metro table.
location.geo_regionstring
Region as string e.g. US-CA.
mobile_browser_classint
Type of device. Possible values are: desktop, tablet, smart tv consoles, or mobile. Joins with mobile_browser_class_id in adh.mobile_browser_cltable.
num_active_view_eligible_impressionint
1 when impression is active view eligible; 0 when impression is not active view eligible.
num_active_view_measurable_impressionint
1 when impression is active view measurable; 0 when impression is not active view measurable.
operating_system_version_idsarray
ID of OS. Joins with operating_system_version_id in adh.os_version table.
physical_screen_heightint
Device screen height in mm.
physical_screen_widthint
Device screen width in mm.
publisher_domainstring
Domain of the page on which ad appeared.
query_idstruct
Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
query_id.process_idint
The processing ID.
query_id.server_ipint
The processing server.
query_id.time_usecint
The query time in microseconds.
query_languagestring
Language used by user.
user_idstring
User ID
is_app_trafficboolean
true if the event happened in a native app. FALSE if the event happened in HTML5 app or webview.

Google Ads label

google_ads_label
customer_idint
Joins with customer_id in any adh.google_ads table.
descriptionstring
Label description.
label_idint
Joins with label_id in adh.google_ads tables that contain label_ids.
label_namestring
Label name.
statusint
Label status. 1 = ENABLED. 2 = DELETED.

In-market segment

in_market
in_market_categorystring
The category of market vertical.
in_market_idint
In-market identifier.
in_market_namestring
A more specific in-market name based on category.

Metro

metro
country_codestring
Two character country code.
metro_abbrevstring
Abbreviated version of metro name.
metro_codestring
The metropolitan area code.
metro_idint
Metro identifier.
metro_namestring
Metro name.

Mobile browser class

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

Operating system

operating_system
mobileboolean
True if the operating system is mobile.
operating_system_idint
Operating system identifier.
operating_system_namestring
Operating system name.

Operating system version

os_version
major_versionint
The major version number of the operating system.
minor_versionint
The minor version of the operating system.
operating_system_idint
Unique ID of OS just for Data Transfer.
operating_system_version_idint
Operating system version identifier.
operator_typestring
Possible values are OPERATOR_TYPE_EQUAL_TO, or OPERATOR_TYPE_GREATER_THAN_EQUAL_TO.
platform_namestring
The platform name in English.

Region

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

YouTube Reserve Active Views

yt_reserve_active_views
num_active_view_viewable_impressionint
1 when impression is active view viewable; 0 when impression is not active view viewable.
query_idstruct
Unique identifier for query has multiple parts.
query_id.process_idint
The processing process.
query_id.server_ipint
The processing server.
query_id.time_usecint
Time in microseconds.
view_idstruct
Unique identifier for view has multiple parts.
view_id.process_idint
The processing process.
view_id.server_ipint
The processing server.
view_id.time_usecint
Time in microseconds.
impression_data.order_idint
impression_data.line_item_idint
Line item id for this impression.
impression_data.creative_idint
The ID of the creative.
impression_data.media_plan_idint
ID of the YouTube Reserve media plan.

YouTube Reserve clicks

yt_reserve_clicks
click_idstruct
Unique identifier for click has multiple parts.
click_id.process_idint
The processing process.
click_id.server_ipint
The processing server.
click_id.time_usecint
Time in microseconds.
click_typeint
The click type.
is_in_rdid_projectboolean
true if this event is also in the _rdid table. Used for deduplication of events.
query_idstruct
Unique identifier for query has multiple parts.
query_id.process_idint
The processing process.
query_id.server_ipint
The processing server.
query_id.time_usecint
Time in microseconds.
user_idstring
User ID
impression_data.order_idint
impression_data.line_item_idint
Line item id for this impression.
impression_data.creative_idint
The ID of the creative.
impression_data.media_plan_idint
ID of the YouTube Reserve media plan.

YouTube Reserve conversions

yt_reserve_conversions
click_idstruct
Unique identifier for click has multiple parts.
click_id.process_idint
The processing process.
click_id.server_ipint
The processing server.
click_id.time_usecint
Time in microseconds.
conversion_idstruct
Unique identifier for conversion has multiple parts.
conversion_id.process_idint
The processing process.
conversion_id.server_ipint
The processing server.
conversion_id.time_usecint
Time in microseconds.
conversion_typeint
The type of conversion.
is_in_rdid_projectboolean
true if this event is also in the _rdid table. Used for deduplication of events.True if this event is also in the _rdid tabUsed for deduplication of events.
labelstring
Name of conversion event.
query_idstruct
Unique identifier for query has multiple parts.
query_id.process_idint
The processing process.
query_id.server_ipint
The processing server.
query_id.time_usecint
Time in microseconds.
user_idstring
User ID
impression_data.order_idint
impression_data.line_item_idint
Line item id for this impression.
impression_data.creative_idint
The ID of the creative.
impression_data.media_plan_idint
ID of the YouTube Reserve media plan.

YouTube Reserve creative

yt_reserve_creative
creative_format_typestring
Some formats map directly to a type. Other types have multiple formats like: html, image, or video.
creative_idint
The ID of the creative.
creative_namestring
Name of the creative.
creative_typestring
The type of creative.
dcm_beaconsarray
Multipart identifier for Campaign Manager tracking pixel for ad.
is_mastheadboolean
True if this is a masthead creative.
third_party_vast_urlstring
VAST url of the creative if the creative is a third party hosted video. Does not support creatives from programmatic items.
video_messagestruct
Multipart identifier for video data.
video_message.video_ad_durationint
Duration of the video in milliseconds.
video_message.youtube_channel_idstring
Id of the channel that provides this video.
video_message.youtube_video_idstring
Video id string representation as it appears on YouTube watch url.

YouTube Reserve impressions

yt_reserve_impressions
active_view_dataint
Whether the impression was enabled for active view measurement.
content_urlstring
URL of the page on which ad appeared. Part of the url is removed for privacy.
creative_idint
The ID of the creative.
demographicsstruct
Unique identifier for demographics has multiple parts
demographics.age_groupint
Code for age group. Joins with age_group_id in adh.age_group table.
demographics.genderint
Code for gender. Joins with gender_id in adh.gender table.
device_heightint
Device height in px.
device_widthint
Device width in px.
inventory_typeenum
The inventory type. Possible values: YOUTUBE, YOUTUBE TV, SEARCH, GMAIL, OTHER. Other refers to either the Google Display or Video network.
is_in_rdid_projectboolean
true if this event is also in the _rdid table. Used for deduplication of events.
line_item_idint
Line item id for this impression.
locationstruct
Unique identifier for location has multiple parts.
location.countrystring
location.geo_city_idint
Code for city. Joins with city_id in adh.city table.
location.geo_metroint
Code for metro region. Joins with metro_id in adh.metro table.
location.geo_regionstring
Region as string, e.g. US-CA.
mobile_browser_classint
Type of device. Possible values are: desktop, tablet, smart tv consoles, or mobile. Joins with mobile_browser_class_id in adh.mobile_browser_class table.
num_active_view_eligible_impressionint
when impression is active view eligible; 0 when impression is not active view eligible.
num_active_view_measurable_impressionint
1 when impression is active view measurable; 0 when impression is not active view measurable.
operating_system_version_idsarray
ID of OS. Joins with operating_system_version_id in adh.os_version table.
order_idint
physical_screen_heightint
Device screen height in mm.
physical_screen_widthint
Device screen width in mm.
publisher_domainstring
Domain of page on which ad appeared.
query_idstruct
Unique identifier for query has multiple parts.
query_id.process_idint
The processing process.
query_id.server_ipint
The processing server.
query_id.time_usecint
Time in microseconds.
query_languagestring
Language used by user.
user_idstring
User ID
is_app_trafficboolean
true if the event happened in a native app. FALSE if the event happened in HTML5 app or webview.
media_plan_idint
ID of the YouTube Reserve media plan.

YouTube Reserve line item

yt_reserve_lineitem
cost_per_unitint
Cost per unit served in micros
cost_typestring
Cost per click, conversion, impression, and Active View.
creative_idarray
Array of creative ids for this line item. Joins with creative_id in any adh.yt table.
end_timetimestamp
Time the line item stopped being served.
line_item_idint
Ad Manager line item serving.
line_item_namestring
Ad Manager line item name.
order_idint
Ad Manager Order identifier used for serving.
order_namestring
Name of the insertion order.
programmaticboolean
true if the line item was programmatic.
skippable_ad_typestring
Possible values are: "skippable", "not skippable", or "selectable".
start_timetimestamp
Time the line item started to be served.
value_cost_per_unitint
The value cost per unit of the line item.

YouTube Reserve order

yt_reserve_order
order_idint
Ad Manager Order identifier used for serving.
order_namestring
Name of Ad Manager order
advertiser_idint
Unique ID of the advertiser.
advertiser_namestring
User entered name of the advertiser.
media_plan_idint
ID of the YouTube Reserve media plan.
media_plan_namestring
Name of the YouTube Reserve media plan.