Clickstream and Session Schema

A medium Data Modeling interview practice problem on DataDriven. Write and execute real data modeling code with instant grading.

Domain

Data Modeling

Difficulty

medium

Seniority

L5

Problem

We run a large e-commerce site with web and mobile apps. We capture every click, page view, and product interaction as raw events. Users browse from multiple devices, and we need to stitch their activity into sessions and build a complete picture of the purchase journey. We get about 600 million events per day. Design the data model.

Summary

Millions of clicks, mostly anonymous.

Practice This Problem

Solve this Data Modeling problem with real code execution. DataDriven runs your solution and grades it automatically.