{
  "_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-0132",
    "kind": "work",
    "objective": "Publish one literal full-union Google Sheet for LBL: exactly one row per calendar day across all available history, with the complete superset of every daily-addressable field exposed by every connected business-data source/API; no concentration, curation, ranking, collapsing, or agent-selected omission",
    "detail": "Named sources include Triple Whale, direct Meta, Klaviyo and BigCommerce, plus any other discovered daily business-data source. Every source-specific duplicate, disagreement, identifier, status, freshness field, raw daily measure and missing value remains visible as its own column. If a connector returns no daily records, its requested schema and connector status still appear. The owner—not the agent—will decide what matters after seeing the union. A field dictionary may accompany the primary tab, but the primary tab itself must contain the exhaustive daily union in one row per date.",
    "state": "completed",
    "priority": 1,
    "revision": 5,
    "depends_on": [],
    "permitted_capabilities": [
      "GET api.lbl.fyi/v1/range",
      "GET api.lbl.fyi/v1/today",
      "POST /api/dispatch (TW, BC, KLAVIYO, META)",
      "POST /api/marketing/meta/insights",
      "APPS_SCRIPT_RUN sheets_create",
      "APPS_SCRIPT_RUN sheets_replace_tab",
      "APPS_SCRIPT_RUN sheets_set_range",
      "APPS_SCRIPT_RUN sheets_append_rows",
      "APPS_SCRIPT_RUN sheets_get",
      "LEDGER_QUERY"
    ],
    "acceptance_tests": [
      {
        "id": "sheet_url_present",
        "type": "evidence_present",
        "field": "sheet_url"
      },
      {
        "id": "field_count_present",
        "type": "evidence_present",
        "field": "daily_column_count"
      },
      {
        "id": "date_range_present",
        "type": "evidence_present",
        "field": "date_range"
      },
      {
        "id": "coverage_present",
        "type": "evidence_present",
        "field": "source_coverage"
      },
      {
        "id": "verification_present",
        "type": "evidence_present",
        "field": "union_and_row_checks"
      }
    ],
    "required_evidence": [
      "sheet_url",
      "date_range",
      "daily_row_count",
      "daily_column_count",
      "source_coverage",
      "union_and_row_checks"
    ],
    "parent_task": null,
    "supersedes": null,
    "failure": null,
    "failure_count": 0,
    "last_result": {
      "accepted": true,
      "tests_declared": 5,
      "tests_passed": 5,
      "tests_inherited_from": null,
      "results": [
        {
          "id": "sheet_url_present",
          "ok": true,
          "detail": "checked against required_evidence",
          "evidence_field": "sheet_url"
        },
        {
          "id": "field_count_present",
          "ok": true,
          "detail": "checked against required_evidence",
          "evidence_field": "daily_column_count"
        },
        {
          "id": "date_range_present",
          "ok": true,
          "detail": "checked against required_evidence",
          "evidence_field": "date_range"
        },
        {
          "id": "coverage_present",
          "ok": true,
          "detail": "checked against required_evidence",
          "evidence_field": "source_coverage"
        },
        {
          "id": "verification_present",
          "ok": true,
          "detail": "checked against required_evidence",
          "evidence_field": "union_and_row_checks"
        }
      ],
      "missing_evidence": []
    },
    "completed_at": "2026-09-06T17:52:26-07:00",
    "created_at": "2026-09-06T17:24:58-07:00",
    "updated_at": "2026-09-06T17:52:26-07:00",
    "audit": "/api/work/task/WT-0132/audit",
    "submit_to": "/api/work/task/WT-0132/submit"
  }
}