Purity Report
The Purity Report compares products in each asset with its assigned planogram. Use foreign-product flags and compliance indicators to identify displays that need review.
Example
Sample Purity Report Entry:
Client: Premium Beverages Corp (ID: CLI-2024-001)
Asset: FRZ-2023-4567 at Downtown Store Alpha
Location: DSA-001 (LOC-001-ALPHA)
Product: Premium Cola 500ml (SKU: PBC-COLA-500ML)
Stock Level: 36 units
Foreign Unit: No
Planogram: Standard Beverage Display 2024 (PLG-BVGS-STD-2024)
Purity Score: 96%
Status: COMPLIANT
Last Modified: 2025-01-31 14:30:22
Note
- Purity scores indicate percentage of authorized products vs. total products.
- Foreign Unit flags immediately identify compliance violations requiring action.
Sample Excel Report
A sample Purity report Excel template is provided here:
Download Purity_Report.xlsx
Note
This template includes Summary/Details/Violations sheets with sample entries for reference.
Delivery and Configuration
- Format: Excel workbook with multiple worksheets (Summary, Details, Violations)
- Delivery Method: Automated email with encrypted attachment
- File Naming: Purity_Report_[ClientCode][LocationCode][YYYY-MM-DD].xlsx
- Frequency: Daily, weekly, or monthly with real-time violation alerts
Key Elements
| Element | Description |
|---|---|
| Client ID | Unique client account identifier |
| Client Name | Organization or company name |
| Asset Purity ID | Unique tracking identifier for compliance analysis |
| Asset ID | Equipment or display unit identifier |
| Asset Serial Number | Physical equipment serial number |
| Location Code | Standardized location identifier |
| Location Name | Human-readable location name |
| Location ID | System-generated unique location identifier |
| Product ID | Internal product identifier |
| SKU | Stock Keeping Unit for inventory tracking |
| Short EAN Code | Abbreviated European Article Number |
| Product Name | Full product description |
| Stock Level | Current inventory quantity |
| Is Foreign Unit | Unauthorized product flag (Yes/No) |
| Planogram ID | Assigned planogram identifier |
| Planogram Name | Descriptive planogram title |
| Image Link | Product image URL reference |
| Last Modified On | Timestamp of last data update |
| Purity Score | Percentage of authorized products |
| Compliance Status | Pass/Fail indicator based on thresholds |
Target Users
- Brand Managers - Protect brand integrity and prevent infiltration
- Store Managers - Maintain planogram standards and compliance
- Equipment Managers - Track asset compliance and proper allocation
Benefits
- Brand Protection: Prevent unauthorized product placement and competitive infiltration
- Compliance Assurance: Maintain contractual obligations with suppliers and retailers
- Revenue Optimization: Ensure premium shelf space allocation for owned products
- Quality Control: Monitor product placement accuracy and display standards
- Risk Mitigation: Early detection of compliance violations and corrective action