(Google Ads Api) Campaign Criterion's location needed more information

[jeonhwan won]

Hi there, 

I tried to call to get locations information from my campaigns. 

Here is the SQL I used and It works well as I expected. 

 

 SELECT campaign.id, campaign.name, campaign_criterion.location.geo_target_constant FROM campaign_criterion

But to get detailed information(name,country_code,target_type) about this location. I need to call again to GeoTargetConstant,  

This is not good for us and your side because we may call at least two times more to your server to get detail location.

So my suggestion is simple to make it possible SQL like below, please

SELECT campaign.id, campaign.name, campaign_criterion.location.geo_target_constant, geo_target_constant.name, geo_target_constant.country_code, geo_target_constant.type FROM campaign_criterion

So with one query, we can get all the information and less stress to your server as well. 

Please let me know your opinion! Thank you 

[Google Ads API Forum Advisor Prod]

Hello Won, 

Appreciate your feedback. I have shared this internally with the team. Please keep an eye on our blog for more future updates. 

Thanks,
Bharani, Google Ads API Team

ref:_00D1U1174p._5001UHEtCM:ref