A Big Query SQL request to simplify journey analysis from Google Analytics 4
It helps generating a file that contains user "Journeys" (with column that is "Journey") that can then be used for visualizing sunbursts and optimizing behaviors
A good example of usage can be found on this article explaining how to get value from a sunburst)
Here is a step by step guide on how to use it
-
Make sure you have connected GA4 to Big Query You can find tutorials here: connect GA4 to BigQuery (for all clients)
-
Copy Paste the file GA4_Journey_Sunburst.sql in a Big Query SQL environment (or if you are familiar with git, clone it on desired place)
-
Specify the proper dates for analysis in the query by replacing with your own dates if need be - that would be typically the last week
-
Find and replace the name of the GA4 (
your_project.your_GA4_ID.events_20*) event tables with the proper names of your table in the whole query -
Find and replace the name of the key tracking page type (
content_group) in your own set up -
Run the query and download results - data should look like this
-
Visualize the Journeys and get insights . You can use any open source packages to visualize sunbursts - SunburstR is a good option in R . Or you can use DataMa Journey SaaS : create account on DataMa platform and upload your CSV in DataMa Journey - free access is available for 15 days. DataMa Journey will provide not only Sunbursts visualization but also comparison and attribution features to understand where you can optimize your journeys. Learn more on DataMa Journey