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` DV360 View State
`event.dv360_zip_postal_code`	`string` DV360 ZIP/Postal Code
`event.event_sub_type`	`string` Contains further details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "POSTVIEW", "POSTCLICK" or blank for conversion events.
`event.event_time`	`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

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` DV360 View State
`event.dv360_zip_postal_code`	`string` DV360 ZIP/Postal Code
`event.event_sub_type`	`string` Contains further details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "POSTVIEW", "POSTCLICK" or blank for conversion events.
`event.event_time`	`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 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
`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` DV360 View State
`event.dv360_zip_postal_code`	`string` DV360 ZIP/Postal Code
`event.event_sub_type`	`string` Contains further details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "POSTVIEW", "POSTCLICK" or blank for conversion events.
`event.event_time`	`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 floodlight

cm_dt_floodlight
`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` DV360 View State
`event.dv360_zip_postal_code`	`string` DV360 ZIP/Postal Code
`event.event_sub_type`	`string` Contains further details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "POSTVIEW", "POSTCLICK" or blank for conversion events.
`event.event_time`	`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 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` DV360 View State
`event.dv360_zip_postal_code`	`string` DV360 ZIP/Postal Code
`event.event_sub_type`	`string` Contains further details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "POSTVIEW", "POSTCLICK" or blank for conversion events.
`event.event_time`	`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` DV360 View State
`event.dv360_zip_postal_code`	`string` DV360 ZIP/Postal Code
`event.event_sub_type`	`string` Contains further details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "POSTVIEW", "POSTCLICK" or blank for conversion events.
`event.event_time`	`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` DV360 View State
`event.dv360_zip_postal_code`	`string` DV360 ZIP/Postal Code
`event.event_sub_type`	`string` Contains further details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "POSTVIEW", "POSTCLICK" or blank for conversion events.
`event.event_time`	`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

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` DV360 View State
`event.dv360_zip_postal_code`	`string` DV360 ZIP/Postal Code
`event.event_sub_type`	`string` Contains further details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "POSTVIEW", "POSTCLICK" or blank for conversion events.
`event.event_time`	`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 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` DV360 View State
`event.dv360_zip_postal_code`	`string` DV360 ZIP/Postal Code
`event.event_sub_type`	`string` Contains further details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "POSTVIEW", "POSTCLICK" or blank for conversion events.
`event.event_time`	`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` DV360 View State
`event.dv360_zip_postal_code`	`string` DV360 ZIP/Postal Code
`event.event_sub_type`	`string` Contains further details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "POSTVIEW", "POSTCLICK" or blank for conversion events.
`event.event_time`	`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
`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.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.
`partner_id`	`int` Unique ID of the partner.
`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.
`lineitem_id`	`int` Unique ID of the line item.
`adgroup_id`	`int` ID of DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table.
`creative_id`	`int` Joins with creative_id in any adh.dv360_youtube table.

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.
`line_item_id`	`int` Unique ID of the line item.
`partner_id`	`int` Unique ID of the partner.
`campaign_id`	`int` Unique ID of the campaign.
`insertion_order_id`	`int` Unique ID of the insertion order.
`lineitem_id`	`int` Unique ID of the line item.

DV360 YouTube advertiser

dv360_youtube_advertiser
`advertiser_name`	`string` Name of the advertiser.
`advertiser_id`	`int` Unique ID 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_name`	`string` Name of the campaign
`campaign_id`	`int` Unique ID of the campaign.
`partner_id`	`int` Unique ID of the partner.

DV360 YouTube clicks

dv360_youtube_clicks
`click_id`	`struct` Unique identifier for click has multiple parts. Joins with click_id in any adh.dv360_youtube table.
`click_id.process_id`	`int` 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.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
`partner_id`	`int` Unique ID of the partner.
`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.
`lineitem_id`	`int` Unique ID of the line item.
`adgroup_id`	`int` ID of DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table.
`creative_id`	`int` Joins with creative_id in any adh.dv360_youtube table.

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.
`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.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
`partner_id`	`int` Unique ID of the partner.
`impression_data.partner_id`	`int` Unique ID of the partner.
`impression_data.advertiser_id`	`int` Unique ID of the advertiser.
`impression_data.campaign_id`	`int` Unique ID of the campaign.
`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.adgroup_id`	`int` ID of DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table.
`impression_data.creative_id`	`int` Joins with creative_id in any adh.dv360_youtube table.

DV360 YouTube creative

dv360_youtube_creative
`partner_id`	`int` Unique ID of the partner.
`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.
`lineitem_id`	`int` Unique ID of the line item.
`adgroup_id`	`int` ID of DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table.
`creative_id`	`int` Joins with creative_id in any adh.dv360_youtube table.
`creative_name`	`string` Creative name.
`creative_type`	`int` Creative type.
`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.
`third_party_vast_url`	`string` VAST url of the creative if the creative is a third party hosted video.
`is_masthead`	`boolean` True if this is a masthead creative.

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.partner_id`	`int` Unique ID of the partner.
`impression_data.advertiser_id`	`int` Unique ID of the advertiser.
`impression_data.campaign_id`	`int` Unique ID of the campaign.
`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.adgroup_id`	`int` ID of the DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table.
`impression_data.creative_id`	`int` Joins with creative_id in any adh.dv360_youtube table.
`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
`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.
`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.
`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.
`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
`is_app_traffic`	`boolean` true if the event happened in a native app.
`partner_id`	`int` Unique ID of the partner.
`advertiser_id`	`int` Unique ID of the advertiser.
`insertion_order_id`	`int` Unique ID of the insertion order.
`lineitem_id`	`int` Unique ID of the line item.
`adgroup_id`	`int` ID of DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table.

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_name`	`string` Name of the insertion order.
`insertion_order_id`	`int` Unique ID 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_name`	`string` Name of the line item.
`line_item_id`	`int` Unique ID of the line item.
`partner_id`	`int` Unique ID of the partner.
`line_item_reservation_type`	`enum` The type of the reservation. Can be either "PROGRAMMATIC", "INSTANTRESERVE" or "NONE" (meaning standard auction).

Freewheel Active Views

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

Freewheel clicks

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

Freewheel creative pixels

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

Freewheel impressions

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

Freewheel pixel

freewheel_pixel
`pixel_url`	`string` The pixel URL.

Google Ads Active Views

google_ads_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 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.
`impression_data.customer_id`	`int` ID of Google Ads customer. Joins with customer_id in any adh.google_ads table.
`impression_data.campaign_id`	`int` Unique ID of the campaign.
`impression_data.adgroup_id`	`int` ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table.
`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.

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
`customer_id`	`INT64` Joins with customer_id in any adh.google_ads table.
`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.
`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.
`adgroup_id`	`INT64` ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table.
`adgroup_creative_status`	`STRING` The status of the creative within the ad group.
`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.
`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
`impression_data.customer_id`	`int` ID of Google Ads customer. Joins with customer_id in any adh.google_ads table.
`impression_data.campaign_id`	`int` Unique ID of the campaign.
`impression_data.adgroup_id`	`int` ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table.
`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.

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.
`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
`impression_data.customer_id`	`int` ID of Google Ads customer. Joins with customer_id in any adh.google_ads table.
`impression_data.campaign_id`	`int` Unique ID of the campaign.
`impression_data.adgroup_id`	`int` ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table.
`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.

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.
`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.
`third_party_url`	`int` The VAST tag URL string, as seen in Google products.

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.
`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
`impression_data.customer_id`	`int` ID of Google Ads customer. Joins with customer_id in any adh.google_ads table.
`impression_data.campaign_id`	`int` Unique ID of the campaign.
`impression_data.adgroup_id`	`int` ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table.
`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.

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_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
`is_app_traffic`	`boolean` true if the event happened in a native app. FALSE if the event happened in HTML5 app or webview.

Google Ads label

google_ads_label
`customer_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.
`inventory_type`	`enum` The inventory type. Possible values: YOUTUBE, YOUTUBE TV, SEARCH, GMAIL, OTHER. Other refers to either the Google Display or Video network.
`gfp_placements`	`array` Ad Manager placement ID for this impression. Does not represent Campaign Manager placement.
`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
`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.
`advertiser_id`	`int` Unique ID of the advertiser.
`advertiser_name`	`string` Publisher entered name.

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
`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.
`impression_data.order_id`	`int`
`impression_data.line_item_id`	`int` Line item id for this impression.
`impression_data.creative_id`	`int` The ID of the creative.
`impression_data.media_plan_id`	`int` ID of the YouTube Reserve media plan.

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.
`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
`impression_data.order_id`	`int`
`impression_data.line_item_id`	`int` Line item id for this impression.
`impression_data.creative_id`	`int` The ID of the creative.
`impression_data.media_plan_id`	`int` ID of the YouTube Reserve media plan.

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.
`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
`impression_data.order_id`	`int`
`impression_data.line_item_id`	`int` Line item id for this impression.
`impression_data.creative_id`	`int` The ID of the creative.
`impression_data.media_plan_id`	`int` ID of the YouTube Reserve media plan.

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.order_id`	`int` ID of Display and Video 360 customer. Joins with customer_id in any adh.dv360 table.
`impression_data.line_item_id`	`int` Line item ID for this impression.
`impression_data.creative_id`	`int` ID of the creative.
`impression_data.media_plan_id`	`int` ID of the YouTube Reserve media plan.
`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_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.
`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
`is_app_traffic`	`boolean` true if the event happened in a native app. FALSE if the event happened in HTML5 app or webview.
`media_plan_id`	`int` ID of the YouTube Reserve media plan.

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
`order_id`	`int` Ad Manager Order identifier used for serving.
`order_name`	`string` Name of Ad Manager 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.