Switching from Excel File Chase into Unified, Effective Data Segmentation
Before
When we started, the company operated at massive global scale (80+ Markets | ~$20B+ Annual Revenue), yet commercially it lacked a unified decision layer. There was no standardized customer segmentation across markets. Reporting was fragmented and heavily manual. Performance analysis required chasing teams for data and reconciling conflicting Excel files.
Leadership (the board, CEO, CMO, Global Brand Director, Controlling Director) could see revenue totals, but not consistently understand who was buying, where, why, and what impact marketing activities actually had.
Major global events and campaigns were executed without a structured framework to measure post-event commercial impact across segments, regions, or time. Decisions were reactive rather than systematically data-guided.
What We Did
We designed and implemented a centralized global performance framework covering all markets worldwide, across online and offline channels.
We consolidated more than 20 data sources (non-standardized revenue data coming from online and offline channels, different countries, geodemographics, assorted excel files, etc) into a single commercial view and built the company's first standardized global customer segmentation model, based on socio-demographic profiling. All this was implemented as a centralized analytics foundation in GCP (BigQuery): a data warehouse plus automated ETL pipelines to ingest, transform, and publish curated datasets into PowerBI.
There had been no formal segmentation before. By the end of the engagement, the entire organization, from marketing to finance, was speaking in segments using the model we established.
Executive Visibility Architecture
We built executive performance visibility across:
- Country and city level
- Channel (online/offline)
- Age and gender
- Customer segment
- Post-campaign sales impact over time
We also created a structured budget allocation and scenario-planning framework based on linear optimization (SciPy optimization → PowerBI scenario interface), enabling leadership to simulate marketing spend distribution across countries, channels, and departments before committing capital.
On top of reporting, we prototyped incrementality / attribution capability for major marketing initiatives using MMM (Marketing Mix Modeling).
After
The organization moved from fragmented reporting to a unified commercial intelligence system covering every global market. Reporting shifted from manual weekly Excel consolidation to automated daily visibility across 80+ markets.
But the real change was how different teams operated:
Finance
Gained daily visibility into revenue by country, channel, city, age, gender, and customer segment. Reduced time spent reconciling reports and validating numbers. Improved monitoring of marketing spend efficiency and margin contribution. Shifted from backward-looking summaries to ongoing performance oversight.
Marketing
Could measure post-campaign sales impact over defined time windows (e.g., 7–30 days after global events). Compared segment-level performance across markets in real time. Identified which demographic clusters responded to which initiatives. Used structured budget allocation scenarios instead of intuition.
Executive Leadership
CFO, CEO, CMO, and Board received a helicopter view across all global markets in one system. Saw performance broken down by more than 10 segmentation parameters (including geography, channel, age, gender, socio-demographic profile, and behavioral characteristics). Made allocation decisions based on structured commercial visibility instead of partial regional reporting.
What This Enabled
For the first time, leadership could:
- Quantify the sales impact of global campaigns and brand events across segments and markets
- Identify which customer clusters drove incremental revenue
- Reallocate marketing budgets between countries and channels based on modeled scenarios
- Monitor daily performance instead of waiting for end-of-week summaries
Instead of different departments working from different Excel files, the organization operated from a shared performance framework: the same segmentation logic, the same revenue definitions, and the same numbers. Finance and marketing stopped debating whose report was correct. They worked from one version of the truth.
Business Context (2024–2025)
Throughout 2024–2025, the company publicly emphasized stronger cost discipline, marketing investment effectiveness, improved gross margins, and operational efficiency. The commercial intelligence framework implemented during this period enabled tighter capital allocation oversight and clearer visibility into segment-driven performance, supporting the organization's shift toward more disciplined, performance-oriented decision-making at global scale.
Executive Takeaway
This was not a reporting project. It was a structural shift from revenue tracking to decision-grade commercial intelligence at global scale. By introducing standardized segmentation, consolidated data visibility, and structured allocation logic, we enabled executive leadership to manage marketing and commercial performance with clarity, across every market worldwide.