π¦ Inventory & Stock Management
Stock Health & Planning
Which products are we forecast to run out of stock in the next 90 days?
What is the total cost value tied up in overstocked products? How much cash could we recover if we liquidate all overstock at a 40% discount?
For SKU [SKU_CODE] - what were the total number of out-of-stock days in the past 90 days and what was the potential revenue loss?
Create a bespoke inventory planning strategy for [SKU_CODE] taking into account lead times, historical sales, and peak periods
Which products should I discontinue vs focus on based on stock turn and profitability?
πͺ Merchandising & Product Performance
Product Analysis
What are my hero products and how do they differ across markets (UK vs US vs EU)?
Rank products from [CATEGORY] by performance (A-star, A, B, C, D) split by season
Are there any products we should cut from our range and any areas we should focus on/expand?
Category & Brand Insights
I'm a category manager for [CATEGORY] - what insights and opportunities can you show me?
Focus on [BRAND] - why is this successful and what are the most popular products in different markets?
Which products should I discount and what is the optimal pricing for [PRODUCT] if we want a 69% gross margin?
π° Finance & Profitability
Margin & Cost Analysis
How can I improve my contribution margin?
Our contribution profit margin is down YTD vs last year - what are the main causes across platforms, countries, and products?
What products are driving the highest vs lowest contribution LTV?
Which products have better contribution margin on Amazon than on Shopify?
Profitability Optimization
Identify my 5 least profitable products and create a 3-month plan to increase their profitability
What would happen to my profitability if I cut ad spend by 25% on my bottom-performing products and re-allocated it to my most best-performing products?
Analyze the metrics impacting profit: revenue, COGS, ad spend, fees, refunds across channels and regions
ποΈ Customer Analytics & Behavior
Customer Segmentation & LTV
Segment my customer base based on LTV, order frequency, repeat rate, products bought, acquisition channel, and discount behavior
Which customer segments deliver the highest profit per marketing dollar?
What is the typical customer purchase behavior for customers from [COUNTRY]? (time between orders, brand loyalty, units per order)
Retention & Growth
What opportunities exist to improve repeat rate in [COUNTRY]?
Do a cohort analysis of lapsed customers (no purchase in 6+ months) - are there patterns in acquisition periods, purchase history, or demographics?
What is the typical time to repurchase and when should I be retargeting customers?
π― Marketing & Growth Strategy
Customer Acquisition & LTV
Which products are most likely to help me acquire high-quality new customers with high LTV?
Generate a comprehensive 3-month plan to improve my LTV:CAC ratio
Looking at the last 12 months, which channels and products work best for acquiring new, high-LTV customers?
Cross-Selling & Upselling
What opportunities do I see to drive AOV in [COUNTRY]?
Analyze products purchased together in the same basket - what are the most common combinations and which should I bundle?
What are the top 3 customer segments bringing in the most revenue, and what email subject lines would drive conversions for each?
π Channel & Marketplace Optimization
Multi-Channel Performance
Analyze my product performance across Amazon and Shopify - which products perform better on each channel and which SKUs should I prioritize where?
Are there products I should stop selling on Amazon because the margin is much lower than Shopify?
Identify cross-channel optimization opportunities to improve overall margin
Geographic Expansion
Analyze my product and channel performance by territory - identify where specific products could be scaled further
Find geographic white-space opportunities - products selling well in one region but not pushed in others
π Business Intelligence & Reporting
Performance Analysis
Create a comprehensive business assessment report analyzing performance over the last 12 months vs previous 12 months
Review all available business performance data and identify the top 3-5 areas requiring immediate attention
What's the biggest risk facing my business right now?
Trend & Competitive Analysis
How does our paid ads performance compare against industry benchmarks when using last click attribution?
This summer compared to last summer, which products have not sold as well and why?
π Returns & Quality Management
Return Analysis
Perform an analysis of refunds for [CATEGORY] - are there certain brands, sizes, or styles with high refund rates?
Are there certain customers more likely to make returns (new vs existing, specific channels, geographies)?
Which [BRAND] SKUs have the highest refunds and what are the most problematic patterns?
π Seasonal & Event Planning
Holiday Optimization
Based on past Black Friday performance, current stock levels, and marketing performance, which products should we feature at what discount?
What can I learn from the Black Friday 2024 period to optimize for this year?
Analyze seasonal trends and identify peak sales periods for inventory planning
π‘ Quick Wins & Daily Operations
Immediate Insights
What is my last 30 days revenue and what are my best-selling products?
Where should I be optimizing my ad spend right now?
Which products tagged with [PRODUCT_TAG] have had no sales in the last 2 weeks?
*π‘ Pro Tips for Better Results:
Be specific with date ranges, countries, and product names
Combine multiple metrics for deeper insights (e.g., analyze LTV, repeat rate, and AOV by customer segment)
Ask follow-up questions to drill down into interesting findings
Use your actual SKU codes, brand names, and country markets for personalized insights*
Break out long complex prompts into shorter more manageable segments