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, 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. Summary

  5. Tools used to gather data and compile report


title.png


General

@utopian-io is the new kid on the Steem block, and has amassed 3.7 million Steem power through delegations.

At the time of writing:
a 5% up-vote is worth $18
a 10% up-vote is worth $36
a 25% up-vote is worth $90
a 50% up-vote is worth $181
a 75% up-vote is worth $271
a 100% up-vote is worth $362
source and source


1. Vote Counts

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

sql2.png




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

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

Daily average: 120




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

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

Daily average: 89




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

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

Daily average: 51

As we can see, @utopian-io has increased its daily number of votes over the past two months and is now voting over double the average number of posts than the average since inception.

Page-Break-7.png

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.6


Votes across Reputation over the past 30 days


image.png

The average reputation here is 58.3


Votes across Reputation since 29th September (first vote)


image.png

The average reputation here is 58.3

Its interesting to see the average reputation of contribution account still in the 50's.

Page-Break-7.png

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

Page-Break-7.png


4. Summary

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

The average reputation of post owner voted on is 58.3 across the lifetime of voting but averages at 57.6 in the past week. This shows a good level of commitment to newer members of the Steem Blockchain who are producing work for @utopian-io.

Vote weight is fallen in line with the increasing amount of Steem Power the account holds. This is sensible and good to see, and 90+ % of the votes over the past week are in the 4 - 10% weight range.

Less than 50 votes were cast with a weight higher than 10%.

With the increasing number of submissions, the voting % has had to be lowered, reducing rewards in some categories (e.g. 'Analysis') by more than half.

It is my feeling (and suggestion), that daily 'analysis' statistics should either be stopped as a contribution, or re-categorized as a 'Standard Report' or something similar, so that their 'weight' as a contribution can be reduced.

Analysis required data over a period of time in order to look at past/future trends - this is where value is provided. I strongly advise @utopian-io to consider this proposal in order to reduce the pressure on the STEEM reward pool.

Overall, I think @utopian-io are using their Steem Power delegations well, rewarding many authors and content with a sensible weight of vote.


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 03rd December 21st 8:30 am CET




Thanks

Asher @abh12345



Posted on Utopian.io - Rewarding Open Source Contributors

H2
H3
H4
3 columns
2 columns
1 column
21 Comments