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 a Sponsored Products report from the Amazon Ads console: search term, placement, advertised product or budget. AuditRoger finds the searches that never sell or sell at a loss, the placements and products that lose money, and the profitable campaigns that run out of budget.
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
4 reports
it reads
Search term, placement, advertised product and budget, as .xlsx or .csv up to 15 MB, told apart by their columns.
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.
Watch
Amazon PPC audit in 42 seconds
Searches, placements and products that lose money, and budgets that run out.
Read the transcript (42 seconds)
Which of your Amazon searches never sell?
Upload your Sponsored Products search term report. AuditRoger lists the searches that never sell, the ones that sell at a loss, and the ones worth buying as exact keywords.
Enter your break-even ACoS, and it flags every search selling above it. Every list is ready to act on.
Your report is read for the audit, then thrown away. It's never stored.
Download the report from Amazon Ads, add your break-even, upload it, and act on the lists.
Your first audit is free, with no credit card. Run it at auditroger.com.
What the audit finds
Six lists from the search term report, and a check from each of the other three reports, 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
Placements (placement report)
- Placements that sell above your break-even, campaign by campaign
- Top of search selling within your target, to raise its adjustment
- Campaigns losing money on dynamic bids, up and down
Products (advertised product report)
- Products with a fair number of clicks that never sold
- Listings shoppers see often and rarely click
- The share of your ad sales that were a different product
Budgets (budget report)
- Profitable campaigns that were out of budget part of the time
- Amazon's own estimate of the sales they missed, and the budget it suggests
- Campaigns that run out while losing money, to fix before raising the budget
Ready to use
- Download the negatives as a CSV, ready to add in the Amazon Ads console
- Try it first on a sample report, before you upload yours
How it works
- 1
Download a report
In the Amazon Ads console, create a Sponsored Products search term, placement, advertised product or budget report and download it. One ending a week ago has its sales in.
- 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?
Connecting your Amazon Ads account directly is coming soon. Until it opens, these four reports have everything this audit needs.
Which reports does it read?
Four Sponsored Products reports, told apart by their columns. The search term report needs Customer Search Term, Clicks, Spend, Sales and Orders, which Amazon includes by default. The placement report needs Campaign Name, Placement, Clicks, Spend, Sales and Orders. The advertised product report needs Advertised ASIN, Impressions, Clicks, Spend, Sales and Orders. The budget report needs Campaign Name, Average Time in Budget, Spend and Sales.
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 search term report in the Amazon Ads console, which dates to pick, and the placement, advertised product and budget reports it reads.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.