Bitcoin Forum
November 17, 2018, 05:45:26 AM *
News: Latest Bitcoin Core release: 0.17.0 [Torrent].
 
   Home   Help Search Login Register More  
Pages: [1]
  Print  
Author Topic: Analysis bounty tables and the sad result of it  (Read 412 times)
LiluSG
Full Member
***
Offline Offline

Activity: 420
Merit: 195


https://datum.org


View Profile
May 10, 2018, 01:21:34 PM
Merited by suchmoon (5), Vod (3), LeGaulois (3), Jet Cash (2), Dr_Pizarro (2), iasenko (1), coinlocket$ (1), sncc (1), Tory-Tory (1)
 #1

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  Sad

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

1542433526
Hero Member
*
Offline Offline

Posts: 1542433526

View Profile Personal Message (Offline)

Ignore
1542433526
Reply with quote  #2

1542433526
Report to moderator
1542433526
Hero Member
*
Offline Offline

Posts: 1542433526

View Profile Personal Message (Offline)

Ignore
1542433526
Reply with quote  #2

1542433526
Report to moderator
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction. Advertise here.
1542433526
Hero Member
*
Offline Offline

Posts: 1542433526

View Profile Personal Message (Offline)

Ignore
1542433526
Reply with quote  #2

1542433526
Report to moderator
1542433526
Hero Member
*
Offline Offline

Posts: 1542433526

View Profile Personal Message (Offline)

Ignore
1542433526
Reply with quote  #2

1542433526
Report to moderator
1542433526
Hero Member
*
Offline Offline

Posts: 1542433526

View Profile Personal Message (Offline)

Ignore
1542433526
Reply with quote  #2

1542433526
Report to moderator
yazher
Member
**
Offline Offline

Activity: 266
Merit: 16

http://iovo.io


View Profile WWW
May 10, 2018, 02:19:17 PM
 #2

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?

LiluSG
Full Member
***
Offline Offline

Activity: 420
Merit: 195


https://datum.org


View Profile
May 10, 2018, 02:28:20 PM
 #3

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
Jr. Member
*
Offline Offline

Activity: 140
Merit: 1


View Profile
May 16, 2018, 12:59:30 AM
 #4

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.

   ▬▬▬▬ ViValid.io  |  every item has a story
▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
▬▬▬▬▬▬▬▬▬▬ PRE SALE 14th May 2018
apoorvlathey
Hero Member
*****
Offline Offline

Activity: 798
Merit: 527



View Profile WWW
May 16, 2018, 03:05:31 PM
 #5

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.

▄▄▄▄▄▄▄▄
██▀▀▀▀██
██▀▀▀▀██
██▀▀▀▀██
██▀▀▀▀██
██▀▀▀▀██
██▀▀▀▀██
██▀▀▀▀██
██▀▀▀▀██
██▀▀▀▀██
██▀▀▀▀██
▀▀▀▀▀▀▀▀
          ▄▄▄▄       
     ▄▄█▀▀▀▄▄▀▀▀█▄▄   
   ▄█▀▄▄████████▄▄▀█▄
 ▄█▀▄██████████████▄▀█▄
▐█ ██████████████████ █▌
█▌▐██████████████████▌▐█
█▌▐██████████████████▌▐█
▐█ ██████████████████ █▌
 ▀█▄▀██████████████▀▄█▀
   ▀█▄▀▀████████▀▀▄█▀   
     ▀▀█▄▄▄▀▀▄▄▄█▀▀     
          ▀▀▀▀         
▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄
███▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀███
██▌                 ▐██
██▌                 ▐██
██▌                 ▐██
██▌                 ▐██
██▌                 ▐██
▐██                 ██▌
 ███▄             ▄███
  ▀███▄         ▄███▀ 
    ▀▀███▄▄▄▄▄███▀▀   
        ▀▀▀▀▀▀▀       
 
██ ████  ██████  ██████ ███ ████ ██████████████████████

..WHITEPAPER..





             ▄████▄▄   ▄
█▄          ██████████▀▄
███        ███████████▀
▐████▄     ██████████▌
▄▄██████▄▄▄▄█████████▌
▀████████████████████
  ▀█████████████████
  ▄▄███████████████
   ▀█████████████▀
    ▄▄█████████▀
▀▀██████████▀
    ▀▀▀▀▀





▄█████████████████████████▄
███████████████████████████
███████████████▀       ████
██████████████      ▄▄▄████
██████████████    ▐████████
██████████████    ▐████████
██████████            ▐████
██████████            █████
██████████████    ▐████████
██████████████    ▐████████
██████████████    ▐████████
▀█████████████    ▐███████▀





                   ▄▄████
              ▄▄████████▌
         ▄▄█████████▀███
    ▄▄██████████▀▀ ▄███▌
▄████████████▀▀  ▄█████
▀▀▀███████▀   ▄███████▌
      ██    ▄█████████
       █  ▄██████████▌
       █  ███████████
       █ ██▀ ▀██████▌
       ██▀     ▀████
                 ▀█▌
Emilyp
Member
**
Offline Offline

Activity: 252
Merit: 10

Global loyalty & rewards


View Profile
May 16, 2018, 04:46:56 PM
 #6

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
Full Member
***
Offline Offline

Activity: 420
Merit: 195


https://datum.org


View Profile
May 16, 2018, 05:10:20 PM
 #7

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
Full Member
***
Offline Offline

Activity: 420
Merit: 195


https://datum.org


View Profile
May 17, 2018, 01:45:48 PM
 #8

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! Shocked
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  Undecided

coinlocket$
Sr. Member
****
Offline Offline

Activity: 364
Merit: 438

RIP SCAMMERS


View Profile WWW
May 17, 2018, 10:16:19 PM
 #9

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? Shocked

My TIP address 12XUa8iczkvz2mdu4yBRDDeUB9nBfGFBaj
LiluSG
Full Member
***
Offline Offline

Activity: 420
Merit: 195


https://datum.org


View Profile
May 23, 2018, 03:39:28 AM
 #10

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 Smiley

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? Shocked

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
Legendary
*
Offline Offline

Activity: 1064
Merit: 1295


I don't merit Spambies


View Profile WWW
May 23, 2018, 05:19:13 AM
 #11

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.

I'm starting to plan my Crypto Coin Tree speculation club

Send me a PM if you would be interested in taking part in the initial planning.
LiluSG
Full Member
***
Offline Offline

Activity: 420
Merit: 195


https://datum.org


View Profile
May 23, 2018, 02:05:24 PM
Merited by DdmrDdmr (1)
 #12

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 Smiley 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
Sr. Member
****
Offline Offline

Activity: 308
Merit: 1243

There are lies, damned lies and statistics. MTwain


View Profile WWW
May 23, 2018, 02:33:27 PM
 #13

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
Full Member
***
Offline Offline

Activity: 420
Merit: 195


https://datum.org


View Profile
May 24, 2018, 03:30:29 AM
 #14

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. Cheesy 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 Smiley
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
Full Member
***
Offline Offline

Activity: 420
Merit: 195


https://datum.org


View Profile
July 19, 2018, 03:22:54 AM
 #15

Hello, Friends!
I did not abandon my work and actively help clean up the tables Smiley
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 Smiley

Pages: [1]
  Print  
 
Jump to:  

Sponsored by , a Bitcoin-accepting VPN.
Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!