Google Analytics → Google BigQuery: Related products pipeline setup

List of related products is generated based on Google Analytics Enhanced Ecommerce data. You can the data in BigQuery for example for recommending algorithms or email campaigns.

To set up export of data about related products from Google Analytics to Big Query, please visit, in section «Data pipelines» on the left click «New pipeline» and do the following:

  1. Select data source: Google Analytics.


  2. Select type of data: Related products.


  3. Provide access to Google Analytics.


  4. Select Google Analytics property and View. Data of this view will be exported to BigQuery.


    Please note that filters and view settings influence not only data you see in Google Analytics, but what data is exported too.
  5. Provide access to Google BigQuery.


  6. Select BigQuery Project and Dataset. Data will be saved there. If you need a new dataset, you can create it here.
    If you haven't created OWOX BI project and connected Google Analytics Property and Google BigQuery project, you can do it here, it's required to finish pipeline setup.


You'll see exported data of the previous day in BigQuery the next day after setup. Data import starts at 5 AM everyday and it usually takes up to 2 hours. Data is saved in a separate table for each day and each table is available for 30 days.

Please note: you can create only one pipeline with data about related products for each Google Analytics Property.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request


Please sign in to leave a comment.