This post provides readers with valuable insights into five custom reports that can be created using GA4. It includes step-by-step instructions on how to create these reports, such as User Acquisition, Page Performance, E-commerce Performance, Custom Event, and Audience Behavior reports. By leveraging these reports, businesses can gain valuable insights …
webgeek 
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 …