{
  "id": "cmpgb8ez40009bzmklon5x7vo",
  "reportType": "EXECUTIVE_SUMMARY",
  "title": "Executive Summary Report - 5/21/2026",
  "status": "COMPLETED",
  "filters": {},
  "summary": {
    "keyAlerts": [
      {
        "type": "price_drop",
        "source": "Shopify Brand Watchlist",
        "lastUpdated": "2026-05-19T12:00:00.000Z",
        "lowestPrice": 18,
        "productName": "Overnight Glow Mask",
        "averagePrice": 21,
        "currentPrice": 18,
        "highestPrice": 24,
        "previousPrice": 24,
        "priceChangeAmount": -6,
        "priceChangePercentage": -25
      },
      {
        "type": "price_drop",
        "source": "Amazon Competitors",
        "lastUpdated": "2026-05-20T12:00:00.000Z",
        "lowestPrice": 24.99,
        "productName": "Vitamin C Glow Serum",
        "averagePrice": 27.49,
        "currentPrice": 24.99,
        "highestPrice": 29.99,
        "previousPrice": 29.99,
        "priceChangeAmount": -5,
        "priceChangePercentage": -16.67
      },
      {
        "type": "out_of_stock",
        "source": "Amazon Competitors",
        "productName": "Barrier Repair Cream",
        "lastSeenTimestamp": "2026-05-20T12:00:00.000Z",
        "availabilityChange": "in_stock -> out_of_stock",
        "firstSeenTimestamp": "2026-05-02T12:00:00.000Z",
        "currentAvailability": "out_of_stock",
        "previousAvailability": "in_stock"
      }
    ],
    "productCount": 4,
    "sourceFilter": "all",
    "topCategories": [
      {
        "name": "Skincare",
        "count": 2
      },
      {
        "name": "Masks",
        "count": 1
      }
    ],
    "topPriceDrops": [
      {
        "source": "Shopify Brand Watchlist",
        "lastUpdated": "2026-05-19T12:00:00.000Z",
        "lowestPrice": 18,
        "productName": "Overnight Glow Mask",
        "averagePrice": 21,
        "currentPrice": 18,
        "highestPrice": 24,
        "previousPrice": 24,
        "priceChangeAmount": -6,
        "priceChangePercentage": -25
      },
      {
        "source": "Amazon Competitors",
        "lastUpdated": "2026-05-20T12:00:00.000Z",
        "lowestPrice": 24.99,
        "productName": "Vitamin C Glow Serum",
        "averagePrice": 27.49,
        "currentPrice": 24.99,
        "highestPrice": 29.99,
        "previousPrice": 29.99,
        "priceChangeAmount": -5,
        "priceChangePercentage": -16.67
      },
      {
        "source": "Shopify Brand Watchlist",
        "lastUpdated": "2026-05-19T12:00:00.000Z",
        "lowestPrice": null,
        "productName": "",
        "averagePrice": null,
        "currentPrice": null,
        "highestPrice": null,
        "previousPrice": null,
        "priceChangeAmount": null,
        "priceChangePercentage": null
      }
    ],
    "totalScrapeRuns": 2,
    "failedScrapeCount": 0,
    "inStockPercentage": 50,
    "averageProductPrice": 18.62,
    "totalProductsTracked": 4,
    "totalSourcesMonitored": 2,
    "latestSuccessfulScrape": "2026-05-20T12:00:00.000Z"
  },
  "data": {
    "rows": [
      {
        "source": "Amazon Competitors",
        "topBrands": [
          {
            "name": "GlowLab",
            "count": 1
          },
          {
            "name": "DermaNorth",
            "count": 1
          }
        ],
        "brandCount": 2,
        "averagePrice": 28.24,
        "productCount": 2,
        "categoryCount": 1,
        "topCategories": [
          {
            "name": "Skincare",
            "count": 2
          }
        ],
        "inStockPercentage": 50,
        "discountedProductCount": 1
      },
      {
        "source": "Shopify Brand Watchlist",
        "topBrands": [
          {
            "name": "LumaSkin",
            "count": 2
          }
        ],
        "brandCount": 1,
        "averagePrice": 18,
        "productCount": 2,
        "categoryCount": 1,
        "topCategories": [
          {
            "name": "Masks",
            "count": 1
          }
        ],
        "inStockPercentage": 50,
        "discountedProductCount": 1
      }
    ],
    "alerts": [
      {
        "type": "price_drop",
        "source": "Shopify Brand Watchlist",
        "lastUpdated": "2026-05-19T12:00:00.000Z",
        "lowestPrice": 18,
        "productName": "Overnight Glow Mask",
        "averagePrice": 21,
        "currentPrice": 18,
        "highestPrice": 24,
        "previousPrice": 24,
        "priceChangeAmount": -6,
        "priceChangePercentage": -25
      },
      {
        "type": "price_drop",
        "source": "Amazon Competitors",
        "lastUpdated": "2026-05-20T12:00:00.000Z",
        "lowestPrice": 24.99,
        "productName": "Vitamin C Glow Serum",
        "averagePrice": 27.49,
        "currentPrice": 24.99,
        "highestPrice": 29.99,
        "previousPrice": 29.99,
        "priceChangeAmount": -5,
        "priceChangePercentage": -16.67
      },
      {
        "type": "out_of_stock",
        "source": "Amazon Competitors",
        "productName": "Barrier Repair Cream",
        "lastSeenTimestamp": "2026-05-20T12:00:00.000Z",
        "availabilityChange": "in_stock -> out_of_stock",
        "firstSeenTimestamp": "2026-05-02T12:00:00.000Z",
        "currentAvailability": "out_of_stock",
        "previousAvailability": "in_stock"
      }
    ]
  },
  "generatedAt": "2026-05-22T02:38:15.757Z",
  "createdAt": "2026-05-22T02:38:15.760Z",
  "updatedAt": "2026-05-22T02:38:15.760Z"
}