Docs / Analytics & optimization

Exporting your responses to CSV

Your SupaPop analytics page shows charts and tables, but sometimes you want the raw data. The CSV export gives you a spreadsheet of every response, with the email, phone, survey answers, and any order it led to. You can open it in Excel, Google Sheets, or LibreOffice, sort it, filter it, or hand it to your team.

This is also the only place you see full email addresses. On the dashboard, the email column is masked (for example, jo***@example.com). The CSV contains the complete, plain-text email and phone for each response.

Before you start

The export uses whatever popup and date range you have selected on the analytics page. There is no separate filter on the export button itself, so set those first:

  • Popup selector. Choose a single popup, or leave it on all popups. The default is all popups.
  • Date range. Pick Today, Yesterday, 7d, 30d, 90d, All, or a custom range. The default is the last 30 days. Choosing All means the file includes every response with no date limit.

How to export your responses

  1. Open the Analytics page in SupaPop.
  2. Set the popup and date range you want to export (see above).
  3. Scroll to the bottom of the page, below the data tables.
  4. Click Export CSV.

Your browser downloads a file named supapop-analytics-YYYY-MM-DD.csv, where the date is today’s date. There is no loading spinner or confirmation message. The file just downloads.

What’s in the file

The CSV has nine columns, in this order:

  • Email (full, not masked)
  • Phone (full, not masked)
  • Submitted At
  • Survey Answers
  • Custom Fields
  • Converted (Yes or No)
  • Order Total
  • Order ID
  • Order Date

A few things to know about how the rows work:

  • Converted is Yes when the response led to at least one order, and No otherwise. For No rows, the order columns (Order Total, Order ID, Order Date) are blank.
  • One row per order. If a customer placed more than one order, that customer’s email appears on more than one row, once per order. So the number of rows is not always the same as the number of responses.
  • Order Total is net of refunds. Refunded amounts are subtracted, and fully refunded or cancelled orders are removed or reduced. This means the revenue in your CSV will not match a raw Shopify gross-sales report for the same orders.
  • Survey Answers and Custom Fields are stored as raw text blocks. Each cell holds the full answer data as a single block of text, not one tidy column per question. If you need a column per question, you will have to split it yourself.
  • Test responses are not included. Any responses from previewing or testing your own popup are left out, so you only see real customer data.

Tips

  • The file holds full PII. Even though the dashboard only shows masked emails, the CSV has complete emails and phone numbers. Treat the file carefully and only share it with people who should see customer contact details.
  • A leading apostrophe is normal. Some cells, such as a phone number that starts with a plus sign, may show a single quote at the front (for example, ‘+1…). This is a safety measure that stops spreadsheets from treating the cell as a formula. Your data is not corrupted.
  • Change the file by changing the dashboard. To export a different popup or a different time window, change the popup selector and date range on the analytics page, then click Export CSV again.
  • Very high-volume stores can hit a cap. The export includes up to the 10,000 most recent responses, and up to 10,000 orders. If you have more than that, some rows are left out and there is no warning shown.

FAQ

Why do the emails in my CSV look different from the dashboard? The dashboard masks emails on purpose (for example, jo***@example.com) so customer addresses are not fully visible on screen. The CSV is the full export, so it includes the complete email and phone for each response.

The file downloaded but it only has a header row. What happened? That means there were no matching responses for the popup and date range you selected. Try a wider date range or switch the popup selector to all popups, then export again.

Why is the revenue lower than my Shopify sales report? Order Total in the CSV is after refunds, and it leaves out cancelled and fully refunded orders. A Shopify gross-sales report counts orders before refunds, so the two figures will differ.