[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_249":250,"_251":252},"routes/_app.x.$handle.$name",{"_100":99,"_32":45,"_109":90,"_27":53,"_13":14,"_110":-5,"_11":111,"_112":113,"_114":115,"_116":117,"_118":119,"_20":-5,"_120":-5,"_121":-5,"_122":25,"_123":124,"_125":59,"_126":-5,"_127":-5,"_128":129},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":25},"version",88,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":37,"_35":36,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","cron-decisiones.ts","latestPath","fileId","1beab11a-7f0c-11f1-8920-1607ee4eb77e","name","fileType","script","content","import { blob } from \"https://esm.town/v/std/blob\"; const TOK=\"kd26\"; const TAGORDER=[\"complaint\",\"lead\",\"question\",\"praise\"]; function pickComments(comments:any){ const arr=(comments||[]).slice().sort((a:any,b:any)=>TAGORDER.indexOf(a.tag)-TAGORDER.indexOf(b.tag)); return arr.slice(0,6).map((c:any)=>({tag:c.tag,autor:c.author,texto:(c.text||\"\").slice(0,140)})); } function pickPosts(posts:any){ const rep=(posts||[]).find((p:any)=>p.flag===\"rep\"); const des=(posts||[]).find((p:any)=>p.flag===\"des\"); return { mejor: rep?{red:rep.net,titulo:(rep.title||\"\").slice(0,80),metrica:rep.metric+\" \"+rep.label}:null, peor: des?{red:des.net,titulo:(des.title||\"\").slice(0,80),metrica:des.metric+\" \"+des.label}:null }; } function pickWeb(web:any){ if(!web) return null; const out:any={}; if(web.ga4) out.ga4={usuarios:web.ga4.usuarios,sesiones:web.ga4.sesiones,vistas:web.ga4.vistas,usuariosDelta:web.ga4.usuariosDelta}; if(web.gsc) out.gsc={clicks:web.gsc.clicks,impresiones:web.gsc.impresiones,posicion:web.gsc.posicion}; return Object.keys(out).length?out:null; } async function claude(cliente:string,resumen:any){ async function callOnce(){ const res=await fetch(\"https://api.anthropic.com/v1/messages\",{method:\"POST\",headers:{\"x-api-key\":Deno.env.get(\"ANTHROPIC_API_KEY\"),\"anthropic-version\":\"2023-06-01\",\"content-type\":\"application/json\"},body:JSON.stringify({model:\"claude-sonnet-5\",max_tokens:1400,system:\"Eres un estratega senior de marketing digital de una agencia. Analiza los datos reales de la semana de un cliente y redacta EXACTAMENTE 3 decisiones para el resumen interno 'Lunes en 30 segundos': una para REPLICAR (algo que funciono y por que, con accion concreta para repetirlo), una para AJUSTAR (algo mejorable con una accion concreta), una para DESCARTAR (algo que no funciona y conviene detener o cambiar). Cada texto: maximo 2 frases, directo, accionable, en espanol, dirigido al equipo interno de la agencia (no al cliente final). Nunca inventes cifras que no te den. Si falta info para alguna categoria, da igual la mejor recomendacion razonable con lo disponible (incluso si es solo sobre datos de sitio web, ads o comentarios). Aunque la informacion disponible sea minima o parcial, NUNCA respondas con un array vacio: usa lo poco que tengas (aunque sea solo el nombre del cliente, o datos de un solo canal) para dar 3 recomendaciones razonables de buenas practicas de marketing digital. Un array vacio nunca es una respuesta valida. Responde UNICAMENTE con el array JSON, sin texto antes ni despues, sin markdown, sin backticks. Formato exacto: [{\\\"type\\\":\\\"rep\\\",\\\"text\\\":\\\"...\\\",\\\"src\\\":\\\"...\\\"},{\\\"type\\\":\\\"adj\\\",\\\"text\\\":\\\"...\\\",\\\"src\\\":\\\"...\\\"},{\\\"type\\\":\\\"des\\\",\\\"text\\\":\\\"...\\\",\\\"src\\\":\\\"...\\\"}]. El campo src es una nota corta citando el dato o evidencia concreta detras de la decision.\",messages:[{role:\"user\",content:\"Cliente: \"+cliente+\"\\nDatos de la semana (JSON): \"+JSON.stringify(resumen)}]})}).then(r=>r.json()); if(res.error) throw new Error(res.error.message||JSON.stringify(res.error)); const txt=(res.content&&res.content[0]&&res.content[0].text)||\"[]\"; let arr:any=[]; try{ arr=JSON.parse(txt.trim()); }catch(e1){ try{ const a=txt.indexOf(\"[\"); const b=txt.lastIndexOf(\"]\"); arr=JSON.parse(a>=0&&b>a?txt.slice(a,b+1):\"[]\"); }catch(e2){ console.log(\"parse_fail\",cliente,txt.slice(0,500),res.stop_reason); arr=[]; } } const out=(Array.isArray(arr)?arr:[]).filter((d:any)=>d&&[\"rep\",\"adj\",\"des\"].includes(d.type)&&d.text).slice(0,3); if(out.length<3) console.log(\"pocas_decisiones\",cliente,out.length,txt.slice(0,500),res.stop_reason); return out; } const r1=await callOnce(); let best=r1; if(best.length<3){ console.log(\"reintento\",cliente,best.length); try{ const r2=await callOnce(); if(r2.length>best.length) best=r2; }catch(e){ console.log(\"reintento_fallo\",cliente,String(e)); } } return best; } export default async function(req:any){ const isHttp=req&&typeof req.url===\"string\"; if(isHttp){const u=new URL(req.url); if(u.searchParams.get(\"t\")!==TOK) return new Response(\"no\",{status:401});} const data=await blob.getJSON(\"kimital-panel-data\"); if(!data||!data.clients) return isHttp?Response.json({error:\"sin_data\"}):undefined; const targets=[]; for(const c of data.clients){ const kpis=c.kpis||{}; const webData=pickWeb(c.web); const tieneAlgo=Object.keys(kpis).length||(c.comments&&c.comments.length)||(c.adsRangos&&c.adsRangos[\"7\"])||webData; if(!tieneAlgo) continue; const pk=pickPosts(c.posts); const payload={ redes:Object.fromEntries(Object.entries(kpis).map(([net,k]:any)=>[net,{seguidores:k.followers,seguidoresDelta:k.followersDelta,postsSemana:k.posts,engagementPct:k.engagement,engagementDelta:k.engagementDelta,interaccionesSemana:k.reach,interaccionesDelta:k.reachDelta}])), ads:(c.adsRangos&&c.adsRangos[\"7\"]&&c.adsRangos[\"7\"].resumen)||null, mejorPost:pk.mejor, peorPost:pk.peor, sitioWeb:webData, comentariosDestacados:pickComments(c.comments) }; targets.push({c,payload}); } const results=await Promise.allSettled(targets.map(t=>claude(t.c.name,t.payload))); const resumen:any[]=[]; results.forEach((r,i)=>{ const c=targets[i].c; if(r.status===\"fulfilled\"){ if(r.value.length) c.decisions=r.value; resumen.push({cliente:c.name,ok:true,n:r.value.length}); } else { resumen.push({cliente:c.name,ok:false,error:String(r.reason)}); } }); await blob.setJSON(\"kimital-panel-data\",data); console.log(\"decisiones ok\",JSON.stringify(resumen)); return isHttp?Response.json({ok:true,resumen}):undefined; }","interval","createdAt",["D",1783984625725],"branchVersion","branchId","8a22b787-6585-48d5-8329-34fbc616a00b","id","d029bcab-ffc1-46e0-b1d9-f7428bbc53a8","panel-datos",["D",1783733917279],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","b596274b-9782-4ee8-a233-0f7690f53b08","pinnedFileId","080f4a68-9607-11f1-bc07-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019f20b5-91da-76ba-afa4-c47eb3e24ea6","tursoName","d029bcabffc146e0b1d9f7428bbc53a8","tursoHostname","d029bcabffc146e0b1d9f7428bbc53a8-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789512647429],"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":89,"_32":90,"_43":42,"_91":44,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":45,"_98":99},"isOwned",235,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","kimital","handle","displayName","KIMITAL Imagen","avatar","https://lh3.googleusercontent.com/a/ACg8ocI8A_Eawu1wTZESeqaX_xzlCotIGOiCqFj1v-NgQJ0aLpYWIM4h=s96-c","tier","pro","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_43":44,"_32":45,"_38":244,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":245,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":246,"_84":247,"_86":248,"_88":25},"tree",[211,212,213,214,215,216,217,218],"files",[211,212,213,214,215,216,217,218],"counts",{"_200":63,"_201":202,"_203":63,"_204":205,"_206":207},"contents",[130,131,132,133,134,135,136,137],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":193,"_32":194,"_30":195,"_141":-5,"_41":42,"_40":196,"_143":25,"_38":197,"_13":161,"_33":37,"_35":198,"_24":25,"_148":-5,"_27":199},{"_43":189,"_32":28,"_30":31,"_141":-5,"_41":42,"_40":14,"_143":25,"_38":190,"_13":191,"_33":37,"_35":36,"_24":25,"_148":-5,"_27":192},{"_43":181,"_32":182,"_30":183,"_141":-5,"_41":42,"_40":184,"_143":25,"_38":185,"_13":186,"_33":37,"_35":187,"_24":25,"_148":-5,"_27":188},{"_43":173,"_32":174,"_30":175,"_141":-5,"_41":42,"_40":176,"_143":25,"_38":177,"_13":178,"_33":37,"_35":179,"_24":25,"_148":-5,"_27":180},{"_43":165,"_32":166,"_30":167,"_141":-5,"_41":42,"_40":168,"_143":25,"_38":169,"_13":170,"_33":37,"_35":171,"_24":25,"_148":-5,"_27":172},{"_43":158,"_32":159,"_30":160,"_141":-5,"_41":42,"_40":161,"_143":25,"_38":162,"_13":153,"_33":37,"_35":163,"_24":25,"_148":-5,"_27":164},{"_43":150,"_32":151,"_30":152,"_141":-5,"_41":42,"_40":153,"_143":59,"_38":154,"_13":155,"_33":146,"_35":156,"_24":25,"_148":-5,"_27":157},{"_43":138,"_32":139,"_30":140,"_141":-5,"_41":42,"_40":142,"_143":25,"_38":144,"_13":145,"_33":146,"_35":147,"_24":25,"_148":-5,"_27":149},"ba4404fc-cc3d-4ef1-bf77-cafabe2f7204","test-meta.ts","7f72a292-7cd2-11f1-8891-1607ee4eb77e","parentId",66,"latest",["D",1783981414685],22,"http","import { blob } from \"https://esm.town/v/std/blob\"; const TOK=\"kd26\"; export default async function(req){ const u=new URL(req.url); if(u.searchParams.get(\"t\")!==TOK) return new Response(\"no\",{status:401}); const H={\"Access-Control-Allow-Origin\":\"*\",\"Access-Control-Allow-Headers\":\"*\"}; if(req.method===\"OPTIONS\") return new Response(\"\",{headers:H}); if(req.method===\"POST\"){ const body=await req.text(); await blob.setJSON(\"paneltmp\",{html:body}); return Response.json({ok:true,len:body.length},{headers:H}); } const d=await blob.getJSON(\"paneltmp\"); return new Response(d?d.html:\"\", {headers:{...H,\"content-type\":\"text/plain; charset=utf-8\"}}); }","label",[139],"092d6bf4-c256-406c-ad45-03ae0b5dc240","main.ts","3ca65afc-7cc9-11f1-8d1a-1607ee4eb77e",3,["D",1783733966306],2,"// KIMITAL - PANEL DE AGENCIA - Backend Fase 1 (datos del dashboard)\n// GET ?key=PANEL_KEY -> entrega el snapshot JSON al panel\n// POST + Bearer PANEL_ADMIN_KEY -> actualiza el snapshot (cron o equipo)\n\nimport { blob } from \"https://esm.town/v/std/blob\";\n\nconst ALLOWED = [\"https://kimital.com\", \"https://www.kimital.com\"];\nconst BLOB_KEY = \"kimital-panel-data\";\n\nexport default async function (req: Request): Promise {\n const KEY = Deno.env.get(\"PANEL_KEY\");\n const ADMIN = Deno.env.get(\"PANEL_ADMIN_KEY\");\n\n const origin = req.headers.get(\"origin\") ?? \"\";\n const cors = {\n \"Access-Control-Allow-Origin\": ALLOWED.includes(origin)\n ? origin\n : ALLOWED[0],\n \"Access-Control-Allow-Methods\": \"GET, POST, OPTIONS\",\n \"Access-Control-Allow-Headers\": \"content-type, authorization\",\n \"Cache-Control\": \"no-store\",\n };\n if (req.method === \"OPTIONS\") return new Response(null, { headers: cors });\n\n if (req.method === \"GET\") {\n const url = new URL(req.url);\n if (!KEY || url.searchParams.get(\"key\") !== KEY) {\n return new Response(\"No autorizado\", { status: 401, headers: cors });\n }\n const data = await blob.getJSON(BLOB_KEY);\n return Response.json(data ?? { meta: null, clients: [] }, {\n headers: cors,\n });\n }\n\n if (req.method === \"POST\") {\n const auth = req.headers.get(\"authorization\") ?? \"\";\n if (!ADMIN || auth !== \"Bearer \" + ADMIN) {\n return new Response(\"No autorizado\", { status: 401, headers: cors });\n }\n let body: any;\n try {\n body = await req.json();\n } catch {\n return new Response(\"JSON invalido\", { status: 400, headers: cors });\n }\n if (!body || !Array.isArray(body.clients) || body.clients.length === 0) {\n return new Response(\"Formato invalido: se espera {meta, clients:[...]}\", {\n status: 400,\n headers: cors,\n });\n }\n const prev = await blob.getJSON(BLOB_KEY);\n if (prev) await blob.setJSON(BLOB_KEY + \"-anterior\", prev);\n await blob.setJSON(BLOB_KEY, body);\n return Response.json({ ok: true, clients: body.clients.length }, {\n headers: cors,\n });\n }\n\n return new Response(\"Metodo no soportado\", { status: 405, headers: cors });\n}",[151],"f86753e8-509c-4d86-b3e9-994d78cd4df0","cron-youtube.ts","4cc7f08c-7ccc-11f1-b774-1607ee4eb77e",7,["D",1783735299867],"// KIMITAL - PANEL - Cron de YouTube: actualiza metricas y comentarios\n// Corre cada madrugada. Requiere env YT_API_KEY (YouTube Data API v3).\n\nimport { blob } from \"https://esm.town/v/std/blob\";\n\nconst BLOB_KEY = \"kimital-panel-data\";\n\n// id del cliente en el panel -> channelId de YouTube\nconst YT_CHANNELS: Record = {\n fiduciario: \"UC0Mn32pZvtPyQQVdx4bZmdw\", // Cafe Fiduciario\n};\n\nexport default async function () {\n const YT_KEY = Deno.env.get(\"YT_API_KEY\");\n if (!YT_KEY) {\n console.log(\"Falta YT_API_KEY - cron sin efecto\");\n return;\n }\n const data = (await blob.getJSON(BLOB_KEY)) as any;\n if (!data || !Array.isArray(data.clients)) {\n console.log(\"No hay snapshot sembrado\");\n return;\n }\n\n for (const [clientId, channelId] of Object.entries(YT_CHANNELS)) {\n const client = data.clients.find((c: any) => c.id === clientId);\n if (!client) continue;\n\n // 1) Estadisticas del canal\n const ch = await fetch(\n \"https://www.googleapis.com/youtube/v3/channels?part=statistics&id=\" +\n channelId + \"&key=\" + YT_KEY,\n ).then((r) => r.json());\n const st = ch.items && ch.items[0] && ch.items[0].statistics;\n if (st) {\n const prev = (client.kpis && client.kpis.youtube) || {};\n const subs = Number(st.subscriberCount || 0);\n client.kpis = client.kpis || {};\n client.kpis.youtube = {\n followers: subs,\n followersDelta: prev.followers\n ? Number(\n (((subs - prev.followers) / prev.followers) * 100).toFixed(1),\n )\n : 0,\n posts: Number(st.videoCount || 0),\n reach: prev.reach || 0,\n reachDelta: prev.reachDelta || 0,\n engagement: prev.engagement || 0,\n engagementDelta: prev.engagementDelta || 0,\n };\n if (!client.platforms.includes(\"youtube\")) {\n client.platforms.push(\"youtube\");\n }\n }\n\n // 2) Ultimos comentarios del canal (reemplaza los \"yt\" anteriores)\n const th = await fetch(\n \"https://www.googleapis.com/youtube/v3/commentThreads?part=snippet&allThreadsRelatedToChannelId=\" +\n channelId + \"&order=time&maxResults=5&key=\" + YT_KEY,\n ).then((r) => r.json());\n if (Array.isArray(th.items)) {\n const nuevos = th.items.map((t: any) => {\n const s = t.snippet.topLevelComment.snippet;\n return {\n net: \"yt\",\n author: s.authorDisplayName,\n when: new Date(s.publishedAt).toLocaleString(\"es-CO\", {\n timeZone: \"America/Bogota\",\n day: \"numeric\",\n month: \"short\",\n hour: \"2-digit\",\n minute: \"2-digit\",\n }),\n post: \"Video del canal\",\n tag: \"question\", // Fase 2: Claude clasificara\n text: s.textDisplay.replace(/<[^>]+>/g, \"\"),\n reply: \"(Fase 2: Claude redactara aqui la respuesta sugerida)\",\n };\n });\n client.comments = nuevos.concat(\n (client.comments || []).filter((c: any) => c.net !== \"yt\"),\n );\n }\n }\n\n data.meta = Object.assign({}, data.meta, {\n actualizado: \"actualizado \" + new Date().toLocaleString(\"es-CO\", {\n timeZone: \"America/Bogota\",\n day: \"numeric\",\n month: \"long\",\n hour: \"2-digit\",\n minute: \"2-digit\",\n }),\n });\n await blob.setJSON(BLOB_KEY, data);\n console.log(\"Snapshot actualizado con YouTube\");\n}",[159],"6c11146b-f5e6-4938-858f-c498dee398c6","cron-web.ts","3c2c71f6-7ef4-11f1-92da-1607ee4eb77e",52,["D",1783976013205],8,"import { blob } from \"https://esm.town/v/std/blob\"; const TOK=\"kd26\"; const WEB_MAP={\"pg1027190790483021\":{ga4:\"530483509\",gsc:[]},\"pg939798619227286\":{ga4:\"530015557\",gsc:[\"sc-domain:abogadofiduciario.com\"]},\"pg1399018606896783\":{ga4:\"317644503\",gsc:[]},\"pg286258314796413\":{ga4:null,gsc:[\"sc-domain:brooksjimenez.com\",\"sc-domain:immigrationrunners.com\",\"sc-domain:golpesoklahoma.com\"]}}; const KIMITAL={id:\"web-kimital\",name:\"Kimital\",initials:\"KM\",ga4:\"543684129\",gsc:[\"https://kimital.com/\"]}; async function token(){const r=await fetch(\"https://oauth2.googleapis.com/token\",{method:\"POST\",headers:{\"content-type\":\"application/x-www-form-urlencoded\"},body:new URLSearchParams({client_id:Deno.env.get(\"GOOGLE_CLIENT_ID\"),client_secret:Deno.env.get(\"GOOGLE_CLIENT_SECRET\"),refresh_token:Deno.env.get(\"GOOGLE_REFRESH_TOKEN\"),grant_type:\"refresh_token\"})}).then(r=>r.json());return r.access_token;} function fechas(off,span){const d=n=>{const x=new Date();x.setUTCDate(x.getUTCDate()-n);return x.toISOString().slice(0,10);};return {start:d(off+span),end:d(off)};} async function ga4(AT,pid){const url=\"https://analyticsdata.googleapis.com/v1beta/properties/\"+pid+\":runReport\";const H={authorization:\"Bearer \"+AT,\"content-type\":\"application/json\"};const tot=await fetch(url,{method:\"POST\",headers:H,body:JSON.stringify({dateRanges:[{startDate:\"30daysAgo\",endDate:\"today\"},{startDate:\"60daysAgo\",endDate:\"31daysAgo\"}],metrics:[{name:\"activeUsers\"},{name:\"sessions\"},{name:\"screenPageViews\"},{name:\"averageSessionDuration\"}]})}).then(r=>r.json());const can=await fetch(url,{method:\"POST\",headers:H,body:JSON.stringify({dateRanges:[{startDate:\"30daysAgo\",endDate:\"today\"}],dimensions:[{name:\"sessionDefaultChannelGroup\"}],metrics:[{name:\"sessions\"}],orderBys:[{metric:{metricName:\"sessions\"},desc:true}],limit:6})}).then(r=>r.json());const pag=await fetch(url,{method:\"POST\",headers:H,body:JSON.stringify({dateRanges:[{startDate:\"30daysAgo\",endDate:\"today\"}],dimensions:[{name:\"pagePath\"}],metrics:[{name:\"screenPageViews\"}],orderBys:[{metric:{metricName:\"screenPageViews\"},desc:true}],limit:6})}).then(r=>r.json());const g=(rows,i)=>((rows&&rows[i]&&rows[i].metricValues)||[]).map(v=>Number(v.value));const cur=g(tot.rows,0),prev=g(tot.rows,1);const dl=(a,b)=>b>0?Math.round((a-b)/b*100):0;return {usuarios:cur[0]||0,sesiones:cur[1]||0,vistas:cur[2]||0,durMedia:Math.round(cur[3]||0),usuariosDelta:dl(cur[0]||0,prev[0]||0),sesionesDelta:dl(cur[1]||0,prev[1]||0),canales:(can.rows||[]).map(r=>({nombre:r.dimensionValues[0].value,sesiones:Number(r.metricValues[0].value)})),paginas:(pag.rows||[]).map(r=>({path:r.dimensionValues[0].value,vistas:Number(r.metricValues[0].value)})),err:tot.error?(tot.error.message||\"err\"):null};} async function gscOne(AT,site){const enc=encodeURIComponent(site);const f=fechas(3,28);const H={authorization:\"Bearer \"+AT,\"content-type\":\"application/json\"};const base=\"https://www.googleapis.com/webmasters/v3/sites/\"+enc+\"/searchAnalytics/query\";const tot=await fetch(base,{method:\"POST\",headers:H,body:JSON.stringify({startDate:f.start,endDate:f.end})}).then(r=>r.json());const qs=await fetch(base,{method:\"POST\",headers:H,body:JSON.stringify({startDate:f.start,endDate:f.end,dimensions:[\"query\"],rowLimit:10})}).then(r=>r.json());const t=(tot.rows&&tot.rows[0])||{clicks:0,impressions:0,ctr:0,position:0};return {site,clicks:t.clicks||0,impresiones:t.impressions||0,ctr:t.ctr||0,posicion:t.position||0,queries:(qs.rows||[]).map(r=>({q:r.keys[0],clicks:r.clicks,impresiones:r.impressions,posicion:r.position}))};} async function gsc(AT,sites){if(!sites||!sites.length)return null;const parts=[];for(const s of sites){try{parts.push(await gscOne(AT,s));}catch(e){}}if(!parts.length)return null;const clicks=parts.reduce((a,p)=>a+p.clicks,0);const imp=parts.reduce((a,p)=>a+p.impresiones,0);const pos=imp>0?parts.reduce((a,p)=>a+p.posicion*p.impresiones,0)/imp:0;const aq={};for(const p of parts){for(const q of p.queries){if(!aq[q.q])aq[q.q]={q:q.q,clicks:0,impresiones:0};aq[q.q].clicks+=q.clicks;aq[q.q].impresiones+=q.impresiones;}}const queries=Object.values(aq).sort((a,b)=>b.clicks-a.clicks).slice(0,10);const dominios=parts.map(p=>{let s=p.site.replace(\"sc-domain:\",\"\").replace(\"https://\",\"\").replace(\"http://\",\"\");if(s.endsWith(\"/\"))s=s.slice(0,-1);return {site:s,clicks:p.clicks,impresiones:p.impresiones};});return {clicks,impresiones:imp,ctr:imp>0?clicks/imp:0,posicion:pos,queries,dominios};} async function buildWeb(AT,cfg){const web={actualizado:new Date().toISOString()};if(cfg.ga4){try{web.ga4=await ga4(AT,cfg.ga4);}catch(e){web.ga4err=String(e);}}try{web.gsc=await gsc(AT,cfg.gsc);}catch(e){web.gscerr=String(e);}return web;} export default async function(req){const isHttp=req&&typeof req.url===\"string\";if(isHttp&&new URL(req.url).searchParams.get(\"t\")!==TOK)return new Response(\"no\",{status:401});const AT=await token();if(!AT){console.log(\"sin AT\");return isHttp?Response.json({error:\"sin_AT\"}):undefined;}const data=await blob.getJSON(\"kimital-panel-data\");if(!data||!data.clients){return isHttp?Response.json({error:\"sin_data\"}):undefined;}for(const c of data.clients){const cfg=WEB_MAP[c.id];if(cfg)c.web=await buildWeb(AT,cfg);}let km=data.clients.find(c=>c.id===KIMITAL.id);if(!km){km={id:KIMITAL.id,name:KIMITAL.name,initials:KIMITAL.initials,platforms:[],kpis:{},bestHour:{},decisions:[],posts:[],schedule:[],comments:[]};data.clients.push(km);}km.web=await buildWeb(AT,{ga4:KIMITAL.ga4,gsc:KIMITAL.gsc});await blob.setJSON(\"kimital-panel-data\",data);const done=data.clients.filter(c=>c.web).map(c=>c.name);console.log(\"web ok\",done);return isHttp?Response.json({ok:true,done}):undefined;}",[166],"8746defd-b376-47c8-bd34-6c8f5a2ecfea","cron-meta.ts","b5827596-7cd3-11f1-b80c-1607ee4eb77e",73,["D",1783982093039],17,"// KIMITAL - PANEL - Cron de Meta: Facebook + Instagram (v5)\n// Seguidores, comentarios y publicaciones del ultimo mes con formato,\n// miniatura y enlace. Guarda el top de CADA red por separado.\n\nimport { blob } from \"https://esm.town/v/std/blob\";\n\nconst BLOB_KEY = \"kimital-panel-data\";\nconst G = \"https://graph.facebook.com/v21.0/\";\nconst DIAS_30 = 30 * 24 * 3600 * 1000;\nconst DIAS_7 = 7 * 24 * 3600 * 1000;\nconst limiteSemana = Date.now() - DIAS_7;\n\nconst ALIAS: Record = {\n \"1027190790483021\": { name: \"N\\u00facleo Pensional\", initials: \"NP\" },\n \"939798619227286\": { name: \"Abogado Fiduciario\", initials: \"AF\" },\n \"110246487208178\": { name: \"Pien S.A.S\", initials: \"PS\" },\n \"104181501157043\": {\n name: \"Su\\u00e1rez & G\\u00f3mez Abogados\",\n initials: \"SG\",\n },\n \"1399018606896783\": { name: \"Gr\\u00faas Cono Sur\", initials: \"GC\" },\n \"286258314796413\": {\n name: \"Michael Brooks - Jim\\u00e9nez P.C.\",\n initials: \"MB\",\n },\n};\n\nfunction cuando(iso: string) {\n return new Date(iso).toLocaleString(\"es-CO\", {\n timeZone: \"America/Bogota\",\n day: \"numeric\",\n month: \"short\",\n hour: \"2-digit\",\n minute: \"2-digit\",\n });\n}\nfunction fecha(iso: string) {\n return new Date(iso).toLocaleString(\"es-CO\", {\n timeZone: \"America/Bogota\",\n day: \"numeric\",\n month: \"short\",\n });\n}\nfunction iniciales(nombre: string) {\n const p = nombre.split(\" \").filter((x) => x.length > 1);\n const a = p[0] ? p[0][0] : \"?\";\n const b = p[1] ? p[1][0] : (p[0] && p[0][1] ? p[0][1] : \"\");\n return (a + b).toUpperCase();\n}\nfunction delta(prev: number | undefined, nuevo: number) {\n if (!prev) return 0;\n return Number((((nuevo - prev) / prev) * 100).toFixed(1));\n}\n\nexport default async function () {\n const T = Deno.env.get(\"META_KEY\");\n if (!T) {\n console.log(\"Falta META_KEY\");\n return;\n }\n const data = (await blob.getJSON(BLOB_KEY)) as any;\n if (!data || !Array.isArray(data.clients)) {\n console.log(\"No hay snapshot\");\n return;\n }\n\n const pages = await fetch(\n G +\n \"me/accounts?fields=id,name,access_token,followers_count,fan_count,instagram_business_account%7Bid,username,followers_count%7D&limit=100&access_token=\" +\n T,\n ).then((r) => r.json());\n if (pages.error) {\n console.log(\"ERROR paginas: \" + JSON.stringify(pages.error));\n return;\n }\n\n const limite = Date.now() - DIAS_30;\n\n for (const p of pages.data || []) {\n const id = \"pg\" + p.id;\n const alias = ALIAS[p.id] || {};\n const nombre = alias.name || p.name;\n let client = data.clients.find((c: any) => c.id === id);\n if (!client) {\n client = {\n id,\n name: nombre,\n initials: alias.initials || iniciales(nombre),\n platforms: [],\n kpis: {},\n bestHour: {},\n decisions: [],\n posts: [],\n schedule: [],\n comments: [],\n };\n data.clients.push(client);\n }\n client.name = nombre;\n client.initials = alias.initials || iniciales(nombre);\n const PT = p.access_token || T;\n const comentarios: any[] = [];\n const publicaciones: any[] = [];\n\n const fbSeg = p.followers_count ?? p.fan_count ?? 0;\n const prevFb = client.kpis.facebook || {};\n client.kpis.facebook = {\n followers: fbSeg,\n followersDelta: delta(prevFb.followers, fbSeg),\n engagement: prevFb.engagement || 0,\n engagementDelta: prevFb.engagementDelta || 0,\n reach: prevFb.reach || 0,\n reachDelta: prevFb.reachDelta || 0,\n posts: prevFb.posts || 0,\n };\n if (!client.platforms.includes(\"facebook\")) {\n client.platforms.push(\"facebook\");\n }\n\n let fbPostsSemana = 0;\n let fbInteraccionesSemana = 0;\n\n try {\n const feed = await fetch(\n G + p.id +\n \"/feed?fields=message,created_time,full_picture,permalink_url,shares,attachments%7Bmedia_type%7D,reactions.summary(true).limit(0),comments.limit(3).summary(true)%7Bfrom,message,created_time%7D&limit=15&access_token=\" +\n PT,\n ).then((r) => r.json());\n for (const post of feed.data || []) {\n const cs = post.comments && post.comments.data\n ? post.comments.data\n : [];\n for (const c of cs) {\n comentarios.push({\n net: \"fb\",\n author: (c.from && c.from.name) || \"Usuario de Facebook\",\n when: cuando(c.created_time),\n post: (post.message || \"Publicacion\").slice(0, 60),\n tag: \"question\",\n text: c.message,\n reply: \"(Fase 2: Claude redactara aqui la respuesta sugerida)\",\n });\n }\n if (new Date(post.created_time).getTime() > limite) {\n const megusta = post.reactions && post.reactions.summary\n ? Number(post.reactions.summary.total_count || 0)\n : 0;\n const compartidos = post.shares ? Number(post.shares.count || 0) : 0;\n const ncom = post.comments && post.comments.summary\n ? Number(post.comments.summary.total_count || 0)\n : 0;\n if (new Date(post.created_time).getTime() > limiteSemana) {\n fbPostsSemana++;\n fbInteraccionesSemana += megusta + ncom + compartidos;\n }\n const att = post.attachments && post.attachments.data &&\n post.attachments.data[0];\n const mt = att ? (att.media_type || \"\") : \"\";\n let formato = \"Publicaci\\u00f3n\";\n if (mt === \"photo\") formato = \"Est\\u00e1tico\";\n else if (mt === \"video\") formato = \"Video\";\n else if (mt === \"album\") formato = \"Carrusel\";\n publicaciones.push({\n net: \"fb\",\n likes: megusta,\n title: (post.message || \"Publicacion de Facebook\").slice(0, 70),\n thumb: post.full_picture || \"\",\n link: post.permalink_url || \"\",\n meta: formato + \" \\u00b7 \" + fecha(post.created_time) + \" \\u00b7 \" +\n compartidos + \" compartidos \\u00b7 \" + ncom + \" comentarios\",\n });\n }\n }\n } catch (e) {}\n\n const fbEngagement = fbSeg > 0 && fbPostsSemana > 0\n ? Math.round((fbInteraccionesSemana / fbPostsSemana) / fbSeg * 1000) / 10\n : 0;\n client.kpis.facebook.posts = fbPostsSemana;\n client.kpis.facebook.engagement = fbEngagement;\n client.kpis.facebook.engagementDelta = delta(prevFb.engagement || 0, fbEngagement);\n client.kpis.facebook.reach = fbInteraccionesSemana;\n client.kpis.facebook.reachDelta = delta(prevFb.reach || 0, fbInteraccionesSemana);\n\n const ig = p.instagram_business_account;\n if (ig) {\n const prevIg = client.kpis.instagram || {};\n const igSeg = ig.followers_count || 0;\n client.kpis.instagram = {\n followers: igSeg,\n followersDelta: delta(prevIg.followers, igSeg),\n engagement: prevIg.engagement || 0,\n engagementDelta: prevIg.engagementDelta || 0,\n reach: prevIg.reach || 0,\n reachDelta: prevIg.reachDelta || 0,\n posts: prevIg.posts || 0,\n };\n if (!client.platforms.includes(\"instagram\")) {\n client.platforms.unshift(\"instagram\");\n }\n let igPostsSemana = 0;\n let igInteraccionesSemana = 0;\n\n try {\n const media = await fetch(\n G + ig.id +\n \"/media?fields=id,caption,timestamp,media_type,media_url,thumbnail_url,permalink,like_count,comments_count,comments.limit(3)%7Busername,text,timestamp%7D&limit=15&access_token=\" +\n PT,\n ).then((r) => r.json());\n for (const m of media.data || []) {\n const cs = m.comments && m.comments.data ? m.comments.data : [];\n for (const c of cs) {\n comentarios.push({\n net: \"ig\",\n author: \"@\" + (c.username || \"usuario\"),\n when: cuando(c.timestamp),\n post: (m.caption || \"Publicacion\").slice(0, 60),\n tag: \"question\",\n text: c.text,\n reply: \"(Fase 2: Claude redactara aqui la respuesta sugerida)\",\n });\n }\n if (new Date(m.timestamp).getTime() > limite) {\n let guardados = 0;\n try {\n const insM = await fetch(\n G + m.id + \"/insights?metric=saved&access_token=\" + PT,\n ).then((r) => r.json());\n guardados = Number(\n (insM.data && insM.data[0] && insM.data[0].values &&\n insM.data[0].values[0] && insM.data[0].values[0].value) || 0,\n );\n } catch (e) {}\n if (new Date(m.timestamp).getTime() > limiteSemana) {\n igPostsSemana++;\n igInteraccionesSemana += Number(m.like_count || 0) + Number(m.comments_count || 0);\n }\n let formato = \"Est\\u00e1tico\";\n if (m.media_type === \"VIDEO\") formato = \"Video / Reel\";\n else if (m.media_type === \"CAROUSEL_ALBUM\") formato = \"Carrusel\";\n publicaciones.push({\n net: \"ig\",\n likes: Number(m.like_count || 0),\n title: (m.caption || \"Publicacion de Instagram\").slice(0, 70),\n thumb: m.thumbnail_url || m.media_url || \"\",\n link: m.permalink || \"\",\n meta: formato + \" \\u00b7 \" + fecha(m.timestamp) + \" \\u00b7 \" +\n guardados + \" guardados \\u00b7 \" +\n Number(m.comments_count || 0) + \" comentarios\",\n });\n }\n }\n } catch (e) {}\n\n const igEngagement = igSeg > 0 && igPostsSemana > 0\n ? Math.round((igInteraccionesSemana / igPostsSemana) / igSeg * 1000) / 10\n : 0;\n client.kpis.instagram.posts = igPostsSemana;\n client.kpis.instagram.engagement = igEngagement;\n client.kpis.instagram.engagementDelta = delta(prevIg.engagement || 0, igEngagement);\n client.kpis.instagram.reach = igInteraccionesSemana;\n client.kpis.instagram.reachDelta = delta(prevIg.reach || 0, igInteraccionesSemana);\n }\n\n const porRed: Record = {};\n for (const pub of publicaciones) {\n (porRed[pub.net] = porRed[pub.net] || []).push(pub);\n }\n let finales: any[] = [];\n for (const arr of Object.values(porRed)) {\n arr.sort((a, b) => b.likes - a.likes);\n finales = finales.concat(arr.slice(0, 8));\n }\n finales.sort((a, b) => b.likes - a.likes);\n client.posts = finales.map((x, i, arr) => ({\n net: x.net,\n title: x.title,\n meta: x.meta,\n thumb: x.thumb,\n link: x.link,\n metric: String(x.likes),\n label: \"me gusta\",\n flag: i === 0\n ? \"rep\"\n : (i === arr.length - 1 && arr.length > 3 ? \"des\" : \"adj\"),\n }));\n\n client.comments = comentarios.slice(0, 8).concat(\n (client.comments || []).filter((c: any) =>\n c.net !== \"fb\" && c.net !== \"ig\"\n ),\n );\n }\n\n data.meta = Object.assign({}, data.meta, {\n actualizado: \"actualizado \" + new Date().toLocaleString(\"es-CO\", {\n timeZone: \"America/Bogota\",\n day: \"numeric\",\n month: \"long\",\n hour: \"2-digit\",\n minute: \"2-digit\",\n }),\n });\n await blob.setJSON(BLOB_KEY, data);\n console.log(\n \"Snapshot actualizado con Meta v5: \" + ((pages.data || []).length) +\n \" paginas\",\n );\n}",[174],"836c5485-0de9-492e-a600-02e1155bdd30","cron-ia.ts","0a28f3da-7f00-11f1-b686-1607ee4eb77e",59,["D",1783978210503],5,"import { blob } from \"https://esm.town/v/std/blob\"; const COMUN=\"Eres un community manager experto que responde comentarios en redes. Reglas: si el comentario trae un nombre, saluda por su nombre; agradece brevemente; tono humano y cálido, nunca robótico; máximo 1-2 emojis y solo si encaja; NUNCA des asesoría legal o financiera puntual ni pidas datos sensibles en público, invita a escribir por privado o a agendar; responde SIEMPRE en el mismo idioma del comentario; máximo 3 frases.\"; const VOZ={\"pg1027190790483021\":\"Núcleo Pensional — asesoría en pensiones (Colombia). Cercano, tranquilizador y experto; claro sin tecnicismos; empatiza con la frustración de los trámites; nunca prometas resultados ni montos; invita a agendar asesoría o WhatsApp.\",\"pg939798619227286\":\"Abogado Fiduciario — derecho fiduciario. Profesional, confiable y preciso; explica en simple; invita a agendar consulta.\",\"pg1399018606896783\":\"Grúas Cono Sur — grúas y traslados (Chile). Práctico, rápido y servicial; español chileno neutro; transmite disponibilidad; pide ubicación por privado; CTA WhatsApp o teléfono 24h.\",\"pg286258314796413\":\"Michael Brooks - Jiménez P.C. — bufete en EE.UU. (inmigración y lesiones personales, Oklahoma). Profesional y empático; BILINGÜE: responde en inglés o español según el idioma del comentario; ofrece consulta gratuita; nada de asesoría legal específica en público.\",\"pg104181501157043\":\"Suárez & Gómez Abogados — bufete bogotano, 20+ años (fiduciario, corporativo, tributario, litigios, inmobiliario, sucesoral), clientes corporativos. Serio, elegante y de alto nivel; trata de USTED, formal pero cercano; orientado a soluciones; valida la inquietud con empatía breve; refuerza experiencia sin arrogancia; para casos específicos invita a privado o a agendar.\",\"pg110246487208178\":\"PienSAS Inversiones — firma bogotana de estructuración financiera y fiduciaria, 15+ años (estructuración financiera, propiedad fraccionada, selección de fiduciarias). Formal pero cercano (USTED), técnico-financiero pero accesible, autoridad tranquila; discreción y prudencia: no prometas resultados ni des asesoría puntual; invita a contacto directo.\",\"fiduciario\":\"Café Fiduciario — canal de YouTube de divulgación financiera/fiduciaria, cercano y didáctico. Cálido, conversacional y educativo; agradece la interacción; invita a ver más videos, suscribirse o dejar dudas; sin asesoría puntual.\"}; const TAGS=[\"complaint\",\"lead\",\"question\",\"praise\"]; function ckey(cid,c){return cid+\"|\"+((c.author||\"\")+\"|\"+(c.text||\"\")).slice(0,90);} async function claude(voz,coms){ const res=await fetch(\"https://api.anthropic.com/v1/messages\",{method:\"POST\",headers:{\"x-api-key\":Deno.env.get(\"ANTHROPIC_API_KEY\"),\"anthropic-version\":\"2023-06-01\",\"content-type\":\"application/json\"},body:JSON.stringify({model:\"claude-haiku-4-5-20251001\",max_tokens:2000,system:COMUN+\" Voz de marca de este cliente: \"+voz+\" Devuelve SOLO un array JSON válido (sin markdown ni texto extra), un objeto por comentario en el MISMO orden recibido; cada objeto con dos campos: tag (uno de: complaint, lead, question, praise) y reply (string con la respuesta sugerida).\",messages:[{role:\"user\",content:\"Comentarios en JSON: \"+JSON.stringify(coms.map((c,i)=>({i,post:c.post,autor:c.author,texto:c.text})))}]})}).then(r=>r.json()); if(res.error) throw new Error(res.error.message||JSON.stringify(res.error)); const txt=(res.content&&res.content[0]&&res.content[0].text)||\"[]\"; const a=txt.indexOf(\"[\"); const b=txt.lastIndexOf(\"]\"); return JSON.parse(a>=0&&b>a?txt.slice(a,b+1):\"[]\"); } export default async function(req){ const isHttp=req&&typeof req.url===\"string\"; if(isHttp){const u=new URL(req.url);if(u.searchParams.get(\"t\")!==\"kd26\")return new Response(\"no\",{status:401});} const data=await blob.getJSON(\"kimital-panel-data\"); if(!data||!data.clients)return isHttp?Response.json({error:\"sin_data\"}):undefined; const cache=(await blob.getJSON(\"ia-cache\"))||{}; const resumen=[]; for(const c of data.clients){ const voz=VOZ[c.id]; const coms=c.comments||[]; if(!voz||!coms.length)continue; const pend=coms.filter(cm=>!cache[ckey(c.id,cm)]); if(pend.length){ try{ const arr=await claude(voz,pend); pend.forEach((cm,i)=>{const r=arr[i]||{}; const tag=TAGS.includes(r.tag)?r.tag:\"question\"; cache[ckey(c.id,cm)]={tag,reply:(r.reply||cm.reply||\"\").trim()};}); }catch(e){ resumen.push({cliente:c.name,error:String(e)}); continue; } } coms.forEach(cm=>{const hit=cache[ckey(c.id,cm)]; if(hit){cm.tag=hit.tag; cm.reply=hit.reply; cm.ia=true;}}); resumen.push({cliente:c.name,comentarios:coms.length,nuevos:pend.length}); } await blob.setJSON(\"ia-cache\",cache); await blob.setJSON(\"kimital-panel-data\",data); console.log(\"ia ok \"+JSON.stringify(resumen)); return isHttp?Response.json({ok:true,resumen}):undefined; }",[182],"aa5356cc-6c21-4371-814d-0b8780488630",["D",1783984625725],12,[28],"047bcefc-f411-46c1-ba70-ba08c4e51a25","cron-ads.ts","8b7c4af4-7cda-11f1-9f35-1607ee4eb77e",36,["D",1783953358417],"// KIMITAL - PANEL - Cron de Pauta Meta v4: resultado segun OBJETIVO de campaña\n// Cada campaña muestra su resultado correcto: Tráfico→clics, Mensajería→\n// conversaciones, Leads→leads, Ventas→compras, Reconocimiento→impresiones.\n// Histórico por rangos (hoy/7/30/90) + serie diaria de 90 días.\n\nimport { blob } from \"https://esm.town/v/std/blob\";\n\nconst BLOB_KEY = \"kimital-panel-data\";\nconst G = \"https://graph.facebook.com/v21.0/\";\n\nconst ADS_MAP: Record = {\n \"act_3957845571176141\": \"pg1027190790483021\",\n \"act_625571338950348\": \"pg939798619227286\",\n \"act_2154091718767545\": \"pg939798619227286\",\n \"act_2312380362489680\": \"pg110246487208178\",\n \"act_490763122931026\": \"pg1399018606896783\",\n \"act_971543805830773\": \"pg1399018606896783\",\n \"act_217576387492184\": \"pg286258314796413\",\n};\n\nconst RANGOS: Array<[string, string]> = [\n [\"hoy\", \"today\"],\n [\"7\", \"last_7d\"],\n [\"30\", \"last_30d\"],\n [\"90\", \"last_90d\"],\n];\n\nconst ESTADOS: Record = {\n ACTIVE: \"Activa\",\n PAUSED: \"Pausada\",\n CAMPAIGN_PAUSED: \"Pausada\",\n ARCHIVED: \"Archivada\",\n DELETED: \"Eliminada\",\n IN_PROCESS: \"En proceso\",\n WITH_ISSUES: \"Con problemas\",\n PENDING_REVIEW: \"En revision\",\n};\n\nconst MESES = [\n \"ene\",\n \"feb\",\n \"mar\",\n \"abr\",\n \"may\",\n \"jun\",\n \"jul\",\n \"ago\",\n \"sep\",\n \"oct\",\n \"nov\",\n \"dic\",\n];\nfunction dinero(n: number, moneda: string) {\n return \"$\" + Math.round(n).toLocaleString(\"es-CO\") +\n (moneda === \"COP\" ? \"\" : \" \" + moneda);\n}\nfunction etiquetaDia(iso: string) {\n const p = iso.split(\"-\");\n return Number(p[2]) + \" \" + MESES[Number(p[1]) - 1];\n}\n\nfunction resultadoDe(objetivo: string, actions: any[], impresiones: number) {\n const m: Record = {};\n for (const a of actions || []) m[a.action_type] = Number(a.value || 0);\n const get = (...ks: string[]) => {\n for (const k of ks) if (m[k]) return m[k];\n return 0;\n };\n const conv = () =>\n get(\n \"onsite_conversion.total_messaging_connection\",\n \"onsite_conversion.messaging_conversation_started_7d\",\n \"onsite_conversion.messaging_first_reply\",\n \"onsite_conversion.messaging_conversation_replied_7d\",\n );\n const leads = () =>\n get(\n \"onsite_conversion.lead_grouped\",\n \"lead\",\n \"onsite_web_lead\",\n \"offsite_complete_registration_add_meta_leads\",\n );\n switch (objetivo) {\n case \"OUTCOME_LEADS\":\n if (leads()) return { resultados: leads(), tipo: \"leads\" };\n if (conv()) return { resultados: conv(), tipo: \"conversaciones\" };\n return { resultados: get(\"link_click\"), tipo: \"clics\" };\n case \"OUTCOME_SALES\": {\n const c = get(\n \"purchase\",\n \"onsite_conversion.purchase\",\n \"offsite_conversion.fb_pixel_purchase\",\n );\n if (c) return { resultados: c, tipo: \"compras\" };\n if (conv()) return { resultados: conv(), tipo: \"conversaciones\" };\n if (leads()) return { resultados: leads(), tipo: \"leads\" };\n return { resultados: get(\"link_click\"), tipo: \"clics\" };\n }\n case \"OUTCOME_TRAFFIC\":\n return { resultados: get(\"link_click\"), tipo: \"clics\" };\n case \"OUTCOME_AWARENESS\":\n case \"OUTCOME_REACH\":\n if (impresiones) return { resultados: impresiones, tipo: \"impresiones\" };\n return {\n resultados: get(\"post_engagement\", \"post_interaction_gross\"),\n tipo: \"interacciones\",\n };\n case \"OUTCOME_ENGAGEMENT\":\n if (conv()) return { resultados: conv(), tipo: \"conversaciones\" };\n if (leads()) return { resultados: leads(), tipo: \"leads\" };\n return {\n resultados: get(\n \"post_engagement\",\n \"post_interaction_gross\",\n \"link_click\",\n ),\n tipo: \"interacciones\",\n };\n default:\n if (conv()) return { resultados: conv(), tipo: \"conversaciones\" };\n if (leads()) return { resultados: leads(), tipo: \"leads\" };\n return { resultados: get(\"link_click\"), tipo: \"clics\" };\n }\n}\n\nasync function insights(\n actId: string,\n level: string,\n preset: string,\n T: string,\n) {\n const url = G + actId + \"/insights?level=\" + level +\n \"&fields=campaign_id,campaign_name,ad_name,spend,impressions,clicks,ctr,actions\" +\n \"&date_preset=\" + preset + \"&limit=300&access_token=\" + T;\n return await fetch(url).then((r) => r.json());\n}\n\nexport default async function () {\n const T = Deno.env.get(\"META_KEY\");\n if (!T) {\n console.log(\"Falta META_KEY\");\n return;\n }\n const data = (await blob.getJSON(BLOB_KEY)) as any;\n if (!data || !Array.isArray(data.clients)) {\n console.log(\"Sin snapshot\");\n return;\n }\n\n const acc: Record = {};\n\n for (const [actId, clientId] of Object.entries(ADS_MAP)) {\n try {\n const info = await fetch(G + actId + \"?fields=currency&access_token=\" + T)\n .then((r) => r.json());\n const moneda = info.currency || \"COP\";\n const camps = await fetch(\n G + actId +\n \"/campaigns?fields=name,objective,effective_status&limit=100&access_token=\" +\n T,\n ).then((r) => r.json());\n const estados: Record = {};\n const objetivos: Record = {};\n for (const c of camps.data || []) {\n estados[c.id] = c.effective_status;\n objetivos[c.id] = c.objective || \"\";\n }\n\n if (!acc[clientId]) acc[clientId] = { moneda, serie: {}, rangos: {} };\n const A = acc[clientId];\n\n const serie = await fetch(\n G + actId +\n \"/insights?fields=spend&time_increment=1&date_preset=last_90d&limit=100&access_token=\" +\n T,\n ).then((r) => r.json());\n for (const s of serie.data || []) {\n A.serie[s.date_start] = (A.serie[s.date_start] || 0) +\n Number(s.spend || 0);\n }\n\n for (const [rk, preset] of RANGOS) {\n if (!A.rangos[rk]) {\n A.rangos[rk] = {\n vistos: {},\n camps: [],\n inv: 0,\n res: 0,\n clicks: 0,\n impr: 0,\n activas: 0,\n };\n }\n const R = A.rangos[rk];\n const insC = await insights(actId, \"campaign\", preset, T);\n const insA = await insights(actId, \"ad\", preset, T);\n const adsByCamp: Record = {};\n for (const row of insA.data || []) {\n (adsByCamp[row.campaign_id] = adsByCamp[row.campaign_id] || []).push(\n row,\n );\n }\n for (const row of insC.data || []) {\n const gasto = Number(row.spend || 0);\n const obj = objetivos[row.campaign_id] || \"\";\n const r = resultadoDe(obj, row.actions, Number(row.impressions || 0));\n if (gasto === 0 && r.resultados === 0) continue;\n if (R.vistos[row.campaign_id]) continue;\n R.vistos[row.campaign_id] = 1;\n const activa = estados[row.campaign_id] === \"ACTIVE\";\n R.camps.push({\n nombre: row.campaign_name,\n estado: ESTADOS[estados[row.campaign_id]] || \"Finalizada\",\n activa,\n inversion: dinero(gasto, moneda),\n gasto,\n resultados: r.resultados,\n resultadoTipo: r.tipo,\n costo: r.resultados\n ? dinero(gasto / r.resultados, moneda)\n : \"\\u2014\",\n ctr: Number(row.ctr || 0).toFixed(2),\n anuncios: (adsByCamp[row.campaign_id] || []).map((a) => {\n const ra = resultadoDe(\n obj,\n a.actions,\n Number(a.impressions || 0),\n );\n const ga = Number(a.spend || 0);\n return {\n nombre: a.ad_name,\n inversion: dinero(ga, moneda),\n resultados: ra.resultados,\n resultadoTipo: ra.tipo,\n costo: ra.resultados\n ? dinero(ga / ra.resultados, moneda)\n : \"\\u2014\",\n ctr: Number(a.ctr || 0).toFixed(2),\n };\n }).filter((a) =>\n a.resultados > 0 || a.inversion !== dinero(0, moneda)\n ).sort((x, y) => y.resultados - x.resultados).slice(0, 6),\n });\n R.inv += gasto;\n R.res += r.resultados;\n R.clicks += Number(row.clicks || 0);\n R.impr += Number(row.impressions || 0);\n if (activa) R.activas++;\n }\n }\n } catch (e) {\n console.log(\"Error \" + actId + \": \" + e);\n }\n }\n\n let conAds = 0;\n for (const c of data.clients) {\n const A = acc[c.id];\n if (A && A.rangos[\"30\"]) {\n const rangos: Record = {};\n let tieneAlgo = false;\n for (const [rk] of RANGOS) {\n const R = A.rangos[rk] ||\n { camps: [], inv: 0, res: 0, clicks: 0, impr: 0, activas: 0 };\n R.camps.sort((x: any, y: any) =>\n (y.activa ? 1 : 0) - (x.activa ? 1 : 0) || y.gasto - x.gasto\n );\n if (R.camps.length) tieneAlgo = true;\n rangos[rk] = {\n ads: R.camps,\n resumen: {\n inversion: dinero(R.inv, A.moneda),\n resultados: R.res,\n ctr: R.impr ? (R.clicks / R.impr * 100).toFixed(2) : \"0\",\n activas: R.activas,\n campanas: R.camps.length,\n moneda: A.moneda,\n },\n };\n }\n if (tieneAlgo) {\n c.adsRangos = rangos;\n c.adsSerie90 = Object.keys(A.serie).sort().map((d) => ({\n d: etiquetaDia(d),\n v: Math.round(A.serie[d]),\n }));\n c.ads = rangos[\"30\"].ads;\n c.adsResumen = rangos[\"30\"].resumen;\n c.adsSerie = c.adsSerie90.slice(-30);\n conAds++;\n }\n }\n }\n await blob.setJSON(BLOB_KEY, data);\n console.log(\"Pauta v4 actualizada: \" + conAds + \" clientes\");\n}",[194],"pulls","branches",1,"forks","envVars",{"_208":170,"_210":63},"connections",{"_208":63,"_209":63},"count","unfilledCount","emptyCount",{"_43":193,"_32":194,"_30":195,"_141":-5,"_41":42,"_40":196,"_143":25,"_38":241,"_13":161,"_33":37,"_35":198,"_24":25,"_148":-5,"_220":242,"_27":243},{"_43":189,"_32":28,"_30":31,"_141":-5,"_41":42,"_40":14,"_143":25,"_38":238,"_13":191,"_33":37,"_35":36,"_24":25,"_148":-5,"_220":239,"_27":240},{"_43":181,"_32":182,"_30":183,"_141":-5,"_41":42,"_40":184,"_143":25,"_38":235,"_13":186,"_33":37,"_35":187,"_24":25,"_148":-5,"_220":236,"_27":237},{"_43":173,"_32":174,"_30":175,"_141":-5,"_41":42,"_40":176,"_143":25,"_38":232,"_13":178,"_33":37,"_35":179,"_24":25,"_148":-5,"_220":233,"_27":234},{"_43":165,"_32":166,"_30":167,"_141":-5,"_41":42,"_40":168,"_143":25,"_38":229,"_13":170,"_33":37,"_35":171,"_24":25,"_148":-5,"_220":230,"_27":231},{"_43":158,"_32":159,"_30":160,"_141":-5,"_41":42,"_40":161,"_143":25,"_38":226,"_13":153,"_33":37,"_35":163,"_24":25,"_148":-5,"_220":227,"_27":228},{"_43":150,"_32":151,"_30":152,"_141":-5,"_41":42,"_40":153,"_143":59,"_38":223,"_13":155,"_33":146,"_35":156,"_24":25,"_148":-5,"_220":224,"_27":225},{"_43":138,"_32":139,"_30":140,"_141":-5,"_41":42,"_40":142,"_143":25,"_38":219,"_13":145,"_33":146,"_35":147,"_24":25,"_148":-5,"_220":221,"_27":222},["D",1783981414685],"children",[],[139],["D",1783733966306],[],[151],["D",1783735299867],[],[159],["D",1783976013205],[],[166],["D",1783982093039],[],[174],["D",1783978210503],[],[182],["D",1783984625725],[],[28],["D",1783953358417],[],[194],["D",1783733917279],["D",1789512647429],{"_100":99,"_108":104},{"_100":99,"_101":102,"_103":104,"_18":55,"_105":106,"_107":25},{"_13":89,"_32":90,"_43":42,"_91":44,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":45,"_98":99},"ctx",{"_82":-5,"_127":282,"_283":284,"_285":286,"_287":25,"_288":25,"_289":25,"_290":59,"_291":-5,"_292":-7,"_293":-7,"_294":63,"_295":25,"_296":25,"_297":-5,"_298":25,"_299":25,"_300":25,"_301":-5},"ENV",{"_253":254,"_255":256,"_257":90,"_258":259,"_260":261,"_262":263,"_264":265,"_266":267,"_268":269,"_270":271,"_272":273,"_274":275,"_276":277,"_278":279,"_280":281},"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 · v88