How to join BigQuery table with ADH(Ads Data Hub) table

Question

I have a BigQuery table 'A' with schema {'UUID': 'String'}. I want to join this table with a ADH(Ads Data Hub) table 'B' having schema {'UUID': 'String', 'USER_ID': 'INT'} on UUID and fetch all user_ids to a new table.

I am having trouble in joining ADH table with BigQuery table.

Can someone please help me out?

Answer 1

My recommendation is to try with Google Ads transfers which allows you to automatically schedule and manage recurring load jobs for Google Ads reporting data. Once you have your data in BigQuery you can use the Google Ads sample queries as a reference to to analyze your transferred data.

Using the BigQuery client library for GO you will get more information about how to run your query with the join desired.

Answer 2

If your table A locates in the same region as your ADH account, you should be able to run cross table queries in ADH. You cannot query user_id as part of the output by using ADH, it's not allowed due to privacy protection. However, if you had your UUID passed to Google Marketing Platform using floodlight with custom-variable enabled, you can use this UUID as join key to map both tables, and do analysis from there.