Skip to main content

CSV Exports

Updated over 2 weeks ago

When our in-app reporting doesn't meet all your needs, you can export your data in a CSV file!

To do so, you can just click into the survey and select the date range you need the responses for.

And click this button found on the right-hand side of the page to pull up the CSV export modal.


The following fields can be exported for any survey you're running.

Customer Data

  1. Full Name: The complete name of the customer, including their first and last names.

  2. First Name: The first name of the customer.

  3. Last Name: The last name of the customer.

  4. Email: The email address of the customer.

  5. Phone: The phone number of the customer.

  6. Address1: The primary street address of the customer.

  7. City: The city in which the customer resides.

  8. Zip: The postal or ZIP code for the customer's address.

  9. Province: The state, province, or region in which the customer resides.

  10. Country: The country in which the customer resides.

  11. Company: The name of the customer's company or organization, if applicable.

  12. Accepts Marketing: A boolean value indicating whether the customer has opted in to receive marketing communications.

  13. Financial Status: The customer's financial status, such as 'paid', 'refunded', or 'pending', for their most recent order.

  14. Fulfillment Status: The current status of the customer's most recent order fulfillment, such as 'fulfilled', 'unfulfilled', or 'partial'.

  15. Total Spent: The total amount the customer has spent across all orders.

  16. Orders Count: The total number of orders the customer has placed.

  17. Line Items: A list of individual products or services purchased by the customer in a single order.

  18. Shopify Customer ID: A unique identifier for the customer within the Shopify system.

  19. Shopify Order ID: A unique identifier for a specific order within the Shopify system.

  20. Shopify Order Number: The sequential order number assigned by Shopify.

Survey Data

  1. Survey Title: The title of the current survey being exported.

  2. Coupon Code: Any coupon code that was generated by the "promo code action" in the current survey response.

  3. Started At: The date and time the customer answered the first question on the survey.

  4. Submitted At: The date and time the customer completed the survey.

  5. The Questions: A separate column for each question in the survey. This is going to be dynamic based on the survey selected.

Note - there is an option on the export modal that says "export checkboxes as separate columns". Selecting this will allow you to export checkbox questions as separate columns instead of as a comma-separated list. If you do not check this option, you will see checkbox responses in a comma-separated list under the same column.

If you have questions, please reach out to hello@knocommerce.com.
​
If you need additional data, check out our API docs.

Did this answer your question?