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

$5,000

“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

Copy-paste promptPrompt written by us, based on this case
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.

Original source

YouTube videoStefano Pretto (Trainadz) (Trainadz)Published Apr 14, 2026 · youtube.com https://www.youtube.com/watch?v=g07ll3rwhRQOpen the source

Keep going

Related use cases

PPC & AdsShows real results

Amazon PPC Campaigns in 15 Minutes with Claude and PPC Assist

Set up a batch of new Sponsored Products campaigns from a product, keyword and structure brief
15 minutes“done within 15 minutes at most” self-reported
ToolsClaude, PPC AssistSourcePodcast episode · Rainer Langer (Der MarkenMacher Podcast)SharedNov 17, 2026PromptWritten by us
Show promptHide prompt for Amazon PPC Campaigns in 15 Minutes with Claude and PPC Assist,Written by us
You're setting up new Amazon Sponsored Products campaigns through my ads tool connection. Products: [ASINs]. Keywords: [list]. Structure: [one campaign per match type / keyword group], daily budget [$x], starting bid [$y], bidding: [fixed bids]. Ask me about anything unclear first. Then show me every campaign, ad group, keyword, budget and bid for approval. After I approve, create them, then read them back and list anything that doesn't match the plan.

PPC & AdsShows real results

80/20 PPC Audit and Exact-Match Campaign Builder Skills with Claude

Find the SKUs and search terms that drive most ad sales, then build exact and broad campaigns with break-even bids
10 hours“used to take us 10 hours” self-reported
ToolsClaudeSourceYouTube video · Dr. Travis Zigler (Profitable Pineapple)SharedNov 10, 2026PromptWritten by us
Show promptHide prompt for 80/20 PPC Audit and Exact-Match Campaign Builder Skills with Claude,Written by us
Using the attached Sponsored Products search term report and business report (child ASIN, same date range): 1) list the SKUs and search terms that make up 80% of sales and ad sales, 2) list search terms with spend and zero orders, 3) for search terms with 3+ orders, build single-keyword exact campaigns with a starting bid = (price - COGS - Amazon fees) x conversion rate, using my COGS and fees: [paste]. Output a sheet. Don't pause anything.

PPC & Ads

Daily Amazon Ad Suggestions from Claude, Reviewed by Codex

Get daily Amazon ad change suggestions, with a second AI checking them before anything changes ToolsClaude, CodexSourceX post · runthatBMCSharedNov 10, 2026PromptWritten by us
Show promptHide prompt for Daily Amazon Ad Suggestions from Claude, Reviewed by Codex,Written by us
You are reviewing another AI's proposed Amazon ad changes before they go live. Here are my rules: [paste rules, e.g. max bid, ACoS target, brand terms never negated], yesterday's report: [paste], and the proposed changes: [paste]. Approve or reject each change with a one-line reason, flag any that break a rule or rest on fewer than [10] clicks, and output only the approved list.

PPC & Ads

20 PPC Skills with Human Approval in Claude and the Amazon Ads MCP

Run day-to-day PPC work through Claude without letting it change the account unreviewed ToolsClaude, Amazon Ads MCP ServerSourceX post · Sam VelezSharedOct 28, 2026PromptWritten by us
Show promptHide prompt for 20 PPC Skills with Human Approval in Claude and the Amazon Ads MCP,Written by us
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.

PPC & Ads

Reading 4,000 Search Terms with Claude

Hand the weekly search term report sweep to Claude and approve each change ToolsClaudeSourceX post · Daniel PopaSharedOct 27, 2026PromptWritten by us
Show promptHide prompt for Reading 4,000 Search Terms with Claude,Written by us
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.

PPC & Ads

Shared Change Log Across Claude and Grok Bot

Log every ad change made by any AI tool and review whether it worked ToolsClaude, Grok Bot, KwickMetrics MCPSourceYouTube video · Karthick Selvaraj (KwickMetrics) on Orange KlikSharedOct 27, 2026PromptWritten by us
Show promptHide prompt for Shared Change Log Across Claude and Grok Bot,Written by us
Before suggesting anything, read tracker.csv in my [repo] for the last 90 days on [brand]. List changes still waiting on review and their due dates. If you make any change to my ads, append a row: date, tool, brand, campaign, what changed, why, expected result, and review date 14 days out. Don't change a campaign that has an open review.