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
“used to take us 10 hours”
Per source Self-reported by the source, not independently verified.
Copy-paste prompt
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.