Forged Alliance Forever

Re: Cool Data

2015-12-31T08:15:41+02:00

how about most game played during 1 day/week/month by a player oк by all players
longest win streak
longest setons game

Statistics: Posted by justmakenewgame — 31 Dec 2015, 08:15

Re: Cool Data

2015-12-23T13:08:22+02:00

I'd like to do some data analysis too. How do I get access to the data? An export was uploaded once to dropbox, but that one is not there anymore.

Statistics: Posted by ax0lotl — 23 Dec 2015, 13:08

Re: Cool Data

2015-12-23T05:13:27+02:00

Sheeo wrote:
Aulex wrote:Downlord and I had a little bit of fun on the dev server last night (I think it's 2 months old) calculating different metrics.

Here are some interesting results (Keep in mind these are only ranked games+ladder games):
mickeymouse has the most number of games played: 13467
followed up by
ta4life with 11417 games whose spent 131.29 days in the game
Aulex has 1977 games who spent 52.5914 days in the game
58.0561% who have accounts have never played a game
437.908898150685 years have collectively been put into the game
2.4434% of semi active users (defined by greater than 10 games) have played over 1000 games
7.3621% of active users (defined by greater than 100 games) have played over 500 games
21.3397% of active users have played over 1000 games
The average game is 69 minutes

What a know some other statistics? Request it

I'd like to know your queries so I can test for accuracy, if you don't mind

it's all in the tmux session, also some of the stuff i posted is semi wrong, but i'm waaay too lazy to update.

Statistics: Posted by Aulex — 23 Dec 2015, 05:13

Re: Cool Data

2015-12-23T04:49:18+02:00

Aulex wrote:
Downlord and I had a little bit of fun on the dev server last night (I think it's 2 months old) calculating different metrics.

Here are some interesting results (Keep in mind these are only ranked games+ladder games):
mickeymouse has the most number of games played: 13467
followed up by
ta4life with 11417 games whose spent 131.29 days in the game
Aulex has 1977 games who spent 52.5914 days in the game
58.0561% who have accounts have never played a game
437.908898150685 years have collectively been put into the game
2.4434% of semi active users (defined by greater than 10 games) have played over 1000 games
7.3621% of active users (defined by greater than 100 games) have played over 500 games
21.3397% of active users have played over 1000 games
The average game is 69 minutes

What a know some other statistics? Request it

I'd like to know your queries so I can test for accuracy, if you don't mind

Statistics: Posted by Sheeo — 23 Dec 2015, 04:49

Re: Cool Data

2015-12-22T14:12:52+02:00

thanks for pointing out that this is ranked/ladder only. since 52% did never play a ranked/ladder game, my assumption would be that a great portion of those only play nonranked games, Coop Missions or single player vs AI. Got any numbers on that?

Statistics: Posted by pza — 22 Dec 2015, 14:12

Re: Cool Data

2015-12-22T14:04:35+02:00

7.3621% of active users (defined by greater than 100 games) have played over 500 games
21.3397% of active users have played over 1000 games

you mean 7.3% of active player, have played between 500 and 1000 games ?

Statistics: Posted by keyser — 22 Dec 2015, 14:04

Re: Cool Data

2015-12-22T12:47:23+02:00

What is the average time since a player last played a game? Can you check that? Of course, this should be only with players who played at least one game to begin with.

Mine should be over a year ago

Statistics: Posted by Plasma_Wolf — 22 Dec 2015, 12:47

Re: Cool Data

2015-12-22T11:25:02+02:00

Blodir wrote:
The average game is 69 minutes

wtf?

This is measured with real time, not game time

Statistics: Posted by Aulex — 22 Dec 2015, 11:25

Re: Cool Data

2015-12-22T11:24:29+02:00

The average game is 69 minutes

wtf?

Statistics: Posted by Blodir — 22 Dec 2015, 11:24

Re: Cool Data

2015-12-22T11:16:43+02:00

tatsu wrote:
Aulex wrote:7.3621% of active users (defined by greater than 100 games) have played over 1000 games
21.3397% of active users have played over 1000 games

errrrrrrr... those are both the same thing but with a different % .... something's wrong.

other than that fun stats! MickeyMouse lol!

updated

Statistics: Posted by Aulex — 22 Dec 2015, 11:16

Re: Cool Data

2015-12-22T06:46:09+02:00

Aulex wrote:
7.3621% of active users (defined by greater than 100 games) have played over 1000 games
21.3397% of active users have played over 1000 games

errrrrrrr... those are both the same thing but with a different % .... something's wrong.

other than that fun stats! MickeyMouse lol!

Statistics: Posted by tatsu — 22 Dec 2015, 06:46

Cool Data

2015-12-22T11:42:12+02:00

Downlord and I had a little bit of fun on the dev server last night (I think it's 2 months old) calculating different metrics.

Here are some interesting results (Keep in mind these are only ranked games+ladder games):
mickeymouse has the most number of games played: 13467
followed up by
ta4life with 11417 games whose spent 131.29 days in the game
Aulex has 1977 games who spent 52.5914 days in the game
58.0561% who have accounts have never played a game
437.908898150685 years have collectively been put into the game
2.4434% of semi active users (defined by greater than 10 games) have played over 1000 games
7.3621% of active users (defined by greater than 100 games) have played over 500 games
21.3397% of active users have played over 1000 games
The average game is 69 minutes

What a know some other statistics? Request it

Statistics: Posted by Aulex — 22 Dec 2015, 06:10