Query the ga4 session last non direct traffic source in bigquery

![rw-book-cover](https://tanelytics.com/wp-content/uploads/2022/11/session-traffic-source-header-image-2.png) ## Metadata - Author: [[taneli-salonen|Taneli Salonen]] - Full Title:: Query the GA4 Session Last Non-Direct Traffic Source in BigQuery - Category:: #🗞️Articles - Document Tags:: [[Google analytics|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](https://support.google.com/analytics/answer/10089681?hl=en) 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](https://read.readwise.io/read/01h6f1wq9d0t9z2pxdgnrtbgdh))