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

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

H2
H3
H4
3 columns
2 columns
1 column
15 Comments