Collect Google Analytics Data In Google BigQuery

Not a Google BigQuery user yet? Sign up for free and get $300 to spend with any GCP product over the next 12 months.

Do any of these challenges sound familiar to you?

Track everything users do on your website

After a hit is sent from your website, it may take up to 24 hours for Google Analytics to make the data available via the interface or API, and up to 48 hours to finish processing the data.

Only 10M hits per month per property are allowed in the free Google Analytics accounts, and you’re almost certain to lose the data above this limit. Other limits are 200K hits per user per day and 500 hits per session.

Not least, you can’t see user phone numbers and email addresses in the reports, as sending any personal identifiable information (PII) to Google Analytics is strictly prohibited.

Avoid data sampling and get non-aggregated session data

When the data volume for a selected date range in a report exceeds 500K sessions, Google Analytics applies session sampling. This means it only processes a percentage of data, and your reports are no longer 100% accurate.

You may want to see all the important information at a glance, in one report, while there are reporting limitations in Google Analytics. Up to 5 dimensions and 10 metrics are allowed in the interface, and not all dimensions and metrics can be used together. In addition, dimensions must be paired with metrics, which means the data is always aggregated.

Get detailed information about your marketing efforts

Google Analytics provides the Cost Data Import feature, enabling you to upload the cost data for all your advertising initiatives, and combines this cost data with revenue and conversion data. However, with Google Analytics alone you can’t see the amount of money you’ve spent acquiring a particular user.

Overcome your analytics challenges with OWOX BI Pipeline

All user behavior data will be sent to Google BigQuery without prior processing, as separate hits, in real time.

The number of hits you can collect is unlimited. You’ll get access to each and every hit from your website.

You’ll be able to collect and use personal data, such as the email addresses and phone numbers of your customers.

Select the Google BigQuery project and the dataset where you want to store and process data.

Click «Create». If you’re creating a «Cost Data» pipeline — congratulations, the setup is complete. If you’re setting up a «User Behavior Data» pipeline, you’ll be redirected to the Settings tab on the page of your newly created pipeline.

Specify the type of data you want to export to Google BigQuery. You can choose to collect both hit-level and session-level data, or hit-level data only.

Specify the details required to collect session data in the pipeline. For more information, please refer to our Help Center.

Copy the tracking code snippet and implement it on the website in any way that is convenient for you. See our Help Center for a step-by-step guide to implementing the tracking code.

All the data is stored and processed only in your Google Cloud Platform project. You can manage access to the data at any time.

The security of your data is ensured by using both the official APIs and OAuth authorization.

OWOX is a recognized Google Cloud Platform Certified Partner.

OWOX BI Pipeline is published in the official Google Analytics app gallery.

Pricing

Select a plan

Basic

Business

Enterprise

Collection of unsampled data from Google Analytics into Google BigQuery

You’ve Got Questions? We’ve Got Answers!

No, OWOX BI Streaming does not influence your Google Analytics performance. All advantages of Google Analytics 360 are available only for Analytics 360 accounts. At the same time, OWOX BI Streaming helps you experience benefits of processing unsampled Google Analytics data without a significant investment.

It is important not only to send data but to collect each hit. OWOX BI Streaming data collection point is located in Google Cloud Platform. It provides high-level SLA and fast resource scaling. One more significant benefit is that data is delivered in Google BigQuery in real-time.