What the audit shows you
- Every search term with ad spend and zero orders
- Your total wasted spend and waste rate, measured against the 8–15% that is typical
- A copy-paste list of negative keywords to add
- A watch list of terms trending toward waste
- Your waste broken down by campaign
- An estimate of what automation would save you
The 5 patterns we grade against
Most Amazon PPC accounts waste 8–15% of their ad spend on search terms that never convert.
Every Amazon PPC account that scores below B falls into one of five waste patterns. The grade is a composite — your final letter reflects whichever pattern is bleeding the most money. The good news: each pattern has a known, mechanical fix. The bad news: nobody fixes them because the search term report is tedious to read.
The five patterns:
- Broad-match bleed — broad-match keywords matching irrelevant search terms. Spend goes up, orders don't.
- Auto-campaign drift — auto/discovery campaigns that were supposed to be short-term experiments and became permanent budget lines that re-bid on what your manual campaigns already cover.
- High-CPC zero-convert — paying $1.50+ per click for terms that don't convert. Often competitor brand terms or generic category queries.
- Untested long tail — hundreds of low-volume terms each costing a few dollars. Individually invisible, collectively significant.
- High-ACoS converters — the trickiest. Terms that DO convert, but at an ACoS that eats your margin. They look like winners in campaign reports.
Upload your report above — we'll tell you which of the five is your account's biggest leak, and give you a 5-day plan to fix it.
How to download your Amazon Search Term Report
- Log into Amazon Seller Central
- Go to Campaign Manager (under Advertising)
- Click Reports in the left sidebar
- Click Create Report
- Select Report Type: Search Term
- Set Date Range to Last 30 Days (or longer for more data)
- Click Run Report, then Download when it's ready
- Upload the downloaded file to the calculator above
What are negative keywords on Amazon?
A negative keyword tells Amazon: "don't show my ad when someone searches for this term." When you find a search term that costs you money but never produces an order, adding it as a negative keyword prevents future waste on that term.
There are two types of negative keywords on Amazon:
- Negative exact — blocks only the exact search term. Use this when the specific term is irrelevant but similar terms might still convert.
- Negative phrase — blocks any search that contains the phrase. Use this when an entire category of terms is irrelevant (e.g., "cheap" or "free").
The calculator above identifies search terms that should be added as negative exact match keywords. You can copy the entire list and paste it directly into Amazon Campaign Manager.
What does each PPC grade mean?
The grade is a 0-100 composite score, mapped to a letter:
- A (90-100) — Tight. Top 10% of accounts. Waste rate under 5%, bids are disciplined, converters are profitable.
- B (80-89) — Solid. A few cleanup opportunities, but the fundamentals are right. Waste rate typically 5-10%.
- C (70-79) — Leaky. Meaningful waste is showing up — usually one pattern dominates. Fixable in a week of focused work.
- D (60-69) — Bleeding. Money is leaving daily. Waste rate 15-20% or significant bid-discipline issues.
- F (0-59) — Hemorrhaging. Most ad spend is producing nothing. Bottom decile. The fixes are known and mechanical — they just haven't been done.
Most accounts score C or D on first audit. The score is a starting point, not a verdict. The 5-day cleanup plan walks you through exactly what to fix first. how to find and eliminate wasted ad spend.
What a rule does with waste: in our rule set, a keyword that spends $10 to $16 in 30 days without an order drops to a $0.28 bid, and past $16 it's paused. See our Amazon PPC automation rules, with every threshold.
Frequently Asked Questions
What does my PPC grade actually mean?
The grade is a 0-100 composite score across four dimensions: how much of your spend goes to zero-order terms, how disciplined your bids are on non-converters, what share of your converters have ACoS above 30%, and how widely waste is spread across your campaigns. A is top 10%, F is bottom decile. Most accounts on first audit land at C or D.
How is the grade calculated?
We start every account at 100 and subtract penalties. Big penalty for high waste rate. Smaller penalties for high-CPC non-converters, bleeding converters (orders but high ACoS), and waste spread across many campaigns. The math is the same for every account — no fudging based on category or spend level.
What is the 5-day cleanup plan?
After we identify your single biggest waste pattern, we email you a 5-day plan with one specific fix per day, tailored to that pattern. If broad-match is your problem, the plan is different than if it's auto-campaign drift. No generic advice — the plan responds to your audit.
Is the shareable grade page anonymous?
Yes. The public page shows your letter grade, score, tagline, and the human-readable name of your top problem. It never shows your search terms, campaign names, exact spend, or anything that identifies your account. You can share the URL on Twitter, Slack, or a forum and nothing private leaks.
Do you store my search term data?
No. The analysis happens entirely client-side in your browser. Your file is never uploaded to any server. If you opt in to save your grade, we receive only the aggregate score and your failure mode — never the raw report.
What file format does the calculator accept?
XLSX (Amazon's default download format), CSV, and TSV files. Download your Search Term Report from Amazon Campaign Manager and upload it directly — no conversion needed.
How is 'wasted spend' defined?
A search term is counted as waste when it has ad spend above your minimum threshold (default $5) and zero orders. These are clicks that cost you money but never produced a sale.
Can I automate this whole process?
Yes. RedHen Labs monitors your search terms every day, identifies waste as it appears, and queues negative keywords and bid changes for your approval. You approve in 2 minutes a day. It also tracks real profit per product after COGS, FBA fees, and ad spend.
How often should I re-audit my PPC?
Weekly is ideal, monthly is the minimum. The shareable URL stays live forever — re-run the audit any time and see whether your grade has climbed. Most accounts move from C to B in 30-60 days of consistent cleanup.
Got a number that doesn't look right? Ask.
Tell me about your business and I'll walk through what your numbers mean. The same person who built the tool answers — usually within a day.
RedHen Labs runs this same audit every night, identifies the negations and bid changes, and applies them only after you approve. Flat $129/mo — never a percentage of what you spend on ads.
Start Free Trial