Benefactor rewards status before Hardfork20

in #utopian-io6 years ago (edited)

0. Introduction

Benefactor Rewards was introduced in hardfork18. It splits a part of the authors rewards to a list of beneficiaries. Regardless of the author's reward setting, benefactors received the rewards in 100% steem power (SP). It was able to help and support developers to continue their steem-based application projects (Dapps).

Once hardfork20 is implemented on Tuesday, September 25, at 11:00am EST., benefactors will receive both steem power (SP) and liquid steem. It will be helpful for project owners and developer to sustain and maintain their projects.

Why do this analysis?

In this analysis, I want to explore the benefactor reward trends and distribution before the full implementation of hardfork20. In addition, I will find out “proof of growth” of the steem blockchain by looking into the number of projects being reward through benefactor reward system.

Github Repository: steemit/steem

1. Aim of the Analysis

The goal of the analysis is to:

  1. Analyze the monthly benefactor rewards trend between April 2017 and July 2018;

  2. Perform a comparative analysis between the first 8 months and the last 8 months of benefactor rewards; and,

  3. Find out the most number of engagement and rewards among the beneficiaries.

2. Methodology ( Tools and Query)

I use steemSQL wrapper to find out the data columns inside the VOCommentBenefactorRewards table from steemSQL. Having no experience with the VOCommentBenefactorRewards table, I initialize a query to look into data contents in each columns.

SELECT * FROM VOCommentBenefactorRewards(NOLOCK) WHERE VOCommentBenefactorRewards.timestamp >= '2018/07/01' AND VOCommentBenefactorRewards.timestamp < '2018/08/01'


After observing the raw data, I found out that the reward is an varchar data type. This could not be used to create visuals and plots on benefactor reward trends. So, I created a new query which contains a convertion of varchar to float data type for the rewards.

CONVERT(float,LEFT(VOCommentBenefactorRewards.reward,LEN(VOCommentBenefactorRewards.reward)-6))) AS [REWARD]


A final query was used to tabulate the monthly distribution of benefactors, post count, and sum of rewards. The query is written below.

SELECT
YEAR(VOCommentBenefactorRewards.timestamp) AS [YEAR],
MONTH(VOCommentBenefactorRewards.timestamp) AS [MONTH],
COUNT(VOCommentBenefactorRewards.benefactor) AS [BENEFACTOR],
COUNT(VOCommentBenefactorRewards.permlink) AS [POST],
SUM(CONVERT(float,LEFT(VOCommentBenefactorRewards.reward,LEN(VOCommentBenefactorRewards.reward)-6))) AS [REWARD]
FROM VOCommentBenefactorRewards(NOLOCK)
WHERE
VOCommentBenefactorRewards.timestamp >= '2017/04/01' AND
VOCommentBenefactorRewards.timestamp < '2018/08/01'
GROUP BY
YEAR(VOCommentBenefactorRewards.timestamp),
MONTH(VOCommentBenefactorRewards.timestamp)


To retrieve all the benefactors with each corresponding post count and reward sum, another query was used :

SELECT
VOCommentBenefactorRewards.benefactor AS [BENEFACTOR],
COUNT(VOCommentBenefactorRewards.permlink) AS [POST],
SUM(CONVERT(float,LEFT(VOCommentBenefactorRewards.reward,LEN(VOCommentBenefactorRewards.reward)-6))) AS [REWARD]
FROM VOCommentBenefactorRewards(NOLOCK)
WHERE
VOCommentBenefactorRewards.timestamp >= '2017/04/01' AND
VOCommentBenefactorRewards.timestamp < '2018/08/01'
GROUP BY
VOCommentBenefactorRewards.benefactor


After all the data were successfully gathered, visualization and plotting was done through Microsoft Excel.

3. Data Presentation and Analysis

Rewards and User Engagement Shares of Benefactors

A total of 777,267,981 Vests was rewarded to 2,712 benefactors. Dtube received 34.16% of the rewards. It was followed by utopian.pay and esteemapp with 15.49% and 11.06% share of the reward. Most rewarded beneficiaries are projects, Dapps and delegators in the platform.

Figure 1: Rewards distribution among different beneficiaries

Popular mobile apps (e.g. esteemapp and steepshot) gain more shares in the reward because it is easily accessible through user's smartphone.

Contribution based Dapps also landed on top of the most rewarded beneficiaries such as utopian-io and steemhunt.

Among delegators, @freedom received about 2.21% of the reward. Other delegators such as @misterdelegation and @ned (steemit founder) also received a fair share of the reward.

Figure 2: Post count distribution among different beneficiaries

In terms of user engagement, esteemapp gain 41.21% share for being popularly used by users in steem blockchain. It was followed by steepshot with 7.53% usage. Popular Dapps such as Dtube and Dmania also receive a good share of user engagement.

Short content platforms such as esteemapp, steepshot, zappl and Dmania are quite popular for most users in the platform. It has listed the most engagement among top beneficiaries.

Photography related apps and project also popular among users such as steepshot and bescouted.com. In addition, contribution and rewarding platforms such as utopian and steemhunt is also popular.

Benefactor Reward: Monthly Trends

Figure 3: Monthly number of beneficiaries receiving the rewards

After benefactor rewards released in April 2017 (hardfork18), the number of benefactors was steadily increasing for the next 12 months. On average, there are 146,237 beneficiaries rewarded. A notable decline was observed from March 2018 until today. However, the number of beneficiaries in July is still above the 146,237 average.

As stated earlier, majority of the beneficiaries are projects in steemit. The decline of beneficiaries may be attributed to projects that was already shutting down. In fact, chainb has announced shutdown 5 months ago.

In reality, project owners and developers need to pay for the operating cost to maintain the project online including server fees. Withdrawing steem power (vests) needs at most 13 weeks to fully get the all withdrawn steem power (vest).

In addition, hardfork20 is timely to correct the downtrend. Projects owners will be receiving liquid steem so that they can easily have funds to pay the operating cost.


Figure 4: Monthly benefactor rewards generated

On average, the monthly generated benefactor reward is 48,579,248.79 Vests. The highest generated benefactor reward was about 95,806,550.87 Vests. A notable decline only happen in May 2018. It recorded 62,494,712.42 Vests. However, the decline is still above the monthly average.

Overall, the plot shows an increasing amount of rewards generated. From the current numbers, it is expected to steadily increase in the coming months. A boost is also predicted as hardfork20 is released.

Figure 4: Monthly post with beneficiaries (user engagement to projects) rewards generated

The same with the other metrics. Post count shown a steady increased in the first 12 months. On average, there are 165,636.68 post per month. A steady decrease observed after March 2018. However, the number are still above the monthly average.

In addition, the plot shows engagement of users to different projects in steemit. Each projects generates a good increasing numbers of engagement per month. It is projected to steadily increase for the coming months. However, we can not take for granted that there was a decrease in engagement. It may suggest lower retention of users into these projects.

I am hoping the notable decrease in the engagement will be reverse by the implementation of hardfork20. Hardfork20 have interesting updates that I believe to make the current numbers turn around.

Looking for "proof of growth"

From April to November 2017, a total of 145,606,905.2 Vests distributed to 554 beneficiaries. Esteemapp received 25.26% of the rewards amounting to 36,787,416.08 vests. Dtube and Chainbb followed with 19.53% and 11.86% share of the reward.

Figure 6: Rewards shared by benefactor between April to November 2017

In the first 8 months, pioneer projects in steemit received big chuck of the reward. However, there are fewer projects as beneficiaries within the timestamp. We can also note that majority of the beneficiaries at this time are delegators and project owners e.g. @ned, @misterdelegation, @elear etc.

On the other hand, from December 2017 to July 2018, Dtube gained the highest rewards at 37.53% share. It amounts to 23,7051,773.568934 Vests. The reward received by Dtube increased by 644% from the earlier.

Esteemapp placed third among beneficiaries at 7.76% which amounts to 49,024,725.5949041 Vests. It ranks two step lower from the previous ranking. In terms of reward earned, esteemapp gained 144% from December 2017 to July 2018 as compared to April 2017 to November 2017.

Figure 7: Rewards shared by benefactor between December 2017 to July 2018

We can acknowledge growth of majority of the Dapps. However, it is inevitable that there were no project that suffer lost in the platform. Chainb has the biggest lost among the Dapps in the platform. It ranks 39th on the received reward from it previous rank 3rd in rewards. Primarily, the drop is caused by its announcement of shutdown earlier this year. Its reward drops 224.74%.

From December 2017 to July 2018, majority of the beneficiaries where projects in the platform. We can take note that the number of projects have tremendously increased over the last 8 months. As a proof, there were more projects ranked with more benefactor rewards received than the earlier 8 months of benefactor rewards distribution. Sadly, there are some platforms that was not able to continue.


Figure 8: Comparison for selected Dapps rewards between different timestamp

We can see a tremendous growth in rewards for the popular dapps. As we can observe from the plot, majority of the selected dapps received more rewards between December 2017 to July 2018 as compared to April 2017 to November 2017. For example, dtube earned over 644% rewards as compared to the earlier stage of benefactor reward system in the platform.


Figure 8: Comparison for selected Dapps engagement between different timestamp

Furthermore, we can observe more usage and engagement on dapps in the platform. For example, esteemapp was widely used platform as it shares 35.53% of all post with beneficiaries. It is a good indication that dapps and other projects in the platform encourages user to engage more on the platform. Basically, majority of these projects rewards post and contribution.

Overall, a positive "proof of growth" was identified from the increase in the rewards and engagements on different projects in steemit. There were platforms that have loss rewards and shutting down. However, there are more new projects coming in. Majority generates bigger benefactor rewards and engagement to these projects.

As steemit moves forward with hardfork20, I strongly believe it will turn around the decreasing trend in the lat 3 months. We can expect a better rewards for both the users and the benefactors as well.

4. Final Thoughts

A total of 2,712 benefactors shares the benefactor reward pool amounting to 777,267,981 Vests. Dapps received majority of the benefactor rewards. Dtube, utopian and esteemapp shares 60.71% of the total benefactor reward.

In terms of engagement, short content platforms like esteemapp, steepshot, zappl and Dmania are popular with the users in the platform. It generates 64.87% of user postings with beneficiaries.

A notable decline was observed in the last 3 months for both rewards and posting. However, in general, the plot suggest an increasing trend even with a decrease in the tail-end of the timestamp. We can expect a turn around of the last 3-months down trend by the time hardfork20 is implemented.

As for the "proof of growth", I was able to point out that there was a steady growth of the platform. In comparison to the time where benefactor reward was first introduced in hardfork18, we can take into account a big increase of both rewards and engagement generated through the dapps and projects in steemit.

Lastly, hardfork20 will eventually raised the reward further which could also generate more engagement. The increasing trend observed today will eventually be sustained.

Proof of Work: juecoree/Steemit-Analysis

Sort:  

Hi @juecoree, very interesting approach to look into the benefactor rewards! A few of the graphs seem to indicate connections to the user boost in mid 2017 and beginning of 2018, as well as the high Steem price around end of 2017, which could maybe partly explain engagement trends. Add some axis labels to the graphs to make them easier readable. The beneficiary system is greatly influenced by the the rise (and possibly fall) of dapps. You took a rather coarse cut to look into two periods of around 8 months. Visualizing the share of the individual dapps over time could have provided additional insights. Also, some apps switched the beneficiary accounts over time, or use more than one beneficiary per post.

Once hardfork20 is implemented [...] benefactors will receive both steem power (SP) and liquid steem.

You probably meant the same thing, but just to confirm: The beneficiary shares in HF20 will use the same payout settings as the author rewards, which can be either 100% SP as before or 50% SP and 50% STEEM/SBD.

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]

Thanks for the review, @crokkon! I agree it will generate additional insight if I had look into the individual dapps.

Thank you for your review, @crokkon!

So far this week you've reviewed 1 contributions. Keep up the good work!

Hey @juecoree
Thanks for contributing on Utopian.
We’re already looking forward to your next contribution!

Want to chat? Join us on Discord https://discord.gg/h52nFrV.

Vote for Utopian Witness!

You have a minor misspelling in the following sentence:

Among delegators, @freedom recieved about 2.
It should be received instead of recieved.

Congratulations! This post has been upvoted from the communal account, @minnowsupport, by juecoree from the Minnow Support Project. It's a witness project run by aggroed, ausbitbank, teamsteem, someguy123, neoxian, followbtcnews, and netuoso. The goal is to help Steemit grow by supporting Minnows. Please find us at the Peace, Abundance, and Liberty Network (PALnet) Discord Channel. It's a completely public and open space to all members of the Steemit community who voluntarily choose to be there.

If you would like to delegate to the Minnow Support Project you can do so by clicking on the following links: 50SP, 100SP, 250SP, 500SP, 1000SP, 5000SP.
Be sure to leave at least 50SP undelegated on your account.

Resteemed your article. This article was resteemed because you are part of the New Steemians project. You can learn more about it here: https://steemit.com/introduceyourself/@gaman/new-steemians-project-launch

Congratulations! Your post has been selected as a daily Steemit truffle! It is listed on rank 15 of all contributions awarded today. You can find the TOP DAILY TRUFFLE PICKS HERE.

I upvoted your contribution because to my mind your post is at least 13 SBD worth and should receive 146 votes. It's now up to the lovely Steemit community to make this come true.

I am TrufflePig, an Artificial Intelligence Bot that helps minnows and content curators using Machine Learning. If you are curious how I select content, you can find an explanation here!

Have a nice day and sincerely yours,
trufflepig
TrufflePig

Coin Marketplace

STEEM 0.16
TRX 0.15
JST 0.028
BTC 57847.79
ETH 2291.52
USDT 1.00
SBD 2.46