Free KDP tool

Search Term Report Analyzer for KDP Ads

Find where your ad money goes. Add your Amazon Sponsored Products search term report and see wasted spend, best search terms, negatives to add and keywords to harvest. Your file stays in your browser. Nothing is uploaded.

Private by design: your file is read inside your browser. It is never uploaded or sent to InteliAds or anyone else.

Terms with at least this many clicks and 0 orders.

How it works

  • Your browser reads the CSV file. Commas, semicolons and tabs all work, and $, £ and € signs are fine.
  • Rows for the same search term are added up across campaigns.
  • Wasted spend: terms with many clicks and no orders. These are your suggested negatives (negative exact, or negative product for ASINs).
  • Harvests: terms with enough orders and an ACOS under your limit that are not already exact keywords.
  • Top converters: the terms with the most orders.

Worked example

Click “Try a sample report” above. The sample spends $102.55 in total. $37.1 of it goes to search terms like “free kindle books” that got many clicks and no orders. Adding those as negative exact keywords stops paying for them. Illustration only.

Next, set bids for your new exact keywords with the Amazon Ads bid calculator, or check your totals with the ACOS calculator.

FAQ

Is my report uploaded anywhere?
No. The file is read by your own browser on your own device. It is not uploaded or sent to InteliAds or anyone else. You can even turn off your internet after the page loads and it still works.
How do I download the search term report?
In Amazon Ads, go to Measurement & Reporting, then Sponsored ads reports. Create a report with type Sponsored Products and report Search term. Pick a date range, such as the last 30 or 60 days, and download it as CSV.
What counts as wasted spend?
Spend on search terms that got at least 10 clicks and no orders. You can change the click limit. Books with low conversion rates may need a higher limit.
What is an exact-match harvest?
It means taking a search term that already sells in an auto or broad campaign and adding it as an exact keyword. That gives you direct control of its bid.
Should I add every suggested negative?
Check each one first. A term with no orders yet may still lead to page reads or later sales. Your own book title and author name are usually worth keeping.
My file does not work. What should I check?
Make sure it is a Sponsored Products search term report saved as CSV, not Excel. It needs Customer Search Term, Clicks, Spend and Orders columns.