Clickstream De-normalization

abandonedcart

Client Challenges

Project Scope

Our client is a US E-Commerce company who wanted to perform analytics on the clickstream data in real time and ad hoc.

Solution

Big Data layer

Datametica built a foundational big data layer to enable analytics on the clickstream data. The data is ingested in real time. Then the data is cleansed and a single unified and denormalized layer is built using different lookup tables and files. This denormalized layer is accessed to carry out analytics.

Benefits

time-1
Real-time

Delivers summaries in real time

 

 

tracking
Streaming data analytics

Ability to run analytics on streaming data

 

 

mail
Relevant recommendations

Able to send relevant and targeted recommendations to customers

 

 

growth
Increased E-Commerce sales
Top