Clickstream Analytics Pipeline for E-Commerce Web Traffic
Every page view, add-to-cart, and video play on a busy e-commerce or media site is a signal, but by the time traditional batch reports surface those signals the campaign is over or the customer is gone. Product and marketing teams need to see traffic behavior within seconds so they can react to spikes, broken funnels, and trending content while it still matters.
The intern builds a complete real-time clickstream system in Python. Web server logs flow into Kafka topics that absorb traffic bursts without dropping events, and Spark Streaming jobs parse, sessionize, and aggregate the stream, computing metrics like page views per minute, conversion funnels, and top content over sliding windows. Processed results are written to Hive tables for durable, queryable history, Presto provides low-latency ad-hoc SQL across it all, and a dashboard visualizes live traffic so non-technical stakeholders can watch the site breathe.
The project teaches the ingestion-processing-serving pattern used by real analytics teams: partitioning Kafka topics, managing streaming state, designing Hive schemas for time-series events, and exposing insight through both SQL and visualization.