Feb ’18 DLive Analysis - Blockchain Business Intelligence

in #dlive8 years ago

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 

Sort:  

@paulag amazing article. I'm a numbers person myself so the way you break this down is amazing. Maybe one day you can bring a BI type stream to DLive?

On the part of your article where you said in February we voted on average 130 times a day. This is done manually by my small team, and we will continue to do more and better as time goes on. We love seeing new streamers and new content :D

Your team work hard and do great work @jimmylin. thank you making @dlive good platform for us.

so happy you stopped by @jimmylin and thank you for clearing up the question I had on curation. Thats a lot of work - hope to see the team keep it up. Really glad you like this report!

Bring BI to Dlive is an option - as an online instructor for my day job - Dlive offers a lot that us instructors need. I did notice your learning category on discord :-). I would like to talk with you about this, and about more data - maybe you would hit me up on discord when you get a few min. My discord name is the same.

Just messaged you on Discord :) We can chat there.

Don't you just love sentences that start with, can you...

Can you list the top earners for the month from dlive votes?!

Apps like dlive dtube utopian-io, combined with SMTs will see STEEM 20$+ next year :p

yes I can....would you like me too...?

Yes please if it's a quick one!

Just because you said please

1.png

Some nice money being made at the top! Thank you!

Wish my net connection was better!!

You do a great work @paulag awesome analysis ✊🏻

Ah thank you so much @hafizul

Hallo @paulag i'm steemian from bojonggede bogor indonesia😊

Coin Marketplace

STEEM 0.12
TRX 0.34
JST 0.033
BTC 113032.10
ETH 4198.29
USDT 1.00
SBD 0.86