Is there a math equation to combine NPS scores? | XM Community
Skip to main content

Is there a math equation to combine NPS scores?

  • August 10, 2022
  • 2 replies
  • 251 views
karahansobrien
Level 1 ●
Forum|alt.badge.img+7

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

2 replies

rondev
Level 6 ●●●●●●
Forum|alt.badge.img+22
  • rondev
  • Level 6 ●●●●●●
  • August 16, 2022

If you have Dashboard feature available, try using Custom Metrics.

Ron Dev (DM for any request. XM Technology Consultant, surveysolution.in)
karahansobrien
Level 1 ●
Forum|alt.badge.img+7
  • karahansobrien
  • Author
  • Level 1 ●
  • August 16, 2022

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.

    Terms & ConditionsAccessibility statement