Analysis bounty tables and the sad result of it

[LiluSG]

Hello, my friends
I want to raise an important topic for me, about the work of bounty managers with articles, and about what showed a frontal analysis. The table that was analyzed, a table of well-known managers on the forum.

Prehistory. I received the final table with the rates and tokens. There were more than 3,000 applications. They estimated at least 2/3 or half. But the eye caught the end of the list, where there were 2 duplicates with bets. I looked a little more and found another couple of such coincidences

Of course, I decided to automate the process and see what it will show throughout the table. I parseled google sheet to my table. And I use the formula in - Tables - Format - Conditional formatting - similar type "=AND(NOT(ISBLANK(A1)); COUNTIF($A$1:$F; "=" & A1) > 1)" I got duplicates of the whole table by links. Here I laid out a full instruction with screenshots - https://bitcointalk.org/index.php?topic=3800524.0

The results amazed me! More than 500-600 duplicates with bets and tokens. When you scroll the table, it blushes. There are places where everything is red, the entire list of links that you see. And after all, I checked only one table and only on articles, I did not even look at the articles themselves. And what if you check all their campaigns? And what if you start checking every famous manager here?

I wrote to the managers and now I'm waiting for an answer. I do not think that this is their evil intent. Most likely they have a large volume and they can not check everything, or they do not have a tool that allows it to be done in 3 minutes. Although Google spreadsheet is very flexible in the analysis, including.

Why am I writing this here?
I want to raise the problem and give the tool to everyone. You can use it in any of your campaigns.
I want that the tightening of the screws works not only in the direction of the bounty of hunters, but also managers who take money for their work.
Well, of course, ban all who steal the work. Moreover, this can be the reason for painting the trust. Because for each article there is a nickname with BT

This situation was drawn from simple curiosity. And I am very saddened by the situation  

Thank you
Yours faithfully


P.S.
I do not often write in the English thread. But I think I wrote that thread.
I do not want to call a team of managers, they have not answered me yet.
I do not want to punish managers at this stage.

But I'm ready to talk with the moderators in private messages and give all the data that they can check it. And at least punish the participants from the forum who stole the work.

P.S.#2
The topic now has a link to a full, visual instruction - https://bitcointalk.org/index.php?topic=3800524.0
You can send it to the manager if he has a lot of mistakes, you have a dialogue with him and he does not know about this method. This will help in his work

[LiluSG]

That's why there are a lot of participants, mostly they are belong to the bounty farmers and these guys are the virus of this forum. what about social media campaigns? and signature campaign? maybe there are some duplicates too?

The rest I have not watched yet. Signatures are usually tightly controlled and I have not seen thousands of participants. Social networking is not as profitable, but I'm sure that can be checked in this manner. It's very fast and visually

Articles are still a profitable direction. And this situation showed that there is a problem. I did not even watch the content itself. Because the content is also copied. And I'm not even talking about the quality of content. I'm more than sure that most managers do not even look at articles. Judging by the fact that gets the maximum rate

[snapee11]

I already heard about this situation. The entries will be filled up with duplicates and fakes immediately. This is the reason why some bounty hunters quit on their work. You will have hundreds of stakes but receiving only two digits of tokens. These scammers is somewhat the reason why the ICOs don't reach the hardcap and even the softcap and might even make bounties fall down after ICO distribution.

[apoorvlathey]

I hadn't tested your method yet, but there is an automatic way too to sort out duplicate entries.
As almost all the applications are taken using Google Forms, in the user response section, Google automatically shows Duplicate entries which can be useful to find duplicate links or eth addresses and much more.

[Emilyp]

It will be good if bounties are well checked. If it's done this way, it will reduce the number of fake accounts and that of people ho steal other people's account to join a given bounty and also that of individuals who steal people's work. A thorough check will help reward only those who worked for such bounty campaign and not just any farmer in the bounty.

[LiluSG]

I already heard about this situation. The entries will be filled up with duplicates and fakes immediately. This is the reason why some bounty hunters quit on their work. You will have hundreds of stakes but receiving only two digits of tokens. These scammers is somewhat the reason why the ICOs don't reach the hardcap and even the softcap and might even make bounties fall down after ICO distribution.

You are definitely right. For high-profile projects, this may not be critical, only in terms of bounty hunter. But for medium-sized projects, this is more tangible

I hadn't tested your method yet, but there is an automatic way too to sort out duplicate entries.
As almost all the applications are taken using Google Forms, in the user response section, Google automatically shows Duplicate entries which can be useful to find duplicate links or eth addresses and much more.

Yes, the functionality of Google tables is very wide and allows much to do, on the side of the author of the table. But my method suggests checking any table by copying your data. Those. some control over the campaigns if the manager does not manage. Although of course, all these corrections and checks are the work of the manager

P.S. I added a link to the full instruction - https://bitcointalk.org/index.php?topic=3800524.0

It will be good if bounties are well checked. If it's done this way, it will reduce the number of fake accounts and that of people ho steal other people's account to join a given bounty and also that of individuals who steal people's work. A thorough check will help reward only those who worked for such bounty campaign and not just any farmer in the bounty.

I added a full instruction that can be sent to the manager if they make a lot of mistakes. This will help them in their work. Not to mention the reports of duplicates found

[LiluSG]

The biggest problem, in all this, is when you can not contact the manager. For example, now, I found another final table where there are a lot of duplicates. Scammers took about 10-15% of the total pool for articles!
And there is no manager. He is not listed in the bounty, there is no chat, there is no BT, there is nothing. As a result, they will pay thousands of dollars to scammers. And this helplessness most troubles 

[coinlocket$]

nice work op, I've opened this 3d seems you are great with scipt/google code, if you want look at it! https://bitcointalk.org/index.php?topic=3813034.msg37298788#msg37298788

Also how can u copy paste a protect speadsheet? is it even possible?

[LiluSG]

For example, made the color of the final table. Scammers took about 15% percent of the media pool. There was no reaction from the manager and the project team. Let's see what happens if the table is made public and in chats post. I have none of these

It turns out that there is no sense in writing articles, you just need to make 10-20 duplicates in the table.. and they'll give you more than if you write yourself
https://docs.google.com/spreadsheets/d/1YCFgTT4dm2l8AfXStmJpieVBnntRiC-okAyYkKyScoE/edit#gid=942320464

P.S. From the team there was a reaction. They said they would take action

nice work op, I've opened this 3d seems you are great with scipt/google code, if you want look at it! https://bitcointalk.org/index.php?topic=3813034.msg37298788#msg37298788

Also how can u copy paste a protect speadsheet? is it even possible?

Thank you)
I'll look at the link

Yes, the sheet in the table can simply be copied to itself. You can also parsing the data. This applies to both classic tables in Google and html

[Jet Cash]

Congrats on your work. Anything we can do to reduce the activity and profitability of the scammers and cheats here should be encoraged and supported. Lets hope tht the bounty managers will support you as well.

[LiluSG]

Congrats on your work. Anything we can do to reduce the activity and profitability of the scammers and cheats here should be encoraged and supported. Lets hope tht the bounty managers will support you as well.

Thank you I can not change the situation on the whole bounty market. But I have an algorithm for finding duplicates. I can clean up those projects in which I'm sitting. Publicity of the link in the chat, gave immediately the right response from the team project, although when I first wrote to them, they did not take seriously the problem

We can not encourage this. This way we give the air to the scammers. If you look at the wallets of scammers, there is also a very interesting picture emerges

[DdmrDdmr]

We can not encourage this. This way we give the air to the scammers. If you look at the wallets of scammers, there is also a very interesting picture emerges

Sometime ago I had in mind that an automated wallet-crossing product could be created to see if any wallets are interrelated. That is, give it a set of wallet addresses and see which have common interaction between them in terms of the core coin or supported tokens.

I looked into it but left it at an exploratory level since it requires bags of time.  Even so, if it were feasible to create the product, it could help bounty managers to detect fraudulent participations (and alt accounts in the process if worked from the Forum side).

Obviously, scammers could then just keep their wallets 100% independent of each other and avoid this kind of procedure. In addition, it can lead to false positives (such as real relatives moving tokens amongst themselves, and participating in a campaign, thus being marked as scammers).
It’s a bit like the judicial system (bad as it may be): the principal that should stand is that one is innocent until proven otherwise, with no gap for reasonable doubt.

The bounty sheet procedure that you suggest is a fragrant basic need.

[LiluSG]

https://docs.google.com/spreadsheets/d/1NIOhcx741wYU2A3kwmTGtB49N5TYsLjCBXBh-bScIs0/edit#gid=745399704

New table. In this table, the scale of the scammers is about 10-20% of the total pool. More than half of the links with the highest score have duplicates. Some links are duplicated up to 9 times. There are scammers who received 3 times the charge for the fact that they posted a link to Twitter auditing! Damn they got 2 times more than I do for my article. This time I did not paint all the scammers in red, as it will take a lot of time, and the scale is visible and so. And again, it's not my job and they do not pay me for it)

I published a link in the bounty thread, here and in the project channel with 18 thousand users. Previous experiment gave excellent and quick feedback
Although there is no reaction, but my message in a telegram has already been deleted by someone from the team))

Sometime ago I had in mind that an automated wallet-crossing product could be created to see if any wallets are interrelated. That is, give it a set of wallet addresses and see which have common interaction between them in terms of the core coin or supported tokens.

Yes, this is the decision to go deeper into the analysis of frauds, for the entire bounty market. Unfortunately, here you need programming skills and understanding of mechanics and analytics. In general, such a product is obvious, it's strange that no one has developed it. Either it already exists, but it is not published, like know-how (bounty platforms, bounty managers' teams)

I agree, what I'm suggesting, these are simple things at the level of the functionality of Google tables. They seemed so obvious to me that I was shocked by the results. But this is better than nothing. I clean out a table of their bounty, thus increasing the payments to all participants

[LiluSG]

Hello, Friends!
I did not abandon my work and actively help clean up the tables
There are managers who are well-check everything yourself. But for the time being I still have to make reports.

For example, in the last project that checked, found 25 scam links for 600 works - https://docs.google.com/spreadsheets/d/1x2aplyPdBYlPKKIcxJCJ32Ebrnx8UJ2cVyCd8HQOzo0/edit#gid=1331468531
I sent the report to the manager, as well as the link to the algorithm I use. Most likely everything will be cleaned and every bet in the table will bring additional +31 tokens. Trifle but it's nice