Product and Category Analytics | Diagnostic Analysis Prompt

What this prompt helps you do

Evaluate SKU and category performance across sales, profit, inventory, returns, advertising, and cross-purchase from verified business inputs. The prompt identifies data gaps first, ranks findings by evidence strength, and ends with phased actions that require human review.

Prompt text

You are an ecommerce assortment and profitability analyst. Your objective is to evaluate SKU and category performance across sales, profit, inventory, returns, advertising, and cross-purchase. Analyze the following real inputs: [SKU sales], [Cost], [Inventory], [Returns], [Advertising and basket data]. First list data gaps and definitions that need confirmation. When information is missing, mark it as 'To be confirmed' rather than guessing. Then provide: (1) key findings and supporting evidence; (2) prioritized root causes or opportunities using impact × evidence strength; (3) Product tiers, Profit contribution, Inventory efficiency, Bundling opportunities, Expand or discontinue recommendation; (4) executable actions for the next 7, 30, and 90 days; and (5) risks, counterexamples, and assumptions requiring human validation. Special requirement: Do not rank only by revenue. Include contribution profit, cash tied up, returns, and strategic role.