If YOU joined STEEMIT in March '17 then ... by paulag

View this thread on steempeak.com
· @paulag ·
$8.81
If YOU joined STEEMIT in March '17 then ...
<html>
<p>If you joined Steemit in March 2017 then you celebrated your Steemit birthday with 8,347 other Steemains. What an awesome achievement to see you are still posting or still curating. Congratulations and welcome to the One Year Club.&nbsp;</p>
<p>It is commonly known that the retention rate on Steemit is rather low, so if your Steemit birthday was in March and you are reading this, let it be known that you have achieved a lot. &nbsp;You are an early adaptor of an experimental platform and you deserve to be acknowledged.&nbsp;</p>
<p>To celebarte your 1 year Steemit Birthday I have some data to present to you. &nbsp;Data that proves you are special</p>
https://steemitimages.com/DQmXgDZSMUrTx4Ew3q7fqt8s6WKLm9RAogwcnuZ5k7R3XSc/image.png
<p>&nbsp;</p>
<p>In March 2017 8,348 new accounts registered on Steemit. &nbsp;Of this 5,376 &nbsp;have never made a post. &nbsp;That means only 36% or 2,972 accounts made post or comments on the platform.</p>
<p>Did you know that the % of new steemains that joined in February 17 that made a post or comment was a similar with 39%?</p>
<p>From this 2,972 accounts, a further 1,001 accounts stopped posting by day 20 and have not posted since and only 620 accounts have posted in the last 45 days. If you are one of these 620 accounts you make up only 7% of the 8,348 users that registered on Steemit in Mar 2017.</p>
<p>&nbsp;</p>
https://steemitimages.com/DQmePT5cnzN7f8uHMFWNNhQZqFvdJA72waqcdabUdRiVVVP/image.png
<p>These 8,348 accounts own 5.34M SP between them. &nbsp;They have received 125.96K SP in delegation and have given out 1.94 M in delegation. &nbsp;This leaves a controlling SP of 3.52M SP. &nbsp;From the data above we can also see that the 2,972 accounts that posted made 498,545 posts earning 414.81M in author rewards and also 90.91M in curator rewards.</p>
<p>Taking the same dataset but now adding a filter to exclude any users that have not posted. &nbsp;The 2,972 accounts that have posted own 90% of the SP owned by everyone that joined in Mar and they are in control of 86% of the controlling SP</p>
https://steemitimages.com/DQmUPx58np8QtwghThQESaUoUqxEf9kKB2aXWFXuyCtjrzC/image.png
<p>&nbsp;</p>
<p>There is however a different between the curation rewards earned on all accounts registered in March17 to the accounts with active authors. &nbsp;This difference of 5.45 M or 6% of curation reward earned by accounts registered in March 17 went to curators, or accounts that have never posted just voted.</p>
<p>We spoke about retention, but just to let you visualised when the accounts were dropping off. &nbsp;The chart below plots the number of days since last post against the no of days registered on Steemit. &nbsp;The deeper the colour the more users.</p>
<p>We can see on the right of this chart high population of deep colours. &nbsp;This represents the users that registered and either never posted or haven’t posted in 340+ days. &nbsp;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% of accounts that have posted in the last 45 days.</p>
<p>&nbsp;</p>
https://steemitimages.com/DQmVz3EBLtwMnPms2FgJ5qgXmmuZP1iNZXtJ8hbn1SVsiwU/image.png
<p><br></p>
<p>The table below plots the 2,972 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 275+ days where a number of accounts have an SP of up to 50K and 100K. &nbsp;&nbsp;We can also see a number of outliers that have higher than average SP owned.</p>
https://steemitimages.com/DQmSJs77jMLu2nHh1MYVHueya3ZKNeYkBnKGNMvg28jBF2m/image.png
<p>&nbsp;</p>
<p>If we run the same chart with ALL the account that registered in March 17 not much changes except over on the left there is a new outlier with just under 200K SP</p>
<p>&nbsp;</p>
https://steemitimages.com/DQmNaHfmRJC4xVJ2di2z8vMn8eVgGotuwi573oLideGdixs/image.png
<p><br></p>
<p>So who are the movers and shakers that registered in March β€˜17</p>
<p>First I filtering the data to show accounts that never posted. &nbsp;This table was then sorted to show those owning the most SP.</p>
https://steemitimages.com/DQmQHH2tE6LGGsJbmqEyab42qKuY3Xs4cX1rQ2eu77tS4Vh/image.png
<p>&nbsp;</p>
<p>Next I have filtered the data to show the users that have been active in the last 45 days. The table below shows this data sorted by SP owned&nbsp;</p>
https://steemitimages.com/DQmS5LY9JJVLVqa9mhAbBgFAj9UFXgKWGeAVBca4BfSGxo3/image.png
<p>&nbsp;</p>
<p>And the table below shows the same data but this time sorted the posting rewards earned (shown in vests)</p>
<p>&nbsp;</p>
https://steemitimages.com/DQmTGjVnE34SWZV8qLFZWu9wvaRnZ61EXwvbUyJsiHftWWi/image.png
<p><br></p>
<p>While sorting through this data I found a number of accounts that registered in March 2017 but only made their first or second post in the last 45 days. &nbsp;Welcome back dudes and dudesses. &nbsp;Glad you have joined us.</p>
<p>&nbsp;</p>
https://steemitimages.com/DQmUqZk53zXMvUQR646P6qufB2kgWTTrDHhf2X7h39CMN1f/image.png
<p>Looking at all March 2017 accounts now and sorting by the number of posts and comments made.</p>
<p>&nbsp;</p>
https://steemitimages.com/DQmPtW9kNQXzJ1pPirHBUrDTurLaMazMi8Ta6o8yPyg2oo4/image.png
<p>Finally I did some totting on data relating to inactive author accounts.</p>
<p>7,661 accounts set up in March 17 have an SP of 50 or less. &nbsp;The total SP owned by these accounts is 189.10K. &nbsp;&nbsp;Of this 5,304 accounts have never posted or commented. The total of SP owned by these accounts is 127.61K</p>
<p>Conclusion</p>
<p>The % author retention from March 17 is only 7%, however these accounts own 90% of the SP owned by all of the accounts registered that month. In the last 45 days, we seen a return of 16 Steemains to the platform that were previously considered dead fish. &nbsp;Although only a small value (0.4%), it is nice to see this claw back.</p>
<p>How many of the accounts do you recognise?</p>
<p>There are a few familiar names such as @ranchorelaxo , @trafalgar, &nbsp;@honeybeee, &nbsp;@battleaxe and @robert-call. &nbsp;Hope you all enjoyed your Steemit Birthday!</p>
<p>The Data and Analysis</p>
<p>This analysis was prepared using Power BI to connect to Steemsql</p>
<p>The SQL query used was</p>
<p>select *</p>
<p>from Accounts NOLOCK</p>
<p>where &nbsp;&nbsp;&nbsp;( created &gt;= CONVERT(DATE,'2017-03-01') AND created&lt; CONVERT(DATE,'2017-04-01'))</p>
<p><br></p>
<p>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 23 March 18</p>
<p>From here I then carried out analysis, calculations and modelling using DAX&nbsp;</p>
<p>The aim of this analysis was to establish the retention of authors based on users registered in March 2017 and also visualize the SP growth of active authors after 1 year on Steemit. &nbsp;Its aim was also to celebrate and identify users that have remained active for the last year.</p>
<p><br></p>
</html>
πŸ‘  , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,
properties (23)
post_id40,188,004
authorpaulag
permlinkif-you-joined-steemit-in-march-17-then
categorysteemit
json_metadata"{"app": "steemit/0.1", "format": "html", "users": ["ranchorelaxo", "trafalgar", "honeybeee", "battleaxe", "robert-call"], "image": ["https://steemitimages.com/DQmXgDZSMUrTx4Ew3q7fqt8s6WKLm9RAogwcnuZ5k7R3XSc/image.png"], "tags": ["steemit", "stats", "life", "blog", "blockchainbi"]}"
created2018-03-23 19:36:21
last_update2018-03-23 19:36:21
depth0
children16
net_rshares3,127,529,969,040
last_payout2018-03-30 19:36:21
cashout_time1969-12-31 23:59:59
total_payout_value7.429 SBD
curator_payout_value1.383 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length7,073
author_reputation224,445,607,823,384
root_title"If YOU joined STEEMIT in March '17 then ..."
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (52)
@learner365 ·
I wasn't there at that time . though I came to know steem in July I truly understand its potential in January after my fund made 1 lakh$ from it .  I will do it one day.  whatever happy anniversary
properties (22)
post_id40,188,217
authorlearner365
permlinkre-paulag-if-you-joined-steemit-in-march-17-then-20180323t193806083z
categorysteemit
json_metadata"{"app": "steemit/0.1", "tags": ["steemit"]}"
created2018-03-23 19:38:06
last_update2018-03-23 19:38:06
depth1
children0
net_rshares0
last_payout2018-03-30 19:38:06
cashout_time1969-12-31 23:59:59
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length197
author_reputation812,830,516,164
root_title"If YOU joined STEEMIT in March '17 then ..."
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
@ninaja ·
$0.02
I made my account sometime in February-March and I have been finding it really hard to post, so I am not surprised the user retention rate is so low. Why do you think people drop off the platform so quickly?
πŸ‘  
properties (23)
post_id40,188,627
authorninaja
permlinkre-paulag-if-you-joined-steemit-in-march-17-then-20180323t194129054z
categorysteemit
json_metadata"{"app": "steemit/0.1", "tags": ["steemit"]}"
created2018-03-23 19:41:33
last_update2018-03-23 19:41:33
depth1
children7
net_rshares7,890,939,758
last_payout2018-03-30 19:41:33
cashout_time1969-12-31 23:59:59
total_payout_value0.016 SBD
curator_payout_value0.005 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length207
author_reputation18,908,917,484
root_title"If YOU joined STEEMIT in March '17 then ..."
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (1)
@paulag ·
I think there are many reasons, the biggest is the expectation gap in what people think they will get from the platform and what they actually do get
πŸ‘  ,
properties (23)
post_id40,189,192
authorpaulag
permlinkre-ninaja-re-paulag-if-you-joined-steemit-in-march-17-then-20180323t194604389z
categorysteemit
json_metadata"{"app": "steemit/0.1", "tags": ["steemit"]}"
created2018-03-23 19:46:03
last_update2018-03-23 19:46:03
depth2
children6
net_rshares778,629,459
last_payout2018-03-30 19:46:03
cashout_time1969-12-31 23:59:59
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length149
author_reputation224,445,607,823,384
root_title"If YOU joined STEEMIT in March '17 then ..."
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (2)
@demotruk ·
Don't forget though that many of the accounts don't represent unique users in the first place. Several people were creating many accounts back then, sometimes just to obtain free Steem.
πŸ‘  ,
properties (23)
post_id40,190,892
authordemotruk
permlinkre-paulag-re-ninaja-re-paulag-if-you-joined-steemit-in-march-17-then-20180323t200031538z
categorysteemit
json_metadata"{"app": "steemit/0.1", "tags": ["steemit"]}"
created2018-03-23 20:00:33
last_update2018-03-23 20:00:33
depth3
children2
net_rshares5,109,165,864
last_payout2018-03-30 20:00:33
cashout_time1969-12-31 23:59:59
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length185
author_reputation96,481,588,331,838
root_title"If YOU joined STEEMIT in March '17 then ..."
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (2)
@ninaja ·
$3.19
Yeah I have noticed that Steemit tends to create the illusion, when you first join, that you will make a lot of money easily. But that just isn't the case.
πŸ‘  , ,
properties (23)
post_id40,192,109
authorninaja
permlinkre-paulag-re-ninaja-re-paulag-if-you-joined-steemit-in-march-17-then-20180323t201036437z
categorysteemit
json_metadata"{"app": "steemit/0.1", "tags": ["steemit"]}"
created2018-03-23 20:10:39
last_update2018-03-23 20:10:39
depth3
children2
net_rshares1,134,896,487,190
last_payout2018-03-30 20:10:39
cashout_time1969-12-31 23:59:59
total_payout_value2.396 SBD
curator_payout_value0.796 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length155
author_reputation18,908,917,484
root_title"If YOU joined STEEMIT in March '17 then ..."
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (3)
@masdem ·
People expect money right away! But to be always on Steemit you need constancy ... and love for this platform. Remain exactly those who fall in love with steemit and invest. Thanks for the detailed statistics
properties (22)
post_id40,191,298
authormasdem
permlinkre-paulag-if-you-joined-steemit-in-march-17-then-20180323t200451319z
categorysteemit
json_metadata"{"app": "steemit/0.1", "tags": ["steemit"]}"
created2018-03-23 20:03:54
last_update2018-03-23 20:03:54
depth1
children0
net_rshares0
last_payout2018-03-30 20:03:54
cashout_time1969-12-31 23:59:59
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length208
author_reputation569,581,081,073
root_title"If YOU joined STEEMIT in March '17 then ..."
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
@cryptoj215 ·
Great post! Good seeing people stick around for a year!
properties (22)
post_id40,193,195
authorcryptoj215
permlinkre-paulag-if-you-joined-steemit-in-march-17-then-20180323t202017198z
categorysteemit
json_metadata"{"app": "steemit/0.1", "tags": ["steemit"]}"
created2018-03-23 20:20:18
last_update2018-03-23 20:20:18
depth1
children2
net_rshares0
last_payout2018-03-30 20:20:18
cashout_time1969-12-31 23:59:59
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length55
author_reputation80,455,466,172
root_title"If YOU joined STEEMIT in March '17 then ..."
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
@paulag ·
steemit is 2 years old this week, there are many more here longer
πŸ‘  ,
properties (23)
post_id40,196,125
authorpaulag
permlinkre-cryptoj215-re-paulag-if-you-joined-steemit-in-march-17-then-20180323t204857795z
categorysteemit
json_metadata"{"app": "steemit/0.1", "tags": ["steemit"]}"
created2018-03-23 20:48:54
last_update2018-03-23 20:48:54
depth2
children0
net_rshares4,688,463,029
last_payout2018-03-30 20:48:54
cashout_time1969-12-31 23:59:59
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length65
author_reputation224,445,607,823,384
root_title"If YOU joined STEEMIT in March '17 then ..."
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (2)
@jenkinrocket ·
$0.08
Agreed. I'm among the two year crew!
πŸ‘  ,
properties (23)
post_id40,206,429
authorjenkinrocket
permlinkre-cryptoj215-re-paulag-if-you-joined-steemit-in-march-17-then-20180323t223555146z
categorysteemit
json_metadata"{"app": "steemit/0.1", "tags": ["steemit"]}"
created2018-03-23 22:35:54
last_update2018-03-23 22:35:54
depth2
children0
net_rshares30,479,260,088
last_payout2018-03-30 22:35:54
cashout_time1969-12-31 23:59:59
total_payout_value0.084 SBD
curator_payout_value0.000 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length36
author_reputation25,572,770,303,018
root_title"If YOU joined STEEMIT in March '17 then ..."
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (2)
@yasu24 ·
I resteemed this post. I joined steemit in 2017 july.
properties (22)
post_id40,298,223
authoryasu24
permlinkre-paulag-if-you-joined-steemit-in-march-17-then-20180324t135109122z
categorysteemit
json_metadata"{"app": "steemit/0.1", "tags": ["steemit"]}"
created2018-03-24 13:51:12
last_update2018-03-24 13:51:12
depth1
children0
net_rshares0
last_payout2018-03-31 13:51:12
cashout_time1969-12-31 23:59:59
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length53
author_reputation106,605,049,898,479
root_title"If YOU joined STEEMIT in March '17 then ..."
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
@angeltirado ·
interesting blogs and posting thank you  have a nice day my friend.
properties (22)
post_id40,298,797
authorangeltirado
permlinkre-paulag-if-you-joined-steemit-in-march-17-then-20180324t135545475z
categorysteemit
json_metadata"{"app": "steemit/0.1", "tags": ["steemit"]}"
created2018-03-24 13:55:48
last_update2018-03-24 13:55:48
depth1
children0
net_rshares0
last_payout2018-03-31 13:55:48
cashout_time1969-12-31 23:59:59
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length67
author_reputation29,587,693,495,256
root_title"If YOU joined STEEMIT in March '17 then ..."
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
@clixmoney ·
This is my 11th month in steemit, my birthday is very soon, I hope I will see my name in a similar post in may also. ☺
properties (22)
post_id41,663,180
authorclixmoney
permlinkre-paulag-if-you-joined-steemit-in-march-17-then-20180402t064026476z
categorysteemit
json_metadata"{"app": "steemit/0.1", "tags": ["steemit"]}"
created2018-04-02 06:40:27
last_update2018-04-02 06:40:27
depth1
children0
net_rshares0
last_payout2018-04-09 06:40:27
cashout_time1969-12-31 23:59:59
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length118
author_reputation506,342,573,332,958
root_title"If YOU joined STEEMIT in March '17 then ..."
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000