Joinable fields in Ads Data Hub

Generally, fields with the same category and ID name can be joined together across tables. For example adh.adwords_impressions.query_id can be joined with adh.adwords_clicks.query_id. In this example adwords is the common category, query_id is the common ID name, and impressions and clicks are the two different tables.

Additional fields that can be joined

  • To join a DoubleClick Campaign Manager Pixel with an AdWords creative:

adh.dcm_dt_impressions.event.site_placement_id joins with adh.adwords_creative.beacon_url[offset(0)].placement_id

  • To join a third party DoubleClick Campaign Manager creative with an AdWords creative:

adh.dcm_dt_impressions.event.site_placement_id joins with adh.adwords_creative.snippet_url[offset(0)].placement_id

Fields that cannot be joined

User IDs cannot be joined across product categories. For example, AdWords user IDs cannot be joined with either YouTube or DCM Data Transfer user IDs.

Also, fields common to multiple product categories like: creative_id, campaign_id, and browser_id cannot be joined across product. For example adh.dcm_dt_*.campaign_id cannot join with adh.adwords_*.campaign_id

Generally, AdWords cannot join with either YouTube or DCM DT. DCM DT cannot join with YouTube.