Kevin Hillstrom: MineThatData

Case Study: Interacting Challenges

Category performance comes later ... early in a project, I look for high level trends that help guide me to solutions.

I liberally borrow analytics from my Elite Program runs. The rolling twelve-month view of customer behavior is always illuminating.

There's all sorts of goodies in the table.

Customer counts fall away during 2025.

Annual orders per buyer have declined from about 1.17 per year to 1.14 per year ... in other words, customers are only buying once per year. More on that in a future post.

Items per order collapsed in November 2025.

Price per item purchased accelerated in November 2025. It is usually not a coincidence when items per order decrease and price per item purchased increases ... customers have a budget.

AOV decreased for years, but in the last three months of the year AOV increased at a healthy rate.

I mentioned yesterday the problem with new items. This table clearly illustrates the challenge, and the challenge is a two-year challenge that accelerated late in 2025.

The last two columns illustrate trends among items selling at/above their historical average price point (i.e. a $30 item selling for $30) and items selling below their historical average price point (i.e. a $30 item selling for $20). In the past year, items selling below their historical average price point declined faster than items selling at/above their historical average price point. Though demand collapsed, demand collapsed faster among items selling below their historical average price point. The merchandising team was trying to sell at full price. Good job!

Another important Elite Program table is the Comp Segment table. Here is the table.

There are many tidbits here that shape where the analysis is headed. I'll explain those tomorrow. Interestingly ... there IS a marketing challenge that the table above identifies. Can you see it?

So far ...

A clear merchandising problem with new items.
Customers only purchase one time per year.
Customer counts are decreasing throughout all of 2025.
Prices increased late in 2025.
More full-priced selling in 2025.

Case Study: First Steps

When you work on a new consulting project, you don't ask silly questions like "Why is your company named 'Beans'?" You wonder, you ponder, but you don't ask.

Instead you do two things.

You listen.
You run client data through the Elite Program Code.

Remember, Beans ... The Internet's Only Variety Store ... was a $31 million dollar business that is now a $20 million dollar business. That's an unacceptable drop, and a drop of that nature is generally self-inflicted. Businesses can collapse on their own, they can collapse because they are mismanaged, and they can collapse for both reasons. Typically ... somebody mismanaged something or didn't understand something.

Somebody at Beans mismanaged something or didn't understand something.

I like to run new data through my Elite Program framework. I want to see how a client compares to all other clients. Within a client, there are many points of view ... there are fables, there are stories employees tell themselves. There are also facts about actual customer behavior and actual merchandise categories.

Let's look at a simple comparison in the data. Depicted below are two graphs, one for annual demand from new items, one for annual demand from existing items. I elected to graph each metric with the same scale on the y-axis because doing so is illustrative of the challenges Beans faces.

What do you observe?

Existing item demand takes a hit in the last months of 2025, sure. Now look at the trajectory of new item annual demand. From fourth quarter 2024 through fourth quarter 2025, we have a catastrophe.

I'm literally 30 minutes into the project, and I already have a potential culprit - it's the Chief Merchandising Officer. In my mind, I prepare myself for the fact that future discussions are not going to go well. If this was a marketing mistake, both graphs would decline at the same rate. If this is a merchandising mistake (and it most certainly is), one graph doesn't look too bad while the other graph looks ... bad!

Yup, we're off to a good start.

I'll typically send a tidbit to the project sponsor and anybody the project sponsor wants me to include. I'll clearly communicate that my first view of the data suggests a merchandising challenge, not a marketing challenge. Then I'll duck, because somebody is likely to be angry with my assessment.

P.S.: If you like the comparison above, consider becoming part of my Elite Program, with runs in June / October / February of every year. Cost is $1,800 for the first run, then $1,000 each thereafter. June is just around the corner, friends!

Case Study

Let's spend some time talking about a case study. I will analyze a business called "Beans". The data is real, the company and scenario is fictional.

The business is owned by Paisley Ingram. She calls Beans "The Internet's Only Variety Store". If you ask Paisley, she'll tell you ... "I sell whatever I want to sell. Always have. My customers love me."

Annual Demand/Sales for the past five years.

Demand 4 Years Ago: $31.0 million.
Demand 3 Years Ago: $28.4 million.
Demand 2 Years Ago: $27.4 million.
Demand 1 Year Ago: $25.6 million.
Demand as of 1/1/2026: $20.8 million.

Woo boy.

Let's dive in and see what a study of merchandise and categories can tell us about the problems at The World's Only Variety Store.

Your Mission

Years ago I worked with a CEO who had a Mission for his team.

He firmly believed in retaining customers, in loyalty programs. He believed that he could "force" a customer to become loyal. Seriously. He talked about it. Just get the right offer in front of the right customer at the right time. Throw some points at the customer. Let the customer redeem points when he told the customer it was the right time to redeem points. "It works for BJ's Restaurant and Brewhouse!" Good for him ... free pizookies all around.

The Mission? "We're going to thrive by creating a large number of highly loyal customers, and we have the tools to do this outside of the merchandise we sell."

I mostly disagree with the guy, but he had a clear Mission for his team.

(IDEAS) * (TALENT + LEADERSHP + STORYTELLING) = MISSIONS

His team moved in lock step with his Mission. The guy did his job as a Leader. His Team was talented. His Leadership was good. His ideas were poor. His storytelling was non-existent. This meant his Mission, while clearly articulated, had minimal value.

He needed new customers.

It is possible to have a good Mission but a bad outcome.

Stories Support Missions

I met with a client ... the analyst was struggling to articulate something important. I spent fifteen seconds tying thoughts together ... an Executive then said to the analyst "Why didn't you say that?"

The analyst looked mortified.

Because HE DID SAY THAT!!!

Of course, he didn't say it in a way that resonated with anybody.

Every three or four years, stories re-emerge. They re-emerge because technology moves us in a direction we don't fully understand, leading to a handful of individuals who articulate the future in a way that allows us to feel comfortable, feel knowledgeable, feel confident, and consequently take action.

In my hobby (headphones), people will ask questions about headphones or review headphones on Reddit (https://www.reddit.com/r/headphones/). You can sniff out bad storytelling in two seconds ... it is clear contributors using AI to write, and you know it the minute you see it. AI has a structure that is synthetic and inauthentic. It's obvious. Bad storytelling.

The same thing happens in business.

In catalog marketing, there are no storytellers ... and that is horrifying because the most famous sitcom of all time leveraged catalog storytelling as a core component of the series (Elaine working at the J. Peterman catalog). Seriously ... pick one employee from any ... ANY catalog brand who is a brilliant storyteller. I'll wait for your reply ...

You'd think the catalog vendor community would be able to communicate a compelling story that does not use terms like "digital fatigue", "Gen-Z", or "leading brands".

Human Teams = Talent + Leadership + Storytelling.

Our equation evolves.

(IDEAS) * (TALENT + LEADERSHP + STORYTELLING) = MISSIONS