I recently used the NPS (Net Promoter Score) question, which offers a 11 point scale (0 to 10) to users, to choose from. Rating 0-6 options were labelled as ‘Detractors’, 7-8 as ‘Passives’ while 9-10 ‘Promoters’.
Now, I realized that when I downloaded the data in excel, I was only seeing scores of 6 or 8 or 10 (basically the upper bounds of the 3 category labels I used in NPS questions). Even though users did select a rating 4 or 5, Kobo automatically changed that 6. Similarly, 7s were changed to 8s and 9s were changed to 10s.
I checked the data in Table format on Kobo too, and I faced the same problem. In fact, even the choice selection in the main form itself, was also changed by Kobo.
This is deeply upsetting as I cannot afford to lose the raw data, the actual ratings. I tried downloading the Excel in different formats, but nothing seems to work.
Can somebody help me out to understand:
- How can I retrieve my raw data?
- Is this a bug on Kobo or something to do with me labeling all options a ‘Detractors’ instead of ‘Detractors_Rating 1’, ‘Detractors_Rating 2’, ‘Detractors_Rating 3’…