Design a clickstream events table for web analytics

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

Domain

Data Modeling

Difficulty

medium

Problem

Design a clickstream events table for web analytics. Track user page views with session_id, user_id, page_url, referrer, timestamp, and device info. This is a high-volume append-only table.

Practice This Problem

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