How to Read Your Amazon Search Term Report

What Is the Search Term Report?

The Search Term Report is the most important data source in Amazon PPC management. It shows you exactly what customers typed into Amazon's search bar before clicking your ad — and whether that click resulted in a sale. This is the bridge between what you think customers are searching for and what they're actually searching for.

Every Amazon PPC campaign uses keywords (the terms you bid on) to match against search terms (what customers type). The Search Term Report reveals this matching. A single keyword like "cutting board" (broad match) might match hundreds of different search terms: "bamboo cutting board large", "cutting board with juice groove", "small cutting board for apartment", and even irrelevant terms like "cutting board repair" or "cutting board wall art". Without the Search Term Report, you're blind to this matching — you know you're spending money, but you don't know which actual customer searches are consuming your budget.

Where to Download It

Navigate to Campaign Manager → Reports → Create Report → Search Term Report. Choose your date range (30 days for most analyses), select the campaigns you want to analyze (or choose all campaigns for a portfolio-wide view), and download the CSV file.

A few tips for the download: always use at least a 14-day window — shorter periods don't have enough data for meaningful analysis. For campaign-specific analysis, download individual campaign reports. For portfolio-wide optimization, download everything together — you might find the same search term appearing across multiple campaigns with different performance, which indicates a structural issue to fix.

The report typically takes 1-2 minutes to generate. For accounts with high ad spend and many campaigns, the file can be large (10,000+ rows). That's normal — high-spend accounts generate more search term data, which means more optimization opportunities.

Key Columns Explained

Customer Search Term: What the shopper actually typed into Amazon's search bar. This is the most important column — it tells you the real language customers use to find products like yours.

Keyword: The keyword in your campaign that matched this search term. Understanding this connection helps you see how Amazon's matching algorithm works for your campaigns.

Match Type: Whether the match was broad, phrase, exact, or auto-targeting. Auto and broad match generate the most search term variety (and therefore the most optimization opportunities).

Impressions: How many times your ad appeared for this search term. High impressions with low clicks suggest your ad isn't compelling for this particular search (or your product isn't relevant to what the shopper wants).

Clicks: How many shoppers clicked your ad after seeing it for this search term. Clicks cost money — every click is a charge to your PPC budget.

Spend: Total money spent on this search term in the reporting period. This is the column to sort by when looking for wasted spend — your biggest spending terms should all be converting.

7-Day Total Sales: Revenue attributed to this search term (Amazon uses a 7-day attribution window for Sponsored Products). Sales of $0 means the search term generated clicks but no conversions.

ACoS: Advertising Cost of Sales for this specific search term. Spend ÷ Sales × 100. This is your per-term efficiency metric. For a deeper understanding, see our ACoS explainer.

How to Find Wasted Spend

Wasted spend is money you're paying for clicks that never convert. Finding and eliminating it is the fastest way to improve your PPC profitability.

Step 1: Sort by spend (highest first), filter for zero sales. These are your biggest money drains — search terms that attracted clicks and consumed budget without generating any revenue. A search term with $45 in spend and $0 in sales is $45 wasted.

Step 2: Apply the "20-click rule." Don't negate a search term after just 3-4 clicks — that's not enough data. Wait until a term has 15-20+ clicks (or spend roughly equal to your product's selling price) before deciding it won't convert. Below that threshold, you're making decisions based on statistical noise.

Step 3: Check relevance before negating. Some zero-conversion terms are actually relevant to your product — they just haven't converted yet. "Bamboo cutting board with juice groove" is relevant if that's what your product is. In this case, the issue might be your listing (price too high? main image not compelling?) rather than the search term itself. Only negate terms that are genuinely irrelevant to your product.

Step 4: Negate as exact match. Add wasteful search terms as negative exact match keywords in the campaign where they appeared. This stops your ad from appearing for that specific search term while keeping the broader keyword active. Use negative phrase match sparingly — it's more aggressive and can block relevant variations you haven't discovered yet.

Typical wasted spend for an unoptimized account: 15-25% of total PPC budget. A $3,000/month PPC account might be wasting $450-750/month on non-converting search terms. Weekly negation reduces this waste to under 5% within 4-6 weeks. For a complete negative keyword strategy, see our negative keywords guide.

How to Find Winners

Winners are search terms that consistently convert at or below your target ACoS. These are your most valuable keywords — they represent customer searches that lead to purchases of your product.

Sort by orders (highest first) or ACoS (lowest first). Terms with low ACoS and multiple conversions are your proven performers. These should be in dedicated exact match campaigns where they get optimized bids and don't compete for budget with unproven terms.

Look for patterns in your winners. Do your best-converting terms include specific adjectives (size, material, use case)? Do they mention specific features? These patterns tell you what customers actually value — information you can use to improve your listing copy, title, and advertising strategy.

Check for winners in unexpected places. Sometimes the best-converting search terms are long-tail phrases you never would have thought to target. "Cutting board wedding gift set" or "extra thick bamboo board for meat" might convert at 2-3x your average rate. These hidden gems are one of the main reasons to analyze the Search Term Report regularly — they only appear when real customers search for them.

Keyword Graduation Strategy

Keyword graduation is the process of moving proven search terms from discovery campaigns (auto/broad match) to dedicated manual exact match campaigns. This is the systematic way to build a high-performance keyword portfolio.

Graduation criteria: A search term qualifies for graduation when it has 3+ conversions in the reporting period (proves consistent demand, not a one-time fluke), ACoS is at or below your target (confirms profitability), and the search term is specific enough to warrant a dedicated bid (single-word terms are usually too broad for exact match).

The graduation process:

1. Create a new exact match keyword in your manual campaign using the search term as the keyword.
2. Set the initial bid 10-15% above the current average CPC for that search term (visible in the report). This ensures competitive placement from day one.
3. Add the search term as a negative exact match in the original auto/broad campaign. This prevents both campaigns from bidding on the same search term — double-bidding wastes money because you're competing against yourself in the auction.
4. Monitor the graduated keyword's performance for 7-14 days. Adjust the bid based on actual results in the exact match campaign.

Over time, your campaign structure evolves: auto campaigns discover new search terms, broad campaigns test broader keyword themes, and exact match campaigns extract maximum value from proven winners. This is the PPC flywheel that consistently top-performing sellers operate. For the complete PPC optimization workflow, see our PPC SOP guide.

Advanced Search Term Analysis

Competitor brand term analysis: Your auto campaigns may be matching on competitor brand names. Check whether these terms convert — sometimes shoppers searching for a competitor discover your product and purchase. If competitor brand terms convert profitably, keep them. If they don't, negate them to stop wasting budget on brand-loyal shoppers who aren't interested in alternatives.

Search term cannibalization: The same search term appearing in multiple campaigns (with spend in each) means you're bidding against yourself. Consolidate — keep the search term in your best-performing campaign and negate it everywhere else.

Seasonal term identification: Some search terms only appear during certain periods (holiday gift terms, back-to-school terms, seasonal use terms). Track these and build seasonal campaigns that activate and deactivate based on your calendar. You'll avoid wasting budget during off-season and be prepared when demand spikes.

New-to-brand analysis: If you have Brand Analytics access, cross-reference your top search terms with new-to-brand percentages. High new-to-brand terms are particularly valuable because they're bringing in first-time customers. These terms may justify higher ACoS targets because the customer lifetime value exceeds the initial acquisition cost.

How Often to Analyze

Weekly (minimum): Every seller should analyze their Search Term Report weekly. This cadence catches wasteful terms before they consume a full month's budget and graduates winners while they're still performing. Most optimization value comes from consistent weekly analysis, not occasional deep dives.

Twice weekly during high-spend periods: During product launches, Prime Day, and Q4, your PPC spend is elevated and the data accumulates faster. Bi-weekly analysis during these periods prevents waste from compounding and ensures your campaigns stay optimized during your most important revenue periods.

Monthly deep dive: Once a month, step back from tactical optimization and look at strategic patterns. Which keyword themes are growing? Which are declining? Are your campaigns' search term profiles shifting over time? This strategic view helps you adjust your overall PPC direction. For related strategy, see our 2026 PPC guide.

Common Mistakes

Negating too quickly. A search term with 5 clicks and zero conversions might just need more data. Wait for 15-20+ clicks before making negation decisions. Early negation can block terms that would have converted with more exposure.

Only looking at ACoS. A search term with 35% ACoS might seem wasteful if your target is 22%, but if it's driving 50% new-to-brand customers and building organic ranking, it's strategically valuable. Consider the full picture.

Ignoring long-tail opportunities. Terms with 1-2 conversions and very low ACoS are easy to overlook because they individually generate small revenue. But collectively, 50 long-tail exact match keywords with 2 conversions each represent 100 conversions per month at superior efficiency.

Never reviewing auto campaign search terms. Auto campaigns are your discovery engine. If you never analyze what they're discovering, you're missing both the waste (irrelevant matches) and the opportunities (hidden gems) that auto campaigns generate.

Automate the Analysis

A comprehensive search term analysis across 14 campaigns and 2,800+ search terms takes 2-3 hours manually. Or it takes Jarvio about 4 seconds. Here's the difference: