Skip to content

How to read your Amazon search term report (and what to do with it)

By Akshit Seth · Last updated 26 October 2026

· 5 min read

Illustration of a rising glass bar chart in green and blue with a gold arrow and a magnifier.

What is the Amazon search term report?

The search term report lists the actual searches shoppers typed before they clicked your Sponsored Products or Sponsored Brands ads, with the spend, clicks, orders and sales for each one. It's the most useful report in Amazon ads, because it shows which searches earn money, which waste it and which deserve their own exact match keyword.

What the report shows

The search term report shows the exact words shoppers typed before they clicked your ad, and what each search cost and earned. Keywords are what you bid on, but search terms are what you actually paid for, and the gap between the two is where most wasted spend hides. This guide shows how to download the report, which columns to read and four decisions to make for every search, with a worked example in rupees. If you'd rather have it done every week for you, it's part of our Amazon PPC management service.

The report covers Sponsored Products and Sponsored Brands. In automatic and product targeting campaigns, some rows show a product code (an ASIN starting with B0) instead of words. Those are clicks from other products' pages.

How to download it

Illustration of a petrol-blue glass magnifying lens examining product blocks.
  1. In Seller Central, open Advertising, then Campaign Manager.
  2. Go to Measurement & reporting, open Sponsored ads reports and click Create report.
  3. Choose Sponsored Products as the report category and Search term as the report type.
  4. Pick the time unit (summary or daily) and the report period, then click Run report.
  5. When the report is ready, download it from the reports page.

These steps follow Adbrew's walkthrough (Adbrew). Amazon moves its menus from time to time, so if a step doesn't match your screen, look for "Sponsored ads reports". Amazon doesn't keep this data for long: Intentwise reported a 60-day window in the console in 2023 (Intentwise), so download a copy every month.

The columns that matter

Comparison

Customer search term

What it tells you
What the shopper typed, or the ASIN of the product page they clicked from

Targeting and match type

What it tells you
Which of your keywords or targets matched the search

Impressions and clicks

What it tells you
How often the ad showed, and how often it was clicked

CPC

What it tells you
The average cost per click

Spend

What it tells you
What the search cost you

7 Day Total Orders and 7 Day Total Sales

What it tells you
Orders and sales credited to the ad within 7 days of the click

ACoS

What it tells you
Spend ÷ sales × 100

Conversion rate

What it tells you
Orders ÷ clicks × 100

For sellers, Amazon credits Sponsored Products sales for 7 days after the click, so the most recent week will look worse than it ends up.

Four decisions for every search term

Illustration of a glass telescope on a green hill pointing at floating search bubbles and stars.

Start with your target cost per order: the selling price × your target ACoS. A ₹1,000 product with a 25% target ACoS can afford ₹250 in clicks for each order. Then make one of four decisions for each search:

Comparison

Negate

When
The search is clearly wrong for your product, or it has spent more than your target cost per order without an order
What to do
Add it as a negative exact keyword. For a whole family of wrong searches, use negative phrase

Move to exact

When
It has orders at an ACoS below your target, with 10 or more clicks
What to do
Add it as an exact match keyword in a manual campaign with its own bid, and as a negative exact in the campaign it came from

Change the bid

When
It has orders, but its ACoS is above your target (lower the bid), or well below target with few impressions (raise it)
What to do
Change the bid by 10% to 20% at a time and check again in two weeks

Wait

When
Fewer than 10 clicks, and spend still under your target cost per order
What to do
Leave it and check again next week

The "10 or more clicks and at least one order" rule for moving a search to exact match comes from eVanik (eVanik). Amazon's own guide suggests waiting for at least 20 clicks before you judge a possible negative (Amazon Ads).

A worked example in rupees

A seller of a ₹1,000 steel water bottle has a 25% target ACoS, so a target cost per order of ₹250, and a break-even ACoS of 40%. Here are five rows from 30 days of the report:

Comparison

steel bottle 1 litre

Clicks
42
Spend
₹546
Orders
5
Sales
₹5,000
ACoS
10.9%
Decision
Move to exact, and raise the bid a little to win more of it

steel bottle for kids

Clicks
25
Spend
₹300
Orders
1
Sales
₹1,000
ACoS
30.0%
Decision
Keep, but lower the bid: above target, below break-even

copper bottle

Clicks
22
Spend
₹264
Orders
0
Sales
₹0
ACoS
–
Decision
Negate: spent more than ₹250 without an order

plastic bottle

Clicks
6
Spend
₹78
Orders
0
Sales
₹0
ACoS
–
Decision
Negate now: the wrong product

insulated bottle 750 ml

Clicks
7
Spend
₹91
Orders
0
Sales
₹0
ACoS
–
Decision
Wait: too few clicks to judge

Two negatives stop ₹342 a month of spend that had produced no orders. The exact match keyword then gets its own bid and budget, so the search that sells best stops competing with everything else in the automatic campaign.

How often to check

Illustration of unbranded product packaging arranged on green and blue glass platforms.
  • Every week: sort the last 14 to 30 days by spend and work through the top rows. eVanik suggests a fixed weekly slot, and says "45 minutes every Tuesday is the minimum cadence for steady ACoS reduction".
  • Every month: download and save the full report, and look at slower-selling products, which need more than a week of data.
  • Before and after sale events: search behaviour changes during the Great Indian Festival, so check again when the sale ends.

Mistakes to avoid

  • Negating after one or two clicks. You'll block searches that would have sold.
  • Judging the last seven days. Sales are still being credited, so recent ACoS looks too high.
  • Negating searches that sell because one week looked expensive. Look at 30 days before you block a search that has orders.
  • Ignoring the ASIN rows. Product page clicks that never convert can be blocked with negative product targeting.
  • Not keeping a copy. Once the data is gone, you can't go back and check what happened last quarter.

Want the maths for your own products? Use our ACoS calculator to find your break-even and target ACoS. If your ads still aren't paying back after this, see why your Amazon ads aren't working, or let our Amazon PPC management service take it over.

Frequently asked questions about How to read your Amazon search term report (and what to do with it)

How far back does the search term report go?

Not far. Intentwise reported in 2023 that the ads console keeps 60 days of search term data, against 90 days for some other reports. Check the date ranges your console offers, and download the report every month so you build your own history.

What's the difference between a keyword and a search term?

A keyword is what you bid on. A search term is what the shopper actually typed. One broad or phrase match keyword, such as steel water bottle, can match many search terms, such as steel water bottle 1 litre for school, and the report shows each one separately.

Should I negate a search term after one click?

No, one click tells you almost nothing. Amazon suggests judging a possible negative after at least 20 clicks, and a simple money rule works too: negate a search once it has spent your target cost per order without an order. Searches that are clearly irrelevant are the exception, so negate those straight away.

Get a free ads audit

We'll check your account for the problems in this guide and send you a written plan.

+91
Which marketplaces do you sell on?

Pick all that apply

* required

We'll contact you on WhatsApp, phone or email about your audit. See our Privacy Policy.

WhatsApp Call Free audit