Google Analytics Real-Time Data → Google BigQuery: Create a streaming pipeline

What you need before creating a pipeline

To use Google BigQuery and create a streaming pipeline in OWOX BI, you need a Google Cloud Platform project with activated billing.

To use the OWOX BI streaming service, you need to be subscribed to the plan Basic, Business, or Enterprise.

How to create a pipeline

To create a Google Analytics Real-Time Data → Google BigQuery pipeline, go to the Create a pipeline page and take the following steps:

Step 1: Select data source: Google Analytics

Create_a_Pipeline_1.Select_data_sorce.png

Step 2: Select type of data: User behavior data

Create_a_Pipeline_2.Select_data_type.png

Step 3: Provide access to Google Analytics

Create_a_Pipeline_3._Provide_access_to_GA.png

Step 4: Select Google Analytics property and view as the data source

Here, specify the Google Analytics view you want to gather data to. You need to have the Edit permission for this Google Analytics view.

Note that you can set up only one streaming pipeline per property.

Create_a_Pipeline_4.Select_GA_view.png

Step 5: Provide access to Google BigQuery

Provide access to the BigQuery project where you want to gather Google Analytics data to.

Create_a_Pipeline_5._Provide_Access_to_BQ.png

Step 6: Select Google BigQuery dataset

First, select the Google BigQuery project that contains the dataset you want to gather data to. Then, select the dataset.

If needed, you can create a new dataset right here.

You can set up only one OWOX BI streaming pipeline for each BigQuery dataset. Creating several pipelines for one dataset may cause the hit data to be overwritten.

Create_a_Pipeline_6.Select_BQ_dataset.png

 

Step 7: Implement tracking code

After completing all the steps, don't forget to implement the tracking code. Find it on the created pipeline's page: Settings > JavaScript code for hit data collection.

Integration_code_2.png

The method of implementing the tracking code depends on your project. Here is the full list of the tracking code implementation methods.

Done. The Google Analytics Real-Time Data → Google BigQuery streaming pipeline is all set. An OWOX BI dataset with the streaming tables will appear in your BigQuery project in the first minute of the next hour. 

Please note: In OWOX BI pipeline, the maximum hit payload size is 16 KB. The hits exceeding this limit won't be processed and sent to BigQuery.
In Google Analytics, the maximum hit payload size is 8 KB (Google Analytics Docs).

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.