实体产品经营指标体系设计
把销售、退货、质量与单件利润串成指标树,给出计算口径、数据来源、预警规则和复盘安排。
完整提示词
<context>
You define the KPIs a product manager or small brand uses to run a physical product line. Unlike software, the cost of a quality problem arrives months later as returns, warranty claims and bad reviews, and it eats margin unit by unit. Teams often track revenue and star rating, and miss that a model with a good rating has a 14% return rate in one channel, or that warranty cost per unit has doubled for one production batch.
The set should link sales, customer and quality signals to margin per unit, with definitions precise enough that two people compute the same number.
</context>
<task>
<product_line>
{{product_line}}
</product_line>
<channels>
{{channels}}
</channels>
{{#available_data}}
<available_data>
{{available_data}}
</available_data>
{{/available_data}}
1. Draw a KPI tree in text: contribution margin per unit at the top, broken into price after discounts, landed cost, channel fees, cost of returns and warranty cost; with sales and customer drivers beside it.
2. Define each KPI with an exact formula and time basis:
- Sell-through = units sold to end customers in the period / units available (opening stock + received) in that channel, by SKU.
- Return rate = units returned / units sold, by the month of sale (cohort), not the month of return; with reason codes (defect, not as described, size or fit, damaged in transit, changed mind).
- Field failure rate = failures reported / units sold, by months in service (0-3, 4-12, 13-24), and by production batch where known.
- Warranty cost per unit sold = claims cost (parts, labour, shipping, replacements) / units sold in the matching cohort.
- Rating trend = rolling 90-day average rating and count, by model and channel, plus share of 1-2 star reviews mentioning quality.
- Contribution margin per unit after returns and warranty.
- Attach rate = orders including an accessory or consumable / orders with the main product.
Add a stock measure (weeks of cover) if supply is a concern.
3. Data sources: the system or report for each, its lag (retailer sell-out often arrives weeks late) and the owner.
4. Alert thresholds relative to the product's own baseline: for example return rate up by a quarter on the trailing 13-week cohort average, any batch whose 0-3 month failure rate is double the line average, and any safety-related failure (fire, burns, shock, choking, sharp edges) as an immediate alert regardless of count.
5. Review routine: weekly sales and stock, monthly quality and margin by SKU and channel, quarterly line review deciding fix, reprice, reposition or discontinue.
</task>
<constraints>
- Do not invent industry benchmarks or "normal" return rates; thresholds are relative to the product's own baseline until there is history.
- Use the product's real channels; do not add channels that are not listed.
- Safety-related failures go to whoever is responsible for product safety straight away; product safety reporting duties differ by country, so say to check them.
- If the products or channels are not described, ask for them and stop.
</constraints>
<output_format>
## KPI tree
An indented text tree.
## KPI definitions
Table: KPI | formula | cohort or period basis | split by | why it matters.
## Data sources
Table: KPI | source | lag | owner.
## Alert thresholds
Table: KPI | alert rule | who is alerted | first action.
## Review routine
Weekly, monthly and quarterly agendas as short lists.
## Gaps and questions
Data you cannot yet get and what to confirm.
</output_format>可替换内容
- {{product_line}}
- {{channels}}
- {{#available_data}}
- {{available_data}}
- {{/available_data}}
分类与标签
商业营销、产品经营、质量监测、退货分析、指标体系、经营复盘