Effectiveness of SMT support by @misterdelegation and Steemit Inc.

The STEEM blockchain is currently preparing for the launch of SMT’s and Steemit Inc. is doing it bit to support developers and DApps that are built upon the STEEM Blockchain. Steemit Inc shows its support by way of delegation of Steem Power via Hive account@misterdelegation.

Each of the DApps has the opportunity to create their own SMT on the STEEM blockchain and ultimately this delegation is supporting the launch of SMT’s.

Repository

https://github.com/steemit/steem

In the last few months we have seen several new DApps appear and Hive account@misterdelegation is now supporting more developers than ever. Currently there is 16,354,836.69 SP out on delegation. The table below shows who is in receipt of this delegation, how much SP they have been delegated and the current vote worth of the amount delegated.

Aim of Analysis

The aim of this analysis is to establish and present data in a meaningful way to enable readers of this report asses the effectiveness of the delegation by each delegate. All values provided are based on the DApps delegated SP by Misterdelegation and excludes owned SP and all other delegations.

Scope

The scope of Analysis was a 45 day period from 1st June to the 15th July. Please note that Hive account@fundition and Hive account@tasteem did not receive delegation until 13th June.

All data was taken from STEEMSQL. The full queries used to gather the data can be found below the post.
This report was produced on request by Hive account@birdinc

High Level Overview

The table below shows each of the delegates, the number of votes they made in the 45 day period, the average voting weight used, the value of the votes( Vote worth,), the average vote value and the number of distinct authors voted for. This table has been sorted by the value of the votes given.

The chart below shows the DApps by the average % vote given. Hive account@fundition is way out ahead with an average % vote of over 65% and on the lower end, before the flagging accounts we have Hive account@steemhunt at 1.69%

The donut chart below shows the number of distinct authors voted for during the time period along with the % of distinct authors that have received votes with the delegated power. Hive account@esteemapp out in front with almost 3K authors reach which make up 19% of the total authors reached from all the apps listed.

The pie chart below shows the amount given out in votes with the delegation by Dapp. Dlive has distributed over 22% distributing over 87K in rewards just from the delegated SP they have received.

Finally, the chart below shows the number of votes given. We can see that Hive account@mack-bot has given out 30% of the votes or in this case flags. 46K flags in 45 days.

Detailed Analysis

Hive account@busy.pay has received 3.9% of the delegation and has given out 5.7% of the rewards to 10.86% of the authors with 11.9% of the votes given.

Hive account@dlive has 12.66% of the delegation but has given out 24.28% of the rewards to 15.59% of the authors with 5.5% of the votes given.

Hive account@dsound has 6.07% of the delegation and has given out 10.49% of the rewards to 2.24% of the authors with 2.22% of the votes given.

Hive account@dtube has 12.34% of the delegation and has given out 20.93% of the rewards to 4.49% of the authors with 1.42% of the votes given.

Hive account@esteemapp has 3.08% of the delegation and has given out 3.97% of the rewards to 24.36% of the authors with 8.36% of the votes given.

Hive account@fundition has 6.13% of the delegation and has given out 4.07% of the rewards to 0.85% of the authors with 0.17% of the votes given.

Hive account@sndbox has 0.92% of the delegation and has given out 1.07% of the rewards to 9.61% of the authors with 1.71% of the votes given.

Hive account@steemhunt has 6.13% of the delegation and has given out 10.28% of the rewards to 10.57% of the authors with 16.53% of the votes given.

Hive account@steemit-jp has 1.53% of the delegation and has given out 2.16% of the rewards to 3.57% of the authors with 2.94% of the votes given.

Hive account@steempress-io has 6.13% of the delegation and has given out 9.09% of the rewards to 6.77% of the authors with 4.54% of the votes given.

Hive account@tasteem has 6.13% of the delegation and has given out 8.34% of the rewards to 12.72% of the authors with 8.09% of the votes given.

Hive account@utopian-io has 6.28% of the delegation and has given out 8.96% of the rewards to 11.16% of the authors with 2.99% of the votes given.

Hive account@mack-bot has 1.56% of the delegation and has returned 0.54% to the rewards pool from 5.58% of the authors with 30% of the votes/flags given.

Hive account@spaminator has 16.46% of the delegation and has returned 4.15% to the rewards pool from 4.27% of the authors with 2.19% of the votes/flags given.

Hive account@steemcleaners has 9.25% of the delegation and has returned 5.27% to the rewards pool from 6.53% of the authors with 1.44% of the votes/flags given.

2.5% of the delegation goes to Hive account@bittrex Hive account@poloniex, Hive account@binance-hot and Hive account@trendings-grace and has not been un used.

SP Ratio Score

With all this data is it hard to establish which account is most effective with their delegated SP. So I have used this data to devise a scoring system.

Using the table above in detailed analysis shows the % each accounts contributed to the group overall in terms of % SP they received by delegation, % rewards $, % of votes and % of authors reached.
From here I have calculated some ratios against the % SP. Each of these ratios have been added together to provide a score from which I can rank the delegates. This is the SP ratio score.

Hive account@mack-bot, with such a large Votes/SP ratio and the third highest Author/SP ratio comes in with the highest SP Ratio Score

Hive account@sndbox, tops the Author/SP ratio score at 10.45 and comes in second on the SP ratio score

For those interested I have ran some descriptive statistics on the above table of data

Conclusion

Congratulations to all delegates on receiving this delegation, and also to Steemit Inc. and it’s team for making such delegations. It would make you wonder if Hive account@ned has a delegation policy and if so, maybe he would consider sharing it?

The aim of this analysis was to gather and present data so that you can make an informed decision as to the effectiveness each delegate is with their delegated power and was not to given personal opinion on how effective each delegate is with their power.

When running this analysis again, what further data would you like to see included to evaluate the effectiveness of the deletion in support of future SMT's?

What are your opinions on the effectiveness and effective use of the SP delegated?

The Data and Code

The vote value for each DApp used the in calculations was based only on the SP delegated from Hive account@misterdelegation.

As mentioned above, the data was extracted from STEEMSQL. I used Power BI to extract, transform and model the data.

The M Code used to gather and transform the data was

let
Source = Sql.Database("vip.steemsql.com", "DBSteem", [Query="SELECT#(lf)*#(lf)FROM #(lf)Txvotes (NOLOCK)#(lf)#(lf)WHERE [voter] in ('steemhunt','steempress-io','binance-hot','busy.pay','dlive','dsound','dtube','esteemapp','mack-bot', 'sndbox','spaminator','steemcleaners','trendings-grace','utopian-io','steemit-jp','tasteem','fundition' )#(lf) AND CONVERT(DATE,timestamp) BETWEEN '2018-06-01' AND '2018-07-15'"]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"timestamp", type date}}),
#"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each [weight]/10000),
#"Changed Type1" = Table.TransformColumnTypes(#"Added Custom",{{"Custom", Percentage.Type}}),
#"Renamed Columns" = Table.RenameColumns(#"Changed Type1",{{"Custom", "% weight"}})
in
#"Renamed Columns"