← All tools
Free tools
Find the wasted spend in your search term report
Drop the Sponsored Products search term report from the Amazon Ads console. The file is read inside your browser and never leaves your computer.
Where to get the report
- Open the Amazon Ads console (advertising.amazon.com, or Campaign Manager inside Seller Central) and choose the marketplace: Amazon.ae, Amazon.sa or Amazon.com.
- In the left menu open Measurement & Reporting → Sponsored ads reports, then click Create report.
- Campaign type: Sponsored Products. Report type: Search term. Time unit: Summary.
- Report period: Last 30 days (or Last 60 days). Click Run report. The search term report covers up to the last 60 days in most views and older data drops off, so download it regularly.
- When the status shows Completed, click Download. Drop the .xlsx or .csv file below as it is. Do not edit the columns.
Rules
%
Use the target ACoS from the break-even calculator.
Leave on Auto to use your report's own conversion rate. Type a number to set it yourself. A spend check always applies.
Drop the .xlsx or .csv report here
Runs in your browser. Nothing is uploaded or stored.
How it is calculated
- Account numbers from the whole report: conversion rate = orders ÷ clicks, order value = sales ÷ orders, target cost per order = order value × target ACoS
- Auto click threshold = the larger of 10 and 2 ÷ conversion rate, rounded up (20 when the report has no orders)
- Negate: orders = 0 and either (clicks ≥ threshold and spend ≥ target cost per order) or spend ≥ 2 × target cost per order
- Watch: orders = 0 below those thresholds, or over target on fewer than 1 ÷ conversion rate clicks
- Over target: orders > 0, ACoS = spend ÷ sales above your target, and clicks ≥ 1 ÷ conversion rate. Lower the bid if the term is its own exact keyword or ASIN target, otherwise isolate it in exact
- Harvest: orders ≥ your minimum, ACoS at or under target, and the term is not already an exact keyword or ASIN target anywhere in the report
- Spend above target = spend − target ACoS × sales, summed over the over-target rows
Live audit call
Want a senior strategist to read these numbers with you?
In 30 minutes we open your ads console together, check what this tool flagged, and tell you the first three changes we would make.

Get the next brief by emailWhat changed on Amazon for sellers in the UAE and Saudi Arabia, in English or Arabic. Short, and only when something matters.
