Amz Consultors logo Amz Consultors AutomationBook a free strategy call

PPC · Keyword research & targeting

Keyword research from Search Query Performance

Build a keyword sheet from Search Query Performance, organic rank and your search term report, and mark each keyword good ranking, target or pass by comparing your conversion rate with the keyword's.

Updated Oct 23, 20263 min readWho: Brand owner or PPC managerHow often: Before a launch or relaunch; then monthly

What this sheet does

The first step of a launch or relaunch is deep keyword research: know the landscape of your niche and have every option in front of you. Use the keywords in your Search Query Performance (SQP) report and put SQP data and PPC data side by side, to see the opportunity your product has on each keyword.

ColumnFromMeaning
Organic rankHelium 10 CerebroWhere you rank for the keyword
SFRBrand Analytics (by hand)Search frequency rank last month; lower = bigger keyword
Total count of purchasesSQPAll purchases on the keyword: the size of the prize
KW CVRSQPTotal purchases ÷ total clicks: the keyword's average conversion
ASIN CVRSQPYour purchases ÷ your clicks
CVR deltaFormulaHow much better or worse you convert than the keyword
KW CTR / ASIN CTRSQPClicks ÷ impressions, for the keyword and for you: CTR win or loss
ActionFormulaOrganic rank 10 or better: Good ranking. Your CVR above the keyword's: Target. Otherwise: Pass
CalculatorSQP keyword opportunity

Search Query Performance clicks and purchases per keyword to keyword CVR vs your CVR, relevance, and good ranking, target or pass.

Want these numbers for your own account? Get a free audit →

Building the sheet

Use the SQP opportunity tab of the keyword research workbook ↓, one copy per product, with the ASIN in the file name.

  1. SQP for last month

    ASIN view, your ASIN, previous month. With many variations, use the child ASIN with the most sales in the last 30 days. Generate download.

    Seller Central›Brands›Brand Analytics›Search Analytics›Search Query Performance

  2. Copy each keyword's numbers

    Search query, impressions (total and ASIN), clicks (total and ASIN) and purchases (total and ASIN) into the green columns.

  3. Organic rank

    Paste your ASIN, Get Keywords, export as CSV, and copy each keyword's organic rank.

    Seller Central›Helium 10›Tools›Cerebro

  4. SFR, keyword by keyword

    Reporting range: last month. Search the keyword and copy its search frequency rank. Small keywords have no SFR: enter "-".

    Seller Central›Brand Analytics›Search Analytics›Top Search Terms

  5. PPC data

    Sponsored Products, Search term, the longest period allowed. Put it in the search term workbook ↓ and use its Keyword landscape tab to see clicks, spend, ACOS and CVR per keyword (how).

    Seller Central›Reports›Advertising reports›Create report

  6. Relevance

    Top 3 clicked products that look like yours, 0–3, as in the keywords and competitors research.

  7. Repeat for each product
  • SQP ASIN view for last month pasted
  • Organic rank from Cerebro added
  • SFR added for each keyword
  • Actions checked: good ranking, target, pass
  • Score 1 and score 2 noted
  • Brand View added for products with many variations

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.