Hello,
You should be able to get this data for your locations by using the following query:
SELECT
geographic_view.country_criterion_id,
geographic_view.location_type,
metrics.clicks,
metrics.cost_micros
FROM
geographic_view
Let me know if you still have issues.
Regards,
Anthony
Google Ads API Team

ref:_00D1U1174p._5001UHFuda:ref