Interpreting Index: Category Development Index and Fair Share Index

A dashboard shows a sales index of 110. Is that a good result? If the benchmark is last year’s sales, you’re up 10%. If it’s this year’s plan, you’re 10% ahead of plan. And if you’re looking at an index of out-of-stock rates, a 110 means your rate is 10% higher than the benchmark. That could be a reason to investigate.
Read More

The Insights Activator Series: Quick Wins for Smarter Analysis

Some of the best learning happens in small doses. You don't always need a full course to sharpen your analysis. Sometimes one good question, one worked example or one practical tool is enough to change how you look at your data on Monday morning.
Read More

From Data to Insights: Make Better Business Decisions

You’ve pulled the data, built the charts, and checked the numbers. But when someone asks, “So what should we do?” the answer still isn’t clear. I see this often. Teams put a lot of work into reporting results, but the connection between the analysis and the business decision gets lost.
Read More

Beyond 100: How to Calculate and Use CDI and Fair Share Index

Let's talk about indices! They're some of the most useful tools in business analysis, from category management and sales to finance and marketing, for retailers and suppliers alike, and in my experience, some of the most misunderstood. An index is simply a comparison of two numbers, where 100 means "the same": this year vs. last year, actual vs. target, your share here vs. your share everywhere.
Read More

Excel Skills for Commercial Teams: The Foundations, What's New, and How to Use Copilot

Copilot can now build formulas, PivotTables and even whole worksheets for you. That makes strong Excel foundations more important, not less. You still need to know what a good answer looks like.
Read More

The Secret Sauce for Better Strategy in Your Analysis

Good analysis isn't about finding interesting numbers. It's about finding the numbers that matter for what your business, and your retail partner, are trying to achieve.
Read More

Improving Your Business Acumen in Category Management

Business acumen is the ability to assess an external market and make effective decisions. You need the skills and tools to think more like an owner of the business and to understand, set and execute business strategy while being able to measure the effectiveness of their business strategy through financial performance – skills that I think many of us can improve upon. Think about what you’re responsible for in your job. How often do you think about or consider the impact of your decisions on other areas in your company? For example product supply? Or finance? Or your implementation team?
Read More

5 Ways to Maximize ROI on Category Assessments

We spend a lot of time analyzing our business, but we need to ask whether we are looking at the entire picture or just scratching the surface. Are you looking for the big opportunities? Developing next year’s category plan? Identifying weaknesses when business is soft? Determining the next big innovation? Evaluating the post results from an initiative? Or analyzing a specific tactic? Identifying the question will help you achieve your goals.
Read More

Why Category Management Needs More Critical Thinkers

We’re all searching for better ways to tap into Shopper insights data to address the “why” in category management — why aren’t we finding it?
Read More

Category Management with Limited Data: Start with What You Have

“We don’t have the data to do category management.” If that sounds familiar, I’d start with a question. What decision are you trying to make—and what information do you already have that could help? You may not have item-level Retailer sales, consumer panel data, or a complete view of the market. You may have shipment reports, a few customer scorecards, store observations, and people who know the business well. That isn’t the same as having a full category data set. But it doesn’t mean there’s nothing useful you can do. The opportunity is to work with what you have, understand what it leaves out, and make recommendations that fit the evidence. Waiting for perfect data won’t build that capability for your team. What decision are you trying to make? “Understand the category” can turn into a long list of reports you wish you had. A more specific question helps you decide where to start. Are you trying to understand why a customer is ordering less? Whether an item deserves a wider listing? Where the assortment may be missing a Shopper need? Each question needs different information. Before asking for another data source, write down the decision, what you already know, and what you would need to check. For example, declining shipments might give a supplier a reason to investigate a customer’s business. They don’t prove that Shoppers are buying less. The customer may have changed its ordering pattern, reduced inventory, or bought ahead in an earlier period. That distinction matters. It changes both your explanation and the conversation you should have next. Know what your data can tell you A useful starting point is to sort your information by the question it can help answer—not just by the name of the report. Shipment and order data: What did we sell to the customer, when, and in what quantities? Check returns, timing, and inventory changes before treating that as Shopper demand. Retailer sales and scorecards: What happened in the business covered by the report? Confirm the measures, periods, stores, and channels included. Store and online observations: What can Shoppers find, compare, and buy at the locations or pages you checked? A store visit can reveal a question worth investigating, but it doesn’t establish how common the issue is. Customer discussions and internal knowledge: What do people closer to the work know about changes in listings, promotions, availability, or execution? Use that knowledge to develop explanations you can check. Market or Shopper research, where available: What wider context does it add? Make sure its category definitions, coverage, and timing fit your question. Then ask: Where is the gap that could change our decision? You don’t need to fill every gap at once. If you’re investigating an availability issue, confirming whether stock reached the shelf may be more useful than purchasing a broad market report. Match the recommendation to the evidence Imagine a supplier sees lower shipments for a range over the last quarter. The team also visits a few stores and notices empty shelf positions for two items. Would you recommend cutting the range? I wouldn’t start there. The shipment decline and store observations give you reasons to ask questions, not enough evidence for a broad assortment change. A more useful recommendation might be to review customer inventory, confirm the current listings, and check availability across a defined group of stores. If the customer can share sales for those items, you can compare what sold with what was ordered and delivered. You’ve moved the discussion forward without pretending you know more than you do. When presenting your findings, separate three things: What we know. State the finding and the period or locations it covers. What might explain it. Identify possible explanations without presenting them as established causes. What we recommend next. Propose a focused check, a small test, or an action supported by the evidence. Limited data should influence the scope and confidence of your recommendation. It doesn’t mean you have to abandon a fact-based approach. Build capability alongside your data It can be helpful to think about category management as a continuum. As access to information, team skills, resources, and collaboration develops, the questions you can answer may become more detailed. Free download: See which stage you're at today, and what it would take to move up, with The Commercial Capability Continuum. But I’d be careful about putting an entire organization into one tier based on its data access. A team may have detailed sales data for one customer and very little for another. It may have strong analytical skills but limited time, or useful information that different functions haven’t connected. More data, more capability, and more collaboration don’t always arrive together. Ask your team: Can we interpret the measures and comparisons we already use? Do we understand the Retailer’s strategy and the Shopper needs behind the category? Are we connecting information across sales, category management, marketing, finance, and supply chain? Can we explain what our recommendation could mean for sales, profit, and execution? A new dashboard won’t answer those questions for you. Neither will AI. Tools can help organize information and explore possible explanations, but they can’t make missing evidence appear. Your team still needs to check the inputs and judge what the output supports. Before investing in more data, identify what it would help you decide and whether your team is ready to use it. Sometimes the priority is a new source. Sometimes it’s learning how to get more value from the information already available. Take the next step with your team At your next category discussion, bring one business question and the information you have today. Work through what it tells you, what it doesn’t, and which gap matters most to the decision. Agree on a next step, who will own it, and when you’ll review what you learned. That is category management work. It may be a more focused analysis than a team with access to a full range of data could complete, but it can still help you ask better questions and make a more informed recommendation. Through CMKG’s Learn → Connect → Apply approach, we can create learning using your own data, reports, and business examples. Pair online learning with a virtual session focused on interpreting the information you have, identifying its limitations, and turning findings into practical next steps. Explore Our Learning Approach to see how we can support your objectives, whether you’re developing your own analytical skills, working with a small team, or building a shared approach across your commercial organization. Happy learning! Sue
Read More