PPC & Ads · from a Reddit thread, Oct 21, 2026 · Added
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
The post is titled '$0 to Almost $300K/month in 3 years', the brand's growth over the three years he has run its ads, not a result of Claude alone.
Per source Reported by an agency about its own client work, not independently verified.
Copy-paste prompt
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.
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 Reddit thread
What they did
A freelance PPC manager who has run ads for a 35-SKU home improvement brand for three years describes what now runs on Claude. Every week the Search Query Performance report goes into Claude, which groups queries by intent (DIY install, renters, outdoor use, room, material), shows performance per intent and flags growing queries missing from the listing. Claude puts impression share next to purchase share for every query; where purchase share is higher, they raise Top of Search in steps on half of those queries and keep the other half as a control for about 14 days. His rules are written as Claude skills that run the search term report every Monday and propose changes he approves one by one. Claude on the desktop connects to their Amazon data through a custom MCP connector for true profit per SKU after fees, ads and returns, and a scheduled skill sends a weekly Slack alert with days of cover, over- and understock and reorder dates. Claude also sorts competitors' 1 to 3 star reviews by theme for listing images and bullets.
How it went
The post is titled '$0 to Almost $300K/month in 3 years', the brand's growth over the three years he has run its ads, not a result of Claude alone. About the profit dashboard he says: "It replaced Sellerboard for us." He also says Claude is "still very bad when it comes to ads management so I wouldn't recommend it for ppc execution", but it is worth it for analyzing a couple 100k search terms.
We only report what the source says. Results are self-reported unless noted.
Worth knowing
He is the brand's PPC freelancer, not the owner, and says so. The same post lists PPC tactics that don't use Claude (self-targeting, Amazon's AI video generator, Creator Connections); this case covers only the Claude work. Main-image test images were made with 'GPT 2', which isn't tagged here.