Things you really want to see in "Cantr Statististics
Moderators: Public Relations Department, Players Department
- SekoETC
- Posts: 15525
- Joined: Wed May 05, 2004 11:07 am
- Location: Finland
- Contact:
Re: Things you really want to see in "Cantr Statististics
4'1 - 4
4'2 - 2
4'3 - 1
4'4 - 1
4'5 - 1
4'6 - 0
4'7 - 1
4'8 - 2
4'9 - 4
5'0 - 1
5'1 - 3
5'2 - 15
5'3 - 23
5'4 - 31
5'5 - 39
5'6 - 52
5'7 - 18
5'8 - 18
5'9 - 24
5'10 - 26
5'11 - 25
6'0 - 5
6'1 - 14
6'2 - 22
6'3 - 10
6'4 - 12
6'5 - 8
6'6 - 3
6'7 - 1
6'8 - 4
6'9 - 1
Fortunately no one taller than that, unless they're over 7 feet tall.
I'm not going to go into searching for feet because there are so many ways that could be written.
61 petite
8 giant
302 large
419 small
846 tall
827 short
There are 2 with sectoral heterochromia, 1 heterochromatic. This of course can't count all the people who write "his/her right eye is color1 and left eye is color2".
4'2 - 2
4'3 - 1
4'4 - 1
4'5 - 1
4'6 - 0
4'7 - 1
4'8 - 2
4'9 - 4
5'0 - 1
5'1 - 3
5'2 - 15
5'3 - 23
5'4 - 31
5'5 - 39
5'6 - 52
5'7 - 18
5'8 - 18
5'9 - 24
5'10 - 26
5'11 - 25
6'0 - 5
6'1 - 14
6'2 - 22
6'3 - 10
6'4 - 12
6'5 - 8
6'6 - 3
6'7 - 1
6'8 - 4
6'9 - 1
Fortunately no one taller than that, unless they're over 7 feet tall.
I'm not going to go into searching for feet because there are so many ways that could be written.
61 petite
8 giant
302 large
419 small
846 tall
827 short
There are 2 with sectoral heterochromia, 1 heterochromatic. This of course can't count all the people who write "his/her right eye is color1 and left eye is color2".
Not-so-sad panda
- EchoMan
- Posts: 7768
- Joined: Fri Aug 26, 2005 1:01 pm
- Location: Stockholm, Sweden
Re: Things you really want to see in "Cantr Statististics
cm's?
Lots of metric people on here.

- SekoETC
- Posts: 15525
- Joined: Wed May 05, 2004 11:07 am
- Location: Finland
- Contact:
Re: Things you really want to see in "Cantr Statististics
Could look at round numbers like 150/155/160/165/170/175/180 but if somebody has used something more precise like 163 and a half, they wouldn't show up. I'm not going to start searching for every possible number separately.
Not-so-sad panda
- Wolfsong
- Posts: 1277
- Joined: Sun Dec 13, 2009 5:33 am
- Location: Australia
Re: Things you really want to see in "Cantr Statististics
Breakdown of towns by population of new accounts created in them, not new characters (so under whatever days, weeks old.)

- masterekat
- Posts: 496
- Joined: Thu Sep 02, 2010 9:55 pm
- Location: Spa City, Arkansas
Re: Things you really want to see in "Cantr Statististics
Locations by language with the most notes and characters by language holding the most notes.

- SekoETC
- Posts: 15525
- Joined: Wed May 05, 2004 11:07 am
- Location: Finland
- Contact:
Re: Things you really want to see in "Cantr Statististics
Wolfsong wrote:Breakdown of towns by population of new accounts created in them, not new characters (so under whatever days, weeks old.)
I don't think it's possible to write such a query, if I even understood what you meant by that request. I interpreted so that I should get the spawning location of the first character on each account that's sufficiently new, then count how many times each town is represented in the set of data and order them by which ones are the most common. The only way of potentially doing that seems to be to order it by character id and group by player, in which case if you select spawning location, it hopefully gives the spawning location of the first character on each account, since each player is only represented once, but in order to get how many times each town is represented, I would have to copy the data to a new table, and apparently the database got overstressed by trying to figure out how to do this.
Edit:
This includes accounts with id greater than 100000. I'm not quite sure if they're actually the player's first character in each case but hopefully it is, because it was so much trouble to get.
People's first-spawns / Town
242 Vlotryan
71 Cechowice
45 Eden
40 Zatoka Urodzaju
37 Eden Majklimburski
33 Kishnakotis
27 Dom Bojran
24 Bojholm
23 Abramowo
21 Grande Chifre
15 Seatown
15 Longinazy Forest (west)
15 Pakrante
13 Snavirn forest (south)
13 Lusitania
13 Apolodoro
12 Blojt Forest East
12 Morkalva
11 Brunoi
11 Mil Cavernas
Not-so-sad panda
- Cwalen
- Posts: 276
- Joined: Sun Jan 30, 2011 5:08 am
Re: Things you really want to see in "Cantr Statististics
I am still beating the drum for.
How long before the average newby stops twitching?
Is there, as I have some indication of and expect.
80% death before significant interaction.
15% three days or more.
4% Actually gives it a go.
and the golden 1% who have the time frame and intelligence to have the potential to be real players.
It's really mission critical data. Rd needs it, PD needs it, marketing needs it more than a years worth of advertising.
I mostly want it to check if I still have my eye in for estimating the general populaces response to an online world.
How long before the average newby stops twitching?
Is there, as I have some indication of and expect.
80% death before significant interaction.
15% three days or more.
4% Actually gives it a go.
and the golden 1% who have the time frame and intelligence to have the potential to be real players.
It's really mission critical data. Rd needs it, PD needs it, marketing needs it more than a years worth of advertising.
I mostly want it to check if I still have my eye in for estimating the general populaces response to an online world.
The avalanche has begun, it is useless for the pebbles to vote.
- SekoETC
- Posts: 15525
- Joined: Wed May 05, 2004 11:07 am
- Location: Finland
- Contact:
Re: Things you really want to see in "Cantr Statististics
But it's not recorded how many times a character says something or how many times a player clicks various links before they give up.
Not-so-sad panda
- Chris
- Posts: 856
- Joined: Sat May 05, 2007 1:03 pm
Re: Things you really want to see in "Cantr Statististics
SekoETC wrote:But it's not recorded how many times a character says something or how many times a player clicks various links before they give up.
How about time between registration (or first login) and last login?
- SekoETC
- Posts: 15525
- Joined: Wed May 05, 2004 11:07 am
- Location: Finland
- Contact:
Re: Things you really want to see in "Cantr Statististics
I wrote some false statistics here.
Last edited by SekoETC on Thu Jul 07, 2011 5:26 pm, edited 1 time in total.
Not-so-sad panda
- Chris
- Posts: 856
- Joined: Sat May 05, 2007 1:03 pm
Re: Things you really want to see in "Cantr Statististics
SekoETC wrote:Only counting non-active accounts created within the last 365 days:
Last date and registering date are the same: 22268 [62.7%]
Last day is 1 day after registering date: 4246 [12.0%]
Last day is 2-4 days after registering date: 2693 [7.6%]
5 to 9 days: 1472 [4.1%]
10 to 29 days: 1402 [3.9%]
30 to 59 days: 614 [1.7%]
60 to 99 days: 443 [1.2%]
100 to 199 days: 559 [1.6%]
200 to 365 days: 1823 [5.1%]
I added percentages above, based on a total of 35,520.
The good news is that we have a lot of people looking at Cantr. The bad news is that most don't even stay for a week.
- Doug R.
- Posts: 14857
- Joined: Wed Mar 23, 2005 6:56 pm
- Contact:
Re: Things you really want to see in "Cantr Statististics
So, then, the next obvious question is, how many accounts, in total, have been created in the last 365 days, so we can see the retention percentage?
Hamsters is nice. ~Kaylee, Firefly
- SekoETC
- Posts: 15525
- Joined: Wed May 05, 2004 11:07 am
- Location: Finland
- Contact:
Re: Things you really want to see in "Cantr Statististics
I must've done something wrong because the amount of accounts created in that time is 4355, much less than the 20k. Maybe it was characters rather than players. In any case, the numbers are all wrong.
Actual number of expired accounts that were last accessed the same day they were created: 2572
1 day: 527
2 to 4: 286
5 to 9: 137
10 to 29: 158
30 to 59: 97
60 to 99: 43
100 to 199: 57
200 to 365: 27
Actual number of expired accounts that were last accessed the same day they were created: 2572
1 day: 527
2 to 4: 286
5 to 9: 137
10 to 29: 158
30 to 59: 97
60 to 99: 43
100 to 199: 57
200 to 365: 27
Not-so-sad panda
- Doug R.
- Posts: 14857
- Joined: Wed Mar 23, 2005 6:56 pm
- Contact:
Re: Things you really want to see in "Cantr Statististics
So, we're looking at a 1 year retention rate of 10.36%. Honestly, from what I've heard, that's really, really damn good. I heard a typical retention rate is about 2%.
So really, if we have an excellent retention rate, all we need to do is keep players older than 1 year from quitting, and we'll have decent growth. To do that, we need to make the game more open-ended.
Edit: Maybe the 2% was clickthrough rate on banner ads. Still, I don't think 10% is too too bad. How many of those on the far end of the time spectrum come back? It could be more than 10%, ultimately.
So really, if we have an excellent retention rate, all we need to do is keep players older than 1 year from quitting, and we'll have decent growth. To do that, we need to make the game more open-ended.
Edit: Maybe the 2% was clickthrough rate on banner ads. Still, I don't think 10% is too too bad. How many of those on the far end of the time spectrum come back? It could be more than 10%, ultimately.
Hamsters is nice. ~Kaylee, Firefly
- Doug R.
- Posts: 14857
- Joined: Wed Mar 23, 2005 6:56 pm
- Contact:
Re: Things you really want to see in "Cantr Statististics
Follow up: How many accounts are still active that were created:
Within 366-730 days ago
Within 761-1095 days ago
etc, etc.
Within 366-730 days ago
Within 761-1095 days ago
etc, etc.
Hamsters is nice. ~Kaylee, Firefly
Return to “General Discussion”
Who is online
Users browsing this forum: No registered users and 1 guest