[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_103":104,"_105":106},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","LUFI","name","ghl-mcp","path","informe_ads_semanal.ts","project",{"_22":45,"_11":12,"_33":46,"_47":-5,"_48":42,"_49":50,"_51":50,"_52":53,"_54":-5,"_55":56,"_57":58,"_59":32,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":-5,"_67":-5,"_68":-5,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":80,"_81":82,"_83":84,"_85":42},"file",{"_22":23,"_11":14,"_24":25,"_26":-5,"_27":28,"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":-5,"_13":44},"permalink","https://www.val.town/x/LUFI/ghl-mcp/code/informe_ads_semanal.ts","extension","id","2e6a1a33-35df-4b62-9097-01ac06a65c44","fileId","0c43c484-a3d0-11f1-8756-1607ee4eb77e","parentId","branchId","503589fd-0897-499b-af7b-d0300e6e6843","branchVersion",86,"latest",true,"createdAt",["D",1788025007584],"version",2,"fileType","interval","content","import { email } from \"https://esm.town/v/std/email\";\nimport { DEFAULT_LOCATION_ID, getToken } from \"./ghl.ts\";\n\nconst GHL = \"https://services.leadconnectorhq.com\";\nconst EL = \"https://admin.easylaundry.cl\";\nconst EL_MAIL = \"xlufix@gmail.com\";\nconst EL_PASS = \"Julieta7533#\";\nconst LOCAL = \"251\";\nconst UA = \"Mozilla/5.0 (Windows NT 10.0; Win64; x64) Chrome/124 Safari/537.36\";\n\n/* ---------- utilidades ---------- */\nfunction norm(s: string): string {\n return String(s).toUpperCase()\n .normalize(\"NFD\").replace(/[\\u0300-\\u036f]/g, \"\")\n .replace(/[^A-Z\\s]/g, \" \").replace(/\\s+/g, \" \").trim();\n}\nconst clp = (n: number) => \"$\" + n.toLocaleString(\"es-CL\");\n\nfunction ck(res: Response, prev = \"\"): string {\n const m = new Map();\n for (const c of prev.split(\"; \").filter(Boolean)) {\n const i = c.indexOf(\"=\"); m.set(c.slice(0, i), c.slice(i + 1));\n }\n for (const raw of res.headers.getSetCookie?.() ?? []) {\n const f = raw.split(\";\")[0]; const i = f.indexOf(\"=\");\n if (i > 0) m.set(f.slice(0, i).trim(), f.slice(i + 1));\n }\n return [...m].map(([k, v]) => `${k}=${v}`).join(\"; \");\n}\nasync function ws(path: string, body: any, cookie: string) {\n const r = await fetch(EL + path, {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json; charset=utf-8\",\n \"Cookie\": cookie, \"User-Agent\": UA, \"X-Requested-With\": \"XMLHttpRequest\",\n },\n body: JSON.stringify(body),\n });\n return { text: await r.text(), cookie: ck(r, cookie) };\n}\n\n/* ---------- 1. leads de anuncios desde GHL ---------- */\nasync function traerLeads() {\n const tok = getToken(DEFAULT_LOCATION_ID);\n const H = { Authorization: `Bearer ${tok}`, Version: \"2021-07-28\", Accept: \"application/json\" };\n const leads: any[] = [];\n let sid: string | null = null, sat: number | null = null;\n\n for (let p = 0; p < 10; p++) {\n let url = `${GHL}/contacts/?locationId=${DEFAULT_LOCATION_ID}&limit=100`;\n if (sid && sat) url += `&startAfterId=${sid}&startAfter=${sat}`;\n const r = await fetch(url, { headers: H });\n if (!r.ok) break;\n const cs = (await r.json()).contacts ?? [];\n if (!cs.length) break;\n for (const c of cs) {\n const at = (c.attributions ?? []).find((a: any) => a.isFirst) ?? (c.attributions ?? [])[0];\n if (!at) continue;\n if (!(at.utmSessionSource === \"Paid Social\" || at.utmAdId || at.adName)) continue;\n leads.push({\n nombre: (`${c.firstName ?? \"\"} ${c.lastName ?? \"\"}`).trim() || c.contactName || \"\",\n tel: c.phone ?? \"\",\n creado: (c.dateAdded ?? \"\").slice(0, 10),\n anuncio: at.adName ?? \"(sin nombre)\",\n });\n }\n const u = cs[cs.length - 1];\n sid = u.id; sat = new Date(u.dateAdded).getTime();\n }\n return leads;\n}\n\n/* ---------- 2. ventas desde EasyLaundry ---------- */\nasync function traerVentas(desde: string, hasta: string) {\n const r0 = await fetch(EL + \"/\", { headers: { \"User-Agent\": UA } });\n await r0.text();\n let cookie = ck(r0);\n const lg = await ws(\"/WebServices.aspx/iniciarSesion\", { usr: EL_MAIL, pass: EL_PASS }, cookie);\n cookie = lg.cookie;\n const sl = await ws(\"/WebServices.aspx/SET_ID_LOCAL_GLOBAL\", { ID_LOCAL: LOCAL }, cookie);\n cookie = sl.cookie;\n\n const ventas = new Map();\n let d = new Date(desde + \"T00:00:00Z\");\n const fin = new Date(hasta + \"T00:00:00Z\");\n while (d <= fin) {\n const last = new Date(Date.UTC(d.getUTCFullYear(), d.getUTCMonth() + 1, 0));\n const f = last > fin ? fin : last;\n const r = await ws(\"/ws.aspx/OT_RETIRADAS_X_LOCAL_Traer_Periodo\",\n { FECHA_INICIO: d.toISOString().slice(0, 10), FECHA_TERMINO: f.toISOString().slice(0, 10) },\n cookie);\n try {\n const j = JSON.parse(r.text);\n const arr = j.d === \"\" ? [] : JSON.parse(j.d);\n for (const o of arr) {\n const n = norm(o.nombre ?? \"\");\n if (!n) continue;\n const raw = String(o.monto_total ?? \"\").replace(/<[^>]*>/g, \"\");\n const mm = parseInt(raw.replace(/[^\\d]/g, \"\"), 10);\n ventas.set(n, (ventas.get(n) ?? 0) + (isNaN(mm) ? 0 : mm));\n }\n } catch { }\n d = new Date(f.getTime() + 86400000);\n }\n return ventas;\n}\n\n/* ---------- 3. informe ---------- */\nexport default async function () {\n const hoy = new Date();\n const hasta = hoy.toISOString().slice(0, 10);\n const d90 = new Date(hoy.getTime() - 90 * 86400000).toISOString().slice(0, 10);\n const d7 = new Date(hoy.getTime() - 7 * 86400000).toISOString().slice(0, 10);\n\n const leads = await traerLeads();\n const ventas = await traerVentas(d90, hasta);\n const nombresVenta = [...ventas.keys()];\n\n const convertidos: any[] = [];\n for (const l of leads) {\n const ln = norm(l.nombre);\n const partes = ln.split(\" \").filter(p => p.length > 2);\n if (partes.length < 2) continue;\n const hit = nombresVenta.find(nv => {\n const pv = nv.split(\" \").filter(p => p.length > 2);\n return partes.filter(p => pv.includes(p)).length >= 2;\n });\n if (hit) convertidos.push({ ...l, facturado: ventas.get(hit)! });\n }\n\n const semana = leads.filter(l => l.creado >= d7);\n const convSemana = convertidos.filter(c => c.creado >= d7);\n\n const porAnuncio: Record = {};\n for (const l of leads) {\n porAnuncio[l.anuncio] ??= { leads: 0, conv: 0, fact: 0 };\n porAnuncio[l.anuncio].leads++;\n }\n for (const c of convertidos) {\n porAnuncio[c.anuncio].conv++;\n porAnuncio[c.anuncio].fact += c.facturado;\n }\n\n const filas = Object.entries(porAnuncio)\n .sort((a: any, b: any) => b[1].fact - a[1].fact)\n .map(([n, a]: any) => {\n const tasa = a.leads ? (a.conv / a.leads * 100).toFixed(1) : \"0\";\n const color = a.conv === 0 ? \"#B3446B\" : Number(tasa) >= 7 ? \"#2E7D32\" : \"#8A6078\";\n return `\n ${n}\n ${a.leads}\n ${a.conv}\n ${tasa}%\n ${clp(a.fact)}\n `;\n }).join(\"\");\n\n const nuevos = convSemana.length\n ? convSemana.map(c =>\n `

${c.nombre} — ${clp(c.facturado)} · ${c.anuncio}

`\n ).join(\"\")\n : `

Ninguno esta semana

`;\n\n const factTotal = convertidos.reduce((a, c) => a + c.facturado, 0);\n const tasaG = leads.length ? (convertidos.length / leads.length * 100).toFixed(1) : \"0\";\n\n const html = `\n

\n Ladys Lavandería · Informe semanal de publicidad

Anuncios → clientes → plata

\n Semana al ${hasta} · ventana de análisis 90 días

\n\n

${semana.length}

leads esta semana

${convSemana.length}

convirtieron

${tasaG}%

conversión global

\n\n

Clientes nuevos de esta semana

${nuevos}\n\n

Rendimiento por anuncio (90 días)

\n \n \n \n \n \n \n \n \n ${filas}\n \n \n \n \n \n \n \n

Anuncio	Leads	Clientes	Tasa	Facturado
TOTAL	${leads.length}	${convertidos.length}	${tasaG}%	${clp(factTotal)}

\n\n

\n Cómo leerlo: un anuncio con muchos leads y pocos clientes atrae curiosos, no compradores.\n Bajo 3% conviene revisarlo o apagarlo. Sobre 7% conviene subirle presupuesto.

\n El cruce se hace por nombre entre GHL y EasyLaundry, así que las cifras son un piso:\n quien se registró con apodo no aparece.\n

`;\n\n await email({\n subject: `Ladys · Publicidad: ${semana.length} leads, ${convSemana.length} clientes nuevos`,\n html,\n });\n\n return { leads: leads.length, convertidos: convertidos.length, facturado: factTotal };\n}\n","deleted",false,"label",[14],"af78805c-2bed-420c-8baf-302de98516b6",["D",1781837290695],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","userId","019d4994-8d78-7000-b4ab-acb550747512","pinnedFileId","91a11d28-a323-11f1-ab04-1607ee4eb77e","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019d4994-8d78-7000-b4ab-b1c5ddec9378","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_9":10,"_102":98},"org",{"_9":10,"_96":-5,"_97":98,"_55":56,"_99":100,"_101":42},"branch",{"_35":86,"_11":87,"_22":28,"_88":45,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":12,"_95":10},"isOwned",196,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzNCbEZzUENZZHpzbHpkTThyejIzUERENVltdiJ9","tier","free","canRestrictVals","profileImageUrl","ctx",{"_79":-5,"_136":137,"_138":139,"_140":141,"_142":42,"_143":42,"_144":42,"_145":32,"_146":-5,"_147":-7,"_148":-7,"_149":63,"_150":42,"_151":42,"_152":-5,"_153":42,"_154":42,"_155":42,"_156":-5},"ENV",{"_107":108,"_109":110,"_111":87,"_112":113,"_114":115,"_116":117,"_118":119,"_120":121,"_122":123,"_124":125,"_126":127,"_128":129,"_130":131,"_132":133,"_134":135},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","71c1b20804b3232a7e513be260cfffc1932a9e97","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","orgs",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]