[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_224":225,"_226":227},"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",49,"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-web.ts","latestPath","fileId","3c2c71f6-7ef4-11f1-92da-1607ee4eb77e","name","fileType","http","content","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;}","script","createdAt",["D",1783974046418],"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":219,"_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":220,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":221,"_84":222,"_86":223,"_88":25},"tree",[194,195,196,197,198,199],"files",[194,195,196,197,198,199],"counts",{"_182":63,"_183":184,"_185":63,"_186":187,"_188":189},"contents",[130,131,132,133,134,135],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":175,"_32":176,"_30":177,"_139":-5,"_41":42,"_40":178,"_141":25,"_38":179,"_13":158,"_33":160,"_35":180,"_24":25,"_145":-5,"_27":181},{"_43":167,"_32":168,"_30":169,"_139":-5,"_41":42,"_40":170,"_141":25,"_38":171,"_13":172,"_33":160,"_35":173,"_24":25,"_145":-5,"_27":174},{"_43":163,"_32":28,"_30":31,"_139":-5,"_41":42,"_40":14,"_141":25,"_38":164,"_13":165,"_33":37,"_35":36,"_24":25,"_145":-5,"_27":166},{"_43":155,"_32":156,"_30":157,"_139":-5,"_41":42,"_40":158,"_141":25,"_38":159,"_13":150,"_33":160,"_35":161,"_24":25,"_145":-5,"_27":162},{"_43":147,"_32":148,"_30":149,"_139":-5,"_41":42,"_40":150,"_141":59,"_38":151,"_13":152,"_33":34,"_35":153,"_24":25,"_145":-5,"_27":154},{"_43":136,"_32":137,"_30":138,"_139":-5,"_41":42,"_40":140,"_141":25,"_38":142,"_13":143,"_33":34,"_35":144,"_24":25,"_145":-5,"_27":146},"c699515c-aba2-40cf-beb6-1a2b06ce55ce","test-meta.ts","7f72a292-7cd2-11f1-8891-1607ee4eb77e","parentId",46,"latest",["D",1783973584462],14,"import { blob } from \"https://esm.town/v/std/blob\"; const TOK=\"kd26\"; export default async function(req){ if(new URL(req.url).searchParams.get(\"t\")!==TOK) return new Response(\"no\",{status:401}); const data=await blob.getJSON(\"kimital-panel-data\"); const clients=(data?.clients||[]).map(c=>({id:c.id,name:c.name,web:c.web?{ga4:c.web.ga4?{usuarios:c.web.ga4.usuarios,sesiones:c.web.ga4.sesiones,vistas:c.web.ga4.vistas,err:c.web.ga4.err||null}:(c.web.ga4err||null),gsc:c.web.gsc?{clicks:c.web.gsc.clicks,impresiones:c.web.gsc.impresiones,doms:(c.web.gsc.dominios||[]).length}:null}:null})); return Response.json({clients}); }","label",[137],"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}",[148],"f86753e8-509c-4d86-b3e9-994d78cd4df0","cron-youtube.ts","4cc7f08c-7ccc-11f1-b774-1607ee4eb77e",7,["D",1783735299867],"interval","// 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}",[156],"07c309f4-35d1-43a3-92d1-5b86ecd0c40f",["D",1783974046418],5,[28],"9f21936f-3150-4404-8f6c-6c2fcf7e6e4f","cron-meta.ts","b5827596-7cd3-11f1-b80c-1607ee4eb77e",35,["D",1783953168690],10,"// 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;\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 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 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 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 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 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\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}",[168],"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}",[176],"pulls","branches",1,"forks","envVars",{"_190":192,"_193":63},"connections",{"_190":63,"_191":63},"count","unfilledCount",8,"emptyCount",{"_43":175,"_32":176,"_30":177,"_139":-5,"_41":42,"_40":178,"_141":25,"_38":216,"_13":158,"_33":160,"_35":180,"_24":25,"_145":-5,"_201":217,"_27":218},{"_43":167,"_32":168,"_30":169,"_139":-5,"_41":42,"_40":170,"_141":25,"_38":213,"_13":172,"_33":160,"_35":173,"_24":25,"_145":-5,"_201":214,"_27":215},{"_43":163,"_32":28,"_30":31,"_139":-5,"_41":42,"_40":14,"_141":25,"_38":210,"_13":165,"_33":37,"_35":36,"_24":25,"_145":-5,"_201":211,"_27":212},{"_43":155,"_32":156,"_30":157,"_139":-5,"_41":42,"_40":158,"_141":25,"_38":207,"_13":150,"_33":160,"_35":161,"_24":25,"_145":-5,"_201":208,"_27":209},{"_43":147,"_32":148,"_30":149,"_139":-5,"_41":42,"_40":150,"_141":59,"_38":204,"_13":152,"_33":34,"_35":153,"_24":25,"_145":-5,"_201":205,"_27":206},{"_43":136,"_32":137,"_30":138,"_139":-5,"_41":42,"_40":140,"_141":25,"_38":200,"_13":143,"_33":34,"_35":144,"_24":25,"_145":-5,"_201":202,"_27":203},["D",1783973584462],"children",[],[137],["D",1783733966306],[],[148],["D",1783735299867],[],[156],["D",1783974046418],[],[28],["D",1783953168690],[],[168],["D",1783953358417],[],[176],["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":257,"_258":259,"_260":261,"_262":25,"_263":25,"_264":25,"_265":59,"_266":-5,"_267":-7,"_268":-7,"_269":63,"_270":25,"_271":25,"_272":-5,"_273":25,"_274":25,"_275":25,"_276":-5},"ENV",{"_228":229,"_230":231,"_232":90,"_233":234,"_235":236,"_237":238,"_239":240,"_241":242,"_243":244,"_245":246,"_247":248,"_249":250,"_251":252,"_253":254,"_255":256},"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 · v49