Back to blog

PPC Reporting: KPIs, Formulas and a Report Template

PPC Course

PPC Reporting: KPIs, Formulas and a Report Template

By Daniel | PPC Performance Marketing Specialist

How to build a PPC report that drives decisions: which KPIs to show, formulas, impression share and Quality Score, report structure, cadence and a template.

Updated 31 October 2026 · Part of the PPC guide series

Short answer: A good PPC report shows whether paid advertising is reaching its business goal, explains why results changed and says what will happen next. Lead with business outcomes (sales, revenue, qualified leads, cost per acquisition or return on ad spend), then the supporting platform metrics (clicks, CTR, CPC, impression share), then insights and next actions. A report that only lists metrics without explanation does not help anyone make a decision.

Business KPIs vs platform metrics

Level Examples Who cares most
Business outcomes Revenue, profit, qualified leads, customers, CAC Owners, executives, clients
Efficiency CPA, ROAS, conversion rate, cost per qualified lead Marketing managers
Platform diagnostics Impressions, clicks, CTR, CPC, impression share, Quality Score PPC specialists

Report top-down: start with outcomes, then use efficiency and diagnostics to explain them.

Core PPC metrics and formulas

Metric Formula What it tells you
CTR (click-through rate) Clicks ÷ impressions How compelling ads are for the searches they show on
CPC (cost per click) Cost ÷ clicks Price of traffic
Conversion rate Conversions ÷ clicks (or interactions) How well traffic turns into actions
CPA (cost per acquisition) Cost ÷ conversions Cost of each conversion
ROAS (return on ad spend) Conversion value ÷ cost Revenue per unit of ad spend
Impression share Impressions ÷ eligible impressions How much of the available demand you are reaching
CAC (customer acquisition cost) All acquisition costs ÷ new customers True cost of a customer (not the same as CPA)

Notes:

  • CPA is not CAC. A "conversion" may be a lead, not a customer, and CAC includes costs beyond ad spend.
  • ROAS is not profit. A 4:1 ROAS can still lose money if margins are thin; report profit or margin-adjusted ROAS where you can.

Diagnostics: impression share and Quality Score

  • Impression share is the impressions you got divided by the impressions you were eligible for. Google estimates eligibility, so treat small changes with caution. "Lost impression share (budget)" points to budget limits; "lost impression share (rank)" points to bids or ad quality.
  • Absolute top impression share shows how often you appeared in the most prominent position.
  • Quality Score (1 to 10, keyword level) is a diagnostic tool. Google states it is not an input in the ad auction, so use it to find ad, keyword or landing page problems, not as a KPI to report upward.

Worked Example: Calculating the Core Metrics

A store spends $3,000 in a month. The campaigns record 60,000 impressions, 2,400 clicks, 96 orders and $9,600 in conversion value (illustrative numbers). The formulas give:

  • CTR: 2,400 ÷ 60,000 = 4%
  • CPC: $3,000 ÷ 2,400 = $1.25
  • Conversion rate: 96 ÷ 2,400 = 4%
  • CPA: $3,000 ÷ 96 = $31.25
  • ROAS: $9,600 ÷ $3,000 = 3.2 (or 320%)

If the average gross margin is 35%, the $9,600 in revenue produces about $3,360 in gross profit, which barely covers the $3,000 in ad spend. This is why a ROAS of 3.2 can look healthy in the platform while the business makes almost nothing from the channel. Report the margin-adjusted view next to ROAS.

Metrics by business model

E-commerce: revenue, ROAS (ideally profit-based), conversion rate, average order value, new vs returning customers, product or category performance.

Lead generation: leads, cost per lead, lead-to-qualified rate, cost per qualified lead, pipeline or revenue from paid leads (from your CRM). A cheap lead that never becomes a customer is not a good result.

Local and calls: calls, call duration, booked appointments, store visits where available.

Segment before you conclude

Totals hide the story. Break results down by:

  • Campaign and campaign type (Search, Shopping, Performance Max, Display, social)
  • Brand vs non-brand search
  • Device, location and time of day
  • New vs returning customers
  • Audience or match type, where relevant

Brand search usually has a much lower CPA than non-brand. Mixing them makes total performance look better than prospecting really is.

Check the Landing Page Behind the Numbers

When the conversion rate is the weak link, look at the page before changing bids. A free SEO audit reports load time, mobile speed and basic page problems for the landing page, which helps explain a low conversion rate and gives you a concrete item for the next actions list.

Why Google Ads and Analytics numbers differ

Expect differences between platform reports and your analytics or CRM, because of:

  • Different attribution models (which touchpoint gets credit).
  • Different conversion dates (date of the click vs date of the conversion).
  • Different counting rules (one vs every conversion per click) and conversion windows.
  • Consent and tracking gaps (users who decline cookies, blocked tags).

Pick one source of truth for each KPI, state it in the report, and do not mix sources in one number. Our guide to PPC attribution models explains the attribution side.

A one-page PPC report structure

  1. Summary (3 to 5 sentences): result vs goal, the main reason, the main next step.
  2. Goal pacing: spend and outcomes vs target for the month or quarter.
  3. KPI table: this period vs previous period vs same period last year.
  4. What changed and why: 2 to 4 insights with evidence.
  5. Tests: what was tested, the result, the decision.
  6. Next actions: owners and dates.
  7. Appendix: detailed campaign tables for those who want them.

Reporting cadence

Audience Frequency Focus
PPC team Daily or weekly Spend pacing, anomalies, search terms, tests
Marketing manager Weekly or biweekly Efficiency, pacing, key changes
Leadership or client Monthly Outcomes vs goal, insights, plan
Strategy review Quarterly Budget allocation, channel mix, forecasts

Common reporting mistakes

  • Reporting clicks and CTR as success without conversions or revenue.
  • Comparing periods of different length or with different seasonality.
  • Treating platform-attributed conversions as fully incremental.
  • Combining brand and non-brand results.
  • No explanation and no next step.

For SEO reporting, see our SEO analytics and reporting guide.

FAQs

What should a PPC report include?

A short summary, progress against goals, a KPI table with comparisons, explanations of what changed, test results and next actions. Detailed campaign tables can go in an appendix.

What are the most important PPC KPIs?

The ones tied to business outcomes: revenue or qualified leads, CPA or cost per qualified lead, and ROAS or profit. CTR, CPC and impression share are supporting diagnostics.

Is Quality Score a KPI?

No. Google describes Quality Score as a diagnostic tool and says it is not an input in the ad auction. Use it to find problems with ads, keywords or landing pages.

How Do I Explain a Bad Month to a Client?

State the result against the goal, give the 1 or 2 most likely causes with evidence from the data, say what you will change and when you will measure it again. Reports that hide bad news or skip the next step lose trust faster than a weak month does.

Should I Report ROAS or Profit?

Report both when you can. ROAS is easy to track in the platform, but profit shows whether the advertising is worth doing after product costs and other expenses. A target ROAS should come from your margins, not from a general benchmark.

Why don't Google Ads and Google Analytics conversions match?

They often use different attribution models, conversion dates, counting settings and tracking coverage. Choose one source for each KPI and note it in the report.