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 -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@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+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/952d329a-8464-4b7d-867d-2616d6dc346a%40googlegroups.com.
