The challenge
An electronics brand with sales across 6 channels (D2C, Amazon, retail, distributors, B2B, MercadoLibre) had completely siloed data. Could not calculate real customer LTV or correctly attribute marketing investments.
The solution
We built a centralized data lake on BigQuery with real-time ingestion from all channels, a custom multi-touch attribution model, and executive dashboards for LTV, real ROAS, and demand forecasting by SKU and region.