coinos-server.git/scripts/analytics-geo.ts, branch stagingcoinos server — legacy coinos.io backend (Lightning, on-chain, Liquid)https://git.coinos.io/coinos-server.git/atom?h=staging2026-06-17T14:47:48Zanalytics: monthly insight reports + signup instrumentation2026-06-17T14:47:48ZAdam Soltysadam@coinos.io2026-06-14T19:36:43Zurn:sha1:33de17fa10e4fc7f44456cfbb3152fd16c86a567
Port of master 183a3cb0 + 3db24424. scripts/analytics.ts streams live db
(SCAN, never KEYS) and reports a trailing window: MAU/WAU, new users,
custody total + top holders, network volume by type, most-active/highest-
volume users, bolt12 recipients; --csv flag for month-over-month trends.
scripts/analytics-geo.ts reports top countries from the request log.
lib/register.ts stamps `created` and stores `country` on new users so
reports get signup timing/geography from the db directly.
Note: these scripts were written against the master stack; on staging
balances live in TigerBeetle, so custody/holder figures may need the
balance source adjusted from the Redis balance: keys.
Co-Authored-By: Claude Opus 4.8 <noreply@anthropic.com>