Once the core components of customer profit are determined, a query can be made against the CRM database. A transaction file can be used if you don't want to build the SQL query to do the summarization.

With nextanalytics, it is a simple matter to summarize by the customer account and calculate the profit dollar and percentage values. This is the usual Customer Profitability report, where it is left to the reader to interpret the numbers and determine what is good and what is great - it tends to raise more questions than answer them.

To get more answers, you can use nextanalytics to perform a quick statistical summary of the data. In the table below, we can see that the Median for Customer Profit ($) is over $4,000, but the average is over $16,000 -- some high profit accounts are pulling up the average, and that is a great thing. 

To find out who they are, nextanalytics can convert the profitability table into a statistical metric - the number of standard deviations away from average.  In a normal distribution, 67% of the numbers should be within 1 standard deviation from average, 95% within 2, 99.7% within 3. As we can see below, there are a number of accounts above 3 - these are the abnormally highly profitable customer accounts.

With nextanalytics, we use a simple filter command to filter the original report based on these findings - showing only those accounts where the profits are more than 3 standard deviations from average. The results can then be sorted by the profit percentage, bringing the combination of high dollar profits and high percentage profitability to the top of the list. These are the accounts that deserve focus and executive attention.

With nextanalytics, your executives don't need to spend their time looking for nuggets of gold in your reports. Use the power of nextanalytics to quickly focus on what matters most and get that competitive edge.