Tag: sku intelligence
Connect With Us
Is your sales history self-encrypting?
Emcien’s mission is to find the actionable intelligence that is hidden in the sales history of configurable products. We call this SKU intelligence. Many companies, however, save their sales history in a way that keeps any patterns hidden forever. I call this self-encryption. Many of these worst practices began as a way of saving space at a time when storage space was expensive.
A configurable product is one where the customer has to make choices to customize the product to his own particular needs or preferences. The valuable patterns are in the way these choices are made. The sales history should be at the right level of abstraction: in terms of the choices that the customer made. Here are four ways you may be encrypting your data.
- SKU Numbers. SKU numbers identify unique product configurations. They are a great shorthand for keeping track of what has been built and what is sitting in inventory. But if the sales history is kept in terms of SKU numbers, and the definitions of those SKU numbers are stored in a different place, then you may not be able to decipher your own history. By “different place” I mean a different database, different computer system, or anywhere that is not part of the history itself.
- Part Numbers. Customer orders get translated into Bills-of-Material (BOM) so that the requested item can be built and delivered. But what happens to the order afterwards? Often it is saved in terms of the part numbers. The customer ordered “2GB of RAM”, which became part 123-XYZ-645A. This was the right part number for 2GB of RAM from a certain supplier during a certain period of time. Remembering 123-XYZ-645A may be important for some warranty issues, but it is the wrong level of abstraction for understanding the customer. Many customers ordered “2GB of RAM”, but they got many different part numbers (different suppliers at different times). Part numbers change constantly, and unless a complete trail of part number changes and equivalences is maintained, a history in terms of part numbers is irretrievably fragmented.
- Standard Options. Most manufacturers make different models of their products, and the different models come with different “standard options”. The sales history doesn’t mention these options because there would be so much repetition (let’s save space!). The problem is that the set of standard options changes over time, even though the model names stay the same. Which options were standard on Model ABC in September 2007? Who remembers?
- Product Packages and Option Bundles. This is similar to the standard option problem. Some set of options is bundled together and sold as the “Sports Package” for some period of time. So the sales history says “Sports Package”. What was in the Sports Package in September 2007? Who remembers?
The sales history should be self-contained, with a record of each unit sold, expressed in terms of the options bought by the customer. If some options were implied by others, but could have been different, then they should be spelled out. If the data is saved in the right way, then the patterns in how customers buy the product can be revealed.
The difference can be dramatic. The message below appears to be gibberish.
|
S |
C |
O |
|
|
T |
D |
F |
|
S |
T |
I |
A |
I |
I |
R |
N |
|
|
N |
I |
L |
|
A |
|
D |
|
A |
S |
E |
E |
N |
H |
E |
I |
|
E |
H |
|
N |
|
E |
S |
E |
|
A |
C |
|
S |
R |
U |
H |
T |
|
R |
R |
M |
I |
|
D |
|
Y |
|
L |
E |
Y |
U |
O |
N |
E |
Y |
But suppose we use the key that Dan Brown uses in “The Lost Symbol”: the magic square discovered by Benjamin Franklin.
|
14 |
3 |
62 |
51 |
46 |
35 |
30 |
19 |
|
52 |
61 |
4 |
13 |
20 |
29 |
36 |
45 |
|
11 |
6 |
59 |
54 |
43 |
38 |
27 |
22 |
|
53 |
60 |
5 |
12 |
21 |
28 |
37 |
44 |
|
55 |
58 |
7 |
10 |
23 |
26 |
39 |
42 |
|
9 |
8 |
57 |
56 |
41 |
40 |
25 |
24 |
|
50 |
63 |
2 |
15 |
18 |
31 |
34 |
47 |
|
16 |
1 |
64 |
49 |
48 |
33 |
32 |
17 |
Then we see the hidden message: “Emcien can easily find the hidden treasure in your sales history”.
The value is that customers are speaking to you when they buy your products. This is the true Voice of the Customer (VOC). But due to the data encryption issue, companies are blind to this intelligence. Unleash this intelligence, and you can drive higher sales and margin by serving the customer with the right choices.
Comments Off
Value of SKU Intelligence (What Are Customers Buying?)
One of the most frequent questions we are asked about Emcien’s methodology is “why hasn’t anyone done this before?” The answer seems obvious to us, but we should probably write it down once and for all so we can just point people to a definitive document.
Exploding SKU’s to attributes generates a LOT of data. It is only useful if this translates to actionable intelligence. As we all know, we don’t need more data. We need actionable items and recommendations to improve business. The simplest answer is that collecting all the attribute data for SKUs has not been done before, because the algorithms have not existed to farm intelligence from them. In this blog I am going to address –
- Why having the data with the SKU attributes is invaluable!
- What analytics capabilities are needed, if you have that data
- Value of having SKU Intelligence (To drive SKU velocity)
Consider a product that has attributes, and offers lots of variety, also called configurations. Almost all products come under that class today! Think car, computer, or cell phone. The product has features, and each feature has alternative options. For example, a car has an engine (V-6 or V-8), a body type (sedan or convertible), and a color (red, green, blue, black, or white). Any specific car has many choices for each of the features. Customers make choices on the features. Do you want the cloth seats or the leather seats? Do you want the DVD player? How about the iPod connector? Make a choice for about 30 features and you are done. This applies for shampoo, toothpaste, computers, light fixtures, consumer electronics, … all products that have attributes choices.
We consider a configurable product that has a large number of features, each of which many alternative choices/options. Notice that we have finessed the hierarchy problem by allowing only two levels: feature and option. A customer will typically call out only a few attributes during a purchase. They expect you to know how you can complete that spec to fill the order. That is the single biggest opportunity at every point of sale!
If we have data with attributes for every SKU, we can begin to talk about buying patterns! A buying pattern is groups of options that are bought together, like the red color with the convertible body style. Or the DVD player with the leather seats. Or the pattern might involve 3 options, 4 options, 5 options…. many options.
Auto detect most popular attributes in fastest sellers
This brings me to a very important point. If you have sales data with attributes, you need an analytics engine that will automatically detect and tell you what attributes are bought together and are highly popular. A reporting tool that makes you query every choice combination will NOT work! You will be very old by the time you get an answer to most popular choices, as there are millions of attribute combinations. Emcien offers an analytics engine with cluster analysis that will tell you what attribute groups are popular. This answers the questions – what are customers buying and what attributes are popular. This knowledge can also be used for planning the SKU definition and knowing what products need to be on the top landing pages of your web site/ store aisles. (SKU Definition is the list of attributes in the SKU.)
Once the SKU definition is in place, 75% of the cost structure and efficiency of your supply chain has been fixed ! Your supply chain operates under the assumption that the SKU definition is correct. What does this mean? This means that if you offer 2 SKUs with slightly different attributes, that could have been consolidated into one, the supply chain will suffer that cost and inefficiency. The SKU definition has to be optimized before you send it into the supply chain. This is a key driver to SKU inventory.
Customers buy products based on choices at the attribute level. If you cannot gather demand intelligence at the attribute level, you are out of touch with your customer. Customers DO NOT buy SKUs. They do not know the SKU numbers, and they do not care.
SKU Challenges Based on Supply Model
Your business falls into one of these categories based on your supply model (see table). Knowing what attributes customers are buying can dramatically improve your demand response. You will be able to improve -
- SKU definition -This means knowing how many SKUs you need and what needs to be in the SKU
- Demand Forecasting – You will be able to forecast demand at the attribute level, which is the level that customers are buying
- SKU Inventory - plan what to stock to have highest turns.
- Sales Productivity and Efficiency – If you know what attributes are selling together, you can implement an automated recommendation engine (EmcienMatch) and your sales rep can recommend a good choice to the customer during the ordering process. This is probably the single biggest value of knowing what attributes customers are buying. Your sales reps are a trusted advisor to your customers. If the sales person know that all customers of a certain type bough a particular configuration, he could recommend that choice to the customer. Win! Customer is happy because he done! Sales person is happy because he looks smart! You are happy because you increased your sales repeatability!
For our Nerdy Math readers, here is technical nugget that you will love:
SO – here is another reason why what Emcien does has not been done before. Statistics deals with numerically valued variables. A numerically valued random variable X has a domain that can be classified as a ratio scale, an interval scale, an ordinal scale, or a nominal scale. In a nominal scale, the numbers {0,1,2,3,…} are just labels and have no numerical significance. In an ordinal scale the numbers provide an ordering, so that 2>1 in some appropriate sense. An interval scale allows real numbers (like 3.27) and differences are significant, but ratios are not. The classic example is temperature. A difference of 10 degrees is bigger than a difference of 5 degrees, but 100 degrees is not twice as hot as 50 degrees. Finally, a ratio scale allows all of the usual numerical operations on real numbers. Most of statistics assumes a ratio scale, and almost all of it assumes at least an ordinal scale. This leads directly to the mean, variance, covariance, and correlation. It also leads to metric spaces with distance functions.
But we want to consider a random variable X that represents a choice between cloth seats and leather seats. You might argue that leather > cloth, because leather is more expensive. But what about color? Is there any sense in which green > red? We are really interested in nominal scales. We may assign 0, 1, and 2 to “none”, V-6, and V-8 respectively, but these are just labels. That has a profound effect on the statistics we can use. And beyond statistics, we will have to develop notions of proximity or closeness that do not depend on distance functions. So it hasn’t been done before because the mathematics you need is not the popular stuff that’s in the textbooks.
Comments Off