How Much of the Rewards Pool is Paid out by BitBots Votes V's Organic Votes

View this thread on: d.buzz | hive.blog | peakd.com | ecency.com
·@paulag·
0.000 HBD
How Much of the Rewards Pool is Paid out by BitBots Votes V's Organic Votes
A recent post by @tarazkp called out for someone to look at how much of the reward pool is available or paid out via organic votes.

You can read that full posts (and comments because it is an interesting discussion) here:

https://steemit.com/steem/@tarazkp/looking-for-a-good-bidbot-mathematician

To try and answer this question and carry out this analysis I am going to look at data for the month of February 2018.  Some of the data I can extract from previous analysis I have prepared for the month of February and other values required a new query or calculation.  You can find full details of the query and original analysis at the bottom of the post.

The basis of the queries was to find the number of votes given in February by each of the accounts as shown below and also to value those votes.  Valuations are based on 100% votes as per steemworld.com and adjusted by the voting weight actually used per vote. Please note that the value of a vote today on steemworld is not the same as it was in Feb due to changing conditions.

Once I had all of the data for February, I was then able to deduct these from Total values to arrive at Organic Vote and Estimate organic Vote value.  The results are shown in the table below.

![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1521742675/rajoatfw4nl7emg5hntl.png)



 
The value for Bidbots above is the combine value of all of the bidbots as listed on https://steembottracker.com/

@abh12345 wanted to see some pie charts for this data so below shows the % of total post pay-out each voting route (or app or whatever we want to call it ) contributed to the over all total.

![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1521741005/ygokje2z5vmo2fyfn8fx.png)

 
 The pie chart below shows the % number of votes each app contributed to the overall total in February

![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1521742721/cstsnnucuowirxpkfwwq.png)


 
Based on this we can see that 62.49% of post payouts in Feb was down to organic voting (I don’t really think it is fully organic voting as many people auto vote but for the sake of this post)

## Conclusion
@tarazkp had asked to see what % of the rewards pool is available for organic votes after bidbots and other known voting apps.  By using data from the month of February, we know what was paid out on post in SBD value (this is gross, so author and curator rewards). 

We have also calculated how many votes the bidbots and other know voting apps made and an approximation of the gross worth of these votes. By deducting one from the other we are left with ‘organic’ votes and vote worth.

In February 62.49% of vote value was organic and the bitbots  contributed almost 24% of the total payouts for Feb.

Would it be safe then to say if 62.5%% of the vote value is organic, the 62.5%% of the rewards pool is used to pay ‘organic’ votes?  This would also be the case then that 24% of the rewards pool will be distributed by paid bidbots!

I must mention again that when I say organic in this context, we are talking votes made by all other except those listed.  We are all fully aware that this is not a realistic of ‘organic’ votes as auto voting and other bots are all over steemit.  the bitbots accounted for can be found on https://steembottracker.com/

## Queries and Data

The M query used to find the total number of votes for the month of February was 
``` language
let
    Source = Sql.Database("vip.steemsql.com", "DBSteem", [Query="SELECT#(lf)*#(lf)FROM #(lf)Txvotes (NOLOCK)#(lf)#(lf)where timestamp >= CONVERT(DATE,'2018-02-01') #(lf)and         timestamp< CONVERT(DATE,'2018-03-01')"]),
in
    Source
```

From the data I then carried out COUNTROWS DAX expression to get the total number of Feb votes.
To get the total number of votes from the bidbots the following M query was used


``` language
let
    Source = Sql.Database("vip.steemsql.com", "DBSteem", [Query="SELECT#(lf)*#(lf)FROM #(lf)Txvotes (NOLOCK)#(lf)#(lf)where timestamp >= CONVERT(DATE,'2018-02-01') #(lf)and         timestamp< CONVERT(DATE,'2018-03-01')#(lf)and voter in ('kittybot', 'isotonic', 'getboost', 'booster', 'lightningbolt', 'nado.bot', 'shares', 'peace-bot', 'postdoctor', 'spydo', 'singing.beauty', 'minnowhelper', 'jerrybanfield', 'sunrawhale', 'sleeplesswhale', 'zapzap', 'cryptoempire', 'pwrup', 'redwhale', 'lovejuice', 'foxyd', 'noicebot', 'minnowfairy', 'honestbot', 'seakraken', 'upboater', 'whalebuilder', 'mrswhale', 'upgoater', 'smartsteem', 'dailyupvotes', 'pushup', 'allaz', 'sneaky-ninja', 'upmyvote', 'dolphinbot', 'minnowvotes', 'chronocrypto', 'thebot', 'inciter', 'oceanwhale', 'promobot', 'mitsuko', 'bearwards', 'voterunner', 'brupvoter', 'payforplay', 'edensgarden', 'redlambo', 'mercurybot', 'appreciator', 'slimwhale', 'moneymatchgaming', 'boomerang', 'childfund', 'buildawhale', 'youtake', 'megabot', 'authors.league', 'upme', 'alphaprime', 'steembloggers', 'msp-bidbot', 'lost-ninja', 'estream.studios', 'upyou', 'postpromoter', 'rocky1', 'bluebot', 'flymehigh', 'aksdwi', 'puppybot', 'onlyprofitbot', 'boostbot', 'discordia', 'canalcrypto', 'therising', 'ebargains', 'fishbaitbot', 'luckyvotes', 'brandonfrye', 'estabond', 'upmewhale', 'hotbot', 'adriatik', 'steembidbot')"]),
    #"Added Custom" = Table.AddColumn(Source, "% weight", each [weight]/10000),
    #"Changed Type" = Table.TransformColumnTypes(#"Added Custom",{{"% weight", Percentage.Type}, {"timestamp", type date}})
in
    #"Changed Type"
```


Using the data returned by this query, I then carried out a mash up of data from https://steembottracker.com/ .  This gave me the value of a 100% vote.  Using the data about the vote weight was multiplied by the 100% vote value to get the approx. value of the vote given.

The queries used to get the votes and vote values for February for the above mentioned apps is covered in detail in previous post so I will not replicate it here.  If you are interested in this code you can find it on any of the posts below 

https://steemit.com/utopian-io/@paulag/feb-18-zappl-steem-app-analysis-blockchainbi

https://steemit.com/dmania/@paulag/feb-18-dmania-steem-app-analysis-blockchain-business-intelligence

https://steemit.com/utopian-io/@paulag/feb-18-dsound-steem-app-analysis-blockchainbi

https://steemit.com/dlive/@paulag/feb-18-dlive-analysis-blockchain-business-intelligence

The value for the total post payout in Feb is taken from https://steemit.com/utopian-io/@paulag/february-2018-steemit-post-benchmarking-report-blockchain-business-intelligence

To note on this, there is a timing different between posts and votes.  The payout value is based on Posts made in Feb, not actual votes made in Feb.  This might lead to a small variation in actuals





<br /><hr/><em>Posted on <a href="https://utopian.io/utopian-io/@paulag/how-much-of-the-rewards-pool-is-paid-out-to-bitbots-v-s-organic-votes">Utopian.io -  Rewarding Open Source Contributors</a></em><hr/>
👍 , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,