Wasted spend

What you get

Find the search terms that take clicks and never sell. Start with a list, and move to negatives on Amazon when you trust it. The result is a Sheet of zero-sale, high-click search terms, costliest first, and, on Amazon, a dry run of proposed negatives.

The prompt

Paste a prompt into your AI tool. Each one points the tool at the docs and at your key, which stays in BUILD_API_KEY.

Wasted-spend sheet

For Zapier. Schedule: Mondays at 7.

Read https://build.sellermate.ai/SKILL.md. My key is in BUILD_API_KEY. Build me a Zapier zap that every Monday finds Amazon Ads search terms with 15 or more clicks and no sales in the last 30 days, and adds them to the Google Sheet wasted-spend, costliest first.

Negatives sweep

For Claude Code. Schedule: Mondays at 9.

Read https://build.sellermate.ai/SKILL.md. My key is in BUILD_API_KEY. Every week, find Amazon Ads search terms with 15 or more clicks and no sales, and list them as proposed negative keywords. Show me a dry run in #approvals, wait for my yes, then add only the approved ones, 50 at most, and keep a log.

Steps

1. Get a key

   Create a key in the console and save it as BUILD_API_KEY in your tool's secrets. See Get a key.

2. Paste the prompt

   Pick the prompt above for your tool and paste it. Change the names in it, such as the channel or the Sheet, to yours.

3. Run it once

   Check the first result against your own numbers before you schedule it.

4. Schedule it

   Ask your tool to run it on the schedule shown with the prompt.

Calls it makes

Data used

• get_search_term_performance

Variants

Add one of these to the prompt:

• Use 25 clicks as the limit.
• Add the campaign name to each row.
• Skip terms that contain your brand name.
• Only add exact negatives.