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
Full Name: The complete name of the customer, including their first and last names.
First Name: The first name of the customer.
Last Name: The last name of the customer.
Email: The email address of the customer.
Phone: The phone number of the customer.
Address1: The primary street address of the customer.
City: The city in which the customer resides.
Zip: The postal or ZIP code for the customer's address.
Province: The state, province, or region in which the customer resides.
Country: The country in which the customer resides.
Company: The name of the customer's company or organization, if applicable.
Accepts Marketing: A boolean value indicating whether the customer has opted in to receive marketing communications.
Financial Status: The customer's financial status, such as 'paid', 'refunded', or 'pending', for their most recent order.
Fulfillment Status: The current status of the customer's most recent order fulfillment, such as 'fulfilled', 'unfulfilled', or 'partial'.
Total Spent: The total amount the customer has spent across all orders.
Orders Count: The total number of orders the customer has placed.
Line Items: A list of individual products or services purchased by the customer in a single order.
Shopify Customer ID: A unique identifier for the customer within the Shopify system.
Shopify Order ID: A unique identifier for a specific order within the Shopify system.
Shopify Order Number: The sequential order number assigned by Shopify.
Survey Data
Survey Title: The title of the current survey being exported.
Coupon Code: Any coupon code that was generated by the "promo code action" in the current survey response.
Started At: The date and time the customer answered the first question on the survey.
Submitted At: The date and time the customer completed the survey.
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.