Hub › Lessons › Customer research, lesson 5
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:
| Property | Type | What goes in it |
|---|---|---|
| Feedback | Title (the first column) | A short summary in your words, such as "Box crushed, cream stuck to side" |
| Quote | Text | The customer's own words, without names or numbers |
| Theme | Select | One of your themes, plus an option called Unsorted |
| Source | Select | Where it came from: WhatsApp, Instagram DM, Google review, email |
| Date received | Date | The day the message arrived |
- Use the themes you already have. If you sorted feedback in lesson 1, copy those theme names into the Theme options. Keep the list short: eight to ten themes plus Unsorted.
- No commas in theme names. Write "Too sweet or want less sweet", not "Too sweet, or want less sweet". When we created our test database through Notion's API, it refused the theme name with a comma, and commas also separate values in a CSV file.
- Leave out contact details. The log is for patterns, not for customer records. Keep the quote and drop the name and phone number.
Step 2: Add the view that counts each theme (3 minutes)
- Click + next to the view name at the top of the database and choose Board. Name it "By theme, last month".
- Open the view settings, choose Group and pick Theme. Each theme becomes a column.
- 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.
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:
- Copy the CSV block into a plain text file and save it as
feedback.csv. - Open the Feedback log as a full page, click the ••• menu at the top and choose Merge with CSV.
- 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
- The numbers add up. Under Check, rows plus messages left out should equal the messages you gave. If not, find the missing message before importing.
- Quotes are the customer's words. Compare two or three quotes with the original messages. A tidied-up quote hides how customers really talk.
- Every theme is one of yours. The CSV should only use your theme names or Unsorted. A new name will not match your Theme options.
- Every row has a date. A row with no date drops out of the "last month" view, so it is never counted. Add the date, or the day you received it if you are not sure.
- No names, numbers or emails. Search the CSV for anything that looks like a phone number or a name before you import it.
- Decide on Unsorted rows. If the same new theme keeps appearing, add it as a Theme option and re-tag those rows. If it is a one-off, leave it as Unsorted.
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)
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.
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:
| Theme | Cards |
|---|---|
| Unsorted | 2 |
| Order lead time questions | 1 |
| Delivery areas and fees | 1 |
| Boxes damaged or ill-fitting | 1 |
| Too sweet or want less sweet | 1 |
| Price versus size or other bakeries | 1 |
| Praise for taste and texture | 1 |
| Custom and halal questions | 1 |
| Collection point not answering | 0 |
- The September rows were left out, as the filter should do.
- The void deck complaint disappeared. It had no date, so the "on or after one month ago" filter skipped it, and the Collection point theme had no cards. That is why step 5 asks you to give every row a date.
- Two Unsorted cards is the signal to decide. One call-back request and one gift card question are not a pattern yet. If gift card questions keep coming, add the theme.
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:
- Version 2 asks how you write dates and leaves a date empty when it could be read two ways. Version 1 guessed, and got it wrong for Singapore in one of three runs.
- Version 2 logs every customer message, including requests. In version 1, two of three bakery runs dropped the call-back request as "not feedback", so it would never have been counted.
- What did not change: in all runs of both versions, quotes were copied exactly, themes came only from the owner's list or Unsorted, the spam message was left out, and no name or phone number reached the CSV.
Watch out for
- Counts are a guide, not proof. Two people asking about gift cards in a week is a hint to look closer, not a reason to launch a product.
- One message, one row. If a message covers two themes, the prompt picks one and lists the other under Also touches. Add a second row yourself if both matter.
- Import each batch once. A merge adds rows and never updates them, so the same messages imported twice are counted twice.
- Keep private details out. Paste messages without names, numbers or order details where you can. The prompt removes them from the CSV, but check.
- Theme names must match exactly. "Delivery fees" and "Delivery areas and fees" become two columns. Keep your theme list next to the prompt.
Next step
Turn your top theme into content
The biggest column on your board is a list of questions customers already ask. Turn customer questions into content ideas with the earlier lesson, then plan the posts in a Notion content calendar such as our Notion Content Calendar template.
Go to the content ideas lessonNext in this series: check your pricing page
Lesson 6 helps you check your pricing page for unclear terms, starting with the questions your feedback log shows customers keep asking.
Go to lesson 6How we checked this lesson
- On 5 Nov 2026 (about 3:45 to 4:30 am Singapore time) we ran the prompt with Claude Code 2.1.318 in print mode on three illustrative inputs: the bakery with eleven messages, the yoga teacher with six messages dated 3/11 to 5/11, and an empty message list. We ran version 1 seven times and version 2 twelve times. The CSV above is from the first bakery run of version 2 after we removed the comma from one theme name.
- A separate script checked every output: the CSV header, that every value was quoted, that each quote appears word for word in a message, that each theme is on the list or Unsorted, sources and dates against the input, summary length, the spam message left out, and that the name and phone number appear nowhere in the output. All version 2 runs with a stated date format passed. We also read every output.
- We created a Notion test database with these five properties through Notion's API, added the ten rows plus two older rows, and created the board view grouped by Theme with the "on or after one month ago" filter. Querying the view returned the 9 cards shown above. We did not build it in the Notion app itself, and we did not run Merge with CSV; those steps come from Notion's help pages.
- Notion help pages checked on 5 Nov 2026: Import data into Notion (Merge with CSV, matching headers, MM/DD/YYYY dates, merges add rows), Board view (Group, the count next to each column) and Views, filters and sorts (Filter, Save for everyone). Notion changes its menus from time to time; if a name differs, look for the closest option.
- We tested one assistant on three inputs. AI output varies by tool, model and input, so run the step 5 check each time.
- Last reviewed: 5 November 2026.