1. Podcasts
  2. Bulletproof Your CPG Brand
  3. 342. The Data Said, Delete It. Here's Why That Could Have Been an Expensive Mistake.
Bulletproof Your CPG Brand

7 Oct 2026 · 7m · 4 chapters

Episode artwork

342. The Data Said, Delete It. Here's Why That Could Have Been an Expensive Mistake.

In short

How “delete it” assortment recommendations based on item rankings can be an expensive mistake when the decision frame ignores shopper role, substitution, and incrementality; AI dashboards make it faster to get answers, but you must ensure the answer solves the right problem.

Guests

No guest is mentioned; host is Dan Lohman (Bulletproof Your CBG Brand Podcast).

Key claims

Item velocity/margin rankings can be correct yet incomplete; distinguish which items sell most vs which strengthen the category; evaluate source of volume, retention, and incrementality; ask what the retailer gains (profit, traffic/basket, competitive advantage) and what shoppers/retailer lose if the item disappears.

Notable examples

A trial-size checkout item ranked low by volume but drove category traffic and profitable growth; a major retailer reset recommending moving 17 items (11 the host’s) would have removed over half the business, so they rebuilt the category around shopper impact and secured four additional SKUs per store across 2,500 stores.

Written by AI. May contain mistakes.

Chapters

1:08

The Importance of Understanding Product Roles

Discusses how some products serve critical roles beyond their sales numbers.

“When I worked for a big brand, we sold one of the most recognizable brands in the world.”
2:39

Evaluating Assortment Decisions

Explains what to consider when making decisions about product assortment in retail.

“If I delete it, does the shopper simply move to another item I already sell?”
4:13

Case Study: Navigating Retail Recommendations

Shares a personal experience of challenging a retailer's recommendation based on consumer loyalty.

“That is one question that has changed a lot of decisions for me over the years.”
5:46

Actionable Retail Strategy Exercise

Presents a framework for testing retail decisions before implementation.

“A sophisticated category model can help.”
A man walking through an airport, asking his phone a question

Ask about this episode

Get the gist, explore an idea or ask about something said.

Claude

On Bulletproof Your CPG Brand, what are the key points of this episode?

Searching your listening

Transcript

Automatic transcript. May contain errors.

0:00The data said delete it. Here's why that could have been an inexpensive mistake. Years ago, a traditional category management report could have told the retailer to get rid of one of the lowest velocity. highest margin items we sold. The assortment math would have looked pretty reasonable. The item was small. It did not sell like the core items in the category. If you rank the category by volume and then draw a line after sales at roughly 80%, this item would easily fall below it. Delete it. Except that would have missed what the item was actually doing for the retailer. That is a category management problem.

0:34The item ranking can be right. Well, the decision frame is incomplete. That is the lesson I want to talk about today because we now have better data, faster dashboards, smarter algorithms, and AI tools that can give us the answers in seconds. That is useful. It also makes one skill more important, knowing when the answer is solving the wrong problem. I'm Dan Lohman. This is the Bulletproof Your CBG Brand Podcast, where every week I share an expensive retail lesson that you can learn before your brand has to pay for it. Now let's roll up our sleeves and get started. When I worked for a big brand, we sold one of the most recognizable brands in the world.

1:13One of our items was in a trial size package. You probably saw it at the checkout stand. It was in a little package you could throw in a backpack, a glove box, or suitcase. From a traditional item ranking perspective, it was not the hero skew. But when we looked more closely, it was doing something the basic ranking report did not show very well. It was an entry point into the category. It was an impulse purchase at the checkout stand. It carried an attractive margin. It reminded shoppers of the brand and the category. And our work showed that removing it could hurt the category because the item played an outsized role beyond its own sales.

1:48In fact, the item drove traffic and profitable growth in the category. That is the difference between asking which item sells the most and asking which items make the category stronger. Those are not the same question. The original report did not have to be wrong. The map did not have to be wrong. The frame was incomplete. That is the danger I want you to recognize. We tend to trust clean answers. The ranking report says to delete an item. A category says it needs a space for another item with better sales. The retailer says velocity is weak. AI gives you a recommendation with a very confident explanation that justifies deleting the item.

2:27None of those answers? Ask the shopper what matters most to them and if discontinuing the item might cause them to shop elsewhere. When I look at an assortment decision, I want to at least understand three things. First is source. Where does the item's volume come from? If I delete it, does the shopper simply move to another item I already sell? Do they move to a competitor? Do they leave the category? Do they leave the store altogether to purchase the item at a different retailer? Does the item bring a shopper into the category who otherwise would not have purchased? Second is retention. Does the item help the retailer keep a shopper, a trip, a basket, a need state, a premium customer from shopping their competition?

3:08A category entry point. Sometimes a small skew has strategic value because it keeps the shopper in the franchise, not because it wins the raw velocity ranking. Third is incrementality. What disappears if the item disappears? That is the question a normal ranking report can miss. If the item is mostly cannibalizing another skew, that is one answer. If the item creates an additional occasion, different shopper, an impulse purchase, a higher margin transaction, or a reason not to shop somewhere else, that is a very different answer. And then I widen the frame one more time. What does the retailer gain?

3:46Retailers generally care about three things that show up in a hundred different forms. They need a reasonable profit. They need more shopper traffic and a higher basket value. And they need a competitive advantage that gives shoppers a reason to choose their store instead of someone else's. So when you recommend adding, deleting, or expanding or shrinking an item, I want you to ask, does the decision make the retailer's business better or does it only make the item ranking report look cleaner? That is one question that has changed a lot of decisions for me over the years. And another major retailer reset, the accepted recommendation called for moving 17 items.

4:2311 of those items are ours. Across more than 2 ,500 stores, that would have taken out more than half of our business with that retailer. The recommendation from the category captain looked convincing, and every one of the retailer's divisions accepted the new item assortment. They were making room for the new brand. I could not reconcile it with the shopper loyalty, category role, and retailer performance I was seeing. Our sales were up and my division was outperforming the others. So I asked a different question. What would the retailer and the shoppers lose if those products disappeared? We rebuilt the category around the shopper.

5:00Substitution, retailer economics, category consequences. The 11 recommended SKUs were not removed and I effectively demonstrated to the retailer that the category captains new brand would pull profitable sales from the category while alienating some of their most loyal shoppers. The final outcome was four additional SKUs for our brand per store for all 2 ,500 stores. Same industry, same report, a very different decision. That's what I mean by retail judgment. It is not ignoring the report. It is not trusting your gut instead of the facts. It is recognizing what the obvious answer may be missing and then connecting the data, the shopper, the retailer, economics, and execution before you make an expensive decision.

5:43AI can help you do that faster. A strong analyst can help. A stronger broker can help. A sophisticated category model can help. Use all of it. Just do not confuse the recommendation with the decision. Here is the retail muscle rep I want you to try this week. This exercise could help you defend against competitive initiatives. Take one recommendation your team is considering or being confronted with right now. Add a skew, delete a skew, expand distribution, cut distribution, increase trade, raise price, whatever it is. Before you act, write down four questions. Number one, what is this decision recommending?

6:22Number two, what important context can it not see? Number three, what would the retailer or shopper lose if we follow it? Number four, what evidence would make us choose differently? The last question matters. If nothing could change your mind, you're not pressure testing the decision, you're defending it. The easier it becomes to get the answer, the more important it is to ask the right question. If your team has the report but still cannot agree on what the decision should be, that is exactly why I built the Retail Clarity Decision Tools. Bring me one retailer, one report, and one decision. We can pressure test what the report may be missing and build the capacity into your team.

7:03Go to RetailSolve.com forward slash decision tools. The spreadsheet is not the product. The decision is. I'm Dan Loman. Thank you for listening. Learn the expensive lesson before your brand has to pay for it. You can get the founder problem finder and the show notes at RetailSolve.com forward slash session 342.

From the publisher

342. A category management report can be mathematically correct and still point you toward the wrong decision.

In this episode of Bulletproof Your CPG Brand, I share what happened when one of the lowest-velocity, highest-margin items in an assortment looked like an obvious candidate for deletion. The ranking made sense. What it could not fully show was the job the item was doing for the shopper, retailer and category.

I break down three questions I use to pressure-test an assortment recommendation: SOURCE, RETENTION and INCREMENTALITY. Where does the volume go if the item disappears? What shopper, trip, basket or need state could the retailer lose? What actually disappears when the SKU disappears? 342 The Data Said Delete It. He…

I also share a second assortment decision where 11 of our SKUs were recommended for removal across more than 2,500 stores. After rebuilding the decision around shopper loyalty, substitution, retailer economics and category consequences, the 11 stayed and the final outcome became four additional SKUs per store. 342 The Data Said Delete It. He…

The lesson is not to ignore the data.

Use the data. Then understand what the data cannot see before you make the decision.

If your team has the reports but still cannot agree on what the decision should be, bring me one retailer, one report and one decision:

RetailSolved.com/DecisionTools

Show notes and resources: RetailSolved.com/session342

Chapters

00:00 Category Management: When the Math Is Right and the Decision Is Wrong

01:08 The Trial-Size SKU the Ranking Missed

02:02 When the Report Is Right but the Frame Is Incomplete

02:39 SOURCE: Where Does the Volume Go?

02:59 RETENTION: What Does the Retailer Keep?

03:18 INCREMENTALITY: What Disappears?

03:41 What Does the Retailer Gain?

04:18 17 Items Out. 11 Were Ours.

05:22 Retail Judgment: Recommendation vs. Decision

05:56 Four Questions to Pressure-Test the Decision

06:51 Retail Clarity Decision Tools

More from Bulletproof Your CPG Brand

All episodes