Google Ads API joining tables

[Jessie]

Hi,

Is it possible to join two tables detail_placement_view and detail_placement_group? I'm trying to get the Placement (group) display name as well as Placement (detail) name with a single query using join statement.

Thanks,

Jessie

[googleadsapi...@google.com]

Hi Jessie,

Thank you for reaching out. Unfortunately, JOIN statements are currently not supported in GAQL. As of now, you can only select fields which are selectable within the resource. I would suggest that you keep an eye on our blog post to get the latest updates.

Regards,

Dave

Google Ads API Team

=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
    https://ads-developers.googleblog.com/search/label/google_ads_api
    https://developers.google.com/adwords/api/community/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

Was your question answered? Please rate your experience with us by taking a short survey.
If not -- reply to this email and tell us what else we can do to help.

Take Survey

Also find us on our blog and discussion group:
http://googleadsdeveloper.blogspot.com/search/label/adwords_api
https://developers.google.com/adwords/api/community/

--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
 
You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwor...@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
---
You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscribe@googlegroups.com.
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/4ccc0f9d-f1c6-47cd-923f-8156057123f7%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Zhisheng Zhou]

Hi. Is tables joining supported by GAQL now?

Best,

Zhisheng

adwords-api...@googlegroups.com

For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
---
You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group.

To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api...@googlegroups.com.

[Google Ads API Forum Advisor Prod]

Hi Zhisheng,

Thank you for reaching out. Joining tables is not an option in the GAQL. Please fetch data through the available resources instead.

Thanks and regards,
Xiaoming, Google Ads API Team
 

Xiaoming Google Ads API Team

ref:_00D1U1174p._5004Q2Be6Nj:ref