utopian-io - Voting Analysis: User reputation and vote weight

in #utopian-io7 years ago

This is an analysis of the voting of @utopian-io from inception to present day.

Sections

  1. Vote numbers - previous 7 days; last 30 days; since first vote cast on the 29th September 2017

  2. Votes against reputation of author

  3. Votes weight against reputation of author.

  4. Analysis and Summary

  5. Tools used to gather data and compile report


title.png


General

@utopian-io is the open source project for open source projects, housed on the Steem Blockchain.

Currently, @utopian.io holds 3.7 million Steem power through delegations from its kind sponsors.

To become a sponsor and view the current standings visit https://utopian.io/sponsors


1. Vote Counts

The following SQL query has been used to extract this data:

sql2.png




Total number of votes given in the past 7 days: 867

Number of votes given in the past 7 days for comments: 0

Daily average: 124




Total number of votes given in the past 30 days: 3449

Number of votes given in the past 30 days for comments: 9

Daily average: 115




Total number of votes given since 29th September (first vote): 4441

Number of votes given since 29th September for comments: 19

Daily average: 58

As we can see, @utopian-io has increased its daily number of votes over the past two and a half months and the average daily number of up-votes continue to rise. The 7 day average vote count is almost double the average since the start of the project 76 days ago.


2. Votes and Reputation

The vote count is on the vertical axis, and the reputation range on the horizontal axis.


Votes across Reputation over the past 7 days

To extract this data, the following SQL query has been used:

sql1.png

Note the calculation to refine the user reputation, and the joining of the 'Accounts' table and 'TxVotes' table.



image.png

The average reputation here is 57.9


Votes across Reputation over the past 30 days


image.png

The average reputation here is 58.7


Votes across Reputation since 29th September (first vote)


image.png

The average reputation here is 58.8

Its interesting to see the average reputation of contribution account still in the 50's, but is steadily increasing as time goes on.


3. Vote Weight and Reputation

The vote weight is on the vertical axis, and the reputation range on the horizontal axis.


Weight (Strength) of votes cast across reputation over the past 7 days


image.png


Weight (Strength) of votes cast across Reputation over the past 30 days


image.png


Weight (Strength) of votes cast across Reputation since 29th September (first vote)


image.png


4. Analysis and Summary

The number of average daily votes has risen impressively since the beginning of the @utopian-io project. This shows the number of author posts relating to @utopian-io is increasing, and the accounts' willingness to support them.

The average reputation of post owner voted on is 58.8 across the lifetime of voting but averages at 57.9 in the past week. This shows a continuing trend from the last analysis of the data, whereby there is a constant influx of new authors for @utopian-io, who are looking to contribute and build their reputation here.

Vote weight has fallen in line with the increasing amount of contributions submitted and approved by @utopian-io. This is sensible and good to see as it shows there is consideration towards voting appropriately, both to keep the vote power of the bot at a high level, and reduce the time-frame between voting runs.

Also, with the sharp rise in the value of STEEM this past week, the vote weight can be lowered and still provide the contributors with an acceptable 'payment' for their work.

The most popular vote weight percentages this past week are 5, 8, 10, and 15%, with the maximum vote weight being 20%.

This is the first week since the inception of the project, that the vote weight has not surpassed 20%.

Only 14 submissions were rewarded with a vote weight higher than 15%

Overall, I think @utopian-io are using their Steem Power delegation appropriately. It is my feeling that in time, the vote weight for each category will fall further as the number of daily contributions increase further.

Without additional delegation, or a fall in the price of STEEM, some authors may consider their options when choosing to contribute via https://utopian.io. At this point in time, the future is looking bright for this project.


5. Tools used to gather this report

The data is sourced from SteemSQL - A publicly available SQL database with all the blockchain data held with (Data is normally 1/2 hours delayed from live)

The SQL queries to extra to the data have been produced in both SQL Server Personal Edition and LINQPAD 5.

The charts used to present the data were produced using MS Excel.

This data was compiled on the 12th December 2017 at 2:30pm CET




Thanks

Asher @abh12345



Posted on Utopian.io - Rewarding Open Source Contributors

Sort:  

Wow that was amazing, thanks for doing it!

If I can provide a suggestion: the vote weight vs reputation stats are a bit hard to read and/or to understand its implications, I'd be interested in some extended explanation on them in the future.

Thank you very much for your constructive feedback @katamori!

I will certainly attempt to make a clearer this chart, or at least the explanation of what is happening, next time around. Thanks!

Thank you for the contribution. It has been approved.

You can contact us on Discord.
[utopian-moderator]

Thank you very much @thegoldenphoenix !

Great analysis, the visual representation makes it easy for anyone to see what goes on behind the closed curtain.

Thanks very much, I try to display the data as clear as I can. This takes time even with the scripts in place.

Cheers :)

Hey @abh12345 I am @utopian-io. I have just upvoted you!

Achievements

  • Seems like you contribute quite often. AMAZING!

Community-Driven Witness!

I am the first and only Steem Community-Driven Witness. Participate on Discord. Lets GROW TOGETHER!

mooncryption-utopian-witness-gif

Up-vote this comment to grow my power and help Open Source contributions like this one. Want to chat? Join me on Discord https://discord.gg/Pc8HG9x

Great analysis,thanks for sharing

Thanks very much for your support!

Wow! Great analysis about voting
I will learn new so manything from your post
Thank you dear @abh12345 for sharing this topic with us.
Best Wishes For You

Thank you :)

You are most welcome:)

Congratulations! This post has been upvoted from the communal account, @minnowsupport, by abh12345 from the Minnow Support Project. It's a witness project run by aggroed, ausbitbank, teamsteem, theprophet0, someguy123, neoxian, followbtcnews/crimsonclad, and netuoso. The goal is to help Steemit grow by supporting Minnows and creating a social network. Please find us in the Peace, Abundance, and Liberty Network (PALnet) Discord Channel. It's a completely public and open space to all members of the Steemit community who voluntarily choose to be there.

If you would like to delegate to the Minnow Support Project you can do so by clicking on the following links: 50SP, 100SP, 250SP, 500SP, 1000SP, 5000SP. Be sure to leave at least 50SP undelegated on your account.

This post has received a 0.20 % upvote from @drotto thanks to: @banjo.

Congratulations @abh12345! You have completed some achievement on Steemit and have been rewarded with new badge(s) :

Award for the number of upvotes

Click on any badge to view your own Board of Honor on SteemitBoard.
For more information about SteemitBoard, click here

If you no longer want to receive notifications, reply to this comment with the word STOP

By upvoting this notification, you can help all Steemit users. Learn how here!

Coin Marketplace

STEEM 0.17
TRX 0.15
JST 0.028
BTC 59774.28
ETH 2422.19
USDT 1.00
SBD 2.44