{
  "today": "2026-11-04",
  "config": {
    "stale_days": 30,
    "activity_days": 14,
    "far_future_days": 365,
    "required": [
      "amount",
      "close_date",
      "owner",
      "next_step"
    ]
  },
  "columns_used": {
    "id": "Opportunity ID",
    "name": "Opportunity Name",
    "owner": "Opportunity Owner",
    "amount": "Amount",
    "close_date": "Close Date",
    "stage": "Stage",
    "next_step": "Next Step",
    "stage_entered": "Stage Entered Date",
    "last_activity": "Last Activity Date"
  },
  "open_deals": 5,
  "closed_skipped": 1,
  "clean_deals": 1,
  "hygiene_score": 20,
  "issue_counts": {
    "past_close_date": 1,
    "stale_stage": 2,
    "no_recent_activity": 2,
    "no_activity_logged": 0,
    "missing_fields": 2,
    "zero_amount": 1,
    "far_future_close": 1
  },
  "by_owner": {
    "Rep A": {
      "open": 2,
      "clean": 1,
      "with_issues": 1,
      "amount_with_issues": 0
    },
    "Rep B": {
      "open": 1,
      "clean": 0,
      "with_issues": 1,
      "amount_with_issues": 120000
    },
    "Rep C": {
      "open": 1,
      "clean": 0,
      "with_issues": 1,
      "amount_with_issues": 15000
    },
    "(no owner)": {
      "open": 1,
      "clean": 0,
      "with_issues": 1,
      "amount_with_issues": 30000
    }
  },
  "deals": [
    {
      "id": "P2",
      "name": "Contoso Robotics: new logo",
      "owner": "Rep B",
      "stage": "Proposal",
      "amount": 120000,
      "close_date": "2026-10-31",
      "issues": [
        {
          "code": "past_close_date",
          "detail": "close date 2026-10-31 is 4 days ago"
        },
        {
          "code": "stale_stage",
          "detail": "81 days in Proposal"
        },
        {
          "code": "no_recent_activity",
          "detail": "last activity 23 days ago"
        },
        {
          "code": "missing_fields",
          "detail": "next_step, Decision Maker"
        }
      ]
    },
    {
      "id": "P4",
      "name": "Tailspin Toys: pilot",
      "owner": "Rep C",
      "stage": "Qualification",
      "amount": 15000,
      "close_date": "2028-03-01",
      "issues": [
        {
          "code": "far_future_close",
          "detail": "close date 2028-03-01 is more than 365 days out"
        },
        {
          "code": "stale_stage",
          "detail": "64 days in Qualification"
        },
        {
          "code": "no_recent_activity",
          "detail": "last activity 63 days ago"
        }
      ]
    },
    {
      "id": "P5",
      "name": "Adventure Works: upsell",
      "owner": "(no owner)",
      "stage": "Proposal",
      "amount": 30000,
      "close_date": null,
      "issues": [
        {
          "code": "missing_fields",
          "detail": "close_date, owner, Decision Maker"
        }
      ]
    },
    {
      "id": "P3",
      "name": "Fabrikam Health: renewal",
      "owner": "Rep A",
      "stage": "Discovery",
      "amount": 0,
      "close_date": "2026-12-31",
      "issues": [
        {
          "code": "zero_amount",
          "detail": "amount is 0"
        }
      ]
    }
  ],
  "checks_skipped": []
}