Jump to content


Exploring WG's database

datamining community status statistics analysis please be civil

  • Please log in to reply
153 replies to this topic

Kamakazi Rusher #1 Posted 11 July 2017 - 10:55 PM

    Sergeant

  • Players
  • 6623 battles
  • 109
  • [RDDT]
  • Member since:
    03-09-2014

Hey everyone! Last week I finished going through WG's database and pulling information on all Xbox players. You may have seen my previous work where I posted active players in a chart, but I came to find out that that data only covered players with more than 100 battles!

 

So, I ran a script for two weeks that went through player IDs 1 to 12,025,000 to see what accounts were valid and pulling all possible player info and gameplay statistics. (Due to an error, frags were not pulled but I will go back through when I get all PS4 data!) I've stored the data into two separate spreadsheets that contain player summarized statistics and per-player, per-tank stats. I'm currently spending some time organizing and analyzing what I have to share with you all. Some other individuals, such as website developers and Dr. Bodge, have also been given the data to review. They will likely share their own findings in separate threads.

 

I will be periodically updating this post and the one I created over on Reddit with links to (non)interactive charts, source code, etc. as they come by.

 

Please feel free to leave requests on what you would like to see graphed and/or calculated. Please note that I did not pull WN8 information and will not be calculating that. Also, please keep the comments here civil! I don't mind questions and negative criticism as long as it's constructive or helps push us to think outside the box.

 

Also keep in mind that I'll be more active on Reddit than here since I get notifications from the Narwhal app.

 


 

The data itself is hosted on my Google Drive. Note that it's large (~4GB) and compressed in a GZip'd Tarball. You'll want to use 7Zip to open it if you're using a Windows machine. Three files will be extracted: player info and stat summaries, player statistics in each of their tanks, and a listing of all tanks with necessary info.

 

Source code can be found at: https://gist.github....bf432efcd6ca514

 


 

Xbox Graphs

 


PS4 data is now complete! This one required going through account IDs 1,073,740,000 to 1,790,000,000. (For some reason, PS4 IDs start this high. No idea as to why that is.)

 

Data can be found on my Google Drive.


 

PS4 Graphs


Combined

Edited by Kamakazi Rusher, 15 July 2017 - 09:38 PM.

Code Monkey, Network Engineer, and Ethical Systems Penetration Tester

Community Status Tracker - Official Thread

Take a look at my post where I datamined WG's servers! Account registration, inactive players, premium ownership, all that good stuff!


rhymeswithN00bs #2 Posted 12 July 2017 - 12:13 AM

    Major

  • Beta Tester
  • 16150 battles
  • 10,826
  • [GIRLS]
  • Member since:
    01-04-2014
Cool. I'm looking forward to analysis from Bodge and everyone.

 

XOXO, Noobius Y


Kamakazi Rusher #3 Posted 12 July 2017 - 02:54 AM

    Sergeant

  • Players
  • 6623 battles
  • 109
  • [RDDT]
  • Member since:
    03-09-2014
Alright, three interactive charts and one static chart have been added. This has been fun! Hopefully I'll get to work with it tomorrow after running errands. I think I may hop off for a bit and grind out that Caernarvon s'more

Code Monkey, Network Engineer, and Ethical Systems Penetration Tester

Community Status Tracker - Official Thread

Take a look at my post where I datamined WG's servers! Account registration, inactive players, premium ownership, all that good stuff!


JTank97 #4 Posted 12 July 2017 - 03:30 AM

    Major

  • Players
  • 18751 battles
  • 2,318
  • [RATT]
  • Member since:
    01-19-2015
These are some pretty sad graphs - looks like it begins to dip hard when they released the game on Xbox One in summer 2015. Then they started with the bloody reskin parade - this game has lost so many veteran players it's tragic.

Kamakazi Rusher #5 Posted 12 July 2017 - 12:40 PM

    Sergeant

  • Players
  • 6623 battles
  • 109
  • [RDDT]
  • Member since:
    03-09-2014

View PostJTank97, on 11 July 2017 - 09:30 PM, said:

These are some pretty sad graphs - looks like it begins to dip hard when they released the game on Xbox One in summer 2015. Then they started with the bloody reskin parade - this game has lost so many veteran players it's tragic.

 

Not only that, there's definitely a struggle to retain new players and, in some cases, to even get them to play the game. I went back and added accounts who are registered in the database (but whom had never played any PvP) to the Account Lifespan graph. Maybe it's because players were logged in when they downloaded the game, or perhaps they couldn't get past the tutorial, or maybe they just "bought" the New Tanker packages, but regardless of how they got marked for it, we can see that they never played PvP. Dec 2014 had over 900k players register but never play...

Code Monkey, Network Engineer, and Ethical Systems Penetration Tester

Community Status Tracker - Official Thread

Take a look at my post where I datamined WG's servers! Account registration, inactive players, premium ownership, all that good stuff!


swamp_fox_009 #6 Posted 12 July 2017 - 01:49 PM

    First lieutenant

  • Players
  • 16877 battles
  • 824
  • [ODH]
  • Member since:
    12-04-2015
Will be interesting to see how the ps4 players add to these numbers. As I am a 360 to ps4 reroll.

M1_x_1B #7 Posted 12 July 2017 - 02:25 PM

    First lieutenant

  • Players
  • 5928 battles
  • 666
  • Member since:
    12-18-2015

This is really good work. Thanks for doing this.

 

I'm trying to wrap my head around some of the numbers. Maybe I'm not seeing it, but is there a running "Grand Total" for new accounts?

 

The reason I ask... is it possible to compare "total" accounts opened in WoT with "total" xbox users? I guess my thought is, how many xbox users have already tried the game?

 

We see that new players outpaced inactive players until Aug 2015, but is there a way to include "active" players on this graph? Curious to know if more players are leaving than staying.



RadiantPup27709 #8 Posted 12 July 2017 - 02:28 PM

    Major

  • Players
  • 25709 battles
  • 6,003
  • Member since:
    02-06-2014
:facepalm:


Kamakazi Rusher #9 Posted 12 July 2017 - 02:55 PM

    Sergeant

  • Players
  • 6623 battles
  • 109
  • [RDDT]
  • Member since:
    03-09-2014

View PostM1_x_1B, on 12 July 2017 - 08:25 AM, said:

This is really good work. Thanks for doing this.

 

I'm trying to wrap my head around some of the numbers. Maybe I'm not seeing it, but is there a running "Grand Total" for new accounts?

 

The reason I ask... is it possible to compare "total" accounts opened in WoT with "total" xbox users? I guess my thought is, how many xbox users have already tried the game?

 

We see that new players outpaced inactive players until Aug 2015, but is there a way to include "active" players on this graph? Curious to know if more players are leaving than staying.

 

There are at least 11,250,900 accounts in the database that I was able to successfully pull. Only 6,924,241 of those accounts had at least 1 battle on record. That leaves 4,326,659 accounts that never battled in PvP.

 

I can create another graph that displays the sum of all new accounts vs the sum of all inactive vs the sum of all active if you'd like

 

View PostRadiantPup27709, on 12 July 2017 - 08:28 AM, said:

:facepalm:

 

:confused:

Code Monkey, Network Engineer, and Ethical Systems Penetration Tester

Community Status Tracker - Official Thread

Take a look at my post where I datamined WG's servers! Account registration, inactive players, premium ownership, all that good stuff!


Kamakazi Rusher #10 Posted 12 July 2017 - 03:23 PM

    Sergeant

  • Players
  • 6623 battles
  • 109
  • [RDDT]
  • Member since:
    03-09-2014
Hey M1_x_1B, does this graph answer your question?

Code Monkey, Network Engineer, and Ethical Systems Penetration Tester

Community Status Tracker - Official Thread

Take a look at my post where I datamined WG's servers! Account registration, inactive players, premium ownership, all that good stuff!


M1_x_1B #11 Posted 12 July 2017 - 03:34 PM

    First lieutenant

  • Players
  • 5928 battles
  • 666
  • Member since:
    12-18-2015

View PostKamakazi Rusher, on 12 July 2017 - 03:23 PM, said:

Hey M1_x_1B, does this graph answer your question?

 

Very nice! Thanks.

 

Kind of interesting that when inactive outpaced new accounts in Aug. 2015, it also looks like active accounts started to decline around that time also. So, it is going on approximately 2 years of declining numbers. Too bad.



M1_x_1B #12 Posted 12 July 2017 - 03:39 PM

    First lieutenant

  • Players
  • 5928 battles
  • 666
  • Member since:
    12-18-2015

View PostKamakazi Rusher, on 12 July 2017 - 02:55 PM, said:

 

There are at least 11,250,900 accounts in the database that I was able to successfully pull. Only 6,924,241 of those accounts had at least 1 battle on record. That leaves 4,326,659 accounts that never battled in PvP.

 

I can create another graph that displays the sum of all new accounts vs the sum of all inactive vs the sum of all active if you'd like

 

 

So, currently, there is roughly 513K active accounts. Based on the above numbers who played at least 1 game, 7.4% have stayed. I really don't know if that is good or bad. I guess on one hand, 513K active is a pretty large number of players IMHO. I guess the bigger question is how many of the 513K are actually spending money?



Kamakazi Rusher #13 Posted 12 July 2017 - 03:47 PM

    Sergeant

  • Players
  • 6623 battles
  • 109
  • [RDDT]
  • Member since:
    03-09-2014

View PostM1_x_1B, on 12 July 2017 - 09:39 AM, said:

 

So, currently, there is roughly 513K active accounts. Based on the above numbers who played at least 1 game, 7.4% have stayed. I really don't know if that is good or bad. I guess on one hand, 513K active is a pretty large number of players IMHO. I guess the bigger question is how many of the 513K are actually spending money?

 

By the way, I just updated the graph to include a cumulative sum of players who are registered but never played. Previously they were not considered "active" nor "inactive."

 

As with most F2P games, you'll experience a high amount of downloads/registrations but low retention. That's where your question really matters: are we retaining players who are paying to support the game?

 

One way to answer this is to see how many premium vehicles are being purchased and how much of that gets translated into revenue. While we cannot be 100% certain about tanks that have been "gifted" in the past to the community (e.g. T14, earn OPs like CDC or Motherland), we can look at the amount of premiums owned by active players to see if they're spending money.

 

I guess my next task is to filter down the data to active players, see how many/which premiums they own, and roughly estimate the earnings from those...


Code Monkey, Network Engineer, and Ethical Systems Penetration Tester

Community Status Tracker - Official Thread

Take a look at my post where I datamined WG's servers! Account registration, inactive players, premium ownership, all that good stuff!


M1_x_1B #14 Posted 12 July 2017 - 04:09 PM

    First lieutenant

  • Players
  • 5928 battles
  • 666
  • Member since:
    12-18-2015

View PostKamakazi Rusher, on 12 July 2017 - 03:47 PM, said:

 

By the way, I just updated the graph to include a cumulative sum of players who are registered but never played. Previously they were not considered "active" nor "inactive."

 

As with most F2P games, you'll experience a high amount of downloads/registrations but low retention. That's where your question really matters: are we retaining players who are paying to support the game?

 

One way to answer this is to see how many premium vehicles are being purchased and how much of that gets translated into revenue. While we cannot be 100% certain about tanks that have been "gifted" in the past to the community (e.g. T14, earn OPs like CDC or Motherland), we can look at the amount of premiums owned by active players to see if they're spending money.

 

I guess my next task is to filter down the data to active players, see how many/which premiums they own, and roughly estimate the earnings from those...

 

That would definitely be a start. Like you said, WG is giving away a lot more "freemiums", so that makes it difficult. However, the thing about some of the freemiums, many of them could be purchased at one point or another. Also, players with more than 1 premium tank are obviously supporting the game. Too bad there isn't a way to know if an account has premium time or not. That is another indicator of financial support for the game.

 

Damn, you got a "stats nerd" like me all excited about this stuff. ;)



Dyslexsticks #15 Posted 12 July 2017 - 04:25 PM

    Major

  • Players
  • 33343 battles
  • 9,461
  • [BNKR]
  • Member since:
    02-12-2014

View PostRadiantPup27709, on 12 July 2017 - 02:28 PM, said:

:facepalm:

 

No further comment on that then?

Did you manage to stand my post? You might like: My Twitch Channel | My YouTube Channel | My Twitter (fixed!)My Xbox to YouTube Guide


SprungNickel427 #16 Posted 12 July 2017 - 04:42 PM

    First lieutenant

  • Players
  • 29698 battles
  • 789
  • [UMFF5]
  • Member since:
    11-29-2015
Account age Vs battles shows a couple accounts over 100,000 battles. Wow. Is that for real?

SprungNickel427 #17 Posted 12 July 2017 - 04:49 PM

    First lieutenant

  • Players
  • 29698 battles
  • 789
  • [UMFF5]
  • Member since:
    11-29-2015

Is there a way to graph matches played nightly, players playing 1-10,11-20-21-30 battles, just to see the nightly retention and in game time?

 



Kamakazi Rusher #18 Posted 12 July 2017 - 05:23 PM

    Sergeant

  • Players
  • 6623 battles
  • 109
  • [RDDT]
  • Member since:
    03-09-2014

View PostSprungNickel427, on 12 July 2017 - 10:42 AM, said:

Account age Vs battles shows a couple accounts over 100,000 battles. Wow. Is that for real?

 

Yup! In fact, let me share some info that I released in a previous Reddit post:

 

  • Highest Xbox account ID: 11,898,184
  • Total Xbox records found: 11,250,548
  • Hall of Fame requires players to have 100 battles before being listed. As of right now, there are only 1,675,220 players who meet this for Xbox
  • Total tanks purchased and used by players on Xbox: 83,761,954
  • FidgetyData23 (player ID 3956694) holds the highest number of battles in any single tank. They have played 25,308 battles in the T1E6-X! In this tank...
    • They have survived 9,706 battles (38.35%)
    • They have won 15,075 battles (59.57%)
    • They have cut down 26,343 trees
  • WiredSinger30 (player ID 5540995) holds the second-highest number of battles in any single tank. They have played 21,124 battles in the MS-1! In this tank...
    • They have survived 10,490 battles (49.66%)
    • They have won 11,799 battles (55.86%)
    • They have cut down 10,401 trees
  • Banjo518 (player ID 930300) holds the third-highest number of battles in any single tank. They have played 20,561 battles in the M53/M55! In this tank...
    • They have survived 8,106 battles (39.42%)
    • They have won 10,295 battles (50.07%)
    • They have cut down 13,386 trees

 

View PostSprungNickel427, on 12 July 2017 - 10:49 AM, said:

Is there a way to graph matches played nightly, players playing 1-10,11-20-21-30 battles, just to see the nightly retention and in game time?

 

 

Yes, but it requires a lot of time, storage, and bandwidth.

 

For example, the API allows for 10 requests per second per IP address. I can pull summarized player info in groups of 100 at a time. That means, under optimal situations, I can pull 1,000 players per second. We have confirmed 11,250,548 accounts. That's 11,250 seconds or 3 hours to pull all player accounts. (Mind you, this is just for Xbox!) You could run this twice each day and then publish it with a front-end interface (e.g. website).


Code Monkey, Network Engineer, and Ethical Systems Penetration Tester

Community Status Tracker - Official Thread

Take a look at my post where I datamined WG's servers! Account registration, inactive players, premium ownership, all that good stuff!


DecoNoir #19 Posted 12 July 2017 - 05:24 PM

    Major

  • Players
  • 37076 battles
  • 4,557
  • Member since:
    02-12-2014

View PostSprungNickel427, on 12 July 2017 - 08:42 AM, said:

Account age Vs battles shows a couple accounts over 100,000 battles. Wow. Is that for real?

 

Considering some of the people hovering around 60-70k, I think it'd be generous to call them "battles". I imagine most of those are AFKers or at best serial yoloers.

 

Contributor and General Handyman for Status Report. Like our work? Chat with us on the Status Report Discord


sumplkrum #20 Posted 12 July 2017 - 05:38 PM

    Major

  • Players
  • 12420 battles
  • 2,158
  • Member since:
    02-27-2014
Explains why premium tank prices keep going up. ... Less active players to scrounge money from.  :sceptic:
Stat masturbation:




1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users