Ads Data Hub table schema - Marketers

Affinity segment

affinity

affinity_category

string
Affinity category.

affinity_id

int64
Affinity identifier.

affinity_name

string
Affinity name.

Age group

age_group

age_group_id

int64
Age group identifier.

age_group_name

string
Age group name.

Browser

browser

browser_id

int64
Browser identifier.

browser_name

string
Browser name.

major_version

string
Major version of the browser (whole number version).

minor_version

string
Minor version of the browser (incremental or decimal version).

City

city

city_id

int64
Unique ID of the city.

city_name

string
City name.

country_code

string
Two character country code.

Campaign Manager 360 Data Transfer account info

cm_dt_account_info

account_id

int64
Unique ID of the account.

timezone_name

string
Timezone of the account.

Campaign Manager 360 Data Transfer Active View plus

cm_dt_active_view_plus

To query EEA user data, use the policy-isolated tables in place of cm_dt_active_view_plus :

cm_dt_active_view_plus_policy_isolated_youtube
cm_dt_active_view_plus_policy_isolated_network
cm_dt_active_view_plus_policy_isolated_search
cm_dt_active_view_plus_policy_isolated_android_tv
cm_dt_active_view_plus_policy_isolated_google_tv
cm_dt_active_view_plus_policy_isolated_other

event

struct

event.active_view_audible_impressions

int64
Active View: Impressions Audible

event.active_view_audible_time_msec

int64
Active View: Play Time Audible (milliseconds)

event.active_view_audible_visible_time_msec

int64
Active View: Play Time Audible and Visible (milliseconds)

event.active_view_background_count

int64
Active View: Impressions In Background

event.active_view_complete_viewable_impressions

int64
Active View: Impressions Visible at Completion

event.active_view_eligible_impressions

int64
Whether the impression was eligible to measure viewability. An impression is eligible if (a) the ad's creative has an Active View tag and (b) the tag successfully communicates with Google Marketing Platform servers at the time of the impression.

event.active_view_first_quartile_viewable_audible_impressions

int64
Active View: Impressions Visible and Audible at First Quartile

event.active_view_first_quartile_viewable_impressions

int64
Active View: Impressions Visible at First Quartile

event.active_view_fullscreen_count

int64
Active View: Impressions Full-Screen

event.active_view_impressions_audible_and_visible_at_completion

int64
Active View: Impressions Audible and Visible at Completion

event.active_view_impressions_visible10_seconds

int64
Active View: Impressions Visible 10 Seconds

event.active_view_measurable_impressions

int64
Whether the impression was measurable with Active View.

event.active_view_midpoint_viewable_audible_impressions

int64
Active View: Impressions Visible and Audible at Midpoint

event.active_view_midpoint_viewable_impressions

int64
Active View: Impressions Visible at Midpoint

event.active_view_plus_measurable_count

int64
Active View Plus: Measurable Impressions

event.active_view_start_viewable_audible_impressions

int64
Active View: Impressions Visible and Audible at Start

event.active_view_start_viewable_impressions

int64
Active View: Impressions Visible at Start

event.active_view_third_quartile_viewable_audible_impressions

int64
Active View: Impressions Visible and Audible at Third Quartile

event.active_view_third_quartile_viewable_impressions

int64
Active View: Impressions Visible at Third Quartile

event.active_view_tos_msec

int64
Active View: Time on Screen (milliseconds)

event.active_view_viewable_impressions

int64
Whether the impression was viewable.

event.active_view_visible_time_msec

int64
Active View: Video Visible Time (milliseconds)

event.activity_count

int64
Activity Quantity

event.activity_id

int64
The ID of the Floodlight tag related to the conversion event.

event.ad_id

int64
Unique ID of the ad placement.

event.advertiser_id

int64
Unique ID of the advertiser

event.audience_segment_id

int64
Unique ID of the audience segment.

event.browser_platform_id

string
ID of the browser type.

event.browser_version

string
Browser/Platform Version

event.campaign_id

int64
The unique ID of the Campaign Manager 360 campaign

event.city_id

int64
City ID

event.conversion_id

int64
Indicates whether an activity has been matched as a post-click (value of 1) or post-impression (value of 2), or unmatched (value of 0).

event.country_code

string
Country

event.creative_version

string
Creative version number.

event.dma_region_id

int64
Designated Market Area ID (US/Canada).

event.dv360_ad_position

int64
Specifies the position of the ad on the page if known. 1 represents above the fold, 2 represents below the fold.

event.dv360_advertiser_id

int64
The Display & Video 360 numerical ID for the advertiser related to the event, for example 164332.

event.dv360_adx_page_categories

string
DV360 Adx Page Categories

event.dv360_attributed_inventory_source_external_id

string
The external ID of the attributed inventory source that Display & Video 360 selected as the best match from those accessible to the advertiser related to the view event based on floor price and auction type.

event.dv360_attributed_inventory_source_is_public

string
True if inventory source is available to all buyers. False otherwise.

event.dv360_auction_bid_price_advertiser_currency

int64

event.dv360_auction_bid_price_partner_currency

int64

event.dv360_auction_bid_price_usd

int64

event.dv360_auction_id

string
A string used to join events among view/click/conversion types, for example"ABCDEFGH_abcdefgh-0123456789". Do not assume any ordering, structure or meaning to the auction_id value.

event.dv360_bid_price_advertiser_currency

int64
The bid price sent to the exchange in advertiser currency nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics.

event.dv360_bid_price_partner_currency

int64
The bid price sent to the exchange in partner currency nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics.

event.dv360_bid_price_usd

int64
The bid price sent to the exchange in USD nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics..

event.dv360_bid_request_publisher_id

string
The publisher id in the publisher.id field of bid request.

event.dv360_billable_cost_advertiser_currency

int64
The total amount of money billed to the partner, including the media cost and partner costs, in advertiser currency nanos.

event.dv360_billable_cost_partner_currency

int64
The total amount of money billed to the partner, including the media cost and partner costs, in partner currency nanos.

event.dv360_billable_cost_usd

int64
The total amount of money billed to the partner, including the media cost and partner costs, in USD nanos.

event.dv360_browser_id

int64
The Display & Video 360 numerical ID identifying the browser related to this event.

event.dv360_browser_reportable_id

int64
The new Display & Video 360 numerical ID identifying the browser related to this event.

event.dv360_browser_timezone_offset_minutes

int64
The difference in minutes between the active timezone on the user's browser and GMT-12, for example 1320 represents a browser timezone of GMT+10.

event.dv360_campaign_id

int64
The unique ID of the linked Display & Video 360 campaign.

event.dv360_city_id

int64
The Display & Video 360 numerical ID identifying the best-guess city of the impression.

event.dv360_country_code

string
2-letter ISO 3166-1 country code identifying the best-guess country of the impression, for example "US".

event.dv360_cpm_fee_1_advertiser_currency

int64
DV360 CPM fee 1 advertiser currency

event.dv360_cpm_fee_1_partner_currency

int64
DV360 CPM fee 1 partner currency

event.dv360_cpm_fee_1_usd

int64
DV360 CPM fee 1 usd

event.dv360_cpm_fee_2_advertiser_currency

int64
DV360 CPM fee 2 advertiser currency

event.dv360_cpm_fee_2_partner_currency

int64
DV360 CPM fee 2 partner currency

event.dv360_cpm_fee_2_usd

int64
DV360 CPM fee 2 usd

event.dv360_cpm_fee_3_advertiser_currency

int64
DV360 CPM fee 3 advertiser currency

event.dv360_cpm_fee_3_partner_currency

int64
DV360 CPM fee 3 partner currency

event.dv360_cpm_fee_3_usd

int64
DV360 CPM fee 3 usd

event.dv360_cpm_fee_4_advertiser_currency

int64
DV360 CPM fee 4 advertiser currency

event.dv360_cpm_fee_4_partner_currency

int64
DV360 CPM fee 4 partner currency

event.dv360_cpm_fee_4_usd

int64
DV360 CPM fee 4 usd

event.dv360_cpm_fee_5_advertiser_currency

int64
DV360 CPM fee 5 advertiser currency

event.dv360_cpm_fee_5_partner_currency

int64
DV360 CPM fee 5 partner currency

event.dv360_cpm_fee_5_usd

int64
DV360 CPM fee 5 usd

event.dv360_creative_id

int64
The Display & Video 360 numerical ID for the creative related to the event, for example 367487.

event.dv360_data_fees_advertiser_currency

int64
DV360 data fees advertiser currency

event.dv360_data_fees_partner_currency

int64
DV360 data fees partner currency

event.dv360_data_fees_usd

int64
DV360 data fees usd

event.dv360_device_type

int64
The numerical value of the identified device type. 0 = Computer, 1 = Other, 2 = Smart Phone, 3 = Tablet, 4 = Smart TV, 5 = Connected TV, 6 = Set Top Box, 7 = Connected Device.

event.dv360_exchange_id

string
The Display & Video 360 numerical ID for the exchange that requested the ad.

event.dv360_insertion_order_id

int64
The Display & Video 360 numerical ID for the insertion order related to the event, for example 1079941.

event.dv360_isp_id

int64
The Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.

event.dv360_isp_reportable_id

int64
The new Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.

event.dv360_language

string
The ISO-639-1 code or "zh_CN" (Chinese (simplified)), "zh_TW" (Chinese (traditional)) or "other" representing the language related to the view event.

event.dv360_line_item_id

int64
The Display & Video 360 numerical ID for the line item related to the event, for example 1155785.

event.dv360_matching_targeted_keywords

string
A comma separated string containing a list of targeted keywords matching the page related to the view event, for example "apple,orange,banana". Although the page related to the view event may match many keywords, only those which were targeted will be included; if the list of keywords is large we may impose a limit to the number of keywords returned.

event.dv360_matching_targeted_segments

string
Space-separated IDs of targeted user lists that match the visitor, for example "-4 456". If the visitor is in a user list that is not targeted by the ad associated with this event it will not be included here.

event.dv360_media_cost_advertiser_currency

int64
The amount paid for the impression in advertiser currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.

event.dv360_media_cost_partner_currency

int64
The amount paid for the impression in the partner currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.

event.dv360_media_cost_usd

int64
The amount paid for the impression in USD nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.

event.dv360_media_fee_1_advertiser_currency

int64
DV360 media fee 1 advertiser currency

event.dv360_media_fee_1_partner_currency

int64
DV360 media fee 1 partner currency

event.dv360_media_fee_1_usd

int64
DV360 media fee 1 usd

event.dv360_media_fee_2_advertiser_currency

int64
DV360 media fee 2 advertiser currency

event.dv360_media_fee_2_partner_currency

int64
DV360 media fee 2 partner currency

event.dv360_media_fee_2_usd

int64
DV360 media fee 2 usd

event.dv360_media_fee_3_advertiser_currency

int64
DV360 media fee 3 advertiser currency

event.dv360_media_fee_3_partner_currency

int64
DV360 media fee 3 partner currency

event.dv360_media_fee_3_usd

int64
DV360 media fee 3 usd

event.dv360_media_fee_4_advertiser_currency

int64
DV360 media fee 4 advertiser currency

event.dv360_media_fee_4_partner_currency

int64
DV360 media fee 4 partner currency

event.dv360_media_fee_4_usd

int64
DV360 media fee 4 usd

event.dv360_media_fee_5_advertiser_currency

int64
DV360 media fee 5 advertiser currency

event.dv360_media_fee_5_partner_currency

int64
DV360 media fee 5 partner currency

event.dv360_media_fee_5_usd

int64
DV360 media fee 5 usd

event.dv360_mobile_make_id

int64
The numerical ID for the mobile make. This value may be missing.

event.dv360_mobile_make_reportable_id

int64
The new numerical ID for the mobile make. This value may be missing.

event.dv360_mobile_model_id

int64
The numerical ID for the mobile model. This value may be missing.

event.dv360_mobile_model_reportable_id

int64
The new numerical ID for the mobile model. This value may be missing.

event.dv360_net_speed

int64
The Display & Video 360 numerical ID representing the network speed related to the view event. 1=Dial-up, 2=EDGE/2G, 3=UMTS/3G, 4=Basic DSL, 5=HSDPA/3.5G, 6=Broadband/4G, 7=Unknown.

event.dv360_operating_system_id

int64
Operating System ID.

event.dv360_operating_system_reportable_id

int64
New Operating System ID.

event.dv360_request_time

int64
A Unix timestamp in microseconds (1/1,000,000 second) for when we received the ad request, for example1330403779608570 represents Tuesday February 28th 2012 04:36:19.608570. Although this value is consistent across the view, click and conversion even it is not guaranteed to be unique - use auction_id to join events

event.dv360_revenue_advertiser_currency

int64
The total amount in advertiser currency nanos made by the partner account for the view event. This value may be zero.

event.dv360_revenue_partner_currency

int64
The total amount in partner currency nanos made by the partner account for the view event. This value may be zero.

event.dv360_revenue_usd

int64
The total amount in USD nanos made by the partner account for the view event. This value may be zero.

event.dv360_site_id

int64
The Display & Video 360 numerical ID for the most specific universal site that matches the url.

event.dv360_state_region_id

int64
DV360 Region ID

event.dv360_supply_chain_complete

boolean
Indicates whether the supply chain object is complete in the bid request.

event.dv360_supply_chain_domain

array<string>
The domain in the supply path, the order is the same as the order in the supply chain JSON.

event.dv360_supply_chain_seller_id

array<string>
Array of strings. The seller ID in the supply path, the order is the same as the order in the supply chain JSON.

event.dv360_url

string
The raw URL taken from the bid request received from the exchange, for example "http://www.example.com". As some exchanges mask the URL in their bid requests this value may be: "source_url_hidden"

event.dv360_view_state

string
Populated for wrapped tags. (Two impression records when both events occur.) Possible values are: "OUTER", DV360 returned wrapped tag; "INNER", ad served post wrapped tag; "3PAS_MERGED", wrapped tag tracked by CM; "3PAS_OUTER", tracking ping sent to CM but no response, 3rd party blocked ad serving.

event.dv360_zip_postal_code

string
DV360 ZIP/Postal Code

event.event_sub_type

string
Contains further details related to the event - these are VIEW and CLICK for view and click events, but may be POSTVIEW, POSTCLICK or blank for conversion events.

event.event_time

int64
Time in microseconds since 1970-01-01 00:00:00 UTC.

event.event_type

string
Contains VIDEO_ACTIVE_VIEW_SESSION.

event.floodlight_config_id

int64
Unique ID of the floodlight configuration.

event.impression_id

string
Impression ID

event.interaction_time_utc_seconds

string
Interaction time UTC seconds

event.landing_page_url_id

int64
Unique ID of the landing page URL. Only populates for clicks, NULL for other tables.

event.operating_system_id

int64
ID of the operating system.

event.ord_value

string
The advertiser's ordinal ID, if relevant for a given activity type. Passed in the 'ord=' key-value (also used for storing the client's Order-ID in sales tags)

event.other_data

string
Stores key-value data from the activity string which is not otherwise labeled. (Any key-value that is NOT "src=", "type=", "cat=", "ord=", "u=", "cost=", "qty=", "tran=", "a=", or "b="). Custom Floodlight Variables, such as "u1=" and "u2=", are available and can be used for further product breakdown.

event.placement_id

int64
Unique ID for the site page / placement where the ad ran.

event.platform_type_id

int64
Identifier that maps to the platform on which the event occurred. Possible values are: 30000: desktop, 30001: high-end smartphone, 30002: tablet, 30003: mid-range smartphone, 30004: connected TV, 30005: unknown, 30006: set top box.

event.referrer_url

string
Contains the URL on which the ad appeared, when possible. May also be empty, or return ad server URLs.

event.rendering_id

int64
Unique ID of the creative for Data Transfer. Does not correspond to the UI-Creative-ID.

event.rich_media_event_counters

int64
MET Counter Value (the ecn= value).

event.rich_media_event_id

int64
MET Event ID for the Rich Media ad.

event.rich_media_event_timers

double
Time in microseconds since 1970-01-01 00:00:00 UTC.

event.rich_media_event_type_id

int64
ID of Rich Media Event Type.

event.segment_value_1

int64
Segment Value 1

event.site_id

int64
Unique ID for the site where the ad ran.

event.state

string
ID for user's state or province (US/Canada)

event.tran_value

string
TRAN Value

event.u_value

string
U Value

event.zip_code

string
Postal-Code (US/Canada).

network_id

int64
The network ID.

user_id

opaque
The tracking ID (it is based on, but does not expose the user's browser cookie or mobile device ID). This field may be zeroed out for privacy reasons. User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

Campaign Manager 360 Data Transfer activities attributed

cm_dt_activities_attributed

To query EEA user data, use the policy-isolated tables in place of cm_dt_activities_attributed :

cm_dt_activities_attributed_policy_isolated_youtube
cm_dt_activities_attributed_policy_isolated_network
cm_dt_activities_attributed_policy_isolated_search
cm_dt_activities_attributed_policy_isolated_accommodations
cm_dt_activities_attributed_policy_isolated_maps
cm_dt_activities_attributed_policy_isolated_gmail
cm_dt_activities_attributed_policy_isolated_playstore
cm_dt_activities_attributed_policy_isolated_shopping

event

struct

event.activity_id

int64
The ID of the Floodlight tag related to the conversion event.

event.ad_id

int64
Unique ID of the ad placement.

event.advertiser_id

int64
Unique ID of the advertiser

event.attribution_model_config_id

int64
Unique ID of the attribution model.

event.audience_segment_id

int64
Unique ID of the audience segment.

event.browser_platform_id

string
ID of the browser type.

event.browser_version

string
Browser/Platform Version

event.campaign_id

int64
The unique ID of the Campaign Manager 360 campaign

event.city_id

int64
City ID

event.conversion_event_id

string
The unique ID of the conversion event.

event.country_code

string
Country

event.creative_version

string
Creative version number.

event.dma_region_id

int64
Designated Market Area ID (US/Canada).

event.dv360_ad_position

int64
Specifies the position of the ad on the page if known. 1 represents above the fold, 2 represents below the fold.

event.dv360_advertiser_id

int64
The Display & Video 360 numerical ID for the advertiser related to the event, for example 164332.

event.dv360_adx_page_categories

string
DV360 Adx Page Categories

event.dv360_attributed_inventory_source_external_id

event.dv360_attributed_inventory_source_is_public

string
True if inventory source is available to all buyers. False otherwise.

event.dv360_auction_bid_price_advertiser_currency

int64

event.dv360_auction_bid_price_partner_currency

int64

event.dv360_auction_bid_price_usd

int64

event.dv360_auction_id

string
A string used to join events among view/click/conversion types, for example"ABCDEFGH_abcdefgh-0123456789". Do not assume any ordering, structure or meaning to the auction_id value.

event.dv360_bid_price_advertiser_currency

event.dv360_bid_price_partner_currency

event.dv360_bid_price_usd

event.dv360_bid_request_publisher_id

string
The publisher id in the publisher.id field of bid request.

event.dv360_billable_cost_advertiser_currency

int64
The total amount of money billed to the partner, including the media cost and partner costs, in advertiser currency nanos.

event.dv360_billable_cost_partner_currency

int64
The total amount of money billed to the partner, including the media cost and partner costs, in partner currency nanos.

event.dv360_billable_cost_usd

int64
The total amount of money billed to the partner, including the media cost and partner costs, in USD nanos.

event.dv360_browser_id

int64
The Display & Video 360 numerical ID identifying the browser related to this event.

event.dv360_browser_reportable_id

int64
The new Display & Video 360 numerical ID identifying the browser related to this event.

event.dv360_browser_timezone_offset_minutes

int64
The difference in minutes between the active timezone on the user's browser and GMT-12, for example 1320 represents a browser timezone of GMT+10.

event.dv360_campaign_id

int64
The unique ID of the linked Display & Video 360 campaign.

event.dv360_city_id

int64
The Display & Video 360 numerical ID identifying the best-guess city of the impression.

event.dv360_country_code

string
2-letter ISO 3166-1 country code identifying the best-guess country of the impression, for example "US".

event.dv360_cpm_fee_1_advertiser_currency

int64
DV360 CPM fee 1 advertiser currency

event.dv360_cpm_fee_1_partner_currency

int64
DV360 CPM fee 1 partner currency

event.dv360_cpm_fee_1_usd

int64
DV360 CPM fee 1 usd

event.dv360_cpm_fee_2_advertiser_currency

int64
DV360 CPM fee 2 advertiser currency

event.dv360_cpm_fee_2_partner_currency

int64
DV360 CPM fee 2 partner currency

event.dv360_cpm_fee_2_usd

int64
DV360 CPM fee 2 usd

event.dv360_cpm_fee_3_advertiser_currency

int64
DV360 CPM fee 3 advertiser currency

event.dv360_cpm_fee_3_partner_currency

int64
DV360 CPM fee 3 partner currency

event.dv360_cpm_fee_3_usd

int64
DV360 CPM fee 3 usd

event.dv360_cpm_fee_4_advertiser_currency

int64
DV360 CPM fee 4 advertiser currency

event.dv360_cpm_fee_4_partner_currency

int64
DV360 CPM fee 4 partner currency

event.dv360_cpm_fee_4_usd

int64
DV360 CPM fee 4 usd

event.dv360_cpm_fee_5_advertiser_currency

int64
DV360 CPM fee 5 advertiser currency

event.dv360_cpm_fee_5_partner_currency

int64
DV360 CPM fee 5 partner currency

event.dv360_cpm_fee_5_usd

int64
DV360 CPM fee 5 usd

event.dv360_creative_id

int64
The Display & Video 360 numerical ID for the creative related to the event, for example 367487.

event.dv360_data_fees_advertiser_currency

int64
DV360 data fees advertiser currency

event.dv360_data_fees_partner_currency

int64
DV360 data fees partner currency

event.dv360_data_fees_usd

int64
DV360 data fees usd

event.dv360_device_type

int64
The numerical value of the identified device type. 0 = Computer, 1 = Other, 2 = Smart Phone, 3 = Tablet, 4 = Smart TV, 5 = Connected TV, 6 = Set Top Box, 7 = Connected Device.

event.dv360_exchange_id

string
The Display & Video 360 numerical ID for the exchange that requested the ad.

event.dv360_insertion_order_id

int64
The Display & Video 360 numerical ID for the insertion order related to the event, for example 1079941.

event.dv360_isp_id

int64
The Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.

event.dv360_isp_reportable_id

int64
The new Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.

event.dv360_language

string
The ISO-639-1 code or "zh_CN" (Chinese (simplified)), "zh_TW" (Chinese (traditional)) or "other" representing the language related to the view event.

event.dv360_line_item_id

int64
The Display & Video 360 numerical ID for the line item related to the event, for example 1155785.

event.dv360_matching_targeted_keywords

event.dv360_matching_targeted_segments

event.dv360_media_cost_advertiser_currency

int64
The amount paid for the impression in advertiser currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.

event.dv360_media_cost_partner_currency

int64
The amount paid for the impression in the partner currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.

event.dv360_media_cost_usd

int64
The amount paid for the impression in USD nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.

event.dv360_media_fee_1_advertiser_currency

int64
DV360 media fee 1 advertiser currency

event.dv360_media_fee_1_partner_currency

int64
DV360 media fee 1 partner currency

event.dv360_media_fee_1_usd

int64
DV360 media fee 1 usd

event.dv360_media_fee_2_advertiser_currency

int64
DV360 media fee 2 advertiser currency

event.dv360_media_fee_2_partner_currency

int64
DV360 media fee 2 partner currency

event.dv360_media_fee_2_usd

int64
DV360 media fee 2 usd

event.dv360_media_fee_3_advertiser_currency

int64
DV360 media fee 3 advertiser currency

event.dv360_media_fee_3_partner_currency

int64
DV360 media fee 3 partner currency

event.dv360_media_fee_3_usd

int64
DV360 media fee 3 usd

event.dv360_media_fee_4_advertiser_currency

int64
DV360 media fee 4 advertiser currency

event.dv360_media_fee_4_partner_currency

int64
DV360 media fee 4 partner currency

event.dv360_media_fee_4_usd

int64
DV360 media fee 4 usd

event.dv360_media_fee_5_advertiser_currency

int64
DV360 media fee 5 advertiser currency

event.dv360_media_fee_5_partner_currency

int64
DV360 media fee 5 partner currency

event.dv360_media_fee_5_usd

int64
DV360 media fee 5 usd

event.dv360_mobile_make_id

int64
The numerical ID for the mobile make. This value may be missing.

event.dv360_mobile_make_reportable_id

int64
The new numerical ID for the mobile make. This value may be missing.

event.dv360_mobile_model_id

int64
The numerical ID for the mobile model. This value may be missing.

event.dv360_mobile_model_reportable_id

int64
The new numerical ID for the mobile model. This value may be missing.

event.dv360_net_speed

int64
The Display & Video 360 numerical ID representing the network speed related to the view event. 1=Dial-up, 2=EDGE/2G, 3=UMTS/3G, 4=Basic DSL, 5=HSDPA/3.5G, 6=Broadband/4G, 7=Unknown.

event.dv360_operating_system_id

int64
Operating System ID.

event.dv360_operating_system_reportable_id

int64
New Operating System ID.

event.dv360_request_time

event.dv360_revenue_advertiser_currency

int64
The total amount in advertiser currency nanos made by the partner account for the view event. This value may be zero.

event.dv360_revenue_partner_currency

int64
The total amount in partner currency nanos made by the partner account for the view event. This value may be zero.

event.dv360_revenue_usd

int64
The total amount in USD nanos made by the partner account for the view event. This value may be zero.

event.dv360_site_id

int64
The Display & Video 360 numerical ID for the most specific universal site that matches the url.

event.dv360_state_region_id

int64
DV360 Region ID

event.dv360_supply_chain_complete

boolean
Indicates whether the supply chain object is complete in the bid request.

event.dv360_supply_chain_domain

array<string>
The domain in the supply path, the order is the same as the order in the supply chain JSON.

event.dv360_supply_chain_seller_id

array<string>
Array of strings. The seller ID in the supply path, the order is the same as the order in the supply chain JSON.

event.dv360_url

event.dv360_view_state

event.dv360_zip_postal_code

string
DV360 ZIP/Postal Code

event.event_sub_type

string
Contains further details related to the event - these are VIEW and CLICK for view and click events, but may be POSTVIEW, POSTCLICK or blank for conversion events.

event.event_time

int64
Time in microseconds since 1970-01-01 00:00:00 UTC.

event.event_type

string
Contains CONVERSION or MODELED_CONVERSION for conversion events.

event.floodlight_config_id

int64
Unique ID of the floodlight configuration.

event.interaction_time_utc_seconds

string
Interaction time UTC seconds

event.landing_page_url_id

int64
Unique ID of the landing page URL. Only populates for clicks, NULL for other tables.

event.operating_system_id

int64
ID of the operating system.

event.ord_value

string
The advertiser's ordinal ID, if relevant for a given activity type. Passed in the 'ord=' key-value (also used for storing the client's Order-ID in sales tags)

event.other_data

event.placement_id

int64
Unique ID for the site page / placement where the ad ran.

event.platform_type_id

event.referrer_url

string
Contains the URL on which the ad appeared, when possible. May also be empty, or return ad server URLs.

event.rendering_id

int64
Unique ID of the creative for Data Transfer. Does not correspond to the UI-Creative-ID.

event.rich_media_event_counters

int64
MET Counter Value (the ecn= value).

event.rich_media_event_id

int64
MET Event ID for the Rich Media ad.

event.rich_media_event_timers

double
Time in microseconds since 1970-01-01 00:00:00 UTC.

event.rich_media_event_type_id

int64
ID of Rich Media Event Type.

event.sa360_adgroup_id

int64
SA360 Ad Group ID

event.sa360_campaign_id

int64
SA360 Campaign ID

event.sa360_customer_id

int64
SA360 Customer ID

event.sa360_keyword_id

int64
SA360 Keyword ID

event.segment_value_1

int64
Segment Value 1

event.site_id

int64
Unique ID for the site where the ad ran.

event.state

string
ID for user's state or province (US/Canada)

event.total_conversions

double
The amount of conversion credit in nanos credited to the attributed event. For sales activities, Floodlight might count more than one conversion per event. For example, you can set up Floodlight to count the number of items purchased as the number of conversions for a single event. (The double value of the int event.activity_count in activities_events.)

event.total_conversions_revenue

double
The amount of revenue in USD credited to the attributed event. (The attributed version of event.activity_revenue in activities_events.)

event.total_transaction_count

double
The number of transactions or activity tag fires in nanos credited to the attributed event.

event.tran_value

string
TRAN Value

event.u_value

string
U Value

event.zip_code

string
Postal-Code (US/Canada).

network_id

int64
The network ID.

user_id

Campaign Manager 360 Data Transfer activities events

cm_dt_activities_events

To query EEA user data, use the policy-isolated tables in place of cm_dt_activities_events :

cm_dt_activities_events_policy_isolated_youtube
cm_dt_activities_events_policy_isolated_network
cm_dt_activities_events_policy_isolated_search
cm_dt_activities_events_policy_isolated_maps
cm_dt_activities_events_policy_isolated_unconsented_floodlights
cm_dt_activities_events_policy_isolated_other
cm_dt_activities_events_policy_isolated_playstore
cm_dt_activities_events_policy_isolated_shopping

event

struct

event.activity_count

int64
Activity Quantity

event.activity_id

int64
The ID of the Floodlight tag related to the conversion event.

event.activity_revenue

double
The amount of revenue in USD megas credited to the event. You can multiply by 1,000,000 to see it as a dollar amount.

event.browser_platform_id

string
ID of the browser type.

event.browser_version

string
Browser/Platform Version

event.conversion_event_id

string
The unique ID of the conversion event.

event.cookie_consented_floodlight_impressions

int64
The number of Floodlight impressions in which users have consented to cookie tracking.

event.country_code

string
Country

event.duplicate_floodlight_impressions

int64
Floodlight impressions which are logged after the user has consented to cookies, but have been previously been logged as unconsented events. Thus, these are considered to be duplicate events.

event.event_time

int64
Time in microseconds since 1970-01-01 00:00:00 UTC.

event.event_type

string
Event Type

event.floodlight_config_id

int64
Unique ID of the floodlight configuration.

event.operating_system_id

int64
ID of the operating system.

event.ord_value

string
The advertiser's ordinal ID, if relevant for a given activity type. Passed in the 'ord=' key-value (also used for storing the client's Order-ID in sales tags)

event.other_data

event.platform_type_id

event.state

string
ID for user's state or province (US/Canada)

event.tran_value

string
TRAN Value

event.u_value

string
U Value

network_id

int64
The network ID.

user_id

Campaign Manager 360 Data Transfer activity category

cm_dt_activity_category

account_id

int64
Unique ID of the account.

activity

string
User defined category report interface name for floodlight tags.

activity_group_id

int64
ID of the group to which this advertiser belongs. An advertiser may be a member of only one group.

activity_id

int64
Unique ID of the Floodlight activity.

activity_sub_type

string
User defined string corresponding to cat= value from Floodlight tag.

activity_type

string
User defined string corresponding to type= value from Floodlight tag.

advertiser_id

int64
Unique ID of the advertiser.

floodlight_config_id

int64
Unique ID of the floodlight configuration.

tag_counting_method_id

int64
User defined type - describing Floodlight tag type. Key: 1 - standard, 2 - unique, 3 - custom, 4 - integer of transactionfor sales tags only, 5 - integer of items sold.

Campaign Manager 360 Data Transfer activity type

cm_dt_activity_type

account_id

int64
Unique ID of the account.

activity_group

string
Name for this activity group.

activity_group_id

int64
ID of the group to which this advertiser belongs. An advertiser may be a member of only one group.

activity_type

string
User defined string corresponding to type= value from Floodlight tag.

advertiser_id

int64
Unique ID of the advertiser.

floodlight_config_id

int64
Unique ID of the floodlight configuration.

Campaign Manager 360 Data Transfer ad

cm_dt_ad

account_id

int64
Unique ID of the account.

ad

string
User defined ad name.

ad_click_url

string
Click through URL of Click Ad type creatives only (aka Click Commands)

ad_comments

string
User defined ad level comments.

ad_id

int64
Unique ID of the ad.

ad_type

string
Type of ad. Possible values are: Standard, Interstitial, Static Click, Dynamic Click, Tracking, In-Steam Video, DART Search, Affiliate, PInclusion, Product feeds, Natural Search, Default, Interstitial Default, InStream Default, Ad Brand-neutral

ad_type_id

int64
Unique ID of the ad type.

advertiser_id

int64
Unique ID of the advertiser.

campaign_id

int64
The unique ID of the Campaign Manager 360 campaign.

creative_size

string
The creative size in pixels: width x height. Empty size is represented by "0X0".

floodlight_config_id

int64
Unique ID of the floodlight configuration.

Campaign Manager 360 Data Transfer Ad placement assignments

cm_dt_ad_placement_assignment

account_id

int64
Unique ID of the account.

ad_id

int64
Unique ID of the ad.

advertiser_id

int64
Unique ID of the advertiser.

floodlight_config_id

int64
Unique ID of the floodlight configuration.

placement_id

int64

Campaign Manager 360 Data Transfer Advertiser

cm_dt_advertiser

account_id

int64
Unique ID of the account.

advertiser

string
User entered name of the advertiser.

advertiser_group

string
User specified group to which this advertiser belongs. An advertiser may be a member of only one group.

advertiser_group_id

int64
Group ID to which this advertiser belongs. An advertiser may be a member of only one group.

advertiser_id

int64
Unique ID of the advertiser.

floodlight_config_id

int64
Unique ID of the floodlight configuration.

Campaign Manager 360 Data Transfer asset

cm_dt_asset

account_id

int64
Unique ID of the account.

asset

string
Name of the creative asset.

asset_category

string
Category of the creative asset.

asset_id

int64
Unique ID of the asset.

asset_orientation

string
Screen orientation of the asset.

Campaign Manager 360 Data Transfer audience segments

cm_dt_audience_segments

account_id

int64
Unique ID of the account.

advertiser_id

int64
Unique ID of the advertiser.

audience_segment

string
Name of the audience segment.

audience_segment_id

int64
Unique ID of the audience segment.

floodlight_config_id

int64
Unique ID of the floodlight configuration.

Campaign Manager 360 Data Transfer browser

cm_dt_browser

browser_platform

string

browser_platform_id

int64
Browser / Platform ID

Campaign Manager 360 Data Transfer campaign

cm_dt_campaign

account_id

int64
Unique ID of the account.

advertiser_id

int64
Unique ID of the advertiser.

billing_invoice_code

string
The code entered in the billing invoice.

campaign

string
User entered campaign name.

campaign_end_date

int64
Campaign end date as YYYYMMDD.

campaign_id

int64
The unique ID of the Campaign Manager 360 campaign.

campaign_start_date

int64
Campaign start date as YYYYMMDD.

floodlight_config_id

int64
Unique ID of the floodlight configuration.

Campaign Manager 360 Data Transfer city

cm_dt_city

city

string
The city name

city_id

int64
Unique ID of the city.

Campaign Manager 360 Data Transfer clicks

cm_dt_clicks

To query EEA user data, use the policy-isolated tables in place of cm_dt_clicks :

cm_dt_clicks_policy_isolated_youtube
cm_dt_clicks_policy_isolated_network
cm_dt_clicks_policy_isolated_search
cm_dt_clicks_policy_isolated_accommodations
cm_dt_clicks_policy_isolated_assistant
cm_dt_clicks_policy_isolated_maps
cm_dt_clicks_policy_isolated_gmail
cm_dt_clicks_policy_isolated_other
cm_dt_clicks_policy_isolated_shopping

event

struct

event.active_view_audible_impressions

int64
Active View: Impressions Audible

event.active_view_audible_time_msec

int64
Active View: Play Time Audible (milliseconds)

event.active_view_audible_visible_time_msec

int64
Active View: Play Time Audible and Visible (milliseconds)

event.active_view_background_count

int64
Active View: Impressions In Background

event.active_view_complete_viewable_impressions

int64
Active View: Impressions Visible at Completion

event.active_view_eligible_impressions

event.active_view_first_quartile_viewable_audible_impressions

int64
Active View: Impressions Visible and Audible at First Quartile

event.active_view_first_quartile_viewable_impressions

int64
Active View: Impressions Visible at First Quartile

event.active_view_fullscreen_count

int64
Active View: Impressions Full-Screen

event.active_view_impressions_audible_and_visible_at_completion

int64
Active View: Impressions Audible and Visible at Completion

event.active_view_impressions_visible10_seconds

int64
Active View: Impressions Visible 10 Seconds

event.active_view_measurable_impressions

int64
Whether the impression was measurable with Active View.

event.active_view_midpoint_viewable_audible_impressions

int64
Active View: Impressions Visible and Audible at Midpoint

event.active_view_midpoint_viewable_impressions

int64
Active View: Impressions Visible at Midpoint

event.active_view_plus_measurable_count

int64
Active View Plus: Measurable Impressions

event.active_view_start_viewable_audible_impressions

int64
Active View: Impressions Visible and Audible at Start

event.active_view_start_viewable_impressions

int64
Active View: Impressions Visible at Start

event.active_view_third_quartile_viewable_audible_impressions

int64
Active View: Impressions Visible and Audible at Third Quartile

event.active_view_third_quartile_viewable_impressions

int64
Active View: Impressions Visible at Third Quartile

event.active_view_tos_msec

int64
Active View: Time on Screen (milliseconds)

event.active_view_viewable_impressions

int64
Whether the impression was viewable.

event.active_view_visible_time_msec

int64
Active View: Video Visible Time (milliseconds)

event.activity_count

int64
Activity Quantity

event.activity_id

int64
The ID of the Floodlight tag related to the conversion event.

event.ad_id

int64
Unique ID of the ad placement.

event.advertiser_id

int64
Unique ID of the advertiser

event.audience_segment_id

int64
Unique ID of the audience segment.

event.browser_platform_id

string
ID of the browser type.

event.browser_version

string
Browser/Platform Version

event.campaign_id

int64
The unique ID of the Campaign Manager 360 campaign

event.city_id

int64
City ID

event.conversion_id

int64
Indicates whether an activity has been matched as a post-click (value of 1) or post-impression (value of 2), or unmatched (value of 0).

event.country_code

string
Country

event.creative_version

string
Creative version number.

event.dma_region_id

int64
Designated Market Area ID (US/Canada).

event.dv360_ad_position

int64
Specifies the position of the ad on the page if known. 1 represents above the fold, 2 represents below the fold.

event.dv360_advertiser_id

int64
The Display & Video 360 numerical ID for the advertiser related to the event, for example 164332.

event.dv360_adx_page_categories

string
DV360 Adx Page Categories

event.dv360_attributed_inventory_source_external_id

event.dv360_attributed_inventory_source_is_public

string
True if inventory source is available to all buyers. False otherwise.

event.dv360_auction_bid_price_advertiser_currency

int64

event.dv360_auction_bid_price_partner_currency

int64

event.dv360_auction_bid_price_usd

int64

event.dv360_auction_id

string
A string used to join events among view/click/conversion types, for example"ABCDEFGH_abcdefgh-0123456789". Do not assume any ordering, structure or meaning to the auction_id value.

event.dv360_bid_price_advertiser_currency

event.dv360_bid_price_partner_currency

event.dv360_bid_price_usd

event.dv360_bid_request_publisher_id

string
The publisher id in the publisher.id field of bid request.

event.dv360_billable_cost_advertiser_currency

int64
The total amount of money billed to the partner, including the media cost and partner costs, in advertiser currency nanos.

event.dv360_billable_cost_partner_currency

int64
The total amount of money billed to the partner, including the media cost and partner costs, in partner currency nanos.

event.dv360_billable_cost_usd

int64
The total amount of money billed to the partner, including the media cost and partner costs, in USD nanos.

event.dv360_browser_id

int64
The Display & Video 360 numerical ID identifying the browser related to this event.

event.dv360_browser_reportable_id

int64
The new Display & Video 360 numerical ID identifying the browser related to this event.

event.dv360_browser_timezone_offset_minutes

int64
The difference in minutes between the active timezone on the user's browser and GMT-12, for example 1320 represents a browser timezone of GMT+10.

event.dv360_campaign_id

int64
The unique ID of the linked Display & Video 360 campaign.

event.dv360_city_id

int64
The Display & Video 360 numerical ID identifying the best-guess city of the impression.

event.dv360_country_code

string
2-letter ISO 3166-1 country code identifying the best-guess country of the impression, for example "US".

event.dv360_cpm_fee_1_advertiser_currency

int64
DV360 CPM fee 1 advertiser currency

event.dv360_cpm_fee_1_partner_currency

int64
DV360 CPM fee 1 partner currency

event.dv360_cpm_fee_1_usd

int64
DV360 CPM fee 1 usd

event.dv360_cpm_fee_2_advertiser_currency

int64
DV360 CPM fee 2 advertiser currency

event.dv360_cpm_fee_2_partner_currency

int64
DV360 CPM fee 2 partner currency

event.dv360_cpm_fee_2_usd

int64
DV360 CPM fee 2 usd

event.dv360_cpm_fee_3_advertiser_currency

int64
DV360 CPM fee 3 advertiser currency

event.dv360_cpm_fee_3_partner_currency

int64
DV360 CPM fee 3 partner currency

event.dv360_cpm_fee_3_usd

int64
DV360 CPM fee 3 usd

event.dv360_cpm_fee_4_advertiser_currency

int64
DV360 CPM fee 4 advertiser currency

event.dv360_cpm_fee_4_partner_currency

int64
DV360 CPM fee 4 partner currency

event.dv360_cpm_fee_4_usd

int64
DV360 CPM fee 4 usd

event.dv360_cpm_fee_5_advertiser_currency

int64
DV360 CPM fee 5 advertiser currency

event.dv360_cpm_fee_5_partner_currency

int64
DV360 CPM fee 5 partner currency

event.dv360_cpm_fee_5_usd

int64
DV360 CPM fee 5 usd

event.dv360_creative_id

int64
The Display & Video 360 numerical ID for the creative related to the event, for example 367487.

event.dv360_data_fees_advertiser_currency

int64
DV360 data fees advertiser currency

event.dv360_data_fees_partner_currency

int64
DV360 data fees partner currency

event.dv360_data_fees_usd

int64
DV360 data fees usd

event.dv360_device_type

int64
The numerical value of the identified device type. 0 = Computer, 1 = Other, 2 = Smart Phone, 3 = Tablet, 4 = Smart TV, 5 = Connected TV, 6 = Set Top Box, 7 = Connected Device.

event.dv360_exchange_id

string
The Display & Video 360 numerical ID for the exchange that requested the ad.

event.dv360_insertion_order_id

int64
The Display & Video 360 numerical ID for the insertion order related to the event, for example 1079941.

event.dv360_isp_id

int64
The Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.

event.dv360_isp_reportable_id

int64
The new Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.

event.dv360_language

string
The ISO-639-1 code or "zh_CN" (Chinese (simplified)), "zh_TW" (Chinese (traditional)) or "other" representing the language related to the view event.

event.dv360_line_item_id

int64
The Display & Video 360 numerical ID for the line item related to the event, for example 1155785.

event.dv360_matching_targeted_keywords

event.dv360_matching_targeted_segments

event.dv360_media_cost_advertiser_currency

int64
The amount paid for the impression in advertiser currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.

event.dv360_media_cost_partner_currency

int64
The amount paid for the impression in the partner currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.

event.dv360_media_cost_usd

int64
The amount paid for the impression in USD nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.

event.dv360_media_fee_1_advertiser_currency

int64
DV360 media fee 1 advertiser currency

event.dv360_media_fee_1_partner_currency

int64
DV360 media fee 1 partner currency

event.dv360_media_fee_1_usd

int64
DV360 media fee 1 usd

event.dv360_media_fee_2_advertiser_currency

int64
DV360 media fee 2 advertiser currency

event.dv360_media_fee_2_partner_currency

int64
DV360 media fee 2 partner currency

event.dv360_media_fee_2_usd

int64
DV360 media fee 2 usd

event.dv360_media_fee_3_advertiser_currency

int64
DV360 media fee 3 advertiser currency

event.dv360_media_fee_3_partner_currency

int64
DV360 media fee 3 partner currency

event.dv360_media_fee_3_usd

int64
DV360 media fee 3 usd

event.dv360_media_fee_4_advertiser_currency

int64
DV360 media fee 4 advertiser currency

event.dv360_media_fee_4_partner_currency

int64
DV360 media fee 4 partner currency

event.dv360_media_fee_4_usd

int64
DV360 media fee 4 usd

event.dv360_media_fee_5_advertiser_currency

int64
DV360 media fee 5 advertiser currency

event.dv360_media_fee_5_partner_currency

int64
DV360 media fee 5 partner currency

event.dv360_media_fee_5_usd

int64
DV360 media fee 5 usd

event.dv360_mobile_make_id

int64
The numerical ID for the mobile make. This value may be missing.

event.dv360_mobile_make_reportable_id

int64
The new numerical ID for the mobile make. This value may be missing.

event.dv360_mobile_model_id

int64
The numerical ID for the mobile model. This value may be missing.

event.dv360_mobile_model_reportable_id

int64
The new numerical ID for the mobile model. This value may be missing.

event.dv360_net_speed

int64
The Display & Video 360 numerical ID representing the network speed related to the view event. 1=Dial-up, 2=EDGE/2G, 3=UMTS/3G, 4=Basic DSL, 5=HSDPA/3.5G, 6=Broadband/4G, 7=Unknown.

event.dv360_operating_system_id

int64
Operating System ID.

event.dv360_operating_system_reportable_id

int64
New Operating System ID.

event.dv360_request_time

event.dv360_revenue_advertiser_currency

int64
The total amount in advertiser currency nanos made by the partner account for the view event. This value may be zero.

event.dv360_revenue_partner_currency

int64
The total amount in partner currency nanos made by the partner account for the view event. This value may be zero.

event.dv360_revenue_usd

int64
The total amount in USD nanos made by the partner account for the view event. This value may be zero.

event.dv360_site_id

int64
The Display & Video 360 numerical ID for the most specific universal site that matches the url.

event.dv360_state_region_id

int64
DV360 Region ID

event.dv360_supply_chain_complete

boolean
Indicates whether the supply chain object is complete in the bid request.

event.dv360_supply_chain_domain

array<string>
The domain in the supply path, the order is the same as the order in the supply chain JSON.

event.dv360_supply_chain_seller_id

array<string>
Array of strings. The seller ID in the supply path, the order is the same as the order in the supply chain JSON.

event.dv360_url

event.dv360_view_state

event.dv360_zip_postal_code

string
DV360 ZIP/Postal Code

event.dynamic_profile

string
Studio dynamic profile name.

event.dynamic_profile_id

int64
Studio dynamic profile ID.

event.event_sub_type

string
Contains further details related to the event - these are VIEW and CLICK for view and click events, but may be POSTVIEW, POSTCLICK or blank for conversion events.

event.event_time

int64
Time in microseconds since 1970-01-01 00:00:00 UTC.

event.event_type

string
Contains CLICK.

event.feed

array<string>
Feed ID.

event.feed_reporting_dimension1

array<string>

event.feed_reporting_dimension2

array<string>

event.feed_reporting_dimension3

array<string>

event.feed_reporting_dimension4

array<string>

event.feed_reporting_dimension5

array<string>

event.feed_reporting_dimension6

array<string>

event.feed_reporting_label

array<string>
Dynamic Feed Reporting Label.

event.feed_unique_id

array<string>

event.floodlight_config_id

int64
Unique ID of the floodlight configuration.

event.gclid

string
Google click identifier (GCLID). Can be used in queries, but can't be exported in reports.

event.impression_id

string
Impression ID

event.interaction_time_utc_seconds

string
Interaction time UTC seconds

event.landing_page_url_id

int64
Unique ID of the landing page URL. Only populates for clicks, NULL for other tables.

event.operating_system_id

int64
ID of the operating system.

event.ord_value

string
The advertiser's ordinal ID, if relevant for a given activity type. Passed in the 'ord=' key-value (also used for storing the client's Order-ID in sales tags)

event.other_data

event.placement_id

int64
Unique ID for the site page / placement where the ad ran.

event.platform_type_id

event.referrer_url

string
Contains the URL on which the ad appeared, when possible. May also be empty, or return ad server URLs.

event.rendering_id

int64
Unique ID of the creative for Data Transfer. Does not correspond to the UI-Creative-ID.

event.rich_media_event_counters

int64
MET Counter Value (the ecn= value).

event.rich_media_event_id

int64
MET Event ID for the Rich Media ad.

event.rich_media_event_timers

double
Time in microseconds since 1970-01-01 00:00:00 UTC.

event.rich_media_event_type_id

int64
ID of Rich Media Event Type.

event.sa360_adgroup_id

int64
SA360 Ad Group ID

event.sa360_campaign_id

int64
SA360 Campaign ID

event.sa360_customer_id

int64
SA360 Customer ID

event.sa360_keyword_id

int64
SA360 Keyword ID

event.segment_value_1

int64
Segment Value 1

event.site_id

int64
Unique ID for the site where the ad ran.

event.state

string
ID for user's state or province (US/Canada)

event.tran_value

string
TRAN Value

event.u_value

string
U Value

event.zip_code

string
Postal-Code (US/Canada).

network_id

int64
The network ID.

user_id

Campaign Manager 360 Data Transfer creative

cm_dt_creative

account_id

int64
Unique ID of the account.

advertiser_id

int64
Unique ID of the advertiser.

creative

string
Creative Name as entered into the Campaign Manager 360 interface.

creative_id

int64
The Creative ID in Campaign Manager 360 UI.

creative_image_url

string
Location of creative image (Does not apply to rich media).

creative_last_modified_date

int64
Unix epoch timestamp (milliseconds) of the last time this creative was modified.

creative_size

string
The creative size in pixels: width x height. Empty size is represented by "0X0".

creative_type

string
The type of creative.

creative_type_id

int64

creative_version

int64
Used for change management to capture different versions

floodlight_config_id

int64
Unique ID of the floodlight configuration.

rendering_id

int64
Unique ID of the creative for Data Transfer. This isn't the creative ID in the Campaign Manager 360 UI.

Campaign Manager 360 Data Transfer creative ad assignment

cm_dt_creative_ad_assignment

account_id

int64
Unique ID of the account.

ad_click_url

string
Click through URL of Click Ad type creatives only (aka Click Commands)

ad_id

int64
Unique ID of the ad.

advertiser_id

int64
Unique ID of the advertiser.

creative_end_date

int64
Rotation end date and time in milliseconds since 1970-01-01 00:00:00 UTC.

creative_group1

string
User defined value from creative group 1.

creative_group1_id

int64
Unique ID of creative group 1.

creative_group2

string
User defined value from creative group 2.

creative_group2_id

int64
Unique ID of creative group 2.

creative_id

int64
The Creative ID in Campaign Manager 360 UI.

creative_rotation_type

string
Rotation type.

creative_rotation_type_id

int64
Id of the rotation type.

creative_start_date

int64
Rotation start date and time in Unix epoch time (milliseconds).

floodlight_config_id

int64
Unique ID of the floodlight configuration.

Campaign Manager 360 Data Transfer custom creative field

cm_dt_custom_creative_field

account_id

int64
Unique ID of the account.

advertiser_id

int64
Unique ID of the advertiser.

creative_field_id

int64
The Creative ID in Campaign Manager 360 UI.

creative_field_name

string
User defined name associated to a particular custom creative field.

creative_field_number

int64
Slot ID assigned to this custom creative field (typically IDs from 1-20).

creative_field_value

string
User defined value as available option to named field.

creative_field_value_id

int64
ID of the user defined creative value.

creative_id

int64
The Creative ID in Campaign Manager 360 UI.

floodlight_config_id

int64
Unique ID of the floodlight configuration.

Campaign Manager 360 Data Transfer custom floodlight variable

cm_dt_custom_floodlight_variable

account_id

int64
Unique ID of the account.

advertiser_id

int64
Unique ID of the advertiser.

floodlight_config_id

int64
Unique ID of the floodlight configuration.

floodlight_variable_id

int64
Unique ID of the floodlight variable.

floodlight_variable_name

string
User defined name of the custom floodlight variable.

Campaign Manager 360 Data Transfer custom rich media

cm_dt_custom_rich_media

account_id

int64
Unique ID of the account.

advertiser_id

int64
Unique ID of the advertiser.

floodlight_config_id

int64
Unique ID of the floodlight configuration.

rich_media_event_id

int64
ID of the rich media event.

rich_media_event_name

string
Name of the rich media event.

rich_media_event_type

string
Possible values are: Timer, Exit, or Counter.

rich_media_event_type_id

int64
ID of the rich media event type.

Campaign Manager 360 Data Transfer designated market area

cm_dt_designated_market_area

dma_region

string

dma_region_id

int64

Campaign Manager 360 Data Transfer impressions

cm_dt_impressions

To query EEA user data, use the policy-isolated tables in place of cm_dt_impressions :

cm_dt_impressions_policy_isolated_youtube
cm_dt_impressions_policy_isolated_network
cm_dt_impressions_policy_isolated_search
cm_dt_impressions_policy_isolated_android_tv
cm_dt_impressions_policy_isolated_google_tv
cm_dt_impressions_policy_isolated_other

event

struct

event.active_view_audible_impressions

int64
Active View: Impressions Audible

event.active_view_audible_time_msec

int64
Active View: Play Time Audible (milliseconds)

event.active_view_audible_visible_time_msec

int64
Active View: Play Time Audible and Visible (milliseconds)

event.active_view_background_count

int64
Active View: Impressions In Background

event.active_view_complete_viewable_impressions

int64
Active View: Impressions Visible at Completion

event.active_view_eligible_impressions

event.active_view_first_quartile_viewable_audible_impressions

int64
Active View: Impressions Visible and Audible at First Quartile

event.active_view_first_quartile_viewable_impressions

int64
Active View: Impressions Visible at First Quartile

event.active_view_fullscreen_count

int64
Active View: Impressions Full-Screen

event.active_view_impressions_audible_and_visible_at_completion

int64
Active View: Impressions Audible and Visible at Completion

event.active_view_impressions_visible10_seconds

int64
Active View: Impressions Visible 10 Seconds

event.active_view_measurable_impressions

int64
Whether the impression was measurable with Active View.

event.active_view_midpoint_viewable_audible_impressions

int64
Active View: Impressions Visible and Audible at Midpoint

event.active_view_midpoint_viewable_impressions

int64
Active View: Impressions Visible at Midpoint

event.active_view_plus_measurable_count

int64
Active View Plus: Measurable Impressions

event.active_view_start_viewable_audible_impressions

int64
Active View: Impressions Visible and Audible at Start

event.active_view_start_viewable_impressions

int64
Active View: Impressions Visible at Start

event.active_view_third_quartile_viewable_audible_impressions

int64
Active View: Impressions Visible and Audible at Third Quartile

event.active_view_third_quartile_viewable_impressions

int64
Active View: Impressions Visible at Third Quartile

event.active_view_tos_msec

int64
Active View: Time on Screen (milliseconds)

event.active_view_viewable_impressions

int64
Whether the impression was viewable.

event.active_view_visible_time_msec

int64
Active View: Video Visible Time (milliseconds)

event.activity_count

int64
Activity Quantity

event.activity_id

int64
The ID of the Floodlight tag related to the conversion event.

event.ad_id

int64
Unique ID of the ad placement.

event.advertiser_id

int64
Unique ID of the advertiser

event.audience_segment_id

int64
Unique ID of the audience segment.

event.browser_platform_id

string
ID of the browser type.

event.browser_version

string
Browser/Platform Version

event.campaign_id

int64
The unique ID of the Campaign Manager 360 campaign

event.city_id

int64
City ID

event.conversion_id

int64
Indicates whether an activity has been matched as a post-click (value of 1) or post-impression (value of 2), or unmatched (value of 0).

event.country_code

string
Country

event.creative_version

string
Creative version number.

event.dma_region_id

int64
Designated Market Area ID (US/Canada).

event.dv360_ad_position

int64
Specifies the position of the ad on the page if known. 1 represents above the fold, 2 represents below the fold.

event.dv360_advertiser_id

int64
The Display & Video 360 numerical ID for the advertiser related to the event, for example 164332.

event.dv360_adx_page_categories

string
DV360 Adx Page Categories

event.dv360_attributed_inventory_source_external_id

event.dv360_attributed_inventory_source_is_public

string
True if inventory source is available to all buyers. False otherwise.

event.dv360_auction_bid_price_advertiser_currency

int64

event.dv360_auction_bid_price_partner_currency

int64

event.dv360_auction_bid_price_usd

int64

event.dv360_auction_id

string
A string used to join events among view/click/conversion types, for example"ABCDEFGH_abcdefgh-0123456789". Do not assume any ordering, structure or meaning to the auction_id value.

event.dv360_bid_price_advertiser_currency

event.dv360_bid_price_partner_currency

event.dv360_bid_price_usd

event.dv360_bid_request_publisher_id

string
The publisher id in the publisher.id field of bid request.

event.dv360_billable_cost_advertiser_currency

int64
The total amount of money billed to the partner, including the media cost and partner costs, in advertiser currency nanos.

event.dv360_billable_cost_partner_currency

int64
The total amount of money billed to the partner, including the media cost and partner costs, in partner currency nanos.

event.dv360_billable_cost_usd

int64
The total amount of money billed to the partner, including the media cost and partner costs, in USD nanos.

event.dv360_browser_id

int64
The Display & Video 360 numerical ID identifying the browser related to this event.

event.dv360_browser_reportable_id

int64
The new Display & Video 360 numerical ID identifying the browser related to this event.

event.dv360_browser_timezone_offset_minutes

int64
The difference in minutes between the active timezone on the user's browser and GMT-12, for example 1320 represents a browser timezone of GMT+10.

event.dv360_campaign_id

int64
The unique ID of the linked Display & Video 360 campaign.

event.dv360_city_id

int64
The Display & Video 360 numerical ID identifying the best-guess city of the impression.

event.dv360_country_code

string
2-letter ISO 3166-1 country code identifying the best-guess country of the impression, for example "US".

event.dv360_cpm_fee_1_advertiser_currency

int64
DV360 CPM fee 1 advertiser currency

event.dv360_cpm_fee_1_partner_currency

int64
DV360 CPM fee 1 partner currency

event.dv360_cpm_fee_1_usd

int64
DV360 CPM fee 1 usd

event.dv360_cpm_fee_2_advertiser_currency

int64
DV360 CPM fee 2 advertiser currency

event.dv360_cpm_fee_2_partner_currency

int64
DV360 CPM fee 2 partner currency

event.dv360_cpm_fee_2_usd

int64
DV360 CPM fee 2 usd

event.dv360_cpm_fee_3_advertiser_currency

int64
DV360 CPM fee 3 advertiser currency

event.dv360_cpm_fee_3_partner_currency

int64
DV360 CPM fee 3 partner currency

event.dv360_cpm_fee_3_usd

int64
DV360 CPM fee 3 usd

event.dv360_cpm_fee_4_advertiser_currency

int64
DV360 CPM fee 4 advertiser currency

event.dv360_cpm_fee_4_partner_currency

int64
DV360 CPM fee 4 partner currency

event.dv360_cpm_fee_4_usd

int64
DV360 CPM fee 4 usd

event.dv360_cpm_fee_5_advertiser_currency

int64
DV360 CPM fee 5 advertiser currency

event.dv360_cpm_fee_5_partner_currency

int64
DV360 CPM fee 5 partner currency

event.dv360_cpm_fee_5_usd

int64
DV360 CPM fee 5 usd

event.dv360_creative_id

int64
The Display & Video 360 numerical ID for the creative related to the event, for example 367487.

event.dv360_data_fees_advertiser_currency

int64
DV360 data fees advertiser currency

event.dv360_data_fees_partner_currency

int64
DV360 data fees partner currency

event.dv360_data_fees_usd

int64
DV360 data fees usd

event.dv360_device_type

int64
The numerical value of the identified device type. 0 = Computer, 1 = Other, 2 = Smart Phone, 3 = Tablet, 4 = Smart TV, 5 = Connected TV, 6 = Set Top Box, 7 = Connected Device.

event.dv360_exchange_id

string
The Display & Video 360 numerical ID for the exchange that requested the ad.

event.dv360_insertion_order_id

int64
The Display & Video 360 numerical ID for the insertion order related to the event, for example 1079941.

event.dv360_isp_id

int64
The Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.

event.dv360_isp_reportable_id

int64
The new Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.

event.dv360_language

string
The ISO-639-1 code or "zh_CN" (Chinese (simplified)), "zh_TW" (Chinese (traditional)) or "other" representing the language related to the view event.

event.dv360_line_item_id

int64
The Display & Video 360 numerical ID for the line item related to the event, for example 1155785.

event.dv360_matching_targeted_keywords

event.dv360_matching_targeted_segments

event.dv360_media_cost_advertiser_currency

int64
The amount paid for the impression in advertiser currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.

event.dv360_media_cost_partner_currency

int64
The amount paid for the impression in the partner currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.

event.dv360_media_cost_usd

int64
The amount paid for the impression in USD nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.

event.dv360_media_fee_1_advertiser_currency

int64
DV360 media fee 1 advertiser currency

event.dv360_media_fee_1_partner_currency

int64
DV360 media fee 1 partner currency

event.dv360_media_fee_1_usd

int64
DV360 media fee 1 usd

event.dv360_media_fee_2_advertiser_currency

int64
DV360 media fee 2 advertiser currency

event.dv360_media_fee_2_partner_currency

int64
DV360 media fee 2 partner currency

event.dv360_media_fee_2_usd

int64
DV360 media fee 2 usd

event.dv360_media_fee_3_advertiser_currency

int64
DV360 media fee 3 advertiser currency

event.dv360_media_fee_3_partner_currency

int64
DV360 media fee 3 partner currency

event.dv360_media_fee_3_usd

int64
DV360 media fee 3 usd

event.dv360_media_fee_4_advertiser_currency

int64
DV360 media fee 4 advertiser currency

event.dv360_media_fee_4_partner_currency

int64
DV360 media fee 4 partner currency

event.dv360_media_fee_4_usd

int64
DV360 media fee 4 usd

event.dv360_media_fee_5_advertiser_currency

int64
DV360 media fee 5 advertiser currency

event.dv360_media_fee_5_partner_currency

int64
DV360 media fee 5 partner currency

event.dv360_media_fee_5_usd

int64
DV360 media fee 5 usd

event.dv360_mobile_make_id

int64
The numerical ID for the mobile make. This value may be missing.

event.dv360_mobile_make_reportable_id

int64
The new numerical ID for the mobile make. This value may be missing.

event.dv360_mobile_model_id

int64
The numerical ID for the mobile model. This value may be missing.

event.dv360_mobile_model_reportable_id

int64
The new numerical ID for the mobile model. This value may be missing.

event.dv360_net_speed

int64
The Display & Video 360 numerical ID representing the network speed related to the view event. 1=Dial-up, 2=EDGE/2G, 3=UMTS/3G, 4=Basic DSL, 5=HSDPA/3.5G, 6=Broadband/4G, 7=Unknown.

event.dv360_operating_system_id

int64
Operating System ID.

event.dv360_operating_system_reportable_id

int64
New Operating System ID.

event.dv360_request_time

event.dv360_revenue_advertiser_currency

int64
The total amount in advertiser currency nanos made by the partner account for the view event. This value may be zero.

event.dv360_revenue_partner_currency

int64
The total amount in partner currency nanos made by the partner account for the view event. This value may be zero.

event.dv360_revenue_usd

int64
The total amount in USD nanos made by the partner account for the view event. This value may be zero.

event.dv360_site_id

int64
The Display & Video 360 numerical ID for the most specific universal site that matches the url.

event.dv360_state_region_id

int64
DV360 Region ID

event.dv360_supply_chain_complete

boolean
Indicates whether the supply chain object is complete in the bid request.

event.dv360_supply_chain_domain

array<string>
The domain in the supply path, the order is the same as the order in the supply chain JSON.

event.dv360_supply_chain_seller_id

array<string>
Array of strings. The seller ID in the supply path, the order is the same as the order in the supply chain JSON.

event.dv360_url

event.dv360_view_state

event.dv360_zip_postal_code

string
DV360 ZIP/Postal Code

event.dynamic_profile

string
Studio dynamic profile name.

event.dynamic_profile_id

int64
Studio dynamic profile ID.

event.event_sub_type

string
Contains further details related to the event - these are VIEW and CLICK for view and click events, but may be POSTVIEW, POSTCLICK or blank for conversion events.

event.event_time

int64
Time in microseconds since 1970-01-01 00:00:00 UTC.

event.event_type

string
Contains VIEW.

event.feed

array<string>
Feed ID.

event.feed_reporting_dimension1

array<string>

event.feed_reporting_dimension2

array<string>

event.feed_reporting_dimension3

array<string>

event.feed_reporting_dimension4

array<string>

event.feed_reporting_dimension5

array<string>

event.feed_reporting_dimension6

array<string>

event.feed_reporting_label

array<string>
Dynamic Feed Reporting Label.

event.feed_unique_id

array<string>

event.floodlight_config_id

int64
Unique ID of the floodlight configuration.

event.impression_id

string
Impression ID

event.interaction_time_utc_seconds

string
Interaction time UTC seconds

event.landing_page_url_id

int64
Unique ID of the landing page URL. Only populates for clicks, NULL for other tables.

event.operating_system_id

int64
ID of the operating system.

event.ord_value

string
The advertiser's ordinal ID, if relevant for a given activity type. Passed in the 'ord=' key-value (also used for storing the client's Order-ID in sales tags)

event.other_data

event.placement_id

int64
Unique ID for the site page / placement where the ad ran.

event.platform_type_id

event.referrer_url

string
Contains the URL on which the ad appeared, when possible. May also be empty, or return ad server URLs.

event.rendering_id

int64
Unique ID of the creative for Data Transfer. Does not correspond to the UI-Creative-ID.

event.rich_media_event_counters

int64
MET Counter Value (the ecn= value).

event.rich_media_event_id

int64
MET Event ID for the Rich Media ad.

event.rich_media_event_timers

double
Time in microseconds since 1970-01-01 00:00:00 UTC.

event.rich_media_event_type_id

int64
ID of Rich Media Event Type.

event.segment_value_1

int64
Segment Value 1

event.site_id

int64
Unique ID for the site where the ad ran.

event.state

string
ID for user's state or province (US/Canada)

event.tran_value

string
TRAN Value

event.u_value

string
U Value

event.zip_code

string
Postal-Code (US/Canada).

network_id

int64
The network ID.

user_id

Campaign Manager 360 Data Transfer keyword value

cm_dt_keyword_value

account_id

int64
Unique ID of the account.

ad_id

int64
Unique ID of the ad.

advertiser_id

int64
Unique ID of the advertiser.

floodlight_config_id

int64
Unique ID of the floodlight configuration.

keyword

string
Targeted key/value pair.

Campaign Manager 360 Data Transfer landing page url

cm_dt_landing_page_url

account_id

int64
Unique ID of the account.

landing_page_url

string
The URL a user was sent to when they clicked on an ad.

landing_page_url_id

int64
Unique ID of the landing page URL. Only populates for clicks, NULL for other tables.

Campaign Manager 360 Data Transfer operating system

cm_dt_operating_system

operating_system

string

operating_system_id

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

Campaign Manager 360 Data Transfer paid search

cm_dt_paid_search

ad_id

int64
Unique ID of the ad.

advertiser_id

int64
Unique ID of the advertiser.

campaign_id

int64
The unique ID of the Campaign Manager 360 campaign.

floodlight_config_id

int64
Unique ID of the floodlight configuration.

paid_search_ad_group

string
User defined keyword group.

paid_search_ad_group_id

int64
Unique ID of the keyword group.

paid_search_ad_id

int64
Unique ID associated with a Search Ads 360 ad.

paid_search_bid_strategy

string
User defined keyword bid strategy. Returns a value of (not set) if empty.

paid_search_bid_strategy_id

int64
ID of the keyword bid strategy.

paid_search_campaign

string
User defined name of campaign as entered into Search Ads 360.

paid_search_campaign_id

int64
ID of the Search Ads 360 campaign.

paid_search_keyword

string
User defined keyword value as entered into Search Ads 360.

paid_search_keyword_id

int64
Unique ID from Search Ads 360. Uses the "long" format

paid_search_landing_page_url

string
User defined landing page URL as entered into Search Ads 360.

paid_search_legacy_keyword_id

int64
Unique ID from Search Ads 360. Uses the "short" format in which the leading 43* is removed.

paid_search_match_type

string
User selected

Campaign Manager 360 Data Transfer paid search ad group

cm_dt_paid_search_ad_group

account_id

int64
Unique ID of the account.

advertiser_id

int64
Unique ID of the advertiser.

floodlight_config_id

int64
Unique ID of the floodlight configuration.

sa360_ad_group

string
User defined name of ad group as entered into Search Ads 360.

sa360_ad_group_id

int64
ID of the Google Ads ad group.

Campaign Manager 360 Data Transfer paid search campaign

cm_dt_paid_search_campaign

account_id

int64
Unique ID of the account.

advertiser_id

int64
Unique ID of the advertiser.

floodlight_config_id

int64
Unique ID of the floodlight configuration.

sa360_bid_strategy

string
User defined keyword bid strategy.

sa360_bid_strategy_id

int64
ID of the keyword bid strategy.

sa360_campaign

string
User defined name of campaign as entered into Search Ads 360.

sa360_campaign_id

int64
ID of the Google Ads campaign.

Campaign Manager 360 Data Transfer paid search keyword

cm_dt_paid_search_keyword

account_id

int64
Unique ID of the account.

advertiser_id

int64
Unique ID of the advertiser.

floodlight_config_id

int64
Unique ID of the floodlight configuration.

sa360_ad_group_id

int64
ID of the Google Ads ad group.

sa360_keyword

string
User defined keyword value as entered into Search Ads 360.

sa360_keyword_id

int64
Google Ads Criterion ID.

sa360_match_type

string
Match type.

Campaign Manager 360 Data Transfer placement

cm_dt_placement

account_id

int64
Unique ID of the account.

activity_id

int64
Unique ID of the Floodlight activity.

advertiser_id

int64
Unique ID of the advertiser.

campaign_id

int64
The unique ID of the Campaign Manager 360 campaign.

content_category

string
User defined content category.

content_category_id

int64
ID of content category.

flighting_activated

boolean
Indicates whether this is a flighted (billing) placement.

floodlight_config_id

int64
Unique ID of the floodlight configuration.

package_roadblock_id

int64

package_roadblock_type

string

package_roadblock_type_id

int64

placement

string

placement_cap_cost_option

int64
User entered cost capping amount.

placement_cost_structure

string

placement_end_date

int64
End date of the flight in 'YYYYMMDD' format.

placement_id

int64

placement_start_date

int64
Start date of the flight in 'YYYYMMDD' format.

placement_strategy

string
User defined placement strategy.

placement_strategy_id

int64
ID of the placement strategy.

site_id

int64
Unique ID of the site.

site_keyname

string

Campaign Manager 360 Data Transfer placement cost

cm_dt_placement_cost

account_id

int64
Unique ID of the account.

advertiser_id

int64
Unique ID of the advertiser.

floodlight_config_id

int64
Unique ID of the floodlight configuration.

placement_comments

string
User entered placement pricing comments.

placement_end_date

int64
End date of the flight in 'YYYYMMDD' format.

placement_id

int64
Placement ID

placement_rate

int64
Purchased rate expressed in nanos of the network's currency. 1 nano = 1 billionth. 1 nano USD = $0.000000001.

placement_start_date

int64
Start date of the flight in 'YYYYMMDD' format.

placement_total_booked_units

int64
The number of purchased units.

Campaign Manager 360 Data Transfer rich media

cm_dt_rich_media

To query EEA user data, use the policy-isolated tables in place of cm_dt_rich_media :

cm_dt_rich_media_policy_isolated_youtube
cm_dt_rich_media_policy_isolated_network
cm_dt_rich_media_policy_isolated_search
cm_dt_rich_media_policy_isolated_android_tv
cm_dt_rich_media_policy_isolated_google_tv
cm_dt_rich_media_policy_isolated_other

event

struct

event.active_view_audible_impressions

int64
Active View: Impressions Audible

event.active_view_audible_time_msec

int64
Active View: Play Time Audible (milliseconds)

event.active_view_audible_visible_time_msec

int64
Active View: Play Time Audible and Visible (milliseconds)

event.active_view_background_count

int64
Active View: Impressions In Background

event.active_view_complete_viewable_impressions

int64
Active View: Impressions Visible at Completion

event.active_view_eligible_impressions

event.active_view_first_quartile_viewable_audible_impressions

int64
Active View: Impressions Visible and Audible at First Quartile

event.active_view_first_quartile_viewable_impressions

int64
Active View: Impressions Visible at First Quartile

event.active_view_fullscreen_count

int64
Active View: Impressions Full-Screen

event.active_view_impressions_audible_and_visible_at_completion

int64
Active View: Impressions Audible and Visible at Completion

event.active_view_impressions_visible10_seconds

int64
Active View: Impressions Visible 10 Seconds

event.active_view_measurable_impressions

int64
Whether the impression was measurable with Active View.

event.active_view_midpoint_viewable_audible_impressions

int64
Active View: Impressions Visible and Audible at Midpoint

event.active_view_midpoint_viewable_impressions

int64
Active View: Impressions Visible at Midpoint

event.active_view_plus_measurable_count

int64
Active View Plus: Measurable Impressions

event.active_view_start_viewable_audible_impressions

int64
Active View: Impressions Visible and Audible at Start

event.active_view_start_viewable_impressions

int64
Active View: Impressions Visible at Start

event.active_view_third_quartile_viewable_audible_impressions

int64
Active View: Impressions Visible and Audible at Third Quartile

event.active_view_third_quartile_viewable_impressions

int64
Active View: Impressions Visible at Third Quartile

event.active_view_tos_msec

int64
Active View: Time on Screen (milliseconds)

event.active_view_viewable_impressions

int64
Whether the impression was viewable.

event.active_view_visible_time_msec

int64
Active View: Video Visible Time (milliseconds)

event.activity_count

int64
Activity Quantity

event.activity_id

int64
The ID of the Floodlight tag related to the conversion event.

event.ad_id

int64
Unique ID of the ad placement.

event.advertiser_id

int64
Unique ID of the advertiser

event.audience_segment_id

int64
Unique ID of the audience segment.

event.browser_platform_id

string
ID of the browser type.

event.browser_version

string
Browser/Platform Version

event.campaign_id

int64
The unique ID of the Campaign Manager 360 campaign

event.city_id

int64
City ID

event.conversion_id

int64
Indicates whether an activity has been matched as a post-click (value of 1) or post-impression (value of 2), or unmatched (value of 0).

event.country_code

string
Country

event.creative_version

string
Creative version number.

event.dma_region_id

int64
Designated Market Area ID (US/Canada).

event.dv360_ad_position

int64
Specifies the position of the ad on the page if known. 1 represents above the fold, 2 represents below the fold.

event.dv360_advertiser_id

int64
The Display & Video 360 numerical ID for the advertiser related to the event, for example 164332.

event.dv360_adx_page_categories

string
DV360 Adx Page Categories

event.dv360_attributed_inventory_source_external_id

event.dv360_attributed_inventory_source_is_public

string
True if inventory source is available to all buyers. False otherwise.

event.dv360_auction_id

string
A string used to join events among view/click/conversion types, for example"ABCDEFGH_abcdefgh-0123456789". Do not assume any ordering, structure or meaning to the auction_id value.

event.dv360_bid_price_advertiser_currency

event.dv360_bid_price_partner_currency

event.dv360_bid_price_usd

event.dv360_bid_request_publisher_id

string
The publisher id in the publisher.id field of bid request.

event.dv360_billable_cost_advertiser_currency

int64
The total amount of money billed to the partner, including the media cost and partner costs, in advertiser currency nanos.

event.dv360_billable_cost_partner_currency

int64
The total amount of money billed to the partner, including the media cost and partner costs, in partner currency nanos.

event.dv360_billable_cost_usd

int64
The total amount of money billed to the partner, including the media cost and partner costs, in USD nanos.

event.dv360_browser_id

int64
The Display & Video 360 numerical ID identifying the browser related to this event.

event.dv360_browser_reportable_id

int64
The new Display & Video 360 numerical ID identifying the browser related to this event.

event.dv360_browser_timezone_offset_minutes

int64
The difference in minutes between the active timezone on the user's browser and GMT-12, for example 1320 represents a browser timezone of GMT+10.

event.dv360_campaign_id

int64
The unique ID of the linked Display & Video 360 campaign.

event.dv360_city_id

int64
The Display & Video 360 numerical ID identifying the best-guess city of the impression.

event.dv360_country_code

string
2-letter ISO 3166-1 country code identifying the best-guess country of the impression, for example "US".

event.dv360_cpm_fee_1_advertiser_currency

int64
DV360 CPM fee 1 advertiser currency

event.dv360_cpm_fee_1_partner_currency

int64
DV360 CPM fee 1 partner currency

event.dv360_cpm_fee_1_usd

int64
DV360 CPM fee 1 usd

event.dv360_cpm_fee_2_advertiser_currency

int64
DV360 CPM fee 2 advertiser currency

event.dv360_cpm_fee_2_partner_currency

int64
DV360 CPM fee 2 partner currency

event.dv360_cpm_fee_2_usd

int64
DV360 CPM fee 2 usd

event.dv360_cpm_fee_3_advertiser_currency

int64
DV360 CPM fee 3 advertiser currency

event.dv360_cpm_fee_3_partner_currency

int64
DV360 CPM fee 3 partner currency

event.dv360_cpm_fee_3_usd

int64
DV360 CPM fee 3 usd

event.dv360_cpm_fee_4_advertiser_currency

int64
DV360 CPM fee 4 advertiser currency

event.dv360_cpm_fee_4_partner_currency

int64
DV360 CPM fee 4 partner currency

event.dv360_cpm_fee_4_usd

int64
DV360 CPM fee 4 usd

event.dv360_cpm_fee_5_advertiser_currency

int64
DV360 CPM fee 5 advertiser currency

event.dv360_cpm_fee_5_partner_currency

int64
DV360 CPM fee 5 partner currency

event.dv360_cpm_fee_5_usd

int64
DV360 CPM fee 5 usd

event.dv360_creative_id

int64
The Display & Video 360 numerical ID for the creative related to the event, for example 367487.

event.dv360_data_fees_advertiser_currency

int64
DV360 data fees advertiser currency

event.dv360_data_fees_partner_currency

int64
DV360 data fees partner currency

event.dv360_data_fees_usd

int64
DV360 data fees usd

event.dv360_device_type

int64
The numerical value of the identified device type. 0 = Computer, 1 = Other, 2 = Smart Phone, 3 = Tablet, 4 = Smart TV, 5 = Connected TV, 6 = Set Top Box, 7 = Connected Device.

event.dv360_exchange_id

string
The Display & Video 360 numerical ID for the exchange that requested the ad.

event.dv360_insertion_order_id

int64
The Display & Video 360 numerical ID for the insertion order related to the event, for example 1079941.

event.dv360_isp_id

int64
The Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.

event.dv360_isp_reportable_id

int64
The new Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.

event.dv360_language

string
The ISO-639-1 code or "zh_CN" (Chinese (simplified)), "zh_TW" (Chinese (traditional)) or "other" representing the language related to the view event.

event.dv360_line_item_id

int64
The Display & Video 360 numerical ID for the line item related to the event, for example 1155785.

event.dv360_matching_targeted_keywords

event.dv360_matching_targeted_segments

event.dv360_media_cost_advertiser_currency

int64
The amount paid for the impression in advertiser currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.

event.dv360_media_cost_partner_currency

int64
The amount paid for the impression in the partner currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.

event.dv360_media_cost_usd

int64
The amount paid for the impression in USD nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.

event.dv360_media_fee_1_advertiser_currency

int64
DV360 media fee 1 advertiser currency

event.dv360_media_fee_1_partner_currency

int64
DV360 media fee 1 partner currency

event.dv360_media_fee_1_usd

int64
DV360 media fee 1 usd

event.dv360_media_fee_2_advertiser_currency

int64
DV360 media fee 2 advertiser currency

event.dv360_media_fee_2_partner_currency

int64
DV360 media fee 2 partner currency

event.dv360_media_fee_2_usd

int64
DV360 media fee 2 usd

event.dv360_media_fee_3_advertiser_currency

int64
DV360 media fee 3 advertiser currency

event.dv360_media_fee_3_partner_currency

int64
DV360 media fee 3 partner currency

event.dv360_media_fee_3_usd

int64
DV360 media fee 3 usd

event.dv360_media_fee_4_advertiser_currency

int64
DV360 media fee 4 advertiser currency

event.dv360_media_fee_4_partner_currency

int64
DV360 media fee 4 partner currency

event.dv360_media_fee_4_usd

int64
DV360 media fee 4 usd

event.dv360_media_fee_5_advertiser_currency

int64
DV360 media fee 5 advertiser currency

event.dv360_media_fee_5_partner_currency

int64
DV360 media fee 5 partner currency

event.dv360_media_fee_5_usd

int64
DV360 media fee 5 usd

event.dv360_mobile_make_id

int64
The numerical ID for the mobile make. This value may be missing.

event.dv360_mobile_make_reportable_id

int64
The new numerical ID for the mobile make. This value may be missing.

event.dv360_mobile_model_id

int64
The numerical ID for the mobile model. This value may be missing.

event.dv360_mobile_model_reportable_id

int64
The new numerical ID for the mobile model. This value may be missing.

event.dv360_net_speed

int64
The Display & Video 360 numerical ID representing the network speed related to the view event. 1=Dial-up, 2=EDGE/2G, 3=UMTS/3G, 4=Basic DSL, 5=HSDPA/3.5G, 6=Broadband/4G, 7=Unknown.

event.dv360_operating_system_id

int64
Operating System ID.

event.dv360_operating_system_reportable_id

int64
New Operating System ID.

event.dv360_request_time

event.dv360_revenue_advertiser_currency

int64
The total amount in advertiser currency nanos made by the partner account for the view event. This value may be zero.

event.dv360_revenue_partner_currency

int64
The total amount in partner currency nanos made by the partner account for the view event. This value may be zero.

event.dv360_revenue_usd

int64
The total amount in USD nanos made by the partner account for the view event. This value may be zero.

event.dv360_site_id

int64
The Display & Video 360 numerical ID for the most specific universal site that matches the url.

event.dv360_state_region_id

int64
DV360 Region ID

event.dv360_supply_chain_complete

boolean
Indicates whether the supply chain object is complete in the bid request.

event.dv360_supply_chain_domain

array<string>
The domain in the supply path, the order is the same as the order in the supply chain JSON.

event.dv360_supply_chain_seller_id

array<string>
Array of strings. The seller ID in the supply path, the order is the same as the order in the supply chain JSON.

event.dv360_url

event.dv360_view_state

event.dv360_zip_postal_code

string
DV360 ZIP/Postal Code

event.event_sub_type

string
Contains further details related to the event - these are VIEW and CLICK for view and click events, but may be POSTVIEW, POSTCLICK or blank for conversion events.

event.event_time

int64
Time in microseconds since 1970-01-01 00:00:00 UTC.

event.event_type

string
Contains RICH_MEDIA_INTERACTION.

event.floodlight_config_id

int64
Unique ID of the floodlight configuration.

event.impression_id

string
Impression ID

event.interaction_time_utc_seconds

string
Interaction time UTC seconds

event.landing_page_url_id

int64
Unique ID of the landing page URL. Only populates for clicks, NULL for other tables.

event.operating_system_id

int64
ID of the operating system.

event.ord_value

string
The advertiser's ordinal ID, if relevant for a given activity type. Passed in the 'ord=' key-value (also used for storing the client's Order-ID in sales tags)

event.other_data

event.placement_id

int64
Unique ID for the site page / placement where the ad ran.

event.platform_type_id

event.referrer_url

string
Contains the URL on which the ad appeared, when possible. May also be empty, or return ad server URLs.

event.rendering_id

int64
Unique ID of the creative for Data Transfer. Does not correspond to the UI-Creative-ID.

event.rich_media_event_counters

int64
MET Counter Value (the ecn= value).

event.rich_media_event_id

int64
MET Event ID for the Rich Media ad.

event.rich_media_event_timers

double
Time in microseconds since 1970-01-01 00:00:00 UTC.

event.rich_media_event_type_id

int64
ID of Rich Media Event Type.

event.segment_value_1

int64
Segment Value 1

event.site_id

int64
Unique ID for the site where the ad ran.

event.state

string
ID for user's state or province (US/Canada)

event.tran_value

string
TRAN Value

event.u_value

string
U Value

event.zip_code

string
Postal-Code (US/Canada).

network_id

int64
The network ID.

user_id

Campaign Manager 360 Data Transfer site

cm_dt_site

account_id

int64
Unique ID of the account.

site

string
The name of the site.

site_directory

string
Global unique name for this site.

site_directory_id

int64
Global unique ID for this site.

site_id

int64
Unique ID of the site.

Campaign Manager 360 Data Transfer state

cm_dt_state

region

string
Abbreviated state/province name.

region_full_name

string
Region name in English.

DV360 Data Transfer Active View plus

dv360_dt_active_view_plus

To query EEA user data, use the policy-isolated tables in place of dv360_dt_active_view_plus :

dv360_dt_active_view_plus_policy_isolated_youtube
dv360_dt_active_view_plus_policy_isolated_network
dv360_dt_active_view_plus_policy_isolated_search

event

struct

event.active_view_audible_impressions

int64
Active View: Impressions Audible

event.active_view_audible_time_msec

int64
Active View: Play Time Audible (milliseconds)

event.active_view_audible_visible_time_msec

int64
Active View: Play Time Audible and Visible (milliseconds)

event.active_view_background_count

int64
Active View: Impressions In Background

event.active_view_complete_viewable_impressions

int64
Active View: Impressions Visible at Completion

event.active_view_eligible_impressions

event.active_view_first_quartile_viewable_audible_impressions

int64
Active View: Impressions Visible and Audible at First Quartile

event.active_view_first_quartile_viewable_impressions

int64
Active View: Impressions Visible at First Quartile

event.active_view_fullscreen_count

int64
Active View: Impressions Full-Screen

event.active_view_impressions_audible_and_visible_at_completion

int64
Active View: Impressions Audible and Visible at Completion

event.active_view_impressions_visible10_seconds

int64
Active View: Impressions Visible 10 Seconds

event.active_view_measurable_impressions

int64
Whether the impression was measurable with Active View.

event.active_view_midpoint_viewable_audible_impressions

int64
Active View: Impressions Visible and Audible at Midpoint

event.active_view_midpoint_viewable_impressions

int64
Active View: Impressions Visible at Midpoint

event.active_view_plus_measurable_count

int64
Active View Plus: Measurable Impressions

event.active_view_start_viewable_audible_impressions

int64
Active View: Impressions Visible and Audible at Start

event.active_view_start_viewable_impressions

int64
Active View: Impressions Visible at Start

event.active_view_third_quartile_viewable_audible_impressions

int64
Active View: Impressions Visible and Audible at Third Quartile

event.active_view_third_quartile_viewable_impressions

int64
Active View: Impressions Visible at Third Quartile

event.active_view_tos_msec

int64
Active View: Time on Screen (milliseconds)

event.active_view_viewable_impressions

int64
Whether the impression was viewable.

event.active_view_visible_time_msec

int64
Active View: Video Visible Time (milliseconds)

event.activity_count

int64
Activity Quantity

event.activity_id

int64
The ID of the Floodlight tag related to the conversion event.

event.ad_id

int64
Unique ID of the ad placement.

event.advertiser_id

int64
Unique ID of the advertiser

event.audience_segment_id

int64
Unique ID of the audience segment.

event.browser_platform_id

string
ID of the browser type.

event.browser_version

string
Browser/Platform Version

event.campaign_id

int64
The unique ID of the Campaign Manager 360 campaign

event.city_id

int64
City ID

event.conversion_id

int64
Indicates whether an activity has been matched as a post-click (value of 1) or post-impression (value of 2), or unmatched (value of 0).

event.country_code

string
Country

event.creative_version

string
Creative version number.

event.dma_region_id

int64
Designated Market Area ID (US/Canada).

event.dv360_ad_position

int64
Specifies the position of the ad on the page if known. 1 represents above the fold, 2 represents below the fold.

event.dv360_advertiser_id

int64
The Display & Video 360 numerical ID for the advertiser related to the event, for example 164332.

event.dv360_adx_page_categories

string
DV360 Adx Page Categories

event.dv360_attributed_inventory_source_external_id

event.dv360_attributed_inventory_source_is_public

string
True if inventory source is available to all buyers. False otherwise.

event.dv360_auction_bid_price_advertiser_currency

int64

event.dv360_auction_bid_price_partner_currency

int64

event.dv360_auction_bid_price_usd

int64

event.dv360_auction_id

string
A string used to join events among view/click/conversion types, for example"ABCDEFGH_abcdefgh-0123456789". Do not assume any ordering, structure or meaning to the auction_id value.

event.dv360_bid_price_advertiser_currency

event.dv360_bid_price_partner_currency

event.dv360_bid_price_usd

event.dv360_bid_request_publisher_id

string
The publisher id in the publisher.id field of bid request.

event.dv360_billable_cost_advertiser_currency

int64
The total amount of money billed to the partner, including the media cost and partner costs, in advertiser currency nanos.

event.dv360_billable_cost_partner_currency

int64
The total amount of money billed to the partner, including the media cost and partner costs, in partner currency nanos.

event.dv360_billable_cost_usd

int64
The total amount of money billed to the partner, including the media cost and partner costs, in USD nanos.

event.dv360_browser_id

int64
The Display & Video 360 numerical ID identifying the browser related to this event.

event.dv360_browser_reportable_id

int64
The new Display & Video 360 numerical ID identifying the browser related to this event.

event.dv360_browser_timezone_offset_minutes

int64
The difference in minutes between the active timezone on the user's browser and GMT-12, for example 1320 represents a browser timezone of GMT+10.

event.dv360_campaign_id

int64
The unique ID of the linked Display & Video 360 campaign.

event.dv360_city_id

int64
The Display & Video 360 numerical ID identifying the best-guess city of the impression.

event.dv360_country_code

string
2-letter ISO 3166-1 country code identifying the best-guess country of the impression, for example "US".

event.dv360_cpm_fee_1_advertiser_currency

int64
DV360 CPM fee 1 advertiser currency

event.dv360_cpm_fee_1_partner_currency

int64
DV360 CPM fee 1 partner currency

event.dv360_cpm_fee_1_usd

int64
DV360 CPM fee 1 usd

event.dv360_cpm_fee_2_advertiser_currency

int64
DV360 CPM fee 2 advertiser currency

event.dv360_cpm_fee_2_partner_currency

int64
DV360 CPM fee 2 partner currency

event.dv360_cpm_fee_2_usd

int64
DV360 CPM fee 2 usd

event.dv360_cpm_fee_3_advertiser_currency

int64
DV360 CPM fee 3 advertiser currency

event.dv360_cpm_fee_3_partner_currency

int64
DV360 CPM fee 3 partner currency

event.dv360_cpm_fee_3_usd

int64
DV360 CPM fee 3 usd

event.dv360_cpm_fee_4_advertiser_currency

int64
DV360 CPM fee 4 advertiser currency

event.dv360_cpm_fee_4_partner_currency

int64
DV360 CPM fee 4 partner currency

event.dv360_cpm_fee_4_usd

int64
DV360 CPM fee 4 usd

event.dv360_cpm_fee_5_advertiser_currency

int64
DV360 CPM fee 5 advertiser currency

event.dv360_cpm_fee_5_partner_currency

int64
DV360 CPM fee 5 partner currency

event.dv360_cpm_fee_5_usd

int64
DV360 CPM fee 5 usd

event.dv360_creative_id

int64
The Display & Video 360 numerical ID for the creative related to the event, for example 367487.

event.dv360_data_fees_advertiser_currency

int64
DV360 data fees advertiser currency

event.dv360_data_fees_partner_currency

int64
DV360 data fees partner currency

event.dv360_data_fees_usd

int64
DV360 data fees usd

event.dv360_device_type

int64
The numerical value of the identified device type. 0 = Computer, 1 = Other, 2 = Smart Phone, 3 = Tablet, 4 = Smart TV, 5 = Connected TV, 6 = Set Top Box, 7 = Connected Device.

event.dv360_exchange_id

string
The Display & Video 360 numerical ID for the exchange that requested the ad.

event.dv360_insertion_order_id

int64
The Display & Video 360 numerical ID for the insertion order related to the event, for example 1079941.

event.dv360_isp_id

int64
The Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.

event.dv360_isp_reportable_id

int64
The new Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.

event.dv360_language

string
The ISO-639-1 code or "zh_CN" (Chinese (simplified)), "zh_TW" (Chinese (traditional)) or "other" representing the language related to the view event.

event.dv360_line_item_id

int64
The Display & Video 360 numerical ID for the line item related to the event, for example 1155785.

event.dv360_matching_targeted_keywords

event.dv360_matching_targeted_segments

event.dv360_media_cost_advertiser_currency

int64
The amount paid for the impression in advertiser currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.

event.dv360_media_cost_partner_currency

int64
The amount paid for the impression in the partner currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.

event.dv360_media_cost_usd

int64
The amount paid for the impression in USD nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.

event.dv360_media_fee_1_advertiser_currency

int64
DV360 media fee 1 advertiser currency

event.dv360_media_fee_1_partner_currency

int64
DV360 media fee 1 partner currency

event.dv360_media_fee_1_usd

int64
DV360 media fee 1 usd

event.dv360_media_fee_2_advertiser_currency

int64
DV360 media fee 2 advertiser currency

event.dv360_media_fee_2_partner_currency

int64
DV360 media fee 2 partner currency

event.dv360_media_fee_2_usd

int64
DV360 media fee 2 usd

event.dv360_media_fee_3_advertiser_currency

int64
DV360 media fee 3 advertiser currency

event.dv360_media_fee_3_partner_currency

int64
DV360 media fee 3 partner currency

event.dv360_media_fee_3_usd

int64
DV360 media fee 3 usd

event.dv360_media_fee_4_advertiser_currency

int64
DV360 media fee 4 advertiser currency

event.dv360_media_fee_4_partner_currency

int64
DV360 media fee 4 partner currency

event.dv360_media_fee_4_usd

int64
DV360 media fee 4 usd

event.dv360_media_fee_5_advertiser_currency

int64
DV360 media fee 5 advertiser currency

event.dv360_media_fee_5_partner_currency

int64
DV360 media fee 5 partner currency

event.dv360_media_fee_5_usd

int64
DV360 media fee 5 usd

event.dv360_mobile_make_id

int64
The numerical ID for the mobile make. This value may be missing.

event.dv360_mobile_make_reportable_id

int64
The new numerical ID for the mobile make. This value may be missing.

event.dv360_mobile_model_id

int64
The numerical ID for the mobile model. This value may be missing.

event.dv360_mobile_model_reportable_id

int64
The new numerical ID for the mobile model. This value may be missing.

event.dv360_net_speed

int64
The Display & Video 360 numerical ID representing the network speed related to the view event. 1=Dial-up, 2=EDGE/2G, 3=UMTS/3G, 4=Basic DSL, 5=HSDPA/3.5G, 6=Broadband/4G, 7=Unknown.

event.dv360_operating_system_id

int64
Operating System ID.

event.dv360_operating_system_reportable_id

int64
New Operating System ID.

event.dv360_request_time

event.dv360_revenue_advertiser_currency

int64
The total amount in advertiser currency nanos made by the partner account for the view event. This value may be zero.

event.dv360_revenue_partner_currency

int64
The total amount in partner currency nanos made by the partner account for the view event. This value may be zero.

event.dv360_revenue_usd

int64
The total amount in USD nanos made by the partner account for the view event. This value may be zero.

event.dv360_site_id

int64
The Display & Video 360 numerical ID for the most specific universal site that matches the url.

event.dv360_state_region_id

int64
DV360 Region ID

event.dv360_supply_chain_complete

boolean
Indicates whether the supply chain object is complete in the bid request.

event.dv360_supply_chain_domain

array<string>
The domain in the supply path, the order is the same as the order in the supply chain JSON.

event.dv360_supply_chain_seller_id

array<string>
Array of strings. The seller ID in the supply path, the order is the same as the order in the supply chain JSON.

event.dv360_url

event.dv360_view_state

event.dv360_zip_postal_code

string
DV360 ZIP/Postal Code

event.event_sub_type

string
Contains further details related to the event - these are VIEW and CLICK for view and click events, but may be POSTVIEW, POSTCLICK or blank for conversion events.

event.event_time

int64
Time in microseconds since 1970-01-01 00:00:00 UTC.

event.event_type

string
Contains VIDEO_ACTIVE_VIEW_SESSION.

event.floodlight_config_id

int64
Unique ID of the floodlight configuration.

event.impression_id

string
Impression ID

event.interaction_time_utc_seconds

string
Interaction time UTC seconds

event.landing_page_url_id

int64
Unique ID of the landing page URL. Only populates for clicks, NULL for other tables.

event.operating_system_id

int64
ID of the operating system.

event.ord_value

string
The advertiser's ordinal ID, if relevant for a given activity type. Passed in the 'ord=' key-value (also used for storing the client's Order-ID in sales tags)

event.other_data

event.placement_id

int64
Unique ID for the site page / placement where the ad ran.

event.platform_type_id

event.referrer_url

string
Contains the URL on which the ad appeared, when possible. May also be empty, or return ad server URLs.

event.rendering_id

int64
Unique ID of the creative for Data Transfer. Does not correspond to the UI-Creative-ID.

event.rich_media_event_counters

int64
MET Counter Value (the ecn= value).

event.rich_media_event_id

int64
MET Event ID for the Rich Media ad.

event.rich_media_event_timers

double
Time in microseconds since 1970-01-01 00:00:00 UTC.

event.rich_media_event_type_id

int64
ID of Rich Media Event Type.

event.segment_value_1

int64
Segment Value 1

event.site_id

int64
Unique ID for the site where the ad ran.

event.state

string
ID for user's state or province (US/Canada)

event.tran_value

string
TRAN Value

event.u_value

string
U Value

event.zip_code

string
Postal-Code (US/Canada).

network_id

int64
The network ID.

user_id

DV360 Data Transfer activities attributed

dv360_dt_activities_attributed

To query EEA user data, use the policy-isolated tables in place of dv360_dt_activities_attributed :

dv360_dt_activities_attributed_policy_isolated_youtube
dv360_dt_activities_attributed_policy_isolated_network
dv360_dt_activities_attributed_policy_isolated_search

event

struct

event.activity_id

int64
The ID of the Floodlight tag related to the conversion event.

event.ad_id

int64
Unique ID of the ad placement.

event.advertiser_id

int64
Unique ID of the advertiser

event.attribution_model_config_id

int64
Unique ID of the attribution model.

event.audience_segment_id

int64
Unique ID of the audience segment.

event.browser_platform_id

string
ID of the browser type.

event.browser_version

string
Browser/Platform Version

event.campaign_id

int64
The unique ID of the Campaign Manager 360 campaign

event.city_id

int64
City ID

event.conversion_event_id

string
The unique ID of the conversion event.

event.country_code

string
Country

event.creative_version

string
Creative version number.

event.dma_region_id

int64
Designated Market Area ID (US/Canada).

event.dv360_ad_position

int64
Specifies the position of the ad on the page if known. 1 represents above the fold, 2 represents below the fold.

event.dv360_advertiser_id

int64
The Display & Video 360 numerical ID for the advertiser related to the event, for example 164332.

event.dv360_adx_page_categories

string
DV360 Adx Page Categories

event.dv360_attributed_inventory_source_external_id

event.dv360_attributed_inventory_source_is_public

string
True if inventory source is available to all buyers. False otherwise.

event.dv360_auction_bid_price_advertiser_currency

int64

event.dv360_auction_bid_price_partner_currency

int64

event.dv360_auction_bid_price_usd

int64

event.dv360_auction_id

string
A string used to join events among view/click/conversion types, for example"ABCDEFGH_abcdefgh-0123456789". Do not assume any ordering, structure or meaning to the auction_id value.

event.dv360_bid_price_advertiser_currency

event.dv360_bid_price_partner_currency

event.dv360_bid_price_usd

event.dv360_bid_request_publisher_id

string
The publisher id in the publisher.id field of bid request.

event.dv360_billable_cost_advertiser_currency

int64
The total amount of money billed to the partner, including the media cost and partner costs, in advertiser currency nanos.

event.dv360_billable_cost_partner_currency

int64
The total amount of money billed to the partner, including the media cost and partner costs, in partner currency nanos.

event.dv360_billable_cost_usd

int64
The total amount of money billed to the partner, including the media cost and partner costs, in USD nanos.

event.dv360_browser_id

int64
The Display & Video 360 numerical ID identifying the browser related to this event.

event.dv360_browser_reportable_id

int64
The new Display & Video 360 numerical ID identifying the browser related to this event.

event.dv360_browser_timezone_offset_minutes

int64
The difference in minutes between the active timezone on the user's browser and GMT-12, for example 1320 represents a browser timezone of GMT+10.

event.dv360_campaign_id

int64
The unique ID of the linked Display & Video 360 campaign.

event.dv360_city_id

int64
The Display & Video 360 numerical ID identifying the best-guess city of the impression.

event.dv360_country_code

string
2-letter ISO 3166-1 country code identifying the best-guess country of the impression, for example "US".

event.dv360_cpm_fee_1_advertiser_currency

int64
DV360 CPM fee 1 advertiser currency

event.dv360_cpm_fee_1_partner_currency

int64
DV360 CPM fee 1 partner currency

event.dv360_cpm_fee_1_usd

int64
DV360 CPM fee 1 usd

event.dv360_cpm_fee_2_advertiser_currency

int64
DV360 CPM fee 2 advertiser currency

event.dv360_cpm_fee_2_partner_currency

int64
DV360 CPM fee 2 partner currency

event.dv360_cpm_fee_2_usd

int64
DV360 CPM fee 2 usd

event.dv360_cpm_fee_3_advertiser_currency

int64
DV360 CPM fee 3 advertiser currency

event.dv360_cpm_fee_3_partner_currency

int64
DV360 CPM fee 3 partner currency

event.dv360_cpm_fee_3_usd

int64
DV360 CPM fee 3 usd

event.dv360_cpm_fee_4_advertiser_currency

int64
DV360 CPM fee 4 advertiser currency

event.dv360_cpm_fee_4_partner_currency

int64
DV360 CPM fee 4 partner currency

event.dv360_cpm_fee_4_usd

int64
DV360 CPM fee 4 usd

event.dv360_cpm_fee_5_advertiser_currency

int64
DV360 CPM fee 5 advertiser currency

event.dv360_cpm_fee_5_partner_currency

int64
DV360 CPM fee 5 partner currency

event.dv360_cpm_fee_5_usd

int64
DV360 CPM fee 5 usd

event.dv360_creative_id

int64
The Display & Video 360 numerical ID for the creative related to the event, for example 367487.

event.dv360_data_fees_advertiser_currency

int64
DV360 data fees advertiser currency

event.dv360_data_fees_partner_currency

int64
DV360 data fees partner currency

event.dv360_data_fees_usd

int64
DV360 data fees usd

event.dv360_device_type

int64
The numerical value of the identified device type. 0 = Computer, 1 = Other, 2 = Smart Phone, 3 = Tablet, 4 = Smart TV, 5 = Connected TV, 6 = Set Top Box, 7 = Connected Device.

event.dv360_exchange_id

string
The Display & Video 360 numerical ID for the exchange that requested the ad.

event.dv360_insertion_order_id

int64
The Display & Video 360 numerical ID for the insertion order related to the event, for example 1079941.

event.dv360_isp_id

int64
The Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.

event.dv360_isp_reportable_id

int64
The new Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.

event.dv360_language

string
The ISO-639-1 code or "zh_CN" (Chinese (simplified)), "zh_TW" (Chinese (traditional)) or "other" representing the language related to the view event.

event.dv360_line_item_id

int64
The Display & Video 360 numerical ID for the line item related to the event, for example 1155785.

event.dv360_matching_targeted_keywords

event.dv360_matching_targeted_segments

event.dv360_media_cost_advertiser_currency

int64
The amount paid for the impression in advertiser currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.

event.dv360_media_cost_partner_currency

int64
The amount paid for the impression in the partner currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.

event.dv360_media_cost_usd

int64
The amount paid for the impression in USD nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.

event.dv360_media_fee_1_advertiser_currency

int64
DV360 media fee 1 advertiser currency

event.dv360_media_fee_1_partner_currency

int64
DV360 media fee 1 partner currency

event.dv360_media_fee_1_usd

int64
DV360 media fee 1 usd

event.dv360_media_fee_2_advertiser_currency

int64
DV360 media fee 2 advertiser currency

event.dv360_media_fee_2_partner_currency

int64
DV360 media fee 2 partner currency

event.dv360_media_fee_2_usd

int64
DV360 media fee 2 usd

event.dv360_media_fee_3_advertiser_currency

int64
DV360 media fee 3 advertiser currency

event.dv360_media_fee_3_partner_currency

int64
DV360 media fee 3 partner currency

event.dv360_media_fee_3_usd

int64
DV360 media fee 3 usd

event.dv360_media_fee_4_advertiser_currency

int64
DV360 media fee 4 advertiser currency

event.dv360_media_fee_4_partner_currency

int64
DV360 media fee 4 partner currency

event.dv360_media_fee_4_usd

int64
DV360 media fee 4 usd

event.dv360_media_fee_5_advertiser_currency

int64
DV360 media fee 5 advertiser currency

event.dv360_media_fee_5_partner_currency

int64
DV360 media fee 5 partner currency

event.dv360_media_fee_5_usd

int64
DV360 media fee 5 usd

event.dv360_mobile_make_id

int64
The numerical ID for the mobile make. This value may be missing.

event.dv360_mobile_make_reportable_id

int64
The new numerical ID for the mobile make. This value may be missing.

event.dv360_mobile_model_id

int64
The numerical ID for the mobile model. This value may be missing.

event.dv360_mobile_model_reportable_id

int64
The new numerical ID for the mobile model. This value may be missing.

event.dv360_net_speed

int64
The Display & Video 360 numerical ID representing the network speed related to the view event. 1=Dial-up, 2=EDGE/2G, 3=UMTS/3G, 4=Basic DSL, 5=HSDPA/3.5G, 6=Broadband/4G, 7=Unknown.

event.dv360_operating_system_id

int64
Operating System ID.

event.dv360_operating_system_reportable_id

int64
New Operating System ID.

event.dv360_request_time

event.dv360_revenue_advertiser_currency

int64
The total amount in advertiser currency nanos made by the partner account for the view event. This value may be zero.

event.dv360_revenue_partner_currency

int64
The total amount in partner currency nanos made by the partner account for the view event. This value may be zero.

event.dv360_revenue_usd

int64
The total amount in USD nanos made by the partner account for the view event. This value may be zero.

event.dv360_site_id

int64
The Display & Video 360 numerical ID for the most specific universal site that matches the url.

event.dv360_state_region_id

int64
DV360 Region ID

event.dv360_supply_chain_complete

boolean
Indicates whether the supply chain object is complete in the bid request.

event.dv360_supply_chain_domain

array<string>
The domain in the supply path, the order is the same as the order in the supply chain JSON.

event.dv360_supply_chain_seller_id

array<string>
Array of strings. The seller ID in the supply path, the order is the same as the order in the supply chain JSON.

event.dv360_url

event.dv360_view_state

event.dv360_zip_postal_code

string
DV360 ZIP/Postal Code

event.event_sub_type

string
Contains further details related to the event - these are VIEW and CLICK for view and click events, but may be POSTVIEW, POSTCLICK or blank for conversion events.

event.event_time

int64
Time in microseconds since 1970-01-01 00:00:00 UTC.

event.event_type

string
Contains CONVERSION or MODELED_CONVERSION.

event.floodlight_config_id

int64
Unique ID of the floodlight configuration.

event.interaction_time_utc_seconds

string
Interaction time UTC seconds

event.landing_page_url_id

int64
Unique ID of the landing page URL. Only populates for clicks, NULL for other tables.

event.operating_system_id

int64
ID of the operating system.

event.ord_value

string
The advertiser's ordinal ID, if relevant for a given activity type. Passed in the 'ord=' key-value (also used for storing the client's Order-ID in sales tags)

event.other_data

event.placement_id

int64
Unique ID for the site page / placement where the ad ran.

event.platform_type_id

event.referrer_url

string
Contains the URL on which the ad appeared, when possible. May also be empty, or return ad server URLs.

event.rendering_id

int64
Unique ID of the creative for Data Transfer. Does not correspond to the UI-Creative-ID.

event.rich_media_event_counters

int64
MET Counter Value (the ecn= value).

event.rich_media_event_id

int64
MET Event ID for the Rich Media ad.

event.rich_media_event_timers

double
Time in microseconds since 1970-01-01 00:00:00 UTC.

event.rich_media_event_type_id

int64
ID of Rich Media Event Type.

event.segment_value_1

int64
Segment Value 1

event.site_id

int64
Unique ID for the site where the ad ran.

event.state

string
ID for user's state or province (US/Canada)

event.total_conversions

event.total_conversions_revenue

double
The amount of revenue in USD credited to the attributed event. (The attributed version of event.activity_revenue in activities_events.)

event.total_transaction_count

double
The number of transactions or activity tag fires in nanos credited to the attributed event.

event.tran_value

string
TRAN Value

event.u_value

string
U Value

event.zip_code

string
Postal-Code (US/Canada).

network_id

int64
The network ID.

user_id

DV360 Data Transfer advertiser

dv360_dt_advertiser

dv360_advertiser

string
Name of the advertiser.

dv360_advertiser_id

int64
Unique ID of the advertiser.

dv360_partner_id

int64
Unique ID of the partner.

DV360 Data Transfer campaign

dv360_dt_campaign

dv360_advertiser_id

int64
Unique ID of the advertiser.

dv360_campaign

string
Name of the campaign

dv360_campaign_id

int64
The unique ID of the Display & Video 360 campaign.

dv360_partner_id

int64
Unique ID of the partner.

DV360 Data Transfer clicks

dv360_dt_clicks

To query EEA user data, use the policy-isolated tables in place of dv360_dt_clicks :

dv360_dt_clicks_policy_isolated_youtube
dv360_dt_clicks_policy_isolated_network
dv360_dt_clicks_policy_isolated_search

event

struct

event.active_view_audible_impressions

int64
Active View: Impressions Audible

event.active_view_audible_time_msec

int64
Active View: Play Time Audible (milliseconds)

event.active_view_audible_visible_time_msec

int64
Active View: Play Time Audible and Visible (milliseconds)

event.active_view_background_count

int64
Active View: Impressions In Background

event.active_view_complete_viewable_impressions

int64
Active View: Impressions Visible at Completion

event.active_view_eligible_impressions

event.active_view_first_quartile_viewable_audible_impressions

int64
Active View: Impressions Visible and Audible at First Quartile

event.active_view_first_quartile_viewable_impressions

int64
Active View: Impressions Visible at First Quartile

event.active_view_fullscreen_count

int64
Active View: Impressions Full-Screen

event.active_view_impressions_audible_and_visible_at_completion

int64
Active View: Impressions Audible and Visible at Completion

event.active_view_impressions_visible10_seconds

int64
Active View: Impressions Visible 10 Seconds

event.active_view_measurable_impressions

int64
Whether the impression was measurable with Active View.

event.active_view_midpoint_viewable_audible_impressions

int64
Active View: Impressions Visible and Audible at Midpoint

event.active_view_midpoint_viewable_impressions

int64
Active View: Impressions Visible at Midpoint

event.active_view_plus_measurable_count

int64
Active View Plus: Measurable Impressions

event.active_view_start_viewable_audible_impressions

int64
Active View: Impressions Visible and Audible at Start

event.active_view_start_viewable_impressions

int64
Active View: Impressions Visible at Start

event.active_view_third_quartile_viewable_audible_impressions

int64
Active View: Impressions Visible and Audible at Third Quartile

event.active_view_third_quartile_viewable_impressions

int64
Active View: Impressions Visible at Third Quartile

event.active_view_tos_msec

int64
Active View: Time on Screen (milliseconds)

event.active_view_viewable_impressions

int64
Whether the impression was viewable.

event.active_view_visible_time_msec

int64
Active View: Video Visible Time (milliseconds)

event.activity_count

int64
Activity Quantity

event.activity_id

int64
The ID of the Floodlight tag related to the conversion event.

event.ad_id

int64
Unique ID of the ad placement.

event.advertiser_id

int64
Unique ID of the advertiser

event.audience_segment_id

int64
Unique ID of the audience segment.

event.browser_platform_id

string
ID of the browser type.

event.browser_version

string
Browser/Platform Version

event.campaign_id

int64
The unique ID of the Campaign Manager 360 campaign

event.city_id

int64
City ID

event.conversion_id

int64
Indicates whether an activity has been matched as a post-click (value of 1) or post-impression (value of 2), or unmatched (value of 0).

event.country_code

string
Country

event.creative_version

string
Creative version number.

event.dma_region_id

int64
Designated Market Area ID (US/Canada).

event.dv360_ad_position

int64
Specifies the position of the ad on the page if known. 1 represents above the fold, 2 represents below the fold.

event.dv360_advertiser_id

int64
The Display & Video 360 numerical ID for the advertiser related to the event, for example 164332.

event.dv360_adx_page_categories

string
DV360 Adx Page Categories

event.dv360_attributed_inventory_source_external_id

event.dv360_attributed_inventory_source_is_public

string
True if inventory source is available to all buyers. False otherwise.

event.dv360_auction_bid_price_advertiser_currency

int64

event.dv360_auction_bid_price_partner_currency

int64

event.dv360_auction_bid_price_usd

int64

event.dv360_auction_id

string
A string used to join events among view/click/conversion types, for example"ABCDEFGH_abcdefgh-0123456789". Do not assume any ordering, structure or meaning to the auction_id value.

event.dv360_bid_price_advertiser_currency

event.dv360_bid_price_partner_currency

event.dv360_bid_price_usd

event.dv360_bid_request_publisher_id

string
The publisher id in the publisher.id field of bid request.

event.dv360_billable_cost_advertiser_currency

int64
The total amount of money billed to the partner, including the media cost and partner costs, in advertiser currency nanos.

event.dv360_billable_cost_partner_currency

int64
The total amount of money billed to the partner, including the media cost and partner costs, in partner currency nanos.

event.dv360_billable_cost_usd

int64
The total amount of money billed to the partner, including the media cost and partner costs, in USD nanos.

event.dv360_browser_id

int64
The Display & Video 360 numerical ID identifying the browser related to this event.

event.dv360_browser_reportable_id

int64
The new Display & Video 360 numerical ID identifying the browser related to this event.

event.dv360_browser_timezone_offset_minutes

int64
The difference in minutes between the active timezone on the user's browser and GMT-12, for example 1320 represents a browser timezone of GMT+10.

event.dv360_campaign_id

int64
The unique ID of the linked Display & Video 360 campaign.

event.dv360_city_id

int64
The Display & Video 360 numerical ID identifying the best-guess city of the impression.

event.dv360_country_code

string
2-letter ISO 3166-1 country code identifying the best-guess country of the impression, for example "US".

event.dv360_cpm_fee_1_advertiser_currency

int64
DV360 CPM fee 1 advertiser currency

event.dv360_cpm_fee_1_partner_currency

int64
DV360 CPM fee 1 partner currency

event.dv360_cpm_fee_1_usd

int64
DV360 CPM fee 1 usd

event.dv360_cpm_fee_2_advertiser_currency

int64
DV360 CPM fee 2 advertiser currency

event.dv360_cpm_fee_2_partner_currency

int64
DV360 CPM fee 2 partner currency

event.dv360_cpm_fee_2_usd

int64
DV360 CPM fee 2 usd

event.dv360_cpm_fee_3_advertiser_currency

int64
DV360 CPM fee 3 advertiser currency

event.dv360_cpm_fee_3_partner_currency

int64
DV360 CPM fee 3 partner currency

event.dv360_cpm_fee_3_usd

int64
DV360 CPM fee 3 usd

event.dv360_cpm_fee_4_advertiser_currency

int64
DV360 CPM fee 4 advertiser currency

event.dv360_cpm_fee_4_partner_currency

int64
DV360 CPM fee 4 partner currency

event.dv360_cpm_fee_4_usd

int64
DV360 CPM fee 4 usd

event.dv360_cpm_fee_5_advertiser_currency

int64
DV360 CPM fee 5 advertiser currency

event.dv360_cpm_fee_5_partner_currency

int64
DV360 CPM fee 5 partner currency

event.dv360_cpm_fee_5_usd

int64
DV360 CPM fee 5 usd

event.dv360_creative_id

int64
The Display & Video 360 numerical ID for the creative related to the event, for example 367487.

event.dv360_data_fees_advertiser_currency

int64
DV360 data fees advertiser currency

event.dv360_data_fees_partner_currency

int64
DV360 data fees partner currency

event.dv360_data_fees_usd

int64
DV360 data fees usd

event.dv360_device_type

int64
The numerical value of the identified device type. 0 = Computer, 1 = Other, 2 = Smart Phone, 3 = Tablet, 4 = Smart TV, 5 = Connected TV, 6 = Set Top Box, 7 = Connected Device.

event.dv360_exchange_id

string
The Display & Video 360 numerical ID for the exchange that requested the ad.

event.dv360_insertion_order_id

int64
The Display & Video 360 numerical ID for the insertion order related to the event, for example 1079941.

event.dv360_isp_id

int64
The Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.

event.dv360_isp_reportable_id

int64
The new Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.

event.dv360_language

string
The ISO-639-1 code or "zh_CN" (Chinese (simplified)), "zh_TW" (Chinese (traditional)) or "other" representing the language related to the view event.

event.dv360_line_item_id

int64
The Display & Video 360 numerical ID for the line item related to the event, for example 1155785.

event.dv360_matching_targeted_keywords

event.dv360_matching_targeted_segments

event.dv360_media_cost_advertiser_currency

int64
The amount paid for the impression in advertiser currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.

event.dv360_media_cost_partner_currency

int64
The amount paid for the impression in the partner currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.

event.dv360_media_cost_usd

int64
The amount paid for the impression in USD nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.

event.dv360_media_fee_1_advertiser_currency

int64
DV360 media fee 1 advertiser currency

event.dv360_media_fee_1_partner_currency

int64
DV360 media fee 1 partner currency

event.dv360_media_fee_1_usd

int64
DV360 media fee 1 usd

event.dv360_media_fee_2_advertiser_currency

int64
DV360 media fee 2 advertiser currency

event.dv360_media_fee_2_partner_currency

int64
DV360 media fee 2 partner currency

event.dv360_media_fee_2_usd

int64
DV360 media fee 2 usd

event.dv360_media_fee_3_advertiser_currency

int64
DV360 media fee 3 advertiser currency

event.dv360_media_fee_3_partner_currency

int64
DV360 media fee 3 partner currency

event.dv360_media_fee_3_usd

int64
DV360 media fee 3 usd

event.dv360_media_fee_4_advertiser_currency

int64
DV360 media fee 4 advertiser currency

event.dv360_media_fee_4_partner_currency

int64
DV360 media fee 4 partner currency

event.dv360_media_fee_4_usd

int64
DV360 media fee 4 usd

event.dv360_media_fee_5_advertiser_currency

int64
DV360 media fee 5 advertiser currency

event.dv360_media_fee_5_partner_currency

int64
DV360 media fee 5 partner currency

event.dv360_media_fee_5_usd

int64
DV360 media fee 5 usd

event.dv360_mobile_make_id

int64
The numerical ID for the mobile make. This value may be missing.

event.dv360_mobile_make_reportable_id

int64
The new numerical ID for the mobile make. This value may be missing.

event.dv360_mobile_model_id

int64
The numerical ID for the mobile model. This value may be missing.

event.dv360_mobile_model_reportable_id

int64
The new numerical ID for the mobile model. This value may be missing.

event.dv360_net_speed

int64
The Display & Video 360 numerical ID representing the network speed related to the view event. 1=Dial-up, 2=EDGE/2G, 3=UMTS/3G, 4=Basic DSL, 5=HSDPA/3.5G, 6=Broadband/4G, 7=Unknown.

event.dv360_operating_system_id

int64
Operating System ID.

event.dv360_operating_system_reportable_id

int64
New Operating System ID.

event.dv360_request_time

event.dv360_revenue_advertiser_currency

int64
The total amount in advertiser currency nanos made by the partner account for the view event. This value may be zero.

event.dv360_revenue_partner_currency

int64
The total amount in partner currency nanos made by the partner account for the view event. This value may be zero.

event.dv360_revenue_usd

int64
The total amount in USD nanos made by the partner account for the view event. This value may be zero.

event.dv360_site_id

int64
The Display & Video 360 numerical ID for the most specific universal site that matches the url.

event.dv360_state_region_id

int64
DV360 Region ID

event.dv360_supply_chain_complete

boolean
Indicates whether the supply chain object is complete in the bid request.

event.dv360_supply_chain_domain

array<string>
The domain in the supply path, the order is the same as the order in the supply chain JSON.

event.dv360_supply_chain_seller_id

array<string>
Array of strings. The seller ID in the supply path, the order is the same as the order in the supply chain JSON.

event.dv360_url

event.dv360_view_state

event.dv360_zip_postal_code

string
DV360 ZIP/Postal Code

event.event_sub_type

string
Contains further details related to the event - these are VIEW and CLICK for view and click events, but may be POSTVIEW, POSTCLICK or blank for conversion events.

event.event_time

int64
Time in microseconds since 1970-01-01 00:00:00 UTC.

event.event_type

string
Contains CLICK.

event.floodlight_config_id

int64
Unique ID of the floodlight configuration.

event.impression_id

string
Impression ID

event.interaction_time_utc_seconds

string
Interaction time UTC seconds

event.landing_page_url_id

int64
Unique ID of the landing page URL. Only populates for clicks, NULL for other tables.

event.operating_system_id

int64
ID of the operating system.

event.ord_value

string
The advertiser's ordinal ID, if relevant for a given activity type. Passed in the 'ord=' key-value (also used for storing the client's Order-ID in sales tags)

event.other_data

event.placement_id

int64
Unique ID for the site page / placement where the ad ran.

event.platform_type_id

event.referrer_url

string
Contains the URL on which the ad appeared, when possible. May also be empty, or return ad server URLs.

event.rendering_id

int64
Unique ID of the creative for Data Transfer. Does not correspond to the UI-Creative-ID.

event.rich_media_event_counters

int64
MET Counter Value (the ecn= value).

event.rich_media_event_id

int64
MET Event ID for the Rich Media ad.

event.rich_media_event_timers

double
Time in microseconds since 1970-01-01 00:00:00 UTC.

event.rich_media_event_type_id

int64
ID of Rich Media Event Type.

event.segment_value_1

int64
Segment Value 1

event.site_id

int64
Unique ID for the site where the ad ran.

event.state

string
ID for user's state or province (US/Canada)

event.tran_value

string
TRAN Value

event.u_value

string
U Value

event.zip_code

string
Postal-Code (US/Canada).

network_id

int64
The network ID.

user_id

DV360 Data Transfer impressions

dv360_dt_impressions

To query EEA user data, use the policy-isolated tables in place of dv360_dt_impressions :

dv360_dt_impressions_policy_isolated_youtube
dv360_dt_impressions_policy_isolated_network
dv360_dt_impressions_policy_isolated_search

event

struct

event.active_view_audible_impressions

int64
Active View: Impressions Audible

event.active_view_audible_time_msec

int64
Active View: Play Time Audible (milliseconds)

event.active_view_audible_visible_time_msec

int64
Active View: Play Time Audible and Visible (milliseconds)

event.active_view_background_count

int64
Active View: Impressions In Background

event.active_view_complete_viewable_impressions

int64
Active View: Impressions Visible at Completion

event.active_view_eligible_impressions

event.active_view_first_quartile_viewable_audible_impressions

int64
Active View: Impressions Visible and Audible at First Quartile

event.active_view_first_quartile_viewable_impressions

int64
Active View: Impressions Visible at First Quartile

event.active_view_fullscreen_count

int64
Active View: Impressions Full-Screen

event.active_view_impressions_audible_and_visible_at_completion

int64
Active View: Impressions Audible and Visible at Completion

event.active_view_impressions_visible10_seconds

int64
Active View: Impressions Visible 10 Seconds

event.active_view_measurable_impressions

int64
Whether the impression was measurable with Active View.

event.active_view_midpoint_viewable_audible_impressions

int64
Active View: Impressions Visible and Audible at Midpoint

event.active_view_midpoint_viewable_impressions

int64
Active View: Impressions Visible at Midpoint

event.active_view_plus_measurable_count

int64
Active View Plus: Measurable Impressions

event.active_view_start_viewable_audible_impressions

int64
Active View: Impressions Visible and Audible at Start

event.active_view_start_viewable_impressions

int64
Active View: Impressions Visible at Start

event.active_view_third_quartile_viewable_audible_impressions

int64
Active View: Impressions Visible and Audible at Third Quartile

event.active_view_third_quartile_viewable_impressions

int64
Active View: Impressions Visible at Third Quartile

event.active_view_tos_msec

int64
Active View: Time on Screen (milliseconds)

event.active_view_viewable_impressions

int64
Whether the impression was viewable.

event.active_view_visible_time_msec

int64
Active View: Video Visible Time (milliseconds)

event.activity_count

int64
Activity Quantity

event.activity_id

int64
The ID of the Floodlight tag related to the conversion event.

event.ad_id

int64
Unique ID of the ad placement.

event.advertiser_id

int64
Unique ID of the advertiser

event.audience_segment_id

int64
Unique ID of the audience segment.

event.browser_platform_id

string
ID of the browser type.

event.browser_version

string
Browser/Platform Version

event.campaign_id

int64
The unique ID of the Campaign Manager 360 campaign

event.city_id

int64
City ID

event.conversion_id

int64
Indicates whether an activity has been matched as a post-click (value of 1) or post-impression (value of 2), or unmatched (value of 0).

event.country_code

string
Country

event.creative_version

string
Creative version number.

event.dma_region_id

int64
Designated Market Area ID (US/Canada).

event.dv360_ad_position

int64
Specifies the position of the ad on the page if known. 1 represents above the fold, 2 represents below the fold.

event.dv360_advertiser_id

int64
The Display & Video 360 numerical ID for the advertiser related to the event, for example 164332.

event.dv360_adx_page_categories

string
DV360 Adx Page Categories

event.dv360_attributed_inventory_source_external_id

event.dv360_attributed_inventory_source_is_public

string
True if inventory source is available to all buyers. False otherwise.

event.dv360_auction_bid_price_advertiser_currency

int64

event.dv360_auction_bid_price_partner_currency

int64

event.dv360_auction_bid_price_usd

int64

event.dv360_auction_id

string
A string used to join events among view/click/conversion types, for example"ABCDEFGH_abcdefgh-0123456789". Do not assume any ordering, structure or meaning to the auction_id value.

event.dv360_bid_price_advertiser_currency

event.dv360_bid_price_partner_currency

event.dv360_bid_price_usd

event.dv360_bid_request_publisher_id

string
The publisher id in the publisher.id field of bid request.

event.dv360_billable_cost_advertiser_currency

int64
The total amount of money billed to the partner, including the media cost and partner costs, in advertiser currency nanos.

event.dv360_billable_cost_partner_currency

int64
The total amount of money billed to the partner, including the media cost and partner costs, in partner currency nanos.

event.dv360_billable_cost_usd

int64
The total amount of money billed to the partner, including the media cost and partner costs, in USD nanos.

event.dv360_browser_id

int64
The Display & Video 360 numerical ID identifying the browser related to this event.

event.dv360_browser_reportable_id

int64
The new Display & Video 360 numerical ID identifying the browser related to this event.

event.dv360_browser_timezone_offset_minutes

int64
The difference in minutes between the active timezone on the user's browser and GMT-12, for example 1320 represents a browser timezone of GMT+10.

event.dv360_campaign_id

int64
The unique ID of the linked Display & Video 360 campaign.

event.dv360_city_id

int64
The Display & Video 360 numerical ID identifying the best-guess city of the impression.

event.dv360_country_code

string
2-letter ISO 3166-1 country code identifying the best-guess country of the impression, for example "US".

event.dv360_cpm_fee_1_advertiser_currency

int64
DV360 CPM fee 1 advertiser currency

event.dv360_cpm_fee_1_partner_currency

int64
DV360 CPM fee 1 partner currency

event.dv360_cpm_fee_1_usd

int64
DV360 CPM fee 1 usd

event.dv360_cpm_fee_2_advertiser_currency

int64
DV360 CPM fee 2 advertiser currency

event.dv360_cpm_fee_2_partner_currency

int64
DV360 CPM fee 2 partner currency

event.dv360_cpm_fee_2_usd

int64
DV360 CPM fee 2 usd

event.dv360_cpm_fee_3_advertiser_currency

int64
DV360 CPM fee 3 advertiser currency

event.dv360_cpm_fee_3_partner_currency

int64
DV360 CPM fee 3 partner currency

event.dv360_cpm_fee_3_usd

int64
DV360 CPM fee 3 usd

event.dv360_cpm_fee_4_advertiser_currency

int64
DV360 CPM fee 4 advertiser currency

event.dv360_cpm_fee_4_partner_currency

int64
DV360 CPM fee 4 partner currency

event.dv360_cpm_fee_4_usd

int64
DV360 CPM fee 4 usd

event.dv360_cpm_fee_5_advertiser_currency

int64
DV360 CPM fee 5 advertiser currency

event.dv360_cpm_fee_5_partner_currency

int64
DV360 CPM fee 5 partner currency

event.dv360_cpm_fee_5_usd

int64
DV360 CPM fee 5 usd

event.dv360_creative_id

int64
The Display & Video 360 numerical ID for the creative related to the event, for example 367487.

event.dv360_data_fees_advertiser_currency

int64
DV360 data fees advertiser currency

event.dv360_data_fees_partner_currency

int64
DV360 data fees partner currency

event.dv360_data_fees_usd

int64
DV360 data fees usd

event.dv360_device_type

int64
The numerical value of the identified device type. 0 = Computer, 1 = Other, 2 = Smart Phone, 3 = Tablet, 4 = Smart TV, 5 = Connected TV, 6 = Set Top Box, 7 = Connected Device.

event.dv360_exchange_id

string
The Display & Video 360 numerical ID for the exchange that requested the ad.

event.dv360_insertion_order_id

int64
The Display & Video 360 numerical ID for the insertion order related to the event, for example 1079941.

event.dv360_isp_id

int64
The Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.

event.dv360_isp_reportable_id

int64
The new Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.

event.dv360_language

string
The ISO-639-1 code or "zh_CN" (Chinese (simplified)), "zh_TW" (Chinese (traditional)) or "other" representing the language related to the view event.

event.dv360_line_item_id

int64
The Display & Video 360 numerical ID for the line item related to the event, for example 1155785.

event.dv360_matching_targeted_keywords

event.dv360_matching_targeted_segments

event.dv360_media_cost_advertiser_currency

int64
The amount paid for the impression in advertiser currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.

event.dv360_media_cost_partner_currency

int64
The amount paid for the impression in the partner currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.

event.dv360_media_cost_usd

int64
The amount paid for the impression in USD nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.

event.dv360_media_fee_1_advertiser_currency

int64
DV360 media fee 1 advertiser currency

event.dv360_media_fee_1_partner_currency

int64
DV360 media fee 1 partner currency

event.dv360_media_fee_1_usd

int64
DV360 media fee 1 usd

event.dv360_media_fee_2_advertiser_currency

int64
DV360 media fee 2 advertiser currency

event.dv360_media_fee_2_partner_currency

int64
DV360 media fee 2 partner currency

event.dv360_media_fee_2_usd

int64
DV360 media fee 2 usd

event.dv360_media_fee_3_advertiser_currency

int64
DV360 media fee 3 advertiser currency

event.dv360_media_fee_3_partner_currency

int64
DV360 media fee 3 partner currency

event.dv360_media_fee_3_usd

int64
DV360 media fee 3 usd

event.dv360_media_fee_4_advertiser_currency

int64
DV360 media fee 4 advertiser currency

event.dv360_media_fee_4_partner_currency

int64
DV360 media fee 4 partner currency

event.dv360_media_fee_4_usd

int64
DV360 media fee 4 usd

event.dv360_media_fee_5_advertiser_currency

int64
DV360 media fee 5 advertiser currency

event.dv360_media_fee_5_partner_currency

int64
DV360 media fee 5 partner currency

event.dv360_media_fee_5_usd

int64
DV360 media fee 5 usd

event.dv360_mobile_make_id

int64
The numerical ID for the mobile make. This value may be missing.

event.dv360_mobile_make_reportable_id

int64
The new numerical ID for the mobile make. This value may be missing.

event.dv360_mobile_model_id

int64
The numerical ID for the mobile model. This value may be missing.

event.dv360_mobile_model_reportable_id

int64
The new numerical ID for the mobile model. This value may be missing.

event.dv360_net_speed

int64
The Display & Video 360 numerical ID representing the network speed related to the view event. 1=Dial-up, 2=EDGE/2G, 3=UMTS/3G, 4=Basic DSL, 5=HSDPA/3.5G, 6=Broadband/4G, 7=Unknown.

event.dv360_operating_system_id

int64
Operating System ID.

event.dv360_operating_system_reportable_id

int64
New Operating System ID.

event.dv360_request_time

event.dv360_revenue_advertiser_currency

int64
The total amount in advertiser currency nanos made by the partner account for the view event. This value may be zero.

event.dv360_revenue_partner_currency

int64
The total amount in partner currency nanos made by the partner account for the view event. This value may be zero.

event.dv360_revenue_usd

int64
The total amount in USD nanos made by the partner account for the view event. This value may be zero.

event.dv360_site_id

int64
The Display & Video 360 numerical ID for the most specific universal site that matches the url.

event.dv360_state_region_id

int64
DV360 Region ID

event.dv360_supply_chain_complete

boolean
Indicates whether the supply chain object is complete in the bid request.

event.dv360_supply_chain_domain

array<string>
The domain in the supply path, the order is the same as the order in the supply chain JSON.

event.dv360_supply_chain_seller_id

array<string>
Array of strings. The seller ID in the supply path, the order is the same as the order in the supply chain JSON.

event.dv360_url

event.dv360_view_state

event.dv360_zip_postal_code

string
DV360 ZIP/Postal Code

event.event_sub_type

string
Contains further details related to the event - these are VIEW and CLICK for view and click events, but may be POSTVIEW, POSTCLICK or blank for conversion events.

event.event_time

int64
Time in microseconds since 1970-01-01 00:00:00 UTC.

event.event_type

string
Contains VIEW.

event.floodlight_config_id

int64
Unique ID of the floodlight configuration.

event.impression_id

string
Impression ID

event.interaction_time_utc_seconds

string
Interaction time UTC seconds

event.landing_page_url_id

int64
Unique ID of the landing page URL. Only populates for clicks, NULL for other tables.

event.operating_system_id

int64
ID of the operating system.

event.ord_value

string
The advertiser's ordinal ID, if relevant for a given activity type. Passed in the 'ord=' key-value (also used for storing the client's Order-ID in sales tags)

event.other_data

event.placement_id

int64
Unique ID for the site page / placement where the ad ran.

event.platform_type_id

event.referrer_url

string
Contains the URL on which the ad appeared, when possible. May also be empty, or return ad server URLs.

event.rendering_id

int64
Unique ID of the creative for Data Transfer. Does not correspond to the UI-Creative-ID.

event.rich_media_event_counters

int64
MET Counter Value (the ecn= value).

event.rich_media_event_id

int64
MET Event ID for the Rich Media ad.

event.rich_media_event_timers

double
Time in microseconds since 1970-01-01 00:00:00 UTC.

event.rich_media_event_type_id

int64
ID of Rich Media Event Type.

event.segment_value_1

int64
Segment Value 1

event.site_id

int64
Unique ID for the site where the ad ran.

event.state

string
ID for user's state or province (US/Canada)

event.tran_value

string
TRAN Value

event.u_value

string
U Value

event.zip_code

string
Postal-Code (US/Canada).

network_id

int64
The network ID.

user_id

DV360 Data Transfer insertion order

dv360_dt_insertion_order

dv360_advertiser_id

int64
Unique ID of the advertiser.

dv360_campaign_id

int64
The unique ID of the Display & Video 360 campaign.

dv360_insertion_order

string
Name of the insertion order.

dv360_insertion_order_id

int64
The Display & Video 360 numerical ID for the insertion order related to the event, e.g. 1079941.

dv360_partner_id

int64
Unique ID of the partner.

DV360 Data Transfer line item

dv360_dt_line_item

dv360_advertiser_id

int64
Multiple Display & Video 360 "advertisers" generally exist underneath a single partner. Vendor client IDs are saved here.

dv360_campaign_id

int64
The unique ID of the Display & Video 360 campaign.

dv360_insertion_order_id

int64
The Display & Video 360 numerical ID for the insertion order related to the event, e.g. 1079941.

dv360_line_item

string
Name of the line item.

dv360_line_item_id

int64
Unique ID of the line item.

dv360_partner_id

int64
Unique ID of the partner.

DV360 YouTube Active Views

dv360_youtube_active_views

To query EEA user data, use the policy-isolated tables in place of dv360_youtube_active_views :

dv360_youtube_active_views_policy_isolated_youtube
dv360_youtube_active_views_policy_isolated_network

content_url

string
URL of the page on which the ad appeared. Part of the URL is removed for privacy.

impression_data

struct
Impression of the ad that was clicked.

impression_data.adgroup_id

int64
ID of the Display & Video 360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table.

impression_data.advertiser_id

int64
Multiple Display & Video 360 "advertisers" generally exist underneath a single partner. Vendor client IDs are saved here.

impression_data.campaign_id

int64
The Display & Video 360 numerical ID for the campaign related to the event, e.g. 164332.

impression_data.creative_id

int64
Unique ID of the creative. Joins with creative_id in any adh.dv360_youtube table.

impression_data.insertion_order_id

int64
The Display & Video 360 numerical ID for the insertion order related to the event, e.g. 1079941.

impression_data.line_item_id

int64
The Display & Video 360 numerical ID for the line item related to the event, e.g. 1155785.

impression_data.partner_id

int64
Unique ID of the partner.

impression_id

string
Unique identifier for impression.

is_updm_eligible

boolean
Whether the user is eligible for UPDM queries. This is true for logged-in events that don't have any privacy restrictions, such as child users or unconsented users.

num_active_view_viewable_impression

int64
1 when impression is active view eligible; 0 when impression is not active view eligible.

query_id

struct
Unique identifier for query has multiple parts. Joins with query_id in any adh.dv360_youtube table.

query_id.process_id

int64
Integer that identifies the process on the machine that generated the event.

query_id.server_ip

int64
The IPv4 address of the server that managed the ad request. Used to identify unique events for joins.

query_id.time_usec

int64
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.

user_id

view_id

struct
Unique identifier for view has multiple parts.

view_id.process_id

int64
Integer that identifies the process on the machine that generated the event.

view_id.server_ip

int64
The IPv4 address of the server that managed the ad request. Used to identify unique events for joins.

view_id.time_usec

int64
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.

view_type

string
The type of view event. The expected values are DELAYED_IMPRESSION, ACTIVE_VIEW_BILLABLE, ACTIVE_VIEW_MEASUREMENT, ACTIVE_VIEW_INFERRED, ACTIVE_VIEW_VIDEO, ACTIVE_VIEW_MOBILEAPP, ACTIVE_VIEW_TIME_ON_SCREEN, RENDERED_IMPRESSION, VIDEO_TERMINATION, VIDEO_AD_DISPLAY_IMPRESSION, BEGIN_TO_RENDER_IMPRESSION, ATTACHED_TO_VIEW_IMPRESSION, VENDOR_BLOCKED_AD, ACTIVE_VIEW_AUDIO, ACTIVE_VIEW_SYNTHETIC, VPID_BEACON, ACTIVE_VIEW_SESSION.

viewability_metrics

struct
Summable viewability metrics intended for Core and Advanced tiers of viewability. Metrics are organized by measurability pools. For each measurability pool, there is a sub-field containing the number of impressions that were measurable and the metrics that are available.

viewability_metrics.active_view_plus_metrics

struct
(Video only) Measures a variety of viewability metrics (including quartiles) that share a common measurability denominator.

viewability_metrics.active_view_plus_metrics.ad_duration_msec

int64
Total ad duration in milliseconds.

viewability_metrics.active_view_plus_metrics.audible_and_fully_visible_watchtime_msec

int64
Total audible (volume > 0%) and fully visible (100% on screen) watchtime in milliseconds.

viewability_metrics.active_view_plus_metrics.audible_and_visible_watchtime_msec

int64
Total audible (volume > 0%) and visible (at least 50% on screen) watchtime in milliseconds.

viewability_metrics.active_view_plus_metrics.audible_count

int64
Number of impressions that were audible (volume > 0%) at any point during playback.

viewability_metrics.active_view_plus_metrics.audible_watchtime_msec

int64
Total audible (volume > 0%) watchtime, in milliseconds.

viewability_metrics.active_view_plus_metrics.background_count

int64
Number of backgrounded impressions.

viewability_metrics.active_view_plus_metrics.fullscreen_count

int64
Number of fullscreened impressions. Note that this count only increments on YouTube platforms that have a toggle between normal/fullscreen state. YouTube Platforms that are always in fullscreen (like YouTube CTV Apps) will show up as 0.

viewability_metrics.active_view_plus_metrics.fully_visible_watchtime_msec

int64
Total fully visible (100% on screen) watchtime in milliseconds.

viewability_metrics.active_view_plus_metrics.measurable_count

int64
Number of impressions where Active View Plus metrics were able to be measured.

viewability_metrics.active_view_plus_metrics.q1

struct
Instantaneous metrics for first quartile event.

viewability_metrics.active_view_plus_metrics.q2

struct
Instantaneous metrics for second quartile (midpoint) event.

viewability_metrics.active_view_plus_metrics.q3

struct
Instantaneous metrics for third quartile event.

viewability_metrics.active_view_plus_metrics.q4

struct
Instantaneous metrics for fourth quartile (complete) event.

viewability_metrics.active_view_plus_metrics.start

struct
Instantaneous metrics for start event.

viewability_metrics.active_view_plus_metrics.viewable_10_sec_count

int64
Number of impressions that were at least 50% on screen for at least 10 seconds (cumulative).

viewability_metrics.active_view_plus_metrics.visible_watchtime_msec

int64
Total visible (at least 50% on screen) watchtime, in milliseconds.

viewability_metrics.active_view_plus_metrics.watchtime_msec

int64
Total watchtime in milliseconds. Note: This may differ from the value reported in Google Ads, as it is only populated when Ads Data Hub is able to measure Active View metrics.

viewability_metrics.active_view_plus_metrics.{start, q1, q2, q3, q4}.audible

int64
Number of impressions that were audible (volume > 0%) at this point.

viewability_metrics.active_view_plus_metrics.{start, q1, q2, q3, q4}.audible_and_visible

int64
Number of impressions that were audible (volume > 0%) and 50% on screen at this point.

viewability_metrics.active_view_plus_metrics.{start, q1, q2, q3, q4}.reached

int64
Number of impressions that reached this point.

viewability_metrics.active_view_plus_metrics.{start, q1, q2, q3, q4}.visible

int64
Number of impressions that were at least 50% on screen at this point.

viewability_metrics.enabled_count

int64
Number of impressions with Active View enabled.

viewability_metrics.groupm_trueview_viewable_impressions

struct
(Video only) Similar to groupm_viewable_impressions, but with an additional requirement on playback time for measurability. Impressions must reach the GroupM threshold of 15 seconds or 50% duration in addition to being GroupM measurable to be considered GroupM TrueView measurable.

viewability_metrics.groupm_trueview_viewable_impressions.measurable_count

int64
Number of impressions where GroupM viewability was able to be measured and that reached the GroupM playback threshold.

viewability_metrics.groupm_trueview_viewable_impressions.viewable_count

int64
Number of impressions that met the GroupM standard.

viewability_metrics.groupm_viewable_impressions

struct
(Video only) Measures video ads playing 100% pixels on screen with audio volume > 0% for playback of at least 15 seconds or 50% of the ad duration, whichever is shorter.

viewability_metrics.groupm_viewable_impressions.measurable_count

int64
Number of impressions where GroupM viewability was able to be measured.

viewability_metrics.groupm_viewable_impressions.viewable_count

int64
Number of impressions that met the GroupM standard.

viewability_metrics.mrc_cross_media_viewable_impressions

struct
(Video only) Measures video ads playing 100% on screen for 2 continuous seconds.

viewability_metrics.mrc_cross_media_viewable_impressions.measurable_count

int64
Number of impressions where Cross-Media MRC viewability was able to be measured.

viewability_metrics.mrc_cross_media_viewable_impressions.viewable_count

int64
Number of impressions that met the Cross-Media MRC viewable standard.

viewability_metrics.mrc_viewable_impressions

struct
Viewability metrics based on the MRC standard. That is, whether a video ad showed 50% pixels on screen for 2 continuous seconds of playback, or a display ad showed 50% pixels on screen for 1 continuous second.

viewability_metrics.mrc_viewable_impressions.measurable_count

int64
Number of impressions where MRC viewability was able to be measured.

viewability_metrics.mrc_viewable_impressions.viewable_count

int64
Number of impressions that met the MRC viewable standard.

viewability_metrics.time_on_screen

struct
Measures the total time on screen for viewable impressions as determined by the MRC standard. The measurable count for impressions in this metric is zero for impressions that do not meet the MRC viewability threshold.

viewability_metrics.time_on_screen.measurable_count

int64
Number of impressions where Time On Screen was able to be measured and met the MRC viewable standard.

viewability_metrics.time_on_screen.msec

int64
Visible (at least 50% on screen) watchtime, in milliseconds, for impressions that met the MRC viewable standard.

DV360 YouTube ad group

dv360_youtube_adgroup

adgroup_id

int64
ID of the Display & Video 360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table.

adgroup_name

string
Ad group name.

adgroup_status

string
The ad group. Possible values are: STATUS_ENABLED, STATUS_PAUSED, STATUS_DELETED, or STATUS_SOFT_DELETED.

adgroup_type

string
The ad group type. Possible values are: VIDEO_ACTION, VIDEO_VIEW, VIDEO_REACH, VIDEO_PAUSE, VIDEO_TRUE_VIEW_IN_STREAM, VIDEO_TRUE_VIEW_IN_DISPLAY, VIDEO_BUMPER, VIDEO_NON_SKIPPABLE_IN_STREAM, DISPLAY, SEARCH, VIDEO_OUTSTREAM, YOUTUBE_AUDIO, VIDEO_MASTHEAD, OTHER

advertiser_id

int64
Multiple Display & Video 360 "advertisers" generally exist underneath a single partner. Vendor client IDs are saved here.

campaign_id

int64
The Display & Video 360 numerical ID for the campaign related to the event, e.g. 164332.

insertion_order_id

int64
The Display & Video 360 numerical ID for the insertion order related to the event, e.g. 1079941.

line_item_id

int64
The Display & Video 360 numerical ID for the line item related to the event, e.g. 1155785.

partner_id

int64
Unique ID of the partner.

DV360 YouTube advertiser

dv360_youtube_advertiser

advertiser_id

int64
Multiple Display & Video 360 "advertisers" generally exist underneath a single partner. Vendor client IDs are saved here.

advertiser_name

string
Name of the advertiser.

advertiser_timezone

string
The DV360 advertiser time zone default set in account settings.

partner_id

int64
Unique ID of the partner.

DV360 YouTube campaign

dv360_youtube_campaign

advertiser_id

int64
Multiple Display & Video 360 "advertisers" generally exist underneath a single partner. Vendor client IDs are saved here.

campaign_id

int64
The Display & Video 360 numerical ID for the campaign related to the event, e.g. 164332.

campaign_name

string
Name of the campaign.

partner_id

int64
Unique ID of the partner.

DV360 YouTube clicks (deprecated - use dv360_youtube_creative_conversions)

dv360_youtube_clicks

advertiser_click_cost_local_micros

double
The advertiser's cost in local currency micros.

advertiser_click_cost_usd

double
The advertiser's click cost in dollars.

click_id

struct
Unique identifier for click has multiple parts. Joins with click_id in any adh.dv360_youtube table.

click_id.process_id

int64
Integer that identifies the process on the machine that generated the event.

click_id.server_ip

int64
The IPv4 address of the server that managed the ad request. Used to identify unique events for joins.

click_id.time_usec

int64
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.

click_type

int64
The click type.

impression_data

struct
Impression of the ad that was clicked.

impression_data.adgroup_id

int64
ID of the Display & Video 360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table.

impression_data.advertiser_id

int64
Multiple Display & Video 360 "advertisers" generally exist underneath a single partner. Vendor client IDs are saved here.

impression_data.campaign_id

int64
The Display & Video 360 numerical ID for the campaign related to the event, e.g. 164332.

impression_data.creative_id

int64
Unique ID of the creative. Joins with creative_id in any adh.dv360_youtube table.

impression_data.insertion_order_id

int64
The Display & Video 360 numerical ID for the insertion order related to the event, e.g. 1079941.

impression_data.line_item_id

int64
The Display & Video 360 numerical ID for the line item related to the event, e.g. 1155785.

impression_data.partner_id

int64
Unique ID of the partner.

impression_id

string
Unique identifier for impression.

is_trueview

boolean
True if the event was a TrueView view. False if the event was not a TrueView view.

is_updm_eligible

boolean
Whether the user is eligible for UPDM queries. This is true for logged-in events that don't have any privacy restrictions, such as child users or unconsented users.

query_id

struct
Unique identifier for query has multiple parts. Joins with query_id in any adh.dv360_youtube table.

query_id.process_id

int64
Integer that identifies the process on the machine that generated the event.

query_id.server_ip

int64
The IPv4 address of the server that managed the ad request. Used to identify unique events for joins.

query_id.time_usec

int64
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.

user_id

DV360 YouTube conversions

dv360_youtube_conversions

To query EEA user data, use the policy-isolated tables in place of dv360_youtube_conversions :

dv360_youtube_conversions_policy_isolated_youtube
dv360_youtube_conversions_policy_isolated_network

attribution_event_type

string
Primary interaction this conversion is attributed to. Valid values: INTERACTION, CLICK, ENGAGED_VIEW, OTHER.

click_id

struct
Unique identifier for click has multiple parts. Joins with click_id in any adh.dv360_youtube table.

click_id.process_id

int64
Integer that identifies the process on the machine that generated the event.

click_id.server_ip

int64
The IPv4 address of the server that managed the ad request. Used to identify unique events for joins.

click_id.time_usec

int64
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.

conversion_id

struct
Unique identifier for conversion has multiple parts.

conversion_id.process_id

int64
Integer that identifies the process on the machine that generated the event.

conversion_id.server_ip

int64
The IPv4 address of the server that managed the ad request. Used to identify unique events for joins.

conversion_id.time_usec

int64
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.

conversion_type

int64
The conversion type.

impression_data

struct
Impression of the ad that was clicked.

impression_data.adgroup_id

int64
ID of the Display & Video 360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table.

impression_data.advertiser_id

int64
Multiple Display & Video 360 "advertisers" generally exist underneath a single partner. Vendor client IDs are saved here.

impression_data.campaign_id

int64
The Display & Video 360 numerical ID for the campaign related to the event, e.g. 164332.

impression_data.creative_id

int64
Unique ID of the creative. Joins with creative_id in any adh.dv360_youtube table.

impression_data.insertion_order_id

int64
The Display & Video 360 numerical ID for the insertion order related to the event, e.g. 1079941.

impression_data.line_item_id

int64
The Display & Video 360 numerical ID for the line item related to the event, e.g. 1155785.

impression_data.partner_id

int64
Unique ID of the partner.

impression_id

string
Unique identifier for impression.

is_updm_eligible

boolean
Whether the user is eligible for UPDM queries. This is true for logged-in events that don't have any privacy restrictions, such as child users or unconsented users.

label

string
Name of conversion event.

query_id

struct
Unique identifier for query has multiple parts. Joins with query_id in any adh.dv360_youtube table.

query_id.process_id

int64
Integer that identifies the process on the machine that generated the event.

query_id.server_ip

int64
The IPv4 address of the server that managed the ad request. Used to identify unique events for joins.

query_id.time_usec

int64
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.

user_id

DV360 YouTube creative

dv360_youtube_creative

adgroup_id

int64
ID of the Display & Video 360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table.

advertiser_id

int64
Multiple Display & Video 360 "advertisers" generally exist underneath a single partner. Vendor client IDs are saved here.

campaign_id

int64
The Display & Video 360 numerical ID for the campaign related to the event, e.g. 164332.

creative_id

int64
Unique ID of the creative. Joins with creative_id in any adh.dv360_youtube table.

creative_name

string
The name of the Display & Video 360 creative.

creative_type

int64
Enum corresponding to the creative type.

insertion_order_id

int64
The Display & Video 360 numerical ID for the insertion order related to the event, e.g. 1079941.

line_item_id

int64
The Display & Video 360 numerical ID for the line item related to the event, e.g. 1155785.

partner_id

int64
Unique ID of the partner.

third_party_vast_url

string
URL used for VAST (Video Ad Serving Template) redirect creatives. Formatting doesn't match yt_reserve_creative.third_party_vast_url.

video_message

struct
Multipart identifier for video data.

video_message.video_ad_duration

int64
Duration of the video in milliseconds.

video_message.youtube_video_id

string
Video ID string representation as it appears on YouTube watch url.

DV360 YouTube creative conversions

dv360_youtube_creative_conversions

To query EEA user data, use the policy-isolated tables in place of dv360_youtube_creative_conversions :

dv360_youtube_creative_conversions_policy_isolated_youtube
dv360_youtube_creative_conversions_policy_isolated_network

advertiser_cost_local_micros

double
The advertiser's cost in local currency micros.

advertiser_cost_usd

double
The advertiser's click cost in dollars.

click_id

struct
Unique identifier for click has multiple parts. Joins with click_id in any adh.dv360_youtube table.

click_id.process_id

int64
Integer that identifies the process on the machine that generated the event.

click_id.server_ip

int64
The IPv4 address of the server that managed the ad request. Used to identify unique events for joins.

click_id.time_usec

int64
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.

content_url

string
URL of the page on which the ad appeared. Part of the URL is removed for privacy.

conversion_id

struct
Unique identifier for conversion has multiple parts.

conversion_id.process_id

int64
Integer that identifies the process on the machine that generated the event.

conversion_id.server_ip

int64
The IPv4 address of the server that managed the ad request. Used to identify unique events for joins.

conversion_id.time_usec

int64
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.

conversion_type

int64
The conversion type.

impression_data

struct
Impression of the ad that was clicked.

impression_data.adgroup_id

int64
ID of the Display & Video 360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table.

impression_data.advertiser_id

int64
Multiple Display & Video 360 "advertisers" generally exist underneath a single partner. Vendor client IDs are saved here.

impression_data.campaign_id

int64
The Display & Video 360 numerical ID for the campaign related to the event, e.g. 164332.

impression_data.creative_id

int64
Unique ID of the creative. Joins with creative_id in any adh.dv360_youtube table.

impression_data.insertion_order_id

int64
The Display & Video 360 numerical ID for the insertion order related to the event, e.g. 1079941.

impression_data.line_item_id

int64
The Display & Video 360 numerical ID for the line item related to the event, e.g. 1155785.

impression_data.partner_id

int64
Unique ID of the partner.

impression_id

string
Unique identifier for impression.

is_updm_eligible

boolean
Whether the user is eligible for UPDM queries. This is true for logged-in events that don't have any privacy restrictions, such as child users or unconsented users.

label

string
Name of conversion event.

num_clicks

int64
Number of clicks.

num_video_views

int64
Number of video views.