Path Analysis

Showing 1 - 8 of 8 Items

Use a session path to take the last 2 (or any other N events) that immediately precede the session’s end. Make sure to ask for sessions with more than 5 events in the path. Use either the sunburst visualization or a regular grid view. This helps us answer questions like what were my users doing right before they quit the site?

select  last(path_to_string(path),2) as path, count(*) as count
from cooladata
where date_range(context)
	and filters(context)
	and path_count()>5
	and path_count >= 2
cluster path by session
group by path
order by count desc  
Limit 10
Behavioral Segmentation
Behavioral
Path Analysis

We use CoolaData’s session path to and take only the first 3 events from it. We filter by is_new =1 to only get that user’s first session ever in the app/site.

.

select  first(path_to_string(path),3) as path, count(*) as count
from cooladata
where date_range(context)
	and filters(context)
	and path_count()>5
cluster path by session
group by path
order by count desc  
Limit 10


Behavioral Segmentation
Behavioral

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
Product Analytics
Behavioral
Path Analysis

Use a session path to take the last 2 (or any other N events) that immediately precede the session’s end. Make sure to ask for sessions with more than 5 events in the path. Use either the sunburst visualization or a regular grid view. This helps us answer questions like what were my users doing right before they quit the site?

select  last(path_to_string(path),2) as path, count(*) as count
from cooladata
where date_range(context)
	and filters(context)
	and path_count()>5
	and path_count >= 2
cluster path by session
group by path
order by count desc  
Limit 10
Product Analytics
Behavioral
Path Analysis

Use a session path to take the last 2 (or any other N events) that immediately precede the session’s end. Make sure to ask for sessions with more than 5 events in the path. Use either the sunburst visualization or a regular grid view. This helps us answer questions like what were my users doing right before they quit the site?

select  last(path_to_string(path),2) as path, count(*) as count
from cooladata
where date_range(context)
	and filters(context)
	and path_count()>5
	and path_count >= 2
cluster path by session
group by path
order by count desc  
Limit 10
Behavioral Segmentation
Behavioral
Path Analysis

Use a session path to take the last 2 (or any other N events) that immediately precede the session’s end. Make sure to ask for sessions with more than 5 events in the path. Use either the sunburst visualization or a regular grid view. This helps us answer questions like what were my users doing right before they quit the site?

select  last(path_to_string(path),2) as path, count(*) as count
from cooladata
where date_range(context)
	and filters(context)
	and path_count()>5
	and path_count >= 2
cluster path by session
group by path
order by count desc  
Limit 10
Behavioral Segmentation
Behavioral
Path Analysis

Use a session path to take the last 2 (or any other N events) that immediately precede the session’s end. Make sure to ask for sessions with more than 5 events in the path. Use either the sunburst visualization or a regular grid view. This helps us answer questions like what were my users doing right before they quit the site?

select  last(path_to_string(path),2) as path, count(*) as count
from cooladata
where date_range(context)
	and filters(context)
	and path_count()>5
	and path_count >= 2
cluster path by session
group by path
order by count desc  
Limit 10
Behavioral Segmentation
Behavioral
Path Analysis

We use CoolaData’s session path to and take only the first 3 events from it. We filter by is_new =1 to only get that user’s first session ever in the app/site.

select  first(path_to_string(path),3) as path, count(*) as count
from cooladata
where date_range(context)
	and filters(context)
	and path_count()>5
cluster path by session
group by path
order by count desc  
Limit 10
Behavioral Segmentation
Behavioral