Viewing Form & Survey Results

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, which you can access on a flow by flow basis from your dashboard:

Once you received and download 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 .gz format, so you may need to convert this to .csv before uploading 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.

Open your new sheet and in the 'File' tab, select 'Import'.

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.

Once the CSV is imported, turn on the Filter option for your spreadsheet:

Now you can filter the name column to "appcues:form_submitted" to retrieve the results.

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.

Still need help? Contact Us Contact Us