Viewing Form & Survey Results
Submit Article Requests
Do you have a suggestion for an article you would like to see created?
Feel free to submit this form and add your suggestions to our document board.
- Installation & Developers
- User Experiences
- Account Management
- Best Practices
Table of Contents
Once you've created a form or survey and published it live, you can review user responses by exporting a CSV. You can export the CSV from the analytics page of the particular flow:
Exporting form & survey responses
The easiest way to see all form & survey responses for a user is to choose " Survey". The export will be emailed to you in a few minutes and will include one line per user, with their latest response per field and the date and time it was last submitted, in a condensed format that's easy to read.
Note: if the same user answers a survey more than once, only the most recent response is returned in the survey export. If you're looking to see all the responses, you'll need to select the full export.
If you need more detail or granularity, continue on to the next section.
Manually parsing form responses from a full CSV export
Individual form response events are included one by one in the Full and Basic CSV exports as well, but they require a lot of manual work to determine which responses came from which users.
You would only need to parse form events manually if:
- You need to correlate specific user properties with each response at the time it was submitted.
- You need to see all responses, not just the latest.
- You want to calculate the timing of when each form element was filled out, not just see the most recent time.
- You have other advanced needs that require viewing each form event separately.
If you don't need to do these kinds of advanced analyses, you should export "Survey" as shown above.
Once you received and downloaded your CSV via email, the easiest way to view the form response data is to import the CSV into Google Sheets or Excel. The example below uses Google Sheets.
The file will come in the email in a .zip format, so you may need to convert this to .csv before uploading it to your product of choice. On a Mac, you'll simply click the file, which will open it and automatically convert it to a .csv format. On Windows, you may need to use a conversion software like WinZip or 7-Zip.
Step 1. Open your new sheet and in the 'File' tab, select 'Import'.
Step 2. You will then see a few options. You can choose whichever options make the most sense for you but, for a new Google Sheet, the default options will work just fine.
Step 3. Once the CSV is imported, in the 'Data' tab, select the 'Create a Filter' option.
Step 4. Go to the 'name column' (it should be column D) to apply the filter. First, you'll need to 'Clear' all filters and then search by "appcues:form_submitted" to retrieve the results.
Step 5. For each of the fields in the form, there will be a column titled "attributes.interaction.response" followed by the question or label associated with that form field. In that column, you'll find the user's answer to the question. One of the columns in the spreadsheet will be titled attributes._identity.userId, which will indicate which user submitted this response.