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 my.bi.owox.com, in section «Data pipelines» on the left click «New pipeline» and do the following:

  1. Select data source: Google Analytics.

     1.png

  2. Select type of data: Related products.

     2.png

  3. Provide access to Google Analytics.

     3.png

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

     4.png


    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.

    5.png 

  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.

     6.png

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

0 Comments

Please sign in to leave a comment.