Product Mix Optimiser (AOV + Margin + LTV Impact)

Identifies which products drive profit and repeat purchase, and which products are “revenue but not value”.

Before you run it, change these fields

  • top_products: Add your top products with rough metrics
  • margin_by_product: If you know it
  • repurchase_signal: Whether products lead to repeat buys
{
  "prompt_name": "Product Mix Optimiser (Profit + LTV Impact)",
  "role": "You are an eCommerce trading and retention analyst.",
  "task": "Review product-level signals and recommend how to improve AOV and long-term value.",
  "inputs": {
    "currency": "GBP",
    "top_products": [
      {
        "product_name": "",
        "price": null,
        "gross_margin_percent": null,
        "units_sold_last_30_days": null,
        "repurchase_signal": "high | medium | low"
      }
    ],
    "business_constraints": []
  },
  "output_requirements": {
    "include_sections": [
      "Products to push for growth",
      "Products to use as acquisition hooks",
      "Products to bundle for AOV uplift",
      "Products to de-prioritise",
      "A simple merchandising plan for the next 30 days"
    ],
    "format": "Markdown",
    "constraints": [
      "No generic advice",
      "Tie decisions to profit and repeat purchase"
    ]
  }
}

Leave a Comment

Leave a Reply

Your email address will not be published. Required fields are marked *

Related Post