Top 50 streamers in August 2012 - Page 3

On September 04 2012 07:28 Xiphos wrote:
wtf is day9

[On September 04 2012 04:36 Conti wrote:Teamliquid takes the viewer numbers straight from the streaming sites, so it doesn't matter where you're watching the streams from. I could do the same to get slightly more accurate numbers, but that's way more work than just taking them straight from TL..

On September 04 2012 01:17 Conti wrote:

Well, let's see.. These are the total numbers of viewers watching a SC2 player stream in a given month (so I'm excluding casters, events and other games):

sqlite> select log.game,sum(viewers) from log inner join dates on dates.d_id=log.d_id inner join players on players.p_id=log.p_id
 where date>"2012-04" and date<"2012-05" and log.game="SC2" and players.streamertype="Player" group by log.game;
SC2|21975553
sqlite> select log.game,sum(viewers) from log inner join dates on dates.d_id=log.d_id inner join players on players.p_id=log.p_id
 where date>"2012-05" and date<"2012-06" and log.game="SC2" and players.streamertype="Player" group by log.game;
SC2|16540003
sqlite> select log.game,sum(viewers) from log inner join dates on dates.d_id=log.d_id inner join players on players.p_id=log.p_id
 where date>"2012-06" and date<"2012-07" and log.game="SC2" and players.streamertype="Player" group by log.game;
SC2|16310764
sqlite> select log.game,sum(viewers) from log inner join dates on dates.d_id=log.d_id inner join players on players.p_id=log.p_id
 where date>"2012-07" and date<"2012-08" and log.game="SC2" and players.streamertype="Player" group by log.game;
SC2|15699150
sqlite> select log.game,sum(viewers) from log inner join dates on dates.d_id=log.d_id inner join players on players.p_id=log.p_id
 where date>"2012-08" and date<"2012-09" and log.game="SC2" and players.streamertype="Player" group by log.game;
SC2|16604833

The numbers themselves don't really mean much, but they allow us to see a trend. And in this case we can see that the viewer numbers have been mostly steady in the last few months after a noticeable decline in May. Back then it has been speculated that Summer is to blame.


Whoops, my bad. You're quite right, somehow I missed the two IM players. I'll fix the OP. Still, there's less and less Korean team players streaming every month. :/


I don't have any numbers for TSL3, but here's the numbers for TSL4 so far:

sqlite> select events.name,avg(viewers) from log inner join events on events.e_id=log.e_id
 where events.name>"TSL4 Round" and events.name<"TSL5" and log.p_id=5642 group by log.e_id;
TSL4 Round of 32 Day 1|17457.5714285714
TSL4 Round of 32 Day 2|21978.5555555556
TSL4 Round of 32 Day 3|15957.875
TSL4 Round of 32 Day 4|23352.0454545455
TSL4 Round of 16 Sunday|13474.6315789474
TSL4 Round of 16 Monday|16443.2272727273
TSL4 Round of 8 Day 1|8554.17647058824
TSL4 Round of 8 Day 2|13729.0476190476
TSL4 Semifinals|10622.4285714286
sqlite>

The numbers depend a lot on the competition. Going head-to-head with The International sure didn't help TSL's viewership.

Also, I'm sorry guys that I'm not presenting numbers like these in a more pretty format in the OP. Life's keeping me too busy to do that currently. :/

On September 04 2012 00:25 SnowSC2 wrote:

It seems like if you start streaming a lot, your average viewer count will deflate to a more steady number. Idra used to pull a metric ass-ton when he rarely streamed, and now that he streams more he has less on average (yet obviously he will still make more from simply streaming more.)

On September 04 2012 00:25 SnowSC2 wrote:

It seems like if you start streaming a lot, your average viewer count will deflate to a more steady number. Idra used to pull a metric ass-ton when he rarely streamed, and now that he streams more he has less on average (yet obviously he will still make more from simply streaming more.)

On September 08 2012 15:41 Nathanias wrote:
I'm not with a51, I enjoy being on this list but wish I was better. Hopefully I will improve enough to deserve this status and eventually get onto a team or be featured ><