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
- Open the search term workbook ↓
One copy per product.
- 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).
- Download the search term report
Sponsored Products, Search term, last 60 days.
Seller Central›Reports›Advertising reports
- Filter to the product's portfolio
- 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 for | Example | Action |
|---|---|---|
| New big keyword tests | One of your top 5 keywords got 60 clicks or less in 60 days: barely tested, though it could move the product a lot | Put it in a single-keyword campaign with a set budget, and see what CVR and ACOS you get |
| New small and medium keyword tests | Dozens of keywords on your list got under 30 clicks in 60 days: they aren't really targeted | Target them in a new SP exact campaign aimed at top of search: good ACOS and organic rank help |
| Spend on low-CVR keywords | High spend on a keyword converting worse than the others | Move budget to high-CVR keywords with similar volume and CPC |
| Spend on high-CPC keywords | The highest CPC, without a higher CVR, so a higher ACOS | Lower spend on that keyword |
| The test campaign… | Then |
|---|---|
| Shows good ACOS and/or CVR | Scale bids and budgets |
| Isn't getting traction | Raise the top-of-search placement or the keyword bid |
| Gets many product page or rest-of-search clicks with medium or bad results | Lower 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.
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
Related guides
- Amazon keywords and competitors researchPick your 5 to 8 direct competitors, pull every keyword they win from Brand Analytics and Cerebro, find the soft competitors, then add…
- Summary of the PPC search term reportRoll the search term report up to one line per search term for a product, add search volume, and sort to see the highest-spending terms…
- Search term harvesting and isolationFind search terms that perform well but aren't targeted yet, add them as exact, broad and phrase targets with set starting bids, and…
