Thanks for visiting the original Drilling Down web site!  

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

Read the book-
First 9 Chapters: pdf

Get the book at Booklocker.com

Relationship Marketing, Customer Loyalty, and Retention book

Customers Speak Up on Book & Site

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

Fresh Customer
Marketing Articles

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

Book Contents

Contact Jim Novo

 

 

Drilling Down

Turning Customer Data into Profits

 with a Spreadsheet

Site and Book topic:

Maximizing marketing ROI with customer behavior analysis

 


Learn Methods, Metrics
(site map)

[ Home ]    [ FAQ ]    [ Download   [ Contact / About / Privacy ]

This is the faster loading site for slow connections.  The "pretty" version of this page is here.


Drilling Down Software

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

You can achieve the same results by using only an Excel spreadsheet and following the instructions in the book.  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, page views. visits, log-ins, downloads, etc.

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 might take the 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 then 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 addressing all the above marketing techniques are provided in the book.

You can achieve the same results by using only a spreadsheet of any kind and following the instructions in the book.  MS Access is not required to be successful using the book, only to run the application included with the book.

What would you like to do now?

Get the book with Free customer scoring software at:

Booklocker.com     Amazon.com     Barnes & Noble.com

Find Out Specifically What is in the Book

Learn Customer Marketing Models and Metrics (site article list)

 

Note: This is the "slow connection" version of the home site.  It's intentionally sparse design allows faster page downloads.  To access this content in what some say is a more visually appealing format, click here.

Questions about any of the concepts on this site?   e-mail me.

What Will I Learn
in the Book?

About the Author
Newsletter Sign-Up

Example of the
Drilling Down Method

See Drilling Down
Results in Action

Relationship Marketing
Customer Retention

Customer Loyalty

Get the Book
with Free Software!
(Booklocker.com)

Fresh Drilling Down
Related Articles

Advanced Customer
Modeling Articles

       [ Home ]    [ FAQ ]    [ Download ]    [ About / Contact / Privacy ]  

Welcome to the original Drilling Down web site;
recent advice and discussion are on the Marketing Productivity Blog and Twitter.

Contact me (Jim Novo) for questions or problems regarding this web site.   
Copyright The Drilling Down Project. All rights reserved.  Privacy Policy.