The Category Management AI Prompt Vault

75+ Advanced Prompts for Turning Retail Data, Shopper Insights, Market Trends, and Commercial Questions Into Faster, Sharper Category Recommendations

Overview

Category managers rarely suffer from a lack of data.

The bigger problem is converting fragmented information into clear insights, strong hypotheses, commercially relevant recommendations, and retailer-ready stories.

The Category Management AI Prompt Vault is designed to accelerate that work.

Use these prompts with your approved AI tools to help you:

• Diagnose category performance
• Generate and challenge hypotheses
• Identify assortment opportunities
• Analyze pricing architecture
• Improve promotional thinking
• Translate shopper data into action
• Structure category reviews
• Prepare retailer meetings
• Improve commercial storytelling
• Pressure-test recommendations
• Build action plans faster

The prompts are deliberately structured to make the AI act more like a category strategist and analytical thought partner rather than a generic writing assistant.

HOW TO USE THIS VAULT

For the strongest output, give the AI four things:

1. CONTEXT

Explain:

• Category
• Retailer
• Market
• Time period
• Strategic objective
• Available data

2. DATA

Paste the relevant:

• Sales
• Units
• Share
• Pricing
• Distribution
• Shopper metrics
• Promotion results
• Assortment data
• Space data
• Research findings

3. TASK

Tell the AI exactly what you want it to do.

Examples:

• Diagnose
• Compare
• Prioritize
• Challenge
• Summarize
• Recommend
• Reframe
• Quantify

4. OUTPUT FORMAT

Specify what a useful answer looks like.

Examples:

• Executive summary
• Table
• Top 5 opportunities
• Slide headlines
• Hypothesis tree
• Recommendation matrix
• 30-60-90 day plan

THE CATEGORY MANAGEMENT MASTER PROMPT

Use this when you want a complete category diagnosis.

Act as a senior retail category management strategist. I will provide category performance data, shopper metrics, assortment information, pricing, promotional data, and retailer context.

Analyze the information objectively from the perspective of maximizing total category growth and shopper value rather than favoring any individual brand.

Structure your response around:

1. What is happening?
2. What are the likely drivers?
3. What is performing disproportionately well?
4. Where is performance leaking?
5. What shopper behaviors may explain the results?
6. What assumptions require validation?
7. What are the five highest-potential category opportunities?
8. Which opportunities should be prioritized based on commercial impact and ease of execution?
9. What retailer actions should follow?
10. Which KPIs should be used to measure success?

Separate facts from hypotheses. Do not invent missing data. Clearly label areas where additional evidence is required.

Data:
[PASTE DATA]

Retailer objective:
[INSERT]

Category objective:
[INSERT]

SECTION 1 — CATEGORY PERFORMANCE DIAGNOSTIC PROMPTS

Prompt 1 — Category Health Diagnostic

Act as an experienced category director. Review the performance data below and identify the five most important signals.

For each signal, provide:

• Observation
• Likely cause
• Commercial implication
• Shopper implication
• Recommended next analysis

Pay particular attention to situations where headline sales performance may hide underlying weakness.

Data:
[PASTE]

Prompt 2 — Sales vs. Units Diagnosis

Analyze the relationship between dollar sales, unit sales, average selling price, and mix.

Determine whether growth is primarily driven by:

• True volume expansion
• Pricing
• Premiumization
• Pack-size changes
• Promotion
• Distribution

Identify any signs that value growth is masking weakening underlying demand.

Data:
[PASTE]

Prompt 3 — Retailer vs. Market Gap

Compare retailer category performance with total market performance.

Identify:

1. Where the retailer is outperforming
2. Where the retailer is underperforming
3. Which gaps matter most commercially
4. Which high-growth market segments the retailer is failing to capture
5. The most likely causes of the gap

Rank the opportunities from highest to lowest potential.

Data:
[PASTE]

Prompt 4 — Growth Contribution Analysis

Analyze which segments are driving total category growth.

For each segment, compare:

• Current sales share
• Growth rate
• Dollar growth contribution
• Unit growth
• Margin contribution

Identify segments that contribute disproportionately more growth than their current category size.

Highlight where current retailer investment may be based on historical size rather than future growth potential.

Data:
[PASTE]

Prompt 5 — Performance Red-Flag Finder

Review this category dataset specifically for hidden warning signs.

Look for combinations such as:

• Dollar sales up while units decline
• Sales up while market share falls
• Penetration down while frequency rises
• Promotional sales up while base sales fall
• Margin down despite sales growth
• High velocity with low distribution
• Low velocity with high distribution

Identify the ten most important red flags and explain why each matters.

Data:
[PASTE]

SECTION 2 — ROOT-CAUSE & HYPOTHESIS PROMPTS

Prompt 6 — Root-Cause Tree

Build a root-cause tree for the following category problem:

[INSERT PROBLEM]

Divide possible causes into:

• Shopper
• Assortment
• Pricing
• Promotion
• Distribution
• Availability
• Space
• Competition
• Seasonality
• External market forces

For each possible cause, identify the data needed to confirm or reject it.

Prompt 7 — Hypothesis Generator

Generate 15 plausible hypotheses that could explain this category performance issue:

[INSERT ISSUE]

Rank each hypothesis by:

• Likelihood
• Potential commercial impact
• Ease of validation

Then recommend the first five analyses I should run.

Prompt 8 — Challenge My Assumption

I currently believe:

[INSERT ASSUMPTION]

Act as a skeptical category director and challenge this conclusion.

Provide:

• Five alternative explanations
• Evidence that would support my view
• Evidence that would disprove my view
• Risks of acting too quickly
• The minimum additional analysis needed before making a recommendation

Prompt 9 — Correlation vs. Causation Check

Review the following findings and identify where I may be confusing correlation with causation.

For each claim:

1. State the implied causal assumption
2. Give alternative explanations
3. Identify potential confounding variables
4. Recommend evidence needed before claiming causality

Findings:
[PASTE]

Prompt 10 — Missing Data Finder

Based on this category analysis, identify what critical information is missing.

Organize missing information into:

• Performance data
• Shopper data
• Competitive data
• Assortment
• Pricing
• Promotion
• Space
• Availability

Prioritize the missing data based on how materially it could change the recommendation.

Current analysis:
[PASTE]

SECTION 3 — SHOPPER INSIGHT PROMPTS

Prompt 11 — Shopper Funnel Diagnosis

Analyze category performance through the shopper funnel:

• Penetration
• Frequency
• Spend per trip
• Units per trip
• Spend per buyer
• Retention
• Recruitment

Identify which lever is contributing most to growth or decline.

Then recommend actions to improve the weakest lever.

Data:
[PASTE]

Prompt 12 — Penetration Problem

Household penetration in this category has changed from [X]% to [Y]%.

Generate the most likely reasons for the movement.

Separate causes into:

• Category relevance
• Pricing
• Competition
• Distribution
• Assortment
• Shopper demographics
• Occasion changes

Recommend five actions for improving recruitment.

Prompt 13 — Frequency Growth

Category penetration is relatively healthy, but buyer frequency is below target.

Identify possible new purchase occasions that could increase category frequency.

For each occasion, provide:

• Target shopper
• Shopper need
• Product proposition
• Merchandising idea
• Promotional idea
• Cross-category partner

Category:
[INSERT]

Prompt 14 — Shopper Segmentation

Create a practical shopper segmentation for the following retail category:

[CATEGORY]

Base the segmentation on behaviors and needs rather than demographics alone.

For each segment, provide:

• Name
• Core motivation
• Purchase trigger
• Main barrier
• Preferred price position
• Preferred format
• Typical purchase mission
• Growth strategy

Prompt 15 — Unmet Need Finder

Based on the shopper insights below, identify unmet or underserved category needs.

For each opportunity, explain:

• What shoppers need
• Why current assortment may fail them
• Which shoppers are affected
• What product, service, pricing, or merchandising response could address the need

Shopper research:
[PASTE]

SECTION 4 — ASSORTMENT OPTIMIZATION PROMPTS

Prompt 16 — SKU Rationalization

Analyze this SKU-level assortment data objectively.

Evaluate each SKU based on:

• Sales
• Rate of sale
• Margin
• Growth
• Distribution
• Incrementality
• Strategic role
• Shopper uniqueness

Classify each SKU into:

• Protect
• Grow
• Maintain
• Investigate
• Rationalize

Explain every rationalization recommendation and identify risks associated with removing the item.

Data:
[PASTE]

Prompt 17 — Range Duplication Finder

Review the following assortment and identify possible SKU duplication.

Look for products serving substantially similar:

• Shopper needs
• Pack sizes
• Price points
• Flavors
• Benefits
• Occasions

Identify where complexity may exceed incremental shopper value.

Data:
[PASTE]

Prompt 18 — Whitespace Analysis

Analyze this category assortment for whitespace opportunities.

Look for missing:

• Price tiers
• Pack formats
• Need states
• Benefits
• Shopper segments
• Usage occasions
• Premium propositions
• Value propositions

Rank each whitespace opportunity by potential impact.

Current range:
[PASTE]

Prompt 19 — Good-Better-Best Architecture

Evaluate the current assortment against a good-better-best architecture.

Determine whether shoppers have:

• A credible opening price point
• Clear mainstream options
• Meaningfully differentiated premium choices

Identify pricing or proposition gaps.

Data:
[PASTE]

Prompt 20 — Assortment Expansion Opportunity

Identify products or segments that may deserve increased distribution.

Give extra weight to:

• High rate of sale
• Strong growth
• Low current distribution
• High shopper incrementality
• Strong margin

Rank the top ten expansion candidates and explain why.

Data:
[PASTE]

SECTION 5 — PRICING PROMPTS

Prompt 21 — Price Architecture Diagnostic

Analyze this category’s price architecture.

Identify:

• Opening price point
• Major price clusters
• Price gaps
• Mainstream range
• Premium tier
• Pack-price inconsistencies

Determine whether shoppers have a clear reason to trade up.

Data:
[PASTE]

Prompt 22 — Competitive Price Comparison

Compare the retailer’s pricing with these competitors.

Identify:

• Products priced materially above market
• Products materially below market
• Key value perception risks
• Price points worth protecting
• Areas where premium pricing appears justified

Do not recommend matching every competitor price automatically.

Data:
[PASTE]

Prompt 23 — Price Increase Risk

Evaluate the risks associated with a proposed price increase from [CURRENT PRICE] to [NEW PRICE].

Consider:

• Percentage increase
• Competitive price gap
• Shopper elasticity
• Available substitutes
• Pack alternatives
• Private label
• Category penetration

Create best-case, expected-case, and downside scenarios.

Prompt 24 — Price-Pack Architecture

Analyze the relationship between pack size and price across this category.

Identify:

• Illogical price-per-unit relationships
• Trade-down opportunities
• Trade-up barriers
• Pack-size gaps
• Opportunities to improve value perception

Data:
[PASTE]

Prompt 25 — Premiumization Opportunity

Determine whether this category has a premiumization opportunity.

Evaluate:

• Premium segment growth
• Premium unit growth
• Premium penetration
• Premium distribution
• Margin contribution
• Shelf allocation

Recommend whether to expand, maintain, or reduce premium presence.

Data:
[PASTE]

SECTION 6 — PROMOTION PROMPTS

Prompt 26 — Promotion Effectiveness Diagnostic

Evaluate this promotional event.

Assess:

• Baseline sales
• Promotional sales
• Uplift
• Incremental units
• Incremental revenue
• Cannibalization
• Forward buying
• Post-event dip
• Gross margin
• Promo ROI

Determine whether the promotion created genuinely incremental category demand.

Data:
[PASTE]

Prompt 27 — Promotional Dependency

Determine whether this category is becoming overdependent on promotion.

Analyze trends in:

• Promo sales %
• Base sales
• Discount depth
• Promotion frequency
• Shopper response
• Margin

Flag any evidence that shoppers are being trained to wait for deals.

Data:
[PASTE]

Prompt 28 — Promotional Calendar Optimizer

Review this promotional calendar and identify opportunities to improve efficiency.

Look for:

• Overpromotion
• Event overlap
• Excessive discount depth
• Repeated mechanics
• Poor seasonal alignment
• Growth segments receiving too little support

Recommend a revised promotion strategy.

Calendar:
[PASTE]

Prompt 29 — Promotion Objective Matcher

Recommend the best promotional mechanic for each of these objectives:

• Recruit new shoppers
• Increase frequency
• Drive stock-up
• Encourage premium trial
• Grow basket size
• Increase cross-category attachment
• Defend against competition

For each, explain why the mechanic fits and which KPI should measure success.

Prompt 30 — Promotion Postmortem

Turn the following promotion results into an executive postmortem.

Include:

• What happened
• What worked
• What did not
• Why
• Commercial impact
• Shopper implications
• What should be repeated
• What should change next time

Data:
[PASTE]

SECTION 7 — SPACE & MERCHANDISING PROMPTS

Prompt 31 — Space-to-Sales Analysis

Compare category sales share with shelf-space share.

Identify:

• Under-spaced segments
• Over-spaced segments
• High-growth segments receiving insufficient space
• Low-productivity areas that could fund reallocation

Data:
[PASTE]

Prompt 32 — Facing Optimization

Review SKU rate of sale, sales contribution, margin, and OOS performance.

Recommend where facings should be:

• Increased
• Maintained
• Reduced

Prioritize hero SKU availability and total category productivity.

Data:
[PASTE]

Prompt 33 — Shelf Navigation Redesign

Act as a shopper-led merchandising strategist.

Redesign the shelf navigation for:

[CATEGORY]

Organize products based on how shoppers are most likely to make decisions.

Consider:

• Need
• Benefit
• Format
• Occasion
• Price
• Brand

Recommend a logical hierarchy and explain why it makes shopping easier.

Prompt 34 — Cross-Merchandising Ideas

Generate 20 commercially credible cross-merchandising opportunities for:

[CATEGORY]

For each:

• Adjacent category
• Shopper mission
• Why the pairing makes sense
• Display idea
• Promotional mechanic

Avoid random product combinations.

Prompt 35 — Secondary Placement Strategy

Identify the highest-potential secondary placement opportunities for:

[CATEGORY]

Consider:

• Seasonal missions
• Checkout
• High-traffic areas
• Adjacent categories
• Endcaps
• Digital placement

Rank the opportunities by relevance and commercial potential.

SECTION 8 — AVAILABILITY & DISTRIBUTION PROMPTS

Prompt 36 — OOS Root-Cause Diagnostic

Analyze these out-of-stock patterns.

Determine whether the likely issue is:

• Forecasting
• Ordering
• Store execution
• Supply
• Distribution
• Promotional demand
• Insufficient facings

Prioritize the causes and recommend corrective actions.

Data:
[PASTE]

Prompt 37 — Lost Sales Estimate

Estimate lost sales caused by out-of-stocks using the data below.

State all assumptions explicitly.

Show:

• Lost weekly sales
• Lost annualized sales
• Potential recoverable sales

Do not present estimates as exact.

Data:
[PASTE]

Prompt 38 — Distribution Expansion

Identify SKUs that could justify wider distribution.

Prioritize products with:

• High rate of sale
• Strong repeat
• Strong growth
• Low current distribution
• High incrementality

Rank opportunities and identify risks.

Data:
[PASTE]

SECTION 9 — COMPETITIVE ANALYSIS PROMPTS

Prompt 39 — Competitor Gap Analysis

Compare our category proposition with [COMPETITOR].

Analyze:

• Range
• Pricing
• Promotion
• Space
• Innovation
• Value architecture
• Shopper navigation

Identify which competitor advantages are strategically important and which do not need to be copied.

Data:
[PASTE]

Prompt 40 — Competitive Threat Assessment

Evaluate the following competitive development:

[INSERT]

Determine:

• Likely shopper impact
• Potential share risk
• Vulnerable segments
• Areas where our current proposition is defensible
• Recommended response

Avoid recommending reaction simply for the sake of reacting.

Prompt 41 — Fair Share Opportunity

Calculate and interpret fair-share opportunities by segment.

Compare retailer total category share with retailer share in each segment.

Highlight segments where the retailer materially under-indexes.

Rank opportunities based on segment growth and size.

Data:
[PASTE]

SECTION 10 — INNOVATION PROMPTS

Prompt 42 — Innovation Territory Generator

Identify five high-potential innovation territories for:

[CATEGORY]

Base them on:

• Unmet shopper needs
• Emerging behaviors
• Growing occasions
• Format changes
• Convenience
• Value
• Premiumization

Avoid simply generating new flavors or minor variants.

Prompt 43 — New Product Evaluation

Evaluate this proposed innovation:

[PRODUCT CONCEPT]

Assess:

• Shopper need
• Incrementality
• Cannibalization risk
• Price position
• Range fit
• Margin potential
• Distribution potential
• Competitive differentiation

Provide a go / test / revise / reject recommendation.

Prompt 44 — Innovation Post-Launch Review

Analyze this new product after launch.

Review:

• Trial
• Repeat
• Rate of sale
• Distribution
• Incrementality
• Cannibalization
• Margin
• Retailer performance

Determine whether performance reflects temporary launch support or sustainable shopper demand.

Data:
[PASTE]

SECTION 11 — DIGITAL CATEGORY MANAGEMENT PROMPTS

Prompt 45 — Digital Shelf Audit

Conduct a digital shelf audit using the information below.

Assess:

• Search visibility
• Product titles
• Images
• Descriptions
• Reviews
• Filters
• Availability
• Price
• Sponsored placement

Prioritize the ten highest-value fixes.

Data:
[PASTE]

Prompt 46 — Search Term Opportunity

Analyze these retailer-site search terms.

Identify:

• High-demand needs
• Missing assortment
• Language shoppers actually use
• Emerging trends
• Search terms with weak conversion

Translate findings into assortment and content recommendations.

Data:
[PASTE]

Prompt 47 — Online vs. In-Store Assortment

Compare online and in-store category assortments.

Identify where the online range should be:

• Broader
• Narrower
• Different

Base recommendations on digital shopper behavior rather than assuming perfect parity is required.

Data:
[PASTE]

SECTION 12 — CATEGORY STRATEGY PROMPTS

Prompt 48 — Category Strategy Builder

Build a 12-month category strategy for:

[CATEGORY]

Retailer objective:
[OBJECTIVE]

Organize the strategy into:

• Protect
• Fix
• Grow
• Innovate

For each initiative provide:

• Rationale
• Action
• Commercial impact
• KPI
• Timing
• Risk

Prompt 49 — Opportunity Prioritization

I have identified the following category opportunities:

[PASTE]

Score each 1–5 against:

• Sales potential
• Margin potential
• Shopper benefit
• Strategic fit
• Speed to impact
• Ease of execution
• Evidence strength

Rank them and recommend the top three priorities.

Prompt 50 — Protect-Fix-Grow

Classify these findings into:

PROTECT — strengths that should not be disrupted

FIX — problems suppressing current performance

GROW — opportunities requiring new investment

Then create a three-priority category plan.

Findings:
[PASTE]

SECTION 13 — RETAILER PRESENTATION PROMPTS

Prompt 51 — Turn Data Into Slide Headlines

Convert the following category findings into retailer-ready slide headlines.

Each headline should:

• State the conclusion
• Explain why it matters
• Avoid simply naming the chart
• Be concise enough for a presentation

Give me three headline options per finding.

Findings:
[PASTE]

Prompt 52 — Data-to-Insight Converter

For each data point below, convert it into:

1. Observation
2. Insight
3. “So what?”
4. Recommended action

Do not overstate conclusions beyond the evidence.

Data:
[PASTE]

Prompt 53 — Executive Summary Generator

Turn the following category analysis into a retailer-ready executive summary.

Structure:

• Current category state
• Three key findings
• Three opportunities
• Recommended action
• Commercial prize

Keep the language commercial, concise, and objective.

Analysis:
[PASTE]

Prompt 54 — 10-Slide Category Review

Turn this category analysis into a 10-slide retailer review.

For every slide provide:

• Slide title
• Headline conclusion
• Recommended visual/chart
• 2–3 supporting points
• Speaker takeaway

Analysis:
[PASTE]

Prompt 55 — Cut My Deck

Review this category presentation outline and identify what should be deleted, combined, or moved to the appendix.

The retailer should leave remembering no more than three major messages.

Prioritize clarity and decision-making over showing all available analysis.

Deck:
[PASTE]

SECTION 14 — COMMERCIAL STORYTELLING PROMPTS

Prompt 56 — Build the Narrative

Turn these findings into a logical commercial story.

Use this sequence:

1. Context
2. Performance
3. Tension/problem
4. Shopper explanation
5. Opportunity
6. Recommendation
7. Commercial prize

Findings:
[PASTE]

Prompt 57 — Stronger “So What?”

The current insight is:

[PASTE]

Rewrite it so it clearly answers:

• Why should the retailer care?
• What is at risk?
• What is the opportunity?

Give me five versions ranging from cautious to assertive.

Prompt 58 — Recommendation Rewriter

Rewrite these category recommendations so each one contains:

• Specific action
• Reason
• Shopper benefit
• Commercial benefit
• Success KPI

Avoid vague verbs such as “consider,” “explore,” and “leverage” unless uncertainty genuinely requires them.

Recommendations:
[PASTE]

SECTION 15 — RETAILER MEETING PREPARATION PROMPTS

Prompt 59 — Meeting Prep

Prepare me for a retailer category review on:

[CATEGORY]

Retailer objective:
[INSERT]

Our recommendation:
[INSERT]

Generate:

• Five likely retailer questions
• Five objections
• Strong evidence-led responses
• Three areas where we should avoid overclaiming
• Three questions we should ask the retailer

Prompt 60 — Objection Simulator

Act as a skeptical retail category buyer.

Challenge this recommendation:

[INSERT]

Give me ten realistic objections involving:

• Space
• Margin
• Shopper demand
• Complexity
• Operational feasibility
• Competitive risk

Then provide concise evidence-based responses.

Prompt 61 — Tough Buyer Role-Play

Role-play a retailer buyer who disagrees with my recommendation.

Ask me one challenging question at a time.

Focus on whether my recommendation genuinely grows the category rather than my own brand.

Recommendation:
[INSERT]

Prompt 62 — Questions to Ask the Retailer

Generate 15 high-value strategic questions I should ask the retailer before finalizing a category recommendation.

Cover:

• Business objectives
• Shopper priorities
• Margin
• Space
• Promotion
• Digital
• Operational constraints

Category:
[INSERT]

SECTION 16 — CATEGORY CAPTAINCY PROMPTS

Prompt 63 — Neutrality Test

Review this recommendation for supplier bias.

Ask:

• Does it grow the total category?
• Would I recommend it if my brand did not benefit?
• Are competitor products treated objectively?
• Is the shopper outcome positive?
• Is the retailer economics case credible?

Identify biased language or logic and rewrite the recommendation more objectively.

Recommendation:
[PASTE]

Prompt 64 — Category Captain Recommendation

Act as a neutral category captain.

Based only on the evidence below, recommend how the retailer should allocate assortment and space.

Ignore manufacturer ownership.

Optimize for:

• Category growth
• Shopper choice
• Productivity
• Margin
• Future growth

Data:
[PASTE]

SECTION 17 — QUANTIFICATION PROMPTS

Prompt 65 — Size the Opportunity

Estimate the commercial size of this opportunity:

[INSERT]

Use the available data below.

Provide:

• Conservative scenario
• Base scenario
• Upside scenario

State assumptions clearly and show the calculation logic.

Do not imply false precision.

Data:
[PASTE]

Prompt 66 — Share Gain Prize

Calculate the sales upside if retailer category share increases from [CURRENT SHARE]% to:

• [SCENARIO 1]%
• [SCENARIO 2]%
• [SCENARIO 3]%

Total category market size:
$[INSERT]

Show calculations and assumptions.

Prompt 67 — Distribution Opportunity

Estimate potential incremental sales from expanding distribution of:

[SKU]

Current stores:
[___]

Target stores:
[___]

Weekly rate of sale:
[___]

Expected weeks:
[___]

Include a conservative adjustment for lower productivity in incremental stores.

Prompt 68 — Space Reallocation Scenario

Model a simple scenario where [X]% of shelf space is moved from [SEGMENT A] to [SEGMENT B].

Use:

• Current sales per facing
• Growth rate
• Margin
• OOS

Estimate potential sales and margin impact.

Explicitly state limitations.

Data:
[PASTE]

SECTION 18 — DECISION-MAKING PROMPTS

Prompt 69 — Decision Memo

Turn this category analysis into a one-page decision memo.

Include:

• Decision required
• Relevant facts
• Options
• Trade-offs
• Recommendation
• Risks
• Success metrics

Analysis:
[PASTE]

Prompt 70 — Option Comparison

Compare these three category options:

Option A: [___]

Option B: [___]

Option C: [___]

Evaluate each against:

• Sales
• Margin
• Shopper impact
• Complexity
• Speed
• Risk
• Strategic fit

Recommend one and explain why.

Prompt 71 — Pre-Mortem

Assume this category recommendation failed badly 12 months from now:

[RECOMMENDATION]

Identify the ten most plausible reasons for failure.

For each:

• Early warning sign
• Preventive action
• KPI to monitor

SECTION 19 — ACTION PLANNING PROMPTS

Prompt 72 — 30-60-90 Day Plan

Convert this recommendation into a 30-60-90 day implementation plan.

Recommendation:
[INSERT]

Include:

• Actions
• Owner
• Dependencies
• KPI
• Decision gates
• Risks

Prompt 73 — Test-and-Learn Plan

Design a controlled retail test for:

[INITIATIVE]

Include:

• Hypothesis
• Test stores
• Control stores
• Duration
• KPIs
• Confounding factors
• Success threshold
• Scale / modify / stop rules

Prompt 74 — KPI Scorecard

Build a simple category scorecard for this strategy:

[STRATEGY]

Include no more than 10 KPIs.

Divide them into:

• Outcome metrics
• Leading indicators
• Execution metrics

Explain why each KPI matters.

SECTION 20 — ADVANCED “THINK LIKE A CATEGORY DIRECTOR” PROMPTS

Prompt 75 — What Am I Missing?

Review everything below as a category director who was not involved in the analysis.

Tell me:

• What seems convincing
• What seems weak
• What assumptions are hidden
• What evidence is missing
• What alternative conclusions exist
• What the retailer is most likely to challenge

Analysis:
[PASTE]

Prompt 76 — Find the One Big Opportunity

Review this category analysis and identify the single highest-leverage commercial opportunity.

Do not give me a long list.

Choose one.

Explain:

• Why it matters
• Evidence supporting it
• What could invalidate it
• Required action
• Commercial prize
• KPI

Prompt 77 — Simplify the Strategy

Reduce this category strategy to three priorities only.

One must:

• Protect current performance

One must:

• Fix a major leakage

One must:

• Build future growth

Explain what should intentionally be deprioritized.

Strategy:
[PASTE]

Prompt 78 — Second-Order Effects

Analyze the second-order consequences of this recommendation:

[INSERT]

Consider potential effects on:

• Shopper substitution
• Margin mix
• Competition
• Inventory
• OOS
• Category complexity
• Promotion
• Supplier economics

Identify unintended consequences before implementation.

Prompt 79 — Executive Challenge

Imagine the CFO, retailer buyer, supply-chain lead, merchandising director, and shopper-insights lead are all reviewing this recommendation.

For each stakeholder:

• What would they question?
• What evidence would they demand?
• What would make them support the proposal?

Recommendation:
[INSERT]

Prompt 80 — Category Strategy Stress Test

Stress-test this category strategy under three scenarios:

1. Shopper spending weakens
2. A major competitor increases promotional intensity
3. Supply constraints reduce availability

Explain what parts of the strategy remain robust and what should change.

Strategy:
[PASTE]

SECTION 21 — RAPID PROMPTS FOR EVERYDAY CATEGORY MANAGEMENT

Use these when you need fast outputs.

Turn Data Into Insights

Give me the five most commercially important insights from this data. For each, explain the “so what?” and likely action. [PASTE DATA]

Create Slide Headlines

Give me ten conclusion-led slide headlines based on these findings. [PASTE]

Find Red Flags

What concerns should a category director immediately notice in this performance data? [PASTE]

Find Growth Opportunities

Identify the top five category growth opportunities supported by this information. [PASTE]

Improve a Recommendation

Make this recommendation more specific, retailer-centric, measurable, and commercially persuasive: [PASTE]

Pressure-Test an Insight

Give me five reasons this conclusion might be wrong: [PASTE]

Prepare for a Meeting

What are the ten toughest questions a retailer could ask about this recommendation? [PASTE]

Summarize a Report

Summarize this research into five category implications and five recommended actions. [PASTE]

Build a Decision Tree

Create a diagnostic decision tree for understanding why [KPI] is declining.

Quantify the Prize

Show me three credible ways to quantify the commercial value of this opportunity: [INSERT].

SECTION 22 — THE UNIVERSAL PROMPT ENHANCER

Add this block to almost any prompt to improve the quality of the response:

Important instructions:

• Separate fact from hypothesis.
• Do not invent missing data.
• State assumptions explicitly.
• Challenge obvious conclusions.
• Focus on total category growth, not supplier advantage.
• Highlight risks and trade-offs.
• Quantify opportunities where evidence allows.
• Prioritize recommendations rather than giving an unranked list.
• Make every recommendation specific and measurable.
• Identify what additional evidence would materially change the recommendation.

SECTION 23 — DATA INPUT TEMPLATE

Use this before running more complex prompts.

CATEGORY

[INSERT]

RETAILER

[INSERT]

PERIOD

[INSERT]

RETAILER OBJECTIVE

[INSERT]

CATEGORY OBJECTIVE

[INSERT]

SALES

Current: $[___]

Growth: [___]%

Market Growth: [___]%

UNITS

Current: [___]

Growth: [___]%

SHARE

Current: [___]%

Change: [___] pts

PRICE

ASP: $[___]

Change: [___]%

SHOPPER

Penetration: [___]%

Frequency: [___]

Spend per Buyer: $[___]

ASSORTMENT

SKUs: [___]

Distribution: [___]%

ROS: [___]

PROMOTION

Promo Sales: [___]%

Promo Uplift: [___]%

Base Sales Growth: [___]%

MARGIN

Margin: [___]%

Margin Growth: [___]%

AVAILABILITY

OOS: [___]%

KEY BUSINESS QUESTION

[INSERT]

SECTION 24 — THE INSIGHT QUALITY FILTER

Before using any AI-generated insight in a retailer discussion, score it against these seven questions.

1. Is It Supported?

Does actual evidence support the conclusion?

□ Yes
□ No

2. Is It Commercially Relevant?

Does it affect:

• Sales
• Margin
• Share
• Shopper
• Productivity

□ Yes
□ No

3. Does It Explain Why?

Or is it simply an observation?

□ Yes
□ No

4. Is It Actionable?

Can someone do something because of it?

□ Yes
□ No

5. Is It Retailer-Centric?

Does it improve the total category rather than merely your brand?

□ Yes
□ No

6. Is It Measurable?

Can success be tracked?

□ Yes
□ No

7. Has It Been Challenged?

Have alternative explanations been considered?

□ Yes
□ No

Gold Standard

An insight scoring 7/7 is potentially presentation-ready.

Anything below 5/7 should usually be strengthened.

SECTION 25 — AI OUTPUT RED FLAGS

Never blindly accept an AI-generated recommendation.

Watch for:

Unsupported Precision

Example:

“This initiative will increase sales by 17.4%.”

Without sufficient evidence, that is false precision.

Invented Causality

Example:

“Sales declined because shoppers dislike the new packaging.”

Unless you have evidence, this is a hypothesis.

Generic Recommendations

Example:

“Improve customer engagement.”

Ask:

How? Where? For whom? Against which KPI?

Brand Bias

If the recommendation conveniently benefits your supplier while reducing retailer choice or economics, challenge it.

Failure to Consider Trade-Offs

Every meaningful commercial action carries trade-offs.

Removing SKUs can improve productivity but reduce choice.

Adding facings can reduce OOS but consumes space elsewhere.

Discounting can create volume but destroy margin.

Make the trade-offs explicit.

SECTION 26 — THE “MAKE IT 10X BETTER” PROMPT

Use this after receiving an initial AI response.

Improve the previous output substantially.

Specifically:

• Remove generic observations
• Rank insights by commercial importance
• Challenge weak assumptions
• Connect every insight to a retailer action
• Add shopper implications
• Add potential risks
• Quantify the opportunity where possible
• Make recommendations more specific
• Identify which claims still require validation

Write at the level expected from a senior category director preparing for an executive retailer meeting.

SECTION 27 — THE BOARDROOM VERSION PROMPT

Use this when your output is too detailed.

Condense this analysis for a senior executive who has three minutes.

Give me:

1. What is happening
2. Why it matters
3. The largest commercial risk
4. The largest commercial opportunity
5. The decision required

Maximum 250 words.

Analysis:
[PASTE]

SECTION 28 — THE RETAIL BUYER VERSION PROMPT

Rewrite this category analysis for a retail buyer.

Emphasize:

• Shopper benefit
• Category growth
• Margin
• Space productivity
• Ease of implementation

Remove unnecessary analytical jargon.

Analysis:
[PASTE]

SECTION 29 — THE SENIOR LEADERSHIP VERSION PROMPT

Rewrite this analysis for senior commercial leadership.

Focus on:

• Financial impact
• Competitive implication
• Strategic significance
• Decision required
• Risk

Keep detailed methodology out of the main narrative.

Analysis:
[PASTE]

SECTION 30 — THE CATEGORY REVIEW CO-PILOT PROMPT

Use this prompt repeatedly as you build your review.

You are my category review co-pilot.

Your role is to help me build a fact-based, retailer-centric category strategy.

Whenever I provide new information:

1. Integrate it with previous findings.
2. Identify whether it confirms or contradicts earlier hypotheses.
3. Update the priority opportunities.
4. Tell me what information still matters.
5. Challenge me if I overstate the evidence.
6. Keep the final story focused on no more than three major retailer actions.

Current category objective:
[INSERT]

Current retailer objective:
[INSERT]

BONUS — THE CATEGORY MANAGER PROMPT CHAIN

Instead of asking one giant question, run this sequence.

STEP 1 — Diagnose

What are the five biggest performance signals in this data?

STEP 2 — Explain

What are the three most plausible causes of each signal?

STEP 3 — Validate

What evidence would confirm or reject these causes?

STEP 4 — Prioritize

Which issues have the largest commercial impact?

STEP 5 — Solve

What retailer actions could address the top three?

STEP 6 — Quantify

How could we credibly estimate the commercial prize?

STEP 7 — Challenge

Why might these recommendations be wrong?

STEP 8 — Communicate

Turn the final recommendation into three retailer-ready slides.

This chained approach often produces much stronger reasoning than asking AI to jump directly from raw data to a recommendation.

BONUS — THE PERFECT CATEGORY INSIGHT PROMPT

Using only the evidence I provide, develop the strongest possible category insight.

Structure it as:

Observation: What happened?

Driver: What most likely explains it?

Shopper Meaning: What does it suggest about shopper behavior?

Commercial Implication: Why should the retailer care?

Action: What should change?

KPI: How will we know it worked?

Clearly distinguish any hypothesis from confirmed fact.

Evidence:
[PASTE]

BONUS — CATEGORY REVIEW FINAL QUALITY CHECK

Paste your completed presentation into AI with:

Act as a demanding retailer category director reviewing this presentation before a buyer meeting.

Score it from 1–10 for:

• Clarity
• Evidence
• Shopper centricity
• Commercial relevance
• Objectivity
• Recommendation specificity
• Quantification
• Storytelling
• Executive simplicity

Then identify:

• The three weakest slides
• The three biggest logical gaps
• The hardest retailer objections
• Anything that should be removed
• Anything missing that could materially improve the recommendation

Presentation:
[PASTE]

USAGE TIPS / ADVANCED APPLICATIONS

1. Use AI to Accelerate Thinking, Not Replace Judgment

AI is most useful when it helps you:

• Explore hypotheses faster
• Structure messy data
• Challenge assumptions
• Generate alternatives
• Improve communication

It should not replace:

• Data validation
• Retailer knowledge
• Shopper research
• Commercial judgment
• Compliance requirements
• Final decision ownership

2. Never Ask AI to “Find an Insight” Without Context

Weak:

Analyze this.

Better:

Identify evidence that penetration loss, distribution, pricing, or declining frequency may be suppressing growth. Separate confirmed facts from hypotheses.

Specific prompts create stronger outputs.

3. Force Prioritization

AI loves generating long lists.

Regularly add:

“Rank these from highest to lowest commercial importance and recommend only the top three.”

That turns brainstorming into decision support.

4. Ask AI to Attack Its Own Recommendation

After generating an idea, use:

“Now argue against this recommendation.”

This is one of the fastest ways to identify weak logic before a retailer does.

5. Ask for Missing Evidence

Add:

“What evidence would materially change your recommendation?”

This helps distinguish robust conclusions from fragile assumptions.

6. Build Around Decisions

The highest-value AI prompt is often not:

“What does this data say?”

Instead ask:

“What decision should this analysis help the retailer make?”

That keeps category management commercially focused.

THE CATEGORY MANAGEMENT AI MASTER WORKFLOW

Use this seven-stage process:

1. INPUT

Provide clean, relevant data.

2. DIAGNOSE

Identify unusual performance signals.

3. HYPOTHESIZE

Generate plausible explanations.

4. VALIDATE

Determine what evidence supports each explanation.

5. PRIORITIZE

Focus on the highest-value opportunities.

6. RECOMMEND

Translate findings into specific actions.

7. COMMUNICATE

Turn the analysis into a compelling retailer story.

AI can accelerate every step—but you remain responsible for the evidence and final commercial judgment.

Wrap-Up

The real power of AI in category management is not producing more words. It is helping you move faster from data → hypothesis → insight → action → commercial decision.

Use this vault to challenge your thinking, structure retailer reviews, diagnose performance, generate sharper hypotheses, quantify opportunities, improve recommendations, and build more persuasive category stories.

Use this asset to instantly shortcut category analysis.