
The Category Insight-to-Action Micro-Workbook
A Guided System for Turning Raw Retail Data Into Clear Insights, Stronger Recommendations, and Retailer-Ready Commercial Actions
Overview
Category teams often have no shortage of data. The real challenge is converting that data into a recommendation someone can confidently act on.
The Category Insight-to-Action Micro-Workbook gives you a practical framework for moving from observation to explanation, from explanation to implication, and from implication to action.
Use it for:
- Category reviews
- Retailer presentations
- Joint business planning
- Range reviews
- Assortment resets
- Pricing reviews
- Promotional analysis
- Shopper diagnostics
- Space recommendations
- Innovation strategy
- Weekly performance reviews
The core discipline is simple:
Do not stop at what happened.
Every meaningful category insight should answer four questions:
- What happened?
- Why did it happen?
- Why does it matter?
- What should we do next?
SECTION 1 — THE I.N.S.I.G.H.T. FRAMEWORK
Use this framework whenever you need to convert data into action.
I — IDENTIFY THE SIGNAL
What changed?
Examples:
- Dollar sales increased 8%.
- Units declined 3%.
- Penetration fell 1.4 points.
- Premium share increased.
- Promotional sales rose.
- Hero SKU OOS increased.
N — NAME THE DRIVER
What is most likely causing the change?
Possible drivers:
- Price
- Volume
- Mix
- Distribution
- Availability
- Promotion
- Shopper recruitment
- Frequency
- Competition
- Seasonality
- Range change
S — SEPARATE FACT FROM HYPOTHESIS
Ask:
What do we know?
versus:
What do we believe?
Example:
Fact
Dollar sales grew 8%, while units fell 3%.
Hypothesis
Higher pricing may be suppressing unit demand.
Do not present the second statement as proven unless the evidence supports it.
I — INTERPRET THE COMMERCIAL MEANING
Why should the retailer care?
Potential implications:
- Lost sales
- Lost margin
- Share erosion
- Shopper defection
- Low productivity
- Excess complexity
- Missed premium opportunity
- Weak recruitment
- Promotional dependency
G — GAUGE THE SIZE OF THE OPPORTUNITY
Estimate:
- Sales upside
- Margin upside
- Share gain
- Recoverable OOS sales
- Distribution opportunity
- Space productivity upside
H — HIGHLIGHT THE ACTION
What specifically should change?
Avoid:
“Focus on premium.”
Use:
“Reallocate two facings from duplicated mainstream SKUs into the highest-velocity premium products.”
T — TRACK SUCCESS
Which KPI tells us whether the recommendation worked?
Examples:
- Sales growth
- Unit growth
- Penetration
- Rate of sale
- Margin
- Availability
- Conversion
- Promo incrementality
SECTION 2 — THE FOUR-LINE INSIGHT BUILDER
Use this repeatedly throughout the workbook.
WHAT HAPPENED?
Write the observation.
WHY?
Write the strongest evidence-backed explanation.
SO WHAT?
Write why it matters commercially.
NOW WHAT?
Write the action.
EXAMPLE
What Happened?
Premium value sales increased 17%, versus category growth of 6%.
Why?
Premium growth is being driven by stronger shopper trade-up and increased distribution.
So What?
The segment is becoming disproportionately important to future category value.
Now What?
Increase premium assortment and shelf support, funded by declining mainstream duplication.
SECTION 3 — OBSERVATION VS. INSIGHT
One of the most common category-management mistakes is presenting observations as insights.
Observation
“Segment A grew 14%.”
That tells us what happened.
It does not tell us why it matters.
Better Insight
“Segment A grew 14%, more than twice the total category rate, making it one of the largest contributors to incremental category growth.”
Stronger Actionable Insight
“Segment A is growing more than twice as fast as the total category but remains underrepresented in assortment and space, creating an opportunity to reallocate low-productivity shelf capacity into one of the category’s strongest growth engines.”
That is an insight.
SECTION 4 — THE DATA-TO-ACTION LADDER
For every major finding, move through five levels.
LEVEL 1 — DATA
What number do you see?
LEVEL 2 — OBSERVATION
What changed?
LEVEL 3 — INTERPRETATION
What does the pattern suggest?
LEVEL 4 — IMPLICATION
Why does it matter?
LEVEL 5 — ACTION
What should change?
SECTION 5 — THE “SO WHAT?” TEST
After every chart, ask:
Why should the retailer care?
If you cannot answer that clearly, the chart may not belong in the main presentation.
Use these prompts:
- Does this affect sales?
- Does this affect margin?
- Does this affect share?
- Does this affect shopper value?
- Does this affect productivity?
- Does this reveal a risk?
- Does this reveal an opportunity?
- Does this change a decision?
If the answer is no to all eight, the finding may be interesting but not commercially important.
SECTION 6 — SALES INSIGHT WORKSHEET
Raw Data
Dollar Sales: $________
Growth: ______%
Unit Growth: ______%
ASP Change: ______%
Market Growth: ______%
Share Change: ______ pts
WHAT HAPPENED?
Complete:
Category dollar sales are ______________________________.
WHY?
Possible drivers:
□ Price
□ Volume
□ Mix
□ Distribution
□ Promotion
□ Premiumization
□ Availability
Primary driver:
SO WHAT?
Complete:
This matters because ________________________________________.
NOW WHAT?
Complete:
We recommend ________________________________________.
EXAMPLE
Data
Dollar sales +10%
Units -4%
ASP +15%
Observation
Dollar growth remains strong.
Insight
The category is growing in value despite declining physical demand.
Implication
Headline performance may be masking shopper resistance to higher prices.
Action
Review penetration, price elasticity, entry price points, and competitive pricing before further price increases.
SECTION 7 — MARKET SHARE INSIGHT WORKSHEET
Raw Data
Retailer Growth: ______%
Market Growth: ______%
Current Share: ______%
Prior Share: ______%
Share Change: ______ pts
Interpretation
Retailer growing faster than market?
□ Yes
□ No
Share gaining?
□ Yes
□ No
Underperforming specific segments?
□ Yes
□ No
Insight Builder
What Happened?
Why?
So What?
Now What?
EXAMPLE
The retailer grew 4% while the market grew 9%, resulting in a 1.2-point share decline. Underperformance is concentrated within convenience and premium, the two fastest-growing areas of the market. This suggests the retailer is participating in category growth but not capturing its fair share of future demand. We recommend strengthening assortment, distribution, and visibility within those segments.
SECTION 8 — SHOPPER INSIGHT WORKSHEET
Shopper Metrics
Penetration: ______%
Change: ______ pts
Frequency: ______
Change: ______%
Spend per Trip: $________
Change: ______%
Units per Trip: ______
Change: ______%
SHOPPER DIAGNOSTIC
Penetration Down + Frequency Up
Possible interpretation:
The category is relying on fewer, heavier buyers.
Penetration Up + Frequency Down
Possible interpretation:
Recruitment is strong but repeat/usage may be weak.
Penetration Flat + Spend Up
Possible interpretation:
Value growth is coming from existing buyers.
Penetration Up + Frequency Up
Possible interpretation:
Broad-based shopper growth.
WORKBOOK
What Is the Main Shopper Signal?
What May Be Causing It?
What Is the Risk?
What Is the Opportunity?
Recommended Action
SECTION 9 — PENETRATION LOSS WORKSHEET
If penetration is declining, investigate:
□ Price barrier
□ Weak entry proposition
□ Lost relevance
□ Competitive switching
□ Distribution gaps
□ Missing formats
□ Poor availability
□ Changing demographics
□ Reduced occasion relevance
□ Over-complexity
Strongest Hypothesis
Evidence Supporting It
Evidence Against It
Additional Data Required
Recommended Test
SECTION 10 — FREQUENCY GROWTH WORKSHEET
If penetration is stable but frequency is weak, ask:
What new reason could shoppers have to purchase one additional time?
Potential occasions:
- Breakfast
- Lunch
- Dinner
- Snacking
- Entertaining
- Gifting
- Travel
- On-the-go
- Seasonal
- Health reset
- Convenience
Current Core Occasion
Potential New Occasion
Shopper Need
Required Product/Pack
Merchandising Idea
KPI
SECTION 11 — ASSORTMENT INSIGHT WORKSHEET
Range Metrics
Total SKUs: ______
SKUs generating 80% of sales: ______
Bottom 20% sales contribution: ______%
Average ROS: ______
Duplicated SKUs identified: ______
Range gaps identified: ______
Key Questions
Is the range too broad?
Is the range too narrow?
Where is duplication concentrated?
Which needs are missing?
Which growth segments are underrepresented?
INSIGHT BUILDER
What Happened?
Why?
So What?
Now What?
EXAMPLE
The assortment expanded by 12% while category sales remained broadly flat. Most incremental SKUs sit in already crowded mainstream need states, while premium and convenience remain underrepresented. This suggests additional range complexity has not translated into meaningful incremental shopper choice. We recommend rationalizing low-velocity duplication and reinvesting the space into underdeveloped growth segments.
SECTION 12 — SKU PRODUCTIVITY WORKSHEET
For each important SKU:
SKU
Sales
$________
Rate of Sale
Margin
________%
Distribution
________%
Growth
________%
Shopper Role
Incrementality
High / Medium / Low
Likely Substitute
Recommended Action
Protect / Expand / Maintain / Test / Rationalize
SECTION 13 — PRICE INSIGHT WORKSHEET
Price Metrics
Opening Price Point: $________
Mainstream Range: $________ to $________
Premium Entry: $________
Price Index: ______
ASP Change: ______%
Unit Change: ______%
Questions
Is the entry price competitive?
Is there a missing price tier?
Can shoppers trade up logically?
Is premium clearly differentiated?
Is price suppressing units?
ACTIONABLE PRICE INSIGHT TEMPLATE
The category’s current price architecture shows [GAP / ISSUE], which may be affecting [SHOPPER BEHAVIOR]. We recommend [ACTION] to improve [ACCESS / TRADE-UP / VALUE PERCEPTION], measured through [KPI].
SECTION 14 — PROMOTION INSIGHT WORKSHEET
Promotion Metrics
Promo Sales %: ______%
Base Sales Growth: ______%
Promo Uplift: ______%
Estimated Incrementality: ______%
Margin Impact: $________
Cannibalization: ______%
Ask
Did the promotion create incremental demand?
Did it simply shift timing?
Did it cannibalize other SKUs?
Did margin improve?
EXAMPLE
Promotional sales increased 22%, but base sales declined 8% and estimated incrementality remains low. This suggests promotional activity may be shifting purchase timing rather than building category demand. We recommend reducing event frequency and reallocating investment toward fewer, higher-incrementality recruitment and basket-building events.
SECTION 15 — SPACE INSIGHT WORKSHEET
Space vs. Sales
| Segment | Sales Share | Shelf Share | Gap |
| [A] | ___% | ___% | ___ |
| [B] | ___% | ___% | ___ |
| [C] | ___% | ___% | ___ |
Questions
Which segment is under-spaced?
Which segment is over-spaced?
Where is growth strongest?
What space could be reallocated?
ACTION TEMPLATE
[SEGMENT] contributes [X]% of category sales and [Y]% of growth but receives only [Z]% of shelf space. We recommend reallocating [SPACE] from [LOWER-PRODUCTIVITY AREA] to better align shelf allocation with current shopper demand.
SECTION 16 — AVAILABILITY INSIGHT WORKSHEET
Metrics
Overall OOS: ______%
Hero SKU OOS: ______%
Estimated Lost Sales: $________
Fill Rate: ______%
Diagnostic
Is the issue supply?
□ Yes
□ No
Forecasting?
□ Yes
□ No
Facings?
□ Yes
□ No
Replenishment?
□ Yes
□ No
Promotional spike?
□ Yes
□ No
INSIGHT TEMPLATE
Shopper demand exists, but availability is constraining conversion on [SKU / SEGMENT]. With an OOS rate of [X]%, the retailer may be losing approximately [RANGE] in sales. We recommend [ACTION], measured through [OSA / OOS / SALES].
SECTION 17 — MARGIN INSIGHT WORKSHEET
Metrics
Sales Growth: ______%
Margin %: ______%
Margin Change: ______ pts
Margin Dollars: $________
Promo Margin: ______%
Premium Mix: ______%
Key Question
Is growth creating value—or destroying value?
If Sales Up + Margin Down
Investigate:
- Promotion
- Trade-down
- Cost inflation
- Poor mix
- Markdowns
- Low-margin volume growth
ACTIONABLE INSIGHT
Category sales are growing [X]%, but margin is declining [Y], indicating growth quality is weakening. The biggest pressure comes from [DRIVER]. We recommend improving mix through [ACTION] rather than relying solely on additional volume.
SECTION 18 — COMPETITIVE INSIGHT WORKSHEET
Compare
Range
Retailer: ______
Competitor: ______
Price
Retailer: ______
Competitor: ______
Premium
Retailer: ______
Competitor: ______
Promotion
Retailer: ______
Competitor: ______
Availability
Retailer: ______
Competitor: ______
Most Important Competitive Gap
Does It Matter to Shoppers?
Commercial Impact
Recommended Response
SECTION 19 — DIGITAL INSIGHT WORKSHEET
Metrics
Online Growth: ______%
Digital Share: ______%
Conversion: ______%
Search-to-Click: ______%
Online Availability: ______%
Questions
Are shoppers finding the products?
Are they clicking?
Are they converting?
Are products in stock?
DIGITAL ACTION TEMPLATE
Digital category traffic is [STRONG / WEAK], but conversion is constrained by [SEARCH / CONTENT / PRICE / AVAILABILITY]. We recommend [ACTION] and will measure success through [KPI].
SECTION 20 — INNOVATION INSIGHT WORKSHEET
Metrics
Trial: ______%
Repeat: ______%
ROS: ______
Distribution: ______%
Incrementality: ______%
Cannibalization: ______%
Ask
Is trial strong?
Is repeat strong?
Is demand incremental?
Is the product underdistributed?
EXAMPLE
Innovation trial is strong, but repeat is materially below the category benchmark. This suggests launch support is generating curiosity but not yet sustainable demand. Before expanding distribution, we recommend identifying the repeat barrier and testing improvements to proposition, price, or communication.
SECTION 21 — THE ROOT-CAUSE TREE
When a KPI is weak, do not jump directly to a solution.
Start with possible causes.
CATEGORY SALES DECLINE
Possible causes:
Shopper
- Fewer buyers
- Lower frequency
- Lower spend
- Lost relevance
Product
- Weak assortment
- Missing innovation
- Duplication
- Poor quality perception
Price
- Higher prices
- Weak value
- Poor architecture
Promotion
- Less support
- Poor mechanics
- Reduced incrementality
Execution
- Distribution
- OOS
- Shelf visibility
- Digital discoverability
Competition
- Better range
- Better price
- Better innovation
- Stronger promotion
ROOT-CAUSE WORKSHEET
Problem
Possible Cause #1
Evidence
Possible Cause #2
Evidence
Possible Cause #3
Evidence
Most Likely Cause
SECTION 22 — FACT / HYPOTHESIS / PROOF WORKSHEET
Use this to prevent overclaiming.
| Statement | Fact or Hypothesis? | Evidence | Confidence |
| [___] | [___] | [___] | Low / Med / High |
| [___] | [___] | [___] | Low / Med / High |
| [___] | [___] | [___] | Low / Med / High |
HIGH-CONFIDENCE LANGUAGE
Use:
“The data shows…”
“The evidence indicates…”
“This confirms…”
MEDIUM-CONFIDENCE LANGUAGE
Use:
“The pattern suggests…”
“A likely explanation is…”
“This may indicate…”
LOW-CONFIDENCE LANGUAGE
Use:
“One hypothesis is…”
“This requires validation…”
“We do not yet have enough evidence to conclude…”
SECTION 23 — THE INSIGHT STRENGTH SCORE
Score every proposed insight from 1–5.
Evidence Strength
___ / 5
Commercial Relevance
___ / 5
Shopper Relevance
___ / 5
Actionability
___ / 5
Quantification
___ / 5
Clarity
___ / 5
Objectivity
___ / 5
Total
___ / 35
30–35
Presentation-ready.
24–29
Strong but can be sharpened.
18–23
Needs more evidence or specificity.
Below 18
Probably an observation, not a strong insight.
SECTION 24 — THE COMMERCIAL PRIZE WORKSHEET
Every major opportunity should be quantified where possible.
Opportunity
Current Sales Base
$________
Current Performance Gap
Conservative Upside
$________
Base Upside
$________
Upside Scenario
$________
Key Assumptions
SECTION 25 — DISTRIBUTION PRIZE CALCULATOR
Current Stores
Target Stores
Additional Stores
Weekly ROS
$________
Weeks
Gross Sales Opportunity
Additional Stores × ROS × Weeks
$________
Conservative Adjustment
________%
Adjusted Opportunity
$________
SECTION 26 — SHARE GAIN PRIZE CALCULATOR
Total Market Size
$________
Current Retailer Share
________%
Target Share
________%
Share Gain
________ pts
Potential Sales Prize
$________
SECTION 27 — OOS RECOVERY CALCULATOR
Expected Weekly Sales
$________
OOS Loss %
________%
Number of Stores
Weeks
Potential Recoverable Sales
$________
SECTION 28 — RECOMMENDATION BUILDER
A useful recommendation should answer six questions.
- WHAT SHOULD CHANGE?
- WHERE?
- HOW MUCH?
- WHY?
- WHAT IS THE PRIZE?
- HOW WILL SUCCESS BE MEASURED?
WEAK VS. STRONG RECOMMENDATIONS
Weak
“Improve premium.”
Strong
“Increase premium shelf allocation by four percentage points, funded by low-productivity mainstream duplication, and measure success through premium mix, sales per facing, and total category margin.”
Weak
“Reduce promotion.”
Strong
“Reduce low-incrementality promotional events by two per quarter and redirect funding toward recruitment and basket-building mechanics.”
Weak
“Improve availability.”
Strong
“Increase hero SKU facings and safety stock in high-volume stores to reduce OOS from 8% to below 4%.”
SECTION 29 — THE INSIGHT-TO-ACTION TABLE
Use this as your master working sheet.
| Data | Observation | Driver | So What? | Action | KPI |
| [___] | [___] | [___] | [___] | [___] | [___] |
| [___] | [___] | [___] | [___] | [___] | [___] |
| [___] | [___] | [___] | [___] | [___] | [___] |
| [___] | [___] | [___] | [___] | [___] | [___] |
SECTION 30 — THE PRIORITIZATION FILTER
Once you have multiple insights, score them.
| Criteria | Score 1–5 |
| Commercial Upside | ___ |
| Shopper Benefit | ___ |
| Margin Impact | ___ |
| Strategic Fit | ___ |
| Ease of Execution | ___ |
| Speed to Impact | ___ |
| Evidence Strength | ___ |
Total
___ / 35
PRIORITY GUIDE
29–35
Act now.
23–28
High priority.
17–22
Test or develop.
Below 17
Monitor.
SECTION 31 — PROTECT / FIX / GROW
Reduce the final analysis to three actions.
PROTECT
What is already working?
FIX
What is leaking value?
GROW
Where is the next opportunity?
SECTION 32 — THE ONE-NUMBER, ONE-INSIGHT, ONE-ACTION RULE
For every major recommendation, choose:
ONE NUMBER
ONE INSIGHT
ONE ACTION
This makes retailer presentations dramatically clearer.
EXAMPLE
Number
Premium contributes 31% of total category growth.
Insight
Premium is becoming disproportionately important to future value growth.
Action
Reallocate shelf space from declining mainstream duplication into top-performing premium SKUs.
SECTION 33 — THE THREE-LAYER EVIDENCE STACK
The strongest insights combine three forms of evidence.
MARKET EVIDENCE
What is happening across the market?
RETAILER EVIDENCE
What is happening within the retailer?
SHOPPER EVIDENCE
What explains the behavior?
SYNTHESIS
Because all three indicate ________________________________________, we recommend ________________________________________.
SECTION 34 — THE CONTRADICTION CHECK
Good analysis does not ignore conflicting evidence.
Evidence Supporting the Insight
Evidence That Contradicts It
What Could Explain the Contradiction?
Does the Recommendation Change?
SECTION 35 — THE ALTERNATIVE EXPLANATION TEST
Before finalizing an insight, ask:
What are three other reasons this could be happening?
Alternative #1
Alternative #2
Alternative #3
What Evidence Would Differentiate Them?
This protects you from locking onto the first plausible explanation.
SECTION 36 — THE RETAILER VALUE TEST
Before recommending an action, score:
Total Category Sales Benefit
___ / 5
Shopper Benefit
___ / 5
Margin Benefit
___ / 5
Productivity Benefit
___ / 5
Strategic Fit
___ / 5
Supplier Neutrality
___ / 5
Total
___ / 30
Ask:
Would I still recommend this if my own brand did not benefit?
If not, strengthen the category case.
SECTION 37 — TURNING INSIGHTS INTO SLIDE HEADLINES
Avoid descriptive headings.
Weak
Shopper Performance
Strong
The category is losing buyers despite higher spend from remaining households.
Weak
Premium
Strong
Premium is generating disproportionate category growth but remains underrepresented in the range.
Weak
Promotions
Strong
Increasing promotional dependence is failing to strengthen underlying base demand.
Weak
Distribution
Strong
High-velocity products remain underdistributed despite demonstrated shopper demand.
Weak
Space
Strong
Shelf allocation is anchored to historical size rather than future growth.
SECTION 38 — SLIDE HEADLINE BUILDER
Use:
[WHAT IS HAPPENING] + [WHY IT MATTERS]
Template
[SEGMENT / KPI] is [MOVEMENT], creating [COMMERCIAL IMPLICATION].
Your Headline
SECTION 39 — THE RETAILER STORY BUILDER
Arrange your strongest insights into this sequence.
- CONTEXT
- PERFORMANCE
- TENSION
- SHOPPER EXPLANATION
- OPPORTUNITY
- RECOMMENDATION
- COMMERCIAL PRIZE
SECTION 40 — THE FIVE-SLIDE RAPID STORY
If you need to communicate quickly:
SLIDE 1 — WHAT IS HAPPENING?
Headline:
SLIDE 2 — WHY?
Headline:
SLIDE 3 — SO WHAT?
Headline:
SLIDE 4 — WHAT SHOULD CHANGE?
Headline:
SLIDE 5 — WHAT IS THE PRIZE?
Headline:
SECTION 41 — CATEGORY INSIGHT SWIPE FILE
Use these structures to accelerate your thinking.
Growth
“[SEGMENT] represents only [X]% of sales but contributes [Y]% of category growth, making it disproportionately important to future performance.”
Shopper
“Category performance is increasingly dependent on [EXISTING SHOPPER], while recruitment among [TARGET] remains underdeveloped.”
Assortment
“The range has expanded faster than category sales, suggesting additional choice is not delivering proportional incremental value.”
Price
“The current price ladder leaves a gap between [X] and [Y], potentially creating a barrier to shopper progression.”
Promotion
“Promotional sales are increasing while base demand weakens, suggesting the category is becoming more deal-dependent.”
Space
“[SEGMENT] is delivering more sales and growth than its current shelf allocation would suggest.”
Availability
“Lost sales appear operational rather than demand-related, with high-velocity products disproportionately affected by OOS.”
SECTION 42 — ACTION LANGUAGE SWIPE FILE
Replace vague actions with specific ones.
Instead of:
“Focus on…”
Use:
“Increase…”
“Reduce…”
“Reallocate…”
“Expand…”
“Remove…”
“Test…”
“Protect…”
“Introduce…”
“Consolidate…”
“Shift…”
“Prioritize…”
“Correct…”
SECTION 43 — THE “DON’T OVERCLAIM” FILTER
Before presenting:
Is the conclusion directly supported?
□ Yes
□ No
Are assumptions clearly labeled?
□ Yes
□ No
Are causal claims proven?
□ Yes
□ No
Is the prize presented as an estimate?
□ Yes
□ No
Is conflicting evidence acknowledged?
□ Yes
□ No
Is supplier bias controlled?
□ Yes
□ No
SECTION 44 — THE DECISION TEST
Ask:
What decision should this insight help someone make?
Insight
Decision
Decision Owner
Required Evidence
Deadline / Decision Point
If you cannot identify the decision, question whether the insight deserves priority.
SECTION 45 — THE 10-MINUTE CATEGORY INSIGHT SPRINT
When you need a fast analysis, use this.
MINUTE 1–2
Identify the biggest KPI movement.
MINUTE 3–4
Identify likely driver.
MINUTE 5
Write the “so what?”
MINUTE 6
Write the action.
MINUTE 7
Identify evidence supporting it.
MINUTE 8
Write strongest counterargument.
MINUTE 9
Estimate the prize.
MINUTE 10
Write the slide headline.
SECTION 46 — THE 30-MINUTE INSIGHT WORKSHOP
Use with a cross-functional team.
5 Minutes — Facts
Everyone writes the top three objective facts.
5 Minutes — Drivers
Generate possible explanations.
5 Minutes — Challenge
Ask what could make those explanations wrong.
5 Minutes — Implications
Identify commercial consequences.
5 Minutes — Actions
Generate possible responses.
5 Minutes — Prioritize
Select one protect, one fix, and one grow action.
SECTION 47 — THE INSIGHT REVIEW MEETING SCRIPT
Opening
“The objective today is not to review every data point. It is to identify which findings are strong enough to change a category decision.”
For Each Finding
“What happened?”
“What evidence explains it?”
“Why does the retailer care?”
“What should change?”
“How will we measure it?”
Close
“Which three insights are important enough to become actions?”
SECTION 48 — THE BAD INSIGHT REPAIR SHOP
Take a weak insight and improve it.
Weak Insight
“Premium is growing.”
Ask
How fast?
______%
Relative to category?
______%
Contribution to growth?
______%
Space share?
______%
Margin?
______%
Repaired Insight
SECOND EXAMPLE
Weak Insight
“Promo sales are high.”
Ask
Promo share?
______%
Base growth?
______%
Incrementality?
______%
Margin?
______%
Repaired Insight
SECTION 49 — THE CATEGORY INSIGHT SCORECARD
At the end of your analysis, rate the final work.
| Dimension | Score |
| Facts Are Clear | ___ / 5 |
| Root Cause Is Credible | ___ / 5 |
| Shopper Meaning Is Clear | ___ / 5 |
| Commercial Impact Is Clear | ___ / 5 |
| Recommendation Is Specific | ___ / 5 |
| Prize Is Quantified | ___ / 5 |
| KPI Is Defined | ___ / 5 |
| Trade-Offs Are Understood | ___ / 5 |
| Evidence Is Objective | ___ / 5 |
| Story Is Simple | ___ / 5 |
Total
___ / 50
43–50
Retailer-ready.
35–42
Strong; tighten weaker areas.
25–34
Needs more validation.
Below 25
Still analysis—not action.
SECTION 50 — THE ONE-PAGE INSIGHT-TO-ACTION WORKSHEET
CATEGORY
RETAILER OBJECTIVE
KEY DATA POINT
WHAT HAPPENED?
WHY?
FACTS
HYPOTHESES
SO WHAT?
SHOPPER IMPACT
COMMERCIAL IMPACT
RECOMMENDED ACTION
ESTIMATED PRIZE
$________________________
KPI
RISK
NEXT DECISION
SECTION 51 — THE THREE-INSIGHT CATEGORY SUMMARY
Force yourself to select only three.
INSIGHT #1 — PROTECT
Evidence
Meaning
Action
INSIGHT #2 — FIX
Evidence
Meaning
Action
INSIGHT #3 — GROW
Evidence
Meaning
Action
SECTION 52 — THE EXECUTIVE SUMMARY TEMPLATE
During [PERIOD], the category delivered [PERFORMANCE], primarily driven by [DRIVER]. However, analysis reveals [KEY RISK / GAP], particularly within [SEGMENT / SHOPPER / KPI].
The strongest commercial opportunity is [OPPORTUNITY], supported by [EVIDENCE].
We recommend three actions:
Protect: [ACTION]
Fix: [ACTION]
Grow: [ACTION]
The estimated commercial opportunity is [RANGE], with success measured through [KPIs].
SECTION 53 — THE CATEGORY INSIGHT MASTER FORMULA
Use this whenever you get stuck:
We observed [WHAT HAPPENED]. The evidence suggests this is driven by [WHY]. This matters because [COMMERCIAL / SHOPPER IMPLICATION]. Therefore, we recommend [SPECIFIC ACTION], with an estimated opportunity of [PRIZE] and success measured through [KPI].
EXAMPLE 1 — ASSORTMENT
We observed that the range increased 14% while sales grew only 2%. The evidence suggests most additions duplicated existing mainstream shopper needs. This matters because complexity is increasing without proportional category value. Therefore, we recommend rationalizing low-incremental duplicated SKUs and reinvesting the released space into premium and convenience propositions, with success measured through sales per SKU, sales per facing, and total category growth.
EXAMPLE 2 — SHOPPER
We observed that category value sales grew 5% while household penetration declined 1.6 points. The evidence suggests growth is increasingly dependent on higher spending from existing buyers. This matters because the category’s future buyer base is becoming narrower. Therefore, we recommend strengthening recruitment through accessible price points, trial formats, and new occasions, with success measured through penetration, new-buyer rate, and unit growth.
EXAMPLE 3 — PROMOTION
We observed that promotional sales increased 20% while base sales declined 7%. The evidence suggests promotional activity is increasingly shifting purchase timing rather than creating incremental category demand. This matters because the category is becoming more dependent on discounting. Therefore, we recommend reducing low-incrementality events and redirecting funding toward recruitment and basket-building mechanics, with success measured through base sales, incrementality, and promo ROI.
EXAMPLE 4 — AVAILABILITY
We observed that hero SKUs account for 43% of sales but experience an 8% OOS rate. The evidence suggests shelf capacity and replenishment are not keeping pace with demand. This matters because sales are being lost despite proven shopper demand. Therefore, we recommend increasing facings and improving inventory parameters for the highest-velocity items, with success measured through OOS, sales, and rate of sale.
ADVANCED APPLICATION — THE “WHAT WOULD CHANGE MY MIND?” TEST
For each insight, ask:
What evidence would cause me to abandon or materially change this conclusion?
Current Conclusion
Evidence That Would Change My Mind
Do I Have That Evidence?
□ Yes
□ No
This prevents confirmation bias and strengthens retailer credibility.
ADVANCED APPLICATION — THE SECOND-ORDER EFFECT TEST
Before taking action, ask what else may change.
Example:
Delisting SKUs may:
- Improve productivity
- Reduce shopper choice
- Increase hero OOS
- Shift sales to competitors
- Improve navigation
Recommended Action
Positive Effects
Negative Effects
Mitigation
ADVANCED APPLICATION — THE “IF WE DO NOTHING” TEST
A strong commercial recommendation explains the cost of inaction.
Complete:
If no action is taken, we expect [RISK] to continue because [CAUSE], potentially resulting in [COMMERCIAL CONSEQUENCE].
This is particularly effective when the retailer must prioritize competing initiatives.
ADVANCED APPLICATION — THE TEST-BEFORE-SCALE WORKSHEET
When evidence is not strong enough for full implementation:
Hypothesis
Test
Test Stores / Group
Control
Duration
Primary KPI
Success Threshold
Scale Rule
Stop Rule
USAGE TIPS / ADVANCED APPLICATIONS
- Write the “So What?” Before Building the Slide
Before inserting a chart, write the conclusion.
If the chart does not support that conclusion, rethink the slide.
- Use Multiple KPIs Together
A single number rarely tells the complete story.
Useful combinations include:
Sales + Units + ASP
Sales + Market Growth + Share
Penetration + Frequency + Spend
ROS + Distribution
Promo Sales + Base Sales + Incrementality
Sales Share + Shelf Share
- Do Not Force Causality
If the evidence only supports a hypothesis, say so.
Credibility is more valuable than sounding certain.
- Prioritize Decisions, Not Data
The goal of category analysis is not:
“Show what happened.”
The goal is:
“Help someone make a better commercial decision.”
- Compress the Final Story
After completing the workbook, reduce your output to:
One Problem
What needs fixing?
One Opportunity
Where is growth?
Three Actions
What should happen?
One Prize
What is it worth?
Five KPIs Maximum
How will success be measured?
THE INSIGHT-TO-ACTION MASTER CHECKLIST
Before calling an insight complete:
□ I know what happened.
□ I understand the likely driver.
□ Fact and hypothesis are separated.
□ The shopper implication is clear.
□ The commercial implication is clear.
□ The opportunity is quantified where possible.
□ The recommendation is specific.
□ The action is realistic.
□ Trade-offs are acknowledged.
□ Success KPIs are defined.
□ The insight changes or supports a decision.
□ I could defend it under retailer challenge.
FINAL WORKBOOK CHALLENGE
Take one real category issue and complete this:
THE DATA SAYS:
THE REAL INSIGHT IS:
THE RETAILER SHOULD CARE BECAUSE:
WE RECOMMEND:
THE ESTIMATED PRIZE IS:
SUCCESS WILL BE MEASURED BY:
If those six lines are clear, your analysis has successfully moved from data to decision.
Wrap-Up
The value of category analysis is not measured by how many charts you produce. It is measured by whether the analysis helps someone make a better decision.
Use this workbook to force every meaningful finding through a disciplined sequence:
What happened? → Why? → So what? → Now what?
Then strengthen it with evidence, quantify the prize, define the action, pressure-test the logic, and measure the result.
Use this asset to instantly shortcut data-to-action translation and position yourself as the expert.





