PPC & Ads · from a Blog post, Feb 26, 2026 · Added

Amazon PPC Audit Gem from an Expert's Videos with Gemini

Turn a PPC expert's public videos into a reusable audit assistant and run your own reports through it

He calls it "Super simple" and shares the steps, not audit results.

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

Copy-paste prompt

Copy-paste promptPrompt written by us, based on this case
Using only the sources in this notebook, list every strategy, rule and procedure the speaker gives for optimizing Amazon PPC campaigns (bids, match types, negatives, placements, budgets), with the source for each. Then write instructions for an assistant whose job is to audit an Amazon brand's PPC from uploaded Business Reports, Search Query Performance reports and bulk files using these rules, and to say which rule each recommendation comes from.

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 Blog post

What they did

Jon Derkits, who runs an Amazon agency and the Best@Amazon newsletter, decided his company would build its AI tools in Google's suite after a Claude Code training stalled because his team had no Claude enterprise plan. He then rebuilt a friend's 'clone a PPC expert' project with Google tools: add the expert's YouTube channel to NotebookLM with a Chrome extension, add that notebook as a source in Gemini, have Gemini extract the strategies, tactics and procedures for optimizing Amazon PPC campaigns, then have it draft instructions for a Gem whose job is to audit a brand's PPC. Into that Gem he uploads Business Reports, SQP reports or bulk PPC files.

How it went

He calls it "Super simple" and shares the steps, not audit results. For a leadership team, the Gem can summarize its findings in a Canvas, or a separate brand-guidelines Gem can turn them into a slide deck.

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

Worth knowing

A how-to, with no ACoS, time or sales figures. The Gem only knows what the expert said on video plus the files you upload, so check its advice against your own targets before changing bids.

Original source

Blog postJon Derkits (Best@Amazon) (Best@Amazon newsletter)Published Feb 26, 2026 · bestatamazon.kit.com https://bestatamazon.kit.com/posts/same-same-but-differentOpen the source

Keep going

Related use cases

PPC & Ads

Monthly PPC Audit from Four Sponsored Ads Reports with Gemini

Turn four Sponsored Ads reports into keyword clusters, scale-ups, fix-or-kill targets and a 7-day plan ToolsGeminiSourcePodcast episode · Noah Wickham (My Amazon Guy podcast)SharedAug 20, 2026PromptWritten by us
Show promptHide prompt for Monthly PPC Audit from Four Sponsored Ads Reports with Gemini,Written by us
I'm attaching four Sponsored Ads reports for the last 30 days: search term, targeting, placement and search term impression share.
Target ACoS: [x]%. TACoS goal: [y]%.
1. Sanity check: flag missing data or anything that looks wrong before you analyse.
2. Cluster search terms and targets by theme; for each cluster show spend, sales, ACoS, ROAS and top converting terms.
3. Scale-ups: terms under target ACoS with low impression share; suggest a bid increase and say why.
4. Fix or kill: targets well over target ACoS; say which to fix (bid/match type) and which to negate.
5. Placement and budget changes, then a 7-day action plan.

PPC & Ads

Auditing Amazon's Ads Agent Recommendations with Gemini

Check whether Amazon's Ads Agent is buying branded clicks, low-intent traffic or sales on low-stock ASINs ToolsGeminiSourceBlog post · Rick Wong (SellerMetrics)SharedMay 5, 2026PromptSeller's own prompt
Show promptHide prompt for Auditing Amazon's Ads Agent Recommendations with Gemini,Seller's own prompt
I am uploading a raw dataset from my Amazon Search Term Report. Act as a Data Scientist specializing in e-commerce attribution.

Task 1: Segmentation. Analyze the 'Customer Search Term' column. Identify any term that matches the string '[Your Brand Name]' or phonetic misspellings. Tag these rows as 'BRANDED'. Tag all other rows as 'NON-BRANDED'.

Task 2: Quantitative Analysis. Create a summary table comparing these two segments across the following metrics:
- Total Spend
- Total Sales
- Weighted Average CPC (Cost Per Click)
- Conversion Rate (CVR)
- ROAS

Task 3: Agent Efficiency Score. Focus specifically on campaigns where the 'Campaign Name' indicates it is an Agent-managed campaign. Calculate the percentage of the Agent's total budget allocated to 'BRANDED' terms.

Task 4: Interpretation. If the Branded Spend Share exceeds 20%, estimate the 'Cannibalization Cost' assuming that 60% of branded sales would have occurred organically without advertising. Provide a corrected 'True ROAS' for the Agent excluding these branded sales.

PPC & AdsOlder post · Apr 2026

Inventory-Aware PPC Bidding with n8n and Gemini (Vendor Build)

Throttle bids by days of cover and pause ads before a stockout, with Gemini writing the decision notes Toolsn8n, GeminiSourceVendor docs · Polat Deniz (PDV Automations)SharedApr 5, 2026PromptWritten by us
Show promptHide prompt for Inventory-Aware PPC Bidding with n8n and Gemini (Vendor Build),Written by us
Here is my ASIN list with current bids, target ACoS, net price, 30-day conversion rate, FBA units available and average daily units sold [paste].
For each ASIN: days of cover, the bid from target ACoS x net price x conversion rate, and the bid after these rules: under [14] days of cover cut bids by [30]%; under [5] days pause; never go below $[min] or above $[max].
Return a table of current bid, proposed bid and the reason. Don't change anything.

PPC & Ads

MCP PPC Harvesting and Reporting at an Amazon Ads Agency

Run daily search-term harvests and multi-account reporting without half-day builds ToolsGeminiSourceReddit thread · u/ (r/FulfillmentByAmazon)SharedThread dated about six months before 2026-11-06 on the search-index copy; Reddit showed no exact calendar date in the fetch.PromptWritten by us
Show promptHide prompt for MCP PPC Harvesting and Reporting at an Amazon Ads Agency,Written by us
Connected to my Amazon Ads MCP (read-only until I approve writes): pull the last [7] days of search terms across all Sponsored Products campaigns for accounts [list]. Propose negatives (0 orders, [10]+ clicks) and exact harvests (2+ orders, ACoS under [target]). Show bid changes larger than [15]% as a separate approval table. Don't push changes until I confirm.

PPC & AdsShows real results

Streaming TV Buys Consolidated with Amazon Ads Agent

Buy streaming TV ads across several publishers from one Amazon ad platform, aimed at shoppers new to your brand
75%“75% reduction in customer cost per acquisition” seller-reported
ToolsAmazon Ads AgentSourceNews article · AdExchanger (Alyssa Boyle)SharedNov 18, 2026PromptWritten by us
Show promptHide prompt for Streaming TV Buys Consolidated with Amazon Ads Agent,Written by us
I sell [product] on Amazon and run Sponsored Products. Using my ad data for the last 90 days:
1. What share of my ad-attributed sales were new-to-brand?
2. Draft a plan for a [$X] streaming TV test aimed at shoppers in my category who haven't bought my brand: which audience to use and how to measure it (new-to-brand purchases, branded searches).
3. List what you need from me before launch. Don't create any campaign until I approve.

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.