2025
Meta Ads Dashboard
Meta Ads performance data is noisy. CPR looks good on a low-spend campaign and terrible on a high-spend one. You need context to compare them. I built a Power BI dashboard that covers all the main KPIs and adds a Unified Performance Score that normalises CPR across total spend, so you can actually rank campaigns fairly.
The problem
Raw Meta Ads data gives you numbers, not answers. A campaign with a low CPR might have almost no spend behind it. You cannot trust that number the same way you trust a result from a campaign that ran for weeks. Comparing campaigns without accounting for spend is comparing apples to guesses.
What I built
A Power BI dashboard covering the key Meta Ads metrics: CPR (Cost Per Result), Reach, Reach-to-Impressions ratio, Cost Per Reach, Total Spend, and Video Plays. The layout gives a clear overview at the top, then breaks down performance by campaign and time period.
The Unified Performance Score
The standout calculation is the Unified Performance Score. It takes CPR (which already measures efficiency) and normalises it against total spend. The result highlights campaigns where the good CPR is backed by real volume. Low CPR on a €5 campaign is noise. Low CPR on a €500 campaign is signal. The score makes that distinction visible.