#Logs twitch code
If you want to take a look at the source code the code is avaliable on github: /ArneVogel/TWS. For some channels the logger has only registered half of all subscriptions. I am going to keep the bot running and will try to make the logging more robust so the data comes more reliable. The three streamers from United States Virgin Islands unfortunately didn’t recieve any subscriptions as far as I can tell with the data :( Future plans Scroll down the page and look for the logout page option. Now press on the three dots from the upper right corner and tap on settings. Where the streamers come from: tws=# SELECT language, count(*) from partner group by language order by count(*) DESC Īnd the number of subscriptions to streamers with their language set to x: tws=# SELECT language, count(*) from partner join subscription on p_id = partner.id group by language order by count(*) DESC Open the twitch app in your mobile phone and press on the profile icon. More than one in 2000 subscriptions on twitch are from champion7b.
Some people have way to much money to throw around. tws=# SELECT u.name, count(u.id) from subscription join users u on u_id = u.id group by u.id order by count(u.id) desc limit 10 Ībove is the number of subs and gifted subscriptions per user. Of all subscriptions 41.5% were prime subs, 55% were $5 subscriptions, 1.78% where $9.99 subs and 1.7% were $24.99 subs. tws=# SELECT sub_plan, count(sub_plan) from subscription group by sub_plan So on average one user subscribes to 1.4 streamers per month. The total number of subscriptions detected by the bot are 1 461 692. tws=# SELECT count(*) from users Īnd to these 9948 streamers are 1 040 416 users that subscribed atleast to one of the partners. Data tws=# SELECT count(*) from partner Įxcactly 9948 streamers chats are monitored for subscriptions as of this writing. Unfortunately the site runs on the same server as the logging bot so it’s quite slow sometimes.
The data is only a small portion of all subscriptions on twitch. The logger isn’t as robust as I would like to have it, it wasn’t logging 100% of the time in each channel and it sometimes counted subscriptions twice when users had the chance to announce a sub multiple times. Note that this the logging wasn’t perfect and this overview is only a distorted view on the ground truth of data that twitch has. Logging Twitch Subscriptions for One Month įor one month now I have been logging twitch subscriptions of channels that have surpassed 50 viewers at one point in the month and are partnered with twitch.
0 kommentar(er)
