📊 Analytics & Server Insights

Two new analytics layers are now live — one for server owners and staff, one for platform admins.

Server Insights

Available at Panel → your server → Insights (owner and team access).

Activity tab

Charts and KPIs built from daily activity snapshots collected by the bot:

• Messages / day — area chart over the selected period (7d / 30d / 90d)
• Active members / day — bar chart of unique members who sent at least one message
• Member growth / day — joins minus leaves per day
• Voice minutes / day — total minutes spent in voice channels

KPIs: active members (7d), messages (7d), total current member count, net growth (7d).

7-day prediction — linear regression on the last 30 days of message data, shown as a day-by-day forecast. Only displayed when at least 7 data points are available.

⏱ Activity data is synced by the bot every hour. Today's stats may be up to 1 hour behind.

Leveling tab

• Top 20 leaderboard with level, XP and prestige
• Level distribution histogram (0–10 / 11–25 / 26–50 / 51–100 / 100+)

Data is read directly from the database — updated in real time.

Moderation tab

• Sanctions by type (warn / mute / kick / ban)
• Sanction timeline over the last 30 days
• Top 10 most-sanctioned members (all time)

Updated in real time.

Reports & Tickets tab

• Reports: count by status, average resolution time
• Tickets: count by status, average close time

Updated in real time.

Members tab

• Inactive members — members with no XP gain in the last 14 days and 30 days (relevant if XP decay is enabled)
• Top contributors — top 10 members by total XP

Based on last XP gain per member — updated in real time.

/trends Discord command

Generate a 30-day chart directly in Discord:

• /trends messages — messages per day (area chart)
• /trends members — active members per day (bar chart)
• /trends activity — voice minutes per day (bar chart)

The bot renders the chart as a PNG and posts it as an attachment. Requires the bot to have been active on your server for at least a few days.

Admin Analytics

Available at /admin/analytics for platform admins only.

Overview — total users, DAU/WAU/MAU, new servers, messages this week (with delta vs. previous period). Charts filterable by 30d / 90d / 1y.

Users — paginated table with last login, registration date, number of servers. Inactivity breakdowns (>30d / >90d / >180d). Cohort retention at J+7, J+14, J+30.

Servers — paginated table with feature adoption badges and bot last-seen date. Feature adoption bars showing % of servers using each feature.

Features — leveling stats (level distribution, prestige/title counts, top XP servers this week), report and ticket totals, chat activity.

All queries cached for 10 minutes.

— The YAWBDB Team