Draftsim Content Spend

\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}","deleted","label",[113],"pulls",1,"forks","envVars",{"_136":52,"_138":52},"connections",{"_136":52,"_137":52},"count","unfilledCount","emptyCount",{"_20":112,"_13":113,"_114":115,"_116":-5,"_117":21,"_118":30,"_119":106,"_22":140,"_29":121,"_122":123,"_124":125,"_126":38,"_127":-5,"_141":142,"_88":143},["D",1782862177785],"children",[],[113],["D",1782856436302],{"_11":12,"_86":82},{"_11":12,"_80":-5,"_81":82,"_45":46,"_83":84,"_85":38},{"_29":30,"_13":26,"_20":21,"_27":28,"_31":-5,"_32":-5,"_75":-5,"_76":-5,"_77":-5,"_78":14,"_79":12},"ctx",{"_68":-5,"_108":181,"_182":183,"_184":185,"_186":38,"_187":38,"_188":38,"_189":106,"_190":-5,"_191":-7,"_192":-7,"_193":52,"_194":38,"_195":38,"_196":-5,"_197":38,"_198":38,"_199":38,"_200":-5},"ENV",{"_152":153,"_154":155,"_156":26,"_157":158,"_159":160,"_161":162,"_163":164,"_165":166,"_167":168,"_169":170,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180},"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"]

Branches1

Branches
1