Paid Media Performance Dashboard
The month-end numbers land on a Monday. Meta says its ads returned 5x. Google says 4x. The finance lead adds up the revenue both platforms claim and gets a bigger number than the store took all month. Both ad accounts are glowing green, and sales are where they were in the spring.
That gap is built into how paid media is bought and sold. US internet advertising revenue reached $294.6 billion in 2025, up 13.9%, according to the IAB and PwC. Search took $114.2 billion and social $117.7 billion. The same report puts 84.1% of that revenue with the 10 largest companies, the platforms that also supply the measurement advertisers use to judge them. It notes that advertisers are putting more weight on proving incrementality, not reach alone.
For brands that sell online, the stakes keep rising. E-commerce made up 17.1% of US retail sales in the second quarter of 2026, up from 16.3% a year earlier, on Census Bureau figures. More of the market is online, so more of the budget goes to platforms that score their own ads.
This page follows an invented direct-to-consumer brand through two years of paid media on Google and Meta. It isn't a customer, and every monthly figure is modeled. None of the ten targets below has a published benchmark behind it, because ad costs swing too far by product and season for a cross-industry figure to mean much.
What is an Advertising KPI Dashboard?
Overview
An advertising KPI dashboard puts what the ad platforms report next to what the business actually took, so you can tell whether paid media is creating sales or just claiming them.
The board follows a dollar through the auction. Ad spend vs budget shows whether the month is pacing to plan. CPM is what a thousand impressions cost, and it's set mostly by competition, which is why it tends to climb in the weeks before the holidays. Click-through rate shows whether the ad earns a click once it's seen, and cost per click combines the two. Meta ad frequency shows how often the same person sees the same ads, the earliest sign of tired creative or a shrinking audience.
After the click comes the sale. Ad conversion rate is purchases per click, and cost per acquisition is spend per purchase. Return on ad spend divides attributed revenue by spend, and it's the figure most paid teams are judged on.
The last two are there to keep ROAS in check. Marketing efficiency ratio divides total store revenue by total ad spend, with no attribution at all. New customer share shows how much of what the ads claim came from people who had never bought before. When ROAS rises and those two fall, the ads are mostly being credited for repeat customers who would have bought anyway.
Who benefits from this dashboard?
- Paid media manager: CTR, CPC, frequency and CPA by platform make up the weekly to-do list: which ads to replace, which audiences have gone stale, which campaigns to cap.
- Head of growth or CMO: MER and new customer share answer the board's real question. It isn't "what was ROAS?" but "did the ad budget grow the customer base?"
- Finance lead: Spend vs budget keeps the month honest, and MER is the one efficiency figure that reconciles to the revenue in the books.
- Founder: Reads ROAS beside MER every month, and if the two drift apart, wants to know why before approving next quarter's budget.
- Agency account lead: Showing a client MER and new customer share next to platform ROAS is how you keep the account when the platform numbers and the client's sales disagree.
Never let a branded search or retargeting campaign set the ROAS target for the account. Those campaigns reach people who already know you, so their ROAS is always the highest on the board. Report them on their own line, or a blended figure will hide how expensive new customers really are.
Dashboard Example Overview
The brand sells sheets, duvet covers and pillows from its own website, with a little over $20 million a year in sales, shipped from one warehouse. It spends $500,000 to $880,000 a month on Google (Search, Shopping and YouTube) and Meta (Facebook and Instagram), run by a two-person in-house team. Its big months are Black Friday through Cyber Monday and the January white sale. Ten KPIs, reported monthly:
- Ad Spend vs Budget: Actual Google and Meta spend divided by the month's approved budget. Anything from 95% to 100% is on plan. Over 100% usually means someone raised a daily budget and nobody lowered it.
- Cost per Thousand Impressions (CPM): Spend divided by impressions, times 1,000. The auction sets most of it, not the team, so read it for season and competition.
- Click-Through Rate (CTR): Clicks divided by impressions, the way Google Ads defines it. Blended across both platforms, so search lifts it and social pulls it down.
- Cost Per Click (CPC): Spend divided by clicks. It's CPM divided by CTR in disguise, so check which of the two moved before you react.
- Ad Frequency: Meta impressions divided by Meta reach over the month. A rising figure means the same people keep seeing the same ads.
- Ad Conversion Rate: Platform-reported purchases divided by ad clicks. It rises when ads chase warm audiences and falls when they find new ones.
- Cost Per Acquisition (CPA): Spend divided by platform-reported purchases. Its blind spot: it costs the same whether the buyer is new or has ordered three times before.
- Return on Ad Spend (ROAS): Attributed revenue divided by spend. Until May 2025 this company used the platforms' own figures. From June 2025 it multiplies them by the incremental share its latest holdout test found.
- Marketing Efficiency Ratio (MER): Total store revenue from every channel divided by total ad spend. No attribution, no double counting.
- New Customer Share of Ad Purchases: Ad-attributed purchases by people with no earlier order on the customer list, divided by all ad-attributed purchases. Google's customer acquisition goals work from the same idea: a customer list that tells the platform who has bought before.
In October 2024, ROAS is 3.51 and MER 3.30, a gap small enough that nobody asks about it. New customers make up 46.0% of ad purchases, and Meta frequency is 2.6.
November costs more than planned. CPM jumps to $25.68 around Black Friday, and spend finishes at 107.0% of budget after daily caps were raised for Cyber Monday and left there.
Then ROAS starts to climb. The automated campaigns drift toward people who have visited the site or bought before, because those people convert. Branded search grows too. ROAS reaches 4.50 in the January white sale and 4.65 in May 2025. Conversion rate is 3.71%, CPA has fallen to $35.69 and CTR is up to 1.59%. Apart from CPM, every cost and response KPI on the board is beating its target.
Three other KPIs have been red since the winter, and it's April before anyone asks why. By May 2025 MER is down to 3.08, below its 3.5 target, while ROAS sits at 4.65. Frequency has climbed to 4.4, and new customer share has fallen to 31.3%. The platforms are claiming more revenue than the store took, and most of what they claim comes from existing customers.
So across April and May 2025 the company tests it. On Meta, a random slice of the audience is held back from seeing the ads. Branded search and retargeting are switched off in a set of matched states for six weeks. Google offers the same kind of test as Conversion Lift, comparing people who saw the ads with people who didn't. About half the purchases the platforms had claimed turn out to be incremental. Retargeting and branded search come out weakest.
From June 2025 the board's ROAS is the incremental figure, refreshed after each quarterly test. The chart steps down from 4.65 in May to 2.26 in June. The ads were the same in both months. The drop is the test result, applied to the series.
In July the team acts on what the test found. Retargeting is capped at a small slice of spend, and existing customers are excluded from prospecting campaigns. Branded search bids are cut back, and new creative goes live every three weeks. ROAS gets worse before it gets better, bottoming out at 1.92 in September 2025. CPA rises to $49.42 that month and conversion rate falls to 2.86%, because cold audiences convert less often than people who already own your sheets. By October, frequency is down to 2.5 and new customer share has passed 50% for the first time, at 52.0%.
The holidays are the hard part. Prospecting through the most expensive weeks of the year, without cheap retargeting sales to prop it up, sends CPA to $57.15 in November 2025 at a CPM of $23.15. MER comes in at 2.89, below the 3.03 of the November before, and the January white sale finishes at 3.49 against 3.55. For three months the new approach looks like the wrong call, and the board says so.
Then the customers won in the autumn start ordering again. MER beats the prior year in February 2026, 3.52 against 3.19, its first month over the 3.5 target since January 2025, and reaches 3.77 in March. By September 2026, ROAS is 2.98 on the incremental basis and MER is 3.90, against 2.97 a year earlier. New customers make up 55.1% of ad purchases. CPA is $48.18, still well above the $35.69 of May 2025, and it isn't coming back down. That's the price of paying for customers the business didn't already have.
Creating an Advertising Dashboard in SimpleKPI
-
Step 1 Pick the attribution basis for ROAS and label it
Platform-reported, last-click from your analytics tool, or incremental from a holdout test: each gives a different ROAS for the same month, and in this example the gap was roughly two to one. Choose one and write it into the KPI description. If you switch, report the old and new figures side by side for a quarter, so the step has a visible cause.
The guide to choosing KPIs covers settling definitions like this before you set targets.
-
Step 2 Count revenue and new customers in the store's own records
Spend, impressions, clicks and frequency come from Google Ads and Meta Ads Manager. Total revenue for MER comes from the store or the accounting ledger, net of refunds. Whether a buyer is new comes from your own customer list. If the platform decides who counts as new, you're back to letting it mark its own homework.
-
Step 3 Tag branded search and retargeting apart from prospecting
Label every campaign as brand, retargeting or prospecting before it goes on the board. Blended CPA and ROAS mix the cheapest sales in the account with the hardest ones, so moving budget between them shifts the averages even when no campaign got better or worse.
-
Step 4 Bring new customer share to every CPA conversation
In the weekly paid media review, read CPA and ROAS with new customer share beside them. In the monthly budget meeting, lead with MER and spend vs budget. A falling CPA alongside a falling new customer share isn't a win. It usually means the ads have gone back to chasing existing buyers.
-
Step 5 Set Black Friday targets apart from the rest of the year
CPM and CPA rise every November for reasons the team can't control. Give those two their own holiday-season targets, and compare each holiday month with the same month last year, not with October.
List of Advertising KPIs
None of these ten has a published cross-industry benchmark worth copying. Google's own help center says a good CTR depends on what you advertise and on which networks. Every target here is a (starting point), to be replaced once you have twelve months of your own data.
| KPI Name | Typical Target | Description / Calculation |
|---|---|---|
| Ad Spend vs Budget | 95% to 100% (starting point) | Actual paid media spend divided by the month's approved budget. |
| Cost per Thousand Impressions (CPM) | ≤ $19 (starting point) | Ad spend divided by impressions, times 1,000. Lower is better. Set a separate holiday target. |
| Click-Through Rate (CTR) | ≥ 1.3% blended (starting point) | Clicks divided by impressions. Search runs higher than social, so watch the mix. |
| Cost Per Click (CPC) | ≤ $1.40 (starting point) | Ad spend divided by clicks. Lower is better. |
| Ad Frequency | ≤ 3.0 a month (starting point) | Meta impressions divided by Meta reach over the month. Lower is better. |
| Ad Conversion Rate | ≥ 2.8% (starting point) | Platform-reported purchases divided by ad clicks. |
| Cost Per Acquisition (CPA) | ≤ $50 (starting point) | Ad spend divided by platform-reported purchases. Lower is better. |
| Return on Ad Spend (ROAS) | ≥ 2.8x incremental (starting point) | Attributed revenue divided by ad spend. State the attribution basis. |
| Marketing Efficiency Ratio (MER) | ≥ 3.5x (starting point) | Total store revenue from all channels divided by total paid media spend. |
| New Customer Share of Ad Purchases | ≥ 50% (starting point) | Ad-attributed purchases by first-time customers divided by all ad-attributed purchases. |
Want a wider set to choose from? The 28 marketing KPIs guide covers paid social, search and email measures beyond the ten here. If your sales close through a sales team rather than a checkout, the marketing dashboard example follows cost per SQL and pipeline instead. For the store side of the same customer, see the e-commerce dashboard example.
Why Advertising Dashboards Matter
Each ad platform writes its own report card. Meta's ROAS is measured by Meta, and Google's by Google. Each one optimizes for the conversions it can see and claim, and the cheapest of those come from people already on their way to buy.
That's why the KPIs on this board pull against each other. Push CPA down and the campaigns drift toward warm audiences, so new customer share falls with it. Bring frequency down by widening the audience and conversion rate drops, because strangers buy less often than past customers. Cut branded search and platform ROAS falls, even if MER barely moves. A paid team can make almost any one of these look good by quietly giving up another.
The pair that settles most arguments is ROAS and MER on the same chart. When they move together, the platforms are probably reporting something real. When ROAS climbs and MER doesn't, as it did here from October 2024 to May 2025, the ads are collecting credit for sales that would have happened without them.
So before you raise next quarter's budget on a strong ROAS, switch the ads off somewhere for a few weeks: a handful of states, or a random holdout group on Meta. The test costs a few weeks of sales in the held-out regions. Budgeting on the wrong number can cost a year of them.
Building it in SimpleKPI
Build this dashboard yourself with SimpleKPI's KPI dashboards, or start from the Marketing KPIs template. The mechanics are the same whatever you track:
- KPIs: each one gets a target, an entry frequency and tags, so you can report by team, site, product or whatever you split the numbers by.
- Data: type numbers in, import a spreadsheet, or use an integration or the API. The dashboard updates as each number lands, so daily and monthly KPIs sit side by side.
- Reports: scheduled KPI reports email the numbers to people who never log in.
- AI: Kip, the built-in AI, suggests targets and flags indicative benchmarks (AI estimates, not peer data) once some history builds up.
- Price: $79 a month for unlimited users and KPIs, as one flat price, with a 14-day free trial and no card needed.
