Steps
- Download the search term workbook ↓
One copy per product (ASIN).
- Download the search term report
Sponsored Products, Search term, the longest time frame. The same works for Sponsored Brands.
Seller Central›Reports›Advertising reports›Create report
- Filter to the product's portfolio
Assuming your campaigns are organized by portfolio per product.
- Paste the columns
Targeting, match type, customer search term, impressions, clicks, spend, 7-day total sales, 7-day total orders into the Search term report tab.
- Remove $ signs if needed
Select the spend and sales columns, Ctrl+H, find $, replace all.
- Add search volume by hand
In the SFR column of Summary & harvest, recommended from Brand Analytics Top Search Terms.
Summary & harvest shows one line per search term you got any traction on, with impressions, clicks, spend, sales, orders, ACOS, CVR, CTR, CPC and share of spend. Filter and sort it to find the highest-spending terms, the winners to harvest and the bleeders.
Prefer not to use a spreadsheet? Paste the report here instead:
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 →- Report filtered to the product's portfolio
- Columns pasted, $ removed
- Search volume added for the main terms
- Sorted by spend and reviewed
Related guides
- 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…
- Checking the keyword landscape for new targetsMatch 60 days of search term data to your keyword research list to find big keywords you barely test, small ones you never test, and…
