Drilling Down Software Application

Report Software Bugs (none outstanding)

The Drilling Down MS Access application provides the ability to create a "loyalty score" for each individual customer from raw files of customer transactions.  These scores rank each customer against all the other customers for likelihood to respond to promotions and future value to the business, enabling the tracking of customer LifeCycles and creation of very high ROI marketing promotions.

You can achieve the same results by using only an Excel spreadsheet and following the instructions in the book, or using some clever R code created by a reader of the book) or by your own application (business rules supplied).

It takes only 30 minutes to score customers having up to 65,000 transactions (purchases, visits, page views) by hand in an Excel spreadsheet.  The MS Access application is not required to be successful using the techniques in the book; it serves to more easily score customers with a large volume of transactions (65K - 100K) or so; over that you probably want to use the business rules provided in the book to take the task over to SQL server or Oracle. 

Customers with the highest scores tend to be best customers and have the highest response rate to promotions.  Customers with the lowest scores tend to be customers in the process of defecting from the business and have the lowest response rate to promotions. 

Any group of customer activity transactions with a Customer ID, number of units, and date of activity can be scored, for example, purchases or page views.  

If you're not sure what the above means or why it's incredibly important to improving response to marketing promotions and increasing the profitability of your business, you should take the Comparing the Potential Value of Customer Groups tutorial first before reading on.

There are 25 possible customer scores.  The highest scoring customers can be anywhere from 5 to 50 times more likely to respond to promotions than the lowest scoring customers, depending on the type of business.  The scores allow you to target customers by likelihood to respond and future value, driving up sales while shrinking the costs of promotions.  Scores also form the basis for addressing the 3 key elements of profitable customer retention programs -  Profitability of Offers, Identifying Best Customers at Risk, and Optimizing New Customer Value.

The application displays the total customer count for each score.  Users can then see and export a table of all customer ID's and their individual scores in preparation for a marketing campaign.  The book describes using these scores for many different marketing purposes, including customer valuation, retention, determining optimal media purchases, structuring the web site to benefit best customers, and preventing customer defection.

This is a basic application, running on MS Access and using an Excel Pivot Table for output, covering the "base case" from the Drilling Down book.  For those who have the capability to write software apps or are working with rules-based CRM engines, the business rules for creating and using the scores are provided in the book.

Download Software Readme File