PPC & Ads · from a YouTube video, Sep 15, 2026 · Added

Keyword Research and Harvesting Report Skill with Claude, Scale Insights and Data Dive

Combine rank tracking and ad data into one keyword report that shows market trend, missing exact-match keywords and what to harvest

On a test brand the report showed the top-20 keyword market down 12% from the same month last year, which he reads as a cue to lower spend and trim keywords.

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
Using my Scale Insights and Data Dive connections, for ASIN [ASIN] in [account]: 1) show last 30 days' sales, TACoS and break-even ACoS; 2) sum search volume for my top 20 Rank Radar keywords by month and compare with the same month last year; 3) list those 20 keywords with search volume, my conversion vs market conversion, organic rank, and whether each is in an exact-match campaign; 4) list converting auto/broad search terms not yet in exact, with search volume, and mark which are too small to bother moving. Don't change any campaigns.

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 YouTube video

What they did

A team leader at Trainadz, an agency that says it oversees over $10 million a month in Amazon ad spend for 150+ brands, built a Claude skill that runs on two MCPs: Scale Insights (ad data) and Data Dive (Rank Radar and master keyword list). You upload the skill, name the account and the ASINs (he suggests starting with one), and it reports per product: last-30-day sales, break-even ACoS, TACoS, combined search volume of the top 20 tracked keywords and its year-over-year change; the top 20 keywords with search volume, market and own conversion, click and purchase share, organic rank and whether each is in exact match; the keywords with the most spend; and a harvesting list of converting broad and auto terms with their search volume.

How it went

On a test brand the report showed the top-20 keyword market down 12% from the same month last year, which he reads as a cue to lower spend and trim keywords. The harvesting table let him leave very low-volume converting terms in auto instead of adding them to exact, and it surfaced terms found only through PPC that weren't in the master keyword list. He says 'I completely automate my harvesting process,' and shares the skill in the video description.

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

Worth knowing

Year-over-year numbers need a year of history in Data Dive and Scale Insights. The video is from the agency's own channel and promotes its community.

Original source

YouTube videoTrainadzPublished Sep 15, 2026 · youtube.com https://www.youtube.com/watch?v=PC0OVdBObhMOpen the source

Keep going

Related use cases

PPC & AdsShows real resultsOlder post · Apr 2026

Stockout Ad Pausing with Claude

Pause ads when a SKU goes out of stock and restart them before it returns
$130/day“the pause saved about $130/day in wasted spend” self-reported
ToolsClaude, Scale InsightsSourceX post · AI Ecom OperatorSharedApr 30, 2026PromptWritten by us
Show promptHide prompt for Stockout Ad Pausing with Claude,Written by us
Every morning, check my FBA inventory and my Sponsored Products campaigns.
- If an advertised ASIN has 0 sellable units, list every campaign/ad group advertising it and recommend pausing them. Estimate the daily spend at risk.
- If an ASIN I paused for stockout now shows inbound units received at FBA, recommend re-enabling exactly those campaigns before the listing goes back in stock.
Never act without my explicit approval. Show me a table: ASIN, stock status, campaigns affected, recommended action.

PPC & AdsShows real results

Overnight Bid Fixes Across 3,000 Campaigns with Claude and an Owned Data MCP

Sync all Amazon Ads and Seller Central data into your own database and let Claude propose and run approved changes
$15k to $20k“each saving $15k to $20k a year” agency-reported
ToolsClaudeSourceReddit thread · u/dhiraj18SharedOct 17, 2026PromptWritten by us
Show promptHide prompt for Overnight Bid Fixes Across 3,000 Campaigns with Claude and an Owned Data MCP,Written by us
Using my connected Amazon data, run this morning check for [brand]:
1. Campaigns whose budget ran out before [6 PM] yesterday.
2. Campaigns with ACOS above [X]% yesterday compared with their 14-day average.
3. Campaigns with zero impressions.
4. Listings suppressed since yesterday.
5. ASINs with under 14 days of cover that still have ads running.
6. Every bid, budget or status change made yesterday and who made it.
Write a plain-English plan of fixes and wait for my approval before changing anything.

PPC & AdsShows real results

Seven EU Marketplaces Run on Claude Skills and MCP Account History

Turn your own bid and rank rules into Claude skills that propose changes from full account history
€1,445“spent €43 in a month and brought €1,445 in sales” self-reported
ToolsClaudeSourceReddit thread · u/Bony377SharedOct 15, 2026PromptWritten by us
Show promptHide prompt for Seven EU Marketplaces Run on Claude Skills and MCP Account History,Written by us
Using my connected account data with at least 90 days of history (ad spend, organic rank, Brand Analytics, stock and margin per SKU), apply these rules:
1. If a keyword's ad spend rose over the last [14] days but its organic rank didn't improve, propose a bid cut.
2. If organic rank is climbing and margin per unit is above [X], propose a bid increase.
3. List every campaign with ACOS under [5]%, with its spend and sales.
Show the data behind every proposal and don't change anything until I approve.

PPC & AdsShows real results

Search Term Report vs Cerebro Ranks with Claude

Find where ad spend overlaps organic rank and where to push for page 1
+22.90%“$832k every 2 months (+22.90% YoY)” agency-reported
ToolsClaude, Helium 10SourceX post · George Schwartz (Extension eCom)SharedOct 11, 2026PromptWritten by us
Show promptHide prompt for Search Term Report vs Cerebro Ranks with Claude,Written by us
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.

PPC & Ads

Rank Moves to Bid Changes with Claude and Helium 10 MCP

Turn organic rank changes into specific bid raises and cuts ToolsClaude, Helium 10SourcePodcast episode · Ramzan Malik (via AM/PM Podcast #552)SharedSep 5, 2026PromptWritten by us
Show promptHide prompt for Rank Moves to Bid Changes with Claude and Helium 10 MCP,Written by us
Pull organic rank for my catalog and join it to my Sponsored Products search term report for the last 30 days. Score keywords with a volume-weighted rank index. Propose 10 bid raises where organic rank slipped but conversion is strong, and 10 bid cuts where organic rank is strong and paid clicks are wasteful. Name the ad group and current bid for each. Don't change anything.

PPC & AdsShows real results

Amazon DSP Campaign Planning and Weekly Reporting with Claude

Plan, build and report Amazon DSP campaigns across several marketplaces
€277,000“€277,000 of attributed DSP sales, a ROAS of 19.4” agency-reported
ToolsClaudeSourceBlog post · e-Comas (with Marc Villaseca)SharedJul 17, 2026PromptWritten by us
Show promptHide prompt for Amazon DSP Campaign Planning and Weekly Reporting with Claude,Written by us
Here are my Amazon DSP exports for the last 4 weeks: campaign report, reach and frequency, and device breakdown.
1. Show average frequency per line item by market and flag any above 7.
2. Show spend share and ROAS by device type and suggest bid-modifier changes.
3. List the 5 changes you'd make before the next flight, each with the number that supports it. Don't assume data that isn't in the files.