← All use cases · Shops & e-commerce
Have Claude build your weekly KPI report so it's done before you walk in Monday morning
Mark X. Cronin, co-founder and president of John's Crazy Socks, a Long Island, New York online sock retailer with a Huntington storefront (Wahoo Market) and nine employees on website, social, product and customer service, in Newsday
Claude runs the weekly KPI reports so they're ready Monday morning. The company also uses AI for market research, data analysis and image creation.
Claude $17/mo billed annually ($20 monthly); free plan available (the article doesn't say which plan or how the report is scheduled)
Medium · or we set it up for $197
Claude
The problem
The president built the company's weekly key performance indicator reports himself.
What happened
"Now, Claude runs those, the weekly reports, so when I come in Monday morning they're done," Cronin told Newsday. No time figures are given.
Quoted in the source: Mark X. Cronin, co-founder and president, John's Crazy Socks. Source: Newsday: How Long Island businesses are using AI to save time and why some refuse (Arielle Dollinger) (2026-10-22) · Added 2026-10-24.
How to set it up yourself
- What John's Crazy Socks uses: Claude for the weekly KPI reports. The article doesn't say which systems feed it, so the steps below are our DIY version.
- List the 6-10 numbers you check every week (for example orders, revenue, average order value, returns, ad spend, email signups, top products) and where each one lives.
- Each Friday, export last week's and the prior week's data from your store platform and ad accounts as CSV files, upload them to a Claude Project, and run the prompt below. Check every number against the source for the first month.
- Once the numbers match, connect Claude to your data with its built-in connectors, or have Zapier collect the exports into one folder, so the report can be ready Monday with no hand work.
Copy-paste prompt
You build the weekly KPI report for {COMPANY NAME}, a {BUSINESS TYPE}. From the attached files, calculate for last week and the week before: {LIST YOUR KPIS}. Show a table with each KPI, last week, prior week, change and percent change. Then write five bullet points: the two biggest improvements, the two biggest drops with the likely cause from the data, and one thing to check this week. Show your calculation for any number you derive. If a number can't be found in the files, write NOT IN DATA instead of estimating.We set up one AI automation in your tools, live within 48 hours of getting access, for $197. No call needed. Founding price for our first 10 customers (regular $297).
One short email a day: 3 new AI use cases from real small businesses, each with its source and setup steps, plus a Tool of the Day. Free, no spam, unsubscribe anytime.
Tools used
Claude
AI assistant for writing, long documents, analysis and coding help.
From $17/mo billed annually ($20 monthly) (checked 2026-10-24)
Visit site →Some tool links may be affiliate links. Disclosure
Checked prices: Claude: from $17/mo billed annually ($20 monthly) (verified 2026-10-24)
Rather not do it yourself?
The $197 Quick-Win: we set up one AI automation that saves you hours each week, in accounts you own, live within 48 hours of getting access. No call needed. Refund if it isn't live in 48 hours or isn't doing its job in the first 14 days. Founding price for our first 10 customers (regular $297). Terms.
See the $197 Quick-WinNeed more than one automation or ongoing care? Bigger setups: $149/mo with setup included (6-month minimum), or $497 pay-once. Satisfaction guarantee: we'll fix it until it works. Pay-once setups: or we refund your setup fee. $149/mo plan: cancel in the first 30 days and we refund your first month. We reply within 1 business day.
Related for Shops & e-commerce
Use ChatGPT to bulk-add book listings and spot titles to feature
The owner uses ChatGPT to fill in book details in bulk, uses AI on Google Analytics data to spot rising interest (romance before Valentin…
ChatGPT
Canva AI (Magic Studio)GAGoogle AnalyticsAdd a catalogue-only AI 'librarian' to your bookshop website
'Ask the Librarian' answers in the reader's language, only recommends books in the store's catalogue with live price and stock, and puts …
Use AI to research, price and catalogue thousands of used books before opening
AI helps find prices for comparable copies, check whether sets are complete, decipher old inscriptions, and turn his dictated book detail…
Running something like this in your business? Submit your use case and we'll credit you with a link.
Get 3 new AI use cases every morning
One email every morning: 3 new AI use cases from real small businesses, each linked to its source, plus a Tool of the Day. Free. No spam, unsubscribe anytime. Privacy
Rather have one set up for you? The $197 Quick-Win.