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|
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).
||Product ID if the model attributes the product value. If there are no products, fill in any index|
||Number of products in a transaction. If there are no products, fill in index "1"|
||Order creation time|
During model calculation, data from the source you add replaces data from Google Analytics with grouping by
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:
- There is a transaction in Google Analytics, but new transactions data source doesn't contain it
Value of such transactions isn't attributed.
- 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.
- 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.