Analyzing the Slothicorn Project on the Steem Blockchain

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.

<p dir="auto">If you missed Stellas post introducing Slothicorn you can read it here<br /><span> <a href="https://steemit.com/slothicorn/@stellabelle/introducing-a-new-steem-project-slothicorn-half-sloth-half-unicorn-all-magic" target="_blank" rel="noreferrer noopener" title="This link will take you away from hive.blog" class="external_link">https://steemit.com/slothicorn/@stellabelle/introducing-a-new-steem-project-slothicorn-half-sloth-half-unicorn-all-magic <p dir="auto"><span>If you would like to find out more about this project or get involved then have a read of <a href="/@inquiringtimes">@inquiringtimes post on the discord server and then hop on over and join in on the magic. <p dir="auto"><span><a href="https://steemit.com/slothicorn/@inquiringtimes/an-introduction-to-the-slothicorn-discord-chat" target="_blank" rel="noreferrer noopener" title="This link will take you away from hive.blog" class="external_link">https://steemit.com/slothicorn/@inquiringtimes/an-introduction-to-the-slothicorn-discord-chat <p dir="auto"><span>Behind <a href="/@slothicorn">@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. <p dir="auto"><span>The aim of this analysis is to see how far the reach has been and establish some behaviours of voting from <a href="/@slothicorn">@slothicorn and posting within the tag <a href="/trending/slothicorn"> #slothicorn <p dir="auto">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 <h2><span>Vote Analysis from <a href="/@slothicorn">@Slothicorn <p dir="auto"><img src="https://images.hive.blog/768x0/https://res.cloudinary.com/hpiynhbhq/image/upload/v1519119902/bxmk2lrtscnnjaanq5xe.png" alt="4.png" srcset="https://images.hive.blog/768x0/https://res.cloudinary.com/hpiynhbhq/image/upload/v1519119902/bxmk2lrtscnnjaanq5xe.png 1x, https://images.hive.blog/1536x0/https://res.cloudinary.com/hpiynhbhq/image/upload/v1519119902/bxmk2lrtscnnjaanq5xe.png 2x" /> <p dir="auto"><span>Since the start of 2018 <a href="/@slothicorn">@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 <a href="/@slothicorn">@slothicorn is $4.74K SBD <p dir="auto">Lets look at this over time <p dir="auto"><img src="https://images.hive.blog/768x0/https://res.cloudinary.com/hpiynhbhq/image/upload/v1519119917/x3cwlmvdqqyibnzqy4af.png" alt="5.png" srcset="https://images.hive.blog/768x0/https://res.cloudinary.com/hpiynhbhq/image/upload/v1519119917/x3cwlmvdqqyibnzqy4af.png 1x, https://images.hive.blog/1536x0/https://res.cloudinary.com/hpiynhbhq/image/upload/v1519119917/x3cwlmvdqqyibnzqy4af.png 2x" /> <p dir="auto">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. <h2><span>Post Analysis to <a href="/trending/slothicorn"> #Slothicorn <p dir="auto"><img src="https://images.hive.blog/768x0/https://res.cloudinary.com/hpiynhbhq/image/upload/v1519119940/goyhrjp1amqof7vmuoh6.png" alt="6.png" srcset="https://images.hive.blog/768x0/https://res.cloudinary.com/hpiynhbhq/image/upload/v1519119940/goyhrjp1amqof7vmuoh6.png 1x, https://images.hive.blog/1536x0/https://res.cloudinary.com/hpiynhbhq/image/upload/v1519119940/goyhrjp1amqof7vmuoh6.png 2x" /> <p dir="auto">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. <p dir="auto"><span>Of this $9.25K SBD, <a href="/@slothicorn">@slothicorn contributed approx. 4.74K or 51% of the rewards to this community. <p dir="auto"><img src="https://images.hive.blog/768x0/https://res.cloudinary.com/hpiynhbhq/image/upload/v1519119958/klnr70uom0a6s8vo367x.png" alt="7.png" srcset="https://images.hive.blog/768x0/https://res.cloudinary.com/hpiynhbhq/image/upload/v1519119958/klnr70uom0a6s8vo367x.png 1x, https://images.hive.blog/1536x0/https://res.cloudinary.com/hpiynhbhq/image/upload/v1519119958/klnr70uom0a6s8vo367x.png 2x" /> <p dir="auto"><span>The chart above shows the number of posts per day to the tag <a href="/trending/slothcorn"> #slothcorn. From this we can see a steady growth in the popularity of this tag. <h2>Slothcorn Contributor Activity <p dir="auto"><img src="https://images.hive.blog/768x0/https://res.cloudinary.com/hpiynhbhq/image/upload/v1519119976/ed9atzh42hgf9tw6r1rd.png" alt="9.png" srcset="https://images.hive.blog/768x0/https://res.cloudinary.com/hpiynhbhq/image/upload/v1519119976/ed9atzh42hgf9tw6r1rd.png 1x, https://images.hive.blog/1536x0/https://res.cloudinary.com/hpiynhbhq/image/upload/v1519119976/ed9atzh42hgf9tw6r1rd.png 2x" /> <p dir="auto"><span>Above you will find three tables of data. The table on the left represents the authors voted for by <a href="/@slothicorn">@slothicorn sorted by the number of votes received. <p dir="auto"><span>The table in the centre represents the Authors the contributed Posts to the tag <a href="/trending/slothicorn"> #slothicorn, sorted by the number of posts submitted. <p dir="auto"><span>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 <a href="/trending/slothicorn"> #slothicorn. <h2>Conclusion <p dir="auto">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. <p dir="auto">It appears from the data and voting pattern that the posts are manually curated and authors tend to contribute more than once. <p dir="auto">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. <h2>The Data and Query <p dir="auto">I used Power BI to connect to the Steemsql database. The SQL query used to get the voting data from Steemsql was <pre><code>SELECT * FROM Txvotes (NOLOCK) WHERE [voter] in ('slothicorn') and YEAR(timestamp) = 2018 <p dir="auto">The query used to get the posts and comments was <pre><code>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"%') <p dir="auto">After collecting the data from the Sql query, I then used DAX to carry out calculations and analysis across the tables. <h2>Vote worth and Total Approx Payout. <p dir="auto"><span>At the time of calculation <a href="/@slothicorn">@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 <a href="/@slothicorn">@slothicorn voted 67 times on the 19th – the day the data was collected. <p dir="auto"><span>I am part of a Blockchain Business Intelligence community. We all post under the tag <a href="/trending/blockchainbi"> #blockchainbi. If you have an analysis you would like carried out on Steemit data, please do contact me or any of the <a href="/trending/blockchainbi"> #blockchainbi team and we will do our best to help you... <p dir="auto"><span>You can find <a href="/trending/blockchainbi"> #blockchainbi on discord <a href="https://discordapp.com/invite/JN7Yv7j" target="_blank" rel="noreferrer noopener" title="This link will take you away from hive.blog" class="external_link">https://discordapp.com/invite/JN7Yv7j <p dir="auto"><br /><hr /><em>Posted on <a href="https://utopian.io/utopian-io/@paulag/analyzing-the-slothicorn-project-on-the-steemit-blochchain" target="_blank" rel="noreferrer noopener" title="This link will take you away from hive.blog" class="external_link">Utopian.io - Rewarding Open Source Contributors<hr /><p>