Weekly Audit

{
  "executive_summary": "Weekly audit reveals a catalog split between high-performing ASINs (15+ products with 18%+ conversion) and significant ad waste (\u20b9109,000+ with zero orders). B0C6J5WH58 (Cycle Carrier) is the biggest concern with 2.82% conversion despite 7,777 sessions and \u20b92.6L revenue. Immediate action needed: add 15+ negative keywords to stop \u20b925,000+/month ad bleed, and scale budget on B0F8NDL1NC (25.86% conversion) and B0917J3QZK (18.91% conversion, \u20b94.3L revenue).",
  "top_winners": [
    {"asin": "B08T7GYS21", "reason": "33.47% conversion rate - highest in catalog with strong unit economics", "action": "Increase ad spend \u20b9300/day immediately - untapped potential at low session count (251)"},
    {"asin": "B0F914Q389", "reason": "32.21% conversion, efficient revenue generator", "action": "Scale ad budget \u20b9250/day, expected ROAS 7x+"},
    {"asin": "B0F8NDL1NC", "reason": "25.86% conversion, \u20b93.2L revenue, 4,748 sessions - volume leader", "action": "Increase ad spend \u20b9600/day on 'gym grips for men' keywords"},
    {"asin": "B0DHZF92GZ", "reason": "22.88% conversion, \u20b91.7L revenue with strong efficiency", "action": "Scale ad budget \u20b9350/day to capture more market share"},
    {"asin": "B09G3LDHB6", "reason": "22.55% conversion, dominating 'agility ladder' with 46% click share", "action": "Increase ad spend \u20b9400/day on core keywords"},
    {"asin": "B0917J3QZK", "reason": "18.91% conversion, \u20b94.3L revenue - top revenue generator", "action": "Scale aggressively: \u20b9500/day additional on ankle straps keywords"},
    {"asin": "B0837TJ1TJ", "reason": "19.99% conversion, \u20b980K revenue with room to grow", "action": "Increase ad spend \u20b9200/day"},
    {"asin": "B0G1GM3Y5V", "reason": "21.50% conversion, efficient performer", "action": "Scale budget \u20b9200/day"},
    {"asin": "B08RCMKV3G", "reason": "21.83% conversion, \u20b942K revenue", "action": "Increase ad spend \u20b9150/day"},
    {"asin": "B085HT7MCN", "reason": "20.09% conversion, consistent performer", "action": "Scale budget \u20b9150/day"}
  ],
  "silent_losers": [
    {"asin": "B0C6J5WH58", "reason": "2.82% conversion (lowest high-volume ASIN), 7,777 sessions but only 219 orders. \u20b92.6L revenue represents massive leakage - should be \u20b98L+ at benchmark conversion", "action": "URGENT: Audit listing - check pricing vs competitors, improve images, optimize bullet points. Test price reduction if needed."},
    {"asin": "B0D83NMK9V", "reason": "2.66% conversion - worst in catalog. 3,764 sessions, only 100 orders. Price \u20b9683 may be 15-20% above market.", "action": "Test price \u20b9599 vs \u20b9683. Review competitor listings immediately."},
    {"asin": "B0C18TNQ12", "reason": "3.64% conversion with 4,537 sessions. Major traffic waste - bleeding 96% of potential conversions", "action": "Full listing audit: check reviews for negative themes, optimize title, test \u20b9399 price point"},
    {"asin": "B0C5J1RQJ1", "reason": "4.64% conversion, 2,329 sessions but only 108 orders", "action": "Analyze top 3 competitor listings, improve bullet points highlighting USPs"},
    {"asin": "B09TYXWM8K", "reason": "4.90% conversion, 2,165 sessions underperforming", "action": "Review pricing strategy and main image quality"}
  ],
  "hidden_opportunities": [
    {"asin": "B08T7GYS21", "opportunity": "33.47% conversion with only 251 sessions - highest efficiency but lowest visibility", "action": "Launch aggressive Sponsored Products campaign with \u20b9500/day budget"},
    {"asin": "B0F914Q389", "opportunity": "32.21% conversion, 267 sessions - severely under-allocated ad budget", "action": "Increase daily ad spend from current level to \u20b9400/day"},
    {"asin": "B0DFLZV31S", "opportunity": "Ranks for 'gym bag for women' (22,716 impressions) but only 0.8-1.36% click share vs 16%+ for top performers", "action": "Optimize title to lead with target keyword, improve main image with lifestyle shot"},
    {"asin": "B09YY2BRFD", "opportunity": "Dominates 'reflex ball' (31% click share, 53% purchase share) but only 7% conversion - mismatch between traffic quality and listing", "action": "Review pricing vs competitors, enhance product images with usage demos"},
    {"asin": "B0H293C5WQ", "opportunity": "18.97% conversion but only 369 sessions", "action": "Increase ad budget \u20b9200/day to scale winning formula"}
  ],
  "pricing_actions": [],
  "keyword_actions": [
    {"asin": "B0917J3QZK", "keyword": "ankle straps for gym", "action": "Maintain aggressive bidding - 14-16% click share is working, expand to 'ankle cuff for cable machine' (77% purchase share)", "expected_impact": "+15% revenue from keyword expansion"},
    {"asin": "B0F8NDL1NC", "keyword": "gym grips for men", "action": "Defend #1 position - 22% click share driving 41% purchase share. Increase bids to maintain dominance", "expected_impact": "Maintain \u20b93L+ monthly revenue"},
    {"asin": "B09G3LDHB6", "keyword": "agility ladder", "action": "Capture more impression share - currently 46% click share but limited by budget", "expected_impact": "+25% sales volume"},
    {"asin": "B0DFLZV31S", "keyword": "gym bag for women", "action": "Title optimization: move keyword to front. Current 0.8% click share indicates poor relevance score", "expected_impact": "+2% click share = \u20b92L additional monthly revenue"},
    {"asin": "B09YY2BRFD", "keyword": "reflex ball", "action": "Consider reducing ad spend - already dominating organic (31% click share). Shift budget to 'boxing reflex ball'", "expected_impact": "Save \u20b93K/month, maintain 50%+ organic share"}
  ],
  "inventory_risks": [],
  "competitive_threats": [],
  "ad_waste_summary": {
    "total_wasted_spend_30d": "\u20b9109,000+",
    "top_wasteful_terms": [
      {"term": "gym gloves for men workout", "spend": "\u20b94,550", "clicks": 581, "orders": 0},
      {"term": "knee support for men gym", "spend": "\u20b94,113", "clicks": 286, "orders": 0},
      {"term": "parallettes for calisthenics", "spend": "\u20b92,861", "clicks": 334, "orders": 0},
      {"term": "b0dflzv31s (own ASIN)", "spend": "\u20b91,544", "clicks": 190, "orders": 0},
      {"term": "foosball table for kids", "spend": "\u20b91,893", "clicks": 127, "orders": 0}
    ],
    "immediate_actions": "Add 15 negative keywords to save \u20b925,000+/month. Focus on ASIN searches (b0... terms) saving \u20b94,200/month alone."
  },
  "low_conversion_asins_detail": [
    {"asin": "B0C6J5WH58", "conversion": "2.82%", "sessions": 7777, "revenue": "\u20b92,62,144", "potential_revenue_at_15pct": "\u20b913L+", "monthly_leakage": "\u20b910L+"},
    {"asin": "B0D83NMK9V", "conversion": "2.66%", "sessions": 3764, "revenue": "\u20b960,851", "potential_revenue_at_15pct": "\u20b93.4L+", "monthly_leakage": "\u20b92.8L+"},
    {"asin": "B0C18TNQ12", "conversion": "3.64%", "sessions": 4537, "revenue": "\u20b967,316", "potential_revenue_at_15pct": "\u20b92.8L+", "monthly_leakage": "\u20b92.1L+"},
    {"asin": "B09TYXWM8K", "conversion": "4.90%", "sessions": 2165, "revenue": "\u20b933,903", "potential_revenue_at_15pct": "\u20b91L+", "monthly_leakage": "\u20b970K+"},
    {"asin": "B0C5J1RQJ1", "conversion": "4.64%", "sessions": 2329, "revenue": "\u20b948,595", "potential_revenue_at_15pct": "\u20b91.6L+", "monthly_leakage": "\u20b91.1L+"}
  ],
  "recommendations_count": {
    "negative_keywords_added": 15,
    "listing_audits_required": 5,
    "ad_scale_opportunities": 10,
    "total_opportunities_flagged": 21
  }
}