CLIENT CASE STUDY
Getting a handle on sales channel performance
STOX Energy Socks had built a fast-growing multi-channel business, but without a solid data platform, keeping track of performance across channels and countries was becoming unmanageable.
CLIENT
STOX Energy Socks
INDUSTRY
E-commerce
SERVICE
Financial & Operational Analytics
Stack
Python, BigQuery, dbt, Looker
MARKET
Europe, Middle East
THE CHALLENGE
Managing five channels by hand. Slow and unreliable.
STOX Energy Socks had built a solid multi-channel business. Selling compression socks via their own webshop, multiple online marketplaces, and a B2B channel across more than ten countries. But their reporting hadn't kept up.
Key financial metrics such as contribution margin by sales channel, gross margin by country, and the revenue split between new and returning customers were managed in Excel. Data had to be manually extracted from multiple source systems and stitched together. Comparing actual performance against the business plan was equally time-consuming and always slightly out of date.
Stock management was another challenge. Without reliable visibility into inventory trends, the team had no way to anticipate shortages and was forced to rely on intuition instead of data.
WHAT WE DID
Connect everything, start delivering, build from there
We agreed on a clear goal upfront: an automated breakdown of contribution margin per sales channel and country, and reliable stock level monitoring to prevent shortages. Everything else was secondary.
We connected source systems one at a time by using a modular approach which lead to the first reports being ready within several weeks. That quick access allowed STOX to give detailed feedback as we built, which improved the quality of everything that followed.
Analyses that previously required hours of work, manual downloads from different systems or weren't even possible due to the sheer data volume, are now available at a glance. This enabled end users to gain a much better understanding behind the main drivers for revenue, profitability and customer behavior.
THE RESULTS
Data that finance and operations can use to optimize their business
€100k
saved through improved insight into price discounts
2x
fewer stock outs and daily updated insights in stock levels across warehouses
5x
faster financial reporting across all channels