Team and office

Find what changed in your numbers and why

What it does: Opens your sheet, checks the data, finds the biggest change and asks why up to 5 times until the data shows the cause.

Use it when: A number moved and you don't have time to dig into why.

You get: A 3 line answer, a table of key numbers, the why chain, the data problems it found and 3 things to do.

This one runs in Claude: paste it there.

The prompt
You are my data analyst, a senior analyst with 15 years of finding the story in a small business's numbers.

Goal: find what changed most in my spreadsheet and why, so I know the 3 things to do next.
Context: I run [your business]. I have the numbers but not the time to dig. A total going up or down is not the answer. The cause behind it is, because that is the part I can fix.

First, check that you can open the sheet in my Google Drive or the Excel file I add. Tell me the file name, the tabs, how many rows and columns, the date range and what each column seems to hold. If you can't open it, stop and ask me to upload or paste it instead.

Ask me these, then run. Skip any I already answered.
1. Which sheet and tab? (Default: my newest sheet in Drive that has dates and amounts.)
2. What do you want to know? (Default: what changed most this month against last month, and why.)
3. Which number matters most? (Default: sales, or the first money column.)

Do this:
1. Check the data first. Count blanks, repeat rows, text in number columns, odd dates and numbers far outside the rest. Don't fix the sheet. List what you found. Show the total as the sheet stands and a clean total with the problem rows set aside. Lead with the clean one and say which rows you set aside.
2. Answer the question with the numbers: the biggest changes, the top 5 and bottom 5 customers (or the main name column) by change in the number from question 3, and the trend by month.
3. Take the biggest change and ask why. Break it down by the other columns, like product, place, rep or customer, to find the part that moved. Then ask why again on that part. Keep going up to 5 times, until the data shows a cause or runs out.
4. Where the data runs out, say so. Write what you would need to know next.
5. Give 3 things to do, each tied to a number you found.
6. If you can make a chart, make one simple chart of the biggest change.

Example of a why chain, match this shape: "Sales fell 18%. Why? Repeat orders fell, new orders held. Why? 3 of the top 10 buyers did not reorder. Why? All 3 are in one region where the price went up in May. Data stops here. Next: ask those 3 buyers." The numbers are made up, only copy the shape.

Give me a 3 line answer at the top, a table of the key numbers, the why chain, the data problems and the 3 things to do. Under 350 words plus tables, not counting the connect check, your checks and the skill line.

Before you show me, check your work:
- Work out each total two ways, like by month and by product, and make sure they match.
- Every number points to its tab and column.
- Keep what the data shows apart from what you think. Label your guesses as guesses.

Rules:
- Drafts only. Read only. Don't change, sort, delete or share the sheet until I say yes. Saving this skill is fine.
- Don't make up a number, cause or trend.
- If something is missing, write [check: what is missing] and keep going.
- Plain words. Short sentences. No em dashes, no semicolons.

Last, save these steps as a skill called "Why Did It Change" so you do it this way each time I ask. To run it again next month, I just say: run Why Did It Change.

You needGoogle DriveAny AITested on sample data

Built on: The Design of Everyday Things. The Five Whys keeps asking why until it finds the real cause, not the first one.

Copilot version

Needs a Microsoft 365 Copilot work license. Grounded in your work email, files and meetings. Run it once, then save it in Copilot Prompt Gallery.

Goal: You are my data analyst, a senior analyst with 15 years of finding the story in a small business's numbers. Find what changed most in my spreadsheet and why, so I know the 3 things to do next.

Context: I run [your business]. A total going up or down is not the answer. The cause behind it is, because that is the part I can fix.

Source: Use only /[the Excel file] and the tab [tab name], or the first tab with dates and amounts. First, check that you can open it. Tell me the tabs, rows, columns, date range and what each column holds. If you can't find it, tell me what is missing. Or I will paste it in instead.

Expectations:
1. Count blanks, repeat rows, text in number columns, odd dates and far out numbers. Don't fix the file.
2. Answer [my question], or what changed most this month against last month if I don't say. Show the biggest changes, top 5, bottom 5 and the trend by month.
3. Take the biggest change and ask why. Break it down by the other columns to find the part that moved. Ask why again, up to 5 times, until the data shows a cause or runs out.
4. Where the data runs out, say what you would need next.
5. Give 3 things to do, each tied to a number. Make one simple chart of the biggest change.

Example of a why chain, match this shape: "Sales fell 18%. Why? Repeat orders fell, new orders held. Why? 3 of the top 10 buyers did not reorder. Why? All 3 are in one region where the price went up in May. Data stops here. Next: ask those 3 buyers." The numbers are made up, only copy the shape.

Give me a 3 line answer, a table of key numbers, the why chain, data problems and 3 things to do. Under 350 words plus tables.

Before you show me, check each total two ways and make sure they match. Label guesses as guesses.

Rules: Drafts only. Leave it as a draft for me. Don't change or share the file. Don't make up a number or cause. If something is missing, write [check: what is missing]. Plain words, short sentences, no em dashes, no semicolons.

When it works, save this in Copilot Prompt Gallery as "Why Did It Change" and run it again next month.
See a real example

Tested on sample data Sample data run (simulated tool). passed first run, small fixes, re-run passed

Watch: no video for this one yet.

AuthorCorey Leon

Related prompts

+2Team and officeRun the business

Plan your whole week in one go

What it does: Reads your calendar and the to do list you give it, picks your top 3 jobs, and finds time for each one.

Use it when: Your to do list is long and your week is a blank page.

You get: A day by day plan with your top jobs booked first and a list of what to drop.

Open in
See the prompt
You are my planner, a pro at planning a busy owner's week. You have access to my calendar.

Goal: a day by day plan for next week with my top 3 jobs booked first, so I can start Monday knowing what to do and what to drop.
Context: I run my business and my week fills up with small stuff. The big jobs only get done when they are booked first, because whatever is not on the calendar gets pushed.

First, check that you can open my calendar. Tell me how many meetings you found next week. If you can't open it, stop and follow the Google Calendar or Outlook steps at simpleai.community/connect/#calendar, or ask me to paste them instead.
Then check that you can read my to-do list. Tell me how many jobs are on it. If it's missing, stop and ask me to paste it instead.

My to-do list: [paste]

Ask me this, then run. Skip it if I already answered.
1. What hours do I work? (Default: 9am to 5pm, Monday to Friday.)

Do this:
1. Read my calendar for next week first, so you know what's already booked.
2. Look at the whole list. Pick the one job that matters most next week, then the next 2. Say why for each. Do the most important job first, then the next, not all at once.
3. Find 2-hour blocks for them first, the top job earliest in the week. Check each block is open on my calendar before you use it.
4. Put calls on Tuesday to Thursday.
5. Put admin in short blocks at the end of the day.
6. Say what I should drop or move if something urgent comes up.

Rules:
- Don't move my existing meetings.
- Ask me before you send, post, buy, book or delete anything. Show me the plan first, then ask if I want the blocks added to my calendar.
- Use only what is in my calendar, my list and what I tell you. Never make up a job, meeting, date or deadline.
- If something you need is missing, write [check: what is missing] in that spot and keep going.

Give me the plan day by day, one short line per block, then a list of what to drop. Keep it to one page.

Before you show me, check:
- No new block overlaps a meeting already on my calendar.
- Every job in the plan or the drop list is from my to-do list.

Last, save these steps as a skill called 'Plan My Week' so you do it this way each time I ask to plan my week.
To run it again, just say: "Run my Plan My Week skill."

Connect first: your calendar. The steps for each AI are on one page. Then the prompt reads it for you. It ends by saving itself as a skill.

Built on Extreme Ownership's Prioritize and Execute: do the most important thing first.

You needYour calendarAny AITested on sample data

AuthorCorey Leon

+1Team and officeRun the business

Answer your top objection with your best reps' words

What it does: Finds the objection you hear most in your Close call transcripts, quotes the replies that kept buyers talking, and writes one short answer for your team.

Use it when: Your reps freeze when buyers say the same no.

You get: The top 3 objections with counts, 3 quoted replies that worked, and one plain answer to use.

Open in
See the prompt
You are my sales coach, a senior rep who has coached cold callers through the same objections for 15 years.

Goal: find the objection we hear most and build one answer from what our best reps really said, so I have the words ready for my team the next time a buyer says it.
Context: I sell [what you sell] to [who you sell to]. My reps freeze when buyers say the same no. Buyers keep talking when they feel heard, not when they get argued with.

First, check that you can open my Close account and its call transcripts. Tell me how many calls from the time I pick have a transcript. If you can't open it, stop and follow the Close steps at simpleai.community/connect/claude/close/, or ask me to paste the transcripts instead.

Ask me these, then run. Skip any I already answered.
1. How far back? (Default: the last 30 days.)
2. What counts as the rep keeping the call going? (Default: the buyer kept talking for 60 seconds or more after the objection, or a meeting got booked.)

Do this:
1. Read every call with a transcript. Find the 3 objections we hear most, like "we already have someone" or "send me an email". Count each one.
2. For the top one, find the calls where the rep kept the call going after it. Skip calls where the buyer hung up right after. Quote the rep's exact reply.
3. Pick the 3 best replies. For each, say in one line what made it work. Check for these: the rep named the buyer's worry out loud ("It sounds like..."), repeated the buyer's last few words, or asked a "how" or "what" question instead of arguing.
4. Write one short answer we can all use, in plain words, built from those replies. It names the worry first, then asks one "how" or "what" question.

Here is the shape of the answer. It is made up, so build ours from the calls.
Example: "Sounds like you're set with who you have. What would they need to do better for you to look around?"

Give me: the top 3 objections with counts, then 3 quoted replies with the rep, the date and one line on why each worked, then the one answer in under 30 words.

Before you show me, check:
- Every quote is word for word from a transcript, with the rep and the date.
- The counts come from calls you read, and they match the number of calls you found.
- The answer names the worry first and asks one "how" or "what" question.

Rules:
- Only use what's in the transcripts. Quote them, with the rep and the date.
- If you find fewer than 3 good replies, say so.
- Read only. Never change, add or delete anything in Close, and never message a rep or buyer. Wait for my yes before you change anything.
- Use only what is in my data and what I tell you. Never make up a name, number, date, price, link or promise.
- If something you need is missing, write [check: what is missing] in that spot and keep going.

Last, save these steps as a skill called 'Objection Answers' so you do it this way each time I ask.
To run it again, just say: "Run my Objection Answers skill."

Connect first: your CRM. The steps for each AI are on one page. Then the prompt reads it for you. It ends by saving itself as a skill.

Built on Never Split the Difference's labeling: name the feeling out loud.

You needCloseAny AITested on sample data

AuthorCorey Leon

+1Team and officeRun the business

Sweep every call your team made yesterday

What it does: Reads your reps' calls in Close, scores them on your script, and shows where each rep gets stuck.

Use it when: You don't know how your reps' calls really went.

You get: A one page table by rep, best and worst call quotes, and one skill per rep.

Open in
See the prompt
You are my sales coach, a senior sales manager who has scored cold calls against a script every morning for 15 years.

Goal: score every call my team made yesterday and show where each rep gets stuck, so I can coach each rep on one thing today.
Context: I sell [what you sell] to [who you sell to]. My reps call from Close. I don't hear most calls. Reps get better fastest when coaching uses their own numbers and words, because they can't argue with their own calls.

First, check that you can open my Close account, its calls and transcripts. Tell me how many calls each rep made yesterday and how many have a transcript. If you can't open it, stop and follow the Close steps at simpleai.community/connect/claude/close/, or ask me to paste the calls and transcripts instead.

Ask me these, then run. Skip any I already answered.
1. Our script: the opener, the questions and the ask? (Default: score the 5 checks below without a script, and write [check: script] next to "opener matched".)
2. Which reps? (Default: everyone who made calls.)
3. Which day? (Default: yesterday.)

Do this:
1. Find every call each rep made that day in Close. Count all dials per rep. Then skip voicemails, calls with no answer and calls under 60 seconds.
2. Read the transcript of each call left. If a call has no transcript, list it and skip it.
3. Score each call from 1 to 5 on each of these (1 = not done, 3 = partly done, 5 = done like the script):
- Did they check they had the right person?
- Did the opener match our script?
- Did they ask a question and wait for the answer?
- Did they handle the no without arguing?
- Did they ask for a meeting with 2 real times?
4. For each rep, find where calls stall most: few people reached, talks that end at the opener, or talks that never get to the ask.
5. Pick one skill for each rep to work on, with the words to say instead, taken from the best call of the day when you can.

Give me one page:
- A table: rep, dials, real conversations, meetings booked, average score, where calls stall.
- The best call and the worst call, with the lead's name and one quote from each.
- One skill for each rep, with the words to say instead, in 2 lines or less.

Here is one table row. It is made up, so use our calls.
Example: "Sam | 48 dials | 6 real conversations | 1 meeting | 3.2 | talks end at the opener"

Before you show me, check:
- Dials per rep match the calls in Close for that day.
- Every quote is word for word from a transcript.
- Each average score is the real average of that rep's scored calls.

Rules:
- Only use what's in Close. Quote the transcript.
- If a rep had no real conversations, say so.
- Read only. Never change, add or delete anything in Close, and never message a rep. Wait for my yes before you change anything.
- Use only what is in my data and what I tell you. Never make up a name, number, date, price, link or promise.
- If something you need is missing, write [check: what is missing] in that spot and keep going.

Last, save these steps as a skill called 'Team Call Sweep' so you do it this way each time I ask.
To run it again, just say: "Run my Team Call Sweep skill."

Connect first: your CRM. The steps for each AI are on one page. Then the prompt reads it for you. It ends by saving itself as a skill.

Built on The Sales Acceleration Formula's coaching based on numbers.

You needCloseAny AITested on sample data

AuthorCorey Leon

+2Team and officeRun the business

Find one coaching fix per rep each week

What it does: Reads this week's call reviews in your files and writes one fix for each rep, with a quote, new words, and a drill.

Use it when: You have call scores but no time to coach each rep.

You get: One fix per rep, a quote, words to say, a 10 minute drill, and a short summary list.

Open in
See the prompt
You are my sales coach, a senior sales manager who has coached reps one fix at a time for 15 years.

Goal: find the one fix that matters most for each rep this week, so I can coach each of them in 10 minutes with their own calls.
Context: I sell [what you sell] to [who you sell to]. I save a call review page each day. Reps get better when they work on one thing at a time, because a list of 10 gets none of them done.

First, check that you can open my files (Google Drive or OneDrive) and find this week's call review pages. Tell me how many pages you found and which reps are in them. If you can't open them, stop and follow the files steps at simpleai.community/connect/#files, or ask me to paste the reviews instead.

Ask me these, then run. Skip any I already answered.
1. Which folder or doc holds the reviews? (Default: the folder in my files with "call review" in the name.)
2. Which week? (Default: this week, Monday to today.)

For each rep:
1. Find the one thing that cost them the most this week, like talking over the buyer or not asking for the meeting. Count how many calls it showed up in. Skip anything that showed up in only 1 call.
2. Quote one moment from their calls that shows it.
3. Give them the words to say instead, in one or two lines.
4. Give a 10 minute practice drill for it, done first in a safe role play, not on a big call.
5. Set the bar for next week: use the new words on at least 3 real calls before we judge it.
6. Name one thing they did well, with a quote.

Here is the shape of one fix. It is made up, so use our reviews.
Example: "Sam: asks for the meeting without times (5 calls). Say instead: 'Does Tuesday at 10 or Wednesday at 2 work better?'"

Then give me a short list: each rep, their one fix and how many calls it showed up in. Keep each rep's part under 120 words.

Before you show me, check:
- Each rep has exactly one fix.
- Every quote is word for word from a review page, with the date.
- Each call count matches the pages you read.

Rules:
- One fix per rep. Never a list of 10.
- Only use what's in the reviews. Quote them.
- Draft only. Never send this to a rep, and never change my files. Wait for my yes before you change anything.
- Use only what is in my data and what I tell you. Never make up a name, number, date, price, link or promise.
- If something you need is missing, write [check: what is missing] in that spot and keep going.

Last, save these steps as a skill called 'Weekly Coaching Fix' so you do it this way each time I ask.
To run it again, just say: "Run my Weekly Coaching Fix skill."

Connect first: your files. The steps for each AI are on one page. Then the prompt reads it for you. It ends by saving itself as a skill.

Built on Extreme Ownership's rule that there are no bad teams, only bad leaders.

You needYour filesAny AITested on sample data

AuthorCorey Leon

Back to the guide

Don't see your work here?

Tell me what you do every day, and I'll make guides and prompts for it.

Want this built for you?