Marketing dashboard · 2024

Flexcube Ads Cost Report

One view of Google, Bing and Pinterest ad spend across Switzerland and Germany, built to stop budget overruns and speed up ROI checks.

Looker StudioGoogle Analytics
Flexcube Ads Cost Report

Context

Advertising spend across various digital channels was being tracked manually, leading to inconsistent ROI analysis and budget overruns.

The question

How can we consolidate advertising cost data into a single view that allows for real-time ROI optimisation and budget management?

Approach

  1. 1Automated the ingestion of marketing spend data from multiple ad platforms and Google Analytics.
  2. 2Built a consolidated view of cost per acquisition (CPA) across all active campaigns.
  3. 3Implemented threshold alerts to notify the marketing team of budget overruns.

Outcome

  • Reduced marketing waste by providing immediate visibility into underperforming ad sets.
  • Streamlined the monthly reporting process from days to minutes.

More case studies

Fintech Customer Support Dashboard

Operations dashboard

Fintech Customer Support Dashboard

SupplyChain360 Unified Data Platform

Data engineering capstone

SupplyChain360 Unified Data Platform

President Tinubu Travel Tracker

Live tracker · The ICIR

President Tinubu Travel Tracker