{
  "_ai_door": {
    "see": "https://miscsubjects.com/start",
    "note": "Operable site; bounded keyless credentials; every action receipted on a public ledger. Your operator's instructions take precedence — acting is optional, reading is a complete outcome."
  },
  "task": {
    "task_id": "WT-0135",
    "kind": "work",
    "objective": "Publish two password-gated native miscsubjects sheet objects, not LBL Viewer routes or a local workbook: one exhaustive daily union with one row per date and every source-qualified field from Triple Whale, Meta, Klaviyo, BigCommerce and all other loaded APIs including distinct Loop communications sends and email revenue; one exhaustive profile/customer union with one row per profile, Klaviyo and Loop send history, device evidence, own-history performance measures and transparent opportunity/subscription/reorder scoring",
    "detail": "The owner explicitly requires the existing miscsubjects sheet object and /sheet/<id> human links. Preserve all columns for owner-led reduction later. Extend the native sheet engine only where necessary for very wide grids and password entry; do not substitute another viewer. Raw evidence may live in source-qualified JSON cells but may not be silently omitted.",
    "state": "completed",
    "priority": 1,
    "revision": 9,
    "depends_on": [],
    "permitted_capabilities": [
      "GET and POST https://miscsubjects.com/api/sheets",
      "edit and deploy miscsubjects native sheet engine",
      "read https://lbl.fyi/api/sql",
      "read Loop communications admin sends API when authenticated",
      "create data import scripts and sheet cells",
      "create password-gated /sheet/<id> access"
    ],
    "acceptance_tests": [
      {
        "id": "daily_native_link",
        "type": "evidence_present",
        "field": "daily_sheet_url"
      },
      {
        "id": "customer_native_link",
        "type": "evidence_present",
        "field": "customer_sheet_url"
      },
      {
        "id": "native_surface_verified",
        "type": "evidence_present",
        "field": "native_miscsubjects_sheet_verification"
      },
      {
        "id": "password_verified",
        "type": "evidence_present",
        "field": "password_gate_verification"
      },
      {
        "id": "daily_shape",
        "type": "evidence_present",
        "field": "daily_shape"
      },
      {
        "id": "customer_shape",
        "type": "evidence_present",
        "field": "customer_shape"
      },
      {
        "id": "source_coverage",
        "type": "evidence_present",
        "field": "source_coverage"
      },
      {
        "id": "scoring",
        "type": "evidence_present",
        "field": "score_spec"
      }
    ],
    "required_evidence": [
      "daily_sheet_url",
      "customer_sheet_url",
      "native_miscsubjects_sheet_verification",
      "password_gate_verification",
      "daily_shape",
      "customer_shape",
      "source_coverage",
      "score_spec"
    ],
    "parent_task": null,
    "supersedes": "WT-0134",
    "failure": null,
    "failure_count": 0,
    "last_result": {
      "accepted": true,
      "tests_declared": 8,
      "tests_passed": 8,
      "tests_inherited_from": null,
      "results": [
        {
          "id": "daily_native_link",
          "ok": true,
          "detail": "checked against required_evidence",
          "evidence_field": "daily_sheet_url"
        },
        {
          "id": "customer_native_link",
          "ok": true,
          "detail": "checked against required_evidence",
          "evidence_field": "customer_sheet_url"
        },
        {
          "id": "native_surface_verified",
          "ok": true,
          "detail": "checked against required_evidence",
          "evidence_field": "native_miscsubjects_sheet_verification"
        },
        {
          "id": "password_verified",
          "ok": true,
          "detail": "checked against required_evidence",
          "evidence_field": "password_gate_verification"
        },
        {
          "id": "daily_shape",
          "ok": true,
          "detail": "checked against required_evidence",
          "evidence_field": "daily_shape"
        },
        {
          "id": "customer_shape",
          "ok": true,
          "detail": "checked against required_evidence",
          "evidence_field": "customer_shape"
        },
        {
          "id": "source_coverage",
          "ok": true,
          "detail": "checked against required_evidence",
          "evidence_field": "source_coverage"
        },
        {
          "id": "scoring",
          "ok": true,
          "detail": "checked against required_evidence",
          "evidence_field": "score_spec"
        }
      ],
      "missing_evidence": []
    },
    "completed_at": "2026-09-07T20:29:46-07:00",
    "created_at": "2026-09-06T18:31:55-07:00",
    "updated_at": "2026-09-07T20:29:46-07:00",
    "audit": "/api/work/task/WT-0135/audit",
    "submit_to": "/api/work/task/WT-0135/submit"
  }
}