I want to get country infomation with campaign in table 'location_view', my query as followed

[MY LOVE]

SELECT
customer.id,
campaign.id,
campaign.name,
campaign.status,
metrics.interactions,
metrics.cost_micros,
metrics.conversions,
metrics.ctr,
metrics.impressions,
metrics.clicks,
segments.date,
FROM location_view
WHERE

segments.date BETWEEN '%s' AND '%s'

please, thanks!

[Google Ads API Forum Advisor]

Hi,

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

With regards to your concern, you can use geographic_view. Let me know if you have any question.

Thanks,

Nirmita Google Ads API Team

 

ref:_00D1U1174p._5004Q2ZLmzv:ref