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
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.