I have a table which includes the following:
ID evar event_date ranking
1 landing 2019-01-01 1
1 content 2019-01-02 2
1 homepage 2019-01-03 3
2 support 2019-02-01 1
2 content 2019-02-02 2
3 content 2019-01-23 1
3 support 2019-01-24 2
etc.
I am trying to map customer journeys, so I've ranked the pages that were visited by date.
I need to find the top journeys on the website - so it needs to be at this level, but aggregated by the number of users.
For example: ID 1 made the journey landing
> content
> homepage
;
I would like to see who else made that same journey (without me manually checking)
How can I write such a query?