Skip to main content
Case Study

ADA helped a global retailer get a holistic view of their online business by consolidating their data on Amazon Redshift

Segment

Retail

The Results

Understand the impact of clickstream data on revenue.
Consolidated transaction and clickstream data for further data analysis.

The Execution

The customer is a leading global sporting goods retailer with a footprint in 56 countries and selling products from over 20 brands.

The customer needed E-Commerce Digital Performance Dashboards to provide insights into its rapidly expanding e-commerce business. However, its transactional and clickstream customer interaction data were located in separate data silos, hampering a consolidated view of its data.

ADA helped migrate the customer’s clickstream data from GCP BigQuery and consolidated it with its transactional data on AWS Redshift. We merged session-level data with revenue data to create a holistic analytics dataset. ADA then built AWS QuickSight dashboards to provide:

Table Of Contents
The Results
The Execution

Explore More Resources on Commerce Personalization

Wine.com Drives AttributeBased Recommendations for Personalization
Food & Beverage US

Wine.com Drives AttributeBased Recommendations for Personalization

See full story
0 %
Reduction in out-of-stock across stores
0 %
increase in revenue

Let’s turn your data and AI into measurable outcomes!