Ads Data Hub table format - Vendors

Browser

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

City

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

Campaign Manager Data Transfer account info

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

Campaign Manager Data Transfer active view plus

cm_dt_active_view_plus
device_id_md5string
MD5-hashed device ID; a utility may be provided to hash raw device IDs to match.
eventstruct
event.active_view_eligible_impressionsint
Active View: Eligible Impressions
event.active_view_measurable_impressionsint
Active View: Measurable Impressions
event.active_view_viewable_impressionsint
Active View: Viewable Impressions
event.activity_countint
Activity Quantity
event.activity_idint
Activity ID
event.ad_idint
Ad ID
event.advertiser_idint
Advertiser ID
event.audience_segment_idint
event.browser_platform_idstring
Browser/Platform ID
event.browser_versionstring
Browser/Platform Version
event.campaign_idint
Campaign ID
event.city_idint
City ID
event.conversion_idint
Conversion ID
event.country_codestring
Country
event.creative_versionstring
Creative Version
event.dma_region_idint
Designated Market Area (DMA) ID
event.dv360_ad_positionint
DV360 Ad Position
event.dv360_advertiser_idint
DV360 Advertiser ID
event.dv360_adx_page_categoriesstring
DV360 Adx Page Categories
event.dv360_auction_idstring
DV360 Auction ID
event.dv360_browser_idint
DV360 Browser/Platform ID
event.dv360_browser_timezone_offset_minutesint
DV360 Browser Timezone Offset Minutes
event.dv360_city_idint
DV360 City ID
event.dv360_country_codestring
DV360 Country Code
event.dv360_creative_idint
DV360 Creative ID
event.dv360_device_typeint
DV360 Device Type
event.dv360_isp_idint
DV360 ISP ID
event.dv360_languagestring
DV360 Language
event.dv360_mobile_make_idint
DV360 Mobile Make ID
event.dv360_mobile_model_idint
DV360 Mobile Model ID
event.dv360_net_speedint
DV360 Net Speed
event.dv360_operating_system_idint
Operating System ID.
event.dv360_state_region_idint
DV360 Region ID
event.dv360_view_statestring
DV360 View State
event.dv360_zip_postal_codestring
DV360 ZIP/Postal Code
event.event_sub_typestring
Event Sub-Type
event.event_timeint
Event Time
event.event_typestring
Event Type
event.floodlight_config_idint
Floodlight Configuration
event.impression_idstring
Impression ID
event.interaction_time_utc_secondsstring
Interaction Time
event.landing_page_url_idint
Landing Page URL ID
event.operating_system_idint
Operating System ID
event.ord_valuestring
ORD Value
event.placement_idint
Placement ID
event.platform_type_idint
event.referrer_urlstring
Referrer URL
event.rendering_idint
Rendering ID
event.rich_media_event_countersint
Event Counters
event.rich_media_event_idint
Rich Media Event ID
event.rich_media_event_timersdouble
Event Timers
event.rich_media_event_type_idint
Rich Media Event Type ID
event.site_idint
Site ID (Campaign Manager)
event.statestring
State/Region
event.zip_codestring
Zip Code
is_in_rdid_projectboolean
True if this event is also in the _rdid table. Used for deduplication of events.
network_idint
The network ID.
user_idstring
User ID

Campaign Manager Data Transfer activities

cm_dt_activities
device_id_md5string
MD5-hashed device ID; a utility may be provided to hash raw device IDs to match.
eventstruct
event.active_view_eligible_impressionsint
Active View: Eligible Impressions
event.active_view_measurable_impressionsint
Active View: Measurable Impressions
event.active_view_viewable_impressionsint
Active View: Viewable Impressions
event.activity_countint
Activity Quantity
event.activity_idint
Activity ID
event.ad_idint
Ad ID
event.advertiser_idint
Advertiser ID
event.audience_segment_idint
event.browser_platform_idstring
Browser/Platform ID
event.browser_versionstring
Browser/Platform Version
event.campaign_idint
Campaign ID
event.city_idint
City ID
event.conversion_idint
Conversion ID
event.country_codestring
Country
event.creative_versionstring
Creative Version
event.dma_region_idint
Designated Market Area (DMA) ID
event.dv360_ad_positionint
DV360 Ad Position
event.dv360_advertiser_idint
DV360 Advertiser ID
event.dv360_adx_page_categoriesstring
DV360 Adx Page Categories
event.dv360_auction_idstring
DV360 Auction ID
event.dv360_browser_idint
DV360 Browser/Platform ID
event.dv360_browser_timezone_offset_minutesint
DV360 Browser Timezone Offset Minutes
event.dv360_city_idint
DV360 City ID
event.dv360_country_codestring
DV360 Country Code
event.dv360_creative_idint
DV360 Creative ID
event.dv360_device_typeint
DV360 Device Type
event.dv360_isp_idint
DV360 ISP ID
event.dv360_languagestring
DV360 Language
event.dv360_mobile_make_idint
DV360 Mobile Make ID
event.dv360_mobile_model_idint
DV360 Mobile Model ID
event.dv360_net_speedint
DV360 Net Speed
event.dv360_operating_system_idint
Operating System ID.
event.dv360_state_region_idint
DV360 Region ID
event.dv360_view_statestring
DV360 View State
event.dv360_zip_postal_codestring
DV360 ZIP/Postal Code
event.event_sub_typestring
Event Sub-Type
event.event_timeint
Event Time
event.event_typestring
Event Type
event.floodlight_config_idint
Floodlight Configuration
event.impression_idstring
Impression ID
event.interaction_time_utc_secondsstring
Interaction Time
event.landing_page_url_idint
Landing Page URL ID
event.operating_system_idint
Operating System ID
event.ord_valuestring
ORD Value
event.placement_idint
Placement ID
event.platform_type_idint
event.referrer_urlstring
Referrer URL
event.rendering_idint
Rendering ID
event.rich_media_event_countersint
Event Counters
event.rich_media_event_idint
Rich Media Event ID
event.rich_media_event_timersdouble
Event Timers
event.rich_media_event_type_idint
Rich Media Event Type ID
event.site_idint
Site ID (Campaign Manager)
event.statestring
State/Region
event.zip_codestring
Zip Code
is_in_rdid_projectboolean
True if this event is also in the _rdid table. Used for deduplication of events.
network_idint
The network ID.
user_idstring
User ID

Campaign Manager Data Transfer activity category

cm_dt_activity_category
account_idint
Unique ID of the account.
activitystring
User defined category report interface name for floodlight tags.
activity_group_idint
ID of the group to which this advertiser belongs. An advertiser may be a member of only one group.
activity_idint
Unique ID of the Floodlight activity.
activity_sub_typestring
User defined string corresponding to cat= value from Floodlight tag.
activity_typestring
User defined string corresponding to type= value from Floodlight tag.
advertiser_idint
Unique ID of the advertiser.
floodlight_config_idint
Unique ID of the floodlight configuration.
tag_counting_method_idint
User defined type - describing Floodlight tag type. Key: 1 - standard, 2 - unique, 3 - custom, 4 - integer of transactionfor sales tags only, 5 - integer of items sold.

Campaign Manager Data Transfer activity type

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

Campaign Manager Data Transfer ad

cm_dt_ad
account_idint
Unique ID of the account.
adstring
User defined ad name.
ad_click_urlstring
Click through URL of Click Ad type creatives only (aka Click Commands)
ad_commentsstring
User defined ad level comments.
ad_idint
Unique ID of the ad.
ad_typestring
Type of ad. Possible values are: Standard, Interstitial, Static Click, Dynamic Click, Tracking, In-Steam Video, DART Search, Affiliate, PInclusion, Product feeds, Natural Search, Default, Interstitial Default, InStream Default, Ad Brand-neutral
ad_type_idint
Unique ID of the ad type.
advertiser_idint
Unique ID of the advertiser.
campaign_idint
Unique ID of the campaign.
creative_sizestring
The creative size in pixels: width x height. Empty size is represented by "0X0".
floodlight_config_idint
Unique ID of the floodlight configuration.

Campaign Manager Data Transfer Ad placement assignments

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

Campaign Manager Data Transfer Advertiser

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

Campaign Manager Data Transfer asset

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

Campaign Manager Data Transfer audience segments

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

Campaign Manager Data Transfer browser

cm_dt_browser
browser_platformstring
browser_platform_idint
Browser / Platform ID

Campaign Manager Data Transfer campaign

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

Campaign Manager Data Transfer city

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

Campaign Manager Data Transfer clicks

cm_dt_clicks
device_id_md5string
MD5-hashed device ID; a utility may be provided to hash raw device IDs to match.
eventstruct
event.active_view_eligible_impressionsint
Active View: Eligible Impressions
event.active_view_measurable_impressionsint
Active View: Measurable Impressions
event.active_view_viewable_impressionsint
Active View: Viewable Impressions
event.activity_countint
Activity Quantity
event.activity_idint
Activity ID
event.ad_idint
Ad ID
event.advertiser_idint
Advertiser ID
event.audience_segment_idint
event.browser_platform_idstring
Browser/Platform ID
event.browser_versionstring
Browser/Platform Version
event.campaign_idint
Campaign ID
event.city_idint
City ID
event.conversion_idint
Conversion ID
event.country_codestring
Country
event.creative_versionstring
Creative Version
event.dma_region_idint
Designated Market Area (DMA) ID
event.dv360_ad_positionint
DV360 Ad Position
event.dv360_advertiser_idint
DV360 Advertiser ID
event.dv360_adx_page_categoriesstring
DV360 Adx Page Categories
event.dv360_auction_idstring
DV360 Auction ID
event.dv360_browser_idint
DV360 Browser/Platform ID
event.dv360_browser_timezone_offset_minutesint
DV360 Browser Timezone Offset Minutes
event.dv360_city_idint
DV360 City ID
event.dv360_country_codestring
DV360 Country Code
event.dv360_creative_idint
DV360 Creative ID
event.dv360_device_typeint
DV360 Device Type
event.dv360_isp_idint
DV360 ISP ID
event.dv360_languagestring
DV360 Language
event.dv360_mobile_make_idint
DV360 Mobile Make ID
event.dv360_mobile_model_idint
DV360 Mobile Model ID
event.dv360_net_speedint
DV360 Net Speed
event.dv360_operating_system_idint
DV60 operating system ID
event.dv360_state_region_idint
DV360 Region ID
event.dv360_view_statestring
DV360 View State
event.dv360_zip_postal_codestring
DV360 ZIP/Postal Code
event.event_sub_typestring
Event Sub-Type
event.event_timeint
Event Time
event.event_typestring
Event Type
event.floodlight_config_idint
Floodlight Configuration
event.impression_idstring
Impression ID
event.interaction_time_utc_secondsstring
Interaction Time
event.landing_page_url_idint
Landing Page URL ID
event.operating_system_idint
Operating System ID
event.ord_valuestring
ORD Value
event.placement_idint
Placement ID
event.platform_type_idint
event.referrer_urlstring
Referrer URL
event.rendering_idint
Rendering ID
event.rich_media_event_countersint
Event Counters
event.rich_media_event_idint
Rich Media Event ID
event.rich_media_event_timersdouble
Event Timers
event.rich_media_event_type_idint
Rich Media Event Type ID
event.site_idint
Site ID (Campaign Manager)
event.statestring
State/Region
event.zip_codestring
Zip Code
is_in_rdid_projectboolean
True if this event is also in the _rdid table. Used for deduplication of events.
network_idint
The network ID.
user_idstring
User ID

Campaign Manager Data Transfer creative

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

Campaign Manager Data Transfer creative ad assignment

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

Campaign Manager Data Transfer custom creative field

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

Campaign Manager Data Transfer custom rich media

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

Campaign Manager Data Transfer designated market area

cm_dt_designated_market_area
dma_regionstring
dma_region_idint

Campaign Manager Data Transfer events

cm_dt_events
device_id_md5string
MD5-hashed device ID; a utility may be provided to hash raw device IDs to match.
eventstruct
event.active_view_eligible_impressionsint
Active View: Eligible Impressions
event.active_view_measurable_impressionsint
Active View: Measurable Impressions
event.active_view_viewable_impressionsint
Active View: Viewable Impressions
event.activity_countint
Activity Quantity
event.activity_idint
Activity ID
event.ad_idint
Ad ID
event.advertiser_idint
Advertiser ID
event.audience_segment_idint
event.browser_platform_idstring
Browser/Platform ID
event.browser_versionstring
Browser/Platform Version
event.campaign_idint
Campaign ID
event.city_idint
City ID
event.conversion_idint
Conversion ID
event.country_codestring
Country
event.creative_versionstring
Creative Version
event.dma_region_idint
Designated Market Area (DMA) ID
event.dv360_ad_positionint
DV360 Ad Position
event.dv360_advertiser_idint
DV360 Advertiser ID
event.dv360_adx_page_categoriesstring
DV360 Adx Page Categories
event.dv360_auction_idstring
DV360 Auction ID
event.dv360_browser_idint
DV360 Browser/Platform ID
event.dv360_browser_timezone_offset_minutesint
DV360 Browser Timezone Offset Minutes
event.dv360_city_idint
DV360 City ID
event.dv360_country_codestring
DV360 Country Code
event.dv360_creative_idint
DV360 Creative ID
event.dv360_device_typeint
DV360 Device Type
event.dv360_isp_idint
DV360 ISP ID
event.dv360_languagestring
DV360 Language
event.dv360_mobile_make_idint
DV360 Mobile Make ID
event.dv360_mobile_model_idint
DV360 Mobile Model ID
event.dv360_net_speedint
DV360 Net Speed
event.dv360_operating_system_idint
event.dv360_state_region_idint
DV360 Region ID
event.dv360_view_statestring
DV360 View State
event.dv360_zip_postal_codestring
DV360 ZIP/Postal Code
event.event_sub_typestring
Event Sub-Type
event.event_timeint
Event Time
event.event_typestring
Event Type
event.floodlight_config_idint
Floodlight Configuration
event.impression_idstring
Impression ID
event.interaction_time_utc_secondsstring
Interaction Time
event.landing_page_url_idint
Landing Page URL ID
event.operating_system_idint
Operating System ID
event.ord_valuestring
ORD Value
event.placement_idint
Placement ID
event.platform_type_idint
event.referrer_urlstring
Referrer URL
event.rendering_idint
Rendering ID
event.rich_media_event_countersint
Event Counters
event.rich_media_event_idint
Rich Media Event ID
event.rich_media_event_timersdouble
Event Timers
event.rich_media_event_type_idint
Rich Media Event Type ID
event.site_idint
Site ID (Campaign Manager)
event.statestring
State/Region
event.zip_codestring
Zip Code
is_in_rdid_projectboolean
True if this event is also in the _rdid table. Used for deduplication of events.
network_idint
The network ID.
user_idstring
User ID

Campaign Manager Data Transfer floodlight

cm_dt_floodlight
device_id_md5string
MD5-hashed device ID. Utility will be provided to hash raw device IDs to match.
eventstruct
event.active_view_eligible_impressionsint
Active View: Eligible Impressions
event.active_view_measurable_impressionsint
Active View: Measurable Impressions
event.active_view_viewable_impressionsint
Active View: Viewable Impressions
event.activity_countint
Activity Quantity
event.activity_idint
Activity ID
event.ad_idint
Ad ID
event.advertiser_idint
Advertiser ID
event.audience_segment_idint
event.browser_platform_idstring
Browser/Platform ID
event.browser_versionstring
Browser/Platform Version
event.campaign_idint
Campaign ID
event.city_idint
City ID
event.conversion_idint
Conversion ID
event.country_codestring
Country
event.creative_versionstring
Creative Version
event.dma_region_idint
Designated Market Area (DMA) ID
event.dv360_ad_positionint
DV360 Ad Position
event.dv360_advertiser_idint
DV360 Advertiser ID
event.dv360_adx_page_categoriesstring
DV360 Adx Page Categories
event.dv360_auction_idstring
DV360 Auction ID
event.dv360_browser_idint
DV360 Browser/Platform ID
event.dv360_browser_timezone_offset_minutesint
DV360 Browser Timezone Offset Minutes
event.dv360_city_idint
DV360 City ID
event.dv360_country_codestring
DV360 Country Code
event.dv360_creative_idint
DV360 Creative ID
event.dv360_device_typeint
DV360 Device Type
event.dv360_isp_idint
DV360 ISP ID
event.dv360_languagestring
DV360 Language
event.dv360_mobile_make_idint
DV360 Mobile Make ID
event.dv360_mobile_model_idint
DV360 Mobile Model ID
event.dv360_net_speedint
DV360 Net Speed
event.dv360_operating_system_idint
event.dv360_state_region_idint
DV360 Region ID
event.dv360_view_statestring
DV360 View State
event.dv360_zip_postal_codestring
DV360 ZIP/Postal Code
event.event_sub_typestring
Event Sub-Type
event.event_timeint
Event Time
event.event_typestring
Event Type
event.floodlight_config_idint
Floodlight Configuration
event.impression_idstring
Impression ID
event.interaction_time_utc_secondsstring
Interaction Time
event.landing_page_url_idint
Landing Page URL ID
event.operating_system_idint
Operating System ID
event.ord_valuestring
ORD Value
event.placement_idint
Placement ID
event.platform_type_idint
event.referrer_urlstring
Referrer URL
event.rendering_idint
Rendering ID
event.rich_media_event_countersint
Event Counters
event.rich_media_event_idint
Rich Media Event ID
event.rich_media_event_timersdouble
Event Timers
event.rich_media_event_type_idint
Rich Media Event Type ID
event.site_idint
Site ID (Campaign Manager)
event.statestring
State/Region
event.zip_codestring
Zip Code
is_in_rdid_projectboolean
True if this event is also in the _rdid table. Used for deduplication of events.
network_idint
The network ID.
user_idstring
User ID

Campaign Manager Data Transfer impressions

cm_dt_impressions
device_id_md5string
MD5-hashed device ID. Utility will be provided to hash raw device IDs to match.
eventstruct
event.active_view_eligible_impressionsint
Active View: Eligible Impressions
event.active_view_measurable_impressionsint
Active View: Measurable Impressions
event.active_view_viewable_impressionsint
Active View: Viewable Impressions
event.activity_countint
Activity Quantity
event.activity_idint
Activity ID
event.ad_idint
Ad ID
event.advertiser_idint
Advertiser ID
event.audience_segment_idint
event.browser_platform_idstring
Browser/Platform ID
event.browser_versionstring
Browser/Platform Version
event.campaign_idint
Campaign ID
event.city_idint
City ID
event.conversion_idint
Conversion ID
event.country_codestring
Country
event.creative_versionstring
Creative Version
event.dma_region_idint
Designated Market Area (DMA) ID
event.dv360_ad_positionint
DV360 Ad Position
event.dv360_advertiser_idint
DV360 Advertiser ID
event.dv360_adx_page_categoriesstring
DV360 Adx Page Categories
event.dv360_auction_idstring
DV360 Auction ID
event.dv360_browser_idint
DV360 Browser/Platform ID
event.dv360_browser_timezone_offset_minutesint
DV360 Browser Timezone Offset Minutes
event.dv360_city_idint
DV360 City ID
event.dv360_country_codestring
DV360 Country Code
event.dv360_creative_idint
DV360 Creative ID
event.dv360_device_typeint
DV360 Device Type
event.dv360_isp_idint
DV360 ISP ID
event.dv360_languagestring
DV360 Language
event.dv360_mobile_make_idint
DV360 Mobile Make ID
event.dv360_mobile_model_idint
DV360 Mobile Model ID
event.dv360_net_speedint
DV360 Net Speed
event.dv360_operating_system_idint
event.dv360_state_region_idint
DV360 Region ID
event.dv360_view_statestring
DV360 View State
event.dv360_zip_postal_codestring
DV360 ZIP/Postal Code
event.event_sub_typestring
Event Sub-Type
event.event_timeint
Event Time
event.event_typestring
Event Type
event.floodlight_config_idint
Floodlight Configuration
event.impression_idstring
Impression ID
event.interaction_time_utc_secondsstring
Interaction Time
event.landing_page_url_idint
Landing Page URL ID
event.operating_system_idint
Operating System ID
event.ord_valuestring
ORD Value
event.placement_idint
Placement ID
event.platform_type_idint
event.referrer_urlstring
Referrer URL
event.rendering_idint
Rendering ID
event.rich_media_event_countersint
Event Counters
event.rich_media_event_idint
Rich Media Event ID
event.rich_media_event_timersdouble
Event Timers
event.rich_media_event_type_idint
Rich Media Event Type ID
event.site_idint
Site ID (Campaign Manager)
event.statestring
State/Region
event.zip_codestring
Zip Code
is_in_rdid_projectboolean
True if this event is also in the _rdid table. Used for deduplication of events.
network_idint
The network ID.
user_idstring
User ID

Campaign Manager Data Transfer landing page url

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

Campaign Manager Data Transfer operating system

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

Campaign Manager Data Transfer placement

cm_dt_placement
account_idint
Unique ID of the account.
activity_idint
Unique ID of the Floodlight activity.
advertiser_idint
Unique ID of the advertiser.
campaign_idint
Unique ID of the campaign.
content_categorystring
User defined content category.
content_category_idint
ID of content category.
floodlight_config_idint
Unique ID of the floodlight configuration.
placementstring
placement_idint
site_idint
Unique ID of the site.
site_keynamestring

Campaign Manager Data Transfer rich media

cm_dt_rich_media
device_id_md5string
MD5-hashed device ID; a utility may be provided to hash raw device IDs to match.
eventstruct
event.active_view_eligible_impressionsint
Active View: Eligible Impressions
event.active_view_measurable_impressionsint
Active View: Measurable Impressions
event.active_view_viewable_impressionsint
Active View: Viewable Impressions
event.activity_countint
Activity Quantity
event.activity_idint
Activity ID
event.ad_idint
Ad ID
event.advertiser_idint
Advertiser ID
event.audience_segment_idint
event.browser_platform_idstring
Browser/Platform ID
event.browser_versionstring
Browser/Platform Version
event.campaign_idint
Campaign ID
event.city_idint
City ID
event.conversion_idint
Conversion ID
event.country_codestring
Country
event.creative_versionstring
Creative Version
event.dma_region_idint
Designated Market Area (DMA) ID
event.dv360_ad_positionint
DV360 Ad Position
event.dv360_advertiser_idint
DV360 Advertiser ID
event.dv360_adx_page_categoriesstring
DV360 Adx Page Categories
event.dv360_auction_idstring
DV360 Auction ID
event.dv360_browser_idint
DV360 Browser/Platform ID
event.dv360_browser_timezone_offset_minutesint
DV360 Browser Timezone Offset Minutes
event.dv360_city_idint
DV360 City ID
event.dv360_country_codestring
DV360 Country Code
event.dv360_creative_idint
DV360 Creative ID
event.dv360_device_typeint
DV360 Device Type
event.dv360_isp_idint
DV360 ISP ID
event.dv360_languagestring
DV360 Language
event.dv360_mobile_make_idint
DV360 Mobile Make ID
event.dv360_mobile_model_idint
DV360 Mobile Model ID
event.dv360_net_speedint
DV360 Net Speed
event.dv360_operating_system_idint
event.dv360_state_region_idint
DV360 Region ID
event.dv360_view_statestring
DV360 View State
event.dv360_zip_postal_codestring
DV360 ZIP/Postal Code
event.event_sub_typestring
Event Sub-Type
event.event_timeint
Event Time
event.event_typestring
Event Type
event.floodlight_config_idint
Floodlight Configuration
event.impression_idstring
Impression ID
event.interaction_time_utc_secondsstring
Interaction Time
event.landing_page_url_idint
Landing Page URL ID
event.operating_system_idint
Operating System ID
event.ord_valuestring
ORD Value
event.placement_idint
Placement ID
event.platform_type_idint
event.referrer_urlstring
Referrer URL
event.rendering_idint
Rendering ID
event.rich_media_event_countersint
Event Counters
event.rich_media_event_idint
Rich Media Event ID
event.rich_media_event_timersdouble
Event Timers
event.rich_media_event_type_idint
Rich Media Event Type ID
event.site_idint
Site ID (Campaign Manager)
event.statestring
State/Region
event.zip_codestring
Zip Code
is_in_rdid_projectboolean
True if this event is also in the _rdid table. Used for deduplication of events.
network_idint
The network ID.
user_idstring
User ID

Campaign Manager Data Transfer site

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

Campaign Manager Data Transfer state

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

DV360 Data Transfer active view plus

dv360_dt_active_view_plus
device_id_md5string
MD5-hashed device ID. Utility will be provided to hash raw device IDs to match.
eventstruct
event.active_view_eligible_impressionsint
Active View: Eligible Impressions
event.active_view_measurable_impressionsint
Active View: Measurable Impressions
event.active_view_viewable_impressionsint
Active View: Viewable Impressions
event.activity_countint
Activity Quantity
event.activity_idint
Activity ID
event.ad_idint
Ad ID
event.advertiser_idint
Advertiser ID
event.audience_segment_idint
event.browser_platform_idstring
Browser/Platform ID
event.browser_versionstring
Browser/Platform Version
event.campaign_idint
Campaign ID
event.city_idint
City ID
event.conversion_idint
Conversion ID
event.country_codestring
Country
event.creative_versionstring
Creative Version
event.dma_region_idint
Designated Market Area (DMA) ID
event.dv360_ad_positionint
DV360 Ad Position
event.dv360_advertiser_idint
DV360 Advertiser ID
event.dv360_adx_page_categoriesstring
DV360 Adx Page Categories
event.dv360_auction_idstring
DV360 Auction ID
event.dv360_browser_idint
DV360 Browser/Platform ID
event.dv360_browser_timezone_offset_minutesint
DV360 Browser Timezone Offset Minutes
event.dv360_city_idint
DV360 City ID
event.dv360_country_codestring
DV360 Country Code
event.dv360_creative_idint
DV360 Creative ID
event.dv360_device_typeint
DV360 Device Type
event.dv360_isp_idint
DV360 ISP ID
event.dv360_languagestring
DV360 Language
event.dv360_mobile_make_idint
DV360 Mobile Make ID
event.dv360_mobile_model_idint
DV360 Mobile Model ID
event.dv360_net_speedint
DV360 Net Speed
event.dv360_operating_system_idint
event.dv360_state_region_idint
DV360 Region ID
event.dv360_view_statestring
DV360 View State
event.dv360_zip_postal_codestring
DV360 ZIP/Postal Code
event.event_sub_typestring
Event Sub-Type
event.event_timeint
Event Time
event.event_typestring
Event Type
event.floodlight_config_idint
Floodlight Configuration
event.impression_idstring
Impression ID
event.interaction_time_utc_secondsstring
Interaction Time
event.landing_page_url_idint
Landing Page URL ID
event.operating_system_idint
Operating System ID
event.ord_valuestring
ORD Value
event.placement_idint
Placement ID
event.platform_type_idint
event.referrer_urlstring
Referrer URL
event.rendering_idint
Rendering ID
event.rich_media_event_countersint
Event Counters
event.rich_media_event_idint
Rich Media Event ID
event.rich_media_event_timersdouble
Event Timers
event.rich_media_event_type_idint
Rich Media Event Type ID
event.site_idint
Site ID (Campaign Manager)
event.statestring
State/Region
event.zip_codestring
Zip Code
is_in_rdid_projectboolean
True if this event is also in the _rdid table. Used for deduplication of events.
network_idint
The network ID.
user_idstring
User ID

DV360 Data Transfer activities

dv360_dt_activities
device_id_md5string
MD5-hashed device ID. Utility will be provided to hash raw device IDs to match.
eventstruct
event.active_view_eligible_impressionsint
Active View: Eligible Impressions
event.active_view_measurable_impressionsint
Active View: Measurable Impressions
event.active_view_viewable_impressionsint
Active View: Viewable Impressions
event.activity_countint
Activity Quantity
event.activity_idint
Activity ID
event.ad_idint
Ad ID
event.advertiser_idint
Advertiser ID
event.audience_segment_idint
event.browser_platform_idstring
Browser/Platform ID
event.browser_versionstring
Browser/Platform Version
event.campaign_idint
Campaign ID
event.city_idint
City ID
event.conversion_idint
Conversion ID
event.country_codestring
Country
event.creative_versionstring
Creative Version
event.dma_region_idint
Designated Market Area (DMA) ID
event.dv360_ad_positionint
DV360 Ad Position
event.dv360_advertiser_idint
DV360 Advertiser ID
event.dv360_adx_page_categoriesstring
DV360 Adx Page Categories
event.dv360_auction_idstring
DV360 Auction ID
event.dv360_browser_idint
DV360 Browser/Platform ID
event.dv360_browser_timezone_offset_minutesint
DV360 Browser Timezone Offset Minutes
event.dv360_city_idint
DV360 City ID
event.dv360_country_codestring
DV360 Country Code
event.dv360_creative_idint
DV360 Creative ID
event.dv360_device_typeint
DV360 Device Type
event.dv360_isp_idint
DV360 ISP ID
event.dv360_languagestring
DV360 Language
event.dv360_mobile_make_idint
DV360 Mobile Make ID
event.dv360_mobile_model_idint
DV360 Mobile Model ID
event.dv360_net_speedint
DV360 Net Speed
event.dv360_operating_system_idint
event.dv360_state_region_idint
DV360 Region ID
event.dv360_view_statestring
DV360 View State
event.dv360_zip_postal_codestring
DV360 ZIP/Postal Code
event.event_sub_typestring
Event Sub-Type
event.event_timeint
Event Time
event.event_typestring
Event Type
event.floodlight_config_idint
Floodlight Configuration
event.impression_idstring
Impression ID
event.interaction_time_utc_secondsstring
Interaction Time
event.landing_page_url_idint
Landing Page URL ID
event.operating_system_idint
Operating System ID
event.ord_valuestring
ORD Value
event.placement_idint
Placement ID
event.platform_type_idint
event.referrer_urlstring
Referrer URL
event.rendering_idint
Rendering ID
event.rich_media_event_countersint
Event Counters
event.rich_media_event_idint
Rich Media Event ID
event.rich_media_event_timersdouble
Event Timers
event.rich_media_event_type_idint
Rich Media Event Type ID
event.site_idint
Site ID (Campaign Manager)
event.statestring
State/Region
event.zip_codestring
Zip Code
is_in_rdid_projectboolean
True if this event is also in the _rdid table. Used for deduplication of events.
network_idint
The network ID.
user_idstring
User ID

DV360 Data Transfer advertiser

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

DV360 Data Transfer campaign

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

DV360 Data Transfer clicks

dv360_dt_clicks
device_id_md5string
MD5-hashed device ID. Utility will be provided to hash raw device IDs to match.
eventstruct
event.active_view_eligible_impressionsint
Active View: Eligible Impressions
event.active_view_measurable_impressionsint
Active View: Measurable Impressions
event.active_view_viewable_impressionsint
Active View: Viewable Impressions
event.activity_countint
Activity Quantity
event.activity_idint
Activity ID
event.ad_idint
Ad ID
event.advertiser_idint
Advertiser ID
event.audience_segment_idint
event.browser_platform_idstring
Browser/Platform ID
event.browser_versionstring
Browser/Platform Version
event.campaign_idint
Campaign ID
event.city_idint
City ID
event.conversion_idint
Conversion ID
event.country_codestring
Country
event.creative_versionstring
Creative Version
event.dma_region_idint
Designated Market Area (DMA) ID
event.dv360_ad_positionint
DV360 Ad Position
event.dv360_advertiser_idint
DV360 Advertiser ID
event.dv360_adx_page_categoriesstring
DV360 Adx Page Categories
event.dv360_auction_idstring
DV360 Auction ID
event.dv360_browser_idint
DV360 Browser/Platform ID
event.dv360_browser_timezone_offset_minutesint
DV360 Browser Timezone Offset Minutes
event.dv360_city_idint
DV360 City ID
event.dv360_country_codestring
DV360 Country Code
event.dv360_creative_idint
DV360 Creative ID
event.dv360_device_typeint
DV360 Device Type
event.dv360_isp_idint
DV360 ISP ID
event.dv360_languagestring
DV360 Language
event.dv360_mobile_make_idint
DV360 Mobile Make ID
event.dv360_mobile_model_idint
DV360 Mobile Model ID
event.dv360_net_speedint
DV360 Net Speed
event.dv360_operating_system_idint
event.dv360_state_region_idint
DV360 Region ID
event.dv360_view_statestring
DV360 View State
event.dv360_zip_postal_codestring
DV360 ZIP/Postal Code
event.event_sub_typestring
Event Sub-Type
event.event_timeint
Event Time
event.event_typestring
Event Type
event.floodlight_config_idint
Floodlight Configuration
event.impression_idstring
Impression ID
event.interaction_time_utc_secondsstring
Interaction Time
event.landing_page_url_idint
Landing Page URL ID
event.operating_system_idint
Operating System ID
event.ord_valuestring
ORD Value
event.placement_idint
Placement ID
event.platform_type_idint
event.referrer_urlstring
Referrer URL
event.rendering_idint
Rendering ID
event.rich_media_event_countersint
Event Counters
event.rich_media_event_idint
Rich Media Event ID
event.rich_media_event_timersdouble
Event Timers
event.rich_media_event_type_idint
Rich Media Event Type ID
event.site_idint
Site ID (Campaign Manager)
event.statestring
State/Region
event.zip_codestring
Zip Code
is_in_rdid_projectboolean
True if this event is also in the _rdid table. Used for deduplication of events.
network_idint
The network ID.
user_idstring
User ID

DV360 Data Transfer impressions

dv360_dt_impressions
device_id_md5string
MD5-hashed device ID. Utility will be provided to hash raw device IDs to match.
eventstruct
event.active_view_eligible_impressionsint
Active View: Eligible Impressions
event.active_view_measurable_impressionsint
Active View: Measurable Impressions
event.active_view_viewable_impressionsint
Active View: Viewable Impressions
event.activity_countint
Activity Quantity
event.activity_idint
Activity ID
event.ad_idint
Ad ID
event.advertiser_idint
Advertiser ID
event.audience_segment_idint
event.browser_platform_idstring
Browser/Platform ID
event.browser_versionstring
Browser/Platform Version
event.campaign_idint
Campaign ID
event.city_idint
City ID
event.conversion_idint
Conversion ID
event.country_codestring
Country
event.creative_versionstring
Creative Version
event.dma_region_idint
Designated Market Area (DMA) ID
event.dv360_ad_positionint
DV360 Ad Position
event.dv360_advertiser_idint
DV360 Advertiser ID
event.dv360_adx_page_categoriesstring
DV360 Adx Page Categories
event.dv360_auction_idstring
DV360 Auction ID
event.dv360_browser_idint
DV360 Browser/Platform ID
event.dv360_browser_timezone_offset_minutesint
DV360 Browser Timezone Offset Minutes
event.dv360_city_idint
DV360 City ID
event.dv360_country_codestring
DV360 Country Code
event.dv360_creative_idint
DV360 Creative ID
event.dv360_device_typeint
DV360 Device Type
event.dv360_isp_idint
DV360 ISP ID
event.dv360_languagestring
DV360 Language
event.dv360_mobile_make_idint
DV360 Mobile Make ID
event.dv360_mobile_model_idint
DV360 Mobile Model ID
event.dv360_net_speedint
DV360 Net Speed
event.dv360_operating_system_idint
event.dv360_state_region_idint
DV360 Region ID
event.dv360_view_statestring
DV360 View State
event.dv360_zip_postal_codestring
DV360 ZIP/Postal Code
event.event_sub_typestring
Event Sub-Type
event.event_timeint
Event Time
event.event_typestring
Event Type
event.floodlight_config_idint
Floodlight Configuration
event.impression_idstring
Impression ID
event.interaction_time_utc_secondsstring
Interaction Time
event.landing_page_url_idint
Landing Page URL ID
event.operating_system_idint
Operating System ID
event.ord_valuestring
ORD Value
event.placement_idint
Placement ID
event.platform_type_idint
event.referrer_urlstring
Referrer URL
event.rendering_idint
Rendering ID
event.rich_media_event_countersint
Event Counters
event.rich_media_event_idint
Rich Media Event ID
event.rich_media_event_timersdouble
Event Timers
event.rich_media_event_type_idint
Rich Media Event Type ID
event.site_idint
Site ID (Campaign Manager)
event.statestring
State/Region
event.zip_codestring
Zip Code
is_in_rdid_projectboolean
True if this event is also in the _rdid table. Used for deduplication of events.
network_idint
The network ID.
user_idstring
User ID

DV360 Data Transfer insertion order

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

DV360 Data Transfer line item

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

Freewheel active views

freewheel_active_views
freewheel_event_idrecord
Unique identifier for query has multiple parts. Joins with event_id.
freewheel_event_id.time_usecint
Time in microseconds.
freewheel_event_id.server_ipint
The processing server.
freewheel_event_id.process_idint
The processing process.
labelstring
Name of conversion event.
ad_current_time_msint
The current time of the ad video playback in milliseconds
user_languagestring
A three-letter ISO 639-2/bibliographic language code
active_viewrecord
Active view
ad_idstring
VAST ad_id
user_idstring
Raw user ID.

Freewheel clicks

freewheel_clicks
freewheel_event_idrecord
Unique identifier for query has multiple parts. Joins with event_id.
freewheel_event_id.time_usecint
Time in microseconds.
freewheel_event_id.server_ipint
The processing server.
freewheel_event_id.process_idint
The processing process.
labelstring
Name of conversion event.
ad_current_time_msint
The current time of the ad video playback in milliseconds
user_languagestring
A three-letter ISO 639-2/bibliographic language code
ad_idstring
VAST ad_id
user_idstring
Raw user ID.

Freewheel creative pixels

freewheel_creative_pixels
ad_idstring
Vast Ad ID.
pixel_urlstring
pixel URL.

Freewheel GAM pixels

freewheel_gam_pixels
pixel_urlstring
pixel URL.

Freewheel impressions

freewheel_impressions
freewheel_event_idrecord
Unique identifier for query has multiple parts. Joins with event_id.
freewheel_event_id.time_usecint
Time in microseconds.
freewheel_event_id.server_ipint
The processing server.
freewheel_event_id.process_idint
The processing process.
labelstring
Name of conversion event.
ad_current_time_msint
The current time of the ad video playback in milliseconds
user_languagestring
A three-letter ISO 639-2/bibliographic language code
ad_idstring
VAST ad_id
user_idstring
Raw user ID.

Google Ads active views

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

Google Ads ad group

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

Google Ads campaign

google_ads_campaign
advertising_channel_typestring
Advertising channel type. Possible values are: SEARCH, DISPLAY, VIDEO, or OTHER.
campaign_idint
Unique ID of the campaign.
campaign_namestring
Campaign name.
campaign_statusint
Campaign status. 3 = ACTIVE. 5 = PAUSED. 7 = DELETED.
customer_idint
Joins with customer_id in any adh.google_ads table.
end_timeint
Timestamp when the campaign ends in milliseconds.
label_idsarray
Joins with label_id in the adh.google_ads_label table.
start_timeint
Timestamp when the campaign begins in milliseconds.

Google Ads clicks

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

Google Ads clicks audience

google_ads_clicks_audience
click_idstruct
Unique identifier for click has multiple parts. Joins with click_id in any adh.yt table.
click_id.process_idint
The processing process.
click_id.server_ipint
The processing server.
click_id.time_usecint
Time in microseconds.
click_typeint
The click type.
is_in_rdid_projectboolean
True if this event is also in the _rdid table. Used for deduplication of events.
query_idstruct
Unique identifier for query has multiple parts. Joins with query_id in any adh.yt table.
query_id.process_idint
The processing process.
query_id.server_ipint
The processing server.
query_id.time_usecint
Time in microseconds.
user_idstring
User ID

Google Ads conversions

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

Google Ads conversions audience

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

Google Ads creative

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

Google Ads creative vendor metadata

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

Google Ads customer

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

Google Ads impressions

google_ads_impressions
ad_group_creative_idint
ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table.
adgroup_idint
ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table.
campaign_idint
Unique ID of the campaign.
content_urlstring
URL of the page on which ad appeared. Part of the url is removed for privacy.
customer_idint
ID of Google Ads customer.Joins with customer_id in any adh.google_ads table.
device_heightint
Device height in px.
device_widthint
Device width in px.
is_in_rdid_projectboolean
True if this event is also in the _rdid table. Used for deduplication of events.
locationstruct
Unique identifier for location has multiple parts
location.countrystring
location.geo_city_idint
Code for city. Joins with city_id in adh.city table.
location.geo_metroint
Code for metro region. Joins with metro_id in adh.metro table.
location.geo_regionstring
Region as string e.g. US-CA.
mobile_browser_classint
Type of browser. Possible values are: desktop, tablet, smart tv consoles, or mobile. Joins with mobile_browser_class_id in adh.mobile_browser_cltable.
num_active_view_eligible_impressionint
1 when impression is active view eligible; 0 when impression is not active view eligible.
num_active_view_measurable_impressionint
1 when impression is active view measurable; 0 when impression is not active view measurable.
operating_system_version_idsarray
ID of OS. Joins with operating_system_version_id in adh.os_version table.
physical_screen_heightint
Device screen height in mm.
physical_screen_widthint
Device screen width in mm.
publisher_domainstring
Domain of the page on which ad appeared.
query_idstruct
Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
query_id.process_idint
The processing ID.
query_id.server_ipint
The processing server.
query_id.time_usecint
The query time in microseconds.
query_languagestring
Language used by user.
user_idstring
User ID
is_app_trafficboolean
TRUE if the event happened in a native app. FALSE if the event happened in HTML5 app or webview.

Google Ads label

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

Google Ads view through conversions

google_ads_view_through_conversions
click_idstruct
Unique identifier for click has multiple parts. Joins with click_id in any adh.yt table.
click_id.process_idint
The processing process.
click_id.server_ipint
The processing server.
click_id.time_usecint
Time in microseconds.
conversion_idstruct
Unique identifier for conversion has multiple parts.
conversion_id.process_idint
The processing process.
conversion_id.server_ipint
The processing server.
conversion_id.time_usecint
Time in microseconds.
conversion_typeint
The type of conversion.
device_id_md5string
MD5-hashed device ID. Utility will be provided to hash raw device IDs to match.
is_in_rdid_projectboolean
True if this event is also in the _rdid table. Used for deduplication of events.
labelstring
Name of conversion event.
query_idstruct
Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
query_id.process_idint
The processing ID.
query_id.server_ipint
The processing server.
query_id.time_usecint
The query time in microseconds.
user_idstring
User ID

Metro

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

Mobile browser class

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

Operating system

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

Operating system version

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

Partner Sold - Cross Sell active views

partner_sold_cross_sell_active_views
num_active_view_viewable_impressionint
1 when impression is active view eligible; 0 when impression is not active view eligible.
query_idstruct
Unique identifier for query has multiple parts. Joins with query_id.
query_id.process_idint
The processing ID.
query_id.server_ipint
The processing server.
query_id.time_usecint
The query time in microseconds.
view_idstruct
Unique identifier for view has multiple parts.
view_id.process_idint
The processing ID.
view_id.server_ipint
The processing server.
view_id.time_usecint
The query time in microseconds.

Partner Sold - Cross Sell clicks

partner_sold_cross_sell_clicks
click_idstruct
Unique identifier for click has multiple parts. Joins with click_id.
click_id.process_idint
The processing ID.
click_id.server_ipint
The processing server.
click_id.time_usecint
The query time in microseconds.
click_typeint
The click type.
device_id_md5string
MD5-hashed device ID. Utility will be provided to hash raw device IDs to match.
is_in_rdid_projectboolean
True if this event is also in the _rdid table. Used for deduplication of events.
query_idstruct
Unique identifier for query has multiple parts. Joins with query_id.
query_id.process_idint
The processing ID.
query_id.server_ipint
The processing server.
query_id.time_usecint
The query time in microseconds.
user_idstring
User ID

Partner Sold - Cross Sell conversions

partner_sold_cross_sell_conversions
click_idstruct
Unique identifier for click has multiple parts. Joins with click_id.
click_id.process_idint
The processing ID.
click_id.server_ipint
The processing server.
click_id.time_usecint
The query time in microseconds.
conversion_idstruct
Unique identifier for conversion has multiple parts.
conversion_id.process_idint
The processing ID.
conversion_id.server_ipint
The processing server.
conversion_id.time_usecint
The query time in microseconds.
conversion_typeint
The conversion type.
device_id_md5string
MD5-hashed device ID. Utility will be provided to hash raw device IDs to match.
is_in_rdid_projectboolean
True if this event is also in the _rdid table. Used for deduplication of events.
labelstring
query_idstruct
Unique identifier for query has multiple parts.
query_id.process_idint
The processing ID.
query_id.server_ipint
The processing server.
query_id.time_usecint
The query time in microseconds.
user_idstring
User ID

Partner Sold - Cross Sell creative pixels

partner_sold_cross_sell_creative_pixels
ad_idstring
Unique ID of the ad.
pixel_urlstring

Partner Sold - Cross Sell GAM pixels

partner_sold_cross_sell_gam_pixels
ad_idstring
Unique ID of the ad.
pixel_urlstring

Partner Sold - Cross Sell impressions

partner_sold_cross_sell_impressions
ad_group_creative_idint
adgroup_idint
campaign_idint
Unique ID of the campaign.
content_urlstring
URL of the page on which ad appeared. Part of the url is removed for privacy.
creative_idint
The Creative ID in Campaign Manager UI.
customer_idint
device_heightint
Device height in pixels.
device_id_md5string
MD5-hashed device ID. Utility will be provided to hash raw device IDs to match.
device_widthint
Device width in pixels.
gfp_placementsarray
Ad Manager placement ID for this impression. Does not represent Campaign Manager placement.
is_in_rdid_projectboolean
True if this event is also in the _rdid table. Used for deduplication of events.
line_item_idint
Line item id for this impression.
locationstruct
Unique identifier for location has multiple parts.
location.countrystring
location.geo_city_idint
Code for city. Joins with city_id in adh.city table.
location.geo_metroint
Code for metrio region. Joins with metro_id in adh.metro table.
location.geo_regionstring
Region as a string (e.g. US-CA)
mobile_browser_classint
Possible values are: desktop, tablet, smart tv consoles,o r mobile. Joins with mobile_browser_class_id in adh.mobile_browser_cltable.
num_active_view_eligible_impressionint
1 when impression is active view eligible; 0 when impression is not active view eligible.
num_active_view_measurable_impressionint
1 when impression is active view measurable; 0 when impression is not active view measurable.
operating_system_version_idsarray
ID of operating system. Joins with operating_system_version_id in adh.os_version table.
order_idint
physical_screen_heightint
Device height in mm.
physical_screen_widthint
Device screen width in mm.
publisher_domainstring
Domain of page on which ad appeared.
query_idstruct
Unique identifier for query has multiple parts.
query_id.process_idint
The processing ID.
query_id.server_ipint
The processing server.
query_id.time_usecint
The query time in microseconds.
query_languagestring
Language used by user.
user_idstring
User ID

region

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

YouTube Reserve active views

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

YouTube Reserve clicks

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

YouTube Reserve conversions

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

YouTube Reserve creative

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

YouTube Reserve impressions

yt_reserve_impressions
content_urlstring
RL of the page on which ad appeared. Part of the url is removed for privacy.
creative_idint
The Creative ID in Campaign Manager UI.
device_heightint
Device height in px.
device_widthint
Device width in px.
is_in_rdid_projectboolean
True if this event is also in the _rdid table. Used for deduplication of events.
line_item_idint
Line item id for this impression.
locationstruct
Unique identifier for location has multiple parts.
location.countrystring
location.geo_city_idint
Code for city. Joins with city_id in adh.city table.
location.geo_metroint
Code for metro region. Joins with metro_id in adh.metro table.
location.geo_regionstring
Region as string, e.g. US-CA.
mobile_browser_classint
Desktop, tablet, smart tv consoles, or mobile. Joins with mobile_browser_class_id in adh.mobile_browser_class table.
num_active_view_eligible_impressionint
when impression is active view eligible; 0 when impression is not active view eligible.
num_active_view_measurable_impressionint
1 when impression is active view measurable; 0 when impression is not active view measurable.
operating_system_version_idsarray
ID of OS. Joins with operating_system_version_id in adh.os_version table.
order_idint
physical_screen_heightint
Device screen height in mm.
physical_screen_widthint
Device screen width in mm.
publisher_domainstring
Domain of page on which ad appeared.
query_idstruct
Unique identifier for query has multiple parts.
query_id.process_idint
The processing process.
query_id.server_ipint
The processing server.
query_id.time_usecint
Time in microseconds.
query_languagestring
Language used by user.
user_idstring
User ID
is_app_trafficboolean
TRUE if the event happened in a native app. FALSE if the event happened in HTML5 app or webview.
media_plan_idint
ID of the YouTube Reserve media plan.

YouTube Reserve line item

yt_reserve_lineitem
creative_idarray
Array of creative ids for this line item. Joins with creative_id in any adh.yt table.
end_timetimestamp
Time the line item stopped being served.
line_item_idint
Ad Manager line item serving.
line_item_namestring
Ad Manager line item name.
order_idint
Ad Manager Order identifier used for serving.
order_namestring
Name of the insertion order.
programmaticboolean
True if the line item was programmatic.
skippable_ad_typestring
Possible values are: "skippable", "not skippable", or "selectable".
start_timetimestamp
Time the line item started to be served.

YouTube Reserve order

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