Search term reports by location and device

[Suraj Chopade]

Hi,

I am trying to generate the search term report by device & location. I have data loaded in bigquery and I have search_query_stats which has metrics for search term with device information. But it has missing location details like country. How would I get the country/location details and how can generate the data group by device & location.

Thanks

[Google Ads API Forum Advisor Prod]

Hi Suraj,

Thanks for reaching out! Can you please provide the current query you are using to generate the report so I can see what you are already using? Generally, in order to get reports for location, you will have to use the location_view within Google Ads API. For reports on device, you can also try using the campaign_criterion resource to pull campaign_criterion.device.type. 

Regards,

Danica Google Ads API Team

ref:_00D1U1174p._5004Q23wsir:ref