Searches that never sell
- No orders after enough clicks that two would be expected
- Spend higher than your average cost per order
- Suggested as negative exact
Amazon PPC auditBeta
Sponsored Products spend, against your real break-even.
Upload your Sponsored Products search term report. AuditRoger finds the searches that never sell, the ones that sell at a loss, and the ones worth buying as exact keywords.
Amazon PPC audit
There's nothing to connect: you upload a report, and it isn't stored.
- No orders after enough clicks that two would be expected
- Spend higher than your average cost per order
- Suggested as negative exact
.xlsx / .csv
file types
Up to 15 MB, as downloaded from the Amazon Ads console.
8+
clicks before a search counts as wasted
More if your conversion rate is low: enough clicks that two orders would be expected.
2+
orders before a search is worth harvesting
Within your target ACoS (or break-even, or the report's average, if you enter neither), and not already an exact keyword.
Not stored
your report
The file is read for the audit, then discarded.
What the audit finds
Six lists, each ready to act on in your campaigns.
Searches that sell at a loss
- ACoS more than 5% over your break-even (above 31.5% for a 30% break-even)
- The spend above break-even, for each search
- Shown when you enter your break-even ACoS
Searches to harvest
- 2 or more orders within your target ACoS
- Found by auto, broad or phrase campaigns
- Not yet bought as an exact keyword
Product targets
- ASINs that sell, to target on purpose
- ASINs that don't, to negate
Overlap
- The same search getting clicks in 2 or more campaigns
- So your campaigns stop competing for it
Words that never sell
- A word or pair of words in 3 or more searches with no orders, and at least an average order's cost in spend
- Suggested as negative phrase
How it works
- 1
Download the report
In the Amazon Ads console, create a Sponsored Products search term report and download it.
- 2
Add your numbers
Enter your break-even and target ACoS if you have them. The profit calculator can work out break-even for you.
- 3
Upload it
Drop in the .xlsx or .csv file. It's read in seconds and not stored.
- 4
Act on the lists
Add the negatives, and move the searches to harvest into exact-match campaigns.
Questions
Why upload a report instead of connecting?
A direct connection needs approval for Amazon's Advertising API. Until then, the search term report has everything this audit needs.
Which report does it read?
The Sponsored Products search term report. It needs the Customer Search Term, Clicks, Spend, Sales and Orders columns, which Amazon includes by default.
What does Beta mean here?
The checks are complete, but the audit has been run on fewer real reports than the Google Ads and GA4 audits. If a report won't read, email it to hello@auditroger.com and we'll fix the parser.
Guides
Download your Amazon search term reportWhere to find the Sponsored Products search term report in the Amazon Ads console, which date range to pick, and how to upload it for the audit.Break-even ACoS, worked outThe break-even ACoS formula with a worked example, and how the Amazon PPC audit uses your break-even to flag searches that sell at a loss.Tag Google ads that send traffic to AmazonWhy Google ads that link to Amazon without an Attribution tag hide your sales, what the Google Ads audit checks, and how to add the tags.
The rest of AuditRoger
Google Ads auditWasted spend, search terms, Quality Score and tracking.Meta Ads audit (Coming soon)Spend with no results, creative fatigue and structure.GA4 auditTracking health, the Google Ads link and data quality.Audit reportsRanked fixes, comparisons, share links and client reports.Roger AIAnswers from your own audits, with their sources.
Audit your search term report
Upload the report and get the lists in seconds. Nothing is stored.