Weekly Audit

{
  "executive_summary": "Week ending 2026-07-20 reveals a portfolio with polarized performance: top ASINs (B0DFLZV31S, B0F8NDL1NC, B0917J3QZK) drive strong revenue with 33-96% conversion rates, while two critical underperformers (B0D83NMK9V at 7.61% CVR, B0C18TNQ12 at 9.51% CVR) waste 657 sessions/week. Urgent inventory crisis: B0C6J5WH58 and B09FLSDQWS are stockout, with B0CKFFP5RW and B0C8FWV29T at critical low stock. Ad waste exceeds ₹12,000 on zero-conversion terms. Immediate actions: restock 4 ASINs, add 6 negative keywords, price-test 2 underperformers, scale budget on 5 winners.",
  "top_winners": [
    {
      "asin": "B0DFLZV31S",
      "reason": "₹194,893 revenue, 33.94% CVR, 822 sessions - highest revenue driver",
      "action": "Increase SP ad spend by ₹500/day; strong scale opportunity"
    },
    {
      "asin": "B0F8NDL1NC",
      "reason": "95.77% conversion rate, ₹77,807 revenue - exceptional efficiency",
      "action": "Increase SP ad spend by ₹400/day; capture more high-intent traffic"
    },
    {
      "asin": "B0917J3QZK",
      "reason": "64.14% CVR, ₹86,483 revenue, 382 sessions - strong performer",
      "action": "Increase SP ad spend by ₹350/day to scale volume"
    },
    {
      "asin": "B09G3LDHB6",
      "reason": "80.68% CVR, ₹45,021 revenue - highly efficient conversion",
      "action": "Increase SP ad spend by ₹300/day"
    },
    {
      "asin": "B08NJJKSMK",
      "reason": "51.08% CVR, ₹67,658 revenue, 417 sessions - solid volume",
      "action": "Increase SP ad spend by ₹250/day"
    }
  ],
  "silent_losers": [
    {
      "asin": "B0D83NMK9V",
      "reason": "7.61% CVR catastrophic - 394 sessions yielding only 30 units vs potential 120+; ₹17,827 revenue loss vs benchmark",
      "action": "Price test: reduce from ₹683 to ₹615 (10% off); audit listing images and title"
    },
    {
      "asin": "B0C18TNQ12",
      "reason": "9.51% CVR - 263 sessions wasting traffic; cycle brake set with low conversion vs category",
      "action": "Price test: reduce from ₹420 to ₹379; optimize title for 'cycle brake set' keywords"
    },
    {
      "asin": "B09YY2BRFD",
      "reason": "16.27% CVR below portfolio average; 209 sessions underperforming",
      "action": "Improve A+ content and solicit reviews; test price point at ₹320"
    },
    {
      "asin": "B0C6J5WH58",
      "reason": "14.32% CVR with 419 sessions - now stockout, lost all momentum",
      "action": "URGENT: Restock 300 units via air shipment"
    },
    {
      "asin": "B0GL85NRK7",
      "reason": "25.49% CVR with 153 sessions - below average conversion",
      "action": "Optimize main image and title; improve bullet points"
    },
    {
      "asin": "B08RY2SQRR",
      "reason": "30.15% CVR with 136 sessions - moderate underperformance",
      "action": "Refresh A+ content and bullet points"
    }
  ],
  "hidden_opportunities": [
    {
      "asin": "B0DHZF92GZ",
      "opportunity": "82.01% CVR with ₹40,313 revenue - no identified ad gaps, organic strength",
      "action": "Launch Sponsored Products campaign with ₹250/day budget"
    },
    {
      "asin": "B0DSHTJTH8",
      "opportunity": "94.29% CVR but only 35 sessions - high efficiency, low visibility",
      "action": "Increase ad visibility; expand keyword targeting"
    },
    {
      "asin": "B0837TJ1TJ",
      "opportunity": "93.42% CVR with 76 sessions - exceptional conversion, scale potential",
      "action": "Increase ad spend by ₹200/day to drive session volume"
    },
    {
      "asin": "B0GP6MY57F",
      "opportunity": "91.67% CVR with 60 sessions - untapped scale opportunity",
      "action": "Launch SP campaign targeting category keywords"
    },
    {
      "asin": "B08T7GYS21",
      "opportunity": "311.11% CVR (attribution anomaly) with 9 sessions - investigate and scale",
      "action": "Analyze attribution; if valid, aggressively scale ad spend"
    }
  ],
  "pricing_actions": [
    {
      "asin": "B0D83NMK9V",
      "current_price": 683,
      "suggested_price": 615,
      "reason": "7.61% CVR indicates price resistance; 10% reduction should improve CVR to 12-15%"
    },
    {
      "asin": "B0C18TNQ12",
      "current_price": 420,
      "suggested_price": 379,
      "reason": "9.51% CVR on cycle brake set; test ₹379 to match competitor positioning"
    }
  ],
  "keyword_actions": [
    {
      "asin": "B0D83NMK9V",
      "keyword": "hand gripper 100kg",
      "action": "Add as negative exact keyword - ₹349 spent, 73 clicks, 0 orders",
      "expected_impact": "Save ₹500/week in wasted ad spend"
    },
    {
      "asin": "PORTFOLIO",
      "keyword": "b0ccd8gjh8",
      "action": "Add negative exact across all campaigns - ₹1,386 wasted",
      "expected_impact": "Immediate savings of ₹1,400/week"
    },
    {
      "asin": "PORTFOLIO",
      "keyword": "knee support for men gym",
      "action": "Add negative phrase - ₹1,186 spent, 0 orders",
      "expected_impact": "Save ₹1,200/week"
    },
    {
      "asin": "PORTFOLIO",
      "keyword": "parallettes for calisthenics",
      "action": "Add negative exact - product mismatch, ₹747 wasted",
      "expected_impact": "Save ₹750/week"
    },
    {
      "asin": "PORTFOLIO",
      "keyword": "reflex ball",
      "action": "Add negative phrase - ₹723 spent, wrong intent",
      "expected_impact": "Save ₹700/week"
    },
    {
      "asin": "PORTFOLIO",
      "keyword": "gym gloves for men workout",
      "action": "Add negative phrase - ₹720 spent, 0 orders",
      "expected_impact": "Save ₹700/week"
    },
    {
      "asin": "ALL_KNEE_PRODUCTS",
      "keyword": "knee cap men",
      "action": "Optimize listings for organic rank - currently spending ₹13,285 with no organic position",
      "expected_impact": "Reduce ad dependency by 30% over 60 days"
    },
    {
      "asin": "ALL_GRIP_PRODUCTS",
      "keyword": "gym grips",
      "action": "Build organic rank - ₹10,271 ad spend with zero organic visibility",
      "expected_impact": "Improve organic position to top 20 within 30 days"
    },
    {
      "asin": "ANKLE_STRAP_PRODUCTS",
      "keyword": "ankle strap for gym",
      "action": "Listing optimization for organic - ₹8,049 ad dependency",
      "expected_impact": "Achieve page 1 organic rank"
    }
  ],
  "inventory_risks": [
    {
      "asin": "B0C6J5WH58",
      "risk": "STOCKOUT - 0 available, 0 reserved. Was selling 60 units/week (₹75,115 revenue). BSR momentum destroyed.",
      "action": "URGENT: Restock 300 units via air shipment within 7 days"
    },
    {
      "asin": "B09FLSDQWS",
      "risk": "STOCKOUT - 0 available. Historically 104.88% CVR, strong performer.",
      "action": "URGENT: Restock 200 units via air shipment"
    },
    {
      "asin": "B0CKFFP5RW",
      "risk": "CRITICAL LOW STOCK - 1 unit available, 0 reserved. 55% CVR, 22 units in 6 days.",
      "action": "Restock 150 units via sea shipment; expedite if possible"
    },
    {
      "asin": "B0C8FWV29T",
      "risk": "CRITICAL LOW STOCK - 9 available, 1 reserved. 88% CVR - will stockout within days.",
      "action": "Restock 150 units via air shipment immediately"
    },
    {
      "asin": "B0FG82VQTS",
      "risk": "LOW STOCK - 8 available, 6 reserved. 58.18% CVR, high velocity.",
      "action": "Restock 120 units via sea shipment"
    },
    {
      "asin": "B0FG81VR96",
      "risk": "LOW STOCK - 5 available, 10 reserved. Demand exceeds supply. 59.38% CVR.",
      "action": "Restock 150 units via air shipment"
    }
  ],
  "competitive_threats": [
    {
      "asin": "B0D83NMK9V",
      "threat": "Low conversion (7.61%) suggests aggressive competitor pricing on hand grippers. Search results dominated by established brands.",
      "action": "Monitor competitor prices daily; implement dynamic pricing rule"
    },
    {
      "asin": "B0C18TNQ12",
      "threat": "Cycle brake set niche may have new entrants with lower prices causing CVR drop to 9.51%.",
      "action": "Track top 5 competitor ASINs weekly; adjust pricing strategy"
    }
  ]
}