Feb ’18 DLive Analysis - Blockchain Business Intelligence

If you still stream on Twitch, then you’re streaming in the wrong place my friend….welcome to DLive

DLive is one of those awesome apps built on the Steemit platform.  If you are looking for a streaming solution then DLive is surely worth checking out.  

Although relatively new, DLive is heavily funded by way of delegated SP from Steemit Inc and has such massive potential.

Aim of Analysis

The aim of this analysis is to monitor the monthly activity from @dlive in terms of voting.  It is also to analyse posts made via the Dlive app and posts made to the dlive 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 

The data from the blockchain is limited.  When it comes to streaming videos, metrics such as streaming duration and number of viewers 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

The Analysis

February Dlive Votes Overview

In Feb 2018 DLive voted 3639 times for 585 Authors.  The average vote payout was SBD $32 and the total approx. payout given by DLive was SBD $116.13K.  We can also see from above that the average % voting weight used by @dlive was 7.64% and the average number of votes given per day was 130.

February Voting Time Series

Popular Streemers in terms of Upvotes from @Dlive

 DLive Tag post analysis

In February 22K posts were made by 3179 authors receiving 85K comments and 192K votes. The payout value of this posts is SBD $149.76K.

The average post payout in Feb for #dlive posts was $6.80 – substantially higher than the overall post payout average on the Steemit blockchain

We seen above that Dlive have given out approx. SBD $116.13K.  That equates to 77% of the total rewards for this category/tag/app

These 22K posts received 85K comments from 7013 authors.  The comments received 9813 votes and received rewards of SBD $1.85K

Streeming Lovers

Below shows which accounts have posted the most to Dlive in the month of February

And the list below shows those that engage with the posts via comments

Conclusion

Dlive is an awesome project, receiving 22K posts in the month of Feb and voting for 3639 of them. This means that almost 1 in 7 posts made will be voted on by @dlive.  @dlive voted on average 130 times a day in Feb.  I am not sure how much of this is manual curation – maybe someone from the Dlive team could let me know?

77% of the payout in this category comes from @dlive and for Dlive.io 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 – Dlive is only a baby and needs to grow and this will take time!

Welcome to the block @dlive – I wish you every success in with this project and hope to be a contributor as soon as my studio problems are resolved.  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 Query

The SQL query used to collect data on votes made by @dlive was

SELECT *

FROM Txvotes (NOLOCK)

WHERE [voter] in ('dlive') and YEAR(timestamp) = 2018

The SQL query used to collect data on Posts made to #dlive was

SELECT

    author,

    json_metadata,

     permlink,

     total_payout_value,

    pending_payout_value,

    net_votes,

    created,

    children,

    Category,

    Depth

FROM comments (NOLOCK)

where YEAR(created) = 2018 and

json_metadata like ('%"dlive"%')

The Current vote worth for Dlive has been taken from https://steemworld.org/@dlive at 1st 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