الطلب
“An e-commerce clickstream star schema with ClickstreamFact linked to Date, User, Product, Referrer, and Page dimensions, storing session, click, time spent and bounce data.”
جرّب إذنAdd a campaign dimensionAdd an order conversion measure
ما الذي يتضمنه هذا الرسم
اقرأ القرارات الكامنة وراءه.
01
Fact table grain is one click event per row
02
Dimensions include Date, User, Product, Referrer, Page
03
Measures include click count and time spent
When building an analytics warehouse for web traffic and user behavior.