Drilling Down Home Page Turning Customer Data
into Profits with a Spreadsheet
The Guide to Maximizing Customer Marketing ROI

Site Map


Book Includes all tutorials and examples from this web site
.

Get the book!

Purchase Drilling Down Book

Customers Speak Up on Book & Site


About the Author

Workshops, Project Work: Retail Metrics & Reporting, High ROI
Customer Marketing

Marketing Productivity Blog

8 Customer
Promotion Tips

Relationship
Marketing

Customer Retention

Customer Loyalty

High ROI Customer Marketing: 3 Key Success Components

LifeTime Value and
True ROI of Ad Spend

Customer Profiling

Intro to Customer
Behavior Modeling

Customer Model:
Frequency

Customer Model:
Recency

Customer Model:
Recent Repeaters

Customer Model:
RFM

Customer LifeCycles

LifeTime Value

Calculating ROI

Mapping Visitor
Conversion

Measuring Retention
in Online Retailing

Measuring CRM ROI

CRM Analytics:
Micro vs. Macro

Pre-CRM Testing for
Marketing ROI

Customer
Behavior Profiling

See Customer
Behavior Maps


Favorite Drilling
Down Web Sites

About the Author

Book Contents

 What is in the book?
 Productivity Blog
 CRM   
  Simple CRM
 Customer Retention
 Relationship Marketing
 Customer Loyalty
 Retail Optimization
 Telco/Utility/Services
  Visitor Conversion
  Visitor Quality
  Guide to E-Metrics
  Customer Profiles
  Customer LifeCycles
  LifeTime Value
  Calculating ROI

  Workshops/Services
  Recent Repeaters
  RFM
  Retail Promotion
  Pre-CRM ROI Test
  Tracking CRM ROI
 
Tutorial: Latency
  Tutorial: Recency
  Behavior Visualization
  About Jim
  Consulting
  Praise
  Contact
  FAQ
  Search
 
Downloads
  Privacy

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

 

 
    Home Page


Thanks for visiting the original Drilling Down web site!

The advice and discussion continue on the Marketing Productivity Blog
and
Twitter: @jimnovo

Read the first 9 chapters of the Drilling Down book: download PDF

Purchase Book

Consulting

 

Slow connection?  Same content, less graphics, think Jakob Nielsen in Arial - Go to faster loading website

Contact me (Jim Novo) for questions or problems with anything on this web site.  

 
The Drilling Down Project.  All rights reserved, all media.

   

Ask Jim a Question

/

Get the book with Free scoring software at Booklocker.com

Find Out Specifically What is in the Book

Learn Customer Marketing Concepts and Metrics (site article list)

 


This is the original Drilling Down web site; the advice and discussion continue on the Marketing Productivity Blog and Twitter.

Download the first 9 chapters of the Drilling Down book here: PDF
Purchase Book          Consulting