Prompt Library

4 min. readlast update: 10.27.2025

INVENTORY & DEMAND PLANNING

  1. “Which SKUs have sold below forecast for the past 30 days and are accumulating excess stock?”
    → Spot slow movers for potential markdowns or ad pulls.

  2. “Show me the top 5 fastest-selling products with fewer than 10 days of inventory left and high forecasted demand.”
    → Trigger urgent restock decisions.

  3. “Which products have the highest return rates over the last 90 days, and how do they affect overall margin?”
    → Inform product buying or creative updates.

  4. “List products with high stock, low margin, and declining conversion rates over the last 14 days.”
    → Suggest discounting or bundling opportunities.

  5. “Identify SKUs where sell-through is below 20%, but ad spend remains above $500 per week.”
    → Flag inefficient spend tied to dead stock.

  6. What’s the ideal product mix to maximize both retention and revenue?
    → Helps identify which combination of products keeps customers returning while also producing strong financial outcomes.

  7. Should we focus on improving retention of existing products or launching new ones?
    → Helps prioritize resources: enhance what works or expand assortment strategically.

  8. Show retention curves by product category (and by specific months like May–July)
    → Identifies which product types create loyal, repeat purchasers and how seasonality affects behavior.

MARKETING PERFORMANCE

  1. “Which Meta ad sets are driving the most first-time customers with above-average AOV in the last 7 days?”
    → Double down on efficient acquisition.

  2. “Show me campaigns where CAC has increased more than 20% WoW but ROAS is still above break-even.”
    → Assess sustainable spend escalation.

  3. “Identify campaigns or ad sets with the highest conversion rates (CVR) across paid and email channels.”
    → Optimise creative direction.

  4. “Highlight any Google Ads campaigns with diminishing returns over the last 7 days.”
    → Investigate channel and campaign underperformance.

  5. “Which ad campaigns are driving high traffic but low product add-to-carts?”
    → Suggest landing page or PDP testing.

  6. Compare CLV of customers who start with sale items vs. full-price items
    → Determines whether discount-driven acquisition leads to lower long-term value compared to full-price-first customers.

  7. What is the customer lifetime value over the last 6 months for Category A vs. Category B buyers?
    → Compares product category quality in driving long-term spending and helps optimize marketing toward higher-value categories.

  8. Compare retention rates: customers who bought tops vs. dresses vs. both
    → Reveals whether multi-category shoppers are more loyal than single-category shoppers.

  9. Which products act as ‘gateway products’ that lead to long-term retention?
    → Identifies the best introductory products for new customer acquisition campaigns.

PROFITABILITY & FINANCIALS

  1. “What’s the projected profit for this month based on current sales trends, ad spend, and discounting activity?”
    → Real-time profitability forecasting.

  2. “Which product categories are driving the highest gross margin dollars over the past 30 days?”
    → Reallocate focus and budget to top performers.

  3. “Flag any products selling below breakeven margin after discounts and returns.”
    → Enforce profit guardrails.

  4. “Compare this week’s blended CAC to the same week last year and alert me if variance exceeds 15%.”
    → Historical benchmarking.

  5. “Show me which customer segments are least profitable after factoring in returns and discount redemption.”
    → Adjust targeting and offers.


PROCUREMENT & SUPPLY CHAIN

  1. “Generate a reorder list for products expected to go below safety stock in the next 21 days.”
    → Smart replenishment.

  2. “Flag any procurement decisions that could lead to overstock based on trailing 90-day sell-through.”
    → Prevent cash flow traps.

 

Was this article helpful?