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.
Knowing how to calculate a number is important. Knowing what it means—and what to do with it—is where that work becomes useful.
Start with the decision you need to make
Before opening a spreadsheet, ask: What are we trying to understand, and what decision will this analysis support?
“Analyze category performance” is a broad assignment. “Understand why this retailer’s category is declining faster than the market” gives you somewhere to start.
That question helps you decide which comparisons matter, which data sources to use, and where to spend your time.
It also helps you recognize when you have enough information to recommend a next step. Otherwise, there is always another report to pull.
Give the numbers something to stand beside
Suppose a retailer’s category sales are down 8%. Is that a poor result?
You can’t tell from that number alone.
- If the market is down 12%, the retailer may be holding up relatively well.
- If the market is growing 3%, the retailer has a different problem to investigate.
- If sales dollars are growing but units are falling, price and product mix may be masking weaker volume.
The number hasn’t changed. The context has.
Useful comparisons might include market performance, the same period last year, a business target, another region, or a similar store group.
Choose the comparison that fits the question—and check that the time periods, products, and channels are comparable.
Work from the bigger picture into the detail
When something looks unusual, it’s tempting to jump straight to individual products. But a long list of declining items won’t necessarily explain the category’s performance.
Start with the overall result, then break it into meaningful parts. Which segments, brands, store groups, or channels account for the largest changes?
Look at both the rate of change and the size of the business. A small segment declining 30% may contribute less to the overall decline than a large segment declining 5%.
Then use the data available to investigate possible explanations: distribution changes, availability, pricing, promotion, assortment, or changes in shopper purchasing.
Let each answer guide the next question.
Separate what you know from what you suspect
This is an important part of developing insights. An observation, a possible explanation, and a recommendation are connected—but they serve different purposes.
Watch: Creating Insights
See how to move beyond reporting results and develop an insight that helps guide a category decision. This short excerpt comes from CMKG’s Completing a Basic Category Review module.
Use the data sources that fit the question
Different sources answer different questions. Retailer POS data can show where sales performance changed. Market data adds a competitive comparison. Consumer panel data can help explore household purchasing patterns. Inventory and availability records may reveal an execution issue.
You don’t need every source for every analysis. You do need to understand what your sources cover—and what they leave out.
If you only have shipment data, for example, be careful about treating it as a direct measure of shopper demand. Changes in customer ordering or inventory can affect shipments too.
Give the insight a practical next step
A useful insight helps someone decide, prioritize, investigate, or act.
In our example, recommending a category-wide price reduction would be premature. A more useful next step might be to review availability and price gaps in the largest declining segment before choosing an action.
Make that next step specific:
- What will we check or change?
- Who needs to be involved?
- What result would support our explanation?
- When will we review what happened?
Sometimes the right recommendation is a small test. Sometimes it is further investigation. Either can move the business forward when the purpose is clear.
Build the habit into everyday work
The next time you review a report, ask yourself three questions:
- What is happening? State the finding clearly.
- Why does it matter? Connect it to the business question and relevant context.
- What should happen next? Recommend an action, a test, or a focused investigation.
You don’t need a more complicated dashboard to start practicing this. Take one analysis you already use and work through those questions with your team.
That is how confidence builds: by connecting the numbers to the decisions people actually need to make.
Free download — Insight Writing Practice Worksheet
Ready to practice turning data into an insight? The free Insight Writing Practice Worksheet gives you three retail scenarios to work through using What → So What → Now What. Write your own insights first, then compare them with the sample answers to see how each one explains what changed, why it matters, and what to investigate next.
Download the Insight Writing Practice Worksheet
Turn your team’s data into practical insights
Turning data into insights is one of the biggest challenges across commercial teams. Category management, sales, marketing, and analytics teams may have the reports they need, yet still struggle to explain what the findings mean and what to recommend. Building that capability takes practice with the business questions and decisions they face every day.
CMKG’s Understand Category Performance learning track helps teams interpret performance, ask better questions, and identify opportunities. Through our Learn → Connect → Apply approach, we can create a custom learning experience using your own data, reports, and business examples. Pair online learning with facilitated virtual sessions where your team works through a relevant challenge, chooses meaningful comparisons, and separates observations from possible explanations before recommending a next step.
Explore our learning approach to see how we can tailor the learning to your team’s priorities and build a shared approach to turning data into action.
