Get uac campaign's user location report though google ads api

[Q]

hi~

We try to get uac campaign's user location report through google ads api while meeting some problem.

We use "User location view" to get uac account's data,  sql like below:

SELECT

campaign.id,

user_location_view.country_criterion_id,

segments.date,

segments.device,

segments.geo_target_county,

metrics.all_conversions,

metrics.all_conversions_from_interactions_rate,

metrics.all_conversions_value,

metrics.clicks,

metrics.cost_micros,

metrics.ctr,

metrics.impressions,

metrics.video_view_rate,

metrics.video_views

metrics.view_through_conversions

FROM user_location_view WHERE segments.date >= '2020-11-07' AND segments.date <= '2020-11-08'

;

But it seems like no data return and no errors. 

So my questions are :

1. Can i get uac account user location report through this way?

2. I wonder the sql is right or not ? 

Thanks for your help!

[Q]

Plus, we use google ads api v3 version.

[Google Ads API Forum Advisor Prod]

Hi,

Thank you for reaching out. Since you are still using the deprecated v3, I would recommend that you consider migrating to the latest version to keep updated on new features of the Google Ads API.

Moving forward, so I can also investigate, could you provide your customer ID and the complete request and response logs, along with the request ID?

You may send the requested details using the Reply privately to author option. 

Best regards,

Peter Laurence Napa Oliquino Google Ads API Team

ref:_00D1U1174p._5004Q27vOdt:ref

[Q]

hi,

I have already migrated to the latest version(V6), but the data I retrieved is not right.

Question : I try to get uac account's user location data through this API(https://developers.google.com/google-ads/api/fields/v3/user_location_view), but I can only retrieve user location data of 16 countries. Is there any restrictions on api?  I can get all data through UI. 

The code :

SELECT

campaign.id,

user_location_view.country_criterion_id,

segments.geo_target_county,

segments.ad_network_type,

segments.date,

segments.device,

metrics.clicks,

metrics.cost_micros,

metrics.ctr,

metrics.impressions

FROM user_location_view WHERE segments.date >= '2020-11-01' AND segments.date <= '2020-11-01' ;

[Google Ads API Forum Advisor Prod]

Hi,

Thank you for the additional details.

However, for our team to further investigate, could you also share your customer ID, as well as the complete request and response logs along with the request ID, and the Google Ads UI view's screenshot that you mentioned contained all the data?

You may send these details using the Reply privately to author option.