{
  "_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-0130",
    "kind": "work",
    "objective": "Build and publish one unified LBL daily performance sheet with one row per calendar day across all available history, merging BigCommerce store truth, Triple Whale spend and attribution, Meta delivery, Klaviyo email and SMS, customer classification, data-quality flags, and derived daily KPIs without collapsing conflicting source definitions",
    "detail": "The sheet is the canonical team-readable daily dataset behind the daily report. It must preserve source-specific measures, represent unavailable values as missing rather than zero, include every date from the earliest available source date through the latest complete day in America/Chicago, expose source freshness and reconciliation fields, and be shareable by URL. Dynamic campaign/ad/flow detail may live in supporting tabs or raw fields, but the primary tab is exactly one row per day.",
    "state": "superseded",
    "priority": 1,
    "revision": 4,
    "depends_on": [],
    "permitted_capabilities": [
      "GET api.lbl.fyi/v1/range",
      "GET api.lbl.fyi/v1/today",
      "D1_QUERY",
      "LEDGER_QUERY",
      "GET /api/sheets",
      "POST /api/sheets",
      "PUT /api/sheets/<id>/values/A1",
      "PATCH /api/sheets/<id>",
      "GET /api/sheets/<id>/export.csv"
    ],
    "acceptance_tests": [
      {
        "id": "unified_sheet_exists",
        "type": "sql_count_at_least",
        "sql": "SELECT COUNT(*) AS n FROM user_sheets WHERE title = 'LBL Unified Daily Performance'",
        "min": 1
      },
      {
        "id": "unified_sheet_has_daily_cells",
        "type": "sql_count_at_least",
        "sql": "SELECT COUNT(*) AS n FROM sheet_cells WHERE sheet_id IN (SELECT id FROM user_sheets WHERE title = 'LBL Unified Daily Performance')",
        "min": 100
      }
    ],
    "required_evidence": [
      "sheet_url",
      "date_range",
      "daily_row_count",
      "source_inventory",
      "reconciliation_and_missingness_checks"
    ],
    "parent_task": null,
    "supersedes": null,
    "failure": null,
    "failure_count": 0,
    "last_result": null,
    "completed_at": null,
    "created_at": "2026-09-06T17:12:10-07:00",
    "updated_at": "2026-09-07T20:30:50-07:00",
    "audit": "/api/work/task/WT-0130/audit",
    "submit_to": "/api/work/task/WT-0130/submit"
  }
}