Ads Data Hub table format - Advertisers
Advertisers have access to all fields.
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
- Active View Plus / adh.cm_dt_active_view_plus
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.u_value Table: activities, clicks, impressions
|
U Value 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.segment_value_1 Tables: activities, clicks
|
Segment Value 1 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.other_data Table: activity
|
Other Data string |
event.referrer_url Table: impressions
|
Referrer URL string |
event.tran_value Table: activities
|
TRAN Value 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_bid_price_usd Tables: activities, clicks, impressions
|
DV360 Bid Price (USD) int |
event.dv360_bid_price_partner_currency Tables: activities, clicks, impressions
|
DV360 Bid Price (Partner Currency) int |
event.dv360_bid_price_advertiser_currency Tables: activities, clicks, impressions
|
DV360 Bid Price (Advertiser Currency) int |
event.dv360_url Tables: activities, clicks, impressions
|
DV360 URL string |
event.dv360_site_id Tables: activities, clicks, impressions
|
DV360 Site 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_matching_targeted_keywords Tables: activities, clicks, impressions
|
DV360 Matching Targeted Keywords string |
event.dv360_exchange_id Tables: activities, clicks, impressions
|
DV360 Exchange ID string |
event.dv360_attributed_inventory_source_external_id Tables: activities, clicks, impressions, rich-media
|
DV360 Attributed Inventory Source External ID string |
event.dv360_attributed_inventory_source_is_public Tables: activities, clicks, impressions
|
DV360 Attributed Inventory Source Is Public 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_matching_targeted_segments Tables: activities, clicks, impressions
|
DV360 Matching Targeted Segments 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 |
event.dv360_media_cost_usd Tables: activities, clicks, impressions
|
DV360 Media Cost (USD) int |
event.dv360_media_cost_partner_currency Tables: activities, clicks, impressions
|
DV360 Media Cost (Partner Currency) int |
event.dv360_media_cost_advertiser_currency Tables: activities, clicks, impressions
|
DV360 Media Cost (Advertiser Currency) int |
event.dv360_revenue_usd Tables: activities, clicks, impressions
|
DV360 Revenue (USD) int |
event.dv360_revenue_partner_currency Tables: activities, clicks, impressions
|
DV360 Revenue (Partner Currency) int |
event.dv360_revenue_advertiser_currency Tables: activities, clicks, impressions
|
DV360 Revenue (Advertiser Currency) int |
event.dv360_billable_cost_usd Tables: activities, clicks, impressions
|
DV360 Billable Cost (USD) int |
event.dv360_billable_cost_partner_currency Tables: activities, clicks, impressions
|
DV360 Billable Cost (Partner Currency) int |
event.dv360_billable_cost_advertiser_currency Tables: activities, clicks, impressions
|
DV360 Billable Cost (Advertiser Currency) int |
event.active_view_audible_impressions Tables: active view plus | Number of impressions that are audible int |
event.active_view_audible_time_msec Tables: active view plus | Audible play time int |
event.active_view_audible_visible_time_msec Tables: active view plus | Audible and visible play time int |
event.active_view_background_count Tables: active view plus | Impressions that are in background int |
event.active_view_impressions_audible_and_visible_at_completion Tables: active view plus | Count of audible and viewable impressions on complete. int |
event.active_view_complete_viewable_impressions Tables: active view plus | Number of impressions at the completion of video int |
event.active_view_first_quartile_viewable_audible_impressions Tables: active view plus | Number of impressions visible and audible at first quartile of video int |
event.active_view_first_quartile_viewable_impressions Tables: active view plus | Number of impressions at the first quartile of video int |
event.active_view_fullscreen_count Tables: active view plus | Impressions that are full-screen int |
event.active_view_midpoint_viewable_audible_impressions Tables: active view plus | Number of impressions visible and audible at midpoint of video int |
event.active_view_midpoint_viewable_impressions Tables: active view plus | Number of impressions at the midpoint of video int |
event.active_view_start_viewable_audible_impressions Tables: active view plus | Number of impressions visible and audible at start of video int |
event.active_view_start_viewable_impressions Tables: active view plus | Viewable impressions at start int |
event.active_view_third_quartile_viewable_audible_impressions Tables: active view plus | Number of impressions visible and audible at third quartile of video int |
event.active_view_third_quartile_viewable_impressions Tables: active view plus | Number of impressions at the third quartile of video int |
event.active_view_tos_msec Tables: active view plus | Time on screen int |
event.active_view_impressions_visible10_seconds Tables: active view plus | Count of impressions visible for 10 seconds or more. int |
event.active_view_visible_time_msec Tables: active view plus | Time video is visible on screen int |
event.active_view_plus_measurable_count Tables: active view plus | Number of impressions whose ActiveView+ viewability can be measured. int |
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
- Active View Plus / adh.dv360_dt_active_view_plus
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_bid_price_usd Tables: activities, clicks, impressions
|
DV360 Bid Price (USD) int |
event.dv360_bid_price_partner_currency Tables: activities, clicks, impressions
|
DV360 Bid Price (Partner Currency) int |
event.dv360_bid_price_advertiser_currency Tables: activities, clicks, impressions
|
DV360 Bid Price (Advertiser Currency) int |
event.dv360_url Tables: activities, clicks, impressions
|
DV360 URL string |
event.dv360_site_id Tables: activities, clicks, impressions
|
DV360 Site 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_matching_targeted_keywords Tables: activities, clicks, impressions
|
DV360 Matching Targeted Keywords string |
event.dv360_exchange_id Tables: activities, clicks, impressions
|
DV360 Exchange ID string |
event.dv360_attributed_inventory_source_external_id Tables: activities, clicks, impressions, rich-media
|
DV360 Attributed Inventory Source External ID string |
event.dv360_attributed_inventory_source_is_public Tables: activities, clicks, impressions
|
DV360 Attributed Inventory Source Is Public 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_matching_targeted_segments Tables: activities, clicks, impressions
|
DV360 Matching Targeted Segments 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 |
event.dv360_media_cost_usd Tables: activities, clicks, impressions
|
DV360 Media Cost (USD) int |
event.dv360_media_cost_partner_currency Tables: activities, clicks, impressions
|
DV360 Media Cost (Partner Currency) int |
event.dv360_media_cost_advertiser_currency Tables: activities, clicks, impressions
|
DV360 Media Cost (Advertiser Currency) int |
event.dv360_revenue_usd Tables: activities, clicks, impressions
|
DV360 Revenue (USD) int |
event.dv360_revenue_partner_currency Tables: activities, clicks, impressions
|
DV360 Revenue (Partner Currency) int |
event.dv360_revenue_advertiser_currency Tables: activities, clicks, impressions
|
DV360 Revenue (Advertiser Currency) int |
event.dv360_billable_cost_usd Tables: activities, clicks, impressions
|
DV360 Billable Cost (USD) int |
event.dv360_billable_cost_partner_currency Tables: activities, clicks, impressions
|
DV360 Billable Cost (Partner Currency) int |
event.dv360_billable_cost_advertiser_currency Tables: activities, clicks, impressions
|
DV360 Billable Cost (Advertiser Currency) int |
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. |
event.active_view_audible_impressions Tables: active view plus | Active View: Impressions Audible int |
event.active_view_audible_time_msec Tables: active view plus | Active View: Play Time Audible (Seconds) int |
event.active_view_audible_visible_time_msec Tables: active view plus | Active View: Play Time Audible and Visible (Seconds) int |
event.active_view_background_count Tables: active view plus | Active View: Impressions In Background int |
event.active_view_impressions_audible_and_visible_at_completion Tables: active view plus | Active View: Impressions Audible and Visible at Completion int |
event.active_view_complete_viewable_impressions Tables: active view plus | Active View: Impressions Visible at Completion int |
event.active_view_first_quartile_viewable_audible_impressions Tables: active view plus | Active View: Impressions Visible and Audible at First Quartile int |
event.active_view_first_quartile_viewable_impressions Tables: active view plus | Active View: Impressions Visible at First Quartile int |
event.active_view_fullscreen_count Tables: active view plus | Active View: Impressions Full-Screen int |
event.active_view_midpoint_viewable_audible_impressions Tables: active view plus | Active View: Impressions Visible and Audible at Midpoint int |
event.active_view_midpoint_viewable_impressions Tables: active view plus | Active View: Impressions Visible at Midpoint int |
event.active_view_start_viewable_audible_impressions Tables: active view plus | Active View: Impressions Visible and Audible at Start int |
event.active_view_start_viewable_impressions Tables: active view plus | Active View: Impressions Visible at Start int |
event.active_view_third_quartile_viewable_audible_impressions Tables: active view plus | Active View: Impressions Visible and Audible at Third Quartile int |
event.active_view_third_quartile_viewable_impressions Tables: active view plus | Active View: Impressions Visible at Third Quartile int |
event.active_view_tos_msec Tables: active view plus | Active View: Time on Screen (Seconds) int |
event.active_view_impressions_visible10_seconds Tables: active view plus | Active View: Impressions Visible 10 Seconds int |
event.active_view_visible_time_msec Tables: active view plus | Active View: Video Visible Time (Seconds) int |
event.active_view_plus_measurable_count Tables: active view plus | Active View Plus: Measurable Impressions int |
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.
|
||||||
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:
|
||||||
demographics |
Unique identifier for demographics has multiple parts:
|
||||||
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. |
||||||
activeview_cost (Deprecated, use advertiser_impression_cost and advertiser_click_cost ) |
int Active View cost in micros. |
||||||
impression_cost (Deprecated, use advertiser_impression_cost and advertiser_click_cost ) |
int Impression cost in micros. Use adh.google_ads_impressions advertiser_impression_cost_usd or advertiser_impression_cost_local_micros instead. |
||||||
click_cost (Deprecated, use advertiser_impression_cost and advertiser_click_cost ) |
int Click cost in micros. Use adh.google_ads_clicks advertiser_click_cost_usd or advertiser_click_cost_local_micros instead. |
||||||
conv_cost (Deprecated, use advertiser_impression_cost and advertiser_click_cost ) |
int Conversion cost in micros. |
||||||
micros_to_usd (Deprecated) |
int Micros to dollar factor that is multiplied to obtain cost in dollars. |
||||||
active_view_data |
int See UDF functions available to use this field. |
||||||
advertiser_impression_cost_usd |
double The advertiser's impression cost in dollars. |
||||||
advertiser_impression_cost_local_micros |
double The advertiser's local currency in micros. |
||||||
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.
|
||||||
query_id |
Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
|
||||||
click_cost (Deprecated) |
int Cost in micros in advertiser currency. Use adh.google_ads_clicks advertiser_click_cost_usd or advertiser_click_cost_local_micros instead. |
||||||
cost_usd (Deprecated) |
double Cost in usd. Use adh.google_ads_clicks advertiser_click_cost_usd or advertiser_click_cost_local_micros instead. |
||||||
advertiser_click_cost_usd |
double The advertiser's click cost in dollars. |
||||||
advertiser_click_cost_local_micros |
double The advertiser's cost in local currency micros. |
||||||
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. |
Conversions
adh.google_ads_conversions | |||||||
---|---|---|---|---|---|---|---|
conversion_id |
Unique identifier for conversion has multiple parts:
|
||||||
click_id |
unique identifier for click has multiple parts. Joins with click_id in any adh.google_ads table.
|
||||||
label |
string Name of conversion event. |
||||||
query_id |
Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
|
||||||
conversion_type |
int The type of conversion. |
||||||
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.
|
||||||
view_id |
Unique identifier for query has multiple parts:
|
||||||
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.
|
||||||
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.
|
||||||
demographics |
Unique identifier for demographics has multiple parts:
|
||||||
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. |
||||||
activeview_cost (Deprecated) |
int Active view cost in micros. |
||||||
impression_cost (Deprecated) |
int Impression cost in micros. |
||||||
click_cost (Deprecated) |
int Click cost in micros. |
||||||
conv_cost (Deprecated) |
int Conversion cost in micros. |
||||||
micros_to_usd (Deprecated) |
int Micros to dollar factor. Multiply with the desired cost to obtain cost in dollars. |
||||||
active_view_data |
int Active View mask. See UDF functions available to use this field. |
||||||
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
|
||||||
click_id |
Unique identifier for click has multiple parts. Joins with click_id in any adh.yt table.
|
||||||
click_cost (Deprecated) |
int Cost in micros advertiser currency. |
||||||
cost_usd (Deprecated) |
double Cost in usd. |
||||||
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 Conversions
adh.yt_reserve_conversions | |||||||
---|---|---|---|---|---|---|---|
query_id |
Unique identifier for query has multiple parts. Joins with query_id in any adh.yt table.
|
||||||
click_id |
Unique identifier for click has multiple parts. Joins with click_id in any adh.yt table.
|
||||||
conversion_id |
Unique identifier for click has multiple parts:
|
||||||
label |
string Name of conversion event. |
||||||
conversion_type |
int The type of conversion. |
||||||
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.
|
||||||
view_id (Deprecated) |
Unique identifier for query has multiple parts:
|
||||||
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.
|
||||||
view_id |
Unique identifier for query has multiple parts:
|
||||||
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 line item
adh.yt_reserve_lineitem | |
---|---|
order_id |
int Ad Manager Order identifier used for serving. |
line_item_id |
int Ad Manager line item serving. |
line_item_name |
string Ad Manager line item name. |
cost_type |
string Cost per Click, Conversion, Impression and Active View. |
cost_per_unit |
int Cost per unit served, in micros. |
value_cost_per_unit |
int The value cost per unit of the line item. |
skippable_ad_type |
string Skippable, Not Skippable, Selectable. |
programmatic |
boolean True if the line item was programmatic. |
start_time |
timestamp Time the line item started to be served. |
end_time |
timestamp Time the line item stopped being served. |
creative_id |
int[] Array of creative ids for this line item. Joins with creative_id in any adh.yt table. |
order_name |
string Name of the insertion order. |
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.
|
||||||||||||||||||
video_message |
Multipart identifier for video data.
|
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:
|
||||||||||||||||||
beacon_url |
Multipart identifier for third-party ad trafficked by Campaign Manager.
|
||||||||||||||||||
video_message |
Multipart identifier for video data.
|
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. |
Gender
adh.gender | |
---|---|
gender_id |
int Gender identifier. |
gender_name |
string Gender name of: male, female, or unknown. |
Age group
adh.age_group | |
---|---|
age_group_id |
int Age group identifier. |
age_group_name |
string Age group name. |
Affinity segment
adh.affinity | |
---|---|
affinity_id |
int Affinity identifier. |
affinity_name |
string Affinity name. |
affinity_category |
string Affinity category. |
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. |