Website tracking with 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
  • 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
  • The definitions of device categories in the "owoxbi_sessions" 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
  • Which type of access does OWOX BI require and how to update the access tokens?
  • How are the 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?

  Read more