FAF stats

Talk about general things concerning Forged Alliance Forever.

Moderators: FtXCommando, Ze Dogfather

Re: FAF stats

Postby sierra109 » 02 Dec 2016, 03:17

I am trying to collect some data on the FAF fan base and would appreciate it if you took this very short survey about FAF https://goo.gl/forms/b4S6CzDzGEyxFVlg2
sierra109
 
Posts: 3
Joined: 18 Nov 2016, 05:34
Has liked: 0 time
Been liked: 1 time
FAF User Name: Sirra109

Re: FAF stats

Postby Softly » 02 Dec 2016, 21:08

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:

download.png
download.png (254.91 KiB) Viewed 4715 times

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.
download1.png
download1.png (135.03 KiB) Viewed 4682 times



I also did the same for ladder, with "active" meaning 10 games or more in a month (since fewer ladder games are played:
download2.png
download2.png (215.92 KiB) Viewed 4715 times

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.
Last edited by Softly on 02 Dec 2016, 21:29, edited 1 time in total.
Softly
Supreme Commander
 
Posts: 1009
Joined: 26 Feb 2012, 15:23
Location: United Kingdom
Has liked: 150 times
Been liked: 251 times
FAF User Name: Softles

Re: FAF stats

Postby speed2 » 03 Dec 2016, 13:33

Topic for posting stats on FAF.

Any posts without a (proper*) graph I'll ask to be deleted.

Spoiler: show
IceDreamer wrote:I'd like to point out that the spike in low-rated players coincides with a dip in the two tiers immediately above them (In rating). Is that explained by, for whatever reason, players rated ~1400 dropping rating and becoming lower rated, or is that not how this works, suggesting an influx of new players?


Anihilnine wrote:Now plot releases on the same graph :) and map pool changes etc.


Anihilnine wrote:Main date to put on there is removal of map pool selection.


Exotic_Retard wrote:and ladder map pool changes but i think that they dont seem to change much
User avatar
speed2
Contributor
 
Posts: 3189
Joined: 05 Jan 2013, 15:11
Has liked: 636 times
Been liked: 1119 times
FAF User Name: speed2

Re: FAF stats

Postby Softly » 10 Dec 2016, 20:37

download3.png
download3.png (82.36 KiB) Viewed 4516 times


Shameless repost of this graph from another thread :)
Softly
Supreme Commander
 
Posts: 1009
Joined: 26 Feb 2012, 15:23
Location: United Kingdom
Has liked: 150 times
Been liked: 251 times
FAF User Name: Softles

Re: FAF stats

Postby Softly » 12 Dec 2016, 03:33

Not a new chart, but here to advertise my new stats website: http://softled.northeurope.cloudapp.azu ... ps?map=560

Just some maps stuff right now, we'll see if I upgrade it any further.

download4.png
download4.png (89.18 KiB) Viewed 4477 times


Feedback welcome! (But only in this thread if you bring a graph with you)
Softly
Supreme Commander
 
Posts: 1009
Joined: 26 Feb 2012, 15:23
Location: United Kingdom
Has liked: 150 times
Been liked: 251 times
FAF User Name: Softles

Re: FAF stats

Postby speed2 » 20 Jan 2017, 12:26

Might not be the best looking ones since Im a new to this graph thingie, but I tried mkay

Image

Image

Spoiler: show
As you can see in the second graph, some shit is about the go down with ladder.
User avatar
speed2
Contributor
 
Posts: 3189
Joined: 05 Jan 2013, 15:11
Has liked: 636 times
Been liked: 1119 times
FAF User Name: speed2

Re: FAF stats

Postby Brutus5000 » 01 Apr 2017, 00:46

Hey softly,

if you are still interested, I wrote a server script, that could run any SQL query and upload it to the content server. If run by a cron job it could be even done automatically on a regular schedule.

https://github.com/FAForever/faftools/blob/develop/scripts/reporting.sh

If you need any SQL queries I could help you as well* 8-)

*0,99€ per minute, prices from mobile network can be higher
The 9th Doctor wrote:You think it'll last forever, the people and cars and concrete. But it won't. One day it's all gone, even the sky.
Brutus5000
Councillor - DevOps
 
Posts: 366
Joined: 05 Aug 2016, 23:32
Has liked: 29 times
Been liked: 288 times
FAF User Name: brutus5000

Re: FAF stats

Postby Softly » 01 Apr 2017, 22:23

select * from game_player_stats;
select * from game_stats;
Softly
Supreme Commander
 
Posts: 1009
Joined: 26 Feb 2012, 15:23
Location: United Kingdom
Has liked: 150 times
Been liked: 251 times
FAF User Name: Softles

Re: FAF stats

Postby keyser » 11 Apr 2017, 23:47

http://imgur.com/9b7NJYe

soflty is it possible to know what's the % games played on water map with water mexx vs the one played on water map without water mexx nowadays (2-3 last months would be enough i guess) ?
Zockyzock:
VoR is the clan of upcoming top players now
keyser
Councillor - Game
 
Posts: 1870
Joined: 17 May 2013, 14:27
Has liked: 424 times
Been liked: 540 times
FAF User Name: keyser

Re: FAF stats

Postby Softly » 16 Apr 2017, 22:06

Would need 1) a dump of the maps DB and 2) Someone to label up all the water maps.

Happy to draw a graph if someone gives me the data for it.
Softly
Supreme Commander
 
Posts: 1009
Joined: 26 Feb 2012, 15:23
Location: United Kingdom
Has liked: 150 times
Been liked: 251 times
FAF User Name: Softles

PreviousNext

Return to General Discussions

Who is online

Users browsing this forum: No registered users and 1 guest