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.
| Column | From | Meaning |
|---|---|---|
| Organic rank | Helium 10 Cerebro | Where you rank for the keyword |
| SFR | Brand Analytics (by hand) | Search frequency rank last month; lower = bigger keyword |
| Total count of purchases | SQP | All purchases on the keyword: the size of the prize |
| KW CVR | SQP | Total purchases ÷ total clicks: the keyword's average conversion |
| ASIN CVR | SQP | Your purchases ÷ your clicks |
| CVR delta | Formula | How much better or worse you convert than the keyword |
| KW CTR / ASIN CTR | SQP | Clicks ÷ impressions, for the keyword and for you: CTR win or loss |
| Action | Formula | Organic rank 10 or better: Good ranking. Your CVR above the keyword's: Target. Otherwise: Pass |
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.
- 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
- Copy each keyword's numbers
Search query, impressions (total and ASIN), clicks (total and ASIN) and purchases (total and ASIN) into the green columns.
- Organic rank
Paste your ASIN, Get Keywords, export as CSV, and copy each keyword's organic rank.
Seller Central›Helium 10›Tools›Cerebro
- 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
- 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
- Relevance
Top 3 clicked products that look like yours, 0–3, as in the keywords and competitors research.
- 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
Related guides
- How to use SQP: shares, opportunities and shopping conceptsRead Search Query Performance as your share of the market at each funnel step, spot the four patterns (including queries where you convert…
- 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…
- 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…
- Keyword research for a relaunch with Brand AnalyticsRelaunch step 1: pull 90% of your niche's keywords from 5–10 competitors in Brand Analytics, add SQP, PPC and organic rank data, and mark…
