\n \n Monthly Report\n

\n Offsite Client MTD Performance\n

\n Generated {today} · Day {editing\n ? \n : {day}} of {DAYS_IN_MONTH}{\" \"}\n · Today's pace target: {pacePct.toFixed(1)}%\n

\n \n setEditing(!editing)}\n style={{\n padding: \"8px 16px\",\n borderRadius: 8,\n border: \"1px solid #e2e8f0\",\n background: editing ? \"#6366f1\" : \"#f8fafc\",\n color: editing ? \"#fff\" : \"#374151\",\n fontWeight: 600,\n fontSize: 13,\n cursor: \"pointer\",\n }}\n >\n {editing ? \"✅ Done\" : \"✏️ Edit Data\"}\n \n \n\n {/* Summary */}\n \n {[\n { label: \"Clients Tracked\", val: clients.length },\n { label: \"On Track\", val: onTrack },\n { label: \"Lagging\", val: lagging },\n { label: \"At Risk\", val: atRisk },\n ].map((s) => (\n \n

{s.val}

{s.label}

\n \n ))}\n \n\n {/* Legend */}\n \n {[\n {\n label: \"On Track\",\n color: \"#16a34a\",\n bg: \"#f0fdf4\",\n desc: \"≥95% of today's pace — on course to hit goal\",\n },\n {\n label: \"Lagging\",\n color: \"#d97706\",\n bg: \"#fffbeb\",\n desc: \"70–94% of today's pace — behind but recoverable\",\n },\n {\n label: \"At Risk\",\n color: \"#dc2626\",\n bg: \"#fef2f2\",\n desc: \"<70% of today's pace — needs immediate action\",\n },\n ].map((s) => (\n \n \n {s.label}\n \n {s.desc}\n \n ))}\n \n\n {/* Client cards */}\n \n {clients.map((c, i) => {\n const { color, bg } = CLIENT_COLORS[c.name] || DEFAULT_COLOR;\n const pctOfPace = (c.actualPct / pacePct) * 100;\n const status = getStatus(pctOfPace);\n const open = expanded === c.name;\n return (\n \n !editing && setExpanded(open ? null : c.name)}\n style={{\n padding: \"18px 20px\",\n cursor: editing ? \"default\" : \"pointer\",\n background: \"#fff\",\n display: \"flex\",\n alignItems: \"center\",\n gap: 16,\n }}\n >\n \n {c.name[0]}\n \n

\n \n {editing\n ? (\n updateClientName(i, e.target.value)}\n style={{\n fontWeight: 600,\n fontSize: 14,\n border: \"1px solid #cbd5e1\",\n borderRadius: 6,\n padding: \"4px 8px\",\n width: 140,\n }}\n />\n )\n : (\n \n {c.name}\n \n )}\n \n {editing\n ? (\n \n MTD %:{\" \"}\n updateClient(i, v)}\n />\n

\n )\n : (\n <>\n \n {c.actualPct}% MTD\n \n \n {Math.round(pctOfPace)}%\n \n \n {status.label}\n \n \n )}\n \n \n {!editing && (\n <>\n \n \n Gray line = today's pace target ({pacePct.toFixed(1)}%)\n · Large % = performance vs. today's target\n \n \n )}\n \n {!editing && (\n \n {open ? \"▲\" : \"▼\"}\n \n )}\n \n {!editing && open && (\n \n

\n \n Today's pace target:\n {\" \"}\n {pacePct.toFixed(1)}%\n

\n Actual MTD:{\" \"}\n {c.actualPct}%\n

\n \n vs. today's target:\n {\" \"}\n = 95 ? \"#16a34a\" : \"#dc2626\" }}\n >\n {Math.round(pctOfPace)}%\n \n

\n Projected EOM:\n {\" \"}\n \n {Math.min(Math.round(c.actualPct * 2), 100)}%\n \n

\n \n )}\n \n );\n })}\n {editing && (\n \n + Add Client\n \n )}\n \n\n {/* Placement Metrics */}\n \n

\n 📍 Placement Metrics — March\n

\n \n \n \n {th(\"Client\")}\n {th(\n \"Placement Opps\",\n \"Number of placement opportunities identified for the client this month.\",\n )}\n {th(\n \"Placements Made\",\n \"Number of placements actually secured and confirmed.\",\n )}\n {th(\n \"Approval %\",\n \"Placements Made ÷ Placement Opps. Over 100% means more placements were made than opps identified.\",\n )}\n \n \n \n {placements.map((r, i) => {\n const { color } = CLIENT_COLORS[r.client] || DEFAULT_COLOR;\n const approvalPct = r.opps === 0\n ? null\n : Math.round((r.made / r.opps) * 100);\n const approvalLabel = approvalPct === null\n ? \"N/A\"\n : `${approvalPct}%`;\n const approvalColor = approvalPct === null\n ? \"#94a3b8\"\n : approvalPct >= 100\n ? \"#16a34a\"\n : approvalPct >= 50\n ? \"#d97706\"\n : \"#dc2626\";\n return (\n \n \n {editing\n ? (\n \n updatePlacementClient(i, e.target.value)}\n style={{\n width: 100,\n padding: \"4px 8px\",\n border: \"1px solid #cbd5e1\",\n borderRadius: 6,\n fontSize: 13,\n }}\n />\n )\n : r.client}\n \n \n {editing\n ? (\n updatePlacement(i, \"opps\", v)}\n />\n )\n : r.opps}\n \n \n {editing\n ? (\n updatePlacement(i, \"made\", v)}\n />\n )\n : r.made}\n \n \n {!editing && approvalLabel}\n \n \n );\n })}\n \n \n {editing && (\n \n + Add Row\n \n )}\n \n\n {/* Email Metrics */}\n \n

\n 📧 Email Campaign Metrics\n

\n \n \n \n {th(\"Client\")}\n {th(\n \"Goal\",\n \"Total emails contracted/committed for the full month.\",\n )}\n {th(\"Emails Sent MTD\", \"Actual emails sent so far this month.\")}\n {th(\n \"Should Have Sent MTD\",\n `Expected sends based on linear pacing through Day ${day} of ${DAYS_IN_MONTH}.`,\n )}\n {th(\n \"% to Goal\",\n \"Actual sends as a percentage of the full monthly target.\",\n )}\n {th(\n \"Pacing Status\",\n \"Whether actual sends are ahead or behind today's expected pace.\",\n )}\n \n \n \n {emailData.map((r, i) => {\n const { color } = CLIENT_COLORS[r.client] || DEFAULT_COLOR;\n const gap = r.sent - r.shouldHave, ahead = gap >= 0;\n return (\n \n \n {editing\n ? (\n updateEmailClient(i, e.target.value)}\n style={{\n width: 100,\n padding: \"4px 8px\",\n border: \"1px solid #cbd5e1\",\n borderRadius: 6,\n fontSize: 13,\n }}\n />\n )\n : r.client}\n \n \n {editing\n ? (\n updateEmail(i, \"goal\", v)}\n />\n )\n : r.goal.toLocaleString()}\n \n \n {editing\n ? (\n updateEmail(i, \"sent\", v)}\n />\n )\n : r.sent.toLocaleString()}\n \n \n {editing\n ? (\n updateEmail(i, \"shouldHave\", v)}\n />\n )\n : r.shouldHave.toFixed(0)}\n \n \n {r.pctToGoal}%\n \n \n {!editing && (\n \n {ahead\n ? `▲ ${Math.abs(gap).toFixed(0)} ahead`\n : `▼ ${Math.abs(gap).toFixed(0)} behind`}\n \n )}\n \n \n );\n })}\n \n \n {editing && (\n \n + Add Row\n \n )}\n \n\n {/* Priority table */}\n \n

\n 🚦 Campaign Push Priority\n

\n \n \n \n {[\"Priority\", \"Client\", \"Action Needed\", \"Timeline\"].map((h) => (\n \n {h}\n \n ))}\n \n \n \n {[\n {\n priority: \"🔴 #1\",\n client: \"Zola\",\n action:\n \"0 campaigns in queue — source & pitch new placements immediately\",\n timeline: \"Today\",\n },\n {\n priority: \"🟠 #2\",\n client: \"Sanity\",\n action:\n \"✅ Publisher follow-up in progress for 1 approved campaign; source additional placements in parallel\",\n timeline: \"This week\",\n },\n {\n priority: \"🟢 #3\",\n client: \"Synthesia\",\n action:\n \"✅ Publisher follow-up in progress for 3 approved campaigns; monitor for over-delivery once live\",\n timeline: \"This week\",\n },\n ].map((r, i) => (\n \n \n {r.priority}\n \n \n {r.client}\n \n \n {r.action}\n \n \n {r.timeline}\n \n \n ))}\n \n \n \n\n \n Projections based on linear pacing through March 31 · Click \"Edit Data\"\n to update metrics\n \n \n );\n}","deleted","label","airops-offsite-mtdreport","children",[],[101],"files",[158],"counts",{"_182":33,"_183":184,"_185":33,"_186":187,"_190":191},"pulls","branches",1,"forks","envVars",{"_188":33,"_189":33},"count","emptyCount","connections",{"_188":33,"_192":33},"unfilledCount","contents",[],"file",{"_106":159,"_97":101,"_160":161,"_162":-5,"_163":146,"_164":103,"_165":22,"_108":197,"_102":167,"_168":169,"_170":171,"_172":22,"_173":174,"_100":198},["D",1773423317205],[101],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.branch.$branch.version.$version.code.$",{"_95":96,"_97":98,"_99":45,"_102":103,"_100":101,"_104":207,"_156":212,"_178":217,"_195":218,"_193":221,"_222":-5,"_223":-5,"_224":-5,"_225":-5,"_226":227,"_186":-5},{"_106":107,"_97":98,"_108":208,"_110":-5,"_111":22,"_112":113,"_114":74,"_115":74,"_14":116,"_117":-5,"_118":22,"_119":-5,"_120":-5,"_121":33,"_16":122,"_123":-5,"_124":-5,"_125":-5,"_126":127,"_128":127,"_129":130,"_131":130,"_132":130,"_133":127,"_134":127,"_23":209,"_138":210,"_143":211,"_155":22},["D",1773423080660],{"_95":96,"_136":137},{"_95":96,"_140":137,"_14":116,"_141":142},{"_102":145,"_97":45,"_106":146,"_147":107,"_148":-5,"_149":-5,"_150":-5,"_151":-5,"_152":-5,"_153":98,"_154":96},[213],{"_106":159,"_97":101,"_160":161,"_162":-5,"_163":146,"_164":103,"_165":22,"_108":214,"_102":167,"_168":169,"_170":171,"_172":22,"_173":174,"_175":215,"_100":216},["D",1773423317205],[],[101],[213],{"_106":159,"_97":101,"_160":161,"_162":-5,"_163":146,"_164":103,"_165":22,"_108":219,"_102":167,"_168":169,"_170":171,"_172":22,"_173":174,"_100":220},["D",1773423317205],[101],[],"upstream","pull","ahead","behind","templates",[],"actionData","errors"]

airops_offsite

MTD-Report