NPS Calculation Through BeastMode

austinisenhart

I'm trying to do an NPS Calculation through a beastmode and have already converted the "NPS-Value" column in another beast mode to Scores (9-10) = Promoter, (7,8) Passive, (0-6) Detractors. I'm trying to do the promoters - detractors / total *100 function in a separate beast mode but can't get it to work properly. What would be the correct function to make this work? This is what my data looks like and I'm not able to change any columns to be a "count of Promoters, or Detractors".

2024-08-14_140744.jpg

ArborRose

For Net Promoter Score (NPS), you'll want to create a formula that counts the number of Promoters, Detractors, and Total Responses, and then applies the NPS formula.

You should have a column that contains the net promoter scores and another one for your calculated Promoters, Passives, and Detractors. You should have your column already categorized with "Promoter", "Passive", and "Detractor" values.

You'll need beast modes for counting Promoters, another for counting Detractors, and one for counting Total Responses.

COUNT(CASE WHEN `NPS_Category` = 'Promoter' THEN 1 ELSE NULL END)

COUNT(CASE WHEN `NPS_Category` = 'Detractor' THEN 1 ELSE NULL END)

COUNT(`NPS_Category`)

And then create a new Beast Mode to calculate NPS using the formula.

(

  (SUM(CASE WHEN `NPS_Category` = 'Promoter' THEN 1 ELSE 0 END) - 

   SUM(CASE WHEN `NPS_Category` = 'Detractor' THEN 1 ELSE 0 END))

  / COUNT(`NPS_Category`)

) * 100

ArborRose

For Net Promoter Score (NPS), you'll want to create a formula that counts the number of Promoters, Detractors, and Total Responses, and then applies the NPS formula.

You should have a column that contains the net promoter scores and another one for your calculated Promoters, Passives, and Detractors. You should have your column already categorized with "Promoter", "Passive", and "Detractor" values.

You'll need beast modes for counting Promoters, another for counting Detractors, and one for counting Total Responses.

COUNT(CASE WHEN `NPS_Category` = 'Promoter' THEN 1 ELSE NULL END)

COUNT(CASE WHEN `NPS_Category` = 'Detractor' THEN 1 ELSE NULL END)

COUNT(`NPS_Category`)

And then create a new Beast Mode to calculate NPS using the formula.

(

  (SUM(CASE WHEN `NPS_Category` = 'Promoter' THEN 1 ELSE 0 END) - 

   SUM(CASE WHEN `NPS_Category` = 'Detractor' THEN 1 ELSE 0 END))

  / COUNT(`NPS_Category`)

) * 100

austinisenhart

Thanks for the feedback. I had to make an edit to the ETL to rename my columns but this formula worked!