Many of you may think that analyzing data and running statistics is dreadfully boring, and you may be right – but for a self-proclaimed geek like myself, I actually enjoy playing around with data – especially if it poses a challenge and on top of that shows some nice or surprising patterns.
My latest “assignment” was quite interesting, as I was investigating mission wins during each played out war. Not only was I looking at faction wins for each mission, I also looked into wins for the different battle types and wins depending on which faction was the defending party.
Some of our players have been concerned about faction balance within the game and we, of course, wanted to investigate if this is actually a problem. It required me to look into a vast amount of old log files going back to last year and because of this I decided to write a program that would do it all for me – God only knows, I am too lazy to do it all by hand :-) Since most of Heroes & Generals is written in C#, I wanted to write the program in the same code, even though my previous knowledge of programming languages has been restricted to Java, C++ and VBA. So, through nicely available online tutorials and a heavy use of Google (thank God for Google!), I spent some time teaching myself C#. I was told it would be quite similar to Java, but seriously folks, for a newbie like me – the hell it is! However, I did manage to write a functioning program in Visual Studio (I am sure all of you hard core programmers could write a much prettier one, but hey, it works!). The program looked through many thousands of lines of codes in multiple log-files, cross referencing other log files as well and then extracted the data important for querying mission wins. Boy, how I love writing programs – especially ones that can save me a lot of time :-)
Anyways, enough about my venturing into the secret world of C#, below are some of the results – now keep in mind, that this is a work in progress and something we will continue to investigate and monitor to provide the best experience for our players.
From November of 2012 to January 15th (before the Guderian build), the overall missions wins (% missions won within a war) looked like this:
and after the Guderian build, the results were:
It seems that the Guderian build may have taken care of some of the inconsistencies regarding faction wins, but this is something we will monitor closely.
When dividing wins into different battle types and looking at the defending faction, the below graphs show the percentage wins when defending. Again the data is divided into before the Guderian build (January 15th 2013, top graph) and after (bottom graph).
These results are quite interesting as it seems that for the Airfield battles, defenders lose almost 75% of the times a battle is fought. We will definitely investigate this further.
So, these are some of the things I work with here at Reto-Moto and in the future I will continue looking into the game statistics to aid in making the game fun and interesting for our users.
Now, isn’t this fun – do you still think data mining is boring!?