Joining Of two table into Google Ads API

[Shweta Suthar]

Hi Team,

Is it possible to join two tables ad_group_ad and recommendation ? I'm trying to get the both ad type details with a single query using join statement.

Thanks,

Shweta Shweta

[Google Ads API Forum Advisor]

Hi Shweta,
 
Thank you for reaching us out. I am Sherwin from Google Ads API support team. I hope that you are doing well today.

Moving forward to your concern , it is somewhat possible because in the Recommendation report, the Ad_group is listed as attribute resources. However, the Recommendation report is a type of report that doesn't have any metrics so if you are looking for the metrics of the Ad_group, it will not be fetched. So if you don't need metrics, we suggest using the Recommendation report. On the other hand, if you need the metrics of the Ad_group, it is not possible to combine the Recommendation because it is not listed as attribute resources.

I hope this helps but if you have other concerns, please let us know.

Kind regards,

Sherwin Vincent Google Ads API Team

 

ref:_00D1U1174p._5004Q2euESO:ref

[Shweta Suthar]

Hi Sherwin,

Thank you for the update. 

we are trying to merge ad_group_ad  not Ad_group with Recommendation.

https://developers.google.com/google-ads/api/fields/v11/ad_group_ad

Is it possible to merge  ad_group_ad and Recommendation?

Thanks,

Shweta Suthar

[Google Ads API Forum Advisor]

Hi Shweta,

Thank you for your reply. I work with Sherwin and allow me to assist you here.

With regard to your question "Is it possible to merge ad_group_ad and Recommendation?" that you mentioned. I'm afraid that this is not possible as the ad_group_ad resource is not supported in the recommendation report.

The only resources that are supported in the recommendation report are the following:
ad_group
campaign
campaign_budget
customer

Best regards,

Jinky Google Ads API Team

ref:_00D1U1174p._5004Q2euESO:ref