Timeframe:
Active: All Data (1 Apr – 15 Jun)
Segment:
Group 1
Visibility Intelligence
Catalog Audit & Revenue Recovery
Overview
Cards update to the selected category level
AD SPEND ON LOW-YIELD CATALOG
₹9.3L
-43.8% WoW(Ad Spend on SKUs with < ₹20 RPV) / (Total Ad Spend) * 100
STARVED HIGH-YIELD WAREHOUSE CAPITAL
₹12.8L
+12.6% WoWStock Value of WH SKUs where RPV > ₹40 AND PDP Views are underaverage
WAREHOUSE-WEIGHTED ZERO TURN INVENTORY
53%
-18% MOM(WH SKUs with 0 Sales * 0.8 weight) + (PM SKUs with 0 Sales * 0.2 weight)
Macro Trend ? Misallocation vs Revenue
Tracked against the three overview metrics for Category Level.
Cluster-Level Analysis
Mutually Exclusive, Collectively Exhaustive(MECE) Product Clusters. Grouping on Type × Price | Fulfillment Time | Age | Inventory Holding
GROUP BY:
Demotion Hit-List
MECE clusters burning traffic → [Marketing] Pause Ads | [Merch] Demote PLP
Promotion Hit-List
Starved MECE clusters → [Marketing] Scale Ads | [Merch] Push to Pg 1
Category Audit Tree
Expand with the caret. 3-level paths stop automatically.
| Category | Decision Metrics | Base Metrics (Proof) | |||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Ad Spend on Low Yield Catalog | Starved High-Yield Warehouse Capital | Warehouse Weighted Zero Turn Inventory | Revenue | PDP Views | Product Count | Ad Spends | Units Sold | Inventory Value | Warehouse Inventory Value | Avg Unit Value | Importance Score | Revenue WhI | Zero Turn WhI | Zero Turn All | Products Whl | Sell Through Value WhI | Zero Turn WhI % | Zero Turn All % | |
L1 root | ₹27.7L | ₹13.3Cr | 71% | ₹40.0Cr | 92,73,817 | 11,761 | ₹77.6L | 24,687 | ₹66.6Cr | ₹24.0Cr | ₹24341.09 | 5.8 | ₹17.0Cr | 1,350 | 9,671 | 2,231 | 24.8% | 68.6% | 80.8% |
L1 root | ₹8.1L | ₹4K | 58% | ₹2.3Cr | 28,95,178 | 25,816 | ₹24.1L | 15,653 | ₹71.8Cr | ₹10K | ₹1679.33 | 4.8 | ₹20K | 1 | 24,917 | 2 | 0.5% | 50% | 90.6% |
L1 root | ₹1.9L | ₹2.1L | 99% | ₹80.9L | 6,30,514 | 12,260 | ₹5.6L | 4,952 | ₹30.7Cr | ₹2.8L | ₹2053.48 | 5.4 | ₹0 | 6 | 11,874 | 6 | 0% | 100% | 95.1% |
L1 root | ₹60K | ₹48.5L | 91% | ₹78.7L | 2,17,035 | 819 | ₹2.2L | 119 | ₹4.7Cr | ₹73.9L | ₹69903.7 | 3.9 | ₹11.6L | 14 | 811 | 15 | 8.5% | 88.9% | 99.5% |
L1 root | ₹2.3L | ₹1K | 98% | ₹68.8L | 11,60,733 | 9,757 | ₹6.8L | 12,031 | ₹21.3Cr | ₹4K | ₹886.63 | 4.9 | ₹0 | 1 | 9,352 | 1 | 0% | 100% | 91.7% |
L1 root | ₹1.3L | ₹30K | 99% | ₹60.0L | 8,08,688 | 22,982 | ₹3.3L | 8,871 | ₹62.6Cr | ₹48K | ₹2607.39 | 4.2 | ₹0 | 2 | 22,445 | 2 | 0% | 100% | 96% |
L1 root | ₹26K | ₹0 | — | ₹23.8L | 1,16,871 | 903 | ₹1.1L | 1,171 | ₹2.9Cr | ₹0 | ₹4986.73 | 4.3 | ₹0 | 0 | 825 | 0 | 0% | — | 91.6% |
L1 root | ₹391.3088 | ₹4K | 0% | ₹1.4L | 7,244 | 2 | ₹2K | 93 | ₹9K | ₹9K | ₹1536 | 4.4 | ₹1.4L | 0 | 0 | 2 | 604% | 0% | 0% |
L1 root | ₹345.832 | ₹0 | — | ₹6K | 812 | 51 | ₹695 | 8 | ₹5.7L | ₹0 | ₹791 | 4.6 | ₹0 | 0 | 51 | 0 | 0% | — | 100% |