Let's approach this discussion in bite-sized pieces. This table reviews repurchase activity for Apparel Tops . . the best-selling category that Beans: The Internet's Only Variety Store sells. Yes, there's a lot going on here. An introductory tidbit . . ...
‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ 

Kevin Hillstrom: MineThatData

Case Study: Customer Response To Merchandising Changes

Let's approach this discussion in bite-sized pieces.

This table reviews repurchase activity for Apparel Tops ... the best-selling category that Beans: The Internet's Only Variety Store sells.



Yes, there's a lot going on here.

An introductory tidbit ... in the past year, 79% of demand in Apparel Tops comes from customers who haven't bought in at least a year or are first-time buyers. Only 16% of demand came from last year's Apparel Tops customers and just 5% of demand came from other twelve-month buyers.

If you are the marketer trying to grow Apparel Tops (your best-selling category), what might your approach be?

  • Awareness (organic social) and Search (product listing ads).

You could try to squeeze more out of existing buyers, but what is the point? If your efforts were positive and increased sales among existing Apparel Tops buyers by 10%, total demand would grow by 16%*10% = 1.6% ... meaningless.

When a merchant tells you that the marketer is not getting her product in front of the "right customers", the merchants is both wrong and right at the same time.
  • Wrong, in that the merchant usually has minimal experience with marketing techniques.
  • Right, in that most categories benefit from exposure to prospects who haven't bought the product previously.

Pay attention to rebuy rates over time.
  • 16% to 15% to 14% to 11% for existing buyers.
  • 7% to 6% to 6% to 4% among all other twelve-month buyers.

This is a mystery that requires professional levels of communication.
  • The category is stable because new/reactivated customers are buying the product.
  • The category is stable because new/existing items are being managed reasonably.
  • The housefile ... twelve-month buyers ... are increasingly less likely to buy this product, but their share of total demand is not sufficient for management to notice there is a problem.







        
 

Case Study: Hints of Discontinued Items

Remember our "Class Of" table for the Fashion category? I do.



There are "tells" in this table that help me understand how a merchant approaches the business. In this case, the merchant in charge of Fashion discontinued existing items. Yes, the merchant failed to introduce enough new items to grow the category. Acknowledged. But the merchant also decided to take the hatchet to existing items.

How do I know this?

Look at the Class from Three Years Ago. Demand went from $564k to $384k to $160k in Years 1/2/3. Demand trails off after the introduction year, then trails off faster.

Look at the Class from Two Years Ago. Here comes a "tell". Demand went from $860k to $276k to $75k. That doesn't happen because the items fall off faster ... that happens because a merchant says "I don't like those items". Not liking existing items and then not introducing enough new items is one of two things.

  1. The merchant is killing the category on purpose (which happens all the time).
  2. The merchant is committing professional malpractice.

Our job is to understand if (1) is happening or if (2) is happening.

If a merchant is trying to purposely kill a category, the merchant has to demonstrate that killing the category does not impact other categories. In other words, when I worked at Nordstrom, if we killed off Cosmetics we'd be killing off the business because fragrance on the ground floor of a store brought in new customers who shopped the entire store. There's nothing more alluring to customer acquisition than fragrance.

Tell me what you've learned so far (kevinh@minethatdata.com). Are you finding this valuable? My clients find it valuable.





        
 

Case Study: The Virus Is Spreading

Yesterday we talked about the fact that Fashion was being starved by a lack of new items. Because existing items either die off quickly or are discontinued quickly, new items must fill the gap if a category is going to thrive.

I summarized all categories - looking at new items by year, as well as demand across new items and existing items. Here we go.




What does the data tell us? A lot. Your category data will communicate to you as well.

Total Business = Starved of New Items.

Apparel Bottoms = Not Starved.

Apparel Tops = Not Starved.

Fashion = Starved.

Home = Starved 2 Years Ago, Lack of New Item Demand in the Past Year.

Jewelry = Starved.

Entertainment = Starved.

Workplace = Drastically Starved.

Outside = Not Starved.

Having Fun = Starved and a Lack of New Item Demand (might be a metaphor in this category).

Seasonal = Starved.

Decorations = Not Starved (many new items 1-2 years ago).


We have Apparel Bottoms, Apparel Tops, Outside, and Decorations that are being managed consistently. Everything else? Being cut to the bone.


Apparel Bottoms / Apparel Tops / Outside / Decorations?

  • 1,099 new items three years ago, 1,055 new items today.
  • $7.1 million existing demand three years ago, $7.1 million today.
  • $6.7 million new item demand three years ago, $5.5 million today.

Everything else?
  • 2,047 new items three years ago, 1,125 new items today.
  • $7.4 million existing demand three years ago, $5.5 million today.
  • $7.2 million new item demand three years ago, $2.6 million today.

In the four "preferred" categories, there is still degradation in new item demand on a comparable number of new items.

All other categories are simply imploding.

This business isn't failing. Management is likely failing the business. Four categories are performing acceptably. I emailed Paisley Ingram a paragraph about what I observed.


From: paisley.ingram@beans.com
Sent: Monday, May 4, 2026 11:13 PM
To:
Kevin Hillstrom <kevinh@minethatdata.com>
Subject: RE:
Four Key Categories

Kevin, we certainly struggled with our merchandising strategy the past four years. We know that Apparel is performing well, so we elected to prioritize Apparel. Sloane's arrival (our Chief Merchandising Officer) has been invigorating! She has us focused on products and categories that performed well historically. She uses actual performance data to show us "what works", then plans her assortment accordingly. She believes that new items are inherently risky, and any downside to not having enough new items can be overcome by a sound marketing strategy to attract customers or speak to loyal buyers. She strongly believes in a marketing/merchandising partnership that is led by product carryover tactics.

You keep asking interesting questions that stray from marketing, focusing on what we sell and how we sell it. Are you suggesting a gap between our current merchandising strategy and our results?

Best,

Paisley


______________________________________________________

From: Kevin Hillstrom <kevinh@minethatdata.com>
Sent: Monday, May 4, 2026 4:57 PM
To: paisley.ingram@beans.com
Subject: Four Key Categories

The data suggest that about half of your business is somewhat healthy ... Apparel Bottoms, Apparel Tops, Outside, and Decorations. All other categories show a disinvestment in new items, new items then fail to become existing items, causing those categories to perform poorly over time, with an acceleration in poor performance in the past year. Was there a plan to contract the business, or was there a plan to approach most categories differently and the results observed were unexpected?

Thanks,

Kevin





        
 

Case Study: Killing a Category

Last week I showed you category performance over time. The result was ... chaos.



When I see chaos, I dig into what might be causing chaos. Apparel Tops have performed reasonably well over time, certainly not exhibiting the dramatic declines observed elsewhere. I produce a "Class Of" report to understand how different merchandise classes are behaving. Here is the Class Of report for Apparel Tops.



Ah. This table has so much information in it. New item development is reasonably consistent over time ... 799 styles to 757 styles to just 637 new styles last year to 748 new styles in the year just ended.

Look at how much demand new items generate in year two. Three years ago, new items generated $4.6 million in year one and $2.0 million in year two. Two years ago, the relationship was $4.6 million / $2.3 million. A year ago the relationship was $3.7 million / $1.7 million. In other words, new items either die off quickly or are quickly discontinued. When this dynamic happens, it is critically important to constantly replenish the assortment with new items. "Beans" (The Internet's Only Variety Store) appears to replenish new items within Apparel Tops at a reasonable rate.

Of course, Apparel Tops is a category that is hanging in there.

Fashion, on the other hand, is struggling. What does the Fashion Class Of report look like?



Do you see the change in management of the category?

Look at new styles by year ... 120 to 175 to 167 to 97.

Look at demand by year ... $1.2 million to $1.5 million to $1.4 million to $0.8 million.

The category isn't dying.

The category is being killed by Management ... or more specifically, by the Merchant in charge of Fashion.

Obviously there are times when it is good to kill off a category ... customers don't like the merchandise, times are changing, gross margins are poor. I asked Paisley Ingram, the Owner of Beans (The Internet's Only Variety Store), her thoughts about Fashion.


From: paisley.ingram@beans.com
Sent: Sunday, May 3, 2026 8:06 PM
To:
Kevin Hillstrom <kevinh@minethatdata.com>
Subject: RE:
Category = Fashion

Kevin, thank you for noticing this trend within Fashion. Our Chief Merchandising Officer, Sloane Montgomery, thought it was a good idea to trim the assortment down to winning items, giving customers a focused assortment to browse from. As Sloane says, "It doesn't matter how many new items we sell, most items appear new to customers who haven't seen the item before". She thinks you might want to dig into the problem more carefully, identifying marketing issues that led to the demand shortfall.

Best,

Paisley


______________________________________________________

From: Kevin Hillstrom <kevinh@minethatdata.com>
Sent: Sunday, May 3, 2026 6:15 AM
To: paisley.ingram@beans.com
Subject: Category = Fashion

When I analyzed Fashion, I quickly observed that the number of new items in the past year was cut nearly in half. This reduction in new items led to a significant reduction in demand in the category. Is there a reason why this happened?

Thanks,

Kevin






        
 

Case Study: Merchandise Chaos

There are simple reports I produce to introduce me to category performance. Below is a summary of five year's of demand/sales data by category. Prepare for chaos.




This is a company ("Beans" ... The Internet's Only Variety Store) that is lost.

Why do I suggest this company is "lost"?

There is no merchandise consistency within this brand. It is common for a handful of categories to be the "gravity" that holds a brand together. When I worked at Nordstrom, you'd have some mix of womens / mens / footwear / cosmetics that generally glued customers to the brand. It would have been crazy for footwear to be +40% and cosmetics to be -40% ... long before either category skewed beyond +/- 10% somebody would have been promoted/fired.

Look at Fashion ... Fashion is -46% IN JUST ONE YEAR! How does that happen?

Jewelry? It looks like it is being killed off. Same thing with Office. And Media. And Recreation.

Seasonal merch went from nothing to something to nothing.

Meanwhile, Table Top / Outdoor / Apparel Bottoms / Apparel Tops are not performing poorly.

I asked Paisley Ingram what happened?





From: paisley.ingram@beans.com
Sent: Tuesday, April 28, 2026 2:16 PM
To:
Kevin Hillstrom <kevinh@minethatdata.com>
Subject: RE:
Five Year Category Performance

Our long-time Chief Merchandising Officer left the company four years ago to spend more time with her family. We wish her well in all endeavors. Her replacement left the company about two years ago to spend more time with her family. We also wish her well in all endeavors. Our current Chief Merchandising Officer is Sloane Montgomery. Sloane firmly believes in a focused assortment of favorites that customers love, and she is a strong believer in our apparel offering.

Thanks,

Paisley


______________________________________________________

From: Kevin Hillstrom <kevinh@minethatdata.com>
Sent: Tuesday, April 28, 2026 11:47 AM
To: paisley.ingram@beans.com
Subject: Five Year Category Performance

I took a look at category performance by year. It is obvious that something unusual happened 3-4 years ago, and again in the past year or two. Is there anything I need to know about your merchandising strategy as I dig into category performance?

Thanks,

Kevin