coinos-server.git/scripts/analytics.ts, branch regtest-fulcrumcoinos server — legacy coinos.io backend (Lightning, on-chain, Liquid)https://git.coinos.io/coinos-server.git/atom?h=regtest-fulcrum2026-06-04T07:42:15Zanalytics: --csv flag for month-over-month trend tracking2026-06-04T07:42:15ZAdam Soltysadam@coinos.io2026-06-04T07:42:15Zurn:sha1:3db24424438322c3b341623456bd235ae64f98a1
Appends one metrics row per run to a CSV (header written if file is new):
date, users, MAU/WAU, payments, volume, custody, fee revenue, bolt12
recipients, and per-type volume/txn columns. Notice goes to stderr so it
doesn't pollute the saved stdout report or --json output. Drives the new
monthly snapshot cron (~/scripts/analytics-cron.sh).
Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
analytics: monthly insight reports + signup instrumentation2026-06-04T06:10:20ZAdam Soltysadam@coinos.io2026-06-04T06:10:20Zurn:sha1:183a3cb03e9ca04a0b1433fa2850a47747de00d6
scripts/analytics.ts — streams live db (SCAN, never KEYS) and reports for
a trailing window (default 30d): MAU/WAU, new users, custody total + top
holders, network volume by type (lightning/liquid/bitcoin/internal/bolt12/
fund), most-active and highest-volume users, and bolt12 recipients with a
"regular" flag for the Ocean mining-reward stream.
scripts/analytics-geo.ts — top countries from the request log. Counts only
/login + /register events tied to a username (raw cf-ipcountry volume is
dominated by datacenter/nostr traffic). Surfaces a distinct-IP-per-country
column so proxy/VPN egress is visible, and filters a known credential-test
bot IP. Honest result: US #1, then GB/CA/JP/DE/ES/BR.
lib/register.ts — stamp `created` (ms epoch) and store `country` (CF/
ipregistry code) on new users, so future reports get real signup timing and
geography from the db directly instead of log archaeology. Existing users
predate this; backfill is out of scope.
Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>