How to format query filtering on segments.product_country

[Karl]

Hi,

I am trying to pull shopping performance data from a specific country (Sweden) in an account, but can't figure how the WHERE clause on segments.product_country is supposed to be formatted.  Using the query builder I got:

const query = "SELECT segments.product_item_id, segments.product_country, metrics.clicks FROM shopping_performance_view WHERE segments.product_country = 'SE' AND segments.date DURING LAST_30_DAYS"

but this returned error "MutateError.UNSPECIFIED: Call to GoogleAdsService.Search failed: Resource name 'SE' is malformed: expected 'geoTargetConstants/{criterion_id}'"

So next I tried to include that in the query:

"SELECT segments.product_item_id, segments.product_country, metrics.clicks FROM shopping_performance_view WHERE segments.product_country = 'geoTargetConstants/SE' AND segments.date DURING LAST_30_DAYS"

But that resulted in the error: "Ba: Could not read from Google Ads"

Any tips much appreciated!

[Sigurd Fabrin]

Yes, it looks for a resource name that must be formatted in a specific way https://developers.google.com/google-ads/api/fields/v14/shopping_performance_view#segments.product_country

More on resource names here https://developers.google.com/google-ads/api/docs/client-libs/python/resource-names

Sigurd

[Sigurd Fabrin]

found a csv with all the geo target ids https://developers.google.com/google-ads/api/data/geotargets 

Sigurd

[Karl]

Thanks a bunch Sigurd!