Shopify

Conduct a comprehensive business health audit for my Shopify store over the last 90 days. Start by analyzing overall sales performance including total revenue, order count, average order value, and gross margins after discounts. Segment customers into lifecycle stages: new customers (first purchase in last 90 days), returning customers (2-5 orders), loyal customers (6+ orders), and at-risk customers (no purchase in 60+ days). For each segment, calculate total count, average spend, and contribution to revenue. Analyze product performance by identifying top 20 revenue generators, products with declining sales trends, and slow-moving inventory that might need promotion. Include geographic analysis showing which regions drive the most revenue and have the highest AOV. Finally, examine operational efficiency by tracking unfulfilled orders, payment statuses, and customer acquisition patterns. Present all findings in an executive dashboard with trend charts, segment breakdowns, and actionable recommendations for growth opportunities and areas needing attention

Create a comprehensive customer lifetime value and retention analysis for my Shopify store. Analyze customer purchase patterns over the last 12 months, segmenting by: total spend brackets ($0-50, $50-200, $200-500, $500-1000, $1000+), purchase frequency (1x, 2-3x, 4-6x, 7+ purchases), and recency (purchased within 30, 60, 90, or 180+ days). For each segment, calculate average order value, total lifetime value, purchase frequency, and time between orders. Identify high-value customer characteristics and purchasing patterns. Analyze churn risk by finding customers who typically reorder but haven't purchased recently based on their historical patterns. Include analysis of marketing acceptance rates across different customer segments and correlate this with retention rates. Create cohort analysis showing how customer value evolves over time and identify the most profitable customer acquisition periods. Present insights in an interactive dashboard with retention curves, CLV predictions, and targeted retention strategies for each customer segment.

Perform a comprehensive product performance and inventory optimization analysis for my Shopify store. Analyze sales data for the last 6 months to identify product trends, seasonal patterns, and inventory needs. Categorize all products by performance: star performers (top 20% by revenue), steady sellers (consistent sales), declining products (negative sales trend), and dead stock (no sales in 60+ days). For each category, provide detailed metrics including units sold, revenue generated, average selling price, and sales velocity. Analyze product relationships to identify frequently bought together items and upselling opportunities. Examine geographic preferences to understand regional product performance differences. Include price point analysis to identify optimal pricing strategies and discount effectiveness across different product categories. Track inventory turnover rates and identify products that might need promotional support or discontinuation. Create detailed product scorecards showing profitability, demand trends, and strategic recommendations. Present findings in a comprehensive product management dashboard with performance matrices, trend analysis, and actionable inventory optimization strategies including reorder recommendations and promotional opportunities