The keyword harvesting loop

Keyword harvesting is the weekly discipline that turns your discovery campaigns into a compounding system. Auto and broad campaigns surface converting queries you didn't know to target; the harvesting loop extracts those queries, promotes them to dedicated exact-match campaigns at a tighter bid, and prevents the source campaigns from bidding against themselves.

Done consistently, this loop builds the keyword infrastructure of your advertising account — an ever-growing set of exact-match campaigns where every keyword was proven to convert before you gave it its own budget.

1. Pull the Search Term Report

   In Seller Central, navigate to Advertising → Campaign Manager → Reports → Search Term Report. Select a 7- or 14-day window. Download the CSV.

   A 7-day window catches recent performance and reflects current bid and placement conditions. A 14-day window smooths out day-of-week variance but may include data from before a recent bid change. Most sellers run the loop weekly on a fixed day — same cadence, consistent data.

   In RankASIN, uploaded STR CSVs are stored as search_term_rows and power the campaign performance panels automatically. Upload your report at Advertising workspace to keep your performance data current.

2. Filter for proven converters

   Open the CSV in your spreadsheet tool of choice. Filter by:

   • Purchases (or Orders) above zero — only rows where the customer search term resulted in a purchase
   • ACoS below your target — for a 30% target ACoS, keep rows at or below 30%. The formula is: Spend / Revenue × 100.

   Sort by purchases descending, then by ACoS ascending within the same purchase count. The top rows are your candidates.

   The column you care about is the Customer Search Term — not the keyword you bid on. The customer search term is what the shopper actually typed. That is the query you want to target in your new exact-match campaign.

3. Extract the customer search query

   Copy the qualifying customer search terms into a separate list. Deduplicate if the same query appears across multiple campaigns.

   At this point you have a list of proven search queries: real words real shoppers typed, which resulted in purchases from your product, at an ACoS you can sustain.

4. Create a Manual Exact campaign targeting those queries

   In Seller Central (or in your campaign blueprint in RankASIN), create a new Sponsored Products campaign:

   • Targeting: Manual keyword targeting
   • Match type: Exact
   • Keywords: your extracted customer search terms
   • Bid: 75–85% of the CPC the term was paying in the source campaign. If a term was converting at $1.20 CPC in your auto campaign, open at $0.90–1.00 in the new exact campaign. You're buying the same shopper intent at a lower cost because you're being more precise.
   • Bidding strategy: Dynamic Down Only
   • Campaign name: follow the standard naming pattern — {Initials} | {Product} | {ASIN} | {Market} | SPM | "Root" KWs | Exact — or use a single-keyword naming convention for high-volume terms being promoted to dedicated ranking campaigns.

   Group terms by semantic root where possible. Terms sharing the same core (e.g., "exfoliating toner pads", "exfoliating toner pad for face", "acid exfoliating pads") can share one campaign if they're semantically tight. Terms that are distinct enough to warrant independent bid control get their own campaign.

5. Add the harvested term as a Negative Exact in the source campaign

   This is the step most sellers skip — and it's the most important one.

   For every customer search term you graduate to an exact-match campaign, add that query as a Negative Exact in the campaign where it was discovered (your auto or broad campaign). Without this step, your auto and broad campaigns continue bidding on the same query as your new exact campaign — you end up competing against yourself in the same auction, inflating your own CPC and splitting attribution between two campaigns.

   In Seller Central: open the source campaign → Negative Keywords → Negative Exact → paste the term.

   If you graduated multiple terms in one harvesting session, add all of them to the source campaign's negative list in one batch.

6. Repeat weekly

   Set a calendar reminder. The loop compounds over time — the first cycle finds 3–5 proven terms; after 8 weeks of consistent harvesting, most accounts have a portfolio of 15–40 exact-match campaigns covering their best-converting queries at optimized bids. The auto and broad campaigns continue discovering new terms while your exact campaigns compound the ones already proven.

   Also see Negative keyword management for the full pruning workflow — harvesting positives and pruning negatives are complementary disciplines.