Query requirements for setting up a data pipeline to Google BigQuery

For the pipeline to work correctly, the schema of the data you get as a query result must correspond to the data schema of the dataset used for data upload (read more about the types of datasets).

For example, in the dataset schema for "About product" data:

  • the productSku field is required
  • additionally, you can specify any variations of the following fields: productBrand, productVariant, productCategoryHierarchy, productName, productPrice

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 the 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.