PPC & Ads · from a YouTube video, Nov 10, 2026 · Added

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”

Per source Self-reported by the source, not independently verified.

Copy-paste prompt

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

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

Dr. Travis Zigler, who owns Amazon brands (including the lip balm and moth-trap brands his firm bought in June 2026) and manages about 30 client accounts, runs three Claude skills inside a Claude project for each brand's PPC. He downloads a Sponsored Products search term report and two business detail reports and runs an 80/20 audit skill, then a keyword velocity finder on the saved reports, then a search term scaling engine. The last one outputs a Google Drive workbook with single-keyword exact campaigns for terms with 3+ orders, broad campaigns for terms with 10+ orders, negative keyword lists, and a max CPC per term worked out as profit per sale times conversion rate.

How it went

On his own account the audit found that 8 of 67 SKUs (11.9%) produced 80% of sales and that 819 of 8,497 search terms drove 80% of ad sales, and it flagged zero-order spend above his 20% baseline, up from 19.8% in his August audit. The scaling engine listed 288 new exact-match campaigns and put wasted ad spend at 35% after an aggressive September. He says the work 'used to take us 10 hours' and Claude did it 'in less than the time of this presentation.'

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

Worth knowing

Recorded as a live demo on his own account; the big ACoS and sales charts earlier in the video come from his pre-AI strategy, not from these skills. He sells a paid challenge built around the skills. He still reviews negatives and never lets the skill pause a product.

Original source

YouTube videoDr. Travis Zigler (Profitable Pineapple) (Dr. Travis Zigler | Profitable Pineapple)Published Nov 10, 2026 · youtube.com https://www.youtube.com/watch?v=ZJRgR2pCoI0Open the source

Keep going

Related use cases

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.

PPC & Ads

Weekly SQP Intent Sorting, Profit Checks and Reorder Alerts with Claude

Run weekly search-query, search-term, profit and stock checks for a 35-SKU brand through Claude ToolsClaudeSourceReddit thread · u/KaleidoscopeEarly257SharedOct 21, 2026PromptWritten by us
Show promptHide prompt for Weekly SQP Intent Sorting, Profit Checks and Reorder Alerts with Claude,Written by us
Here is my Search Query Performance report for last week: [paste or attach].
1. Group every query into intent buckets (for example install, renter, outdoor, room, material) and show impressions, clicks, purchases and purchase share per bucket.
2. List queries where my purchase share is higher than my impression share.
3. Flag growing queries that don't appear in my title, bullets or A+: [paste listing].
Don't change any bids. Give me proposed Top of Search increases for half of the queries from step 2 and keep the other half as a control group.

PPC & AdsShows real results

Replacing a PPC Agency with Claude and the Seller Labs MCP

Take Amazon ads back in-house from a $15,000/month agency
$75,000 a month“he was saving about $75,000 a month” vendor-affiliated
ToolsClaude, Seller Labs MCPSourceX post · Nhan Dinh (Seller Labs)SharedOct 19, 2026PromptWritten by us
Show promptHide prompt for Replacing a PPC Agency with Claude and the Seller Labs MCP,Written by us
You have read access to my Amazon Ads and sales data. Don't change anything without my approval.
1. List my current campaigns and the products each one covers. Flag any campaign that mixes different product formats.
2. Propose a structure with one campaign per product format, each with its own keyword list pulled from search terms that already convert for that format.
3. For every change you want to make (new campaign, bid, budget, negative), tell me what and why, and wait for my yes.
4. Each week, report spend, CPC, sales and units by product format against the week before.