TapCub is live — analytics, insights and live chat, free on one platform
Analytics

PPC Dashboard: The Metrics, Formulas and Layout That Drive Decisions

What a PPC dashboard should show, with Google Ads definitions for CPC, conversion rate and ROAS, a four-campaign worked example, break-even ROAS rules and a layout you can copy.

Xu An Published Nov 20, 2026 11 min read Analytics
Sample data: break-even ROAS is 2.5 at a 40% gross margin. The blended 2.83 looks healthy, but three of the four campaigns are below break-even; brand search earns $3,960 and the others lose $2,496 between them.Sample data

A PPC dashboard is one page showing whether pay-per-click spend earns more than it costs: spend, clicks, conversions, cost per conversion and return on ad spend, broken down by campaign. The rule that makes it useful is to compare each campaign with its break-even ROAS (1 divided by gross margin), because a blended ROAS can look healthy while two thirds of the spend loses money. Below: formulas, a worked example and a layout.

What you will learn

  • Show every campaign against its break-even ROAS (1 / gross margin); a blended ROAS of 2.83 hid non-brand campaigns at 1.82 in the sample
  • Use the ad platform's own definitions for CPC, conversion rate and ROAS, and pick one primary conversion so the numbers mean one thing
  • Expect platform clicks and analytics sessions to differ (90% in the sample); choose one for the dashboard and label it

What questions should a PPC dashboard answer?

A PPC dashboard is one screen that shows whether paid search and other pay-per-click spend is producing conversions at an acceptable cost. It should answer three questions, in this order, and every metric on it should serve one of them:

  1. Are we spending as planned? Spend against budget, pace for the month.
  2. Is the spend producing results at a cost we can afford? Conversions, cost per conversion, return on ad spend.
  3. Where should we change something? Which campaign, keyword group or ad is above or below the target.

A dashboard that cannot lead to a decision (click through rate in the corner, a rainbow of line charts) is a report. For the written, periodic version see PPC reports; for how to interpret the numbers once you have them, see PPC analysis. This page is about the layout and the formulas behind it.

Which PPC metrics belong on the dashboard, and how are they calculated?

Use the platform's own definitions so your dashboard matches what the ad account reports. These are the ones Google Ads documents.

MetricFormulaGoogle Ads' own example or note
Click-through rateClicks ÷ impressionsMeasures whether the ad earns the click
Average CPCTotal cost of clicks ÷ number of clicksTwo clicks costing $0.20 and $0.40 give $0.60 ÷ 2 = $0.30 (definition)
Conversion rateConversions ÷ interactions50 conversions from 1,000 interactions is 5%; it can exceed 100% when more than one conversion is counted per interaction (definition)
Cost per conversion (CPA)Cost ÷ conversionsCost per customer action
Conversion value per cost (ROAS)Conversion value ÷ costGoogle's formula is "Conv. value / cost" (definition)
Impression shareImpressions ÷ total eligible impressionsShows whether more budget or bid could reach more people (definition)

Two cautions before you build anything:

  • Know which conversions are counted. If the account counts "every" conversion or tracks more than one conversion action, conversion rate can exceed 100% and cost per conversion changes meaning. Pick one primary conversion for the dashboard.
  • ROAS is revenue, not profit. A 3.0 ROAS can lose money on a thin margin. The next two sections show how to turn it into a go or stop rule.
MetricFormulaSample: brand search
CPCSpend / clicks$1,800 / 3,000 = $0.60
Conversion rateConversions / clicks300 / 3,000 = 10.00%
CPASpend / conversions$1,800 / 300 = $6.00
ROASRevenue / spend$14,400 / $1,800 = 8.00
Break-even ROAS1 / gross margin1 / 0.40 = 2.5

Sample data, 40% gross margin. Definitions follow Google Ads Help.

Worked example: four campaigns, one blended number that hides losers

Sample data: one month, a store with a 40% gross margin. Revenue is the conversion value from tracked purchases.

CampaignSpendClicksConversionsRevenueCPCConversion rateCPAROASProfit after ad cost
Brand search$1,8003,000300$14,400$0.6010.00%$6.008.00$3,960
Generic search$5,2004,000160$11,200$1.304.00%$32.502.15−$720
Competitor terms$2,4001,60028$1,960$1.501.75%$85.710.82−$1,616
Display remarketing$1,6003,20040$3,600$0.501.25%$40.002.25−$160
All four$11,00011,800528$31,160$0.934.47%$20.832.83$1,464

How each cell is computed: CPC = spend ÷ clicks; conversion rate = conversions ÷ clicks; CPA = spend ÷ conversions; ROAS = revenue ÷ spend; profit = revenue × 40% − spend. For brand search: 1,800 ÷ 3,000 = $0.60, 300 ÷ 3,000 = 10.00%, 1,800 ÷ 300 = $6.00, 14,400 ÷ 1,800 = 8.00, 14,400 × 0.4 − 1,800 = $3,960.

What the blended row hides:

  • The total ROAS of 2.83 looks healthy. It is above the break-even of 2.5 computed in the next section.
  • Brand search carries everything. It earned $3,960 on 16% of the spend. Without it, the other three campaigns spent $9,200 and returned $16,760, a ROAS of 1.82, and lost $2,496 after ad cost (16,760 × 0.4 − 9,200).
  • Brand clicks often capture demand that already existed. That is a judgement, not a measurement here, but it is a reason not to let an 8.00 ROAS justify spend elsewhere.

The dashboard's job is to make this visible in one table, so the blended number is never the only number on the page.

app.tapcub.com

ROAS by campaign vs break-even 2.5

sample month
Brand search8.00
Generic search2.15
Competitor terms0.82
Display remarketing2.25
All four, blended2.83
Sample data
Sample data: break-even ROAS is 2.5 at a 40% gross margin. The blended 2.83 looks healthy, but three of the four campaigns are below break-even; brand search earns $3,960 and the others lose $2,496 between them.

How do you set a break-even ROAS and decision rules?

Break-even ROAS is the ROAS at which the ad cost equals the margin earned:

Break-even ROAS = 1 ÷ gross margin

At a 40% margin that is 1 ÷ 0.40 = 2.5; at 35% it is 2.86. Revenue of $2.50 per $1.00 of spend leaves $1.00 of margin, which exactly pays for the ad cost. Anything below that loses money before overhead.

Turn it into decision rules and write them on the dashboard, not in somebody's head. These thresholds are working rules for this example, not Google guidance:

ConditionActionCampaign in the sample
ROAS ≥ break-even and enough conversionsKeep; consider raising budget if impression share is limited by budgetBrand search (8.00, 300 conversions)
ROAS below break-even, 30 or more conversionsFix before cutting: tighten keywords, lower bids, check the landing pageGeneric search (2.15, 160 conversions)
ROAS well below break-even, fewer than 30 conversionsCap the budget and collect one more conversion cycle before judgingCompetitor terms (0.82, 28 conversions)
ROAS within 15% of break-evenTest the creative or the landing page before changing bidsDisplay remarketing (2.25, within 10% of 2.5)

The 30-conversion floor is a practical guard, not a statistical law: with fewer conversions, one more or one fewer order moves the rate visibly.

What layout makes a PPC dashboard readable?

Order the page the way the decision is made, top to bottom.

  1. Row 1, six cards: spend, clicks, conversions, CPA, ROAS and profit after ad cost, each with the change against the previous period and the target next to it.
  2. Row 2, trend: spend and conversions by day on one chart, so a spending spike without matching conversions is obvious. Mark launches and budget changes on it.
  3. Row 3, campaign table: the table from the worked example, sortable, with conditional colour against the break-even ROAS. This is the row people act on.
  4. Row 4, diagnostics: impression share and click-through rate by campaign, and the share of spend on brand versus non-brand terms.

Rules that keep it honest:

  • One primary conversion and one date range for the whole page.
  • Targets shown next to every number, otherwise a number has no meaning.
  • Brand and non-brand terms separated, as in the example.
  • A footnote saying when conversion data was last complete: recent days undercount conversions that have not happened yet.

Why do ad platform numbers and your analytics not match?

Expect differences, and decide which source owns which number before you compare them.

NumberUsually owned byWhy it differs
Spend, impressions, clicksAd platformOnly the platform knows what it charged
Sessions from the adsYour analyticsA click is not always a loaded page: people leave before the script runs, or block it
Conversions and revenueYour analytics or order systemThe platform counts what its tag sees, inside its own attribution window

Sample data: brand search had 3,000 platform clicks and 2,700 sessions in analytics, so clicks to sessions is 2,700 ÷ 3,000 = 90%. Spend per session is $1,800 ÷ 2,700 = $0.667, against a $0.60 CPC. Neither is wrong; they divide by different things. Choose one for the dashboard and label it.

How to build a PPC dashboard in TapCub

TapCub does not run, bid on or optimise ads, and it does not pull spend from an ad account on its own. It puts the spend you enter next to the sessions, conversions and revenue it measures. For the four-campaign example:

  1. Tag the destination links. Use utm_source, utm_medium and utm_campaign on each ad. In Web analytics › Sources, visits that carry click IDs such as gclid or msclkid are treated as paid search by default, and the UTM tab splits visitors and sessions by campaign.
  2. Enter spend. In All-platform analytics › Business › Channel ROI, open Costs and add rows one by one or import a CSV with day, channel, source, campaign, cost (and optionally clicks, impressions). Importing the same day, channel, source and campaign again overwrites the row.
  3. Read the ROI tab. It shows cost per click (spend ÷ sessions, so it will differ from the platform's CPC as shown above), cost per acquisition (spend ÷ purchases on the order ledger) and return on ad spend (revenue ÷ spend), grouped by channel, source or campaign. The quadrant uses sessions on the X axis, conversion rate on Y and revenue as bubble size.
  4. Check the goal side. For non-purchase conversions, set up a goal in Web analytics › Goals; its conversion rate divides by unique visitors, not sessions. The Sources channel table shows conversions per channel.
  5. Know the limits. Revenue comes from the order ledger; if spend is present and revenue stays zero, purchases have not been recorded yet. TapCub computes the three cost metrics above, not break-even or profit, so keep the margin in your own sheet.

FAQ

What is a PPC dashboard?

A PPC dashboard is a single view of pay-per-click performance: spend, clicks, conversions, cost per conversion and return on ad spend, broken down by campaign. A useful one shows targets beside each number and highlights the campaigns that fall below break-even, so it leads to a decision rather than a discussion.

What metrics should a PPC dashboard include?

Spend, clicks, click-through rate, average CPC, conversions, conversion rate, cost per conversion and ROAS, plus impression share to see whether budget limits reach. Add profit after ad cost if you know your gross margin. Keep to one primary conversion so the cost metrics mean one thing.

What is a good ROAS?

It depends on margin. Break-even ROAS is 1 divided by gross margin: 2.5 at a 40% margin. Google defines conversion value per cost as conversion value divided by cost. Compare your ROAS with your break-even, not with another business's figure.

Why is my conversion rate over 100%?

Google Ads can show a conversion rate above 100% when you count every conversion, or track more than one conversion action, because several conversions can be credited to one interaction. Use one primary conversion for the dashboard if you want the rate to stay between 0 and 100%.

How often should I check a PPC dashboard?

Check spend pace daily and campaign decisions weekly. Conversions can arrive days after a click, so a campaign's last few days look worse than they will end up. Wait for enough conversions, for example 30 or more, before cutting a campaign on conversion rate alone.

Sources

Filed underAnalytics

Was this article helpful?

We use your answers to fix and expand this page.

Xu An

Customer Experience Consultant

Writes about live chat, visitor conversations, and self-service, sharing practical ways to make customer communication clearer and more effective.

Put spend next to what visitors did

Import spend by day, channel and campaign and read cost per acquisition and return on ad spend beside sessions and revenue.

See your data clearly. Find your growth.

Every click, backed by data. Install one line of code and see your first numbers in a minute.

No credit card · Free plans for analytics and chat · Cookieless analytics