Understanding Amazon Ads Reports: The Reports KDP Authors Actually Need

Amazon Ads reporting can be overwhelming. The console surfaces dashboards, downloadable CSVs, and aggregated metrics across dozens of dimensions. Most authors either ignore the data entirely (and optimize on instinct) or drown in it (and change too much based on too little). The path between these extremes is knowing which reports matter, what questions they answer, and what specific actions their data should trigger. This guide maps every relevant report to its function and the decisions it informs.

The Reports Landscape in Amazon Ads

Amazon’s current Sponsored Products reporting includes Search term, Targeting, Advertised product, Campaign, Placement, Performance over time, Purchased product, and Search term impression share reports. You do not need every report every week. Start with the business question, then choose the report that answers it.

For most authors, Search term, Targeting, Placement, and Advertised product do most of the recurring work. Purchased product and impression-share data become more useful once the account has enough activity to justify deeper diagnosis.

Search Term Report: The Most Important Report

The Search Term Report shows the actual queries, word for word, that triggered your ads and generated impressions, clicks, and sales. It is the only place where you can see real reader vocabulary instead of the keyword or targeting you set. Running this report is the core action of every weekly optimization session.

How to run it: navigate to Reports → Create Report → Sponsored Products → Search Term, set your date range (previous 7 or 14 days), select all campaigns, and download. The key columns to analyze are: Search Term (the actual query), Impressions, Clicks, Spend, 7-Day Total Sales, 7-Day Total Orders, and ACoS. Add a calculated column for ACoS if it is not pre-calculated (Spend ÷ Sales × 100).

Sort by clicks descending. Focus on terms with repeated clicks. Categorize each into: converter (sales > 0, ACoS ≤ target, add to manual exact match), waste (multiple clicks, zero sales, clearly irrelevant, add as negative), or undecided (3-8 clicks, no sale yet, leave for another week).

This workflow is the engine of all Amazon Ads improvement. Done weekly, it systematically eliminates waste and builds a growing list of empirically validated converting keywords. Run separate Search Term Reports for each ad type.

Sponsored Products and Sponsored Brands generate different search term data. Sponsored Products automatic campaigns specifically are your richest source of discovery data, prioritize this report above all others.

Campaign Performance Report

The Campaign Performance Report shows aggregate performance at the campaign level: total impressions, clicks, spend, attributed sales, ACoS, and CTR per campaign. This is the top-level view that tells you whether each campaign is within your performance targets and whether budget allocation is correct.

Use this report to: identify campaigns with ACoS significantly above target over 30+ days (candidates for bid reduction or structural review); identify campaigns consistently hitting their daily budget cap (candidates for budget increase if ACoS is good); compare CTR across campaigns (campaigns with much lower CTR than average may have keyword/audience mismatch issues); and track total spend vs total attributed sales to calculate your rough ACoS across the full account. Pull this report monthly for trend analysis. Comparing month-on-month campaign performance tells you whether your optimization cycle is producing compound improvement (ACoS declining, conversion improving over time) or whether you are on a flat or deteriorating trajectory.

Targeting Report

The Targeting report shows performance for the keywords, products, or categories you deliberately targeted. It answers a different question from the Search term report: the targeting report tells you what you bid on; the search-term report tells you what the shopper actually searched or where the match occurred.

Use it to compare targets, identify expensive targets that are not earning enough, and find targets that deserve more budget. Do not impose a universal click threshold. A decision should reflect spend, expected royalty, conversion pattern, and how much evidence the target has accumulated.

Placement Report

The Placement Report breaks performance down by where your ad appeared on Amazon: Top of Search (first row of results), Rest of Search (below the fold), and Product Pages (on detail pages of other ASINs). Each placement type has different conversion dynamics, and the report reveals whether your ads perform better in some placements than others. How to use it: compare conversion rate and ACoS across the three placement types.

If Top of Search shows significantly better conversion and ACoS than Product Pages, increase your Top of Search bid modifier in the campaign settings (you can increase bids by a percentage specifically for Top of Search placements). If Product Pages are underperforming, lower their modifier or remove it. If all three are roughly equivalent, no modifier change is needed.

Run this report monthly. Placement performance is relatively stable, you do not need to check it weekly, but a monthly review ensures your bid modifiers reflect actual placement efficiency rather than defaults.

Purchased Product and Product-Targeting Evidence

Product-targeting performance appears through your targeting and campaign data, while the Purchased product report helps show what shoppers bought after interacting with Sponsored Products. That can reveal cross-format behavior or other titles that are benefiting from the campaign.

For book advertising, separate the advertised ASIN from the purchased ASIN when the report allows it. A Kindle ad that helps sell the paperback may still be commercially useful even though the format-level economics differ.

Advertised Product Report

The Advertised Product Report shows performance broken down by the specific book being advertised, useful when you have multiple books running in the same account and want to see per-book performance without running separate reports for each book’s campaigns individually. It shows impressions, clicks, spend, sales, and ACoS per advertised ASIN. This report is most useful for multi-book accounts.

It enables a quick per-book performance review, identifying which books are advertising efficiently and which are consuming budget without proportional returns. This informs both optimization priorities (focus improvement effort on underperforming books) and budget reallocation decisions (reduce spend on structurally poor performers, increase on high performers).

Use Targeting and Search-Term Reports Together

The Targeting report summarizes the keywords, products, and categories you chose, while the Search term report exposes the shopper searches or matched contexts that actually generated clicks. Read them together: one tells you the instruction you gave Amazon, the other tells you how that instruction played out in the auction.

This comparison is especially useful for broad, phrase, automatic, and product targeting. It shows which targets are opening the door to relevant traffic and which are repeatedly matching searches that should be narrowed or excluded.

Understand the 14-Day Author Attribution Window

Amazon’s current attribution documentation gives authors a 14-day click lookback for Sponsored Products. That means an eligible purchase can be attributed to the campaign when it occurs within the campaign’s applicable 14-day window after the click. Book products do not receive the wider brand-halo treatment Amazon describes for branded retail products.

Attribution is not the same as incrementality. A reported sale means Amazon assigned credit under its attribution rules; it does not prove the customer would never have bought without the ad. Use attributed sales to manage campaigns, then compare them with total KDP performance for the broader business picture.

Use a Reporting Cadence That Matches Your Spend

Amazon itself recommends giving new Sponsored Products campaigns time to gather information before making more advanced bid changes. For a small author account, a weekly or every-other-week search-term review is usually more useful than daily intervention. Larger accounts may need more frequent budget checks.

The rule is evidence, not calendar purity. Check budgets often enough to prevent accidental overspend, review search terms often enough to stop obvious waste, and leave low-volume targets alone long enough to accumulate meaningful data.

Building a Reporting Spreadsheet Workflow

Maintaining a running spreadsheet with your monthly reporting data transforms reports from one-off snapshots into trend analysis tools. Create a master sheet with tabs for: monthly campaign performance summary (total spend, total attributed sales, overall ACoS, TACoS calculated against KDP royalties); keyword performance tracker (keywords, current bids, monthly ACoS, trend direction); negative keyword log (all negatives added, date added, campaign); and confirmed converters log (all terms promoted from automatic to manual exact match, date, opening bid). This historical record becomes invaluable after three to six months.

You can see which keywords have consistently produced good ACoS over time versus which had one good week and have since reverted to waste. You can see seasonal patterns (certain genres see higher conversion in December; certain nonfiction categories see spikes in January). You can see whether each bid change you made produced the expected result.

Without this record, each optimization session starts from scratch. With it, you accumulate genuine expertise about your specific book’s advertising.

Common Data Traps and Misreadings

The most common mistake is treating a small sample as a verdict. A target with a few clicks and no sale may simply be early; a target that has spent more than you can plausibly recover deserves a harder look. Use spend relative to royalty and repeated behavior instead of a universal click count.

Another mistake is treating ACoS as profit. Amazon Ads reports attributed sales revenue, while KDP royalty can be much lower than retail price. Finally, do not use impressions as a success metric by themselves. Pair delivery with clicks, CPC, attributed purchases, placement, and the quality of the traffic that the Search term report reveals.

Frequently Asked Questions

Make Every Report Answer a Decision

You do not need a reporting warehouse. You need a repeatable path from shopper search to target to placement to attributed outcome, with enough context to know what to change next.