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
  1. 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.

  2. 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.

  3. Platform-specific metrics where they matter

    Clicks, conversions, calls, and subscribers, each from the platform that measures it.

  4. 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

Is your marketing data spread across platforms? Let's talk.