Try out all OWOX BI features with a trial period Start for free

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

Importing user audience data to Google Analytics

To import your users data to a Google Analytics remarketing audience, you need to create an "About user" data set.

When creating the data set, its data schema must contain:

Key: a Custom Dimension into which you collect ClientID;

Imported Data: a Custom Dimension into which you collect a value used to segment your audience.

image1.png

You must have these Custom Dimensions created before you create the data set.

To import data from Google BigQuery, write a query that will get a user's Client ID and the condition, according to which the user will be assigned to a certain audience.

The query must look like this:

#standardSQL
SELECT
clientID as dimension{custom dimension index},
{user condition} as dimension{custom dimension index}
FROM…

Once the pipeline is activated, you can set up a user audience in Google Analytics based on the data imported from Google BIgQuery.

Importing "About product" data to Google Analytics

In the dataset schema for the "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?
1 out of 1 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.