OWOX BI hit-based web streaming to Google BigQuery

Browse by solutions

• Set up web tracking on the website
  • 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

  Read more
• 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

  Read more
• How OWOX BI collects data to Google BigQuery
  • How hits-based website streaming works with Google Consent Mode
  • Session data collection based on the OWOX BI algorithm
  • Calculating and updating 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

  Read more
• 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")

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

  Read more
• 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

  Read more
• FAQ
  • Why does hitId have different UTM source and keyword in the hit and session data tables?
  • Why do I need bot traffic statistics?
  • Why does the same Client ID within a single domain have different OWOX User IDs?
  • Which values will be recorded to the hit and session data tables when GCLID auto-tagging and manual UTM tagging data overlap in Google Ads?
  • How does the qt parameter affect assigning transactions to user sessions?
  • How to check the number of transaction hits in BigQuery per date?

  Read more