Competitor Analysis - Net Promoter Score (NPS) PowerPoint Slide Template & Excel Model
Originally published: 06/04/2020 14:43
Last version published: 07/09/2022 12:14
Publication number: ELQ-29516-13
View all versions & Certificate

Competitor Analysis - Net Promoter Score (NPS) PowerPoint Slide Template & Excel Model

A PowerPoint Template Slide to show your business' NPS Score vs Competition to help strategic investment decisions.


During my time at Strategy& Consulting (PwC Group), in a Buy-Side Due Diligence mission, I was asked to do a slide and an excel model to compare the NPS (Net Promoter Score) of all the campsites of a large Group to its local competitors. I had then to present my conclusions on the positioning of the Group in 1 star to 5 star + campsite categories.

To represent this, I decided to create a graph showing how direct competitors are competing in each "star" category based on a NPS score.

- - - - - - - - -

About NPS (Net Promoter Score):

NPS is one of the key indicators to measure Customer Satisfaction across Time and compared to comparable competitors or alternatives and can be calculated as follows:

Based on Customer Satisfaction Surveys (and especially on the question: Would you refer this service/product to a friend), you can then categorise:

- Promoters (score 9-10): Fuel Growth - they are loyal to your product/service and who will keep buying and refer others.
- Passives (score 7-8): Can go to Competition - they are satisfied with the product/service but unenthusiastic customers
- Detractors (score 0-6): Destroy Growth with negative word-of-mouth - they are unsatisfied customers who can can damage your brand

To calculate the NPS, you have to subtract the percentage of Detractors from the percentage of Promoters. This % has a range of min -100 (all customers are Detractors) to max 100 (all customers are Promoters).

You can calculate & segment this NPS Score per Geography, Product/Service Category, over time, per Manager or any other pertinent axis.

- - - - - - - - -

In my Campsite Buy Side Due Diligence Strategy Consulting Mission, I used Trip Advisor's rating section for each campsite (Group + Competitors) as a data source.

After converting the data into Excel, I modelled the data into a table that could then be represented on a Graph in a PowerPoint Slide.

Given the success of this slide (the Client highly appreciated the insight), I decided to build a "universal" Template for other consultants/executives to do the same with their company's products/services vs competition.

The file is an editable Microsoft PowerPoint Template Slide with an online or offline 18 step-by-step methodology, with pedagogical illustrations for each step. An editable Excel file to adapt the data points to your market/industry/company/competitors is included in the PowerPoint file.

Should you have any questions on using this top tier Management/Strategy Competitor Analysis NPS (Net Promoter Score) Consulting Template slide, you're welcome to reach out to me via Private Message.

Good luck!
- Tim

⭐️ Bundle of 8 Competitor Analysis Strategy Consulting Frameworks (including this one):

⭐️ Bundle of 23 Commercial Due-Diligence Model Templates (including this one):


This Best Practice includes
1 PowerPoint Template Slide + 1 Attached Excel Model + 1 Example + 1 online & offline 18 step-by-step methodology

Acquire business license for $9.00

Add to cart

Add to bookmarks


5.0 / 5 (4 votes)

please wait...