Any company armed with a deep understanding of both its cash and customer flows (both in and out) has a competitive advantage over those who do not - and that's what The Bathtub Report is there to give you.
If I had to choose the two most important measures to understand how a business is really doing, it would be the two C's: Cash and Customers.
By law, every public company in the US must issue a Cash Flow Statement (the Source and Application of Funds Statement) in its Annual Report to show where its cash is coming from and where it is being spent. It cuts through the accounting chicanery that we have become aware of in recent times, and lets us see what is really going on inside the business.
It will be some years before companies are required to issue a Customer Flow Statement in their Annual Report because most still don't have a good, reliable system to capture a large share of actual customer spending behavior. At least 75% of sales would probably be the absolute minimum needed to provide shareholders with an insight into customer movement, both into and out of the business. It would certainly tell them how effective management is at providing the right goods and services for the company's marketplace.
Fortunately, we don't have to wait until such a customer metric is mandated by law. For those of us with a good customer database, we can start measuring our customer inflows and outflows immediately. One way to do this is using what I call The Bathtub Report. A consultant friend told me recently he recommends it to all of his clients. A major European retailer told me it is the first customer report they look at each month. Its appeal lies in its simplicity.
To clarify the report further:
A comparison with the same period last year is shown, together with the percentage changes in each component. Three consecutive months of results are shown to give management a feel for trends and, more importantly, changes in trends.
Obviously, the component periods should be changed to suit your particular business, as described in Figure 2 (below). For example, companies that report on a 4-weekly (or 4/4/5 weekly) cycle should do likewise when measuring customer flow, rather than using a calendar month. Also, of course, companies who sell infrequently purchased products (such as furniture or jewelry) might define an active customer as one who made a purchase in the past 12 months (rather than 3 months).
The Bathtub Report - Notes on Preparation and Use
Purpose: To identify the components that affect your Active Customer total, thereby helping you measure how effective you are in building your customer base.
Review Period: This can be weekly, 4-weekly, monthly, or quarterly, depending on the nature of your business and your customer frequency.
Inactive Customers: This definition also varies according to the nature of your business. In the example shown, a business with high frequency, a customer was deemed inactive if no purchases were made within the past 3 consecutive months.
Averages Per Store: Multi-site businesses should express their customer details as averages per store, both to make the numbers readily understandable and to avoid comparison confusion as stores are opened and closed.
A company using this report is able not only to measure the changing level of its active customers from period to period but can improve that level by developing programs that improve the component elements: adding new customers, recovering more lost customers, and reducing the customer outflow (by looking after existing customers better). Through a careful analysis of the results of these different programs, a company can readily discover which programs are the most cost-effective in building its active customer total. These, obviously, are where it will concentrate more of its marketing resources.
As you will no doubt appreciate, a company armed with a deep understanding of both its cash and customer flows (both in and out) will have a competitive advantage over those who do not. I hope that The Bathtub Report will help move your company into the former group!
Brian Woolf is a global leader in loyalty marketing and has written three definitive works on the subject, Measured Marketing: A Tool to Shape Food Store Strategy, Customer Specific Marketing, and Loyalty Marketing: The Second Act. He devotes his time to helping retailers develop, critique and strengthen their loyalty programs.
The techniques and metrics Brian Woolf has developed have become guiding principles for those operating some of the world's most successful programs. He is the President of the Retail Strategy Center, and has consulted, and spoken at conferences, in the US, Europe, Japan, and Australasia.
Prior to his total commitment to loyalty marketing, his corporate roles included Deputy Managing Director of Progressive Enterprises, a major New Zealand retailer; and Chief Financial Officer of Food Lion, a leading US food retailer. He has an M.Com. (Economics) from the University of Auckland, New Zealand, and an MBA from the Harvard Business School.