Daily 5:30 AM PPC Waste Report with Claude Code and the Ad Badger MCP

Use the wasted-ad-spend-dashboard skill on [brand] for the last 30 days. Rank by spend, draft a negatives list for my approval, and log what we did under `initiatives/wasted-spend-[date]/`.

You are the strategy agent in my Amazon PPC system. You do NOT execute changes. Each day:
1. Read the bidding agent's proposed bid changes and the inventory agent's stock alerts (pasted below).
2. Resolve conflicts with this priority: inventory risk > profitability > growth. Example: never approve a bid increase on an ASIN with < 14 days of stock.
3. Ignore any recommendation driven by a single day of data unless it's confirmed by the 7-day trend.
4. Output an approval queue for me: change, agent, reason, conflict resolved (Y/N).
Bidding agent proposals: [paste]
Inventory agent alerts: [paste]

Read [library repo] and the Amazon [Ads / SP-API] reference for [endpoints I need].
Build a CLI with read-only commands first: [list campaigns, pull search term report, get FBA inventory].
Then write a skill that explains when to call each command. Don't add any command that changes bids, budgets or listings until I ask.

Build me a match type harvester for my Amazon ad account. Ask me before any code: my target ACoS; my minimum spend floor (below this, ignore noise); my minimum conversion floor (below this, a term doesn't qualify for promotion); my conversion attribution window (7, 14, or 30 days); and the percentage above current CPC I want to bid when promoting a term to a tighter match type. Don't assume defaults.

Ask me to paste my Sponsored Products search term report CSV (Campaign Manager reports tab, last 30 days) or confirm I have live Amazon Ads data wired through an MCP. If I paste the CSV, treat the first row as headers and confirm which columns you're mapping to spend, clicks, orders inside the attribution window, ACoS, campaign, ad group, customer search term, match type of the targeting keyword, CPC, and advertised ASIN.

Classify every customer search term. A term qualifies for promotion to phrase match if its current targeting keyword is broad match, has spend above my floor, has orders above my floor inside my attribution window, and has ACoS at or below my target. A term qualifies for promotion to exact match if its current targeting keyword is phrase match and meets the same volume and ACoS criteria. Anything draining spend with zero orders gets flagged for negative keyword addition to the original broad keyword.

Output one decision table, one row per customer search term. Columns: current match type, recommended match type, advertised ASIN, spend, clicks, orders, ACoS, current CPC, recommended starting bid (current CPC plus my premium), recommended negative keyword adds for the original broad keyword, one-line reason. Then bundle promotions by advertised ASIN: for each ASIN with three or more promotions, output the suggested ad group structure (one exact match ad group per SKAG, one phrase match ad group containing the phrase-tier terms, plus the negative keyword list for the original broad keyword). If I ask for it, also produce the same structure formatted for the Amazon Sponsored Products bulk operations template (entity type, operation = create, campaign name, ad group name, match type, keyword text, bid) so I can upload it directly. No auto action. Every promotion and every negative keyword add waits for my approval.

For each of my Amazon markets [list], read the last 14 days of Sponsored Products data [attach].
Give me one page per market: spend vs target, the 5 biggest wasted-spend terms, the 5 best terms not yet in exact match, and budget-capped campaigns.
Rank markets by how urgently they need attention. Don't change anything.

Pull my Sponsored Products search term report and the Brand Analytics search terms report for [ASIN] since [date of last bid change; avoid Prime Day/BFCM].
1. Search terms in broad, phrase or ASIN campaigns with at least [2] orders that I don't target as exact.
2. Organic search terms where my product was purchased or added to cart that I don't advertise on (include misspellings).
3. Targets whose ROAS is well above or below [4], ignoring anything with less than $[10] spend.
Check every suggestion against my existing targets. Don't change anything; list proposed campaigns with settings and bids for my approval.