Customer Journey and Path Analysis

Customer journey and path analysis focuses on understanding the sequence of actions users take as they move through a product. Instead of looking at individual events in isolation, this analysis examines how users progress from one step to another, such as from login to feature usage to purchase.

Each user journey is made up of multiple events that occur over time within sessions. By analyzing these sequences, businesses can understand common paths users take, identify friction points, and improve the overall user experience.

Path analysis helps answer questions such as what users do first, what actions follow, and where they stop or drop off. It provides insights into how users navigate the product and how different actions are connected.

For beginners, the goal is to:

• Understand what a customer journey represents
• Identify sequences of user actions
• Recognize how events form a path
• Learn how to analyze user behavior step by step

• The order of events performed by users
• Common paths users take within sessions
• How users move from one action to another
• Patterns in user navigation

---

The Basic Pattern

SELECT column_name
FROM table_name;
  

---

Examples

Example 1 — View Events in Order for Each User

Example 2 — View Events Within Each Session

Example 3 — Count Events per Session

---

Practice Tasks (Your Turn!)

Task 1

Find the number of sessions per user ordered from highest to lowest.

Task 2

View all sessions sorted by session start time.

Task 3

Find the number of orders per order status.