Top 20 members with Post to Merit Ratio.

[mikeywith]

 
    Using piggy's data which is amazingly pulled of the forum. and just for fun , i wanted to know who has the best Post to Merit ratio ( not sure if should be Merit
     to Post) but you get the point.


    



    while most if not all of these people are simply merit abusers, it surprises me that some of them "checked a few randomly" have not been given any negative trust feedback.


*sorry for the bad data representation, it is the best i have in hand now.

edit* i know most of these users are not longer around, but some are active up to now, and their merit to post ratio is very questionable. and even some of those who are long gone, the people who gave them a dozen of merits for nothing are still around.

here are some random posts appeared from the data with crazy ass merits >

https://bitcointalk.org/index.php?topic=2169466.msg30174930#msg30174930
https://bitcointalk.org/index.php?topic=1162392.msg47898171#msg47898171
https://bitcointalk.org/index.php?topic=3127999.msg32372749#msg32372749
https://bitcointalk.org/index.php?topic=5042266.msg46870695#msg46870695
https://bitcointalk.org/index.php?topic=5042266.msg46870747#msg46870747
https://bitcointalk.org/index.php?topic=2180877.msg43346652#msg43346652
https://bpip.org/smerit.aspx?to=deadsea33   > 90 merits from the same member on the same topic  
https://bpip.org/smerit.aspx?to=TNM1WPCK > same shit

https://bitcointalk.org/index.php?action=profile;u=1180530 > legit , with impressive ratio ( almost 2 merits per post )
https://bitcointalk.org/index.php?action=profile;u=2371316 > legit , better than satoshi and theymos performance combined  (5.6 ratio)
 

*when i have more time, i'll try to make a script the pulls every specious merit action, will be using vod's webiste along with piggy's database. if there are any more resources please enlighten me.

Enjoy the holidays.

[1715009609]

1715009609

[S_Therapist]

Those are users who have been nuked because of spamming or other reason. And those merits are airdropped merit, only exception is the one who got 77 merits.

Edit:

Those are users who have been nuked because of spamming or other reason.

Only Newbies can be nuked. They probably deleted their posts on their own.

Thank you for sharing this. I was not aware of it.

[Alex_Sr]

...

Such calculations are not quite correct:

1. Users simply deleted their posts, and not received merit for 1 post
2. It makes sense to consider the ratio of the earned merit, not the merit, obtained by airdrop

But this is already done in this LoyceV topic:

Percentage of Merit received on old posts, deleted posts, and average per post
 

[Upgrade00]

Some of these account may have been hacked and the new user deleted majority of the old posts and that led to the high ratio of merits per post.
I am not entirely sure, but some could also be users who received airdropped merits and then deleted all their old posts.
Although some is pretty obvious merit abuse.

[mikeywith]

...

Such calculations are not quite correct:

1. Users simply deleted their posts, and not received merit for 1 post
2. It makes sense to consider the ratio of the earned merit, not the merit, obtained by airdrop

But this is already done in this LoyceV topic:

Percentage of Merit received on old posts, deleted posts, and average per post
  

the link you posted ,  Loycev only took a few examples and compared old to new post's merit.

also if you take this user for example > https://bpip.org/smerit.aspx?to=VeilDango

he has better ratio than satoshi and theymos ( 3.64 merit per new post)

i know the majority of these members are long gone. but a few of them are there around and active, and you will be amazed of the ratio they have compared to other well known members.

I will make a better flirtation " probably after the holiday" that will be more in depth of users who have the most merits compared to their post count.

[Alex_Sr]

...

Yes, there are users with earned Merit with a high ratio Merit / Post:

	Name:	Merit received	Posts total	Merit per post
	cheddur_announce	67	1	67,0
	saginaw32	65	1	65,0
	TeleX AI	50	2	25,0
	nessie.io	148	8	18,5
	unknownids	55	5	11,0
	peterparker9191	74	7	10,57
	DECENT Marketing	60	6	10,0
	Battlestar_Coin	78	10	7,8
	YumukluSucurta	100	14	7,14
	coffeandtango	100	16	6,25
	kerem89	100	17	5,88

Merits they have received mostly deleted posts

[Marshall14]

It may actually be difficult to get an accurate data,as many users have either cleared up their post history for one reason or the other or have stopped posting on the forum
You'll need more in depth materials and probably a history of such users posts,deleted or not(if thats possible)

[LoyceV]

Those are users who have been nuked because of spamming or other reason.

Only Newbies can be nuked. They probably deleted their posts on their own.

also if you take this user for example > https://bpip.org/smerit.aspx?to=VeilDango

he has better ratio than satoshi and theymos ( 3.64 merit per new post)

Allow me to check his data:
User VeilDango (full history)

• Received a total of 134 Merit up to last Friday.
• Received 0 Merit for 0 of 0 posts created before the introduction of Merit.
• Received 134 Merit (100.00%) for 4 (10.81%) of 37 posts created after the introduction of Merit (3.6216 Merit per new post).
• Received 0 Merit for posts that are now deleted.

He received many Merits for this ANN post, including 50 from one Legendary who hasn't earned a single Merit on his own.

This thread lists the anomalies who did something weird, not the ones who actually earned that much Merit for real posts. Even worse: it includes the airdropped Merit, which wasn't earned at all.
If you get me a list of userIDs, I can list them in the format as below.

This is an interesting account, who received 50 Merit from theymos:
User johank (full history)

• Received a total of 79 Merit up to last Friday.
• Received 0 Merit for 0 of 0 posts created before the introduction of Merit.
• Received 78 Merit (98.73%) for 6 (42.85%) of 14 posts created after the introduction of Merit (5.5714 Merit per new post).
• Received 1 Merit (1.26%) for posts that are now deleted.

[DdmrDdmr]

<…>

We really have to be careful using data to retrieve useful close to truthful information. What you have done is divide personal total merit by number of posts, and that is conceptually wrong on two accounts:

-   The merit column represents the profiles total merit, including airdropped merit (not just earned merit).
-   Posts accounts for all the posting history (not narrowed down to Merit era or more recent).

@LoyceV has a topic on the matter, as stated by @Alex_Sr, with a focus that separated meaningfull concepts. Back in October, I created a post called Analysis – Personal merit per day, merit per post and ranking-up projections where I focused on the last four months to only take into account recent data.

Information, if not treated properly, is not only misleading, but points back false conclusions.

[Gabteb]

Ah it feels like this Merit system stoped me on sr.Member forever as noone want give metis so i dont understand how to get metits for Hero member as already have more than 600 Activity but only 256 meits for this moment so dont imagine how to get more 250 merits its realy impossible for me at this moment.

[Alex_Sr]

Ah it feels like this Merit system stoped me on sr.Member forever as noone want give metis so i dont understand how to get metits for Hero member as already have more than 600 Activity but only 256 meits for this moment so dont imagine how to get more 250 merits its realy impossible for me at this moment.

If you really want it - it's quite real! I registered on the forum on January 27, 2018 and started with 0 merits.

[bitmover]

I believe an Activity/Merit ratio would be a much more useful statistics

In this case, even the airdropped merit could be considered, as users with airdropped merit have high activity.

[mikeywith]

<…>
We really have to be careful using data to retrieve useful close to truthful information. What you have done is divide personal total merit by number of posts, and that is conceptually wrong on two account:

-   The merit column represents the profiles total merit, including airdropped merit (not just earned merit).
-   Posts accounts for all the posting history (not narrowed down to Merit era or more recent).

everyone who registered before the merit system got the airdropped merit, so i thought comparing those who got the airdropped merit to one another is not wrong since they all had the same base record based on their activities/post by then. so eventually that should takes out the airdropped merit out of calculation, at least mathematically speaking.but this will be unfair to those who did not witness the airdrop, so you are right, the data we have now is far from accurate to be treated the way i treated it, seems like the vast majority of the best merit ratio members are only at their rank simply because they got the airdrop merit and never really posted after or before that, which brings their post count close to nothing allowing them to be on the top list. maybe the airdropped merits should have been given in a better form. take a look at this guy for insanse > https://bitcointalk.org/index.php?action=profile;u=957841 . got 100 merit airdropped with only 12 posts.

but you have a valid point in this, for this to be a more accurate representation of post quality , we need to count only the earned merits. in which case a few unknown members have some very good ratio.

I will be looking at your analysis along side with LoyceV's , thanks for the input.

This thread lists the anomalies who did something weird, not the ones who actually earned that much Merit for real posts. Even worse: it includes the airdropped Merit, which wasn't earned at all.

If you get me a list of userIDs, I can list them in the format as below.

ya i have no clue why i ended up posting the abnormal and weird accounts, but honestly that's the db has, most of the top 100 members i got after taking the merit to post ratio into count were some crazy shit and merit abused, but mathematically speaking, there is nothing wrong with the list  , most other top merited people had their airdropped merits too, so that alone is not the main cause for this terrible report, the main reason is that most of those people stopped posting after they got the the pre merit,which made their ratio far too good to be true.

the query was nothing fancy really, just a simple straight forward
 
 

Code:

select username , (merit/posts) from table order by (meriy/posts) desc limit 20 

i would like to see you run the data on those, as for now i have no clue how to get the earned merits only as it's not on piggy's db, are you using some script to pull the data or someone has another db for it?

anyway I will try to give you a list of userIds that have earned the merit with good ratio but for now all i have in hand is the merit count, i will be ignoring fixed numbers such 100,250,500,1000 which i believe those represent the airdroped merit. but that still will require some manual work.

cheers.

it is not impossible, it is not even hard, you get merits you post on boards you are good at, and you can help others. by doing so , you will get merits without even trying. it's true that the merit system is not perfect, but to a very good extent it does represent one's posts's quality. so just focus on what you good at.


 

[LoyceV]

maybe the airdropped merits should have been given in a better form. take a look at this guy for insanse > https://bitcointalk.org/index.php?action=profile;u=957841 . got 100 merit airdropped with only 12 posts.

The airdrop was based on the user's rank at that moment. To receive 100 Merit, that user must have had a Full Member rank. He deranked by deleting his posts.

ya i have no clue why i ended up posting the abnormal and weird accounts

That happens when you sort all accounts based on extremes.

i have no clue how to get the earned merits only as it's not on piggy's db, are you using some script to pull the data or someone has another db for it?

I've created this list, which shows how many Merit points each user has received after the airdrop.

i will be ignoring fixed numbers such 100,250,500,1000 which i believe those represent the airdroped merit. but that still will require some manual work.

That's not enough: someone with 260 Merit has most likely received 250 from the airdrop too.

Good luck!

[DdmrDdmr]

<…> maybe the airdropped merits should have been given in a better form. take a look at this guy for insanse > https://bitcointalk.org/index.php?action=profile;u=957841 . got 100 merit airdropped with only 12 posts. <…>  

That is really a self-deranked profile: the profile was a full member at the time of the merit airdrop, and at some point since then deleted all his posts except for 12 (11 participations in games and rounds, and … surprise surprise …  a post offering to sell the account).

Initial overall airdrop was really rather simple, and equivalent to the rank of each profile at the time of the actual airdrop.  

 

<…> i would like to see you run the data on those, as for now i have no clue how to get the earned merits only as it's not on piggy's db, are you using some script to pull the data or someone has another db for it? <…>

I guess you downloaded @Piggy’s DB from Open scraped data of all the users - SQL Lite DB - 2.481.270 users. If I remember correctly, his first extraction (2 months ago) had a merit table on top of the user profile table. The current extraction (second extraction) may not have that data. I used his raw files at some point, which are user profile related (but I did not check the SQLLite data dump to see if the merit table was included this time, since I download the merit data myself and accumulate it in my DB).

Even so, if you want to just focus on merited profiles, then you should really be using @Piggy’s other public DB, updated weekly, and located on this thread: Tool to run online SQL queries over Full Merit Data. That dataset has both a user table (merited and meriters) and a merit table will all the historical merit TXs. There you can join the profile and merit tables to perform merit analysis.

[Alone055]

Ah it feels like this Merit system stoped me on sr.Member forever as noone want give metis so i dont understand how to get metits for Hero member as already have more than 600 Activity but only 256 meits for this moment so dont imagine how to get more 250 merits its realy impossible for me at this moment.

Apart from the broken grammar and other mistakes, the parts of your post I've marked in bold makes it clear why you have received no metis, oops sorry, merits.  
First of all, you need to be constructive in order to get merits, after that, if you are posting in English sections, you need to be good in it. Otherwise if you think you are constructive but weak in English, you can stick to your local board which I'm sure has one or more Merit Sources to reward you for your efforts and other members would also do that if they feel so. Complaining about the issue doesn't solve the issue. You need to find a solution to it.


P.S: Sorry for being off-topic.  

[mikeywith]

thanks

Even so, if you want to just focus on merited profiles, then you should really be using @Piggy’s other public DB, updated weekly, and located on this thread: Tool to run online SQL queries over Full Merit Data. That dataset has both a user table (merited and meriters) and a merit table will all the historical merit TXs. There you can join the profile and merit tables to perform merit analysis.

exactly what i needed , with these 2 tables you can't go wrong. btw it is amazing how Piggy manages to retrieve this amount of data on the weekly.

 -----------------------------------------

i am wondering what should i rename this topic to ?

[Theb]

Ah it feels like this Merit system stoped me on sr.Member forever as noone want give metis so i dont understand how to get metits for Hero member as already have more than 600 Activity but only 256 meits for this moment so dont imagine how to get more 250 merits its realy impossible for me at this moment.

Clearly you need to stop wondering why you aren't receiving as much merits as other members do as you don't even know how to properly use the English grammar and its punctuation marks. The 5 out of the 6 merits you received shows that you received it from trading merits with vhns222, the 2 posts you received 5 merits from him undoubtedly aren't worth 5 merits from anyone with a right mind.


Merited Post # 1 (2 Merits)

Both have potential but there is 1 BTC where you can invest and many many alts so if you want choose alt, then do your best, find good one, not shitcoin.

Merited Post # 2 (3 Merits)

Dont Hodl everything you have but some of them which are usable but  you are if you needt money so much and can do it then HODL many sell as there is no way.

So far I have seen your other post and you have been consistent with your grammar mistakes so you really need to stop complaining that your activity is bigger than your merits as it's is awarded to quality not the duration of your membership here.

[mikeywith]

I have to disagree to your point, it's a valid reason for someone not to get merit for the quality or the actual content of their posts, English on the other hand is not a scale for post quality by any means. nobody is obligated to speak perfect English unless they are getting paid to do exactly that. Many of us here "including myself" speak a poor to average English, as long as one can deliver their point, that alone should be enough.

[nutildah]

I have to disagree to your point, it's a valid reason for someone not to get merit for the quality or the actual content of their posts, English on the other hand is not a scale for post quality by any means. nobody is obligated to speak perfect English unless they are getting paid to do exactly that. Many of us here "including myself" speak a poor to average English, as long as one can deliver their point, that alone should be enough.

Just FYI, as far as the population of this forum is considered, I would place your English competency at "above average" to "good." I read some of your other posts and you're much more competent at it than most.

I agree with what you're saying -- its not fair if your native language isn't English, but in the case being referenced the poor post quality is compounded by the bad spelling, grammar, punctuation. Even if they fix all the mistakes they are still mediocre posts at best.

Also, I believe that the merit system isn't really intended to punish mediocrity but reward inventiveness. You can't demerit people for bad posts, after all.

---

I remember smaragda... That guy was annngery! Gonna read what posts he left for us right now, lol.