Google Analytics User Behavior Data → Google BigQuery
Set up streaming pipeline
- Google Analytics → Google BigQuery: Create a user behavior data streaming pipeline
- Set up session data collection based on OWOX BI algorithm
- Setting up raw data collection about Google Ads campaigns with auto-tagging
- Creating a referral exclusion list for session data collection
- Set up collecting email and phone data
View-through conversion tracking
Set up data collection
- Website tracking with GTM. The customTask method
- Website tracking with analytics.js on-site code
- Tracking with Measurement Protocol
- Set up tracking for AMP pages
- iOS apps tracking
- Android apps tracking
How OWOX BI collects data to Google BigQuery
- Session data collection based on the OWOX BI algorithm
- Calculation and updates of the session cost data in the adCost and attributedAdCost fields
- User behavior data discrepancies between OWOX BI and Google Analytics: possible reasons and how to fix them
- Collecting OWOX User ID
- Collecting and updating User ID, userEmail, and userPhone data
- Collecting and updating data about Google Ads campaigns with auto-tagging in session data tables
Data schemas
Call tracking integration
- CoMagic: data sent to BigQuery
- Ringostat: set up data collection
- Ringostat: data sent to BigQuery
- Calltouch: set up data collection
- Calltouch: data sent to BigQuery
- Calltracking.ru: set up data collection
FAQ
- What are the possible reasons of discrepancy in Google Analytics and the Google Analytics Real-Time Data → Google BigQuery pipeline data?
- How to fix the "Cannot output multiple independently repeated fields at the same time" error?
- How does the Google Analytics → Google BigQuery user behavior data pipeline in OWOX BI is different from the BigQuery Export for Google Analytics 360?
- Why does a sessionId has more than one hit with the "isEntrance = 1" parameter?
Sample queries
- How does user interaction with social buttons affect the conversion rate?
- How do the page type, device, browser, etc. affect the page load speed or server response time?
- What checkout steps have the highest exit rate?
- How can you calculate time between product detail view and purchase?
- Traffic on out-of-stock product card
- Calculation of revenue from advert blocks