PPC & Ads · from a Blog post, Aug 26, 2026 · Added

Weekly Amazon Ads and Organic Dashboard with Claude Code

Turn weekly Business Report and ads downloads into dashboards and an AI-written recap, and catch wrong numbers

While extending the dashboard he found that some of the numbers were wrong, and some of the reporting logic had already passed two live reporting cycles: Budget Amount was being summed as actual ad spend, a join created a phantom blank-date row that distorted spend, and a blend compared campaign names across platforms that don't share them.

Per source Reported by an agency about its own client work, not independently verified.

Copy-paste prompt

Copy-paste promptPrompt written by us, based on this case
I'll give you this week's Business Report (by child ASIN) and Sponsored Products, Brands and Display reports. Clean them, check for duplicate rows and dates already in my sheet, and append one row per ASIN and per campaign for the week. Calculate sessions, CVR, units, sales, ad spend, ad sales, ACOS, ROAS, TACOS and organic sales (total minus ad sales). Use actual spend, never budget. Then write a 5-line recap and list any total that doesn't match the report totals.

The source didn't publish its exact prompt. We wrote this starter so you can try the same workflow. Replace anything in [brackets].

See the original Blog post

What they did

Toshiki Gealone built a weekly reporting system for a real seller account he works with. He downloads the Business Report and Ads reports from Seller Central, runs two saved prompts in Claude Code, and it cleans the data, calculates the week, checks for duplicates, appends it to Google Sheets and writes a weekly recap. Looker Studio dashboards show sessions, sales, CVR, ASP, units, ad spend and sales, ACOS/ROAS, TACOS, organic vs ad-driven sales, SKU, campaign and placement performance, and Subscribe & Save subscriber trends. He left Buy Box % out because the brand is the only seller on its ASINs.

How it went

While extending the dashboard he found that some of the numbers were wrong, and some of the reporting logic had already passed two live reporting cycles: Budget Amount was being summed as actual ad spend, a join created a phantom blank-date row that distorted spend, and a blend compared campaign names across platforms that don't share them. He cross-checked every corrected figure against Amazon's Ads Console before finalizing.

We only report what the source says. Results are self-reported unless noted.

Worth knowing

Work for a client, with a video of the workflow and dashboards. His point: "nothing looked obviously broken. The totals were simply slightly wrong," so check AI-built reports against the Ads Console before you trust them.

Original source

Blog postToshiki Gealone (Toshiki Gealone (LinkedIn))Published Aug 26, 2026 · linkedin.com https://www.linkedin.com/posts/toshikigealone_aiautomation-amazonppc-amazonadvertising-activity-7498247387522457600-2mxVOpen the source

Keep going

Related use cases

PPC & AdsShows real results

New Ad Account Onboarding and a Rule Scoreboard in a Claude Code Workspace

Set up a new Amazon ad account in an existing AI workspace and track which bidding rule drove each change
367 changes“last week 367 changes went to Amazon with 0 upload errors” self-reported
ToolsClaude CodeSourceX post · Sam VelezSharedNov 10, 2026PromptWritten by us
Show promptHide prompt for New Ad Account Onboarding and a Rule Scoreboard in a Claude Code Workspace,Written by us
For every bid, budget and negative-keyword change in this week's upload file, add a column naming the single rule from my rulebook that triggered it. Then, for changes made 14+ days ago, roll up results per rule: number of changes, spend, sales and ACoS before vs after. List rules with a losing record first. Don't edit the rulebook; propose changes for me to approve.

PPC & AdsShows real results

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

Get a wasted-spend and Buy Box report in chat every morning without asking
$6,700“one brand spent $6,700 on zero-order search terms over 30 days” vendor claim
ToolsClaude Code, Ad Badger MCPSourcePodcast episode · Michael Erickson Facchin (The PPC Den #405)SharedOct 16, 2026PromptWritten by us
Show promptHide prompt for Daily 5:30 AM PPC Waste Report with Claude Code and the Ad Badger MCP,Written by us
Build me a daily report that runs at 5:30 AM on my computer and posts to my chat.
Write a Python script (don't do the math yourself) that pulls the last 30 days of search terms through my ads data connection and calculates: spend on zero-order search terms and its share of total spend, the last 15 days vs the prior 15, top 10 non-converting search terms and n-grams by spend, and what ACoS would be with no zero-order spend.
Then write a short executive summary from the script's output only, and list suggested negatives for me to approve.

PPC & Ads

Multi-Agent PPC Management with Claude Code

Run separate bidding, inventory and strategy agents on an Amazon ad account ToolsClaude Code, CodexSourceReddit thread · u/ScribbleSparkSharedJul 28, 2026PromptWritten by us
Show promptHide prompt for Multi-Agent PPC Management with Claude Code,Written by us
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]

PPC & Ads

Turning APIs into CLIs and Skills for Seller Central and Ads with Claude Code

Have Claude Code wrap an API in a command-line tool and skill for back-office and ads work ToolsClaude CodeSourceX post · Nick SpisakSharedJun 5, 2026PromptWritten by us
Show promptHide prompt for Turning APIs into CLIs and Skills for Seller Central and Ads with Claude Code,Written by us
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.

PPC & AdsShows real results

Match-Type Harvesting with Claude Code

Promote converting search terms from broad to phrase to exact and add negatives
doubled“three months later the seller had 40 campaigns and his ROAS had doubled” vendor-affiliated
ToolsClaude CodeSourceYouTube video · Seller Labs (Nhan Dinh)SharedMay 14, 2026PromptSeller's own prompt
Show promptHide prompt for Match-Type Harvesting with Claude Code,Seller's own prompt
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.

PPC & AdsOlder post · Apr 2026

Two People Running 20 Amazon Markets with a Claude Code Agent System

Replace an agency team with an agent system for Amazon PPC across many brands and markets ToolsClaude Code, CodexSourceX post · Alex KovalovSharedApr 15, 2026PromptWritten by us
Show promptHide prompt for Two People Running 20 Amazon Markets with a Claude Code Agent System,Written by us
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.