Yesterday we looked in detail at Retention for Authors, and we calculated the 60 day retention rate to be 23.3%. However as we all know, Steemit is not just about Authors. It is also about Curators.
In this article, we are going to analyse steemit data for votes to try and calculate the retention rate for Curators.
If you missed yesterday’s analysis you can find it here
https://steemit.com/bisteemit/@paulag/steemit-retention-part-1-business-intelligence-steemit
In the final post, we will combine the results for part 1 and 2 of this analysis and see how Steemit preforms against other social media platforms
Curator Retention
Just so you have the values handy, the chart below shows the number of new accounts registered by month for both 2016 in black and 2017 in turquoise.
High level overview
The first thing I, and probably you, notice from this data is that nearly every account that has registered on Steemit has placed at least 1 vote. There are only 2 accounts out of 361k that have not voted.
In the pie chart it is clear to see, although every account has voted, there is a big drop off. Over 57% of accounts have not voted in the last 60 days. There is however over 28% (102K) of the registered accounts actually voting in the last 30 days. This is nice and high as only 52K accounts actually posted or commented in the last 30 day.
2016
There were 118K accounts registered on Steemit in 2016, however only 11k of these accounts (<10%) have voted in the last 60 days
The chart on the right shows by month of registration, the % of users that are actively, or not actively voting.
2017
The visualisations for 2017 shows a much more promising situation. 58% of accounts registered have voted in the last 60 day. You must keep in mind that 32% of the accounts registered in 2017 have also registered in the last 60%. This would mean that 26% of accounts registered Between Jan and mid-July are have voted in the last 60 days.
Clusters and Outlier's
The last analysis I carried out on the data was to look at the overall clusters and outliers between the number of days accounts have been registered on steemit and the voting ‘active days’.
To calculate the ‘active days’ of a curator I took the last vote date for each user and deducted the account creation date.
The Red mass going up the Days Registered on the left give an indication of the number of curators that were only active for a very short period of time, like days. The further to the right that you move on the chart shows users that have remained active on steemit over time
I was expecting to see a cluster around the 0-100 days registered because there has been a spike in new users during this time
Steemit Curator Retention Rate
In yesterday’s post I introduced you to the calculation for retention. We are going to calculate the 60 day retention rate for curators
Retention Rate = (CE/CN)) X 100
CE = number of users at end of period (that have voted in the last 60 days)= 152K
CN = number of new users acquired during period = 358K
therefore : 152k / 358k = .424 x 100 = 42.4%
Curator retention calculated to be 42.4% of total users.
All of the data taken in this report was from the superb steemsql managed by 
I have used Power BI to connect to steemsql and then used DAX calculations for the analysis.
I am part of a Steemit Business Intelligence community. We all post under the tag #BIsteemit. If you have an analysis you would like carried out on Steemit data, please do contact me or any of the #bisteemit team and we will do our best to help you...