Google Analytics User Behavior Data → Google BigQuery

Set up streaming pipeline

• Google Analytics → Google BigQuery: Create a user behavior data streaming pipeline
• Google Analytics → Google BigQuery: Set up session data collection based on OWOX BI algorithm
• Collect raw data from Google Ads campaigns with auto-tagging
• Creating a referral exclusion list for session data collection
• Set up collecting email and phone data
• Google Analytics → Google BigQuery: Session data collection based on Google Analytics 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
• Set up tracking for AMP pages
• Tracking with SegmentStream (former DigitalDataManager)

See all 9 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 collected with the OWOX BI algorithm ("owoxbi_sessions")
• Schema for session data tables based on Google Analytics data ("session_streaming")

Data collection in a 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

• 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 11 articles

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

See all 10 articles