In the digital advertising landscape, the recent iOS 17+ updates have introduced significant changes, particularly affecting how traffic from Google and Meta Ads is tracked and reported. Apple’s initiative to enhance user privacy through its ‘Link Tracking Protection’ feature, present in the latest update, has created a new challenge for …
GA4 and BigQuery Introduction
Discover the power of GA4 and BigQuery integration to unlock advanced analytics capabilities. Learn how combining Google Analytics 4 with BigQuery allows for in-depth data analysis, custom reporting, and data-driven decision-making Google has introduced a groundbreaking new approach to measuring app and web analytics with Google Analytics 4 (GA4). Though …
Querying GA4 Session Last Non-direct Traffic Source in BigQuery
Hello! I recently found a solution to one of GA4 BigQuery export’s limitations – the lack of session-level traffic source data. I will share how I recreated GA4 session traffic source dimensions using BigQuery export event data, resulting in a lookup table containing the last non-direct source of traffic for …