Examples
Examples
Try the starting example
- Category/size cells: category, size, units sold, fit-labelled returned units, other returned units
- Dress,M,100,10,5 Dress,L,50,5,5 Shoes,38,20,2,0
- Fit-labelled returns / sold units (%)
- 10
- All returns / sold units (%)
- 15.882353
- Fit-labelled share of returned units (%)
- 62.962963
- Fit-labelled return rate by category (%)
- Dress: 10; Shoes: 10
- Fit-labelled return rate by category/size (%)
- Dress/M: 10; Dress/L: 10; Shoes/38: 10
Try another scenario
- Category/size cells: category, size, units sold, fit-labelled returned units, other returned units
- Dress,M,100,10,5 Dress,L,50,5,5 Shoes,38,20,0,0
- Fit-labelled returns / sold units (%)
- 8.823529
- All returns / sold units (%)
- 14.705882
- Fit-labelled share of returned units (%)
- 60
- Fit-labelled return rate by category (%)
- Dress: 10; Shoes: 0
- Fit-labelled return rate by category/size (%)
- Dress/M: 10; Dress/L: 10; Shoes/38: 0
Calculation method
Calculation method
Fit-labelled returns / sold units (%)
Sum fit-labelled returns / sold units×100.
All returns / sold units (%)
Sum disjoint fit and other returns / sold×100.
Fit-labelled share of returned units (%)
Fit returns / all returned units×100.
Fit-labelled return rate by category (%)
Aggregate supplied cells by category before dividing fit returns by sold units.
Fit-labelled return rate by category/size (%)
For each supplied cell divide fit returns by sold units. Zero denominators stay explicitly undefined.
Symbols and units
- a
- Category/size cells: category, size, units sold, fit-labelled returned units, other returned units
Use the units shown. A list keeps the order in which you enter its values. The symbol ^ means “raised to the power of”.
Assumptions & limits
Assumptions & limits
- A denominator-aware report of reasons already labelled in the supplied records. It does not infer fit, product quality, customer intent or a causal explanation for returns.
Are these inputs private?
These calculations run in your browser. A shared link contains the values you choose to share. Only questions submitted to the separate AI finder are sent to OpenAI.
Further reading
Google Merchant Center: product-data terminology and consistency background ↗
Background reading; this does not imply endorsement or independent review of SumFizz.