“What Features/Practices Annoy You The Most About Apps/Websites?”
We asked 800 contestants this question to demonstrate how Caplena can analyze survey responses. In doing so, you will learn how to employ this approach to analyze your own survey data! Are you ready? Let’s go!
The Expected Result
The basic principle when having to evaluate free-text is called Coding: The process of assigning one or more tags or topics to every text element.
When you have assigned codes to a majority or even all of your text elements, you can create statistics, charts, and dashboards, describing your results:
Dashboards in Caplena
Of course, these steps can be done manually in Excel or some other coding software. It even should be done there if you have, say, only 50 text elements. However, this is totally impractical with 200 – and borderline impossible with 5000 responses.
Caplena will eliminate much of the repetitive work in analyzing open-ends. Spend more time on the task which requires your insights instead: Making sense of the results.
Three Steps To Get Results
The first step is obviously getting your hands on the data. There are several ways to accomplish this: Ask your clients for feedback, send out an NPS survey or scrape the web for social media data posts or product reviews.
We support various file types, such as Excel, CSV, or SPSS. You also have the choice to directly input your data in the form of numbers, dates, booleans, strings, NPS and CSAT scores etc. Using our latest integrations feature, you can also simply copy and paste links of survey-type websites, and download the respective responses like that.
After completing this step, a codebook is generated, i.e. a list of codes (tags) that should be attached to the texts. Keywords, as other tools deliver them, might be Service or Price.
You can also upload a codebook you may have from similar or identical historical surveys so that you dont need to start from scratch building a new one. We also offer a wide range of survey codebook templates that you can select and then adjust to your specific needs.
We can now begin to make sense of the survey responses after categorizing all the unstructured text into structured categories. Caplena provides a visualization module, in which you can easily create charts and dashboards, which you can either download or share with your team/clients directly through a shareable link.
It is also possible to download all the raw results – the charts themselves can also be exported for use in their visualization toolkit.
The mechanics of creating bar, pie, line, treemap, or graph charts on Caplena are very simple, but making sense of your data is not. Getting to the essence of the data and telling a compelling story with a few words and a few charts is the most critical aspect of any analysis. This is also where you should invest most of your energy.
Within 25 minutes, you can go from having open-ended text responses in Excel to presenting your results in an interactive dashboard. It is all about taking advantage of today’s technologies in the most efficient manner and spending your time on the things that machines cannot automate – such as making sense of the results.
Did you enjoy this tutorial? 🚀 Feel free to suggest more topics in which you would like more guidance, and we will do our best to make it happen!
✉️Just email our Head of Marketing sheila [at ] caplena.com
To give Caplena a try for free, click here.