Did you Join Steemit In Jan 17? Here is some Data to Celebrate

If you joined Steemit in Janurary 2017 then you celebrated your Steemit birthday with 6,739 other Steemain. Congratulations and welcome to the One Year Club.

It is commonly known that the retention rate on Steemit is rather low, so if your Steemit birthday was in Janurary and you are reading this, let it be known that you have achieved a lot. You are an early adapter of an experimental platform and you deserve to be acknowledged.

To celebrate your 1 year Steemit Birthday I have some data to present to you. Data that proves you are special

In January 2017 6740 new accounts registered on Steemit. Of this 4470 have never made a post. That means only 31% or 2270 accounts made post or comments on the platform.
From this 2270 accounts, a further 1073 accounts stopped posting by day 20 and have not posted since and only 487 accounts have posted in the last 45 days. If you are one of these 487 accounts you make up only 7.5% of the 6740 users that registered on Steemit in Jan 2017.

These 6740 accounts own 834.45K SP between them. They have received 50.8K SP in delegation and have given out 96.67K in delegation. This leaves a controlling SP of 788.57K. From the data above we can also see that the 1708 accounts that posted made 925,543 posts earning 496.18M in author rewards and also 34.61M in curator rewards.

Taking the same dataset but now adding a filter to exclude any users that have not posted. The 2270 accounts that have posted own 56% of the SP owned by everyone that joined in Jan and they are in control of 60% of the controlling SP

There is however a different between the curation rewards earned on All accounts registered in Jan 17 to the accounts with active authors. This difference of 3.59M or 10% of curation reward earned by accounts registered in Jan 17 went to curators, or accounts that have never posted just voted.

We spoke about retention, but just to let you visualized when the accounts were dropping off. The chart below plots the number of days since last post against the no of days registered on Steemit. The deeper the color the more users.

We can see on the right of this chart high population of deep colours. This represents the users that registered and either never posted or haven’t posted in 340+ days. As we move to the left of the chart we can see the drop off slows down and on the left there is a high concentration of accounts posting, which represents the 7.5% of accounts that have posted in the last 45 days.

The chart below plots the 2270 identified authors against the number of days active and the SP Owned. We can see most accounts have an SP of less than 1.5K until we get to accounts active 350+ days where many accounts have an SP of up to 5K and 10K. There are only 7 accounts with an owned SP of over 10K from accounts that registered in Jan 2017

If we run the same chart with ALL the account that registered in Jan 17 we can see a few outlier accounts set up and never posted with owned SP of 20K+

Movers and Shakers

First Filtering the data to accounts that never posted and sorting by SP owned

Now if we filter the data to show the users active in the last 45 days, first sorting by SP owned

And now sorting by Posting rewards earned shown in vests

While sorting through this data I found a number of accounts that registered in Jan 2017 but only made their first or second post in the last 45 days. Welcome back dudes and dudesses

Looking at all Jan 2017 accounts now and sorting by the number of posts and comments made.

Inactive Authors

Finally I did some totting on data relating to inactive author accounts.

6312 accounts set up in Jan 17 have an SP of 50 or less. The total SP owned by these accounts is 201.08K. Of this 4447 accounts have never posted and the total of SP owned by these accounts is 138.51K

Conclusion

Author Retention % from Jan 17 is only 7.5%, however these accounts own more than 55% of the SP owned by all of the accounts registered that month. In the last 45 days, we seen a return of 22 Steemains to the platform that were previously considered dead fish. Although only a small value (0.3%), it is nice to see this claw back.

A point of interest from this data is the totting on data relating to inactive author accounts. How many of these people will return to steemit and grow or transfer out this SP? And having dead fish accounts like this, does it help with the price of STEEM as these coins are effectively locked in for potentially far longer than 13 week?

The Data and Analysis

This analysis was prepared using Power BI to connect to Steemsql
The SQL query used was

select *
from Accounts NOLOCK
where  
( created >= CONVERT(DATE,'2017-01-01') AND created< CONVERT(DATE,'2017-02-01'))

From here I used the M language in Power BI query editor to remove any columns I did not need, before I loaded the data into the model. The data was extracted 30 Jan 18
From here I then carried out analysis, calculations and modelling using DAX

Aim of Analysis

The aim of this analysis was to establish the retention of Authors based on Users registered in Jan 2017 and also visualize the SP growth of Active authors after 1 year on Steemit. Its aim was also to celebrate and identify users that have remained active for the last year and to see if fish can rise from the dead.

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

If you know someone that joined Steemit in Jan 17, feel free to tag them in the comments :-)

---

Posted on Utopian.io - Rewarding Open Source Contributors

---