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

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


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:

Customer Model:

Customer Model:
Recent Repeaters

Customer Model:

Customer LifeCycles

LifeTime Value

Calculating ROI

Mapping Visitor

Measuring Retention
in Online Retailing

Measuring CRM ROI

CRM Analytics:
Micro vs. Macro

Pre-CRM Testing for
Marketing ROI

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.

See Drilling Down in Action - description below graph

Good Recency

The likelihood of a customer to repeat an action (purchase, visit, game play) relative to other customers can be predicted using a customer LifeCycle metric known as Recency.  Recency is defined by the number of days or weeks since the customer has performed the action (purchase, visit, etc.) you are profiling.  The more Recently a customer has engaged in an action, the more likely they are to repeat the action, especially when encouraged to repeat by some kind of promotional effort.

This is a graph of customer Recency (time elapsed since last activity) based on last visit (or page view) date.  The number of unique visitors is on the left (y-axis) scale; the number of days since last visit (or page view) on the bottom (x-axis) scale.  This site has about 5 million unique visitors a month.  "Yesterday" is at the far left of the chart – 1 day ago.  The right side of the chart is 90 days ago.

Customers are plotted by the number of days since their last visit (page view).  For example, all the customers without a visit in the past 7 days are counted and the total is represented on the graphed line above the "7" at the bottom left of this graph.  Look at it for a minute.  What does this data speak to you?

If your answer is these guys have a great business, you’re right.  I mean, they have 5 million uniques TOTAL, and almost all of them visited YESTERDAY.  Not only that, but virtually ALL of them have visited in the last 10 days!  This is a smokin’ business.  But you wouldn’t know that without looking at Recency, would you?  You have to know this stuff.  It means something very important, not only to marketing, but also to the value of your business. 

Now take a look at this second graph below.  Once again, a graph of customer Recency, based on last visit (page view) date.  Unique visitors are on the left (y-axis), and days since last visit (page view) on the bottom.  Yesterday (1 day ago) on the far left, 90 days ago on the far right.  This is a smaller site. They launched with about 60,000 uniques 90 days ago, but only about 3000 a day come back now.  What’s the future of this business?  What’s the data say to you?

Bad Recency

It’s toast, man.  Absolutely moribund.  They’ll be lucky to keep the visitors they have.  They need to make major changes, and I hope they have the e-mail addresses of those people who never came back so they can promote their new offering.  If they don’t, there’s not much hope. 

These two businesses didn’t just magically get to where they are overnight; there was a process, where customer behavior changed over time.  Wouldn’t it be great if there was a way you could keep tabs on this process, a way to know the direction your business is headed?  There is, and you can learn about it by taking the Drilling Down Method Tour.

What would you like to do now?

Get the book with Free customer scoring software at:     Barnes &

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!

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.