Netthandelsgruppen
Unified Shopify, QuickBooks, and marketing data into a single warehouse. Cut reporting time by 80%.
Headline outcome
+65%
ROI boost
The challenge
Where they started.
A multi-brand e-commerce group running Shopify, WooCommerce, Facebook Ads, Google Ads, TikTok Ads, and QuickBooks — none of it connected. No unified business visibility. No technical team. Reports lived in spreadsheets and Looker dashboards with no underlying pipelines. Marketing spend and commerce performance couldn't be reconciled in the same view. Every month close was manual. Every meeting started with 'which number is right?'
The approach
What we actually built.
01
Unified ingestion
Airbyte for WooCommerce and marketplaces. Custom Python on Airflow for WooCommerce REST. Automated syncs replaced the manual CSV grind.
02
Marketing unification
Hevo pipelines for Facebook Ads, Google Ads, and TikTok Ads — standardized schemas landing in the same warehouse.
03
Transformation with dbt
Modelled commerce + marketing + finance into a single source of truth. Tests on every critical metric.
04
Looker semantic layer
LookML models so every dashboard — finance, marketing, ops — pulls from the same definitions. No more spreadsheet dissent.
Results
The numbers that shifted.
+65%
ROI boost on marketing spend
80%
Reduction in reporting time
1
Source of truth, across 4 brands