Negative Keyword Cleanup with Claude and the Seller Labs MCP

You have read access to my Amazon Ads and sales data. Don't change anything without my approval.
1. List my current campaigns and the products each one covers. Flag any campaign that mixes different product formats.
2. Propose a structure with one campaign per product format, each with its own keyword list pulled from search terms that already convert for that format.
3. For every change you want to make (new campaign, bid, budget, negative), tell me what and why, and wait for my yes.
4. Each week, report spend, CPC, sales and units by product format against the week before.

Here is my search term report for the last [14] days [attach].
Give me, in plain English: the search terms wasting money (spend over $[x] with no orders) and the ones worth scaling (orders with ACoS under [y]%).
For each, the exact change you'd make. Don't make any change until I confirm it.

I'm attaching two files for the same brand: the Sponsored Products search term report for the last 60 days and a Helium 10 Cerebro export of the brand's organic ranks.
Match them by keyword and give me three lists:
1. Keywords where we already rank organically in the top 10 but still spend heavily on ads (candidates to cut spend).
2. Keywords ranked 11-40 with good conversion in the ads data (candidates to push toward page 1).
3. Keywords with spend and no organic rank at all.
Show spend, sales, ACoS and organic rank for each row.

You are my Amazon data engineer. Write a plain-Python script (standard library only) that:
1. Uses my Amazon Ads API refresh token to pull daily Sponsored Products campaign stats and the full search-term report for the last 30 days, plus the same 30-day window last year.
2. Uses SP-API to pull Sales & Traffic by ASIN, FBA inventory, and customer returns for the same windows.
3. Saves everything as one JSON bundle per day.
Then write a reconciliation check: for a date I choose, print total spend, clicks, orders and sales so I can compare them against my current PPC tool. Do not make any write calls to Amazon.

Find all keywords across all campaigns that have spent more than $50 with zero sales in the last 30 days.

You are my weekly Amazon PPC auditor. First read my goals sheet: target ACOS, target TACOS, monthly sales target and daily budget per campaign.
Then, from the campaign and search-term reports I attach for the last 7 and 30 days:
1. List every campaign that is off target, and by how much.
2. Propose specific changes (bid changes, negatives, budget moves, pausing) that move each one toward its goal. Give the reason and the data behind each.
3. Put the changes in a table with an Approve/Reject column. Change nothing yourself.