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) On Tuesday, October 19, 2021 at 10:35:35 PM UTC+7 Александр Кочкарёв wrote: > 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) > > 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. > > On Monday, October 18, 2021 at 1:53:30 PM UTC+7 Александр Кочкарёв wrote: > >> 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: >> [image: 2021-10-18_13-48-08.png] >> > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/7097a942-a967-4d06-bb58-b3c754804d30n%40googlegroups.com.
