{
  "region": "au",
  "brand": "autograb",
  "fileKeyPrefix": "test-1234/3",
  "data": {
    "dealership_name": "Hilton Garage Ltd",
    "dealership_id": "2beb2399018a469e98786fe0290202de",
    "report_date": "2025-11-04",
    "report_title": "Inventory Intelligence Report - Hilton Garage Ltd",
    "quick_actions": [
      {
        "title": "Liquidate Aged Premium Stock",
        "description": "Immediately send the 2022 Range Rover (439 days) and 2016 Ford Fiesta (296 days) to auction. Based on severe aging (over 8x market average) these units represent significant holding cost and capital drag. | Impact Score: 8.28 (driven by extreme aging pressure)."
      },
      {
        "title": "Re-price Underperforming SUVs",
        "description": "Aggressively re-price the 6 Honda CR-Vs, which are aging 168% slower than the market amid high supply (92 days MDS). Based on limited market evidence (2 similar cars sold recently, you have 6 in stock) a significant price drop is needed to stimulate interest and avoid further holding costs. | Impact Score: 0.90 (high aging pressure + weak market demand)."
      },
      {
        "title": "Protect Margin on Fast Movers",
        "description": "Protect Margin on Fast Movers: Maintain or increase pricing on Skoda Karoq stock. Based on strong market evidence (you have 5 in stock) these are selling 4x faster than competitors in a high-demand segment (26 days MDS), creating an opportunity to maximise gross profit. | Impact Score: 0.52 (driven by strong pricing power opportunity)."
      }
    ],
    "summary_kpis": [
      {
        "name": "Active Listings",
        "caption": "Total vehicles currently for sale on your forecourt.",
        "value": "975",
        "class": ""
      },
      {
        "name": "Median Days Online",
        "caption": "The typical age of your inventory; a low number indicates fresh stock.",
        "value": "14 Days",
        "class": ""
      },
      {
        "name": "% Aged Stock (>60d)",
        "caption": "Percentage of inventory that has been listed for over 60 days.",
        "value": "9.4%",
        "class": ""
      },
      {
        "name": "Aging Index",
        "caption": "Your inventory turns 36% faster than competitors selling a similar mix of cars.",
        "value": "0.64",
        "class": ""
      },
      {
        "name": "Median Price vs Market",
        "caption": "The typical vehicle is priced £135 below its estimated market retail value.",
        "value": "-£135",
        "class": ""
      },
      {
        "name": "Median Market Days Supply",
        "caption": "The demand for your typical vehicle; under 45 days is high demand.",
        "value": "57 Days",
        "class": ""
      }
    ],
    "tailwinds": [
      {
        "title": "Capitalise on Skoda Karoq Strength",
        "description": "Your 5 Karoqs are selling approximately 4 times faster than the market average. Based on strong market evidence in a high-demand segment (26 days MDS), maintain firm pricing to protect margins and prioritise acquiring more."
      },
      {
        "title": "Expand Electric Vehicle Offering",
        "description": "Your Electric Hatchbacks and SUVs are turning significantly faster than the market (aging indices of 0.47 and 0.53 respectively). Based on strong evidence from your 32 EV units, this is a clear growth area to lean into for future acquisitions."
      },
      {
        "title": "Leverage Overall Speed Advantage",
        "description": "Your overall portfolio turns 36% faster than the mix-weighted market. This strong operational performance frees up capital faster and reduces holding costs, providing a significant competitive advantage."
      }
    ],
    "headwinds": [
      {
        "title": "Address Critically Aged Premium SUVs",
        "description": "Your Land Rover Range Rover stock (3 units) is aging 4.5 times slower than the market. Based on limited market evidence (1 similar car sold recently), immediate action, likely wholesale, is required for the unit at 439 days to stop further financial loss."
      },
      {
        "title": "Resolve Honda CR-V Stagnation",
        "description": "Your 6 Honda CR-Vs are taking 168% longer to sell than competitors' units, compounded by weak market demand (92 days MDS). Based on limited market evidence, an aggressive repricing and marketing strategy is needed to move this stagnant stock."
      },
      {
        "title": "Review Mild-Hybrid SUV Performance",
        "description": "The Mild-Hybrid-Petrol SUV segment (14 units) is underperforming, aging 33% slower than the market. This indicates a potential misalignment in pricing or desirability that requires a detailed review to improve sales velocity."
      }
    ],
    "inventory_overview": {
      "age_distribution": [
        {
          "days": "0-15",
          "units": 517,
          "percent": "53.0%",
          "bar_width": 100
        },
        {
          "days": "16-30",
          "units": 141,
          "percent": "14.5%",
          "bar_width": 27.27272727272727
        },
        {
          "days": "31-45",
          "units": 162,
          "percent": "16.6%",
          "bar_width": 31.334622823984525
        },
        {
          "days": "46-60",
          "units": 63,
          "percent": "6.5%",
          "bar_width": 12.18568665377176
        },
        {
          "days": "61-90",
          "units": 62,
          "percent": "6.4%",
          "bar_width": 11.992263056092844
        },
        {
          "days": "91-120",
          "units": 15,
          "percent": "1.5%",
          "bar_width": 2.9013539651837523
        },
        {
          "days": "121+",
          "units": 15,
          "percent": "1.5%",
          "bar_width": 2.9013539651837523
        }
      ],
      "total_units": 975,
      "total_stock": 975
    },
    "aged_vs_market": {
      "dealership_avg": 23.960040983606596,
      "market_avg": 37.29888889666291,
      "aging_index": 0.6423794834743797,
      "overall_index": "0.64",
      "segments": [
        {
          "name": "Petrol Hatchback",
          "dealer_days": 21.4,
          "market_days": 34.3,
          "index": 0.63,
          "flag_class": "flag-green"
        },
        {
          "name": "Petrol SUV",
          "dealer_days": 22.3,
          "market_days": 38.2,
          "index": 0.59,
          "flag_class": "flag-green"
        },
        {
          "name": "Diesel SUV",
          "dealer_days": 23.5,
          "market_days": 35.4,
          "index": 0.66,
          "flag_class": "flag-green"
        },
        {
          "name": "Diesel Hatchback",
          "dealer_days": 19.6,
          "market_days": 35.2,
          "index": 0.56,
          "flag_class": "flag-green"
        },
        {
          "name": "Petrol Coupe",
          "dealer_days": 24.5,
          "market_days": 37.9,
          "index": 0.65,
          "flag_class": "flag-green"
        },
        {
          "name": "Hybrid-Petrol Hatchback",
          "dealer_days": 19.5,
          "market_days": 28.2,
          "index": 0.69,
          "flag_class": "flag-green"
        }
      ],
      "exceptions": [
        {
          "vin": "SALKA9AU8NA005257",
          "stock_no": "",
          "year_make_model": "2022 Land Rover Range Rover",
          "days_online": 439,
          "price_gap_pct": "-5.5%",
          "severity_score": 10602,
          "action": "Immediate wholesale exit. Holding costs exceed potential retail gain."
        },
        {
          "vin": "WF0DXXGAKDFM75502",
          "stock_no": "",
          "year_make_model": "2016 Ford Fiesta",
          "days_online": 296,
          "price_gap_pct": "-22.6%",
          "severity_score": 1527,
          "action": "Wholesale exit. Already significantly underpriced and not selling."
        },
        {
          "vin": "SHSRE5850JU005011",
          "stock_no": "",
          "year_make_model": "2018 Honda CR-V",
          "days_online": 138,
          "price_gap_pct": "-10.2%",
          "severity_score": 1316,
          "action": "Aggressive price reduction (~10%) and review for auction."
        },
        {
          "vin": "WF0AXXWPMAJA28169",
          "stock_no": "",
          "year_make_model": "2018 Ford Kuga",
          "days_online": 208,
          "price_gap_pct": "-16.2%",
          "severity_score": 927,
          "action": "Prepare for wholesale. A retail sale is unlikely at this age."
        },
        {
          "vin": "WMWWG320203C43568",
          "stock_no": "",
          "year_make_model": "2017 Mini Cooper",
          "days_online": 118,
          "price_gap_pct": "-17.6%",
          "severity_score": 854,
          "action": "Final significant price reduction before wholesale consideration."
        }
      ]
    },
    "playbooks": {
      "repricing": [
        {
          "title": "31-45 Days",
          "description": "For the 162 units in this bracket, implement a minor price adjustment of 1-2% on models with an aging index above 1.1 to stimulate early interest and maintain sales velocity."
        },
        {
          "title": "46-60 Days",
          "description": "Review all 63 vehicles. Apply a 3-5% price reduction to any unit priced above the market average. Refresh adverts with new photos and improved descriptions to regain visibility."
        },
        {
          "title": "61-90 Days",
          "description": "Take decisive action on the 62 vehicles here. Implement a significant price drop of 5-7% to position them as clear value leaders in the market. Flag for management review."
        },
        {
          "title": "91+ Days",
          "description": "The 30 vehicles over 90 days require immediate and aggressive action. Price to wholesale value or slightly above. Any unit not sold within 14 days should be sent to auction to free up capital."
        }
      ],
      "acquisition": [
        {
          "band": "Buy",
          "criteria": "High demand (MDS < 45) and proven fast sellers (Aging Index < 0.9).",
          "examples": "Skoda Karoq, Toyota Yaris, Kia Sportage, Electric Hatchbacks/SUVs.",
          "flag_class": "flag-green"
        },
        {
          "band": "Cautious",
          "criteria": "Balanced demand (MDS 45-70) or where you have high stock concentration.",
          "examples": "Petrol/Diesel Hatchbacks, Mercedes-Benz A-Class, BMW 1 Series.",
          "flag_class": "flag-yellow"
        },
        {
          "band": "Avoid",
          "criteria": "Oversupplied market (MDS > 70) or models consistently aging on your forecourt (Aging Index > 1.5).",
          "examples": "Land Rover Range Rover, Honda CR-V, Renault Kadjar.",
          "flag_class": "flag-red"
        }
      ]
    },
    "footer": {
      "generated_date": "2025-11-04",
      "data_source": "BigQuery Analytics Platform",
      "timestamp": "2025-11-04 (Australia/Melbourne)"
    },
    "glossary": {
      "categories": [
        {
          "category": "Key Performance Metrics",
          "terms": [
            {
              "term": "Days Online",
              "definition": "The number of days a vehicle has been advertised for sale on your lot. Lower numbers indicate fresher inventory.",
              "example": "A car with 30 days online has been listed for sale for one month."
            },
            {
              "term": "Aging Index",
              "definition": "How your inventory age compares to competitors. A value of 1.0 means same age, below 1.0 means fresher stock, above 1.0 means older stock.",
              "example": "An index of 1.2 means your stock has been listed 20% longer than similar dealerships."
            },
            {
              "term": "Market Days Supply (MDS)",
              "definition": "How many days it would take to sell all current market inventory at the current customer demand rate. Lower MDS means high demand.",
              "example": "MDS of 45 days means strong demand - the market would sell out in 6-7 weeks."
            }
          ]
        },
        {
          "category": "Reliability & Prioritisation",
          "terms": [
            {
              "term": "Days to Sell (DTS)",
              "definition": "Market-level sell-through speed derived from the most recent removals in the UK market. Higher DTS indicates it takes longer for similar vehicles to sell.",
              "example": "A badge with DTS of 38 days is selling faster than one with DTS of 65 days."
            },
            {
              "term": "Impact Score",
              "definition": "A composite score prioritising actions using ageing, price gap, and market days supply to estimate commercial impact.",
              "example": "Impact Score = 0.5*aging pressure + 0.3*price gap + 0.2*market supply pressure."
            },
            {
              "term": "Confidence Bands",
              "definition": "High, Medium, or Low confidence labels derived from recent market sales volume and the dealer units referenced in each insight.",
              "example": "High confidence requires at least 8 recent market sales and 3 dealer units in scope."
            }
          ]
        }
      ]
    },
    "data_notes": {
      "overview": "This report provides data-driven insights to optimise your inventory management and pricing strategy for the UK market. All metrics use quality-controlled data, mix-weighted benchmarking, and badge-level detail whenever sample support allows.",
      "notes": [
        {
          "title": "Current Inventory Snapshot",
          "description": "This report analyses vehicles currently for sale, not your historical sell-through. We enrich it with market-level Days to Sell (DTS) and Market Days Supply (MDS) derived from live removals to benchmark demand.",
          "icon": "📸"
        },
        {
          "title": "Price Freshness Filter",
          "description": "We only include vehicles with price updates in the last 3 months. This ensures we're comparing actively managed inventory and excludes stale listings that may no longer be on the market.",
          "icon": "🗓️"
        },
        {
          "title": "Data Quality Controls",
          "description": "Vehicles tagged as 'trash' (data quality issues), 'mismatch' (incorrectly listed), or 'damaged' are automatically excluded from all analysis to ensure accurate market comparisons and reliable benchmarks.",
          "icon": "✅"
        },
        {
          "title": "Tailored Market Comparisons",
          "description": "Market benchmarks are weighted based on YOUR exact make/model mix, not generic averages. This creates true apples-to-apples comparisons. Your top segments (Mercedes-Benz A-Class (5%), BMW 1 Series (4%), Nissan QASHQAI (4%)) drive the weighting of your benchmarks.",
          "icon": "⚖️"
        },
        {
          "title": "Granularity Ladder",
          "description": "Insights prefer Year+Make+Model+Badge granularity. If support is limited we escalate to broader levels and clearly label the change.",
          "icon": "🪜"
        },
        {
          "title": "Statistical Guardrails",
          "description": "We use 45->60->90 day rolling windows, IQR filtering, and confidence bands tied to sample support so recommendations stay evidence-based.",
          "icon": "📊"
        }
      ],
      "data_freshness": "Data refreshed daily from live market feeds. Market benchmarks use the latest 45->60->90 day windows with badge-level weighting where supported. Report generated 2025-11-04T22:25:31.240052."
    }
  }
}