Amz Consultors logo Amz Consultors AutomationBook a free strategy call

Keywords · Tracking & data

Main keywords tracking (weekly)

Track CTR, CPC, CVR, spend and SFR for each product's 5–10 main keywords every week from the search term report, to spot niche trends early, control PPC, and judge listing A/B tests.

Updated Oct 25, 20263 min readWho: Account owner (keywords), VA (weekly update)How often: Weekly, with the weekly meeting

Why

  • See the trend in your niche: exact CTR, CPC and CVR for each keyword and for all of them together.
  • Spot changes in key metrics early and adapt fast.
  • Stay on top of PPC: spend and CVR per main keyword, and big changes you can fix early.
  • A/B tests: with weekly history per keyword, you can judge whether a new main image or listing change improved CTR and CVR. It's PPC data, so it's reliable.
The tracking sheet: keywords with formula columns for impressions, clicks, spend, sales, orders, CVR, ACOS, CPC and CTR, and the pasted search term data.
A versus B testing illustration.

Fill it in at the same time as the weekly meeting: when you review the 80/20 products, open this report to see what happened on the main keywords in PPC and in the market.

Set up the sheet

  1. Download the template

    Main keywords tracking ↓ (works in Excel and Google Sheets). Bookmark your copy.

  2. Copy the Product template tab for each product

    Rename it after the product.

  3. List the main keywords in column A

    The biggest keywords you know are most relevant. Skip huge keywords your product doesn't do well on, and very small ones (beyond 750,000–1,000,000 SFR). 5 is enough; no more than 10.

  4. Fill in the last 4 weeks, then every week from now on
Template tabs: a main template copied for each product, and the keyword list in column A.

The weekly update

  1. Start the week's block

    The template has six weekly blocks. For more, copy the last block to the right (SFR column through 7 Day Total Orders), then group and hide old weeks (View → Group). Clear the SFR and pasted data in the new block, but keep the blue formula columns.

  2. Download the Sponsored Products search term report

    Measurement & Reporting → Create report → Sponsored Products, Search term, Daily, last week → Run report.

  3. Filter the portfolio to this product
  4. Paste the columns in order

    Customer Search Term → Impressions → Clicks → Spend → 7 Day Total Sales → 7 Day Total Orders (#). Follow the headers in row 3.

  5. Remove the $ signs from Spend and Sales

    Select the columns → Ctrl+H → find "$" → Replace all.

  6. Fill in each keyword's SFR

    Brands → Brand Analytics → Top Search Terms, last week, one keyword at a time.

  7. Repeat for every product you track
Google Sheets View → Group → Group columns.
The grouping toggle above the grouped columns.
New week's columns with the SFR and pasted data cleared, keeping the formula columns.
Report configuration: Sponsored Products, Search term, Daily, Last week.
Excel filter on Portfolio name.
Find and replace removing the $ sign from the pasted columns.
Seller Central Brands menu with Brand Analytics.
Brand Analytics Search Analytics menu with Top Search Terms.
Top Search Terms: weekly range, the keyword entered, and its search frequency rank.

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.