• List Price: $99.20
  • Save: $4.96 (5%)
Only 5 left in stock (more on the way).
Ships from and sold by Amazon.com.
Gift-wrap available.
Condition: Used: Good
Comment: Shared Knowledge is a not for profit public charity! Check us out on facebook. We provide funding for educational programs in Richmond, Virginia. PLEASE READ FULL DESCRIPTION -USED GOOD- This book has been read and may show wear to the cover and or pages. There may be some dog-eared pages. In some cases the internal pages may contain highlighting/margin notes/underlining or any combination of these markings. The binding will be secure in all cases. This is a good reading and studying copy and has been verified that all pages are legible and intact. If the book contained a CD it is not guaranteed to still be included. Your purchase directly supports our scholarship program as well as our partner charities. All items are packed and shipped from the Amazon warehouse. Thanks so much for your purchase!
Access codes and supplements are not guaranteed with used items.
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

DRILLING DOWN: Turning Customer Data into Profits with a Spreadsheet - Third Edition Paperback – June 18, 2004

ISBN-13: 978-1591135197 ISBN-10: 1591135192 Edition: 3rd

Buy New
Price: $94.24
19 New from $94.24 14 Used from $70.34
Amazon Price New from Used from
"Please retry"
$94.24 $70.34

Frequently Bought Together

DRILLING DOWN: Turning Customer Data into Profits with a Spreadsheet - Third Edition + Data-Driven Marketing: The 15 Metrics Everyone in Marketing Should Know
Price for both: $114.10

Buy the selected items together

Holiday Deals in Books
Holiday Deals in Books
Find deals for every reader in the Holiday Deals in Books store, featuring savings of up to 50% on cookbooks, children's books, literature & fiction, and more.

Product Details

  • Paperback: 356 pages
  • Publisher: Booklocker.com, Inc.; 3 edition (June 18, 2004)
  • Language: English
  • ISBN-10: 1591135192
  • ISBN-13: 978-1591135197
  • Product Dimensions: 5.5 x 0.8 x 8.5 inches
  • Shipping Weight: 1 pounds (View shipping rates and policies)
  • Average Customer Review: 4.8 out of 5 stars  See all reviews (8 customer reviews)
  • Amazon Best Sellers Rank: #1,245,952 in Books (See Top 100 in Books)

Editorial Reviews

From the Publisher

Here's some Frequently Asked Questions on Jim Novo's book:

Q: You say these techniques work for "any size business". How can that be? What kind of business does it work for?

A: The Drilling Down approach uses customer activity profiling. Online customer behavior is pretty much the same in a small or large business scenario; if visits or purchases are important to the profitability of the business, the Drilling Down approach works.

The tools used by each size of business are different, not the ideas driving their use. For example, a small business may be using MS Excel or Access to keep track of customers, and a large business would be using a CRM app. The small business would be exporting targeted customers to a file; large business would be using the Drilling Down ideas to build rules for the CRM engine.

That said, the Drilling Down approach is probably least useful in very high ticket B2B shops, where sales cycles are quite long and usually handled by salespeople. Drilling Down is a "direct to customer" approach, and works particularly well in online content publishing and retailing.

Q: What's an "activity-based" profile, and why is it important?

A: Activity-based profiles or models are more powerful than demographic profiles because they are about "action", they attempt to predict the future. Will the customer visit again? Will they buy again? Will they respond to a promotion? These are the types of questions activity-based profiles answer. You will not get these answers from knowing a customer is 45 years old, lives in New York, and likes cats.

That said, adding demographics to an activity-based profile can be very powerful, because the demos supply some of the answers to "why" the customer may behave in the way predicted by the activity-based profile. This allows you to write better copy for promotions and more carefully target groups of customers.

Q: What kind of customer data do I need?

A: The least data you need is a group of customer transactions from a single source (purchases or visits, for example) having a date of the activity and customer identifier of some kind. Any data you have beyond this just improves your ability to profile your customers.

Q: What methods does Drilling Down use?

A: Drilling Down uses derivations of the RFM method developed in cataloging and TV shopping for predicting the likelihood of a customer responding to promotions and judging a customer's value to the company. There are three important differences though. First, the original RFM model is a "one shot" model, taking a snapshot of customer behavior at a point in time. The Drilling Down method looks at customer behavior over time (Customer LifeCycles), which greatly improves on the original model. Second, interactive customers behave differently than offline customers, so the "classic" RFM approach has to be modified for use on the 'Net. Third, the original RFM model is difficult for people without a background in database marketing to deal with. The Drilling Down method simplifies the process to make it easy for people new to data-driven marketing to use, and adds the capability of using visual displays (graphs and charts) of customer behavior to aid in decision making.

Q: Why is the Drilling Down approach unique?

A: Most books or articles on the Latency, Recency, and RFM models are difficult to digest and hard to follow. They show you the theory but don't teach you how to actually construct and implement High ROI Customer Marketing campaigns yourself. This book shows you how to profile and segment or score customers, step by step, in simple language, with a spreadsheet (or any other program you want to use or write yourself to do the scoring - the business rules are provided). Then it shows you how to use the results like the big guys do to increase profits!

This is just where it starts, though. This book extends the basic theories of RFM into a number of tools you can use to improve customer retention, measure the effectiveness of content changes to your site, put a valuation on your business and more.

Along this journey you will also learn how ROI, LifeTime Value, customer LifeCycles, and all the other little gems of data-driven marketing link together for a total picture of how marketing with customer data works.

Q: What's the output of all this, what do I get in the end?

A: In the most simplistic case, each customer gets a "score" to start off their profile. This score ranks the likelihood of a customer to respond to a promotion relative to all the other customers, and is a measure of a customer's future value to your business. The score allows you to rank your customers by where they are in the customer LifeCycle. As the book advances, you see how to use these scores in a lot of different ways, both alone and in combination with any other customer data you may have. The actual "physical" output favored in the book is graphs and charts, so you can "visualize" customer retention and defection, and pick targets for marketing campaigns by looking at these graphs and charts.

Q: What if I don't sell anything on my site? Can the book help me?

A: Absolutely. Any activity a customer generates (a visit or download, for example) can be used in profiling. Content only sites can benefit from using profiles to determine who their best customers are, what parts of the site they visit, and what areas could use improvement. Just because a page has high traffic doesn't mean your best customers are using it. What if you found out your "stickiest" customers actually hang out more in a low page volume area? This would have tremendous implications for the site design and content. Profiles can also be used to assess the effectiveness of changes made to the site. There are solid examples of these approaches provided in the book.

From the Author

Got customer data? Have you figured out how to turn it into increased profits for your company? If the answer is no, this book was written for you.

It doesn't matter if you are large company with lots of resources or a small start-up, whether you are an IT or marketing person, whether your tool of choice is a data warehouse or a spreadsheet, the toughest part about using your customer data to increase sales or reduce costs (or both) is figuring out where to focus your efforts. What data is most important to evaluate? How do I organize the data into reports that make sense to people and are actionable, reports that drive profitable business decisions?

Here is the secret. No matter what your company calls this use of customer data to increase profits - CRM Analytics, Relationship Marketing, Database Marketing, Behavioral Targeting - the three step path to success is:

1. Track customers using simple customer value metrics that really mean something to the profitability of your business, now and in the future

2. Set up early warning reports or automated "trip wires" to alert you to positive or negative changes in these metrics affecting your future sales and profits

3. Launch a marketing or service action with the specific customers flagged by your reports to either increase your sales, reduce your costs, or both

The Drilling Down book teaches you how.

Jim Novo

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

4.8 out of 5 stars
5 star
4 star
3 star
2 star
1 star
See all 8 customer reviews
Share your thoughts with other customers

Most Helpful Customer Reviews

4 of 4 people found the following review helpful By Katerina on September 7, 2010
Format: Paperback Verified Purchase
Dear Mr.Jim Novo!

First of all, I'd like to apologize for my English!
My name is Ekaterine Maglakelidze. I am a lecturer at Tbilisi State University and University of Georgia(Georgia, the former Soviet Union).
I'd like You to know that Your book is the first item I've bought in Amazon.com. I do really appreciate Your book. I think it is the best book among those I've ever read in Consumer Behavior. What I really appreciate is that materials are very comprehensive and quite simple to understand especially for foreigners. I have recommended Your book to my students at Tbilisi State University and at University of Georgia(it is a private University located in Tbilisi, Georgia).They are happy to know how to use behavioral-based metrics (like Latency) and how to Design High ROI Marketing Programs. You see students are fed with theoretical materials that have no practical use. They are happy to have customer scoring software but they have not installed Your spreadsheet yet but I think we will manage it.
Finally, We will be happy if You find time to visit Our University and give the lecture.

Best regards,
Ekaterine Maglakelidze
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
4 of 4 people found the following review helpful By Alan Eager on June 30, 2003
Format: Paperback
This is truly a great guide. The author assumes no prior knowledge and walks you through many examples about how to do Recency and Frequency (RF) scoring, hurdle rates, Lifetime value and how to apply it to your direct marketing campaigns. I got a lot out of this book as is deals with the scientific nature of transaction and customer analysis.
A little pricey, but you can get the pdf from the website...
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
1 of 1 people found the following review helpful By Derick Jose on June 23, 2008
Format: Paperback
This is one of the most actionable book on Analytics I have seen in the market. Lots of specifics around scenarios which tell a layman how interplay between recency , frequency across various industries can be used to derive simple insights. One word of caution though. The RFM metrics have to be seen in the context of the business process cycle and the different rhythms of the industries they apply in. In short Jim makes the complex , simple .
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
Format: Paperback
Jim is a straight-forward guy and this book cuts to the chase. Are you segmenting your customer data... how hard? If you are not factoring in recency/latency and the previous purchase behavior to predict and quantify things like long term customer value, intent to repurchase, subscriber valuation you are probably offering incentives to customers who would have bought otherwise and lowering your margins and in turn letting customers who have fallen out of the buying cycle disappear completely. With the economy pinched your best ROI is in your customer data and you need to spend the $99 for this book as the key to unlock it. Get the book, your XLS data and get after it. Jim writes as he speaks, good author and even better guy
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

What Other Items Do Customers Buy After Viewing This Item?