Skip to content

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

  1. Go to Analytics and open your quiz.
  2. Click See responses at the top of the page.
  3. 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

ColumnWhat it shows
TimeWhen the shopper started (UTC), with their device (Mobile or Desktop) and source (such as instagram, or Direct) under it.
AnswersEach question’s short label (or its text) and the answers picked.
Result or RecommendedThe result page they got, or the first three products recommended, then “+2 more” for the rest.
EmailThe email they left in this run, if any.
CartHow many products they added to the cart. Hover over it to see which.
OrderThe 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.

#Didn’t finish and No match

Didn’t finish marks a shopper who started but didn’t reach their results. Usually they left partway. It also shows when:

  • The shopper is still taking the quiz right now.
  • The run reached its results faster than a person could, or during an unusual burst of finishes, so it wasn’t counted or billed. See How Teacup counts.

No match marks a shopper whose answers matched nothing, so they got your fallback results. Their answers show which combination needs a rule or a result. See When answers match nothing.

#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

  1. On Responses, pick the range you want.
  2. Click Download CSV.
  3. 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:

ColumnWhat 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.
Devicemobile or desktop. Empty when unknown.
SourceThe utm_source or the website that sent them, or Direct.
LanguageThe store language they browsed in, such as en or fr.
One column per questionHeaded with the question’s short label or text, in the order shoppers meet them. Several answers are separated by semicolons.
ResultThe result page, or the recommended products’ names, separated by semicolons.
No matchyes when nothing matched. Otherwise empty.
EmailThe email left in this run.
Added to cartThe names of the products they added.
OrdersHow many orders with quiz products came from this run.
Order valueTheir quiz products’ value, such as 12.34. Empty without orders.
CurrencyThe currency of Order value, such as USD.
Response idA 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).