PPC & Ads · Blog post · source The case study page shows no date.

AMC LTV Cohorts and Client Decks with Claude

Measure shopper lifetime value by ASIN and turn it into client decks

He found that the LTV of holiday shoppers is 'quite a bit lower than during regular seasons' and could tell a brand its 'LTV is down 20% over a 12-month window.'

Per source From the tool's vendor, not independently tested.

Copy-paste prompt

Copy-paste promptStarter prompt (written by us)
From my AMC cohort data, build a 12-month matrix for [ASIN]: customers by first-purchase month, and their repeat purchases and revenue in each following month. Then compare the 12-month LTV of customers acquired in November-December with those acquired in other months, and tell me what that means for how much I should pay to acquire a holiday customer.

The source didn't publish its exact prompt. We wrote this starter so you can try the same workflow. Replace anything in [brackets].

What they did

Nick Menicucci, VP of marketplaces at the agency eAccountable, used Intentwise Explore to build Amazon Marketing Cloud views of LTV-to-CAC across client SKUs and 12-month cohort matrices by ASIN. He then connected clients' Amazon data, including AMC, to Claude through Intentwise's AI Gateway MCP, so he could pair search terms, Share of Voice and Amazon Marketing Stream data with the AMC insights and build client decks.

How it went

He found that the LTV of holiday shoppers is 'quite a bit lower than during regular seasons' and could tell a brand its 'LTV is down 20% over a 12-month window.' He puts the time savings from AI Gateway at 'upwards of 50%,' which he frames as time moved to strategy rather than time saved.

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

Worth knowing

A vendor case study from Intentwise with no date on the page. The AMC views were built with Intentwise's team in its own platform; Claude sits on top for analysis and decks.

Original source

Blog postIntentwisePublished The case study page shows no date. · intentwise.com https://www.intentwise.com/casestudy/eaccountableOpen the source

Keep going

Related use cases

PPC & AdsReported numbers

Agency Wasted-Spend Checks and Unit Forecasts with Claude and Intentwise

Find wasted spend across client accounts and build forecasts without gathering reports
10 minutes“a bottoms-up unit forecast for all of the agency's Amazon brands in 10 minutes” vendor claim
ToolsClaude, Intentwise AI GatewaySourceBlog post · IntentwiseSource dateThe case study page shows no date.PromptStarter prompt
View promptHide prompt for Agency Wasted-Spend Checks and Unit Forecasts with Claude and Intentwise,Starter prompt
For each client account, list every campaign where average CPC in the last 7 days is more than double its 30-day average. For each one, check: placement bid adjustments (top of search, product pages), and any non-brand search terms showing up in campaigns named as branded. Give me a table of campaign, CPC change, likely cause and the fix.

PPC & Ads

Ad Swing Diagnosis with Claude and Intentwise

Find out why ad performance swung and act on it without opening the ads console ToolsIntentwise AI Gateway, ClaudeSourceBlog post · IntentwiseSource dateThe case study page shows no date.PromptStarter prompt
View promptHide prompt for Ad Swing Diagnosis with Claude and Intentwise,Starter prompt
Campaign set A is running at about 60% ACOS with flat sales and set B at about 80% ACOS with growing sales. Using the last 60 days of search term data, find the keywords and close variants whose spend or sales moved between campaigns, and show where each one is converting best. Recommend where to keep each keyword and where to add it as a negative.

PPC & AdsReported numbers

Search Term Report vs Cerebro Ranks with Claude

Find where ad spend overlaps organic rank and where to push for page 1
+22.90%“$832k every 2 months (+22.90% YoY)” agency-reported
ToolsClaude, Helium 10SourceX post · George Schwartz (Extension eCom)Source dateOct 11, 2026PromptStarter prompt
View promptHide prompt for Search Term Report vs Cerebro Ranks with Claude,Starter prompt
I'm attaching two files for the same brand: the Sponsored Products search term report for the last 60 days and a Helium 10 Cerebro export of the brand's organic ranks.
Match them by keyword and give me three lists:
1. Keywords where we already rank organically in the top 10 but still spend heavily on ads (candidates to cut spend).
2. Keywords ranked 11-40 with good conversion in the ads data (candidates to push toward page 1).
3. Keywords with spend and no organic rank at all.
Show spend, sales, ACoS and organic rank for each row.

PPC & AdsReported numbers

Amazon DSP Campaign Planning and Weekly Reporting with Claude

Plan, build and report Amazon DSP campaigns across several marketplaces
€277,000“€277,000 of attributed DSP sales, a ROAS of 19.4” agency-reported
ToolsClaudeSourceBlog post · e-Comas (with Marc Villaseca)Source dateJul 17, 2026PromptStarter prompt
View promptHide prompt for Amazon DSP Campaign Planning and Weekly Reporting with Claude,Starter prompt
Here are my Amazon DSP exports for the last 4 weeks: campaign report, reach and frequency, and device breakdown.
1. Show average frequency per line item by market and flag any above 7.
2. Show spend share and ROAS by device type and suggest bid-modifier changes.
3. List the 5 changes you'd make before the next flight, each with the number that supports it. Don't assume data that isn't in the files.

PPC & Ads

Six Claude Cowork Skills That End in Seller Central Flat Files

Build reusable Claude skills for listings, research and PPC that output upload-ready files ToolsClaude, Helium 10SourceYouTube video · Chris Rawlings (Orange Klik webinar)Source dateJun 17, 2026PromptStarter prompt
View promptHide prompt for Six Claude Cowork Skills That End in Seller Central Flat Files,Starter prompt
Here are my keyword performance export and targets: target ACOS [X]%, harvest after [N] orders, negate after [M] clicks with 0 orders.
List search terms to promote to exact match and terms to add as negatives, with the campaign and ad group for each, as a Sponsored Products bulk file I can review before upload.