🧠 AI Learning Hub

Hub › Lessons › Customer research, lesson 5

Lesson 5 · AI for customer researchAbout 25 minutes

Log customer feedback in Notion and count it by theme

Sorting a month of messages once, as in lesson 1, is useful. Keeping a running log is more useful, because next month you can see whether "box arrived crushed" came up once or six times. This lesson sets up a small Notion database with five properties, one board view that counts each theme over the last month, and a tested prompt that turns new messages into rows you can import. Our tests also found three small things that quietly break the count: dates like 3/11, commas in theme names and rows with no date.

What you will be able to do: keep every piece of customer feedback in one Notion database and see, in one view, how often each theme came up in the last month.

Step 1: Build the feedback database (5 minutes)

In Notion, create a new page, add a table database and name it "Feedback log". Rename the first column and add four more properties:

The five properties of the feedback log
PropertyTypeWhat goes in it
FeedbackTitle (the first column)A short summary in your words, such as "Box crushed, cream stuck to side"
QuoteTextThe customer's own words, without names or numbers
ThemeSelectOne of your themes, plus an option called Unsorted
SourceSelectWhere it came from: WhatsApp, Instagram DM, Google review, email
Date receivedDateThe day the message arrived

Step 2: Add the view that counts each theme (3 minutes)

  1. Click + next to the view name at the top of the database and choose Board. Name it "By theme, last month".
  2. Open the view settings, choose Group and pick Theme. Each theme becomes a column.
  3. Choose Filter, pick Date received, set it to is on or after and choose the relative date One month ago. If you share the database, choose Save for everyone.

The grey number next to each column heading is the count. Notion's board help says it shows the number of cards in each column by default. Read the biggest numbers first: those are the themes worth acting on this month.

Step 3: The prompt that turns messages into rows

Fill in the first three lines and paste your new messages under the third, then paste the whole prompt into your AI tool. Say how you write dates. In Singapore, 3/11 usually means 3 November; to Notion's CSV import it means 11 March.

Prompt: messages to feedback log rows
Turn new customer messages into rows for my Notion feedback log. Use only what the messages say.

My themes (use these names exactly):
How I write dates (for example day/month/year):
Messages (one per line: date, where it came from, then the message; names and contact details removed if you can):

Do this:
1. Make one row per customer message, including questions, requests and complaints. Leave out only spam, adverts and messages not from a customer, and list them at the end.
2. Feedback: a short summary in plain words, 3 to 8 words.
3. Quote: the customer's words copied exactly, or the most important part of them. Do not fix spelling or grammar.
4. Theme: pick the one theme from my list that fits best. If none fits, write Unsorted. Do not make up new themes in the CSV.
5. Source: copy where it came from, as I wrote it.
6. Date received: read the date the way I said I write dates, then write it as MM/DD/YYYY. If I gave no date, leave it empty. If I did not say how I write dates and a date could be read two ways, such as 3/11, leave it empty and say so under Check.
Output:
- A CSV block with exactly this header: Feedback,Quote,Theme,Source,Date received
- Put every value in double quotes. Write a double quote inside a value as two double quotes.
Then, after the CSV:
- Not feedback: the messages you left out, and why.
- Unsorted: each row marked Unsorted, with a theme name I could add. Do not add it to the CSV.
- Also touches: rows that also fit a second theme.
- Check: messages I gave, rows in the CSV, messages left out. The rows plus left out must equal the messages.

Rules:
- Never copy names, phone numbers, emails or order numbers into any column, even if a message contains them. Replace them with [removed] inside the quote.
- Do not guess dates, sources or themes.
- Do not add praise, advice or replies to customers.
- If no messages are given, ask me for them and stop.

Step 4: Add the rows to Notion

You have two options. For a handful of messages, type the rows in by hand from the AI's table. For more, import the CSV:

  1. Copy the CSV block into a plain text file and save it as feedback.csv.
  2. Open the Feedback log as a full page, click the ••• menu at the top and choose Merge with CSV.
  3. Match each CSV column to the property with the same name, then import.

Notion's import help says the header names should match your property names exactly, that dates import in MM/DD/YYYY format, and that a merge adds rows and does not update existing ones. So import each batch of messages once, or you will count them twice. We followed these steps from Notion's help but did not run the import ourselves; see how we checked this lesson below.

Step 5: Check the rows in 5 minutes

Worked example

This continues the made-up home bakery in Tampines from lessons 1 to 4. In early November the owner copied eleven new messages from WhatsApp, Instagram and Google reviews and used her themes from lesson 1. The business, messages, name and phone number are illustrative.

Input (illustrative)

Sample input
My themes (use these names exactly):
- Order lead time questions
- Praise for taste and texture
- Delivery areas and fees
- Price versus size or other bakeries
- Too sweet or want less sweet
- Boxes damaged or ill-fitting
- Custom and halal questions
- Collection point not answering
How I write dates (for example day/month/year): day month year, for example 1 Nov 2026
Messages (one per line: date, where it came from, then the message; names and contact details removed if you can):
- 1 Nov 2026, WhatsApp: Can I order a cake for next Wed? Is 4 days enough
- 1 Nov 2026, Google review: The pandan chiffon is still the best, so fluffy
- 2 Nov 2026, Instagram DM: Delivery to Sengkang how much ah
- 2 Nov 2026, WhatsApp: Box was crushed at one corner, the cream stuck to the side
- 2 Nov 2026, WhatsApp: Hi this is Mei Ling, can call me at 9999 0000 about the 8 inch cake?
- 3 Nov 2026, Instagram DM: Follow us for "free" giveaways!! Click link in bio
- 3 Nov 2026, Google review: Chocolate cake a bit too sweet for me, but my kids loved it
- 3 Nov 2026, WhatsApp: Do you sell gift cards? Want to give my colleague
- 4 Nov 2026, WhatsApp: Is the eggless one possible? My son can't take egg
- 4 Nov 2026, Instagram DM: S$88 for 8 inch is a bit steep leh
- WhatsApp: Waited at the void deck 15 min, nobody came down

Output (as returned)

The CSV is shown word for word from our test with Claude. The notes after it are summarised.

CSV returned
Feedback,Quote,Theme,Source,Date received
"Asks if 4 days notice is enough","Can I order a cake for next Wed? Is 4 days enough","Order lead time questions","WhatsApp","11/01/2026"
"Pandan chiffon still the best, fluffy","The pandan chiffon is still the best, so fluffy","Praise for taste and texture","Google review","11/01/2026"
"Asks delivery fee to Sengkang","Delivery to Sengkang how much ah","Delivery areas and fees","Instagram DM","11/02/2026"
"Box crushed, cream stuck to side","Box was crushed at one corner, the cream stuck to the side","Boxes damaged or ill-fitting","WhatsApp","11/02/2026"
"Asks for a call about 8 inch cake","can call me at [removed] about the 8 inch cake?","Unsorted","WhatsApp","11/02/2026"
"Chocolate cake too sweet, kids loved it","Chocolate cake a bit too sweet for me, but my kids loved it","Too sweet or want less sweet","Google review","11/03/2026"
"Asks if gift cards are sold","Do you sell gift cards? Want to give my colleague","Unsorted","WhatsApp","11/03/2026"
"Asks if eggless option is possible","Is the eggless one possible? My son can't take egg","Custom and halal questions","WhatsApp","11/04/2026"
"8 inch at S$88 feels steep","S$88 for 8 inch is a bit steep leh","Price versus size or other bakeries","Instagram DM","11/04/2026"
"Waited 15 min, nobody came down","Waited at the void deck 15 min, nobody came down","Collection point not answering","WhatsApp",""

Not feedback: the Instagram giveaway message, as spam.

Unsorted: the call-back request and the gift card question, with "Call-back requests" and "Gift card questions" suggested as possible new themes.

Also touches: the chocolate cake review also fits Praise for taste and texture.

Check: 11 messages, 10 rows, 1 left out. The void deck message had no date, so its date is empty. The name and phone number were replaced with [removed].

What it looked like in Notion

We added these ten rows to a test database with the five properties above, plus two older rows dated September, and created the "By theme, last month" board view. On 5 November the view showed 9 cards:

Cards per theme in the test view
ThemeCards
Unsorted2
Order lead time questions1
Delivery areas and fees1
Boxes damaged or ill-fitting1
Too sweet or want less sweet1
Price versus size or other bakeries1
Praise for taste and texture1
Custom and halal questions1
Collection point not answering0

The 3/11 problem

We also tested a made-up yoga teacher whose six messages were dated 3/11/2026 to 5/11/2026, meaning 3 to 5 November. With the first version of the prompt, which did not ask how dates are written, three runs gave three different results: one read them as 3 to 5 November, one turned them into 03/11/2026 (11 March to Notion's import), and one left them empty and asked. With the final prompt and "day/month/year" filled in, all three runs wrote 11/03/2026 to 11/05/2026, which Notion reads as 3 to 5 November. With the date line left empty, both runs left every date empty and asked which format was meant, instead of guessing.

What we changed after testing

The prompt above is the second version. We ran both on the same inputs:

Watch out for

Next step

How we checked this lesson