Like many others in its genre, the game is free-to-play, but players are encouraged to purchase optional items that enhance their playing experience. As a first task, the company would like you to generate a report that breaks down the game's purchasing data into meaningful insights.
Your final report should include each of the following:
- Total Number of Players
- Number of Unique Items
- Average Purchase Price
- Total Number of Purchases
- Total Revenue
- Percentage and Count of Male Players
- Percentage and Count of Female Players
- Percentage and Count of Other / Non-Disclosed
- The below each broken by gender
- Purchase Count
- Average Purchase Price
- Total Purchase Value
- Average Purchase Total per Person by Gender
- The below each broken into bins of 4 years (i.e. <10, 10-14, 15-19, etc.)
- Purchase Count
- Average Purchase Price
- Total Purchase Value
- Average Purchase Total per Person by Age Group
- Identify the the top 5 spenders in the game by total purchase value, then list (in a table):
- SN
- Purchase Count
- Average Purchase Price
- Total Purchase Value
- Identify the 5 most popular items by purchase count, then list (in a table):
- Item ID
- Item Name
- Purchase Count
- Item Price
- Total Purchase Value
- Identify the 5 most profitable items by total purchase value, then list (in a table):
- Item ID
- Item Name
- Purchase Count
- Item Price
- Total Purchase Value
- The majority percentage is of male players with (84%) as compared to female players with(14%).
- Overall,Female players and non-disclosed players spent more on average at 6% and 11% higher than their male.
- Age demographic lies between 20-24 (44.8%) with secondary groups falling between 15-19 (18.60%) and 25-29 (13.4%)and has the highest average purchases per person are the 35 to 39 year old.
- The top 5 spenders spent on average $3.45 per purchase with a total purchase value of $13.32. 5.Oathbreaker, Fiery Glass Crusader and Nirvana are the most profitable items and are also 3 of the top 4 most popular items.