Automated Ads Reporting Pipeline

Hey everyone! :wave: Coming from my background in Performance Marketing, one of the biggest frustrations has always been jumping between multiple ad platform dashboards (Google Ads, Meta Ads, TikTok Ads, LinkedIn Ads) and manually downloading CSVs just to see the *whole channel performance* in one place. So I built this project: *Automated Ads Reporting Suite* A fully automated data pipeline that consolidates, transforms, and visualizes digital advertising performance data across multiple platforms. *How it works:* • Ingests raw campaign data from a *Kaggle dataset* (not live APIs) • Transforms & standardizes data across all platforms • Loads everything into *Google BigQuery* • Visualizes it in a clean executive dashboard using *Looker Studio* Built end-to-end with *Bruin* for pipeline orchestration and Google BigQuery as the data warehouse. *View Live Dashboard* → https://lookerstudio.google.com/u/0/reporting/e9ac6c38-c7ab-45b9-af8a-61c94bda8a97/page/KXarF *GitHub Repository*: Would love your feedback or any questions — feel free to drop them in the thread! Thanks!