3 - 8 MARCH 2018 SLOTHICORN Upvote Analysis

in #utopian-io7 years ago (edited)

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

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



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

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

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

Welcome to @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 @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

Sort:  

Your contribution cannot be approved because it does not refer to or relate to an open-source repository. See here for a definition of "open-source."

Dear @irwanumpal, the slothicorn github repository at this point contains no code. The analysis you've done is based on Steem blockchain data, but the scope of the work is too narrow to accept this as an analysis for steemit/steem.
Additionally, the "analysis" aspect is a bit short. You show data only from one week, so drawing conclusions on the community growth is not really meaningful. The comparison of the average payout with all steem lacks reference numbers.

You can contact us on Discord.
[utopian-moderator]

Thank you @crokkon for your advice...