Statistics

[niekcandaele]

Issue to track different statistics/analytics we want to expose.

All of these stats are 'over time', stored in our timeseries DB. This will allow users to pick periods they are interested in and allow more complex queries like dividing into bar charts of 'daily buckets' for example.

A lot of these should have the datapoints per gameserver and globally.

• Total currency in rotation #1485

  • How much currency is spent (aka deleted from rotation)
  • How much currency is earned (aka money printer)
  • ^ There's some edge cases here, eg transactions between players should not increase these. Currency that is already in rotation should never be counted again

• Currency per player

• Average currency per player

  • Consider adding median/min/max too for statistical relevance. Average will get distorted by the richest players

• Implement shop analytics to show most popular donor packs #1581

• Function executions over time

  • Filterable by hook/command/cron ID
  • This'll help figure out which commands are most popular for example

• Player country stats #1467

  • Display a world map showing where players originate from
  • Additionally a table with the 'raw numbers' (?)
  • Can display this domain wide and filtered per gameserver

[El-Limon]

Figma ideas https://www.figma.com/design/KkSDe8Ag27qxXWc5xZZN78/Takaro-dahboarding?node-id=0-1&t=bgR1EfGnwAWaLyYZ-1

Players overview:

• top 10 players based on amount of events (preconfigured selection on kills, chats) per player
• Total players (already in api)
  Player detail view:
• Playtime per player
• Amount of logins per player per game server
• Player lifetime value

Economy & Shop :

• Popular customers based on spent
• Total revenue
• Total orders per week
• Average order value
• Total orders
• Add percentage vs last period eg: $ 250 (+30% in green , - 30% in red)
• Popular products list based on $ or quantity
• Monthly sales graph

Everything should be viewable on the global shop page but also on the player detail page under economy