What is the most popular path my readers take on my site?
We’d like to see the path of the different urls or pages a user viewed in a single session based on the automatic page load event in the JS SDK. You can also replace the page_url with page_title or to your own custom property. Tip: Use the sunburst visualization. Change the limit to get more paths.
select page_path, count(distinct session_id) as sessions from (select session_id, group_concat (page_url,',') as page_path from (select session_id, page_url,event_time_ts as ts from cooladata where date_range(context) and filters(context) and event_name = ‘page_load’ and page_url is not null order by ts) group by 1) group by 1 order by 2 desc limit 20