[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_151":152,"_153":154},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_115":-5,"_20":116,"_22":117,"_118":119,"_120":121,"_25":122,"_24":-5,"_123":-5,"_124":-5,"_125":53,"_126":127,"_128":44,"_129":-5,"_130":-5,"_131":132},"routes/_app.x.$handle.$name.branch.$branch.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":-7,"_25":26,"_27":-5,"_28":-5,"_29":-5,"_30":-5,"_31":-5},"handle","devinbugbasher","name","sitelytics","branchName","main","version","path","","project",{"_33":61,"_13":14,"_45":62,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":69,"_70":-5,"_71":72,"_73":37,"_74":44,"_75":-5,"_76":-5,"_77":78,"_79":80,"_81":-5,"_82":-5,"_83":-5,"_84":-5,"_85":86,"_87":86,"_88":89,"_90":89,"_91":89,"_92":86,"_93":86,"_94":95,"_96":97,"_98":99,"_100":53},"tree",[56],"file","contents",[32],"upstream","pull","ahead","behind","envVars",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_18":55},"id","0d00c783-9b8a-4baa-bb88-2d8b3dd99831","main.tsx","fileId","cacfa2c6-a0b8-11f1-b2c7-1607ee4eb77e","parentId","branchId","14c3c843-7aeb-4259-877a-25404443601b","branchVersion",2,"latest",true,"createdAt",["D",1787685347218],1,"fileType","http","content","// Sitelytics — shared analytics + A/B dashboard for the consumer site experiments.\n// PUBLIC val: no secrets. Stores events in Val Town sqlite.\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nconst CORS = {\n \"Access-Control-Allow-Origin\": \"*\",\n \"Access-Control-Allow-Methods\": \"GET,POST,OPTIONS\",\n \"Access-Control-Allow-Headers\": \"content-type\",\n};\n\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS site_events (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n site TEXT NOT NULL,\n event TEXT NOT NULL,\n variant TEXT,\n ref TEXT,\n ua TEXT,\n ts TEXT DEFAULT (datetime('now'))\n)`);\n\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n if (req.method === \"OPTIONS\") return new Response(null, { headers: CORS });\n\n if (req.method === \"POST\" && url.pathname === \"/e\") {\n try {\n const b = await req.json();\n const site = String(b.site || \"\").slice(0, 40);\n const event = String(b.event || \"\").slice(0, 60);\n if (!site || !event) throw new Error(\"bad\");\n await sqlite.execute({\n sql: \"INSERT INTO site_events (site, event, variant, ref, ua) VALUES (?,?,?,?,?)\",\n args: [\n site,\n event,\n String(b.variant || \"\").slice(0, 8),\n String(b.ref || \"\").slice(0, 200),\n (req.headers.get(\"user-agent\") || \"\").slice(0, 200),\n ],\n });\n return Response.json({ ok: true }, { headers: CORS });\n } catch {\n return Response.json({ ok: false }, { status: 400, headers: CORS });\n }\n }\n\n if (url.pathname === \"/stats.json\") {\n const rows = await sqlite.execute(\n \"SELECT site, event, variant, COUNT(*) as n FROM site_events GROUP BY site, event, variant ORDER BY site, event, variant\",\n );\n return Response.json(rows.rows, { headers: CORS });\n }\n\n // Dashboard\n const agg = await sqlite.execute(\n \"SELECT site, variant, SUM(event='pageview') as pv, SUM(event LIKE 'convert%') as conv FROM site_events GROUP BY site, variant ORDER BY site, variant\",\n );\n const events = await sqlite.execute(\n \"SELECT site, event, COUNT(*) as n FROM site_events GROUP BY site, event ORDER BY site, n DESC\",\n );\n const rows = (agg.rows as any[]).map((r) => {\n const pv = Number(r[2]) || 0, conv = Number(r[3]) || 0;\n const rate = pv ? ((100 * conv) / pv).toFixed(1) + \"%\" : \"–\";\n return \"\" + r[0] + \"\" + (r[1] || \"?\") + \"\" + pv + \"\" + conv + \"\" +\n rate + \"\";\n }).join(\"\");\n const evrows = (events.rows as any[]).map((r) =>\n \"\" + r[0] + \"\" + r[1] + \"\" + r[2] + \"\"\n ).join(\"\");\n const html = `Sitelytics\n\n\n

Sitelytics — consumer site A/B dashboard

Variants (pageviews vs conversions)

\n${rows}

site	variant	pageviews	conversions	rate

All events

\n${evrows}

site	event	count

\n`;\n return new Response(html, { headers: { \"content-type\": \"text/html; charset=utf-8\" } });\n}\n","deleted",false,"label",[35],{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_58":59,"_18":60},["D",1787685347218],"children",[],[35],"25181549-212a-463b-8f68-c4756f332b25",["D",1787685086499],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","consumer web experiment","imageUrl","userId","d4c60dec-629c-48f7-ab40-94425a911883","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019ffe68-9501-7766-879a-0bb7d10b2c21","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_114":19},"org",{"_11":12,"_109":19,"_110":19,"_71":72,"_111":112,"_113":53},"branch",{"_17":42,"_13":16,"_33":40,"_101":61,"_102":-5,"_103":-5,"_104":-5,"_105":-5,"_106":-5,"_107":14,"_108":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":61,"_13":14,"_45":147,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":69,"_70":-5,"_71":72,"_73":37,"_74":44,"_75":-5,"_76":-5,"_77":78,"_79":80,"_81":-5,"_82":-5,"_83":-5,"_84":-5,"_85":86,"_87":86,"_88":89,"_90":89,"_91":89,"_92":86,"_93":86,"_94":148,"_96":149,"_98":150,"_100":53},[144],"files",[144],"counts",{"_135":78,"_136":47,"_137":78,"_31":138,"_139":140},[133],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_18":134},[35],"pulls","branches","forks",{"_141":78,"_143":78},"connections",{"_141":78,"_142":78},"count","unfilledCount","emptyCount",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_58":145,"_18":146},[],[35],["D",1787685086499],{"_11":12,"_114":19},{"_11":12,"_109":19,"_110":19,"_71":72,"_111":112,"_113":53},{"_17":42,"_13":16,"_33":40,"_101":61,"_102":-5,"_103":-5,"_104":-5,"_105":-5,"_106":-5,"_107":14,"_108":12},"ctx",{"_94":-5,"_130":184,"_185":186,"_187":188,"_189":53,"_190":53,"_191":53,"_192":44,"_193":-5,"_194":-7,"_195":-7,"_196":78,"_197":53,"_198":53,"_199":-5,"_200":53,"_201":53,"_202":53,"_203":-5},"ENV",{"_155":156,"_157":158,"_159":16,"_160":161,"_162":163,"_164":165,"_166":167,"_168":169,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","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"]

Code