Voting Habits of the top 50 witnesses - Steemit Business Intelligence
Witnesses play a vital support role in keeping Steemit up and running. And each witness relies on votes from steemains to keep their role as a witness active, just like us steemains need votes on our posts to keep us as active authors.
With this in mind, I decided to analyse the witness accounts and the voting habits of the top 50 witnesses.
Approach
Data Transformations
Using Power BI I connected to https://steemit.com/~witnesses and pulled down a list of the top 50 witnesses.
I then also used Power BI to connect to steemsql held and managed by @arcange . The first table I connected was the TXvotes table. I used the listed pulled down of the top 50 witnesses to filter the TV votes table and I also filtered the table to look at votes made in September only.
Next I connected to the accounts table. using the voter name from the TXvotes table, and the account name on the accounts table as common fields in both tables, using an outer join I merged the two tables so that the account creation date, account reputation and vesting shares are now showing the TXvotes table to give greater further details on the witnesses.
Finally I connected to the Comments table in steemsql. By using the permalink field in the comments table and the permalink field in the TXvotes table as the common fields, I carried out another outer join to pull in the category for the post and the post depth.
The final steps in the data transformation were to change the date fields from data type date and time to data type date. This is an important step for time intelligence functions to work when modelling the data.
The only tables loaded to the data model is the Witenss list table and the newly expanded TXvotes table.
Data Modelling
I use DAX (Data Analysis eXpressions) to carry out calculations across the tables of data. The first step in modelling the data was to add a date table. In Power BI a date table is required for time intelligence functions to work. After this I carried out further calculations on the data which are represented in the visualisations below.
Who are the top 50 Witnesses
On average, witnesses in the top 50 have been on Steemit for over 440 days. There are some exceptions to this. In number 50 is @netuoso, who is only on steemit 96 days as at the date of analysis. On the opposite end of the scale we have @blocktrades in number 9 and that account was registered 540 days ago.
The average vesting shares held in the by the top 50 wintesses is 492.87M, but again there is a huge variation between those at the top of the scale and those at the bottom. @Blocktrades is well ahead with 7469M vests whereas @chainsquad.com has only .814M. This is not an indication of how much they have made here on steemit, as for this one would also need to look at withdrawals. I have not included withdrawals in this analysis.
Finally I had a quick look at posts to see how active witness are when it comes to posting. I was very surprised to see two witnesses with no posts at all. It makes me wonder how they are in the top witnesses? If they are not interacting with the community who is giving them votes and why? Hmm that’s another analysis. Besides that, on average witness have made 1660 posts each.
The visualisation below plots the post count by the number of days on steemit for each witness and the size of the bubble represents the vest shares held
Voting
In total the top 50 witnesses voted 177,493 times. Of this only 0.2% of votes were self-votes and 0.9% were votes to other witnesses.
First I sorted the witnesses by the number of votes given to see who gave the most votes
And then by average weight to see which witnesses vote with a lot of power
Next I had a look to see which witness votes for themselves the most
And who votes for themselves with a lot of power
Sorting by the number of votes given to other witnesses in the top 50
The visualisation below plots the average % weight for self-votes, against the average % weight of a vote to witnesses and the size of the bubble represents the total average weight of a vote given by the witness.
When are witnesses voting?
The 12th Sept has been the busiest day that witnesses have voted so far, with the average daily vote reducing in the last 6 days. The busiest time seems to be at 9:25 am however the busy period is from 7:00am till 17:00pm
What do witnesses vote for?
Analysing the categories on posts voted for by whales, I first looked at the number of votes given to each category
Then I looked at the number of posts voted on in each category by witnesses
I was expecting to see a higher number of posts in the Spanish category and as I did not get this expected result, I plotted the Number of posts against the number of votes in each category.
From this chart it is easy to see the outliers. Spanish having a slightly higher than average number of posts, but as it is placed well over on the left of this chart, there has been well above average number of votes by witnesses in this category. Photography and life categories are also outliers with a rather high number of posts that were voted on.
Next I looked to see if witnesses tend to vote on posts or on comments. In the table below 0 relates to a post, other number related to the comment depth on a post
I was surprised to see the number of votes given on comments of a depth of 2 or more. It shows that discussion on posts are read by witnesses. So I wanted to see which witnesses were actively voting on comments with a depth of 2 or more. From the chart below we can see a breakdown of these votes, by witness. It is clear to see that some people are spreading comment votes around the community, while others like to vote on their own comments!
Downvotes
The final table I wish to share with you is the witnesses with the highest number of down votes to other people posts
This analysis probably opens up more questions than it answers. Questions that the data can answer, however I have purposely left out some of the questions I asked.
Why?
Well there is a substantial risk of down votes for bringing to the forefront things people don’t want discussed.
I am part of a Steemit Business Intelligence community. We all post under the tag #BIsteemit. If you have an analysis you would like carried out on Steemit data, please do contact me or any of the #bisteemit team and we will do our best to help you...
Wow...lots of information. I need to read that again. You add weight to my already questioning my attempt to be a witness so early in the game, and barely getting any voters for my witness at all. Im already 50 bucks in the negative because my witness is not making a penny. Not sure what I've done wrong or why the lack of support. Good job on this post wish my upvote had more weight for you. Cheers
It's probably a fool's errand to try witnessing under 60 rep if you are relatively new to the platform.
yes I would say so, I have been looking into it a bit and if you cannot gather the support it will be almost impossible to cover the costs unless you already have a server set up for something else and can run this alongside it... You put in a lot of effort just getting the votes to make any cash of it and in a way it should not be about the money in the first place
Agreed!
Wait, can you explain how you lost $50?
Probably hosting fees.
yes hosting fees
Excellent article! great stats...
I can say this, I know that like the 1 witness @lukestokes.mhth , the reason that account doesn't vote is because thats just an account @Lukestokes created to only have his witness proceeds goto, it helps with bookkeeping and other reasons, but his main account @lukestokes does post and vote quite frequently.. there are a couple witnesses that setup separate accounts here on steemit just to receive their witness proceeds too
I came to say this. He's very active and a top guy.
Interesting study, lots of numbers and tables. However, numbers don't tell the whole story. Some witnesses (and non-witnesses) upvote for curation, downvote for fighting spam, some have high SP, low SP, this varies the self-upvotes value, some have a lot of whale friends to vote for them, some have less or none, etc... Lots of human factors and politics are at play, not just for witnesses, but for the whole platform. I don't think numbers should be the only factor in determining who to vote for.
Just to make sure that I understand...
To downvote a post is to flag it?
(I guess Reddit has influenced me greatly in looking for the 'down' arrow for downvoting!)
Yes, the flag is the same thing as downvote.
Another gem by Paula! :swoon:
Wow, top-notch stuff. Great graphics. Can't really add much more except to say it's very interesting!
why is it not possible to upvote value and resteem after 7days? that is so unfair ... thanks for the BI info... ;)
woah...thats a lot of data- thanks for accumulating it -
This post has given me pause to think, I wonder how much thought people put into their witness votes?
I haven't seen much discussion around criteria people use for witness voting and considering how important a function this is that surprises me.
Also the fact that so many witnesses have been on Steemit for such a long time (in the top 50) also surprises me. What is the barrier to entry for newcomers? and why are new witnesses not being attracted to Steemit?
witnesses are being attracted but they are not yet in the top 50 or even 100 to even be noticed. The more a witness is out in the community both doing for the community and promoting their desire to be a witness the more others notice and will support them. Regular witness update posts are also a good idea, you'll find most of the top 19 do update posts.
I vote for witnesses as I see them on posts asking for votes. If they seem like they care and deserve a vote - I give it. I've been here just over 3 months and I've voted for about 15 - so that means I'm not seeing posts that catch my eye from the others. I only rejected voting for one of them so far. About half my votes are write-ins. I'm not sure how much time and effort to put into this beyond looking when a post catches my eye.
Woow...great post...share this info more often...