How do you get "search query" data in BigQuery from Google Analytics

[Elizabeth Clark]

Not sure if this is the right forum to be posting this in so I'm posting in Google Analytics and here. We are trying to analyze "search query" and "keywords". Currently we have Google Ads (previously Adwords) and Google Analytics 360 setup. We also currently send our raw google analytics data to BigQuery. 

In the UI, we can see the "search query" performance report at the individual user level. However, we are unable to find this data in our BigQuery export. I've searched through all of the schema documentation for google analytics in BigQuery and I'm unable to find the "search query" field. Is there a way to get this information? I thought that perhaps we could pull in our Adwords data into BigQuery and join on gclid. However, the search query performance report is only at the aggregrate level. If we pulled in the click performance report we would have gclid but that report does not seem to have the search query. Any recommendations for how to get this information? 

[googleadsapi...@google.com]

Hi Elizabeth,

It appears that your concern is more related to the Google Ads Product as the AdWords API currently does not support data from BigQuery. You may reach out to the product experts via the Google Ads Community Forum for further assistance.

Thanks and regards,

Peter

AdWords API Team

=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
    http://googleadsdeveloper.blogspot.com/search/label/adwords_api
    https://developers.google.com/adwords/api/community/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

Was your question answered? Please rate your experience with us by taking a short survey.
If not -- reply to this email and tell us what else we can do to help.

Take Survey

Also find us on our blog and discussion group:
http://googleadsdeveloper.blogspot.com/search/label/adwords_api
https://developers.google.com/adwords/api/community/

On 02/12/19 13:22:39 clark...@googlemail.com wrote:

Not sure if this is the right forum to be posting this in so I'm posting in Google Analytics and here. We are trying to analyze "search query" and "keywords". Currently we have Google Ads (previously Adwords) and Google Analytics 360 setup. We also currently send our raw google analytics data to BigQuery. 

In the UI, we can see the "search query" performance report at the individual user level. However, we are unable to find this data in our BigQuery export. I've searched through all of the schema documentation for google analytics in BigQuery and I'm unable to find the "search query" field. Is there a way to get this information? I thought that perhaps we could pull in our Adwords data into BigQuery and join on gclid. However, the search query performance report is only at the aggregrate level. If we pulled in the click performance report we would have gclid but that report does not seem to have the search query. Any recommendations for how to get this information? 

--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
 
You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwor...@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
---
You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscribe@googlegroups.com.
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/49d085ff-f269-4a13-a57f-e3f6dc117932%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.