About the client
Unitrailer is a European leader in the sale of car trailers, parts, and accessories. The company operates in an e-commerce model and serves multiple markets simultaneously, running advertising campaigns and analytics on dozens of different accounts and platforms.
The growing scale of operations meant that the existing data processing model required process automation.
The Challenge
Unitrailer's dynamic expansion into 25 European markets generated immense data complexity.
The company had to manage a multidimensional matrix of marketing, analytical, and sales data. This included:
- - Analytical and advertising systems: Google Analytics 4, Google Ads, Meta Ads, TikTok Ads, Bing Ads, Criteo, and Google Search Console accounts.
- - E-commerce and CRM systems: The IdoSell platform, containing sales and product data from all markets and other marketplace platforms.
- - Marketplace Data: Detailed data from Allegro, including information on auction costs and sales generated within them.
In total, this amounted to nearly 100 different data sources.
The business bottleneck was analytical chaos, i.e., manual work:
The team spent a huge amount of time manually combining data from various systems just to create simple reports (e.g., a summary of marketing expenses).
💡 The Solution: WitCloud Automated Data Platform
Unitrailer needed to reduce the time required to prepare data for decision-making. To this end, they decided to implement WitCloud as a central system for automatic data integration, processing, and modeling.
- Automating 100 sources without coding: WitCloud automatically connected all 100 data sources. The entire process took place without writing code, thanks to ready-made connectors.
- Automatic transformation of chaos into ready-to-use data: WitCloud not only dumps 800 raw tables into one place, which is BigQuery, but in subsequent steps, it automatically processes the data, unifies it, and builds lightweight, small, and aggregated tables (datamarts) so that they meet business needs and are usable in visualizations. This approach also significantly lowers the costs of querying data from the database.
- One Coherent Report: Everything was made available in one coherent report located in Looker Studio, giving a full picture of the business.
- Infrastructure "on autopilot": The entire process runs fully automatically, 24/7, from data downloading, through error monitoring, to infrastructure maintenance.
Results
1. Reduction of analytics costs and business decisions in seconds, not days
Reports that previously required hours of manual combination of xls sheets (e.g., summary of marketing expenses, Google Analytics 4 data, or sales from CRM for all markets) are now executed in a few seconds. Data is always ready "at hand" for all markets.
2. Full Cross-Market Product Analysis
The company gained the instant ability to analyze the entire product offer and sales (from IdoSell, Allegro, and other systems) in one place. This allows for strategic decisions regarding the assortment in individual markets.
3. Team Focused on Growth, Not on "Putting Out Fires"
When a company stops wasting time asking "How much was it?" and starts discussing "What do we do next?" – it is a sign that it has moved from chaos to strategy. Specialists and analysts stop being data "gatekeepers" and become strategic partners for the business.
4. Foundation for AI ready immediately
Instead of heavy tables, lightweight, optimized, and organized datasets were created, which are ready to be used by AI models.
Client Opinion
“We can't live without this data”
Summary
Thanks to WitCloud, Unitrailer transitioned from a dispersed, expensive, and hard-to-maintain data ecosystem to a modern infrastructure:
- - fully automated reports available on demand, not on order
- - cost-optimized processes,
- - data ready for prompting with AI models
This is not just ordinary "reporting" — it is a data platform supporting expansion and rapid business decisions.