Client
Digital Marketing Agency Client
Date
April 6, 2026
Services
Next.js , Google BigQuery , Windsor.ai
Our Role
Data Engineer, Business Intelligence Developer
Highlights
- Developed a comprehensive client performance dashboard for a digital marketing agency tracking revenue, ad spend, and ROAS across 20 active clients.
- Enabled real-time visibility into Facebook and Google Ads performance with client-level and platform-level breakdowns.
- Provided granular insights into FB ROAS, Google ROAS, total cost, MER, and status indicators (Stable / At Risk) per client.
- Built interactive views with filtering, search, and segmentation (All Clients, Needs Attention, Top Performers) for efficient portfolio management.
- Integrated BigQuery as the data backend with utility and status logic layers powering dynamic data rendering.
- Designed and implemented the end-to-end data architecture covering source ingestion, Windsor.ai pipeline setup, BigQuery warehousing, custom dashboard delivery, and Cloud Run deployment.
KPIs & Metrics Tracked
- Total Revenue & Revenue Change %
- Total Ad Spend (Facebook + Google)
- Average MER (Marketing Efficiency Ratio)
- Average FB ROAS & Google ROAS
- Per-Client FB Cost, FB ROAS, Google Cost, Google ROAS
- Total Cost per Client
- Client Status (Stable / At Risk / Top Performer)
- Active Client Count
