CODEWITHSUNDEEP
google-bigquery
user3457337
user3457337

Reputation: 55

Trying to find the field 'Search Query' from GA in BigQuery

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!

Upvotes: 0

Views: 1439

Answers (1)

Ben P
Ben P

Reputation: 3379

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.

Upvotes: 2

Related Questions