330. THE REPORT WAS 100% ACCURATE. THE DECISION COST $100,000.

0:00Daniel Lohman:Your dashboard may be your biggest blind spot. We were paying more than$100 ,000 for what was supposed to be a better source of truth. But the reporting we were producing for Wall Street did not match what other analysts were seeing. When I dug into the custom database, I found missing items, dramatically overstated items and understated items. The software was working, the data looked professional, and the answer was still misleading. That is the blind spot I want to talk about today. How the dashboard you rely on may be your bottleneck. Welcome to the Bulletproof Your CPG Brand Podcast. I'm Dan Lohman, founder of Retail Solved, and this is the show where we help entrepreneur CPG founders protect runway, improve execution, and compete smarter.

0:45Daniel Lohman:Today we're talking about why more data does not always create more clarity. This is part two of the CPG Decision Clarity Series. Follow Bulletproof Your CPG Brand now so you do not miss next week's episode. on how to start with the decision instead of the spreadsheet. Let's roll up our sleeves and get started. Most CBG brands do not have a reporting problem. They have plenty of reports. Sales reports, retailer portals, distributor reports, broker updates, trade, promotion recaps, deduction reports, syndicated data, shopper data, inventory reports, forecast, dashboards, and spreadsheets. That's a lot of reports.

1:24Daniel Lohman:Sometimes a business has so many reports that different departments can enter the same meeting with different versions of the truth. I see this all the time. Finance has one answer. Sales has another. Marketing sees something different. The broker has their own interpretation. The retail portal appears to be saying something else entirely. And after everyone reviews the data, the team is still debating what to do next. That is not necessarily a reporting problem. that is a decision problem. And when the margin for error gets smaller, decision quality matters more. Your report may be technically accurate.

2:00Daniel Lohman:Your dashboard may be functioning exactly as it was designed. Your software provider may be delivering exactly what the contract promised. And still the business can make the wrong decision. That is the uncomfortable truth. More data does not automatically create clarity. I want to be careful here. I am not criticizing data scientist. I am not criticizing business intelligence teams. I have worked with some exceptionally talented analysts. A strong finance and BI team is a real advantage, but CPG has complexities that do not always fit neatly inside a standard model. Retailer data is messy. Distributor data is messy.

2:39Daniel Lohman:Retailer portals are messy. Syndicated data has gaps. New products do not always appear where they should. A pack size change does not always get connected to the old pack so it does not report prior sales right away. Items get classified differently across different platforms and definitely not the way customers shop. Promotions do not always line up with the weeks shown on the report. Retailer definitions do not always match the brand definitions. The same product can serve multiple shopper need states while being placed inside only one database category. A tool may not understand that. A person who built the tool may not understand that.

3:17Daniel Lohman:And that is not because they're careless. It is because understanding the software is not the same as understanding how shopper, retailer, category, broker, distributor, and brand interact. That is where context matters. The$100 ,000 source of truth. Years ago, I was responsible for producing reporting that ultimately went to Wall Street. The company had invested more than$100 ,000 in a custom database. It was supposed to provide a cleaner and more precise view of the business. But something did not feel right. Our reporting did not align with what other analysts were providing. The numbers were not reconciling the way I expected.

3:54Daniel Lohman:So I started digging. Some products were dramatically understated. Some were overstated. Some items that appeared in the standard database were missing from our custom database. There were gaps that could materially change how someone interpreted the performance of our business. I ended up spending at least 20 hours a month, cleaning it up, reconciling the differences, and trying to understand what was really happening. Think about that. The company had paid more than$100 ,000 for something intended to create a better source of truth, and the tool still needed someone who understood the business well enough to recognize when the answer did not make sense.

4:30Daniel Lohman:That is the lesson. The software was not broken. The people were not necessarily doing bad work. The problem was that the business was trusting the output without enough operating context. I do not share that to brag about finding a database issue. I share that because these blind spots exist in every business. They exist in inexpensive spreadsheets. They exist inside retailer portals. They exist inside custom databases. They can even exist in the most respected platforms in the industry. I have found issues inside tools built by companies considered to be the gold standard. In one situation, correcting a problem they did not know existed helped uncover a new revenue source and a stronger point of differentiation for them.

5:14Daniel Lohman:The point is not that every platform is bad. The point is that no platform is perfect, and when the margin of error gets smaller, you cannot afford to confuse a polished report with a complete answer. This is especially true for smaller brands that don't have the luxury of purchasing a custom database, so they are forced to look at their portfolio in isolated segments, even when items are right next to each other on the shelf. I have a solution for that. That is why this episode is so important. Blind spot number one. The data is accurate but incomplete. This is one of the easiest problems to miss.

5:51Daniel Lohman:Every number shown in the report may be correct, but what is not shown? Perhaps an item is missing. Perhaps a retailer is excluded. Perhaps distributor shipments are being mistaken for consumer purchase. Perhaps promotional timing is not aligned correctly. Perhaps a product transition is splitting performance across two UPCs. Perhaps one report captures natural channel performance while another captures conventional retail differently. Perhaps the brand is celebrating sales growth without seeing the margin that was sacrificed to generate it. An accurate number can still tell an incomplete story.

6:25Daniel Lohman:and an incomplete story can lead to a bad decision. Blind spot number two, the data is organized around the database, not the shopper. This is one of the most important lessons I learned in category management. Databases are not always organized the way shoppers shop. With every brand I've worked with, products were often merchandised on the same shelf. A shopper could stand in front of the section and see a group of products serving a related need, but inside its syndicated data, those products can appear across multiple different categories. On a recent project, the items were merchandised together on the same shelf from the shopper point of view, but they were in 17 different categories in the standard database.

7:08Daniel Lohman:Let that sink in a moment. The database saw individual classifications. The shopper saw a solution. That distinction matters because when the data is organized around a generic category structure, it can hide the relationships that actually influence shopper choice. All the items within a category as the shopper sees it can interact. Sales from one item can boost or blunt another item when a product assortment is changed. That matters a lot when working with retailers. I built a robust custom tool that brought multiple data sources together and reorganized the information through a shopper first taxonomy.

7:44Daniel Lohman:I created retail ready views and a deeper analytical tools that allowed us to look at products, categories, and opportunities in a more useful way. A taxonomy is a data hierarchy, how the data is organized. Simply put, when a shopper stands in front of a category, what influences their decision? Shoppers see only the snack category, while the database break each section into their own distinct category. That work helped us identify a white space for a reimagined chip before launch. It helped us think about flavor, size, retailer fit, category placement, competitive framing, and shopper need states.

8:21Daniel Lohman:We were not simply asking, where do chips sell? We were asking, where does this product fit into the shopper's life? What is it competing against? And how can it create a new reason to buy? That is a very different question. And the quality of the question changes the quality of the tool. The question is not only whether the data is correct, the question is whether the data is organized in a way that reflects how the shopper actually makes a decision. Blind spot number three. Every department is optimized in isolation. This happens constantly. Sales is trying to grow revenue. Marketing is trying to increase awareness.

8:59Daniel Lohman:Finance is protecting margin. Operations is managing inventory. The broker is trying to close distribution gaps. The distributor is trying to manage movement. The retailer is trying to grow the category and protect productivity. Every group can be doing its job. Every group can hit its individual metric and the business can still become weaker. A promotion may grow sales but compress margin. A new retailer may expand distribution but create costly execution problems. A new SKU may increase the brand's total sales while stealing volume from another item. A marketing campaign may generate attention without creating repeat purchase.

9:37Daniel Lohman:A sales team may win more doors without securing the right items in those doors. A deduction team may recover money without fixing the process that created the deduction. That is what I meant by optimizing in isolation. The dashboard said one area improved, but the larger business did not. Retail does not operate in isolation. Shopper behavior influences velocity. Velocity influences retailer confidence. Retailer confidence influences distribution. Distribution influences inventory. Inventory influences promotional performance. Promotional performance influences margin. Poor execution creates deductions.

10:16Daniel Lohman:Deductions affect cash. Cash affects runway. Everything is connected. The reporting system needs to help the team see those connections. Blind spot number four. The report arrives after the decision has already been made. A lot of reports are rearview mirrors. They show what happened last month, last quarter, last promotion, last retailer review. That information matters. But the shopper already made their decision. The retailer already made their choice. The promotion already ran. The cash already left. The deduction already appeared. The inventory already went out of stock. The opportunity is not to eliminate historical reporting.

10:56Daniel Lohman:The opportunity is to use history to improve the next decision. That is where many dashboards fall short. They summarize, they display, they organize. But they do not help the team reroute. The best decision tools should help answer what's changing. Why is it changing? Where's the risk? Where's the opportunity? What do we need to do before the next event? Shipment, retailer meeting, or commitment? Reports show what happened. Retail Clarity shows what to ask next. This is why I built the Retail Clarity Framework. It is a way to move beyond one-dimensional reporting. There are four lenses. The first is the internal lens.

11:37Daniel Lohman:What happened? Sales, velocity, distribution, margin, trade spend deductions, inventory, retail execution. Those metrics tell us what the business did. They matter, but they are only the beginning. The second is the shopper lens. Why did it happen? Did the brand bring in new shoppers? Did repeat purchase improve? Did the shopper respond to the promotion or merely buy earlier than they would have? Did price sensitivity change? Did the product solve the same need the shopper originally hired it to solve? Did the shopper move to private label? Did they move to a different size, flavor, format, or channel?

12:15Daniel Lohman:The third is the category and competitive lens. What influenced the result? Did a competitor launch an item? Did the retailer change the shelf? Did another brand fund a promotion? Did the category definition miss a new source of competition? Did distribution move? Did the retailer change its pricing strategy? Did a new item take space or visibility? Did the brand assortment become inconsistent across retailers? The fourth is the predictive lens. What should happen next? Where should we invest? What should we stop funding? Which gaps matter most? Which retailer deserves attention? Which item needs support?

12:55Daniel Lohman:Which promotion window creates the best opportunity? Where is margin leaking? What can we prevent before the next short pay, out of stock, or missed commitment? That is the difference between a report and a decision tool. A report gives you information. A decision tool helps a team choose an action. Start with the decision, not the spreadsheet. One of the biggest mistakes teams make is beginning with the data. They open the file. They pull every available field. They create charts. They add filters. They build a beautiful dashboard. Then they ask, what should we do with it? I would reverse that.

13:33Daniel Lohman:Start with the decision. What question does the business need to answer? Not, what data do we have? Ask, what are we trying to understand? Are we trying to determine which promotions create profitable growth? Are we trying to find the most valuable distribution gaps? Are we trying to identify why one retailer is underperforming? Are we trying to understand where deductions originate? Are we trying to determine which items belong in the core assortment? Are we trying to see whether a new product created incremental demand or transferred volume from somewhere else? Are we trying to help the COO see what is driving profit and loss?

14:11Once the decision is clear, then determine what data is required. That sounds simple, but it changes everything. Five questions to ask before trusting your next report. Take one report your team reviews every week or every month. Ask five questions. First, what decision is this report supposed to make easier? If the answer is vague, the report may be informational rather than operational. Second, what is missing from the picture? Items, retailers, channels, timing, margin, promotion, shopper behavior, competitive activity, execution. Third, does the structure reflect how the shopper and category actually work?

14:53Or is the business simply accepting the category definitions that come with the database? Fourth, what other part of the business could change the interpretation? A sales increase can look different after trade spend. A distribution win can look different after velocity. A promotion can look different after incrementality. A deduction can look different after the root cause is identified. Fifth, what action should become clear after reviewing it? If everyone leaves the meeting with another request for analysis, the tool probably has not finished its job. A decision tool should reduce debate, not create more of it.

15:31That does not mean that everyone must agree immediately. A huge blind spot for brands is when each department and a manager wants their own different report. Same data, but from a different perspective. This is the fastest way to increase decision confusion, and this always sends teams down competing rabbit holes. Strong teams should challenge assumptions, but the tool should help the team focus the debate. It should make the important exceptions visible. It should expose gaps. It should show priorities. It should help the teams see where to look first, and it needs ownership. One of my favorite parts of building tools for brands is training the team to maintain them.

16:11I do not want the company dependent on me forever just to refresh a spreadsheet. I want the system to become part of how the team works. That means the logic must be clear. The taxonomy must be understandable. The process must be documented. The users need to know what the tool can answer and what it cannot. because software alone is never the full solution. A strong tool combines the right data, the right question, the right business context, the right owner, and the discipline to keep it current. Your reporting may be the bottleneck. Founders often assume the bottleneck is a lack of data. So they purchase another platform.

16:50They request another dashboard. They add another report. They ask the broker for another spreadsheet. But what if the report is making the business slower? What if the team is spending hours reconciling numbers instead of making decisions? What if every department is looking at its own version of performance? What if the reports explain the past but never help protect the next promotion, shipment, or retailer conversation? Then the bottleneck is not access to information. The bottleneck is decision clarity. When the margin for error gets smaller, clarity becomes your competitive advantage. Not because clarity guarantees perfection, it does not.

17:30But it gives the business a better chance to see risks sooner, to spot opportunities earlier, to stop funding what's not working, to protect margin, to reduce preventable leaks, and to focus scarce time and resources where they can create the most value. Doing this alone will give your brand a competitive edge because most brands don't have the discipline to bake this into their SOP. The practical next step. Here's what I want you to do next week. Choose one report your team relies on. It may be a sales report, a promotion recap, a broker update, a distributor report, a deduction tracker, a category view, an executive dashboard.

18:09Then ask, what decision is this supposed to help us make? Does it answer that question? What does the team still debate after reviewing it? What part of the business is missing? And what will we need to see earlier to make a better decision next time? The unresolved question is the opportunity. That may be where your next decision tool should begin. This also is the best way to identify, quantify, and plug decision leaks in your business. I recently created a decision tool page on RetailSolved. That's RetailSolved.com slash DecisionTools. You will see examples of tools designed to help CBG teams understand sales, distribution, promotion, deductions, retailer performance, and category opportunities more clearly.

18:54These are not generic dashboards. The goal is to turn messy retail information into a practical next decision. If your team has a report who relies on but still debates what to do next, send me the report or simply describe what you're trying to understand. Tell me the decision it does not answer. I will let you know honestly whether a custom decision tool makes sense. Again, that is RetailSolve.com slash DecisionTools. The spreadsheet is not the product, the decision is. To recap, your dashboard may be working exactly as designed, your data may be technically accurate, and the answer may still be incomplete.

19:34Do not assume that more data automatically creates more clarity. Start with the decision. Understand what is missing. Organize the information around the shopper, the category, and the way that business actually operates. Then build a tool that helps your team see what to do next. because when the margin for error gets smaller, clarity becomes your competitive advantage. Thanks for listening to the Bulletproof Your CPG Brand podcast. If this episode made you think differently about one of your reports, share it with someone on your team. Then ask one question. What decision does this report still not help us make?

20:11Connect with me on LinkedIn and message me. I read every one. I'll see you next time. You can get the show notes and the free download for this episode at RetailSoft.com slash Session330.