Google Ads Statistics By Country by API

[Ersan]

Hi;

I need to get impression, click, cost and conversion report by country. How should i update my query at below? 

I mean; for example i want to get Turkiye's impression, click, cost and conversion data.

Could someone help me?

SELECT metrics.impressions, metrics.clicks, metrics.cost_micros, metrics.conversions FROM geographic_view
WHERE segments.date >= '2023-01-01 AND segments.date <= '2024-01-01'
AND metrics.cost_micros > '0' AND segments.country = 'TR'

[Google Ads API Forum Advisor]

Hi,

Thank you for reaching out to the Google Ads API support team.

By reviewing your concern, I understand that you would like to get the impression, click, cost, and conversion report for a Turkish country. Please refer to this example GAQL query on how to retrieve Locations using the Google Ads API.

You may use the geographic_view report. Geographic View includes all metrics aggregated at the country level, one row per country. It reports metrics at either the actual physical location of the user or an area of interest. If other segment fields are used, you may get more than one row per country and user_location_view report. It reports metrics at the actual physical location of the user by targeted or not targeted location. 

Also, you can use Query Builder to create your query and Query Validator to validate your query. 
 

This message is in relation to case "ref:!00D1U01174p.!5004Q02rzuXO:ref" (ADR-00227115)

Thanks,
 

Google Ads API Team