Weekly Audit

All opportunities have been flagged. Now I'll generate the final JSON report:

{
  "executive_summary": "Weekly audit reveals three critical conversion issues wasting high traffic: B0D83NMK9V (1.76% conv, 7,461 sessions), B0C18TNQ12 (2.5% conv, 5,605 sessions), and B0C6J5WH58 (2.74% conv, 6,099 sessions) represent ₹700K+ in lost revenue potential. Immediate listing fixes required. Ad waste totals ₹47K+ monthly on zero-conversion terms like 'knee support for men gym' (₹6,021). Top winners B0F8NDL1NC (25.99% conv, ₹284K revenue) and B0917J3QZK (19.69% conv, ₹419K revenue) should be scaled aggressively. B08RCMKV3G shows exceptional 30.1% conversion but only 2.04% click share - massive untapped potential.",
  "top_winners": [
    {"asin": "B0917J3QZK", "reason": "19.69% conversion, ₹419,237 revenue, 1,192 units. Dominates 'ankle cuff for cable machine' (77.78% purchase share)", "action": "Increase ad budget 40% - target ACOS 25%"},
    {"asin": "B0F8NDL1NC", "reason": "25.99% conversion, ₹284,536 revenue, 1,078 units. Strong on 'gym grips for men' (41.98% purchase share)", "action": "Increase ad budget 50% - target ACOS 20%"},
    {"asin": "B08RCMKV3G", "reason": "30.1% conversion (highest in catalog) but only 412 sessions. Only 2.04% click share on 'gym gloves for woman' indicates scaling opportunity", "action": "Double ad budget immediately - target ACOS 18%"},
    {"asin": "B0DHZF92GZ", "reason": "25.06% conversion, ₹172,407 revenue, 493 units. Strong efficiency metrics", "action": "Increase ad budget 35% - target ACOS 22%"},
    {"asin": "B083FX5V8Q", "reason": "21.35% conversion, ₹56,646 revenue from only 740 sessions. High efficiency", "action": "Increase ad budget 40% - target ACOS 24%"},
    {"asin": "B085HT7MCN", "reason": "24.43% conversion, ₹58,207 revenue. Efficient with room to scale", "action": "Increase ad budget 50% - target ACOS 20%"}
  ],
  "silent_losers": [
    {"asin": "B0D83NMK9V", "reason": "CRITICAL: 1.76% conversion with 7,461 sessions. Losing 7,330 potential customers. SQP shows poor 'hand gripper 100kg' performance (0.29% purchase share)", "action": "URGENT listing audit: check pricing (₹683), images, reviews, title optimization. Potential ₹300K revenue recovery"},
    {"asin": "B0C18TNQ12", "reason": "CRITICAL: 2.5% conversion with 5,605 sessions, ₹57,771 revenue. High traffic waste", "action": "URGENT listing audit: price ₹420 may be uncompetitive. Check images and review rating"},
    {"asin": "B0C6J5WH58", "reason": "CRITICAL: 2.74% conversion with 6,099 sessions yet ₹207,676 revenue shows demand exists. Biggest revenue opportunity", "action": "URGENT listing audit: pricing, images, variant availability. Potential ₹400K revenue recovery"},
    {"asin": "B09YY2BRFD", "reason": "4.93% conversion with 4,423 sessions - below optimal. Price ₹320", "action": "Listing audit: pricing vs competitors, image quality, review analysis"},
    {"asin": "B0G1H1WDGV", "reason": "3.29% conversion with 2,159 sessions, only 16 days of data. Newer listing underperforming", "action": "Optimize title, images, pricing. Implement review generation strategy"}
  ],
  "hidden_opportunities": [
    {"asin": "B08RCMKV3G", "opportunity": "Ranks with 30.1% conversion but only 2.04% click share on 'gym gloves for woman' (7,448 impressions). Massive untapped traffic", "action": "Aggressive ad scaling + title optimization for 'gym gloves for woman'"},
    {"asin": "B0917J3QZK", "opportunity": "Dominates niche keywords: 'ankle cuff for cable machine' 77.78% purchase share, 'wrist cuffs for gym' 45.83% purchase share", "action": "Expand to related keywords, increase bids on winning terms"},
    {"asin": "B0F8NDL1NC", "opportunity": "Strong on 'lifting grip for gym' (60% purchase share) but spending ₹21,772 on 'gym grips' with no organic ranking", "action": "Optimize title for 'gym grips' to reduce ad dependency"},
    {"asin": null, "opportunity": "Spending ₹21,970 on 'gym gloves for men workout' with no organic ranking - catalog gap or optimization needed", "action": "Audit if relevant products exist; optimize B08RCMKV3G or add new SKU"},
    {"asin": null, "opportunity": "Ad waste from ASIN searches: 'b0ccd8gjh8' (₹4,564), 'b0dxkkzlwk' (₹2,416), 'b09dq1kd58' (₹2,119) - competitors not converting", "action": "Add all ASIN search terms as negative keywords"}
  ],
  "pricing_actions": [],
  "keyword_actions": [
    {"asin": null, "keyword": "knee support for men gym", "action": "ADD NEGATIVE EXACT - ₹6,021.90 spent, 437 clicks, 0 orders", "expected_impact": "Save ₹6,000/month"},
    {"asin": null, "keyword": "gym gloves for men workout", "action": "ADD NEGATIVE EXACT - ₹4,345.18 spent, 576 clicks, 0 orders", "expected_impact": "Save ₹4,300/month"},
    {"asin": null, "keyword": "b0ccd8gjh8", "action": "ADD NEGATIVE EXACT - ₹4,564.33 spent (competitor ASIN), 0 orders", "expected_impact": "Save ₹4,500/month"},
    {"asin": null, "keyword": "gym bag for women", "action": "ADD NEGATIVE EXACT - ₹3,059.99 spent, 327 clicks, 0 orders", "expected_impact": "Save ₹3,000/month"},
    {"asin": null, "keyword": "reflex ball", "action": "ADD NEGATIVE EXACT - ₹2,981.96 spent, 289 clicks, 0 orders", "expected_impact": "Save ₹3,000/month"},
    {"asin": null, "keyword": "punching bag for home", "action": "ADD NEGATIVE EXACT - ₹1,409.68 spent, 517 clicks, 0 orders", "expected_impact": "Save ₹1,400/month"},
    {"asin": "B0F8NDL1NC", "keyword": "gym grips", "action": "Optimize title - move 'gym grips' to front. Currently spending ₹21,772 with no organic rank", "expected_impact": "Reduce ad spend by 30%, improve organic rank"},
    {"asin": null, "keyword": "gym gloves for men workout", "action": "Catalog audit - ₹21,970 spent but no organic visibility. Determine if product gap exists", "expected_impact": "Identify new SKU opportunity or fix existing listing"}
  ],
  "inventory_risks": [],
  "competitive_threats": []
}