A Claude PPC Overhaul That Sank ROAS (Cautionary)

Review my Sponsored Products targets for the last 30 days. For each target with ACOS above [X]% or more than [N] clicks and no sales, recommend lower bid, pause or keep, with the reason.
Show the list first; only make the changes I approve.

Here are my keyword performance export and targets: target ACOS [X]%, harvest after [N] orders, negate after [M] clicks with 0 orders.
List search terms to promote to exact match and terms to add as negatives, with the campaign and ad group for each, as a Sponsored Products bulk file I can review before upload.

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.

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.

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.