How to find wasted search terms and add negative keywords in Amazon Search Term reports

When Amazon ad spend goes up but orders don't follow, many sellers' first reaction is to cut the budget. My habit is to check the Search Term report first, because wasted terms are usually hidden in the actual search terms, not in the campaign names. In terms of operation, first pull 7 to 14 days of data and sort by spend, clicks, orders, and ACOS. For terms with many clicks but no conversions…