{
  "_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-0150",
    "kind": "repair",
    "objective": "Loop Meta spend has no working projection: meta_api_daily (what the union sheet and lbl.fyi read) has no writer in the platform, and the insights backfill transform writes nothing into ad_daily_metrics",
    "detail": "Measured 2026-09-07 22:25 PDT in loop-data-platform D1. meta_api_daily ends 2026-07-16 for act_837019435833638 and no code in apps/ or packages/ writes it (only migrations 0039/0042 and the viewer read it); it was filled by a one-off pull. The platform's meta/insights_backfill (loop-meta-insights-backfill) with date_preset last_90d ran to success (sync run seen=861 rows, 6 pages, instance ada08a26-fbcc-4517-ac7e-b3c556cb1c3c) and enqueued transform.meta.insights_page messages, yet ad_daily_metrics holds 0 rows for any account and dlq_events is empty; the whole-history preset errored at Meta (HTTP 500 page 0, instance c7a1b18a). Failure class: a collector whose projection is dead or missing, reported as success by the sync counter. Layer: apps/queue-consumer transformMetaInsightsPage and the absent meta_api_daily writer. Invariant: every collector run must be measured on its target table, never on records_seen. Repair: find why transformMetaInsightsPage lands nothing (deployed consumer version vs source, R2 envelope shape, account_id numeric vs act_ prefix), write meta_api_daily from ad_daily_metrics or point the viewer and the union sheet at ad_daily_metrics, and add a post-run check that compares MAX(date) on the target table before and after. Interim truth for Loop Meta spend Jun 9 to Aug 7 2026 lives in the miscsubjects growth spine (/api/growth/metrics/account/<id>), imported 2026-09-07 with receipts.",
    "state": "open",
    "priority": 2,
    "revision": 1,
    "depends_on": [],
    "permitted_capabilities": [],
    "acceptance_tests": [
      {
        "id": "target_table_advances",
        "type": "evidence_present",
        "field": "meta_target_table_max_date"
      }
    ],
    "required_evidence": [
      "meta_target_table_max_date",
      "root_cause"
    ],
    "parent_task": null,
    "supersedes": null,
    "failure": null,
    "failure_count": 0,
    "last_result": null,
    "completed_at": null,
    "created_at": "2026-09-07T22:17:44-07:00",
    "updated_at": "2026-09-07T22:17:44-07:00",
    "audit": "/api/work/task/WT-0150/audit",
    "submit_to": "/api/work/task/WT-0150/submit"
  }
}