SKU Accuracy by Client

Description

Retrieves the monthly average SKU Accuracy by client and outlet classification.


Query :

SELECT
    DATENAME(MONTH, ap.CreatedOn) AS [Month],
    l.Assortment2,
    AVG(ap.SKUAccuracy) AS SKUAccuracy,
    ap.ClientId
FROM AssetPurity ap
INNER JOIN Location l
    ON ap.LocationId = l.LocationId
WHERE ap.ClientId = 213
  AND ap.Isdeleted = 0
  AND ap.CountryId = 6
  AND ap.CreatedOn >= '2026-06-01'
  AND ap.CreatedOn < '2026-09-01'
  AND ap.SKUAccuracy is NOT NULL
  AND ap.SKUAccuracy != 0
GROUP BY
    MONTH(ap.CreatedOn),
    DATENAME(MONTH, ap.CreatedOn),
    l.Assortment2,
    ap.ClientId
ORDER BY
    MONTH(ap.CreatedOn),
    l.Assortment2;