Amz Consultors logo Amz Consultors AutomationBook a free strategy call

PPC · Keyword research & targeting

Checking the keyword landscape for new targets

Match 60 days of search term data to your keyword research list to find big keywords you barely test, small ones you never test, and keywords wasting spend.

Updated Oct 23, 20263 min readWho: PPC managerHow often: Monthly, for mature products

What and why

Match your Sponsored Products search term report to your keyword research list with simple formulas. It shows weak spots in your PPC strategy, low-hanging fruit and some bleeders. A healthy monthly habit to understand where your PPC money goes, best for mature products that have run for a while, not brand-new ones.

You need your keyword research list, per product, and the SP search term report for the last 60 days (the longest Amazon allows).

Building the table

  1. Open the search term workbook ↓

    One copy per product.

  2. Paste your keyword list

    In the Keyword landscape tab, column A, sorted from the biggest keyword to the smallest (by SFR from Brand Analytics, or search volume from Helium 10 or another tool).

  3. Download the search term report

    Sponsored Products, Search term, last 60 days.

    Seller Central›Reports›Advertising reports

  4. Filter to the product's portfolio
  5. Paste it

    Targeting, match type, customer search term, impressions, clicks, spend, 7-day total sales and 7-day total orders into the Search term report tab. Remove the $ signs if they paste as text (Ctrl+H, find $, replace with nothing).

The landscape tab now shows impressions, clicks, spend, sales, orders, ACOS, CVR, CTR and CPC for every keyword on your list, and flags the gaps.

What to look for

Look forExampleAction
New big keyword testsOne of your top 5 keywords got 60 clicks or less in 60 days: barely tested, though it could move the product a lotPut it in a single-keyword campaign with a set budget, and see what CVR and ACOS you get
New small and medium keyword testsDozens of keywords on your list got under 30 clicks in 60 days: they aren't really targetedTarget them in a new SP exact campaign aimed at top of search: good ACOS and organic rank help
Spend on low-CVR keywordsHigh spend on a keyword converting worse than the othersMove budget to high-CVR keywords with similar volume and CPC
Spend on high-CPC keywordsThe highest CPC, without a higher CVR, so a higher ACOSLower spend on that keyword
The test campaign…Then
Shows good ACOS and/or CVRScale bids and budgets
Isn't getting tractionRaise the top-of-search placement or the keyword bid
Gets many product page or rest-of-search clicks with medium or bad resultsLower the keyword bid and raise the top-of-search bid

Cutting spend on a weak keyword: filter the search term report for that search term to see which campaigns spend on it, find the target driving most of the traffic, and lower its bid aggressively (at least 15% for a noticeable impact). Check spend every 2 days for about 6 days to confirm it dropped.

CalculatorSearch term report analyzer

Paste a Sponsored Products search term report to see spend per unique search term, new terms to harvest with starting bids, and bleeders.

Want these numbers for your own account? Get a free audit →
  • Keyword list pasted, biggest first
  • 60-day search term report for the product pasted
  • Top 5 keywords with 60 or fewer clicks: single-KW tests
  • Keywords under 30 clicks: SP exact top-of-search test
  • Low-CVR and high-CPC keywords cut back

Want this done for you?

We run advertising, listings and account health for Amazon, Walmart and eBay brands. Start with a free review of your account.