NetPromoter Score (NPS) - Analytics Cookbook Recipe

Content

 

 

 

 

 

 

NetPromoter Score (NPS)

 

 

 

 

Calculating Your NPS for the Last 7 Days

 

 

 

 

Author: Simon Kilgarriff

 

 

 

 

Difficulty rating: (Intermediate)

 

 

 

 

Target persona: Marketing/Survey Analyst, Service Managers, Executive

 

 

 

 

Ingredients:

 

 

 

 

5 Tables (questions, question_responses, question_sessions, flows, surveys)

 

 

 

 

1 Outer / 3 Inner Joins

 

 

 

 

7 Columns using formulas (7 count distinct (), 1 min(), 1 max() & date_diff())

 

 

 

 

5 Filters - 1 required, 1 fixed, 3 run-time

 

 

 

 

1 Function - multiple uses of count function

 

 

 

 

 

 

 

 

 

Overall description/purpose:

 

 

 

 

Survey reports can always be tricky because of the table joins. This report enables you to see a breakdown (by response score) for all the choice type questions for a survey. It is useful for analyzing things like customer satisfaction, where the most satisfied customers will select the choice with the highest score and the least satisfied customers will select the choice with the lowest score.