I'm able to fetch Region and City IDs in the below format. However, I would
want their names to be displayed instead of IDs. One way I figured out was
making another request with the Region/City ID to fetch the name.
Query to fetch Region and City IDs.
SELECT campaign.name ,segments.geo_target_region, segments.geo_target_city,
metrics.clicks, metrics.impressions, metrics.cost_micros FROM
geographic_view
Query to fetch Names of a set of Regions
var regionsList = [];
// Form Array from Above query
SELECT geo_target_constant.name, geo_target_constant.country_code,
geo_target_constant.target_type FROM geo_target_constant WHERE
geo_target_constant.id IN ("+ regionsList +")"
Can I fetch Region and City Name and the other metrics in a single query?
If yes, can someone please help me with the inner query.
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 [email protected]
To unsubscribe from this group, send email to
[email protected]
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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/adwords-api/d9dbfab3-32ac-452e-a990-db941603416d%40googlegroups.com.
