FAF Statistics Megathread

This one is a plot of when I first saw someone play a game (in blue) and when I last saw them play a game (in green) (all values plotted are the cumulative values).

All this shows is that I see new people when my data begins, and I stop seeing people after my data ends (aka, time is a thing).

The real purpose of this post is to share all my code so far. Its all in ipython notebook (see http://jupyter.org/) files (thats how I did the dev), and is attached. Also included is all the raw data, so knock yourselves out.

Source : https://forums.faforever.com/viewtopic.php?f=2&t=13449#p138933

Leaderboards rating distribution (amount of players) :

Source : https://forums.faforever.com/viewtopic.php?f=2&t=13449#p138971

Popularity of different mods over time.
Looks like ladder really is dying this time! Also clear to see is when the server update broke coop, and when it got fixed again.
Notably missing is the "faf" mod, that was just way higher than all these other mods :

and by contrast with "vanilla" FAF :

Source : https://forums.faforever.com/viewtopic.php?f=2&t=13449&start=10#p139077

win ratios on Seton's Clutch for different factions:
All ratings:

1500+

Source : https://forums.faforever.com/viewtopic.php?f=2&t=13449&start=10#p139093

aeolus messages per day :

Source : https://forums.faforever.com/viewtopic.php?f=2&t=13449&start=10#p139149

Number of active players :

Source : https://forums.faforever.com/viewtopic.php?f=2&t=13449&start=10#p139660

Source : https://forums.faforever.com/viewtopic.php?f=2&t=13449&start=20#p140246

Following on from my last graph, I decided to investigate how many "active" players we have in each rating group.

I decided that "active" for globally rated games was 50 games or more:

From this we can see that the growth in active players is mainly driven from people with global MEANS in the 1000 - 1500 range (aka, ~800 to 1300 rating)

The larger numbers of these players masked trends for higher rated groups in this graph, so I decided to plot them separately:

While there were never very many players in the 2000+ mean bracket (1800+ rating) there has been a clear downward trend, with there only being half the number active in that group as this time two years ago.

I also did the same for ladder, with "active" meaning 10 games or more in a month (since fewer ladder games are played:

Here its quite clearly the low rating groups which are the odd ones out, with the number of active people with 1000 mean or less (~800 rating or less) on ladder increasing drastically in recent months.

All other rating groups for ladder seem to be falling significantly though.

Source : https://forums.faforever.com/viewtopic.php?f=2&t=13449&start=20#p139889

Source : https://forums.faforever.com/viewtopic.php?f=2&t=13449&start=20#p140398

Summed to periods of a month

factions, assuming 1=uef, 2=aeon, 3=cybran, 4=sera. no idea what 5 and 6 are

all ratings

1000+ mean

1500+ mean

1800+ mean

2000+ mean

Source : https://forums.faforever.com/viewtopic.php?f=2&t=13449&start=30#p149466

mount of ladder games / week.
There are some differences with this one viewtopic.php?f=2&t=13449&start=10#p139077
My graph has some drops in activity at newyears that are not in soflty's graph.

Here is a version with data only from 2016-2017

Source : https://forums.faforever.com/viewtopic.php?f=2&t=13449&start=30#p149475

Old Forum stats :

Users with the most topic creations in general discussions :

And a version for those with a very wide screen:

Source : https://forums.faforever.com/viewtopic.php?f=2&t=13449&start=40#p151990

Highest mean views per topic created (at least 5 topics created in General Discussions):

Number of topics created each month in General Discussions:

Source : https://forums.faforever.com/viewtopic.php?f=2&t=13449&start=40#p152003

The following graphs were created from a join the the game_stats and game_player_stats table using the game id.

Methodology:

• Games where no players could be found were discarded
• Even teams => At least 2 teams, and all teams have the same number of players
• Game is marked as valid => FAF thought it was a ranked game

Source : https://forums.faforever.com/viewtopic.php?f=2&t=13449&start=40#p152860

Global rating over total games (global + ladder)
https://plot.ly/~bsse/27/

Ladder rating over total games
https://plot.ly/~bsse/25/

Global rating over ladder rating
https://plot.ly/~bsse/23/

Source : https://forums.faforever.com/viewtopic.php?f=2&t=13449&start=80#p164738

Ladder win percentages by faction and rating:
https://plot.ly/~bsse/45

Games played by each faction and rating:
https://plot.ly/~bsse/50/

Source : https://forums.faforever.com/viewtopic.php?f=2&t=13449&start=80#p167079

Source : https://forums.faforever.com/viewtopic.php?f=2&t=13449&start=80#p168623

Lower rated players gain rating from draws, and the data for "0 rating advantage" actually refers to the range 0-10 rating advantage.

Second view, focused on new players.

Source : https://forums.faforever.com/viewtopic.php?f=2&t=13449&start=90#p168635

Mean success rate: 324034/521269 ==> 62.2% (Trueskill)
Mean success rate: 286803/521269 ==> 55.0% (Simple Ladder)
Mean success rate: 247667/521269 ==> 47.5% (Random Guessing)

The 'Simple Ladder' scheme awards players -1, 0, and 1 points for losses, draws, and wins respectively.
Note that the data used for these experiments is biased by having had the trueskill rating scheme used as the matchmaker.

Both plots are for 1v1 results only. Other rating schemes may appear in future plots, if you have ideas or questions let me know.

Source : https://forums.faforever.com/viewtopic.php?f=2&t=13449&start=90#p169175

A player is considered "active" if their player details have been updated in the past month, e.g. by logging in.

A player is considered "retained" if they are active.

Source : https://forums.faforever.com/viewtopic.php?f=2&t=13449&start=90#p173021

Old stats from the dark world of FAF moderation :

Source : https://forums.faforever.com/viewtopic.php?f=2&t=13449&start=100#p175559

Source : https://forums.faforever.com/viewtopic.php?f=2&t=13449&start=110#p177027