Bitcoin Forum

Other => Meta => Topic started by: seoincorporation on October 26, 2018, 03:03:11 PM



Title: Almost 2.5M users registered but only 30k accounts
Post by: seoincorporation on October 26, 2018, 03:03:11 PM
After having some fun with the nice Piggy's Merit Data SQL tool (https://bitcointalk.org/index.php?topic=4551881.0) i realized the total users on the 'UserData' table was a lil more than 30,000. But the last user ID was 2450245.

here the question is; did admin and mods ban 2,420,254 accounts? Or something is wrong with the DB query?

https://albertoit.github.io/Merit-Explorer-SQL/ (https://albertoit.github.io/Merit-Explorer-SQL/)
Code:
SELECT count(UserName) FROM UserData;
Quote
count(UserName)
30858


Title: Re: Almost 2.5M users registered but only 30k accounts
Post by: TryNinja on October 26, 2018, 03:08:29 PM
I'm pretty sure this DB only has data about users who received or sent at least one merit (since the data is probably taken from theymos' weekly merit history file). If there is no merit transaction coming from your account, you can't be in that database.

So, 30858 accounts have received/sent merit at least once.

This is a tool that allow you to run full SQL queries over the merit data and is based on SQLite (https://www.sqlite.org/index.html). If you are familiar with SQL you know the possibilities are basically endless or limited to your SQL knowledge.


Title: Re: Almost 2.5M users registered but only 30k accounts
Post by: DdmrDdmr on October 26, 2018, 03:31:01 PM
<Ö>
Itís as @TryNinja points out. The driver for the data is the cumulative of merit.txt files, so basically there are all the sMerit TXs since day one, along with the name of the board,  sub-board and thread involved.  In addition, all user profiles involved are provided (whether they are senders or receivers) , but no information is retrievable if there is no associated merit TX involved.


Title: Re: Almost 2.5M users registered but only 30k accounts
Post by: iasenko on October 26, 2018, 04:07:36 PM
According to Vod's BPIP database, there are 326,673
Active Profiles.
That will say that those account have been active for the last 30 days.
Of course many people log in not so frequently, so those numbers are approximate


Title: Re: Almost 2.5M users registered but only 30k accounts
Post by: seoincorporation on October 26, 2018, 04:30:10 PM
So, 30858 accounts have received/sent merit at least once.
Thanks for the info, now all have sense, but I think 30k users active on the merit system still a low number.

<Ö>
Itís as @TryNinja points out. The driver for the data is the cumulative of merit.txt files, so basically there are all the sMerit TXs since day one, along with the name of the board,  sub-board and thread involved.  In addition, all user profiles involved are provided (whether they are senders or receivers) , but no information is retrievable if there is no associated merit TX involved.
My confusion comes from the two tables on the link I posted, there we see 'MeritData' and 'UserData' tables, i think the users one was the full user's list because the information we get from this table doesn't mention  Merits (It only give UserId, UserName and Rank)


According to Vod's BPIP database, there are 326,673
Active Profiles.
That will say that those accounts have been active for the last 30 days.
Of course many people log in not so frequently, so those numbers are approximate


Well, close to 10% of the total users are active, but let's remember a lot of people use multiple accounts, but 326k still a big number.

Thanks for the information guys  :D


Title: Re: Almost 2.5M users registered but only 30k accounts
Post by: jackg on October 26, 2018, 05:43:25 PM
According to Vod's BPIP database, there are 326,673
Active Profiles.
That will say that those account have been active for the last 30 days.
Of course many people log in not so frequently, so those numbers are approximate


And only 30k sent or recieved merits?

Granted a lot of the rest will be alts/bounty or spammers but not receiving a single merit is a bit weird. Thatís less than 10%.

Granted some will be bots parsing the forum or copy-pasting but still, that number is ridiculously low.


Title: Re: Almost 2.5M users registered but only 30k accounts
Post by: manfredmann on October 26, 2018, 06:15:47 PM

And only 30k sent or recieved merits?

only time will tell for this since this is the start of something good to bitcoin.Bitcoin os a global ctypto and so it will do also the same with the forum. It was forseen by admin that forum still continue to be global. So, the merit implementation with users receive or sent with more less 30k users is not that bad. Reminders than one should need to get at least 1 merit to rank up to jr. member. The forum users with 2m registered on it states that only few knew about forun.



Title: Re: Almost 2.5M users registered but only 30k accounts
Post by: dogtana on October 28, 2018, 08:45:06 PM
Is there any statistic showing the total number of members of a particular rank? For example how many newbs, juniors, members, full members etc there are? That would be interesting to see.


Title: Re: Almost 2.5M users registered but only 30k accounts
Post by: Don Pedro Dinero on October 28, 2018, 08:52:26 PM
Is there any statistic showing the total number of members of a particular rank? For example how many newbs, juniors, members, full members etc there are? That would be interesting to see.

Have a look at this: https://bitcointalk.org/index.php?topic=5057502.msg47358062#msg47358062


Title: Re: Almost 2.5M users registered but only 30k accounts
Post by: cryptovigi on October 28, 2018, 08:56:42 PM
Is there any statistic showing the total number of members of a particular rank? For example how many newbs, juniors, members, full members etc there are? That would be interesting to see.

here you are but stats are from the end of september... if you want more data check full thread:

...
Merit system works about 8,5 month, since introducing 251.653 merits was given for the post writing, they came to 22.547 users (from 2,400,000 users registered what is less than 1%!!!).

Below you can see how many users and number of merit was awarded in each group of users.
You can see that the largest group of users 56,47% who have ever earn merit are users who start their posting career after introducing new system Ė what meansÖ newbies!!! Looking at numbers of merit the situation is the same this group have earned the largest part of merit (for posting).
Of course you always can say that many of them didnít get their merit in proper way Ė bought them, begged for them etc. but it still remains the largest group.
...


Title: Re: Almost 2.5M users registered but only 30k accounts
Post by: mazdafunsun on October 29, 2018, 11:11:31 AM
After having some fun with the nice Piggy's Merit Data SQL tool (https://bitcointalk.org/index.php?topic=4551881.0) i realized the total users on the 'UserData' table was a lil more than 30,000. But the last user ID was 2450245.

According to Vod's BPIP database, there are 326,673

30k accounts who have recived merit is not such a small number if you take in account how many users are actively posting in forum.

I have taken time to do user activity research in depth here: https://bitcointalk.org/index.php?topic=5046264.msg46655791#msg46655791
I analysed 2,37 Million users and used several criteria to evaluate user activity.

And one of them was, how many users have made a post in last 3 months. The result was: Including Newbies 137122 users, excluding newbies 31211

This activity criteria is more relavent if we talk about recived merits since non posting users will not recive merit ( except some special cases with very old posts).

Is there any statistic showing the total number of members of a particular rank? For example how many newbs, juniors, members, full members etc there are? That would be interesting to see.

Take a look at the end of the this post: https://bitcointalk.org/index.php?topic=5046264.msg46655791#msg46655791
I believe that this is the " freshest" user data with distrobution by rank.


Title: Re: Almost 2.5M users registered but only 30k accounts
Post by: iasenko on October 29, 2018, 11:22:46 AM
@mazdafunsun

I was wrong about the active members, I was on a mobile I couldn't get the correct info from BPIP website.
Now, according to Vod, the BPIP's Active Profiles are those who have logged in at least once for the last 3 mounts.
Here is the final update from today > 322,676 Active Profiles