Amazon Search Term Report Analyzer

In the Amazon Ads console open Measurement & Reporting, then Sponsored ads reports. Create a report with Sponsored Products as the ad product, Search term as the report type, choose a date range (30 to 60 days works well), run it and download the .xlsx or .csv file.

No. The file is read and analysed entirely inside your web browser. Nothing is sent to Sotrics or anyone else, and nothing is stored after you close the page.

A search term becomes a negative keyword candidate when it has no sales and either reached your minimum number of clicks (10 by default) or spent more than one sale is worth at your target ACoS (your average order value x target ACoS). Always check relevance before negating.

Harvesting means taking customer search terms that already convert in auto, broad or phrase campaigns and adding them as exact-match keywords, so you can set their bid on their own. The tool lists terms with at least 2 orders at or under your target ACoS that are not yet targeted as exact.

Search terms that start with B0 are product pages where your ad was shown, usually from auto or product targeting campaigns. Converting ASINs can be added as product targets; non-converting ones as negative product targets.

Download a bulk file from Amazon Ads Bulk operations (Sponsored Products), add it in step 4, choose where harvested keywords should go and download the bulksheet. Check it in Excel, then upload it under Bulk operations. Amazon processes it and shows any rows it could not apply.

The standard Sponsored Products search term report in .xlsx or .csv, from both the old and the new Amazon Ads reporting. The tool finds the columns automatically, including Customer Search Term, Match Type, Targeting, Clicks, Spend, 7 Day Total Sales and 7 Day Total Orders.