[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_195":196,"_197":198},"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",23,"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 * 네이버 마케팅 통합 리포트 v3 — 브랜드 분리 (풍년보감 / 텅스페이스)\n *\n * 새로운 기능:\n * - 브랜드 자동 분류 (캠페인명 키워드 매칭)\n * - 브랜드별 SA 효율 분석 (ROAS / CTR / CPC)\n * - 브랜드별 일별 분석 (7일 트렌드)\n * - 매출 분리 표시\n * - DA 섹션 (GFA API 대기)\n *\n * 환경변수: NAVER_SA_API_KEY, NAVER_SA_SECRET_KEY, NAVER_SA_CUSTOMER_ID\n */\n\nconst API_BASE = \"https://api.searchad.naver.com\";\n\n// 텅스페이스 브랜드 키워드 (이 중 하나라도 캠페인명에 포함되면 텅스페이스)\nconst TONGSPACE_KEYWORDS = [\n \"텅스\",\n \"곤약\",\n \"쫀드기\",\n \"쫀디기\",\n \"쫀뜨기\",\n \"스파이크샷\",\n];\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} ${await res.text()}`);\n return res.json();\n}\n\nfunction dateInKST(daysOffset: number): string {\n const d = new Date(Date.now() + daysOffset * 86400000);\n return d.toLocaleDateString(\"sv-SE\", { timeZone: \"Asia/Seoul\" });\n}\n\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n const targetDate = url.searchParams.get(\"date\") || dateInKST(-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. 어제 캠페인별 통계\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. 7일 일별 트렌드 (브랜드별 분리 안 됨 → 추후 별도 조회 필요)\n const trendByBrand: Record = {\n \"풍년보감\": [],\n \"텅스페이스\": [],\n };\n for (let i = -6; i <= 0; i++) {\n const d = dateInKST(i);\n const dayStats = await callNaver(\"/stats\", {\n ids,\n fields: '[\"impCnt\",\"clkCnt\",\"salesAmt\",\"ccnt\",\"convAmt\"]',\n timeRange: JSON.stringify({ since: d, until: d }),\n });\n // 브랜드별 합계\n const byBrand: 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 (dayStats?.data || [])) {\n const c = cmap.get(s.id);\n if (!c) continue;\n const b = byBrand[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(byBrand[\"풍년보감\"]);\n trendByBrand[\"텅스페이스\"].push(byBrand[\"텅스페이스\"]);\n }\n\n // 4. 어제 캠페인별 데이터 가공 + 브랜드별 그룹화\n const rowsByBrand: Record = {\n \"풍년보감\": [],\n \"텅스페이스\": [],\n };\n for (const s of (yStats?.data || [])) {\n const c = cmap.get(s.id);\n if (!c) continue;\n rowsByBrand[c.brand].push({\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 }\n\n // 정렬\n for (const b of [\"풍년보감\", \"텅스페이스\"]) {\n rowsByBrand[b].sort((a: any, b: any) => b.spend - a.spend);\n }\n\n // 5. 브랜드별 집계\n const summary: Record = {};\n for (const b of [\"풍년보감\", \"텅스페이스\"]) {\n const rows = rowsByBrand[b];\n const trend = trendByBrand[b];\n summary[b] = {\n // 전일\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 // 7일\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 activeCampaigns: rows.filter((r: any) =>\n r.spend > 0 || r.imp > 0\n ).length,\n totalCampaigns: rows.length,\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\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.ySpend) * 100)\n : 0;\n overall.tRoas = overall.tSpend > 0\n ? Math.round((overall.tRev / overall.tSpend) * 100)\n : 0;\n\n const html = renderHTML({\n targetDate,\n trendByBrand,\n rowsByBrand,\n summary,\n overall,\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 { 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 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\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()}%

`).join(\"\");\n\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원

`).join(\"\");\n\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\n const allRows = rows.map((r: any, i: number) => `\n ${i + 1}${esc(r.name)}${r.tp}${\n fmt(r.spend)\n }${fmtN(r.clk)}${r.conv}${fmt(r.rev)}${\n r.roas > 0 ? r.roas.toLocaleString() + \"%\" : \"-\"\n }`).join(\"\") ||\n `전일 활성 캠페인 없음`;\n\n return `\n

${emoji} ${brand}

\n\n

7일 광고비

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

7일 매출

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

7일 ROAS

${s.tRoas.toLocaleString()}%

7일 전환

${s.tConv}건

\n\n

전일 광고비

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

전일 매출

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

전일 ROAS

${s.yRoas.toLocaleString()}%

전일 전환

${s.yConv}건

\n\n

SA 효율 분석

\n${\n top5HTML\n ? `

⭐ ROAS TOP 5 캠페인

${top5HTML}`\n : '

전환된 캠페인이 없습니다

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

⚠️ 비효율 캠페인 (광고비 쓰지만 매출 0)

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

SA 일별 분석 (7일)

\n광고비\n매출\nROAS\n

\n${trendRows}

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

\n\n

SA 키워드 분석

🔍 키워드 레벨 분석 (Phase 2 예정)

캠페인별 키워드 성과 분석은 추가 API 호출이 필요해서 다음 단계로 분리했어요.

현재는 캠페인 레벨 데이터까지만 표시. 키워드 레벨 추가 시 응답 시간이 길어져 캐싱 전략과 함께 별도 작업 예정입니다.

\n\n

DA 디스플레이 (GFA)

🔌 GFA API 연동 대기 중

대행사 통해 GFA API 자격증명 수신 대기 중. 받으면 자동으로 이 섹션에 ${brand} DA 데이터 자동 통합 예정.

\n\n

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

\n${allRows}

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

\n\n

\n\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 return `\n네이버 마케팅 통합 리포트 — ${d.targetDate}\n

\n\n

기준일: ${d.targetDate} (전일) · 7일 트렌드

네이버 마케팅 통합 리포트

PNBG · 풍년보감 + 텅스페이스 통합 분석

\n\n

전체 통합 KPI

\n\n

7일 총 광고비

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

7일 총 매출

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

7일 통합 ROAS

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

7일 총 전환

${d.overall.tConv}건

\n\n

전일 광고비

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

전일 매출

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

전일 ROAS

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

전일 전환

${d.overall.yConv}건

\n\n

📊 브랜드별 7일 비교

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

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

\n\n\n`;\n}","/**\n * 네이버 마케팅 통합 리포트 v4 — 브랜드 분리 + 키워드 분석 추가\n *\n * v3 대비 신규:\n * - 키워드 레벨 분석 (TOP 10 by spend, TOP 10 by ROAS, BOTTOM 5)\n * - 파워링크/브랜드검색 캠페인만 키워드 보유 (쇼핑검색은 상품 기반)\n *\n * 환경변수: NAVER_SA_API_KEY, NAVER_SA_SECRET_KEY, NAVER_SA_CUSTOMER_ID\n */\n\nconst API_BASE = \"https://api.searchad.naver.com\";\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; // /stats 한 번에 처리할 ID 수\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\n// 키워드 분석용: 한 캠페인의 모든 키워드 + 어제 stats 가져오기\nasync function fetchCampaignKeywords(\n campaignId: string,\n targetDate: string,\n): Promise {\n // 1. adgroups\n const adgroups = await callNaver(\"/ncc/adgroups\", {\n nccCampaignId: campaignId,\n });\n if (!Array.isArray(adgroups) || adgroups.length === 0) return [];\n\n // 2. 각 adgroup의 keywords (병렬)\n const keywordsArrs = await Promise.all(\n adgroups.map((ag: any) =>\n callNaver(\"/ncc/keywords\", { nccAdgroupId: ag.nccAdgroupId })\n ),\n );\n const allKeywords: any[] = [];\n for (const arr of keywordsArrs) {\n if (Array.isArray(arr)) allKeywords.push(...arr);\n }\n if (allKeywords.length === 0) return [];\n\n // 3. /stats 배치 호출 (100개씩)\n const statsMap = new Map();\n for (let i = 0; i < allKeywords.length; i += STATS_BATCH_SIZE) {\n const batch = allKeywords.slice(i, i + STATS_BATCH_SIZE);\n const batchIds = batch.map((k) => k.nccKeywordId).join(\",\");\n try {\n const statsRes = await callNaver(\"/stats\", {\n ids: batchIds,\n fields: '[\"impCnt\",\"clkCnt\",\"salesAmt\",\"ccnt\",\"ctr\",\"cpc\",\"convAmt\"]',\n timeRange: JSON.stringify({ since: targetDate, until: targetDate }),\n });\n for (const s of (statsRes?.data || [])) {\n statsMap.set(s.id, s);\n }\n } catch (e) {\n // 일부 배치 실패 무시\n }\n }\n\n // 4. keyword + stats 병합 (stats가 있는 키워드만)\n return allKeywords\n .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 bidAmt: k.bidAmt || 0,\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 })\n .filter(Boolean);\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\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. 어제 캠페인별 통계\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. 7일 일별 트렌드 (브랜드별)\n const trendByBrand: Record = {\n \"풍년보감\": [],\n \"텅스페이스\": [],\n };\n for (let i = -6; i <= 0; 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 activeKeywordCampaigns: 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 // 키워드 분석 가능한 캠페인만 수집 (활성+키워드 보유 가능 유형)\n if (\n KEYWORD_CAMPAIGN_TYPES.includes(c.campaignTp) &&\n (row.spend > 0 || row.imp > 0)\n ) {\n activeKeywordCampaigns[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 campIds = activeKeywordCampaigns[brand];\n // 병렬로 모든 캠페인 키워드 가져오기\n const results = await Promise.all(\n campIds.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 kwCount: keywordsByBrand[b].length,\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 const html = renderHTML({\n targetDate,\n trendByBrand,\n rowsByBrand,\n summary,\n overall,\n keywordsByBrand,\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 }\n // TOP 10 by spend\n const topSpend = [...kws].sort((a, b) => b.spend - a.spend).slice(0, 10);\n // TOP 10 by ROAS (min spend 500원)\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 // BOTTOM 5: 광고비 많은데 전환 0\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[], showRoas = true) => `\n${\n showRoas ? \"\" : \"\"\n }\n${\n rows.map((k) =>\n `${\n showRoas\n ? ``\n : \"\"\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}	${fmt(k.rev)}	${\n k.roas > 0 ? k.roas.toLocaleString() + \"%\" : \"-\"\n }

`;\n\n return `\n

📊 광고비 TOP 10 (어제)

\n${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\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()}%

`).join(\"\");\n\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원

${emoji} ${brand}

\n\n

7일 광고비

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

7일 매출

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

7일 ROAS

${s.tRoas.toLocaleString()}%

7일 전환

${s.tConv}건

\n\n

전일 광고비

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

전일 매출

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

전일 ROAS

${s.yRoas.toLocaleString()}%

전일 전환

${s.yConv}건

\n\n

SA 효율 분석

\n${\n top5HTML\n ? `

⭐ ROAS TOP 5 캠페인

${top5HTML}`\n : '

전환된 캠페인이 없습니다

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

⚠️ 비효율 캠페인 (광고비 쓰지만 매출 0)

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

SA 일별 분석 (7일)

\n광고비\n매출\nROAS\n

\n${trendRows}

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

\n\n

SA 키워드 분석

\n${renderKeywordsSection(brand)}\n\n

DA 디스플레이 (GFA)

🔌 GFA API 연동 대기 중

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

\n\n

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

\n${allRows}

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

\n\n

기준일: ${d.targetDate} (전일) · 7일 트렌드

네이버 마케팅 통합 리포트

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

\n\n

전체 통합 KPI

\n\n

7일 총 광고비

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

7일 총 매출

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

7일 통합 ROAS

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

7일 총 전환

${d.overall.tConv}건

\n\n

전일 광고비

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

전일 매출

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

전일 ROAS

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

전일 전환

${d.overall.yConv}건

\n\n

📊 브랜드별 7일 비교

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

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

\n\n\n`;\n}","createdAt",["D",1778491474964],"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":190,"_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":191,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":192,"_81":193,"_83":194,"_85":25},"tree",[177,178,179],"files",[177,178,179],"counts",{"_165":166,"_167":168,"_169":60,"_170":171,"_172":173},"contents",[139,140,141],"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":157,"_32":158,"_30":159,"_145":-5,"_41":42,"_40":160,"_147":127,"_38":161,"_13":162,"_33":34,"_35":163,"_24":25,"_151":-5,"_27":164},{"_43":153,"_32":28,"_30":31,"_145":-5,"_41":42,"_40":14,"_147":25,"_38":154,"_13":155,"_33":34,"_35":37,"_24":25,"_151":-5,"_27":156},{"_43":142,"_32":143,"_30":144,"_145":-5,"_41":42,"_40":146,"_147":25,"_38":148,"_13":149,"_33":34,"_35":150,"_24":25,"_151":-5,"_27":152},"1b6b5256-4cf0-11f1-bbcd-ee650bb23af1","naverSearchAd.ts","05c7ae2c-4cf0-11f1-8681-ee650bb23af1","parentId",15,"latest",["D",1778472956094],4,"/**\n * 네이버 검색광고 API용 HMAC-SHA256 서명 생성기 (val.town)\n *\n * 환경변수 (val.town secrets):\n * NAVER_SA_API_KEY : Access License (엑세스라이선스)\n * NAVER_SA_SECRET_KEY : Secret Key (비밀키)\n * NAVER_SA_CUSTOMER_ID: Customer ID (광고주 ID)\n * WORKER_KEY : 본인이 정한 임의 비밀번호 (커머스용 8845 그대로 사용 가능)\n *\n * 호출:\n * GET ?key=WORKER_KEY&method=GET&uri=/ncc/campaigns\n * GET ?key=WORKER_KEY&method=GET&uri=/stats\n */\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 method = (url.searchParams.get(\"method\") || \"GET\").toUpperCase();\n const uri = url.searchParams.get(\"uri\") || \"/stats\";\n\n const API_KEY = Deno.env.get(\"NAVER_SA_API_KEY\")!;\n const SECRET_KEY = Deno.env.get(\"NAVER_SA_SECRET_KEY\")!;\n const CUSTOMER_ID = Deno.env.get(\"NAVER_SA_CUSTOMER_ID\")!;\n\n try {\n const timestamp = String(Date.now());\n const message = `${timestamp}.${method}.${uri}`;\n\n const enc = new TextEncoder();\n const key = await crypto.subtle.importKey(\n \"raw\",\n enc.encode(SECRET_KEY),\n { name: \"HMAC\", hash: \"SHA-256\" },\n false,\n [\"sign\"],\n );\n const sigBuffer = await crypto.subtle.sign(\n \"HMAC\",\n key,\n enc.encode(message),\n );\n const signature = btoa(String.fromCharCode(...new Uint8Array(sigBuffer)));\n\n return Response.json({\n ok: true,\n api_key: API_KEY,\n customer_id: CUSTOMER_ID,\n timestamp,\n signature,\n });\n } catch (err: any) {\n return Response.json({ error: \"exception\", message: err.message }, {\n status: 500,\n });\n }\n}","label",[143],"3986535a-4d1b-11f1-b32b-ee650bb23af1",["D",1778491474964],7,[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}",[158],"pulls",1,"branches",2,"forks","envVars",{"_174":14,"_176":60},"connections",{"_174":60,"_175":60},"count","unfilledCount","emptyCount",{"_43":157,"_32":158,"_30":159,"_145":-5,"_41":42,"_40":160,"_147":127,"_38":187,"_13":162,"_33":34,"_35":163,"_24":25,"_151":-5,"_181":188,"_27":189},{"_43":153,"_32":28,"_30":31,"_145":-5,"_41":42,"_40":14,"_147":25,"_38":184,"_13":155,"_33":34,"_35":37,"_24":25,"_151":-5,"_181":185,"_27":186},{"_43":142,"_32":143,"_30":144,"_145":-5,"_41":42,"_40":146,"_147":25,"_38":180,"_13":149,"_33":34,"_35":150,"_24":25,"_151":-5,"_181":182,"_27":183},["D",1778472956094],"children",[],[143],["D",1778491474964],[],[28],["D",1778469067627],[],[158],["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":228,"_229":230,"_231":232,"_233":25,"_234":25,"_235":25,"_236":127,"_237":-5,"_238":-7,"_239":-7,"_240":60,"_241":25,"_242":25,"_243":-5,"_244":25,"_245":25,"_246":25,"_247":-5},"ENV",{"_199":200,"_201":202,"_203":135,"_204":205,"_206":207,"_208":209,"_210":211,"_212":213,"_214":215,"_216":217,"_218":219,"_220":221,"_222":223,"_224":225,"_226":227},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v23