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 over 2 months ago

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