GROUP_PATH
Syntax
GROUP_PATH(<any>)
Description
Displays the path from one point to another for all values in a group. This can be used for click stream analysis.
This is a group series function.
Example
This example is a simple click stream analysis that displays the path during specified sessions.
Given the following data:
session | timestamp | url |
---|---|---|
session1 | 2 | url1 |
session1 | 3 | url1 |
session1 | 4 | url2 |
session2 | 5 | url1 |
session2 | 6 | url2 |
session1 | 7 | url3 |
session2 | 8 | url1 |
session1 | 9 | url2 |
session2 | 10 | url1 |
First create a group using GROUPBY(#RawData!session).
session |
---|
session1 |
session2 |
Next sort your timestamp in ascending order using GROUP_SORT_ASC(#RawData!timestamp).
session | timestamp |
---|---|
session1 | 2 |
session1 | 3 |
session1 | 4 |
session1 | 7 |
session1 | 9 |
session2 | 5 |
session2 | 6 |
session2 | 8 |
session2 | 10 |
Then use the GROUP_PATH(#RawData!url). The result shows paths for all values of the column in ascending order in relation to the GROUPBY() column.
session | timestamp | url_Path |
---|---|---|
session1 | 2 | ["external","url1"] |
session1 | 3 | ["url1","url1"] |
session1 | 4 | ["url1","url2"] |
session1 | 7 | ["url2","url3"] |
session1 | 9 | ["url3","url2"] |
session1 | 9 | ["url2","external"] |
session2 | 5 | ["external","url1"] |
session2 | 6 | ["url1","url2"] |
session2 | 8 | ["url2","url1"] |
session2 | 10 | ["url1","url1"] |
session2 | 10 | ["url1","external"] |
Also see:
- GROUP_PATH_CHANGES To filter out paths where the URL doesn't change.
- GROUPBYGAP To extract sessions from gaps in a timestamp.