Analytics Dashboard

Local, dependency-light viewer for retention and pain points.

No database loaded.
Tip: run run_dashboard.bat (or ./scripts/run_dashboard.sh) from repo root.

Matches Over Time

Players Over Time

Sessions Over Time

Avg Ping Over Time (ms)

Avg Wait Over Time (seconds)

Retention (D1 / D7 / D14 / D30)

Percent of new players who returned exactly N days after first play.

Retention by First-Play Cohort (D1/D7/D14/D30)

Each line is a cohort of players whose first match was on that day.

Return Rate by Match Duration

Return Rate by Weapon Category Used

Per-record equipped weapon categories; filtered to weapon groups with enough samples.

D1 by Weapon Category Used

Return Rate by Killed-By Weapon Category

Only defeated records with attacker equipment data.

D1 by Killed-By Weapon Category

D1 by Normalized Death Time

D1 by Match Duration (minutes)

D1 by Session Duration (minutes)

D1 by Avg Ping (ms)

D1 by Avg Wait (seconds)

Return Rate by Downed Count

D1 by Downed Count

D1 by Defeat Outcome

D1 by Unstuck Count

Avg Matches / Session Over Time

Matches Per Session

Session Duration (minutes)

Return Rate by Session Duration

Match Duration (minutes)

Server Avg Player Count (sessionRecords)

Server Bot Rate (sessionRecords)

Server Sessions (sessionRecords)

Avg Ping Over Time (ms)

Ping Distribution (ms)

Wait Time Distribution (seconds)

Return Rate by Avg Ping (ms)

Return Rate by Wait Time (seconds)

D1/D7/D14 Retention by Avg Ping

Placement Distribution

Return Rate by Placement (all records)

Return Rate by Placement (last match)

Death Time Distribution (minutes)

Death Time Distribution (1-Match Players)

Share of death-time minutes for players who only played one match.

Death Time Distribution by Player Match Count

Lines: 1 match, 2 matches, 3 matches, 4+ matches, and average cohort line.

Normalized Death Time (fraction of match)

Return Rate by Normalized Death Time

Return Rate by Game Mode (last match)

Return Rate by Region (last match)

Return Rate by Team Size (last match)

D1 Retention by Game Mode

D1 Retention by Region

D1 Retention by Team Size

MMR Distribution (centered on 1500)

Power Level Distribution (avg per player)

Return Rate by MMR (avg per player)

Item Category Summary

Item Summary (All Items)

Player Summary

Custom Query Builder

Prompt with plain language, generate SQL + chart, then save/edit/delete.

Not saved

Output

SQL
Viz
changes applied
Custom queries run against server DB and current dashboard filters.

Saved Custom Queries

Custom Result