RE: Dtube in 2018 – Data on Activities, Posts, Votes, Payouts and Top Dtubers
Hi @dalz,
good summary of the dtube activties in 2018! It is probably no big surprise that the overall activity decrease follows the general trend on Steem. A direct comparison with overall Steem could have been interesting to see as well. The number of comments saw a strong increase in the last 1-2 weeks of the year. From the graph it looks like a factor of 4-5 more than the weeks before - do you have any idea what "happened" there? Seeing the number of supported users stable over the most part of the year despite the decrease in overall activity is a good sign I think.
Could you briefly explain how you calculated the daily vote values and payouts in STEEM? It looks like you used a fixed STEEM value for the 100% dtube vote for the whole year and discounted that with the individual vote percentages, but maybe I misunderstood?
I think the query for the posts and comments is too broad and captures more posts and comments than those created with dtube. A filter for "dtube" in json_metadata also matches any post that uses dtube as any tag or part thereof, mentions @dtube or any other account with "dtube" in their name, contains a link to a dtube post, etc...
Your contribution has been evaluated according to Utopian policies and guidelines, as well as a predefined set of questions pertaining to the category.
To view those questions and the relevant answers related to your post, click here.
Need help? Write a ticket on https://support.utopian.io/.
Chat with us on Discord.
[utopian-moderator]
Thank for the review @crokkon! You always trough some challenge in the comment :) I'm trying to keep up with those.
I must say doing this analysis in excel was quite a challenge since at occasions there were more than a million rows and excel was slow and lagging. Especially on the post data. Maybe I need to look at some different tool.
The number of comments went from around 300 daily average to a 700-800 in the end of the year. This increase happened on 21 and 22 second December. I really don't know what happened there. I double checked the data and it is accurate. Maybe the holidays made this happened, since this was the start of the weekend :).
About the daily vote values and payouts, I assigned the SP of Dtube for each date, and then calculate the individual votes, according to the weight. I used the daily SP of Dtube, multiplied with 0,00756447%, and multiplied again with the weight of the vote. The percent I used theoretically is for 95% of the Dtube vote. I went with assumption since not all the time Dtube votes with 100% that is for sure.
After this I made the daily sums of the votes. It isn't an 100% accurate way, since not all the time Dtube votes with 95%, and the rewards isn't just in STEEM, but it is close enough I think. Also when I think about it now, I should of removed the 25% curators reward. If you prefer I will make the correction.
haha, I'm just a curious mind - no need to edit the post :) I can image that this comes close the what Excel can handle. Paulag, abh12345 and others use PowerBI - maybe that's an option for you as well? I mostly script it with python.
I think the vote value calculation is not fully correct. The STEEM-equivalent value of the votes varies with several factors even if the SP and the VP is fixed. The most accurate value I can think of right now is to use the
author_rewardfield of the Posts/Comments where dtube voted on and calculate the tdube contribution thereof by the fraction of the dtube vote rshares wrt to the sum of all vote rshares on that post.Thank you for your review, @crokkon! Keep up the good work!