Welcome | Articles | Books | Samplers | News | Links | About | Contact

The Genus Report

A Tool For Category Managers

by Brian Woolf (September 1, 2001)
 

Product category managers often ask: Who are my customers? One way that we have found helpful in answering that question is by using what we call the Genus Report.

Click here to download, save or open the attached spreadsheet!
(for Microsoft Excel v5 or later - file size: 33Kb)

As seen in the attached example for the Ground Coffee category, we broke out the company’s latest quarter’s results, first by customer spending levels (over $100 week, between $50 and $100 week, etc), and then by spending level in the category (Heavy, Medium and Light buyers).

This lets us see the mix of our customers. For example, the Genus Report methodology allows us to learn such things as who is a heavy spender at the chain but a light buyer of coffee (Can we encourage her to buy more coffee?) or who is a heavy buyer of coffee but doesn’t spend much in our stores (Can we encourage her to do more of her food shopping with us?). It obviously provides extremely valuable information for targeting offers to our diverse customer base.

To explain how to read the report we shall focus on the company’s top spenders for the quarter, the Diamonds, who average over $100 per week. (In fact, their average spending per week was $130.14 (6f).)

We see that for every 1000 households in the chain, an average of 52.5 were Diamonds (1f). Of these, 9.7 were among the top 10% of Ground Coffee buyers in the quarter (1a), while 19.1 bought no coffee at all (1e). The former group comprised 18.4% of the Diamonds (2a), and the latter 36.4% (2e).

Those Diamonds that were also heavy coffee buyers comprised 3.2% of all coffee buyers (3a) and accounted for 11.6% of coffee sales (4a).

This premium group spent $3.90 per week on coffee (7a) or 2.8% of their total purchases (8a). On average, these customers bought 0.85 coffee units per week (9a) providing a coffee gross profit per week of $1.25 (11a). This compares to the total weekly gross profit generated by these customers of $38.81 (10a).

Each customer segment is set out in the same format as for the Diamonds.

There are two primary uses of the Genus Report. The first is to test various marketing offers to different customer cells. The second is to use it as a benchmark for the category manager to see whether he or she can improve the penetration of coffee sales among the various customer segments that flow through the company’s stores.

Those using the Genus Report primarily for the second purpose like to set fixed coffee spending thresholds rather than the top 10%, next 20%, and bottom 70%. This allows a stable measurement base for performance comparisons.

Another variation of the Genus Report is to collapse the report into just three groups: Best Customers (Diamonds and Rubies), Potential Best Customers (Opals and Pearls) and New Customers. For beginners, this approach is definitely recommended.

I hope that category managers can take this report and/or the ideas behind it to gain a better understanding of their categories thereby becoming more effective managers.

Copyright © Brian Woolf

 

 

About the author...

Brian Woolf is a global leader in loyalty marketing. In addition to writing 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 spends his time helping retailers develop and strengthen their loyalty programs.

The techniques and metrics he 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 is a frequent speaker at conferences in the US, Europe and Japan.

Prior to his total commitment to loyalty marketing, his corporate roles included Deputy Managing Director of Progressive Enterprises, a major New Zealand retailer; Chief Financial Officer of Food Lion, a leading US food retailer; and President of One Price Clothing, a women's discount apparel chain. He has an M.Com. (Economics) from Auckland University, New Zealand, and an MBA from the Harvard Business School.


If you would like to reproduce any of Brian Woolf's articles or speeches, please include the source of your quote and a suitably visible web link (to www.brianwoolf.com). Please also contact him (click here) to inform him of any reproductions, including where and when the copy will be reproduced. Thank you!

 


 
Brian Woolf
 
6 Parkins Lake Court,
Greenville,
SC  29607-3628
USA

 
· Contact me ·
 

Who is Brian Woolf?
 
Brian Woolf is a global leader in loyalty marketing. In addition to writing three definitive works on the subject, he spends his time helping retailers develop...  more

Back to Top | Privacy Statement | Terms of Use | About Us