Inventory & Ops · from a YouTube video, Nov 6, 2026 · Added
Weekly KPI Sheet and Monday Action Email with Claude
Fill a weekly KPI sheet from Amazon data and email the brand manager five action items every Monday
“a 94% fee spike”
Per source Self-reported by the source, not independently verified.
Copy-paste prompt
Every Monday: from my Amazon data for last week and the week before, fill my KPI sheet [link] with sales, ad spend, TACoS and contribution after ads per brand. Then write a short email comparing the two weeks side by side and list five action items. Flag any SKU whose fee per unit changed by more than 20%. Don't change anything in Seller Central.
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 built a Claude system for his own brands and his agency's clients that fills each brand's Google Sheet with weekly and monthly Amazon data (plus COGS). Every Monday it compares the last week with the week before, side by side, and emails his strategic brand consultants Amazon TACoS, blended TACoS and contribution after ads for each brand, then the top five things to do that week.
How it went
In the run he shows, it caught that the per-unit fees on his tinted lip balm went from 2.67 before deal week to 5.18 after it (the video title calls it a 94% fee spike), so he planned to open a case with his Amazon manager. It also flagged new ads that weren't serving yet. He disagreed with one suggestion to cut Shopify Meta campaigns at about 1 ROAS because they also push Amazon sales.
We only report what the source says. Results are self-reported unless noted.
Worth knowing
A short demo on his own brands; the brands also sell on Shopify, so blended figures include it. He doesn't say how the Amazon data reaches Claude in this clip.