Amz Consultors logo Amz Consultors AutomationBook a free strategy call

PPC · Keyword research & targeting

Summary of the PPC search term report

Roll 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 and how each performs.

Updated Oct 23, 20261 min readWho: VAHow often: Monthly, or before a PPC review

Steps

  1. Download the search term workbook ↓

    One copy per product (ASIN).

  2. 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

  3. Filter to the product's portfolio

    Assuming your campaigns are organized by portfolio per product.

  4. 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.

  5. Remove $ signs if needed

    Select the spend and sales columns, Ctrl+H, find $, replace all.

  6. 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:

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 →
  • Report filtered to the product's portfolio
  • Columns pasted, $ removed
  • Search volume added for the main terms
  • Sorted by spend and reviewed

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.