Salesforce B2C Commerce 19.2 > Merchandising Your Site > Marketing Analysis > Active Merchandising > Active Data Attributes

SKU Coverage

SKU Coverage is the normalized ratio between the total number and the number of available variants of a product master. SKU Coverage is the same for all sites that share an Inventory list, so it's a site-specific value.

SKU Coverage:

Standard Product

Master Product

The SKU coverage for a master product is equal to the average of all the product variations.

SKUCoverage(mp) = SUM(SKUCoverage(vpX)) / X

Where:

Example 1: All Products in Stock

  X-Small Small Medium Large X-Large
black sweatshirt orderable online orderable online orderable online orderable online orderable online
gray sweatshirt orderable online orderable online orderable online orderable online orderable online

In this case, there are 10 variation products. To calculate SKUCoverage, divide the number of variation products that are available to sell online (10) by the total number of variation products (10): 10/10=1.0

Example 2: Not All Products in Stock

Variation products

InStock: true

  X-Small Small Medium Large X-Large
black sweatshirt orderable online sold out online orderable online sold out online orderable online
gray sweatshirt orderable online orderable online sold out online orderable online orderable online

In this case, there are 10 variation products. To calculate SKUCoverage, divide the number of variation products that are available to sell online (7) by the total number of variation products (10): 7/10-.7

Product Bundle

Example 1: Not All Products in Stock

Products in bundle

Product 1 - InStock: true

Product 2 - InStock: false

Product Bundle SKUCoverage: 0.0

Example 2: All Products in Stock

Products in bundle

Product 1 - InStock: true

Product 2 - InStock: true

Product Bundle SKUCoverage: 1.0

Product Set

The SKU coverage for a product set is the ratio of orderable SKUs in the product set over the total number of online SKUs in the product set.

Product Set Example:

Product Set Type SKU Orderable Online
Set Product 1 Variation      
    SKU-1 1 TRUE
    SKU-2 0 FALSE
    SKU-3 1 TRUE
Set Product 2 Variation      
    SKU-4 0 TRUE
    SKU-5 0 TRUE
    SKU-6 1 TRUE
Set Product 2 Standard SKU-7 1 TRUE

Total number of online SKU's in product set: 6

Number of orderable SKU's in the product set: 4

SKUCoverage of product set: 4/6 = 0.66