Metadata
- Author: Taneli Salonen
- Full Title:: Query the GA4 Session Last Non-Direct Traffic Source in BigQuery
- Category:: 🗞️Articles
- Document Tags:: google analytics,
- URL:: https://tanelytics.com/ga4-bigquery-session-traffic_source/
- Finished date:: 2023-07-29
Highlights
This blog post will show how to recreate the GA4 session traffic source dimensions using BigQuery export event data. The result will be a lookup table containing the last non-direct source of traffic for each unique session id (View Highlight)