The right report: Search Term Report

The Amazon Ads Search Term Report shows, for each campaign and ad group, which real shopper search terms generated impressions and clicks on your ads — including in automatic campaigns, where you don't choose the keywords directly. For each term, the report shows impressions, clicks, CTR, spend, orders and attributed sales.

That combination — high spend and zero orders on the same term — is what reveals the waste.

Step by step to find the waste

  1. Pick a period with enough volume — 30, 60 or 90 days, depending on how much the account sells. Very short periods don't have enough clicks for a reliable conclusion.
  2. Download the Search Term Report for all campaigns active in the period.
  3. Sort by spend, highest to lowest.
  4. Filter terms with orders = 0 (or "infinite"/undefined ACoS, when your tool uses that notation).
  5. Compare each term's spend with the advertised product's price — a term that has already spent the equivalent of 2–3 sales of the product without converting any is a strong candidate for adjustment.

Before adding negatives: the small-sample problem

A term with 3 clicks and zero sales isn't, on its own, evidence of waste — it's far too small a sample for any statistical conclusion. The same logic that applies to conversion rate in general applies here: a few clicks may not have converted by chance, not because the term is bad.

Two signals that raise your confidence that it's real waste, not noise:

  • The term has already accumulated enough clicks that, at the campaign's average conversion rate, you'd expect at least 1 sale — and it hasn't converted any.
  • The term's accumulated spend already exceeds the value of a few units of the product sold.

What to do with what you find

Once you find a term with high spend and zero conversions, your options are, from least to most drastic:

  1. Lower the bid on that term/target, keeping some exposure at a lower cost.
  2. Add the term as a negative (negative exact), stopping it from triggering the ad.
  3. Review the campaign structure if the same pattern repeats across many similar terms — it may be a sign of targeting that's too broad.

When a campaign simply stops spending

Before treating it as a targeting problem, rule out two common technical causes that make a campaign stop spending on its own, without any manual change:

  • Product out of stock: budget is only spent on available products. When the product becomes unavailable, the campaign pauses automatically — zero spend isn't a sign of bad targeting, it's a lack of inventory.
  • Lost Buy Box: budget is only spent while the seller is winning the Buy Box (Featured Offer). If another seller takes the Buy Box on the same listing, the campaign doesn't deliver, even if it's active with a competitive bid. The reverse is also worth remembering: investing in ads doesn't guarantee the Buy Box.

A sudden drop in spend on a previously healthy campaign usually has one of these two causes before it's a real campaign structure problem.

Common mistakes

  • Adding negatives based on 1–2 days of data.
  • Pausing the whole campaign instead of handling the specific term.
  • Ignoring terms with low-to-medium spend that, added up, represent a big slice of total waste.
  • Not reviewing again after the adjustment — search behavior changes, and new problem terms show up over time.

How EcomVision helps

EcomVision's Ad Spend Leak Finder automates this analysis: it applies the spend-without-conversion filter to the Search Term Report, shows the accumulated waste in dollars per term and lets you add negatives right from the platform, with a preview before applying — no spreadsheet exports or manual report matching.

Update notice: the fields and exact report name may change in the Amazon Ads interface over time. The most current official reference is always the Amazon Ads documentation (see source below).

Sources