3 - 8 MARCH 2018 SLOTHICORN Upvote Analysis

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 Hive account@stellabelle delegate.

The purpose of this analysis is to monitor the weekly activity of Hive account@slothicorn 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 Hive account@arcange). and my thanks to Hive account@paulag for giving me guidance and Hive account@ghulammujtaba 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 Hive account@slothicorn Votes Analysis

---

The above visualizations show a vote for Hive account@slothicorn on March 3-8, 2018.

On the first Sunday of March 2018 Hive account@slothicorn 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 Hive account@slothicorn 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
Hive account@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 . Hive account@slothicorn averages 24 times a day in the first week of March.

100% of payments in this category are from Hive account@slothicorn. 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 Hive account@slothicorn and also increase the average post payments.

Welcome to Hive account@slothicorn - 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 Hive account@slothicorn 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

---