Draftsim Content Spend

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_152":153,"_154":155},"routes/_app.x.$handle.$name",{"_94":93,"_32":45,"_102":84,"_27":53,"_13":14,"_103":-5,"_11":104,"_105":106,"_107":108,"_109":110,"_111":112,"_20":-5,"_113":-5,"_114":-5,"_115":25,"_116":117,"_118":119,"_120":-5,"_121":-5,"_122":123},"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":-5,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":78,"_79":80,"_81":82,"_83":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":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","main.ts","latestPath","fileId","313b61ce-74ce-11f1-80b1-1607ee4eb77e","name","fileType","http","content","// contentSpend.valtown.ts - Draftsim Content Spend dashboard (val.town HTTP val).\n//\n// GENERATED by build-valtown.mjs from core.mjs + render.mjs.\n// Do not edit by hand; edit those sources and re-run `node build-valtown.mjs`.\n//\n// Deploy (free tier / public code, private data):\n// 1. Upload history.json -> private blob \"contentspend_history\"\n// and rates.json -> private blob \"contentspend_rates\".\n// 2. Create a new HTTP val, paste this whole file.\n// 3. Set env vars: ASANA_TOKEN (required) and ACCESS_KEY (recommended).\n// The pay numbers live in your private blobs, never in this public source.\nimport { blob } from \"https://esm.town/v/std/blob\";\n\n// ---------------------------------------------------------------------------\n// core (embedded from core.mjs)\n// ---------------------------------------------------------------------------\n// core.mjs - runtime-agnostic data layer (Node 18+ and Deno both have global fetch).\n// No env/fs access here; the caller passes the Asana token, history and rates.\n// This same source is embedded verbatim into the val.town build (see build-valtown.mjs),\n// so the local demo and the hosted val compute identically.\n//\n// Two Asana projects feed this:\n// - \"Draftsim Articles\" = the SEO pipeline (writing + editing, per-word)\n// - \"Draftsim News\" = the News pipeline (writing per-word + hourly news labor)\n// A task can live in both; we classify by project membership (News wins).\n\nconst ASANA_BASE = \"https://app.asana.com/api/1.0\";\nconst ARTICLES_PROJECT_GID = \"1200493284657065\";\nconst ARTICLES_PUBLISHED_SECTION = \"1200493284657075\"; // \"Published (Done)\"\nconst NEWS_PROJECT_GID = \"1207991285052821\";\nconst NEWS_PROJECT_NAME = \"Draftsim News\";\nconst NEWS_PUBLISHED_SECTION = \"1207991285052828\"; // \"Published\"\nconst DEFAULTS = { writingRate: 0.037, editingRate: 0.02, fixedAvgMonths: 3 };\n\n// News / Video allocation rules. Some of this is a manual monthly input - update\n// herkoNewsHours each month from his timesheet.\nconst NEWS_CONFIG = {\n // people whose news work is hourly (NOT per-word) - excluded from per-word news writing\n hourlyNewsPeople: [\"Herko Kerghans\", \"Eli Weinberg\", \"Elias Weinberg\"],\n eliNames: [\"Eli Weinberg\", \"Elias Weinberg\"],\n eliSplit: { news: 0.6, video: 0.4 }, // split of Eli's hourly pay\n herkoName: \"Herko Kerghans\",\n herkoNewsHours: 15, // HARDCODED for the current month - update monthly\n herkoHourlyRate: 16.5,\n};\n\nasync function asanaGet(pathAndQuery, token) {\n const res = await fetch(`${ASANA_BASE}${pathAndQuery}`, {\n headers: { Authorization: `Bearer ${token}`, Accept: \"application/json\" },\n });\n if (!res.ok) {\n throw new Error(\n `Asana ${pathAndQuery} -> ${res.status} ${await res.text()}`,\n );\n }\n return res.json();\n}\n\nconst TASK_FIELDS =\n \"name,projects.name,tags.name,custom_fields.name,custom_fields.display_value,custom_fields.number_value,custom_fields.date_value\";\n\nasync function fetchSectionTasks(sectionGid, token) {\n const tasks = [];\n let offset;\n while (true) {\n const q = new URLSearchParams({ limit: \"100\", opt_fields: TASK_FIELDS });\n if (offset) q.set(\"offset\", offset);\n const data = await asanaGet(`/sections/${sectionGid}/tasks?${q}`, token);\n tasks.push(...data.data);\n offset = data.next_page?.offset;\n if (!offset) break;\n }\n return tasks;\n}\n\nfunction cfMap(task) {\n const m = {};\n for (const cf of task.custom_fields || []) m[cf.name] = cf;\n return m;\n}\n\nconst SET_CODE = /^[A-Z0-9]{2,4}$/; // MTG set-code tags: MSH, FDN, DSK, TDM...\n\n// Sub-type for an SEO (Articles) item, from its tags.\nfunction seoSubtype(task) {\n const tags = (task.tags || []).map((t) => t.name);\n if (tags.includes(\"Writer Update\") || /\$update\$/i.test(task.name)) {\n return { cls: \"Update\", setCode: null };\n }\n const set = tags.find((t) => SET_CODE.test(t));\n if (set) return { cls: \"New set\", setCode: set };\n if (tags.includes(\"New\")) return { cls: \"New article\", setCode: null };\n return { cls: \"Other SEO\", setCode: null };\n}\n\nfunction inNewsProject(task) {\n return (task.projects || []).some((p) => p.name === NEWS_PROJECT_NAME);\n}\n\nfunction pubDate(cf) {\n const dv = cf[\"Publish Date\"]?.date_value;\n return dv && typeof dv === \"object\" ? dv.date : null;\n}\n\n// Aggregate the current month across both pipelines, pricing each writer/editor at\n// their own per-word rate from payroll. SEO comes from the Articles section\n// (excluding items that are also in Draftsim News); News comes from the News\n// section (current month only). Hourly news people (Herko, Eli) are excluded from\n// per-word news - their pay is added as fixed news/video labor in assembleData.\nfunction buildCurrentMonth(articleTasks, newsTasks, rates, now = new Date()) {\n const key = `${now.getFullYear()}-${\n String(now.getMonth() + 1).padStart(2, \"0\")\n }`;\n const daysInMonth = new Date(now.getFullYear(), now.getMonth() + 1, 0)\n .getDate();\n const dayOfMonth = now.getDate();\n const fracElapsed = dayOfMonth / daysInMonth;\n\n const wRate = (n) => {\n const known = rates.writers[n] != null;\n return {\n rate: known ? rates.writers[n] : rates.defaultWriteRate,\n fallback: !known,\n };\n };\n const eRate = (n) => {\n const r = rates.editors[n];\n if (r && r.type === \"hourly\") return { type: \"hourly\", rate: r.rate };\n const known = !!(r && r.type === \"perword\");\n return {\n type: \"perword\",\n rate: known ? r.rate : rates.defaultEditRate,\n fallback: !known,\n };\n };\n\n const articleList = [];\n\n // ---- SEO (Articles section, excluding items also in Draftsim News) ----\n const seoAuthors = new Map(), seoEditors = new Map();\n let seoWriting = 0,\n seoWrittenWords = 0,\n seoEditing = 0,\n seoEditedWords = 0,\n seoArticles = 0;\n for (const t of articleTasks) {\n const cf = cfMap(t);\n const wc = cf[\"Word Count\"]?.number_value || 0;\n const pub = pubDate(cf);\n const monthKey = pub ? pub.slice(0, 7) : key; // section is current-month only\n if (monthKey !== key) continue;\n if (inNewsProject(t)) continue; // it's a News item, counted below\n const author = cf[\"Author\"]?.display_value || null;\n const editor = cf[\"Editor\"]?.display_value || null;\n const { cls, setCode } = seoSubtype(t);\n seoArticles++;\n articleList.push({\n name: t.name,\n url: cf[\"URL\"]?.display_value || null,\n type: cf[\"Article Type\"]?.display_value || null,\n cls,\n setCode,\n pipeline: \"SEO\",\n words: wc,\n author,\n editor,\n date: pub,\n });\n if (author) {\n seoWriting += wc * wRate(author).rate;\n seoWrittenWords += wc;\n const a = seoAuthors.get(author) ||\n { name: author, words: 0, articles: 0 };\n a.words += wc;\n a.articles++;\n seoAuthors.set(author, a);\n }\n if (editor) {\n const ei = eRate(editor);\n if (ei.type === \"perword\") {\n seoEditing += wc * ei.rate;\n seoEditedWords += wc;\n }\n const e = seoEditors.get(editor) ||\n { name: editor, words: 0, articles: 0 };\n e.words += wc;\n e.articles++;\n seoEditors.set(editor, e);\n }\n }\n\n // ---- News (News section, current month; per-word writers excl. hourly news people) ----\n const hourlyNews = new Set(NEWS_CONFIG.hourlyNewsPeople);\n const newsAuthors = new Map();\n let newsWriting = 0,\n newsWrittenWords = 0,\n newsTotalWords = 0,\n newsArticles = 0;\n for (const t of newsTasks) {\n const cf = cfMap(t);\n const pub = pubDate(cf);\n if (!pub || pub.slice(0, 7) !== key) continue; // News section keeps all history\n const wc = cf[\"Word Count\"]?.number_value || 0;\n const author = cf[\"Author\"]?.display_value || null;\n newsArticles++;\n newsTotalWords += wc;\n articleList.push({\n name: t.name,\n url: cf[\"URL\"]?.display_value || null,\n type: cf[\"Type\"]?.display_value || null,\n cls: \"News\",\n setCode: null,\n pipeline: \"News\",\n words: wc,\n author,\n editor: null,\n date: pub,\n });\n if (author && !hourlyNews.has(author)) {\n newsWriting += wc * wRate(author).rate;\n newsWrittenWords += wc;\n const a = newsAuthors.get(author) ||\n { name: author, words: 0, articles: 0 };\n a.words += wc;\n a.articles++;\n newsAuthors.set(author, a);\n }\n }\n\n const mkWriters = (m, pipeline) =>\n [...m.values()].sort((a, b) => b.words - a.words).map((a) => {\n const { rate, fallback } = wRate(a.name);\n return { ...a, rate, cost: a.words * rate, fallback, pipeline };\n });\n const mkEditors = (m) =>\n [...m.values()].sort((a, b) => b.words - a.words).map((e) => {\n const ei = eRate(e.name);\n if (ei.type === \"hourly\") {\n return {\n ...e,\n type: \"hourly\",\n rate: ei.rate,\n cost: null,\n fallback: false,\n };\n }\n return {\n ...e,\n type: \"perword\",\n rate: ei.rate,\n cost: e.words * ei.rate,\n fallback: !!ei.fallback,\n };\n });\n\n return {\n key,\n label: now.toLocaleString(\"en-US\", { month: \"long\", year: \"numeric\" }),\n dayOfMonth,\n daysInMonth,\n fracElapsed,\n seo: {\n writingCost: seoWriting,\n writtenWords: seoWrittenWords,\n editingCost: seoEditing,\n editedWords: seoEditedWords,\n articles: seoArticles,\n byAuthor: mkWriters(seoAuthors, \"SEO\"),\n byEditor: mkEditors(seoEditors),\n },\n news: {\n writingCost: newsWriting,\n writtenWords: newsWrittenWords,\n totalWords: newsTotalWords,\n articles: newsArticles,\n byAuthor: mkWriters(newsAuthors, \"News\"),\n },\n articleList: articleList.sort((a, b) => b.words - a.words),\n articles: articleList.length,\n };\n}\n\n// Live Asana fetch (both projects) + the history/rates snapshots + fixed News/Video amounts.\nasync function assembleData(token, history, rates, now = new Date()) {\n const [articleTasks, newsTasks] = await Promise.all([\n fetchSectionTasks(ARTICLES_PUBLISHED_SECTION, token),\n fetchSectionTasks(NEWS_PUBLISHED_SECTION, token),\n ]);\n const currentMonth = buildCurrentMonth(articleTasks, newsTasks, rates, now);\n\n // Fixed News/Video labor amounts (not word-count-derived): Eli's hourly pay\n // split 60/40 news/video, David's video editing, Herko's hardcoded news hours.\n const nv = history.newsVideo || {};\n const recur = history.recurring || [];\n const recurAmt = (name) => (recur.find((x) => x.name === name)?.avg3) || 0;\n const eliHourly = nv.eliHourly != null\n ? nv.eliHourly\n : NEWS_CONFIG.eliNames.reduce((s, n) => s + recurAmt(n), 0);\n const davidVideo = nv.davidVideo || 0;\n\n const newsVideo = {\n eliHourly,\n davidVideo,\n eliNews: eliHourly * NEWS_CONFIG.eliSplit.news,\n eliVideo: eliHourly * NEWS_CONFIG.eliSplit.video,\n eliSplit: NEWS_CONFIG.eliSplit,\n herkoHours: NEWS_CONFIG.herkoNewsHours,\n herkoRate: NEWS_CONFIG.herkoHourlyRate,\n herkoNews: NEWS_CONFIG.herkoNewsHours * NEWS_CONFIG.herkoHourlyRate,\n };\n\n return {\n generatedAt: now.toLocaleString(\"en-US\", {\n month: \"short\",\n day: \"numeric\",\n year: \"numeric\",\n hour: \"numeric\",\n minute: \"2-digit\",\n }),\n defaults: DEFAULTS,\n rates,\n currentMonth,\n newsVideo,\n history: history.months,\n lastClosedMonth: history.lastClosedMonth,\n recurring: history.recurring || [],\n };\n}\n\n// ---------------------------------------------------------------------------\n// render (embedded from render.mjs)\n// ---------------------------------------------------------------------------\n// render.mjs - dashboard HTML + client logic for the Draftsim content-spend tracker.\n// Pure: takes the assembled `data` object and returns an HTML string.\n// Current month splits into SEO (Draftsim Articles) / News (Draftsim News) / Video,\n// each writer/editor priced at their own payroll rate (editable inline).\n\nfunction renderPage(data) {\n const json = JSON.stringify(data).replace(/\n\n\n\n\nDraftsim Content Spend\n\n\n\n \n\n

\n Fixed-pay average\n

\n \n \n \n

\n history window for the hourly/salary/contractor forecast\n

\n Current-month basis\n

\n \n \n

\n \n

\n \n \n per-person rates from payroll: edit any below\n

\n\n

Monthly content spend

\n\n

This month: writers

SEO words (Articles) + News words (News project), each at the writer's rate.

\n \n \n \n

Writer	SEO words	News words	$/word	Est. $

This month: editors & news/video labor

SEO editing is per-word; news & video labor is hourly/fixed.

\n \n \n \n

Person	Role	Basis	Rate	Est. $

\n\n

Expected pay this month — by person

SEO writing + News writing + editing + recurring/fixed pay, per person.

\n \n \n \n

Person	SEO writing	News	Editing	Video / fixed	Total

\n\n

By pipeline / content type

SEO sub-types (Articles tags) and News, with cost.

\n \n \n \n

Pipeline / type	Articles	Words	Cost

By article type

Asana \"Article Type\" / \"Type\" field.

\n \n \n \n

Article type	Articles	Words	Cost

\n\n

Articles published this month

Every published item with pipeline, word count and estimated cost. Click a header to sort.

\n \n \n \n \n \n \n \n \n \n \n \n

Article	Pipeline	Type	Writer	Editor	Words	Cost

\n\n

Recent months — actual paid (from payroll)

Real dollars paid per category (writing here = SEO + News combined; payroll doesn't separate them). Current month is a live estimate.

\n \n \n \n

Month	Writing	Editing	Hourly	Salary	Contractor	Total

\n\n

\n\n\n\n`;\n}\n\n// ---------------------------------------------------------------------------\n// login page (shown until the password is entered)\n// ---------------------------------------------------------------------------\nfunction loginPage(error) {\n return '' +\n '' +\n \"Draftsim Content Spend\" +\n '\";\n}\n\n// ---------------------------------------------------------------------------\n// val.town HTTP handler\n// ---------------------------------------------------------------------------\nexport default async function (req: Request): Promise {\n // Everything sensitive lives in PRIVATE blob storage (this source is public on\n // the free tier): pay data in contentspend_history / contentspend_rates, and the\n // Asana token + access key in contentspend_config = { asanaToken, accessKey }.\n // Env vars (ASANA_TOKEN / ACCESS_KEY) override the config blob if you set them.\n let HISTORY: any, RATES: any, CFG: any;\n try {\n [HISTORY, RATES, CFG] = await Promise.all([\n blob.getJSON(\"contentspend_history\"),\n blob.getJSON(\"contentspend_rates\"),\n blob.getJSON(\"contentspend_config\").catch(() => null),\n ]);\n } catch (e: any) {\n return new Response(\"Could not read data blobs: \" + e.message, {\n status: 500,\n });\n }\n if (!HISTORY || !RATES) {\n return new Response(\n \"Missing data blobs. Upload contentspend_history and contentspend_rates.\",\n { status: 500 },\n );\n }\n\n // Access gate: password-protected via an in-page login form (the page asks for\n // the password before showing any data). The access key is accessKey in the\n // config blob (or the ACCESS_KEY env var). A signed-in cookie persists the\n // session; ?key= or an Authorization: Bearer header also work for\n // bookmarks / API calls.\n const gate = Deno.env.get(\"ACCESS_KEY\") || (CFG && CFG.accessKey);\n const reqUrl = new URL(req.url);\n if (gate) {\n // login form submission\n if (req.method === \"POST\") {\n const form = await req.formData().catch(() => null);\n if (form && form.get(\"password\") === gate) {\n return new Response(null, {\n status: 302,\n headers: {\n \"Location\": \"/\",\n \"Set-Cookie\": \"cs_auth=\" + encodeURIComponent(gate) +\n \"; Path=/; HttpOnly; Secure; SameSite=Lax; Max-Age=2592000\",\n },\n });\n }\n return new Response(loginPage(true), {\n status: 401,\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n }\n // already authenticated? (session cookie, ?key=, or Bearer header)\n const auth = req.headers.get(\"authorization\") || \"\";\n const cookie = req.headers.get(\"cookie\") || \"\";\n const cm = cookie.match(/(?:^|;\\s*)cs_auth=([^;]+)/);\n const authed = reqUrl.searchParams.get(\"key\") === gate ||\n (/^Bearer\\s+/i.test(auth) && auth.replace(/^Bearer\\s+/i, \"\") === gate) ||\n (cm ? decodeURIComponent(cm[1]) === gate : false);\n if (!authed) {\n if (reqUrl.pathname.startsWith(\"/api\")) {\n return new Response(\"Unauthorized\", { status: 401 });\n }\n return new Response(loginPage(false), {\n status: 401,\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n }\n }\n\n const token = Deno.env.get(\"ASANA_TOKEN\") || (CFG && CFG.asanaToken);\n if (!token) {\n return new Response(\n \"Missing Asana token (set ASANA_TOKEN env var or asanaToken in contentspend_config).\",\n { status: 500 },\n );\n }\n\n try {\n const data = await assembleData(token, HISTORY, RATES);\n if (new URL(req.url).pathname.startsWith(\"/api\")) {\n return new Response(JSON.stringify(data, null, 2), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n return new Response(renderPage(data), {\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n } catch (err: any) {\n return new Response(\n `

Error: ${err.message}\\n\\n${err.stack}

`,\n { status: 500, headers: { \"Content-Type\": \"text/html\" } },\n );\n }\n}","// contentSpend.valtown.ts - Draftsim Content Spend dashboard (val.town HTTP val).\n//\n// GENERATED by build-valtown.mjs from core.mjs + render.mjs.\n// Do not edit by hand; edit those sources and re-run `node build-valtown.mjs`.\n//\n// Deploy (free tier / public code, private data):\n// 1. Upload history.json -> private blob \"contentspend_history\"\n// and rates.json -> private blob \"contentspend_rates\".\n// 2. Create a new HTTP val, paste this whole file.\n// 3. Set env vars: ASANA_TOKEN (required) and ACCESS_KEY (recommended).\n// The pay numbers live in your private blobs, never in this public source.\nimport { blob } from \"https://esm.town/v/std/blob\";\n\n// ---------------------------------------------------------------------------\n// core (embedded from core.mjs)\n// ---------------------------------------------------------------------------\n// core.mjs - runtime-agnostic data layer (Node 18+ and Deno both have global fetch).\n// No env/fs access here; the caller passes the Asana token, history and rates.\n// This same source is embedded verbatim into the val.town build (see build-valtown.mjs),\n// so the local demo and the hosted val compute identically.\n//\n// Two Asana projects feed this:\n// - \"Draftsim Articles\" = the SEO pipeline (writing + editing, per-word)\n// - \"Draftsim News\" = the News pipeline (writing per-word + hourly news labor)\n// A task can live in both; we classify by project membership (News wins).\n\nconst ASANA_BASE = \"https://app.asana.com/api/1.0\";\nconst ARTICLES_PROJECT_GID = \"1200493284657065\";\nconst ARTICLES_PUBLISHED_SECTION = \"1200493284657075\"; // \"Published (Done)\"\nconst NEWS_PROJECT_GID = \"1207991285052821\";\nconst NEWS_PROJECT_NAME = \"Draftsim News\";\nconst NEWS_PUBLISHED_SECTION = \"1207991285052828\"; // \"Published\"\nconst DEFAULTS = { writingRate: 0.037, editingRate: 0.02, fixedAvgMonths: 3 };\n\n// News / Video allocation rules. Some of this is a manual monthly input - update\n// herkoNewsHours each month from his timesheet.\nconst NEWS_CONFIG = {\n // people whose news work is hourly (NOT per-word) - excluded from per-word news writing\n hourlyNewsPeople: [\"Herko Kerghans\", \"Eli Weinberg\", \"Elias Weinberg\"],\n eliNames: [\"Eli Weinberg\", \"Elias Weinberg\"],\n eliSplit: { news: 0.6, video: 0.4 }, // split of Eli's hourly pay\n herkoName: \"Herko Kerghans\",\n herkoNewsHours: 15, // HARDCODED for the current month - update monthly\n herkoHourlyRate: 16.5,\n};\n\nasync function asanaGet(pathAndQuery, token) {\n const res = await fetch(`${ASANA_BASE}${pathAndQuery}`, {\n headers: { Authorization: `Bearer ${token}`, Accept: \"application/json\" },\n });\n if (!res.ok) {\n throw new Error(\n `Asana ${pathAndQuery} -> ${res.status} ${await res.text()}`,\n );\n }\n return res.json();\n}\n\nconst TASK_FIELDS =\n \"name,projects.name,tags.name,custom_fields.name,custom_fields.display_value,custom_fields.number_value,custom_fields.date_value\";\n\nasync function fetchSectionTasks(sectionGid, token) {\n const tasks = [];\n let offset;\n while (true) {\n const q = new URLSearchParams({ limit: \"100\", opt_fields: TASK_FIELDS });\n if (offset) q.set(\"offset\", offset);\n const data = await asanaGet(`/sections/${sectionGid}/tasks?${q}`, token);\n tasks.push(...data.data);\n offset = data.next_page?.offset;\n if (!offset) break;\n }\n return tasks;\n}\n\nfunction cfMap(task) {\n const m = {};\n for (const cf of task.custom_fields || []) m[cf.name] = cf;\n return m;\n}\n\nconst SET_CODE = /^[A-Z0-9]{2,4}$/; // MTG set-code tags: MSH, FDN, DSK, TDM...\n\n// Sub-type for an SEO (Articles) item, from its tags.\nfunction seoSubtype(task) {\n const tags = (task.tags || []).map((t) => t.name);\n if (tags.includes(\"Writer Update\") || /\$update\$/i.test(task.name)) {\n return { cls: \"Update\", setCode: null };\n }\n const set = tags.find((t) => SET_CODE.test(t));\n if (set) return { cls: \"New set\", setCode: set };\n if (tags.includes(\"New\")) return { cls: \"New article\", setCode: null };\n return { cls: \"Other SEO\", setCode: null };\n}\n\nfunction inNewsProject(task) {\n return (task.projects || []).some((p) => p.name === NEWS_PROJECT_NAME);\n}\n\nfunction pubDate(cf) {\n const dv = cf[\"Publish Date\"]?.date_value;\n return dv && typeof dv === \"object\" ? dv.date : null;\n}\n\n// Aggregate the current month across both pipelines, pricing each writer/editor at\n// their own per-word rate from payroll. SEO comes from the Articles section\n// (excluding items that are also in Draftsim News); News comes from the News\n// section (current month only). Hourly news people (Herko, Eli) are excluded from\n// per-word news - their pay is added as fixed news/video labor in assembleData.\nfunction buildCurrentMonth(articleTasks, newsTasks, rates, now = new Date()) {\n const key = `${now.getFullYear()}-${\n String(now.getMonth() + 1).padStart(2, \"0\")\n }`;\n const daysInMonth = new Date(now.getFullYear(), now.getMonth() + 1, 0)\n .getDate();\n const dayOfMonth = now.getDate();\n const fracElapsed = dayOfMonth / daysInMonth;\n\n const wRate = (n) => {\n const known = rates.writers[n] != null;\n return {\n rate: known ? rates.writers[n] : rates.defaultWriteRate,\n fallback: !known,\n };\n };\n const eRate = (n) => {\n const r = rates.editors[n];\n if (r && r.type === \"hourly\") return { type: \"hourly\", rate: r.rate };\n const known = !!(r && r.type === \"perword\");\n return {\n type: \"perword\",\n rate: known ? r.rate : rates.defaultEditRate,\n fallback: !known,\n };\n };\n\n const articleList = [];\n\n // ---- SEO (Articles section, excluding items also in Draftsim News) ----\n const seoAuthors = new Map(), seoEditors = new Map();\n let seoWriting = 0,\n seoWrittenWords = 0,\n seoEditing = 0,\n seoEditedWords = 0,\n seoArticles = 0;\n for (const t of articleTasks) {\n const cf = cfMap(t);\n const wc = cf[\"Word Count\"]?.number_value || 0;\n const pub = pubDate(cf);\n const monthKey = pub ? pub.slice(0, 7) : key; // section is current-month only\n if (monthKey !== key) continue;\n if (inNewsProject(t)) continue; // it's a News item, counted below\n const author = cf[\"Author\"]?.display_value || null;\n const editor = cf[\"Editor\"]?.display_value || null;\n const { cls, setCode } = seoSubtype(t);\n seoArticles++;\n articleList.push({\n name: t.name,\n url: cf[\"URL\"]?.display_value || null,\n type: cf[\"Article Type\"]?.display_value || null,\n cls,\n setCode,\n pipeline: \"SEO\",\n words: wc,\n author,\n editor,\n date: pub,\n });\n if (author) {\n seoWriting += wc * wRate(author).rate;\n seoWrittenWords += wc;\n const a = seoAuthors.get(author) ||\n { name: author, words: 0, articles: 0 };\n a.words += wc;\n a.articles++;\n seoAuthors.set(author, a);\n }\n if (editor) {\n const ei = eRate(editor);\n if (ei.type === \"perword\") {\n seoEditing += wc * ei.rate;\n seoEditedWords += wc;\n }\n const e = seoEditors.get(editor) ||\n { name: editor, words: 0, articles: 0 };\n e.words += wc;\n e.articles++;\n seoEditors.set(editor, e);\n }\n }\n\n // ---- News (News section, current month; per-word writers excl. hourly news people) ----\n const hourlyNews = new Set(NEWS_CONFIG.hourlyNewsPeople);\n const newsAuthors = new Map();\n let newsWriting = 0,\n newsWrittenWords = 0,\n newsTotalWords = 0,\n newsArticles = 0;\n for (const t of newsTasks) {\n const cf = cfMap(t);\n const pub = pubDate(cf);\n if (!pub || pub.slice(0, 7) !== key) continue; // News section keeps all history\n const wc = cf[\"Word Count\"]?.number_value || 0;\n const author = cf[\"Author\"]?.display_value || null;\n newsArticles++;\n newsTotalWords += wc;\n articleList.push({\n name: t.name,\n url: cf[\"URL\"]?.display_value || null,\n type: cf[\"Type\"]?.display_value || null,\n cls: \"News\",\n setCode: null,\n pipeline: \"News\",\n words: wc,\n author,\n editor: null,\n date: pub,\n });\n if (author && !hourlyNews.has(author)) {\n newsWriting += wc * wRate(author).rate;\n newsWrittenWords += wc;\n const a = newsAuthors.get(author) ||\n { name: author, words: 0, articles: 0 };\n a.words += wc;\n a.articles++;\n newsAuthors.set(author, a);\n }\n }\n\n const mkWriters = (m, pipeline) =>\n [...m.values()].sort((a, b) => b.words - a.words).map((a) => {\n const { rate, fallback } = wRate(a.name);\n return { ...a, rate, cost: a.words * rate, fallback, pipeline };\n });\n const mkEditors = (m) =>\n [...m.values()].sort((a, b) => b.words - a.words).map((e) => {\n const ei = eRate(e.name);\n if (ei.type === \"hourly\") {\n return {\n ...e,\n type: \"hourly\",\n rate: ei.rate,\n cost: null,\n fallback: false,\n };\n }\n return {\n ...e,\n type: \"perword\",\n rate: ei.rate,\n cost: e.words * ei.rate,\n fallback: !!ei.fallback,\n };\n });\n\n return {\n key,\n label: now.toLocaleString(\"en-US\", { month: \"long\", year: \"numeric\" }),\n dayOfMonth,\n daysInMonth,\n fracElapsed,\n seo: {\n writingCost: seoWriting,\n writtenWords: seoWrittenWords,\n editingCost: seoEditing,\n editedWords: seoEditedWords,\n articles: seoArticles,\n byAuthor: mkWriters(seoAuthors, \"SEO\"),\n byEditor: mkEditors(seoEditors),\n },\n news: {\n writingCost: newsWriting,\n writtenWords: newsWrittenWords,\n totalWords: newsTotalWords,\n articles: newsArticles,\n byAuthor: mkWriters(newsAuthors, \"News\"),\n },\n articleList: articleList.sort((a, b) => b.words - a.words),\n articles: articleList.length,\n };\n}\n\n// Live Asana fetch (both projects) + the history/rates snapshots + fixed News/Video amounts.\nasync function assembleData(token, history, rates, now = new Date()) {\n const [articleTasks, newsTasks] = await Promise.all([\n fetchSectionTasks(ARTICLES_PUBLISHED_SECTION, token),\n fetchSectionTasks(NEWS_PUBLISHED_SECTION, token),\n ]);\n const currentMonth = buildCurrentMonth(articleTasks, newsTasks, rates, now);\n\n // Fixed News/Video labor amounts (not word-count-derived): Eli's hourly pay\n // split 60/40 news/video, David's video editing, Herko's hardcoded news hours.\n const nv = history.newsVideo || {};\n const recur = history.recurring || [];\n const recurAmt = (name) => (recur.find((x) => x.name === name)?.avg3) || 0;\n const eliHourly = nv.eliHourly != null\n ? nv.eliHourly\n : NEWS_CONFIG.eliNames.reduce((s, n) => s + recurAmt(n), 0);\n const davidVideo = nv.davidVideo || 0;\n\n const newsVideo = {\n eliHourly,\n davidVideo,\n eliNews: eliHourly * NEWS_CONFIG.eliSplit.news,\n eliVideo: eliHourly * NEWS_CONFIG.eliSplit.video,\n eliSplit: NEWS_CONFIG.eliSplit,\n herkoHours: NEWS_CONFIG.herkoNewsHours,\n herkoRate: NEWS_CONFIG.herkoHourlyRate,\n herkoNews: NEWS_CONFIG.herkoNewsHours * NEWS_CONFIG.herkoHourlyRate,\n };\n\n return {\n generatedAt: now.toLocaleString(\"en-US\", {\n month: \"short\",\n day: \"numeric\",\n year: \"numeric\",\n hour: \"numeric\",\n minute: \"2-digit\",\n }),\n defaults: DEFAULTS,\n rates,\n currentMonth,\n newsVideo,\n history: history.months,\n lastClosedMonth: history.lastClosedMonth,\n recurring: history.recurring || [],\n departedFixed: history.departedFixed || 0,\n };\n}\n\n// ---------------------------------------------------------------------------\n// render (embedded from render.mjs)\n// ---------------------------------------------------------------------------\n// render.mjs - dashboard HTML + client logic for the Draftsim content-spend tracker.\n// Pure: takes the assembled `data` object and returns an HTML string.\n// Current month splits into SEO (Draftsim Articles) / News (Draftsim News) / Video,\n// each writer/editor priced at their own payroll rate (editable inline).\n\nfunction renderPage(data) {\n const json = JSON.stringify(data).replace(/\n\n\n\n\nDraftsim Content Spend\n\n\n\n \n\n

\n Fixed-pay average\n

\n \n \n \n

\n history window for the hourly/salary/contractor forecast\n

\n Current-month basis\n

\n \n \n

\n \n

\n \n \n per-person rates from payroll: edit any below\n

\n\n

Monthly content spend

\n\n

This month: writers

SEO words (Articles) + News words (News project), each at the writer's rate.

\n \n \n \n

Writer	SEO words	News words	$/word	Est. $

This month: editors & news/video labor

SEO editing is per-word; news & video labor is hourly/fixed.

\n \n \n \n

Person	Role	Basis	Rate	Est. $

\n\n

Expected pay this month — by person

SEO writing + News writing + editing + recurring/fixed pay, per person.

\n \n \n \n

Person	SEO writing	News	Editing	Video / fixed	Total

\n\n

By pipeline / content type

SEO sub-types (Articles tags) and News, with cost.

\n \n \n \n

Pipeline / type	Articles	Words	Cost

By article type

Asana \"Article Type\" / \"Type\" field.

\n \n \n \n

Article type	Articles	Words	Cost

\n\n

Articles published this month

Every published item with pipeline, word count and estimated cost. Click a header to sort.

\n \n \n \n \n \n \n \n \n \n \n \n

Article	Pipeline	Type	Writer	Editor	Words	Cost

\n\n

Recent months — actual paid (from payroll)

Real dollars paid per category (writing here = SEO + News combined; payroll doesn't separate them). Current month is a live estimate.

\n \n \n \n

Month	Writing	Editing	Hourly	Salary	Contractor	Total

\n\n

Error: ${err.message}\\n\\n${err.stack}

`,\n { status: 500, headers: { \"Content-Type\": \"text/html\" } },\n );\n }\n}","createdAt",["D",1782862177785],"branchVersion","branchId","cae77d29-818c-492b-959e-6a982f9df982","id","e7d98772-0509-432f-b71a-a6330d42ebc1","content-spend",["D",1782856436302],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","019bd925-31f2-71b7-9f59-cedf4ab98166","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019bd925-31f2-71b7-9f59-d0cff0553afe","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_94":93,"_101":97},"org",{"_94":93,"_95":-5,"_96":97,"_18":55,"_98":99,"_100":25},"branch",{"_13":14,"_32":84,"_43":42,"_85":44,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":45,"_92":93},"isOwned","main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","Jakedraftsim","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzM4VkIyMW5TdXh3TEVDZHZIcllIQ0d1blF1OSJ9","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_43":44,"_32":45,"_38":148,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":-5,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":149,"_79":150,"_81":151,"_83":25},"tree",[143],"files",[143],"counts",{"_132":61,"_133":134,"_135":61,"_136":137,"_138":139},"contents",[124],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_43":125,"_32":28,"_30":31,"_126":-5,"_41":42,"_40":14,"_127":119,"_38":128,"_13":129,"_33":34,"_35":37,"_24":25,"_130":-5,"_27":131},"a0809364-6e95-4f35-988c-aa3a46a98540","parentId","latest",["D",1782862177785],7,"label",[28],"pulls","branches",1,"forks","envVars",{"_140":61,"_142":61},"connections",{"_140":61,"_141":61},"count","unfilledCount","emptyCount",{"_43":125,"_32":28,"_30":31,"_126":-5,"_41":42,"_40":14,"_127":119,"_38":144,"_13":129,"_33":34,"_35":37,"_24":25,"_130":-5,"_145":146,"_27":147},["D",1782862177785],"children",[],[28],["D",1782856436302],{"_94":93,"_101":97},{"_94":93,"_95":-5,"_96":97,"_18":55,"_98":99,"_100":25},{"_13":14,"_32":84,"_43":42,"_85":44,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":45,"_92":93},"ctx",{"_77":-5,"_121":185,"_186":187,"_188":189,"_190":25,"_191":25,"_192":25,"_193":119,"_194":-5,"_195":-7,"_196":-7,"_197":61,"_198":25,"_199":25,"_200":-5,"_201":25,"_202":25,"_203":25,"_204":-5},"ENV",{"_156":157,"_158":159,"_160":84,"_161":162,"_163":164,"_165":166,"_167":168,"_169":170,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184},"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