Follow the requirements to the Google BigQuery query

Data schema requires to specify keys and imported dimensions and metrics.


ga:productSku ga:dimension23 ga:dimension24
12345 Red S


All Google Analytics dimensions and metrics have to be written without ga: prefix in a query.


Google Analytics Google BigQuery query
ga:sourceMedium sourceMedium
ga:productSku productSku
ga:userId userId
ga:metric1 metric1
ga:... ...


To import data from Google BigQuery your query should look as follows:

SELECT productSKU,dimension23,dimension24
FROM ...

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request


Please sign in to leave a comment.