Every support email costs you time. But behind each one is a pattern you can’t see because you’re too busy replying to notice it. The same questions keep coming in, week after week, from different customers, and you handle them one by one without realising they’re telling you something important about your store.
A customer question dashboard changes that. Instead of answering the same “how long does shipping take?” email for the 47th time, you see exactly what people ask most, which products generate the most confusion, and where your product page is quietly losing sales because information is missing.
Here’s how to build one in under an hour using Google Sheets and a simple form. No plugin, no app, no monthly subscription.
What You’re Building
A simple dashboard that shows:
- The top 10 questions customers ask, ranked by frequency
- Which products trigger the most questions (so you know which pages need fixing)
- Question categories: shipping, sizing, ingredients, returns, stock, pricing
- A trend column showing whether each question type is going up or down week over week
Step 1: Set Up Your Question Log
Create a Google Sheet with these columns:
- Date (when the question came in)
- Product (which item the question is about)
- Question (the actual question, shortened)
- Category (shipping, sizing, returns, stock, product info, pricing, other)
- Channel (email, Instagram DM, product page Q&A, phone)
Name the tab “Question Log.” This is your raw data. Every time a customer asks something, log it here. It takes 15 seconds per question.
If you use Gmail, you can speed this up. Search your inbox for question phrases like “how long,” “what size,” “when will,” “do you have,” “is it in stock.” Batch-process the last 30 days in one sitting. You’ll probably find 50 to 100 questions in 20 minutes.
Step 2: Create a Summary Tab
Add a second tab called “Summary.” This is your dashboard. Set up these sections:
Top Questions (All Time): Use =QUERY('Question Log'!B:E, "select B, count(B) where B is not null group by B order by count(B) desc limit 10", 1). This shows your 10 most asked questions, ranked by how often they appear.
Questions by Category: Use =QUERY('Question Log'!D:E, "select D, count(D) where D is not null group by D order by count(D) desc", 1). This shows which categories generate the most confusion. If shipping questions are 60% of your total, you know exactly where to focus your product page updates.
Most Questioned Products: Use =QUERY('Question Log'!B:C, "select B, count(B) where B is not null group by B order by count(B) desc limit 5", 1). These are the products whose pages need attention first. A product that generates 12 questions a month probably has a description gap.
Step 3: Add a Weekly Trend Column
In your Summary tab, add a column next to each category that counts questions from the last 7 days only. Use:
=COUNTIFS('Question Log'!A:A, ">"&TODAY()-7, 'Question Log'!D:D, "shipping")
Replace “shipping” with each category name. This gives you a rolling 7-day count so you can see if a question type is spiking. If returns questions jumped from 3 to 11 this week, something changed. Maybe a batch arrived damaged. Maybe your sizing chart is off after a supplier change.
Step 4: Set Up a Simple Alert
You don’t need to check the dashboard every day. Set up a conditional formatting rule that highlights any category with more than 5 questions in the last 7 days. Format > Conditional Formatting > Custom formula: =B2>5. Apply a red fill.
Now, when you open your dashboard, any problem area jumps out immediately. You go straight to the product page, fix the missing information, and watch the question count drop next week.
Step 5: Connect It to Action
The dashboard is useless if you don’t act on it. Every Friday, spend 15 minutes reviewing the summary. For any category with more than 5 questions that week, pick one product page update that would answer those questions before they’re asked.
Examples:
- Shipping questions spiking? Add a delivery ETA widget to your product page.
- Sizing questions on one product? Add a size chart with measurements in centimetres, not just S/M/L.
- Stock questions on a bestseller? Add a back-in-stock notification signup.
- Ingredient questions on a skincare product? Add a full ingredient list tab with plain-English explanations.
Each fix takes 10 minutes. Each fix cuts future questions. Within a month, your weekly question count should drop by 30 to 50%.
What This Looks Like in Practice
A small skincare brand tracked questions for 3 weeks. Their dashboard showed that 40% of all questions were about whether a particular moisturiser was safe for sensitive skin. They added a single line to the product page: “Formulated without fragrance, alcohol, or essential oils. Dermatologist tested for sensitive skin.”
Questions about that product dropped by 80% the following week. The founder spent 2 fewer hours per week on support emails. That’s 8 hours a month back.
Why This Works Better Than a Help Desk App
Help desk apps are built for teams. They track tickets, assign conversations, and measure response times. But they don’t tell you why people are emailing. They count tickets, not patterns.
A simple question dashboard tells you the pattern. It shows you that your product page has a gap. It shows you which product needs a better description. It shows you which information is missing before it becomes a lost sale.
The goal isn’t to answer emails faster. It’s to make the emails stop coming because the answer is already on your product page.
Want more like this? Join MOKU Club for free. Weekly resources, early access to new guides, and occasional templates you can actually use. Join below.
