Google Analytics User Behavior Data → Google BigQuery
Set up a user behavior data 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
- Set up special values collecting to Google BigQuery only
Set up data collection
- OWOX BI tracking code integration with Google Tag Manager
- OWOX BI tracking code integration with analytics.js on-site code (DEPRECATED METHOD)
- 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
- 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
- The definitions of device categories in the "owoxbi_sessions" tables
Data schemas
Identifying and solving data discrepancies between Google Analytics and OWOX BI
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
Sample queries
- How to get a session-level scope value for a custom dimension?
- How to calculate visit start time?
- 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?
FAQ
- How are data storing and unique user processing billed?
- 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 differ from the BigQuery Export for Google Analytics 360?
- Why does a sessionId have more than one hit with the "isEntrance = 1" parameter?