Skip to content
Advertisement

Tag: google-analytics

Extract user journey data between two pages in BigQuery Google Analytics data

How to extract users’ journey data between two specific pages in Google Analytics BigQuery Export data? Example: Website has 100 pages: hits.page.pagePath=/page_1 to hits.page.pagePath=/page_100. Goal is to extract user journey data from /page_13 to /page_22, including all in-between pages. The challenge is that the journey is not sequential, like /page_13 -> /page14 -> … -> /page_22. But could be /page13

Advertisement