Analytical data warehouse and dashboards for Ash
About the client
The ASH brand is the creative partnership of French shoe designer Patrick Ithier and Italian entrepreneur Leonello Calvani, two outstanding figures in the footwear industry. Founded in 2000 in Italy, the brand quickly gained worldwide popularity, becoming a trendsetter for the most experimental styles.
The task
Build a unified reporting system for online marketing and sales on top of a BI platform, serving both specialists and department heads.
Goals
- →Integrate data from website and app analytics, Ozon, and other sources
- →Create dashboards for sales control and online marketing
What was built
- 01
Integration with the accounting system
An API service was implemented in Python to receive data from the accounting system. The service transforms the data and stores it in ClickHouse for use in the dashboards .
- 02
Exporting website and app analytics
Connectors were created for Yandex Metrica and AppMetrica (Russian analytics platforms), which export website and app user statistics into ClickHouse.
- 03
Collecting campaign statistics
An integration with the Mindbox service was set up to collect mailing campaign statistics in ClickHouse and to build dashboards on campaigns.
- 04
Instagram and Telegram
Scripts were developed to scrape a service that works with the Telegram channel and the Instagram account, collecting social media statistics and surfacing them on a dashboard.
- 05
Ozon order data
A daily load of Ozon order data into the DWH was set up to build dashboards.
- 06
Building dashboards
Interactive BI dashboards were created for the commercial director and the marketing department.
Result
Connectors were built for the main required data sources. Monitoring of their operation was set up with notifications to Telegram. Connecting new sources and creating dashboards based on their data is ongoing.