# How to Compute the Next Best Product

For a business-to-business application, how do you go about determining the “Next Best Product” for each of your customers?  Let us assume that you already have a database with your customers and their purchases for the past two years, and that you have overlaid your file with SIC codes, number of employees and annual sales. This data can be obtained from D&B.

Your first job is coming up with meaningful SIC (Standard Industrial Code) categories. For each SIC group, determine your total sales. You may have to do some grouping to get something to work with. You will end up with a small group of meaningful SICs.

Then I would categorize the final SICs by number of employees or annual sales, using one or the other, depending on your preference. We can divide them into three categories such as under 400 employees, 401 to 1000, and over 1000 employees.

What do they buy?

From all the SKUs sold to customers, group them into categories. For example, a company with 40,000 different products might group them into:

• Hoses
• Valves
• Pipe
• Switches

Now comes the time to use a sophisticated model. We take each of our several hundred current customers and determine their sales in each of our major product groups. We look at their SIC and employee size category. The model will create a next best product for each of the customer companies based on their product purchases ranked against the other companies in their SIC and company size group. Each of the company score card will look like this:

 XYZ Company Average Annual Purchases Hoses Valves Pipe Switches Total Group Average \$38,002 \$60,003 \$42,001 \$2,002 \$142,008 This Company \$22,001 \$78,003 \$1,001 \$8,990 \$109,995 Next Best Product \$42,001

What this table says to the sales force is that for the XYZ company, the Next Best Product to sell them is Pipe, and that their annual sales to this company could amount to \$42,000 per year, based on the purchases of other similar companies.

The customer database can produce numbers like this for every company. They can be given to the sales force. Each salesman can be measured not only on total sales, but on their ability to increase sales into these conquest categories.

Arthur Middleton Hughes, vice president of The Database Marketing Institute, has presented 28 seminars on database and email marketing.  Arthur has also authored several books includingStrategic Database Marketing 4th Edition (McGraw-Hill 2012). He and Andrew Kordek, chief strategist and co-founder of Trendline Interactive, are hosting a two-day Email Strategy Study Group in Fort Lauderdale  March 26-27, 2013, featuring group competition for email marketers responsible for subscriber acquisition, lifetime value, ratings and reviews, boosting their email budget, and doubling their ROI.  To learn how to attend the Study Group, click here

Post Footer automatically generated by Add Post Footer Plugin for wordpress.

VN:F [1.8.6_1065]
Rating: 0.0/5 (0 votes cast)

Arthur Middleton Hughes has published over 200 articles on Database and E-mail Marketing. Click Here to read them.

## Featured Books

Strategic Database Marketing 4th Edition: from Arthur Hughes.

To take the quizes from this book click here.

Successful E-mail Marketing Strategies: from Hunting to Farming (RACOM 2009) by Arthur Middleton Hughes and Arthur Sweetser.

This new book takes readers through a step by step approach to implementing database marketing essentials to improve e-mails marketing returns intelligently. This is the book that the trade press has been raving about.

The two Arthurs make it easy to see the difference between primitive “Hunting” and customer-centric “Farming”. This is a game-changing attitudinal shift. If you want your e-mail marketing to succeed, learn how to farm.—Stephanie Miller, VP Return Path Click here to download free the exhibits from this new book.

Strategic Database Marketing: from Arthur Hughes.

Customer Churn Reduction and Retention for Telecoms: Models for All Marketers: from Arthur Middleton Hughes.

Arthur Middleton Hughes has just published a new book of Marketing Strategy for Telecoms including Landline and Wireless Telcos, Cable TV, Satellite TV, BPL, IPTV, VoIP and WiMAX.