A marketer presents visual campaign charts to a colleague. Harpy Guide

PPC Reporting — Numbers That Decide

14 min read · Harpy Media

Reports matter when they change what you do next. This guide helps you choose the right Amazon exports, read Search Query Performance alongside ad data, and turn a metric into a clear decision.

A report is not a decision. Start with the question you need to answer, then pull only the data that can help answer it.

Part 1

The reporting mindset

A strong report does more than list numbers. It helps the reader understand what changed, why it might have changed and what to consider next.

The three-step framework

1. Pull the right metrics together.Know which reports exist, how the data is shaped, and how to combine sources to answer the question at hand.
2. Craft the story — what's happening and why.Context is everything. Flat sales mid-Prime-Day is a problem; flat sales the week after Prime Day in a declining market can be a win.
3. Turn the story into action items.Where most reporting dies — people see the ACOS rise, even explain it, and then deliver no recommendation. Diagnosis without a prescription isn't reporting.
🔑 Key insight. Someone who can figure out what's happening and what to do about it — that combination is rare and extremely valuable. Most people can do one or the other.

The five golden metrics

Impressions · Clicks · Orders · Spend · SalesEverything else — CTR, CPC, CVR, ACOS, ROAS — is derived from these five

Always start with the raw ingredients. Jumping straight to calculated metrics on aggregated data is how misreads happen; the five raw numbers can't lie to you the way a blended average can.

The growth decomposition formula

When someone asks “why are sales up (or down)?” — decompose. In Amazon terms: sessions × unit session percentage × average selling price. Only three levers move sales; everything else rolls up into one of them. The analyst's job is to identify which lever moved and why.

Part 2

Critically thinking through metrics

CTR — the metric of first impressions

Metrics are easier to read when you know what affects them. For CTR, for example, placement, the main image, price, reviews and keyword breadth can all change the result.

💡 Tip. Before blaming your creative for a CTR dip, check placement data. If impressions shifted toward product pages, CTR falls with no change in your image at all.

Conversion rate — the closer

CVR determines whether traffic becomes revenue. It moves with the funnel stage of your traffic (bottom-funnel terms convert several times better than browsing terms — mix shifts move the average), brand vs. non-brand mix (branded converts dramatically higher), the product's own strength (price, reviews, images, A+), competitor actions, and seasonality or macro conditions.

CPC — the cost of doing business

Actual CPC = f(your max bid, market price, quality score)Second-price auction: you pay a cent over the next bidder — relevance affects what you're charged

Your bid is only one input. The market — what competitors will pay — sets the price around you, and Amazon's relevance judgment acts as a quality score: a poorly matched product pays a premium for the same click.

ACOS and ROAS — outputs, not inputs

⚠️ Watch out. High ACOS is never the root cause — it is always a CPC problem or a conversion problem. Treating the symptom instead of the lever is the most common analytical failure in PPC. Diagnose which input moved before fixing anything.

Part 3

The Sponsored Products reports

Amazon's console reports each slice the same underlying spend differently. Knowing each report's quirks — and its lookback limit — is half the craft.

Search term report

The queries that actually triggered your ads, against the keywords you targeted. The foundation of harvesting and negation. Quirks worth knowing: data reaches back roughly 65 days (verified — not the 60 everyone repeats), attribution is labeled 7-day for Sponsored Products, and one search term can appear across dozens of ad groups.

💡 Tip. Always pivot search term data before concluding anything. A term spending $1 in each of 100 ad groups looks harmless row by row — summed, it's $100 of possibly wasted spend.

Search term impression share report

The search term report plus two extra columns: impression share — the percentage of available impressions your brand captured on that query — and impression rank — where you stack against every competing brand on the term. Together they turn the report from performance history into competitive positioning.

Total possible impressions = your impressions ÷ impression share58,000 impressions at 0.5% share ≈ 11.6M total — that's the size of the arena

Sort by total possible impressions to find where volume lives, then cross-reference ACOS and CVR: high volume + low ACOS + low rank → push harder, profitably; high volume + high ACOS + low rank → fix conversion first, then push; rank #1 with high share → little room left, look elsewhere.

🔑 Key insight. If your impression share rose while total possible impressions fell, you're winning a shrinking market. That's a critical distinction for any performance conversation — the brand may be doing better than ever while the category contracts. Cross-reference with SQP search volume to prove it.

Advertised product report

Performance by individual ASIN, reaching back 90 days. Its best uses: per-product P&L (pair ad spend with Business Report sales for per-ASIN TACOS), share-of-total analysis (each product's slice of spend vs. its slice of sales — mismatches reveal over- and under-investment), same-SKU ratio (below ~50% and the product is mostly cross-selling, not building its own velocity), and CVR troubleshooting (sort ascending; the bottom of the list deserves investigation).

Campaign performance report

The most flexible report in the suite — daily, weekly, monthly, quarterly, or summary views reaching back years (hourly goes back 30 days). Combined with disciplined campaign naming, it becomes the most powerful tool you own: text functions can strip the ASIN, tactic, and target out of campaign names, letting you pivot years of history by any variable in the name — per-product trend reports no other report can produce.

Part 4

Search Query Performance — a useful data source

Search Query Performance can show how your brand appears across shopper queries. It is a useful source to read alongside ad reports and total-sales data, with the same date range and product scope.

What makes it special

CapabilityWhy it matters
Actual search volumeAmazon shows how many times each query was searched — data that simply didn't exist before SQP
The full-funnel metricsImpressions → Clicks → Add-to-carts → Purchases (the ICAP funnel), per keyword
Your share at every stageImpression share, click share, cart share, purchase share — per query
Brand view and ASIN viewRoll up to the whole brand or drill into one product

You'll find it in Seller Central → Brands → Brand Analytics (brand-registered sellers only). Monthly granularity is the sweet spot — weekly creates heavy exports for little extra insight.

Building the dashboard

The raw export needs work before it's useful. Download 12–18 months of brand-view data; add classification columns tagging each query brand / non-brand / competitor and by product category (a one-time effort — future months mostly reuse the same tags via lookup); then build pivots and charts for volume trends and share trends, filterable by tactic and category. What falls out is the closest thing to a market dashboard Amazon sellers can get.

The shipping-speed insight

💡 Tip. SQP breaks out purchase rate by shipping speed, and same-day delivery converts dramatically better than 2-day. When inventory spreads thin and shoppers start seeing 2-day instead of same-day, conversion silently drops — and you'll wonder why sales fell when nothing in the ads changed. Check delivery promise before blaming the campaigns.

One reconciliation note: SQP impression share will not match the ad console's impression share report, and that's expected — SQP leans toward organic impressions on page-one search, while the console counts all ad placements including product pages. They answer different questions; use each for its own question.

Part 5

Spreadsheet mastery for PPC reporting

At the core of PPC reporting is the spreadsheet — no macros or scripting required, but seven skills are non-negotiable:

1. Pivot tables.The foundation — group, sum, and segment in seconds. Every report starts as a pivot. Watch the trap: never SUM rank or share columns — average or take max/min, or five rank-#1 rows will tell you you're rank 5.
2. VLOOKUP.Cross-reference anything — pull titles into ASIN reports, categories from inventory sheets, compare bid files across uploads.
3. CONCATENATE.Build campaign names at scale — variables in columns, stitched together. Typing hundreds of structured names by hand is how typos enter an account.
4. TEXT BEFORE / TEXT AFTER.The inverse operation — extract variables back out of names so you can pivot by them. More flexible than LEFT/RIGHT for variable-length values like “30%” vs “5%”.
5. IF / AND / OR.Layered logic — “if ACOS above target AND tactic is non-brand, flag it.” Flagging is the bridge between data and decisions.
6. Conditional formatting.Heat maps across KPIs turn thousand-row sheets into pattern recognition — you spot green clusters performing on every metric, not one cherry-picked number.
7. Charts.Line for trends, bar for comparisons, pie for allocation — plus a filter dropdown per ASIN and you have an interactive dashboard inside a sheet.

Part 6

Data storytelling

The What → Why → So What framework

WHAT happened → WHY it happened → WHAT happens nextEvery insight you communicate — email, call, or message — follows this shape

A useful update says what changed, what might explain it and what you recommend checking next. Keep the recommendation clear and tie it to the data you reviewed.

⚠️ Watch out. “ACOS decreased due to optimizations. We will continue optimizing.” — the classic lazy report. It says nothing, teaches nothing, builds no trust. Always the specific cause, the specific next step.

Ask why seven times

Classic root-cause practice says five whys; PPC usually needs seven. Sales dropped 30% — why? Conversion fell 60% — why? Price moved from $15 to $22 — why? The brand raised MSRP on supply costs. Now the so-what: at this CPC we can't afford the current conversion rate; test a middle price that recovers enough conversion to hold rank while keeping the margin gain. The audience doesn't need to see all seven layers — they need to know you did the work and hear the conclusion.

Percentage of total — always

Product% of total sales% of total spendSignal
A42%31%Under-invested — feed it
B10%23%Over-invested — starve it
C15%14%Balanced

Allocation mismatches are invisible until you compute shares on both sides. Roll up to parent ASINs before judging — child-level shares mislead the same way child TACOS does.

Year-over-year context is non-negotiable

Never report month-over-month without year-over-year. December to January always looks like a disaster MoM; up 40% YoY with a smaller seasonal dip is actually outperformance. And check whether category search volume itself moved — if the market contracted 20% and you held share, that's a success story SQP can prove, not a failure to explain away.

Move from a number to an actionKeep the question visible while you work. A clean chart can still mislead if its timeframe or product scope changes.THE PATH TO A BETTER DECISION01 QUESTIONWhat do you need toknow?02 SOURCEWhich report can answerit?03 CONTEXTWhat else changes theread?04 ACTIONWhat will you do next?
Keep the question visible while you work. A clean chart can still mislead if its timeframe or product scope changes.

Part 7

Building your reporting dashboard

Three essential layers

LayerContents
Performance overviewTotal sales, ad spend, TACOS, ACOS — trended, with MTD/YTD/YoY comparisons in both % and absolute terms
Product drill-downsPer-ASIN or per-parent trends, ACOS targets, strategic notes
Strategy breakoutsBrand vs. non-brand vs. competitor splits, ranking-campaign tracking, initiative views (launches, festive sales)

Why not just the ad console? It can't combine ad data with organic data; it can't show TACOS; it can't trend an individual ASIN over custom ranges or show instant YoY for any period. Every serious analysis ends up exported to a spreadsheet anyway — the dashboard just makes that permanent and always-on.

Tagging is everything

The most important reporting practice isn't the dashboard — it's tagging the account properly. Product tags (category, ASIN, line), tactic tags (brand, non-brand, competitor, auto), initiative tags (launch, seasonal push, ranking campaign). With clean tags, any view is one filter away; without them, every question is a fresh spreadsheet build.

🔑 Key insight. The goal of a dashboard is to answer questions before they're asked. When the client stops logging into Amazon because your dashboard is their home base, you've won — losing you would mean losing visibility into their own business.
Give each report a jobMatch the report to the question. Read reports side by side only when the time window and scope line up.A QUICK FIELD CHECKCAMPAIGNWhere is paid spendgoing?SEARCH TERMWhat did shopperstype?SQPHow does the queryfunnel look?BUSINESSWhat happened tototal sales?
Match the report to the question. Read reports side by side only when the time window and scope line up.

Part 8

Client reporting that retains

Know your audience

Different readers need different levels of detail. A manager may need campaign data; a founder may need the business outcome and the next decision. Keep the detail that helps each person act.

Always have a visual ready

Never walk into a performance conversation with only the ad console open. One prepared visual — chart, table, annotated screenshot — that answers the most likely big question changes the entire meeting. Fast sources: spreadsheet charts, an auto-refreshing dashboard, or annotated screenshots.

Reporting calls are sales calls

Every review is a retention event. Show the work, not just the results; preempt the concerns before they're raised; end with explicit next steps; follow up with a bulleted summary. You're demonstrating every time why the relationship continues.

When performance breaks

Things will go wrong; the analysis quality decides what happens next. The pattern that works: a top SKU collapses from 100 units a day to 5 — what happened is obvious, why is the job. Price jumped $15 to $22; conversion fell 60%; at the new conversion, current CPCs can't buy profitable visibility. The recommendation isn't “we'll optimize” — it's test $18.99: a middle point that may recover enough conversion to hold rank while keeping most of the margin. One chart showing price climbing as BSR falls makes the case undeniable.

The same discipline applies when the cause is the market: YoY sales down despite steady investment, SQP shows core-keyword volume down 25%, the category itself contracted. The recommendation shifts from growth mode to efficiency mode — trim the least incremental tactics, protect margin, watch monthly for recovery. Context turns a “failure” into a strategy.

💡 Tip. Email discipline: bullets always (never bury three actions in a paragraph), cut the first draft by a quarter, include one scannable visual, and end with a labeled “Next Steps” section — what you're doing, what you need.

The difference between a good PPC manager and a great one isn't bid-change volume or structural complexity — it's the ability to look at data and see what it means. Anyone can read a scorecard. The job is interpreter: raw data into strategy, context, and action. Data without a story is noise; a story without data is opinion. Together they're strategy — and if you want that kind of reporting on your account, the first diagnosis is free.

Want this run on your account instead? The first diagnosis is free.

Book Free Consultation

Related terms

Sponsored ProductsSearch Query PerformanceASINImpressionsSeller Central

New guides, straight to your inbox.

Practical D2C playbooks as we publish them. No fluff, no spam — unsubscribe anytime.