I have a competitive market intelligence survey and am asking NPS for a number of brand if the respondent has experience with the brand (awareness, usage, NPS). I want to see how my brand stacks up against "Premium" brands in total, for example, let's say my brand is Coca-Cola, and I want to see how my NPS compares to the combination of Pepsi, Dr. Pepper and 7-Up. If I were doing it in excel, I would export the NPS for Pepsi, Dr. Pepper and 7-Up and put them all in one column, then calculate the NPS. I want to know if I can create this calculation in embedded data using math equations so I can use the NPS in my Qualtrics data analysis.
I think the logic would be something like Branch logic IF they answered Pepsi NPS, embedded data PremiumPepsiNPS = something + PremiumDrPepperNPS = something + Premium7UP = something. I recognize the problem is that I am creating a column longer than my rows of data respondents.
Problem #2 is the base number. For example, the base for Coca-Cola may be something like 300, all unique individuals, but the base for the 3 premium brands maybe be 500, some are the same people - who drank 2 or 3 of the brands.
If it's possible in excel, I expect it is possible in Qualtrics, but I can not figure out how to set up. Also, the survey is not live yet so I have time to test it.
Thank you in advance!
Kara
If you have Dashboard feature available, try using Custom Metrics.
Thank you rondev - I called Qualtrics Dashboard support earlier and they did not have a solution unless I uploaded a new .csv file with the NPS scores all in one column. If it can be done in excel, I know it can be done in Qualtrics, I just can't figure out how yet. I started with a math equation (Q10 NPS selected score + Q11 NPS selected score), but I think the issue is the base will vary based on how many answered just Q10, just Q11 and both Q10 and Q11. Also, if they did not answer, I don't want to add in a "0" and artificially skew the NPS. In the "old days" a Qualtrics techie would go to engineering and help get this figured out. I miss the old days.
Leave a Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.