Keyword Search Query googleAnalyticsR or RAdwords

[Peter Trachsel]

Hello

I am trying to read the AdWords Search Queries with R either with the RAdwords or googleAnalyticsR package. When i do lookup available metrics at https://developers.google.com/analytics/devguides/reporting/core/dimsmets i cannot find search queries as a metric. (What i can read are the keywords which come from the organic search (traffic sources).)

Is there any possibility to read the search queries from AdWords or is this metric not available? 

If this topic has already been processed/closed please paste the link. I have not found an exact answer to this question.

Thank you very much and kind regards

Peter

[Shwetha Vastrad (AdWords API Team)]

Hi Peter, 

Are you looking to get the Search terms report or the Paid and Organic report via AdWords API? If so, you need to use AdWords API to download the Search Query Performance Report or the Paid Organic Query Report which are the API equivalent of these two reports. If these reports are not what you are looking for, could you provide a screenshot of the AdWords UI which has the data you are looking for so I can help you out? 

Regards,

Shwetha, AdWords API Team.

[Mark Edmondson]

AdWords search queries are available in the Google Analytics API under ga:keyword
https://developers.google.com/analytics/devguides/reporting/core/dimsmets#view=detail&group=traffic_sources&jump=ga_keyword

You also may want to use the adMatchedQuery
https://developers.google.com/analytics/devguides/reporting/core/dimsmets#view=detail&group=adwords&jump=ga_admatchedquery

For only AdWords keywords, you will want to limit the keywords (so they don't include SEO and other paid search like Bing, by filtering for source==google and medium==cpc

The query in googleAnalyticsR will look something like:

google_analytics(viewId, date_range = c("2017-01-01", "today"), dimensions = c("keyword"), metrics = "adClicks", dim_filters = filter_clause_ga4(list(dim_filter("source","EXACT","google"), dim_filter("medium","EXACT","cpc")), operator = "AND"))

HTH,
Mark

HTH,
Mark