🧠 AI Learning Hub

Hub › Lessons › Customer research, lesson 7

Lesson 7 · AI for customer researchAbout 15 minutes a month

Run a 15-minute monthly customer review with AI

Lessons 1 to 6 gave you a feedback log and tools for acting on it. This lesson turns them into a habit. Once a month, a tested prompt counts last month's feedback by theme, compares it fairly with the month before, and points you to one thing to change. It reports what went up or down. It does not pretend to know why.

What you will be able to do: in about 15 minutes at the start of each month, see which customer themes grew, pick one change for the month ahead, and keep the numbers you need for next month's review.

Step 1: Gather three things (5 minutes)

Step 2: The prompt

Fill in the four lines at the top, paste your rows under the fourth, then paste the whole prompt into your AI tool.

Prompt: monthly customer review
Help me run my monthly customer review. Use only the rows and numbers I give you.

Month I am reviewing:
Last month's count for each theme (from my last review; leave empty if this is my first):
What I changed last month, if anything:
This month's feedback rows (paste the CSV from my feedback log):

Do this:
1. Count the rows for each theme. Count only rows dated inside the month I am reviewing. List rows with no date, or a date outside the month, under "Not counted".
2. Make a table with the columns: Theme, This month, Last month, Difference, Example quote.
   - Last month: copy my number exactly, or write "no data".
   - Difference: this month minus last month, written as +2, -1 or 0, or "n/a" if there is no number for last month.
   - Example quote: one customer quote for that theme, copied word for word from the rows.
   - Sort by This month, highest first. Put Unsorted last.
   - Leave out a theme with no rows this month, unless it had rows last month.
3. Unsorted: copy each Unsorted quote word for word. Say whether two or more look like the same new theme.
4. Last month's change: give the count for the theme the change was about, this month and last month, and say whether it went up, went down or stayed the same. Do not say whether the change caused it or worked. A count cannot show that.
5. One thing for next month: take the theme with the most rows this month, leaving out praise and Unsorted. If two are tied, take the one that went up more. If they are still tied, pick one, say which others were tied and that it is your judgment. Pick the one matching next step from this list and say why in one sentence, using the count:
   - Customers keep asking the same question: add the answer to my FAQ.
   - Customers are unsure about prices, fees, delivery or terms: check my pricing page for unclear terms.
   - Customers are unsure what they get or who it is for: update my one-page offer.
   - I do not know why customers say it: ask three customers my interview questions.
   - Something went wrong with the product or service (damaged, late, wrong): name the one step in my process I should look at.
6. Check next month: the theme and its count to compare at my next review.
7. For next month: this month's count for every theme in the table, one line each, written as "- Theme: number", so I can paste it into next month's review.
Output, in this order: the table; Not counted; Unsorted; Last month's change; One thing for next month; Check next month; For next month; Check (rows I gave, rows counted, rows not counted; counted plus not counted must equal the rows I gave, and the table total must equal rows counted).

Rules:
- Never make up a number, theme, quote or customer.
- Do not say a change worked, failed or caused anything.
- If fewer than 10 rows are counted, say the numbers are too small to compare month to month, then still give one thing for next month.
- Do not write replies to customers. Do not give price advice.
- If no rows are given, ask me for them and stop.

Step 3: Read the review (10 minutes)

Where each next step points
If the review saysUse this lesson
Add the answer to my FAQTurn real customer questions into an FAQ
Check my pricing page for unclear termsCheck your pricing page for unclear terms
Update my one-page offerWrite a one-page offer using only your own facts
Ask three customers my interview questionsWrite customer interview questions that don't lead
Look at one step in my processNo lesson needed. Walk through that step yourself, or ask the person who does it.

Worked example

This continues the made-up home bakery in Tampines from lessons 1 to 6. At the start of November the owner reviewed October: 24 rows from her log, September's counts from her last review, and the one change she made in early October. The business, rows, counts and quotes are illustrative.

Input (illustrative)

Sample input
Help me run my monthly customer review. Use only the rows and numbers I give you.

Month I am reviewing: October 2026
Last month's count for each theme (from my last review; leave empty if this is my first):
- Order lead time questions: 5
- Praise for taste and texture: 4
- Delivery areas and fees: 2
- Price versus size or other bakeries: 2
- Too sweet or want less sweet: 1
- Boxes damaged or ill-fitting: 0
- Custom and halal questions: 3
- Collection point not answering: 1
- Unsorted: 1
What I changed last month, if anything: Early October I added "Order 3 days ahead, counted from the day you pay" to my pricing page.
This month's feedback rows (paste the CSV from my feedback log):
Feedback,Quote,Theme,Source,Date received
"Asks if 3 days is enough for Saturday","If I order on Wed can collect Sat?","Order lead time questions","WhatsApp","October 2, 2026"
"Pandan chiffon very soft","Pandan chiffon super soft, family finished it in one day","Praise for taste and texture","Google review","October 3, 2026"
"Asks delivery fee to Punggol","How much to deliver to Punggol?","Delivery areas and fees","Instagram DM","October 4, 2026"
"Box too small, top of cake squashed","The box was too small, the top of the cake got squashed","Boxes damaged or ill-fitting","WhatsApp","October 5, 2026"
"Asks if halal certified","Is your kitchen halal certified?","Custom and halal questions","Instagram DM","October 6, 2026"
"Chocolate cake rich and moist","Chocolate fudge very rich and moist, will order again","Praise for taste and texture","Google review","October 8, 2026"
"Asks if free delivery applies to Jurong","Free delivery above $80 also for Jurong West?","Delivery areas and fees","WhatsApp","October 9, 2026"
"Wants less sweet frosting","Can make the frosting less sweet? Last time a bit jelak","Too sweet or want less sweet","WhatsApp","October 10, 2026"
"Asks about gift cards","Got gift card or not? For my mum birthday","Unsorted","Instagram DM","October 11, 2026"
"Box corner crushed in delivery","Box corner kena crushed, cream on the side","Boxes damaged or ill-fitting","WhatsApp","October 12, 2026"
"Kids loved the cake","Kids loved the cake, very fluffy","Praise for taste and texture","Google review","October 14, 2026"
"Thinks 8 inch is pricey","8 inch $88 abit pricey compared to other home bakers","Price versus size or other bakeries","Instagram DM","October 15, 2026"
"Asks delivery time window","Delivery to Bedok what time will reach?","Delivery areas and fees","WhatsApp","October 16, 2026"
"Asks for unicorn design","Can do unicorn design for 6 year old?","Custom and halal questions","Instagram DM","October 18, 2026"
"Nobody answered at collection","Reached Tampines block, called twice nobody answer","Collection point not answering","WhatsApp","October 19, 2026"
"Cake slid inside box","Cake slid to one side inside the box","Boxes damaged or ill-fitting","Google review","October 20, 2026"
"Asks gift card for colleague","Do you sell gift cards? Want to give my colleague","Unsorted","WhatsApp","October 22, 2026"
"Asks next day order","Can order today for tomorrow?","Order lead time questions","WhatsApp","October 23, 2026"
"Too sweet for parents","Too sweet for my parents, can reduce sugar?","Too sweet or want less sweet","Google review","October 25, 2026"
"Best pandan cake","Best pandan cake in the east","Praise for taste and texture","Google review","October 27, 2026"
"Asks delivery fee to Sentosa","Sentosa delivery extra charge?","Delivery areas and fees","WhatsApp","October 29, 2026"
"Light and not oily","Very light and not oily, love it","Praise for taste and texture","Instagram DM","October 30, 2026"
"Asks if eggless possible","Is the eggless one possible? My son can't take egg","Custom and halal questions","WhatsApp","September 28, 2026"
"Asks about candles","Got candles included?","Unsorted","WhatsApp",""

Output (as returned)

The table is shown word for word from our first test of the final prompt with Claude. The notes after it are summarised.

The bakery's October review
ThemeThis monthLast monthDifferenceExample quote
Praise for taste and texture54+1"Pandan chiffon super soft, family finished it in one day"
Delivery areas and fees42+2"How much to deliver to Punggol?"
Boxes damaged or ill-fitting30+3"The box was too small, the top of the cake got squashed"
Order lead time questions25-3"If I order on Wed can collect Sat?"
Custom and halal questions23-1"Is your kitchen halal certified?"
Too sweet or want less sweet21+1"Can make the frosting less sweet? Last time a bit jelak"
Price versus size or other bakeries12-1"8 inch $88 abit pricey compared to other home bakers"
Collection point not answering110"Reached Tampines block, called twice nobody answer"
Unsorted21+1"Got gift card or not? For my mum birthday"

Not counted: the eggless question, dated 28 September, and the candles question, which had no date.

Unsorted: both Unsorted quotes ask about gift cards, so the review says they look like the same new theme.

Last month's change: Order lead time questions went from 5 to 2, so it went down. "A count alone cannot show whether the change caused this."

One thing for next month: Delivery areas and fees has the most rows, 4, leaving out praise and Unsorted. Next step: check the pricing page for unclear terms, because four customers asked about delivery fees, free-delivery rules or delivery timing.

Check: 24 rows given, 22 counted, 2 not counted, and the table adds up to 22. The "For next month" list repeats the nine counts, ready for December.

What the test showed

What we changed after testing

The prompt above is the second version. In the first version, both yoga runs added an empty "Unsorted 0" row to the table and the prompt did not say what to do with a tie that last month's numbers cannot break. Version 2 leaves out themes with no rows this month, unless they had rows last month, and asks the AI to say when it is using judgment. It also adds the "For next month" list, so next month's review starts from numbers you can paste instead of numbers you have to rebuild.

Watch out for

The whole series in one loop

Here is how the seven customer research lessons fit together each month:

  1. Sort feedback into themes once, to set up your theme list.
  2. Log each new message in Notion as it arrives.
  3. Run this monthly review at the start of each month.
  4. Act on one thing with the FAQ, pricing page, one-page offer or interview questions lesson.
  5. Next month, see whether that theme went up or down.

Next step

How we checked this lesson