The objective is to develop a comprehensive analytics system for the game that provides insights into player behavior, item effectiveness, and engagement metrics. This system will help in understanding the impact of balance changes and improving the overall game experience.

Data Requirements

1. Item Buy Rate

   • Definition: The percentage of times an item is purchased when it appears in the shop.

     Metric Calculation:

     $$ \text{Item Buy Rate} = \left( \frac{\text{Number of Times Item Bought}}{\text{Number of Times Item Appeared in Shop}} \right) \times 100 $$

   Data Needed:

   • Item ID
   • Shop Appearance Count (per item)
   • Purchase Count (per item)

1. Item Win Rate

   • Definition: The win rate of an item calculated as the ratio of wins to total fights (wins + losses) where the item was used.

     Metric Calculation:

     $$ \text{Item Win Rate} = \left( \frac{\text{Number of Wins with Item}}{\text{Number of Wins with Item} + \text{Number of Losses with Item}} \right) \times 100 $$

   Data Needed:

   • Item ID
   • Count of Wins (per item)
   • Count of Losses (per item)

1. Logins per Day

   • Definition: The total number of player logins recorded each day.

     Metric Calculation: Sum of logins for all players for each day.

   Data Needed:

   • Player ID
   • Login Timestamp

1. Average Logins per Day per Player

   • Definition: The average number of times a player logs into the game each day.

     Metric Calculation:

     $$ \text{Avg Logins per Day per Player} = \frac{\text{Total Logins}}{\text{Number of Days}} $$

   Data Needed:

   • Player ID
   • Login Timestamps
   • Total Number of Days

1. Average Rerolls per Player Between Fights

   • Definition: The average number of times players reroll items between fights.

     Metric Calculation:

     $$ \text{Avg Rerolls per Fight} = \frac{\text{Total Rerolls}}{\text{Number of Players}} $$

   Data Needed:

   • Player ID
   • Reroll Count

1. Average Fights per Day per Player

   • Definition: The average number of fights a player engages in each day. Metric Calculation:

     $$ \text{Avg Fights a Day per Player} = \frac{\text{Total Fights}}{\text{Number of Players}} \times \frac{1}{\text{Number of Days}} $$

Data Needed:

• Player ID
• Fight Count
• Total Number of Days

Deliverables

A comprehensive analytics system with the following features:

• Dashboard or a command line access for viewing the following metrics:
  1. item buy rate
  2. item win rate
  3. logins per day
  4. average logins per day per player
  5. average rerolls per player
  6. average fights per day per player.