⌕

Search Term Harvester

Run an automatic campaign for a week or two, then download the Sponsored Products search term report. This tool sorts every customer search into three lists: terms to move into an exact-match manual campaign, terms to block as negatives, and competitor ASINs worth targeting. Your data stays in your browser.

1. Load the report

Seller Central → Reports → Advertising reports → Sponsored Products → Search term. Save as CSV, or open it in Excel, select all and paste below.

Drop a .csv file here, or

2. Rules

Rule of thumb: about 1.5 ÷ your conversion rate.

From automatic to manual campaigns

An automatic campaign lets Amazon decide where your ad appears. After one or two weeks the search term report shows the actual customer searches that triggered clicks and sales. The terms that converted at an acceptable ACoS belong in an exact-match manual campaign, where you control the bid. The terms that soaked up clicks without a single order should be added as negative keywords so you stop paying for them.

Ten-character codes starting with B0 are other products' ASINs. When one of them converts, a product-targeting campaign aimed at that ASIN is usually worth testing.

Frequently asked questions

How many clicks before a term counts as a negative?

A practical rule is about 1.5 divided by your conversion rate. At an 8% conversion rate that is roughly 19 clicks. Fewer than that and a zero-order term may simply be unlucky.

Is my report uploaded anywhere?

No. The file is read and processed in your browser only.

Part of the free Amazon seller tools on Central Web Tools. Not affiliated with Amazon.

Central Web Tools · About · Privacy · Terms · Contact · A CentVion product · Gifting by CentVion