This feature is available only in Business and Enterprise plans.

By default, Google Analytics data, which was saved in Google BigQuery, is the source of transactions and users behavior data.

If you want to attribute value of products that were bought not online (e.g. brick-and-mortar, call center, etc.), change transactions data source on the model page.

To do that, click on data source change button:


And then select a Google BigQuery view or table containing data on the transactions you need:


Data in Google BigQuery table or view has to be in the following format:

Field name Data type Description
user_id STRING User ID.
Data in the field must be consistent with data in the same field in the user behavior data source (user.Id for OWOX BI Pipeline; customDimensions.index and customDimensions.value for BigQuery Export for Google Analytics).
transaction_id STRING Transaction ID
product_id STRING Product ID if the model attributes the product value. If there are no products, fill in any index
product_price FLOAT Product price
product_quantity INTEGER Number of products in a transaction. If there are no products, fill in index "1" 
time TIMESTAMP Order creation time

How to upload transaction data to Google BigQuery?

During model calculation, data from the source you add replaces data from Google Analytics with grouping by transaction_id, user_id and product_id.

Imprtant: It's critical to have consistent transaction, user, and product data in both sources.

If User ID information is not available, you can fill in Client IDs into user_id field to match data by Client IDs.

There might be three cases when the transactions are replaced:

  1. There is a transaction in Google Analytics, but new transactions data source doesn't contain it
    Value of such transactions isn't attributed.
  2. There is no transaction in Google Analytics, but new transactions data source contains it
    For such transactions, purchase sessions are generated. The sessions have the medium set to 'offline'.
    If a user had online interactions prior to offline purchase, those online interactions get value.
    Value for all funnel interactions that didn't happen online is attributed to the offline purchase session.
    If there were no online interactions prior to offline purchase, all value of an offline transaction is attributed to its session.
  3. There is a transaction both in Google Analytics and new transaction data source
    All information about such transactions and sessions that led to them matches Google Analytics data.
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request


Please sign in to leave a comment.