PPC & Ads · from a YouTube video, Jun 4, 2026 · Added
Monthly Account Audit and Bulk Campaign Builder with Claude at Sellers Side
Audit every ad account monthly with one standard prompt and sort a keyword pool into a ready-to-upload campaign set
“wait about 5 minutes”
Per source Reported by an agency about its own client work, not independently verified.
Copy-paste prompt
Audit this Amazon ads account from the attached reports (search term, campaign, placement, search query performance, business report). Score and explain: ad type split, match type split, brand vs non-brand spend and ROAS, converting search terms not yet harvested to exact, budget utilization, and search-query share vs the market. Then list the 5 biggest problems by money at stake. Our focus metric is [non-branded ROAS].
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
Jonny Golding's agency Sellers Side, which he says manages about $130-140 million a year in Amazon revenue, asked its team what took the most time and automated those jobs with Claude. Audits: they upload a set of reports and a standard audit prompt compares search query performance benchmarks, ad type and match type split, brand vs non-brand, how many converting search terms are harvested, and budget utilization, then gives a score and an interactive dashboard they can question in Claude. Campaigns: they paste a whole search term pool, pick the campaign set they want, and the AI sorts keywords into use-case buckets (for a fitness shorts brand: sport, material, length) and outputs a bulk file.
How it went
He says the audit 'used to take a long time to get built through with a bunch of macros in Excel and now you just dump the reports in, wait about 5 minutes,' and get an interactive dashboard. They audit every account monthly, and for one brand doing nearly $100 million a year they add a line to focus on non-branded ROAS. A morning anomaly scan that flags keywords and products outside normal bounds was still being built.
We only report what the source says. Results are self-reported unless noted.
Worth knowing
He says AI reads data well but can't make strategic calls about where to take an account, so a human still decides. The video is an agency feature on the Orange Klik channel, with a link to the agency.