Skip to main content

Owly AI - Prompt Library

Get the most out of your data with these proven prompts designed for omnichannel eCommerce businesses

Katie Kirtley Jones avatar
Written by Katie Kirtley Jones
Updated this week

πŸ“¦ 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

Did this answer your question?