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

0 Comments

Please sign in to leave a comment.