Marketing 360 Dashboard
The situation
The client was running hundreds of marketing campaigns across dozens of channels. They asked for a single marketing dashboard that would let them assess and compare performance, and analyse what worked best by destination, market, audience, channel, ad and campaign type.
The opportunity
Because the brief was clear, there was no time lost translating requirements. We could focus on execution and give the client a 360 degree understanding of their marketing efforts.
How we made it happen
We consolidated advertising data into Google BigQuery and built the dashboard in Power BI. The dashboard was structured around the client’s questions, making it easy to compare campaigns and spot themes across markets, destinations and audiences.
What changed
- A single view of marketing performance across channels and campaigns
- Fast comparison of results by destination, market and target audience
- Clear visibility of which channels, ads and campaign types performed best
- ROAS improved by over 10% using insights from the dashboard
Why it matters
The dashboard gave the client a consistent way to focus spend on what works, across a complex portfolio of campaigns.
Data Sources
- Google Ads
- Meta Ads
- Google Analytics
- Campaign Manager 360
- SA 360
- Media Tool