Joining customer and campaign?

[Derek Piper]

Trying to get the customer id from a simple metrics query against the 'campaign' table. It does not appear to have the customer id in there though. How do I join to 'customer_client' from the campaign table?

[Google Ads API Forum Advisor]

Hi Derek,

Thanks for reaching out to the Google Ads API team. I hope you are doing well today.
 

With regards to your concern about this, "Trying to get the customer id from a simple metrics query against the 'campaign' table. It does not appear to have the customer id in there though." The customer ID has another report. If you only need the customer ID, you may use this customer report. For this "How do I join to 'customer_client' from the campaign table?" You can't currently join the customer client to the campaign because the customer client has a different report. you may refer to this customer_client report the campaign report only attributed to the customer. I hope this helps.
 

Let us know if your have further questions.

Regards,

Darwin Google Ads API Team

ref:_00D1U1174p._5004Q2gPZoD:ref