{
  "_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-0141",
    "kind": "work",
    "objective": "Close the six Loop data holes behind the union sheets: order line items, Klaviyo events since 2026-03-08, subscriptions, Meta spend after 2026-07-16, and mark the two credential-blocked holes UNKNOWN by name",
    "detail": "Owner order 2026-09-07 (Loop unified-view session): 'fix all the holes and then show me end to end'. Measured in the Loop D1 (loop-data-platform) on 2026-09-07 21:50 PDT: (1) 6,577 of 10,846 orders have no order_items; Oct 2025 to May 2026 almost entirely, plus 287 in Aug 2026. (2) klaviyo_events: 907,998 rows, last datetime 2026-03-08. (3) subscriptions: 0 rows (Recharge signal exists only as Klaviyo metrics). (4) meta_api_daily ends 2026-07-16 for act_837019435833638, 2026-06-08 and 2026-06-28 for the other two. (5) stripe_charges start 2026-05-11 (earlier processor has no credential) and (6) order_attribution starts 2025-11-22 (Triple Whale coverage): these two are credential-bound and stay UNKNOWN, never zero. Root cause of 1 and 2: the platform's backfill workflows deliberately do not self-continue (a retry of a step whose create() succeeded spawned chains), each instance stops at its budget with cursor_json {next_url|remaining} and 'no continuation binding wired', and nothing outside drove the remainder. Repair in flight: an external driver feeds bigcommerce/order_products_backfill 250 order ids per instance (27 slices) and klaviyo/events_backfill 100 pages per instance resuming from the handed-over next_url; meta/insights_backfill fired for the three accounts with date_preset maximum (instance c7a1b18a-9abd-4155-bd73-dbbbdfd5b466). Subscriptions needs a collector (none exists in apps/workflows).",
    "state": "open",
    "priority": 1,
    "revision": 4,
    "depends_on": [],
    "permitted_capabilities": [],
    "acceptance_tests": [
      {
        "id": "measurements",
        "type": "evidence_present",
        "field": "post_backfill_measurements"
      },
      {
        "id": "unknowns_named",
        "type": "evidence_present",
        "field": "unknown_holes"
      }
    ],
    "required_evidence": [
      "post_backfill_measurements",
      "unknown_holes",
      "driver_log"
    ],
    "parent_task": null,
    "supersedes": null,
    "failure": null,
    "failure_count": 0,
    "last_result": null,
    "completed_at": null,
    "created_at": "2026-09-07T21:44:01-07:00",
    "updated_at": "2026-09-07T23:20:57-07:00",
    "audit": "/api/work/task/WT-0141/audit",
    "submit_to": "/api/work/task/WT-0141/submit"
  }
}