Analyzing Dtube

DTube is one of those awesome projects that launched on top of the Steemit Blockchain in 2017. If you are not aware of Dtube is was set up by @heimindanger and as the name suggests it is like Youtube but Decentralized.

With the help of the Steemit community and upvotes on @dtube posts, @dtube was financing its self. In December @mrdelegator delegated 1m SP to @Dtube making a 100% vote worth over SBD$500.

With this voting power @dtube can now make a real effort in rewarding Dtubers for their efforts making the Dtube app a real contender for attracting new video creators.

The aim of this post is to analyse the data behind Dtube. I want to look at details of postings via the Dtube app and also look at the voting done by @dtube.

High Level Overview

In total 41K posts have been made via the dtube app by 7598 different dtubers. These videos have received a total of 300K net votes.

@Dtube has voted for a total of 2856 videos, 668 before the delegation and 2181 after the delegation. The total number of Dtubers voted for is 884, 353 unique dtubers before the delegation and 616 after the delegation.

In total @Dtube votes have been worth SBD$182.49K (SBD= STEEM BACKED DOLLARS trading at US$6.09). Only 6% of this was before the delegation was received.

We can also not from the above data that the average voting weight reduced from 94% to 14% after delegation.

Detailed Analysis

The chart below shows the number of posts made with the Dtube Apps and the number of Dtubers active each day

What we can see from this chart is a spike when Dtube went live, things went down from there until the delegating was received. Once the delegation was received the number of posts and dtubers returned to the level they were at during launch.

The chart above shows how much was reward in votes each day by @dtube. We can see a big increase in daily rewards from this account when the delegation was received. Also in the red line shows the average % weight used when voting, which decreased when the delegation was received.
The table below shows the top earning Dtubers since delegation was received, along with the number of videos they have posted.

We can also add average % weight of vote given and see what Dtubers are getting good votes. You could use this information to look at their Dtube channels and see what are they posting, how good is the quality of the video? Is it unique content?

What I found very interesting from the data is that there have been 41K posts done via the dtube app. However @dtube have only voted on 2856 different posts.

This means that only 6.9% of posts made via the dtube app have been supported by @dtube.
Making an assumption, videos published else where my note get a vote from @dtube. I don’t know what the criteria are for getting a vote from Dtube. Maybe @dtube would like to reply and let us all know?

I also put together a word cloud based on videos that have received a vote from @dtube

The Data

I connected to steemsql held and managed by @arcange.
The SQL query used to collect posts made via the dtube app was

SELECT *
   FROM comments (NOLOCK)
   where   
    ( created >= CONVERT(datetime,'01/06/2017')
    AND created< CONVERT(datetime,'01/02/2018')) and
   (ISJSON(json_metadata) > 0 ) And     
    ( JSON_VALUE(json_metadata,'$.app') in ('dtube', 
   'dtube/0.5','dtube/0.1','dtube/0.2','dtube/0.3''dtube/0.4')  

Initially I was not aware of the different release versions of the dtube app. It was only after extracting data that I noticed it stopped in November, although my requested dates went further. If I have missed anything in this query or the data set please do let me know.

The SQL query used to collect votes from @dtube was

SELECT *
FROM Txvotes (NOLOCK)
 WHERE [voter] in ('dtube')

Once I collected all off the data I then added further filters and used DAX for calculations and modelling.

Conclusion

Its really good to see the interest in Dtube take off again in December. I do hope that this continues, and I am sure Steemit Inc also hopes for success as @mrdelegator is an official steemit account.

I did take some time to watch videos that have an have not been voted for by @dtube and I really do think exclusivity could be a factor when it comes to @dtube making votes. Being the video creator also seems to be a factor, so taking videos from youtube that are not yours will not get you a vote.

I my self have taken steps towards the use of Dtube and have been promoting it to the online instructor community. Traditionally online instructors would use Youtube to direct traffic to their online courses. A lot of good quality educational material, taken directly from paid courses is hosted on Youtube and given away free. Dtube now offers a way online instructors can share part of their courses and get paid at the same time.

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 discordhttps://discordapp.com/invite/JN7Yv7j

---

Posted on Utopian.io - Rewarding Open Source Contributors

---