Shows Customer Retention at team/rep level, as well as who you are losing customers to.
Jump to Overview | Samples | Alert Functionality | Related Alerts | Webinar
Click to Subscribe
Overview
Overview
When Gary completed his certification on Net Promoter Score, the key take away quote was "a 5% increase in retention can result in a 50 to 100% increase in profit". This all tied into the cost of acquiring a new customer versus keeping the ones you have. Understanding why you are losing customers is the 1st step.
This Power BI report will allow you to see which teams/reps are losing the most, who you are losing to, and we can even track how you are winning deals allowing you to put plans in place.
See about tracking referrals here.
Type of Output: On Demand Power BI Report
* * *
Sample
Sample
Home Page:
Account Retention by Sales Rep:
Contracts Won:
* * *
Alert Functionality
Alert Functionality
-Click here for getting Power BI in place
The first step is to identify the group of customer/contracts you're analyzing. This is filtered by Branch, Contract Type, and Metered/NonMetered contracts.
Once that is established:
- New customers did not have an active contract at the beginning date
- Lost customers did not have an active contract at the end date
- Churn are for costumers that had a contract at both the begin and end date.
This is a very bare bones way to identify new vs. lost customers. We wrestled with the idea of "What defines a new customer?". Did they have a contract a year ago and now they resigned? Do they have an active contract but it isn't for Managed IT or Managed Print? When we look at just the dataset being analyzed, it became more clear cut.
Related Alerts
Related Alerts
ID568 - eAuto Activity Trends Power BI
ID704 - The Financial "Model" Power BI
ID770 - Financial Dashboard Power BI
ID771 - Service MIF & Profitability Power BI
ID774 - Customer Business Review Power BI
* * *
Webinar
Webinar recorded November 16, 2021
0 Comments