Guest User

Untitled

a guest
Jun 3rd, 2025
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.09 KB | None | 0 0
  1. Notes
  2. - Chat messages are only taken from when the stream is live
  3. - All sub/bits data is taken from chat so anyone not sharing their resub is not included
  4. - Anyone that gifts offline is not included
  5. - "Income/earnings" is a rough estimate because of the above and regional pricing so make of it what you will
  6. - Prices I used
  7. ○ T1 sub = $3.5
  8. ○ T2 sub = $7.0
  9. ○ T3 sub = $17.5
  10. ○ Prime sub = $2.25
  11. ○ 100 bits = $1
  12.  
  13.  
  14. May all users # of chat messages - https://files.catbox.moe/klt0d2.csv
  15. May top 100 users with chat they are most active in - https://files.catbox.moe/dxw4x3.csv
  16. Raw sub + bits data - https://files.catbox.moe/vmvttm.csv
  17. Average ccv + hours streamed (scraped from SullyGnome) - https://files.catbox.moe/wq78am.csv
  18.  
  19.  
  20. Random notes
  21.  
  22. https://files.catbox.moe/ecf0c9.png
  23. Fixed time stamp column in the raw chat dataset, nothing really surprising here. Mornings are slow, ramps up in the evenings. Nice to see confirmation though of what many people assumed. Time is in EST (probably)
  24.  
  25.  
  26. CCV compared to March, looks like I never ran the script for this data in April
  27.  
  28. ccv_range_march,avg_ccv_march,avg_ccv_may,avg_diff,avg_percent_change,streamer_count
  29. 100-499,279.57,294.38,14.82,6.17,60
  30. 500-999,705.8,741.09,49.43,6.12,45
  31. 1000-1999,1515.08,1697.08,182.0,12.16,24
  32. 2000+,3476.06,3884.29,408.24,14.29,34
  33.  
  34.  
  35. Nothing too informative here but it's nice to see the law of large numbers in practice. Labels could have been a bit better here, the total and N+ Msgs columns are the number of chatters with more than N messages and not counts of messages. May for example reads as 291,459 total chatters across all streams, only 92,861 chatters (32%) sent more than 10 messages.
  36.  
  37. Month Total 10+ Msgs % 10+ 100+ Msgs % 100+ 1000+ Msgs % 1000+
  38. May 291,459 92,861 32% 24,308 8% 3,423 1%
  39. April 283,058 85,570 30% 21,694 8% 2,965 1%
  40. March 283,128 84,211 30% 21,831 8% 3,089 1%
  41. Febr 272,240 82,814 30% 21,060 8% 2,956 1%
  42. Jan 302,565 93,201 30% 23,650 8% 3,131 1%
  43.  
  44.  
  45.  
  46.  
Add Comment
Please, Sign In to add comment