Measure a product's funnel
measure_sku_funnelMeasure product-specific approval, buyout, and return rates from mature order cohorts before decisions, replacing assumed portfolio-wide averages.
Instructions
Measure the observed call-centre approval, post-office buyout, and return rates for one product over a date window, counting only order cohorts old enough to have resolved. Use this before any decision that depends on approval or buyout rates, instead of assuming the portfolio-wide 65% approval and 52.5% buyout. Returns rates together with sample size and a reliability flag, and returns null rates with reliability 'insufficient' rather than a number when the resolved sample is too small to support a conclusion. Read-only.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sku | Yes | Product code as it appears in the snapshot, e.g. 21-183 | |
| window_to | No | ISO date YYYY-MM-DD; defaults to the snapshot date | |
| window_from | No | ISO date YYYY-MM-DD; defaults to the snapshot start | |
| maturity_days | No | Days an order must be old before it counts as resolved. Defaults to FC_COHORT_MATURITY_DAYS (21). Range 0–90. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sku | Yes | ||
| leads | Yes | ||
| window | Yes | ||
| refused | Yes | ||
| approved | Yes | ||
| bought_out | Yes | ||
| min_sample | Yes | ||
| buyout_rate | Yes | ||
| reliability | Yes | ||
| return_rate | Yes | ||
| approval_rate | Yes | ||
| cohort_cutoff | Yes | ||
| maturity_days | Yes | ||
| resolved_orders | Yes | ||
| shipped_resolved | Yes | ||
| excluded_in_flight | Yes | ||
| excluded_still_moving | Yes | ||
| snapshot_generated_at | Yes | ||
| excluded_awaiting_call | Yes | ||
| excluded_immature_cohort | Yes |