[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_210":211,"_212":213},"routes/_app.x.$handle.$name",{"_100":99,"_33":46,"_109":88,"_27":110,"_13":14,"_111":-5,"_11":112,"_113":114,"_115":116,"_117":118,"_119":120,"_20":-5,"_121":-5,"_122":123,"_124":25,"_125":126,"_127":128,"_129":-5,"_130":-5,"_131":132},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_44":45,"_33":46,"_39":47,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":-5,"_54":-5,"_18":55,"_56":-5,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":81,"_82":83,"_84":85,"_86":25},"version",42,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":30},"file",{"_31":32,"_33":28,"_34":35,"_36":38,"_39":40,"_41":14,"_42":43,"_24":25},"previous",{"_31":32,"_33":28,"_34":35,"_36":37},"deleted",false,"deletedHere","path","new-file-4762.ts","latestPath","actionPlanSync.ts","fileId","293a4162-4eb2-11f1-8fef-ee650bb23af1","name","fileType","interval","content","// Learn more: https://docs.val.town/vals/cron/\nexport default async function (interval: Interval) {\n console.log(interval);\n}","/**\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_AI_KEY = \"ai_analysis_latest\";\nconst BLOB_PROCESSED_KEY = \"action_plan_processed\";\nconst SLACK_CHANNEL_ID = Deno.env.get(\"SLACK_CHANNEL_ID\") || \"C09B0J6QXN1\";\nconst NOTION_DB_ID = Deno.env.get(\"NOTION_DB_ID\") ||\n \"5828d1bf-aa95-4662-bdf2-fae160d0654f\";\nconst TRIGGER_PREFIX = \"✏️수정 액션플랜\";\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(\n method: string,\n body: any,\n token: string,\n): 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(\n method: string,\n path: string,\n body: any,\n token: string,\n): 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) {\n console.log(\"SLACK_BOT_TOKEN missing\");\n return;\n }\n if (!notionToken) {\n console.log(\"NOTION_TOKEN missing\");\n return;\n }\n\n // 처리한 ts 목록\n let processed: string[] = [];\n try {\n processed = ((await blob.getJSON(BLOB_PROCESSED_KEY)) as any)?.list || [];\n } catch (e) {}\n\n // 최근 24시간 채널 메시지\n const since = Math.floor(Date.now() / 1000) - 86400;\n const hist = await slackGet(\n `conversations.history?channel=${SLACK_CHANNEL_ID}&oldest=${since}&limit=50`,\n slackToken,\n );\n if (!hist.ok) {\n console.log(\"history error:\", hist.error);\n return;\n }\n\n // 봇이 보낸 메인 메시지 중 스레드 있는 것\n const botMains = (hist.messages || []).filter((m: any) =>\n m.bot_id && !m.thread_ts && (m.reply_count || 0) > 0\n );\n\n let processedCount = 0;\n for (const main of botMains) {\n const replies = await slackGet(\n `conversations.replies?channel=${SLACK_CHANNEL_ID}&ts=${main.ts}&limit=100`,\n slackToken,\n );\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 if (!text.startsWith(TRIGGER_PREFIX)) continue;\n\n // 액션플랜 본문 추출\n const planBody = text.replace(TRIGGER_PREFIX, \"\").replace(/^[:\\s]+/, \"\")\n .trim();\n if (!planBody) continue;\n\n const nowKST = new Date().toLocaleString(\"ko-KR\", {\n timeZone: \"Asia/Seoul\",\n });\n\n // 1. val.town blob 업데이트 (AI HTML에 수정 섹션 append/replace)\n try {\n const cur: any = await blob.getJSON(BLOB_AI_KEY).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 `\\n

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

\\n

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

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

수정된 액션플랜[\\s\\S]*$/,\n editHtml,\n );\n } else {\n updated = cur.html + editHtml;\n }\n await blob.setJSON(BLOB_AI_KEY, {\n ...cur,\n html: updated,\n lastEditedAt: new Date().toISOString(),\n });\n }\n } catch (e) {\n console.log(\"blob update fail:\", e);\n }\n\n // 2. 노션 페이지 업데이트 — main 메시지가 가리키는 분석일 페이지 찾기\n try {\n // 메인 메시지 텍스트에서 날짜 추출 (\"어제 (2026-05-12)\")\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\n ? dateMatch[1]\n : new Date(Date.now() - 86400000).toLocaleDateString(\"sv-SE\", {\n timeZone: \"Asia/Seoul\",\n });\n\n const dbResp = await notionRequest(\n \"POST\",\n `/databases/${NOTION_DB_ID}/query`,\n {\n filter: { property: \"분석일\", date: { equals: targetDate } },\n page_size: 1,\n },\n notionToken,\n );\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 {\n object: \"block\",\n type: \"divider\",\n divider: {},\n },\n {\n object: \"block\",\n type: \"heading_2\",\n heading_2: {\n rich_text: [{\n type: \"text\",\n text: { content: `수정된 액션플랜 (${nowKST} KST)` },\n }],\n color: \"purple_background\",\n },\n },\n ...lines.map((line) => ({\n object: \"block\",\n type: \"numbered_list_item\",\n numbered_list_item: {\n rich_text: [{\n type: \"text\",\n text: { content: line.trim().slice(0, 1900) },\n }],\n },\n })),\n ];\n await notionRequest(\"PATCH\", `/blocks/${pageId}/children`, {\n children,\n }, notionToken);\n }\n } catch (e) {\n console.log(\"notion update fail:\", e);\n }\n\n // 3. ✅ 반응 추가 (실패해도 무방)\n try {\n await slackPost(\"reactions.add\", {\n channel: SLACK_CHANNEL_ID,\n timestamp: r.ts,\n name: \"white_check_mark\",\n }, slackToken);\n } catch (e) {}\n\n // 4. 봇이 자기 자신에게 스레드 답글로 처리 완료 알림\n try {\n await slackPost(\"chat.postMessage\", {\n channel: SLACK_CHANNEL_ID,\n thread_ts: main.ts,\n text:\n `수정 액션플랜 반영 완료 (${nowKST} KST) — 보고서 + 노션 동기화됨`,\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}","createdAt",["D",1778666407660],"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",{"_100":99,"_108":104},"org",{"_100":99,"_101":102,"_103":104,"_18":55,"_105":106,"_107":25},"branch",{"_13":87,"_33":88,"_44":43,"_89":45,"_90":91,"_92":93,"_94":51,"_95":45,"_96":63,"_97":46,"_98":99},"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",{"_44":45,"_33":46,"_39":205,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":-5,"_54":-5,"_18":55,"_56":-5,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":206,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":207,"_82":208,"_84":209,"_86":25},"tree",[188,189,190,191],"files",[188,189,190,191],"counts",{"_175":176,"_177":178,"_179":61,"_180":181,"_182":183},"contents",[140,141,142,143],"upstreamProject","upstreamBranch",{"_44":91,"_39":133,"_134":135,"_33":136,"_89":45,"_13":137,"_90":-5,"_92":-5,"_138":139,"_48":-5,"_86":25,"_50":51,"_98":99,"_62":63,"_97":46},"emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},["D",1778465581010],"updatedAt",["D",1782110067926],"main",134,"lockfileKey","1782110068005-esm.town_v_joowoo_Marketingauto@134-main",{"_44":167,"_33":168,"_31":169,"_147":-5,"_42":43,"_41":170,"_149":128,"_39":171,"_13":172,"_34":151,"_36":173,"_24":25,"_153":-5,"_27":174},{"_44":159,"_33":160,"_31":161,"_147":-5,"_42":43,"_41":162,"_149":25,"_39":163,"_13":164,"_34":151,"_36":165,"_24":25,"_153":-5,"_27":166},{"_44":155,"_33":28,"_31":32,"_147":-5,"_42":43,"_41":14,"_149":25,"_39":156,"_13":157,"_34":35,"_36":38,"_24":25,"_153":-5,"_27":158},{"_44":144,"_33":145,"_31":146,"_147":-5,"_42":43,"_41":148,"_149":25,"_39":150,"_13":93,"_34":151,"_36":152,"_24":25,"_153":-5,"_27":154},"1b604898-4eb2-11f1-9932-ee650bb23af1","slackDailyCron.ts","3f665720-4eb0-11f1-af25-ee650bb23af1","parentId",38,"latest",["D",1778666229517],"http","/**\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 = [\n \"텅스\",\n \"곤약\",\n \"쫀드기\",\n \"쫀디기\",\n \"쫀뜨기\",\n \"스파이크샷\",\n];\nconst NOTION_DB_DEFAULT = \"5828d1bf-aa95-4662-bdf2-fae160d0654f\";\nconst REPORT_URL =\n \"https://joowoo--f970e0684cf811f1801eee650bb23af1.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\") ||\n \"S09PHRXUR0W\";\n\nfunction classifyBrand(name: string): \"풍년보감\" | \"텅스페이스\" {\n for (const kw of TONGSPACE_KEYWORDS) {\n if (name.includes(kw)) return \"텅스페이스\";\n }\n return \"풍년보감\";\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\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}\n\nfunction fmt(n: number): string {\n return n.toLocaleString(\"ko-KR\") + \"원\";\n}\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}\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}\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 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[\"풍년보감\"];\n const ts = kpi[\"텅스페이스\"];\n const total = {\n spend: pn.spend + ts.spend,\n rev: pn.rev + ts.rev,\n conv: pn.conv + ts.conv,\n };\n return {\n pn,\n ts,\n 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(\n html: string,\n sectionTitle: string,\n max: number = 3,\n): 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;\n let isFirst = true;\n while ((rm = rowRe.exec(content)) !== null) {\n if (isFirst) {\n isFirst = false;\n continue;\n } // 헤더 행 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(\n targetDate: 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) 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 return data.results?.[0]?.url || null;\n } catch (e) {\n return null;\n }\n}\n\nasync function slackPost(\n method: string,\n body: any,\n token: string,\n): 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 {\n aiAnalysis = await blob.getJSON(BLOB_AI_KEY);\n } catch (e) {}\n const aiHtml = aiAnalysis?.html || \"\";\n\n // 2. 어제 KPI 페치\n const k = await fetchYesterdayKPI(yesterday);\n\n // 3. 노션 페이지 URL 찾기\n const notionUrl = await findYesterdayNotionPage(yesterday) ||\n \"https://www.notion.so/\" +\n (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\n ? signals\n : (insight\n ? [insight]\n : [\"AI 분석 데이터 없음 — 오늘 07:30 정기 실행 후 적재 예정\"]);\n const top3 = extractSectionItems(aiHtml, \"오늘 즉시 실행 우선순위\", 3);\n const top3Final = top3.length > 0\n ? top3\n : [\"AI 분석 미작성 — 데이터 확인 후 수동 액션 검토 필요\"];\n const followup = extractFollowup(aiHtml);\n\n // 5. 메인 메시지 발송\n const mainText =\n ` 좋은 아침! 어제 (${yesterday}) 네이버 검색광고 리포트가 준비됐어요.\\n\\nPNBG 풍년보감 + 텅스페이스 검색광고 성과를 한눈에 확인하세요.\\n\\n<${REPORT_URL}|리포트 열기> · <${notionUrl}|노션 페이지>`;\n\n const mainResp = await slackPost(\"chat.postMessage\", {\n channel: SLACK_CHANNEL_ID,\n text: mainText,\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: [{\n type: \"text\",\n text,\n ...(bold ? { style: { bold: true } } : {}),\n }],\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\",\n );\n const top3Block = `*오늘 실행 TOP 3*\\n` +\n top3Final.slice(0, 3).map((s, i) => `${i + 1}. ${s.slice(0, 250)}`).join(\n \"\\n\",\n );\n const followupBlock = `*어제 집행률*\\n${followup.slice(0, 300)}`;\n\n const blocks = [\n {\n type: \"section\",\n text: { type: \"mrkdwn\", text: `*요약 KPI (${yesterday})*` },\n },\n {\n type: \"table\",\n rows: [\n [\n cell(\"구분\", true),\n cell(\"광고비\", true),\n cell(\"매출\", true),\n cell(\"ROAS\", true),\n ],\n [\n cell(\"통합\"),\n cell(fmt(k.total.spend)),\n cell(fmt(k.total.rev)),\n cell(`${k.totalRoas.toLocaleString()}%`),\n ],\n [\n cell(\"풍년보감\"),\n cell(fmt(k.pn.spend)),\n cell(fmt(k.pn.rev)),\n cell(`${k.pnRoas.toLocaleString()}%`),\n ],\n [\n cell(\"텅스페이스\"),\n cell(fmt(k.ts.spend)),\n cell(fmt(k.ts.rev)),\n cell(`${k.tsRoas.toLocaleString()}%`),\n ],\n ],\n },\n { type: \"divider\" },\n { type: \"section\", text: { type: \"mrkdwn\", text: signalsBlock } },\n { type: \"section\", text: { type: \"mrkdwn\", text: top3Block } },\n { type: \"section\", text: { type: \"mrkdwn\", text: followupBlock } },\n {\n type: \"context\",\n elements: [{\n type: \"mrkdwn\",\n text:\n \"_액션플랜을 수정하시려면 이 스레드에 *✏️수정 액션플랜:* 으로 시작하는 댓글을 작성하세요. 5분 내 보고서와 노션에 자동 반영됩니다._\",\n }],\n },\n ];\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(\n `[OK] Slack 발송 완료 — ${yesterday} | main_ts=${threadTs} | notion=${notionUrl}`,\n );\n return { ok: true, date: yesterday, mainTs: threadTs, notionUrl };\n}","label",[145],"858a6096-4eb2-11f1-a84a-ee650bb23af1",["D",1778666407660],3,[28],"3edc7c80-4eb0-11f1-8310-ee650bb23af1","naverSAReport.ts","f970e068-4cf8-11f1-801e-ee650bb23af1",31,["D",1778665430080],15,"/**\n * 네이버 마케팅 통합 리포트 v7 — 30일 트렌드 + 데일리 액션\n *\n * v6 대비 변경:\n * - 트렌드 윈도우 7일 → 30일 (오늘 제외, 전일까지)\n * - KPI 카드: 7일/30일 둘 다 표시\n * - 차트: 30일 일별 라인 그래프\n * - AI 분석은 30일 데이터 기반, 액션은 데일리(즉시 실행 가능)\n *\n * 환경변수:\n * - NAVER_SA_API_KEY, NAVER_SA_SECRET_KEY, NAVER_SA_CUSTOMER_ID (기존)\n * - WORKER_KEY (기존)\n * - NOTION_TOKEN, NOTION_DB_ID (기존)\n *\n * 사용법:\n * GET → 풀 리포트 (AI 분석 + 30일 데이터)\n * POST ?key=WORKER_KEY (body: JSON {html, date, summary}) → blob 저장 + 노션 페이지 생성\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 = [\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 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,\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}\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}\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 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\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}\n\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}\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\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\n // h4\n const h4Re = /

([\\s\\S]*?)<\\/h4>/g;\n const h4Set = new Set();\n let h4m;\n while ((h4m = h4Re.exec(content)) !== null) {\n h4Set.add(h4m.index);\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\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\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\n // 표 → 단락으로 (노션 table 블록은 children 구조가 복잡하므로 간단히 텍스트화)\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\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\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 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\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}\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}\n\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n\n // ━━━ POST: AI 분석 저장 + 노션 페이지 생성 ━━━\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\n // 1. blob 저장 (이전 동작)\n await blob.setJSON(BLOB_AI_KEY, {\n html,\n date: targetDate,\n summary,\n savedAt: new Date().toISOString(),\n });\n\n // 2. 노션 페이지 생성 (실패해도 blob은 이미 저장됨)\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\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\n // ━━━ GET: 풀 리포트 ━━━\n const targetDate = url.searchParams.get(\"date\") || dateKST(-1);\n\n try {\n // 1. 캠페인 + 브랜드\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\n // 2. 어제 stats\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\n // 3. 30일 트렌드 (오늘 제외, 전일까지 30일: -30 ~ -1)\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\n // 4. 캠페인 데이터\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\n // 5. 키워드\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\n // 6. 집계\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\n // 7. AI 분석 가져오기 (blob에서)\n let aiAnalysis: any = null;\n try {\n aiAnalysis = await blob.getJSON(BLOB_AI_KEY);\n } catch (e) { /* no analysis */ }\n\n const html = renderHTML({\n targetDate,\n trendByBrand,\n rowsByBrand,\n summary,\n overall,\n keywordsByBrand,\n aiAnalysis,\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 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\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\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\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\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)

🔌 GFA API 연동 대기 중

대행사 통해 자격증명 수신 후 즉시 통합.

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

\n${allRows}

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

\n`;\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\n // AI 분석 섹션 렌더링\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\n return `\n네이버 마케팅 통합 리포트 — ${d.targetDate}\n\n

\n\n

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

네이버 마케팅 통합 리포트

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

PNBG · 풍년보감 + 텅스페이스 · AI 분석 + 효율/일별/키워드

\n\n

전체 통합 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}건

\n\n

📊 브랜드별 30일 비교

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

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

\n\n`;\n}",[160],"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}",[168],"pulls",1,"branches",2,"forks","envVars",{"_184":186,"_187":61},"connections",{"_184":61,"_185":61},"count","unfilledCount",23,"emptyCount",{"_44":167,"_33":168,"_31":169,"_147":-5,"_42":43,"_41":170,"_149":128,"_39":202,"_13":172,"_34":151,"_36":173,"_24":25,"_153":-5,"_193":203,"_27":204},{"_44":159,"_33":160,"_31":161,"_147":-5,"_42":43,"_41":162,"_149":25,"_39":199,"_13":164,"_34":151,"_36":165,"_24":25,"_153":-5,"_193":200,"_27":201},{"_44":155,"_33":28,"_31":32,"_147":-5,"_42":43,"_41":14,"_149":25,"_39":196,"_13":157,"_34":35,"_36":38,"_24":25,"_153":-5,"_193":197,"_27":198},{"_44":144,"_33":145,"_31":146,"_147":-5,"_42":43,"_41":148,"_149":25,"_39":192,"_13":93,"_34":151,"_36":152,"_24":25,"_153":-5,"_193":194,"_27":195},["D",1778666229517],"children",[],[145],["D",1778666407660],[],[28],["D",1778665430080],[],[160],["D",1778469067627],[],[168],["D",1778465580996],["D",1789491713377],{"_100":99,"_108":104},{"_100":99,"_101":102,"_103":104,"_18":55,"_105":106,"_107":25},{"_13":87,"_33":88,"_44":43,"_89":45,"_90":91,"_92":93,"_94":51,"_95":45,"_96":63,"_97":46,"_98":99},"ctx",{"_80":-5,"_130":243,"_244":245,"_246":247,"_248":25,"_249":25,"_250":25,"_251":128,"_252":-5,"_253":-7,"_254":-7,"_255":61,"_256":25,"_257":25,"_258":-5,"_259":25,"_260":25,"_261":25,"_262":-5},"ENV",{"_214":215,"_216":217,"_218":136,"_219":220,"_221":222,"_223":224,"_225":226,"_227":228,"_229":230,"_231":232,"_233":234,"_235":236,"_237":238,"_239":240,"_241":242},"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"]

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

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

${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]*?)(?=

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

Error

🔍 키워드 데이터 없음

📊 광고비 TOP 10

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

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

${emoji} ${brand}

SA 효율 분석

⭐ ROAS TOP 5 캠페인

⚠️ 비효율 캠페인

SA 일별 분석 (30일)

SA 키워드 분석

DA 디스플레이 (GFA)

🔌 GFA API 연동 대기 중

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

🤖 AI 자동 분석 & 액션플랜

🤖 AI 자동 분석

전체 통합 KPI

📊 브랜드별 30일 비교

핵심 인사이트<\\/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 = /

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

Diff · v42