Responses: every shopper’s answers
The Responses page lists each shopper who started a quiz, with their answers, result, email, cart and order. Download them as a CSV for Excel or Google Sheets.
#What a response is
A response is one run: one shopper’s go at one quiz, from their first answer on. A shopper who takes the quiz twice shows twice. Shoppers who only looked at the quiz without answering aren’t listed, and neither are your own test runs or shoppers who declined analytics.
Responses show the real answers behind your numbers: what a shopper who left at question 3 had picked so far, which products a shopper who ordered was recommended, or what a customer answered before writing to you.
#Open Responses
- Go to Analytics and open your quiz.
- Click See responses at the top of the page.
- Pick the range: 7 days, 30 days or 90 days.
The heading says how many there are, such as “1,234 responses in the last 30 days”. They’re listed newest first, by when the shopper started, and times are in UTC. Analytics at the top takes you back to the quiz’s page.
When the quiz’s first response is newer than the start of the range, a line says “Collected from” and that date.
#What each column shows
| Column | What it shows |
|---|---|
| Time | When the shopper started (UTC), with their device (Mobile or Desktop) and source (such as instagram, or Direct) under it. |
| Answers | Each question’s short label (or its text) and the answers picked. |
| Result or Recommended | The result page they got, or the first three products recommended, then “+2 more” for the rest. |
| The email they left in this run, if any. | |
| Cart | How many products they added to the cart. Hover over it to see which. |
| Order | The value of the quiz products they ordered, in the currency they paid. |
Responses use your quiz’s current wording: if you rename an answer, older responses show the new name. Answers and questions you’ve removed from the quiz are left out.
Shoppers who described their needs in their own words show the answers the AI picked for them. Their own words are never stored.
#Paging through
Responses show 50 to a page. The line under the list says which ones you’re seeing, such as “1–50 of 1,234 · page 1 of 25”. Use the previous and next buttons on the list to move between pages.
#Download CSV
- On Responses, pick the range you want.
- Click Download CSV.
- Your browser saves a file named like
teacup-responses-skin-quiz-2026-10-11.csv: the quiz’s ID and the day you downloaded it.
The file covers the same range as the page, newest first, up to 50,000 responses. With more than that, the page says “The download has the newest 50,000.” and older ones aren’t in the file. If the download fails, you’ll see “Couldn’t download the responses. Please try again.”
The columns, in order:
| Column | What it holds |
|---|---|
| Started (UTC) | When the shopper answered the first question, such as 2026-10-09 14:05:31. |
| Finished (UTC) | When they reached their results. Empty if they didn’t. |
| Device | mobile or desktop. Empty when unknown. |
| Source | The utm_source or the website that sent them, or Direct. |
| Language | The store language they browsed in, such as en or fr. |
| One column per question | Headed with the question’s short label or text, in the order shoppers meet them. Several answers are separated by semicolons. |
| Result | The result page, or the recommended products’ names, separated by semicolons. |
| No match | yes when nothing matched. Otherwise empty. |
| The email left in this run. | |
| Added to cart | The names of the products they added. |
| Orders | How many orders with quiz products came from this run. |
| Order value | Their quiz products’ value, such as 12.34. Empty without orders. |
| Currency | The currency of Order value, such as USD. |
| Response id | A random ID for the run. It doesn’t identify the shopper. |
Products no longer in your store show as “Product” followed by their number. A cell that would start like a spreadsheet formula gets an apostrophe in front, so text a shopper typed can never run as a formula.
#Opening it in Excel or Google Sheets
The file is comma-separated and saved as UTF-8 with a marker Excel recognizes, so double-clicking it opens it in Excel with accents and other alphabets intact.
- If everything lands in column A (common when your computer uses a comma for decimals), open a blank workbook, choose Data → From Text/CSV, pick the file, and set the delimiter to comma.
- If letters look garbled in an older version of Excel, use the same import and choose UTF-8 as the file origin.
- In Google Sheets, choose File → Import → Upload and pick the file.
#Responses and the Emails page
An email shows in Responses only when it was left in a run Teacup Quiz recorded. Emails left during your own test runs, or by shoppers who declined analytics, are on the Emails page but not here. To export every email with its answers, use Export CSV on Emails. See Emails and customers.
Still need help?
Chat with us: you talk to a real person, not a bot. Or email us with your store’s address (your-store.myshopify.com).