Hub › Lessons › Customer research, lesson 7
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)
- Last month's rows from your feedback log. In Notion, open the Feedback log as a full page, click ••• at the top right, choose Export, then Markdown & CSV. Notion downloads a zip file with the CSV inside. Open the CSV in a text editor and copy everything. For a short month you can type the rows in instead.
- Last month's count for each theme. Copy the "For next month" lines from your last review. If this is your first review, leave the line empty.
- What you changed last month, if anything. One sentence, such as the line you added to your pricing page.
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.
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)
- Check the numbers first. Under Check, rows counted plus rows not counted should equal the rows you gave. If not, find the missing row before you trust anything else.
- Look at Not counted. Rows with no date or the wrong month are listed there. Add the missing dates in your log so they count next time.
- Compare two quotes with your log. Each example quote should be a customer's exact words.
- Read differences calmly. Going from 2 to 4 is two more messages. With a small business, that can be one busy week.
- Do the one thing. The table below shows which lesson helps with each next step. Write the change and the date in your log, so next month's prompt can report on it.
- Save the "For next month" lines. Keep them on a page next to your feedback log. They are next month's "Last month".
| If the review says | Use this lesson |
|---|---|
| Add the answer to my FAQ | Turn real customer questions into an FAQ |
| Check my pricing page for unclear terms | Check your pricing page for unclear terms |
| Update my one-page offer | Write a one-page offer using only your own facts |
| Ask three customers my interview questions | Write customer interview questions that don't lead |
| Look at one step in my process | No 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)
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.
| Theme | This month | Last month | Difference | Example quote |
|---|---|---|---|---|
| Praise for taste and texture | 5 | 4 | +1 | "Pandan chiffon super soft, family finished it in one day" |
| Delivery areas and fees | 4 | 2 | +2 | "How much to deliver to Punggol?" |
| Boxes damaged or ill-fitting | 3 | 0 | +3 | "The box was too small, the top of the cake got squashed" |
| Order lead time questions | 2 | 5 | -3 | "If I order on Wed can collect Sat?" |
| Custom and halal questions | 2 | 3 | -1 | "Is your kitchen halal certified?" |
| Too sweet or want less sweet | 2 | 1 | +1 | "Can make the frosting less sweet? Last time a bit jelak" |
| Price versus size or other bakeries | 1 | 2 | -1 | "8 inch $88 abit pricey compared to other home bakers" |
| Collection point not answering | 1 | 1 | 0 | "Reached Tampines block, called twice nobody answer" |
| Unsorted | 2 | 1 | +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
- The numbers were right every time. In all 12 test runs with rows, every count, every copied "Last month" number and every difference matched our own count, and every example quote was copied exactly from the rows.
- Old and undated rows were kept out. The September row and the undated row were listed under Not counted in every bakery run.
- No run claimed the change worked. All seven bakery runs reported lead time questions going from 5 to 2 as "went down", and none said the new pricing line caused it.
- The rule is simple on purpose. Every bakery run picked delivery, the biggest problem theme. Damaged boxes went from 0 to 3, which you might judge more urgent. The prompt follows the count; the decision is still yours.
- Ties are labelled. Our made-up yoga teacher had three themes tied at 2 and no last month to compare. All three final-version runs picked one, named the others and said it was a judgment call. They also said 7 rows is too few to compare month to month.
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
- A count is not a cause. If a theme goes down after a change, that is a good sign, not proof. Seasons, promotions and one chatty customer all move the numbers.
- Small numbers jump around. Below about 10 rows a month, look for themes that keep coming back over two or three months rather than reacting to one.
- Check the dates in your export. Our test rows used dates written like October 3, 2026. If your export writes dates differently, check that the Not counted list makes sense.
- Keep private details out. Your log should already have names and numbers removed. Check before you paste.
- One thing means one. The point is a change you will actually make this month, not a list.
The whole series in one loop
Here is how the seven customer research lessons fit together each month:
- Sort feedback into themes once, to set up your theme list.
- Log each new message in Notion as it arrives.
- Run this monthly review at the start of each month.
- Act on one thing with the FAQ, pricing page, one-page offer or interview questions lesson.
- Next month, see whether that theme went up or down.
Next step
Start with your biggest theme
If you have not set up a log yet, sort last month's messages into themes first. Your theme counts from that lesson can be the "Last month" numbers for your first review.
Go to lesson 1Next series: AI for client onboarding
The next series is about delivering your work smoothly. Lesson 1 shows you how to write a client welcome message from your own facts.
Go to the new seriesHow we checked this lesson
- On 7 Nov 2026 (about 3:45 to 4:30 am Singapore time) we ran the prompt with Claude Code 2.1.319 in print mode on three illustrative inputs: the bakery with 24 rows, September counts and one change; a yoga teacher with 7 rows and no earlier review; and an empty row list. We ran version 1 seven times and version 2 nine times. The table above is from the first bakery run of version 2.
- A separate script checked every output: each count against our own count of rows dated in October, each "Last month" number against the input, each difference, that each example quote appears word for word under that theme, the sort order, the Not counted list, the chosen theme and next step, the "For next month" lines, the totals under Check, and that no sentence claims a change caused or fixed anything. All version 2 runs passed. With no rows, every run asked for them and stopped. We also read every output.
- Notion's help page Export your content, checked on 7 Nov 2026, says a full-page database exports as a CSV file inside a zip, from ••• then Export then Markdown & CSV. We did not run the export ourselves in this test; our test rows were written directly as CSV. Notion changes its menus from time to time; if a name differs, look for the closest option.
- We tested one assistant on made-up data. AI output varies by tool, model and input, so check the totals each month.
- Last reviewed: 7 November 2026.