[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_233":234,"_235":236},"routes/_app.x.$handle.$name",{"_98":97,"_32":44,"_107":88,"_26":36,"_13":14,"_108":-5,"_11":109,"_110":111,"_112":113,"_114":115,"_116":117,"_20":-5,"_118":-5,"_119":-5,"_120":24,"_121":122,"_123":57,"_124":-5,"_125":-5,"_126":127},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_32":44,"_37":45,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":36,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":81,"_82":83,"_84":85,"_86":24},"version",41,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":29},"file",{"_30":31,"_32":27,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_23":24},"previous","deleted",false,"deletedHere","path","new-file-8070.ts","latestPath","cron-web.ts","fileId","3c2c71f6-7ef4-11f1-92da-1607ee4eb77e","name","fileType","script","content","","createdAt",["D",1783972287178],"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",{"_98":97,"_106":102},"org",{"_98":97,"_99":100,"_101":102,"_18":53,"_103":104,"_105":24},"branch",{"_13":87,"_32":88,"_42":41,"_89":43,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":44,"_96":97},"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",{"_42":43,"_32":44,"_37":228,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":36,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":229,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":230,"_82":231,"_84":232,"_86":24},"tree",[199,200,201,202,203,204,205],"files",[199,200,201,202,203,204,205],"counts",{"_187":61,"_188":189,"_190":61,"_191":192,"_193":194},"contents",[128,129,130,131,132,133,134],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":180,"_32":181,"_30":182,"_138":-5,"_40":41,"_39":183,"_140":24,"_37":184,"_13":167,"_33":169,"_35":185,"_23":24,"_145":-5,"_26":186},{"_42":172,"_32":173,"_30":174,"_138":-5,"_40":41,"_39":175,"_140":24,"_37":176,"_13":177,"_33":169,"_35":178,"_23":24,"_145":-5,"_26":179},{"_42":164,"_32":165,"_30":166,"_138":-5,"_40":41,"_39":167,"_140":24,"_37":168,"_13":159,"_33":169,"_35":170,"_23":24,"_145":-5,"_26":171},{"_42":156,"_32":157,"_30":158,"_138":-5,"_40":41,"_39":159,"_140":57,"_37":160,"_13":161,"_33":143,"_35":162,"_23":24,"_145":-5,"_26":163},{"_42":150,"_32":151,"_30":152,"_138":-5,"_40":41,"_39":153,"_140":24,"_37":154,"_13":61,"_33":34,"_35":36,"_23":24,"_145":-5,"_26":155},{"_42":147,"_32":27,"_30":31,"_138":-5,"_40":41,"_39":14,"_140":24,"_37":148,"_13":61,"_33":34,"_35":36,"_23":24,"_145":-5,"_26":149},{"_42":135,"_32":136,"_30":137,"_138":-5,"_40":41,"_39":139,"_140":24,"_37":141,"_13":142,"_33":143,"_35":144,"_23":24,"_145":-5,"_26":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],"5d2b0cf8-d6d0-41fe-8f52-8d461ebe0064",["D",1783972287178],[27],"889a4c81-ca17-4722-a0e1-e08d93833eb3","new-file-5870.ts","33f60b28-7ef4-11f1-921a-1607ee4eb77e",40,["D",1783972273397],[151],"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}",[157],"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}",[165],"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}",[173],"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}",[181],"pulls","branches",1,"forks","envVars",{"_195":197,"_198":61},"connections",{"_195":61,"_196":61},"count","unfilledCount",8,"emptyCount",{"_42":180,"_32":181,"_30":182,"_138":-5,"_40":41,"_39":183,"_140":24,"_37":225,"_13":167,"_33":169,"_35":185,"_23":24,"_145":-5,"_207":226,"_26":227},{"_42":172,"_32":173,"_30":174,"_138":-5,"_40":41,"_39":175,"_140":24,"_37":222,"_13":177,"_33":169,"_35":178,"_23":24,"_145":-5,"_207":223,"_26":224},{"_42":164,"_32":165,"_30":166,"_138":-5,"_40":41,"_39":167,"_140":24,"_37":219,"_13":159,"_33":169,"_35":170,"_23":24,"_145":-5,"_207":220,"_26":221},{"_42":156,"_32":157,"_30":158,"_138":-5,"_40":41,"_39":159,"_140":57,"_37":216,"_13":161,"_33":143,"_35":162,"_23":24,"_145":-5,"_207":217,"_26":218},{"_42":150,"_32":151,"_30":152,"_138":-5,"_40":41,"_39":153,"_140":24,"_37":213,"_13":61,"_33":34,"_35":36,"_23":24,"_145":-5,"_207":214,"_26":215},{"_42":147,"_32":27,"_30":31,"_138":-5,"_40":41,"_39":14,"_140":24,"_37":210,"_13":61,"_33":34,"_35":36,"_23":24,"_145":-5,"_207":211,"_26":212},{"_42":135,"_32":136,"_30":137,"_138":-5,"_40":41,"_39":139,"_140":24,"_37":206,"_13":142,"_33":143,"_35":144,"_23":24,"_145":-5,"_207":208,"_26":209},["D",1783972092577],"children",[],[136],["D",1783972287178],[],[27],["D",1783972273397],[],[151],["D",1783733966306],[],[157],["D",1783735299867],[],[165],["D",1783953168690],[],[173],["D",1783953358417],[],[181],["D",1783733917279],["D",1789512647429],{"_98":97,"_106":102},{"_98":97,"_99":100,"_101":102,"_18":53,"_103":104,"_105":24},{"_13":87,"_32":88,"_42":41,"_89":43,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":44,"_96":97},"ctx",{"_80":-5,"_125":266,"_267":268,"_269":270,"_271":24,"_272":24,"_273":24,"_274":57,"_275":-5,"_276":-7,"_277":-7,"_278":61,"_279":24,"_280":24,"_281":-5,"_282":24,"_283":24,"_284":24,"_285":-5},"ENV",{"_237":238,"_239":240,"_241":88,"_242":243,"_244":245,"_246":247,"_248":249,"_250":251,"_252":253,"_254":255,"_256":257,"_258":259,"_260":261,"_262":263,"_264":265},"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 · v41