3 months ago @stellabelle announced a new project on the Steemit Blockchain. A magical project that is half Unicorn half sloth. A project know as #slothicorn. The aim of this magical project is to reward creative commons crypto art and they will be making it easy for artists by introducing a game to teach them the workings of the Steemit Blockchain.
If you missed Stellas post introducing Slothicorn you can read it here
https://steemit.com/slothicorn/@stellabelle/introducing-a-new-steem-project-slothicorn-half-sloth-half-unicorn-all-magic
If you would like to find out more about this project or get involved then have a read of @inquiringtimes post on the discord server and then hop on over and join in on the magic.
https://steemit.com/slothicorn/@inquiringtimes/an-introduction-to-the-slothicorn-discord-chat
Behind @slothicorn is a nice delegation from Stella of 55K SP, used to reward those that contribute. From what I have found this is the first project of its kind that is actively focusing and rewarding artists on the blockchain.
The aim of this analysis is to see how far the reach has been and establish some behaviours of voting from @slothicorn and posting within the tag #slothicorn
For this analysis I have taken data from the Steemsql database for 2018 only– you can find full details of the query after the analysis
Vote Analysis from @Slothicorn
Since the start of 2018 @slothicorn has voted 811 times for 180 different authors on 774 post. The average SBD$ Vote value was $6 with an average voting weight of 63.53%. The total approx. payout given by @slothicorn is $4.74K SBD
Lets look at this over time
What we can tell from this is that slothicorn does not vote every day. To me this implies manual curation which takes time and effort. We can also see that most days voting happens, 20 or more votes are cast.
Post Analysis to #Slothicorn
870 authors have submitted 772 post using the tag slothicorn. These posts have received 3198 comments and 18K net votes with a total payout of $9.25K SBD. The average payout value of a post in slothicorn is $11.84 SBD. This is currently well above that average post payout calculated in the January post benchmarking report of $3.81.
Of this $9.25K SBD, @slothicorn contributed approx. 4.74K or 51% of the rewards to this community.
The chart above shows the number of posts per day to the tag #slothcorn. From this we can see a steady growth in the popularity of this tag.
Slothcorn Contributor Activity
Above you will find three tables of data. The table on the left represents the authors voted for by @slothicorn sorted by the number of votes received.
The table in the centre represents the Authors the contributed Posts to the tag #slothicorn, sorted by the number of posts submitted.
The final table on the right represents authors that have actively contributed to posts by leaving comments, sorted by the number of comments left on posts in the tag #slothicorn.
Conclusion
The Slothcorn Project is underway and is succeeding in rewarding those that make good contributions, as the average post payout for this tag is substantially higher than that on Steemit in general.
It appears from the data and voting pattern that the posts are manually curated and authors tend to contribute more than once.
It is also evident from above that my art skills are not so good! Next time I do this analysis I will have a nice infographic to share with you. I think it will look a lot better than above.
The Data and Query
I used Power BI to connect to the Steemsql database. The SQL query used to get the voting data from Steemsql was
SELECT *
FROM Txvotes (NOLOCK)
WHERE [voter] in ('slothicorn')
and YEAR(timestamp) = 2018
The query used to get the posts and comments was
SELECT
author,
permlink,
total_payout_value,
pending_payout_value,
net_votes,
created,
children,
Category,
Depth
FROM comments (NOLOCK)
where YEAR(created) = 2018 and
json_metadata like ('%"slothicorn"%')
After collecting the data from the Sql query, I then used DAX to carry out calculations and analysis across the tables.
Vote worth and Total Approx Payout.
At the time of calculation @slothicorn had voting power of 55% and a value of $9.2SBD. A 100% vote at full power would be worth $16.68. The values above are based on the current value of $9.20 and therefore are only approximate values. The valuation can also be clarified as undervalued as we can see from the time series voting chart above that @slothicorn voted 67 times on the 19th – the day the data was collected.
I am part of a Blockchain Business Intelligence community. We all post under the tag #blockchainbi. If you have an analysis you would like carried out on Steemit data, please do contact me or any of the #blockchainbi team and we will do our best to help you...
You can find #blockchainbi on discord https://discordapp.com/invite/JN7Yv7j
Posted on Utopian.io - Rewarding Open Source Contributors
Your analysis is very useful to me, as I have been wondering about the numbers. Yes, we do manual curation, with a team of 2 right now. I would love to have a bot do the voting, alas, bots are terrible judges of art, so it appears that humans will be doing the curation. As it grows, we will need more manual curators or some serious AI bots to help. I have some ideas about this.....but nothing concrete.....if there are any programmers who have a good solution, reach out to us in Discord to discuss this.
Thanks so much Paula!
Bots are terrible judges of art
Am so in love with this project. Thanks @stellabelle for helping me see this by resteeming it and to @paulag for sharing...
Hey @paulag I am @utopian-io. I have just upvoted you!
Achievements
Community-Driven Witness!
I am the first and only Steem Community-Driven Witness. Participate on Discord. Lets GROW TOGETHER!
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
Nice..Thanks for the information
Thank you, Paula! Very grateful for your contribution!!!
very informative post!!
I love slothicorn even though I’m not a crypto artist. I do know however work as an artist myself in the ‘physical’ world and know the struggle to get rewarded. It seems to me Slothicorn adds real value to Steemit as a whole and to the lovely artists who are creating all the time.
Thanks for your analysis again, Paula! I love that you’ve tried to create cute puppet infographics just for this post :D
lol I was giggling away while putting this data together, im so not arty, but really love this project
we are glad you chose taq slothicorn in your list of analysis.
.
@stellabelle's baby is growing nicely!
The posts graph is particularly pleasing and is only heading one way :D
Nice one!
the great thing about our group is that you have no trouble finding art that you can use for your posts. As you know, it's all creative commons, so feel free to use anything for your next analysis. Very useful info for me personally!
lol was trying to be a bit arty myself...lol but yes, I should take the help that is being offered. creative commons rocks
thank you @paulag ...nice to know about slothicorn analiysis from you......we hope this tag will be able to carry out its mission...thank to @stellebelle to for this magical project..
Thank you so much for doing this! I have been curious about the stats!
Technically your title should be "Steem blockchain" not "steemit blockchain"
you are correct, I have updated
Interesting project made by @stellabelle
Although I don't know much about BI, but it's great to see more and more applications coming.
I am so happy for all of you slothicorn folks. I saw that bud, and now it is in full bloom...i have not had anything to contribute to it, but I really have fun watching the art and fun flow on my feed. I am a #slothicornlurker
ha ha love it. i was a #slothicornlurker too for some time....this is my first slothi post!
It's a great one. It shines a light on how hashtags can work here.