Fast-growing eCommerce brand (anonymized)
Ecommerce Data Foundation for Digital-Native Brand
One source of truth across Shopify, Ads, and Odoo — unified margin visibility for the first time.
The starting point
A fast-growing eCommerce brand had data everywhere and answers nowhere. Shopify, Google and Meta Ads, and Odoo ERP didn’t talk to each other; the COO rebuilt weekly reports by hand from three CSV exports, and margin was wrong because Shopify revenue ignored Odoo’s landed costs. A data audit surfaced four different definitions of ‘margin’ across the org.
The method
We built the foundation on Fivetran → Snowflake → dbt: staging and intermediate models reconciling orders across platforms into one unified order model, then marts for sales, marketing ROI (true ROAS net of landed cost), and inventory health. A SKU-level margin model tied Shopify revenue to Odoo COGS, and automated dbt tests flagged join mismatches before they ever reached a dashboard.
The result
Weekly reporting went from a full day of spreadsheets to opening a dashboard. The margin model revealed 3 of their top-10 revenue SKUs were margin-negative after landed cost and returns — reshaping pricing and promotions. A new sales channel later took 2 days to integrate instead of weeks, and new hires now self-serve instead of asking the COO to pull numbers.