.

Ads Data Hub table format – Vendors

Vendors don't have access to fields relating to audience segmentation, custom input, cost, transactions, or conversions.

Map Data Transfer fields to Ads Data Hub

Use these tables to map Data Transfer file fields to Ads Data Hub fields

Campaign Manager Data Transfer

Campaign Manager Data Transfer File / ADH table availability:

  • Activities / adh.cm_dt_activities
  • Clicks / adh.cm_dt_clicks
  • Impressions / adh.cm_dt_impressions
  • Rich Media / adh.cm_dt_rich_media
Ads Data Hub to Data Transfer mapping (Campaign Manager fields)
user_id
(is device_id_md5 in _rdid table)
Tables: activities, clicks, impressions, rich-media
User ID
string
event.event_time
Tables: activities, clicks, impressions, rich-media
Event Time
int
event.advertiser_id
Tables: activities, clicks, impressions, rich-media
Advertiser ID
int
event.campaign_id
Tables: activities, clicks, impressions, rich-media
Campaign ID
int
event.ad_id
Tables: activities, clicks, impressions, rich-media
Ad ID
int
event.rendering_id
Tables: activities, clicks, impressions, rich-media
Rendering ID
int
event.creative_version
Tables: activities, clicks, impressions, rich-media
Creative Version
string
event.site_id
Tables: activities, clicks, impressions, rich-media
Site ID (Campaign Manager)
int
event.country_code
Tables: activities, clicks, impressions, rich-media
Country
string
event.state
Tables: activities, clicks, impressions, rich-media
State/Region
string
event.browser_platform_id
Tables: activities, clicks, impressions, rich-media
Browser/Platform ID
string
event.browser_version
Tables: activities, clicks, impressions, rich-media
Browser/Platform Version
string
event.dma_region_id
Tables: clicks, impressions
Designated Market Area (DMA) ID
int
event.city_id
Tables: clicks, impressions
City ID
int
event.zip_code
Tables: clicks, impressions
Zip Code
string
event.event_type
Tables: activities, clicks, impressions
Event Type
string
event.event_sub_type
Tables: activities, clicks, impressions
Event Sub-Type
string
event.placement_id
Tables: activities, clicks, impressions, rich-media
Placement ID
int
event.operating_system_id
Tables: activities, clicks, impressions, rich-media
Operating System ID
int
event.activity_id
Table: activities
Activity ID
int
event.ord_value
Table: activities
ORD Value
string
event.conversion_id
Table: activities
Conversion ID
int
event.floodlight_config_id
Tables: activities, clicks, impressions, rich-media
Floodlight Configuration
int
event.interaction_time_utc_seconds
Table: activities
Interaction Time
int
event.rich_media_event_id
Table: rich-media
Rich Media Event ID
int
event.rich_media_event_type_id
Table: rich-media
Rich Media Event Type ID
int
event.impression_id
Tables: clicks, impressions, rich-media
Impression ID
string
event.activity_count
Tables: activities, clicks, impressions
Activity Quantity
int
event.activity_revenue
Tables: activities, clicks, impressions
Activity Revenue
double
event.active_view_eligible_impressions
Table: impressions
Active View: Eligible Impressions
int
event.active_view_viewable_impressions
Table: impressions
Active View: Viewable Impressions
int
event.rich_media_event_counters
Table: rich-media
Event Counters
int
event.rich_media_event_timers
Table: rich-media
Event Timers
int
event.active_view_measurable_impressions
Table: impressions
Active View: Measurable Impressions
int
event.landing_page_url_id
Tables: activities, clicks, impressions
Landing Page URL ID
int
event.activity_sub_type
Tables: activities, clicks, impressions
Activity Sub Type
string
event.activity_type
Tables: activities, clicks, impressions
Activity Type
string
network_id
Tables: activities, clicks, impressions, rich-media
int
The network ID
is_in_rdid_project
Tables: activities, clicks, impressions, rich-media
boolean
True if this event is also in the _rdid table. Used for deduplication of events.
event.audience_segment_id
Tables: activities, clicks, impressions, rich media
int
event.dv360_auction_id
Tables: activities, clicks, impressions
DV360 Auction ID
string
event.dv360_request_time
Tables: activities, clicks, impressions
DV360 Request Time
int
event.dv360_advertiser_id
Tables: activities, clicks, impressions
DV360 Advertiser ID
int
event.dv360_insertion_order_id
Tables: activities, clicks, impressions
DV360 Insertion Order ID
int
event.dv360_line_item_id
Tables: activities, clicks, impressions
DV360 Line Item ID
int
event.dv360_creative_id
Tables: activities, clicks, impressions
DV360 Creative ID
int
event.dv360_language
Tables: activities, clicks, impressions
DV360 Language
string
event.dv360_adx_page_categories
Tables: activities, clicks, impressions
DV360 Adx Page Categories
string
event.dv360_ad_position
Tables: activities, clicks, impressions
DV360 Ad Position
int
event.dv360_country_code
Tables: activities, clicks, impressions
DV360 Country
string
event.dv360_zip_postal_code
Tables: activities, clicks, impressions
DV360 Postal Code
string
event.dv360_browser_timezone_offset_minutes
Tables: activities, clicks, impressions
DV360 Browser Timezone Offset Minutes
int
event.dv360_net_speed
Tables: activities, clicks, impressions
DV360 Net Speed
int
event.dv360_isp_id
Tables: activities, clicks, impressions
DV360 ISP ID
int
event.dv360_device_type
Tables: activities, clicks, impressions
DV360 Device Type
int
event.dv360_mobile_model_id
Tables: activities, clicks, impressions
DV360 Mobile Model ID
int
event.dv360_state_region_id
Tables: activities, clicks, impressions
DV360 Region ID
int
event.dv360_city_id
Tables: activities, clicks, impressions
DV360 City ID
string
event.dv360_browser_id
Tables: activities, clicks, impressions
DV360 Browser/Platform ID
int
event.dv360_mobile_make_id
Tables: activities, clicks, impressions
DV360 Mobile Make ID
int
event.dv360_country_code
Tables: activities, clicks, impressions
DV360 Country Code
string
event.dv360_view_state
Tables: activities, clicks, impressions
DV360 View State
string
event.dv360_zip_postal_code
Tables: activities, clicks, impressions
DV360 ZIP/Postal Code
string
event.dv360_campaign_id
Tables: activities, clicks, impressions
DV360 Campaign ID
string

Display & Video 360 Data Transfer

Display & Video 360 Data Transfer File / ADH table availability:

  • Activities / adh.dv360_dt_activities
  • Clicks / adh.dv360_dt_clicks
  • Impressions / adh.dv360_dt_impressions
Ads Data Hub to Data Transfer mapping (Display & Video 360 / DV360 fields)
user_id
(is device_id_md5 in _rdid table)
Tables: activities, clicks, impressions
User ID
string
event.event_time
Tables: activities, clicks, impressions
Event Time
int
event.event_type
Tables: activities, clicks, impressions
Event Type
string
event.event_sub_type
Tables: activities, clicks, impressions
Event Sub-Type
string
event.active_view_eligible_impressions
Table: impressions
Active View: Eligible Impressions
int
event.active_view_viewable_impressions
Table: impressions
Active View: Viewable Impressions
int
event.active_view_measurable_impressions
Table: impressions
Active View: Measurable Impressions
int
event.dv360_auction_id
Tables: activities, clicks, impressions
DV360 Auction ID
string
event.dv360_request_time
Tables: activities, clicks, impressions
DV360 Request Time
int
event.dv360_advertiser_id
Tables: activities, clicks, impressions
DV360 Advertiser ID
int
event.dv360_insertion_order_id
Tables: activities, clicks, impressions
DV360 Insertion Order ID
int
event.dv360_line_item_id
Tables: activities, clicks, impressions
DV360 Line Item ID
int
event.dv360_creative_id
Tables: activities, clicks, impressions
DV360 Creative ID
int
event.dv360_language
Tables: activities, clicks, impressions
DV360 Language
string
event.dv360_adx_page_categories
Tables: activities, clicks, impressions
DV360 Adx Page Categories
string
event.dv360_ad_position
Tables: activities, clicks, impressions
DV360 Ad Position
int
event.dv360_country_code
Tables: activities, clicks, impressions
DV360 Country
string
event.dv360_zip_postal_code
Tables: activities, clicks, impressions
DV360 Postal Code
string
event.dv360_browser_timezone_offset_minutes
Tables: activities, clicks, impressions
DV360 Browser Timezone Offset Minutes
int
event.dv360_net_speed
Tables: activities, clicks, impressions
DV360 Net Speed
int
event.dv360_isp_id
Tables: activities, clicks, impressions
DV360 ISP ID
int
event.dv360_device_type
Tables: activities, clicks, impressions
DV360 Device Type
int
event.dv360_mobile_model_id
Tables: activities, clicks, impressions
DV360 Mobile Model ID
int
event.dv360_state_region_id
Tables: activities, clicks, impressions
DV360 Region ID
int
event.dv360_city_id
Tables: activities, clicks, impressions
DV360 City ID
string
event.dv360_browser_id
Tables: activities, clicks, impressions
DV360 Browser/Platform ID
int
event.dv360_mobile_make_id
Tables: activities, clicks, impressions
DV360 Mobile Make ID
int
event.dv360_country_code
Tables: activities, clicks, impressions
DV360 Country Code
string
event.dv360_view_state
Tables: activities, clicks, impressions
DV360 View State
string
event.dv360_zip_postal_code
Tables: activities, clicks, impressions
DV360 ZIP/Postal Code
string
event.dv360_campaign_id
Tables: activities, clicks, impressions
DV360 Campaign ID
string
network_id
Tables: activities, clicks, impressions
int
The network ID.
is_in_rdid_project
Tables: activities, clicks, impressions
boolean
True if this event is also in the _rdid table. Used for deduplication of events.

Campaign Manager metadata (DT match tables)

Account info

adh.cm_dt_account_info
account_id
INTEGER
Unique ID of the account.
timezone_name
STRING
Timezone of the account.

Activity category

adh.cm_dt_activity_category
activity
STRING
User defined category report interface name for floodlight tags.
activity_group_id
INTEGER
The ID associated with an activity group and included in the type= parameter of Floodlight tags.
activity_id
activity
INTEGER
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
impression | click | rich media | activity
INTEGER
Unique ID of the advertiser.
floodlight_config_id
activity
INTEGER
Unique ID of the floodlight configuration.
tag_counting_method_id
INTEGER
User defined type - describing Floodlight tag type. Key: 1 - standard, 2 - unique, 3 - custom, 4 - integer of transactions - for sales tags only, 5 - integer of items sold - for sales tags only.
account_id
INTEGER
Unique ID of the account.

Activity type

adh.cm_dt_activity_type
activity_group
STRING
Name for this activity group.
activity_group_id
INTEGER
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
impression | click | rich media | activity
INTEGER
Unique ID of the advertiser.
floodlight_config_id
activity
INTEGER
Unique ID of the floodlight configuration.
account_id
INTEGER
Unique ID of the account.

Ad

adh.cm_dt_ad
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
impression | click | rich media | activity
INTEGER
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, Paid Inclusion, Product feeds, Natural Search, Default, Interstitial Default, InStream Default Ad, Brand-neutral".
ad_type_id
INTEGER
Unique ID of the ad type.
advertiser_id
impression | click | rich media | activity
INTEGER
Unique ID of the advertiser.
campaign_id
impression | click | rich media | activity
INTEGER
Unique ID of the campaign.
creative_size
STRING
The creative size in pixels, width x height. Empty size represented by "0X0".
floodlight_config_id
activity
INTEGER
Unique ID of the floodlight configuration.
account_id
INTEGER
Unique ID of the account.

Ad placement assignments

adh.cm_dt_ad_placement_assignment
ad_id
impression | click | rich media | activity
INTEGER
Unique ID of the ad.
advertiser_id
impression | click | rich media | activity
INTEGER
Unique ID of the advertiser.
site_placement_id
impression | click | rich media | activity
INTEGER
Unique ID of the placement.
floodlight_config_id
activity
INTEGER
Unique ID of the floodlight configuration.
account_id
INTEGER
Unique ID of the account.

Advertiser

adh.cm_dt_advertiser
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
INTEGER
Group ID to which this advertiser belongs. An advertiser may be a member of only one group.
advertiser_id
impression | click | rich media | activity
INTEGER
Unique ID of the advertiser.
floodlight_config_id
activity
INTEGER
Unique ID of the floodlight configuration.
account_id
INTEGER
Unique ID of the account.

Asset

adh.cm_dt_asset
asset
STRING
Name of the creative asset.
asset_category
STRING
Category of the creative asset.
asset_id
INTEGER
Unique ID of the asset.
asset_orientation
STRING
Screen orientation of the asset.
account_id
INTEGER
Unique ID of the account.

Audience Segments

adh.cm_dt_audience_segments
account_id
INTEGER
Unique ID of the account.
advertiser_id
INTEGER
Unique ID of the advertiser.
audience_segment
STRING
Name of the audience segment.
audience_segment_id
INTEGER
Unique ID of the audience segment.
floodlight_config_id
INTEGER
Unique ID of the floodlight configuration.

Browser

adh.cm_dt_browser
browser
STRING
Browser / platform name.
browser_enum
impression | click | rich media | activity
INTEGER
Unique ID of browser / platform.

Campaign

adh.cm_dt_campaign
advertiser_id
impression | click | rich media | activity
INTEGER
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
INTEGER
Campaign end date as YYYYMMDD.
campaign_id
impression | click | rich media | activity
INTEGER
Unique ID of the campaign.
campaign_start_date
INTEGER
Campaign start date as YYYYMMDD.
floodlight_config_id
activity
INTEGER
Unique ID of the floodlight configuration
account_id
INTEGER
Unique ID of the account.

City

adh.cm_dt_city
city
STRING
The city name, in English.
city_id
impression | click
INTEGER
Unique ID of the city.

Creative

adh.cm_dt_creative
advertiser_id
impression | click | rich media | activity
INTEGER
Unique ID of the advertiser.
creative
STRING
Creative Name as entered into the Campaign Manager interface.
creative_id
INTEGER
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
INTEGER
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_version
INTEGER
Used for change management to capture different versions, such as when traffickers swap creatives.
rendering_id
impression | click | rich media | activity
INTEGER
Unique ID of the creative for Data Transfer. This isn't the creative ID in the Campaign Manager UI.
rendering_type
STRING
Image, HTML, Redirect, etc.
rendering_type_id
INTEGER
Id of the creative type.
floodlight_config_id
activity
INTEGER
Unique ID of the floodlight configuration.
account_id
INTEGER
Unique ID of the account.

Creative ad assignment

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

Custom creative field

adh.cm_dt_custom_creative_field
advertiser_id
impression | click | rich media | activity
INTEGER
Unique ID of the advertiser.
creative_custom_field_id
INTEGER
ID of the user defined creative field name.
creative_custom_field_name
STRING
User defined name associated to a particular custom creative field.
creative_custom_field_number
INTEGER
Slot ID assigned to this custom creative field (typically IDs from 1-20).
creative_custom_field_value
STRING
User defined value as available option to named field.
creative_custom_field_value_id
INTEGER
ID of the user defined creative value.
creative_id
INTEGER
The Creative ID in Campaign Manager UI.
floodlight_config_id
activity
INTEGER
Unique ID of the floodlight configuration
account_id
INTEGER
Unique ID of the account.

Custom floodlight variable

adh.cm_dt_custom_floodlight_variable
advertiser_id
impression | click | rich media | activity
INTEGER
Unique ID of the advertiser.
floodlight_config_id
activity
INTEGER
Unique ID of the floodlight configuration.
floodlight_variable_id
activity
INTEGER
Unique ID of the floodlight variable.
floodlight_variable_name
STRING
User defined name of the custom floodlight variable.
account_id
INTEGER
Unique ID of the account.

Custom rich media

adh.cm_dt_custom_rich_media
advertiser_id
impression | click | rich media | activity
INTEGER
Unique ID of the advertiser
rich_media_event_name
STRING
Name of the rich media event.
rich_media_event_id
INTEGER
ID of the rich media event.
rich_media_event_type_id
rich media
INTEGER
ID of the rich media event type.
rich_media_event_type
STRING
Possible values are: "Timer, Exit, Counter"
floodlight_config_id
activity
INTEGER
Unique ID of the floodlight configuration
account_id
INTEGER
Unique ID of the account

Designated market area

adh.cm_dt_designated_market_area
dma
STRING
DMA text name, in English.
dma_id
impression | click
INTEGER
Unique ID of the DMA.

Keyword value

adh.cm_dt_keyword_value
ad_id
impression | click | rich media | activity
INTEGER
Unique ID of the ad.
advertiser_id
impression | click | rich media | activity
INTEGER
Unique ID of the advertiser.
keyword
STRING
Targeted key/value pair.
floodlight_config_id
activity
INTEGER
Unique ID of the floodlight configuration.
account_id
INTEGER
Unique ID of the account.

Landing page URL

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

Operating system

adh.cm_dt_operating_system
os
STRING
Operating system name.
operating_system_id
impression | click | rich media | activity
INTEGER
Unique ID of OS just for Data Transfer.

Paid search

adh.cm_dt_paid_search
ad_id
impression | click | rich media | activity
INTEGER
Unique ID of the ad.
advertiser_id
impression | click | rich media | activity
INTEGER
Unique ID of the advertiser.
campaign_id
impression | click | rich media | activity
INTEGER
Unique ID of the campaign.
paid_search_ad_group
STRING
User defined keyword group.
paid_search_ad_group_id
INTEGER
Unique ID of the keyword group.
paid_search_ad_id
INTEGER
Unique ID associated with a Search Ads 360 ad.
paid_search_bid_strategy
STRING
User defined keyword bid strategy. Returns a value of "(not set)" if empty.
paid_search_bid_strategy_id
INTEGER
ID of the keyword bid strategy.
paid_search_campaign
STRING
User defined name of campaign as entered into Search Ads 360.
paid_search_campaign_id
INTEGER
ID of the Search Ads 360 campaign.
paid_search_landing_page_url
STRING
User defined landing page URL as entered into Search Ads 360.
paid_search_legacy_keyword_id
INTEGER
Unique ID from Search Ads 360. Uses the "short" format in which the leading 43* is removed.
paid_search_keyword
STRING
User defined keyword value as entered into Search Ads 360.
paid_search_keyword_id
INTEGER
Unique ID from Search Ads 360. Uses the “long” format, a 17 digit number starting with 43*.
paid_search_match_type
STRING
User selected, engine defined, keyword selection match type.
floodlight_config_id
activity
INTEGER
Unique ID of the floodlight configuration.

Placement

adh.cm_dt_placement
activity_id
INTEGER
Unique ID of the Floodlight activity.
advertiser_id
impression | click | rich media | activity
INTEGER
Unique ID of the advertiser.
campaign_id
impression | click | rich media | activity
INTEGER
Unique ID of the campaign.
content_category
STRING
User defined content category.
content_category_id
INTEGER
ID of content category.
flighting_activated
BOOLEAN
Indicates whether this is a flighted (billing) placement.
placement_cap_cost_option
INTEGER
User entered cost capping amount.
placement_end_date
INTEGER
Placement end date as YYYYMMDD.
package_group_id
INTEGER
Page-ID of the parent placement if this placement is a child placement type.
package_group_type
STRING
The type of object. This might be: Placement, Package, or Roadblock.
package_group_type_id
INTEGER
The ID of the object type.
placement_rate_type
STRING
Possible values are: "Impressions, Clicks, CPM, CPC, CPA, Flat Rate - Impressions, Flat Rate - Clicks".
placement_start_date
INTEGER
Placement start date as YYYYMMDD.
placement_strategy
STRING
User defined placement strategy.
placement_strategy_id
INTEGER
ID of the placement strategy.
site_id
impression | click | rich media | activity
INTEGER
Unique ID of the site.
site_placement
STRING
User defined name of placement.
site_placement_id
impression | click | rich media | activity
INTEGER
Unique ID of the placement.
site_placement_keyname
STRING
User defined site key as expressed in the Campaign Manager ad tag.
floodlight_config_id
activity
INTEGER
Unique ID of the floodlight configuration.
account_id
INTEGER
Unique ID of the account.

Placement cost

adh.cm_dt_placement_cost
advertiser_id
impression | click | rich media | activity
INTEGER
Unique ID of the advertiser.
placement_comments
STRING
User entered placement pricing comments.
placement_end_date
INTEGER
End date of the flight in 'YYYYMMDD' format.
placement_rate
INTEGER
Purchased rate expressed in nanos of the network's currency. 1 nano = 1 billionth. 1 nano USD = $0.000000001.
placement_start_date
INTEGER
Start date of the flight in 'YYYYMMDD' format.
placement_total_booked_units
INTEGER
The number of purchased units.
site_placement_id
impression | click | rich media | activity
INTEGER
Unique ID of the placement.
floodlight_config_id
activity
INTEGER
Unique ID of the floodlight configuration.
account_id
INTEGER
Unique ID of the account.

Site

adh.cm_dt_site
site
STRING
The name of the site.
site_directory
STRING
Global unique name for this site.
site_directory_id
INTEGER
Global unique ID for this site.
site_id
impression | click | rich media | activity
INTEGER
Unique ID of the site.
account_id
INTEGER
Unique ID of the account.

State

adh.cm_dt_state
state
STRING
Abbreviated state/province name.
state_name
STRING
State/province name, in English.

Display & Video 360 metadata

Some Display & Video 360 metadata not represented below can be retrieved from public tables in entity read files. To use in queries, entity read file data will need to be converted to a CSV or newline-delimited JSON file and uploaded into an ADH accesible BigQuery data set. Learn more about entity read files.

Advertiser

adh.dv360_dt_advertiser
dv360_advertiser_id
Tables: activities, clicks, impressions
INTEGER
Unique ID of the advertiser.
dv360_advertiser
String
Name of the advertiser.
dv360_partner_id
Tables: activities, clicks, impressions
INTEGER
Unique ID of the partner.

Campaign

adh.dv360_dt_campaign
dv360_campaign_id
Tables: activities, clicks, impressions
INTEGER
Unique ID of the campaign.
dv360_campaign
STRING
Name of the campaign
dv360_advertiser_id
Tables: activities, clicks, impressions
INTEGER
Unique ID of the advertiser.
dv360_partner_id
Tables: activities, clicks, impressions
INTEGER
Unique ID of the partner.

Insertion order

adh.dv360_dt_insertion_order
dv360_insertion_order_id
Tables: activities, clicks, impressions
INTEGER
Unique ID of the insertion order.
dv360_insertion_order
STRING
Name of the insertion order.
dv360_campaign_id
Tables: activities, clicks, impressions
INTEGER
Unique ID of the campaign
dv360_advertiser_id
Tables: activities, clicks, impressions
INTEGER
Unique ID of the advertiser.
dv360_partner_id
Tables: activities, clicks, impressions
INTEGER
Unique ID of the partner.

Line item

adh.dv360_dt_line_item
dv360_line_item_id
Tables: activities, clicks, impressions
INTEGER
Unique ID of the line item.
dv360_line_item
STRING
Name of the line item.
dv360_insertion_order_id
Tables: activities, clicks, impressions
INTEGER
Unique ID of the insertion order.
dv360_campaign_id
Tables: activities, clicks, impressions
INTEGER
Unique ID of the campaign.
dv360_advertiser_id
Tables: activities, clicks, impressions
INTEGER
Unique ID of the advertiser.
dv360_partner_id
Tables: activities, clicks, impressions
INTEGER
Unique ID of the partner.

Google Ads + YouTube TrueView

This data grouping has three tables: impression, click, and conversion. int, repeated data type means there can be more than one value per row for that field. See Big Query reference for details.

Impressions

adh.google_ads_impressions
query_id
Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
query_id.time_usec
int
The query time in microseconds.
query_id.server_ip
int
The processing server.
query_id.process_id
int
The processing ID.
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.
customer_id int
ID of Google Ads customer.Joins with customer_id in any adh.google_ads table.
campaign_id int
ID of Google Ads campaign. Joins with campaign_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.
line_item_id
(Deprecated)
int
ID of Google Ads line item.
output_language
(Deprecated, use query_language)
string
The output language.
targeting_type
(Deprecated)
int
The targeting type used.
publisher_domain string
Domain of the page on which ad appeared.
content_url string
URL of the page on which ad appeared. Part of the url is removed for privacy.
location
Unique identifier for location has multiple parts:
location.geo_region
string
Region as string e.g. US-CA.
location.geo_metro
int
Code for metro region. Joins with metro_id in adh.metro table.
location.geo_city_id
int
Code for city. Joins with city_id in adh.city table.
user_id
(is device_id_md5 in _rdid table)
string
Raw user ID.
is_mobile_id
(Deprecated, use is_in_rdid_project)
boolean
True if the impression came from a mobile app.
device_id_md5
(Deprecated, use _rdid table)
string
MD5-hashed device ID; a utility may be provided to hash raw device IDs to match.
query_language string
Language used by user.
mobile_browser_class int
Type of browser: desktop, tablet, smart tv consoles, or mobile. Joins with mobile_browser_class_id in adh.mobile_browser_class table.
operating_system_version_ids int, repeated
ID of OS. Joins with operating_system_version_id in adh.os_version table.
browser_ids
(Deprecated)
int, repeated
ID of browser. Joins with browser_id in adh.browser table.
user_bandwidth
(Deprecated)
int
Internet bandwidth of user viewing ad.
is_gfp
(Deprecated)
boolean
True if the ad was served from Google Ad Manager.
device_height int
Device height in px.
device_width int
Device width in px.
physical_screen_height int
Device screen height in mm.
physical_screen_width int
Device screen width in mm.
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.
is_in_rdid_project
boolean
True if this event is also in the _rdid table. Used for deduplication of events.

Clicks

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

Google Ads: Viewability

Views

The views table can be used for delayed impressions or to count raw active views.

adh.google_ads_active_views
query_id
Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
query_id.time_usec
int
Time in microseconds.
query_id.server_ip
int
The processing server.
query_id.process_id
int
The processing process.
view_id
Unique identifier for query has multiple parts:
view_id.time_usec
int
Time in microseconds.
view_id.server_ip
int
The processing server.
view_id.process_id
int
The processing process.
view_type
string
Type of view (delayed or ActiveView).
num_active_view_viewable_impression

int
1 when impression is active view viewable; 0 when impression is not active view viewable.

YouTube

YouTube Reserve Impressions

adh.yt_reserve_impressions
query_id
Unique identifier for query has multiple parts. Joins with query_id in any adh.yt table.
query_id.time_usec
int
Time in microseconds.
query_id.server_ip
int
The processing server.
query_id.process_id
int
The processing process.
campaign_id
(Deprecated, use order_id)
int
ID of YouTube campaign.
publisher_domain string
Domain of page on which ad appeared.
content_url string
URL of the page on which ad appeared. Part of the url is removed for privacy.
location
Unique identifier for location has multiple parts.
location.geo_region
string
Region as string, e.g. US-CA.
location.geo_metro
int
Code for metro region. Joins with metro_id in adh.metro table.
location.geo_city_id
int
Code for city. Joins with city_id in adh.city table.
user_id
(is device_id_md5 in _rdid table)
string
Raw user ID.
is_mobile_id
(Deprecated, use is_in_rdid_project)
boolean
True if the impression came from mobile app.
device_id_md5
(Deprecated, use _rdid table)
string
MD5-hashed device ID. Utility will be provided to hash raw device IDs to match.
query_language string
Language used by user.
mobile_browser_class int
Desktop, tablet, smart tv consoles, or mobile. Joins with mobile_browser_class_id in adh.mobile_browser_class table.
operating_system_version_ids int, repeated
ID of OS. Joins with operating_system_version_id in adh.os_version table.
browser_ids
(Deprecated)
int, repeated
ID of browser. Joins with browser_id in adh.browser table.
user_bandwidth
(Deprecated)
int
Bandwidth of user viewing ad.
is_gfp
(Deprecated)
boolean
True if the ad was served from Google Ad Manager.
device_height int
Device height in px.
device_width int
Device width in px.
physical_screen_height int
Device screen height in mm.
physical_screen_width int
Device screen width in mm.
line_item_id int
Line item id for this impression.
creative_id int
Joins with creative_id in any adh.yt table.
gfp_placements int
Ad Manager placement ID for this impression. Does not represent Campaign Manager placement.
targeting_type
(Deprecated)
int
Type of targeting used, AdSense or reservation.
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.
is_in_rdid_project
boolean
True if this event is also in the _rdid table. Used for deduplication of events.

YouTube Reserve Clicks

adh.yt_reserve_clicks
query_id
Unique identifier for query has multiple parts. Joins with query_id in any adh.yt table
query_id.time_usec
int
Time in microseconds.
query_id.server_ip
int
The processing server.
query_id.process_id
int
The processing process.
click_id
Unique identifier for click has multiple parts. Joins with click_id in any adh.yt table.
click_id.time_usec
int
Time in microseconds.
click_id.server_ip
int
The processing server.
click_id.process_id
int
The processing process.
click_type int
The click type.
user_id
(is device_id_md5 in _rdid table)
string
Raw user ID.
is_in_rdid_project
boolean
True if this event is also in the _rdid table. Used for deduplication of events.

YouTube Reserve Views

adh.yt_reserve_views (Deprecated)
query_id
(Deprecated)
Unique identifier for query has multiple parts. Joins with query_id in any adh.yt table.
query_id.time_usec
int
Time in microseconds.
query_id.server_ip
int
The processing server.
query_id.process_id
int
The processing process.
view_id
(Deprecated)
Unique identifier for query has multiple parts:
view_id.time_usec
int
Time in microseconds.
view_id.server_ip
int
The processing server.
view_id.process_id
int
The processing process.
view_type
(Deprecated)
string
Type of view (delayed or ActiveView).
is_gfp
(Deprecated)
boolean
True if the ad was served from GFP.
user_id
(Deprecated)
string
Raw user ID.
is_in_rdid_project
(Deprecated)
boolean
True if this event is also in the _rdid table. Used for deduplication of events.

YouTube Reserve ActiveViews

adh.yt_reserve_active_views
query_id
Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
query_id.time_usec
int
Time in microseconds.
query_id.server_ip
int
The processing server.
query_id.process_id
int
The processing process.
view_id
Unique identifier for query has multiple parts:
view_id.time_usec
int
Time in microseconds.
view_id.server_ip
int
The processing server.
view_id.process_id
int
The processing process.
view_type
string
Type of view (delayed or ActiveView).
num_active_view_viewable_impression

int
1 when impression is active view viewable; 0 when impression is not active view viewable.

YouTube metadata and constants

These tables map the IDs in the YouTube tables to descriptive strings and/or names. The IDs in the YouTube tables are foreign keys to the respective table.

YouTube reserve creative

adh.yt_reserve_creative
creative_id int
Joins with creative_id in any adh.yt table.
creative_name string
Name of the creative.
creative_type string
The type of creative.
creative_format_type string
Some formats map directly to a type. Other types have multiple formats like: html, image, video.
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 line items.
is_masthead boolean
True if this is a masthead creative.
cm_beacons
Multipart identifier for Campaign Manager tracking pixel for ad.
placement_key
string
Full string identifying Campaign Manager placement of pixel.
site_placement_id
int
Unique ID for Campaign Manager placement of pixel.
site_id
int
ID for Campaign Manager site of pixel.
network
int
ID for Campaign Manager campaign of pixel.
advertiser_id
int
ID for Campaign Manager advertiser of pixel.
campaign_id
int
ID for the campaign.
content_url_data
Multipart record for content URL.
url_type
string
The type of URL.
index
int
Index of content URL.
video_message
Multipart identifier for video data.
video_ad_duration
int
Duration of the video in milliseconds.
youtube_video_id
string
Video id string representation as it appears on YouTube watch url.
youtube_channel_id
string
Id of the channel that provides this video.

Google Ads Metadata and constants

These tables map the IDs in the Google Ads tables to descriptive strings and/or names. The IDs in the Google Ads tables are foreign keys to the respective table.

Google Ads customer

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

Google Ads campaign

adh.google_ads_campaign
customer_id int
Joins with customer_id in any adh.google_ads table.
campaign_id int
Joins with campaign_id in any adh.google_ads table.
campaign_name string
Campaign name.
campaign_status int
Campaign status. 3 = ACTIVE. 5 = PAUSED. 7 = DELETED.
advertising_channel_type string
Advertising channel type. SEARCH, DISPLAY, VIDEO, OTHER
start_time int
Timestamp when the campaign begins in milliseconds.
end_time int
Timestamp when the campaign ends in milliseconds.
label_ids int, repeated
Joins with label_id in the adh.google_ads_label table.

Google Ads AdGroup

adh.google_ads_adgroup
customer_id int
Joins with customer_id in any adh.google_ads table.
campaign_id int
Joins with campaign_id in any adh.google_ads table.
adgroup_id int
Joins with adgroup_id in any adh.google_ads table.
adgroup_name string
Ad group name.
adgroup_status int
The ad group 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_BUMPER, VIDEO_NON_SKIPPABLE_IN_STREAM, DISPLAY, SEARCH, OTHER
label_ids int, repeated
Joins with label_id in the adh.google_ads_label table.

Google Ads AdGroupCreative

adh.google_ads_adgroupcreative
customer_id int
Joins with customer_id in any adh.google_ads table.
ad_group_creative_id int
Joins with ad_group_creative_id in any adh.google_ads table.
creative_id int
Joins with creative_id in any adh.google_ads table.
adgroup_id int
Joins with adgroup_id in any adh.google_ads table.
label_ids int, repeated
Joins with label_id in the adh.google_ads_label table.

Google Ads Label

adh.google_ads_label
customer_id int
Joins with customer_id in any adh.google_ads table.
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.
description string
Label description.

Google Ads creative

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

Metro

adh.metro
metro_id int
Metro identifier.
metro_name string
Metro name.
metro_code
(Deprecated, use metro_name instead)
string
The metropolitan area code.
metro_abbrev
(Deprecated, use metro_name instead)
string
Abbreviated version of metro name.
country_code string
Two character country code.

City

adh.city
city_id int
City identifier.
city_name string
City name.
metro_code
(Deprecated, join adh.google_ads_impressions.location.geo_metro_id with adh.metro and use adh.metro.metro_name instead)
string
Metropolitan area code.
region_code
(Deprecated, join adh.google_ads_impressions.location.geo_region_id with adh.region and use adh.metro.region_name instead)
string
The multi character code of the region, which varies by country.
country_code string
Two character country code.
latitude
(Deprecated)
int
Latitude in degrees.
longitude
(Deprecated)
int
Longitude in degrees.

In-market segment

adh.in_market
in_market_id int
In-market identifier.
in_market_name string
A more specific in-market name based on category.
in_market_category string
The category of market vertical.

Browser

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

Operating System

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

Operating System Version

adh.os_version
operating_system_version_id int
Operating system version identifier.
operating_system_id int
Joins with operating_system_id in operating system table.
platform_name string
The platform name in English.
major_version int
The major version number of the operating system.
minor_version int
The minor version of the operating system.
operator_type string
Could be OPERATOR_TYPE_EQUAL_TO (equal to), or OPERATOR_TYPE_GREATER_THAN_EQUAL_TO (greater than or equal to), the OS version information returned in the table.

Region

adh.region
region_id int
Region identifier.
region_name string
Region name.
region_code
(Deprecated, use region_name instead)
string
Region code.
country_code string
Two character country code.

Mobile browser class

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

Partner Sold - Cross Sell

Impressions

adh.partner_sold_cross_sell_impressions
query_id
Unique identifier for query has multiple parts. Joins with query_id.
query_id.time_usec
int
Time in microseconds.
query_id.server_ip
int
The processing server.
query_id.process_id
int
The processing process.
publisher_domain
string
Domain of page on which ad appeared.
content_url
string
URL of the page on which ad appeared. Part of the url is removed for privacy.
location
Unique identifier for query has multiple parts. Joins with query_id.
location.geo_region
string
Region as a string, e.g. US-CA.
location.geo_metro
int
Code for metrio region. Joins with metro_id in adh.metro table.
location.geo_city_id
int
Code for city. Joins with city_id in adh.city table.
user_id
(is device_id_md5 in _rdidtable)
string
Raw user ID.
query_language
string
Language used by user.
mobile_browser_class
repeated int
Desktop, tablet, smart tv consoles, or mobile. Joins with mobile_browser_class_id in adh.mobile_browser_class table.
operating_system_version_ids
repeated int
ID of operating system. Joins with operating_system_version_id in adh.os_version table.
device_height
int
Device height in pixels.
device_width
int
Device width in pixels.
physical_screen_height
int
Device screen height in mm.
physical_screen_width
int
Device screen width in mm.
line_item_id
int
Line item id for this impression.
creative_id
int
Joins with creative_id in any adh.yt table.
gfp_placements
int
Ad Manager placement ID for this impression. Does not represent Campaign Manager placement.
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.
ad_id
string
VAST ad ID.
network_code
string
ID of the publisher network.

Clicks

adh.partner_sold_cross_sell_clicks
query_id
Unique identifier for query has multiple parts. Joins with query_id.
query_id.time_usec
int
Time in microseconds.
query_id.server_ip
int
The processing server.
query_id.process_id
int
The processing process.
click_id
Unique identifier for click has multiple parts. Joins with click_id.
click_id.time_usec
int
Time in microseconds.
click_id.server_ip
int
The processing server.
click_id.process_id
int
The processing process.
click_type
int
The click type.
user_id
string
Raw user ID.
is_in_rdid_project
boolean
True if this event is also in the_rdidtable. Used for deduplication of events.
creative_id
int
Joins with creative_id in any adh.yt table.
ad_id
string
VAST ad ID
network_code
string
ID of publisher network

Conversions

adh.partner_sold_cross_sell_conversions
query_id
Unique identifier for query has multiple parts. Joins with query_id.
query_id.time_usec
int
Time in microseconds.
query_id.server_ip
int
The processing server.
query_id.process_id
int
The processing process.
click_id
Unique identifier for click has multiple parts. Joins with click_id.
click_id.time_usec
int
Time in microseconds.
click_id.server_ip
int
The processing server.
click_id.process_id
int
The processing process.
conversion_id
Unique identifier for query has multiple parts.
conversion_id.time_usec
int
Time in microseconds.
conversion_id.server_ip
int
The processing server.
conversion_id.process_id
int
The processing process.
conversion_type
int
The conversion type.
user_id
string
Raw user ID.
creative_id
int
Joins with creative_id in any adh.yt table.
ad_id
string
VAST ad ID.
network_code
string
ID of publisher network.

Active Views

adh.partner_sold_cross_sell_active_views
query_id
Unique identifier for query has multiple parts. Joins with query_id.
query_id.time_usec
int
Time in microseconds.
query_id.server_ip
int
The processing server.
query_id.process_id
int
The processing process.
view_id
Unique identifier for query has multiple parts.
view_id.time_usec
int
Time in microseconds.
view_id.server_ip
int
The processing server.
view_id.process_id
int
The processing process.
view_type
string
Type of view (delayed or ActiveView).
num_active_view_viewable_impression
int
1 when impression is active view viewable; 0 when impression is not active view viewable.
creative_id
int
Joins with creative_id in any adh.yt table.
ad_id
string
VAST ad ID.
network_code
string
ID of publisher network.

Creative Pixels

adh.partner_sold_cross_sell_creative_pixels
creative_id
string
VAST ad ID.
pixel_url
string
Pixel URL.

Google Ad Manager Pixels

adh.partner_sold_cross_sell_gam_pixels
pixel_url
string
Pixel URL.