rawb
Wednesday, October 6, 2021
have you redownloaded windows at all
everything assumed I had a new device when I did
A fresh windows install is considered a new windows source even if it’s onto the same drive which is dumb
almost there
he streamed back at the early part of where that data comes from
but yeah he has something like 1000 subs
despite not streaming
God
I downloaded the data
its broken down
into a lot more info than I realized
You need ids (which I have for rob)
its broken up into payout periods
and breaks down all sources
so I can get robs ads, subs, bits
for example
rob got 2800 from ads, 135 from subs
this payout
This will take me quite a bit of time to go through
Hit the first major roadblock
I do not actually own excel
lol
so it does not let me edit (i.e, copy paste) the info
so I am uploading the shit to drive so I can open it in sheets
That's cool as hell
That it's that detailed
I have the data set pulled
gonna start doing some visualizations with it
I can't wait to get home later and see
for now, here is all the raw data
that we got from the leak
First graphic
ignore the downspike at the start. So the dataset gave partial data for june 2019, but that did not include sub/prime subs
so its just a lot lower
Ad revenue
Subs
Tf is that spike in subs
we don't know, we will have to think about rob lore that happened during july
Bits
Prime subs
I will now post all of them in bar chart form since bar charts are also nice for visualization
Divided by the number of months we have data for
Here is what I had to deal with btw
Alright, here is all the meaningful things I can think of. If you guys want more data analysis of a specific form, let me know
standard deviation is by year for each respective column obviously
I am mostly confident rob gets a 70/30. He'd have to have 400+ subs to get the earnings he did if it was 50/50 last month
that seems unlikely
70/30 only needs 307 subs
https://docs.google.com/spreadsheets/d/1Nt23qrmQ-upLecKowNmBPgc7hyJMutzSqPBYZ5nh1Ow/edit?usp=sharing Here is the data for those who wants it
Actual raw data is hard to go through, so if you guys want any other channels, it would take me time (and I'd need their twitch id)
since this chatroom is basically twitch leak chat
I did some more digging
on my files
I have some more rob info
that I need to figure out what it means
What’s the data I may be able to help decipher
I have some downtime at work for once
24019930,nofee,2809,N/A,N/A,N/A,N/A,2014-10-27T23:48:52Z,2011-10-19T19:39:59Z,partner,