Where your leads come from, and what goes back

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_1272":1273,"_1274":1275},"routes/_app.x.$handle.$name",{"_100":99,"_32":45,"_109":90,"_27":110,"_13":14,"_111":-5,"_11":112,"_113":114,"_115":116,"_117":118,"_119":120,"_20":-5,"_121":-5,"_122":-5,"_123":25,"_124":125,"_126":59,"_127":-5,"_128":-5,"_129":130},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":25},"version",1231,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","watch-cron.ts","latestPath","fileId","cfa8812e-98c4-11f1-9f38-1607ee4eb77e","name","fileType","interval","content","// THE EARLY-WARNING MONITOR, ACTUALLY RUNNING. v1.0, 15 Aug 2026.\n//\n// WHY THIS FILE HAD TO EXIST, stated plainly because it is a correction and not a feature.\n//\n// Kim asked, on 12 Aug: find out what broke on 19 February, and build exception monitoring so a\n// five-month gap cannot happen again. She was told in writing on 14 Aug:\n//\n// \"Exception monitoring is built and running.\"\n//\n// The first half was true. The second half was not. engine/watch.ts is real, tested (50 assertions,\n// including a replay of the actual February records that raises the alarm on 23 Feb), and had\n// **zero callers anywhere in the tree**. It is absent from the TYPES map in scripts/deploy.mjs, so\n// it deployed to the val as an inert `script`: no interval, no endpoint, nothing to invoke it. Its\n// only runner, scripts/watch-run.mjs, says so in its own header — \"READ ONLY, DEPLOYS NOTHING,\n// SCHEDULES NOTHING\" — and needs a human at a laptop. scripts/restore.mjs already called watch.ts\n// \"the one the val cannot supply\". The codebase knew. The client was told otherwise.\n//\n// This file is the interval that makes the sentence true.\n//\n// WHAT IT DOES AND DOES NOT COVER, so that the same claim is not made twice.\n//\n// The February failure had a specific shape: the work kept happening and the money stopped being\n// written down. That is revenueChannelFindings — activity against dollars over rolling windows —\n// and it needs only the CRM's own payment records, which this file can read on a schedule.\n//\n// It does NOT run the match-ratio check. That one compares what the Square bridge saw against what\n// reached a customer record, and it needs the bridge journal plus the exception-report library that\n// lives on the scripts side. Rather than quietly omit it, the report SAYS it was not inspected:\n// runWatch's own blind-spot machinery turns an uninspected check into a visible line rather than a\n// silent pass. A monitor that hides what it did not look at is the failure it exists to prevent.\n//\n// IT READS AND IT WRITES ONE BLOB. There is no path from here to a message, a tag, a charge or a\n// customer record. The GHL token is used on GET only.\n//\n// IT NEVER SHOUTS AND IT NEVER INVENTS. If the CRM is unreachable it logs, leaves the last report\n// exactly where it was, and records the failure. The view route says how old the report is, so a\n// dead monitor degrades into a visibly stale timestamp instead of into silence that reads as calm.\n\nimport { runWatch, revenuePeriods, type WatchReport } from \"./watch.ts\";\n\nconst LOC = \"BQHJ19uohldYe3eqA0bl\";\nconst GHL = \"https://services.leadconnectorhq.com\";\n// Cloudflare in front of the CRM refuses non-browser clients inconsistently; every read in this\n// project sends a Chrome UA for that reason.\nconst UA =\n \"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0 Safari/537.36\";\n\nexport const WATCH_BLOB = \"watch_report\";\n/** Rolling windows for the February shape. 28 days x 7 covers half a year, which is the length of\n * the gap that actually happened — a monitor with a shorter memory than the failure is decoration. */\nexport const REVENUE_WINDOW_DAYS = 28;\nexport const REVENUE_WINDOWS = 7;\n/** Running totals kept between runs, so \"the number went down\" is answerable. */\nexport const MAX_SNAPSHOTS = 60;\n/** Below this a transaction is a $0 placeholder — a booking with nothing in the amount box, which is\n * precisely the February symptom. It still counts as ACTIVITY; it contributes no DOLLARS. */\nexport const REAL_MONEY = 0.01;\n/** Pages of 100. 237 transactions live on 15 Aug 2026; the cap is a runaway guard, not a limit. */\nexport const PAGE_CAP = 40;\n\nexport type WatchBlob = {\n report: WatchReport;\n builtAt: string;\n inspected: { transactions: number; pages: number; truncated: boolean };\n lastRun: { at: string; ok: boolean; ms: number; error: string };\n snapshots: { at: string; counters: Record }[];\n};\n\nasync function ghlToken(): Promise {\n const env = Deno.env.get(\"GHL_TOKEN\");\n if (env) return env;\n const { blob } = await import(\"https://esm.town/v/std/blob\");\n const cfg = (await blob.getJSON(\"puppy_config\").catch(() => null)) as { ghlToken?: string } | null;\n return cfg?.ghlToken ?? \"\";\n}\n\n/** Every payment record the CRM holds, newest first, paged. GET only. */\nexport async function readTransactions(\n get: (url: string) => Promise,\n): Promise<{ rows: { atMs: number | null; dollars: number }[]; count: number; pages: number; truncated: boolean }> {\n const rows: { atMs: number | null; dollars: number }[] = [];\n let pages = 0, offset = 0, more = true;\n while (more && pages < PAGE_CAP) {\n const page = await get(`${GHL}/payments/transactions?altId=${LOC}&altType=location&limit=100&offset=${offset}`);\n const data: any[] = page?.data ?? [];\n for (const t of data) {\n // A failed charge is not revenue and never was. It IS activity — somebody tried to pay — but\n // counting it as dollars would mask exactly the gap this check looks for.\n const ok = String(t?.status ?? \"\") === \"succeeded\";\n const amt = Number(t?.amount);\n const at = Date.parse(String(t?.createdAt ?? \"\"));\n rows.push({\n atMs: Number.isFinite(at) ? at : null,\n dollars: ok && Number.isFinite(amt) && amt >= REAL_MONEY ? amt : 0,\n });\n }\n pages++;\n offset += data.length;\n more = data.length === 100;\n }\n return { rows, count: rows.length, pages, truncated: more };\n}\n\n/**\n * Newest contact-creation timestamps, for the silence check.\n *\n * BOUNDED ON PURPOSE. The full walk is 58 pages of 100 on this account and it runs hourly; the\n * silence check only asks \"has this gone quiet\", which is a question about the recent end of the\n * list. Three pages is roughly twelve days of intake at the observed 25/day and is plenty to notice\n * a stop. It is NOT enough to count anything, and nothing here tries to.\n */\nexport async function readContactTimes(get: (url: string) => Promise, pages = 3): Promise {\n const out: number[] = [];\n let url: string | null = `${GHL}/contacts/?locationId=${LOC}&limit=100`;\n for (let i = 0; i < pages && url; i++) {\n const page: any = await get(url);\n for (const c of page?.contacts ?? []) {\n const at = Date.parse(String(c?.dateAdded ?? \"\"));\n if (Number.isFinite(at)) out.push(at);\n }\n url = page?.meta?.nextPageUrl ?? null;\n }\n return out;\n}\n\nexport default async function (): Promise {\n const t0 = Date.now();\n let blob: any = null;\n try {\n blob = (await import(\"https://esm.town/v/std/blob\")).blob;\n const prev = (await blob.getJSON(WATCH_BLOB).catch(() => null)) as WatchBlob | null;\n\n const token = await ghlToken();\n if (!token) throw new Error(\"no GHL token in env or puppy_config blob\");\n const get = async (url: string) => {\n const r = await fetch(url, {\n headers: { Authorization: `Bearer ${token}`, Version: \"2021-07-28\", \"User-Agent\": UA, Accept: \"application/json\" },\n });\n if (!r.ok) throw new Error(`${r.status} ${url.slice(0, 110)}`);\n return r.json();\n };\n\n const now = Date.now();\n const tx = await readTransactions(get);\n\n // A RUN THAT READ NOTHING MUST NOT OVERWRITE A RUN THAT READ SOMETHING. Zero transactions from a\n // CRM that held 237 yesterday is a read failure wearing the costume of a quiet month, and\n // publishing it as a report would be the February mistake committed by the monitor itself.\n if (tx.count === 0 && (prev?.inspected?.transactions ?? 0) > 0) {\n throw new Error(`read 0 transactions but the last good run read ${prev!.inspected.transactions}; refusing to publish`);\n }\n\n const periods = revenuePeriods(tx.rows, now, REVENUE_WINDOW_DAYS, REVENUE_WINDOWS);\n const txTimes = tx.rows.map((r) => r.atMs).filter((x): x is number => Number.isFinite(x as number));\n const counters = {\n crmPaymentRecords: tx.count,\n crmPaymentDollarsLifetime:\n Math.round(tx.rows.reduce((a, r) => a + r.dollars, 0) * 100) / 100,\n };\n const snapshots = [...(prev?.snapshots ?? []), { at: new Date(now).toISOString(), counters }].slice(-MAX_SNAPSHOTS);\n\n // The silence check gets the two streams this file can honestly read. A stream that fails to\n // read is OMITTED rather than passed in empty: an empty list would read as \"nothing has arrived\",\n // which is the alarm, and raising it because of our own read failure is crying wolf.\n const streams: { name: string; timestamps: number[]; whereToLook?: string }[] = [\n { name: \"payments recorded in your CRM\", timestamps: txTimes, whereToLook: \"Payments in GoHighLevel\" },\n ];\n try {\n const contactTimes = await readContactTimes(get);\n if (contactTimes.length) {\n streams.push({ name: \"new people arriving in your CRM\", timestamps: contactTimes, whereToLook: \"Contacts in GoHighLevel\" });\n }\n } catch (e) {\n console.log(`[watch] contact stream unreadable, omitted rather than reported as silent: ${String(e).slice(0, 120)}`);\n }\n\n const report = runWatch({\n nowMs: now,\n streams,\n // Deliberately not passed: ratio and journal. Both need the Square bridge, which this file\n // cannot reach. Each becomes a visible \"not inspected\" line via blindSpots rather than an\n // invisible pass. See the header.\n revenue: { subject: \"your bookings\", periods },\n snapshots,\n counterLabels: {\n crmPaymentRecords: \"The number of payment records in your CRM\",\n crmPaymentDollarsLifetime: \"The total value of every payment your CRM has ever recorded\",\n },\n });\n\n const next: WatchBlob = {\n report,\n builtAt: new Date(now).toISOString(),\n inspected: { transactions: tx.count, pages: tx.pages, truncated: tx.truncated },\n lastRun: { at: new Date(now).toISOString(), ok: true, ms: Date.now() - t0, error: \"\" },\n snapshots,\n };\n await blob.setJSON(WATCH_BLOB, next);\n\n const urgent = (report.findings ?? []).filter((f: any) => f.severity === \"urgent\").length;\n const attention = (report.findings ?? []).filter((f: any) => f.severity === \"attention\").length;\n console.log(`[watch] ${tx.count} transactions, ${report.findings?.length ?? 0} finding(s) — ${urgent} urgent, ${attention} attention. ${report.headline}`);\n } catch (e) {\n const msg = String(e).slice(0, 240);\n console.log(`[watch] run failed: ${msg}`);\n // Record the failure ON the last good report rather than replacing it. A monitor whose own\n // failures are invisible is worth less than no monitor, because it is trusted.\n try {\n if (blob) {\n const prev = (await blob.getJSON(WATCH_BLOB).catch(() => null)) as WatchBlob | null;\n if (prev) {\n await blob.setJSON(WATCH_BLOB, {\n ...prev,\n lastRun: { at: new Date().toISOString(), ok: false, ms: Date.now() - t0, error: msg },\n });\n }\n }\n } catch { /* a cache that will not persist must not turn one failure into two */ }\n }\n}\n","\nimport {\n headlineFor,\n isBlindFindingForChecks,\n REVENUE_ACTIVITY_HELD,\n REVENUE_DOLLAR_FALL,\n REVENUE_MIN_BASELINE_ACTIVITY,\n REVENUE_MIN_PERIODS,\n revenueChannelFindings,\n runWatch,\n ratioBuckets,\n revenuePeriods,\n type Finding,\n type WatchReport,\n} from \"./watch.ts\";\nimport { paymentLedger } from \"./facts.ts\";\nimport { fetchPayments, MIN_REAL_PAYMENT, toPayment } from \"./payments-source.ts\";\n\nconst LOC = \"BQHJ19uohldYe3eqA0bl\";\nconst GHL = \"https://services.leadconnectorhq.com\";\nconst PAYMENT_PATH = \"/payments/transactions\";\nconst CONTACT_PATH = \"/contacts/\";\nconst CONTACT_PAGE_SIZE = \"100\";\nconst CONTACT_QUERY_KEYS = new Set([\"locationId\", \"limit\", \"startAfter\", \"startAfterId\"]);\nexport const BRIDGE_URL = \"https://amir5--41ace24c7e2111f18c9d1607ee4eb77e.web.val.run\";\nconst UA =\n \"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0 Safari/537.36\";\nconst DAY = 86_400_000;\nconst PAYMENT_CURRENCY = \"USD\";\nconst PAYMENT_AMOUNT_UNIT = \"major\";\nconst KNOWN_PAYMENT_STATUSES = new Set([\"succeeded\", \"failed\", \"pending\"]);\nconst CRM_REQUEST_TIMEOUT_MS = 15_000;\nconst BRIDGE_REQUEST_TIMEOUT_MS = 15_000;\n\nexport const WATCH_BLOB = \"watch_report\";\nexport const REVENUE_WINDOW_DAYS = 28;\nexport const REVENUE_WINDOWS = 7;\nexport const RATIO_WINDOW_DAYS = 7;\nexport const RATIO_WINDOWS = 6;\nexport const MONITORING_HORIZON_DAYS = REVENUE_WINDOW_DAYS * REVENUE_WINDOWS;\nexport const MAX_SNAPSHOTS = MONITORING_HORIZON_DAYS + 2;\nexport const REAL_MONEY = MIN_REAL_PAYMENT;\nexport const PAGE_CAP = 40;\nexport const BRIDGE_JOURNAL_CAP = 1_500;\nexport const MAX_TRANSACTION_DROP_SHARE = 0.10;\nexport const OVERALL_BUDGET_MS = 45_000;\n\nexport const LIFETIME_COUNTER_KEYS = [\n \"crmPaymentRecords\",\n \"crmPaymentDollarsLifetime\",\n] as const;\ntype LifetimeCounterKey = typeof LIFETIME_COUNTER_KEYS[number];\ntype LifetimeCounters = Record;\ntype Snapshot = { at: string; counters: LifetimeCounters };\ntype ResponseLike = { ok: boolean; status: number; json: () => Promise };\ntype RequestFn = (url: string, init?: RequestInit) => Promise;\ntype BlobLike = {\n getJSON: (key: string) => Promise;\n setJSON: (key: string, value: unknown) => Promise;\n};\n\nexport type ReportFindingSeverity = \"urgent\" | \"attention\" | \"note\" | \"none\";\n\nexport type WatchFindingSummary = {\n findings: Finding[];\n blind: Finding[];\n actionable: Finding[];\n severity: ReportFindingSeverity;\n actionableSeverity: ReportFindingSeverity;\n};\n\nexport type WatchInspected = {\n transactions: number;\n expectedTransactions: number;\n pages: number;\n truncated: boolean;\n validTransactionTimestamps: number;\n paymentStatuses: { succeeded: number; failed: number; pending: number };\n currency: \"USD\";\n amountUnit: \"major\";\n zeroOrTest: number;\n unknownSourceTypes: string[];\n contacts: number;\n contactPages: number;\n bridgeJournalRows: number;\n bridgePayments: number;\n bridgeAtCapacity: boolean;\n bridgeHorizonComplete: boolean;\n};\n\nexport type WatchBlob = {\n report: WatchReport;\n builtAt: string;\n hasSuccessfulReport: boolean;\n inspected: WatchInspected;\n lastRun: {\n at: string;\n ok: boolean;\n degraded?: boolean;\n findingSeverity?: ReportFindingSeverity;\n ms: number;\n error: string;\n };\n snapshots: Snapshot[];\n highWater?: Snapshot;\n};\n\nexport type BridgeEvidence = {\n journal: any[];\n payments: number;\n journalRows: number;\n atCapacity: boolean;\n horizonComplete: boolean;\n oldestAt: string;\n ratio: { subject: string; points: ReturnType };\n};\n\nexport type BridgeReadOptions = {\n admin?: string;\n bridgeUrl?: string;\n request?: RequestFn;\n timeoutMs?: number;\n};\n\nexport type TransactionEvidence = {\n rows: { atMs: number; dollars: number }[];\n count: number;\n expected: number;\n pages: number;\n truncated: false;\n validTimestamps: number;\n statuses: { succeeded: number; failed: number; pending: number };\n currency: \"USD\";\n amountUnit: \"major\";\n zeroOrTest: number;\n unknownSourceTypes: string[];\n};\n\nexport type ContactEvidence = { timestamps: number[]; rows: number; pages: number };\n\nexport type ScheduledWatchDeps = {\n blob?: BlobLike;\n env?: (name: string) => string | undefined;\n request?: RequestFn;\n now?: () => number;\n wallNow?: () => number;\n log?: (line: string) => void;\n runWatchFn?: typeof runWatch;\n};\n\nexport type ScheduledWatchResult = { published: boolean; degraded: boolean; error: string };\n\nconst envValue = (name: string): string | undefined => {\n try {\n return typeof Deno !== \"undefined\" ? Deno.env.get(name) : undefined;\n } catch {\n return undefined;\n }\n};\n\nconst errorText = (value: unknown): string => value instanceof Error ? value.message : String(value);\n\nexport function redactSecrets(value: unknown, known: string[] = []): string {\n let text = errorText(value);\n for (const secret of known.filter((x) => typeof x === \"string\" && x.length >= 4)) {\n text = text.split(secret).join(\"[REDACTED]\");\n }\n return text\n .replace(/Bearer\\s+[^\\s,;]+/gi, \"Bearer [REDACTED]\")\n .replace(/([?&](?:admin|token|api[_-]?key|secret)=)[^&\\s]+/gi, \"$1[REDACTED]\")\n .replace(/\\b((?:admin|token|api[_-]?key|secret)\\s*[:=]\\s*)[^\\s,;]+/gi, \"$1[REDACTED]\")\n .replace(/\\b(?:pit-|ghl_|admin_)[A-Za-z0-9._~-]{12,}/g, \"[REDACTED]\")\n .slice(0, 240);\n}\n\nfunction assertCrmUrl(raw: string, allowedPaths = new Set([PAYMENT_PATH, CONTACT_PATH])): URL {\n let target: URL;\n try {\n target = new URL(raw, GHL);\n } catch {\n throw new Error(\"CRM URL is invalid\");\n }\n if (target.protocol !== \"https:\" || target.origin !== GHL || target.username || target.password) {\n throw new Error(\"refusing a URL outside the CRM origin\");\n }\n if (!allowedPaths.has(target.pathname)) throw new Error(\"refusing an undocumented CRM endpoint\");\n return target;\n}\n\nfunction assertContactPageUrl(raw: string, continuation: boolean): URL {\n const target = assertCrmUrl(raw, new Set([CONTACT_PATH]));\n if (target.hash) throw new Error(\"contact pagination URL contains an unsafe fragment\");\n\n for (const key of target.searchParams.keys()) {\n if (!CONTACT_QUERY_KEYS.has(key)) {\n throw new Error(`contact pagination URL uses an unexpected query route: ${key || \"(empty)\"}`);\n }\n }\n const one = (key: string): string => {\n const values = target.searchParams.getAll(key);\n if (values.length !== 1) {\n throw new Error(`contact pagination URL must contain exactly one ${key}`);\n }\n return values[0];\n };\n\n const locationId = one(\"locationId\");\n if (!/^[A-Za-z0-9]{20}$/.test(locationId)) {\n throw new Error(\"contact pagination URL contains an unsafe locationId\");\n }\n if (locationId !== LOC) {\n throw new Error(\"contact pagination URL is not pinned to the Dogs Spot locationId\");\n }\n if (one(\"limit\") !== CONTACT_PAGE_SIZE) {\n throw new Error(`contact pagination URL changed the requested limit from ${CONTACT_PAGE_SIZE}`);\n }\n\n const startAfter = target.searchParams.getAll(\"startAfter\");\n const startAfterId = target.searchParams.getAll(\"startAfterId\");\n if (!continuation) {\n if (startAfter.length || startAfterId.length) {\n throw new Error(\"initial contact query unexpectedly contains a pagination cursor\");\n }\n return target;\n }\n if (startAfter.length !== 1 || startAfterId.length !== 1) {\n throw new Error(\"contact pagination URL must contain one complete cursor pair\");\n }\n if (!/^\\d{1,20}$/.test(startAfter[0]) || !/^[A-Za-z0-9_-]{1,128}$/.test(startAfterId[0])) {\n throw new Error(\"contact pagination URL contains an unsafe cursor\");\n }\n return target;\n}\n\nfunction bridgeTarget(configured: string): URL {\n let url: URL;\n try {\n url = new URL(configured || BRIDGE_URL);\n if (url.protocol !== \"https:\") throw new Error(\"HTTPS is required\");\n } catch {\n throw new Error(\"bridge journal unavailable: BRIDGE_URL is invalid\");\n }\n const allowed = new URL(BRIDGE_URL);\n if (url.origin !== allowed.origin || url.hostname !== allowed.hostname ||\n url.pathname !== allowed.pathname || url.username || url.password) {\n throw new Error(\"bridge journal unavailable: URL is outside the exact allowed origin\");\n }\n url.search = \"\";\n url.hash = \"\";\n return url;\n}\n\nexport async function readBridgeEvidence(\n nowMs: number,\n options: BridgeReadOptions = {},\n): Promise {\n if (!Number.isFinite(nowMs)) throw new Error(\"bridge journal unavailable: current time is invalid\");\n const admin = (options.admin ?? envValue(\"BRIDGE_ADMIN\") ?? \"\").trim();\n if (!admin) throw new Error(\"bridge journal unavailable: BRIDGE_ADMIN is not configured\");\n\n const configuredUrl = (options.bridgeUrl ?? envValue(\"BRIDGE_URL\") ?? \"\").trim();\n const url = bridgeTarget(configuredUrl);\n url.searchParams.set(\"dump\", \"1\");\n url.searchParams.set(\"admin\", admin);\n\n const timeoutMs = options.timeoutMs ?? BRIDGE_REQUEST_TIMEOUT_MS;\n if (!Number.isFinite(timeoutMs) || timeoutMs <= 0) throw new Error(\"bridge journal request budget is exhausted\");\n let response: ResponseLike;\n try {\n response = await (options.request ?? fetch)(url.toString(), {\n method: \"GET\",\n redirect: \"manual\",\n signal: AbortSignal.timeout(Math.max(1, Math.floor(timeoutMs))),\n }) as ResponseLike;\n } catch {\n throw new Error(\"bridge journal request failed\");\n }\n if (response.status >= 300 && response.status < 400) {\n throw new Error(`bridge journal refused redirect HTTP ${response.status}`);\n }\n if (!response.ok) throw new Error(`bridge journal request failed with HTTP ${response.status}`);\n\n let journal: unknown;\n try {\n journal = await response.json();\n } catch {\n throw new Error(\"bridge journal response was not valid JSON\");\n }\n if (!Array.isArray(journal)) throw new Error(\"bridge journal response was not an array\");\n if (journal.length === 0) {\n throw new Error(\"bridge journal returned zero rows; refusing to publish a zero-data watch report\");\n }\n if (journal.length > BRIDGE_JOURNAL_CAP) {\n throw new Error(`bridge journal exceeded its known ${BRIDGE_JOURNAL_CAP}-row cap`);\n }\n\n const times = journal.map((row, i) => {\n if (!row || typeof row !== \"object\" || Array.isArray(row)) {\n throw new Error(`bridge journal row ${i + 1} is malformed`);\n }\n const at = Date.parse(typeof row.ts === \"string\" ? row.ts : \"\");\n if (!Number.isFinite(at)) throw new Error(`bridge journal row ${i + 1} has an invalid timestamp`);\n if (at > nowMs + 5 * 60_000) throw new Error(`bridge journal row ${i + 1} has a future timestamp`);\n return at;\n });\n\n const ledger = paymentLedger(journal);\n if (ledger.length === 0) {\n throw new Error(\"bridge journal contained no Square payment records; refusing to publish a zero match ratio\");\n }\n if (ledger.some((row) => !Number.isFinite(row.atMs))) {\n throw new Error(\"bridge journal contains a Square payment with no readable timestamp\");\n }\n\n const oldestMs = Math.min(...times);\n const ratioStart = nowMs - RATIO_WINDOW_DAYS * RATIO_WINDOWS * DAY;\n const atCapacity = journal.length === BRIDGE_JOURNAL_CAP;\n const horizonComplete = !atCapacity || oldestMs <= ratioStart;\n if (!horizonComplete) {\n throw new Error(\"bridge journal history is truncated inside the match-ratio horizon\");\n }\n\n return {\n journal,\n payments: ledger.length,\n journalRows: journal.length,\n atCapacity,\n horizonComplete,\n oldestAt: new Date(oldestMs).toISOString(),\n ratio: {\n subject: \"Square payments\",\n points: ratioBuckets(ledger, nowMs, RATIO_WINDOW_DAYS, RATIO_WINDOWS),\n },\n };\n}\n\nexport async function readTransactions(\n get: (url: string) => Promise,\n nowMs = Date.now(),\n options: { pageSize?: number; pageCap?: number } = {},\n): Promise {\n const rawRows: any[] = [];\n const source = await fetchPayments(async (url) => {\n const body = await get(url);\n if (isRecord(body) && Array.isArray(body.data)) rawRows.push(...body.data);\n return body;\n }, {\n locationId: LOC,\n pageSize: options.pageSize,\n pageCap: options.pageCap ?? PAGE_CAP,\n now: nowMs,\n });\n\n const count = source.source.totalCount;\n if (count === 0) throw new Error(\"payment source returned zero transactions; refusing to publish\");\n if (rawRows.length !== count) throw new Error(`payment source read ${rawRows.length} of ${count}`);\n\n const statuses = { succeeded: 0, failed: 0, pending: 0 };\n let zeroOrTest = 0;\n const rows = rawRows.map((raw) => {\n const payment = toPayment(raw);\n if (!KNOWN_PAYMENT_STATUSES.has(payment.status)) {\n throw new Error(`unknown payment status for ${payment.id}: refusing to convert it to zero dollars`);\n }\n if (payment.status === \"succeeded\") statuses.succeeded++;\n else if (payment.status === \"failed\") statuses.failed++;\n else statuses.pending++;\n\n const statedCurrency = raw.currency ?? raw.currencyCode;\n if (statedCurrency != null &&\n (typeof statedCurrency !== \"string\" || statedCurrency.trim().toUpperCase() !== PAYMENT_CURRENCY)) {\n throw new Error(`payment ${payment.id} has an unsupported currency`);\n }\n if (!payment.at) throw new Error(`payment ${payment.id} has no createdAt timestamp`);\n const atMs = Date.parse(payment.at);\n if (!Number.isFinite(atMs)) throw new Error(`payment ${payment.id} has an invalid timestamp`);\n\n const isRevenue = payment.status === \"succeeded\" && payment.amount >= REAL_MONEY;\n if (payment.status === \"succeeded\" && !isRevenue) zeroOrTest++;\n return { atMs, dollars: isRevenue ? payment.amount : 0 };\n });\n\n return {\n rows,\n count,\n expected: source.source.totalCount,\n pages: source.source.pages,\n truncated: false,\n validTimestamps: rows.length,\n statuses,\n currency: PAYMENT_CURRENCY,\n amountUnit: PAYMENT_AMOUNT_UNIT,\n zeroOrTest,\n unknownSourceTypes: source.unknownTypes,\n };\n}\n\nexport async function readContactTimes(\n get: (url: string) => Promise,\n pageLimit = 3,\n nowMs = Date.now(),\n): Promise {\n if (!Number.isInteger(pageLimit) || pageLimit < 1 || pageLimit > 10) {\n throw new Error(\"invalid contact page limit\");\n }\n if (!Number.isFinite(nowMs)) throw new Error(\"contact source current time is invalid\");\n const timestamps: number[] = [];\n const seenUrls = new Set();\n let pages = 0;\n let url: URL | null = assertContactPageUrl(\n `${GHL}${CONTACT_PATH}?locationId=${LOC}&limit=${CONTACT_PAGE_SIZE}`,\n false,\n );\n while (url && pages < pageLimit) {\n const target = url;\n if (seenUrls.has(target.toString())) throw new Error(\"contact pagination repeated a page URL\");\n seenUrls.add(target.toString());\n\n const page = await get(target.toString());\n if (!isRecord(page)) {\n throw new Error(`contact page ${pages + 1} is malformed`);\n }\n if (!Array.isArray(page.contacts)) throw new Error(`contact page ${pages + 1} has no contacts array`);\n if (!isRecord(page.meta)) {\n throw new Error(`contact page ${pages + 1} has no metadata object`);\n }\n if (page.contacts.length > 100) throw new Error(`contact page ${pages + 1} exceeds its requested limit`);\n if (page.meta.nextPageUrl != null &&\n (typeof page.meta.nextPageUrl !== \"string\" || !page.meta.nextPageUrl.trim())) {\n throw new Error(`contact page ${pages + 1} has an invalid nextPageUrl`);\n }\n\n for (const contact of page.contacts) {\n if (!contact || typeof contact !== \"object\" || Array.isArray(contact)) {\n throw new Error(`contact page ${pages + 1} contains a malformed row`);\n }\n const at = Date.parse(String(contact.dateAdded ?? \"\"));\n if (!Number.isFinite(at)) throw new Error(\"contact row has an invalid dateAdded timestamp\");\n if (at > nowMs) throw new Error(\"contact row has a future dateAdded timestamp\");\n if (timestamps.length && at > timestamps[timestamps.length - 1]) {\n throw new Error(\"contact pages are not pinned newest-first\");\n }\n timestamps.push(at);\n }\n pages++;\n\n const next = page.meta.nextPageUrl ?? null;\n url = next ? assertContactPageUrl(next, true) : null;\n }\n if (timestamps.length === 0) throw new Error(\"contact source returned zero timestamps\");\n return { timestamps, rows: timestamps.length, pages };\n}\n\nconst CANONICAL_UTC_TIME = /^\\d{4}-\\d{2}-\\d{2}T\\d{2}:\\d{2}:\\d{2}\\.\\d{3}Z$/;\nconst MAX_REPORT_PERSIST_LAG_MS = 5 * 60_000;\n\nconst isRecord = (value: unknown): value is Record => {\n try {\n return !!value && typeof value === \"object\" && !Array.isArray(value) &&\n Object.getPrototypeOf(value) === Object.prototype;\n } catch {\n return false;\n }\n};\n\nconst isNormalObjectDataDescriptor = (descriptor: PropertyDescriptor | undefined): boolean =>\n descriptor !== undefined && Object.prototype.hasOwnProperty.call(descriptor, \"value\") &&\n descriptor.enumerable === true && descriptor.writable === true && descriptor.configurable === true;\n\nfunction hasExactKeys(\n value: Record,\n required: readonly string[],\n optional: readonly string[] = [],\n): boolean {\n try {\n const allowed = new Set([...required, ...optional]);\n const keys = Reflect.ownKeys(value);\n return required.every((key) => keys.includes(key)) &&\n keys.every((key) => typeof key === \"string\" && allowed.has(key) &&\n isNormalObjectDataDescriptor(Object.getOwnPropertyDescriptor(value, key)));\n } catch {\n return false;\n }\n}\n\nfunction hasExactDataKeys(\n value: Record,\n required: readonly string[],\n optional: readonly string[] = [],\n): boolean {\n return hasExactKeys(value, required, optional);\n}\n\nfunction isExactArray(value: unknown): value is unknown[] {\n try {\n if (!Array.isArray(value) || Object.getPrototypeOf(value) !== Array.prototype) return false;\n const keys = Reflect.ownKeys(value);\n const lengthDescriptor = Object.getOwnPropertyDescriptor(value, \"length\");\n if (!lengthDescriptor || !Object.prototype.hasOwnProperty.call(lengthDescriptor, \"value\") ||\n typeof lengthDescriptor.value !== \"number\" || !Number.isSafeInteger(lengthDescriptor.value) ||\n lengthDescriptor.value < 0 || lengthDescriptor.enumerable !== false ||\n lengthDescriptor.writable !== true || lengthDescriptor.configurable !== false) return false;\n const length = lengthDescriptor.value;\n if (keys.length !== length + 1 || !keys.includes(\"length\")) return false;\n for (let i = 0; i < length; i++) {\n const key = String(i);\n if (!keys.includes(key) ||\n !isNormalObjectDataDescriptor(Object.getOwnPropertyDescriptor(value, key))) return false;\n }\n return keys.every((key) => key === \"length\" ||\n (typeof key === \"string\" && /^(?:0|[1-9]\\d*)$/.test(key) && Number(key) < length));\n } catch {\n return false;\n }\n}\n\nfunction isExactDataArray(value: unknown): value is unknown[] {\n return isExactArray(value);\n}\n\nfunction detachedExactData(\n value: unknown,\n fail: SchemaFailure,\n path: string,\n active: Set

Of the ${ptReadable ? pt.booked : \"unknown\"} Pup Talks: showed / no-show / never marked either way	${ptReadable ? `${pt.showed} / ${pt.noshow} / ${Math.max(0, pt.booked - pt.showed - pt.noshow)}` : \"Unknown\"}
Canceled (not counted above)	${ptReadable ? pt.cancelled : \"Unknown\"}
Show rate	${ptReadable ? `${pt.showed} of ${pt.booked} booked${pt.booked >= 5 ? ` (${pct(pt.showed, pt.booked)})` : \"\"}${Math.max(0, pt.booked - pt.showed - pt.noshow) > 0 && pt.showed + pt.noshow >= 5 ? `; of the ${pt.showed + pt.noshow} actually marked, ${pct(pt.showed, pt.showed + pt.noshow)}` : \"\"}` : \"Unknown\"}
Free Training Day booked / showed	${ftdReadable ? `${ftd.booked} / ${ftd.showed}${ftd.booked === 0 ? \" (none scheduled this week)\" : \"\"}` : \"Unknown\"}
Meta connection error	${esc(metaErr)}

Stage	People
${esc(STATUS_LABEL[s.k])}	${s.n}
Total in a sequence	${sum}

Segment	Count	Share	What can be done
Has an email	${c.emailable}	${pct(c.emailable, d.total)}	Address inventory only; not permission to release.
Email + consent snapshot clear	${c.releaseReady ?? 0}	${pct(c.releaseReady ?? 0, d.total)}	The only rows allowed into the dry-run batch plan.
Email, consent unknown	${c.consentUnknown ?? c.emailable}	${pct(c.consentUnknown ?? c.emailable, d.total)}	Held until each full contact DND snapshot is read.
Email blocked / DND	${c.emailBlocked ?? 0}	${pct(c.emailBlocked ?? 0, d.total)}	Excluded from the release.
Phone only	${c.phoneOnly}	${pct(c.phoneOnly, d.total)}	SMS — held until numbers are validated. Stale numbers get a business flagged by carriers.
Neither	${c.unreachable}	${pct(c.unreachable, d.total)}	Nothing by email or text. Reachable only inside Messenger, within Meta's window.
Excluded	${c.excluded}	${pct(c.excluded, d.total)}	Already customers, already on a path, flagged spam, or duplicates.

Campaign	Spent	Conversations	Cost each
Kims New Except4Ads#2	$180.64	47	$3.84
APRIL 10th Fresh February Leads - Copy	$170.89	44	$3.88
Email CSV AI Campaign	$116.49	22	$5.30
Training Tips-Messenger Leads-6/26	$86.96	14	$6.21
Free Training Day Website 6/19	$0.00	0	off
Total	$554.98	127	$4.37

Measure	This week	How it is worked out
Cost per click	$2.05	$164.00 divided by 80 clicks
Cost per conversion	$41.00	$164.00 divided by 4 conversions
Click through rate	8.25%	80 clicks divided by 970 impressions
Your share of available searches	32%	Google's figure, up from 29%
Rover's share of the same searches	24%	Google's figure, up from 22%

Channel	Messages in	Notes
Facebook	538	72% of everything that came in
Phone	71	120 calls in total, 24 unanswered
Text	71
Instagram	46
Email	4

Figure	Value	Source and method
Facebook spend	$554.98	Ads Manager, account 938090411743620, 31 Jul to 5 Aug, sum of the four live campaigns
Facebook conversations	127	Same view, sum of the Results column
Facebook cost per conversation	$4.37	554.98 divided by 127
Facebook consistency check	4 of 4	Each campaign's spend divided by its results matches Meta's own cost per result to the cent
Google spend, clicks, impressions, conversions	$164, 80, 970, 4	Google Ads overview, account 942-544-7945, 31 Jul to 6 Aug
New contacts, this week and last	175 and 197	CRM contact search on date added, converted to New York time before bucketing, two independent pulls agreed
Appointments	55 and 64	All 29 calendars queried one at a time, 197 raw events, bucketed on start time
Messages in and out	748 and 1,143	660 conversations pulled in full, 15,488 messages, system audit entries excluded
Calls	120, 96 answered	Call type messages, answered means completed
Opportunities won, all time	0	All 5,768 opportunities paginated: 5,594 open, 174 lost, 0 won, 0 abandoned. This is the pipeline view only, not a statement about money received
Payment records in the CRM	232 and 195	Transactions and orders. Three transactions fall inside this week, which is being checked before any return figure is quoted
Contacts with no source, 31 Jul to 5 Aug	120 of 149	Source field on each new contact record

Where the money went	Amount	How this page gets it
Facebook and Instagram3 August to 9 August 2026	$676.94	Read straight from the ad platform every time your card page loads. Read three times today, at 3:06 pm, 3:15 pm and 3:16 pm, and it said the same figure each time.
Google31 July to 6 August 2026	$164.00	Typed by hand. This is the figure in the message sent to you on 7 August. Google puts its own numbers behind a developer token, which Google quotes at about five business days. Google joins this page the same way Facebook has once that token lands, and until then every Google figure you see anywhere is one a person typed.

In the seven days 3 August to 9 August	Count
New people in your CRM	168
Of those, arrived through Facebook or Instagram	139
New cards on your Initial Lead Pipeline	166
Pup Talk appointments on your calendar	20
Of those, showed up	15
Cards that moved into your Customer column	2

Program price on the record	Records	Value
$3,295.00	39	$128,505.00
$2,395.00	11	$26,345.00
$3,795.00	3	$11,385.00
All valued records	53	$166,235.00

What happens to it	Payments	Value
Places itself. One booking open, so the money goes straight on it.	15	$7,880.00
Waits for one of your team to pick. More than one booking open.	0	$0.00
Booking already carries a value, so it is left exactly as it is.	15	$8,237.00
Stays where it is, and it is two separate causes. 3 worth $480.00 carry no name on the record. 3 worth $967.00 name a real customer whose booking sits on another board.	6	$1,447.00
All completed payments	36	$17,564.00

Read from the system itself at 3:12 pm today	Reading
Practice mode	On
Messages to real customers, all time	0
Records it is tracking	1
Practice messages produced	5
Version, and its last pass	1.7.1, 3:11 pm

Program price on the record	Records	Value
$3,295	39	$128,505.00
$2,395	11	$26,345.00
$3,795	3	$11,385.00
All valued records	53	$166,235.00

What happens to it	Payments	Value
Places itself. One booking open, so the money goes straight on it.	15	$7,880.00
Needs one of your team to pick. More than one booking open.	0	$0.00
Already has a value on the booking, so it is left alone.	15	$8,237.00
Cannot be placed, and it is two different problems. Three arrived against a record with no name on it at all. The other three name a real customer who has no card in your Customer column to put the money on.	6	$1,447.00
All completed payments	36	$17,564.00

Route	Payments	What it carries
Invoice raised in the CRM, paid by card	56	Arrives already attached to the customer. This is most of your real revenue.
Order form and manual charges	12	Same, attached to the customer.
Counter sale in Square with no name taken	8	Files against one nameless record. Nothing can ever place these.

What it finds	What it does
One open booking	Writes the amount on. No person involved.
More than one open booking	Puts it on an exception list for your team to pick. It never guesses.
No name on the payment	Reported separately as unplaceable. Never guessed at.
Booking already has a price on it	Left exactly as it is. It never overwrites anybody's number.

Task	Who	How often
Take a name at the counter when somebody pays without one.	Front desk	Only fixes future payments, not past ones. Eight so far have no name.
Pick the right booking when a customer has more than one open.	Whoever you nominate	Zero times today. The list is empty.
Moving cards into Customer	Nobody	Already automated. Noted, and thank you for the correction.
Anything else	Nobody	The rest is automatic.

Outcome	Payments	Value
Places itself. One booking open.	15	$7,880.00
Goes to the exception list for your team to pick.	0	$0.00
Booking already priced, so left alone.	15	$8,237.00
Cannot be placed, reported separately.	6	$1,447.00
All completed payments	36	$17,564.00

${esc(ch.name)}

Where your leads come from, and what goes back

What this page deliberately does not claim

Did the ad leads actually land?

Did the ad leads actually land?

Did the ad leads actually land?

Some numbers could not be read

What last week's report said

What last week's report said

The Dogs Spot, the week in numbers

What happened, in words DRAFT until Amir reviews

New inquiries, last eight weeks

Where this week's inquiries came from

Why there is no revenue figure

Appendix, the fine print

This week's raw counts

How every number is computed

Nurture path registry

Holiday deposits

Holiday deposits

Holiday deposits

Holiday deposits

The Dogs Spot

Waiting on you

From first contact to paying customer

Is everything working?

Where the last 7 days of inquiries came from

Which ads they answered

New inquiries, week by week

What the advertising cost

What we have been doing

One thing worth fixing in the CRM

The follow-up system, in detail

What needs doing today

The Dogs Spot, Nurture Control Panel

Right now

Where those people are

Stop everything

${d.journalTotal <= entriesShown && groups.length <= RECENT_ROWS ? \"Everything it has done so far\" : \"What it has been doing\"}

Something went wrong in the last 24 hours

The dormant list — what is actually in it

Who can actually be contacted

How old it really is

The release plan

Nurture path registry

The Dogs Spot

Waiting on you

From first contact to paying customer

Is everything working?

Where the last 7 days of inquiries came from

Which ads they answered

New inquiries, week by week

What the advertising cost

What we have been doing

One thing worth fixing in the CRM

The follow-up system, in detail

The Dogs Spot, week of 31 July to 6 August 2026

The thing worth two minutes

Facebook

Where the money went

Google

Your CRM

Where the 175 came from

The 175, since you asked what it counts

The gap between what the ads claim and what your CRM received

Appendix, every number and where it came from

What you spent, and what came back

1. What you spent, and what it brought

What your Square money is doing

What your bookings carry today

2. Where your people came from

3. What happened to those people

4. What your follow up system is doing

Your review pipeline, on one page for the first time

Where your money is, and what is missing

The money Square has sent across

The gap, in one sentence

What your bookings currently carry

What happens the moment the amount gets written

Two things worth knowing that nobody asked about

Diff · v1231