[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_223":224,"_225":226},"routes/_app.x.$handle.$name",{"_99":98,"_32":45,"_108":89,"_27":36,"_13":14,"_109":-5,"_11":110,"_111":112,"_113":114,"_115":116,"_117":118,"_20":-5,"_119":-5,"_120":-5,"_121":25,"_122":123,"_124":58,"_125":-5,"_126":-5,"_127":128},"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":36,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":70,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":82,"_83":84,"_85":86,"_87":25},"version",44,"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","cron-web.ts","latestPath","fileId","3c2c71f6-7ef4-11f1-92da-1607ee4eb77e","name","fileType","script","content","","import { blob } from \"https://esm.town/v/std/blob\"; 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?JSON.stringify(tot.error):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);}}web.gsc=await gsc(AT,cfg.gsc);return web;} export default async function(){const AT=await token();if(!AT){console.log(\"sin access token\");return;}const data=await blob.getJSON(\"kimital-panel-data\");if(!data||!data.clients){console.log(\"sin data\");return;}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);console.log(\"web ok\",data.clients.filter(c=>c.web).map(c=>c.name));}","createdAt",["D",1783973024656],"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",{"_99":98,"_107":103},"org",{"_99":98,"_100":101,"_102":103,"_18":54,"_104":105,"_106":25},"branch",{"_13":88,"_32":89,"_43":42,"_90":44,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":45,"_97":98},"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":218,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":36,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":219,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":220,"_83":221,"_85":222,"_87":25},"tree",[193,194,195,196,197,198],"files",[193,194,195,196,197,198],"counts",{"_181":62,"_182":183,"_184":62,"_185":186,"_187":188},"contents",[129,130,131,132,133,134],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":174,"_32":175,"_30":176,"_138":-5,"_41":42,"_40":177,"_140":25,"_38":178,"_13":158,"_33":160,"_35":179,"_24":25,"_145":-5,"_27":180},{"_43":166,"_32":167,"_30":168,"_138":-5,"_41":42,"_40":169,"_140":25,"_38":170,"_13":171,"_33":160,"_35":172,"_24":25,"_145":-5,"_27":173},{"_43":163,"_32":28,"_30":31,"_138":-5,"_41":42,"_40":14,"_140":25,"_38":164,"_13":152,"_33":34,"_35":37,"_24":25,"_145":-5,"_27":165},{"_43":155,"_32":156,"_30":157,"_138":-5,"_41":42,"_40":158,"_140":25,"_38":159,"_13":150,"_33":160,"_35":161,"_24":25,"_145":-5,"_27":162},{"_43":147,"_32":148,"_30":149,"_138":-5,"_41":42,"_40":150,"_140":58,"_38":151,"_13":152,"_33":143,"_35":153,"_24":25,"_145":-5,"_27":154},{"_43":135,"_32":136,"_30":137,"_138":-5,"_41":42,"_40":139,"_140":25,"_38":141,"_13":142,"_33":143,"_35":144,"_24":25,"_145":-5,"_27":146},"735d2a9d-7b6c-42d3-baff-42de9180da96","test-meta.ts","7f72a292-7cd2-11f1-8891-1607ee4eb77e","parentId",39,"latest",["D",1783972092577],12,"http","import { blob } from \"https://esm.town/v/std/blob\";\nconst TOK = \"kd26\";\nexport default async function (req) {\n if (new URL(req.url).searchParams.get(\"t\") !== TOK) {\n return new Response(\"no\", { status: 401 });\n }\n const keys = await blob.list();\n const data = await blob.getJSON(\"kimital-panel-data\");\n const clients = (data?.clients || []).map((c) => ({\n id: c.id,\n name: c.name,\n plataformas: c.platforms,\n keys: Object.keys(c),\n }));\n return Response.json({\n blobKeys: keys.map((k) => k.key),\n metaKeys: Object.keys(data?.meta || {}),\n clients,\n });\n}","label",[136],"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],"b552e23f-395b-4539-850e-19db1a9d8f71",["D",1783973024656],[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}",[167],"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}",[175],"pulls","branches",1,"forks","envVars",{"_189":191,"_192":62},"connections",{"_189":62,"_190":62},"count","unfilledCount",8,"emptyCount",{"_43":174,"_32":175,"_30":176,"_138":-5,"_41":42,"_40":177,"_140":25,"_38":215,"_13":158,"_33":160,"_35":179,"_24":25,"_145":-5,"_200":216,"_27":217},{"_43":166,"_32":167,"_30":168,"_138":-5,"_41":42,"_40":169,"_140":25,"_38":212,"_13":171,"_33":160,"_35":172,"_24":25,"_145":-5,"_200":213,"_27":214},{"_43":163,"_32":28,"_30":31,"_138":-5,"_41":42,"_40":14,"_140":25,"_38":209,"_13":152,"_33":34,"_35":37,"_24":25,"_145":-5,"_200":210,"_27":211},{"_43":155,"_32":156,"_30":157,"_138":-5,"_41":42,"_40":158,"_140":25,"_38":206,"_13":150,"_33":160,"_35":161,"_24":25,"_145":-5,"_200":207,"_27":208},{"_43":147,"_32":148,"_30":149,"_138":-5,"_41":42,"_40":150,"_140":58,"_38":203,"_13":152,"_33":143,"_35":153,"_24":25,"_145":-5,"_200":204,"_27":205},{"_43":135,"_32":136,"_30":137,"_138":-5,"_41":42,"_40":139,"_140":25,"_38":199,"_13":142,"_33":143,"_35":144,"_24":25,"_145":-5,"_200":201,"_27":202},["D",1783972092577],"children",[],[136],["D",1783733966306],[],[148],["D",1783735299867],[],[156],["D",1783973024656],[],[28],["D",1783953168690],[],[167],["D",1783953358417],[],[175],["D",1783733917279],["D",1789512647429],{"_99":98,"_107":103},{"_99":98,"_100":101,"_102":103,"_18":54,"_104":105,"_106":25},{"_13":88,"_32":89,"_43":42,"_90":44,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":45,"_97":98},"ctx",{"_81":-5,"_126":256,"_257":258,"_259":260,"_261":25,"_262":25,"_263":25,"_264":58,"_265":-5,"_266":-7,"_267":-7,"_268":62,"_269":25,"_270":25,"_271":-5,"_272":25,"_273":25,"_274":25,"_275":-5},"ENV",{"_227":228,"_229":230,"_231":89,"_232":233,"_234":235,"_236":237,"_238":239,"_240":241,"_242":243,"_244":245,"_246":247,"_248":249,"_250":251,"_252":253,"_254":255},"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 · v44