analytics engineering notes
Analytics engineering notes #
The main /analytics/ page is operator-first. This page keeps the lower-level transcript integrity counters and source notes out of the hero surface.
Session definitions #
- CLI transcript sessions: Claude and Codex transcript sessions with token events in the active reporting window.
- meta.db session events: rows in
meta.sessions. This countsupanddownevents, not unique sessions. - Resident agent lifetimes:
meta.sessionsrows whereevent = up. This is the closest durable proxy for tmux-resident agent starts.
Debug counters #
- Claude deduped replays: duplicate Claude usage envelopes removed by deduping on
(session_id, message.id). - JSON decode errors skipped: malformed transcript rows ignored during parsing.
- File count: number of transcript files scanned. Useful for audit and parser health, not for homepage meaning.
- Cross-session message id collisions: reused Claude
message.idvalues across different sessions. Tracked for integrity, not treated as a billing event.
Cost note #
The dashboard models API-equivalent cost from token usage and published model pricing. It does not claim subscription billing truth for Claude Max or ChatGPT Pro seats.