Almost 2.5M users registered but only 30k accounts

[seoincorporation]

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/

Code:

SELECT count(UserName) FROM UserData;

count(UserName)
30858

[1713529487]

1713529487

[1713529487]

1713529487

[TryNinja]

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. If you are familiar with SQL you know the possibilities are basically endless or limited to your SQL knowledge.

[DdmrDdmr]

<…>

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.

[TheBeardedBaby]

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

[seoincorporation]

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  

[jackg]

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.

[manfredmann]

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.

[dogtana]

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.

[Don Pedro Dinero]

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

[cryptovigi]

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.
...

[mazdafunsun]

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.

[TheBeardedBaby]

@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