create account

Tx cd8aea884ab995e344f139ace9c0c8f808053d10@15435047

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


Raw transaction

ref_block_num34,082
ref_block_prefix3,073,518,530
expiration2017-09-13 16:22:15
operations
0.
0.comment
1.
parent_author""
parent_permlinkbisteemit
authorpaulag
permlinksteemit-retention-part-2-business-intelligence-steemit
title"Steemit Retention Part 2 – Business Intelligence Steemit"
body"<html>
<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>https://steemit.com/bisteemit/@paulag/steemit-retention-part-1-business-intelligence-steemit</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>
<p>https://steemitimages.com/DQmS1D9YdEQgdxZzVGtb3KBD1HRxqgmcWSjL3szxsj8Tycc/1.png</p>
<h3>High level overview</h3>
<p>&nbsp;https://steemitimages.com/DQmbTy3nXN2DYMeEPqNMv2FT4e23xLjutfT9XoDhm1kd6Aq/1.png&nbsp;</p>
<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>
<h3>2016</h3>
<p>&nbsp;https://steemitimages.com/DQmVnUNQBm7EAMyTVX75oWiu4urPqP5VCBvqywLpmx9MUEZ/2.png&nbsp;</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>
<h3>2017</h3>
<p>&nbsp;https://steemitimages.com/DQmda1m2pDwgWoJWggH6w9xQBee2AJ9LigPuy7Jos4i5s25/3.png&nbsp;</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>https://steemitimages.com/DQmaq7xpDuxyKxz4M9Lm4HsrE5fGVdgopqd9wHqsyC1fcbV/4.png&nbsp;</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 https://discordapp.com/invite/JN7Yv7j</h2>
<h1>Follow, upvote and resteem&nbsp;</h1>
<p><br></p>
</html>"
json_metadata{"tags":["bisteemit","marketing","steemit","success","news"],"users":["arcange"],"image":["https://steemitimages.com/DQmS1D9YdEQgdxZzVGtb3KBD1HRxqgmcWSjL3szxsj8Tycc/1.png","https://steemitimages.com/DQmbTy3nXN2DYMeEPqNMv2FT4e23xLjutfT9XoDhm1kd6Aq/1.png","https://steemitimages.com/DQmVnUNQBm7EAMyTVX75oWiu4urPqP5VCBvqywLpmx9MUEZ/2.png","https://steemitimages.com/DQmda1m2pDwgWoJWggH6w9xQBee2AJ9LigPuy7Jos4i5s25/3.png","https://steemitimages.com/DQmaq7xpDuxyKxz4M9Lm4HsrE5fGVdgopqd9wHqsyC1fcbV/4.png"],"links":["https://steemit.com/bisteemit/@paulag/steemit-retention-part-1-business-intelligence-steemit","https://discordapp.com/invite/JN7Yv7j"],"app":"steemit/0.1","format":"html"}
1.
0.vote
1.
voterpaulag
authorpaulag
permlinksteemit-retention-part-2-business-intelligence-steemit
weight10,000
extensions[]
signatures
0.200970bae6ce9d1e486e96cc7821a493317cb0a642c0583455da6c6a84e543fb035c23c7a73e04ad4f80d53e57e8f01a64896a350ccf90498083186b0055e81023
transaction_idcd8aea884ab995e344f139ace9c0c8f808053d10
block_num15,435,047
transaction_num10

created by @roadscape