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_* |
User iconCookie iconSmartphone icon |
| Google Marketing Platform |
via Data Transfer: Display & Video 360 Campaign Manager 360 |
|
User iconCookie iconSmartphone icon |
| YouTube Google sold |
YouTube Reserve YouTube (in Google Ads) YouTube (in Display & Video 360) |
|
User iconCookie iconSmartphone icon |
| YouTube Partner sold |
Google Ad Manager Freewheel |
|
User iconCookie icon |
| Key | User iconuser_id |
Cookie iconexternal_cookie |
Smartphone icondevice_id_md5 |
Learn more about joinable fields.