Skip to content
SlashClone
DiscoverUse in ClaudeSubmit a link
Sign in
Made by@usagemetrics

Saas usage dashboard

@usagemetrics/saas-usage-dashboard

Turn a product events CSV (timestamp, account_id, user_id, event) into one self-contained HTML dashboard: DAU, WAU, MAU, stickiness, active accounts, top features, activation rate, weekly retention, and accounts trending down. No external scripts; open it in any browser or attach it to an email.

SkillDatav1.0.0 (latest)Tested
Use in Claude Save Like Clone Comment
Activity
New: be the first to try it
  1. 1// Small helpers shared by this kit's scripts. Node built-ins only.
  2. 2import { existsSync, mkdirSync, readFileSync, writeFileSync } from "node:fs";
  3. 3import { dirname } from "node:path";
  4. 4
  5. 5export function fail(message) {
  6. 6 process.stderr.write(`Error: ${message}\n`);
  7. 7 process.exit(1);
  8. 8}
  9. 9
  10. 10/** Parses argv into { _: [positional], flag: value }. Flags without a value become true. */
  11. 11export function parseArgs(argv, booleans = []) {
  12. 12 const out = { _: [] };
  13. 13 for (let i = 0; i < argv.length; i++) {
  14. 14 const a = argv[i];
  15. 15 if (a.startsWith("--")) {
  16. 16 const eq = a.indexOf("=");
  17. 17 if (eq !== -1) out[a.slice(2, eq)] = a.slice(eq + 1);
  18. 18 else if (booleans.includes(a.slice(2))) out[a.slice(2)] = true;
  19. 19 else {
  20. 20 const next = argv[i + 1];
  21. 21 if (next === undefined || next.startsWith("--")) out[a.slice(2)] = true;
  22. 22 else {
  23. 23 out[a.slice(2)] = next;
  24. 24 i++;
  25. 25 }
  26. 26 }
  27. 27 } else out._.push(a);
  28. 28 }
  29. 29 return out;
  30. 30}
  31. 31
  32. 32export function readText(path, what = "file") {
  33. 33 if (!path) fail(`no ${what} given.`);
  34. 34 if (!existsSync(path)) fail(`${what} not found: ${path}`);
  35. 35 return readFileSync(path, "utf8").replace(/^\uFEFF/, "");
  36. 36}
  37. 37
  38. 38export function readJson(path, what = "JSON file") {
  39. 39 const text = readText(path, what);
  40. 40 try {
  41. 41 return JSON.parse(text);
  42. 42 } catch (e) {
  43. 43 return fail(`${path} is not valid JSON (${e.message}).`);
  44. 44 }
  45. 45}
  46. 46
  47. 47/** RFC 4180 CSV parser. Returns { header, rows } where rows are objects keyed by trimmed header. */
  48. 48export function parseCsv(text) {
  49. 49 const raw = [];
  50. 50 let row = [];
  51. 51 let field = "";
  52. 52 let quoted = false;
  53. 53 const pushRow = () => {
  54. 54 row.push(field);
  55. 55 field = "";
  56. 56 if (row.some((v) => v.trim() !== "")) raw.push(row);
  57. 57 row = [];
  58. 58 };
  59. 59 for (let i = 0; i < text.length; i++) {
  60. 60 const ch = text[i];
  61. 61 if (quoted) {
  62. 62 if (ch === '"' && text[i + 1] === '"') {
  63. 63 field += '"';
  64. 64 i++;
  65. 65 } else if (ch === '"') quoted = false;
  66. 66 else field += ch;
  67. 67 } else if (ch === '"') quoted = true;
  68. 68 else if (ch === ",") {
  69. 69 row.push(field);
  70. 70 field = "";
  71. 71 } else if (ch === "\n" || ch === "\r") {
  72. 72 if (ch === "\r" && text[i + 1] === "\n") i++;
  73. 73 pushRow();
  74. 74 } else field += ch;
  75. 75 }
  76. 76 if (field !== "" || row.length) pushRow();
  77. 77 const [head = [], ...body] = raw;
  78. 78 const header = head.map((h) => h.trim());
  79. 79 const rows = body.map((r) => {
  80. 80 const rec = {};
  81. 81 header.forEach((h, i) => {
  82. 82 rec[h] = (r[i] ?? "").trim();
  83. 83 });
  84. 84 return rec;
  85. 85 });
  86. 86 return { header, rows };
  87. 87}
  88. 88
  89. 89export function readCsv(path, what = "CSV file", required = []) {
  90. 90 const { header, rows } = parseCsv(readText(path, what));
  91. 91 const lower = header.map((h) => h.toLowerCase());
  92. 92 const missing = required.filter((c) => !lower.includes(c.toLowerCase()));
  93. 93 if (missing.length)
  94. 94 fail(
  95. 95 `${path} is missing column(s): ${missing.join(", ")}. Found: ${header.join(", ") || "(no header)"}.`,
  96. 96 );
  97. 97 // Normalize keys to lowercase so "Amount" and "amount" both work.
  98. 98 return rows.map((r) => {
  99. 99 const o = {};
  100. 100 for (const [k, v] of Object.entries(r)) o[k.toLowerCase()] = v;
  101. 101 return o;
  102. 102 });
  103. 103}
  104. 104
  105. 105export function csvCell(v) {
  106. 106 const s = v === null || v === undefined ? "" : String(v);
  107. 107 return /[",\n\r]/.test(s) ? `"${s.replace(/"/g, '""')}"` : s;
  108. 108}
  109. 109
  110. 110export function toCsv(rows, columns) {
  111. 111 const lines = [columns.map(csvCell).join(",")];
  112. 112 for (const r of rows) lines.push(columns.map((c) => csvCell(r[c])).join(","));
  113. 113 return lines.join("\n") + "\n";
  114. 114}
  115. 115
  116. 116/** "$1,234.50", "(12.00)", "-3", "" -> number. Empty or junk -> NaN. */
  117. 117export function num(v) {
  118. 118 if (v === null || v === undefined) return NaN;
  119. 119 let s = String(v).trim();
  120. 120 if (s === "") return NaN;
  121. 121 let neg = false;
  122. 122 if (/^\(.*\)$/.test(s)) {
  123. 123 neg = true;
  124. 124 s = s.slice(1, -1);
  125. 125 }
  126. 126 s = s.replace(/[$€£,\s%]/g, "");
  127. 127 if (s.endsWith("-")) {
  128. 128 neg = !neg;
  129. 129 s = s.slice(0, -1);
  130. 130 }
  131. 131 const n = Number(s);
  132. 132 if (!Number.isFinite(n)) return NaN;
  133. 133 return neg ? -n : n;
  134. 134}
  135. 135
  136. 136export function num0(v) {
  137. 137 const n = num(v);
  138. 138 return Number.isNaN(n) ? 0 : n;
  139. 139}
  140. 140
  141. 141export function round(n, digits = 2) {
  142. 142 const f = 10 ** digits;
  143. 143 return Math.round((n + Number.EPSILON) * f) / f;
  144. 144}
  145. 145
  146. 146export function money(n, digits = 0) {
  147. 147 if (!Number.isFinite(n)) return "n/a";
  148. 148 const s = Math.abs(n).toLocaleString("en-US", {
  149. 149 minimumFractionDigits: digits,
  150. 150 maximumFractionDigits: digits,
  151. 151 });
  152. 152 return `${n < 0 ? "-" : ""}$${s}`;
  153. 153}
  154. 154
  155. 155export function pct(n, digits = 1) {
  156. 156 if (!Number.isFinite(n)) return "n/a";
  157. 157 return `${(n * 100).toFixed(digits)}%`;
  158. 158}
  159. 159
  160. 160export function writeOut(path, content) {
  161. 161 mkdirSync(dirname(path), { recursive: true });
  162. 162 writeFileSync(path, content);
  163. 163}
  164. 164
  165. 165/** Accepts 2026-10-03, 2026-10-03T12:00:00Z, 10/03/2026, or unix seconds. Returns a Date (UTC) or null. */
  166. 166export function parseDate(v) {
  167. 167 if (v === null || v === undefined) return null;
  168. 168 const s = String(v).trim();
  169. 169 if (!s) return null;
  170. 170 if (/^\d{9,10}$/.test(s)) return new Date(Number(s) * 1000);
  171. 171 if (/^\d{12,13}$/.test(s)) return new Date(Number(s));
  172. 172 let m = s.match(/^(\d{4})-(\d{2})(?:-(\d{2}))?$/);
  173. 173 if (m) return new Date(Date.UTC(+m[1], +m[2] - 1, m[3] ? +m[3] : 1));
  174. 174 m = s.match(/^(\d{1,2})\/(\d{1,2})\/(\d{2,4})$/);
  175. 175 if (m) {
  176. 176 const y = m[3].length === 2 ? 2000 + +m[3] : +m[3];
  177. 177 return new Date(Date.UTC(y, +m[1] - 1, +m[2]));
  178. 178 }
  179. 179 const d = new Date(s);
  180. 180 return Number.isNaN(d.getTime()) ? null : d;
  181. 181}
  182. 182
  183. 183export const DAY_MS = 86400000;
  184. 184
  185. 185export function dayKey(d) {
  186. 186 return d.toISOString().slice(0, 10);
  187. 187}
  188. 188
  189. 189export function monthKey(d) {
  190. 190 return d.toISOString().slice(0, 7);
  191. 191}
  192. 192
  193. 193/** Monday of the ISO week containing d, as YYYY-MM-DD. */
  194. 194export function weekKey(d) {
  195. 195 const day = (d.getUTCDay() + 6) % 7;
  196. 196 return dayKey(new Date(Date.UTC(d.getUTCFullYear(), d.getUTCMonth(), d.getUTCDate() - day)));
  197. 197}
  198. 198
  199. 199export function addMonths(key, n) {
  200. 200 const [y, m] = key.split("-").map(Number);
  201. 201 const d = new Date(Date.UTC(y, m - 1 + n, 1));
  202. 202 return monthKey(d);
  203. 203}
  204. 204
  205. 205export function monthsBetween(a, b) {
  206. 206 const [ya, ma] = a.split("-").map(Number);
  207. 207 const [yb, mb] = b.split("-").map(Number);
  208. 208 return (yb - ya) * 12 + (mb - ma);
  209. 209}
  210. 210
  211. 211export function median(values) {
  212. 212 const v = values.filter(Number.isFinite).sort((a, b) => a - b);
  213. 213 if (!v.length) return NaN;
  214. 214 const mid = Math.floor(v.length / 2);
  215. 215 return v.length % 2 ? v[mid] : (v[mid - 1] + v[mid]) / 2;
  216. 216}
  217. 217
  218. 218export function sum(values) {
  219. 219 return values.reduce((a, b) => a + (Number.isFinite(b) ? b : 0), 0);
  220. 220}
  221. 221
  222. 222export function mdTable(columns, rows) {
  223. 223 const head = `| ${columns.join(" | ")} |`;
  224. 224 const sep = `| ${columns.map(() => "---").join(" | ")} |`;
  225. 225 const body = rows.map((r) => `| ${r.map((c) => String(c).replace(/\|/g, "/")).join(" | ")} |`);
  226. 226 return [head, sep, ...body].join("\n");
  227. 227}
  228. 228
  229. 229export function escapeHtml(s) {
  230. 230 return String(s)
  231. 231 .replace(/&/g, "&amp;")
  232. 232 .replace(/</g, "&lt;")
  233. 233 .replace(/>/g, "&gt;")
  234. 234 .replace(/"/g, "&quot;");
  235. 235}
Sign in to comment on a line