Impact of iOS 17+ Updates on Digital Advertising and the Importance of UTM Parameters

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 …