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 …

Items dimensions & metrics (GA4 Ecommerce)

Google Analytics 4 provides a wealth of data that can be accessed directly from tables without needing any complex calculations. However, there may be certain dimensions and metrics that require some advanced SQL skills to access and calculate. I have learned some valuable insights on the best practices for calculating …

How to Create a Google Ads Report in GA4

No Pre-Built Report Available Google Analytics 4 (GA4) is the latest version of Google Analytics that offers advanced features for tracking and analyzing website and app data. If you’re using Google Ads to drive traffic to your website or app, you may want to track its performance in GA4 to …