0

I'm trying to find the Google Analytics field 'Search Query' in BigQuery. I can find 'keyword', but not the 'Search Query'.

I can't seem to find the answer anywhere!

user3457337
  • 55
  • 6

1 Answers1

2

trafficSource.keyword is the field you need, as per the export schema:

    trafficSource.keyword   
    STRING  
    The keyword of the traffic source, usually set when the trafficSource.medium 
    is "organic" or "cpc". Can be set by the utm_term URL parameter.
Ben P
  • 3,267
  • 4
  • 26
  • 53
  • TrafficSource.keyword, which returns the keyword, but I'm looking for the Search Query (or Search term). For example: I search on Google for 'yellow raincoat sale', so that's my search query. When I click on the ad, the keyword is '+yellow +raincoat'. I want to find the search query. In the GA interface you can find this under the field 'Search Query', but there seems to be no such field in BigQuery. – user3457337 Oct 04 '18 at 13:08
  • 1
    Oops yes you are right, will correct my post now. Edit further your comment: Aha, got you, you'll have to looking Google Search Console for the query data, I don't believe this is in BigQuery. – Ben P Oct 04 '18 at 13:10
  • When selecting 'trafficSource.keyword' all I get in return is the Google AdWords(Ads) keyword & not the search query. Thanks for your help so far! – user3457337 Oct 04 '18 at 13:13
  • I'm looking for AdWords search terms though – user3457337 Oct 04 '18 at 13:18
  • You can transfer this data into BigQuery with Google Ads Transfers: https://cloud.google.com/bigquery/docs/adwords-transfer – Ben P Oct 04 '18 at 13:26
  • Let us [continue this discussion in chat](https://chat.stackoverflow.com/rooms/181289/discussion-between-user3457337-and-ben-p). – user3457337 Oct 04 '18 at 13:28