1. Introduction.Using @Piggy’s latest full forum member dataset released today (see
Open scraped data of all the users - SQL Lite DB - 2.481.270 users), and comparing it to the one he retrieved roughly a month ago, I wanted to see what the difference in posting habits looked like per rank, during the interval of time between the two snapshots (roughly one month). I wanted to keep it simple, yet meaningful, coming up with the insights depicted in the following sections.
Note: The first DB snapshot was taken between the 03/11/2018 and the 08/11/2018. The second BD snapshot was taken between the 04/12/2018 and the 06/12/2018. There is therefore roughly a 1 month time interval per profile in the data depicted.
2. Number of posts created by Rank![](https://ip.bitcointalk.org/?u=https%3A%2F%2Fi.imgur.com%2FMuv22Vk.png&t=665&c=Ps1M7uVi6Ftxag)
The table above summarizes the number of posts (and merits) created between the two referenced DB snapshots. As we can see:
- 796.538 net posts were created by 53.858 forum members.
- Newbies are the largest creators of content (so as to say), being responsible for 309.351 posts in the period of time analysed (38,84% of all posts created).
- Full Members, Members and Jr. Members are roughly on par in the 12,55%-15,13% range of total posts.
- Legendary, Hero and Sr. Members are in the range of 3,82% to 7,38% of total posts.
- But Newbies on average post 8,4 posts in that period of time, being between 3 and for times higher for the ranks above. I may need to look at this further later on (to see Newbie distribution within their segment).
Note: I have not stripped Copper Members to their underlying ranks, since I wanted to align the results to the data as it was extracted, without altering it. The Brand New users with posts are likely exceptional cases caught in between posting and ranking to Newbies. 3. Number of posts deleted by Rank (negative post number difference).![](https://ip.bitcointalk.org/?u=https%3A%2F%2Fi.imgur.com%2FmWeqRPc.png&t=665&c=OJUEZscClbypPQ)
The above table summarized the number of deleted posts by rank. There are certainly more deleted posts in the time interval analysed, that are compensated by the positive number of posts (i.e. a user creates 20 posts and deleted 3 reflects having created 17 posts). The table shows data for those profiles that have a net decrease in the number of posts.
As we can see:
- 67.248 net posts were deleted by (or in the accounts of) 22.678 forum members.
- Newbies have 35,47% of negative net post attribution, followed by Members (17,99%), Brand New (14,91%) and Full Members (12,41%).
- Average deletion is highest for Brand New members (7,94 posts in the measured period of time on average), likely due to nuked accounts and people deleting a bunch of their post, getting their account drawn back to Newbie rank.
4. Top 25 Post CreatorsThe following list contains the top 25 net post creators in the one month measured period of time:
userid userName rankNow nPostDiff nMeritDiff URL
1740809 cryptolord2077 Full Member 1339 106 https://bitcointalk.org/index.php?action=profile;u=1740809
1741180 Mr.Spider703 Jr. Member 1210 2 https://bitcointalk.org/index.php?action=profile;u=1741180
1740777 Nekroser Jr. Member 1176 2 https://bitcointalk.org/index.php?action=profile;u=1740777
1067333 micgoossens Hero Member 1044 197 https://bitcointalk.org/index.php?action=profile;u=1067333
1745083 kzel2226 Newbie 989 0 https://bitcointalk.org/index.php?action=profile;u=1745083
1742707 TaufiqPD Jr. Member 872 2 https://bitcointalk.org/index.php?action=profile;u=1742707
1747050 bigguga Jr. Member 817 2 https://bitcointalk.org/index.php?action=profile;u=1747050
2340148 Maggiordomo Member 761 2 https://bitcointalk.org/index.php?action=profile;u=2340148
1746838 Tahir460pk Jr. Member 714 4 https://bitcointalk.org/index.php?action=profile;u=1746838
1749739 lKSLMNSLKnkndlksnkJ Jr. Member 656 5 https://bitcointalk.org/index.php?action=profile;u=1749739
1808762 Rimidalv Newbie 617 0 https://bitcointalk.org/index.php?action=profile;u=1808762
1176794 ChiNgadOr Full Member 585 0 https://bitcointalk.org/index.php?action=profile;u=1176794
1745150 Pelana vreo Jr. Member 579 8 https://bitcointalk.org/index.php?action=profile;u=1745150
2418049 johnyjeon Newbie 562 0 https://bitcointalk.org/index.php?action=profile;u=2418049
1741267 Lusya8461 Jr. Member 560 1 https://bitcointalk.org/index.php?action=profile;u=1741267
808310 batang_bitcoin Hero Member 547 3 https://bitcointalk.org/index.php?action=profile;u=808310
479624 Last of the V8s Legendary 543 157 https://bitcointalk.org/index.php?action=profile;u=479624
674078 Gothorum Sr. Member 542 0 https://bitcointalk.org/index.php?action=profile;u=674078
1016855 JollyGood Sr. Member 542 7 https://bitcointalk.org/index.php?action=profile;u=1016855
1733317 minymax1212 Copper Member 534 0 https://bitcointalk.org/index.php?action=profile;u=1733317
2447560 joonjung Newbie 510 0 https://bitcointalk.org/index.php?action=profile;u=2447560
675259 cokroalif Member 507 0 https://bitcointalk.org/index.php?action=profile;u=675259
1747779 Mamoot Member 502 10 https://bitcointalk.org/index.php?action=profile;u=1747779
392914 alevlaslo Hero Member 494 16 https://bitcointalk.org/index.php?action=profile;u=392914
1745890 justhh Newbie 482 0 https://bitcointalk.org/index.php?action=profile;u=1745890
5. Top 25 Post DestroyersThe following list contains the top 25 net post destroyers in the one month measured period of time:
userid userName rankNow nPostDiff nMeritDiff URL
1022815 oleg17 Full Member -779 0 https://bitcointalk.org/index.php?action=profile;u=1022815
14881 Ukigo Hero Member -591 0 https://bitcointalk.org/index.php?action=profile;u=14881
1339716 coinlocket$ Sr. Member -502 68 https://bitcointalk.org/index.php?action=profile;u=1339716
1158497 Yoo Full Member -377 0 https://bitcointalk.org/index.php?action=profile;u=1158497
1894120 madnessteat Member -364 1 https://bitcointalk.org/index.php?action=profile;u=1894120
1062015 CoinCodex Jr. Member -322 0 https://bitcointalk.org/index.php?action=profile;u=1062015
287557 alpho2k Member -301 0 https://bitcointalk.org/index.php?action=profile;u=287557
1393485 EdChain Jr. Member -268 0 https://bitcointalk.org/index.php?action=profile;u=1393485
919324 akmal1984 Sr. Member -264 0 https://bitcointalk.org/index.php?action=profile;u=919324
1269701 cryptoaddictchie Member -264 8 https://bitcointalk.org/index.php?action=profile;u=1269701
516415 rannovan Sr. Member -253 0 https://bitcointalk.org/index.php?action=profile;u=516415
1281378 AAlex48 Member -232 0 https://bitcointalk.org/index.php?action=profile;u=1281378
1333757 ezakmisi Newbie -188 0 https://bitcointalk.org/index.php?action=profile;u=1333757
1112979 yura04071989 Full Member -186 0 https://bitcointalk.org/index.php?action=profile;u=1112979
982595 tarolog Sr. Member -180 0 https://bitcointalk.org/index.php?action=profile;u=982595
1331663 ezakmisa Newbie -167 0 https://bitcointalk.org/index.php?action=profile;u=1331663
225121 franckuestein Staff -165 1 https://bitcointalk.org/index.php?action=profile;u=225121
1065437 fadhilz123 Full Member -164 0 https://bitcointalk.org/index.php?action=profile;u=1065437
2389671 Polizei Jr. Member -163 2 https://bitcointalk.org/index.php?action=profile;u=2389671
1166558 1GUARDIAN Full Member -162 0 https://bitcointalk.org/index.php?action=profile;u=1166558
835622 bitbeanpool Member -154 0 https://bitcointalk.org/index.php?action=profile;u=835622
1270528 Alsem23 Member -151 0 https://bitcointalk.org/index.php?action=profile;u=1270528
1232646 salavat111 Member -150 0 https://bitcointalk.org/index.php?action=profile;u=1232646
1495332 Pranimbo Jr. Member -150 0 https://bitcointalk.org/index.php?action=profile;u=1495332
46978 cashfinder Brand new -146 0 https://bitcointalk.org/index.php?action=profile;u=46978
Edit: Full non-cero created post balance:
https://docs.google.com/spreadsheets/d/179qRGqfO4H_UJu_tafs3qXhLsl4iq85YncisqhL1kbc/edit?usp=sharing