search query performance report missing location(country) information

Hi I am generating the search query performance report using google ads API. In the report I am not getting the location information. Is there any way to get location information? -- * ***Disclaimer** *This email communication (including any attachments) contains information which is confident

DSA ads and final url

Hi How to get the final urls for DSA ads? I have loaded all raw data to bigquery and I am trying to get the final urls for DSA ads but I am not getting ways to do it. Could you please suggest? -- * ***Disclaimer** *This email communication (including any attachments) contains information whic

keyword tables & search query stats

Hi Could anyone help me to know what should be the join criteria I should use to join the keyword and search_query_stats table. I have loaded the google adwords data to bigquery using transfer services. Basically I want to know which keywords triggered the ads for given search terms. -- * ***Di

Search terms and final urls

Hi Team, As per my understanding we can set final urls at keywords and ad level. When user type search query if he see ads and if there is keyword match with search query and if keyword has final url set then that will take more precedence than ad level url. In case if there is no url associat

Search term reports by location and device

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