Case study

Real-time marketing data automation, Samsung (Cheil Worldwide)

Cut manual reporting time by 70% with an automated marketing data warehouse.

Head of Data Analytics & BI · Aug 2019 – Mar 2021

  • ETL
  • BigQuery
  • Python
  • Automation

70%

reduction in manual reporting time

10TB

of data analyzed daily

Details

What happened

The problem

Marketing reporting across Samsung's regional campaigns depended on manual pulls from disconnected platforms, with stakeholders waiting on ad-hoc analysis for basic visibility into performance.

What I built

Set up a marketing data warehouse via ETL, automating data pipelines from third-party platforms using REST APIs, Python, and Google Cloud Functions. Layered on marketing channel attribution modeling and custom dashboards so stakeholders could self-serve instead of waiting on a request queue.

The outcome

Manual reporting time cut by 70%. The pipeline analyzes 10TB of data daily via scheduled SQL queries, feeding real-time dashboards in Google Data Studio and Power BI.