[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_103":104,"_105":106},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","rneill2000","name","figgy-dashboard","path","gifting.ts","project",{"_22":45,"_11":12,"_33":46,"_47":-5,"_48":42,"_49":50,"_51":50,"_52":53,"_54":-5,"_55":56,"_57":58,"_59":32,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":-5,"_67":-5,"_68":-5,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":80,"_81":82,"_83":84,"_85":42},"file",{"_22":23,"_11":14,"_24":25,"_26":-5,"_27":28,"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":-5,"_13":44},"permalink","https://www.val.town/x/rneill2000/figgy-dashboard/code/gifting.ts","extension","id","59854339-6594-4c77-bd9a-de8b2ca1acf6","fileId","197c8b5a-9c13-11f1-8657-1607ee4eb77e","parentId","branchId","92ea88bb-fdfc-4980-81b7-39b17c6f8d3c","branchVersion",28,"latest",true,"createdAt",["D",1787174186482],"version",3,"fileType","script","content","/**\n * Gifting / seeding tracker. Records live in blob storage so they survive\n * restarts, and join to live discount-code performance for real ROI.\n */\n\nconst GIFT_BLOB = \"figgy_gifts\";\n\n/** Editable. Units to seed per month, front-loaded because content needs lead time. */\nexport const GIFT_TARGETS: Record = {\n \"08\": { units: 8, note: \"Start now — these post in September.\" },\n \"09\": { units: 14, note: \"The month that matters. This content carries Q4.\" },\n \"10\": { units: 14, note: \"Last useful window for pre-Black Friday content.\" },\n \"11\": { units: 6, note: \"Only fast-turnaround creators.\" },\n \"12\": { units: 3, note: \"Seeding for Q1, not this season.\" },\n \"01\": { units: 6, note: \"Rebuild the pipeline after the peak.\" },\n \"02\": { units: 6, note: \"\" }, \"03\": { units: 6, note: \"\" }, \"04\": { units: 6, note: \"\" },\n \"05\": { units: 6, note: \"\" }, \"06\": { units: 8, note: \"Back-to-school content starts here.\" },\n \"07\": { units: 8, note: \"Back-to-school content starts here.\" },\n};\n\n/** All-in cost of one gifted Figgy: unit cost plus freight on a bulky item. */\nexport const GIFT_COST = 140;\n\nexport interface Gift {\n id: string;\n name: string;\n handle: string;\n code: string;\n colour: string;\n sentAt: string;\n posted: boolean;\n note: string;\n}\n\nexport async function loadGifts(): Promise {\n try {\n const { blob } = await import(\"https://esm.town/v/std/blob\");\n const v = (await blob.getJSON(GIFT_BLOB)) as Gift[];\n return Array.isArray(v) ? v : [];\n } catch {\n return [];\n }\n}\n\nexport async function saveGifts(g: Gift[]) {\n try {\n const { blob } = await import(\"https://esm.town/v/std/blob\");\n await blob.setJSON(GIFT_BLOB, g);\n } catch { /* best effort */ }\n}\n\nexport interface GiftRow extends Gift {\n orders: number;\n revenue: number;\n grossProfit: number;\n roi: number | null;\n daysSince: number;\n verdict: \"too early\" | \"no return\" | \"paid back\" | \"strong\";\n}\n\n/** Joins each gift to its discount code's real performance. */\nexport function buildGiftRows(\n gifts: Gift[],\n campaigns: Array<{ code: string; orders: number; revenue: number }>,\n marginPct = 73,\n): GiftRow[] {\n const now = Date.now();\n const byCode = new Map(campaigns.map((c) => [c.code.toUpperCase(), c]));\n return gifts.map((g) => {\n const c = byCode.get((g.code || \"\").toUpperCase());\n const orders = c?.orders ?? 0;\n const revenue = c?.revenue ?? 0;\n const grossProfit = revenue * (marginPct / 100);\n const daysSince = Math.floor((now - new Date(g.sentAt).getTime()) / 864e5);\n const roi = GIFT_COST > 0 ? ((grossProfit - GIFT_COST) / GIFT_COST) * 100 : null;\n let verdict: GiftRow[\"verdict\"];\n if (orders === 0 && daysSince < 60) verdict = \"too early\";\n else if (orders === 0) verdict = \"no return\";\n else if (grossProfit >= GIFT_COST * 2) verdict = \"strong\";\n else if (grossProfit >= GIFT_COST) verdict = \"paid back\";\n else verdict = \"no return\";\n return { ...g, orders, revenue, grossProfit, roi, daysSince, verdict };\n }).sort((a, b) => b.revenue - a.revenue || a.sentAt.localeCompare(b.sentAt));\n}\n\nconst esc = (s: string) =>\n String(s ?? \"\").replace(/[&<>\"]/g, (c) => ({ \"&\": \"&\", \"<\": \"<\", \">\": \">\", '\"': \""\" }[c]!));\nconst money = (n: number, cur = \"USD\") =>\n new Intl.NumberFormat(\"en-US\", { style: \"currency\", currency: cur, maximumFractionDigits: 0 }).format(n || 0);\n\nexport function giftSection(rows: GiftRow[], currency: string, dashKey: string): string {\n const mm = String(new Date().getMonth() + 1).padStart(2, \"0\");\n const target = GIFT_TARGETS[mm] ?? { units: 6, note: \"\" };\n const monthPrefix = new Date().toISOString().slice(0, 7);\n const sentThisMonth = rows.filter((r) => r.sentAt.startsWith(monthPrefix)).length;\n const behind = target.units - sentThisMonth;\n\n const spend = rows.length * GIFT_COST;\n const profit = rows.reduce((s, r) => s + r.grossProfit, 0);\n const netRoi = spend > 0 ? ((profit - spend) / spend) * 100 : 0;\n const paidBack = rows.filter((r) => r.verdict === \"paid back\" || r.verdict === \"strong\").length;\n const dead = rows.filter((r) => r.verdict === \"no return\").length;\n\n return `

Gifting

\n ${sentThisMonth} / ${target.units}\n gifted this month\n

\n 0 ? \"over\" : \"\"}\">${behind > 0 ? `${behind} behind target` : \"on target\"}\n

\n ${target.note ? `

${esc(target.note)}

` : \"\"}\n\n ${rows.length\n ? `

\n ${rows.length} gifted all time · ${money(spend, currency)} at cost\n ${money(profit, currency)} gross profit returned\n = 0 ? \"up\" : \"down\"}\">${netRoi >= 0 ? \"+\" : \"\"}${netRoi.toFixed(0)}% net ROI\n ${paidBack} paid back · ${dead} did not\n

\n \n ${rows.slice(0, 20).map((r) => `\n \n \n \n \n \n `).join(\"\")}\n

Creator	Code	Orders	Revenue	Verdict
${esc(r.name)}${r.handle ? ` ${esc(r.handle)} ` : \"\"}	${esc(r.code)}	${r.orders}	${money(r.revenue, currency)}	${esc(r.verdict)} ${r.daysSince}d ago

`\n : `

No gifts recorded yet. Add one below — the code is what makes it measurable.

`}\n\n \n

Cost assumed at ${money(GIFT_COST, currency)} per unit — unit cost plus freight. Revenue is whatever the code actually drove, joined live. Break-even is roughly one order.

\n\n`;\n}\n\nexport function retSection(d: any): string {\n const r = d.retention;\n const cur = d.currency;\n return `

Who is buying

\n New ${money(r.newRevenue, cur)} · ${r.newOrders} orders · ${money(r.newAov, cur)} AOV\n Returning ${money(r.repeatRevenue, cur)} · ${r.repeatOrders} orders · ${money(r.repeatAov, cur)} AOV\n

${r.repeatRevShare.toFixed(0)}% of attributed revenue over the last 26 weeks came from people who had bought before.${\n r.repeatAov > r.newAov\n ? ` Returning customers spend ${money(r.repeatAov - r.newAov, cur)} more per order.`\n : r.newAov > r.repeatAov\n ? ` First orders are ${money(r.newAov - r.repeatAov, cur)} larger — second purchases are add-ons, not couches.`\n : \"\"}

\n ${r.unknownOrders > 0 ? `

${r.unknownOrders} order(s) worth ${money(r.unknownRevenue, cur)} had no customer record (guest checkout) and are excluded from the split rather than guessed at.

` : \"\"}\n

Counted across the 26-week window. Anyone whose lifetime order count exceeds what falls inside it is treated as returning.

\n`;\n}","deleted",false,"label",[14],"196fc02e-3967-4c22-b107-73ead465120f",["D",1787154294799],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Figgy ops: drift, trends, pricing, campaigns, emails","imageUrl","userId","019c9634-cf0e-7564-a473-6d7ef6471105","pinnedFileId","eccf039a-9be4-11f1-aa22-1607ee4eb77e","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019c9634-cf0e-7564-a473-73e1670c6fa4","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_9":10,"_102":98},"org",{"_9":10,"_96":-5,"_97":98,"_55":56,"_99":100,"_101":42},"branch",{"_35":86,"_11":87,"_22":28,"_88":45,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":12,"_95":10},"isOwned",30,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18zQUFzN09QNXRSaXdFZkdubUFOS3F2VGg0bkgifQ","tier","free","canRestrictVals","profileImageUrl","ctx",{"_79":-5,"_136":137,"_138":139,"_140":141,"_142":42,"_143":42,"_144":42,"_145":32,"_146":-5,"_147":-7,"_148":-7,"_149":63,"_150":42,"_151":42,"_152":-5,"_153":42,"_154":42,"_155":42,"_156":-5},"ENV",{"_107":108,"_109":110,"_111":87,"_112":113,"_114":115,"_116":117,"_118":119,"_120":121,"_122":123,"_124":125,"_126":127,"_128":129,"_130":131,"_132":133,"_134":135},"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","orgs",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]