FAF Statistics Megathread

A graph of the number of times each faction gets played (counting rated games only) per week:

1606828448471-download9.png

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

Proportion of games played as each faction. On the x axis this time is the number of games someone has played (in the data I have, with a cutoff once there is less than 100 people with that many games) :
1606828518558-download10.png

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

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.

1606828582913-download11.png

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

Leaderboards rating distribution (amount of players) :
HPIvRsP.png
GnBKAAf.png

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 :
1606828832544-download14.png
and by contrast with "vanilla" FAF :
1606829117816-download16.png
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:
1606829188100-download19.png
1500+
1606829192125-download18.png
Source : https://forums.faforever.com/viewtopic.php?f=2&t=13449&start=10#p139093

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:
1606829499626-download-3.png

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.
1606829526557-download1.png
I also did the same for ladder, with "active" meaning 10 games or more in a month (since fewer ladder games are played:

1606829674619-download2-3.png
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

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
DfXCTZm.png

1000+ mean
KRdMxco.png

1500+ mean
iYBxMRo.png

1800+ mean
cI5ushU.png

2000+ mean
ofPijxh.png

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.

ladder_popularity.png

Here is a version with data only from 2016-2017
ladder_popularity_16-17.png

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 :
1606830570473-download7.png
And a version for those with a very wide screen:
loong.png

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):
1606830581545-download10.png
Number of topics created each month in General Discussions:
1606830584799-download9.png

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

1606830644299-download11.png
1606830649853-download12.png
1606830653035-download13.png

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/
Screenshot from 2020-12-01 15-08-09.png
Ladder rating over total games
https://plot.ly/~bsse/25/
Screenshot from 2020-12-01 15-08-25.png
Global rating over ladder rating
https://plot.ly/~bsse/23/
Screenshot from 2020-12-01 15-08-41.png

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
Screenshot from 2020-12-01 15-09-28.png

Games played by each faction and rating:
https://plot.ly/~bsse/50/
Screenshot from 2020-12-01 15-09-42.png

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

Lower rated players gain rating from draws, and the data for "0 rating advantage" actually refers to the range 0-10 rating advantage.
1606831053764-download17.png
Second view, focused on new players.
1606831057164-download18.png
Source : https://forums.faforever.com/viewtopic.php?f=2&t=13449&start=90#p168635

1606831352997-download22.png
1606831357294-download23.png
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