Slothicorn is a community to support Dedicated, Talented, and Driven Artists.
Slothicorn wants to encourage and promote the creation of Crypto-Currency themed currency, and Creative Commons Art, but Slothicorn is no longer exclusive to that category.
Slothicorn has received funds through the delegate.
The purpose of this analysis is to monitor the weekly activity of in terms of voting. It's also to analyze posts made to the slothicorn category on Blockchain STEEM.
This analysis will be conducted on a weekly basis so that trends can form and growth is measured.
The Data
Using Lynqpad, I have connected to the SteemSQL database (paid subscription service and managed by ). and my thanks to
for giving me guidance and
who have supported me to write this analysis report. You can find the full query at the end of this post.
The Analysis
3 - March 8 2018 Votes Analysis
The above visualizations show a vote for on March 3-8, 2018.
On the first Sunday of March 2018 voted 155 times for 155 Authors. The average voting is SBD $ 4,199 and total approx. The payment provided by the slothicorn is SBD $ 650.94 We can also see from above that the average voting weight used by
is 0.49% and the amount the average vote given per day is 25.
DESCRIPTION OF PERCENTAGE IN PIE
Account that received the highest number of upvotes from Slothicorn
Conclusion
Slothicorn is an amazing project, receiving 1661 posts in the first week of March and casting votes for them. This means that almost 1 in 10 posts created will be selected by . averages 24 times a day in the first week of March.
100% of payments in this category are from . This is rather high and coupled with a lower than average pay as compared to the total writing on blockchain steemit. slothicorn needs to reduce post dependence on sounds from
and also increase the average post payments.
Welcome to - I wish you success in this project. I will prepare this report every week to track the progress of the project.
Do you have any questions or questions about the above data? If so, please leave a comment below.
The SQL Queries
The SQL query used to collect data for votes made by was:
SELECT *
FROM Txvotes (NOLOCK)
WHERE [voter] in ('slothicorn')
AND CONVERT (DATE, timestamp) BETWEEN '2018-03-03' AND '2018-03-08'
The query used to collect data for posts made to the category / tag slothicorn on steemit was:
SELECT
author,
json_metadata,
permlink,
total_payout_value,
pending_payout_value,
net_votes,
created,
children,
Category,
Depth
FROM comments (NOLOCK)
where CONVERT (DATE, created) BETWEEN '2018-02-01' AND '2018-02-28'
and json_metadata like ('% "slothicorn"%')
The Current vote worth for slothicorn has been taken from https://steemworld.org/@slothicorn at 12st March 2018 .
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 or Blockchain 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