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

See all 7 articles

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

See all 10 articles

Data schemas

• Data schema for hit tables ("streaming")
• Schema for session data tables collected with the OWOX BI algorithm ("owoxbi_sessions")
• Schema for session data tables based on Google Analytics data ("session_streaming")

Identifying and solving data discrepancies between Google Analytics and OWOX BI

• Identifying data discrepancies: sample queries
• The acceptable level of a data discrepancy
• Troubleshoot the hit data discrepancies
• Troubleshoot the transaction data discrepancies
• Troubleshoot the session data discrepancies
• Troubleshoot the ad cost data discrepancies

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

See all 10 articles

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?

See all 12 articles

FAQ

• 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?