Amazon DSP Campaign Planning and Weekly Reporting with Claude

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.

Act as my Amazon launch operator for a new SKU. Step by step, and wait for my approval between steps:
1. From the keyword and competitor data I paste below, pick the 15 highest-intent keywords and explain why.
2. Write a title, 5 bullets and backend search terms using those keywords. No claims I haven't given you.
3. Propose a launch campaign structure (Auto, a Discovery/broad campaign, and an exact-match Sales campaign) with starting bids and daily budgets calibrated to the CPCs in the data.
Product details: [paste]
Keyword + competitor data: [paste]

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.