Clickstream Pipeline: Requirements and Data Model

A news reading app has 1.5 million readers on an average day, and each reader opens about 6 articles, which makes 9 million article views a day. While an article is on screen, the app sends an article_open event, a heartbeat event every 15 seconds, a scroll event at each quarter of the page the reader reaches, and an article_close event. An average view lasts about 75 seconds and reaches half the page, so it sends 1 + 5 + 2 + 1 = 9 events.

Views therefore produce 9 x 9 = 81 million events a day. App opens, searches, and shares add about 9 million more, for 90 million in total