[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_272":273,"_274":275},"routes/_app.x.$handle.$name",{"_99":98,"_32":45,"_108":87,"_27":109,"_13":14,"_110":-5,"_11":111,"_112":113,"_114":115,"_116":117,"_118":119,"_20":-5,"_120":-5,"_121":122,"_123":25,"_124":125,"_126":127,"_128":-5,"_129":-5,"_130":131},"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":-5,"_53":-5,"_18":54,"_55":-5,"_56":25,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":64,"_65":66,"_67":68,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":80,"_81":82,"_83":84,"_85":25},"version",109,"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","naverSAReport.ts","latestPath","fileId","f970e068-4cf8-11f1-801e-ee650bb23af1","name","fileType","http","content","/**\n * 네이버 마케팅 통합 리포트 v8 — GFA Notion 통합\n *\n * v7 대비 변경 (2026-06-17):\n * - 각 브랜드 섹션의 GFA placeholder 자리에 실제 데이터 카드 렌더링\n * - Notion GFA DB (`30470cda-...`)에서 어제 row를 query → 브랜드별 노출/클릭/비용/전환 추출\n * - row가 없으면 기존 placeholder 그대로 (Cowork 11:00 처리 전 / 데이터 없는 날)\n *\n * 환경변수:\n * - NAVER_SA_API_KEY, NAVER_SA_SECRET_KEY, NAVER_SA_CUSTOMER_ID\n * - WORKER_KEY\n * - NOTION_TOKEN, NOTION_DB_ID (네이버 SA DB)\n * - GFA_NOTION_DB_ID = \"567f9dc9a0564d818086ecf64e92b5dd\" (기본값 코드에 박혀 있음)\n */\nimport { blob } from \"https://esm.town/v/std/blob\";\nconst API_BASE = \"https://api.searchad.naver.com\";\nconst BLOB_AI_KEY = \"ai_analysis_latest\";\nconst TONGSPACE_KEYWORDS = [\n \"텅스\",\n \"곤약\",\n \"쫀드기\",\n \"쫀디기\",\n \"쫀뜨기\",\n \"스파이크샷\",\n];\nconst KEYWORD_CAMPAIGN_TYPES = [\"WEB_SITE\", \"BRAND_SEARCH\", \"POWER_CONTENTS\"];\nconst STATS_BATCH_SIZE = 100;\nconst NOTION_DB_DEFAULT = \"5828d1bf-aa95-4662-bdf2-fae160d0654f\";\nconst GFA_NOTION_DB_DEFAULT = \"567f9dc9a0564d818086ecf64e92b5dd\"; // 신규\nconst REPORT_URL =\n \"https://joowoo--f970e0684cf811f1801eee650bb23af1.web.val.run\";\nfunction classifyBrand(name: string): \"풍년보감\" | \"텅스페이스\" {\n for (const kw of TONGSPACE_KEYWORDS) {\n if (name.includes(kw)) return \"텅스페이스\";\n }\n return \"풍년보감\";\n}\nasync function makeSignature(\n secretKey: string,\n ts: string,\n method: string,\n uri: string,\n): Promise {\n const enc = new TextEncoder();\n const key = await crypto.subtle.importKey(\n \"raw\",\n enc.encode(secretKey),\n { name: \"HMAC\", hash: \"SHA-256\" },\n false,\n [\"sign\"],\n );\n const sig = await crypto.subtle.sign(\n \"HMAC\",\n key,\n enc.encode(`${ts}.${method}.${uri}`),\n );\n return btoa(String.fromCharCode(...new Uint8Array(sig)));\n}\nasync function callNaver(\n uri: string,\n qs: Record = {},\n): Promise {\n const apiKey = Deno.env.get(\"NAVER_SA_API_KEY\")!;\n const secretKey = Deno.env.get(\"NAVER_SA_SECRET_KEY\")!;\n const customerId = Deno.env.get(\"NAVER_SA_CUSTOMER_ID\")!;\n const ts = String(Date.now());\n const sig = await makeSignature(secretKey, ts, \"GET\", uri);\n const url = new URL(`${API_BASE}${uri}`);\n for (const [k, v] of Object.entries(qs)) url.searchParams.set(k, v);\n const res = await fetch(url.toString(), {\n headers: {\n \"X-Timestamp\": ts,\n \"X-API-KEY\": apiKey,\n \"X-Customer\": customerId,\n \"X-Signature\": sig,\n },\n });\n if (!res.ok) throw new Error(`${uri} ${res.status}`);\n return res.json();\n}\nfunction dateKST(o: number): string {\n return new Date(Date.now() + o * 86400000).toLocaleDateString(\"sv-SE\", {\n timeZone: \"Asia/Seoul\",\n });\n}\n// ━━━ 신규: GFA Notion DB에서 어제 row 가져오기 ━━━\nasync function fetchYesterdayGFA(targetDate: string): Promise {\n const token = Deno.env.get(\"NOTION_TOKEN\");\n const dbId = Deno.env.get(\"GFA_NOTION_DB_ID\") || GFA_NOTION_DB_DEFAULT;\n if (!token) return null;\n try {\n const resp = await fetch(\n `https://api.notion.com/v1/databases/${dbId}/query`,\n {\n method: \"POST\",\n headers: {\n \"Authorization\": `Bearer ${token}`,\n \"Notion-Version\": \"2022-06-28\",\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({\n filter: { property: \"분석일\", date: { equals: targetDate } },\n page_size: 1,\n }),\n },\n );\n if (!resp.ok) return null;\n const data = await resp.json();\n const row = data.results?.[0];\n if (!row) return null;\n const p = row.properties;\n const num = (key: string) => p[key]?.number ?? 0;\n return {\n pageUrl: row.url,\n status: p[\"상태\"]?.select?.name || \"정상\",\n insight: (p[\"핵심 인사이트\"]?.rich_text || []).map((t: any) =>\n t.plain_text\n ).join(\"\"),\n pn: {\n imp: num(\"풍년보감 노출\"),\n clk: num(\"풍년보감 클릭\"),\n spend: num(\"풍년보감 비용\"),\n conv: num(\"풍년보감 전환수\"),\n rev: num(\"풍년보감 전환금액\"),\n },\n ts: {\n imp: num(\"텅스페이스 노출\"),\n clk: num(\"텅스페이스 클릭\"),\n spend: num(\"텅스페이스 비용\"),\n conv: num(\"텅스페이스 전환수\"),\n rev: num(\"텅스페이스 전환금액\"),\n },\n total: {\n spend: num(\"통합 비용\"),\n rev: num(\"통합 전환금액\"),\n roas: num(\"통합 ROAS (%)\"),\n },\n };\n } catch (e) {\n return null;\n }\n}\nasync function fetchCampaignKeywords(\n campaignId: string,\n targetDate: string,\n): Promise {\n const adgroups = await callNaver(\"/ncc/adgroups\", {\n nccCampaignId: campaignId,\n });\n if (!Array.isArray(adgroups) || adgroups.length === 0) return [];\n const kwArrs = await Promise.all(\n adgroups.map((ag: any) =>\n callNaver(\"/ncc/keywords\", { nccAdgroupId: ag.nccAdgroupId })\n ),\n );\n const allKw: any[] = [];\n for (const arr of kwArrs) if (Array.isArray(arr)) allKw.push(...arr);\n if (allKw.length === 0) return [];\n const statsMap = new Map();\n for (let i = 0; i < allKw.length; i += STATS_BATCH_SIZE) {\n const batch = allKw.slice(i, i + STATS_BATCH_SIZE);\n try {\n const r = await callNaver(\"/stats\", {\n ids: batch.map((k) => k.nccKeywordId).join(\",\"),\n fields: '[\"impCnt\",\"clkCnt\",\"salesAmt\",\"ccnt\",\"ctr\",\"cpc\",\"convAmt\"]',\n timeRange: JSON.stringify({ since: targetDate, until: targetDate }),\n });\n for (const s of (r?.data || [])) statsMap.set(s.id, s);\n } catch (e) {}\n }\n return allKw.map((k) => {\n const s = statsMap.get(k.nccKeywordId);\n if (!s || (s.impCnt === 0 && s.salesAmt === 0)) return null;\n return {\n keyword: k.keyword,\n imp: s.impCnt || 0,\n clk: s.clkCnt || 0,\n ctr: s.ctr || 0,\n cpc: s.cpc || 0,\n spend: s.salesAmt || 0,\n conv: s.ccnt || 0,\n rev: s.convAmt || 0,\n roas: s.salesAmt > 0 ? Math.round((s.convAmt / s.salesAmt) * 100) : 0,\n };\n }).filter(Boolean);\n}\nfunction stripTags(s: string): string {\n return s.replace(/<[^>]+>/g, \"\").replace(/ /g, \" \").replace(\n /&/g,\n \"&\",\n ).replace(/</g, \"<\").replace(/>/g, \">\").replace(/"/g, '\"').trim();\n}\nfunction htmlToNotionBlocks(html: string): any[] {\n const blocks: any[] = [];\n blocks.push({\n object: \"block\",\n type: \"callout\",\n callout: {\n rich_text: [{\n type: \"text\",\n text: {\n content:\n \"전체 인터랙티브 리포트는 val.town에서 확인. 이 페이지는 노션 검색·아카이브용 요약입니다.\",\n },\n }],\n icon: { type: \"emoji\", emoji: \"📊\" },\n color: \"blue_background\",\n },\n });\n const sectionRegex = /

([\\s\\S]?)<\\/h3>([\\s\\S]?)(?=

|$)/g;\n let m;\n while ((m = sectionRegex.exec(html)) !== null) {\n const title = stripTags(m[1]);\n const content = m[2];\n if (!title) continue;\n blocks.push({\n object: \"block\",\n type: \"heading_2\",\n heading_2: {\n rich_text: [{ type: \"text\", text: { content: title.slice(0, 1900) } }],\n },\n });\n const h4Re = /

([\\s\\S]*?)<\\/h4>/g;\n let h4m;\n while ((h4m = h4Re.exec(content)) !== null) {\n const t = stripTags(h4m[1]);\n if (t) {\n blocks.push({\n object: \"block\",\n type: \"heading_3\",\n heading_3: {\n rich_text: [{ type: \"text\", text: { content: t.slice(0, 1900) } }],\n },\n });\n }\n }\n const paraRe = /

([\\s\\S]*?)<\\/p>/g;\n let pm;\n while ((pm = paraRe.exec(content)) !== null) {\n const t = stripTags(pm[1]);\n if (t) {\n blocks.push({\n object: \"block\",\n type: \"paragraph\",\n paragraph: {\n rich_text: [{ type: \"text\", text: { content: t.slice(0, 1900) } }],\n },\n });\n }\n }\n const listRe = /<(ol|ul)>([\\s\\S]*?)<\\/\\1>/g;\n let lm;\n while ((lm = listRe.exec(content)) !== null) {\n const isOrdered = lm[1] === \"ol\";\n const itemRe = /

([\\s\\S]*?)<\\/li>/g;\n let im;\n while ((im = itemRe.exec(lm[2])) !== null) {\n const t = stripTags(im[1]);\n if (!t) continue;\n const key = isOrdered ? \"numbered_list_item\" : \"bulleted_list_item\";\n blocks.push({\n object: \"block\",\n type: key,\n [key]: {\n rich_text: [{ type: \"text\", text: { content: t.slice(0, 1900) } }],\n },\n });\n }\n }\n const tableRe = /([\\s\\S]*?)<\\/table>/g;\n let tm;\n while ((tm = tableRe.exec(content)) !== null) {\n const rowRe = /([\\s\\S]*?)<\\/tr>/g;\n let rm;\n const lines: string[] = [];\n while ((rm = rowRe.exec(tm[1])) !== null) {\n const cellRe = /]*>([\\s\\S]*?)<\\/t[hd]>/g;\n const cells: string[] = [];\n let cm;\n while ((cm = cellRe.exec(rm[1])) !== null) cells.push(stripTags(cm[1]));\n if (cells.length) lines.push(cells.join(\" | \"));\n }\n const text = lines.join(\"\\n\");\n if (text) {\n blocks.push({\n object: \"block\",\n type: \"code\",\n code: {\n rich_text: [{\n type: \"text\",\n text: { content: text.slice(0, 1900) },\n }],\n language: \"plain text\",\n },\n });\n }\n }\n }\n blocks.push({\n object: \"block\",\n type: \"paragraph\",\n paragraph: {\n rich_text: [\n { type: \"text\", text: { content: \"전체 인터랙티브 리포트: \" } },\n {\n type: \"text\",\n text: { content: \"리포트 열기\", link: { url: REPORT_URL } },\n },\n ],\n },\n });\n return blocks.slice(0, 100);\n}\nasync function createNotionPage(p: {\n date: string;\n summary: string;\n html: string;\n kpi: Record;\n totalRoas: number;\n pnRoas: number;\n tsRoas: number;\n status: string;\n}): Promise {\n const token = Deno.env.get(\"NOTION_TOKEN\");\n const dbId = Deno.env.get(\"NOTION_DB_ID\") || NOTION_DB_DEFAULT;\n if (!token) throw new Error(\"NOTION_TOKEN not set\");\n const resp = await fetch(\"https://api.notion.com/v1/pages\", {\n method: \"POST\",\n headers: {\n \"Authorization\": `Bearer ${token}`,\n \"Notion-Version\": \"2022-06-28\",\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({\n parent: { database_id: dbId },\n properties: {\n \"날짜\": {\n title: [{ text: { content: `${p.date} 네이버 SA 일일 리포트` } }],\n },\n \"분석일\": { date: { start: p.date } },\n \"통합 ROAS (%)\": { number: p.totalRoas },\n \"풍년보감 광고비\": { number: p.kpi[\"풍년보감\"].spend },\n \"풍년보감 매출\": { number: p.kpi[\"풍년보감\"].rev },\n \"풍년보감 ROAS (%)\": { number: p.pnRoas },\n \"텅스페이스 광고비\": { number: p.kpi[\"텅스페이스\"].spend },\n \"텅스페이스 매출\": { number: p.kpi[\"텅스페이스\"].rev },\n \"텅스페이스 ROAS (%)\": { number: p.tsRoas },\n \"핵심 인사이트\": {\n rich_text: [{ text: { content: (p.summary || \"\").slice(0, 2000) } }],\n },\n \"상태\": { select: { name: p.status } },\n \"리포트 링크\": { url: REPORT_URL },\n },\n children: htmlToNotionBlocks(p.html),\n }),\n });\n if (!resp.ok) {\n throw new Error(\n `Notion API ${resp.status}: ${(await resp.text()).slice(0, 500)}`,\n );\n }\n const data = await resp.json();\n return data.id;\n}\nasync function fetchYesterdayKPI(targetDate: string) {\n const campaigns: any[] = await callNaver(\"/ncc/campaigns\");\n const cmap = new Map(\n campaigns.map((\n c: any,\n ) => [c.nccCampaignId, { ...c, brand: classifyBrand(c.name) }]),\n );\n const ids = campaigns.map((c: any) => c.nccCampaignId).join(\",\");\n const stats = await callNaver(\"/stats\", {\n ids,\n fields: '[\"impCnt\",\"clkCnt\",\"salesAmt\",\"ccnt\",\"ctr\",\"cpc\",\"convAmt\"]',\n timeRange: JSON.stringify({ since: targetDate, until: targetDate }),\n });\n const kpi: Record = {\n \"풍년보감\": { spend: 0, rev: 0, conv: 0 },\n \"텅스페이스\": { spend: 0, rev: 0, conv: 0 },\n };\n let wastedCount = 0;\n for (const s of (stats?.data || [])) {\n const c = cmap.get(s.id);\n if (!c) continue;\n kpi[c.brand].spend += s.salesAmt || 0;\n kpi[c.brand].rev += s.convAmt || 0;\n kpi[c.brand].conv += s.ccnt || 0;\n if ((s.salesAmt || 0) > 1000 && (s.convAmt || 0) === 0) wastedCount++;\n }\n const pnRoas = kpi[\"풍년보감\"].spend > 0\n ? Math.round(kpi[\"풍년보감\"].rev / kpi[\"풍년보감\"].spend * 100)\n : 0;\n const tsRoas = kpi[\"텅스페이스\"].spend > 0\n ? Math.round(kpi[\"텅스페이스\"].rev / kpi[\"텅스페이스\"].spend * 100)\n : 0;\n const totalSpend = kpi[\"풍년보감\"].spend + kpi[\"텅스페이스\"].spend;\n const totalRev = kpi[\"풍년보감\"].rev + kpi[\"텅스페이스\"].rev;\n const totalRoas = totalSpend > 0\n ? Math.round(totalRev / totalSpend * 100)\n : 0;\n let status = \"정상\";\n if (totalSpend === 0) status = \"데이터 부족\";\n else if (totalRoas < 300) status = \"경고\";\n else if (totalRoas < 700) status = \"검토 필요\";\n if (wastedCount >= 5 && (status === \"정상\" || status === \"검토 필요\")) {\n status = \"비효율 다수\";\n }\n return { kpi, pnRoas, tsRoas, totalRoas, status };\n}\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n if (req.method === \"POST\") {\n if (url.searchParams.get(\"key\") !== Deno.env.get(\"WORKER_KEY\")) {\n return Response.json({ error: \"unauthorized\" }, { status: 401 });\n }\n try {\n const body = await req.json();\n const targetDate = body.date || dateKST(-1);\n const summary = body.summary || \"\";\n const html = body.html || \"\";\n await blob.setJSON(BLOB_AI_KEY, {\n html,\n date: targetDate,\n summary,\n savedAt: new Date().toISOString(),\n });\n let notionPageId: string | null = null;\n let notionError: string | null = null;\n try {\n const k = await fetchYesterdayKPI(targetDate);\n notionPageId = await createNotionPage({\n date: targetDate,\n summary,\n html,\n kpi: k.kpi,\n totalRoas: k.totalRoas,\n pnRoas: k.pnRoas,\n tsRoas: k.tsRoas,\n status: k.status,\n });\n } catch (err: any) {\n notionError = err.message;\n }\n return Response.json({\n ok: true,\n savedAt: new Date().toISOString(),\n notionPageId,\n notionError,\n });\n } catch (err: any) {\n return Response.json({ error: err.message }, { status: 500 });\n }\n }\n const targetDate = url.searchParams.get(\"date\") || dateKST(-1);\n try {\n const campaigns: any[] = await callNaver(\"/ncc/campaigns\");\n const cmap = new Map(\n campaigns.map((\n c: any,\n ) => [c.nccCampaignId, { ...c, brand: classifyBrand(c.name) }]),\n );\n const ids = campaigns.map((c: any) => c.nccCampaignId).join(\",\");\n const yStats = await callNaver(\"/stats\", {\n ids,\n fields: '[\"impCnt\",\"clkCnt\",\"salesAmt\",\"ccnt\",\"ctr\",\"cpc\",\"convAmt\"]',\n timeRange: JSON.stringify({ since: targetDate, until: targetDate }),\n });\n const trendByBrand: Record = {\n \"풍년보감\": [],\n \"텅스페이스\": [],\n };\n for (let i = -30; i <= -1; i++) {\n const d = dateKST(i);\n const ds = await callNaver(\"/stats\", {\n ids,\n fields: '[\"impCnt\",\"clkCnt\",\"salesAmt\",\"ccnt\",\"convAmt\"]',\n timeRange: JSON.stringify({ since: d, until: d }),\n });\n const bb: Record = {\n \"풍년보감\": { date: d, spend: 0, revenue: 0, imp: 0, clk: 0, conv: 0 },\n \"텅스페이스\": {\n date: d,\n spend: 0,\n revenue: 0,\n imp: 0,\n clk: 0,\n conv: 0,\n },\n };\n for (const s of (ds?.data || [])) {\n const c = cmap.get(s.id);\n if (!c) continue;\n const b = bb[c.brand];\n b.spend += s.salesAmt || 0;\n b.revenue += s.convAmt || 0;\n b.imp += s.impCnt || 0;\n b.clk += s.clkCnt || 0;\n b.conv += s.ccnt || 0;\n }\n trendByBrand[\"풍년보감\"].push(bb[\"풍년보감\"]);\n trendByBrand[\"텅스페이스\"].push(bb[\"텅스페이스\"]);\n }\n const rowsByBrand: Record = {\n \"풍년보감\": [],\n \"텅스페이스\": [],\n };\n const activeKwCampaigns: Record = {\n \"풍년보감\": [],\n \"텅스페이스\": [],\n };\n for (const s of (yStats?.data || [])) {\n const c = cmap.get(s.id);\n if (!c) continue;\n const row = {\n id: s.id,\n name: c.name,\n tp: c.campaignTp || \"\",\n imp: s.impCnt || 0,\n clk: s.clkCnt || 0,\n ctr: s.ctr || 0,\n cpc: s.cpc || 0,\n spend: s.salesAmt || 0,\n conv: s.ccnt || 0,\n rev: s.convAmt || 0,\n roas: s.salesAmt > 0 ? Math.round((s.convAmt / s.salesAmt) * 100) : 0,\n };\n rowsByBrand[c.brand].push(row);\n if (\n KEYWORD_CAMPAIGN_TYPES.includes(c.campaignTp) &&\n (row.spend > 0 || row.imp > 0)\n ) {\n activeKwCampaigns[c.brand].push(s.id);\n }\n }\n for (const b of [\"풍년보감\", \"텅스페이스\"]) {\n rowsByBrand[b].sort((a: any, b: any) =>\n b.spend - a.spend\n );\n }\n const keywordsByBrand: Record = {\n \"풍년보감\": [],\n \"텅스페이스\": [],\n };\n for (const brand of [\"풍년보감\", \"텅스페이스\"]) {\n const results = await Promise.all(\n activeKwCampaigns[brand].map((cid: string) =>\n fetchCampaignKeywords(cid, targetDate).catch(() => [])\n ),\n );\n for (const arr of results) keywordsByBrand[brand].push(...arr);\n }\n const summary: Record = {};\n for (const b of [\"풍년보감\", \"텅스페이스\"]) {\n const rows = rowsByBrand[b];\n const trend = trendByBrand[b];\n summary[b] = {\n ySpend: rows.reduce((s: number, r: any) => s + r.spend, 0),\n yRev: rows.reduce((s: number, r: any) => s + r.rev, 0),\n yConv: rows.reduce((s: number, r: any) => s + r.conv, 0),\n tSpend: trend.reduce((s, t) => s + t.spend, 0),\n tRev: trend.reduce((s, t) => s + t.revenue, 0),\n tConv: trend.reduce((s, t) => s + t.conv, 0),\n };\n summary[b].yRoas = summary[b].ySpend > 0\n ? Math.round(summary[b].yRev / summary[b].ySpend * 100)\n : 0;\n summary[b].tRoas = summary[b].tSpend > 0\n ? Math.round(summary[b].tRev / summary[b].tSpend * 100)\n : 0;\n }\n const overall = {\n ySpend: summary[\"풍년보감\"].ySpend + summary[\"텅스페이스\"].ySpend,\n yRev: summary[\"풍년보감\"].yRev + summary[\"텅스페이스\"].yRev,\n yConv: summary[\"풍년보감\"].yConv + summary[\"텅스페이스\"].yConv,\n tSpend: summary[\"풍년보감\"].tSpend + summary[\"텅스페이스\"].tSpend,\n tRev: summary[\"풍년보감\"].tRev + summary[\"텅스페이스\"].tRev,\n tConv: summary[\"풍년보감\"].tConv + summary[\"텅스페이스\"].tConv,\n yRoas: 0,\n tRoas: 0,\n };\n overall.yRoas = overall.ySpend > 0\n ? Math.round(overall.yRev / overall.ySpend * 100)\n : 0;\n overall.tRoas = overall.tSpend > 0\n ? Math.round(overall.tRev / overall.tSpend * 100)\n : 0;\n // 신규: GFA 데이터 fetch (병렬과 무관, 빠름)\n const gfa = await fetchYesterdayGFA(targetDate);\n let aiAnalysis: any = null;\n try {\n aiAnalysis = await blob.getJSON(BLOB_AI_KEY);\n } catch (e) {}\n const html = renderHTML({\n targetDate,\n trendByBrand,\n rowsByBrand,\n summary,\n overall,\n keywordsByBrand,\n aiAnalysis,\n gfa, // 신규\n });\n return new Response(html, {\n headers: {\n \"Content-Type\": \"text/html; charset=utf-8\",\n \"Cache-Control\": \"public, max-age=1800\",\n },\n });\n } catch (err: any) {\n return new Response(\n `

Error

${err.message}\\n${\n        err.stack || \"\"\n      }

`,\n { status: 500, headers: { \"Content-Type\": \"text/html; charset=utf-8\" } },\n );\n }\n}\nfunction renderHTML(d: any): string {\n const fmt = (n: number) => n.toLocaleString(\"ko-KR\") + \"원\";\n const fmtN = (n: number) => n.toLocaleString(\"ko-KR\");\n const esc = (s: string) =>\n String(s).replace(/&/g, \"&\").replace(//g,\n \">\",\n );\n // 신규: GFA 카드 렌더링 (브랜드별)\n const renderGFA = (brand: string) => {\n const g = d.gfa;\n if (!g) {\n return `

🔌 GFA 데이터 대기 중

매일 11:00 KST에 영업팀 Drive 파일 → Cowork 자동 처리로 채워집니다.

대행사 API 키 미발급으로 영업팀이 매일 raw 파일을 Drive에 업로드 → Cowork가 Notion GFA DB에 적재 → 이 리포트가 그 DB를 읽어 렌더링.

`;\n }\n const b = brand === \"풍년보감\" ? g.pn : g.ts;\n const brandRoas = b.spend > 0 ? Math.round(b.rev / b.spend * 100) : 0;\n return `\n

노출

${\n fmtN(b.imp)\n }

클릭

${\n fmtN(b.clk)\n }

광고비

${\n fmt(b.spend)\n }

ROAS

${brandRoas.toLocaleString()}%

전환수

${\n fmtN(b.conv)\n }건

전환금액

${\n fmt(b.rev)\n }

CTR

${\n b.imp > 0 ? (b.clk / b.imp * 100).toFixed(2) : \"0.00\"\n }%

CVR

${\n b.clk > 0 ? (b.conv / b.clk * 100).toFixed(2) : \"0.00\"\n }%

\n${\n g.insight\n ? `

💡 GFA 통합 인사이트

${\n esc(g.insight.slice(0, 300))\n }

`\n : \"\"\n }\n

출처: Notion GFA DB (영업팀 Drive 업로드 → Cowork 11:00 자동 처리) · 상세 페이지 열기 ↗

`;\n };\n const renderKeywordsSection = (brand: string) => {\n const kws = d.keywordsByBrand[brand];\n if (!kws || kws.length === 0) {\n return `

🔍 키워드 데이터 없음

이 브랜드는 어제 활성된 파워링크/브랜드검색 캠페인이 없거나 노출/광고비가 없습니다.

쇼핑검색광고는 상품 기반이라 키워드 분석 대상이 아닙니다.

`;\n }\n const topSpend = [...kws].sort((a, b) => b.spend - a.spend).slice(0, 10);\n const topRoas = [...kws].filter((k) => k.spend >= 500 && k.rev > 0).sort((\n a,\n b,\n ) => b.roas - a.roas).slice(0, 10);\n const wasted = [...kws].filter((k) => k.spend > 1000 && k.rev === 0).sort((\n a,\n b,\n ) => b.spend - a.spend).slice(0, 5);\n const renderTable = (rows: any[]) => `\n

\n${\n rows.map((k) =>\n ``\n ).join(\"\")\n }\n

키워드	노출	클릭	CTR	CPC	광고비	전환	매출	ROAS
${esc(k.keyword)}	${\n fmtN(k.imp)\n }	${k.clk}	${k.ctr.toFixed(2)}%	${\n fmtN(k.cpc)\n }원	${fmt(k.spend)}	${k.conv}	${\n fmt(k.rev)\n }	${k.roas > 0 ? k.roas.toLocaleString() + \"%\" : \"-\"}

`;\n return `\n

📊 광고비 TOP 10

${renderTable(topSpend)}\n${\n topRoas.length > 0\n ? `

⭐ ROAS TOP 10 (최소 광고비 500원)

${\n renderTable(topRoas)\n }`\n : \"\"\n }\n${\n wasted.length > 0\n ? `

⚠️ 비효율 키워드 (광고비 1000원↑ / 매출 0)

${\n renderTable(wasted)\n }`\n : \"\"\n }\n

총 ${kws.length}개 활성 키워드

`;\n };\n const renderBrandSection = (brand: string, emoji: string, theme: string) => {\n const s = d.summary[brand];\n const rows = d.rowsByBrand[brand];\n const trend = d.trendByBrand[brand];\n const trendLabels = JSON.stringify(trend.map((t: any) => t.date.slice(5)));\n const trendSpend = JSON.stringify(trend.map((t: any) => t.spend));\n const trendRev = JSON.stringify(trend.map((t: any) => t.revenue));\n const trendRoas = JSON.stringify(\n trend.map((t: any) =>\n t.spend > 0 ? Math.round(t.revenue / t.spend * 100) : 0\n ),\n );\n const top5 = [...rows].filter((r: any) => r.rev > 0).sort((\n a: any,\n b: any,\n ) => b.roas - a.roas).slice(0, 5);\n const top5HTML = top5.map((r: any, i: number) =>\n `

${\n i + 1\n }위

${\n esc(r.name)\n }

광고비 ${fmt(r.spend)} → 매출 ${\n fmt(r.rev)\n }

1000 ? \"\" : \"badge-mid\"\n }\">ROAS ${r.roas.toLocaleString()}%

`\n ).join(\"\");\n const wasted = rows.filter((r: any) => r.spend > 0 && r.rev === 0).sort((\n a: any,\n b: any,\n ) => b.spend - a.spend).slice(0, 3);\n const wastedHTML = wasted.map((r: any) =>\n `

${\n esc(r.name)\n }

광고비 ${\n fmt(r.spend)\n } / 클릭 ${r.clk} / 매출 0원

`\n ).join(\"\");\n const trendRows = trend.map((t: any) => {\n const roas = t.spend > 0 ? Math.round(t.revenue / t.spend * 100) : 0;\n return `${t.date}${fmt(t.spend)}${\n fmtN(t.imp)\n }${t.clk}${t.conv}${\n fmt(t.revenue)\n }${roas.toLocaleString()}%`;\n }).join(\"\");\n const allRows =\n rows.map((r: any, i: number) =>\n `${i + 1}${esc(r.name)}${r.tp}${\n fmt(r.spend)\n }${fmtN(r.clk)}${r.conv}${\n fmt(r.rev)\n }${r.roas > 0 ? r.roas.toLocaleString() + \"%\" : \"-\"}`\n ).join(\"\") ||\n `전일 활성 캠페인 없음`;\n return `\n

${emoji} ${brand}

30일 광고비

${\n fmt(s.tSpend)\n }

30일 매출

${\n fmt(s.tRev)\n }

30일 ROAS

${s.tRoas.toLocaleString()}%

30일 전환

${s.tConv}건

전일 광고비

${\n fmt(s.ySpend)\n }

전일 매출

${\n fmt(s.yRev)\n }

전일 ROAS

${s.yRoas.toLocaleString()}%

전일 전환

${s.yConv}건

SA 효율 분석

\n${\n top5HTML\n ? `

⭐ ROAS TOP 5 캠페인

${top5HTML}`\n : '

전환된 캠페인 없음

'\n }\n${\n wastedHTML\n ? `

⚠️ 비효율 캠페인

${wastedHTML}`\n : \"\"\n }\n

SA 일별 분석 (30일)

광고비매출ROAS

\n${trendRows}

날짜	광고비	노출	클릭	전환	매출	ROAS

SA 키워드 분석

\n${renderKeywordsSection(brand)}\n

DA 디스플레이 (GFA)

\n${renderGFA(brand)}\n

📋 ${brand} 전체 캠페인 (전일)

\n${allRows}

#	캠페인명	유형	광고비	클릭	전환	매출	ROAS

\n`;\n };\n const overallChart = JSON.stringify({\n labels: d.trendByBrand[\"풍년보감\"].map((t: any) => t.date.slice(5)),\n pn: d.trendByBrand[\"풍년보감\"].map((t: any) => t.spend),\n ts: d.trendByBrand[\"텅스페이스\"].map((t: any) => t.spend),\n pnRev: d.trendByBrand[\"풍년보감\"].map((t: any) => t.revenue),\n tsRev: d.trendByBrand[\"텅스페이스\"].map((t: any) => t.revenue),\n });\n let aiSection = \"\";\n if (d.aiAnalysis && d.aiAnalysis.html) {\n const generatedAt = d.aiAnalysis.savedAt\n ? new Date(d.aiAnalysis.savedAt).toLocaleString(\"ko-KR\", {\n timeZone: \"Asia/Seoul\",\n })\n : \"\";\n aiSection =\n `

🤖 AI 자동 분석 & 액션플랜

생성: ${generatedAt} KST · 캠페인/그룹/소재 3단계 분석

${d.aiAnalysis.html}

`;\n } else {\n aiSection =\n `

🤖 AI 자동 분석

매일 아침 07:30 KST에 자동 생성됩니다. 첫 분석은 내일 새벽부터 표시 예정.

`;\n }\n return `\n네이버 마케팅 통합 리포트 — ${d.targetDate}\n\n

분석 기간: ${\n d.trendByBrand[\"풍년보감\"][0]?.date || \"\"\n } ~ ${d.targetDate} (오늘 제외, 전일까지 30일)

네이버 마케팅 통합 리포트

${\n d.trendByBrand[\"풍년보감\"][0]?.date || \"\"\n } ~ ${d.targetDate}

PNBG · 풍년보감 + 텅스페이스 · AI 분석 + SA/GFA 효율 통합

전체 통합 KPI

30일 총 광고비

${\n fmt(d.overall.tSpend)\n }

30일 총 매출

${\n fmt(d.overall.tRev)\n }

30일 통합 ROAS

${d.overall.tRoas.toLocaleString()}%

30일 총 전환

${d.overall.tConv}건

전일 광고비

${\n fmt(d.overall.ySpend)\n }

전일 매출

${\n fmt(d.overall.yRev)\n }

전일 ROAS

${d.overall.yRoas.toLocaleString()}%

전일 전환

${d.overall.yConv}건

📊 브랜드별 30일 비교

풍년보감 광고비텅스페이스 광고비풍년보감 매출텅스페이스 매출

\n${renderBrandSection(\"풍년보감\", \"🍯\", \"theme-pnbg\")}\n${renderBrandSection(\"텅스페이스\", \"🫧\", \"theme-ts\")}\n${aiSection}\n\n

\n\n`;\n}","/**\n * 네이버 마케팅 통합 리포트 v9 — SA 캠페인유형별 통합 (2026-06-17)\n *\n * v8 대비 변경:\n * - 기존 GFA 섹션 → SA 캠페인유형별 상세 섹션으로 교체\n * · 영업팀 raw csv 가 실제로는 SA 데이터(브랜드검색/쇼핑검색/파워링크/파워컨텐츠)이라서\n * · 새 \"네이버 SA 캠페인유형별 일일 리포트\" DB(2829fbc585c7...)를 읽어 렌더링\n * · 4개 캠페인유형 × 광고비/매출/ROAS 표시\n *\n * 환경변수:\n * - NAVER_SA_API_KEY, NAVER_SA_SECRET_KEY, NAVER_SA_CUSTOMER_ID\n * - WORKER_KEY\n * - NOTION_TOKEN, NOTION_DB_ID (네이버 SA 메인 DB)\n * - SA_DETAIL_NOTION_DB_ID = \"2829fbc585c74004b3ae33771f106d2a\" (코드에 기본값 박힘)\n *\n * 사용법:\n * GET → 풀 리포트 (AI 분석 + 30일 데이터 + SA 캠페인유형별)\n * POST ?key=WORKER_KEY (body: JSON {html, date, summary}) → blob 저장 + 노션 페이지 생성\n */\nimport { blob } from \"https://esm.town/v/std/blob\";\nconst API_BASE = \"https://api.searchad.naver.com\";\nconst BLOB_AI_KEY = \"ai_analysis_latest\";\nconst TONGSPACE_KEYWORDS = [\n \"텅스\", \"곤약\", \"쫀드기\", \"쫀디기\", \"쫀뜨기\", \"스파이크샷\",\n];\nconst KEYWORD_CAMPAIGN_TYPES = [\"WEB_SITE\", \"BRAND_SEARCH\", \"POWER_CONTENTS\"];\nconst STATS_BATCH_SIZE = 100;\nconst NOTION_DB_DEFAULT = \"5828d1bf-aa95-4662-bdf2-fae160d0654f\";\nconst SA_DETAIL_NOTION_DB_DEFAULT = \"2829fbc585c74004b3ae33771f106d2a\"; // v9: SA 캠페인유형별 DB\nconst REPORT_URL =\n \"https://joowoo--f970e0684cf811f1801eee650bb23af1.web.val.run\";\n\nfunction classifyBrand(name: string): \"풍년보감\" | \"텅스페이스\" {\n for (const kw of TONGSPACE_KEYWORDS) {\n if (name.includes(kw)) return \"텅스페이스\";\n }\n return \"풍년보감\";\n}\n\nasync function makeSignature(\n secretKey: string, ts: string, method: string, uri: string,\n): Promise {\n const enc = new TextEncoder();\n const key = await crypto.subtle.importKey(\n \"raw\", enc.encode(secretKey), { name: \"HMAC\", hash: \"SHA-256\" }, false, [\"sign\"],\n );\n const sig = await crypto.subtle.sign(\"HMAC\", key, enc.encode(`${ts}.${method}.${uri}`));\n return btoa(String.fromCharCode(...new Uint8Array(sig)));\n}\n\nasync function callNaver(uri: string, qs: Record = {}): Promise {\n const apiKey = Deno.env.get(\"NAVER_SA_API_KEY\")!;\n const secretKey = Deno.env.get(\"NAVER_SA_SECRET_KEY\")!;\n const customerId = Deno.env.get(\"NAVER_SA_CUSTOMER_ID\")!;\n const ts = String(Date.now());\n const sig = await makeSignature(secretKey, ts, \"GET\", uri);\n const url = new URL(`${API_BASE}${uri}`);\n for (const [k, v] of Object.entries(qs)) url.searchParams.set(k, v);\n const res = await fetch(url.toString(), {\n headers: {\n \"X-Timestamp\": ts, \"X-API-KEY\": apiKey,\n \"X-Customer\": customerId, \"X-Signature\": sig,\n },\n });\n if (!res.ok) throw new Error(`${uri} ${res.status}`);\n return res.json();\n}\n\nfunction dateKST(o: number): string {\n return new Date(Date.now() + o * 86400000).toLocaleDateString(\"sv-SE\", {\n timeZone: \"Asia/Seoul\",\n });\n}\n\n// ━━━ v9: SA 캠페인유형별 DB에서 어제 row 가져오기 ━━━\nasync function fetchYesterdaySADetail(targetDate: string): Promise {\n const token = Deno.env.get(\"NOTION_TOKEN\");\n const dbId = Deno.env.get(\"SA_DETAIL_NOTION_DB_ID\") || SA_DETAIL_NOTION_DB_DEFAULT;\n if (!token) return null;\n try {\n const resp = await fetch(`https://api.notion.com/v1/databases/${dbId}/query`, {\n method: \"POST\",\n headers: {\n \"Authorization\": `Bearer ${token}`,\n \"Notion-Version\": \"2022-06-28\",\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({\n filter: { property: \"분석일\", date: { equals: targetDate } },\n page_size: 1,\n }),\n });\n if (!resp.ok) return null;\n const data = await resp.json();\n const row = data.results?.[0];\n if (!row) return null;\n const p = row.properties;\n const n = (k: string) => p[k]?.number ?? 0;\n return {\n pageUrl: row.url,\n status: p[\"상태\"]?.select?.name || \"정상\",\n insight: (p[\"핵심 인사이트\"]?.rich_text || []).map((t: any) => t.plain_text).join(\"\"),\n types: {\n 브랜드검색: { spend: n(\"브랜드검색 비용\"), rev: n(\"브랜드검색 매출\"), roas: n(\"브랜드검색 ROAS (%)\") },\n 쇼핑검색: { spend: n(\"쇼핑검색 비용\"), rev: n(\"쇼핑검색 매출\"), roas: n(\"쇼핑검색 ROAS (%)\") },\n 파워링크: { spend: n(\"파워링크 비용\"), rev: n(\"파워링크 매출\"), roas: n(\"파워링크 ROAS (%)\") },\n 파워컨텐츠: { spend: n(\"파워컨텐츠 비용\"), rev: n(\"파워컨텐츠 매출\"), roas: n(\"파워컨텐츠 ROAS (%)\") },\n },\n total: {\n spend: n(\"통합 비용\"),\n rev: n(\"통합 매출\"),\n roas: n(\"통합 ROAS (%)\"),\n },\n };\n } catch (e) {\n return null;\n }\n}\n\nasync function fetchCampaignKeywords(\n campaignId: string, targetDate: string,\n): Promise {\n const adgroups = await callNaver(\"/ncc/adgroups\", { nccCampaignId: campaignId });\n if (!Array.isArray(adgroups) || adgroups.length === 0) return [];\n const kwArrs = await Promise.all(\n adgroups.map((ag: any) =>\n callNaver(\"/ncc/keywords\", { nccAdgroupId: ag.nccAdgroupId })\n ),\n );\n const allKw: any[] = [];\n for (const arr of kwArrs) if (Array.isArray(arr)) allKw.push(...arr);\n if (allKw.length === 0) return [];\n const statsMap = new Map();\n for (let i = 0; i < allKw.length; i += STATS_BATCH_SIZE) {\n const batch = allKw.slice(i, i + STATS_BATCH_SIZE);\n try {\n const r = await callNaver(\"/stats\", {\n ids: batch.map((k) => k.nccKeywordId).join(\",\"),\n fields: '[\"impCnt\",\"clkCnt\",\"salesAmt\",\"ccnt\",\"ctr\",\"cpc\",\"convAmt\"]',\n timeRange: JSON.stringify({ since: targetDate, until: targetDate }),\n });\n for (const s of (r?.data || [])) statsMap.set(s.id, s);\n } catch (e) {}\n }\n return allKw.map((k) => {\n const s = statsMap.get(k.nccKeywordId);\n if (!s || (s.impCnt === 0 && s.salesAmt === 0)) return null;\n return {\n keyword: k.keyword, imp: s.impCnt || 0, clk: s.clkCnt || 0,\n ctr: s.ctr || 0, cpc: s.cpc || 0, spend: s.salesAmt || 0,\n conv: s.ccnt || 0, rev: s.convAmt || 0,\n roas: s.salesAmt > 0 ? Math.round((s.convAmt / s.salesAmt) * 100) : 0,\n };\n }).filter(Boolean);\n}\n\nfunction stripTags(s: string): string {\n return s.replace(/<[^>]+>/g, \"\").replace(/ /g, \" \").replace(/&/g, \"&\").replace(/</g, \"<\").replace(/>/g, \">\").replace(/"/g, '\"').trim();\n}\n\nfunction htmlToNotionBlocks(html: string): any[] {\n const blocks: any[] = [];\n blocks.push({\n object: \"block\", type: \"callout\",\n callout: {\n rich_text: [{ type: \"text\", text: { content: \"전체 인터랙티브 리포트는 val.town에서 확인. 이 페이지는 노션 검색·아카이브용 요약입니다.\" } }],\n icon: { type: \"emoji\", emoji: \"📊\" }, color: \"blue_background\",\n },\n });\n const sectionRegex = /

([\\s\\S]?)<\\/h3>([\\s\\S]?)(?=

|$)/g;\n let m;\n while ((m = sectionRegex.exec(html)) !== null) {\n const title = stripTags(m[1]); const content = m[2];\n if (!title) continue;\n blocks.push({ object: \"block\", type: \"heading_2\", heading_2: { rich_text: [{ type: \"text\", text: { content: title.slice(0, 1900) } }] } });\n const h4Re = /

([\\s\\S]*?)<\\/h4>/g; let h4m;\n while ((h4m = h4Re.exec(content)) !== null) {\n const t = stripTags(h4m[1]);\n if (t) blocks.push({ object: \"block\", type: \"heading_3\", heading_3: { rich_text: [{ type: \"text\", text: { content: t.slice(0, 1900) } }] } });\n }\n const paraRe = /

([\\s\\S]*?)<\\/p>/g; let pm;\n while ((pm = paraRe.exec(content)) !== null) {\n const t = stripTags(pm[1]);\n if (t) blocks.push({ object: \"block\", type: \"paragraph\", paragraph: { rich_text: [{ type: \"text\", text: { content: t.slice(0, 1900) } }] } });\n }\n const listRe = /<(ol|ul)>([\\s\\S]*?)<\\/\\1>/g; let lm;\n while ((lm = listRe.exec(content)) !== null) {\n const isOrdered = lm[1] === \"ol\"; const itemRe = /

([\\s\\S]*?)<\\/li>/g; let im;\n while ((im = itemRe.exec(lm[2])) !== null) {\n const t = stripTags(im[1]); if (!t) continue;\n const key = isOrdered ? \"numbered_list_item\" : \"bulleted_list_item\";\n blocks.push({ object: \"block\", type: key, [key]: { rich_text: [{ type: \"text\", text: { content: t.slice(0, 1900) } }] } });\n }\n }\n const tableRe = /([\\s\\S]*?)<\\/table>/g; let tm;\n while ((tm = tableRe.exec(content)) !== null) {\n const rowRe = /([\\s\\S]*?)<\\/tr>/g; let rm; const lines: string[] = [];\n while ((rm = rowRe.exec(tm[1])) !== null) {\n const cellRe = /]*>([\\s\\S]*?)<\\/t[hd]>/g; const cells: string[] = []; let cm;\n while ((cm = cellRe.exec(rm[1])) !== null) cells.push(stripTags(cm[1]));\n if (cells.length) lines.push(cells.join(\" | \"));\n }\n const text = lines.join(\"\\n\");\n if (text) blocks.push({ object: \"block\", type: \"code\", code: { rich_text: [{ type: \"text\", text: { content: text.slice(0, 1900) } }], language: \"plain text\" } });\n }\n }\n blocks.push({\n object: \"block\", type: \"paragraph\", paragraph: {\n rich_text: [\n { type: \"text\", text: { content: \"전체 인터랙티브 리포트: \" } },\n { type: \"text\", text: { content: \"리포트 열기\", link: { url: REPORT_URL } } },\n ],\n },\n });\n return blocks.slice(0, 100);\n}\n\nasync function createNotionPage(p: {\n date: string; summary: string; html: string;\n kpi: Record;\n totalRoas: number; pnRoas: number; tsRoas: number; status: string;\n}): Promise {\n const token = Deno.env.get(\"NOTION_TOKEN\");\n const dbId = Deno.env.get(\"NOTION_DB_ID\") || NOTION_DB_DEFAULT;\n if (!token) throw new Error(\"NOTION_TOKEN not set\");\n const resp = await fetch(\"https://api.notion.com/v1/pages\", {\n method: \"POST\",\n headers: {\n \"Authorization\": `Bearer ${token}`, \"Notion-Version\": \"2022-06-28\", \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({\n parent: { database_id: dbId },\n properties: {\n \"날짜\": { title: [{ text: { content: `${p.date} 네이버 SA 일일 리포트` } }] },\n \"분석일\": { date: { start: p.date } },\n \"통합 ROAS (%)\": { number: p.totalRoas },\n \"풍년보감 광고비\": { number: p.kpi[\"풍년보감\"].spend },\n \"풍년보감 매출\": { number: p.kpi[\"풍년보감\"].rev },\n \"풍년보감 ROAS (%)\": { number: p.pnRoas },\n \"텅스페이스 광고비\": { number: p.kpi[\"텅스페이스\"].spend },\n \"텅스페이스 매출\": { number: p.kpi[\"텅스페이스\"].rev },\n \"텅스페이스 ROAS (%)\": { number: p.tsRoas },\n \"핵심 인사이트\": { rich_text: [{ text: { content: (p.summary || \"\").slice(0, 2000) } }] },\n \"상태\": { select: { name: p.status } },\n \"리포트 링크\": { url: REPORT_URL },\n },\n children: htmlToNotionBlocks(p.html),\n }),\n });\n if (!resp.ok) throw new Error(`Notion API ${resp.status}: ${(await resp.text()).slice(0, 500)}`);\n const data = await resp.json();\n return data.id;\n}\n\nasync function fetchYesterdayKPI(targetDate: string) {\n const campaigns: any[] = await callNaver(\"/ncc/campaigns\");\n const cmap = new Map(campaigns.map((c: any) => [c.nccCampaignId, { ...c, brand: classifyBrand(c.name) }]));\n const ids = campaigns.map((c: any) => c.nccCampaignId).join(\",\");\n const stats = await callNaver(\"/stats\", {\n ids,\n fields: '[\"impCnt\",\"clkCnt\",\"salesAmt\",\"ccnt\",\"ctr\",\"cpc\",\"convAmt\"]',\n timeRange: JSON.stringify({ since: targetDate, until: targetDate }),\n });\n const kpi: Record = {\n \"풍년보감\": { spend: 0, rev: 0, conv: 0 },\n \"텅스페이스\": { spend: 0, rev: 0, conv: 0 },\n };\n let wastedCount = 0;\n for (const s of (stats?.data || [])) {\n const c = cmap.get(s.id); if (!c) continue;\n kpi[c.brand].spend += s.salesAmt || 0;\n kpi[c.brand].rev += s.convAmt || 0;\n kpi[c.brand].conv += s.ccnt || 0;\n if ((s.salesAmt || 0) > 1000 && (s.convAmt || 0) === 0) wastedCount++;\n }\n const pnRoas = kpi[\"풍년보감\"].spend > 0 ? Math.round(kpi[\"풍년보감\"].rev / kpi[\"풍년보감\"].spend * 100) : 0;\n const tsRoas = kpi[\"텅스페이스\"].spend > 0 ? Math.round(kpi[\"텅스페이스\"].rev / kpi[\"텅스페이스\"].spend * 100) : 0;\n const totalSpend = kpi[\"풍년보감\"].spend + kpi[\"텅스페이스\"].spend;\n const totalRev = kpi[\"풍년보감\"].rev + kpi[\"텅스페이스\"].rev;\n const totalRoas = totalSpend > 0 ? Math.round(totalRev / totalSpend * 100) : 0;\n let status = \"정상\";\n if (totalSpend === 0) status = \"데이터 부족\";\n else if (totalRoas < 300) status = \"경고\";\n else if (totalRoas < 700) status = \"검토 필요\";\n if (wastedCount >= 5 && (status === \"정상\" || status === \"검토 필요\")) status = \"비효율 다수\";\n return { kpi, pnRoas, tsRoas, totalRoas, status };\n}\n\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n if (req.method === \"POST\") {\n if (url.searchParams.get(\"key\") !== Deno.env.get(\"WORKER_KEY\")) {\n return Response.json({ error: \"unauthorized\" }, { status: 401 });\n }\n try {\n const body = await req.json();\n const targetDate = body.date || dateKST(-1);\n const summary = body.summary || \"\"; const html = body.html || \"\";\n await blob.setJSON(BLOB_AI_KEY, { html, date: targetDate, summary, savedAt: new Date().toISOString() });\n let notionPageId: string | null = null; let notionError: string | null = null;\n try {\n const k = await fetchYesterdayKPI(targetDate);\n notionPageId = await createNotionPage({ date: targetDate, summary, html, kpi: k.kpi, totalRoas: k.totalRoas, pnRoas: k.pnRoas, tsRoas: k.tsRoas, status: k.status });\n } catch (err: any) { notionError = err.message; }\n return Response.json({ ok: true, savedAt: new Date().toISOString(), notionPageId, notionError });\n } catch (err: any) { return Response.json({ error: err.message }, { status: 500 }); }\n }\n const targetDate = url.searchParams.get(\"date\") || dateKST(-1);\n try {\n const campaigns: any[] = await callNaver(\"/ncc/campaigns\");\n const cmap = new Map(campaigns.map((c: any) => [c.nccCampaignId, { ...c, brand: classifyBrand(c.name) }]));\n const ids = campaigns.map((c: any) => c.nccCampaignId).join(\",\");\n const yStats = await callNaver(\"/stats\", {\n ids, fields: '[\"impCnt\",\"clkCnt\",\"salesAmt\",\"ccnt\",\"ctr\",\"cpc\",\"convAmt\"]',\n timeRange: JSON.stringify({ since: targetDate, until: targetDate }),\n });\n const trendByBrand: Record = { \"풍년보감\": [], \"텅스페이스\": [] };\n for (let i = -30; i <= -1; i++) {\n const d = dateKST(i);\n const ds = await callNaver(\"/stats\", {\n ids, fields: '[\"impCnt\",\"clkCnt\",\"salesAmt\",\"ccnt\",\"convAmt\"]',\n timeRange: JSON.stringify({ since: d, until: d }),\n });\n const bb: Record = {\n \"풍년보감\": { date: d, spend: 0, revenue: 0, imp: 0, clk: 0, conv: 0 },\n \"텅스페이스\": { date: d, spend: 0, revenue: 0, imp: 0, clk: 0, conv: 0 },\n };\n for (const s of (ds?.data || [])) {\n const c = cmap.get(s.id); if (!c) continue;\n const b = bb[c.brand];\n b.spend += s.salesAmt || 0; b.revenue += s.convAmt || 0;\n b.imp += s.impCnt || 0; b.clk += s.clkCnt || 0; b.conv += s.ccnt || 0;\n }\n trendByBrand[\"풍년보감\"].push(bb[\"풍년보감\"]);\n trendByBrand[\"텅스페이스\"].push(bb[\"텅스페이스\"]);\n }\n const rowsByBrand: Record = { \"풍년보감\": [], \"텅스페이스\": [] };\n const activeKwCampaigns: Record = { \"풍년보감\": [], \"텅스페이스\": [] };\n for (const s of (yStats?.data || [])) {\n const c = cmap.get(s.id); if (!c) continue;\n const row = {\n id: s.id, name: c.name, tp: c.campaignTp || \"\",\n imp: s.impCnt || 0, clk: s.clkCnt || 0, ctr: s.ctr || 0, cpc: s.cpc || 0,\n spend: s.salesAmt || 0, conv: s.ccnt || 0, rev: s.convAmt || 0,\n roas: s.salesAmt > 0 ? Math.round((s.convAmt / s.salesAmt) * 100) : 0,\n };\n rowsByBrand[c.brand].push(row);\n if (KEYWORD_CAMPAIGN_TYPES.includes(c.campaignTp) && (row.spend > 0 || row.imp > 0)) {\n activeKwCampaigns[c.brand].push(s.id);\n }\n }\n for (const b of [\"풍년보감\", \"텅스페이스\"]) rowsByBrand[b].sort((a: any, b: any) => b.spend - a.spend);\n const keywordsByBrand: Record = { \"풍년보감\": [], \"텅스페이스\": [] };\n for (const brand of [\"풍년보감\", \"텅스페이스\"]) {\n const results = await Promise.all(activeKwCampaigns[brand].map((cid: string) => fetchCampaignKeywords(cid, targetDate).catch(() => [])));\n for (const arr of results) keywordsByBrand[brand].push(...arr);\n }\n const summary: Record = {};\n for (const b of [\"풍년보감\", \"텅스페이스\"]) {\n const rows = rowsByBrand[b]; const trend = trendByBrand[b];\n summary[b] = {\n ySpend: rows.reduce((s: number, r: any) => s + r.spend, 0),\n yRev: rows.reduce((s: number, r: any) => s + r.rev, 0),\n yConv: rows.reduce((s: number, r: any) => s + r.conv, 0),\n tSpend: trend.reduce((s, t) => s + t.spend, 0),\n tRev: trend.reduce((s, t) => s + t.revenue, 0),\n tConv: trend.reduce((s, t) => s + t.conv, 0),\n };\n summary[b].yRoas = summary[b].ySpend > 0 ? Math.round(summary[b].yRev / summary[b].ySpend * 100) : 0;\n summary[b].tRoas = summary[b].tSpend > 0 ? Math.round(summary[b].tRev / summary[b].tSpend * 100) : 0;\n }\n const overall = {\n ySpend: summary[\"풍년보감\"].ySpend + summary[\"텅스페이스\"].ySpend,\n yRev: summary[\"풍년보감\"].yRev + summary[\"텅스페이스\"].yRev,\n yConv: summary[\"풍년보감\"].yConv + summary[\"텅스페이스\"].yConv,\n tSpend: summary[\"풍년보감\"].tSpend + summary[\"텅스페이스\"].tSpend,\n tRev: summary[\"풍년보감\"].tRev + summary[\"텅스페이스\"].tRev,\n tConv: summary[\"풍년보감\"].tConv + summary[\"텅스페이스\"].tConv,\n yRoas: 0, tRoas: 0,\n };\n overall.yRoas = overall.ySpend > 0 ? Math.round(overall.yRev / overall.ySpend * 100) : 0;\n overall.tRoas = overall.tSpend > 0 ? Math.round(overall.tRev / overall.tSpend * 100) : 0;\n // v9: SA 캠페인유형별 데이터 fetch\n const saDetail = await fetchYesterdaySADetail(targetDate);\n let aiAnalysis: any = null;\n try { aiAnalysis = await blob.getJSON(BLOB_AI_KEY); } catch (e) {}\n const html = renderHTML({\n targetDate, trendByBrand, rowsByBrand, summary, overall, keywordsByBrand, aiAnalysis,\n saDetail, // v9\n });\n return new Response(html, {\n headers: {\n \"Content-Type\": \"text/html; charset=utf-8\",\n \"Cache-Control\": \"public, max-age=1800\",\n },\n });\n } catch (err: any) {\n return new Response(\n `

Error

${err.message}\\n${err.stack || \"\"}

`,\n { status: 500, headers: { \"Content-Type\": \"text/html; charset=utf-8\" } },\n );\n }\n}\n\nfunction renderHTML(d: any): string {\n const fmt = (n: number) => n.toLocaleString(\"ko-KR\") + \"원\";\n const fmtN = (n: number) => n.toLocaleString(\"ko-KR\");\n const esc = (s: string) => String(s).replace(/&/g, \"&\").replace(//g, \">\");\n // v9: SA 캠페인유형별 카드 (브랜드 구분 없이 캠페인유형 4종)\n const renderSADetail = () => {\n const g = d.saDetail;\n if (!g) {\n return `

📡 SA 캠페인유형별 데이터 대기 중

매일 11:30 KST 에 영업팀 Drive 파일 → val.town dailyDriveSync_sa 자동 처리로 채워집니다.

출처: Notion \"네이버 SA 캠페인유형별 일일 리포트\" DB

`;\n }\n const rowOf = (label: string, t: typeof g.types[\"브랜드검색\"]) => `\n

${label}

광고비 ${fmt(t.spend)} → 매출 ${fmt(t.rev)}

= 700 ? \"\" : t.roas >= 300 ? \"badge-mid\" : \"badge-low\"}\">ROAS ${t.roas.toLocaleString()}%

`;\n return `\n

통합 광고비

${fmt(g.total.spend)}

통합 매출

${fmt(g.total.rev)}

통합 ROAS

${g.total.roas.toLocaleString()}%

상태

${g.status}

캠페인유형별 (4종)

\n${rowOf(\"🔎 브랜드검색\", g.types[\"브랜드검색\"])}\n${rowOf(\"🛒 쇼핑검색\", g.types[\"쇼핑검색\"])}\n${rowOf(\"📰 파워링크\", g.types[\"파워링크\"])}\n${rowOf(\"📄 파워컨텐츠\", g.types[\"파워컨텐츠\"])}\n${g.insight ? `

💡 인사이트

${esc(g.insight.slice(0, 300))}

` : \"\"}\n

출처: Notion \"네이버 SA 캠페인유형별 일일 리포트\" (영업팀 Drive → val.town dailyDriveSync_sa 11:30 자동 처리) · 상세 페이지 열기 ↗

`;\n };\n const renderKeywordsSection = (brand: string) => {\n const kws = d.keywordsByBrand[brand];\n if (!kws || kws.length === 0) {\n return `

🔍 키워드 데이터 없음

이 브랜드는 어제 활성된 파워링크/브랜드검색 캠페인이 없거나 노출/광고비가 없습니다.

쇼핑검색광고는 상품 기반이라 키워드 분석 대상이 아닙니다.

`;\n }\n const topSpend = [...kws].sort((a, b) => b.spend - a.spend).slice(0, 10);\n const topRoas = [...kws].filter((k) => k.spend >= 500 && k.rev > 0).sort((a, b) => b.roas - a.roas).slice(0, 10);\n const wasted = [...kws].filter((k) => k.spend > 1000 && k.rev === 0).sort((a, b) => b.spend - a.spend).slice(0, 5);\n const renderTable = (rows: any[]) => `\n

\n${rows.map((k) => ``).join(\"\")}\n

키워드	노출	클릭	CTR	CPC	광고비	전환	매출	ROAS
${esc(k.keyword)}	${fmtN(k.imp)}	${k.clk}	${k.ctr.toFixed(2)}%	${fmtN(k.cpc)}원	${fmt(k.spend)}	${k.conv}	${fmt(k.rev)}	${k.roas > 0 ? k.roas.toLocaleString() + \"%\" : \"-\"}

`;\n return `\n

📊 광고비 TOP 10

${renderTable(topSpend)}\n${topRoas.length > 0 ? `

⭐ ROAS TOP 10 (최소 광고비 500원)

${renderTable(topRoas)}` : \"\"}\n${wasted.length > 0 ? `

⚠️ 비효율 키워드 (광고비 1000원↑ / 매출 0)

${renderTable(wasted)}` : \"\"}\n

총 ${kws.length}개 활성 키워드

`;\n };\n const renderBrandSection = (brand: string, emoji: string, theme: string) => {\n const s = d.summary[brand]; const rows = d.rowsByBrand[brand]; const trend = d.trendByBrand[brand];\n const trendLabels = JSON.stringify(trend.map((t: any) => t.date.slice(5)));\n const trendSpend = JSON.stringify(trend.map((t: any) => t.spend));\n const trendRev = JSON.stringify(trend.map((t: any) => t.revenue));\n const trendRoas = JSON.stringify(trend.map((t: any) => t.spend > 0 ? Math.round(t.revenue / t.spend * 100) : 0));\n const top5 = [...rows].filter((r: any) => r.rev > 0).sort((a: any, b: any) => b.roas - a.roas).slice(0, 5);\n const top5HTML = top5.map((r: any, i: number) => `

${i + 1}위

${esc(r.name)}

광고비 ${fmt(r.spend)} → 매출 ${fmt(r.rev)}

1000 ? \"\" : \"badge-mid\"}\">ROAS ${r.roas.toLocaleString()}%

`).join(\"\");\n const wasted = rows.filter((r: any) => r.spend > 0 && r.rev === 0).sort((a: any, b: any) => b.spend - a.spend).slice(0, 3);\n const wastedHTML = wasted.map((r: any) => `

${esc(r.name)}

광고비 ${fmt(r.spend)} / 클릭 ${r.clk} / 매출 0원

`).join(\"\");\n const trendRows = trend.map((t: any) => {\n const roas = t.spend > 0 ? Math.round(t.revenue / t.spend * 100) : 0;\n return `${t.date}${fmt(t.spend)}${fmtN(t.imp)}${t.clk}${t.conv}${fmt(t.revenue)}${roas.toLocaleString()}%`;\n }).join(\"\");\n const allRows = rows.map((r: any, i: number) => `${i + 1}${esc(r.name)}${r.tp}${fmt(r.spend)}${fmtN(r.clk)}${r.conv}${fmt(r.rev)}${r.roas > 0 ? r.roas.toLocaleString() + \"%\" : \"-\"}`).join(\"\") || `전일 활성 캠페인 없음`;\n return `\n

${emoji} ${brand}

30일 광고비

${fmt(s.tSpend)}

30일 매출

${fmt(s.tRev)}

30일 ROAS

${s.tRoas.toLocaleString()}%

30일 전환

${s.tConv}건

전일 광고비

${fmt(s.ySpend)}

전일 매출

${fmt(s.yRev)}

전일 ROAS

${s.yRoas.toLocaleString()}%

전일 전환

${s.yConv}건

SA 효율 분석

\n${top5HTML ? `

⭐ ROAS TOP 5 캠페인

${top5HTML}` : '

전환된 캠페인 없음

'}\n${wastedHTML ? `

⚠️ 비효율 캠페인

${wastedHTML}` : \"\"}\n

SA 일별 분석 (30일)

광고비매출ROAS

\n${trendRows}

날짜	광고비	노출	클릭	전환	매출	ROAS

SA 키워드 분석

\n${renderKeywordsSection(brand)}\n

SA 캠페인유형별 상세

\n${renderSADetail()}\n

📋 ${brand} 전체 캠페인 (전일)

\n${allRows}

#	캠페인명	유형	광고비	클릭	전환	매출	ROAS

\n`;\n };\n const overallChart = JSON.stringify({\n labels: d.trendByBrand[\"풍년보감\"].map((t: any) => t.date.slice(5)),\n pn: d.trendByBrand[\"풍년보감\"].map((t: any) => t.spend),\n ts: d.trendByBrand[\"텅스페이스\"].map((t: any) => t.spend),\n pnRev: d.trendByBrand[\"풍년보감\"].map((t: any) => t.revenue),\n tsRev: d.trendByBrand[\"텅스페이스\"].map((t: any) => t.revenue),\n });\n let aiSection = \"\";\n if (d.aiAnalysis && d.aiAnalysis.html) {\n const generatedAt = d.aiAnalysis.savedAt ? new Date(d.aiAnalysis.savedAt).toLocaleString(\"ko-KR\", { timeZone: \"Asia/Seoul\" }) : \"\";\n aiSection = `

🤖 AI 자동 분석 & 액션플랜

생성: ${generatedAt} KST · 캠페인/그룹/소재 3단계 분석

${d.aiAnalysis.html}

`;\n } else {\n aiSection = `

🤖 AI 자동 분석

매일 아침 07:30 KST에 자동 생성됩니다. 첫 분석은 내일 새벽부터 표시 예정.

`;\n }\n return `\n네이버 마케팅 통합 리포트 — ${d.targetDate}\n\n

분석 기간: ${d.trendByBrand[\"풍년보감\"][0]?.date || \"\"} ~ ${d.targetDate} (오늘 제외, 전일까지 30일)

네이버 마케팅 통합 리포트

${d.trendByBrand[\"풍년보감\"][0]?.date || \"\"} ~ ${d.targetDate}

PNBG · 풍년보감 + 텅스페이스 · AI 분석 + SA 캠페인유형별 통합

전체 통합 KPI

30일 총 광고비

${fmt(d.overall.tSpend)}

30일 총 매출

${fmt(d.overall.tRev)}

30일 통합 ROAS

${d.overall.tRoas.toLocaleString()}%

30일 총 전환

${d.overall.tConv}건

전일 광고비

${fmt(d.overall.ySpend)}

전일 매출

${fmt(d.overall.yRev)}

전일 ROAS

${d.overall.yRoas.toLocaleString()}%

전일 전환

${d.overall.yConv}건

📊 브랜드별 30일 비교

풍년보감 광고비텅스페이스 광고비풍년보감 매출텅스페이스 매출

\n${renderBrandSection(\"풍년보감\", \"🍯\", \"theme-pnbg\")}\n${renderBrandSection(\"텅스페이스\", \"🫧\", \"theme-ts\")}\n${aiSection}\n\n

\n\n`;\n}","createdAt",["D",1781750584664],"branchVersion","branchId","f3cd4724-4cde-11f1-8ce8-ee650bb23af1","id","ef82bd7a-4cde-11f1-bca8-ee650bb23af1","Marketingauto",["D",1778465580996],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","93449a43-3797-404d-b4ae-d751bcdd306b","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019e14ce-2bdb-768c-a9d4-d59a30b7544b","tursoName","ef82bd7a4cde11f1bca8ee650bb23af1","tursoHostname","ef82bd7a4cde11f1bca8ee650bb23af1-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789491713377],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_99":98,"_107":103},"org",{"_99":98,"_100":101,"_102":103,"_18":54,"_104":105,"_106":25},"branch",{"_13":86,"_32":87,"_43":42,"_88":44,"_89":90,"_91":92,"_93":50,"_94":44,"_95":62,"_96":45,"_97":98},"isOwned",110,"naverOrders","projectId","forkedBranchId","ef84c82c-4cde-11f1-bca8-ee650bb23af1","forkedBranchVersion",5,"forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","joowoo","handle","displayName","joo woo","avatar","https://lh3.googleusercontent.com/a/ACg8ocJHI4ZtyHAcRli0zHzjn03GuJOb_BpuVst0ZtYzcbbGbLzMGA=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":267,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":-5,"_56":25,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":64,"_65":66,"_67":268,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":269,"_81":270,"_83":271,"_85":25},"tree",[230,231,232,233,234,235,236,237,238],"files",[230,231,232,233,234,235,236,237,238],"counts",{"_217":218,"_219":220,"_221":60,"_222":223,"_224":225},"contents",[139,140,141,142,143,144,145,146,147],"upstreamProject","upstreamBranch",{"_43":90,"_38":132,"_133":134,"_32":135,"_88":44,"_13":136,"_89":-5,"_91":-5,"_137":138,"_47":-5,"_85":25,"_49":50,"_97":98,"_61":62,"_96":45},"emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},["D",1778465581010],"updatedAt",["D",1782110067926],"main",134,"lockfileKey","1782110068005-esm.town_v_joowoo_Marketingauto@134-main",{"_43":210,"_32":211,"_30":212,"_151":-5,"_41":42,"_40":213,"_153":127,"_38":214,"_13":176,"_33":164,"_35":215,"_24":25,"_157":-5,"_27":216},{"_43":202,"_32":203,"_30":204,"_151":-5,"_41":42,"_40":205,"_153":127,"_38":206,"_13":207,"_33":34,"_35":208,"_24":25,"_157":-5,"_27":209},{"_43":194,"_32":195,"_30":196,"_151":-5,"_41":42,"_40":197,"_153":127,"_38":198,"_13":199,"_33":34,"_35":200,"_24":25,"_157":-5,"_27":201},{"_43":186,"_32":187,"_30":188,"_151":-5,"_41":42,"_40":189,"_153":127,"_38":190,"_13":191,"_33":34,"_35":192,"_24":25,"_157":-5,"_27":193},{"_43":179,"_32":180,"_30":181,"_151":-5,"_41":42,"_40":182,"_153":127,"_38":183,"_13":60,"_33":34,"_35":184,"_24":25,"_157":-5,"_27":185},{"_43":171,"_32":172,"_30":173,"_151":-5,"_41":42,"_40":174,"_153":127,"_38":175,"_13":176,"_33":34,"_35":177,"_24":25,"_157":-5,"_27":178},{"_43":167,"_32":28,"_30":31,"_151":-5,"_41":42,"_40":14,"_153":25,"_38":168,"_13":169,"_33":34,"_35":37,"_24":25,"_157":-5,"_27":170},{"_43":159,"_32":160,"_30":161,"_151":-5,"_41":42,"_40":162,"_153":127,"_38":163,"_13":155,"_33":164,"_35":165,"_24":25,"_157":-5,"_27":166},{"_43":148,"_32":149,"_30":150,"_151":-5,"_41":42,"_40":152,"_153":127,"_38":154,"_13":155,"_33":34,"_35":156,"_24":25,"_157":-5,"_27":158},"441e8428-5427-11f1-82a8-ee650bb23af1","tossReport.ts","8a0b13c0-4eb9-11f1-b7d6-ee650bb23af1","parentId",71,"latest",["D",1779266304839],8,"/**\n * 토스쇼핑 매출 통합 리포트 — val.town HTTP Val\n *\n * GET → 30일 매출 리포트 (HTML, AI 분석 임베드)\n * POST ?key=WORKER_KEY (body: JSON {html, date, summary}) → blob 저장 + 노션 페이지 생성\n *\n * 환경변수:\n * - TOSS_ACCESS_KEY, TOSS_SECRET_KEY (필수)\n * - WORKER_KEY (POST 인증)\n * - NOTION_TOKEN, TOSS_NOTION_DB_ID (노션 적재용)\n *\n * 분류: productName에 텅스/곤약/쫀드기/쫀디기/쫀뜨기/스파이크샷 포함 → 텅스페이스, 나머지 → 풍년보감\n */\n\nimport { blob } from \"https://esm.town/v/std/blob\";\n\nconst TOSS_BASE = \"https://shopping-fep.toss.im\";\nconst OAUTH_URL = \"https://oauth2.cert.toss.im/token\";\nconst BLOB_AI_KEY = \"toss_ai_analysis_latest\";\nconst BLOB_TOKEN_KEY = \"toss_oauth_token\";\nconst TONGSPACE_KEYWORDS = [\"텅스\", \"곤약\", \"쫀드기\", \"쫀디기\", \"쫀뜨기\", \"스파이크샷\"];\nconst TOSS_REPORT_URL = \"https://joowoo--TOSS_VAL_HASH.web.val.run\"; // 배포 후 실제 URL로 교체\n\nfunction classifyBrand(name: string): \"풍년보감\" | \"텅스페이스\" {\n if (!name) return \"풍년보감\";\n for (const kw of TONGSPACE_KEYWORDS) if (name.includes(kw)) return \"텅스페이스\";\n return \"풍년보감\";\n}\n\nfunction dateKST(o: number): string {\n return new Date(Date.now() + o * 86400000).toLocaleDateString(\"sv-SE\", { timeZone: \"Asia/Seoul\" });\n}\n\nasync function getAccessToken(): Promise {\n // 캐시된 토큰 확인 (만료 5분 전까지 재사용)\n try {\n const cached: any = await blob.getJSON(BLOB_TOKEN_KEY);\n if (cached && cached.token && cached.expiresAt && cached.expiresAt > Date.now() + 5 * 60 * 1000) {\n return cached.token;\n }\n } catch (e) {}\n\n const accessKey = Deno.env.get(\"TOSS_ACCESS_KEY\");\n const secretKey = Deno.env.get(\"TOSS_SECRET_KEY\");\n if (!accessKey || !secretKey) throw new Error(\"TOSS_ACCESS_KEY/SECRET_KEY not set\");\n\n const resp = await fetch(OAUTH_URL, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/x-www-form-urlencoded\" },\n body: new URLSearchParams({\n grant_type: \"client_credentials\",\n client_id: accessKey,\n client_secret: secretKey,\n scope: \"toss-shopping-fep:write\",\n }),\n });\n if (!resp.ok) throw new Error(`OAuth ${resp.status}: ${await resp.text()}`);\n const data = await resp.json();\n const token = data.access_token as string;\n const expiresIn = (data.expires_in || 3600) as number;\n await blob.setJSON(BLOB_TOKEN_KEY, { token, expiresAt: Date.now() + expiresIn * 1000 });\n return token;\n}\n\nasync function callToss(uri: string, qs: Record = {}): Promise {\n const token = await getAccessToken();\n const url = new URL(`${TOSS_BASE}${uri}`);\n for (const [k, v] of Object.entries(qs)) url.searchParams.set(k, v);\n const res = await fetch(url.toString(), {\n headers: {\n Authorization: `Bearer ${token}`,\n \"Content-Type\": \"application/json\",\n },\n });\n if (!res.ok) throw new Error(`${uri} ${res.status}: ${await res.text()}`);\n const data = await res.json();\n if (data.resultType === \"FAIL\") throw new Error(`Toss API: ${data.error?.errorCode} ${data.error?.reason}`);\n return data.success;\n}\n\nasync function fetchOrdersInRange(startDate: string, endDate: string): Promise {\n // 토스 API 최대 31일 제한. 30일 윈도우는 한 번에 가능\n const all: any[] = [];\n let cursor: string | null = null;\n let safety = 0;\n while (safety++ < 200) { // 최대 200페이지 = 10,000건\n const qs: Record = { startDate, endDate, limit: \"50\" };\n if (cursor) qs.nextCursor = cursor;\n const result = await callToss(\"/api/v3/shopping-fep/orders/v2\", qs);\n const results = result?.results || [];\n all.push(...results);\n cursor = result?.nextCursor || null;\n if (!cursor) break;\n }\n return all;\n}\n\nfunction fmt(n: number): string {\n return n.toLocaleString(\"ko-KR\") + \"원\";\n}\n\nfunction fmtN(n: number): string {\n return n.toLocaleString(\"ko-KR\");\n}\n\nfunction esc(s: string): string {\n return String(s || \"\").replace(/&/g, \"&\").replace(//g, \">\");\n}\n\n// ━━━ 노션 헬퍼 (v6/v7과 동일 패턴) ━━━\nfunction stripTags(s: string): string {\n return s.replace(/<[^>]+>/g, \"\").replace(/ /g, \" \").replace(/&/g, \"&\").replace(/</g, \"<\").replace(/>/g, \">\").replace(/"/g, '\"').trim();\n}\n\nfunction htmlToNotionBlocks(html: string): any[] {\n const blocks: any[] = [];\n blocks.push({\n object: \"block\",\n type: \"callout\",\n callout: {\n rich_text: [{ type: \"text\", text: { content: \"전체 토스 매출 리포트는 val.town에서 확인. 이 페이지는 노션 검색·아카이브용 요약입니다.\" } }],\n icon: { type: \"emoji\", emoji: \"💰\" },\n color: \"blue_background\",\n },\n });\n\n const sectionRegex = /

([\\s\\S]?)<\\/h3>([\\s\\S]?)(?=

|$)/g;\n let m;\n while ((m = sectionRegex.exec(html)) !== null) {\n const title = stripTags(m[1]);\n const content = m[2];\n if (!title) continue;\n blocks.push({\n object: \"block\",\n type: \"heading_2\",\n heading_2: { rich_text: [{ type: \"text\", text: { content: title.slice(0, 1900) } }] },\n });\n\n const paraRe = /

([\\s\\S]*?)<\\/p>/g;\n let pm;\n while ((pm = paraRe.exec(content)) !== null) {\n const t = stripTags(pm[1]);\n if (t) blocks.push({\n object: \"block\",\n type: \"paragraph\",\n paragraph: { rich_text: [{ type: \"text\", text: { content: t.slice(0, 1900) } }] },\n });\n }\n\n const listRe = /<(ol|ul)>([\\s\\S]*?)<\\/\\1>/g;\n let lm;\n while ((lm = listRe.exec(content)) !== null) {\n const isOrdered = lm[1] === \"ol\";\n const itemRe = /

([\\s\\S]*?)<\\/li>/g;\n let im;\n while ((im = itemRe.exec(lm[2])) !== null) {\n const t = stripTags(im[1]);\n if (!t) continue;\n const key = isOrdered ? \"numbered_list_item\" : \"bulleted_list_item\";\n blocks.push({\n object: \"block\",\n type: key,\n [key]: { rich_text: [{ type: \"text\", text: { content: t.slice(0, 1900) } }] },\n });\n }\n }\n }\n\n blocks.push({\n object: \"block\",\n type: \"paragraph\",\n paragraph: {\n rich_text: [\n { type: \"text\", text: { content: \"전체 인터랙티브 리포트: \" } },\n { type: \"text\", text: { content: \"토스 매출 리포트 열기\", link: { url: TOSS_REPORT_URL } } },\n ],\n },\n });\n\n return blocks.slice(0, 100);\n}\n\nasync function createNotionPage(p: {\n date: string;\n summary: string;\n html: string;\n kpi: Record;\n totalRev: number;\n totalOrders: number;\n status: string;\n}): Promise {\n const token = Deno.env.get(\"NOTION_TOKEN\");\n const dbId = Deno.env.get(\"TOSS_NOTION_DB_ID\");\n if (!token || !dbId) throw new Error(\"NOTION_TOKEN / TOSS_NOTION_DB_ID not set\");\n\n const resp = await fetch(\"https://api.notion.com/v1/pages\", {\n method: \"POST\",\n headers: {\n Authorization: `Bearer ${token}`,\n \"Notion-Version\": \"2022-06-28\",\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({\n parent: { database_id: dbId },\n properties: {\n \"날짜\": { title: [{ text: { content: `${p.date} 토스쇼핑 매출 리포트` } }] },\n \"분석일\": { date: { start: p.date } },\n \"통합 매출\": { number: p.totalRev },\n \"통합 주문수\": { number: p.totalOrders },\n \"풍년보감 매출\": { number: p.kpi[\"풍년보감\"].revenue },\n \"풍년보감 주문수\": { number: p.kpi[\"풍년보감\"].orders },\n \"텅스페이스 매출\": { number: p.kpi[\"텅스페이스\"].revenue },\n \"텅스페이스 주문수\": { number: p.kpi[\"텅스페이스\"].orders },\n \"핵심 인사이트\": { rich_text: [{ text: { content: (p.summary || \"\").slice(0, 2000) } }] },\n \"상태\": { select: { name: p.status } },\n \"리포트 링크\": { url: TOSS_REPORT_URL },\n },\n children: htmlToNotionBlocks(p.html),\n }),\n });\n if (!resp.ok) throw new Error(`Notion ${resp.status}: ${(await resp.text()).slice(0, 500)}`);\n return (await resp.json()).id;\n}\n\n// ━━━ 메인 핸들러 ━━━\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n\n // GET ?kpi=1 → JSON KPI 반환 (슬랙 발송 cron이 호출) — blob 우선\n if (url.searchParams.get(\"kpi\") === \"1\") {\n const targetDate = url.searchParams.get(\"date\") || dateKST(-1);\n try {\n const dailyData: any = await blob.getJSON(`toss_daily_${targetDate}`).catch(() => null);\n const orders = dailyData?.orders || [];\n const k = aggregateKpi(orders);\n return Response.json({\n date: targetDate,\n totalRev: k.totalRev,\n totalOrders: k.totalOrders,\n pn: { rev: k.brand[\"풍년보감\"].revenue, orders: k.brand[\"풍년보감\"].orders },\n ts: { rev: k.brand[\"텅스페이스\"].revenue, orders: k.brand[\"텅스페이스\"].orders },\n status: k.status,\n });\n } catch (err: any) {\n return Response.json({ error: err.message }, { status: 500 });\n }\n }\n\n // 진단: GET ?ip=1 → 현재 출구 IP + 토스 API 호출 가능 여부\n if (url.searchParams.get(\"ip\") === \"1\") {\n const ipify = await fetch(\"https://api.ipify.org?format=json\").then(r => r.json()).catch(e => ({ error: String(e) }));\n const ipinfo = await fetch(\"https://ipinfo.io/json\").then(r => r.json()).catch(e => ({ error: String(e) }));\n let tossPing: any = { skipped: true };\n try {\n const token = await getAccessToken();\n const pingResp = await fetch(`${TOSS_BASE}/api/v3/shopping-fep/orders/v2?startDate=${dateKST(-1)}&endDate=${dateKST(-1)}&limit=1`, {\n headers: { Authorization: `Bearer ${token}` },\n });\n tossPing = { status: pingResp.status, body: (await pingResp.text()).slice(0, 300) };\n } catch (e: any) {\n tossPing = { error: e.message };\n }\n return Response.json({ ipify, ipinfo, tossPing });\n }\n\n // POST: action에 따라 다른 처리\n if (req.method === \"POST\") {\n if (url.searchParams.get(\"key\") !== Deno.env.get(\"WORKER_KEY\")) {\n return Response.json({ error: \"unauthorized\" }, { status: 401 });\n }\n const action = url.searchParams.get(\"action\");\n\n // action=debug → Make.com에서 보낸 body 그대로 blob에 저장 (진단용)\n if (action === \"debug\") {\n try {\n const body = await req.text();\n await blob.setJSON(\"debug_makecom_echo\", {\n body, savedAt: new Date().toISOString(),\n });\n return Response.json({ ok: true, saved: body.length });\n } catch (err: any) {\n return Response.json({ error: err.message }, { status: 500 });\n }\n }\n\n // GET ?get_debug=1 → 저장된 debug 데이터 조회\n // (this is in POST block, won't trigger)\n\n // action=raw → Make.com이 토스에서 받은 raw orders를 일별 blob에 저장\n // ?append=1 → 기존 데이터에 누적 (페이지네이션 후속 호출)\n // ?append=0 (또는 없음) → 덮어쓰기 (첫 페이지)\n // body 형식: {date, orders: [...]} 또는 {date, tossResponse: {success: {results: [...]}}} (Make.com 우회)\n if (action === \"raw\") {\n try {\n const body = await req.json();\n const targetDate = body.date || dateKST(-1);\n // orders 추출 (3가지 형식 지원)\n let newOrders: any[] = [];\n if (Array.isArray(body.orders)) {\n newOrders = body.orders;\n } else if (body.orders && typeof body.orders === \"object\") {\n // Make.com이 array를 단일 객체로 collapse한 케이스\n newOrders = [body.orders];\n } else if (body.tossResponse?.success?.results) {\n // Make.com이 토스 응답 통째로 전달한 케이스\n newOrders = body.tossResponse.success.results;\n }\n const append = url.searchParams.get(\"append\") === \"1\";\n\n let combined = newOrders;\n if (append) {\n const existing: any = await blob.getJSON(`toss_daily_${targetDate}`).catch(() => null);\n if (existing?.orders) combined = [...existing.orders, ...newOrders];\n }\n\n await blob.setJSON(`toss_daily_${targetDate}`, {\n date: targetDate,\n orders: combined,\n count: combined.length,\n savedAt: new Date().toISOString(),\n appended: append,\n });\n return Response.json({ ok: true, date: targetDate, count: combined.length, append });\n } catch (err: any) {\n return Response.json({ error: err.message }, { status: 500 });\n }\n }\n\n // 기본 POST (action 없음): AI 분석 저장 + 노션 적재\n try {\n const body = await req.json();\n const targetDate = body.date || dateKST(-1);\n const summary = body.summary || \"\";\n const html = body.html || \"\";\n\n await blob.setJSON(BLOB_AI_KEY, {\n html, date: targetDate, summary, savedAt: new Date().toISOString(),\n });\n\n let notionPageId: string | null = null;\n let notionError: string | null = null;\n try {\n // 토스 API 직접 호출 대신 blob에 저장된 raw orders 사용\n const dailyData: any = await blob.getJSON(`toss_daily_${targetDate}`).catch(() => null);\n const orders = dailyData?.orders || [];\n const k = aggregateKpi(orders);\n notionPageId = await createNotionPage({\n date: targetDate, summary, html,\n kpi: k.brand, totalRev: k.totalRev, totalOrders: k.totalOrders,\n status: k.status,\n });\n } catch (e: any) { notionError = e.message; }\n\n return Response.json({ ok: true, notionPageId, notionError });\n } catch (err: any) {\n return Response.json({ error: err.message }, { status: 500 });\n }\n }\n\n // GET: 풀 리포트 — blob의 일별 데이터(Make.com이 매일 적재) 우선 사용\n const targetDate = url.searchParams.get(\"date\") || dateKST(-1);\n const startDate = dateKST(-30);\n\n try {\n // 30일 일별 blob에서 orders 모으기 (Make.com이 daily 적재)\n const orders: any[] = [];\n for (let i = -30; i <= -1; i++) {\n const d = dateKST(i);\n try {\n const dailyData: any = await blob.getJSON(`toss_daily_${d}`);\n if (dailyData?.orders) orders.push(...dailyData.orders);\n } catch (e) { /* 그 날 데이터 없음 */ }\n }\n // 만약 blob에 데이터 없으면 → 토스 API 직접 호출 시도 (백업, IP 등록되어 있을 때만)\n if (orders.length === 0) {\n try {\n const apiOrders = await fetchOrdersInRange(startDate, targetDate);\n orders.push(...apiOrders);\n } catch (e) { /* IP 등록 안 됨 — blob 데이터만으로 진행 */ }\n }\n\n // 일별 집계\n const byDate: Record; qty: number }> = {};\n const byBrandDate: Record; qty: number }>> = {\n \"풍년보감\": {}, \"텅스페이스\": {},\n };\n for (const o of orders) {\n const d = (o.orderedAt || \"\").slice(0, 10);\n if (!d) continue;\n const brand = classifyBrand(o.productName || \"\");\n const revenue = (o.price || 0) - (o.totalDiscountPrice || 0);\n const qty = o.quantity || 0;\n if (!byDate[d]) byDate[d] = { rev: 0, orders: new Set(), qty: 0 };\n byDate[d].rev += revenue;\n byDate[d].orders.add(o.orderId);\n byDate[d].qty += qty;\n if (!byBrandDate[brand][d]) byBrandDate[brand][d] = { rev: 0, orders: new Set(), qty: 0 };\n byBrandDate[brand][d].rev += revenue;\n byBrandDate[brand][d].orders.add(o.orderId);\n byBrandDate[brand][d].qty += qty;\n }\n\n // 트렌드 (30일)\n const trendDates: string[] = [];\n for (let i = -30; i <= -1; i++) trendDates.push(dateKST(i));\n const trendByBrand: Record = { \"풍년보감\": [], \"텅스페이스\": [] };\n for (const b of [\"풍년보감\", \"텅스페이스\"]) {\n for (const d of trendDates) {\n const stat = byBrandDate[b][d] || { rev: 0, orders: new Set(), qty: 0 };\n trendByBrand[b].push({ date: d, rev: stat.rev, orders: stat.orders.size, qty: stat.qty });\n }\n }\n\n // 어제 KPI\n const yesterdayStats = aggregateKpi(orders.filter((o: any) => (o.orderedAt || \"\").slice(0, 10) === targetDate));\n // 30일 합계\n const monthStats = aggregateKpi(orders);\n\n // 상품 TOP 10\n const productMap = new Map();\n for (const o of orders) {\n const key = o.productName || \"(이름없음)\";\n const brand = classifyBrand(key);\n const revenue = (o.price || 0) - (o.totalDiscountPrice || 0);\n if (!productMap.has(key)) productMap.set(key, { name: key, brand, rev: 0, orders: 0, qty: 0 });\n const p = productMap.get(key)!;\n p.rev += revenue;\n p.orders += 1;\n p.qty += o.quantity || 0;\n }\n const topProducts = [...productMap.values()].sort((a, b) => b.rev - a.rev).slice(0, 10);\n\n // AI 분석\n let aiAnalysis: any = null;\n try { aiAnalysis = await blob.getJSON(BLOB_AI_KEY); } catch (e) {}\n\n const html = renderHTML({\n targetDate, startDate, trendByBrand, trendDates,\n yesterdayStats, monthStats, topProducts, aiAnalysis,\n });\n return new Response(html, {\n headers: { \"Content-Type\": \"text/html; charset=utf-8\", \"Cache-Control\": \"public, max-age=1800\" },\n });\n } catch (err: any) {\n return new Response(\n `

토스 리포트 오류

${esc(err.message)}\\n${esc(err.stack || \"\")}

`,\n { status: 500, headers: { \"Content-Type\": \"text/html; charset=utf-8\" } }\n );\n }\n}\n\nfunction aggregateKpi(orders: any[]) {\n const brand: Record }> = {\n \"풍년보감\": { revenue: 0, orders: 0, quantity: 0, orderSet: new Set() },\n \"텅스페이스\": { revenue: 0, orders: 0, quantity: 0, orderSet: new Set() },\n };\n let totalRev = 0; const totalOrderSet = new Set(); let totalQty = 0;\n for (const o of orders) {\n const b = classifyBrand(o.productName || \"\");\n const revenue = (o.price || 0) - (o.totalDiscountPrice || 0);\n brand[b].revenue += revenue;\n brand[b].orderSet.add(o.orderId);\n brand[b].quantity += o.quantity || 0;\n totalRev += revenue;\n totalOrderSet.add(o.orderId);\n totalQty += o.quantity || 0;\n }\n for (const b of [\"풍년보감\", \"텅스페이스\"]) brand[b].orders = brand[b].orderSet.size;\n const totalOrders = totalOrderSet.size;\n let status = \"정상\";\n if (totalRev === 0) status = \"데이터 부족\";\n else if (totalRev < 100000) status = \"검토 필요\";\n return { brand, totalRev, totalOrders, totalQty, status };\n}\n\nfunction renderHTML(d: any): string {\n const renderTrendChart = (brand: string) => {\n const t = d.trendByBrand[brand];\n const labels = JSON.stringify(t.map((x: any) => x.date.slice(5)));\n const rev = JSON.stringify(t.map((x: any) => x.rev));\n const ord = JSON.stringify(t.map((x: any) => x.orders));\n return ``;\n };\n\n const brandSection = (brand: string, emoji: string, theme: string) => {\n const ys = d.yesterdayStats.brand[brand];\n const ms = d.monthStats.brand[brand];\n const trend = d.trendByBrand[brand];\n const trendRows = trend.slice().reverse().map((t: any) => `${t.date}${fmt(t.rev)}${fmtN(t.orders)}건${fmtN(t.qty)}개`).join(\"\");\n return `\n

${emoji} ${brand}

30일 매출

${fmt(ms.revenue)}

30일 주문

${fmtN(ms.orders)}건

전일 매출

${fmt(ys.revenue)}

전일 주문

${fmtN(ys.orders)}건

일별 추이 (30일)

\n${trendRows}

날짜	매출	주문	수량

\n${renderTrendChart(brand)}\n`;\n };\n\n // AI 섹션\n let aiSection = \"\";\n if (d.aiAnalysis && d.aiAnalysis.html) {\n const ts = d.aiAnalysis.savedAt ? new Date(d.aiAnalysis.savedAt).toLocaleString(\"ko-KR\", { timeZone: \"Asia/Seoul\" }) : \"\";\n aiSection = `

토스쇼핑 AI 분석 & 액션플랜

생성: ${ts} KST

${d.aiAnalysis.html}

`;\n } else {\n aiSection = `

토스쇼핑 AI 분석

매일 아침 자동 생성됩니다.

`;\n }\n\n const topProductRows = d.topProducts.map((p: any, i: number) =>\n `${i + 1}${esc(p.name)}${esc(p.brand)}${fmt(p.rev)}${fmtN(p.orders)}건${fmtN(p.qty)}개`\n ).join(\"\");\n\n return `\n토스쇼핑 매출 통합 리포트 — ${d.targetDate}\n\n

분석 기간: ${d.startDate} ~ ${d.targetDate} (오늘 제외, 전일까지 30일)

토스쇼핑 매출 통합 리포트

${d.startDate} ~ ${d.targetDate}

PNBG · 풍년보감 + 텅스페이스 · 토스쇼핑 Direct API

전체 통합 KPI

30일 총 매출

${fmt(d.monthStats.totalRev)}

30일 총 주문

${fmtN(d.monthStats.totalOrders)}건

전일 매출

${fmt(d.yesterdayStats.totalRev)}

전일 주문

${fmtN(d.yesterdayStats.totalOrders)}건

\n${brandSection(\"풍년보감\", \"🍯\", \"theme-pnbg\")}\n${brandSection(\"텅스페이스\", \"🫧\", \"theme-ts\")}\n

상품 매출 TOP 10 (30일)

\n${topProductRows || ''}

#	상품명	브랜드	매출	주문	수량
데이터 없음

\n${aiSection}\n\n

`;\n}","label",[149],"df5df0d9-8964-4137-bc02-b1c470fd2c16","slackDailyCron.ts","a418d662-4eb4-11f1-91f3-ee650bb23af1",86,["D",1780882333054],"script","/**\n * 네이버 마케팅 일일 슬랙 발송 — val.town Cron Val\n *\n * 매일 08:00 KST에 자동 실행:\n * 1. val.town blob에서 어제 AI 분석 가져오기\n * 2. 네이버 SA API에서 어제 KPI 페치\n * 3. 노션에서 어제 등록된 페이지 URL 찾기\n * 4. Slack 메인 메시지 발송 → ts 받음\n * 5. 스레드 댓글로 KPI + 시그널 3 + TOP 3 + 어제 집행률\n *\n * 배포 방법:\n * 1. val.town → New Val → Type: Cron\n * 2. 이 코드 전체 붙여넣기\n * 3. Schedule: \"0 23 * * *\" (UTC, = 08:00 KST)\n * 4. 환경변수 (이미 다 등록되어 있어야 함):\n * - NAVER_SA_API_KEY, NAVER_SA_SECRET_KEY, NAVER_SA_CUSTOMER_ID\n * - NOTION_TOKEN, NOTION_DB_ID\n * - SLACK_BOT_TOKEN\n *\n * 채널/멘션 변경 시: 상수만 수정.\n */\n\nimport { blob } from \"https://esm.town/v/std/blob\";\n\nconst API_BASE = \"https://api.searchad.naver.com\";\nconst BLOB_AI_KEY = \"ai_analysis_latest\";\nconst TONGSPACE_KEYWORDS = [\"텅스\", \"곤약\", \"쫀드기\", \"쫀디기\", \"쫀뜨기\", \"스파이크샷\"];\nconst NOTION_DB_DEFAULT = \"5828d1bf-aa95-4662-bdf2-fae160d0654f\";\nconst REPORT_URL = \"https://joowoo--f970e0684cf811f1801eee650bb23af1.web.val.run\";\nconst TOSS_REPORT_URL = Deno.env.get(\"TOSS_REPORT_URL\") || \"https://joowoo--8a0b13c04eb911f1b7d6ee650bb23af1.web.val.run\";\nconst SLACK_CHANNEL_ID = Deno.env.get(\"SLACK_CHANNEL_ID\") || \"C09B0J6QXN1\"; // #마케팅-data\nconst MARKETING_CELL_SUBTEAM = Deno.env.get(\"MARKETING_CELL_SUBTEAM\") || \"S09PHRXUR0W\";\n\nasync function fetchTossKPI(targetDate: string): Promise {\n try {\n const resp = await fetch(`${TOSS_REPORT_URL}?kpi=1&date=${targetDate}`);\n if (!resp.ok) return null;\n return await resp.json();\n } catch (e) { return null; }\n}\n\nfunction classifyBrand(name: string): \"풍년보감\" | \"텅스페이스\" {\n for (const kw of TONGSPACE_KEYWORDS) if (name.includes(kw)) return \"텅스페이스\";\n return \"풍년보감\";\n}\n\nfunction dateKST(o: number): string {\n return new Date(Date.now() + o * 86400000).toLocaleDateString(\"sv-SE\", { timeZone: \"Asia/Seoul\" });\n}\n\nfunction stripTags(s: string): string {\n return s.replace(/<[^>]+>/g, \"\").replace(/ /g, \" \").replace(/&/g, \"&\").replace(/</g, \"<\").replace(/>/g, \">\").replace(/"/g, '\"').trim();\n}\n\nfunction fmt(n: number): string {\n return n.toLocaleString(\"ko-KR\") + \"원\";\n}\n\nasync function makeSignature(secretKey: string, ts: string, method: string, uri: string): Promise {\n const enc = new TextEncoder();\n const key = await crypto.subtle.importKey(\"raw\", enc.encode(secretKey), { name: \"HMAC\", hash: \"SHA-256\" }, false, [\"sign\"]);\n const sig = await crypto.subtle.sign(\"HMAC\", key, enc.encode(`${ts}.${method}.${uri}`));\n return btoa(String.fromCharCode(...new Uint8Array(sig)));\n}\n\nasync function callNaver(uri: string, qs: Record = {}): Promise {\n const apiKey = Deno.env.get(\"NAVER_SA_API_KEY\")!;\n const secretKey = Deno.env.get(\"NAVER_SA_SECRET_KEY\")!;\n const customerId = Deno.env.get(\"NAVER_SA_CUSTOMER_ID\")!;\n const ts = String(Date.now());\n const sig = await makeSignature(secretKey, ts, \"GET\", uri);\n const url = new URL(`${API_BASE}${uri}`);\n for (const [k, v] of Object.entries(qs)) url.searchParams.set(k, v);\n const res = await fetch(url.toString(), {\n headers: { \"X-Timestamp\": ts, \"X-API-KEY\": apiKey, \"X-Customer\": customerId, \"X-Signature\": sig },\n });\n if (!res.ok) throw new Error(`${uri} ${res.status}`);\n return res.json();\n}\n\nasync function fetchYesterdayKPI(targetDate: string) {\n const campaigns: any[] = await callNaver(\"/ncc/campaigns\");\n const cmap = new Map(campaigns.map((c: any) => [c.nccCampaignId, { ...c, brand: classifyBrand(c.name) }]));\n const ids = campaigns.map((c: any) => c.nccCampaignId).join(\",\");\n const stats = await callNaver(\"/stats\", {\n ids,\n fields: '[\"impCnt\",\"clkCnt\",\"salesAmt\",\"ccnt\",\"ctr\",\"cpc\",\"convAmt\"]',\n timeRange: JSON.stringify({ since: targetDate, until: targetDate }),\n });\n const kpi: Record = {\n \"풍년보감\": { spend: 0, rev: 0, conv: 0 },\n \"텅스페이스\": { spend: 0, rev: 0, conv: 0 },\n };\n for (const s of (stats?.data || [])) {\n const c = cmap.get(s.id);\n if (!c) continue;\n kpi[c.brand].spend += s.salesAmt || 0;\n kpi[c.brand].rev += s.convAmt || 0;\n kpi[c.brand].conv += s.ccnt || 0;\n }\n const pn = kpi[\"풍년보감\"]; const ts = kpi[\"텅스페이스\"];\n const total = { spend: pn.spend + ts.spend, rev: pn.rev + ts.rev, conv: pn.conv + ts.conv };\n return {\n pn, ts, total,\n pnRoas: pn.spend > 0 ? Math.round(pn.rev / pn.spend * 100) : 0,\n tsRoas: ts.spend > 0 ? Math.round(ts.rev / ts.spend * 100) : 0,\n totalRoas: total.spend > 0 ? Math.round(total.rev / total.spend * 100) : 0,\n };\n}\n\nfunction extractSectionItems(html: string, sectionTitle: string, max: number = 3): string[] {\n const re = new RegExp(`

${sectionTitle}

([\\\\s\\\\S]*?)(?=

|$)`, \"\");\n const m = html.match(re);\n if (!m) return [];\n const content = m[1];\n\n //

우선\n const items: string[] = [];\n const liRe = /

([\\s\\S]*?)<\\/li>/g;\n let lm;\n while ((lm = liRe.exec(content)) !== null) {\n const t = stripTags(lm[1]);\n if (t) items.push(t);\n if (items.length >= max) return items;\n }\n if (items.length > 0) return items;\n\n // 표의 행\n const rowRe = /([\\s\\S]*?)<\\/tr>/g;\n let rm; let isFirst = true;\n while ((rm = rowRe.exec(content)) !== null) {\n if (isFirst) { isFirst = false; continue; } // 헤더 행 skip\n const cellRe = /]*>([\\s\\S]*?)<\\/t[hd]>/g;\n const cells: string[] = [];\n let cm;\n while ((cm = cellRe.exec(rm[1])) !== null) cells.push(stripTags(cm[1]));\n if (cells.length) items.push(cells.join(\" · \"));\n if (items.length >= max) return items;\n }\n return items;\n}\n\nfunction extractInsight(html: string): string {\n const re = /

핵심 인사이트<\\/h3>\\s*
([\\s\\S]*?)<\\/p>/;\n const m = html.match(re);\n return m ? stripTags(m[1]) : \"\";\n}\n\nfunction extractFollowup(html: string): string {\n const re = /

어제 권장 액션 후속 추적<\\/h3>([\\s\\S]*?)(?=

|$)/;\n const m = html.match(re);\n if (!m) return \"전일 분석 데이터 없음\";\n const text = stripTags(m[1]).slice(0, 400);\n return text || \"전일 분석 데이터 없음\";\n}\n\nasync function findYesterdayNotionPage(targetDate: string): Promise {\n const token = Deno.env.get(\"NOTION_TOKEN\");\n const dbId = Deno.env.get(\"NOTION_DB_ID\") || NOTION_DB_DEFAULT;\n if (!token) return null;\n try {\n const resp = await fetch(`https://api.notion.com/v1/databases/${dbId}/query`, {\n method: \"POST\",\n headers: {\n \"Authorization\": `Bearer ${token}`,\n \"Notion-Version\": \"2022-06-28\",\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({\n filter: { property: \"분석일\", date: { equals: targetDate } },\n page_size: 1,\n }),\n });\n if (!resp.ok) return null;\n const data = await resp.json();\n return data.results?.[0]?.url || null;\n } catch (e) { return null; }\n}\n\nasync function slackPost(method: string, body: any, token: string): Promise {\n const resp = await fetch(`https://slack.com/api/${method}`, {\n method: \"POST\",\n headers: {\n \"Authorization\": `Bearer ${token}`,\n \"Content-Type\": \"application/json; charset=utf-8\",\n },\n body: JSON.stringify(body),\n });\n const data = await resp.json();\n if (!data.ok) throw new Error(`Slack ${method} failed: ${data.error}`);\n return data;\n}\n\nexport default async function () {\n const yesterday = dateKST(-1);\n const slackToken = Deno.env.get(\"SLACK_BOT_TOKEN\");\n if (!slackToken) throw new Error(\"SLACK_BOT_TOKEN not set\");\n\n // 1. AI 분석 가져오기 (없으면 빈 문자열로 진행)\n let aiAnalysis: any = null;\n try { aiAnalysis = await blob.getJSON(BLOB_AI_KEY); } catch (e) {}\n const aiHtml = aiAnalysis?.html || \"\";\n\n // 2. 어제 KPI 페치 (네이버 SA + 토스 병렬)\n const [k, tossKpi] = await Promise.all([\n fetchYesterdayKPI(yesterday),\n fetchTossKPI(yesterday),\n ]);\n\n // 3. 노션 페이지 URL 찾기\n const notionUrl = await findYesterdayNotionPage(yesterday) || \"https://www.notion.so/\" + (Deno.env.get(\"NOTION_DB_ID\") || NOTION_DB_DEFAULT).replace(/-/g, \"\");\n\n // 4. AI 분석에서 추출\n const insight = extractInsight(aiHtml);\n const signals = extractSectionItems(aiHtml, \"핵심 인사이트\", 0).length === 0\n ? extractSectionItems(aiHtml, \"캠페인 단위 데일리 액션\", 3) // fallback\n : [];\n const signalsFinal = signals.length > 0 ? signals : (insight ? [insight] : [\"AI 분석 데이터 없음 — 오늘 07:30 정기 실행 후 적재 예정\"]);\n const top3 = extractSectionItems(aiHtml, \"오늘 즉시 실행 우선순위\", 3);\n const top3Final = top3.length > 0 ? top3 : [\"AI 분석 미작성 — 데이터 확인 후 수동 액션 검토 필요\"];\n const followup = extractFollowup(aiHtml);\n\n // 5. 메인 메시지 — Block Kit으로 두 링크 버튼 + 노션 링크\n const mainBlocks = [\n {\n type: \"section\",\n text: {\n type: \"mrkdwn\",\n text: ` 좋은 아침! 어제 (${yesterday}) 마케팅 리포트가 준비됐어요.\\n\\nPNBG 풍년보감 + 텅스페이스의 검색광고 성과와 토스쇼핑 매출을 한눈에 확인하세요.`,\n },\n },\n {\n type: \"actions\",\n elements: [\n { type: \"button\", text: { type: \"plain_text\", text: \"네이버 검색광고 열기\" }, url: REPORT_URL, style: \"primary\" },\n { type: \"button\", text: { type: \"plain_text\", text: \"토스 매출 열기\" }, url: TOSS_REPORT_URL },\n { type: \"button\", text: { type: \"plain_text\", text: \"노션 페이지\" }, url: notionUrl },\n ],\n },\n ];\n\n const mainResp = await slackPost(\"chat.postMessage\", {\n channel: SLACK_CHANNEL_ID,\n text: `${yesterday} 마케팅 리포트 준비됨`,\n blocks: mainBlocks,\n unfurl_links: false,\n unfurl_media: false,\n }, slackToken);\n\n const threadTs = mainResp.ts;\n\n // 6. 스레드 댓글 — KPI는 Block Kit table, 나머지는 section\n const cell = (text: string, bold = false) => ({\n type: \"rich_text\",\n elements: [{\n type: \"rich_text_section\",\n elements: [{ type: \"text\", text, ...(bold ? { style: { bold: true } } : {}) }],\n }],\n });\n\n const signalsBlock = `*핵심 시그널 ${signalsFinal.length}가지*\\n` +\n signalsFinal.slice(0, 3).map((s, i) => `${i + 1}. ${s.slice(0, 250)}`).join(\"\\n\");\n const top3Block = `*오늘 실행 TOP 3*\\n` +\n top3Final.slice(0, 3).map((s, i) => `${i + 1}. ${s.slice(0, 250)}`).join(\"\\n\");\n const followupBlock = `*어제 집행률*\\n${followup.slice(0, 300)}`;\n\n const blocks: any[] = [\n { type: \"section\", text: { type: \"mrkdwn\", text: `*네이버 검색광고 KPI (${yesterday})*` } },\n {\n type: \"table\",\n rows: [\n [cell(\"구분\", true), cell(\"광고비\", true), cell(\"매출\", true), cell(\"ROAS\", true)],\n [cell(\"통합\"), cell(fmt(k.total.spend)), cell(fmt(k.total.rev)), cell(`${k.totalRoas.toLocaleString()}%`)],\n [cell(\"풍년보감\"), cell(fmt(k.pn.spend)), cell(fmt(k.pn.rev)), cell(`${k.pnRoas.toLocaleString()}%`)],\n [cell(\"텅스페이스\"), cell(fmt(k.ts.spend)), cell(fmt(k.ts.rev)), cell(`${k.tsRoas.toLocaleString()}%`)],\n ],\n },\n ];\n\n // 토스 KPI 표 (페치 성공 시만)\n if (tossKpi && !tossKpi.error) {\n blocks.push({ type: \"divider\" });\n blocks.push({ type: \"section\", text: { type: \"mrkdwn\", text: `*토스쇼핑 매출 KPI (${yesterday})*` } });\n blocks.push({\n type: \"table\",\n rows: [\n [cell(\"구분\", true), cell(\"매출\", true), cell(\"주문수\", true)],\n [cell(\"통합\"), cell(fmt(tossKpi.totalRev || 0)), cell(`${(tossKpi.totalOrders || 0).toLocaleString()}건`)],\n [cell(\"풍년보감\"), cell(fmt(tossKpi.pn?.rev || 0)), cell(`${(tossKpi.pn?.orders || 0).toLocaleString()}건`)],\n [cell(\"텅스페이스\"), cell(fmt(tossKpi.ts?.rev || 0)), cell(`${(tossKpi.ts?.orders || 0).toLocaleString()}건`)],\n ],\n });\n }\n\n blocks.push({ type: \"divider\" });\n blocks.push({ type: \"section\", text: { type: \"mrkdwn\", text: signalsBlock } });\n blocks.push({ type: \"section\", text: { type: \"mrkdwn\", text: top3Block } });\n blocks.push({ type: \"section\", text: { type: \"mrkdwn\", text: followupBlock } });\n blocks.push({ type: \"context\", elements: [{ type: \"mrkdwn\", text: \"_액션플랜을 수정하시려면 이 스레드에 *✏️수정 액션플랜:* 으로 시작하는 댓글을 작성하세요. 5분 내 보고서와 노션에 자동 반영됩니다._\" }] });\n\n await slackPost(\"chat.postMessage\", {\n channel: SLACK_CHANNEL_ID,\n text: `요약 KPI ${yesterday} — ${k.totalRoas}% ROAS`,\n blocks,\n thread_ts: threadTs,\n unfurl_links: false,\n unfurl_media: false,\n }, slackToken);\n\n console.log(`[OK] Slack 발송 완료 — ${yesterday} | main_ts=${threadTs} | notion=${notionUrl}`);\n return { ok: true, date: yesterday, mainTs: threadTs, notionUrl };\n}",[160],"527b89dd-711e-451c-9057-5207b9966b67",["D",1781750584664],18,[28],"0db5de5a-4ce7-11f1-b441-ee650bb23af1","naverOrders.ts","019e14cf-43f6-7268-b974-fbb12d9b6030",10,["D",1778469067627],9,"/**\n * 네이버 커머스API용 bcrypt 서명 생성기 + Make IP 진단 (val.town)\n * 환경변수: NAVER_CLIENT_ID, NAVER_CLIENT_SECRET, WORKER_KEY\n *\n * 응답에 source_ip 추가 → Make가 실제로 어떤 IP에서 호출하는지 확인 가능\n */\n\nimport bcrypt from \"npm:bcryptjs\";\n\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n\n if (url.searchParams.get(\"key\") !== Deno.env.get(\"WORKER_KEY\")) {\n return Response.json({ error: \"unauthorized\" }, { status: 401 });\n }\n\n const NAVER_CLIENT_ID = Deno.env.get(\"NAVER_CLIENT_ID\")!;\n const NAVER_CLIENT_SECRET = Deno.env.get(\"NAVER_CLIENT_SECRET\")!;\n\n // 호출자 IP 추출 (Make 등 클라이언트의 실제 outbound IP)\n const sourceIp = req.headers.get(\"x-forwarded-for\") ||\n req.headers.get(\"cf-connecting-ip\") ||\n req.headers.get(\"x-real-ip\") ||\n \"unknown\";\n\n try {\n const timestamp = Date.now();\n const password = `${NAVER_CLIENT_ID}_${timestamp}`;\n const hashed = bcrypt.hashSync(password, NAVER_CLIENT_SECRET);\n const signature = btoa(hashed);\n\n return Response.json({\n ok: true,\n client_id: NAVER_CLIENT_ID,\n timestamp: String(timestamp),\n signature: signature,\n source_ip: sourceIp, // ← Make가 실제로 어디서 호출하는지\n });\n } catch (err: any) {\n return Response.json(\n { error: \"exception\", message: err.message },\n { status: 500 },\n );\n }\n}",[172],"f52e2d3c-4f35-11f1-b87b-ee650bb23af1","main.ts","f52e2e18-4f35-11f1-b87b-ee650bb23af1",69,["D",1778722859031],"// Learn more: https://docs.val.town/vals/http/\nexport default async function (req: Request): Promise {\n return Response.json({ ok: true })\n}",[180],"73425b7e-4ebb-11f1-8051-ee650bb23af1","ipcheck.ts","66243b7e-4ebb-11f1-b5a1-ee650bb23af1",61,["D",1778670242462],6,"export default async function (): Promise {\n const checks = await Promise.all([\n fetch(\"https://api.ipify.org?format=json\").then(r => r.json()).catch(e => ({ error: String(e) })),\n fetch(\"https://ipinfo.io/json\").then(r => r.json()).catch(e => ({ error: String(e) })),\n fetch(\"https://ifconfig.me/all.json\").then(r => r.json()).catch(e => ({ error: String(e) })),\n ]);\n return Response.json({ checks });\n}",[187],"562ea1a0-5433-11f1-9770-ee650bb23af1","gfaoauth.ts","83989444-542d-11f1-acdb-ee650bb23af1",83,["D",1779271489093],11,"/**\n * GFA OAuth + 데이터 조회 (HTTP Val)\n *\n * Routes:\n * /auth /callback /status /refresh\n * /accounts → 광고 계정 목록\n * /managers → 관리 계정 목록\n * /manager?no=15146 → 매니저 상세 (하위 광고 계정 트리)\n * /campaigns?no=934268 → 캠페인 목록\n * /yesterday → 어제 GFA 성과 (단일)\n * /perf?start=YYYY-MM-DD&end=YYYY-MM-DD → 임의 기간 성과\n * /probe → 4개 매니저 후보로 어제 성과 시도 (광고계정 = env값)\n * /probeMatrix → 4개 광고계정 × 5개 매니저 후보 매트릭스 (어디서 200이 나오는지)\n */\n\nimport { blob } from \"https://esm.town/v/std/blob\";\n\nconst REDIRECT_URI = \"https://joowoo--83989444542d11f1acdbee650bb23af1.web.val.run/callback\";\nconst BLOB_TOKEN_KEY = \"gfa_oauth_token\";\nconst DEFAULT_AD_ACCOUNT = \"934268\";\nconst AD_CANDIDATES = [\"934268\", \"2235348\", \"2345846\", \"1432794\"];\nconst MANAGER_CANDIDATES = [\"15146\", \"934268\", \"2235348\", \"2345846\", \"1432794\"];\n\nasync function getValidAccessToken(clientId: string, clientSecret: string): Promise {\n const saved: any = await blob.getJSON(BLOB_TOKEN_KEY).catch(() => null);\n if (!saved?.refresh_token) return null;\n if (Date.now() < saved.expires_at) return saved.access_token;\n const refreshUrl = `https://nid.naver.com/oauth2.0/token?grant_type=refresh_token` +\n `&client_id=${clientId}&client_secret=${clientSecret}` +\n `&refresh_token=${saved.refresh_token}`;\n const resp = await fetch(refreshUrl, { method: \"POST\" });\n const data = await resp.json();\n if (!data.access_token) return null;\n const expiresAt = Date.now() + (parseInt(data.expires_in) - 60) * 1000;\n await blob.setJSON(BLOB_TOKEN_KEY, {\n ...saved,\n access_token: data.access_token,\n refresh_token: data.refresh_token || saved.refresh_token,\n expires_at: expiresAt,\n issued_at: Date.now(),\n });\n return data.access_token;\n}\n\nasync function gfaFetch(path: string, token: string, managerNo: string): Promise {\n const resp = await fetch(`https://openapi.naver.com/v1/ad-api/1.0${path}`, {\n headers: {\n Authorization: `Bearer ${token}`,\n \"AccessManagerAccountNo\": managerNo,\n },\n });\n const text = await resp.text();\n try { return { status: resp.status, body: JSON.parse(text) }; }\n catch { return { status: resp.status, body: text }; }\n}\n\nfunction htmlPage(title: string, body: string): Response {\n return new Response(\n `${title}\n\n${body}`,\n { headers: { \"Content-Type\": \"text/html; charset=utf-8\" } },\n );\n}\n\nfunction jsonResp(data: any, status = 200): Response {\n return new Response(JSON.stringify(data, null, 2), {\n status,\n headers: { \"Content-Type\": \"application/json; charset=utf-8\" },\n });\n}\n\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n const clientId = Deno.env.get(\"GFA_CLIENT_ID\");\n const clientSecret = Deno.env.get(\"GFA_CLIENT_SECRET\");\n const adAccountNo = Deno.env.get(\"GFA_AD_ACCOUNT_NO\") || DEFAULT_AD_ACCOUNT;\n const managerNo = Deno.env.get(\"GFA_MANAGER_NO\") || adAccountNo;\n\n if (!clientId || !clientSecret) {\n return htmlPage(\"환경변수 누락\",\n `

❌ Env vars 누락

GFA_CLIENT_ID = 2ekHdVjNcKwKDa5RY7qd
\n GFA_CLIENT_SECRET = 99osy05Liz

`);\n }\n\n if (url.pathname === \"/\" || url.pathname === \"/auth\") {\n const state = crypto.randomUUID();\n const authUrl = `https://nid.naver.com/oauth2.0/authorize?response_type=code` +\n `&client_id=${clientId}&redirect_uri=${encodeURIComponent(REDIRECT_URI)}&state=${state}`;\n return Response.redirect(authUrl, 302);\n }\n\n if (url.pathname === \"/callback\") {\n const code = url.searchParams.get(\"code\");\n const state = url.searchParams.get(\"state\");\n const err = url.searchParams.get(\"error\");\n if (err) return htmlPage(\"OAuth 오류\",\n `

❌ ${err}

${url.searchParams.get(\"error_description\") || \"\"}

다시 시도

`);\n if (!code) return new Response(\"Missing code parameter\", { status: 400 });\n const tokenUrl = `https://nid.naver.com/oauth2.0/token?grant_type=authorization_code` +\n `&client_id=${clientId}&client_secret=${clientSecret}&code=${code}&state=${state}`;\n const resp = await fetch(tokenUrl, { method: \"POST\" });\n const data = await resp.json();\n if (!data.access_token) return htmlPage(\"토큰 교환 실패\",\n `

❌ Token exchange failed

${JSON.stringify(data, null, 2)}

`);\n const expiresAt = Date.now() + (parseInt(data.expires_in) - 60) * 1000;\n await blob.setJSON(BLOB_TOKEN_KEY, {\n access_token: data.access_token,\n refresh_token: data.refresh_token,\n token_type: data.token_type || \"bearer\",\n expires_at: expiresAt,\n issued_at: Date.now(),\n });\n const mask = (s: string) => s ? s.slice(0, 6) + \"...\" + s.slice(-4) : \"(없음)\";\n return htmlPage(\"GFA OAuth 인증 완료\",\n `

✅ GFA OAuth 인증 완료

refresh_token: ${mask(data.refresh_token)}
\n expires_in: ${data.expires_in}초

상태 · 매트릭스 probe

`);\n }\n\n if (url.pathname === \"/status\") {\n const saved: any = await blob.getJSON(BLOB_TOKEN_KEY).catch(() => null);\n if (!saved) return htmlPage(\"토큰 없음\",\n `

❌ 저장된 토큰 없음

/auth로 인증 시작

`);\n const mask = (s: string) => s ? s.slice(0, 6) + \"...\" + s.slice(-4) : \"(없음)\";\n const expiresIn = Math.floor((saved.expires_at - Date.now()) / 1000);\n return htmlPage(\"토큰 상태\",\n `

✅ 토큰 저장됨

refresh_token: ${mask(saved.refresh_token)}
\n access_token expires in: ${expiresIn}초
\n 광고 계정: ${adAccountNo} · 매니저: ${managerNo}

광고 계정 · 매니저 목록 · 매트릭스 probe · 어제 성과

`);\n }\n\n if (url.pathname === \"/refresh\") {\n const saved: any = await blob.getJSON(BLOB_TOKEN_KEY).catch(() => null);\n if (!saved?.refresh_token) return new Response(\"No refresh_token saved.\", { status: 400 });\n const refreshUrl = `https://nid.naver.com/oauth2.0/token?grant_type=refresh_token` +\n `&client_id=${clientId}&client_secret=${clientSecret}&refresh_token=${saved.refresh_token}`;\n const resp = await fetch(refreshUrl, { method: \"POST\" });\n const data = await resp.json();\n if (!data.access_token) return new Response(`Refresh failed:\\n${JSON.stringify(data, null, 2)}`, { status: 500 });\n const expiresAt = Date.now() + (parseInt(data.expires_in) - 60) * 1000;\n await blob.setJSON(BLOB_TOKEN_KEY, { ...saved, access_token: data.access_token, refresh_token: data.refresh_token || saved.refresh_token, expires_at: expiresAt, issued_at: Date.now() });\n return new Response(`✅ Refreshed.\\nNew expires_in: ${data.expires_in}s`, { headers: { \"Content-Type\": \"text/plain; charset=utf-8\" } });\n }\n\n if (url.pathname === \"/accounts\") {\n const token = await getValidAccessToken(clientId, clientSecret);\n if (!token) return new Response(\"No token.\", { status: 401 });\n const resp = await fetch(\"https://openapi.naver.com/v1/ad-api/1.0/adAccounts\", {\n headers: { Authorization: `Bearer ${token}` },\n });\n return new Response(await resp.text(), { headers: { \"Content-Type\": \"application/json; charset=utf-8\" } });\n }\n\n if (url.pathname === \"/managers\") {\n const token = await getValidAccessToken(clientId, clientSecret);\n if (!token) return new Response(\"No token.\", { status: 401 });\n const resp = await fetch(\"https://openapi.naver.com/v1/ad-api/1.0/managerAccounts?page=0&size=100\", {\n headers: { Authorization: `Bearer ${token}` },\n });\n return new Response(await resp.text(), { headers: { \"Content-Type\": \"application/json; charset=utf-8\" } });\n }\n\n if (url.pathname === \"/manager\") {\n const no = url.searchParams.get(\"no\") || \"15146\";\n const token = await getValidAccessToken(clientId, clientSecret);\n if (!token) return new Response(\"No token.\", { status: 401 });\n const r = await gfaFetch(`/managerAccounts/${no}`, token, no);\n return jsonResp(r);\n }\n\n if (url.pathname === \"/campaigns\") {\n const no = url.searchParams.get(\"no\") || adAccountNo;\n const m = url.searchParams.get(\"m\") || managerNo;\n const token = await getValidAccessToken(clientId, clientSecret);\n if (!token) return new Response(\"No token.\", { status: 401 });\n const result = await gfaFetch(`/adAccounts/${no}/campaigns?page=0&size=100`, token, m);\n return jsonResp(result);\n }\n\n if (url.pathname === \"/yesterday\") {\n const token = await getValidAccessToken(clientId, clientSecret);\n if (!token) return new Response(\"No token.\", { status: 401 });\n const yesterday = new Date(Date.now() - 86400000).toLocaleDateString(\"sv-SE\", { timeZone: \"Asia/Seoul\" });\n const campRes = await gfaFetch(`/adAccounts/${adAccountNo}/campaigns?page=0&size=100`, token, managerNo);\n const perfRes = await gfaFetch(\n `/adAccounts/${adAccountNo}/performance/past/campaigns?startDate=${yesterday}&endDate=${yesterday}&timeUnit=daily`,\n token, managerNo,\n );\n return jsonResp({\n date: yesterday, adAccountNo, managerNo,\n campaigns_status: campRes.status, campaigns: campRes.body,\n performance_status: perfRes.status, performance: perfRes.body,\n });\n }\n\n if (url.pathname === \"/perf\") {\n const start = url.searchParams.get(\"start\");\n const end = url.searchParams.get(\"end\") || start;\n if (!start) return new Response(\"?start=YYYY-MM-DD required\", { status: 400 });\n const token = await getValidAccessToken(clientId, clientSecret);\n if (!token) return new Response(\"No token.\", { status: 401 });\n const result = await gfaFetch(\n `/adAccounts/${adAccountNo}/performance/past/campaigns?startDate=${start}&endDate=${end}&timeUnit=daily`,\n token, managerNo,\n );\n return jsonResp({ start, end, adAccountNo, managerNo, ...result });\n }\n\n if (url.pathname === \"/probe\") {\n const token = await getValidAccessToken(clientId, clientSecret);\n if (!token) return new Response(\"No token.\", { status: 401 });\n const yesterday = new Date(Date.now() - 86400000).toLocaleDateString(\"sv-SE\", { timeZone: \"Asia/Seoul\" });\n const results: Record = {};\n for (const m of MANAGER_CANDIDATES) {\n const r = await gfaFetch(\n `/adAccounts/${adAccountNo}/performance/past/campaigns?startDate=${yesterday}&endDate=${yesterday}&timeUnit=daily`,\n token, m,\n );\n results[`manager=${m}`] = { status: r.status, code: r.body?.error?.code || r.body?.error || null };\n }\n return jsonResp({ date: yesterday, adAccountNo, results });\n }\n\n // /probeMatrix → 4 광고계정 × 5 매니저 = 20개 조합 한번에 시도\n if (url.pathname === \"/probeMatrix\") {\n const token = await getValidAccessToken(clientId, clientSecret);\n if (!token) return new Response(\"No token.\", { status: 401 });\n const yesterday = new Date(Date.now() - 86400000).toLocaleDateString(\"sv-SE\", { timeZone: \"Asia/Seoul\" });\n const matrix: Record> = {};\n for (const a of AD_CANDIDATES) {\n matrix[a] = {};\n for (const m of MANAGER_CANDIDATES) {\n const r = await gfaFetch(\n `/adAccounts/${a}/performance/past/campaigns?startDate=${yesterday}&endDate=${yesterday}&timeUnit=daily`,\n token, m,\n );\n const rowsCount = r.body?.rows?.length;\n matrix[a][m] = {\n status: r.status,\n ...(r.status === 200 ? { rows: rowsCount } : { err: r.body?.error?.message || r.body?.error?.code }),\n };\n }\n }\n return jsonResp({ date: yesterday, legend: \"rows: ad=광고계정, cols=매니저\", matrix });\n }\n\n return new Response(\n \"Routes: /auth /callback /status /refresh /accounts /managers /manager /campaigns /yesterday /perf /probe /probeMatrix\",\n { status: 404 },\n );\n}",[195],"2b59512a-559b-44b3-9682-5fbec8ba6669","esmReport.ts","53facbda-6a2b-11f1-b874-1607ee4eb77e",108,["D",1781750311593],7,"/**\n * esmReport.ts v2 (2026-06-17) — ESM 매출 라이브 리포트 (SA 스타일 풍부 디자인)\n *\n * v1 대비 변경:\n * - 네이버 SA 리포트와 같은 풍부한 레이아웃\n * - 통합 + 풍년보감 + 텅스페이스 3개 브랜드 섹션\n * - 각 섹션마다 30일 트렌드 차트 + KPI 카드\n * - 핵심 인사이트 callout\n * - 일별 전체 기록 표\n *\n * HTTP:\n * GET → 전체 HTML 페이지\n * GET ?kpi=1 → JSON KPI (어제 1일치)\n *\n * 데이터: Notion \"ESM 매출 일일 리포트\" DB\n */\n\nconst ESM_NOTION_DB_ID = \"5ed8388163b1468fa24b0e966291fd35\";\n\nfunction dateKST(o: number): string {\n return new Date(Date.now() + o * 86400000).toLocaleDateString(\"sv-SE\", {\n timeZone: \"Asia/Seoul\",\n });\n}\n\nasync function notionQuery(dbId: string, filter: any): Promise {\n const token = Deno.env.get(\"NOTION_TOKEN\")!;\n const all: any[] = [];\n let cursor: string | undefined;\n do {\n const body: any = { filter, page_size: 100 };\n if (cursor) body.start_cursor = cursor;\n const resp = await fetch(\n `https://api.notion.com/v1/databases/${dbId}/query`,\n {\n method: \"POST\",\n headers: {\n \"Authorization\": `Bearer ${token}`,\n \"Notion-Version\": \"2022-06-28\",\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify(body),\n },\n );\n if (!resp.ok) throw new Error(`Notion query ${resp.status}`);\n const data = await resp.json();\n all.push(...(data.results || []));\n cursor = data.has_more ? data.next_cursor : undefined;\n } while (cursor);\n return all;\n}\n\nfunction rowToRecord(row: any) {\n const p = row.properties;\n const n = (k: string) => p[k]?.number ?? 0;\n return {\n date: p[\"분석일\"]?.date?.start || \"\",\n status: p[\"상태\"]?.select?.name || \"정상\",\n insight: (p[\"핵심 인사이트\"]?.rich_text || []).map((t: any) => t.plain_text)\n .join(\"\"),\n pageUrl: row.url,\n pn: { rev: n(\"풍년보감 매출\"), orders: n(\"풍년보감 주문수\") },\n ts: { rev: n(\"텅스페이스 매출\"), orders: n(\"텅스페이스 주문수\") },\n total: { rev: n(\"통합 매출\"), orders: n(\"통합 주문수\") },\n ad: n(\"광고비\"),\n roas: n(\"ROAS (%)\"),\n };\n}\n\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n const targetDate = url.searchParams.get(\"date\") || dateKST(-1);\n const start30 = dateKST(-30);\n\n try {\n const rows = await notionQuery(ESM_NOTION_DB_ID, {\n and: [\n { property: \"분석일\", date: { on_or_after: start30 } },\n { property: \"분석일\", date: { on_or_before: targetDate } },\n ],\n });\n const records = rows.map(rowToRecord).sort((a, b) =>\n a.date.localeCompare(b.date)\n );\n const today = records.find((r) => r.date === targetDate);\n\n // 30일 합계\n const sum30 = records.reduce((s, r) => ({\n rev: s.rev + r.total.rev,\n orders: s.orders + r.total.orders,\n ad: s.ad + r.ad,\n pnRev: s.pnRev + r.pn.rev,\n tsRev: s.tsRev + r.ts.rev,\n pnOrders: s.pnOrders + r.pn.orders,\n tsOrders: s.tsOrders + r.ts.orders,\n }), {\n rev: 0,\n orders: 0,\n ad: 0,\n pnRev: 0,\n tsRev: 0,\n pnOrders: 0,\n tsOrders: 0,\n });\n const totalRoas30 = sum30.ad > 0\n ? Math.round(sum30.rev / sum30.ad * 100)\n : 0;\n const pnRoas30 = sum30.ad > 0 && sum30.pnRev > 0\n ? Math.round(\n sum30.pnRev / (sum30.ad * (sum30.pnRev / Math.max(sum30.rev, 1))) * 100,\n )\n : 0;\n const tsRoas30 = sum30.ad > 0 && sum30.tsRev > 0\n ? Math.round(\n sum30.tsRev / (sum30.ad * (sum30.tsRev / Math.max(sum30.rev, 1))) * 100,\n )\n : 0;\n\n // KPI JSON 모드 (Slack 봇에서 쓰는 경우)\n if (url.searchParams.get(\"kpi\") === \"1\") {\n return Response.json({\n date: targetDate,\n totalRev: today?.total.rev || 0,\n totalOrders: today?.total.orders || 0,\n adSpend: today?.ad || 0,\n roas: today?.roas || 0,\n pn: today?.pn || { rev: 0, orders: 0 },\n ts: today?.ts || { rev: 0, orders: 0 },\n status: today?.status || \"데이터 부족\",\n });\n }\n\n const html = renderHTML({\n targetDate,\n start30,\n records,\n today,\n sum30,\n totalRoas30,\n pnRoas30,\n tsRoas30,\n });\n return new Response(html, {\n headers: {\n \"Content-Type\": \"text/html; charset=utf-8\",\n \"Cache-Control\": \"public, max-age=1800\",\n },\n });\n } catch (err: any) {\n return new Response(\n `

Error

${err.message}\\n${\n        err.stack || \"\"\n      }

`,\n { status: 500, headers: { \"Content-Type\": \"text/html; charset=utf-8\" } },\n );\n }\n}\n\nfunction renderHTML(d: any): string {\n const fmt = (n: number) => \"₩\" + n.toLocaleString(\"ko-KR\");\n const fmtN = (n: number) => n.toLocaleString(\"ko-KR\");\n const esc = (s: string) =>\n String(s).replace(/&/g, \"&\").replace(//g,\n \">\",\n );\n\n const labels = JSON.stringify(d.records.map((r: any) => r.date.slice(5)));\n const dataRev = JSON.stringify(d.records.map((r: any) => r.total.rev));\n const dataAd = JSON.stringify(d.records.map((r: any) => r.ad));\n const dataRoas = JSON.stringify(d.records.map((r: any) => r.roas));\n const dataPnRev = JSON.stringify(d.records.map((r: any) => r.pn.rev));\n const dataTsRev = JSON.stringify(d.records.map((r: any) => r.ts.rev));\n\n const renderBrandSection = (\n brandName: string,\n emoji: string,\n theme: string,\n todayBrand: { rev: number; orders: number } | undefined,\n sumBrand: { rev: number; orders: number },\n trendBrand: number[],\n color: string,\n ) => {\n const brandRoas30 = d.sum30.ad > 0\n ? Math.round(\n (sumBrand.rev / Math.max(d.sum30.rev, 1)) * d.sum30.ad > 0\n ? (sumBrand.rev /\n ((sumBrand.rev / Math.max(d.sum30.rev, 1)) * d.sum30.ad)) * 100\n : 0,\n )\n : 0;\n return `\n

${emoji} ${brandName}

30일 매출

${\n fmt(sumBrand.rev)\n }

30일 주문수

${\n fmtN(sumBrand.orders)\n }건

매출 비중 (30일)

${\n d.sum30.rev > 0 ? ((sumBrand.rev / d.sum30.rev) * 100).toFixed(1) : \"0.0\"\n }%

일평균 매출

${\n fmt(Math.round(sumBrand.rev / Math.max(d.records.length, 1)))\n }

전일 매출

${\n fmt(todayBrand?.rev || 0)\n }

전일 주문수

${\n fmtN(todayBrand?.orders || 0)\n }건

전일 AOV (객단가)

${\n fmt(\n todayBrand && todayBrand.orders > 0\n ? Math.round(todayBrand.rev / todayBrand.orders)\n : 0,\n )\n }

전일 매출 비중

${\n d.today && d.today.total.rev > 0\n ? ((todayBrand?.rev || 0) / d.today.total.rev * 100).toFixed(1)\n : \"0.0\"\n }%

📊 ${brandName} 30일 매출 추이

\n`;\n };\n\n return `\nESM 매출 통합 리포트 — ${d.targetDate}\n\n

분석 기간: ${d.start30} ~ ${d.targetDate} (오늘 제외, 전일까지 30일)

🛒 ESM 매출 통합 리포트

${d.start30} ~ ${d.targetDate}

G마켓 + 옥션 (이베이 코리아) · PNBG 풍년보감 + 텅스페이스 · 일별 매출 자동 집계

\n\n

📦 통합 KPI

30일 총 매출

${\n fmt(d.sum30.rev)\n }

30일 총 주문수

${\n fmtN(d.sum30.orders)\n }건

30일 총 광고비

${\n fmt(d.sum30.ad)\n }

30일 통합 ROAS

${\n d.sum30.ad > 0 ? d.totalRoas30.toLocaleString() + \"%\" : \"-\"\n }

전일 매출

${\n fmt(d.today?.total.rev || 0)\n }

전일 주문수

${\n fmtN(d.today?.total.orders || 0)\n }건

전일 광고비

${\n fmt(d.today?.ad || 0)\n }

전일 ROAS

${\n (d.today?.ad || 0) > 0 ? (d.today?.roas || 0).toLocaleString() + \"%\" : \"-\"\n }

\n\n${\n d.today?.insight\n ? `

💡 전일 핵심 인사이트: ${\n esc(d.today.insight)\n }

`\n : \"\"\n }\n\n

📈 30일 통합 트렌드 (매출 / 광고비 / ROAS)

매출광고비ROAS

\n\n${\n renderBrandSection(\n \"풍년보감\",\n \"🍯\",\n \"theme-pnbg\",\n d.today?.pn,\n { rev: d.sum30.pnRev, orders: d.sum30.pnOrders },\n d.records.map((r: any) => r.pn.rev),\n \"#EF9F27\",\n )\n }\n${\n renderBrandSection(\n \"텅스페이스\",\n \"🫧\",\n \"theme-ts\",\n d.today?.ts,\n { rev: d.sum30.tsRev, orders: d.sum30.tsOrders },\n d.records.map((r: any) => r.ts.rev),\n \"#85B7EB\",\n )\n }\n\n

📋 전체 일별 기록 (최근 30일)

\n\n${\n d.records.slice().reverse().map((r: any) => `\n`).join(\n \"\",\n ) ||\n ``\n }\n

날짜	매출	주문수	광고비	ROAS	풍년 매출	텅스 매출	상세
${r.date}	${fmt(r.total.rev)}	${\n fmtN(r.total.orders)\n }	${r.ad > 0 ? fmt(r.ad) : \"-\"}	${\n r.roas > 0 ? r.roas.toLocaleString() + \"%\" : \"-\"\n }	${fmt(r.pn.rev)}	${\n fmt(r.ts.rev)\n }	노션
데이터 없음

\n\n\n

\n\n`;\n}",[203],"8e1720d0-e960-43fc-8b72-fe0889f2d520","actionPlanSync.ts","293a4162-4eb2-11f1-8fef-ee650bb23af1",87,["D",1780882342257],"/**\n * 액션플랜 슬랙 → 보고서 + 노션 동기화 Cron Val\n *\n * 매 5분마다 실행:\n * 1. #마케팅-data 채널의 봇 메인 메시지 스레드 스캔\n * 2. \"✏️수정 액션플랜:\"으로 시작하는 댓글 감지\n * 3. 본문 추출 후:\n * - val.town blob AI 분석 HTML에 \"수정된 액션플랜\" 섹션 append/replace\n * - 노션 페이지(분석일 기준 매칭)에 수정 섹션 append\n * 4. 처리 완료된 댓글에 ✅ 반응 추가 + ts 기록 (중복 방지)\n *\n * 배포 방법:\n * - val.town New Val → Cron\n * - 이 코드 붙여넣기\n * - Schedule: \"* / 5 * * * *\" (5분 간격) ← 별 슬래시 5 (시스템 표시 회피)\n * - 환경변수: SLACK_BOT_TOKEN, NOTION_TOKEN (기존 사용)\n */\n\nimport { blob } from \"https://esm.town/v/std/blob\";\n\nconst BLOB_NAVER_AI_KEY = \"ai_analysis_latest\";\nconst BLOB_TOSS_AI_KEY = \"toss_ai_analysis_latest\";\nconst BLOB_PROCESSED_KEY = \"action_plan_processed\";\nconst SLACK_CHANNEL_ID = Deno.env.get(\"SLACK_CHANNEL_ID\") || \"C09B0J6QXN1\";\nconst NAVER_NOTION_DB_ID = Deno.env.get(\"NOTION_DB_ID\") || \"5828d1bf-aa95-4662-bdf2-fae160d0654f\";\nconst TOSS_NOTION_DB_ID = Deno.env.get(\"TOSS_NOTION_DB_ID\") || \"5533ea10-a140-4f72-9b93-73ede28b745b\";\n\nconst TRIGGER_BASE = [\n \"✏️수정 액션플랜\",\n \"✏️ 수정 액션플랜\",\n \":pencil2:수정 액션플랜\",\n \":pencil2: 수정 액션플랜\",\n \"수정 액션플랜\",\n];\n\nfunction detectCategory(text: string): \"naver\" | \"toss\" | \"both\" {\n const lower = text.toLowerCase();\n const head = text.slice(0, 80);\n if (/\\[\\s*토스\\s*\\]|\\[\\s*toss\\s*\\]|토스쇼핑|토스 매출/i.test(head)) return \"toss\";\n if (/\\[\\s*네이버\\s*\\]|\\[\\s*naver\\s*\\]|네이버 검색광고|검색광고/i.test(head)) return \"naver\";\n return \"both\";\n}\n\nfunction matchesTrigger(text: string): { match: boolean; prefix: string; category: \"naver\" | \"toss\" | \"both\" } {\n const t = text.trim();\n for (const p of TRIGGER_BASE) {\n if (t.startsWith(p)) {\n return { match: true, prefix: p, category: detectCategory(t) };\n }\n }\n return { match: false, prefix: \"\", category: \"both\" };\n}\n\nfunction escapeHtml(s: string): string {\n return s.replace(/&/g, \"&\").replace(//g, \">\");\n}\n\nasync function slackGet(path: string, token: string): Promise {\n const resp = await fetch(`https://slack.com/api/${path}`, {\n headers: { Authorization: `Bearer ${token}` },\n });\n return resp.json();\n}\n\nasync function slackPost(method: string, body: any, token: string): Promise {\n const resp = await fetch(`https://slack.com/api/${method}`, {\n method: \"POST\",\n headers: {\n Authorization: `Bearer ${token}`,\n \"Content-Type\": \"application/json; charset=utf-8\",\n },\n body: JSON.stringify(body),\n });\n return resp.json();\n}\n\nasync function notionRequest(method: string, path: string, body: any, token: string): Promise {\n const resp = await fetch(`https://api.notion.com/v1${path}`, {\n method,\n headers: {\n Authorization: `Bearer ${token}`,\n \"Notion-Version\": \"2022-06-28\",\n \"Content-Type\": \"application/json\",\n },\n body: body ? JSON.stringify(body) : undefined,\n });\n return resp.json();\n}\n\nexport default async function () {\n const slackToken = Deno.env.get(\"SLACK_BOT_TOKEN\");\n const notionToken = Deno.env.get(\"NOTION_TOKEN\");\n if (!slackToken) { console.log(\"SLACK_BOT_TOKEN missing\"); return; }\n if (!notionToken) { console.log(\"NOTION_TOKEN missing\"); return; }\n\n // 처리한 ts 목록\n let processed: string[] = [];\n try { processed = ((await blob.getJSON(BLOB_PROCESSED_KEY)) as any)?.list || []; } catch (e) {}\n\n // 최근 24시간 채널 메시지\n const since = Math.floor(Date.now() / 1000) - 86400;\n const hist = await slackGet(`conversations.history?channel=${SLACK_CHANNEL_ID}&oldest=${since}&limit=50`, slackToken);\n if (!hist.ok) { console.log(\"history error:\", hist.error); return; }\n\n // 봇이 보낸 메인 메시지 중 스레드 있는 것\n // (메인 메시지는 thread_ts가 자기 ts와 같거나 비어있음. 댓글은 thread_ts가 부모 ts)\n const botMains = (hist.messages || []).filter((m: any) =>\n m.bot_id && (m.reply_count || 0) > 0 && (!m.thread_ts || m.thread_ts === m.ts)\n );\n\n let processedCount = 0;\n for (const main of botMains) {\n const replies = await slackGet(`conversations.replies?channel=${SLACK_CHANNEL_ID}&ts=${main.ts}&limit=100`, slackToken);\n if (!replies.ok) continue;\n\n for (const r of (replies.messages || [])) {\n if (r.ts === main.ts) continue;\n if (processed.includes(r.ts)) continue;\n const text = (r.text || \"\").trim();\n const trig = matchesTrigger(text);\n if (!trig.match) continue;\n\n // 액션플랜 본문 추출 (트리거 prefix 제거)\n const planBody = text.slice(trig.prefix.length).replace(/^[:\\s]+/, \"\").trim();\n if (!planBody) continue;\n\n const nowKST = new Date().toLocaleString(\"ko-KR\", { timeZone: \"Asia/Seoul\" });\n\n // 카테고리에 따른 대상 목록 결정\n const targets: Array<{ name: string; blobKey: string; dbId: string }> = [];\n if (trig.category === \"naver\" || trig.category === \"both\") {\n targets.push({ name: \"네이버\", blobKey: BLOB_NAVER_AI_KEY, dbId: NAVER_NOTION_DB_ID });\n }\n if (trig.category === \"toss\" || trig.category === \"both\") {\n targets.push({ name: \"토스\", blobKey: BLOB_TOSS_AI_KEY, dbId: TOSS_NOTION_DB_ID });\n }\n\n const appliedTo: string[] = [];\n\n for (const target of targets) {\n // 1. val.town blob 업데이트\n try {\n const cur: any = await blob.getJSON(target.blobKey).catch(() => null);\n if (cur && cur.html) {\n const editHtmlBody = planBody.split(\"\\n\").filter(l => l.trim())\n .map(l => `

${escapeHtml(l.trim())}

`).join(\"\");\n const editHtml = `\\n

수정된 액션플랜 (${nowKST} KST)

\\n

${editHtmlBody}`;\n let updated;\n if (cur.html.includes(\"

수정된 액션플랜\")) {\n updated = cur.html.replace(/\\n?

수정된 액션플랜[\\s\\S]*$/, editHtml);\n } else {\n updated = cur.html + editHtml;\n }\n await blob.setJSON(target.blobKey, {\n ...cur, html: updated, lastEditedAt: new Date().toISOString(),\n });\n }\n } catch (e) { console.log(`${target.name} blob update fail:`, e); }\n\n // 2. 노션 페이지 업데이트\n try {\n const mainText = main.text || (main.blocks?.[0]?.text?.text) || \"\";\n const dateMatch = mainText.match(/\$(\\d{4}-\\d{2}-\\d{2})\$/);\n const targetDate = dateMatch ? dateMatch[1]\n : new Date(Date.now() - 86400000).toLocaleDateString(\"sv-SE\", { timeZone: \"Asia/Seoul\" });\n\n const dbResp = await notionRequest(\"POST\", `/databases/${target.dbId}/query`, {\n filter: { property: \"분석일\", date: { equals: targetDate } },\n page_size: 1,\n }, notionToken);\n const pageId = dbResp.results?.[0]?.id;\n\n if (pageId) {\n const lines = planBody.split(\"\\n\").filter(l => l.trim());\n const children: any[] = [\n { object: \"block\", type: \"divider\", divider: {} },\n {\n object: \"block\", type: \"heading_2\",\n heading_2: {\n rich_text: [{ type: \"text\", text: { content: `수정된 액션플랜 (${nowKST} KST)` } }],\n color: \"purple_background\",\n },\n },\n ...lines.map(line => ({\n object: \"block\", type: \"numbered_list_item\",\n numbered_list_item: {\n rich_text: [{ type: \"text\", text: { content: line.trim().slice(0, 1900) } }],\n },\n })),\n ];\n await notionRequest(\"PATCH\", `/blocks/${pageId}/children`, { children }, notionToken);\n appliedTo.push(target.name);\n }\n } catch (e) { console.log(`${target.name} notion update fail:`, e); }\n }\n\n // 3. ✅ 반응 추가 (실패해도 무방)\n try {\n await slackPost(\"reactions.add\", {\n channel: SLACK_CHANNEL_ID, timestamp: r.ts, name: \"white_check_mark\",\n }, slackToken);\n } catch (e) {}\n\n // 4. 봇이 자기 자신에게 스레드 답글로 처리 완료 알림\n try {\n const scope = appliedTo.length > 0 ? appliedTo.join(\" + \") : \"대상 페이지 없음\";\n await slackPost(\"chat.postMessage\", {\n channel: SLACK_CHANNEL_ID,\n thread_ts: main.ts,\n text: `수정 액션플랜 반영 완료 (${nowKST} KST) — ${scope} 보고서/노션 동기화됨`,\n }, slackToken);\n } catch (e) {}\n\n processed.push(r.ts);\n processedCount++;\n }\n }\n\n // 처리 목록 저장 (최근 200개만)\n await blob.setJSON(BLOB_PROCESSED_KEY, { list: processed.slice(-200) });\n console.log(`[OK] 동기화 — ${processedCount}건 처리`);\n return { ok: true, processed: processedCount };\n}",[211],"pulls",1,"branches",2,"forks","envVars",{"_226":228,"_229":60},"connections",{"_226":60,"_227":60},"count","unfilledCount",23,"emptyCount",{"_43":210,"_32":211,"_30":212,"_151":-5,"_41":42,"_40":213,"_153":127,"_38":264,"_13":176,"_33":164,"_35":215,"_24":25,"_157":-5,"_240":265,"_27":266},{"_43":202,"_32":203,"_30":204,"_151":-5,"_41":42,"_40":205,"_153":127,"_38":261,"_13":207,"_33":34,"_35":208,"_24":25,"_157":-5,"_240":262,"_27":263},{"_43":194,"_32":195,"_30":196,"_151":-5,"_41":42,"_40":197,"_153":127,"_38":258,"_13":199,"_33":34,"_35":200,"_24":25,"_157":-5,"_240":259,"_27":260},{"_43":186,"_32":187,"_30":188,"_151":-5,"_41":42,"_40":189,"_153":127,"_38":255,"_13":191,"_33":34,"_35":192,"_24":25,"_157":-5,"_240":256,"_27":257},{"_43":179,"_32":180,"_30":181,"_151":-5,"_41":42,"_40":182,"_153":127,"_38":252,"_13":60,"_33":34,"_35":184,"_24":25,"_157":-5,"_240":253,"_27":254},{"_43":171,"_32":172,"_30":173,"_151":-5,"_41":42,"_40":174,"_153":127,"_38":249,"_13":176,"_33":34,"_35":177,"_24":25,"_157":-5,"_240":250,"_27":251},{"_43":167,"_32":28,"_30":31,"_151":-5,"_41":42,"_40":14,"_153":25,"_38":246,"_13":169,"_33":34,"_35":37,"_24":25,"_157":-5,"_240":247,"_27":248},{"_43":159,"_32":160,"_30":161,"_151":-5,"_41":42,"_40":162,"_153":127,"_38":243,"_13":155,"_33":164,"_35":165,"_24":25,"_157":-5,"_240":244,"_27":245},{"_43":148,"_32":149,"_30":150,"_151":-5,"_41":42,"_40":152,"_153":127,"_38":239,"_13":155,"_33":34,"_35":156,"_24":25,"_157":-5,"_240":241,"_27":242},["D",1779266304839],"children",[],[149],["D",1780882333054],[],[160],["D",1781750584664],[],[28],["D",1778469067627],[],[172],["D",1778722859031],[],[180],["D",1778670242462],[],[187],["D",1779271489093],[],[195],["D",1781750311593],[],[203],["D",1780882342257],[],[211],["D",1778465580996],["D",1789491713377],{"_99":98,"_107":103},{"_99":98,"_100":101,"_102":103,"_18":54,"_104":105,"_106":25},{"_13":86,"_32":87,"_43":42,"_88":44,"_89":90,"_91":92,"_93":50,"_94":44,"_95":62,"_96":45,"_97":98},"ctx",{"_79":-5,"_129":305,"_306":307,"_308":309,"_310":25,"_311":25,"_312":25,"_313":127,"_314":-5,"_315":-7,"_316":-7,"_317":60,"_318":25,"_319":25,"_320":-5,"_321":25,"_322":25,"_323":25,"_324":-5},"ENV",{"_276":277,"_278":279,"_280":135,"_281":282,"_283":284,"_285":286,"_287":288,"_289":290,"_291":292,"_293":294,"_295":296,"_297":298,"_299":300,"_301":302,"_303":304},"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"]

([\\s\\S]*?)<\\/h3>([\\s\\S]*?)(?=

Error

🔌 GFA 데이터 대기 중

🔍 키워드 데이터 없음

📊 광고비 TOP 10

⭐ ROAS TOP 10 (최소 광고비 500원)

⚠️ 비효율 키워드 (광고비 1000원↑ / 매출 0)

${emoji} ${brand}

SA 효율 분석

⭐ ROAS TOP 5 캠페인

⚠️ 비효율 캠페인

SA 일별 분석 (30일)

SA 키워드 분석

DA 디스플레이 (GFA)

📋 ${brand} 전체 캠페인 (전일)

🤖 AI 자동 분석 & 액션플랜

🤖 AI 자동 분석

전체 통합 KPI

📊 브랜드별 30일 비교

([\\s\\S]*?)<\\/h3>([\\s\\S]*?)(?=

Error

📡 SA 캠페인유형별 데이터 대기 중

캠페인유형별 (4종)

🔍 키워드 데이터 없음

📊 광고비 TOP 10

⭐ ROAS TOP 10 (최소 광고비 500원)

⚠️ 비효율 키워드 (광고비 1000원↑ / 매출 0)

${emoji} ${brand}

SA 효율 분석

⭐ ROAS TOP 5 캠페인

⚠️ 비효율 캠페인

SA 일별 분석 (30일)

SA 키워드 분석

SA 캠페인유형별 상세

📋 ${brand} 전체 캠페인 (전일)

🤖 AI 자동 분석 & 액션플랜

🤖 AI 자동 분석

전체 통합 KPI

📊 브랜드별 30일 비교

([\\s\\S]*?)<\\/h3>([\\s\\S]*?)(?=

토스 리포트 오류

${emoji} ${brand}

일별 추이 (30일)

토스쇼핑 AI 분석 & 액션플랜

토스쇼핑 AI 분석

전체 통합 KPI

상품 매출 TOP 10 (30일)

${sectionTitle}

핵심 인사이트<\\/h3>\\s*([\\s\\S]*?)<\\/p>/;\n const m = html.match(re);\n return m ? stripTags(m[1]) : \"\";\n}\n\nfunction extractFollowup(html: string): string {\n const re = /

어제 권장 액션 후속 추적<\\/h3>([\\s\\S]*?)(?=

❌ Env vars 누락

❌ ${err}

❌ Token exchange failed

✅ GFA OAuth 인증 완료

❌ 저장된 토큰 없음

✅ 토큰 저장됨

Error

${emoji} ${brandName}

📊 ${brandName} 30일 매출 추이

📦 통합 KPI

📈 30일 통합 트렌드 (매출 / 광고비 / ROAS)

📋 전체 일별 기록 (최근 30일)

수정된 액션플랜 (${nowKST} KST)

수정된 액션플랜\")) {\n updated = cur.html.replace(/\\n?

([\\s\\S]?)<\\/h3>([\\s\\S]?)(?=

([\\s\\S]?)<\\/h3>([\\s\\S]?)(?=

([\\s\\S]?)<\\/h3>([\\s\\S]?)(?=

핵심 인사이트<\\/h3>\\s*
([\\s\\S]*?)<\\/p>/;\n const m = html.match(re);\n return m ? stripTags(m[1]) : \"\";\n}\n\nfunction extractFollowup(html: string): string {\n const re = /

Diff · v109