How to select all matched locations at account level?

[Александр Кочкарёв]

Hello!

I'am working on some AdWords script.

Can someone advice me how make a correct query (which fields to select and from what resources) to select matched locations at account level?

I want to select in script the same data that i can select from UI:

[Google Ads API Forum Advisor]

Hi, 

Thank you for reaching out.

You may note that this forum channel specializes in AdWords / Google Ads API related concerns only.

Since you mentioned using Adwords (Google Ads) Scripts, you may reach out to their support team instead via their own forum, if this is indeed the platform you are currently using.

However, if you are using the above mentioned APIs, could you provide our team with more details on the said matched locations? I asked because targeted (not matched) locations can be extracted using the location_view.

Best regards,

Peter Laurence Napa Oliquino Google Ads API Team

ref:_00D1U1174p._5004Q2PKP5e:ref

[Александр Кочкарёв]

Hello Peter! Very thanks for reply!

I think my question is related more to Ads API because i use GAQL queries, and think this queries routed to the same engine that process queries from API (please, correct me if its wrong).

My customer want to analyze data which appeared in UI when selecting "Locations" (from left menu) -> and then "Matched locations (account)" (above table header)
Here is the screenshot with data which i want to get from query:
https://yadi.sk/i/vYwXdBYQC9pNLg
(can't attach image here because message was deleted immediately after i try to post it)

In API docs (near here: https://developers.google.com/google-ads/api/fields/v8/user_location_view_query_builder ) i found 3 resources related to locations:

geographic_view

location_view

user_location_view

Only "user_location_view" has "user_location_view.targeting_location" attribute. Which i expect to be responsible for showing targeted or matched locations.

I make 2 queries with different user_location_view.targeting_location condition:

This query, with user_location_view.targeting_location = TRUE produces 3 rows:

"SELECT user_location_view.country_criterion_id, user_location_view.resource_name, user_location_view.targeting_location, segments.geo_target_most_specific_location, customer.descriptive_name, customer.id FROM user_location_view WHERE user_location_view.targeting_location = TRUE"

3 rows returned.

But this, with only difference that user_location_view.targeting_location = FALSE

"SELECT user_location_view.country_criterion_id, user_location_view.resource_name, user_location_view.targeting_location, segments.geo_target_most_specific_location, customer.descriptive_name, customer.id FROM user_location_view WHERE user_location_view.targeting_location = FALSE"

returns nothing.

And here i am stuck... Don't know how to pull this data, which i expect to get from my second query.

[Google Ads API Forum Advisor]

Hi,

Thank you for sharing all these details.

Upon checking, the matched locations information do not appear to be currently supported in the Google Ads API. That said, allow me to create a feature request, subject for review, for support in retrieving these locations and their metrics.

For now, you may keep an eye on our blog for updates and announcements.

[Александр Кочкарёв]

Thank you for answer! I think it will be great to make request for this feature.