How much and what kinds of technology does my company need in order to implement a customer stratification program? (Webinar Attendee Question)

The foundation for a customer stratification model is the ability for your ERP system or Data Warehouse to be able to provide key data about your business that would be used to objectively measure the critical factors you identify as part of each of your key dimensions. The factors usually come from your customer master, item master, and transaction master. Page 27 of the research provides you with a list of the 39 most common data fields they recommend utilizing. I would also recommend having at least two years of data available.

Once you have the data, if you have a current version of Excel, you should be able to run all of the calculations using the variousl recommended formulas. These calculations will provide you with spreadsheets full of data. To translate that into information that is easily consummed by your sales force, I would recommend a visualization product that takes the information and puts it into a format that is easy on the eyes. As Dr. Lawrence mentioned, there are several different products available on the market that can take Excel information and transform it into an interactive dashboard of results. We have found the dashboard to be very powerful.