{"id":87397,"date":"2022-12-16T12:21:51","date_gmt":"2022-12-16T06:51:51","guid":{"rendered":"https:\/\/www.mygreatlearning.com\/blog\/analyzing-the-promoters-and-detractors-and-net-promoter-score\/"},"modified":"2024-09-11T14:32:31","modified_gmt":"2024-09-11T09:02:31","slug":"analyzing-the-promoters-and-detractors-and-net-promoter-score","status":"publish","type":"post","link":"https:\/\/www.mygreatlearning.com\/blog\/analyzing-the-promoters-and-detractors-and-net-promoter-score\/","title":{"rendered":"Analyzing the Promoters and Detractors and Net Promoter Score"},"content":{"rendered":"
\"\"<\/figure>\n\n\n\n

Contributed BY: <\/strong>VENKATESH SUSWARAM<\/p>\n\n\n\n

I\u2019m Venkatesh, currently reside in Bangalore. I graduated from BITS Pilani in 2013. My hobbies include playing the Piano, gymming, doing fitness activities, and reading books. Coming to my professional experience, I\u2019m currently working as a Senior Business analyst in Data Science and Advanced Analytics team at VMWare. I have a total of 8+ years of experience in the data analytics domain. I\u2019ve worked on management consulting and product-based firms so far. Before joining PGP-DSBA at Great Learning, I worked on a couple of machine learning projects. One of the projects is to predict the sentiment of the customers ( Net promoters score ) using the transactional data of the customers.<\/p>\n\n\n\n

Business constantly tries to improve customer satisfaction, and the net promoter survey is a crucial component of capturing feedback from the customers. In this survey, the customers would like us to rate their experience doing business with the organization (1 being worst and ten being best ). If the customer score is between 1- 6, they are classified as \u2018Detractors\u2019 ( most likely churned-out customers ), 7,8 - Neutral, and 9,10 - Promoters (loyal customers). The response rate is very low for this survey. Hence business wants to predict the customers\u2019 sentiment by merely using the transactional data ( bookings, sales leads, service requests, etc. ) without taking any survey inputs. <\/p>\n\n\n\n

The key challenges were data is not balanced and the data for customers with a low rating is sparsely available. Data cleansing and transformation are required as we collect the data from multiple data sources. Customer identifiers are different across data sources. Hence we have to merge data at a common unique identifier. NPS survey is conducted at the email level. There could be chances where both promoters and detractor feedbacks are from the same company.<\/p>\n\n\n\n

EDA Steps<\/strong><\/p>\n\n\n\n

Data Cleansing: Removed the customers with no bookings in the past 5 years and default customers., Removed highly correlated variables ( threshold = 70 % )  <\/p>\n\n\n\n

Data Manipulation: 1. Replaced the outliers ( greater than z  & 0.99)  with z = 0.99, and normalized the input variables between -1 and 1.<\/p>\n\n\n\n

Exclusions:<\/p>\n\n\n\n

1. Excluded the customer details who have had no bookings in the past 5 years, <\/p>\n\n\n\n

2. Excluded the \u201cDefault\u201d account name, especially owing to a large number of SRs<\/p>\n\n\n\n

Models Applied<\/strong><\/p>\n\n\n\n

We have tried logistic regression, random forest, etc., models on this data. The random forest model provides decent accuracy and an F1 score of 76%. <\/p>\n\n\n\n

Impact<\/strong><\/p>\n\n\n\n