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
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
I would like to see who else made that same journey (without me manually checking)
How can I write such a query?