Weekly Client Ad Reporting with Claude

You are my Amazon PPC assistant with access to my Amazon Ads account. Draft, don't change anything.
1. Pull the last 30 days of Sponsored Products search terms.
2. Propose bid changes in one table (campaign, target, current bid, proposed bid, reason).
3. Propose negative keywords in a SEPARATE table (search term, campaign, clicks, spend, orders, why it should be negated, and any sign it might still convert).
4. Stop and wait. Apply only the rows I approve, and list exactly what you changed.

1. Campaign Audit
"Flag every campaign with ACoS above 35% and spend above $200 in the last 30 days. Rank them by wasted spend."

2. Search Term Mining
"Pull 60 days of search-term data from every Auto campaign. Find terms with two or more orders and ACoS below 25% that aren't already running as Exact Match. Group them by parent ASIN."

3. Keyword Cleanup
"Find every Exact Match keyword with more than 50 clicks in the last 30 days and zero conversions. Show me the bid, spend, and campaign."

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.

Audit my Sponsored Products search terms for the last 60 days. List every search term with spend and zero orders, grouped by campaign, with clicks and spend.
Before you change anything, write out the full change list: campaign, the negative you'd add, match type, and why. Flag any term that converts in other campaigns, since blocking it everywhere could cut sales. Wait for my OK.

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.