Amazon PPC Audit

One Bad Keyword Is Draining Your Budget — Here's How to Find It Fast

⚠ One keyword can consume 30–40% of budget with near-zero sales

Your campaign ACoS looks acceptable — but buried inside it is one keyword silently destroying your ROI. This guide gives you a 5-factor diagnostic framework to identify it, classify it, and fix it in under 20 minutes.

June 2026 8 min read Amazon PPC Keyword Audit ACoS Optimization Chintan K C

Why Campaign ACoS Lies to You

Campaign ACoS is a weighted average. One keyword at 287% ACoS can hide behind three at 20% — and your dashboard will show a comfortable 38%. The problem is invisible until you look at the right level.

What You See

Campaign Dashboard

Campaign ACoS 38%

Total Spend ₹18,400

Status Signal Acceptable ✓

What's Actually Happening

Keyword Level Reality

wireless earphone 19% ACoS

bt earphone india 22% ACoS

earphone cheap wireless 287% ACoS

↑ This keyword is consuming 34% of your budget

The fix is not a bid adjustment. The fix is identifying which keyword is responsible — and then classifying it correctly as Pause, Bid Down, or Restructure. This guide shows you exactly how to do that with your Search Term Report data in under 20 minutes.

Quick Reference

5 Diagnostic Factors at a Glance

Each factor is a signal. The more signals a keyword triggers, the more certain your diagnosis. Run all five checks on any keyword flagged by Factor 1 — the Spend Share Gap — and you'll have a complete picture in under 20 minutes.

Spend Concentration

One keyword consuming a disproportionate share of budget relative to its sales contribution — the core problem this audit diagnoses.

Funnel Break

Where a keyword loses performance — at the click stage (CTR) or conversion stage (CVR). Each break requires a different fix.

Match Type Leakage

Broad and Auto campaigns expand targeting beyond your keyword — spending on irrelevant search terms that never convert for your product.

Spend Share by Keyword

earphone cheap wireless

38%

wireless earphone

22%

bt earphone india

18%

Others

22%

Sales Share by Same Keyword

earphone cheap wireless

wireless earphone

38%

bt earphone india

28%

Others

28%

Gap = Spend Share − Sales Share. "earphone cheap wireless": −32%. This is your budget drainer.

Factor	What to Check	Healthy Signal	Action Threshold	Tool
F1 — Spend Share Gap	Spend Share % minus Sales Share %	0% to +10%	Gap worse than −15% → review Gap worse than −25% → pause	Gemini
F2 — Funnel Break	CTR and CVR per keyword	CTR >0.5% · CVR >10%	CTR <0.3% → critical CVR <5% → listing issue	Claude
F3 — Match Type Leakage	Customer Search Term column — Broad/Auto rows	All terms relevant	Irrelevant term found → Negative Exact 5+ per week → structural leakage	Gemini
F4 — Zero-Conversion	Filter: Orders = 0, sort by Spend	Below 15 clicks → wait	Spend ≥ 2× avg CPC × exp. conversions with 0 orders → pause/bid down	Gemini
F5 — Decision Threshold	ACoS vs target · Gap · CVR combined	ACoS ≤ target · Gap neutral	ACoS >2× target OR zero conversions above threshold → Zone 3 action	Claude

3-Zone Decision Framework

Zone 1 — Keep

Run as-is

ACoS at or below target · Gap neutral/positive · CTR above 0.4% · 1+ conversion per ₹500

Zone 2 — Bid Down

Reduce bid 20–30%

ACoS 20–50% above target · Gap −10% to −20% · Some conversions but inefficient · Re-evaluate in 14 days

Zone 3 — Pause / Restructure

Pause or move to Exact

ACoS above 2× target OR zero conversions with spend ≥ 2× breakeven threshold · Gap worse than −25%

Deep Dive

Factor-by-Factor Diagnosis

Factors 1 and 2 are available to everyone. Register to unlock the full diagnostic system — including Match Type Leakage, the Zero-Conversion filter, the 3-Zone Decision Matrix, and the AI Prompt Library.

Factor 1 of 5

Spend Share vs Sales Share Gap

Primary Diagnostic

Spend Share % = (Keyword Spend ÷ Total Campaign Spend) × 100

Sales Share % = (Keyword Sales ÷ Total Campaign Sales) × 100

Gap = Spend Share % − Sales Share %

Negative gap = over-spending relative to sales contribution. Sort by Gap to find your budget drainer.

Example — 3 keywords, same campaign

wireless earphone — Spend 12%, Sales 18%Gap +6% ✓

bt earphone india — Spend 9%, Sales 11%Gap +2% ✓

earphone cheap wireless — Spend 31%, Sales 4%Gap −27% ← Budget Drainer

Sort by Gap descending-negative. The keyword at the top is your primary suspect. Any gap worse than −25% is almost always a pause candidate.

Factor 2 of 5

Funnel Break — CTR vs CVR Diagnosis

Break Detection

CTR = (Clicks ÷ Impressions) × 100

CVR = (Orders ÷ Clicks) × 100

CTR Break → keyword-listing mismatch or weak main image

CVR Break → listing not converting paid traffic — fix listing, not keyword

Funnel model — keyword with CVR break

Impressions10,000

Clicks (CTR 3.8%)380

Orders (CVR 0.5%)2 — Break at CVR

ACoS312%

CVR break means the keyword is working — the listing is failing. Pausing the keyword in this case wastes potentially valid traffic. Fix price, images, or reviews first.

Factor 3 of 5

Match Type Leakage

Broad / Auto

Keyword Set: bluetooth speaker (Broad Match)

Amazon Served On:

→ "bluetooth speaker stand" — wrong product

→ "cheap speaker 100 rupees" — wrong intent

→ "bluetooth speaker 20w" — relevant ✓

Leakage impact — 30-day Broad match campaign

Total Broad match spend₹15,000

Spend on irrelevant terms₹6,200 (41%)

Orders from irrelevant terms0

Fix: Negative Exact added₹6,200 recovered/month

Weekly Search Term review for Broad and Auto campaigns is non-negotiable. Leakage compounds every week without review — 30 days of unchecked Broad match can waste 30–40% of campaign budget.

Factor 4 of 5

Zero-Conversion Keyword Filter

Spend Threshold

Filter: Orders column = 0 → Sort by Spend descending

Threshold: Spend ≥ (Avg CPC × expected conversions × 2)

Keywords below 15 clicks: insufficient data — wait. Above threshold with 0 orders: action today.

Zero-conversion audit — filtered results

earphone bluetooth cheap — 350 clicks₹4,200 | 0 orders → Pause

best earphone under 200 — 258 clicks₹3,100 | 0 orders → Pause

earphone new brand — 8 clicks₹96 | 0 orders → Wait

Total recoverable (top 2)₹7,300/month saved

The keyword with the most clicks and zero orders is the highest-confidence pause candidate. Statistical certainty scales with click count — 50+ clicks with zero orders is a near-definitive verdict.

Factor 5 of 5

3-Zone Decision Threshold

Action Framework

Zone 1 — Keep: ACoS ≤ target · Gap neutral/positive

Zone 2 — Bid Down: ACoS 20–50% above target · Gap −10% to −20%

Zone 3 — Pause: ACoS >2× target OR zero conversions above threshold

Zone assignment — practical decision logic

Zone 1: Run as-isNo changes needed

Zone 2: Bid down 20–30%Re-evaluate at 14 days

Zone 3: Pause outrightIrrelevant intent confirmed

Zone 3: Move to Exact + NegativeRelevant intent, wrong match type

The distinction between "pause outright" and "move to Exact + Negative" is intent. If the search term is what your buyer would type — keep the intent, fix the match type. If it's not your buyer — remove it completely.

Correct Diagnosis Sequence

Run Spend Share Gap — identify the primary suspectCalculate and sort by Gap. Flag everything worse than −15%. This is your diagnostic entry point.

Run Funnel Break — understand the type of problemCTR or CVR? This determines whether the fix lives in the keyword or the listing. Critical before any action.

Check Match Type Leakage — stop new waste immediatelyAdd negative keywords for all irrelevant search terms found in Broad and Auto. Prevents future erosion.

Apply Zero-Conversion Filter — triage by data confidenceKeywords with 15+ clicks and zero orders are statistically confirmed non-converters. Act with confidence.

Execute 3-Zone Decision Matrix — take action todayClassify every flagged keyword. Execute Zone 3 immediately. Log all changes. Review Zone 2 at 14 days.

Common Mistakes to Avoid

Mistake 01

Optimizing campaign ACoS instead of keyword ACoS. Campaign ACoS is a result, not a diagnostic signal. Adjust the thermometer and you never fix the temperature.

Mistake 02

Pausing a keyword when the funnel breaks at CVR. If the keyword is generating clicks, it's doing its job. The listing is failing — not the keyword. Fix the listing first.

Mistake 03

Running Broad or Auto campaigns for 30+ days without a single Search Term review. Match type leakage compounds weekly — unchecked campaigns waste 30–40% of budget on irrelevant queries.

Mistake 04

Applying the same action to all zero-conversion keywords regardless of click count. A keyword with 5 clicks has no data. A keyword with 60 clicks and zero orders has been decided by the market.

Mistake 05

Evaluating bid changes within 48 hours. Amazon PPC needs 3–5 days to propagate bid changes. The 14-day review window is a minimum — not a suggestion.

AI Prompt Library

Same analysis. Done with AI. Pick a factor, copy the prompt, paste your data, and get instant results.

Gemini

Paste: Search Term Report CSV — last 30 days

Below is my Amazon Search Term Report for the last 30 days. [paste CSV data here] For each keyword or search term: 1. Calculate Spend Share % and Sales Share % from totals 2. Find all keywords where Spend Share minus Sales Share is worse than −15% 3. List all keywords with zero conversions and spend above ₹500 4. Flag any search terms that appear irrelevant based on product category 5. Which single keyword should I pause first, and why?

AI returns: flagged keywords ranked by gap severity + single top pause recommendation

Claude

Paste: Keyword-level data — Impressions, Clicks, Orders, Spend

I am an Amazon PPC manager. Below is keyword-level data from my Search Term Report. [paste impressions, clicks, orders, spend per keyword] For each keyword: 1. Calculate CTR = Clicks / Impressions × 100 2. Calculate CVR = Orders / Clicks × 100 3. Identify where the funnel breaks: CTR stage, CVR stage, or both 4. Diagnose the likely root cause: keyword-listing mismatch, listing quality, bid issue, or intent mismatch 5. What is the recommended action for each keyword based on where its funnel breaks?

AI returns: per-keyword CTR/CVR with funnel break point and action recommendation

Gemini

Paste: Search Term Report CSV — Broad and Auto match rows

Below is my Amazon Search Term Report for the last 30 days. [paste CSV data here] For each row where Match Type is Broad or Auto: 1. Identify Customer Search Terms that are irrelevant to the product category 2. Flag terms with wrong price intent (e.g., "cheap", "100 rupees") 3. Flag terms from a different product category entirely 4. List all flagged terms as Negative Exact keyword candidates 5. Which 3 negative keywords would recover the most wasted spend immediately?

AI returns: irrelevant term list + top 3 negative keyword priorities by spend recovered

Gemini

Paste: Search Term Report CSV (filtered or full)

Below is my Amazon Search Term Report for the last 30 days. [paste CSV data here] My average CPC is ₹[X]. For keywords with zero orders (Orders = 0): 1. Calculate the spend threshold: Average CPC × 2 × expected conversions 2. List all keywords that have crossed this threshold with 0 orders 3. Separate keywords with fewer than 15 clicks (insufficient data) from those above 15 clicks 4. For above-threshold keywords, are the search terms relevant to a typical product buyer? 5. Rank by urgency: which keyword should I pause first to recover the most wasted spend?

AI returns: threshold-sorted zero-conversion list with pause/watch/data-needed classification

Claude

Paste: Flagged keyword list from F1–F4 analysis

I am an Amazon PPC manager. Below is my flagged keyword list from a Search Term Report audit. [paste flagged keyword data here] My target ACoS is [X]%. My average CPC is ₹[Y]. For each flagged keyword: 1. Classify into Zone 1 (Keep), Zone 2 (Bid Down), or Zone 3 (Pause/Restructure) 2. For Zone 2: what bid reduction percentage do you recommend? 3. For Zone 3: should I pause outright or move to Exact match + Negative? 4. Estimate monthly budget recovered if I take all Zone 3 actions today 5. What is the single most important action I should take first?

AI returns: zone classification per keyword, bid recommendations, estimated monthly savings

Your First Action — Do This Today

One Step. 15 Minutes. Real Account.

You've learned the framework. Now apply it. Here is the single most impactful action from this topic — broken into 5 steps you can complete right now on your actual Seller Central account.

Open Seller Central and navigate to Advertising Reports

Log in to Seller Central. Go to the Reports section and select Advertising Reports. Choose Search Term Report, set the date range to the last 30 days, and download the CSV file.

Seller Central → Reports → Advertising Reports → Search Term Report → Date range: last 30 days → Download

Steps 2–5 are available to registered members. Step 2 shows you exactly how to add the Spend Share Gap columns and find your budget drainer in under 5 minutes.

Key Takeaways

What to Remember From This Guide

Four principles that separate sellers who diagnose accurately from those who adjust bids blindly and wonder why nothing improves.

Campaign ACoS is a weighted average — never the diagnosis

A campaign showing 38% ACoS can contain a keyword at 287% ACoS hidden by three performing keywords. Always audit at keyword level. The Spend Share Gap column is the entry point — not the campaign dashboard.

Where the funnel breaks determines the fix — not the ACoS

A CTR break means keyword-listing mismatch. A CVR break means the keyword is working but the listing is failing. Pausing a keyword with a CVR break removes valid traffic from a fixable problem. Check the funnel before taking any action.

Broad and Auto campaigns leak without weekly review

Amazon expands targeting beyond your intent. Without a weekly Search Term Report review, Broad and Auto campaigns accumulate irrelevant spend at a rate of 30–40% of budget within 30 days. Negative Exact additions are the correction mechanism.

One keyword found and fixed monthly compounds into real savings

The data required for this audit exists in a single downloadable report. The difference between accounts that improve and accounts that stagnate is not access to information — it is the habit of checking it. 15 minutes monthly is the entire investment.

Free PPC Tool

Calculate Your Break-Even ACoS Before Your Next Audit

Knowing your Break-Even ACoS is essential for Zone classification in Factor 5. The free PPC Calculator gives you the threshold in under 60 seconds — no spreadsheet required.

Enter product cost and price

Get Break-Even ACoS instantly

Use as your Zone 1/2/3 threshold

Open Free PPC Calculator → Book a Free Discovery Call Explore SelluxPro

SOP Reference: 230626