Google Analytics User Behavior Data → Google BigQuery

Set up streaming pipeline

• Google Analytics Real-Time Data → Google BigQuery: Create a streaming pipeline
• Google Analytics Real-Time Data → Google BigQuery: Set up session data collection based on OWOX BI algorithm
• Google Analytics Real-Time Data → Google BigQuery: Set up session data streaming based on Google Analytics data
• Set up AdWords reports for session auto-tagging
• Create a referral exclusion list for collecting hit-based session data
• Set up collecting email and phone data

Set up data collection

• Website tracking with GTM. The customTask method
• Website tracking with GTM. The Custom HTML tag method
• Website tracking with analytics.js on-site code
• Tracking with Measurement Protocol
• iOS apps tracking
• Android apps tracking

See all 7 articles

Collected data

• Session data collection based on the OWOX BI algorithm
• Collecting and updating the Google Analytics-based session data
• Differences between the session data collection algorithms
• Why the number of sessions collected differs when using the OWOX BI algorithm
• Collecting OWOX User ID
• Collecting and updating User ID data

See all 9 articles

Data schemas

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

Google Analytics Custom Domain

• Collecting data from gtag.js using Custom Domain
• Collecting data from analytics.js using Custom Domain
• Collect hits from Google Tag Manager with Custom Domain
• Send Measurement protocol hits with Custom Domain

Call tracking integration

• Call-tracking

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

See all 10 articles