Weekly Audit

{
  "executive_summary": "Week of June 8-15, 2026: Strong sales performance across top ASINs with ₹779,696 total weekly revenue. Critical issue identified: ₹5,000+ in weekly ad waste on non-converting search terms including competitor ASINs and irrelevant keywords. Top 5 ASINs drove 1,194 units (35% of catalog volume). Immediate action required on negative keywords to save ~₹3,500/week. No inventory risks detected. 12 ASINs show incomplete data requiring verification.",
  "top_winners": [
    {"asin": "B0F8NDL1NC", "reason": "281 units, ₹77,969 revenue - highest volume ASIN at ₹277 ASP", "action": "Increase ad budget 20%, target Buy Box dominance"},
    {"asin": "B0DFLZV31S", "reason": "212 units, ₹139,026 revenue - highest revenue ASIN at ₹656 ASP", "action": "Scale Sponsored Products, ensure 30+ day inventory cover"},
    {"asin": "B09YY2BRFD", "reason": "268 units, ₹85,757 revenue - strong velocity at ₹320 ASP", "action": "Increase ad budget 20%, push for category bestseller"},
    {"asin": "B08ZYFWXDB", "reason": "218 units, ₹113,491 revenue - high ASP performance at ₹520", "action": "Maintain ad presence, monitor competitor pricing"},
    {"asin": "B0917J3QZK", "reason": "210 units, ₹74,525 revenue - consistent performer at ₹355 ASP", "action": "Optimize for secondary keywords, maintain momentum"}
  ],
  "silent_losers": [
    {"asin": "B07VVYXSG7", "reason": "Only 9 units in 5 days (₹6,111 revenue) despite ₹679 ASP - lowest velocity", "action": "Audit listing quality, check reviews, verify keyword indexing"},
    {"asin": "B0DHLMQ9L8", "reason": "Only 9 units in 5 days (₹4,793 revenue) at ₹532 ASP - underperforming price point", "action": "Check session volume vs conversion; optimize or reduce ad spend"},
    {"asin": "B0CKFD1K7L", "reason": "13 units, ₹3,887 revenue - lowest volume with ₹299 ASP", "action": "Review competitive positioning, consider price adjustment or bundling"},
    {"asin": "B0FHC79NNQ", "reason": "12 units, ₹3,597 revenue in 6 days - weak velocity", "action": "Analyze search term report, optimize listing content"},
    {"asin": "B0DSHTJTH8", "reason": "16 units, ₹4,784 revenue in 6 days at ₹299 ASP - below par", "action": "Check if keyword indexing issues, review main image"}
  ],
  "hidden_opportunities": [
    {"asin": "B0F8NDL1NC", "opportunity": "Scale momentum with increased ad budget - clear winner with strong organic velocity", "action": "Increase daily PPC budget by ₹500, expand to Sponsored Brands"},
    {"asin": "B0DFLZV31S", "opportunity": "High ASP winner (₹656) with ₹139K weekly revenue - maximize share", "action": "Launch Sponsored Brands video campaign, target premium keywords"},
    {"asin": "B0C6J5WH58", "opportunity": "20 units at ₹1,297 ASP (₹25,941 revenue) - highest ASP in catalog", "action": "Increase inventory, scale ads on this premium SKU"},
    {"asin": "B09267QF9V", "opportunity": "16 units at ₹999 ASP (₹15,979 revenue) - strong premium performance", "action": "Optimize for high-value keywords, increase bid on top converters"},
    {"asin": "B097LL3GD5", "opportunity": "22 units at ₹727 ASP (₹15,994 revenue) - above-average ASP", "action": "Expand keyword targeting, test Sponsored Display retargeting"}
  ],
  "pricing_actions": [
    {"asin": "B0F8NDL1NC", "current_price": 279, "suggested_price": null, "reason": "No pricing gaps detected - current price competitive"},
    {"asin": "B0DFLZV31S", "current_price": 626, "suggested_price": null, "reason": "No pricing gaps detected - maintains premium positioning"},
    {"asin": "B09YY2BRFD", "current_price": 320, "suggested_price": null, "reason": "No pricing gaps detected - price point driving strong volume"},
    {"asin": "B08ZYFWXDB", "current_price": 523, "suggested_price": null, "reason": "No pricing gaps detected - competitive at this level"}
  ],
  "keyword_actions": [
    {"asin": "B0DFLZV31S", "keyword": "b0glg2x42f", "action": "Add as negative exact keyword immediately", "expected_impact": "Save ₹356/week, eliminate 124 wasted clicks"},
    {"asin": "B0F8NDL1NC", "keyword": "b09dq1kd58", "action": "Add as negative exact keyword immediately", "expected_impact": "Save ₹302/week, eliminate 153 wasted clicks"},
    {"asin": "CATALOG_WIDE", "keyword": "knee support for men gym", "action": "Add as negative phrase OR optimize relevant ASIN listing", "expected_impact": "Save ₹1,189/week (₹476 waste + ₹713 ad gap) or improve organic rank"},
    {"asin": "CATALOG_WIDE", "keyword": "gym gloves for men workout", "action": "Add as negative phrase OR improve product-keyword match", "expected_impact": "Save ₹670/week (₹274 waste + ₹396 ad gap)"},
    {"asin": "CATALOG_WIDE", "keyword": "reflexes ball", "action": "Evaluate listing fit - if relevant, optimize content; if not, negative keyword", "expected_impact": "Save ₹893/week or achieve organic ranking for ₹893 ad spend"},
    {"asin": "CATALOG_WIDE", "keyword": "gym grips", "action": "Optimize grip-related ASIN for this keyword to achieve organic rank", "expected_impact": "Reduce ₹503 weekly ad dependency through organic presence"},
    {"asin": "CATALOG_WIDE", "keyword": "ankle strap for gym", "action": "Add to relevant ASIN listing content and backend keywords", "expected_impact": "Build organic rank to offset ₹308 weekly ad spend"},
    {"asin": "CATALOG_WIDE", "keyword": "battle rope for gym", "action": "Add as negative exact - category mismatch", "expected_impact": "Save ₹180/week"},
    {"asin": "CATALOG_WIDE", "keyword": "swimming bag for women", "action": "Add as negative exact - category drift", "expected_impact": "Save ₹200/week"},
    {"asin": "CATALOG_WIDE", "keyword": "cycle stand", "action": "Add as negative phrase - cycling category mismatch", "expected_impact": "Save ₹285/week (₹144 + ₹141 related terms)"},
    {"asin": "CATALOG_WIDE", "keyword": "foosball table for kids", "action": "Add as negative exact - gaming category mismatch", "expected_impact": "Save ₹130/week"}
  ],
  "inventory_risks": [],
  "competitive_threats": [
    {"asin": "COMPETITOR_B0GLG2X42F", "threat": "Competitor ASIN b0glg2x42f receiving 124 clicks from your ads - customers comparing", "action": "Add as negative keyword; analyze competitor offer to differentiate"},
    {"asin": "COMPETITOR_B09DQ1KD58", "threat": "Competitor ASIN b09dq1kd58 receiving 153 clicks from your ads", "action": "Add as negative keyword; review their positioning vs yours"}
  ]
}