Visibility Intelligence

Catalog Audit & Revenue Recovery — Rolling 30 Days

Overview

Top-level KPIs and macro trends

✦ Wastage Recovered (Rolling 30d)
₹11.8L
6 SKUs improved
Σ [ Wastage(T-7) − Wastage(T-0) ] where T-7 > T-0
Active Burn — Visibility Wastage
₹9.3L
-43.8% WoW
Traffic routed into OOS / zero-conversion products
Starved Opportunity — Visibility Deficit
₹12.8L
+12.6% WoW
Revenue left on the table from under-exposed winners

Macro Trend — Misallocation vs Revenue

Green area (above zero) = Visibility Deficit. Red area (below zero) = Visibility Wastage. Gold line = Total Revenue.

Cluster-Level Analysis

MECE Product Clusters — Type × Price groupings

Demotion Hit-List

MECE clusters burning traffic → Demote / Pause Ads

Promotion Hit-List

Starved MECE clusters → Promote P1 / Scale Ads

Where Is Your Traffic Going?

Bubble = stock value. Product IDs labelled. Quadrant labels reveal trapped vs starved inventory.

MECE:
★ STARVED WINNERS
EFFICIENT AT SCALE ★
UNDERPERFORMERS
⚠ TRAPPED INVENTORY
High Efficiency (>6)Mid (3–6)Low / Trapped (<3)

SKU-Level Action Queues

Product-wise alerts with temporal trend

List 1 — Surging Wastage (New Cash Burn)

Filtered by largest absolute ₹ spike in Visibility Wastage over last 7 days (not % change). Catches items rapidly becoming a massive financial problem this week.

Product IDProduct Name8-Wk TrendWastage (7d ago)Wastage (Today)₹ Spike
PRD-0087Sheer Embroidered Curtain – Ivory₹1.5L₹3.0L₹1.5L
PRD-1155Bamboo Storage Jar Set (3pc)₹95K₹2.2L₹1.3L
PRD-5501Round Nesting Side Table – Walnut₹1.1L₹2.1L₹98K
PRD-0993LED Copper Fairy Light 20m₹78K₹1.6L₹84K
PRD-2244Macramé Wall Hanging – Boho₹55K₹1.3L₹75K

List 2 — Emerging Deficits (New Stockouts)

Filtered by largest absolute ₹ spike in Visibility Deficit over last 7 days. Catches starved winners the moment they lose momentum due to a sudden stockout or traffic drop.

Product IDProduct Name8-Wk TrendDeficit (7d ago)Deficit (Today)₹ Spike
PRD-1042Microfiber Comforter – King Grey₹1.8L₹3.4L₹1.6L
PRD-4420Cast Iron Skillet 10″ Preseasoned₹1.2L₹2.6L₹1.4L
PRD-3901Abstract Canvas Print – Set of 3₹95K₹2.1L₹1.2L
PRD-66885-Tier Industrial Bookshelf₹88K₹1.9L₹1.1L
PRD-7712Egyptian Cotton Bath Towel – 600GSM₹72K₹1.7L₹96K

Master Audit Table

Complete catalog data — click headers to sort

■ Decision ■ Scores ■ Base Metrics

ProductDecisionScoresBase Metrics (Proof)
IDProductDeficit ₹Wastage ₹VisibilityVis ROIInv AvailExposureFreshnessDays LiveLive StockInv Cover (d)S/O Days (L30)Avg Views (L7)LT VIP ViewsAd Spend (L30)Own Rev (L30)Halo Rev (L30)Rev/ViewATC Rate %
PRD-0087Sheer Embroidered Curtain₹12K₹3.0L
3.2
1.8
V. HighHighCore Catalog2451,84295d05,8001,82,000₹45K₹18K₹4K
0.8
0.4%
PRD-1155Bamboo Storage Jar Set₹2.2L
2.8
1.2
V. HighHighAgeing3102,200120d06,1002,10,000₹52K₹12K₹4K
0.4
0.2%
PRD-5501Round Nesting Side Table₹2.1L
2.1
0.9
V. HighV. HighAgeing3803,100145d07,2003,20,000₹68K₹9K₹2K
0.4
0.1%
PRD-0993LED Copper Fairy Light 20m₹5K₹1.6L
3.5
2.1
V. HighHighAgeing2901,50088d04,9001,95,000₹38K₹22K₹9K
3.1
1.2%
PRD-2318Stainless Steel Kadhai₹85K₹42K
5.8
5.2
MedMedMaturing9068035d23,10098,000₹18K₹1.4L₹58K
6.5
4.2%
PRD-1042Microfiber Comforter King₹3.4L
8.5
9.1
HighMedCore Catalog18042022d54,2001,45,000₹28K₹2.9L₹92K
8.2
6.8%
PRD-3901Abstract Canvas Print Set₹2.1L
7.9
8.4
MedLowNew Arrival2835018d32,20032,000₹15K₹1.9L₹68K
7.8
5.5%
PRD-4420Cast Iron Skillet 10″₹2.6L
9
9.3
LowLowCore Catalog420858d121,8002,80,000₹8K₹3.1L₹1.3L
9.1
8.2%
PRD-66885-Tier Industrial Bookshelf₹1.9L
8.8
8.9
LowV. LowNew Arrival1412012d89008,500₹5K₹1.8L₹82K
8.9
7.1%
PRD-7712Egyptian Cotton Towel 600G₹1.7L
7.2
7.5
MedMedMaturing7552028d43,4001,12,000₹22K₹1.6L₹52K
5.4
4.8%

Systemic Anomalies

Data collisions flagged for human investigation

List 3 — Systemic Anomalies (Diagnostic Box)

Data collisions requiring human investigation. Click to expand threshold analysis.

PRD-8801Phantom FunnelVelvet Cushion Cover – Emerald
Investigate Checkout
PRD-9902Phantom FunnelCeramic Dinner Plate Set (6pc)
Investigate Checkout
PRD-3345Window ShopperFaux Leather Ottoman – Tan
Investigate PDP
PRD-4456Window ShopperWooden Photo Frame – 8x10
Investigate PDP
PRD-5567Broken HaloDuvet Cover – Geometric Print
Check Set-Matches