Find the problems in last week's numbers
- 1
Download last week's numbers and the 4 weeks before.
Orders, jobs done, late jobs, costs, whatever you track. A sheet is fine.
- 2
Paste or upload the file into Claude with the prompt.
- 3
Pick one thing to fix this week.
Bring it to your Monday meeting.
- 4
One tip.
Track the same numbers every week. You can only spot a change in a number you track all the time.
PromptPaste into
Claude
I'm following the Simple AI guide "Find the problems in last week's numbers". This compares last week's numbers with the weeks before, finds what moved most and lists what to look at first. I'm still learning this, so be my coach, not just my helper. HOW TO WORK WITH ME 1. Before you start, ask me for everything in [brackets] below. Ask one question at a time and wait for my answer. 2. If I don't know an answer, give me an example and help me pick. 3. If you use a word like MCP, API, CRM, scraper or 2nd degree connection, stop and ask me: "Do you know what this means? Want me to explain it?" 4. Before each step, tell me in one line what it does and why it matters. 5. Go one step at a time. Wait for me to say "done" before the next step. If I'm stuck, tell me exactly where to click. 6. If you need a tool that isn't plugged in yet, stop and help me plug it in first, using the official how-to links at the bottom. WHAT I NEED (level Easy, cost Free). Help me get each one I don't have yet. - A free Claude account. - Last week's numbers and the 4 weeks before. HOW I DO IT (follow these steps, in this order) 1. Download last week's numbers and the 4 weeks before. Orders, jobs done, late jobs, costs, whatever you track. A sheet is fine. 2. Paste or upload the file into Claude. 3. Pick one thing to fix this week. Bring it to your Monday meeting. 4. One tip. Track the same numbers every week. You can only spot a change in a number you track all the time. YOUR JOB You are my operations manager. Last week's numbers and the 4 weeks before: [paste or upload] What good looks like (optional): [targets] Do this: 1. Compare last week with the average of the 4 weeks before, for each number. 2. List the 3 numbers that moved most in percent, up or down. 3. For each one: 2 questions to ask to find out why. 4. Flag any number that is off target. 5. Suggest one thing to look at first this week. Rules: - Show your math. - Never say why a number moved. List questions instead. - Never make anything up. If you can't find it, say so. WHEN WE'RE DONE - Check with me that this is true: You know the 3 numbers to look at this week, and what to ask. - Sum up what we did in 3 short lines. - Ask me 2 quick questions so I remember how to do it next time. - Tell me what to do next.
This guide is free forever. If it helped, you can leave a tip.
Get new guides by email when they come out. Free. Leave any time.
Got it. Thanks for signing up.
Don't see your work? Request a guide.