Ads Data Hub table format - 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
Active View: Eligible Impressions
event.active_view_measurable_impressions
int
Active View: Measurable Impressions
event.active_view_viewable_impressions
int
Active View: Viewable Impressions
event.activity_count
int
Activity Quantity
event.activity_id
int
Activity ID
event.ad_id
int
Ad ID
event.advertiser_id
int
Advertiser ID
event.audience_segment_id
int
event.browser_platform_id
string
Browser/Platform ID
event.browser_version
string
Browser/Platform Version
event.campaign_id
int
Campaign ID
event.city_id
int
City ID
event.conversion_id
int
Conversion ID
event.country_code
string
Country
event.creative_version
string
Creative Version
event.dma_region_id
int
Designated Market Area (DMA) ID
event.dv360_ad_position
int
DV360 Ad Position
event.dv360_advertiser_id
int
DV360 Advertiser ID
event.dv360_adx_page_categories
string
DV360 Adx Page Categories
event.dv360_auction_id
string
DV360 Auction ID
event.dv360_browser_id
int
DV360 Browser/Platform ID
event.dv360_browser_timezone_offset_minutes
int
DV360 Browser Timezone Offset Minutes
event.dv360_city_id
int
DV360 City ID
event.dv360_country_code
string
DV360 Country Code
event.dv360_creative_id
int
DV360 Creative ID
event.dv360_device_type
int
DV360 Device Type
event.dv360_isp_id
int
DV360 ISP ID
event.dv360_language
string
DV360 Language
event.dv360_mobile_make_id
int
DV360 Mobile Make ID
event.dv360_mobile_model_id
int
DV360 Mobile Model ID
event.dv360_net_speed
int
DV360 Net Speed
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
Event Sub-Type
event.event_time
int
Event Time
event.event_type
string
Event Type
event.floodlight_config_id
int
Floodlight Configuration
event.impression_id
string
Impression ID
event.interaction_time_utc_seconds
string
Interaction Time
event.landing_page_url_id
int
Landing Page URL ID
event.operating_system_id
int
Operating System ID
event.ord_value
string
ORD Value
event.placement_id
int
Placement ID
event.platform_type_id
int
event.referrer_url
string
Referrer URL
event.rendering_id
int
Rendering ID
event.rich_media_event_counters
int
Event Counters
event.rich_media_event_id
int
Rich Media Event ID
event.rich_media_event_timers
double
Event Timers
event.rich_media_event_type_id
int
Rich Media Event Type ID
event.site_id
int
Site ID (Campaign Manager)
event.state
string
State/Region
event.zip_code
string
Zip Code
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
User ID

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
Active View: Eligible Impressions
event.active_view_measurable_impressions
int
Active View: Measurable Impressions
event.active_view_viewable_impressions
int
Active View: Viewable Impressions
event.activity_count
int
Activity Quantity
event.activity_id
int
Activity ID
event.ad_id
int
Ad ID
event.advertiser_id
int
Advertiser ID
event.audience_segment_id
int
event.browser_platform_id
string
Browser/Platform ID
event.browser_version
string
Browser/Platform Version
event.campaign_id
int
Campaign ID
event.city_id
int
City ID
event.conversion_id
int
Conversion ID
event.country_code
string
Country
event.creative_version
string
Creative Version
event.dma_region_id
int
Designated Market Area (DMA) ID
event.dv360_ad_position
int
DV360 Ad Position
event.dv360_advertiser_id
int
DV360 Advertiser ID
event.dv360_adx_page_categories
string
DV360 Adx Page Categories
event.dv360_auction_id
string
DV360 Auction ID
event.dv360_browser_id
int
DV360 Browser/Platform ID
event.dv360_browser_timezone_offset_minutes
int
DV360 Browser Timezone Offset Minutes
event.dv360_city_id
int
DV360 City ID
event.dv360_country_code
string
DV360 Country Code
event.dv360_creative_id
int
DV360 Creative ID
event.dv360_device_type
int
DV360 Device Type
event.dv360_isp_id
int
DV360 ISP ID
event.dv360_language
string
DV360 Language
event.dv360_mobile_make_id
int
DV360 Mobile Make ID
event.dv360_mobile_model_id
int
DV360 Mobile Model ID
event.dv360_net_speed
int
DV360 Net Speed
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
Event Sub-Type
event.event_time
int
Event Time
event.event_type
string
Event Type
event.floodlight_config_id
int
Floodlight Configuration
event.impression_id
string
Impression ID
event.interaction_time_utc_seconds
string
Interaction Time
event.landing_page_url_id
int
Landing Page URL ID
event.operating_system_id
int
Operating System ID
event.ord_value
string
ORD Value
event.placement_id
int
Placement ID
event.platform_type_id
int
event.referrer_url
string
Referrer URL
event.rendering_id
int
Rendering ID
event.rich_media_event_counters
int
Event Counters
event.rich_media_event_id
int
Rich Media Event ID
event.rich_media_event_timers
double
Event Timers
event.rich_media_event_type_id
int
Rich Media Event Type ID
event.site_id
int
Site ID (Campaign Manager)
event.state
string
State/Region
event.zip_code
string
Zip Code
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
User ID

Campaign Manager Data Transfer 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
Active View: Eligible Impressions
event.active_view_measurable_impressions
int
Active View: Measurable Impressions
event.active_view_viewable_impressions
int
Active View: Viewable Impressions
event.activity_count
int
Activity Quantity
event.activity_id
int
Activity ID
event.ad_id
int
Ad ID
event.advertiser_id
int
Advertiser ID
event.audience_segment_id
int
event.browser_platform_id
string
Browser/Platform ID
event.browser_version
string
Browser/Platform Version
event.campaign_id
int
Campaign ID
event.city_id
int
City ID
event.conversion_id
int
Conversion ID
event.country_code
string
Country
event.creative_version
string
Creative Version
event.dma_region_id
int
Designated Market Area (DMA) ID
event.dv360_ad_position
int
DV360 Ad Position
event.dv360_advertiser_id
int
DV360 Advertiser ID
event.dv360_adx_page_categories
string
DV360 Adx Page Categories
event.dv360_auction_id
string
DV360 Auction ID
event.dv360_browser_id
int
DV360 Browser/Platform ID
event.dv360_browser_timezone_offset_minutes
int
DV360 Browser Timezone Offset Minutes
event.dv360_city_id
int
DV360 City ID
event.dv360_country_code
string
DV360 Country Code
event.dv360_creative_id
int
DV360 Creative ID
event.dv360_device_type
int
DV360 Device Type
event.dv360_isp_id
int
DV360 ISP ID
event.dv360_language
string
DV360 Language
event.dv360_mobile_make_id
int
DV360 Mobile Make ID
event.dv360_mobile_model_id
int
DV360 Mobile Model ID
event.dv360_net_speed
int
DV360 Net Speed
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
Event Sub-Type
event.event_time
int
Event Time
event.event_type
string
Event Type
event.floodlight_config_id
int
Floodlight Configuration
event.impression_id
string
Impression ID
event.interaction_time_utc_seconds
string
Interaction Time
event.landing_page_url_id
int
Landing Page URL ID
event.operating_system_id
int
Operating System ID
event.ord_value
string
ORD Value
event.placement_id
int
Placement ID
event.platform_type_id
int
event.referrer_url
string
Referrer URL
event.rendering_id
int
Rendering ID
event.rich_media_event_counters
int
Event Counters
event.rich_media_event_id
int
Rich Media Event ID
event.rich_media_event_timers
double
Event Timers
event.rich_media_event_type_id
int
Rich Media Event Type ID
event.site_id
int
Site ID (Campaign Manager)
event.state
string
State/Region
event.zip_code
string
Zip Code
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
User ID

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 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 events

cm_dt_events
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
Active View: Eligible Impressions
event.active_view_measurable_impressions
int
Active View: Measurable Impressions
event.active_view_viewable_impressions
int
Active View: Viewable Impressions
event.activity_count
int
Activity Quantity
event.activity_id
int
Activity ID
event.ad_id
int
Ad ID
event.advertiser_id
int
Advertiser ID
event.audience_segment_id
int
event.browser_platform_id
string
Browser/Platform ID
event.browser_version
string
Browser/Platform Version
event.campaign_id
int
Campaign ID
event.city_id
int
City ID
event.conversion_id
int
Conversion ID
event.country_code
string
Country
event.creative_version
string
Creative Version
event.dma_region_id
int
Designated Market Area (DMA) ID
event.dv360_ad_position
int
DV360 Ad Position
event.dv360_advertiser_id
int
DV360 Advertiser ID
event.dv360_adx_page_categories
string
DV360 Adx Page Categories
event.dv360_auction_id
string
DV360 Auction ID
event.dv360_browser_id
int
DV360 Browser/Platform ID
event.dv360_browser_timezone_offset_minutes
int
DV360 Browser Timezone Offset Minutes
event.dv360_city_id
int
DV360 City ID
event.dv360_country_code
string
DV360 Country Code
event.dv360_creative_id
int
DV360 Creative ID
event.dv360_device_type
int
DV360 Device Type
event.dv360_isp_id
int
DV360 ISP ID
event.dv360_language
string
DV360 Language
event.dv360_mobile_make_id
int
DV360 Mobile Make ID
event.dv360_mobile_model_id
int
DV360 Mobile Model ID
event.dv360_net_speed
int
DV360 Net Speed
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
Event Sub-Type
event.event_time
int
Event Time
event.event_type
string
Event Type
event.floodlight_config_id
int
Floodlight Configuration
event.impression_id
string
Impression ID
event.interaction_time_utc_seconds
string
Interaction Time
event.landing_page_url_id
int
Landing Page URL ID
event.operating_system_id
int
Operating System ID
event.ord_value
string
ORD Value
event.placement_id
int
Placement ID
event.platform_type_id
int
event.referrer_url
string
Referrer URL
event.rendering_id
int
Rendering ID
event.rich_media_event_counters
int
Event Counters
event.rich_media_event_id
int
Rich Media Event ID
event.rich_media_event_timers
double
Event Timers
event.rich_media_event_type_id
int
Rich Media Event Type ID
event.site_id
int
Site ID (Campaign Manager)
event.state
string
State/Region
event.zip_code
string
Zip Code
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
User ID

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
Active View: Eligible Impressions
event.active_view_measurable_impressions
int
Active View: Measurable Impressions
event.active_view_viewable_impressions
int
Active View: Viewable Impressions
event.activity_count
int
Activity Quantity
event.activity_id
int
Activity ID
event.ad_id
int
Ad ID
event.advertiser_id
int
Advertiser ID
event.audience_segment_id
int
event.browser_platform_id
string
Browser/Platform ID
event.browser_version
string
Browser/Platform Version
event.campaign_id
int
Campaign ID
event.city_id
int
City ID
event.conversion_id
int
Conversion ID
event.country_code
string
Country
event.creative_version
string
Creative Version
event.dma_region_id
int
Designated Market Area (DMA) ID
event.dv360_ad_position
int
DV360 Ad Position
event.dv360_advertiser_id
int
DV360 Advertiser ID
event.dv360_adx_page_categories
string
DV360 Adx Page Categories
event.dv360_auction_id
string
DV360 Auction ID
event.dv360_browser_id
int
DV360 Browser/Platform ID
event.dv360_browser_timezone_offset_minutes
int
DV360 Browser Timezone Offset Minutes
event.dv360_city_id
int
DV360 City ID
event.dv360_country_code
string
DV360 Country Code
event.dv360_creative_id
int
DV360 Creative ID
event.dv360_device_type
int
DV360 Device Type
event.dv360_isp_id
int
DV360 ISP ID
event.dv360_language
string
DV360 Language
event.dv360_mobile_make_id
int
DV360 Mobile Make ID
event.dv360_mobile_model_id
int
DV360 Mobile Model ID
event.dv360_net_speed
int
DV360 Net Speed
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
Event Sub-Type
event.event_time
int
Event Time
event.event_type
string
Event Type
event.floodlight_config_id
int
Floodlight Configuration
event.impression_id
string
Impression ID
event.interaction_time_utc_seconds
string
Interaction Time
event.landing_page_url_id
int
Landing Page URL ID
event.operating_system_id
int
Operating System ID
event.ord_value
string
ORD Value
event.placement_id
int
Placement ID
event.platform_type_id
int
event.referrer_url
string
Referrer URL
event.rendering_id
int
Rendering ID
event.rich_media_event_counters
int
Event Counters
event.rich_media_event_id
int
Rich Media Event ID
event.rich_media_event_timers
double
Event Timers
event.rich_media_event_type_id
int
Rich Media Event Type ID
event.site_id
int
Site ID (Campaign Manager)
event.state
string
State/Region
event.zip_code
string
Zip Code
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
User ID

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
Active View: Eligible Impressions
event.active_view_measurable_impressions
int
Active View: Measurable Impressions
event.active_view_viewable_impressions
int
Active View: Viewable Impressions
event.activity_count
int
Activity Quantity
event.activity_id
int
Activity ID
event.ad_id
int
Ad ID
event.advertiser_id
int
Advertiser ID
event.audience_segment_id
int
event.browser_platform_id
string
Browser/Platform ID
event.browser_version
string
Browser/Platform Version
event.campaign_id
int
Campaign ID
event.city_id
int
City ID
event.conversion_id
int
Conversion ID
event.country_code
string
Country
event.creative_version
string
Creative Version
event.dma_region_id
int
Designated Market Area (DMA) ID
event.dv360_ad_position
int
DV360 Ad Position
event.dv360_advertiser_id
int
DV360 Advertiser ID
event.dv360_adx_page_categories
string
DV360 Adx Page Categories
event.dv360_auction_id
string
DV360 Auction ID
event.dv360_browser_id
int
DV360 Browser/Platform ID
event.dv360_browser_timezone_offset_minutes
int
DV360 Browser Timezone Offset Minutes
event.dv360_city_id
int
DV360 City ID
event.dv360_country_code
string
DV360 Country Code
event.dv360_creative_id
int
DV360 Creative ID
event.dv360_device_type
int
DV360 Device Type
event.dv360_isp_id
int
DV360 ISP ID
event.dv360_language
string
DV360 Language
event.dv360_mobile_make_id
int
DV360 Mobile Make ID
event.dv360_mobile_model_id
int
DV360 Mobile Model ID
event.dv360_net_speed
int
DV360 Net Speed
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
Event Sub-Type
event.event_time
int
Event Time
event.event_type
string
Event Type
event.floodlight_config_id
int
Floodlight Configuration
event.impression_id
string
Impression ID
event.interaction_time_utc_seconds
string
Interaction Time
event.landing_page_url_id
int
Landing Page URL ID
event.operating_system_id
int
Operating System ID
event.ord_value
string
ORD Value
event.placement_id
int
Placement ID
event.platform_type_id
int
event.referrer_url
string
Referrer URL
event.rendering_id
int
Rendering ID
event.rich_media_event_counters
int
Event Counters
event.rich_media_event_id
int
Rich Media Event ID
event.rich_media_event_timers
double
Event Timers
event.rich_media_event_type_id
int
Rich Media Event Type ID
event.site_id
int
Site ID (Campaign Manager)
event.state
string
State/Region
event.zip_code
string
Zip Code
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
User ID

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
Active View: Eligible Impressions
event.active_view_measurable_impressions
int
Active View: Measurable Impressions
event.active_view_viewable_impressions
int
Active View: Viewable Impressions
event.activity_count
int
Activity Quantity
event.activity_id
int
Activity ID
event.ad_id
int
Ad ID
event.advertiser_id
int
Advertiser ID
event.audience_segment_id
int
event.browser_platform_id
string
Browser/Platform ID
event.browser_version
string
Browser/Platform Version
event.campaign_id
int
Campaign ID
event.city_id
int
City ID
event.conversion_id
int
Conversion ID
event.country_code
string
Country
event.creative_version
string
Creative Version
event.dma_region_id
int
Designated Market Area (DMA) ID
event.dv360_ad_position
int
DV360 Ad Position
event.dv360_advertiser_id
int
DV360 Advertiser ID
event.dv360_adx_page_categories
string
DV360 Adx Page Categories
event.dv360_auction_id
string
DV360 Auction ID
event.dv360_browser_id
int
DV360 Browser/Platform ID
event.dv360_browser_timezone_offset_minutes
int
DV360 Browser Timezone Offset Minutes
event.dv360_city_id
int
DV360 City ID
event.dv360_country_code
string
DV360 Country Code
event.dv360_creative_id
int
DV360 Creative ID
event.dv360_device_type
int
DV360 Device Type
event.dv360_isp_id
int
DV360 ISP ID
event.dv360_language
string
DV360 Language
event.dv360_mobile_make_id
int
DV360 Mobile Make ID
event.dv360_mobile_model_id
int
DV360 Mobile Model ID
event.dv360_net_speed
int
DV360 Net Speed
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
Event Sub-Type
event.event_time
int
Event Time
event.event_type
string
Event Type
event.floodlight_config_id
int
Floodlight Configuration
event.impression_id
string
Impression ID
event.interaction_time_utc_seconds
string
Interaction Time
event.landing_page_url_id
int
Landing Page URL ID
event.operating_system_id
int
Operating System ID
event.ord_value
string
ORD Value
event.placement_id
int
Placement ID
event.platform_type_id
int
event.referrer_url
string
Referrer URL
event.rendering_id
int
Rendering ID
event.rich_media_event_counters
int
Event Counters
event.rich_media_event_id
int
Rich Media Event ID
event.rich_media_event_timers
double
Event Timers
event.rich_media_event_type_id
int
Rich Media Event Type ID
event.site_id
int
Site ID (Campaign Manager)
event.state
string
State/Region
event.zip_code
string
Zip Code
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
User ID

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
Active View: Eligible Impressions
event.active_view_measurable_impressions
int
Active View: Measurable Impressions
event.active_view_viewable_impressions
int
Active View: Viewable Impressions
event.activity_count
int
Activity Quantity
event.activity_id
int
Activity ID
event.ad_id
int
Ad ID
event.advertiser_id
int
Advertiser ID
event.audience_segment_id
int
event.browser_platform_id
string
Browser/Platform ID
event.browser_version
string
Browser/Platform Version
event.campaign_id
int
Campaign ID
event.city_id
int
City ID
event.conversion_id
int
Conversion ID
event.country_code
string
Country
event.creative_version
string
Creative Version
event.dma_region_id
int
Designated Market Area (DMA) ID
event.dv360_ad_position
int
DV360 Ad Position
event.dv360_advertiser_id
int
DV360 Advertiser ID
event.dv360_adx_page_categories
string
DV360 Adx Page Categories
event.dv360_auction_id
string
DV360 Auction ID
event.dv360_browser_id
int
DV360 Browser/Platform ID
event.dv360_browser_timezone_offset_minutes
int
DV360 Browser Timezone Offset Minutes
event.dv360_city_id
int
DV360 City ID
event.dv360_country_code
string
DV360 Country Code
event.dv360_creative_id
int
DV360 Creative ID
event.dv360_device_type
int
DV360 Device Type
event.dv360_isp_id
int
DV360 ISP ID
event.dv360_language
string
DV360 Language
event.dv360_mobile_make_id
int
DV360 Mobile Make ID
event.dv360_mobile_model_id
int
DV360 Mobile Model ID
event.dv360_net_speed
int
DV360 Net Speed
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
Event Sub-Type
event.event_time
int
Event Time
event.event_type
string
Event Type
event.floodlight_config_id
int
Floodlight Configuration
event.impression_id
string
Impression ID
event.interaction_time_utc_seconds
string
Interaction Time
event.landing_page_url_id
int
Landing Page URL ID
event.operating_system_id
int
Operating System ID
event.ord_value
string
ORD Value
event.placement_id
int
Placement ID
event.platform_type_id
int
event.referrer_url
string
Referrer URL
event.rendering_id
int
Rendering ID
event.rich_media_event_counters
int
Event Counters
event.rich_media_event_id
int
Rich Media Event ID
event.rich_media_event_timers
double
Event Timers
event.rich_media_event_type_id
int
Rich Media Event Type ID
event.site_id
int
Site ID (Campaign Manager)
event.state
string
State/Region
event.zip_code
string
Zip Code
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
User ID

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
Active View: Eligible Impressions
event.active_view_measurable_impressions
int
Active View: Measurable Impressions
event.active_view_viewable_impressions
int
Active View: Viewable Impressions
event.activity_count
int
Activity Quantity
event.activity_id
int
Activity ID
event.ad_id
int
Ad ID
event.advertiser_id
int
Advertiser ID
event.audience_segment_id
int
event.browser_platform_id
string
Browser/Platform ID
event.browser_version
string
Browser/Platform Version
event.campaign_id
int
Campaign ID
event.city_id
int
City ID
event.conversion_id
int
Conversion ID
event.country_code
string
Country
event.creative_version
string
Creative Version
event.dma_region_id
int
Designated Market Area (DMA) ID
event.dv360_ad_position
int
DV360 Ad Position
event.dv360_advertiser_id
int
DV360 Advertiser ID
event.dv360_adx_page_categories
string
DV360 Adx Page Categories
event.dv360_auction_id
string
DV360 Auction ID
event.dv360_browser_id
int
DV360 Browser/Platform ID
event.dv360_browser_timezone_offset_minutes
int
DV360 Browser Timezone Offset Minutes
event.dv360_city_id
int
DV360 City ID
event.dv360_country_code
string
DV360 Country Code
event.dv360_creative_id
int
DV360 Creative ID
event.dv360_device_type
int
DV360 Device Type
event.dv360_isp_id
int
DV360 ISP ID
event.dv360_language
string
DV360 Language
event.dv360_mobile_make_id
int
DV360 Mobile Make ID
event.dv360_mobile_model_id
int
DV360 Mobile Model ID
event.dv360_net_speed
int
DV360 Net Speed
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
Event Sub-Type
event.event_time
int
Event Time
event.event_type
string
Event Type
event.floodlight_config_id
int
Floodlight Configuration
event.impression_id
string
Impression ID
event.interaction_time_utc_seconds
string
Interaction Time
event.landing_page_url_id
int
Landing Page URL ID
event.operating_system_id
int
Operating System ID
event.ord_value
string
ORD Value
event.placement_id
int
Placement ID
event.platform_type_id
int
event.referrer_url
string
Referrer URL
event.rendering_id
int
Rendering ID
event.rich_media_event_counters
int
Event Counters
event.rich_media_event_id
int
Rich Media Event ID
event.rich_media_event_timers
double
Event Timers
event.rich_media_event_type_id
int
Rich Media Event Type ID
event.site_id
int
Site ID (Campaign Manager)
event.state
string
State/Region
event.zip_code
string
Zip Code
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
User ID

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
Active View: Eligible Impressions
event.active_view_measurable_impressions
int
Active View: Measurable Impressions
event.active_view_viewable_impressions
int
Active View: Viewable Impressions
event.activity_count
int
Activity Quantity
event.activity_id
int
Activity ID
event.ad_id
int
Ad ID
event.advertiser_id
int
Advertiser ID
event.audience_segment_id
int
event.browser_platform_id
string
Browser/Platform ID
event.browser_version
string
Browser/Platform Version
event.campaign_id
int
Campaign ID
event.city_id
int
City ID
event.conversion_id
int
Conversion ID
event.country_code
string
Country
event.creative_version
string
Creative Version
event.dma_region_id
int
Designated Market Area (DMA) ID
event.dv360_ad_position
int
DV360 Ad Position
event.dv360_advertiser_id
int
DV360 Advertiser ID
event.dv360_adx_page_categories
string
DV360 Adx Page Categories
event.dv360_auction_id
string
DV360 Auction ID
event.dv360_browser_id
int
DV360 Browser/Platform ID
event.dv360_browser_timezone_offset_minutes
int
DV360 Browser Timezone Offset Minutes
event.dv360_city_id
int
DV360 City ID
event.dv360_country_code
string
DV360 Country Code
event.dv360_creative_id
int
DV360 Creative ID
event.dv360_device_type
int
DV360 Device Type
event.dv360_isp_id
int
DV360 ISP ID
event.dv360_language
string
DV360 Language
event.dv360_mobile_make_id
int
DV360 Mobile Make ID
event.dv360_mobile_model_id
int
DV360 Mobile Model ID
event.dv360_net_speed
int
DV360 Net Speed
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
Event Sub-Type
event.event_time
int
Event Time
event.event_type
string
Event Type
event.floodlight_config_id
int
Floodlight Configuration
event.impression_id
string
Impression ID
event.interaction_time_utc_seconds
string
Interaction Time
event.landing_page_url_id
int
Landing Page URL ID
event.operating_system_id
int
Operating System ID
event.ord_value
string
ORD Value
event.placement_id
int
Placement ID
event.platform_type_id
int
event.referrer_url
string
Referrer URL
event.rendering_id
int
Rendering ID
event.rich_media_event_counters
int
Event Counters
event.rich_media_event_id
int
Rich Media Event ID
event.rich_media_event_timers
double
Event Timers
event.rich_media_event_type_id
int
Rich Media Event Type ID
event.site_id
int
Site ID (Campaign Manager)
event.state
string
State/Region
event.zip_code
string
Zip Code
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
User ID

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
Active View: Eligible Impressions
event.active_view_measurable_impressions
int
Active View: Measurable Impressions
event.active_view_viewable_impressions
int
Active View: Viewable Impressions
event.activity_count
int
Activity Quantity
event.activity_id
int
Activity ID
event.ad_id
int
Ad ID
event.advertiser_id
int
Advertiser ID
event.audience_segment_id
int
event.browser_platform_id
string
Browser/Platform ID
event.browser_version
string
Browser/Platform Version
event.campaign_id
int
Campaign ID
event.city_id
int
City ID
event.conversion_id
int
Conversion ID
event.country_code
string
Country
event.creative_version
string
Creative Version
event.dma_region_id
int
Designated Market Area (DMA) ID
event.dv360_ad_position
int
DV360 Ad Position
event.dv360_advertiser_id
int
DV360 Advertiser ID
event.dv360_adx_page_categories
string
DV360 Adx Page Categories
event.dv360_auction_id
string
DV360 Auction ID
event.dv360_browser_id
int
DV360 Browser/Platform ID
event.dv360_browser_timezone_offset_minutes
int
DV360 Browser Timezone Offset Minutes
event.dv360_city_id
int
DV360 City ID
event.dv360_country_code
string
DV360 Country Code
event.dv360_creative_id
int
DV360 Creative ID
event.dv360_device_type
int
DV360 Device Type
event.dv360_isp_id
int
DV360 ISP ID
event.dv360_language
string
DV360 Language
event.dv360_mobile_make_id
int
DV360 Mobile Make ID
event.dv360_mobile_model_id
int
DV360 Mobile Model ID
event.dv360_net_speed
int
DV360 Net Speed
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
Event Sub-Type
event.event_time
int
Event Time
event.event_type
string
Event Type
event.floodlight_config_id
int
Floodlight Configuration
event.impression_id
string
Impression ID
event.interaction_time_utc_seconds
string
Interaction Time
event.landing_page_url_id
int
Landing Page URL ID
event.operating_system_id
int
Operating System ID
event.ord_value
string
ORD Value
event.placement_id
int
Placement ID
event.platform_type_id
int
event.referrer_url
string
Referrer URL
event.rendering_id
int
Rendering ID
event.rich_media_event_counters
int
Event Counters
event.rich_media_event_id
int
Rich Media Event ID
event.rich_media_event_timers
double
Event Timers
event.rich_media_event_type_id
int
Rich Media Event Type ID
event.site_id
int
Site ID (Campaign Manager)
event.state
string
State/Region
event.zip_code
string
Zip Code
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
User ID

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.

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.

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_TRUE_VIEW_IN_DISPLAY, VIDEO_BUMPVIDEO_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 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.
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

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.yt 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.yt 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.yt 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.yt table.
query_id.process_id
int
The processing process.
query_id.server_ip
int
The processing server.
query_id.time_usec
int
Time in microseconds.
user_id
string
User ID

Google Ads conversions audience

google_ads_conversions_audience
click_id
struct
Unique identifier for click has multiple parts. Joins with click_id in any adh.yt 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.yt 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.

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.
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.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.

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.

Google Ads view through conversions

google_ads_view_through_conversions
click_id
struct
Unique identifier for click has multiple parts. Joins with click_id in any adh.yt 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.
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. 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.
user_id
string
User ID

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
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 pixels

partner_sold_cross_sell_creative_pixels
ad_id
string
Unique ID of the ad.
pixel_url
string

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
ad_group_creative_id
int
adgroup_id
int
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.
creative_id
int
The Creative ID in Campaign Manager UI.
customer_id
int
device_height
int
Device height in pixels.
device_id_md5
string
MD5-hashed device ID. Utility will be provided to hash raw device IDs to match.
device_width
int
Device width in pixels.
gfp_placements
array
Ad Manager placement ID for this impression. Does not represent Campaign Manager placement.
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 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
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_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
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

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.

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

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

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 Creative ID in Campaign Manager UI.
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 impressions

yt_reserve_impressions
content_url
string
RL of the page on which ad appeared. Part of the url is removed for privacy.
creative_id
int
The Creative ID in Campaign Manager UI.
device_height
int
Device height in px.
device_width
int
Device width in px.
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
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.