- You are less profitable because you send your profit to support agencies. You lose out on equity or bonuses.
- They generate an increase in net sales.
Helping CEOs Understand How Customers Interact With Advertising, Products, Brands, and Channels
June 07, 2026
Oh Come On!
June 03, 2026
At 10,000 Feet?
We established that there are four categories that the Merchandising Team believes in ... and seven categories that are being purposely contracted.
Does a contracted category impact customer response?
Yes.
Let's look at how many customers bought from the four primary categories and all other categories (both) in the past four years.
- 3 Years Ago: 180,286.
- 2 Years Ago: 171,306.
- 1 Year Ago: 169,072.
- Today: 110,850.
- 3 Years Ago: 168,952.
- 2 Years Ago: 156,288.
- 1 Year Ago: 174,994.
- Today: 184,286.
- 3 Years Ago: 217,656.
- 2 Years Ago: 243,028.
- 1 Year Ago: 218,436.
- Today: 130,866.
- Both Groups = $11.46.
- Primary Categories Only = $6.44.
- Secondary Categories Only = $4.60.
June 02, 2026
The 15,000 Foot View
Yesterday we took a step back, looking at the business from a 30,000 foot view. We clearly observed that there was a new merchandise problem over the past two years.
I drilled down one level ... there are four categories that the Merchandising Team appear to have faith in.
Apparel Tops / Apparel Bottoms / Outside / Decorations were less than half the business three years ago ... today they're more than 60% of the business. Demand isn't necessarily stable, but it isn't bad. Existing items are stable, new items are down about $900,000 from two years ago.
Everything else?
Wow.
New items are down 45% from just two years ago. New item demand is down a whopping 70% from two years ago!!!!! In the past year, existing item demand is down a million dollars.
Tomorrow we'll apply this 15,000 foot level view of the business to customer response. It's obvious the Merchandising Team is doing something on purpose ... are customers impacted (hint - yes, they're impacted).
Click here for more information and file layouts.
June 01, 2026
The 30,000 Foot Level
It's common to run across a Marketing Team that is persecuted. "They don't know what they're doing!!" And yes, there are a ton of marketing teams that have absolutely no clue what they're doing ... that's life.
But there are marketing teams that are being persecuted ... they're blamed for problems that they have nothing to do with. Maybe the website has a 2.8% conversion rate and it was 3.3% last year ... "the marketing team is sending us terrible traffic". The Marketing Team blames Google & Facebook. Everybody is pointing at somebody.
Somebody should be pointing at the data. Here's the high level view of Beans ... at 30,000 feet, it is easy to see this isn't a marketing problem.
The business was at $27.4 million two years ago ... it is at $20.8 million today. Yes, there is a problem.
A simple cut of the data by new item sales vs. existing item sales shows us there is a merchandising problem.
- New Items: Decreased by $6.5 million.
- Existing Items: Decreased by $0.1 million.
May 31, 2026
Another Way To Depict The Challenge
If a business discontinues too many existing items (or fails to introduce sufficient quantities of new items), we should be able to see the problem manifest via sales declines. Right?
Here is a scatter plot of number of items sold each year (>= $1,000) on the x-axis ... the y-axis shows us annual sales per item.
The three outliers on the bottom left of the chart? Those represent the past three months when this brand also decided to not spend money acquiring new customers, compounding their own challenges.
Otherwise, there's a clear relationship. Every additional item offered yields an ever-decreasing rate of demand/sales.
Is this good or bad? It almost looks bad.
Let's perform a multiplication.
- "Beans" generates $9,800 per item when it sells 2,700 items = $26.5 million.
- "Beans" generates $12,750 per item when it sells 1,900 items = $24.2 million.
May 28, 2026
A Problem, Presented Visually
The following bar chart clearly illustrates a problem.
I depicted the number of styles (i.e. t-shirt, not white t-shirt, not XL white t-shirt, just the style level) with annual sales >= $1,000.
There are two dates that are problematic in the image.
- End of December 2023.
- End of December 2024.
May 27, 2026
Sloane Montgomery
I'll receive an email from one of you ... my first thought is "here comes a new project!".
More often than not, it's an email about a fictional character in a months-long case study. A character named Sloane Montgomery. She's the Chief Merchandising Officer at the fictional company being analyzed. She doesn't hold back. She says what she wants to say, nobody in Human Resources is going to restrain her.
It seems like some of you work with this individual.
Spend any amount of time on LinkedIn and you'll read dozens of hopelessly simple stories about how "brands" can improve. Read the comments ... professionals saying that something Bed Bath & Beyond did is a "cautionary tale". Sure it is.
Have you ever tried to change something that a company does, only to have an individual get in your way, and the individual is somebody you cannot control? The person doesn't report to you. The person is lawless, arrogant, craves power, has power.
The person has power.
Often, the person is not the CEO. I once worked with a Manager-level individual who could stop any initiative cold dead. He'd just say "we're not working on that" and that was it, nobody worked on it. When the person retired, progress happened.
I once worked with the President of a Merchandise Division. This person was not smart. This person was powerful. This person posted substandard results for years, but was a golden child, adored by Leadership. This person used up staff. This person stole ideas.
Most of you work at "brands" that know what to do, that know what must be done. I've yet to work with a catalog brand that knows the brand should have moved into the future twenty years ago but failed to do so ... and is now trapped by the customer who shops the catalog, the merchandise preferred by a customer who bought from catalogs in 1989, and the vendors who are dependent on the brand to keep spending money on catalogs. The employees know they need to change. And yet? Change doesn't happen. Because somebody like Sloane Montgomery has power, and won't let change happen.
Your job, of course, is to make change happen.
What does Sloane Montgomery (or your version of Sloane Montgomery) need to look good?
What is Sloane Montgomery afraid of?
What motivates Sloane Montgomery?
What motivates you?
Is there an intersection between what motivates Sloane Montgomery and what motivates you?
Is the person simply corrupt / corrupted? If so, it might be time for you to work somewhere else.
Does the person have morals? If so, there is a solution. It will be your job to identify the solution.
You won't find the solution on LinkedIn. Your problem is a local problem (a unique individual with unique personality traits) ... the stuff people share on LinkedIn are global problems with pithy solutions.
There's a reason many of you email me about this fictional individual.
Do you work with somebody comparable to Sloane Montgomery? If so, email me your story (kevinh@minethatdata.com) ... how did you get break down the barrier between you and the individual?
May 26, 2026
Beans: Email Communications
A discussion about Home merchandise. The discussion started after I previously shared the following "Class Of" table.
______________________________________________________
From: sloane.montgomery@beans.com
Sent: Monday, May 25, 2026 3:19 PM
To: Paisley Ingram <paisley.ingram@beans.com>
Subject: RE: FW: Rebuilding Plan
I can't believe I'm saying this ... maybe.
But I can't be the only one accountable here. If the solution is my team cranking out a bunch of new styles/skus and then the marketing team executes their standard ten batch-and-blast campaigns each week with a subject line that says "88 new items!!" paired with a Facebook post showing a new towel then I'd just as soon do nothing. That's not marketing, that's coloring by the numbers.
Our marketing team cannot keep pretending it is 2011. They're going to have to work as hard as my team works. I need your support on this one.
From: paisley.ingram@beans.com
Sent: Monday, May 25, 2026 2:47 PM
To: Sloane Montgomery <sloane.montgomery@beans.com>
Subject: RE: FW: Rebuilding Plan
Does he have a point that many of our Categories need to be "rebuilt"? It looks to me like he identified a credible problem.
From: sloane.montgomery@beans.com
Sent: Monday, May 25, 2026 2:33 PM
To: Paisley Ingram <paisley.imgram@beans.com>
Subject: RE: FW: Rebuilding Plan
Goober the Linguist used the word "dearth".
Mutton Head is kind of missing the point. This is a problem that can be solved by the Marketing Team. Prospects who never purchased from us don't know what is new and what is existing. They don't! If we only had three products, it would be up to Marketing to either find a market for the three products or they could do the hard work to create a market for the three products. Ideally they'd do both. It's not like Apple has tens of thousands of products, some would suggest they have a "dearth" of products. And yet, they're just fine.
It is wrong to suggest that the size of my assortment is a problem. Size matters, to a point.
From: Paisley Ingram <paisley.ingram@beans.com>
Sent: Monday, May 25, 2026 2:03 PM
To: Sloane.Montgomery@beans.com
Subject: FW: Rebuilding Plan
FYI.
Best,
Paisley
From: Kevin Hillstrom <kevinh@minethatdata.com>
Sent: Monday, May 25, 2026 1:15 PM
To: paisley.ingram@beans.com
Subject: Rebuilding Plan
We've talked about the importance of "rebuilding" your assortment. There are many categories where existing items were scaled back. Take Home for instance. Two years ago only $650,000 of $1,889,000 of new merchandise from the year prior was carried forward. The dearth of existing items results in the customer having too little to choose from. As new items were scaled back from 542 to 525 to 388 to 368 per year, too little demand was generated from new items, causing subsequent year existing merchandise to suffer. To have a great existing class of merchandise, you have to have plenty of new items the year(s) prior.
This is a cycle that is very hard to pull out of unless your Merchandising Team spends 2-3 years "rebuilding" the assortment. If I were in your shoes, I'd require a "rebuilding plan" from your Merchandising Team and a "Merchandise Awareness Plan" from your Marketing Team. Both teams would work together for the next three years to build a foundation for success. Your Marketing Team should be able to clearly articulate how they will create awareness for new items.
I'm happy to share examples from non-competitive clients if you are interested.
Thanks,
Kevin
May 25, 2026
"Categories" Project and Customer Advocate Mentoring
Ok, I've listened to your requests over the past year ... those requests resulted in two new project opportunities for all of you. Contact me (kevinh@minethatdata.com) for details.
You've read my Case Study series (plenty more coming from the world of "Beans", FYI). Those analytics are part of a new product offering called "Categories" ... where you will learn how your customers interact with Merchandise Categories/Departments. The analysis is designed to explain why your business is thriving / struggling, pointing out actionable insights for marketing and merchandising purposes. As you can see, if you are a prior client or are a blog subscriber (hint - that's you) there is a substantial cost incentive to work on this project.
The most popular request in 2026 has been a form of specialized "Mentoring" ... either weekly video conferences or weekly video conferences fused with ad-hoc analytics designed to help your Management Team navigate customer behavior in 2026. Here are your two "Mentoring" options ... I call this offering a "Customer Advocate Mentorship" opportunity. Think of it as me being a "Chief Customer Officer" of sorts.
Click here for data layouts as well as other project offerings for the remainder of 2026.
My July / August / September calendar is likely to fill up quickly after this announcement, so please reach out soon to reserve time for your project.
Thanks,
Kevin
May 21, 2026
It's Time!
- Data due by 6/15 (let me know if you need to see the file format I use to run the analysis).
- Payment due by 6/15 (I'll invoice you ASAP).
- Analysis completed by 6/30.
May 20, 2026
Case Study: A Marketing Plan
I ran a logistic regression equation to understand how likely multi-category buyers are to purchase again in the next year ... after controlling for purchase frequency and AOV ... analyzing twelve-month buyers. Here's the results of the Logistic Regression equation ... nerdy stuff you can ignore (though I do want to show my work).
The variable "multicat" has an Exp(B) of 1.361 ... this means that any customer that historically purchased from more than one category was 36% more likely to buy again in the future AFTER controlling for purchase frequency and AOV.
Separately, I was able to demonstrate that "multiple" is important ... whether the number is two categories or seven categories is much less important.
In a prior analysis, we demonstrated that customers are responsive for a few months following a first purchase, then are dormant, then come back at months 11/12/13 and again at 23/24/25 following a first purchase.
A marketing plan becomes obvious.
- Separate email streams for first-time buyers within three months of a first purchase, attempting to generate a quick second order (preferably) within a second category.
- Personalize the merchandise in email campaigns for first-time buyers to increase the probability of a second purchase (preferably) within a second category.
- When a prospect visits via search, the goal is to convert the prospect to a first order and hopefully cross-shop the customer into a second item and/or second category.
- When a customer reaches recency = 11/12/13/23/24/25, we ramp-up messaging and frequency.
- Personalize the home page and/or landing pages to show customers what they "need" to see to maximize their future value.
May 19, 2026
Case Study: All Paths Lead to Apparel Tops
Yesterday I talked about Entertainment customers shifting dollars over time to Apparel Tops.
By the time the customer orders for the third time, 34% is in Apparel Tops, just 9% in Entertainment.
Does this happen to all categories? In this case, yeah, it happens to all categories.
Here are first order categories and migration through a third order.
Apparel Bottoms: 47% / 21% (Bottoms vs Tops) in first order, 16% / 35% in third order.
Fashion: 34% / 21% (Fashion vs Tops) in first order, 9% / 33% in third order.
Home: 47% / 19% to 18% / 32%.
Jewelry: 40% / 17% to 6% / 35%.
Workplace: 27% / 21% to 3% / 36%.
Outside: 51% / 12% to 17% / 27%.
Having Fun: 37% / 20% to 15% / 32%.
Seasonal: 34% / 19% to 7% / 31%.
Decorations: 31% / 20% to 9% / 32%.
Two interesting things happening, of course. First, customers on a first order do buy from multiple categories, with Apparel Tops being right there at the top. Second, as the customer evolves, the customer spends more and more money with Apparel Tops, less and less money with the category of a first purchase.
As a marketer, tell me how you plan on using this information to make different decisions? If the answer is "I'm not changing anything", that means something.
Tomorrow, we'll explore an email exchange discussing "doing something different" given we have knowledge of customer behavior.
May 18, 2026
Case Study: Entry Points Into A Brand And Subsequent Migration
May 17, 2026
Case Study: Off-Season Purchases
We've learned that "Beans: The Internet's Only Variety Store" is heavily skewed to the November/December timeframe.
I've learned across nearly twenty years of consulting project that it's not healthy for a business to skew so heavily to Christmas. You want to offer products that customers purchase all-year. If there's a reason that subscription-centric brands are coveted by investors, there's the opposite reason that Nov/Dec businesses aren't coveted.
When I see a skewed business, I run a regression model to test the dollar contribution of Oct/Nov/Dec orders vs. orders generated during the rest of the year. For twelve-month buyers, spanning four years of purchase history and one year of "prediction", here's the simple regression equation.
- 1.257 + 0.079*($ Spent in Oct/Nov/Dec) + 0.095*($ Spent Jan-Sep).
May 14, 2026
Case Study: Simple Forecasts
- 9.4% from last year's Apparel Tops AND Other Category buyers.
- 6.4% from last year's Apparel Tops only customers.
- 4.7% from last year's Other Category buyers.
- 79.5% from New/Reactivated buyers this year.
- Category Yes, Other Yes = $5.98 in the next year.
- Category Yes, Other No = $4.58 in the next year.
- Category No, Other Yes = $1.44 in the next year.
May 13, 2026
Case Study: When The Crabby Merchant Is Right ... And Horribly Wrong At The Same Time
In the email dialogue shared yesterday, the Chief Merchandising Officer suggested that her customers had long repurchase cycles, therefore, it's not fair to measure future value across only twelve months.
For "Beans: The Internet's Only Variety Store", she is both correct and horribly wrong at the same time.
Her customers have long repurchase cycles. I use my Life Table Methodology to measure repurchase activity/cycles. Here is what the data looks like.
The green table shows incremental repurchase probabilities by month, as well as cumulative repurchase probabilities by month, for 1x buyers, 2x buyers, 3x buyers, and 4x buyers. The graph next to the green table maps out incremental repurchase probabilities for first time (1x) buyers. Look at that stupid-high spike at month = 12. What do you think that is?
- It is customers coming back and repurchasing at high rates exactly one year following a first purchase.
- New customers spend maybe $11 in year one, $7 in year two, and $4 in year three. In total, that's $22 of future demand ... it's nothing.
May 12, 2026
Case Study: An Email Correspondence
Maybe the most important finding in the past week is that "virtually nobody" is repurchasing when acquired by "Beans: The Internet's Only Variety Store!", regardless of merchandise category. Discovering the fact is one thing. Communicating the fact is quite another thing. And sometimes, the communication results in a reshaping of the message I convey.
This is why I send "tidbits" in my projects ... the back-and-forth interaction is useful and helps shape the outcome of the project.
From: Kevin Hillstrom <kevinh@minethatdata.com>
Sent: Monday, May 11, 2026 3:22 PM
To: Kevin Hillstrom <kevinh@minethatdata.com>
Subject: RE: FW: RE: FW: Repurchase Activity
Does Sloane have a point? Sort of. But the point doesn't change the fact that your customers have minimal future value.
If I measure repurchase activity over three years instead of one year, repurchase rates improve from maybe 18% to 33%. In that manner, Sloane is right.
Let's look at annual spend for customers acquired four years ago. Year1 = $10.68 in sales. Year2 = $6.92 in sales. Year3 = $4.08 in sales.
The story doesn't change ... the customers you acquire have virtually no future value when converting sales to profit. You have to generate a lot of profit on a first order to stay in business.
From: Paisley Ingram <paisley.ingram@beans.com>
Sent: Monday, May 11, 2026 2:56 PM
To: Kevin Hillstrom <kevinh@minethatdata.com>
Subject: FW: RE: FW: Repurchase Activity
Does Sloane have a point regarding a longer repurchase cycle?
From: sloane.montgomery@beans.com
Sent: Monday, May 11, 2026 10:39 AM
To: Paisley Ingram <paisley.ingram@beans.com>
Subject: RE: FW: Repurchase Activity
His experience is limited - those companies are too big to matter. $20,000? Highway robbery. I'll get you better answers from AI for minimal cost. Let's focus on the future, not an antiquated business model where some dweeb is paid a premium for something software can easily generate for free.
Ask Goober if customers have a longer repurchase cycle? I think he's looking at the issue the wrong way. Marketers are marketers for a reason, they're simpletons who are too narrow-minded to have the world-view you and I have to have to run a business.
From: paisley.ingram@beans.com
Sent: Monday, May 11, 2026 10:33 AM
To: Sloane Montgomery <sloane.montgomery@beans.com>
Subject: RE: FW: Repurchase Activity
He was part of the Management Teams at both Eddie Bauer and Nordstrom back in the day. We're paying him $20,000 for his work.
Also, we're breaking too many eggs. Sales are down 20% since your arrival. We can't survive if we go below $16 million in annual sales.
From: sloane.montgomery@beans.com
Sent: Monday, May 11, 2026 9:56 AM
To: Paisley Ingram <paisley.imgram@beans.com>
Subject: RE: FW: Repurchase Activity
First of all, who is this propeller-head you are working with? You can tell this Goober never worked for a real business, he's just out there wandering aimlessly in the Land of the Theoretical. How much are you paying for his "insights"?
Anybody with half a brain knows you don't measure lifetime value within twelve months. It's called Lifetime Value for a reason. You measure the Lifetime. That's what I'm working toward. And if we have to break a couple of eggs along the way, so be it.
From: Paisley Ingram <paisley.ingram@beans.com>
Sent: Monday, May 11, 2026 9:44 AM
To: Sloane.Montgomery@beans.com
Subject: FW: Repurchase Activity
FYI Sloane.
Best,
Paisley
From: Kevin Hillstrom <kevinh@minethatdata.com>
Sent: Monday, May 11, 2026 9:12 AM
To: paisley.ingram@beans.com
Subject: Repurchase Activity
Thanks,
Kevin
May 11, 2026
Case Study: Which Categories Bring In Valuable Customers?
I ran an analysis, measuring how much future value (demand/sales over the next twelve months) a customer will generate after being acquired within each merchandise category. If a category does a great job of bringing in new customers and those customers don't spend money in the future, well, we've got a problem.
Here's a summary table of what I learned.
Apparel Tops is a high-volume category, and fortunately it is a top-three category in terms of future value (NY Value).
Notice that most categories generate customers that buy from nearly two categories in the next year if the customer repurchases.
However ...
However, there is a problem in this table.
When a customer is acquired, regardless of category, the customer spends very little in the next year. Seasonal is worst ($6.40) ... Outside is best ($11.33).
In other words, there is very little customer loyalty associated with this brand. Newly acquired customers have a low chance of buying in the first year with the brand (between 14% and 18%), and if they buy the don't spend much ($46.00 to $63.00).
This is one of those moments when the Consultant realizes s/he is about to anger people. Yes, you can run a profitable business with a customer base that simply doesn't spend much, but it means everything regarding the p&l is dependent upon generating profit off of a first purchase.
Tomorrow, I'll share what the conversation looked like regarding exceptionally low future value metrics.
May 10, 2026
Brief Case Study Break: What Your Media Might Look Like In The Future
I'm writing this back on Sunday night.
Here are the two shows I just watched on YouTube.
Case Study: Dispelling Legends
At "Beans: The Internet's Only Variety Store" there is a legend ... that a broad assortment "holds the brand together".
It's been my opinion that Leadership is violating this "legend", assuming the legend is true.
So ... I performed a classic Factor Analysis to demonstrate categories that customers like to purchase from. If dots on the image below are close together, customers like to purchase from the categories "near each other" on the image. If categories are far apart, it means different customers prefer the categories.
Here's the image from the Factor Analysis.
There appear to be three reasons why customers buy from this brand.
- Apparel Tops: We know this is a high-volume category, and it is all by itself meaning that many customers ONLY purchase Apparel Tops.
- Home / Outside: There are clearly customers who view this brand as a Home / Outside brand. There's some bad news here ... some customers clearly come for Home / Outside, but a few weeks ago I showed you that Home decreased from $6.0 million to $2.9 million over four years. No bueno.
- Everything Else: There are customers who view this brand as an eclectic mix of categories (the right/middle side of the image).
May 07, 2026
Case Study: Customer Response to a Dying Category
We talked about Apparel Tops yesterday. We've previously mentioned that Fashion is a dying category, largely because the merchandising team appears to be killing the category. How does customer response change when a category is being killed off?
Similar to Apparel Tops, most demand comes from new/reactivated category buyers (80%). Again, the marketer has to know this, because the marketing plan has to include a lot of $$$ and attention in awareness (organic social) and search (product listing ads). If the marketer doesn't acknowledge this fact and act upon it, well, the marketer is equally culpable with the merchant at killing off the category.
This likely applies to your business as well. Most of your categories offer products that largely appeal to new/reactivated buyers and/or prospects. A marketing department that does not understand this dynamic is a marketing department that sub-optimizes the potential of the category/business.
Ok, what have the merchandising team done with their assortment-contraction initiative?
Rebuy Rates over time.
- 12-Month Fashion Buyers = 2.0% to 3.0% to 2.8% to 1.5%.
- All Other 12-Month Buyers = 1.6% to 2.5% to 2.2% to 1.2%.
- 36,236 to 54,438 to 52,418 to 27,308.
May 06, 2026
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).
- 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.
- 16% to 15% to 14% to 11% for existing buyers.
- 7% to 6% to 6% to 4% among all other twelve-month buyers.
- 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.
Oh Come On!
I receive my daily dose of propaganda from industry sources. Digging through twelve glowing articles about Macy's because they posted th...
-
It is time to find a few smart individuals in the world of e-mail analytics and data mining! And honestly, what follows is a dataset that y...
-
It's the story of 2015 among catalogers. "Our housefile performance is reasonable, but our co-op customer acquisition efforts ar...
-
I'm frequently asked for project endorsements. And for obvious reasons, clients want to keep their results as secret as possible. Howe...









