Category Insight-to-Action

The Category Insight-to-Action Micro-Workbook

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:

  1. What happened?
  2. Why did it happen?
  3. Why does it matter?
  4. 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.

  1. WHAT SHOULD CHANGE?
  2. WHERE?
  3. HOW MUCH?
  4. WHY?
  5. WHAT IS THE PRIZE?
  6. 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.

  1. CONTEXT
  2. PERFORMANCE
  3. TENSION
  4. SHOPPER EXPLANATION
  5. OPPORTUNITY
  6. RECOMMENDATION
  7. 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

  1. 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.

  1. 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

  1. Do Not Force Causality

If the evidence only supports a hypothesis, say so.

Credibility is more valuable than sounding certain.

  1. Prioritize Decisions, Not Data

The goal of category analysis is not:

“Show what happened.”

The goal is:

“Help someone make a better commercial decision.”

  1. 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.