work / marketing-performance-dashboard
Five marketing platforms, one Power BI dashboard.
- Area
- Marketing performance
- Client
- Not disclosed
- Period covered
- Jan 2024 to May 2025
- Tool
- Microsoft Power BI
- Published
- May 2025
01The problem
Marketing results spread across five platforms.
Leads, spend, and conversions lived in Meta, Google, Nextdoor, Mailchimp, and Google Business Profile, each with its own numbers and its own screen. The goal: one interactive dashboard, designed for clarity and actionable insights.
Select a screenshot to enlarge.
02Architecture
Before and after.
Before
Ad platformsMeta · Google · Nextdoor
Email and localMailchimp · Google Business Profile
Translation
Power BI modelJan 2024 to May 2025
After
One dashboardKPIs · year over year · close ratio
03Decisions
The same KPIs for every platform
Leads, impressions, spend, CTR, conversion rate, and cost per lead, side by side, so platforms can be compared on equal terms.
Year-over-year and close ratio
Every KPI comes with its year-over-year trend, plus a close-ratio analysis of amount proposed versus accepted.
Platform-specific metrics where they matter
Clicks, conversions, calls, and subscribers, each from the platform that measures it.
Filter by time, source, and campaign
The whole dashboard filters by period, ad source, and campaign, with monthly or other time granularity.
04Stack
Power BIMetaGoogleNextdoorMailchimpGoogle Business Profile
Next step