INVENTORY & DEMAND PLANNING
-
“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. -
“Show me the top 5 fastest-selling products with fewer than 10 days of inventory left and high forecasted demand.”
→ Trigger urgent restock decisions. -
“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. -
“List products with high stock, low margin, and declining conversion rates over the last 14 days.”
→ Suggest discounting or bundling opportunities. -
“Identify SKUs where sell-through is below 20%, but ad spend remains above $500 per week.”
→ Flag inefficient spend tied to dead stock.
MARKETING PERFORMANCE
-
“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. -
“Show me campaigns where CAC has increased more than 20% WoW but ROAS is still above break-even.”
→ Assess sustainable spend escalation. -
“Identify campaigns or ad sets with the highest conversion rates (CVR) across paid and email channels.”
→ Optimise creative direction. -
“Highlight any Google Ads campaigns with diminishing returns over the last 7 days.”
→ Investigate channel and campaign underperformance. -
“Which ad campaigns are driving high traffic but low product add-to-carts?”
→ Suggest landing page or PDP testing.
PROFITABILITY & FINANCIALS
-
“What’s the projected profit for this month based on current sales trends, ad spend, and discounting activity?”
→ Real-time profitability forecasting. -
“Which product categories are driving the highest gross margin dollars over the past 30 days?”
→ Reallocate focus and budget to top performers. -
“Flag any products selling below breakeven margin after discounts and returns.”
→ Enforce profit guardrails. -
“Compare this week’s blended CAC to the same week last year and alert me if variance exceeds 15%.”
→ Historical benchmarking. -
“Show me which customer segments are least profitable after factoring in returns and discount redemption.”
→ Adjust targeting and offers.
PROCUREMENT & SUPPLY CHAIN
-
“Generate a reorder list for products expected to go below safety stock in the next 21 days.”
→ Smart replenishment. -
“Flag any procurement decisions that could lead to overstock based on trailing 90-day sell-through.”
→ Prevent cash flow traps.