Free agents + LAUNCH30: 30% off paid agents until 31 Dec 2026 (one-time purchases only) See free agents
Oarsman AI Sign in

Amazon Search Term Cleaner / Docs

Amazon Search Term Cleaner: setup guide

A summary of wasted spend from your downloaded Search term report, with the top 10 terms to add as negatives and the top 10 converting terms to add as exact keywords.

Who it is for: Amazon seller or small agency running Sponsored Products ads, spending $300-$30,000 (₹25k-₹25 lakh) a month, who checks search terms by hand in a spreadsheet.

Format: Claude skill pack · Version: 1.0.1 · Tested on: Python 3.13.5 (standard library only)

What it does

You give it your Search term report. It reads the classic and the newer column layouts in any currency, adds up daily rows per campaign, ad group and search term, and applies plain rules. A term is a negative when it has enough clicks with no order, or has spent more than your average cost per order with no order. ASINs are marked as negative product targets. A converting term at or under your target ACOS that is not already an exact keyword is listed to add, with a start bid. Brand words you protect are never negated. The report gives the full counts and lists the top 10 of each.

What you need

  • Claude.ai with code execution switched on (or Claude Code, or Python 3.10+)
  • A Search term report downloaded from Amazon Ads > Measurement & Reporting > Sponsored ads reports
  • No Amazon login is needed or used

5-minute setup

  1. Claude.ai: open Settings → Capabilities → Skills, click Upload skill and pick claude-ai-upload/amazon-search-term-cleaner.zip.
  2. Claude Code: copy the folder skills/amazon-search-term-cleaner into ~/.claude/skills/.
  3. Start a new chat. Attach your file and say: "Use amazon-search-term-cleaner. My target ACOS is 30% and my brand is AquaPeak. What should I negate in this report".
  4. Claude runs the script and gives you the files listed under Outputs. Check them before you act on them.

Try it with the sample

Run the sample (a fictional report):

python3 skills/amazon-search-term-cleaner/scripts/core.py --report samples/search-term-report-sample.csv --target-acos 30% --protected aquapeak --out out

You should see 5 negatives costing 1,870.00 with no orders, 3 keywords to add and the brand term kept. In Claude, attach your report and use the prompt above.

Settings you can change

Option Default What it is
--report (required) Sponsored Products Search term report you downloaded from Amazon Ads (CSV or XLSX)
--target-acos 30% Your target ACOS. 0.3, 30 and 30% all mean 30%
--min-clicks 10 Clicks with no order before a search term is suggested as a negative
--harvest-min-orders 2 Orders a search term needs before it is suggested as an exact keyword
--protected (none) Comma-separated words never to negate, such as your brand
--out out Output folder

What goes in and what comes out

Inputs: One Sponsored Products Search term report (CSV or XLSX); Target ACOS; Optional brand words never to negate

Outputs: report.md with spend, ACOS and counts; top-negatives.csv (top 10); top-keywords-to-add.csv (top 10)

What Pro adds

  • Every negative and keyword, not just the top 10
  • Negative phrases: words that waste money across many search terms
  • Bid cuts for converting terms far above target ACOS
  • Several reports merged, with overlapping days counted once
  • A target ACOS per campaign (for example Brand 15%)

Pro: https://oarsmanai.com/agents/amazon-search-term-cleaner-pro/

AI disclosure and limits

This product does not call an AI model at run time. It was built by Oarsman AI's AI agents and checked by the automated tests shipped with it.

Limits: - Lists the top 10 negatives and top 10 keywords; the counts cover everything. - One report per run. - Read-only: you make each change in Campaign Manager. - Sponsored Products Search term reports only. - With few clicks a term can look bad by chance; raise --min-clicks for small accounts.

Not tested by us: - reports from every Amazon marketplace (tested: classic and new column layouts, INR and USD) - XLSX reports in the shipped tests (CSV only) - the effect of the changes on your sales

Files

  • oarsman-amazon-search-term-cleaner-v1.0.1.zip
  • CHANGELOG.md
  • QA-REPORT.json
  • README.md
  • SPEC.md
  • SUPPORT.md
  • TROUBLESHOOTING.md
  • VERSION
  • VIDEO-SCRIPT.md
  • claude-ai-upload
  • diagram.mmd
  • diagram.png
  • preview.png
  • samples
  • skills
  • tests

Help

Self-serve: see TROUBLESHOOTING.md (fixes and FAQ). There is no call, chat or email support. Fixes ship as new versions at your download link. Refund: 14 days, works as described, through the checkout platform.