Joinable fields

Generally, fields with the same name within the same buying door can be joined together across tables. For example, adh.google_ads_impressions.impression_id can be joined with adh.google_ads_clicks.impression_id. In this example, Google Display Ads is the common buying door, impression_id is the common field, and google_ads_impressions and google_ads_clicks are the two different tables.

Different Google products use different user IDs, and user IDs can vary within a single product based on sign-in state. Use the following table as a guideline for joining across products. Joins within each buying door will generally work, whereas joins between buying doors generally won't.

Buying Door	Products	Tables	Joinable IDs
Google Display Ads	Google Video Partners (excl. YouTube)	adh.google_ads_*
Google Marketing Platform	via Data Transfer: Display & Video 360 Campaign Manager 360	adh.dv360_dt_* adh.cm_dt_*
YouTube Google sold	YouTube Reserve YouTube (in Google Ads) YouTube (in Display & Video 360)	adh.yt_reserve_* adh.google_ads_* adh.dv360_youtube_*
YouTube Partner sold	Google Ad Manager Freewheel	adh.partner_sold_cross_sell_* adh.freewheel_*
Key	user_id	external_cookie	device_id_md5

Learn more about joinable fields.