The N-Gram Analyzer at https://sheets.adbadger.com/ngram finds the words draining your ad spend.
How it works
Drop your Amazon Ads bulk file. The tool reads the Sponsored Products search term report inside it and splits every customer search term into word patterns: single words, pairs and triples. It then shows which patterns have spent money across many search terms without producing a sale.
The wasted spend figure is the spend on search terms that never sold. It is counted once per search term, never added up across patterns, because one search term feeds several patterns and adding them would double count.
The tool runs in your browser. The file is not uploaded and no account is needed to see the preview.
Getting the full breakdown
The preview shows the top patterns. To see every pattern plus your high-ACOS words, enter your work email and The Badger sends a one-click link to the full report. There is no password. The report is attached to your Badger Sheets account, so it is waiting for you in your audits.
"No Search Terms In That File."
The bulk file was exported without Sponsored Products search term data. Go back to Bulk operations in Amazon Ads, tick the option that includes search term data, download the file again, and drop it.
Very large accounts
If the tool says the account's data is too large to email, the full breakdown is still available in your browser through the in-browser audit at https://sheets.adbadger.com/local, where no email is needed.