Ecommerce collection overlap analysis calculator

Calculate pairwise shared product counts and pairwise Jaccard overlap with your own figures.

Your numbers

Use the units shown. Results update as you change valid inputs.

Use pairwise shared product counts and pairwise Jaccard overlap to compare changes to your inputs. The method and limits below explain the scope.

Examples

Examples

Try the starting example

Collections: name, product IDs joined by | or none
C1,A|B|C C2,B|C|D C3,C|D|E
Pairwise shared product counts
C1/C2: 2; C1/C3: 1; C2/C3: 2
Pairwise Jaccard overlap (%)
C1/C2: 50; C1/C3: 20; C2/C3: 50
Distinct products across all collections
5
Products exclusive to each collection
C1: A; C2: None; C3: E
Products present in multiple collections
B, C, D

Try another scenario

Collections: name, product IDs joined by | or none
C1,A|B|C C2,B|C|D
Pairwise shared product counts
C1/C2: 2
Pairwise Jaccard overlap (%)
C1/C2: 50
Distinct products across all collections
4
Products exclusive to each collection
C1: A; C2: D
Products present in multiple collections
B, C
Calculation method

Calculation method

Pairwise shared product counts

Count product-ID intersection for every unordered collection pair.

Pairwise Jaccard overlap (%)

Intersection/union×100; two empty sets are explicitly undefined rather than assumed identical.

Distinct products across all collections

Count the union of all supplied product IDs.

Products exclusive to each collection

List IDs in one collection and absent from every other supplied collection.

Products present in multiple collections

List IDs with membership in at least two collections.

Symbols and units
a
Collections: name, product IDs joined by | or none

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 provided-ID assortment overlap audit with no similarity inference. Results depend on consistent product identity and the set of collections supplied.
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.

Share this page
Share this calculator

Leave unchecked to share the page without your entered values.