Skip to content

Free tool

Wasted ad spend checker for Amazon search terms

Paste rows from your search term report. Each row gets a verdict — keep, lower the bid, negate or pause, or too early to judge — and you see how much of your spend went on terms that never sold.

  • Paste search terms
  • Keep, lower or negate
  • Total wasted spend

Free, no sign-up. Pick your currency.


USD

Used when a row has no sales column

%

Orders ÷ clicks for this product

%
%

A row with no orders is flagged at 22 clicks or $12.50 spend, whichever comes first.

Copy the columns from your search term report in a spreadsheet and paste. Header rows are skipped (1 line skipped). Up to 2,000 rows. Nothing leaves your browser.

Wasted spend

$54.90

Share of spend checked

26%

Rows to negate or pause

2

Verdict for each pasted row
TermClicksSpendOrdersACOSVerdict
insulated bottle for kids34$28.900—Waste: negate or pause
copper water bottle31$26.000—Waste: negate or pause
stainless water bottle 32 oz120$102.001137.1%Lower the bid; check relevance
water bottle52$46.80293.6%Lower the bid; check relevance
gym shaker bottle12$9.600—Too early to judge

Candidates for negative exact (check relevance before adding)

How it's calculated

No orders: waste once clicks ≥ ln(0.1) ÷ ln(1 − conversion rate), or spend ≥ 2 × price × target ACOS

With orders: keep if ACOS ≤ target; lower the bid if ≤ break-even; otherwise review

The full explanation, with worked examples and exceptions, is in the guide: Finding wasted spend.

Limits of this tool

  • Your own brand terms and new launches need different rules; don't negate them on these numbers alone.
  • Leave out the last few days: orders can still be credited to recent clicks.
  • A term with no orders after many good clicks may point to a listing problem (price, stock, Buy Box) rather than a bad term.

In SellerZero

Do this for every product, automatically

SellerZero's search-term grid shows clicks, spend and orders for every term. Negatives and pauses are prepared in Suggest and wait for your review.

Start growing on Amazon today

Free during beta. No card. Connect your seller and advertising accounts on Amazon's own screens.