PPC & Ads · from a YouTube video, Apr 14, 2026 · Added
N-Gram Wasted Spend Analysis Skill with Claude Cowork
Break every search term into one-, two- and three-word patterns to find words wasting ad spend and add them as negatives
“more than $5,000 in wasted ad spend on one account in less than 30 seconds”
Per source Reported by an agency about its own client work, not independently verified.
Copy-paste prompt
From this Sponsored Products bulk file, split every customer search term into 1-, 2- and 3-word n-grams (skip ASINs). For each n-gram show spend, clicks, orders, sales and ACoS. Flag n-grams with [15]+ clicks and 0 orders, and those with ACoS above 1.5x the account average. Output an Excel sheet and a list of suggested negative phrase terms, but don't add any negatives yourself.
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
Stefano Pretto, founder of Trainadz, runs an N-gram analyzer skill inside a Claude Cowork project set up as his 'Amazon PPC manager.' He starts a new task, attaches an Amazon Ads bulk file, and calls the skill. It installs Python libraries, runs an analyzer script that aggregates search terms, strips ASINs and scores every 1-, 2- and 3-word pattern, then outputs an Excel file and a PDF with average ACoS, a high-ACoS threshold at 1.5x the average, and patterns with high ACoS or no orders.
How it went
He says 'I found more than $5,000 in wasted ad spend on one account in less than 30 seconds.' In the demo, the one-gram 'collagen' had spent $50 over 29 clicks with zero orders, which he calls irrelevant for the product and a candidate for negative phrase. He then asked Claude to add two-gram analysis to the skill so the next run includes it.
We only report what the source says. Results are self-reported unless noted.
Worth knowing
The video title says $4,200 while he says more than $5,000 on camera; we quote what he says. He advises asking Claude whether any downloaded skill is safe before running it. The skill is shared through the agency's community.