Survey reporting

INS1.org
Participant

Since changing the way survey data exports to reports, is there any advice on how to use this new format to analyze data?

We preferred the old format where survey data was displayed with the respondents in rows and the survey questions in columns. That way we could compare by question across respondents, or pull the information into a Word doc mail merge by individual respondents. Now we get an unusable spreadsheet with the questions displayed in rows rather than columns we are at a loss as to how to utilize our survey data. 

We are looking into moving to another platform for surveys, but really hate to leave CC. Any suggestions on how to manipulate the data since this change are welcome.

 

1 REPLY 1
William_A
Moderator

EDIT: As of January 14, 2022, survey results now have a PDF-download option, which allows you to download the visual graphs of your survey results. The CSV options will provide the text and detailed responses info still.

 

Hello @INS1.org ,

 

Our engineers are still working on ways to improve the reporting formatting to be more easily readable / translatable, akin to the old legacy format. Your account has been marked as interested, and they'll notify you directly on any future developments regarding the survey reporting.

 

In the meantime, the best workarounds will require some degree of manipulation. Since the results export as a CSV file, you can sort a specific column so that it'll update the orders of the others respectively. For example, you can sort by first name or last name to see each individual's response to a question. You can sort by question so that you see all the different responses for that question lined up. From there it's just a matter of spreading out the width of the columns / formatting them to show all their data, rather than squishing everything up.

 

Our team has also had success when setting up pivot tables in Excel and other spreadsheet programs with similar functionality. Microsoft has an article on creating pivot tables in Excel, if you'd like to check out that setup.


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
William A
Community & Social Media Support
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Did I answer your question? If so, please mark my post as an "Accepted Solution" by clicking the Accept as Solution button in the bottom right hand corner of this post.

Anyone can be a marketer! Visit our Blog & Resources page to brush up on the latest tips and tricks.
  • Support Tips

    Reporting Metrics

    "Authenticating your emails is the best way to ensure your emails achieve maximum deliverability. If you have your own domain, setting up self-authentication is especially important! " - Will

    See Article
    Avatar
  • Support Tips

    Call-To-Action Links

    "Target your most engaged contacts by creating a segment. Create a special offer or show your appreciation!" - Caitlin

    See Article
    Avatar
  • Support Tips

    Read Before You Send a Test Email

    "Did you know? You can send unlimited test emails to your verified email address, but only 50 in a 24-hour period to non-verified email addresses." - Nick

    See Article
    Avatar