Product and Category Analytics | Audit and Experimentation Prompt

What this prompt helps you do

Audit an existing page, process, dataset, or asset, separate facts from assumptions, and turn the highest-priority issues into tests with baselines, metrics, and stop conditions.

Prompt text

Act as a ecommerce assortment and profitability analyst and audit the current [Page/Process/Data/Asset] related to the objective: evaluate SKU and category performance across sales, profit, inventory, returns, advertising, and cross-purchase. Materials: [SKU sales], [Cost], [Inventory], [Returns], [Advertising and basket data]. Classify findings as Blocking, Major, Moderate, or Optimization, and quote the evidence that triggers each finding. Provide: (1) an issue list; (2) Product tiers, Profit contribution, Inventory efficiency, Bundling opportunities, Expand or discontinue recommendation; (3) at least four improvements or experiments prioritized by impact versus effort; (4) for each experiment, the hypothesis, change, primary metric, guardrail metrics, observation period, and stopping rule; and (5) required human approvals before publishing or execution. Special requirement: Do not rank only by revenue. Include contribution profit, cash tied up, returns, and strategic role.