Ads Data Hub table schema- Vendors

Browser

browser
browser_id	int Browser identifier.
browser_name	string Browser name.
major_version	string Major version of the browser (whole number version).
minor_version	string Minor version of the browser (incremental or decimal version).

City

city
city_id	int Unique ID of the city.
city_name	string City name.
country_code	string Two character country code.
latitude	int Latitude in degrees.
longitude	int Longitude in degrees.
metro_code	string Metropolitan area code.
region_code	string The multi character code of the region

Campaign Manager Data Transfer account info

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

Campaign Manager Data Transfer Active View plus

cm_dt_active_view_plus
device_id_md5	string MD5-hashed device ID; a utility may be provided to hash raw device IDs to match.
event	struct
event.active_view_eligible_impressions	int Whether the impression was eligible to measure viewability. An impression is eligible if (a) the ad's creative has an Active View tag and (b) the tag successfully communicates with Google Marketing Platform servers at the time of the impression.
event.active_view_measurable_impressions	int Whether the impression was measurable with Active View.
event.active_view_viewable_impressions	int Whether the impression was viewable.
event.activity_count	int Activity Quantity
event.activity_id	int The ID of the Floodlight tag related to the conversion event.
event.ad_id	int Unique ID of the ad placement.
event.advertiser_id	int Unique ID of the advertiser
event.audience_segment_id	int
event.browser_platform_id	string ID of the browser type.
event.browser_version	string Browser/Platform Version
event.campaign_id	int Unique ID of the campaign
event.city_id	int City ID
event.conversion_id	int Indicates whether an activity has been matched as a post-click (value of 1) or post-impression (value of 2), or unmatched (value of 0).
event.country_code	string Country
event.creative_version	string Creative version number.
event.dma_region_id	int Designated Market Area ID (US/Canada).
event.dv360_ad_position	int Specifies the position of the ad on the page if known. 1 represents above the fold, 2 represents below the fold.
event.dv360_advertiser_id	int The Display & Video 360 numerical ID for the advertiser related to the event, for example 164332.
event.dv360_adx_page_categories	string DV360 Adx Page Categories
event.dv360_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_browser_id	int The Display & Video 360 numerical ID identifying the browser related to this event.
event.dv360_browser_timezone_offset_minutes	int The difference in minutes between the active timezone on the user's browser and GMT-12, for example 1320 represents a browser timezone of GMT+10.
event.dv360_city_id	int The Display & Video 360 numerical ID identifying the best-guess city of the impression.
event.dv360_country_code	string 2-letter ISO 3166-1 country code identifying the best-guess country of the impression, for example "US".
event.dv360_creative_id	int The Display & Video 360 numerical ID for the creative related to the event, for example 367487.
event.dv360_device_type	int The numerical value of the identified device type. 0 = COMPUTER, 1 = OTHER, 2 = SMARTPHONE, 3 = TABLET, 4 = SMARTTV, 5 = CONNECTEDTV.
event.dv360_isp_id	int The Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.
event.dv360_language	string The ISO-639-1 code or "zh_CN" (Chinese (simplified)), "zh_TW" (Chinese (traditional)) or "other" representing the language related to the view event.
event.dv360_mobile_make_id	int The numerical ID for the mobile make. This value may be missing.
event.dv360_mobile_model_id	int The numerical ID for the mobile model. This value may be missing.
event.dv360_net_speed	int The Display & Video 360 numerical ID representing the network speed related to the view event. 1=Dial-up, 2=EDGE/2G, 3=UMTS/3G, 4=Basic DSL, 5=HSDPA/3.5G, 6=Broadband/4G, 7=Unknown.
event.dv360_operating_system_id	int Operating System ID.
event.dv360_state_region_id	int DV360 Region ID
event.dv360_view_state	string Populated for wrapped tags. (Two impression records when both events occur.) Possible values are: "OUTER", DV360 returned wrapped tag; "INNER", ad served post wrapped tag; "3PAS_MERGED", wrapped tag tracked by CM; "3PAS_OUTER", tracking ping sent to CM but no response, 3rd party blocked ad serving.
event.dv360_zip_postal_code	string DV360 ZIP/Postal Code
event.event_sub_type	string Contains further details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "POSTVIEW", "POSTCLICK" or blank for conversion events.
event.event_time	int Time in microseconds since 1970-01-01 00:00:00 UTC.
event.event_type	string Contains details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "CONVERSION" or blank for conversion events.
event.floodlight_config_id	int Unique ID of the floodlight configuration.
event.impression_id	string Impression ID
event.interaction_time_utc_seconds	string Interaction Time
event.landing_page_url_id	int Unique ID of the landing page URL.
event.operating_system_id	int ID of the operating system.
event.ord_value	string The advertiser's ordinal ID, if relevant for a given activity type. Passed in the 'ord=' key-value (also used for storing the client's Order-ID in sales tags)
event.placement_id	int Unique ID for the site page / placement where the ad ran.
event.platform_type_id	int
event.referrer_url	string Contains the URL on which the ad appeared, when possible. May also be empty, or return ad server URLs.
event.rendering_id	int Unique ID of the creative for Data Transfer. Does not correspond to the UI-Creative-ID.
event.rich_media_event_counters	int MET Counter Value (the ecn= value).
event.rich_media_event_id	int MET Event ID for the Rich Media ad.
event.rich_media_event_timers	double Time in microseconds since 1970-01-01 00:00:00 UTC.rs
event.rich_media_event_type_id	int ID of Rich Media Event Type.
event.site_id	int Unique ID for the site where the ad ran.
event.state	string ID for user's state or province (US/Canada)
event.zip_code	string Postal-Code (US/Canada).
is_in_rdid_project	boolean true if this event is also in the _rdid table. Used for deduplication of events.
network_id	int The network ID.
user_id	string The tracking ID (it is based on, but does not expose the user's browser cookie or mobile device ID). This field may be zeroed out for privacy reasons..

Campaign Manager Data Transfer activities (deprecated)

cm_dt_activities
device_id_md5	string MD5-hashed device ID; a utility may be provided to hash raw device IDs to match.
event	struct
event.active_view_eligible_impressions	int Whether the impression was eligible to measure viewability. An impression is eligible if (a) the ad's creative has an Active View tag and (b) the tag successfully communicates with Google Marketing Platform servers at the time of the impression.
event.active_view_measurable_impressions	int Whether the impression was measurable with Active View.
event.active_view_viewable_impressions	int Whether the impression was viewable.
event.activity_count	int Activity Quantity
event.activity_id	int The ID of the Floodlight tag related to the conversion event.
event.ad_id	int Unique ID of the ad placement.
event.advertiser_id	int Unique ID of the advertiser
event.audience_segment_id	int
event.browser_platform_id	string ID of the browser type.
event.browser_version	string Browser/Platform Version
event.campaign_id	int Unique ID of the campaign
event.city_id	int City ID
event.conversion_id	int Indicates whether an activity has been matched as a post-click (value of 1) or post-impression (value of 2), or unmatched (value of 0).
event.country_code	string Country
event.creative_version	string Creative version number.
event.dma_region_id	int Designated Market Area ID (US/Canada).
event.dv360_ad_position	int Specifies the position of the ad on the page if known. 1 represents above the fold, 2 represents below the fold.
event.dv360_advertiser_id	int The Display & Video 360 numerical ID for the advertiser related to the event, for example 164332.
event.dv360_adx_page_categories	string DV360 Adx Page Categories
event.dv360_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_browser_id	int The Display & Video 360 numerical ID identifying the browser related to this event.
event.dv360_browser_timezone_offset_minutes	int The difference in minutes between the active timezone on the user's browser and GMT-12, for example 1320 represents a browser timezone of GMT+10.
event.dv360_city_id	int The Display & Video 360 numerical ID identifying the best-guess city of the impression.
event.dv360_country_code	string 2-letter ISO 3166-1 country code identifying the best-guess country of the impression, for example "US".
event.dv360_creative_id	int The Display & Video 360 numerical ID for the creative related to the event, for example 367487.
event.dv360_device_type	int The numerical value of the identified device type. 0 = COMPUTER, 1 = OTHER, 2 = SMARTPHONE, 3 = TABLET, 4 = SMARTTV, 5 = CONNECTEDTV.
event.dv360_isp_id	int The Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.
event.dv360_language	string The ISO-639-1 code or "zh_CN" (Chinese (simplified)), "zh_TW" (Chinese (traditional)) or "other" representing the language related to the view event.
event.dv360_mobile_make_id	int The numerical ID for the mobile make. This value may be missing.
event.dv360_mobile_model_id	int The numerical ID for the mobile model. This value may be missing.
event.dv360_net_speed	int The Display & Video 360 numerical ID representing the network speed related to the view event. 1=Dial-up, 2=EDGE/2G, 3=UMTS/3G, 4=Basic DSL, 5=HSDPA/3.5G, 6=Broadband/4G, 7=Unknown.
event.dv360_operating_system_id	int Operating System ID.
event.dv360_state_region_id	int DV360 Region ID
event.dv360_view_state	string Populated for wrapped tags. (Two impression records when both events occur.) Possible values are: "OUTER", DV360 returned wrapped tag; "INNER", ad served post wrapped tag; "3PAS_MERGED", wrapped tag tracked by CM; "3PAS_OUTER", tracking ping sent to CM but no response, 3rd party blocked ad serving.
event.dv360_zip_postal_code	string DV360 ZIP/Postal Code
event.event_sub_type	string Contains further details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "POSTVIEW", "POSTCLICK" or blank for conversion events.
event.event_time	int Time in microseconds since 1970-01-01 00:00:00 UTC.
event.event_type	string Contains details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "CONVERSION" or blank for conversion events.
event.floodlight_config_id	int Unique ID of the floodlight configuration.
event.impression_id	string Impression ID
event.interaction_time_utc_seconds	string Interaction Time
event.landing_page_url_id	int Unique ID of the landing page URL.
event.operating_system_id	int ID of the operating system.
event.ord_value	string The advertiser's ordinal ID, if relevant for a given activity type. Passed in the 'ord=' key-value (also used for storing the client's Order-ID in sales tags)
event.placement_id	int Unique ID for the site page / placement where the ad ran.
event.referrer_url	string Contains the URL on which the ad appeared, when possible. May also be empty, or return ad server URLs.
event.rendering_id	int Unique ID of the creative for Data Transfer. Does not correspond to the UI-Creative-ID.
event.rich_media_event_counters	int MET Counter Value (the ecn= value).
event.rich_media_event_id	int MET Event ID for the Rich Media ad.
event.rich_media_event_timers	double Time in microseconds since 1970-01-01 00:00:00 UTC.rs
event.rich_media_event_type_id	int ID of Rich Media Event Type.
event.site_id	int Unique ID for the site where the ad ran.
event.state	string ID for user's state or province (US/Canada)
event.zip_code	string Postal-Code (US/Canada).
is_in_rdid_project	boolean true if this event is also in the _rdid table. Used for deduplication of events.
network_id	int The network ID.
user_id	string The tracking ID (it is based on, but does not expose the user's browser cookie or mobile device ID). This field may be zeroed out for privacy reasons..

Campaign Manager Data Transfer activities attributed

cm_dt_activities_attributed
device_id_md5	string MD5-hashed device ID; a utility may be provided to hash raw device IDs to match.
event	struct
event.activity_id	int The ID of the Floodlight tag related to the conversion event.
event.ad_id	int Unique ID of the ad placement.
event.advertiser_id	int Unique ID of the advertiser
event.attribution_model_config_id	int Attribution model ID as displayed in CM UI.
event.audience_segment_id	int
event.browser_platform_id	string ID of the browser type.
event.browser_version	string Browser/Platform Version
event.campaign_id	int Unique ID of the campaign
event.city_id	int City ID
event.conversion_event_id	string Unique ID of the conversion event.
event.conversion_id	int DEPRECATED - see event.sub_event_type
event.country_code	string Country
event.creative_version	string Creative version number.
event.dma_region_id	int Designated Market Area ID (US/Canada).
event.dv360_ad_position	int Specifies the position of the ad on the page if known. 1 represents above the fold, 2 represents below the fold.
event.dv360_advertiser_id	int The Display & Video 360 numerical ID for the advertiser related to the event, for example 164332.
event.dv360_adx_page_categories	string DV360 Adx Page Categories
event.dv360_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_browser_id	int The Display & Video 360 numerical ID identifying the browser related to this event.
event.dv360_browser_timezone_offset_minutes	int The difference in minutes between the active timezone on the user's browser and GMT-12, for example 1320 represents a browser timezone of GMT+10.
event.dv360_city_id	int The Display & Video 360 numerical ID identifying the best-guess city of the impression.
event.dv360_country_code	string 2-letter ISO 3166-1 country code identifying the best-guess country of the impression, for example "US".
event.dv360_creative_id	int The Display & Video 360 numerical ID for the creative related to the event, for example 367487.
event.dv360_device_type	int The numerical value of the identified device type. 0 = COMPUTER, 1 = OTHER, 2 = SMARTPHONE, 3 = TABLET, 4 = SMARTTV, 5 = CONNECTEDTV.
event.dv360_isp_id	int The Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.
event.dv360_language	string The ISO-639-1 code or "zh_CN" (Chinese (simplified)), "zh_TW" (Chinese (traditional)) or "other" representing the language related to the view event.
event.dv360_mobile_make_id	int The numerical ID for the mobile make. This value may be missing.
event.dv360_mobile_model_id	int The numerical ID for the mobile model. This value may be missing.
event.dv360_net_speed	int The Display & Video 360 numerical ID representing the network speed related to the view event. 1=Dial-up, 2=EDGE/2G, 3=UMTS/3G, 4=Basic DSL, 5=HSDPA/3.5G, 6=Broadband/4G, 7=Unknown.
event.dv360_operating_system_id	int Operating System ID.
event.dv360_state_region_id	int DV360 Region ID
event.dv360_view_state	string Populated for wrapped tags. (Two impression records when both events occur.) Possible values are: "OUTER", DV360 returned wrapped tag; "INNER", ad served post wrapped tag; "3PAS_MERGED", wrapped tag tracked by CM; "3PAS_OUTER", tracking ping sent to CM but no response, 3rd party blocked ad serving.
event.dv360_zip_postal_code	string DV360 ZIP/Postal Code
event.event_sub_type	string Contains further details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "POSTVIEW", "POSTCLICK" or blank for conversion events.
event.event_time	int Time in microseconds since 1970-01-01 00:00:00 UTC.
event.event_type	string Contains details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "CONVERSION" or blank for conversion events.
event.floodlight_config_id	int Unique ID of the floodlight configuration.
event.impression_id	string Impression ID
event.interaction_time_utc_seconds	string Interaction Time
event.landing_page_url_id	int Unique ID of the landing page URL.
event.operating_system_id	int ID of the operating system.
event.ord_value	string The advertiser's ordinal ID, if relevant for a given activity type. Passed in the 'ord=' key-value (also used for storing the client's Order-ID in sales tags)
event.placement_id	int Unique ID for the site page / placement where the ad ran.
event.referrer_url	string Contains the URL on which the ad appeared, when possible. May also be empty, or return ad server URLs.
event.rendering_id	int Unique ID of the creative for Data Transfer. Does not correspond to the UI-Creative-ID.
event.rich_media_event_counters	int MET Counter Value (the ecn= value).
event.rich_media_event_id	int MET Event ID for the Rich Media ad.
event.rich_media_event_timers	double Time in microseconds since 1970-01-01 00:00:00 UTC.rs
event.rich_media_event_type_id	int ID of Rich Media Event Type.
event.site_id	int Unique ID for the site where the ad ran.
event.state	string ID for user's state or province (US/Canada)
event.total_conversions	double The amount of conversion credit in nanos credited to the attributed event. For sales activities, Floodlight might count more than one conversion per event. For example, you can set up Floodlight to count the number of items purchased as the number of conversions for a single event. (The double value of the int event.activity_count in activities_events)
event.total_conversions_revenue	double The amount of revenue in USD megas credited to the attributed. You can multiply by 1,000,000 to see it as a dollar amount. (The attributed version of event.activity_revenue in activities_events)
event.total_transaction_count	double The number of transactions or activity tag fires in nanos credited to the attributed event.
event.zip_code	string Postal-Code (US/Canada).
is_in_rdid_project	boolean true if this event is also in the _rdid table. Used for deduplication of events.
network_id	int The network ID.
user_id	string The tracking ID (it is based on, but does not expose the user's browser cookie or mobile device ID). This field may be zeroed out for privacy reasons..

Campaign Manager Data Transfer activities events

cm_dt_activities_events
event.activity_count	int
event.activity_id	int The ID of the Floodlight tag related to the conversion event.
event.browser_platform_id	string ID of the browser type.
event.browser_version	string Browser/Platform Version
event.conversion_event_id	int Unique ID of the conversion event.
event.country_code	string Country
event.event_time	int Time in microseconds since 1970-01-01 00:00:00 UTC.
event.floodlight_config_id	int Unique ID of the floodlight configuration.
event.ord_value	string The advertiser's ordinal ID, if relevant for a given activity type. Passed in the 'ord=' key-value (also used for storing the client's Order-ID in sales tags)
event.platform_type_id	int
event.state	string ID for user's state or province (US/Canada)
is_in_rdid_project	boolean true if this event is also in the _rdid table. Used for deduplication of events.
network_id	int The network ID.
user_id	string The tracking ID (it is based on, but does not expose the user's browser cookie or mobile device ID). This field may be zeroed out for privacy reasons..

Campaign Manager Data Transfer activity category

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

Campaign Manager Data Transfer activity type

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

Campaign Manager Data Transfer ad

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

Campaign Manager Data Transfer Ad placement assignments

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

Campaign Manager Data Transfer Advertiser

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

Campaign Manager Data Transfer asset

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

Campaign Manager Data Transfer audience segments

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

Campaign Manager Data Transfer browser

cm_dt_browser
browser_platform	string
browser_platform_id	int Browser / Platform ID

Campaign Manager Data Transfer campaign

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

Campaign Manager Data Transfer city

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

Campaign Manager Data Transfer clicks

cm_dt_clicks
event.operating_system_id	int ID of the operating system.
device_id_md5	string MD5-hashed device ID; a utility may be provided to hash raw device IDs to match.
event	struct
event.active_view_eligible_impressions	int Whether the impression was eligible to measure viewability. An impression is eligible if (a) the ad's creative has an Active View tag and (b) the tag successfully communicates with Google Marketing Platform servers at the time of the impression.
event.active_view_measurable_impressions	int Whether the impression was measurable with Active View.
event.activity_count	int Activity Quantity
event.activity_id	int The ID of the Floodlight tag related to the conversion event.
event.ad_id	int Unique ID of the ad placement.
event.advertiser_id	int Unique ID of the advertiser
event.audience_segment_id	int
event.browser_platform_id	string ID of the browser type.
event.browser_version	string Browser/Platform Version
event.campaign_id	int Unique ID of the campaign
event.city_id	int City ID
event.conversion_id	int Indicates whether an activity has been matched as a post-click (value of 1) or post-impression (value of 2), or unmatched (value of 0).
event.country_code	string Country
event.creative_version	string Creative version number.
event.dma_region_id	int Designated Market Area ID (US/Canada).
event.dv360_ad_position	int Specifies the position of the ad on the page if known. 1 represents above the fold, 2 represents below the fold.
event.dv360_advertiser_id	int The Display & Video 360 numerical ID for the advertiser related to the event, for example 164332.
event.dv360_adx_page_categories	string DV360 Adx Page Categories
event.dv360_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_browser_id	int The Display & Video 360 numerical ID identifying the browser related to this event.
event.dv360_browser_timezone_offset_minutes	int The difference in minutes between the active timezone on the user's browser and GMT-12, for example 1320 represents a browser timezone of GMT+10.
event.dv360_city_id	int The Display & Video 360 numerical ID identifying the best-guess city of the impression.
event.dv360_country_code	string 2-letter ISO 3166-1 country code identifying the best-guess country of the impression, for example "US".
event.dv360_creative_id	int The Display & Video 360 numerical ID for the creative related to the event, for example 367487.
event.dv360_device_type	int The numerical value of the identified device type. 0 = COMPUTER, 1 = OTHER, 2 = SMARTPHONE, 3 = TABLET, 4 = SMARTTV, 5 = CONNECTEDTV.
event.dv360_isp_id	int The Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.
event.dv360_language	string The ISO-639-1 code or "zh_CN" (Chinese (simplified)), "zh_TW" (Chinese (traditional)) or "other" representing the language related to the view event.
event.dv360_mobile_make_id	int The numerical ID for the mobile make. This value may be missing.
event.dv360_mobile_model_id	int The numerical ID for the mobile model. This value may be missing.
event.dv360_net_speed	int The Display & Video 360 numerical ID representing the network speed related to the view event. 1=Dial-up, 2=EDGE/2G, 3=UMTS/3G, 4=Basic DSL, 5=HSDPA/3.5G, 6=Broadband/4G, 7=Unknown.
event.dv360_operating_system_id	int DV60 operating system ID
event.dv360_state_region_id	int DV360 Region ID
event.dv360_view_state	string Populated for wrapped tags. (Two impression records when both events occur.) Possible values are: "OUTER", DV360 returned wrapped tag; "INNER", ad served post wrapped tag; "3PAS_MERGED", wrapped tag tracked by CM; "3PAS_OUTER", tracking ping sent to CM but no response, 3rd party blocked ad serving.
event.dv360_zip_postal_code	string DV360 ZIP/Postal Code
event.event_sub_type	string Contains further details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "POSTVIEW", "POSTCLICK" or blank for conversion events.
event.event_time	int Time in microseconds since 1970-01-01 00:00:00 UTC.
event.event_type	string Contains details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "CONVERSION" or blank for conversion events.
event.floodlight_config_id	int Unique ID of the floodlight configuration.
event.impression_id	string Impression ID
event.interaction_time_utc_seconds	string Interaction Time
event.landing_page_url_id	int Unique ID of the landing page URL.
event.operating_system_id	int ID of the operating system.
event.ord_value	string The advertiser's ordinal ID, if relevant for a given activity type. Passed in the 'ord=' key-value (also used for storing the client's Order-ID in sales tags)
event.placement_id	int Unique ID for the site page / placement where the ad ran.
event.platform_type_id	int
event.referrer_url	string Contains the URL on which the ad appeared, when possible. May also be empty, or return ad server URLs.
event.rendering_id	int Unique ID of the creative for Data Transfer. Does not correspond to the UI-Creative-ID.
event.rich_media_event_counters	int MET Counter Value (the ecn= value).
event.rich_media_event_id	int MET Event ID for the Rich Media ad.
event.rich_media_event_timers	double Time in microseconds since 1970-01-01 00:00:00 UTC.rs
event.rich_media_event_type_id	int ID of Rich Media Event Type.
event.site_id	int Unique ID for the site where the ad ran.
event.state	string ID for user's state or province (US/Canada)
event.zip_code	string Postal-Code (US/Canada).
is_in_rdid_project	boolean true if this event is also in the _rdid table. Used for deduplication of events.
network_id	int The network ID.
user_id	string The tracking ID (it is based on, but does not expose the user's browser cookie or mobile device ID). This field may be zeroed out for privacy reasons..

Campaign Manager Data Transfer creative

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

Campaign Manager Data Transfer creative ad assignment

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

Campaign Manager Data Transfer custom creative field

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

Campaign Manager Data Transfer custom rich media

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

Campaign Manager Data Transfer designated market area

cm_dt_designated_market_area
dma_region	string
dma_region_id	int

Campaign Manager Data Transfer impressions

cm_dt_impressions
device_id_md5	string MD5-hashed device ID. Utility will be provided to hash raw device IDs to match.
event	struct
event.active_view_eligible_impressions	int Whether the impression was eligible to measure viewability. An impression is eligible if (a) the ad's creative has an Active View tag and (b) the tag successfully communicates with Google Marketing Platform servers at the time of the impression.
event.active_view_measurable_impressions	int Whether the impression was measurable with Active View.
event.activity_count	int Activity Quantity
event.activity_id	int The ID of the Floodlight tag related to the conversion event.
event.ad_id	int Unique ID of the ad placement.
event.advertiser_id	int Unique ID of the advertiser
event.audience_segment_id	int
event.browser_platform_id	string ID of the browser type.
event.browser_version	string Browser/Platform Version
event.campaign_id	int Unique ID of the campaign
event.city_id	int City ID
event.conversion_id	int Indicates whether an activity has been matched as a post-click (value of 1) or post-impression (value of 2), or unmatched (value of 0).
event.country_code	string Country
event.creative_version	string Creative version number.
event.dma_region_id	int Designated Market Area ID (US/Canada).
event.dv360_ad_position	int Specifies the position of the ad on the page if known. 1 represents above the fold, 2 represents below the fold.
event.dv360_advertiser_id	int The Display & Video 360 numerical ID for the advertiser related to the event, for example 164332.
event.dv360_adx_page_categories	string DV360 Adx Page Categories
event.dv360_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_browser_id	int The Display & Video 360 numerical ID identifying the browser related to this event.
event.dv360_browser_timezone_offset_minutes	int The difference in minutes between the active timezone on the user's browser and GMT-12, for example 1320 represents a browser timezone of GMT+10.
event.dv360_city_id	int The Display & Video 360 numerical ID identifying the best-guess city of the impression.
event.dv360_country_code	string 2-letter ISO 3166-1 country code identifying the best-guess country of the impression, for example "US".
event.dv360_creative_id	int The Display & Video 360 numerical ID for the creative related to the event, for example 367487.
event.dv360_device_type	int The numerical value of the identified device type. 0 = COMPUTER, 1 = OTHER, 2 = SMARTPHONE, 3 = TABLET, 4 = SMARTTV, 5 = CONNECTEDTV.
event.dv360_isp_id	int The Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.
event.dv360_language	string The ISO-639-1 code or "zh_CN" (Chinese (simplified)), "zh_TW" (Chinese (traditional)) or "other" representing the language related to the view event.
event.dv360_mobile_make_id	int The numerical ID for the mobile make. This value may be missing.
event.dv360_mobile_model_id	int The numerical ID for the mobile model. This value may be missing.
event.dv360_net_speed	int The Display & Video 360 numerical ID representing the network speed related to the view event. 1=Dial-up, 2=EDGE/2G, 3=UMTS/3G, 4=Basic DSL, 5=HSDPA/3.5G, 6=Broadband/4G, 7=Unknown.
event.dv360_operating_system_id	int
event.dv360_state_region_id	int DV360 Region ID
event.dv360_view_state	string Populated for wrapped tags. (Two impression records when both events occur.) Possible values are: "OUTER", DV360 returned wrapped tag; "INNER", ad served post wrapped tag; "3PAS_MERGED", wrapped tag tracked by CM; "3PAS_OUTER", tracking ping sent to CM but no response, 3rd party blocked ad serving.
event.dv360_zip_postal_code	string DV360 ZIP/Postal Code
event.event_sub_type	string Contains further details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "POSTVIEW", "POSTCLICK" or blank for conversion events.
event.event_time	int Time in microseconds since 1970-01-01 00:00:00 UTC.
event.event_type	string Contains details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "CONVERSION" or blank for conversion events.
event.floodlight_config_id	int Unique ID of the floodlight configuration.
event.impression_id	string Impression ID
event.interaction_time_utc_seconds	string Interaction Time
event.landing_page_url_id	int Unique ID of the landing page URL.
event.operating_system_id	int ID of the operating system.
event.ord_value	string The advertiser's ordinal ID, if relevant for a given activity type. Passed in the 'ord=' key-value (also used for storing the client's Order-ID in sales tags)
event.placement_id	int Unique ID for the site page / placement where the ad ran.
event.platform_type_id	int
event.referrer_url	string Contains the URL on which the ad appeared, when possible. May also be empty, or return ad server URLs.
event.rendering_id	int Unique ID of the creative for Data Transfer. Does not correspond to the UI-Creative-ID.
event.rich_media_event_counters	int MET Counter Value (the ecn= value).
event.rich_media_event_id	int MET Event ID for the Rich Media ad.
event.rich_media_event_timers	double Time in microseconds since 1970-01-01 00:00:00 UTC.rs
event.rich_media_event_type_id	int ID of Rich Media Event Type.
event.site_id	int Unique ID for the site where the ad ran.
event.state	string ID for user's state or province (US/Canada)
event.zip_code	string Postal-Code (US/Canada).
is_in_rdid_project	boolean true if this event is also in the _rdid table. Used for deduplication of events.
network_id	int The network ID.
user_id	string The tracking ID (it is based on, but does not expose the user's browser cookie or mobile device ID). This field may be zeroed out for privacy reasons..

Campaign Manager Data Transfer landing page url

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

Campaign Manager Data Transfer operating system

cm_dt_operating_system
operating_system	string
operating_system_id	int Unique ID of OS just for Data Transfer.

Campaign Manager Data Transfer placement

cm_dt_placement
account_id	int Unique ID of the account.
activity_id	int Unique ID of the Floodlight activity.
advertiser_id	int Unique ID of the advertiser.
campaign_id	int Unique ID of the campaign.
content_category	string User defined content category.
content_category_id	int ID of content category.
floodlight_config_id	int Unique ID of the floodlight configuration.
placement	string
placement_id	int
site_id	int Unique ID of the site.
site_keyname	string

Campaign Manager Data Transfer rich media

cm_dt_rich_media
device_id_md5	string MD5-hashed device ID; a utility may be provided to hash raw device IDs to match.
event	struct
event.active_view_eligible_impressions	int Whether the impression was eligible to measure viewability. An impression is eligible if (a) the ad's creative has an Active View tag and (b) the tag successfully communicates with Google Marketing Platform servers at the time of the impression.
event.active_view_measurable_impressions	int Whether the impression was measurable with Active View.
event.active_view_viewable_impressions	int Whether the impression was viewable.
event.activity_count	int Activity Quantity
event.activity_id	int The ID of the Floodlight tag related to the conversion event.
event.ad_id	int Unique ID of the ad placement.
event.advertiser_id	int Unique ID of the advertiser
event.audience_segment_id	int
event.browser_platform_id	string ID of the browser type.
event.browser_version	string Browser/Platform Version
event.campaign_id	int Unique ID of the campaign
event.city_id	int City ID
event.conversion_id	int Indicates whether an activity has been matched as a post-click (value of 1) or post-impression (value of 2), or unmatched (value of 0).
event.country_code	string Country
event.creative_version	string Creative version number.
event.dma_region_id	int Designated Market Area ID (US/Canada).
event.dv360_ad_position	int Specifies the position of the ad on the page if known. 1 represents above the fold, 2 represents below the fold.
event.dv360_advertiser_id	int The Display & Video 360 numerical ID for the advertiser related to the event, for example 164332.
event.dv360_adx_page_categories	string DV360 Adx Page Categories
event.dv360_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_browser_id	int The Display & Video 360 numerical ID identifying the browser related to this event.
event.dv360_browser_timezone_offset_minutes	int The difference in minutes between the active timezone on the user's browser and GMT-12, for example 1320 represents a browser timezone of GMT+10.
event.dv360_city_id	int The Display & Video 360 numerical ID identifying the best-guess city of the impression.
event.dv360_country_code	string 2-letter ISO 3166-1 country code identifying the best-guess country of the impression, for example "US".
event.dv360_creative_id	int The Display & Video 360 numerical ID for the creative related to the event, for example 367487.
event.dv360_device_type	int The numerical value of the identified device type. 0 = COMPUTER, 1 = OTHER, 2 = SMARTPHONE, 3 = TABLET, 4 = SMARTTV, 5 = CONNECTEDTV.
event.dv360_isp_id	int The Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.
event.dv360_language	string The ISO-639-1 code or "zh_CN" (Chinese (simplified)), "zh_TW" (Chinese (traditional)) or "other" representing the language related to the view event.
event.dv360_mobile_make_id	int The numerical ID for the mobile make. This value may be missing.
event.dv360_mobile_model_id	int The numerical ID for the mobile model. This value may be missing.
event.dv360_net_speed	int The Display & Video 360 numerical ID representing the network speed related to the view event. 1=Dial-up, 2=EDGE/2G, 3=UMTS/3G, 4=Basic DSL, 5=HSDPA/3.5G, 6=Broadband/4G, 7=Unknown.
event.dv360_operating_system_id	int
event.dv360_state_region_id	int DV360 Region ID
event.dv360_view_state	string Populated for wrapped tags. (Two impression records when both events occur.) Possible values are: "OUTER", DV360 returned wrapped tag; "INNER", ad served post wrapped tag; "3PAS_MERGED", wrapped tag tracked by CM; "3PAS_OUTER", tracking ping sent to CM but no response, 3rd party blocked ad serving.
event.dv360_zip_postal_code	string DV360 ZIP/Postal Code
event.event_sub_type	string Contains further details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "POSTVIEW", "POSTCLICK" or blank for conversion events.
event.event_time	int Time in microseconds since 1970-01-01 00:00:00 UTC.
event.event_type	string Contains details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "CONVERSION" or blank for conversion events.
event.floodlight_config_id	int Unique ID of the floodlight configuration.
event.impression_id	string Impression ID
event.interaction_time_utc_seconds	string Interaction Time
event.landing_page_url_id	int Unique ID of the landing page URL.
event.operating_system_id	int ID of the operating system.
event.ord_value	string The advertiser's ordinal ID, if relevant for a given activity type. Passed in the 'ord=' key-value (also used for storing the client's Order-ID in sales tags)
event.placement_id	int Unique ID for the site page / placement where the ad ran.
event.platform_type_id	int
event.referrer_url	string Contains the URL on which the ad appeared, when possible. May also be empty, or return ad server URLs.
event.rendering_id	int Unique ID of the creative for Data Transfer. Does not correspond to the UI-Creative-ID.
event.rich_media_event_counters	int MET Counter Value (the ecn= value).
event.rich_media_event_id	int MET Event ID for the Rich Media ad.
event.rich_media_event_timers	double Time in microseconds since 1970-01-01 00:00:00 UTC.rs
event.rich_media_event_type_id	int ID of Rich Media Event Type.
event.site_id	int Unique ID for the site where the ad ran.
event.state	string ID for user's state or province (US/Canada)
event.zip_code	string Postal-Code (US/Canada).
is_in_rdid_project	boolean true if this event is also in the _rdid table. Used for deduplication of events.
network_id	int The network ID.
user_id	string The tracking ID (it is based on, but does not expose the user's browser cookie or mobile device ID). This field may be zeroed out for privacy reasons..

Campaign Manager Data Transfer site

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

Campaign Manager 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
device_id_md5	string MD5-hashed device ID. Utility will be provided to hash raw device IDs to match.
event	struct
event.active_view_eligible_impressions	int Whether the impression was eligible to measure viewability. An impression is eligible if (a) the ad's creative has an Active View tag and (b) the tag successfully communicates with Google Marketing Platform servers at the time of the impression.
event.active_view_measurable_impressions	int Whether the impression was measurable with Active View.
event.active_view_viewable_impressions	int Whether the impression was viewable.
event.activity_count	int Activity Quantity
event.activity_id	int The ID of the Floodlight tag related to the conversion event.
event.ad_id	int Unique ID of the ad placement.
event.advertiser_id	int Unique ID of the advertiser
event.audience_segment_id	int
event.browser_platform_id	string ID of the browser type.
event.browser_version	string Browser/Platform Version
event.campaign_id	int Unique ID of the campaign
event.city_id	int City ID
event.conversion_id	int Indicates whether an activity has been matched as a post-click (value of 1) or post-impression (value of 2), or unmatched (value of 0).
event.country_code	string Country
event.creative_version	string Creative version number.
event.dma_region_id	int Designated Market Area ID (US/Canada).
event.dv360_ad_position	int Specifies the position of the ad on the page if known. 1 represents above the fold, 2 represents below the fold.
event.dv360_advertiser_id	int The Display & Video 360 numerical ID for the advertiser related to the event, for example 164332.
event.dv360_adx_page_categories	string DV360 Adx Page Categories
event.dv360_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_browser_id	int The Display & Video 360 numerical ID identifying the browser related to this event.
event.dv360_browser_timezone_offset_minutes	int The difference in minutes between the active timezone on the user's browser and GMT-12, for example 1320 represents a browser timezone of GMT+10.
event.dv360_city_id	int The Display & Video 360 numerical ID identifying the best-guess city of the impression.
event.dv360_country_code	string 2-letter ISO 3166-1 country code identifying the best-guess country of the impression, for example "US".
event.dv360_creative_id	int The Display & Video 360 numerical ID for the creative related to the event, for example 367487.
event.dv360_device_type	int The numerical value of the identified device type. 0 = COMPUTER, 1 = OTHER, 2 = SMARTPHONE, 3 = TABLET, 4 = SMARTTV, 5 = CONNECTEDTV.
event.dv360_isp_id	int The Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.
event.dv360_language	string The ISO-639-1 code or "zh_CN" (Chinese (simplified)), "zh_TW" (Chinese (traditional)) or "other" representing the language related to the view event.
event.dv360_mobile_make_id	int The numerical ID for the mobile make. This value may be missing.
event.dv360_mobile_model_id	int The numerical ID for the mobile model. This value may be missing.
event.dv360_net_speed	int The Display & Video 360 numerical ID representing the network speed related to the view event. 1=Dial-up, 2=EDGE/2G, 3=UMTS/3G, 4=Basic DSL, 5=HSDPA/3.5G, 6=Broadband/4G, 7=Unknown.
event.dv360_operating_system_id	int
event.dv360_state_region_id	int DV360 Region ID
event.dv360_view_state	string Populated for wrapped tags. (Two impression records when both events occur.) Possible values are: "OUTER", DV360 returned wrapped tag; "INNER", ad served post wrapped tag; "3PAS_MERGED", wrapped tag tracked by CM; "3PAS_OUTER", tracking ping sent to CM but no response, 3rd party blocked ad serving.
event.dv360_zip_postal_code	string DV360 ZIP/Postal Code
event.event_sub_type	string Contains further details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "POSTVIEW", "POSTCLICK" or blank for conversion events.
event.event_time	int Time in microseconds since 1970-01-01 00:00:00 UTC.
event.event_type	string Contains details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "CONVERSION" or blank for conversion events.
event.floodlight_config_id	int Unique ID of the floodlight configuration.
event.impression_id	string Impression ID
event.interaction_time_utc_seconds	string Interaction Time
event.landing_page_url_id	int Unique ID of the landing page URL.
event.operating_system_id	int ID of the operating system.
event.ord_value	string The advertiser's ordinal ID, if relevant for a given activity type. Passed in the 'ord=' key-value (also used for storing the client's Order-ID in sales tags)
event.placement_id	int Unique ID for the site page / placement where the ad ran.
event.platform_type_id	int
event.referrer_url	string Contains the URL on which the ad appeared, when possible. May also be empty, or return ad server URLs.
event.rendering_id	int Unique ID of the creative for Data Transfer. Does not correspond to the UI-Creative-ID.
event.rich_media_event_counters	int MET Counter Value (the ecn= value).
event.rich_media_event_id	int MET Event ID for the Rich Media ad.
event.rich_media_event_timers	double Time in microseconds since 1970-01-01 00:00:00 UTC.rs
event.rich_media_event_type_id	int ID of Rich Media Event Type.
event.site_id	int Unique ID for the site where the ad ran.
event.state	string ID for user's state or province (US/Canada)
event.zip_code	string Postal-Code (US/Canada).
is_in_rdid_project	boolean true if this event is also in the _rdid table. Used for deduplication of events.
network_id	int The network ID.
user_id	string The tracking ID (it is based on, but does not expose the user's browser cookie or mobile device ID). This field may be zeroed out for privacy reasons..

DV360 Data Transfer activities (deprecated)

dv360_dt_activities
device_id_md5	string MD5-hashed device ID. Utility will be provided to hash raw device IDs to match.
event	struct
event.active_view_eligible_impressions	int Whether the impression was eligible to measure viewability. An impression is eligible if (a) the ad's creative has an Active View tag and (b) the tag successfully communicates with Google Marketing Platform servers at the time of the impression.
event.active_view_measurable_impressions	int Whether the impression was measurable with Active View.
event.active_view_viewable_impressions	int Whether the impression was viewable.
event.activity_count	int Activity Quantity
event.activity_id	int The ID of the Floodlight tag related to the conversion event.
event.ad_id	int Unique ID of the ad placement.
event.advertiser_id	int Unique ID of the advertiser
event.audience_segment_id	int
event.browser_platform_id	string ID of the browser type.
event.browser_version	string Browser/Platform Version
event.campaign_id	int Unique ID of the campaign
event.city_id	int City ID
event.conversion_id	int Indicates whether an activity has been matched as a post-click (value of 1) or post-impression (value of 2), or unmatched (value of 0).
event.country_code	string Country
event.creative_version	string Creative version number.
event.dma_region_id	int Designated Market Area ID (US/Canada).
event.dv360_ad_position	int Specifies the position of the ad on the page if known. 1 represents above the fold, 2 represents below the fold.
event.dv360_advertiser_id	int The Display & Video 360 numerical ID for the advertiser related to the event, for example 164332.
event.dv360_adx_page_categories	string DV360 Adx Page Categories
event.dv360_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_browser_id	int The Display & Video 360 numerical ID identifying the browser related to this event.
event.dv360_browser_timezone_offset_minutes	int The difference in minutes between the active timezone on the user's browser and GMT-12, for example 1320 represents a browser timezone of GMT+10.
event.dv360_city_id	int The Display & Video 360 numerical ID identifying the best-guess city of the impression.
event.dv360_country_code	string 2-letter ISO 3166-1 country code identifying the best-guess country of the impression, for example "US".
event.dv360_creative_id	int The Display & Video 360 numerical ID for the creative related to the event, for example 367487.
event.dv360_device_type	int The numerical value of the identified device type. 0 = COMPUTER, 1 = OTHER, 2 = SMARTPHONE, 3 = TABLET, 4 = SMARTTV, 5 = CONNECTEDTV.
event.dv360_isp_id	int The Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.
event.dv360_language	string The ISO-639-1 code or "zh_CN" (Chinese (simplified)), "zh_TW" (Chinese (traditional)) or "other" representing the language related to the view event.
event.dv360_mobile_make_id	int The numerical ID for the mobile make. This value may be missing.
event.dv360_mobile_model_id	int The numerical ID for the mobile model. This value may be missing.
event.dv360_net_speed	int The Display & Video 360 numerical ID representing the network speed related to the view event. 1=Dial-up, 2=EDGE/2G, 3=UMTS/3G, 4=Basic DSL, 5=HSDPA/3.5G, 6=Broadband/4G, 7=Unknown.
event.dv360_operating_system_id	int
event.dv360_state_region_id	int DV360 Region ID
event.dv360_view_state	string Populated for wrapped tags. (Two impression records when both events occur.) Possible values are: "OUTER", DV360 returned wrapped tag; "INNER", ad served post wrapped tag; "3PAS_MERGED", wrapped tag tracked by CM; "3PAS_OUTER", tracking ping sent to CM but no response, 3rd party blocked ad serving.
event.dv360_zip_postal_code	string DV360 ZIP/Postal Code
event.event_sub_type	string Contains further details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "POSTVIEW", "POSTCLICK" or blank for conversion events.
event.event_time	int Time in microseconds since 1970-01-01 00:00:00 UTC.
event.event_type	string Contains details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "CONVERSION" or blank for conversion events.
event.floodlight_config_id	int Unique ID of the floodlight configuration.
event.impression_id	string Impression ID
event.interaction_time_utc_seconds	string Interaction Time
event.landing_page_url_id	int Unique ID of the landing page URL.
event.operating_system_id	int ID of the operating system.
event.ord_value	string The advertiser's ordinal ID, if relevant for a given activity type. Passed in the 'ord=' key-value (also used for storing the client's Order-ID in sales tags)
event.placement_id	int Unique ID for the site page / placement where the ad ran.
event.platform_type_id	int
event.referrer_url	string Contains the URL on which the ad appeared, when possible. May also be empty, or return ad server URLs.
event.rendering_id	int Unique ID of the creative for Data Transfer. Does not correspond to the UI-Creative-ID.
event.rich_media_event_counters	int MET Counter Value (the ecn= value).
event.rich_media_event_id	int MET Event ID for the Rich Media ad.
event.rich_media_event_timers	double Time in microseconds since 1970-01-01 00:00:00 UTC.rs
event.rich_media_event_type_id	int ID of Rich Media Event Type.
event.site_id	int Unique ID for the site where the ad ran.
event.state	string ID for user's state or province (US/Canada)
event.zip_code	string Postal-Code (US/Canada).
is_in_rdid_project	boolean true if this event is also in the _rdid table. Used for deduplication of events.
network_id	int The network ID.
user_id	string The tracking ID (it is based on, but does not expose the user's browser cookie or mobile device ID). This field may be zeroed out for privacy reasons..

DV360 Data Transfer activities attributed

dv360_dt_activities_attributed
device_id_md5	string MD5-hashed device ID; a utility may be provided to hash raw device IDs to match.
event	struct
event.activity_id	int The ID of the Floodlight tag related to the conversion event.
event.ad_id	int Unique ID of the ad placement.
event.advertiser_id	int Unique ID of the advertiser
event.attribution_model_config_id	int Attribution model ID as displayed in DV360 UI.
event.audience_segment_id	int
event.browser_platform_id	string ID of the browser type.
event.browser_version	string Browser/Platform Version
event.campaign_id	int Unique ID of the campaign
event.city_id	int City ID
event.conversion_event_id	string Unique ID of the conversion event.
event.conversion_id	int DEPRECATED - see event.sub_event_type
event.country_code	string Country
event.creative_version	string Creative version number.
event.dma_region_id	int Designated Market Area ID (US/Canada).
event.dv360_ad_position	int Specifies the position of the ad on the page if known. 1 represents above the fold, 2 represents below the fold.
event.dv360_advertiser_id	int The Display & Video 360 numerical ID for the advertiser related to the event, for example 164332.
event.dv360_adx_page_categories	string DV360 Adx Page Categories
event.dv360_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_browser_id	int The Display & Video 360 numerical ID identifying the browser related to this event.
event.dv360_browser_timezone_offset_minutes	int The difference in minutes between the active timezone on the user's browser and GMT-12, for example 1320 represents a browser timezone of GMT+10.
event.dv360_city_id	int The Display & Video 360 numerical ID identifying the best-guess city of the impression.
event.dv360_country_code	string 2-letter ISO 3166-1 country code identifying the best-guess country of the impression, for example "US".
event.dv360_creative_id	int The Display & Video 360 numerical ID for the creative related to the event, for example 367487.
event.dv360_device_type	int The numerical value of the identified device type. 0 = COMPUTER, 1 = OTHER, 2 = SMARTPHONE, 3 = TABLET, 4 = SMARTTV, 5 = CONNECTEDTV.
event.dv360_isp_id	int The Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.
event.dv360_language	string The ISO-639-1 code or "zh_CN" (Chinese (simplified)), "zh_TW" (Chinese (traditional)) or "other" representing the language related to the view event.
event.dv360_mobile_make_id	int The numerical ID for the mobile make. This value may be missing.
event.dv360_mobile_model_id	int The numerical ID for the mobile model. This value may be missing.
event.dv360_net_speed	int The Display & Video 360 numerical ID representing the network speed related to the view event. 1=Dial-up, 2=EDGE/2G, 3=UMTS/3G, 4=Basic DSL, 5=HSDPA/3.5G, 6=Broadband/4G, 7=Unknown.
event.dv360_operating_system_id	int Operating System ID.
event.dv360_state_region_id	int DV360 Region ID
event.dv360_view_state	string Populated for wrapped tags. (Two impression records when both events occur.) Possible values are: "OUTER", DV360 returned wrapped tag; "INNER", ad served post wrapped tag; "3PAS_MERGED", wrapped tag tracked by CM; "3PAS_OUTER", tracking ping sent to CM but no response, 3rd party blocked ad serving.
event.dv360_zip_postal_code	string DV360 ZIP/Postal Code
event.event_sub_type	string Contains further details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "POSTVIEW", "POSTCLICK" or blank for conversion events.
event.event_time	int Time in microseconds since 1970-01-01 00:00:00 UTC.
event.event_type	string Contains details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "CONVERSION" or blank for conversion events.
event.floodlight_config_id	int Unique ID of the floodlight configuration.
event.impression_id	string Impression ID
event.interaction_time_utc_seconds	string Interaction Time
event.landing_page_url_id	int Unique ID of the landing page URL.
event.operating_system_id	int ID of the operating system.
event.ord_value	string The advertiser's ordinal ID, if relevant for a given activity type. Passed in the 'ord=' key-value (also used for storing the client's Order-ID in sales tags)
event.placement_id	int Unique ID for the site page / placement where the ad ran.
event.referrer_url	string Contains the URL on which the ad appeared, when possible. May also be empty, or return ad server URLs.
event.rendering_id	int Unique ID of the creative for Data Transfer. Does not correspond to the UI-Creative-ID.
event.rich_media_event_counters	int MET Counter Value (the ecn= value).
event.rich_media_event_id	int MET Event ID for the Rich Media ad.
event.rich_media_event_timers	double Time in microseconds since 1970-01-01 00:00:00 UTC.rs
event.rich_media_event_type_id	int ID of Rich Media Event Type.
event.site_id	int Unique ID for the site where the ad ran.
event.state	string ID for user's state or province (US/Canada)
event.total_conversions	double The amount of conversion credit in nanos credited to the attributed event. For sales activities, Floodlight might count more than one conversion per event. For example, you can set up Floodlight to count the number of items purchased as the number of conversions for a single event. (The double value of the int event.activity_count in activities_events)
event.total_conversions_revenue	double The amount of revenue in USD megas credited to the attributed. You can multiply by 1,000,000 to see it as a dollar amount. (The attributed version of event.activity_revenue in activities_events)
event.total_transaction_count	double The number of transactions or activity tag fires in nanos credited to the attributed event.
event.zip_code	string Postal-Code (US/Canada).
is_in_rdid_project	boolean true if this event is also in the _rdid table. Used for deduplication of events.
network_id	int The network ID.
user_id	string The tracking ID (it is based on, but does not expose the user's browser cookie or mobile device ID). This field may be zeroed out for privacy reasons..

DV360 Data Transfer advertiser

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

DV360 Data Transfer campaign

dv360_dt_campaign
dv360_advertiser_id	int Unique ID of the advertiser.
dv360_campaign	string Name of the campaign
dv360_campaign_id	int Unique ID of the campaign.
dv360_partner_id	int Unique ID of the partner.

DV360 Data Transfer clicks

dv360_dt_clicks
device_id_md5	string MD5-hashed device ID. Utility will be provided to hash raw device IDs to match.
event	struct
event.active_view_eligible_impressions	int Whether the impression was eligible to measure viewability. An impression is eligible if (a) the ad's creative has an Active View tag and (b) the tag successfully communicates with Google Marketing Platform servers at the time of the impression.
event.active_view_measurable_impressions	int Whether the impression was measurable with Active View.
event.active_view_viewable_impressions	int Whether the impression was viewable.
event.activity_count	int Activity Quantity
event.activity_id	int The ID of the Floodlight tag related to the conversion event.
event.ad_id	int Unique ID of the ad placement.
event.advertiser_id	int Unique ID of the advertiser
event.audience_segment_id	int
event.browser_platform_id	string ID of the browser type.
event.browser_version	string Browser/Platform Version
event.campaign_id	int Unique ID of the campaign
event.city_id	int City ID
event.conversion_id	int Indicates whether an activity has been matched as a post-click (value of 1) or post-impression (value of 2), or unmatched (value of 0).
event.country_code	string Country
event.creative_version	string Creative version number.
event.dma_region_id	int Designated Market Area ID (US/Canada).
event.dv360_ad_position	int Specifies the position of the ad on the page if known. 1 represents above the fold, 2 represents below the fold.
event.dv360_advertiser_id	int The Display & Video 360 numerical ID for the advertiser related to the event, for example 164332.
event.dv360_adx_page_categories	string DV360 Adx Page Categories
event.dv360_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_browser_id	int The Display & Video 360 numerical ID identifying the browser related to this event.
event.dv360_browser_timezone_offset_minutes	int The difference in minutes between the active timezone on the user's browser and GMT-12, for example 1320 represents a browser timezone of GMT+10.
event.dv360_city_id	int The Display & Video 360 numerical ID identifying the best-guess city of the impression.
event.dv360_country_code	string 2-letter ISO 3166-1 country code identifying the best-guess country of the impression, for example "US".
event.dv360_creative_id	int The Display & Video 360 numerical ID for the creative related to the event, for example 367487.
event.dv360_device_type	int The numerical value of the identified device type. 0 = COMPUTER, 1 = OTHER, 2 = SMARTPHONE, 3 = TABLET, 4 = SMARTTV, 5 = CONNECTEDTV.
event.dv360_isp_id	int The Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.
event.dv360_language	string The ISO-639-1 code or "zh_CN" (Chinese (simplified)), "zh_TW" (Chinese (traditional)) or "other" representing the language related to the view event.
event.dv360_mobile_make_id	int The numerical ID for the mobile make. This value may be missing.
event.dv360_mobile_model_id	int The numerical ID for the mobile model. This value may be missing.
event.dv360_net_speed	int The Display & Video 360 numerical ID representing the network speed related to the view event. 1=Dial-up, 2=EDGE/2G, 3=UMTS/3G, 4=Basic DSL, 5=HSDPA/3.5G, 6=Broadband/4G, 7=Unknown.
event.dv360_operating_system_id	int
event.dv360_state_region_id	int DV360 Region ID
event.dv360_view_state	string Populated for wrapped tags. (Two impression records when both events occur.) Possible values are: "OUTER", DV360 returned wrapped tag; "INNER", ad served post wrapped tag; "3PAS_MERGED", wrapped tag tracked by CM; "3PAS_OUTER", tracking ping sent to CM but no response, 3rd party blocked ad serving.
event.dv360_zip_postal_code	string DV360 ZIP/Postal Code
event.event_sub_type	string Contains further details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "POSTVIEW", "POSTCLICK" or blank for conversion events.
event.event_time	int Time in microseconds since 1970-01-01 00:00:00 UTC.
event.event_type	string Contains details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "CONVERSION" or blank for conversion events.
event.floodlight_config_id	int Unique ID of the floodlight configuration.
event.impression_id	string Impression ID
event.interaction_time_utc_seconds	string Interaction Time
event.landing_page_url_id	int Unique ID of the landing page URL.
event.operating_system_id	int ID of the operating system.
event.ord_value	string The advertiser's ordinal ID, if relevant for a given activity type. Passed in the 'ord=' key-value (also used for storing the client's Order-ID in sales tags)
event.placement_id	int Unique ID for the site page / placement where the ad ran.
event.platform_type_id	int
event.referrer_url	string Contains the URL on which the ad appeared, when possible. May also be empty, or return ad server URLs.
event.rendering_id	int Unique ID of the creative for Data Transfer. Does not correspond to the UI-Creative-ID.
event.rich_media_event_counters	int MET Counter Value (the ecn= value).
event.rich_media_event_id	int MET Event ID for the Rich Media ad.
event.rich_media_event_timers	double Time in microseconds since 1970-01-01 00:00:00 UTC.rs
event.rich_media_event_type_id	int ID of Rich Media Event Type.
event.site_id	int Unique ID for the site where the ad ran.
event.state	string ID for user's state or province (US/Canada)
event.zip_code	string Postal-Code (US/Canada).
is_in_rdid_project	boolean true if this event is also in the _rdid table. Used for deduplication of events.
network_id	int The network ID.
user_id	string The tracking ID (it is based on, but does not expose the user's browser cookie or mobile device ID). This field may be zeroed out for privacy reasons..

DV360 Data Transfer impressions

dv360_dt_impressions
device_id_md5	string MD5-hashed device ID. Utility will be provided to hash raw device IDs to match.
event	struct
event.active_view_eligible_impressions	int Whether the impression was eligible to measure viewability. An impression is eligible if (a) the ad's creative has an Active View tag and (b) the tag successfully communicates with Google Marketing Platform servers at the time of the impression.
event.active_view_measurable_impressions	int Whether the impression was measurable with Active View.
event.active_view_viewable_impressions	int Whether the impression was viewable.
event.activity_count	int Activity Quantity
event.activity_id	int The ID of the Floodlight tag related to the conversion event.
event.ad_id	int Unique ID of the ad placement.
event.advertiser_id	int Unique ID of the advertiser
event.audience_segment_id	int
event.browser_platform_id	string ID of the browser type.
event.browser_version	string Browser/Platform Version
event.campaign_id	int Unique ID of the campaign
event.city_id	int City ID
event.conversion_id	int Indicates whether an activity has been matched as a post-click (value of 1) or post-impression (value of 2), or unmatched (value of 0).
event.country_code	string Country
event.creative_version	string Creative version number.
event.dma_region_id	int Designated Market Area ID (US/Canada).
event.dv360_ad_position	int Specifies the position of the ad on the page if known. 1 represents above the fold, 2 represents below the fold.
event.dv360_advertiser_id	int The Display & Video 360 numerical ID for the advertiser related to the event, for example 164332.
event.dv360_adx_page_categories	string DV360 Adx Page Categories
event.dv360_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_browser_id	int The Display & Video 360 numerical ID identifying the browser related to this event.
event.dv360_browser_timezone_offset_minutes	int The difference in minutes between the active timezone on the user's browser and GMT-12, for example 1320 represents a browser timezone of GMT+10.
event.dv360_city_id	int The Display & Video 360 numerical ID identifying the best-guess city of the impression.
event.dv360_country_code	string 2-letter ISO 3166-1 country code identifying the best-guess country of the impression, for example "US".
event.dv360_creative_id	int The Display & Video 360 numerical ID for the creative related to the event, for example 367487.
event.dv360_device_type	int The numerical value of the identified device type. 0 = COMPUTER, 1 = OTHER, 2 = SMARTPHONE, 3 = TABLET, 4 = SMARTTV, 5 = CONNECTEDTV.
event.dv360_isp_id	int The Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.
event.dv360_language	string The ISO-639-1 code or "zh_CN" (Chinese (simplified)), "zh_TW" (Chinese (traditional)) or "other" representing the language related to the view event.
event.dv360_mobile_make_id	int The numerical ID for the mobile make. This value may be missing.
event.dv360_mobile_model_id	int The numerical ID for the mobile model. This value may be missing.
event.dv360_net_speed	int The Display & Video 360 numerical ID representing the network speed related to the view event. 1=Dial-up, 2=EDGE/2G, 3=UMTS/3G, 4=Basic DSL, 5=HSDPA/3.5G, 6=Broadband/4G, 7=Unknown.
event.dv360_operating_system_id	int
event.dv360_state_region_id	int DV360 Region ID
event.dv360_view_state	string Populated for wrapped tags. (Two impression records when both events occur.) Possible values are: "OUTER", DV360 returned wrapped tag; "INNER", ad served post wrapped tag; "3PAS_MERGED", wrapped tag tracked by CM; "3PAS_OUTER", tracking ping sent to CM but no response, 3rd party blocked ad serving.
event.dv360_zip_postal_code	string DV360 ZIP/Postal Code
event.event_sub_type	string Contains further details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "POSTVIEW", "POSTCLICK" or blank for conversion events.
event.event_time	int Time in microseconds since 1970-01-01 00:00:00 UTC.
event.event_type	string Contains details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "CONVERSION" or blank for conversion events.
event.floodlight_config_id	int Unique ID of the floodlight configuration.
event.impression_id	string Impression ID
event.interaction_time_utc_seconds	string Interaction Time
event.landing_page_url_id	int Unique ID of the landing page URL.
event.operating_system_id	int ID of the operating system.
event.ord_value	string The advertiser's ordinal ID, if relevant for a given activity type. Passed in the 'ord=' key-value (also used for storing the client's Order-ID in sales tags)
event.placement_id	int Unique ID for the site page / placement where the ad ran.
event.platform_type_id	int
event.referrer_url	string Contains the URL on which the ad appeared, when possible. May also be empty, or return ad server URLs.
event.rendering_id	int Unique ID of the creative for Data Transfer. Does not correspond to the UI-Creative-ID.
event.rich_media_event_counters	int MET Counter Value (the ecn= value).
event.rich_media_event_id	int MET Event ID for the Rich Media ad.
event.rich_media_event_timers	double Time in microseconds since 1970-01-01 00:00:00 UTC.rs
event.rich_media_event_type_id	int ID of Rich Media Event Type.
event.site_id	int Unique ID for the site where the ad ran.
event.state	string ID for user's state or province (US/Canada)
event.zip_code	string Postal-Code (US/Canada).
is_in_rdid_project	boolean true if this event is also in the _rdid table. Used for deduplication of events.
network_id	int The network ID.
user_id	string The tracking ID (it is based on, but does not expose the user's browser cookie or mobile device ID). This field may be zeroed out for privacy reasons..

DV360 Data Transfer insertion order

dv360_dt_insertion_order
dv360_advertiser_id	int Unique ID of the advertiser.
dv360_campaign_id	int Unique ID of the campaign.
dv360_insertion_order	string Name of the insertion order.
dv360_insertion_order_id	int Unique ID of the insertion order.
dv360_partner_id	int Unique ID of the partner.

DV360 Data Transfer line item

dv360_dt_line_item
dv360_advertiser_id	int Unique ID of the advertiser.
dv360_campaign_id	int Unique ID of the campaign.
dv360_insertion_order_id	int Unique ID of the insertion order.
dv360_line_item	string Name of the line item.
dv360_line_item_id	int Unique ID of the line item.
dv360_partner_id	int Unique ID of the partner.

DV360 YouTube Active View

dv360_youtube_active_views
adgroup_id	int ID of DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table.
advertiser_id	int Unique ID of the advertiser.
campaign_id	int Unique ID of the campaign.
creative_id	int Joins with creative_id in any adh.dv360_youtube table.
insertion_order_id	int Unique ID of the insertion order.
lineitem_id	int Unique ID of the line item.
num_active_view_viewable_impression	int 1 when impression is active view eligible; 0 when impression is not active view eligible.
partner_id	int Unique ID of the partner.
query_id	struct Unique identifier for query has multiple parts. Joins with query_id in any adh.dv360_youtube table.
query_id.process_id	int The processing ID.
query_id.server_ip	int The processing server.
query_id.time_usec	int The query time in microseconds.
view_id	struct Unique identifier for view_id has multiple parts.
view_id.process_id	int Time in microseconds.
view_id.server_ip	int The processing server.
view_id.time_usec	int The processing process.

DV360 YouTube ad group

dv360_youtube_adgroup
adgroup_id	int ID of DV360 ad group. Joins with adgroup_id in any adh.dv360_youtube table.
adgroup_name	string Ad group name.
adgroup_status	string The ad group. Possible values are: "status", "paused", or "enabled".
adgroup_type	string The ad group type. Possible values are: VIDEO_TRUE_VIEW_IN_STREAM, VIDEO_NON_SKIPPABLE_IN_STREAM, VIDEO_BUMPER, VIDEO_TRUE_VIEW_IN_DISPLAY.
advertiser_id	int Unique ID of the advertiser.
campaign_id	int Unique ID of the campaign.
insertion_order_id	int Unique ID of the insertion order.
line_item_id	int Unique ID of the line item.
lineitem_id	int Unique ID of the line item.
partner_id	int Unique ID of the partner.

DV360 YouTube advertiser

dv360_youtube_advertiser
advertiser_id	int Unique ID of the advertiser.
advertiser_name	string Name of the advertiser.
partner_id	int Unique ID of the partner.

DV360 YouTube campaign

dv360_youtube_campaign
advertiser_id	int Unique ID of the advertiser.
campaign_id	int Unique ID of the campaign.
campaign_name	string Name of the campaign
partner_id	int Unique ID of the partner.

DV360 YouTube clicks

dv360_youtube_clicks
adgroup_id	int ID of DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table.
advertiser_id	int Unique ID of the advertiser.
campaign_id	int Unique ID of the campaign.
click_id	struct Unique identifier for click has multiple parts. Joins with click_id in any adh.dv360_youtube table.
click_id.process_id	int The processing process.
click_id.server_ip	int The processing server.
click_id.time_usec	int Time in microseconds.
click_type	int The click type.
creative_id	int Joins with creative_id in any adh.dv360_youtube table.
insertion_order_id	int Unique ID of the insertion order.
is_in_rdid_project	boolean true if this event is also in the _rdid table. Used for deduplication of events.
lineitem_id	int Unique ID of the line item.
partner_id	int Unique ID of the partner.
query_id	struct Unique identifier for query has multiple parts. Joins with query_id in any adh.dv360_youtube table.
query_id.process_id	int The processing process.
query_id.server_ip	int The processing server.
query_id.time_usec	int Time in microseconds.
user_id	string User ID

DV360 YouTube conversions

dv360_youtube_conversions
click_id	struct Unique identifier for click has multiple parts. Joins with click_id in any adh.dv360_youtube table.
click_id.process_id	int The processing process.
click_id.server_ip	int The processing server.
click_id.time_usec	int Time in microseconds.
conversion_id	struct Unique identifier for conversion has multiple parts.
conversion_id.process_id	int The processing process.
conversion_id.server_ip	int The processing server.
conversion_id.time_usec	int Time in microseconds.
conversion_type	int The type of conversion.
impression_data.adgroup_id	int ID of DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table.
impression_data.advertiser_id	int Unique ID of the advertiser.
impression_data.campaign_id	int Unique ID of the campaign.
impression_data.creative_id	int Joins with creative_id in any adh.dv360_youtube table.
impression_data.insertion_order_id	int Unique ID of the insertion order.
impression_data.lineitem_id	int Unique ID of the line item.
impression_data.partner_id	int Unique ID of the partner.
is_in_rdid_project	boolean true if this event is also in the _rdid table. Used for deduplication of events.
label	string Name of conversion event.
partner_id	int Unique ID of the partner.
query_id	struct Unique identifier for query has multiple parts. Joins with query_id in any adh.dv360_youtube table.
query_id.process_id	int The processing process.
query_id.server_ip	int The processing server.
query_id.time_usec	int Time in microseconds.
user_id	string User ID

DV360 YouTube creative

dv360_youtube_creative
adgroup_id	int ID of DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table.
advertiser_id	int Unique ID of the advertiser.
campaign_id	int Unique ID of the campaign.
creative_id	int Joins with creative_id in any adh.dv360_youtube table.
creative_name	string Creative name.
creative_type	int Creative type.
insertion_order_id	int Unique ID of the insertion order.
is_masthead	boolean True if this is a masthead creative.
lineitem_id	int Unique ID of the line item.
partner_id	int Unique ID of the partner.
third_party_vast_url	string VAST url of the creative if the creative is a third party hosted video.
video_message	struct Multipart identifier for video data.
video_message.video_ad_duration	int Duration of the video in milliseconds.
video_message.youtube_video_id	string Video id string representation as it appears on YouTube watch url.

DV360 YouTube creative conversions

dv360_youtube_creative_conversions
click_id	struct Unique identifier for click has multiple parts. Joins with click_id in any adh.dv360_youtube table.
click_id.process_id	int The processing process.
click_id.server_ip	int The processing server.
click_id.time_usec	int Time in microseconds.
conversion_id	struct Unique identifier for conversion has multiple parts.
conversion_id.process_id	int The processing process.
conversion_id.server_ip	int The processing server.
conversion_id.time_usec	int Time in microseconds.
conversion_type	int The type of conversion.
impression_data.adgroup_id	int ID of the DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table.
impression_data.advertiser_id	int Unique ID of the advertiser.
impression_data.campaign_id	int Unique ID of the campaign.
impression_data.creative_id	int Joins with creative_id in any adh.dv360_youtube table.
impression_data.insertion_order_id	int Unique ID of the insertion order.
impression_data.lineitem_id	int Unique ID of the line item.
impression_data.partner_id	int Unique ID of the partner.
is_in_rdid_project	boolean trueif this event is also in the _rdid table. Used for deduplication of events.
label	string Name of conversion event.
query_id	struct Unique identifier for query has multiple parts. Joins with query_id in any adh.dv360_youtube table.
query_id.process_id	int The processing process.
query_id.server_ip	int The processing server.
query_id.time_usec	int Time in microseconds.
user_id	string User ID

DV360 YouTube impressions

dv360_youtube_impressions
adgroup_id	int ID of DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table.
advertiser_id	int Unique ID of the advertiser.
campaign_id	int Unique ID of the campaign.
content_url	string URL of the page on which ad appeared. Part of the url is removed for privacy.
device_height	int Device height in px.
device_width	int Device width in px.
insertion_order_id	int Unique ID of the insertion order.
inventory_type	enum The inventory type. Possible values: YOUTUBE, YOUTUBE TV, SEARCH, GMAIL, OTHER. Other refers to either the Google Display or Video network.
is_app_traffic	boolean true if the event happened in a native app.
is_in_rdid_project	boolean true if this event is also in the _rdid table. Used for deduplication of events.
lineitem_id	int Unique ID of the line item.
location	struct Unique identifier for location has multiple parts
location.country	string
location.geo_city_id	int Code for city. Joins with city_id in adh.city table.
location.geo_metro	int Code for metro region. Joins with metro_id in adh.metro table.
location.geo_region	string Region as string e.g. US-CA.
mobile_browser_class	int Type of browser. Possible values are: desktop, tablet, smart tv consoles, or mobile. Joins with mobile_browser_class_id in adh.mobile_browser_cltable.
num_active_view_eligible_impression	int 1 when impression is active view eligible; 0 when impression is not active view eligible.
num_active_view_measurable_impression	int 1 when impression is active view measurable; 0 when impression is not active view measurable.
operating_system_version_ids	array ID of OS. Joins with operating_system_version_id in adh.os_version table.
partner_id	int Unique ID of the partner.
physical_screen_height	int Device screen height in mm.
physical_screen_width	int Device screen width in mm.
publisher_domain	string Domain of the page on which ad appeared.
query_id	struct Unique identifier for query has multiple parts. Joins with query_id in any adh.dv360_youtube table.
query_id.process_id	int The processing ID.
query_id.server_ip	int The processing server.
query_id.time_usec	int The query time in microseconds.
query_language	string Language used by user.
user_id	string User ID

DV360 YouTube insertion order

dv360_youtube_insertion_order
advertiser_id	int Unique ID of the advertiser.
campaign_id	int Unique ID of the campaign.
insertion_order_id	int Unique ID of the insertion order.
insertion_order_name	string Name of the insertion order.
partner_id	int Unique ID of the partner.

DV360 YouTube line item

dv360_youtube_lineitem
advertiser_id	int Unique ID of the advertiser.
campaign_id	int Unique ID of the campaign.
insertion_order_id	int Unique ID of the insertion order.
line_item_id	int Unique ID of the line item.
line_item_name	string Name of the line item.
line_item_reservation_type	enum The type of the reservation. Can be either "PROGRAMMATIC", "INSTANTRESERVE" or "NONE" (meaning standard auction).
partner_id	int Unique ID of the partner.

Freewheel Active Views

freewheel_active_views
active_view	record Active view
ad_current_time_ms	int The current time of the ad video playback in milliseconds
ad_id	string VAST ad_id
freewheel_event_id	record Unique identifier for query has multiple parts. Joins with event_id.
freewheel_event_id.process_id	int The processing process.
freewheel_event_id.server_ip	int The processing server.
freewheel_event_id.time_usec	int Time in microseconds.
label	string Name of conversion event.
user_id	string Raw user ID.
user_language	string A three-letter ISO 639-2/bibliographic language code

Freewheel clicks

freewheel_clicks
ad_current_time_ms	int The current time of the ad video playback in milliseconds
ad_id	string VAST ad_id
freewheel_event_id	record Unique identifier for query has multiple parts. Joins with event_id.
freewheel_event_id.process_id	int The processing process.
freewheel_event_id.server_ip	int The processing server.
freewheel_event_id.time_usec	int Time in microseconds.
label	string Name of conversion event.
user_id	string Raw user ID.
user_language	string A three-letter ISO 639-2/bibliographic language code

Freewheel creative pixels

freewheel_creative_pixels
ad_id	string Vast Ad ID.
pixel_url	string pixel URL.

Freewheel impressions

freewheel_impressions
ad_current_time_ms	int The current time of the ad video playback in milliseconds
ad_id	string VAST ad_id
content_url	string URL of the page on which ad appeared. Part of the url is removed for privacy.
freewheel_event_id	record Unique identifier for query has multiple parts. Joins with event_id.
freewheel_event_id.process_id	int The processing process.
freewheel_event_id.server_ip	int The processing server.
freewheel_event_id.time_usec	int Time in microseconds.
inventory_type	enum The inventory type. Possible values: YOUTUBE, YOUTUBE TV, SEARCH, GMAIL, OTHER. Other refers to either the Google Display or Video network.
is_app_traffic	bool True if the event happened in a native app. FALSE if the event happened in HTML5 app or webview.
label	string Name of conversion event.
location	struct Unique identifier for location has multiple parts.
location.country	string Two character country code.
location.geo_city_id	int Code for city. Joins with city_id in adh.city table.
location.geo_country_id	int
location.geo_region_id	int Code for region.
mobile_browser_class	int Type of device. Possible values are: desktop, tablet, smart tv consoles, or mobile. Joins with mobile_browser_class_id in adh.mobile_browser_cltable.
publisher_domain	string Domain of the page on which ad appeared.
user_id	string Raw user ID.
user_language	string A three-letter ISO 639-2/bibliographic language code

Freewheel pixel

freewheel_pixel
pixel_url	string The pixel URL.

Google Ads Active Views

google_ads_active_views
impression_data.ad_group_creative_id	int ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table.
impression_data.adgroup_id	int ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table.
impression_data.campaign_id	int Unique ID of the campaign.
impression_data.customer_id	int ID of Google Ads customer. Joins with customer_id in any adh.google_ads table.
num_active_view_viewable_impression	int 1 when impression is active view eligible; 0 when impression is not active view eligible.
query_id	struct Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
query_id.process_id	int The processing ID.
query_id.server_ip	int The processing server.
query_id.time_usec	int The query time in microseconds.
view_id	struct Unique identifier for view_id has multiple parts.
view_id.process_id	int Time in microseconds.
view_id.server_ip	int The processing server.
view_id.time_usec	int The processing process.

Google Ads ad group

google_ads_adgroup
adgroup_id	int ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table.
adgroup_name	string Ad group name.
adgroup_status	string The ad group. Possible values are: "status", "paused", or "enabled".
adgroup_type	string The ad group type. Possible values are: VIDEO_TRUE_VIEW_IN_STREAM, VIDEO_OUTSTREAM, VIDEO_TRUE_VIEW_IN_DISPLAY, VIDEO_BUMPER_IN_STREAM, VIDEO_NON_SKIPPABLE_IN_STREAM, DISPLAY, SEARCH, or OTHER.
campaign_id	int Unique ID of the campaign.
customer_id	int Joins with customer_id in any adh.google_ads table.
label_ids	array Joins with label_id in the adh.google_ads_label table.

Google Ads ad group creative

google_ads_adgroupcreative
ad_group_creative_id	INT64 ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table.
adgroup_creative_status	STRING The status of the creative within the ad group.
adgroup_id	INT64 ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table.
creative_id	INT64 A unique identifier for the creative, specific to the ad group containing it. Joins with creative_id in any adh.google_ads table.
customer_id	INT64 Joins with customer_id in any adh.google_ads table.
label_ids	INT64 Joins with label_id in adh.google_ads tables that contain label_ids.

Google Ads campaign

google_ads_campaign
advertising_channel_type	string Advertising channel type. Possible values are: SEARCH, DISPLAY, VIDEO, or OTHER.
campaign_id	int Unique ID of the campaign.
campaign_name	string Campaign name.
campaign_status	int Campaign status. 3 = ACTIVE. 5 = PAUSED. 7 = DELETED.
customer_id	int Joins with customer_id in any adh.google_ads table.
end_time	int Timestamp when the campaign ends in milliseconds.
label_ids	array Joins with label_id in the adh.google_ads_label table.
reservation_type	enum The type of the reservation. Can be either "INSTANTRESERVE" or "NONE" (meaning standard auction).
start_time	int Timestamp when the campaign begins in milliseconds.

Google Ads clicks

google_ads_clicks
click_id	struct Unique identifier for click has multiple parts. Joins with click_id in any adh.google_ads table.
click_id.process_id	int The processing process.
click_id.server_ip	int The processing server.
click_id.time_usec	int Time in microseconds.
click_type	int The click type.
impression_data.ad_group_creative_id	int ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table.
impression_data.adgroup_id	int ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table.
impression_data.campaign_id	int Unique ID of the campaign.
impression_data.customer_id	int ID of Google Ads customer. Joins with customer_id in any adh.google_ads table.
is_in_rdid_project	boolean true if this event is also in the _rdid table. Used for deduplication of events.
query_id	struct Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
query_id.process_id	int The processing process.
query_id.server_ip	int The processing server.
query_id.time_usec	int Time in microseconds.
user_id	string User ID

Google Ads clicks audience

google_ads_clicks_audience
click_id	struct Unique identifier for click has multiple parts. Joins with click_id in any adh.google_ads table.
click_id.process_id	int The processing process.
click_id.server_ip	int The processing server.
click_id.time_usec	int Time in microseconds.
click_type	int The click type.
is_in_rdid_project	boolean true if this event is also in the _rdid table. Used for deduplication of events.
query_id	struct Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
query_id.process_id	int The processing process.
query_id.server_ip	int The processing server.
query_id.time_usec	int Time in microseconds.
user_id	string User ID

Google Ads conversions

google_ads_conversions
click_id	struct Unique identifier for click has multiple parts. Joins with click_id in any adh.google_ads table.
click_id.process_id	int The processing process.
click_id.server_ip	int The processing server.
click_id.time_usec	int Time in microseconds.
conversion_id	struct Unique identifier for conversion has multiple parts.
conversion_id.process_id	int The processing process.
conversion_id.server_ip	int The processing server.
conversion_id.time_usec	int Time in microseconds.
conversion_type	int The type of conversion.
impression_data.ad_group_creative_id	int ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table.
impression_data.adgroup_id	int ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table.
impression_data.campaign_id	int Unique ID of the campaign.
impression_data.customer_id	int ID of Google Ads customer. Joins with customer_id in any adh.google_ads table.
is_in_rdid_project	boolean true if this event is also in the _rdid table. Used for deduplication of events.
label	string Name of conversion event.
query_id	struct Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
query_id.process_id	int The processing process.
query_id.server_ip	int The processing server.
query_id.time_usec	int Time in microseconds.
user_id	string User ID

Google Ads conversions audience

google_ads_conversions_audience
click_id	struct Unique identifier for click has multiple parts. Joins with click_id in any adh.google_ads table.
click_id.process_id	int The processing process.
click_id.server_ip	int The processing server.
click_id.time_usec	int Time in microseconds.
conversion_id	struct Unique identifier for conversion has multiple parts.
conversion_id.process_id	int The processing process.
conversion_id.server_ip	int The processing server.
conversion_id.time_usec	int Time in microseconds.
conversion_type	int The type of conversion.
is_in_rdid_project	boolean true if this event is also in the _rdid table. Used for deduplication of events.
label	string Name of conversion event.
query_id	struct Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
query_id.process_id	int The processing process.
query_id.server_ip	int The processing server.
query_id.time_usec	int Time in microseconds.
user_id	string User ID

Google Ads creative

google_ads_creative
beacon_url	array Multipart identifier for third-party ad trafficked by Campaign Manager.
creative_id	int Joins with creative_id in any adh.google_ads table.
creative_name	string Creative name.
creative_type	int Creative type.
customer_id	int Joins with customer_id in any adh.google_ads table.
snippet_url	struct Multipart identifier for third-party ad served by Campaign Manager
snippet_url.advertiser_id	int ID for Campaign Manager advertiser of ad being served.
snippet_url.campaign_id	int Joins with campaign_id in any adh.google_ads table.
snippet_url.content_url_data	struct Multipart record for content URL.
snippet_url.content_url_data.index	int Index of content URL.
snippet_url.content_url_data.url_type	string The type of URL.
snippet_url.network	int ID for Campaign Manager network of ad being served.
snippet_url.placement_id	int Unique ID for Campaign Manager placement of ad being served.
snippet_url.placement_key	string Full string identifying Campaign Manager placement of ad being served.
snippet_url.site_id	int ID for Campaign Manager site of ad being served.
template_id	int Template ID of the creative.
third_party_url	int The VAST tag URL string, as seen in Google products.
video_message	struct Multipart identifier for video data.
video_message.video_ad_duration	int Duration of the video in milliseconds.
video_message.youtube_video_id	string Video id string representation as it appears on YouTube watch url.

Google Ads creative conversions

google_ads_creative_conversions
click_id	struct Unique identifier for click has multiple parts. Joins with click_id in any adh.google_ads table.
click_id.process_id	int The processing process.
click_id.server_ip	int The processing server.
click_id.time_usec	int Time in microseconds.
conversion_id	struct Unique identifier for conversion has multiple parts.
conversion_id.process_id	int The processing process.
conversion_id.server_ip	int The processing server.
conversion_id.time_usec	int Time in microseconds.
conversion_type	int The type of conversion.
impression_data.ad_group_creative_id	int ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table.
impression_data.adgroup_id	int ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table.
impression_data.campaign_id	int Unique ID of the campaign.
impression_data.customer_id	int ID of Google Ads customer. Joins with customer_id in any adh.google_ads table.
is_in_rdid_project	boolean true if this event is also in the _rdid table. Used for deduplication of events.
label	string Name of conversion event.
query_id	struct Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
query_id.process_id	int The processing process.
query_id.server_ip	int The processing server.
query_id.time_usec	int Time in microseconds.
user_id	string User ID

Google Ads creative vendor metadata

google_ads_creative_vendor_metadata
creative_id	int The Creative ID in Campaign Manager UI.
legacy_pixel	string
vendor_string	string

Google Ads customer

google_ads_customer
customer_company_name	string Company name.
customer_id	int Joins with customer_id in any adh.google_ads table.
customer_name	string Customer name.
external_customer_id	int Joins with customer_id in any adh.google_ads table.
mcc_ids	array My Client Center Ids in Google Ads that this ADH customer is associated with.

Google Ads impressions

google_ads_impressions
ad_group_creative_id	int ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table.
adgroup_id	int ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table.
campaign_id	int Unique ID of the campaign.
content_url	string URL of the page on which ad appeared. Part of the url is removed for privacy.
customer_id	int ID of Google Ads customer.Joins with customer_id in any adh.google_ads table.
device_height	int Device height in px.
device_width	int Device width in px.
inventory_type	enum The inventory type. Possible values: YOUTUBE, YOUTUBE TV, SEARCH, GMAIL, OTHER. Other refers to either the Google Display or Video network.
is_app_traffic	boolean true if the event happened in a native app. FALSE if the event happened in HTML5 app or webview.
is_in_rdid_project	boolean true if this event is also in the _rdid table. Used for deduplication of events.
location	struct Unique identifier for location has multiple parts
location.country	string
location.geo_city_id	int Code for city. Joins with city_id in adh.city table.
location.geo_metro	int Code for metro region. Joins with metro_id in adh.metro table.
location.geo_region	string Region as string e.g. US-CA.
mobile_browser_class	int Type of device. Possible values are: desktop, tablet, smart tv consoles, or mobile. Joins with mobile_browser_class_id in adh.mobile_browser_cltable.
num_active_view_eligible_impression	int 1 when impression is active view eligible; 0 when impression is not active view eligible.
num_active_view_measurable_impression	int 1 when impression is active view measurable; 0 when impression is not active view measurable.
operating_system_version_ids	array ID of OS. Joins with operating_system_version_id in adh.os_version table.
physical_screen_height	int Device screen height in mm.
physical_screen_width	int Device screen width in mm.
publisher_domain	string Domain of the page on which ad appeared.
query_id	struct Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
query_id.process_id	int The processing ID.
query_id.server_ip	int The processing server.
query_id.time_usec	int The query time in microseconds.
query_language	string Language used by user.
user_id	string User ID

Google Ads label

google_ads_label
customer_id	int Joins with customer_id in any adh.google_ads table.
description	string Label description.
label_id	int Joins with label_id in adh.google_ads tables that contain label_ids.
label_name	string Label name.
status	int Label status. 1 = ENABLED. 2 = DELETED.

Metro

metro
country_code	string Two character country code.
metro_abbrev	string Abbreviated version of metro name.
metro_code	string The metropolitan area code.
metro_id	int Metro identifier.
metro_name	string Metro name.

Mobile browser class

mobile_browser_class
mobile_browser_class_id	int Mobile browser class identifier.
mobile_browser_class_name	string Name of the mobile browser class.

Operating system

operating_system
mobile	boolean True if the operating system is mobile.
operating_system_id	int Operating system identifier.
operating_system_name	string Operating system name.

Operating system version

os_version
major_version	int The major version number of the operating system.
minor_version	int The minor version of the operating system.
operating_system_id	int Unique ID of OS just for Data Transfer.
operating_system_version_id	int Operating system version identifier.
operator_type	string Possible values are OPERATOR_TYPE_EQUAL_TO, or OPERATOR_TYPE_GREATER_THAN_EQUAL_TO.
platform_name	string The platform name in English.

Partner Sold - Cross Sell Active Views

partner_sold_cross_sell_active_views
num_active_view_viewable_impression	int 1 when impression is active view eligible; 0 when impression is not active view eligible.
query_id	struct Unique identifier for query has multiple parts. Joins with query_id.
query_id.process_id	int The processing ID.
query_id.server_ip	int The processing server.
query_id.time_usec	int The query time in microseconds.
view_id	struct Unique identifier for view has multiple parts.
view_id.process_id	int The processing ID.
view_id.server_ip	int The processing server.
view_id.time_usec	int The query time in microseconds.

Partner Sold - Cross Sell clicks

partner_sold_cross_sell_clicks
click_id	struct Unique identifier for click has multiple parts. Joins with click_id.
click_id.process_id	int The processing ID.
click_id.server_ip	int The processing server.
click_id.time_usec	int The query time in microseconds.
click_type	int The click type.
device_id_md5	string MD5-hashed device ID. Utility will be provided to hash raw device IDs to match.
is_in_rdid_project	boolean true if this event is also in the _rdid table. Used for deduplication of events.
query_id	struct Unique identifier for query has multiple parts. Joins with query_id.
query_id.process_id	int The processing ID.
query_id.server_ip	int The processing server.
query_id.time_usec	int The query time in microseconds.
user_id	string User ID

Partner Sold - Cross Sell conversions

partner_sold_cross_sell_conversions
click_id	struct Unique identifier for click has multiple parts. Joins with click_id.
click_id.process_id	int The processing ID.
click_id.server_ip	int The processing server.
click_id.time_usec	int The query time in microseconds.
conversion_id	struct Unique identifier for conversion has multiple parts.
conversion_id.process_id	int The processing ID.
conversion_id.server_ip	int The processing server.
conversion_id.time_usec	int The query time in microseconds.
conversion_type	int The conversion type.
device_id_md5	string MD5-hashed device ID. Utility will be provided to hash raw device IDs to match.
is_in_rdid_project	boolean true if this event is also in the _rdid table. Used for deduplication of events.
label	string Name of conversion event.
query_id	struct Unique identifier for query has multiple parts.
query_id.process_id	int The processing ID.
query_id.server_ip	int The processing server.
query_id.time_usec	int The query time in microseconds.
user_id	string User ID

Partner Sold - Cross Sell creative

partner_sold_cross_sell_creative
creative_format_type	string Some formats map directly to a type. Other types have multiple formats like: html, image, or video.
creative_id	int The ID of the creative.
creative_name	string Name of the creative.
creative_type	string The type of creative.
third_party_vast_url	string VAST url of the creative if the creative is a third party hosted video. Does not support creatives from programmatic items.
video_message	struct Multipart identifier for video data.
video_message.video_ad_duration	int Duration of the video in milliseconds.
video_message.youtube_video_id	string Video id string representation as it appears on YouTube watch url.

Partner Sold - Cross Sell creative pixels

partner_sold_cross_sell_creative_pixels
ad_id	string Unique ID of the ad.
pixel_url	string The pixel URL.

Partner Sold - Cross Sell GAM pixels

partner_sold_cross_sell_gam_pixels
ad_id	string Unique ID of the ad.
pixel_url	string

Partner Sold - Cross Sell impressions

partner_sold_cross_sell_impressions
content_url	string URL of the page on which ad appeared. Part of the url is removed for privacy.
creative_id	int Joins with creative_id in any adh.yt table.
device_height	int Device height in pixels.
device_id_md5	string MD5-hashed device ID. Utility will be provided to hash raw device IDs to match.
device_width	int Device width in pixels.
gfp_placements	array Ad Manager placement ID for this impression. Does not represent Campaign Manager placement.
inventory_type	enum The inventory type. Possible values: YOUTUBE, YOUTUBE TV, SEARCH, GMAIL, OTHER. Other refers to either the Google Display or Video network.
is_in_rdid_project	boolean true if this event is also in the _rdid table. Used for deduplication of events.
line_item_id	int Line item id for this impression.
location	struct Unique identifier for location has multiple parts.
location.country	string Code for country.
location.geo_city_id	int Code for city. Joins with city_id in adh.city table.
location.geo_metro	int Code for metrio region. Joins with metro_id in adh.metro table.
location.geo_region	string Region as a string (e.g. US-CA)
mobile_browser_class	int Type of device. Possible values are: desktop, tablet, smart tv consoles, or mobile. Joins with mobile_browser_class_id in adh.mobile_browser_cltable.
num_active_view_eligible_impression	int 1 when impression is active view eligible; 0 when impression is not active view eligible.
num_active_view_measurable_impression	int 1 when impression is active view measurable; 0 when impression is not active view measurable.
operating_system_version_ids	array ID of operating system. Joins with operating_system_version_id in adh.os_version table.
order_id	int Order ID for the impression.
physical_screen_height	int Device height in mm.
physical_screen_width	int Device screen width in mm.
publisher_domain	string Domain of page on which ad appeared.
query_id	struct Unique identifier for query has multiple parts.
query_id.process_id	int The processing ID.
query_id.server_ip	int The processing server.
query_id.time_usec	int The query time in microseconds.
query_language	string Language used by user.
user_id	string User ID

Partner Sold - Cross Sell line item

partner_sold_cross_sell_lineitem
end_time	timestamp Time the line item stopped being served.
line_item_id	int Ad Manager line item serving.
line_item_name	string Ad Manager line item name.
order_id	int Ad Manager Order identifier used for serving.
order_name	string Name of the insertion order.
programmatic	boolean true if the line item was programmatic.
skippable_ad_type	string Possible values are: "skippable", "not skippable", or "selectable".
start_time	timestamp Time the line item started to be served.

Partner Sold - Cross Sell order

partner_sold_cross_sell_order
advertiser_id	int Unique ID of the advertiser.
advertiser_name	string Publisher entered name.
network_code	int Ad Manager Publisher network code.
order_id	int Ad Manager Order identifier used for serving.
order_name	string Name of Ad Manager order.

Region

region
country_code	string Two character country code.
region_code	string Region code.
region_id	int Region identifier.
region_name	string Region name.

YouTube Reserve Active Views

yt_reserve_active_views
impression_data.creative_id	int The ID of the creative.
impression_data.line_item_id	int Line item id for this impression.
impression_data.media_plan_id	int ID of the YouTube Reserve media plan.
impression_data.order_id	int
num_active_view_viewable_impression	int 1 when impression is active view viewable; 0 when impression is not active view viewable.
query_id	struct Unique identifier for query has multiple parts.
query_id.process_id	int The processing process.
query_id.server_ip	int The processing server.
query_id.time_usec	int Time in microseconds.
view_id	struct Unique identifier for view has multiple parts.
view_id.process_id	int The processing process.
view_id.server_ip	int The processing server.
view_id.time_usec	int Time in microseconds.

YouTube Reserve clicks

yt_reserve_clicks
click_id	struct Unique identifier for click has multiple parts.
click_id.process_id	int The processing process.
click_id.server_ip	int The processing server.
click_id.time_usec	int Time in microseconds.
click_type	int The click type.
impression_data.creative_id	int The ID of the creative.
impression_data.line_item_id	int Line item id for this impression.
impression_data.media_plan_id	int ID of the YouTube Reserve media plan.
impression_data.order_id	int
is_in_rdid_project	boolean true if this event is also in the _rdid table. Used for deduplication of events.
query_id	struct Unique identifier for query has multiple parts.
query_id.process_id	int The processing process.
query_id.server_ip	int The processing server.
query_id.time_usec	int Time in microseconds.
user_id	string User ID

YouTube Reserve conversions

yt_reserve_conversions
click_id	struct Unique identifier for click has multiple parts.
click_id.process_id	int The processing process.
click_id.server_ip	int The processing server.
click_id.time_usec	int Time in microseconds.
conversion_id	struct Unique identifier for conversion has multiple parts.
conversion_id.process_id	int The processing process.
conversion_id.server_ip	int The processing server.
conversion_id.time_usec	int Time in microseconds.
conversion_type	int The type of conversion.
impression_data.creative_id	int The ID of the creative.
impression_data.line_item_id	int Line item id for this impression.
impression_data.media_plan_id	int ID of the YouTube Reserve media plan.
impression_data.order_id	int
is_in_rdid_project	boolean true if this event is also in the _rdid table. Used for deduplication of events.True if this event is also in the _rdid tabUsed for deduplication of events.
label	string Name of conversion event.
query_id	struct Unique identifier for query has multiple parts.
query_id.process_id	int The processing process.
query_id.server_ip	int The processing server.
query_id.time_usec	int Time in microseconds.
user_id	string User ID

YouTube Reserve creative

yt_reserve_creative
creative_format_type	string Some formats map directly to a type. Other types have multiple formats like: html, image, or video.
creative_id	int The ID of the creative.
creative_name	string Name of the creative.
creative_type	string The type of creative.
dcm_beacons	array Multipart identifier for Campaign Manager tracking pixel for ad.
is_masthead	boolean True if this is a masthead creative.
third_party_vast_url	string VAST url of the creative if the creative is a third party hosted video. Does not support creatives from programmatic items.
video_message	struct Multipart identifier for video data.
video_message.video_ad_duration	int Duration of the video in milliseconds.
video_message.youtube_channel_id	string Id of the channel that provides this video.
video_message.youtube_video_id	string Video id string representation as it appears on YouTube watch url.

YouTube Reserve creative conversions

yt_reserve_creative_conversions
click_id	struct Unique identifier for click has multiple parts.
click_id.process_id	int The processing process.
click_id.server_ip	int The processing server.
click_id.time_usec	int Time in microseconds.
conversion_id	struct Unique identifier for conversion has multiple parts.
conversion_id.process_id	int The processing process.
conversion_id.server_ip	int The processing server.
conversion_id.time_usec	int Time in microseconds.
conversion_type	int The type of conversion.
impression_data.creative_id	int ID of the creative.
impression_data.line_item_id	int Line item ID for this impression.
impression_data.media_plan_id	int ID of the YouTube Reserve media plan.
impression_data.order_id	int ID of Display and Video 360 customer. Joins with customer_id in any adh.dv360 table.
is_in_rdid_project	boolean true if this event is also in the _rdid table. Used for deduplication of events.True if this event is also in the _rdid tabUsed for deduplication of events.
label	string Name of conversion event.
query_id	struct Unique identifier for query has multiple parts.
query_id.process_id	int The processing process.
query_id.server_ip	int The processing server.
query_id.time_usec	int Time in microseconds.
user_id	string User ID

YouTube Reserve impressions

yt_reserve_impressions
content_url	string URL of the page on which ad appeared. Part of the url is removed for privacy.
creative_id	int The ID of the creative.
device_height	int Device height in px.
device_width	int Device width in px.
inventory_type	enum The inventory type. Possible values: YOUTUBE, YOUTUBE TV, SEARCH, GMAIL, OTHER. Other refers to either the Google Display or Video network.
is_app_traffic	boolean true if the event happened in a native app. FALSE if the event happened in HTML5 app or webview.
is_in_rdid_project	boolean true if this event is also in the _rdid table. Used for deduplication of events.
line_item_id	int Line item id for this impression.
location	struct Unique identifier for location has multiple parts.
location.country	string
location.geo_city_id	int Code for city. Joins with city_id in adh.city table.
location.geo_metro	int Code for metro region. Joins with metro_id in adh.metro table.
location.geo_region	string Region as string, e.g. US-CA.
media_plan_id	int ID of the YouTube Reserve media plan.
mobile_browser_class	int Type of device. Possible values are: desktop, tablet, smart tv consoles, or mobile. Joins with mobile_browser_class_id in adh.mobile_browser_class table.
num_active_view_eligible_impression	int when impression is active view eligible; 0 when impression is not active view eligible.
num_active_view_measurable_impression	int 1 when impression is active view measurable; 0 when impression is not active view measurable.
operating_system_version_ids	array ID of OS. Joins with operating_system_version_id in adh.os_version table.
order_id	int
physical_screen_height	int Device screen height in mm.
physical_screen_width	int Device screen width in mm.
publisher_domain	string Domain of page on which ad appeared.
query_id	struct Unique identifier for query has multiple parts.
query_id.process_id	int The processing process.
query_id.server_ip	int The processing server.
query_id.time_usec	int Time in microseconds.
query_language	string Language used by user.
user_id	string User ID

YouTube Reserve line item

yt_reserve_lineitem
creative_id	array Array of creative ids for this line item. Joins with creative_id in any adh.yt table.
end_time	timestamp Time the line item stopped being served.
line_item_id	int Ad Manager line item serving.
line_item_name	string Ad Manager line item name.
order_id	int Ad Manager Order identifier used for serving.
order_name	string Name of the insertion order.
programmatic	boolean true if the line item was programmatic.
skippable_ad_type	string Possible values are: "skippable", "not skippable", or "selectable".
start_time	timestamp Time the line item started to be served.

YouTube Reserve order

yt_reserve_order
advertiser_id	int Unique ID of the advertiser.
advertiser_name	string User entered name of the advertiser.
media_plan_id	int ID of the YouTube Reserve media plan.
media_plan_name	string Name of the YouTube Reserve media plan.
order_id	int Ad Manager Order identifier used for serving.
order_name	string Name of Ad Manager order