Are you familiar with SoundCloud? Familiar with hosting Postcasts? DSound.Audio is an awesome app built upon the Steem Blockchain, that is just like SoundCloud but it is decentralised and creators can earn STEEM from upvotes on their content.
The aim of this analysis is to monitor the monthly activity from @dsound in terms of voting. It is also to analyse posts made via the DSound app and posts made to the DSound category on the STEEM Blockchain
This analysis will be carried out on a monthly basis so that trends can be established and growth measured.
The data from the blockchain is limited. When it comes to sharing audio for creators, metrics such as play duration and number of listeners are of critical importance if you are trying to grow your channel. However this data is not collected on the blockchain and not part of this analysis
Using PowerBI, I have connected to the SteemSQL database (paid subscription service held and managed by @arcange). You can find full details of the query used at the bottom of the article
February @dsound Votes Analysis
In Feb 2018 DSound voted 532 times for 2733 Authors. The average vote payout was SBD $21 and the total approx. payout given by DSound was SBD $56.82K We can also see from above that the average % voting weight used by @dsound was 9.38% and the average number of votes given per day was 97.5.
February Voting Time Series
Popular Streemers in terms of Upvotes from @DSound
DSound Tag Post Analysis
In February 13K posts were made by 3054 authors receiving 34K comments and 179K votes. The payout value of this posts is SBD $72.82K.
The average post payout in Feb for #dsound posts was $5.60 – substantially higher than the overall post payout average on the Steemit blockchain
We see above that DSound have given out approx. SBD $56.82K. That equates to 78% of the total rewards for this category/tag/app
These 13K posts received 34K comments from 7158 authors. The comments received 12K votes and received rewards of SBD $1.23K
Below shows which accounts have posted the most to DSound in the month of February
And the list below shows those that engage with the posts via comments
DSound is an awesome project, receiving 13K posts in the month of Feb and voting for 2,733 of them. This means that almost 1 in 5 posts made will be voted on by @dsound. @dsound voted on average 97.5 times a day in Feb. I am not sure how much of this is manual curation – maybe someone from the Dsound team could let me know?
78% of the payout in this category comes from @dsound and for Dsound.audio to be self-sufficient this should really be lower. However there are many factors not in the data above that impacts this and right now, this is not a problem. For one – Dsound is only a baby and needs to grow and this will take time!
Welcome to the block @dsound – I wish you every success in with this project. I will be preparing this report on a monthly basis to track the progress of the project.
Do you have any questions or queries on the data above? If so, please do leave a comment below.
The SQL Queries
The SQL query used to collect data for votes made by @dsound was:
SELECT * FROM Txvotes (NOLOCK) WHERE [voter] in ('dsound') AND CONVERT(DATE,timestamp) BETWEEN '2018-02-01' AND '2018-02-28'
The query used to collect data for posts made to the category/tag Dsound 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 ('%"dsound"%')
The Current vote worth for Dsound has been taken from https://steemworld.org/@dsound at 6st 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...
Posted on Utopian.io - Rewarding Open Source Contributors