Tag: Data Driven

Data-Driven Series: Know Your Customer Type

Data Analysis

Both The Home Depot and Lowe’s continue to focus on the “Pro” customer as the key growth driver for sales. In the case of The Home Depot, there are some interesting store attributes available to vendors, which The Home Depot uses as store descriptors. Last week, I was working with one of our customers who sells product at The Home Depot, and I had an opportunity to help them prioritize where to focus their efforts in 2017. I recommended they spend time identifying, analyzing, and creating specific sales plans for all Pro stores.

To get the conversation started, I showed the vendor a simple summary of dollars per week, per store by customer store type. There are three customer store types: Pro, DIY and Core. Figure 1 shows the average weekly sales by the customer store type. The Pro stores are clearly leading the group in average weekly sales per store by a substantial amount (Figure1).
Dollars Per Week Per Store
Among their 2,200 stores in North America, about 300 Home Depot stores have the Pro customer type attribute. This subset of stores is easily analyzed on a deep dive basis, and results can have a substantial impact on your total sales if you create the correct strategies and execute them well.

To help my customer understand the importance of the store customer type attribute, I pulled 2016 sales for The Home Depot stores in the Anaheim, CA market. If you simply type Anaheim into the homedepot.com store finder you will get back a list of 16 stores. Then, I looked at the total sales by store for each store, and segmented them based on customer type. In the Anaheim market, 12 stores are tagged as Pro stores, 4 stores are tagged as Core, and zero stores are tagged as DIY. Figure 2 identifies the Pro stores with a yellow tag and the Core stores using a white tag. The Pro stores averaged an additional 21% in sales compared to the Core stores.
Sell Thru Time

As we discussed how to leverage this information, I asked the VP of Marketing to pull a list of display promotions for 2016 in the Anaheim market. They ran two displays last year in the market – one in the spring and one in the fall. Each display was a pallet display in the aisle, at the front of their department, with 48 units of product. The average sell-thru time at the Pro stores was 3.75 weeks. The average sell-thru time at the Core stores was 5.35 weeks. The Pro stores are clearly superior when it comes to a high sell thru on a display, and we concluded it would not make sense to ship a display to the 4 Core stores in 2017. Instead, they are allocating those displays to four Pro stores in the Sacramento market. Based on 2016 sales we would expect those displays to perform at similar sell-thru to the Pro stores in Anaheim. Those Sacramento stores did not have a display last year so the sales will represent net new dollars for 2017.

Working to gain an in-depth understanding of stores and their attributes can seem like an overwhelming task when you first tackle the project. With thousands of stores and about three dozen attributes, there are a lot of variables to consider. I find it’s helpful to start with the attributes you hear Home Depot executives focusing on, and then move along to other attributes as you gain efficiency in your analysis. The Home Depot (and Lowe’s) are both very focused on the Pro, which means you should be as well.

DATA-DRIVEN Series: What You Can Learn From Your Average Retail Selling Price

Data Analysis

Last week, I had the opportunity to work with two different customers analyzing their sales at The Home Depot.  One sells products in the paint department and the other sells into the building materials department.  The analysis goal for both customer projects was to deconstruct their YTD sales and identify the factors contributing to higher than expected comp sales increases.  Both customer’s sales for a set of key SKU’s were up about 2.5% YoY and the question they wanted answered was, “What is driving the higher sales, and will it continue?”

Average Retail Price As we deconstructed their respective sales into its component parts of distribution, price, and rate of sale, we uncovered interesting data regarding average retail selling price.  The first customer’s average retail price was pretty consistent across Home Depot stores at the expected $22.95 retail price.  There were some fluctuations, but the data was pretty clustered, as expected.


In contrast, the second customer’s average retail price was very inconsistent.  Customer #2 believed that The Home Depot was pricing their core SKU at $59.95 or $65.95, depending on the market.  However, as you can see in Figure 2, the pricing was very inconsistent across stores.  In fact, we identified stores in the same Home Depot market with a selling price variance of $28.35 per unit.

Home Depot EDI

While there can be good reasons to price a product differently by market due to shipping costs or competitive pressures, it seems irregular to have different prices within the same market.  Take a look at the average retail price of your products. It’s an important exercise that can yield some interesting insights.  It presents an opportunity to have a conversation with your merchant about pricing strategies.  And, It also provides an opportunity to identify markets with similar demographic profiles, but different selling prices, thus providing insight into what price point drives the highest sales.

Does your average selling price match your expectations?  The answer may not be as simple as you think and could reveal some interesting insights.

Home Depot EDI