Examples
Examples
Try the starting example
- Filter definitions: category, attribute key, allowed options joined by |
- apparel,color,red|blue|green apparel,material,cotton|wool
- Products: SKU, category, key=value attributes joined by |
- A,apparel,color=red|material=cotton B,apparel,color=blue|material=NA C,apparel,color=NA|material=wool
- Valid filter-value coverage per category/key (%)
- apparel/color: 66.6666666667; apparel/material: 66.6666666667
- Allowed options with no matching products
- apparel/color: green
- Values outside declared filter options
- None
- Products valid on every category filter (%)
- 33.333333
Try another scenario
- Filter definitions: category, attribute key, allowed options joined by |
- apparel,color,red|blue|green apparel,material,cotton|wool
- Products: SKU, category, key=value attributes joined by |
- A,apparel,color=red|material=cotton B,apparel,color=blue|material=cotton C,apparel,color=blue|material=wool
- Valid filter-value coverage per category/key (%)
- apparel/color: 100; apparel/material: 100
- Allowed options with no matching products
- apparel/color: green
- Values outside declared filter options
- None
- Products valid on every category filter (%)
- 100
Calculation method
Calculation method
Valid filter-value coverage per category/key (%)
For each filter count same-category products with one present declared option / same-category product count.
Allowed options with no matching products
List declared options not present on any product in that category.
Values outside declared filter options
Flag present product values outside the filter’s allowed set; do not silently coerce them.
Products valid on every category filter (%)
Count products with a valid option for every defined filter in their category.
Symbols and units
- a
- Filter definitions: category, attribute key, allowed options joined by |
- b
- Products: SKU, category, key=value attributes joined by |
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 single-value-per-attribute filter audit with declared categories and option sets. It does not infer taxonomy, synonyms, sizes or whether a product’s supplied value is true.
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.