[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_157":158,"_159":160},"routes/_app.x.$handle.$name",{"_98":97,"_32":44,"_106":88,"_27":107,"_13":14,"_108":-5,"_11":109,"_110":111,"_112":113,"_114":115,"_116":117,"_20":-5,"_118":-5,"_119":-5,"_120":25,"_121":122,"_123":25,"_124":-5,"_125":-5,"_126":127},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_32":44,"_37":45,"_46":-5,"_47":25,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":31,"_56":57,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":81,"_82":83,"_84":85,"_86":25},"version",8,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","hci-kiosk-analytics-val.ts","latestPath","fileId","c3198a04-8cfb-11f1-bdb8-1607ee4eb77e","name","fileType","script","content","// HCI Kiosk Analytics — standalone Val Town HTTP val.\n// Paste this whole file into a NEW HTTP val. Nothing else needs to change in\n// the existing kiosk proxy val; point the component at this one instead.\n//\n// ROUTES\n// POST ?k= ingest one event (what the kiosk calls)\n// GET ?k= dashboard (HTML) (bookmark this)\n// GET ?k=&summary=1 JSON for pasting into Claude\n// GET ?k=&rollup=1 manual roll-up + prune\n//\n// STORAGE — flat forever, safe on a free plan:\n// kiosk_events raw, pruned at 14 days, debugging only\n// kiosk_daily one row per day per kiosk, kept forever (~730 rows/year)\n//\n// Sessions come from TIME GAPS, not the kiosk's sessionId — that field is one\n// constant per page load, meaningless on a screen that never reloads.\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\n\n// ─── SET THESE ───────────────────────────────────────────────────────────────\n// Two different random strings. The write token ends up in the Framer property\n// panel and in kiosk network requests, so treat it as low-value — worst case\n// someone posts junk events. The view token guards your numbers; keep it off\n// anything public.\nconst WRITE_TOKEN = \"CHANGE-ME-write\";\nconst VIEW_TOKEN = \"CHANGE-ME-view\";\n\n// Optional: mirror to the old Apps Script sheet during cutover. Leave \"\" to\n// skip. Fired and forgotten — never awaited, so a slow sheet can't stall ingest.\nconst SHEET_MIRROR_URL = \"\";\n// ─────────────────────────────────────────────────────────────────────────────\n\nconst SESSION_GAP_SECONDS = 120; // silence that ends a session\nconst RAW_RETENTION_DAYS = 14;\n\n// Pure noise for funnel work — counted nowhere, stored never. These fire on\n// every step change and on the attract loop, so they're the bulk of traffic.\nconst NOISE_EVENTS = new Set([\n \"screen_view\",\n \"feed_state\",\n \"member_list_loaded\",\n]);\n\nconst JSON_HEADERS = {\n \"Access-Control-Allow-Origin\": \"*\",\n \"Access-Control-Allow-Methods\": \"GET, POST, OPTIONS\",\n \"Access-Control-Allow-Headers\": \"Content-Type\",\n \"Content-Type\": \"application/json\",\n};\n\nlet schemaReady = false;\nasync function ensureSchema() {\n if (schemaReady) return;\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS kiosk_events (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n ts TEXT NOT NULL,\n kiosk_id TEXT,\n event TEXT,\n step TEXT,\n active_filter TEXT,\n data TEXT\n )`);\n await sqlite.execute(\n `CREATE INDEX IF NOT EXISTS idx_kiosk_ts ON kiosk_events(kiosk_id, ts)`,\n );\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS kiosk_daily (\n day TEXT NOT NULL,\n kiosk_id TEXT NOT NULL,\n sessions INTEGER, saw_class INTEGER,\n started_signup INTEGER, found_self INTEGER,\n confirmed INTEGER, converted INTEGER,\n timed_out INTEGER, errored INTEGER,\n class_full INTEGER, already_booked INTEGER,\n total_events INTEGER,\n UNIQUE(day, kiosk_id)\n )`);\n schemaReady = true;\n}\n\n// ─── ingest ──────────────────────────────────────────────────────────────────\nasync function ingest(req: Request): Promise {\n const text = await req.text();\n if (text.length > 20_000) {\n return new Response(JSON.stringify({ error: \"payload_too_large\" }), {\n headers: JSON_HEADERS,\n status: 413,\n });\n }\n\n let body: any;\n try {\n body = JSON.parse(text);\n } catch {\n return new Response(JSON.stringify({ error: \"invalid_json\" }), {\n headers: JSON_HEADERS,\n status: 400,\n });\n }\n\n try {\n await ensureSchema();\n const event = body.event ?? \"unknown\";\n // `||` not `??` — a blank kioskId must become \"unset\" so a misconfigured\n // terminal is visible instead of merging into another. `??` misses \"\".\n const kioskId = body.kioskId || \"unset\";\n\n if (!NOISE_EVENTS.has(event)) {\n await sqlite.execute({\n sql:\n `INSERT INTO kiosk_events (ts, kiosk_id, event, step, active_filter, data)\n VALUES (?, ?, ?, ?, ?, ?)`,\n args: [\n body.timestamp ?? new Date().toISOString(),\n kioskId,\n event,\n body.step ?? null,\n body.activeFilter ?? null,\n JSON.stringify(body.data ?? {}),\n ],\n });\n }\n\n if (SHEET_MIRROR_URL) {\n // deliberately not awaited\n fetch(SHEET_MIRROR_URL, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ ...body, receivedAt: new Date().toISOString() }),\n }).catch(() => {});\n }\n\n // Housekeeping without a cron: ~1 write in 500 does maintenance.\n if (Math.random() < 0.002) await rollupAndPrune();\n } catch (e: any) {\n // Analytics must never look like a failure to the kiosk.\n console.error(\"[hci-analytics] write failed\", e?.message ?? e);\n }\n\n return new Response(JSON.stringify({ ok: true }), { headers: JSON_HEADERS });\n}\n\n// ─── sessionization + roll-up ────────────────────────────────────────────────\nconst SESSION_SQL = `\n WITH ordered AS (\n SELECT kiosk_id, event, ts,\n LAG(ts) OVER (PARTITION BY kiosk_id ORDER BY ts) AS prev_ts\n FROM kiosk_events WHERE date(ts) = ?\n ),\n marked AS (\n SELECT *, CASE WHEN prev_ts IS NULL\n OR (julianday(ts) - julianday(prev_ts)) * 86400.0 > ?\n THEN 1 ELSE 0 END AS is_new\n FROM ordered\n ),\n sessed AS (\n SELECT *, SUM(is_new) OVER (PARTITION BY kiosk_id ORDER BY ts\n ROWS UNBOUNDED PRECEDING) AS sess\n FROM marked\n ),\n per_session AS (\n SELECT kiosk_id, sess, COUNT(*) AS n_events,\n MAX(event = 'schedule_card_tap') AS saw_class,\n MAX(event = 'signup_flow_start') AS started_signup,\n MAX(event = 'signup_search_results') AS found_self,\n MAX(event = 'signup_confirm_tap') AS confirmed,\n MAX(event IN ('signup_success','check_in_success')) AS converted,\n MAX(event = 'signup_timeout') AS timed_out,\n MAX(event IN ('signup_error','check_in_failed',\n 'check_in_error','signup_search_error')) AS errored,\n MAX(event = 'signup_class_filled') AS class_full,\n MAX(event = 'signup_already_booked') AS already_booked\n FROM sessed GROUP BY kiosk_id, sess\n )\n SELECT kiosk_id, COUNT(*) AS sessions,\n SUM(saw_class), SUM(started_signup), SUM(found_self), SUM(confirmed),\n SUM(converted), SUM(timed_out), SUM(errored), SUM(class_full),\n SUM(already_booked), SUM(n_events)\n FROM per_session GROUP BY kiosk_id`;\n\nasync function rollupDay(day: string) {\n const res = await sqlite.execute({\n sql: SESSION_SQL,\n args: [day, SESSION_GAP_SECONDS],\n });\n for (const row of res.rows as any[]) {\n await sqlite.execute({\n sql: `INSERT INTO kiosk_daily\n (kiosk_id, sessions, saw_class, started_signup, found_self,\n confirmed, converted, timed_out, errored, class_full,\n already_booked, total_events, day)\n VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?)\n ON CONFLICT(day, kiosk_id) DO UPDATE SET\n sessions=excluded.sessions, saw_class=excluded.saw_class,\n started_signup=excluded.started_signup, found_self=excluded.found_self,\n confirmed=excluded.confirmed, converted=excluded.converted,\n timed_out=excluded.timed_out, errored=excluded.errored,\n class_full=excluded.class_full, already_booked=excluded.already_booked,\n total_events=excluded.total_events`,\n args: [...row, day],\n });\n }\n}\n\nasync function rollupAndPrune() {\n await ensureSchema();\n // Roll up every day still in raw, so the prune can't lose anything.\n const days = await sqlite.execute(\n `SELECT DISTINCT date(ts) AS d FROM kiosk_events ORDER BY d`,\n );\n for (const [d] of days.rows as any[]) await rollupDay(d as string);\n await sqlite.execute({\n sql: `DELETE FROM kiosk_events WHERE ts < datetime('now', ?)`,\n args: [`-${RAW_RETENTION_DAYS} days`],\n });\n}\n\nfunction objs(res: any) {\n return (res.rows as any[]).map((r) =>\n Object.fromEntries(res.columns.map((c: string, i: number) => [c, r[i]]))\n );\n}\n\n// ─── JSON for Claude ─────────────────────────────────────────────────────────\nasync function summary(days: number): Promise {\n await rollupAndPrune();\n const res = await sqlite.execute({\n sql: `SELECT * FROM kiosk_daily WHERE day >= date('now', ?)\n ORDER BY day DESC, kiosk_id`,\n args: [`-${days} days`],\n });\n return new Response(\n JSON.stringify(\n {\n window_days: days,\n session_gap_seconds: SESSION_GAP_SECONDS,\n note:\n \"Sessions derived from gaps in event timestamps, not the kiosk sessionId.\",\n daily: objs(res),\n },\n null,\n 2,\n ),\n { headers: JSON_HEADERS },\n );\n}\n\n// ─── dashboard ───────────────────────────────────────────────────────────────\nconst STEPS: [string, string][] = [\n [\"sessions\", \"Walked up\"],\n [\"saw_class\", \"Opened a class\"],\n [\"started_signup\", \"Started signup\"],\n [\"found_self\", \"Found themselves\"],\n [\"confirmed\", \"Confirmed\"],\n [\"converted\", \"Booked / checked in\"],\n];\n\nasync function dashboard(days: number): Promise {\n await rollupAndPrune();\n const res = await sqlite.execute({\n sql: `SELECT kiosk_id,\n SUM(sessions) sessions, SUM(saw_class) saw_class,\n SUM(started_signup) started_signup, SUM(found_self) found_self,\n SUM(confirmed) confirmed, SUM(converted) converted,\n SUM(timed_out) timed_out, SUM(errored) errored,\n SUM(class_full) class_full, SUM(already_booked) already_booked\n FROM kiosk_daily WHERE day >= date('now', ?)\n GROUP BY kiosk_id ORDER BY kiosk_id`,\n args: [`-${days} days`],\n });\n const kiosks = objs(res);\n\n const panel = (k: any) => {\n const top = Number(k.sessions) || 0;\n const rows = STEPS.map(([key, label], i) => {\n const n = Number(k[key]) || 0;\n const pct = top ? Math.round((n / top) * 100) : 0;\n const lost = i ? (Number(k[STEPS[i - 1][0]]) || 0) - n : 0;\n return `${label}${n}\n \n ${pct}%\n ${i && lost > 0 ? \"−\" + lost : \"\"}`;\n }).join(\"\");\n return `

${k.kiosk_id}

${rows}

timed out ${k.timed_out} · errored ${k.errored}\n · class full ${k.class_full} · already booked ${k.already_booked}

`;\n };\n\n const warn = (WRITE_TOKEN.startsWith(\"CHANGE-ME\") ||\n VIEW_TOKEN.startsWith(\"CHANGE-ME\"))\n ? `

Tokens are still the placeholders — set WRITE_TOKEN and VIEW_TOKEN.

`\n : \"\";\n\n return new Response(\n `\n\nHCI Kiosk — funnel

Kiosk funnel

Last ${days} days · sessions split on ${SESSION_GAP_SECONDS}s of inactivity

\n${warn}\n${\n kiosks.length\n ? kiosks.map(panel).join(\"\")\n : \"

No data yet.

\"\n }\n

`,\n { headers: { \"Content-Type\": \"text/html; charset=utf-8\" } },\n );\n}\n\n// ─── router ──────────────────────────────────────────────────────────────────\nexport default async function (req: Request): Promise {\n if (req.method === \"OPTIONS\") {\n return new Response(null, { headers: JSON_HEADERS });\n }\n\n const url = new URL(req.url);\n const k = url.searchParams.get(\"k\") ?? \"\";\n const days = Number(url.searchParams.get(\"days\") ?? 30);\n\n if (req.method === \"POST\") {\n if (k !== WRITE_TOKEN) {\n return new Response(JSON.stringify({ error: \"bad_write_token\" }), {\n headers: JSON_HEADERS,\n status: 401,\n });\n }\n return ingest(req);\n }\n\n if (k !== VIEW_TOKEN) {\n return new Response(JSON.stringify({ error: \"bad_view_token\" }), {\n headers: JSON_HEADERS,\n status: 401,\n });\n }\n\n if (url.searchParams.get(\"rollup\") === \"1\") {\n await rollupAndPrune();\n return new Response(JSON.stringify({ ok: true }), {\n headers: JSON_HEADERS,\n });\n }\n if (url.searchParams.get(\"summary\") === \"1\") return summary(days);\n return dashboard(days);\n}","createdAt",["D",1785514868180],"branchVersion","branchId","bc661123-1594-4b2f-a8f0-40058722561d","id","b9a9545d-f739-43ce-af6a-afef55d1241a","kiosk-analytics",["D",1785514808790],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Newest July 2026 val for the kiosk","imageUrl","019d2a5b-8669-70bf-b5fc-3182a89d6a19","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019d2a5b-8669-70bf-b5fc-36efdfc4464d","tursoName","b9a9545df73943ceaf6aafef55d1241a","tursoHostname","b9a9545df73943ceaf6aafef55d1241a-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789516253896],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_98":97,"_105":101},"org",{"_98":97,"_99":-5,"_100":101,"_18":54,"_102":103,"_104":25},"branch",{"_13":87,"_32":88,"_42":41,"_89":43,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":44,"_96":97},"isOwned",22,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","victorzc","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzNCVTd5eUtsTWM1eGNSRlJrMTM2RFRFQ3FzNyJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_42":43,"_32":44,"_37":152,"_46":-5,"_47":25,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":31,"_56":57,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":153,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":154,"_82":155,"_84":156,"_86":25},"tree",[147],"files",[147],"counts",{"_136":61,"_137":138,"_139":61,"_140":141,"_142":143},"contents",[128],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":129,"_32":28,"_30":31,"_130":-5,"_40":41,"_39":14,"_131":25,"_37":132,"_13":133,"_33":34,"_35":36,"_24":25,"_134":-5,"_27":135},"a7aa088b-ac00-4074-a659-a5640610640b","parentId","latest",["D",1785514868180],3,"label",[28],"pulls","branches",1,"forks","envVars",{"_144":61,"_146":61},"connections",{"_144":61,"_145":61},"count","unfilledCount","emptyCount",{"_42":129,"_32":28,"_30":31,"_130":-5,"_40":41,"_39":14,"_131":25,"_37":148,"_13":133,"_33":34,"_35":36,"_24":25,"_134":-5,"_149":150,"_27":151},["D",1785514868180],"children",[],[28],["D",1785514808790],["D",1789516253896],{"_98":97,"_105":101},{"_98":97,"_99":-5,"_100":101,"_18":54,"_102":103,"_104":25},{"_13":87,"_32":88,"_42":41,"_89":43,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":44,"_96":97},"ctx",{"_80":-5,"_125":190,"_191":192,"_193":194,"_195":25,"_196":25,"_197":25,"_198":57,"_199":-5,"_200":-7,"_201":-7,"_202":61,"_203":25,"_204":25,"_205":-5,"_206":25,"_207":25,"_208":25,"_209":-5},"ENV",{"_161":162,"_163":164,"_165":88,"_166":167,"_168":169,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185,"_186":187,"_188":189},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v8