[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_291":292,"_293":294},"routes/_app.x.$handle.$name",{"_106":105,"_38":51,"_115":96,"_33":59,"_13":14,"_116":-5,"_11":117,"_118":119,"_120":121,"_122":123,"_124":125,"_26":-5,"_126":-5,"_127":-5,"_128":31,"_129":130,"_131":65,"_132":-5,"_133":-5,"_134":135},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_49":50,"_38":51,"_44":52,"_53":-5,"_54":31,"_55":56,"_57":56,"_58":59,"_60":-5,"_19":61,"_62":63,"_64":65,"_66":-5,"_67":-5,"_68":69,"_70":71,"_72":73,"_74":75,"_76":77,"_78":-5,"_79":80,"_81":80,"_82":83,"_84":83,"_85":83,"_86":80,"_87":80,"_88":89,"_90":91,"_92":93,"_94":31},"version",224,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","21e1cc64-1ba3-4b89-9621-eb10024da99b","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":29,"_30":31,"_32":31,"_33":34,"_35":34},"file",{"_36":37,"_38":34,"_39":40,"_41":43,"_44":45,"_46":14,"_47":48,"_30":31},"previous",{"_36":37,"_38":34,"_39":40,"_41":42},"deleted",false,"deletedHere","path","cron-web.ts","latestPath","fileId","3c2c71f6-7ef4-11f1-92da-1607ee4eb77e","name","fileType","interval","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:\"356098814\",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 gbp(AT,cfg){const H={authorization:\"Bearer \"+AT};const metrics=[\"BUSINESS_IMPRESSIONS_DESKTOP_MAPS\",\"BUSINESS_IMPRESSIONS_DESKTOP_SEARCH\",\"BUSINESS_IMPRESSIONS_MOBILE_MAPS\",\"BUSINESS_IMPRESSIONS_MOBILE_SEARCH\",\"CALL_CLICKS\",\"WEBSITE_CLICKS\",\"BUSINESS_DIRECTION_REQUESTS\",\"BUSINESS_CONVERSATIONS\"];const end=new Date();const start=new Date();start.setUTCDate(start.getUTCDate()-30);const dq=(prefix,dt)=>`&dailyRange.${prefix}_date.year=${dt.getUTCFullYear()}&dailyRange.${prefix}_date.month=${dt.getUTCMonth()+1}&dailyRange.${prefix}_date.day=${dt.getUTCDate()}`;const qs=metrics.map(m=>`dailyMetrics=${m}`).join(\"&\")+dq(\"start\",start)+dq(\"end\",end);const url=`https://businessprofileperformance.googleapis.com/v1/locations/${cfg.locationId}:fetchMultiDailyMetricsTimeSeries?${qs}`;const res=await fetch(url,{headers:H}).then(r=>r.json());if(res.error)throw new Error(res.error.message||JSON.stringify(res.error));const series=(res.multiDailyMetricTimeSeries||[]).flatMap(g=>g.dailyMetricTimeSeries||[]);const totales={};const byDay={};for(const s of series){const metric=s.dailyMetric;totales[metric]=0;for(const dv of(s.timeSeries?.datedValues||[])){const v=Number(dv.value||0);const day=`${dv.date.year}-${String(dv.date.month).padStart(2,\"0\")}-${String(dv.date.day).padStart(2,\"0\")}`;totales[metric]+=v;byDay[day]=byDay[day]||{};byDay[day][metric]=v;}}const impTot=t=>(t.BUSINESS_IMPRESSIONS_DESKTOP_MAPS||0)+(t.BUSINESS_IMPRESSIONS_DESKTOP_SEARCH||0)+(t.BUSINESS_IMPRESSIONS_MOBILE_MAPS||0)+(t.BUSINESS_IMPRESSIONS_MOBILE_SEARCH||0);const historial=Object.keys(byDay).sort().map(day=>({d:day,impresiones:impTot(byDay[day]),llamadas:byDay[day].CALL_CLICKS||0,clics:byDay[day].WEBSITE_CLICKS||0,direcciones:byDay[day].BUSINESS_DIRECTION_REQUESTS||0}));return {impresiones:impTot(totales),llamadas:totales.CALL_CLICKS||0,clicsWeb:totales.WEBSITE_CLICKS||0,direcciones:totales.BUSINESS_DIRECTION_REQUESTS||0,conversaciones:totales.BUSINESS_CONVERSATIONS||0,historial};}\nasync function gbpResenas(AT,cfg){const H={authorization:\"Bearer \"+AT};const url=`https://mybusiness.googleapis.com/v4/accounts/${cfg.accountId}/locations/${cfg.locationId}/reviews?pageSize=20&orderBy=updateTime%20desc`;const res=await fetch(url,{headers:H}).then(r=>r.json());if(res.error)throw new Error(res.error.message||JSON.stringify(res.error));return (res.reviews||[]).map(r=>({autor:r.reviewer?.displayName||\"Usuario de Google\",texto:r.comment||\"\",estrellas:({ONE:1,TWO:2,THREE:3,FOUR:4,FIVE:5})[r.starRating]||null,ts:r.createTime?Math.floor(new Date(r.createTime).getTime()/1000):0,respondido:!!r.reviewReply,reviewName:r.name||null}));}\nasync 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);}if(cfg.gbp){try{web.gbp=await gbp(AT,cfg.gbp);}catch(e){web.gbperr=String(e);}try{web.gbpResenas=await gbpResenas(AT,cfg.gbp);}catch(e){web.gbpResenasErr=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;}","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:\"356098814\",gsc:[\"sc-domain:brooksjimenez.com\",\"sc-domain:immigrationrunners.com\",\"sc-domain:golpesoklahoma.com\"],gbp:{locationId:\"6454125958639525080\"}}}; 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 gbp(AT,cfg){const H={authorization:\"Bearer \"+AT};const metrics=[\"BUSINESS_IMPRESSIONS_DESKTOP_MAPS\",\"BUSINESS_IMPRESSIONS_DESKTOP_SEARCH\",\"BUSINESS_IMPRESSIONS_MOBILE_MAPS\",\"BUSINESS_IMPRESSIONS_MOBILE_SEARCH\",\"CALL_CLICKS\",\"WEBSITE_CLICKS\",\"BUSINESS_DIRECTION_REQUESTS\",\"BUSINESS_CONVERSATIONS\"];const end=new Date();const start=new Date();start.setUTCDate(start.getUTCDate()-30);const dq=(prefix,dt)=>`&dailyRange.${prefix}_date.year=${dt.getUTCFullYear()}&dailyRange.${prefix}_date.month=${dt.getUTCMonth()+1}&dailyRange.${prefix}_date.day=${dt.getUTCDate()}`;const qs=metrics.map(m=>`dailyMetrics=${m}`).join(\"&\")+dq(\"start\",start)+dq(\"end\",end);const url=`https://businessprofileperformance.googleapis.com/v1/locations/${cfg.locationId}:fetchMultiDailyMetricsTimeSeries?${qs}`;const res=await fetch(url,{headers:H}).then(r=>r.json());if(res.error)throw new Error(res.error.message||JSON.stringify(res.error));const series=(res.multiDailyMetricTimeSeries||[]).flatMap(g=>g.dailyMetricTimeSeries||[]);const totales={};const byDay={};for(const s of series){const metric=s.dailyMetric;totales[metric]=0;for(const dv of(s.timeSeries?.datedValues||[])){const v=Number(dv.value||0);const day=`${dv.date.year}-${String(dv.date.month).padStart(2,\"0\")}-${String(dv.date.day).padStart(2,\"0\")}`;totales[metric]+=v;byDay[day]=byDay[day]||{};byDay[day][metric]=v;}}const impTot=t=>(t.BUSINESS_IMPRESSIONS_DESKTOP_MAPS||0)+(t.BUSINESS_IMPRESSIONS_DESKTOP_SEARCH||0)+(t.BUSINESS_IMPRESSIONS_MOBILE_MAPS||0)+(t.BUSINESS_IMPRESSIONS_MOBILE_SEARCH||0);const historial=Object.keys(byDay).sort().map(day=>({d:day,impresiones:impTot(byDay[day]),llamadas:byDay[day].CALL_CLICKS||0,clics:byDay[day].WEBSITE_CLICKS||0,direcciones:byDay[day].BUSINESS_DIRECTION_REQUESTS||0}));return {impresiones:impTot(totales),llamadas:totales.CALL_CLICKS||0,clicsWeb:totales.WEBSITE_CLICKS||0,direcciones:totales.BUSINESS_DIRECTION_REQUESTS||0,conversaciones:totales.BUSINESS_CONVERSATIONS||0,historial};}\nasync function gbpResenas(AT,cfg){const H={authorization:\"Bearer \"+AT};const url=`https://mybusiness.googleapis.com/v4/accounts/${cfg.accountId}/locations/${cfg.locationId}/reviews?pageSize=20&orderBy=updateTime%20desc`;const res=await fetch(url,{headers:H}).then(r=>r.json());if(res.error)throw new Error(res.error.message||JSON.stringify(res.error));return (res.reviews||[]).map(r=>({autor:r.reviewer?.displayName||\"Usuario de Google\",texto:r.comment||\"\",estrellas:({ONE:1,TWO:2,THREE:3,FOUR:4,FIVE:5})[r.starRating]||null,ts:r.createTime?Math.floor(new Date(r.createTime).getTime()/1000):0,respondido:!!r.reviewReply,reviewName:r.name||null}));}\nasync 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);}if(cfg.gbp){try{web.gbp=await gbp(AT,cfg.gbp);}catch(e){web.gbperr=String(e);}try{web.gbpResenas=await gbpResenas(AT,cfg.gbp);}catch(e){web.gbpResenasErr=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;}","createdAt",["D",1789405872280],"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",{"_106":105,"_114":110},"org",{"_106":105,"_107":108,"_109":110,"_19":61,"_111":112,"_113":31},"branch",{"_13":95,"_38":96,"_49":48,"_97":50,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":-5,"_103":51,"_104":105},"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",{"_49":50,"_38":51,"_44":286,"_53":-5,"_54":31,"_55":56,"_57":56,"_58":59,"_60":-5,"_19":61,"_62":63,"_64":65,"_66":-5,"_67":-5,"_68":69,"_70":71,"_72":73,"_74":75,"_76":287,"_78":-5,"_79":80,"_81":80,"_82":83,"_84":83,"_85":83,"_86":80,"_87":80,"_88":288,"_90":289,"_92":290,"_94":31},"tree",[241,242,243,244,245,246,247,248,249,250,251],"files",[241,242,243,244,245,246,247,248,249,250,251],"counts",{"_230":69,"_231":162,"_232":69,"_233":234,"_235":236},"contents",[136,137,138,139,140,141,142,143,144,145,146],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_49":223,"_38":224,"_36":225,"_149":-5,"_47":48,"_46":226,"_151":65,"_44":227,"_13":220,"_39":40,"_41":228,"_30":31,"_155":-5,"_33":229},{"_49":215,"_38":216,"_36":217,"_149":-5,"_47":48,"_46":218,"_151":65,"_44":219,"_13":220,"_39":40,"_41":221,"_30":31,"_155":-5,"_33":222},{"_49":207,"_38":208,"_36":209,"_149":-5,"_47":48,"_46":210,"_151":65,"_44":211,"_13":212,"_39":40,"_41":213,"_30":31,"_155":-5,"_33":214},{"_49":199,"_38":200,"_36":201,"_149":-5,"_47":48,"_46":202,"_151":65,"_44":203,"_13":204,"_39":40,"_41":205,"_30":31,"_155":-5,"_33":206},{"_49":192,"_38":193,"_36":194,"_149":-5,"_47":48,"_46":195,"_151":65,"_44":196,"_13":69,"_39":40,"_41":197,"_30":31,"_155":-5,"_33":198},{"_49":188,"_38":34,"_36":37,"_149":-5,"_47":48,"_46":14,"_151":31,"_44":189,"_13":190,"_39":40,"_41":43,"_30":31,"_155":-5,"_33":191},{"_49":180,"_38":181,"_36":182,"_149":-5,"_47":48,"_46":183,"_151":65,"_44":184,"_13":185,"_39":40,"_41":186,"_30":31,"_155":-5,"_33":187},{"_49":173,"_38":174,"_36":175,"_149":-5,"_47":48,"_46":176,"_151":65,"_44":177,"_13":69,"_39":153,"_41":178,"_30":31,"_155":-5,"_33":179},{"_49":165,"_38":166,"_36":167,"_149":-5,"_47":48,"_46":168,"_151":65,"_44":169,"_13":170,"_39":153,"_41":171,"_30":31,"_155":-5,"_33":172},{"_49":157,"_38":158,"_36":159,"_149":-5,"_47":48,"_46":160,"_151":65,"_44":161,"_13":162,"_39":153,"_41":163,"_30":31,"_155":-5,"_33":164},{"_49":147,"_38":148,"_36":63,"_149":-5,"_47":48,"_46":150,"_151":65,"_44":152,"_13":69,"_39":153,"_41":154,"_30":31,"_155":-5,"_33":156},"85ee42d1-0143-411e-813d-48191b28705d","tiktok-ia.ts","parentId",166,"latest",["D",1786509236926],"http","const SECRET = \"kimgsync_bb92a1e6f2c14a7db0e56d3f8ac5017e2c9d4471\";\n\nconst TAGS = [\"lead\", \"question\", \"complaint\", \"praise\"];\nconst SENTIMIENTOS = [\"positivo\", \"negativo\", \"neutral\"];\n\nfunction parseArray(txt: string): any[] {\n try {\n const a = txt.indexOf(\"[\");\n const b = txt.lastIndexOf(\"]\");\n if (a >= 0 && b > a) return JSON.parse(txt.slice(a, b + 1));\n return JSON.parse(txt);\n } catch {\n return [];\n }\n}\n\nasync function clasificar(\n marca: string,\n comentarios: { autor: string; texto: string }[],\n) {\n const system =\n \"Eres el community manager de la marca dada (\" + marca +\n \"). Clasifica cada comentario de TikTok y devuelve SOLO un array JSON válido (sin markdown ni texto extra), un objeto por comentario en el MISMO orden recibido. \" +\n \"Cada objeto debe tener tres campos: \" +\n 'tag (uno de: \"lead\", \"question\", \"complaint\", \"praise\"), ' +\n 'sentimiento (uno de: \"positivo\", \"negativo\", \"neutral\"), ' +\n \"reply (respuesta corta en español, cálida y profesional, sin prometer resultados legales, invitando a una consulta cuando aplique).\";\n\n const user = \"Comentarios en JSON: \" + JSON.stringify(\n comentarios.map((c, i) => ({ i, autor: c.autor, texto: c.texto })),\n );\n\n const res = await fetch(\"https://api.anthropic.com/v1/messages\", {\n method: \"POST\",\n headers: {\n \"x-api-key\": Deno.env.get(\"ANTHROPIC_API_KEY\"),\n \"anthropic-version\": \"2023-06-01\",\n \"content-type\": \"application/json\",\n },\n body: JSON.stringify({\n model: \"claude-haiku-4-5-20251001\",\n max_tokens: 4000,\n system,\n messages: [{ role: \"user\", content: user }],\n }),\n }).then((r) => r.json());\n\n if (res.error) throw new Error(res.error.message || JSON.stringify(res.error));\n\n const txt = (res.content?.[0]?.text) || \"[]\";\n const arr = parseArray(txt);\n\n return comentarios.map((_, i) => {\n const r = arr[i] || {};\n return {\n tag: TAGS.includes(r.tag) ? r.tag : \"question\",\n sentimiento: SENTIMIENTOS.includes(r.sentimiento)\n ? r.sentimiento\n : \"neutral\",\n reply: (r.reply || \"\").trim(),\n };\n });\n}\n\nexport default async function(req: Request): Promise {\n if (req.method === \"GET\") {\n return Response.json({ ok: true });\n }\n\n if (req.method !== \"POST\") {\n return Response.json({ error: \"method_not_allowed\" }, { status: 405 });\n }\n\n let body: any;\n try {\n body = await req.json();\n } catch {\n return Response.json({ error: \"invalid_json\" }, { status: 400 });\n }\n\n if (body.secret !== SECRET) {\n return Response.json({ error: \"forbidden\" }, { status: 403 });\n }\n\n const marca = body.marca || \"la marca\";\n const comentarios: any[] = Array.isArray(body.comentarios)\n ? body.comentarios\n : [];\n\n if (comentarios.length === 0) {\n return Response.json({ resultados: [] });\n }\n\n const coms = comentarios.slice(0, 30);\n\n try {\n const resultados = await clasificar(\n marca,\n coms.map((c) => ({ autor: c.autor || \"\", texto: c.texto || \"\" })),\n );\n return Response.json({ resultados });\n } catch (e) {\n return Response.json(\n { error: \"claude_error\", message: String(e) },\n { status: 502 },\n );\n }\n}\n","label",[148],"38bfd4a0-b223-4a40-b893-809c272336cc","resumen-ia.ts","afa23622-9c2a-11f1-b678-1607ee4eb77e",170,["D",1787184337313],1,"const SECRET = \"kimgsync_bb92a1e6f2c14a7db0e56d3f8ac5017e2c9d4471\";\n\nasync function generarResumen(payload: any): Promise {\n const system =\n \"Eres un consultor de marketing digital. Le estás explicando los resultados del mes \" +\n \"a un dueño de negocio que no sabe nada de marketing digital. \" +\n \"Habla en español. No uses palabras técnicas como engagement, CTR o alcance \" +\n \"sin explicarlas en el momento con una analogía simple. \" +\n \"Tu respuesta debe tener exactamente 4 partes, cada una con un título en mayúsculas \" +\n \"seguido de dos puntos y un espacio: \" +\n \"COMO TE FUE: si creció o bajó en términos de negocio (no de métricas), máximo 5 líneas. \" +\n \"QUE FUNCIONO: el formato o tema que mejor resultado dio y una razón sencilla de \" +\n \"por qué probablemente funcionó, máximo 5 líneas. \" +\n \"QUE NO FUNCIONO: qué se debería ajustar, máximo 5 líneas. \" +\n \"Y AHORA QUE: una recomendación concreta y simple para el siguiente mes, máximo 5 líneas. \" +\n \"Tono cercano y profesional, sin exagerar. \" +\n \"No agregues texto fuera de las 4 partes.\";\n\n const user = \"Datos del cliente en JSON:\\n\" + JSON.stringify(payload, null, 2);\n\n const res = await fetch(\"https://api.anthropic.com/v1/messages\", {\n method: \"POST\",\n headers: {\n \"x-api-key\": Deno.env.get(\"ANTHROPIC_API_KEY\"),\n \"anthropic-version\": \"2023-06-01\",\n \"content-type\": \"application/json\",\n },\n body: JSON.stringify({\n model: \"claude-sonnet-4-5\",\n max_tokens: 1400,\n system,\n messages: [{ role: \"user\", content: user }],\n }),\n }).then((r) => r.json());\n\n if (res.error) throw new Error(res.error.message || JSON.stringify(res.error));\n\n const txt = res.content?.[0]?.text;\n if (!txt) throw new Error(\"empty_response\");\n\n return txt.trim();\n}\n\nexport default async function(req: Request): Promise {\n if (req.method === \"GET\") {\n return Response.json({ ok: true });\n }\n\n if (req.method !== \"POST\") {\n return Response.json({ error: \"method_not_allowed\" }, { status: 405 });\n }\n\n let body: any;\n try {\n body = await req.json();\n } catch {\n return Response.json({ error: \"invalid_json\" }, { status: 400 });\n }\n\n if (body.secret !== SECRET) {\n return Response.json({ error: \"forbidden\" }, { status: 403 });\n }\n\n const payload = body.payload;\n if (!payload || typeof payload !== \"object\") {\n return Response.json({ error: \"missing_payload\" }, { status: 400 });\n }\n\n try {\n const resumen = await generarResumen(payload);\n return Response.json({ resumen });\n } catch {\n return Response.json({ error: \"no se pudo generar\" }, { status: 500 });\n }\n}\n",[158],"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}",[166],"ad65ecc5-fdba-41b6-b7b5-58911eaa8ff4","gbp-locations.ts","c1889620-9fd0-11f1-a423-1607ee4eb77e",177,["D",1787585437399],"export default async function(req){const SECRET=\"kimgsync_bb92a1e6f2c14a7db0e56d3f8ac5017e2c9d4471\";const u=new URL(req.url);if(u.searchParams.get(\"secret\")!==SECRET)return new Response(\"forbidden\",{status:403});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());const AT=r.access_token;if(!AT)return Response.json({error:\"sin_AT\"});const H={authorization:\"Bearer \"+AT};const out=[];try{const accts=await fetch(\"https://mybusinessaccountmanagement.googleapis.com/v1/accounts\",{headers:H}).then(r=>r.json());if(accts.error)return Response.json({error:accts.error});for(const a of(accts.accounts||[])){const accountName=a.name;const accountId=a.name.replace(\"accounts/\",\"\");try{const locs=await fetch(`https://mybusinessbusinessinformation.googleapis.com/v1/${accountName}/locations?readMask=name,title,storefrontAddress,phoneNumbers,websiteUri`,{headers:H}).then(r=>r.json());if(locs.error){out.push({accountId,accountName:a.accountName||null,error:locs.error.message||JSON.stringify(locs.error)});continue;}for(const l of(locs.locations||[])){const addr=l.storefrontAddress;const addrStr=addr&&addr.addressLines?addr.addressLines.join(\", \"):null;out.push({accountId,accountName:a.accountName||null,locationId:l.name?l.name.replace(\"locations/\",\"\"):null,title:l.title||null,direccion:addrStr,telefono:l.phoneNumbers&&l.phoneNumbers.primaryPhone?l.phoneNumbers.primaryPhone:null,sitioWeb:l.websiteUri||null});}}catch(e){out.push({accountId,accountName:a.accountName||null,error:String(e)});}}return Response.json(out);}catch(e){return Response.json({error:String(e)});}}\n",[174],"53b5eeef-ad40-4080-b472-86b0fb0237e8","cron-youtube.ts","4cc7f08c-7ccc-11f1-b774-1607ee4eb77e",181,["D",1787778439363],5,"// KIMITAL - PANEL - Cron de YouTube: metricas reales de la semana + comentarios\n// posts = videos subidos en los ultimos 7 dias (no total historico).\n// reach = vistas acumuladas de esos videos recientes.\n// engagement = (likes + comentarios) / vistas * 100.\n// 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 + uploads playlist\n const ch = await fetch(\n \"https://www.googleapis.com/youtube/v3/channels?part=statistics,contentDetails&id=\" +\n channelId + \"&key=\" + YT_KEY,\n ).then((r) => r.json());\n const st = ch.items && ch.items[0] && ch.items[0].statistics;\n const uploadsPlaylist = ch.items?.[0]?.contentDetails?.relatedPlaylists\n ?.uploads;\n\n // Mapa de videoId -> titulo (para etiquetar comentarios con el video real)\n let videoTitles: Record = {};\n\n if (st) {\n const prev = (client.kpis && client.kpis.youtube) || {};\n const subs = Number(st.subscriberCount || 0);\n\n // --- Calculo de posts, reach y engagement de la semana ---\n let posts = 0;\n let reach = 0;\n let engagement = 0;\n\n if (uploadsPlaylist) {\n // Ventana de 7 dias en ms (UTC)\n const sevenDaysAgo = Date.now() - 7 * 86400000;\n\n // Videos recientes del canal (orden: mas nuevos primero)\n const pl = await fetch(\n \"https://www.googleapis.com/youtube/v3/playlistItems?part=snippet&playlistId=\" +\n uploadsPlaylist + \"&maxResults=50&key=\" + YT_KEY,\n ).then((r) => r.json());\n\n // Filtrar videos publicados en los ultimos 7 dias\n const recentIds: string[] = [];\n for (const item of pl.items || []) {\n const vid = item.snippet.resourceId.videoId;\n videoTitles[vid] = (item.snippet.title || \"\").slice(0, 60);\n const pubMs = new Date(item.snippet.publishedAt).getTime();\n if (pubMs >= sevenDaysAgo) {\n recentIds.push(vid);\n }\n }\n\n posts = recentIds.length;\n\n // Estadisticas de los videos recientes (batch hasta 50 IDs)\n if (recentIds.length > 0) {\n const vids = await fetch(\n \"https://www.googleapis.com/youtube/v3/videos?part=statistics&id=\" +\n recentIds.join(\",\") + \"&key=\" + YT_KEY,\n ).then((r) => r.json());\n\n let totalLikes = 0;\n let totalComments = 0;\n for (const v of vids.items || []) {\n const vs = v.statistics || {};\n reach += Number(vs.viewCount || 0);\n totalLikes += Number(vs.likeCount || 0);\n totalComments += Number(vs.commentCount || 0);\n }\n\n // Engagement: (likes + comentarios) / vistas * 100\n engagement = reach > 0\n ? Number(((totalLikes + totalComments) / reach * 100).toFixed(1))\n : 0;\n }\n }\n\n const reachDelta = prev.reach\n ? Number((((reach - prev.reach) / prev.reach) * 100).toFixed(1))\n : 0;\n const engagementDelta = prev.engagement != null\n ? Number((engagement - prev.engagement).toFixed(1))\n : 0;\n\n client.kpis = client.kpis || {};\n client.kpis.youtube = {\n followers: subs,\n followersDelta: prev.followers != null\n ? Number(\n (((subs - prev.followers) / Math.max(prev.followers, 1)) * 100)\n .toFixed(1),\n )\n : 0,\n posts,\n totalVideos: Number(st.videoCount || 0),\n reach,\n reachDelta,\n engagement,\n engagementDelta,\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=50&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 ts: new Date(s.publishedAt).getTime(),\n post: videoTitles[t.snippet.videoId] || \"Video del canal\",\n tag: \"question\",\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}\n",[181],"c2c98edf-520d-49d8-a1a7-4e1e82aa264f",["D",1789405872280],13,[34],"8d357954-a2a1-49a9-8777-437ffa7fec8f","cron-posts-ia.ts","35c8d182-9516-11f1-89fc-1607ee4eb77e",148,["D",1786405804898],"import { blob } from \"https://esm.town/v/std/blob\"; const VOZ={\"pg1027190790483021\":\"Núcleo Pensional — asesoría en pensiones (Colombia). Cercano, tranquilizador y experto; claro sin tecnicismos; empatiza con la frustración de los trámites; nunca prometas resultados ni montos; invita a agendar asesoría o WhatsApp.\",\"pg939798619227286\":\"Abogado Fiduciario — derecho fiduciario. Profesional, confiable y preciso; explica en simple; invita a agendar consulta.\",\"pg1399018606896783\":\"Grúas Cono Sur — grúas y traslados (Chile). Práctico, rápido y servicial; español chileno neutro; transmite disponibilidad; pide ubicación por privado; CTA WhatsApp o teléfono 24h.\",\"pg286258314796413\":\"Michael Brooks - Jiménez P.C. — bufete en EE.UU. (inmigración y lesiones personales, Oklahoma). Profesional y empático; BILINGÜE: responde en inglés o español según el idioma del comentario; ofrece consulta gratuita; nada de asesoría legal específica en público.\",\"pg104181501157043\":\"Suárez & Gómez Abogados — bufete bogotano, 20+ años (fiduciario, corporativo, tributario, litigios, inmobiliario, sucesoral), clientes corporativos. Serio, elegante y de alto nivel; trata de USTED, formal pero cercano; orientado a soluciones; valida la inquietud con empatía breve; refuerza experiencia sin arrogancia; para casos específicos invita a privado o a agendar.\",\"pg110246487208178\":\"PienSAS Inversiones — firma bogotana de estructuración financiera y fiduciaria, 15+ años (estructuración financiera, propiedad fraccionada, selección de fiduciarias). Formal pero cercano (USTED), técnico-financiero pero accesible, autoridad tranquila; discreción y prudencia: no prometas resultados ni des asesoría puntual; invita a contacto directo.\",\"fiduciario\":\"Café Fiduciario — canal de YouTube de divulgación financiera/fiduciaria, cercano y didáctico. Cálido, conversacional y educativo; agradece la interacción; invita a ver más videos, suscribirse o dejar dudas; sin asesoría puntual.\"}; const INTENCIONES=[\"educativo\",\"emocional\",\"promocional\"]; function pkey(cid,p){return cid+\"|\"+(p.link||p.title||\"\").slice(0,90);} async function claudePosts(voz,posts){ const res=await fetch(\"https://api.anthropic.com/v1/messages\",{method:\"POST\",headers:{\"x-api-key\":Deno.env.get(\"ANTHROPIC_API_KEY\"),\"anthropic-version\":\"2023-06-01\",\"content-type\":\"application/json\"},body:JSON.stringify({model:\"claude-haiku-4-5-20251001\",max_tokens:2000,system:\"Eres un estratega de contenido que clasifica publicaciones de redes de una marca. Descripción del cliente: \"+voz+\" Devuelve SOLO un array JSON válido (sin markdown ni texto extra), un objeto por publicación en el MISMO orden recibido; cada objeto con DOS campos: tema (string corto de 2 a 4 palabras, ej inmigracion, defensa criminal, lesiones personales, pensiones) e intencion (exactamente uno de: educativo, emocional, promocional).\",messages:[{role:\"user\",content:\"Publicaciones en JSON: \"+JSON.stringify(posts.map((p,i)=>({i,titulo:p.title,formato:p.formato})))}]})}).then(r=>r.json()); if(res.error) throw new Error(res.error.message||JSON.stringify(res.error)); const txt=(res.content&&res.content[0]&&res.content[0].text)||\"[]\"; const a=txt.indexOf(\"[\"); const b=txt.lastIndexOf(\"]\"); return JSON.parse(a>=0&&b>a?txt.slice(a,b+1):\"[]\"); } export default async function(req){ const isHttp=req&&typeof req.url===\"string\"; if(isHttp){const u=new URL(req.url);if(u.searchParams.get(\"t\")!==\"kd26\")return new Response(\"no\",{status:401});} const data=await blob.getJSON(\"kimital-panel-data\"); if(!data||!data.clients)return isHttp?Response.json({error:\"sin_data\"}):undefined; const cache=(await blob.getJSON(\"ia-posts-cache\"))||{}; const resumen=[]; for(const c of data.clients){ const voz=VOZ[c.id]; const posts=c.postsMes||[]; if(!voz||!posts.length)continue; const pend=posts.filter(p=>!cache[pkey(c.id,p)]); if(pend.length){ try{ const arr=await claudePosts(voz,pend); pend.forEach((p,i)=>{const r=arr[i]||{}; const intencion=INTENCIONES.includes(r.intencion)?r.intencion:\"educativo\"; const tema=(r.tema||\"\").slice(0,40); cache[pkey(c.id,p)]={tema,intencion};}); }catch(e){ resumen.push({cliente:c.name,error:String(e)}); continue; } } posts.forEach(p=>{const hit=cache[pkey(c.id,p)]; if(hit){p.tema=hit.tema; p.intencion=hit.intencion; p.ia=true;}}); const temaMap={}; posts.forEach(p=>{if(p.tema){const inter=(p.likes||0)+(p.comentarios||0)+(p.compartidos||0)+(p.guardados||0); if(!temaMap[p.tema])temaMap[p.tema]={tema:p.tema,n:0,total:0}; temaMap[p.tema].n++; temaMap[p.tema].total+=inter;}}); c.temasPosts=Object.values(temaMap).map(t=>({tema:t.tema,n:t.n,avgInter:Math.round(t.total/t.n)})).sort((a,b)=>b.avgInter-a.avgInter).slice(0,6); const intMap={}; posts.forEach(p=>{if(p.intencion){const inter=(p.likes||0)+(p.comentarios||0)+(p.compartidos||0)+(p.guardados||0); if(!intMap[p.intencion])intMap[p.intencion]={intencion:p.intencion,n:0,total:0}; intMap[p.intencion].n++; intMap[p.intencion].total+=inter;}}); c.intencionPosts=Object.values(intMap).map(t=>({intencion:t.intencion,n:t.n,avgInter:Math.round(t.total/t.n)})).sort((a,b)=>b.avgInter-a.avgInter); resumen.push({cliente:c.name,posts:posts.length,nuevos:pend.length}); } await blob.setJSON(\"ia-posts-cache\",cache); await blob.setJSON(\"kimital-panel-data\",data); console.log(\"ia-posts ok \"+JSON.stringify(resumen)); return isHttp?Response.json({ok:true,resumen}):undefined; }\n",[193],"e91bfb87-b3e8-4bc7-bb6d-63f97e50b0d4","cron-meta.ts","b5827596-7cd3-11f1-b80c-1607ee4eb77e",219,["D",1788898374809],73,"// 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 ckey = (cid, c) =>\n cid + \"|\" + ((c.author || \"\") + \"|\" + (c.text || \"\")).slice(0, 90);\nconst G = \"https://graph.facebook.com/v21.0/\";\nconst DIAS_30 = 30 * 24 * 3600 * 1000;\nconst DIAS_90 = 90 * 24 * 3600 * 1000;\nconst DIAS_7 = 7 * 24 * 3600 * 1000;\nconst limiteSemana = Date.now() - DIAS_7;\nconst hoyCO = () => new Date().toLocaleDateString(\"en-CA\", { timeZone: \"America/Bogota\" });\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\n// Cuentas de pauta por cliente (inverso del ADS_MAP de cron-ads.ts).\nconst ACT_MAP: Record = {\n \"pg1027190790483021\": [\"act_3957845571176141\"],\n \"pg939798619227286\": [\"act_625571338950348\", \"act_2154091718767545\"],\n \"pg110246487208178\": [\"act_2312380362489680\"],\n \"pg1399018606896783\": [\"act_490763122931026\", \"act_971543805830773\"],\n \"pg286258314796413\": [\"act_217576387492184\"],\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// Delta comparando contra el historial propio (no contra el snapshot \"prev\",\n// que no persiste bien entre corridas). Toma la entrada de hace 7 dias, o la\n// mas antigua disponible si hay menos de 7 dias de historial.\nfunction deltaDesdeHistorial(\n historial: any[],\n valorActual: number,\n clave: \"followers\" | \"engagement\" | \"reach\",\n) {\n if (!historial || !historial.length) return 0;\n const refD = new Date(Date.now() - 7 * 24 * 3600 * 1000).toISOString()\n .slice(0, 10);\n let base = null;\n for (const h of historial) {\n if (h.d <= refD && (!base || h.d > base.d)) base = h;\n }\n if (!base) base = historial[0];\n const prevVal = base ? base[clave] : undefined;\n if (prevVal == null || !prevVal) return 0;\n return Number(\n (((valorActual - prevVal) / Math.max(prevVal, 1)) * 100).toFixed(1),\n );\n}\nfunction diaHora(iso: string) {\n const d = new Date(iso);\n const fmt = new Intl.DateTimeFormat(\"en-US\", {\n timeZone: \"America/Bogota\",\n weekday: \"short\",\n hour: \"2-digit\",\n hour12: false,\n });\n const parts = fmt.formatToParts(d);\n const wdPart = parts.find((x) => x.type === \"weekday\");\n const hPart = parts.find((x) => x.type === \"hour\");\n const dias = [\"Mon\", \"Tue\", \"Wed\", \"Thu\", \"Fri\", \"Sat\", \"Sun\"];\n const wd = dias.indexOf(wdPart ? wdPart.value : \"Mon\");\n let hh = Number(hPart ? hPart.value : \"12\");\n if (hh === 24) hh = 0;\n return { day: wd < 0 ? 0 : wd, hour: hh };\n}\nfunction horaCercana(h: number) {\n const HORAS_HEAT = [6, 8, 10, 12, 14, 16, 18, 20, 22];\n let best = HORAS_HEAT[0];\n let bd = Math.abs(h - best);\n for (const b of HORAS_HEAT) {\n const dd = Math.abs(h - b);\n if (dd < bd) {\n bd = dd;\n best = b;\n }\n }\n return best;\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 const IA_CACHE = ((await blob.getJSON(\"ia-cache\")) 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 const limite90 = Date.now() - DIAS_90;\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 // Fallback: si existe un cliente con otro id (sembrado distinto) pero\n // mismo nombre, adoptarlo y normalizar su id (evita duplicados por\n // mismatch de ids entre corridas y con otros crons).\n const porNombre = data.clients.find((c: any) => c.name === nombre);\n if (porNombre) {\n porNombre.id = id;\n client = porNombre;\n }\n }\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 const heatSum: number[][] = Array.from(\n { length: 7 },\n () => Array(24).fill(0),\n );\n const heatCount: number[][] = Array.from(\n { length: 7 },\n () => Array(24).fill(0),\n );\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 historial: prevFb.historial || [],\n };\n if (!client.platforms.includes(\"facebook\")) {\n client.platforms.push(\"facebook\");\n }\n\n let fbPostsSemana = 0;\n let fbInteraccionesSemana = 0;\n let fbPostsMes = 0;\n let fbInteraccionesMes = 0;\n const fbFeedIds = new Set();\n\n try {\n let fbUrl = 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(20).summary(true)%7Bfrom,message,created_time%7D&limit=50&access_token=\" +\n PT;\n let fbPage = 0;\n while (fbPage < 4) {\n let feed: any = null;\n try {\n feed = await fetch(fbUrl).then((r) => r.json());\n } catch (fe) {\n console.log(\"ERROR feed FB (fetch) page \" + p.id +\n \" (\" + (alias.name || p.name) + \"): \" + String(fe));\n break;\n }\n if (feed && feed.error) {\n console.log(\"ERROR feed FB (graph) page \" + p.id +\n \" (\" + (alias.name || p.name) + \"): code=\" + feed.error.code +\n \" subcode=\" + (feed.error.error_subcode || \"-\") + \" msg=\" +\n (feed.error.message || JSON.stringify(feed.error)));\n break;\n }\n const fbData = feed.data || [];\n if (!fbData.length) break;\n let fbOldest = Date.now();\n for (const post of fbData) {\n fbFeedIds.add(post.id);\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 thumb: post.full_picture || \"\",\n postLink: post.permalink_url || \"\",\n tag: \"question\",\n text: c.message,\n reply: \"(Fase 2: Claude redactara aqui la respuesta sugerida)\",\n ts: new Date(c.created_time).getTime(),\n });\n }\n const postTs = new Date(post.created_time).getTime();\n if (postTs < fbOldest) fbOldest = postTs;\n if (postTs > limite90) {\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 fbPostsMes++;\n fbInteraccionesMes += megusta + ncom + compartidos;\n const fbDH = diaHora(post.created_time);\n const fbHB = horaCercana(fbDH.hour);\n heatSum[fbDH.day][fbHB] += megusta + ncom + compartidos;\n heatCount[fbDH.day][fbHB] += 1;\n if (postTs > limiteSemana) {\n fbPostsSemana++;\n fbInteraccionesSemana += megusta + ncom + compartidos;\n }\n const att = post.attachments && post.attachments.data &&\n post.attachments.data[0];\n const mt = att ? (att.media_type || \"\") : \"\";\n let formato = \"Publicaci\\u00f3n\";\n if (mt === \"photo\") formato = \"Est\\u00e1tico\";\n else if (mt === \"video\") formato = \"Video\";\n else if (mt === \"album\") formato = \"Carrusel\";\n publicaciones.push({\n net: \"fb\",\n likes: megusta,\n title: (post.message || \"Publicacion de Facebook\").slice(0, 70),\n thumb: post.full_picture || \"\",\n link: post.permalink_url || \"\",\n ts: postTs,\n meta: formato + \" \\u00b7 \" + fecha(post.created_time) + \" \\u00b7 \" +\n compartidos + \" compartidos \\u00b7 \" + ncom + \" comentarios\",\n formato,\n comentarios: ncom,\n compartidos,\n guardados: 0,\n });\n }\n }\n fbPage++;\n if (fbOldest <= limite90 || !feed.paging || !feed.paging.next) break;\n fbUrl = feed.paging.next;\n }\n } catch (e) {\n console.log(\"ERROR feed FB (loop) page \" + p.id +\n \" (\" + (alias.name || p.name) + \"): \" + String(e));\n }\n\n // DARK POSTS: los ads con creative no publicado organicamente nunca\n // aparecen en /feed; sus comentarios se traen por el post id del\n // creative (effective_object_story_id) de la cuenta de anuncios.\n for (const actId of ACT_MAP[id] || []) {\n try {\n const adsL = await fetch(\n G + actId +\n \"/ads?fields=adcreatives%7Beffective_object_story_id%7D&limit=100&access_token=\" +\n T,\n ).then((r) => r.json());\n const vistos = new Set();\n for (const ad of adsL.data || []) {\n const sid = ad.adcreatives && ad.adcreatives.data &&\n ad.adcreatives.data[0]\n ? ad.adcreatives.data[0].effective_object_story_id\n : null;\n if (!sid || vistos.has(sid) || fbFeedIds.has(sid)) continue;\n vistos.add(sid);\n const post = await fetch(\n G + sid +\n \"?fields=message,full_picture,permalink_url,comments.limit(20)%7Bfrom,message,created_time%7D&access_token=\" +\n PT,\n ).then((r) => r.json());\n if (post.error) continue;\n for (const c of (post.comments && post.comments.data) || []) {\n const aut = (c.from && c.from.name) || \"\";\n const cm = {\n net: \"fb\",\n author: aut || \"Usuario de Facebook\",\n when: cuando(c.created_time),\n post: (post.message || \"Anuncio\").slice(0, 60),\n thumb: post.full_picture || \"\",\n postLink: post.permalink_url || \"\",\n tag: \"question\",\n text: c.message,\n reply: \"(Fase 2: Claude redactara aqui la respuesta sugerida)\",\n ts: new Date(c.created_time).getTime(),\n };\n // Evitar duplicar contra fb-ad que trae cron-ads.ts\n const dup = (client.comments || []).some((x: any) =>\n x.net !== \"fb\" && x.net !== \"ig\" &&\n (x.author || \"\") === cm.author && (x.text || \"\") === cm.text\n );\n if (!dup) comentarios.push(cm);\n }\n }\n } catch (e) {\n console.log(\"ERROR dark posts \" + actId + \" (\" + p.id + \"): \" +\n String(e));\n }\n }\n\n const fbEngagement = fbSeg > 0 && fbPostsSemana > 0\n ? Math.round((fbInteraccionesSemana / fbPostsSemana) / fbSeg * 1000) / 10\n : 0;\n client.kpis.facebook.posts = fbPostsSemana;\n client.kpis.facebook.engagement = fbEngagement;\n client.kpis.facebook.engagementDelta = delta(\n prevFb.engagement || 0,\n fbEngagement,\n );\n client.kpis.facebook.reach = fbInteraccionesSemana;\n client.kpis.facebook.reachDelta = delta(\n prevFb.reach || 0,\n fbInteraccionesSemana,\n );\n const fbEngagementMes = fbSeg > 0 && fbPostsMes > 0\n ? Math.round((fbInteraccionesMes / fbPostsMes) / fbSeg * 1000) / 10\n : 0;\n client.kpis.facebook.mes = {\n posts: fbPostsMes,\n engagement: fbEngagementMes,\n engagementDelta: delta(\n (prevFb.mes && prevFb.mes.engagement) || 0,\n fbEngagementMes,\n ),\n reach: fbInteraccionesMes,\n reachDelta: delta(\n (prevFb.mes && prevFb.mes.reach) || 0,\n fbInteraccionesMes,\n ),\n };\n if (client.kpis.facebook.historial.length < 5) {\n try {\n const since30 = new Date(Date.now() - 29 * 24 * 3600 * 1000)\n .toISOString().slice(0, 10);\n const until30 = new Date().toISOString().slice(0, 10);\n const engIns = await fetch(\n G + p.id +\n \"/insights?metric=page_post_engagements&period=day&since=\" +\n since30 + \"&until=\" + until30 + \"&access_token=\" + PT,\n ).then((r) => r.json());\n const folIns = await fetch(\n G + p.id + \"/insights?metric=page_follows&period=day&since=\" +\n since30 + \"&until=\" + until30 + \"&access_token=\" + PT,\n ).then((r) => r.json());\n const engVals =\n (engIns.data && engIns.data[0] && engIns.data[0].values) || [];\n const folVals =\n (folIns.data && folIns.data[0] && folIns.data[0].values) || [];\n const backfill = engVals.map((ev, i) => {\n const fv = folVals[i];\n const followersDay = fv ? fv.value : fbSeg;\n const eng = followersDay > 0\n ? Math.round((ev.value / followersDay) * 1000) / 10\n : 0;\n return {\n d: ev.end_time.slice(0, 10),\n engagement: eng,\n followers: followersDay,\n };\n });\n if (backfill.length) client.kpis.facebook.historial = backfill;\n } catch (e) {}\n }\n const fbHoy = hoyCO();\n const fbHist = client.kpis.facebook.historial;\n for (let i = fbHist.length - 1; i >= 0; i--) {\n if (fbHist[i].d > fbHoy) fbHist.splice(i, 1);\n }\n const fbExiste = fbHist.find((h) => h.d === fbHoy);\n if (fbExiste) {\n fbExiste.engagement = fbEngagement;\n fbExiste.followers = fbSeg;\n fbExiste.reach = fbInteraccionesSemana;\n } else {\n fbHist.push({\n d: fbHoy,\n engagement: fbEngagement,\n followers: fbSeg,\n reach: fbInteraccionesSemana,\n });\n }\n fbHist.sort((a, b) => (a.d < b.d ? -1 : a.d > b.d ? 1 : 0));\n if (fbHist.length > 120) fbHist.splice(0, fbHist.length - 120);\n client.kpis.facebook.followersDelta = deltaDesdeHistorial(\n fbHist,\n fbSeg,\n \"followers\",\n );\n client.kpis.facebook.engagementDelta = deltaDesdeHistorial(\n fbHist,\n fbEngagement,\n \"engagement\",\n );\n client.kpis.facebook.reachDelta = deltaDesdeHistorial(\n fbHist,\n fbInteraccionesSemana,\n \"reach\",\n );\n client.kpis.facebook.mes.engagementDelta = deltaDesdeHistorial(\n fbHist,\n fbEngagementMes,\n \"engagement\",\n );\n client.kpis.facebook.mes.reachDelta = deltaDesdeHistorial(\n fbHist,\n fbInteraccionesMes,\n \"reach\",\n );\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 historial: prevIg.historial || [],\n };\n if (client.kpis.instagram.historial.length < 5) {\n try {\n const since30 = new Date(Date.now() - 29 * 86400000).toISOString()\n .slice(0, 10);\n const until30 = new Date().toISOString().slice(0, 10);\n const fcIns = await fetch(\n G + ig.id +\n \"/insights?metric=follower_count&period=day&metric_type=time_series&since=\" +\n since30 + \"&until=\" + until30 + \"&access_token=\" + PT,\n ).then((r) => r.json());\n const fcVals =\n (fcIns.data && fcIns.data[0] && fcIns.data[0].values) || [];\n if (fcVals.length) {\n const totals = new Array(fcVals.length);\n totals[fcVals.length - 1] = igSeg;\n for (let i = fcVals.length - 2; i >= 0; i--) {\n totals[i] = totals[i + 1] - (fcVals[i + 1].value || 0);\n }\n const backfill = fcVals.map((v, i) => ({\n d: v.end_time.slice(0, 10),\n engagement: prevIg.engagement || 0,\n followers: totals[i],\n }));\n client.kpis.instagram.historial = backfill;\n }\n } catch (e) {}\n }\n if (!client.platforms.includes(\"instagram\")) {\n client.platforms.unshift(\"instagram\");\n }\n let igPostsSemana = 0;\n let igInteraccionesSemana = 0;\n let igPostsMes = 0;\n let igInteraccionesMes = 0;\n\n try {\n let igUrl = G + ig.id +\n \"/media?fields=id,caption,timestamp,media_type,media_url,thumbnail_url,permalink,like_count,comments_count,comments.limit(20)%7Busername,text,timestamp%7D&limit=100&access_token=\" +\n PT;\n let igPage = 0;\n while (igPage < 4) {\n const media = await fetch(igUrl).then((r) => r.json());\n const igData = media.data || [];\n if (!igData.length) break;\n let igOldest = Date.now();\n for (const m of igData) {\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 thumb: m.thumbnail_url || m.media_url || \"\",\n postLink: m.permalink || \"\",\n tag: \"question\",\n text: c.text,\n reply: \"(Fase 2: Claude redactara aqui la respuesta sugerida)\",\n ts: new Date(c.timestamp).getTime(),\n });\n }\n const mTs = new Date(m.timestamp).getTime();\n if (mTs < igOldest) igOldest = mTs;\n if (mTs > limite90) {\n let guardados = 0;\n if (mTs > limite) {\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 }\n igPostsMes++;\n igInteraccionesMes += Number(m.like_count || 0) +\n Number(m.comments_count || 0);\n const igDH = diaHora(m.timestamp);\n const igHB = horaCercana(igDH.hour);\n heatSum[igDH.day][igHB] += Number(m.like_count || 0) +\n Number(m.comments_count || 0);\n heatCount[igDH.day][igHB] += 1;\n if (mTs > limiteSemana) {\n igPostsSemana++;\n igInteraccionesSemana += Number(m.like_count || 0) +\n Number(m.comments_count || 0);\n }\n let formato = \"Est\\u00e1tico\";\n if (m.media_type === \"VIDEO\") formato = \"Video / Reel\";\n else if (m.media_type === \"CAROUSEL_ALBUM\") formato = \"Carrusel\";\n publicaciones.push({\n net: \"ig\",\n likes: Number(m.like_count || 0),\n title: (m.caption || \"Publicacion de Instagram\").slice(0, 70),\n thumb: m.thumbnail_url || m.media_url || \"\",\n link: m.permalink || \"\",\n ts: mTs,\n meta: formato + \" \\u00b7 \" + fecha(m.timestamp) + \" \\u00b7 \" +\n guardados + \" guardados \\u00b7 \" +\n Number(m.comments_count || 0) + \" comentarios\",\n formato,\n comentarios: Number(m.comments_count || 0),\n compartidos: 0,\n guardados,\n });\n }\n }\n igPage++;\n if (igOldest <= limite90 || !media.paging || !media.paging.next) break;\n igUrl = media.paging.next;\n }\n } catch (e) {}\n\n const igEngagement = igSeg > 0 && igPostsSemana > 0\n ? Math.round((igInteraccionesSemana / igPostsSemana) / igSeg * 1000) /\n 10\n : 0;\n client.kpis.instagram.posts = igPostsSemana;\n client.kpis.instagram.engagement = igEngagement;\n client.kpis.instagram.engagementDelta = delta(\n prevIg.engagement || 0,\n igEngagement,\n );\n client.kpis.instagram.reach = igInteraccionesSemana;\n client.kpis.instagram.reachDelta = delta(\n prevIg.reach || 0,\n igInteraccionesSemana,\n );\n const igEngagementMes = igSeg > 0 && igPostsMes > 0\n ? Math.round((igInteraccionesMes / igPostsMes) / igSeg * 1000) / 10\n : 0;\n client.kpis.instagram.mes = {\n posts: igPostsMes,\n engagement: igEngagementMes,\n engagementDelta: delta(\n (prevIg.mes && prevIg.mes.engagement) || 0,\n igEngagementMes,\n ),\n reach: igInteraccionesMes,\n reachDelta: delta(\n (prevIg.mes && prevIg.mes.reach) || 0,\n igInteraccionesMes,\n ),\n };\n const igHoy = hoyCO();\n const igHist = client.kpis.instagram.historial;\n for (let i = igHist.length - 1; i >= 0; i--) {\n if (igHist[i].d > igHoy) igHist.splice(i, 1);\n }\n const igExiste = igHist.find((h) => h.d === igHoy);\n if (igExiste) {\n igExiste.engagement = igEngagement;\n igExiste.followers = igSeg;\n igExiste.reach = igInteraccionesSemana;\n } else {\n igHist.push({\n d: igHoy,\n engagement: igEngagement,\n followers: igSeg,\n reach: igInteraccionesSemana,\n });\n }\n igHist.sort((a, b) => (a.d < b.d ? -1 : a.d > b.d ? 1 : 0));\n if (igHist.length > 120) igHist.splice(0, igHist.length - 120);\n client.kpis.instagram.followersDelta = deltaDesdeHistorial(\n igHist,\n igSeg,\n \"followers\",\n );\n client.kpis.instagram.engagementDelta = deltaDesdeHistorial(\n igHist,\n igEngagement,\n \"engagement\",\n );\n client.kpis.instagram.reachDelta = deltaDesdeHistorial(\n igHist,\n igInteraccionesSemana,\n \"reach\",\n );\n client.kpis.instagram.mes.engagementDelta = deltaDesdeHistorial(\n igHist,\n igEngagementMes,\n \"engagement\",\n );\n client.kpis.instagram.mes.reachDelta = deltaDesdeHistorial(\n igHist,\n igInteraccionesMes,\n \"reach\",\n );\n }\n let heatBest = { day: 0, hour: 12, v: -1 };\n const heatAvg: number[][] = Array.from(\n { length: 7 },\n () => Array(24).fill(0),\n );\n for (let d = 0; d < 7; d++) {\n for (let h = 0; h < 24; h++) {\n const cnt = heatCount[d][h];\n const avg = cnt > 0 ? heatSum[d][h] / cnt : 0;\n heatAvg[d][h] = avg;\n if (avg > heatBest.v) heatBest = { day: d, hour: h, v: avg };\n }\n }\n client.heatmap = heatAvg;\n client.bestHour = heatBest.v > 0\n ? { day: heatBest.day, hour: heatBest.hour }\n : {};\n\n const porRed: Record = {};\n for (const pub of publicaciones) {\n if (pub.ts <= limite) continue;\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 formato: x.formato,\n comentarios: x.comentarios,\n compartidos: x.compartidos,\n guardados: x.guardados,\n }));\n comentarios.forEach((cm) => {\n const hit = IA_CACHE[ckey(id, cm)];\n if (hit) {\n cm.tag = hit.tag;\n cm.reply = hit.reply;\n cm.ia = true;\n }\n });\n\n comentarios.sort((a, b) => (b.ts || 0) - (a.ts || 0));\n client.comments = comentarios.slice(0, 150).concat(\n (client.comments || []).filter((c: any) =>\n c.net !== \"fb\" && c.net !== \"ig\"\n ),\n );\n client.postsMes = publicaciones.map((x) => ({\n net: x.net,\n title: x.title,\n meta: x.meta,\n thumb: x.thumb,\n link: x.link,\n likes: x.likes,\n ts: x.ts,\n formato: x.formato,\n comentarios: x.comentarios,\n compartidos: x.compartidos,\n guardados: x.guardados,\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}",[200],"ac438544-3073-4c4c-b65a-c52b0d733f01","cron-ia.ts","0a28f3da-7f00-11f1-b686-1607ee4eb77e",180,["D",1787777755208],11,"import { blob } from \"https://esm.town/v/std/blob\"; const COMUN=\"Eres un community manager experto que responde comentarios en redes. Reglas: si el comentario trae un nombre, saluda por su nombre; agradece brevemente; tono humano y cálido, nunca robótico; máximo 1-2 emojis y solo si encaja; NUNCA des asesoría legal o financiera puntual ni pidas datos sensibles en público, invita a escribir por privado o a agendar; responde SIEMPRE en el mismo idioma del comentario; máximo 3 frases.\"; const VOZ={\"pg1027190790483021\":\"Núcleo Pensional — asesoría en pensiones (Colombia). Cercano, tranquilizador y experto; claro sin tecnicismos; empatiza con la frustración de los trámites; nunca prometas resultados ni montos; invita a agendar asesoría o WhatsApp.\",\"pg939798619227286\":\"Abogado Fiduciario — derecho fiduciario. Profesional, confiable y preciso; explica en simple; invita a agendar consulta.\",\"pg1399018606896783\":\"Grúas Cono Sur — grúas y traslados (Chile). Práctico, rápido y servicial; español chileno neutro; transmite disponibilidad; pide ubicación por privado; CTA WhatsApp o teléfono 24h.\",\"pg286258314796413\":\"Michael Brooks - Jiménez P.C. — bufete en EE.UU. (inmigración y lesiones personales, Oklahoma). Profesional y empático; BILINGÜE: responde en inglés o español según el idioma del comentario; ofrece consulta gratuita; nada de asesoría legal específica en público.\",\"pg104181501157043\":\"Suárez & Gómez Abogados — bufete bogotano, 20+ años (fiduciario, corporativo, tributario, litigios, inmobiliario, sucesoral), clientes corporativos. Serio, elegante y de alto nivel; trata de USTED, formal pero cercano; orientado a soluciones; valida la inquietud con empatía breve; refuerza experiencia sin arrogancia; para casos específicos invita a privado o a agendar.\",\"pg110246487208178\":\"PienSAS Inversiones — firma bogotana de estructuración financiera y fiduciaria, 15+ años (estructuración financiera, propiedad fraccionada, selección de fiduciarias). Formal pero cercano (USTED), técnico-financiero pero accesible, autoridad tranquila; discreción y prudencia: no prometas resultados ni des asesoría puntual; invita a contacto directo.\",\"fiduciario\":\"Café Fiduciario — canal de YouTube de divulgación financiera/fiduciaria, cercano y didáctico. Cálido, conversacional y educativo; agradece la interacción; invita a ver más videos, suscribirse o dejar dudas; sin asesoría puntual.\"}; const TAGS=[\"complaint\",\"lead\",\"question\",\"praise\"]; const SENTIMIENTOS=[\"positivo\",\"negativo\",\"neutral\"]; function ckey(cid,c){return cid+\"|\"+((c.author||\"\")+\"|\"+(c.text||\"\")).slice(0,90);} async function claude(voz,coms){ const res=await fetch(\"https://api.anthropic.com/v1/messages\",{method:\"POST\",headers:{\"x-api-key\":Deno.env.get(\"ANTHROPIC_API_KEY\"),\"anthropic-version\":\"2023-06-01\",\"content-type\":\"application/json\"},body:JSON.stringify({model:\"claude-haiku-4-5-20251001\",max_tokens:2000,system:COMUN+\" Voz de marca de este cliente: \"+voz+\" Devuelve SOLO un array JSON válido (sin markdown ni texto extra), un objeto por comentario en el MISMO orden recibido; cada objeto con CUATRO campos: tag (uno de: complaint, lead, question, praise), sentimiento (uno de: positivo, negativo, neutral), tema (string corto de 2 a 4 palabras que resuma el asunto principal del comentario, ejemplo demora en tramite, precio, atencion al cliente), y reply (string con la respuesta sugerida).\",messages:[{role:\"user\",content:\"Comentarios en JSON: \"+JSON.stringify(coms.map((c,i)=>({i,post:c.post,autor:c.author,texto:c.text})))}]})}).then(r=>r.json()); if(res.error) throw new Error(res.error.message||JSON.stringify(res.error)); const txt=(res.content&&res.content[0]&&res.content[0].text)||\"[]\"; const a=txt.indexOf(\"[\"); const b=txt.lastIndexOf(\"]\"); return JSON.parse(a>=0&&b>a?txt.slice(a,b+1):\"[]\"); } export default async function(req){ const isHttp=req&&typeof req.url===\"string\"; if(isHttp){const u=new URL(req.url);if(u.searchParams.get(\"t\")!==\"kd26\")return new Response(\"no\",{status:401});} const data=await blob.getJSON(\"kimital-panel-data\"); if(!data||!data.clients)return isHttp?Response.json({error:\"sin_data\"}):undefined; const cache=(await blob.getJSON(\"ia-cache\"))||{}; const resumen=[]; for(const c of data.clients){ const voz=VOZ[c.id]; const coms=c.comments||[]; if(!voz||!coms.length)continue; const pend=coms.filter(cm=>!cache[ckey(c.id,cm)]); if(pend.length){ try{ const arr=await claude(voz,pend); pend.forEach((cm,i)=>{const r=arr[i]||{}; const tag=TAGS.includes(r.tag)?r.tag:\"question\"; const sentimiento=SENTIMIENTOS.includes(r.sentimiento)?r.sentimiento:\"neutral\"; const tema=(r.tema||\"\").slice(0,40); cache[ckey(c.id,cm)]={tag,sentimiento,tema,reply:(r.reply||cm.reply||\"\").trim()};}); }catch(e){ resumen.push({cliente:c.name,error:String(e)}); continue; } } coms.forEach(cm=>{const hit=cache[ckey(c.id,cm)]; if(hit){cm.tag=hit.tag; cm.sentimiento=hit.sentimiento; cm.tema=hit.tema; cm.reply=hit.reply; cm.ia=true;}}); const hoy=new Date().toLocaleDateString(\"en-CA\",{timeZone:\"America/Bogota\"}); const cnt={positivo:0,negativo:0,neutral:0}; coms.forEach(cm=>{if(cnt[cm.sentimiento]!==undefined)cnt[cm.sentimiento]++;}); c.sentimientoHist=c.sentimientoHist||[]; const sh=c.sentimientoHist; let prevCum={positivo:0,negativo:0,neutral:0}; for(let i=sh.length-1;i>=0;i--){if(sh[i].d!==hoy){const e=sh[i]; prevCum=e._cum||{positivo:e.positivo||0,negativo:e.negativo||0,neutral:e.neutral||0}; break;}} const dayCnt={positivo:Math.max(0,cnt.positivo-prevCum.positivo),negativo:Math.max(0,cnt.negativo-prevCum.negativo),neutral:Math.max(0,cnt.neutral-prevCum.neutral)}; if(!sh.length||sh[sh.length-1].d!==hoy){sh.push({d:hoy,...dayCnt,_cum:{...cnt}}); if(sh.length>60)sh.shift();}else{sh[sh.length-1]={d:hoy,...dayCnt,_cum:{...cnt}};} c.alertaNegativos=cnt.negativo>=3; const temaCount={}; coms.forEach(cm=>{if(cm.tema)temaCount[cm.tema]=(temaCount[cm.tema]||0)+1;}); c.temasComentarios=Object.entries(temaCount).sort((a,b)=>b[1]-a[1]).slice(0,5).map(([tema,n])=>({tema,n})); resumen.push({cliente:c.name,comentarios:coms.length,nuevos:pend.length}); } await blob.setJSON(\"ia-cache\",cache); await blob.setJSON(\"kimital-panel-data\",data); console.log(\"ia ok \"+JSON.stringify(resumen)); return isHttp?Response.json({ok:true,resumen}):undefined; }",[208],"1604c76e-919c-4e39-8a4f-338acc3ee3f9","cron-decisiones.ts","1beab11a-7f0c-11f1-8920-1607ee4eb77e",182,["D",1787778439422],20,"import { blob } from \"https://esm.town/v/std/blob\"; const TOK=\"kd26\"; const TAGORDER=[\"complaint\",\"lead\",\"question\",\"praise\"]; function pickComments(comments:any){ const arr=(comments||[]).slice().sort((a:any,b:any)=>TAGORDER.indexOf(a.tag)-TAGORDER.indexOf(b.tag)); return arr.slice(0,6).map((c:any)=>({tag:c.tag,autor:c.author,texto:(c.text||\"\").slice(0,140)})); } function pickPosts(posts:any){ const rep=(posts||[]).find((p:any)=>p.flag===\"rep\"); const des=(posts||[]).find((p:any)=>p.flag===\"des\"); return { mejor: rep?{red:rep.net,titulo:(rep.title||\"\").slice(0,80),metrica:rep.metric+\" \"+rep.label}:null, peor: des?{red:des.net,titulo:(des.title||\"\").slice(0,80),metrica:des.metric+\" \"+des.label}:null }; } function pickWeb(web:any){ if(!web) return null; const out:any={}; if(web.ga4) out.ga4={usuarios:web.ga4.usuarios,sesiones:web.ga4.sesiones,vistas:web.ga4.vistas,usuariosDelta:web.ga4.usuariosDelta}; if(web.gsc) out.gsc={clicks:web.gsc.clicks,impresiones:web.gsc.impresiones,posicion:web.gsc.posicion}; return Object.keys(out).length?out:null; } async function claude(cliente:string,resumen:any){ async function callOnce(){ const res=await fetch(\"https://api.anthropic.com/v1/messages\",{method:\"POST\",headers:{\"x-api-key\":Deno.env.get(\"ANTHROPIC_API_KEY\"),\"anthropic-version\":\"2023-06-01\",\"content-type\":\"application/json\"},body:JSON.stringify({model:\"claude-sonnet-5\",max_tokens:1400,system:\"Eres un estratega senior de marketing digital de una agencia. Analiza los datos reales de la semana de un cliente y redacta EXACTAMENTE 3 decisiones para el resumen interno 'Lunes en 30 segundos': una para REPLICAR (algo que funciono y por que, con accion concreta para repetirlo), una para AJUSTAR (algo mejorable con una accion concreta), una para DESCARTAR (algo que no funciona y conviene detener o cambiar). Cada texto: maximo 2 frases, directo, accionable, en espanol, dirigido al equipo interno de la agencia (no al cliente final). Nunca inventes cifras que no te den. Si falta info para alguna categoria, da igual la mejor recomendacion razonable con lo disponible (incluso si es solo sobre datos de sitio web, ads o comentarios). Aunque la informacion disponible sea minima o parcial, NUNCA respondas con un array vacio: usa lo poco que tengas (aunque sea solo el nombre del cliente, o datos de un solo canal) para dar 3 recomendaciones razonables de buenas practicas de marketing digital. Un array vacio nunca es una respuesta valida. Responde UNICAMENTE con el array JSON, sin texto antes ni despues, sin markdown, sin backticks. Formato exacto: [{\\\"type\\\":\\\"rep\\\",\\\"text\\\":\\\"...\\\",\\\"src\\\":\\\"...\\\"},{\\\"type\\\":\\\"adj\\\",\\\"text\\\":\\\"...\\\",\\\"src\\\":\\\"...\\\"},{\\\"type\\\":\\\"des\\\",\\\"text\\\":\\\"...\\\",\\\"src\\\":\\\"...\\\"}]. El campo src es una nota corta citando el dato o evidencia concreta detras de la decision.\",messages:[{role:\"user\",content:\"Cliente: \"+cliente+\"\\nDatos de la semana (JSON): \"+JSON.stringify(resumen)}]})}).then(r=>r.json()); if(res.error) throw new Error(res.error.message||JSON.stringify(res.error)); const txt=(res.content&&res.content[0]&&res.content[0].text)||\"[]\"; let arr:any=[]; try{ arr=JSON.parse(txt.trim()); }catch(e1){ try{ const a=txt.indexOf(\"[\"); const b=txt.lastIndexOf(\"]\"); arr=JSON.parse(a>=0&&b>a?txt.slice(a,b+1):\"[]\"); }catch(e2){ console.log(\"parse_fail\",cliente,txt.slice(0,500),res.stop_reason); arr=[]; } } const out=(Array.isArray(arr)?arr:[]).filter((d:any)=>d&&[\"rep\",\"adj\",\"des\"].includes(d.type)&&d.text).slice(0,3); if(out.length<3) console.log(\"pocas_decisiones\",cliente,out.length,txt.slice(0,500),res.stop_reason); return out; } const r1=await callOnce(); let best=r1; if(best.length<3){ console.log(\"reintento\",cliente,best.length); try{ const r2=await callOnce(); if(r2.length>best.length) best=r2; }catch(e){ console.log(\"reintento_fallo\",cliente,String(e)); } } return best; } export default async function(req:any){ const isHttp=req&&typeof req.url===\"string\"; if(isHttp){const u=new URL(req.url); if(u.searchParams.get(\"t\")!==TOK) return new Response(\"no\",{status:401});} const data=await blob.getJSON(\"kimital-panel-data\"); if(!data||!data.clients) return isHttp?Response.json({error:\"sin_data\"}):undefined; const targets=[]; for(const c of data.clients){ const kpis=c.kpis||{}; const webData=pickWeb(c.web); const tieneAlgo=Object.keys(kpis).length||(c.comments&&c.comments.length)||(c.adsRangos&&c.adsRangos[\"7\"])||webData; if(!tieneAlgo) continue; const pk=pickPosts(c.posts); const payload={ redes:Object.fromEntries(Object.entries(kpis).map(([net,k]:any)=>[net,{seguidores:k.followers,seguidoresDelta:k.followersDelta,postsSemana:k.posts,totalVideos:k.totalVideos,engagementPct:k.engagement,engagementDelta:k.engagementDelta,interaccionesSemana:k.reach,interaccionesDelta:k.reachDelta}])), ads:(c.adsRangos&&c.adsRangos[\"7\"]&&c.adsRangos[\"7\"].resumen)||null, mejorPost:pk.mejor, peorPost:pk.peor, sitioWeb:webData, comentariosDestacados:pickComments(c.comments) }; targets.push({c,payload}); } const results=await Promise.allSettled(targets.map(t=>claude(t.c.name,t.payload))); const resumen:any[]=[]; results.forEach((r,i)=>{ const c=targets[i].c; if(r.status===\"fulfilled\"){ if(r.value.length) c.decisions=r.value; resumen.push({cliente:c.name,ok:true,n:r.value.length}); } else { resumen.push({cliente:c.name,ok:false,error:String(r.reason)}); } }); await blob.setJSON(\"kimital-panel-data\",data); console.log(\"decisiones ok\",JSON.stringify(resumen)); return isHttp?Response.json({ok:true,resumen}):undefined; }",[216],"1e484453-006e-45af-811a-61475fa7f91c","cron-ads.ts","8b7c4af4-7cda-11f1-9f35-1607ee4eb77e",178,["D",1787774873896],"// 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 const pagesTok = await fetch(\n G + \"me/accounts?fields=id,access_token&limit=100&access_token=\" + T,\n ).then((r) => r.json());\n const PTOK: Record = {};\n for (const p of pagesTok.data || []) PTOK[p.id] = p.access_token;\n const cuando = (iso: string) =>\n 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 const ckey = (cid: string, c: any) =>\n cid + \"|\" + ((c.author || \"\") + \"|\" + (c.text || \"\")).slice(0, 90);\n const IA_CACHE = ((await blob.getJSON(\"ia-cache\")) as any) || {};\n\n await Promise.all(\n Object.entries(ADS_MAP).map(async ([actId, clientId]) => {\n try {\n const info = await fetch(\n G + actId + \"?fields=currency&access_token=\" + T,\n )\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\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 const adsL = await fetch(\n G + actId +\n \"/ads?fields=creative%7Beffective_object_story_id%7D&limit=100&access_token=\" +\n T,\n ).then((r) => r.json());\n A.stories = A.stories || {};\n for (const ad of adsL.data || []) {\n const sid = ad.creative && ad.creative.effective_object_story_id;\n if (sid) A.stories[sid] = 1;\n }\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] || [])\n .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(\n obj,\n row.actions,\n Number(row.impressions || 0),\n );\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 await Promise.all((Object.values(acc) as any[]).map(async (A: any) => {\n const sids = Object.keys(A.stories || {}).slice(0, 6);\n A.adComments = [];\n await Promise.all(sids.map(async (sid: string) => {\n try {\n const tk = PTOK[sid.split(\"_\")[0]] || T;\n const post = await fetch(\n G + sid +\n \"?fields=message,full_picture,permalink_url,comments.limit(20)%7Bfrom,message,created_time%7D&access_token=\" +\n tk,\n ).then((r) => r.json());\n for (const c of (post.comments && post.comments.data) || []) {\n A.adComments.push({\n net: \"fb-ad\",\n author: (c.from && c.from.name) || \"Usuario de Facebook\",\n when: cuando(c.created_time),\n post: (post.message || \"Anuncio\").slice(0, 60),\n thumb: post.full_picture || \"\",\n postLink: post.permalink_url || \"\",\n tag: \"question\",\n text: c.message,\n reply: \"(Fase 2: Claude redactara aqui la respuesta sugerida)\",\n ts: new Date(c.created_time).getTime(),\n });\n }\n } catch (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.adComments) {\n A.adComments.forEach((cm: any) => {\n const hit = IA_CACHE[ckey(c.id, cm)];\n if (hit) {\n cm.tag = hit.tag;\n cm.reply = hit.reply;\n cm.ia = true;\n }\n });\n c.comments = ((c.comments || []).filter((x: any) => x.net !== \"fb-ad\"))\n .concat(A.adComments);\n c.comments.sort((a: any, b: any) => (b.ts || 0) - (a.ts || 0));\n }\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 // Backfill: 90 días consecutivos hacia atrás desde la última fecha real\n // que devolvió Meta. No usa el reloj del servidor: se ancla en el\n // date_start más reciente presente en A.serie.\n const fechasSerie = Object.keys(A.serie).sort();\n if (fechasSerie.length > 0) {\n const anchor = fechasSerie[fechasSerie.length - 1];\n const [ay, am, ad] = anchor.split(\"-\").map(Number);\n const relleno: Record = {};\n for (let i = 0; i < 90; i++) {\n const dt = new Date(Date.UTC(ay, am - 1, ad - i));\n const key = dt.toISOString().slice(0, 10);\n relleno[key] = A.serie[key] || 0;\n }\n A.serie = relleno;\n }\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}",[224],"pulls","branches","forks","envVars",{"_237":239,"_240":69},"connections",{"_237":69,"_238":69},"count","unfilledCount",8,"emptyCount",{"_49":223,"_38":224,"_36":225,"_149":-5,"_47":48,"_46":226,"_151":65,"_44":283,"_13":220,"_39":40,"_41":228,"_30":31,"_155":-5,"_253":284,"_33":285},{"_49":215,"_38":216,"_36":217,"_149":-5,"_47":48,"_46":218,"_151":65,"_44":280,"_13":220,"_39":40,"_41":221,"_30":31,"_155":-5,"_253":281,"_33":282},{"_49":207,"_38":208,"_36":209,"_149":-5,"_47":48,"_46":210,"_151":65,"_44":277,"_13":212,"_39":40,"_41":213,"_30":31,"_155":-5,"_253":278,"_33":279},{"_49":199,"_38":200,"_36":201,"_149":-5,"_47":48,"_46":202,"_151":65,"_44":274,"_13":204,"_39":40,"_41":205,"_30":31,"_155":-5,"_253":275,"_33":276},{"_49":192,"_38":193,"_36":194,"_149":-5,"_47":48,"_46":195,"_151":65,"_44":271,"_13":69,"_39":40,"_41":197,"_30":31,"_155":-5,"_253":272,"_33":273},{"_49":188,"_38":34,"_36":37,"_149":-5,"_47":48,"_46":14,"_151":31,"_44":268,"_13":190,"_39":40,"_41":43,"_30":31,"_155":-5,"_253":269,"_33":270},{"_49":180,"_38":181,"_36":182,"_149":-5,"_47":48,"_46":183,"_151":65,"_44":265,"_13":185,"_39":40,"_41":186,"_30":31,"_155":-5,"_253":266,"_33":267},{"_49":173,"_38":174,"_36":175,"_149":-5,"_47":48,"_46":176,"_151":65,"_44":262,"_13":69,"_39":153,"_41":178,"_30":31,"_155":-5,"_253":263,"_33":264},{"_49":165,"_38":166,"_36":167,"_149":-5,"_47":48,"_46":168,"_151":65,"_44":259,"_13":170,"_39":153,"_41":171,"_30":31,"_155":-5,"_253":260,"_33":261},{"_49":157,"_38":158,"_36":159,"_149":-5,"_47":48,"_46":160,"_151":65,"_44":256,"_13":162,"_39":153,"_41":163,"_30":31,"_155":-5,"_253":257,"_33":258},{"_49":147,"_38":148,"_36":63,"_149":-5,"_47":48,"_46":150,"_151":65,"_44":252,"_13":69,"_39":153,"_41":154,"_30":31,"_155":-5,"_253":254,"_33":255},["D",1786509236926],"children",[],[148],["D",1787184337313],[],[158],["D",1783733966306],[],[166],["D",1787585437399],[],[174],["D",1787778439363],[],[181],["D",1789405872280],[],[34],["D",1786405804898],[],[193],["D",1788898374809],[],[200],["D",1787777755208],[],[208],["D",1787778439422],[],[216],["D",1787774873896],[],[224],["D",1783733917279],["D",1789512647429],{"_106":105,"_114":110},{"_106":105,"_107":108,"_109":110,"_19":61,"_111":112,"_113":31},{"_13":95,"_38":96,"_49":48,"_97":50,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":-5,"_103":51,"_104":105},"ctx",{"_88":-5,"_133":324,"_325":326,"_327":328,"_329":31,"_330":31,"_331":31,"_332":65,"_333":-5,"_334":-7,"_335":-7,"_336":69,"_337":31,"_338":31,"_339":-5,"_340":31,"_341":31,"_342":31,"_343":-5},"ENV",{"_295":296,"_297":298,"_299":96,"_300":301,"_302":303,"_304":305,"_306":307,"_308":309,"_310":311,"_312":313,"_314":315,"_316":317,"_318":319,"_320":321,"_322":323},"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 · v224