Amazon Ads / PPC / Account audit

Negatives before budget.

How a search-term audit of a 600-campaign Amazon Ads account found that negative keywords, not more spend, were the biggest efficiency lever.

Matías Gaglio ·

Leer en español
Amazon Ads console style bar chart of ROAS by campaign set from the search term audit
~600campaigns audited across six Amazon Ads reports
1,116negatives in the first pass, plus 1,818 in a second
4.64 → 5.88projected pool ROAS at the same spend
14new campaigns harvested from high-ROAS search terms
The question

Where is the money leaking before we spend more?

The brief was clear: grow Revolution Supply's Amazon sales toward a daily floor, lift blended ROAS to 6.0 or more, and don't lose more than 10% of ad-attributed sales on the way. Management had also set a daily ad spend target. The easy reading was "spend up to the target". I wanted to know first where the current budget was being wasted, because new money poured into the same structure would leak the same way.

So the audit started with search terms, not campaigns. A campaign's ROAS is an average of good and bad searches. The search term report shows which queries actually bought something.

Method

Six reports, four questions.

Search terms

30 days of queries with spend and orders, across Sponsored Products, Brands and Display. This is where negatives come from.

Targeting

Keywords and product targets by match type, to see whether a bad query came from a broad keyword or a loose product target.

Campaign and budget

Which campaigns run out of budget, which never spend, and how the daily account cap shapes delivery.

Business Reports

Total sales, sessions and conversion, so ad efficiency is read next to TACoS and the business as a whole.

Every finding went into one of three buckets: block it (negative), move it (harvest into its own campaign), or fund it (shift budget toward it).

What the search terms said

Ad types weren't equal, and averages hid it.

Split by ad type and source, the 30-day search term data showed a wide spread. Sponsored Display earned more than six times what Sponsored Brands did per dollar. Harvested keywords had stopped working while harvested product targets were still healthy.

Campaign setROASRead
Sponsored Display (search terms, 30 days)10.34Strongest ad type. Fund it.
Canada campaigns8.1Separate budget pool and underfunded. Fund it.
Harvested product targets4.93Healthy. Keep it.
Sponsored Brands (search terms, 30 days)1.61Main inefficiency. Block and cut.
Harvested keywords1.39Stopped.
Block

1,116 negatives first, 1,818 more second.

The first pass built 1,116 negative keywords and product targets: mostly queries that had collected clicks and spend over 30 days without a single order. Re-scoring the campaign pool without that waste moved its projected ROAS from 4.64 to 5.88 at the same spend.

A second pass went deeper into Sponsored Brands, where broad traffic was concentrated, and produced another 1,818 negatives.

Move

The other side of the same report is the search terms that worked. 14 new campaigns were built from queries with high ROAS that were buried inside broad campaigns. In their own campaigns they get their own budget and bids.

Fund

Budget moves toward Sponsored Display, Canada and product-target harvests. Those moves depend on raising the Sponsored Products daily account cap, which was already limiting delivery.

ROAS by campaign set: Sponsored Display 10.34, Canada 8.1, harvested product targets 4.93, Sponsored Brands 1.61, harvested keywords 1.39
ROAS by campaign set, from the 30-day search term audit.
Watching spend after the audit

A spend spike traced to three campaigns.

Cleaning an account once isn't enough. In early November daily spend jumped, and the search term data traced most of it to three Sponsored Brands campaigns returning between 1.4 and 2.4 ROAS. The proposal followed the same rules as everything else: pause the one below 1.5, cut the other two hard, and negate the queries that weren't converting. Because the decision came from the rules, it took one review instead of a debate.

Results and limits

Better efficiency, not yet more demand.

October

4.87 ROAS

The most efficient ad month since March, on less spend than September and with no drop in sales.

Ad share

40% → 49%

Ad-attributed sales as a share of total Business Report sales, August to early November.

Total sales

About flat

Average daily sales in the 44 days after the change were within 2% of the 30 days before.

Negatives made each ad dollar work harder, but total sales didn't move with them. Ads now account for a bigger share of a business that is roughly the same size. That's why the next work moved from the ad account to the listings: traffic grew while conversion fell. I cover that in More traffic, less conversion.

Method note: sources are Amazon Ads Campaign Manager, the 30-day search term report and Seller Central Business Reports. Ad figures include Canada and Business Reports are US only. Projections assume the same traffic minus the blocked queries. Before/after comparisons are observational.
Software and tags

Tools and topics in this article.

Software used or related

  • Amazon Ads
  • Amazon Ads bulksheets
  • Search term report
  • Amazon Seller Central
  • Business Reports
  • Excel

Topics

  • Amazon PPC
  • PPC audit
  • Negative keywords
  • Negative product targeting
  • Search term analysis
  • Keyword harvesting
  • Wasted ad spend
  • ROAS
  • TACoS
  • Sponsored Products
  • Sponsored Brands
  • Sponsored Display
  • Budget allocation
  • Amazon Canada
  • Automotive parts
  • Wheel accessories
  • Revolution Supply

Related work

Next step

Want to apply this approach to your brand or team?

Book a 30-minute call, review my CV or email me.