Buy the book on Amazon.com, or buy the Kindle version here!
Time to open up your spreadsheets! (e-mail if you would like a copy).
Ok, enter the value "0.00" into cells C6 - G6. Next, enter the value "0.00" into cells B101 - B340. Finally, enter "1,000" into cell B189.
Next year, we'll retain 38.4% of these customers (cell C11). These customers will order 1.49 times (cell C16), buying 2.47 items per order (cell C17), paying $48.02 per item (cell C18). Notice that as time goes by, these customers become more loyal, buying more expensive items. By the end of year five, these customers are purchasing $83.00 items.
Now, enter "0.00" into cell B189. Enter "1,000" into cell B190.
Next year, we'll retain 36.8% of these customers (cell C11). So basically, these customers are very similar to the customers outlined earlier. However, these customers will order 1.6 times next year, buying 3.0 items per order, paying $40.89 per item.
In other words, these customers are subtly different --- about the same repurchase rate, but buying more items per order, and buying cheaper items as well.
Over time, these customers also buy more expensive items, but only spend $71.89 per item by year five. But notice that these customers are worth more in year five than the customers in the first segment (spending $77,000 in year five, vs. $57,000 in the other segment).
There are such subtle differences between customers in the businesses we manage. Our dashboards and reports suggest similarities. Over time, similar customers with subtle differences in purchase behavior diverge, becoming fundamentally different customers. When we optimize our business for short-term results, we miss out on the things that cause us to have a healthy business in the long-term.
Helping CEOs Understand How Customers Interact With Advertising, Products, Brands, and Channels
November 11, 2009
Subscribe to: Post Comments (Atom)
I Don't Have Control Over New Customers Anymore
We dig into the findings of a Marketing Budget Experiment. The CEO is anxious, because 72% of Paid Social customers are new, while 28% are e...
It is time to find a few smart individuals in the world of e-mail analytics and data mining! And honestly, what follows is a dataset that y...
Sometimes you think "people already know this stuff". Sometimes you realize that Google Analytics give smart analysts almost no op...
If you want to understand why clients don't trust vendors and trade journalists, read this little peach from a week ago: Direct Mail is ...
Post a Comment
Note: Only a member of this blog may post a comment.