
Calculating user paths in GA4 BigQuery is one of the toughest queries you can write in SQL.
Unless you have years of SQL experience, writing this from scratch is painful.
Here is the SQL:

Calculating user paths in GA4 BigQuery is one of the toughest queries you can write in SQL.
Unless you have years of SQL experience, writing this from scratch is painful.
Here is the SQL: