create account

Tx cd8aea884ab995e344f139ace9c0c8f808053d10@15435047

Included in block 15,435,047 at 2017-09-13 16:21:21 (UTC)

Raw transaction

expiration2017-09-13 16:22:15
title"Steemit Retention Part 2 – Business Intelligence Steemit"
<p>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. &nbsp;It is also about Curators.</p>
<p>In this article, we are going to analyse steemit data for votes to try and calculate the retention rate for Curators.</p>
<p>If you missed yesterday’s analysis you can find it here</p>
<p>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</p>
<h2>Curator Retention</h2>
<p>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.</p>
<h3>High level overview</h3>
<p>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. &nbsp;There are only 2 accounts out of 361k that have not voted.</p>
<p>In the pie chart it is clear to see, although every account has voted, there is a big drop off. &nbsp;Over 57% of accounts have not voted in the last 60 days. &nbsp;There is however over 28% (102K) of the registered accounts actually voting in the last 30 days. &nbsp;This is nice and high as only 52K accounts actually posted or commented in the last 30 day.</p>
<p>There were 118K accounts registered on Steemit in 2016, however only 11k of these accounts (&lt;10%) have voted in the last 60 days</p>
<p>The chart on the right shows by month of registration, the % of users that are actively, or not actively voting.</p>
<p>The visualisations for 2017 shows a much more promising situation. &nbsp;58% of accounts registered have voted in the last 60 day. &nbsp;You must keep in mind that 32% of the accounts registered in 2017 have also registered in the last 60%. &nbsp;This would mean that 26% of accounts registered Between Jan and mid-July are have voted in the last 60 days.</p>
<h3>Clusters and Outlier's</h3>
<p>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’.</p>
<p>To calculate the ‘active days’ of a curator I took the last vote date for each user and deducted the account creation date.</p>
<p>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. &nbsp;The further to the right that you move on the chart shows users that have remained active on steemit over time</p>
<p>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</p>
<h2>Steemit Curator Retention Rate</h2>
<p>In yesterday’s post I introduced you to the calculation for retention. &nbsp;We are going to calculate the 60 day retention rate for curators</p>
<p>Retention Rate = (CE/CN)) X 100</p>
<p>CE = number of users at end of period (that have voted in the last 60 days)= 152K</p>
<p>CN = number of new users acquired during period = 358K</p>
<p>therefore : 152k / 358k = .424 x 100 &nbsp;= 42.4%</p>
<p><strong>Curator retention calculated to be 42.4% of total users.</strong></p>
<p>All of the data taken in this report was from the superb steemsql managed by @arcange. &nbsp;</p>
<p>I have used Power BI to connect to steemsql and then used DAX calculations for the analysis.</p>
<p><em><strong>&nbsp;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...</strong></em></p>
<h2>you can find #bisteemit &nbsp;on discord</h2>
<h1>Follow, upvote and resteem&nbsp;</h1>

created by @roadscape