Product Research · from a YouTube video, Nov 9, 2026 · Added

Sales and Ad Spend Questions in Claude via Windsor and Helium 10 Connectors

Connect Claude to Seller Central, Amazon Ads and Helium 10 without your own API access, then ask for last week's numbers

less than 3 minutes

“took me less than 3 minutes to do this”

Per source From a vendor-affiliated source (see Worth knowing), not independently verified.

Copy-paste prompt

Copy-paste promptPrompt written by us, based on this case
Using my connected Amazon data, show last week's (Mon-Sun) total sales, ad spend, ad sales, ACoS and TACoS next to the week before, with the % change for each. Then list the 5 campaigns whose spend changed most week over week. Read-only: don't change anything in my accounts.

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 runs his own Amazon brands and a PPC agency, shows three ways to connect a paid Claude account to Amazon data for sellers who don't have Amazon API access: Windsor.ai's Claude connector (grant it Seller Central and Amazon Ads access), Helium 10's connector (log in from Claude's connector settings), and a custom MCP connector for Quartile, the bid tool his agency uses. He then opens a Claude project per brand, because projects keep memory of the data and reports pulled in, and sets the connectors to 'always allow' so Claude stops pausing for approval.

How it went

He says the Windsor setup 'took me less than 3 minutes to do this.' Asked 'What were my sales and ad spend last week?', Claude pulled the data through Helium 10 and returned last week's sales against the prior week and ad spend week over week. He warns that always-allow permissions 'can be dangerous, so make sure you know what you're doing,' and says to leave hourly bid changes to a bid tool like Quartile because doing them in Claude would cost thousands in Claude fees.

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

Worth knowing

He has affiliate links for Windsor.ai and Helium 10, and the video ends with a pitch for his paid monthly PPC service built on Claude skills and Quartile. He thinks Helium 10's connector needs its roughly $400-a-month plan. He didn't show the Quartile connection on screen because it holds client accounts.

Original source

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

Keep going

Related use cases

Product Research

Brand Analytics Click and Conversion Share with Helium 10 MCP

See which brands win clicks and purchases on a keyword, not just who ranks ToolsHelium 10, ClaudeSourceBlog post · Lauren Stair (Helium 10)SharedNov 5, 2026PromptWritten by us
Show promptHide prompt for Brand Analytics Click and Conversion Share with Helium 10 MCP,Written by us
Using Helium 10 MCP search_amazon_brand_analytics on these keywords: [paste]. For each, show top 3 brands/ASINs with click share and conversion share. Flag (a) high click share / low conversion share leaders, (b) fragmented keywords where no brand exceeds [15]% click share, (c) where my ASIN [B0...] sits if present. Recommend 5 PPC or listing actions. Don't change bids.

Product ResearchShows real results

Mature Listing Sales-Drop Audit Skill with Claude and Helium 10 MCP

Find out why an established ASIN's sales fell, keyword by keyword, before rewriting the listing
less than 10 minutes“the skill runs in less than 10 minutes” vendor-affiliated
ToolsClaude, Helium 10SourcePodcast episode · Bradley Sutton (AM/PM Podcast #566)SharedOct 24, 2026PromptWritten by us
Show promptHide prompt for Mature Listing Sales-Drop Audit Skill with Claude and Helium 10 MCP,Written by us
For ASIN [B0...], compare the last 90 days with the same 90 days last year:
1. Split the sales change into sessions vs conversion rate. Which one moved?
2. List the 15 keywords that lost the most purchases in Search Query Performance, with organic rank then and now and whether I'm advertising on each.
3. Flag competitors now winning purchases on those keywords.
4. Say plainly whether this is a listing problem or a traffic problem, and give the top 5 keywords to win back first.

Product Research

Bulk Keyword List Validation with the Helium 10 MCP's Analyze Keywords Tool

Check hundreds of keywords for search volume, competition and trend before using them in a listing or campaign ToolsHelium 10, ClaudeSourceBlog post · Helium 10SharedOct 16, 2026PromptWritten by us
Show promptHide prompt for Bulk Keyword List Validation with the Helium 10 MCP's Analyze Keywords Tool,Written by us
Run analyze_keywords on the list below. Return a table with search volume, competing products, CPR, trend and Magnet IQ for each. Then split it into: keep (volume over [2,500], under [2,000] competing products, flat or rising), test, and drop (zero volume or declining), with one line on why for each drop. Keywords: [paste list]

Product Research

Keyword Tracker Portfolio Audit with the Helium 10 MCP

Audit tracked-keyword ranks across the catalog without clicking every ASIN ToolsHelium 10, ClaudeSourceBlog post · Lauren Stair (Helium 10)SharedSep 18, 2026PromptWritten by us
Show promptHide prompt for Keyword Tracker Portfolio Audit with the Helium 10 MCP,Written by us
Using Helium 10 MCP list_tracked_keywords across my catalog: 1) list keywords where current rank is worse than previous by [5]+ positions, 2) list keywords ranked 11-20 by search volume, 3) flag ASINs with fewer than [10] tracked keywords, 4) suggest which weekly trackers should go daily. Don't change bids.

Product Research

Competitor ASIN Strategy with Claude and Helium 10 MCP

Turn multi-step Cerebro and Brand Analytics research into one competitor prompt ToolsClaude, Helium 10SourcePodcast episode · Bradley Sutton (AM/PM Podcast #552)SharedSep 5, 2026PromptSeller's own prompt
Show promptHide prompt for Competitor ASIN Strategy with Claude and Helium 10 MCP,Seller's own prompt
Analyze these competitor ASINs in Cerebro: [ASINs]. Exclude variations. Use historical data to describe their advertising strategy over the last 12 months (Sponsored Products, Sponsored Brand video, Sponsored Brand headline). Exclude branded keywords. List holiday-related keywords they ranked top 10 for last November and December with at least 500 searches. Then list keywords all of them currently rank for that my ASIN [ASIN] does not show organic rank for.

Product ResearchShows real results

Daily Rank Check Across 82 SKUs with Claude

Check organic rank for the whole catalog every morning instead of a few bestsellers
82 SKUs“to all 82 SKUs daily” vendor claim
ToolsClaude, Helium 10SourceBlog post · Raeanna Murray (Helium 10)SharedSep 4, 2026PromptWritten by us
Show promptHide prompt for Daily Rank Check Across 82 SKUs with Claude,Written by us
Pull organic rank for every ASIN in my catalog for my tracked keywords. Show, per ASIN and for the whole brand: how many keywords rank 1-10 and 11-20, total indexed keywords, and the combined search volume of keywords in the top 20, each compared with 7 days ago. List the 10 keywords where we lost the most ground.