Built an automated marketing dashboard using Looker Studio, BigQuery, and custom API integrations.
DailyAuto-refresh
SQLQuery layer
Manual monthly reporting replaced with a dashboard that refreshes itself: raw event data lands in BigQuery, a set of SQL views does the heavy lifting, and Looker Studio just renders what's already been calculated correctly.