STEEM Churn Rates Q3 Report by paulag

View this thread on steempeak.com
· @paulag ·
$87.14
STEEM Churn Rates Q3 Report
<html>
<h2>&nbsp;&nbsp;Repository</h2>
<p><a href="https://github.com/steemit/steem">https://github.com/steemit/condenser</a>&nbsp;</p>
<h2>Overview</h2>
<p>Churn is a fact of life in business. &nbsp;You will win new users and you will lose users. Churn measures how many users you are losing. Whereas retention measures how many users you are keeping. &nbsp;Churn can be calculated by the following formula</p>
<p>Churn = Number of Active users at the beginning of the period + New registrations – Number of Active users at the end of the period.</p>
<p>Churn rate can be calculated using&nbsp;</p>
<p>Churn rate = Churn / Number of Active users at the beginning of the period.</p>
<p>A high churn rate on a social media/networking site would indicate low engagement lack of loyalty and high dissatisfaction. &nbsp;&nbsp;To give us some sort of base to use as a benchmark for STEEM, I have taken this chart from <a href="https://www.vertoanalytics.com/chart-week-social-media-networks-churn/">vertoanalytics.com</a></p>
<p>https://steemitimages.com/0x0/https://www.vertoanalytics.com/wp-content/uploads/2017/05/verto-analytics-chart-week-churn-social-media.png&nbsp;</p>
<h2>Aim of Analysis</h2>
<p>The aim of this analysis is to calculated the churn rate on STEEM as a social networking type blockchain* for Q3 of 2018 and compare this to the rest of the year. &nbsp;You can view the Q2 Churn report here</p>
<p>https://steemit.com/steem/@paulag/steemit-monthy-churn-rate-drops-to-35</p>
<p>*STEEM is not only used a as a social networking type blockchain. &nbsp;Some people are investors and wallet holders only. &nbsp;Previous analysis have shown this makes up less than 0.5% of accounts on STEEM and so no adjustment has been made as I have deemed it immaterial.</p>
<p>All data for this analysis was taken from Steemsql held and managed by <a href="https://steemit.com/@arcange">@arcange</a>. &nbsp;As to not distract from the data, I will first present the findings and then the queries used.&nbsp;&nbsp;</p>
<h2>Weekly Churn Q3</h2>
<p>https://cdn.steemitimages.com/DQmaNsqCEUbZfNVXMHX31S1LGFRQiMn6CsgPBAUmVKiydJV/2.png&nbsp;</p>
<p>&nbsp;The table above shows the number of new accounts registered per week, the distinct count of votes, the discount of authors, the distinct user count (either voted or posted/commented), the weekly churn and the weekly churn rate.</p>
<p>The churn rate varies considerably from week to week as it is dependent on two variables. The distinct users and The number of new accounts. &nbsp;As both of these variables vary from week to week it is expected to see this variation reflected in the churn rates.&nbsp;</p>
<p>Below shows how this compares to previous reporting periods. &nbsp;We can see that the average weekly churn halved from Q2 to Q3.</p>
<p>https://cdn.steemitimages.com/DQmZNcGeKWRiQW255aQvmM8dzpeNzxkeVy5ynxdCJiASuML/3.png&nbsp;</p>
<h2>Monthly Churn 2018</h2>
<p>https://cdn.steemitimages.com/DQmamyy872bALRRgn8A3oh1sMkHw11PRbbL9UfcSqX9ohmx/4.png&nbsp;</p>
<p>As with the weekly churn rates you would expect to see a variance on the monthly churn rates as the variable also change. &nbsp;</p>
<p>The monthly churn rate peaks in March at 71% and reduced to a low of 20% &nbsp;in August before rising again in September to 35%. &nbsp;It is worth noting here that HF20 took place in September and very well had an impact as the resource credits problem hit the last week of the month.&nbsp;</p>
<h2>Quarterly Churn Rates</h2>
<p>I think the chart speaks for its self.</p>
<p>https://cdn.steemitimages.com/DQman718uHXcDsa4241WhsbX8KVbF6EAj86vgxy1TiLLjRJ/5.png</p>
<p>Using this as a comparative figure against the social media sites in the image above. &nbsp;Facebook was reporting a churn rate Q3 to Q4 of only 2.8%, Snapchat 23.5%, Instagram 19.1%, Twitter 25.3% and Kick 33%.&nbsp;</p>
<h2>Conclusion</h2>
<p>Churn is a fact of any business. &nbsp;What is an acceptable level of churn is also a business choice but the reality is, the lower this number the better. &nbsp;We had a &nbsp;Q1 churn rate of 121% was very disappointing to see. &nbsp;52% qtr churn is such a massive improvement. &nbsp;</p>
<p>The drop in new users from Q2 to Q3 of 49% had the biggest impact on this reduction in churn as the drop in distinct new users was only 18% for the same period. &nbsp;However Q3 figures could be slightly skewed due to HF 20 as previously mentioned.</p>
<p>What are your thoughts on the churn rates above? &nbsp;What reflection do they give about Steem? &nbsp;Please do comment below</p>
<h2>Personal Opinion</h2>
<p>In my last report I shared my personal thoughts on this data. &nbsp;Something I don't normally do. &nbsp;However retention and churn are close to my heart and something I have been working towards improving with different initiatives and communities. &nbsp;From a witness standpoint @steemcommunity works hard towards improving retention, with manual curation from the @c-squared team, engagement leagues from @abh12345 and the power up leagues ran by myself and the witness (@Steemcommunity) account. Looks like our active work is paying off.</p>
<p>I have shared data before proving increased retention amount users of Ashers league and often feature data posts on communities showing the same. &nbsp;There is a massive amount of people to thank for this reduction in churn. &nbsp;People like @wolfhart @davemccoy and the @pifc team, &nbsp;@meno and the @helpie team ,@aggroed and MSP team, @janton for talking to anyone that will talk back, the @dustsweeper team, the @welcomewagon team, all the projects working on helping redfish, wow I could go on and on. &nbsp;@steemcommunity witness account supports as many community accounts as possible by way of votes to show our support for what you are doing.</p>
<p>The work all of these projects and people have been doing has gone relatively unnoticed and thanked. &nbsp;I have even see some people say who gives a fuck about the retention and I am here to strongly defend the need to have improved retention and churn.</p>
<p>We all know Steemit.com was a beta UI for the STEEM blockchain. &nbsp;A launchpad for greater things. &nbsp;We all know that Steemit Incs main focus is the blockchain and not the UI. &nbsp;I also fully understand and agree that the first few million users on something that could have a few hundred million are not really a big deal. &nbsp;However for Steemit.com to be a successful launchpad for greater things it needs to prove the concept works. &nbsp;Extremely high churn by no means helps this and makes steemit.com useless as a marking tool for the STEEM blockchain and SMT's.</p>
<p>It is also well known that the initial distribution of STEEM makes the blockchain rather centralized. &nbsp;Due to this centralization, when Steemit had a wave of new users for the second half of 2017, there were too few active accounts spreading to spread out the distribution of new coins to a wider base. &nbsp;</p>
<p>Now new account creation is rather low compared to 9 months ago. &nbsp;In Sept we had 109K unique active accounts of which a vast majority is bots. &nbsp;Now is the time to focus on and grow the humans here. &nbsp;Because these will be the base for the next wave, a larger base to spread the rewards. &nbsp;A large base to promote a positive sentiment of STEEM, a larger base to help provide initial traffic and launchpad for DApps to succeed.</p>
<p>Personally I feel the current churn rates are perfect. &nbsp;If we can maintain these levels and grow the accounts we have the STEEM blockchain and SMT's will have an improved chance of success. &nbsp;The next question is, how can we accelerate the growth of accounts while we have this lull to take advantage of?????</p>
<h2>The Queries</h2>
<p>As mentioned I used Steemsql and PowerBI to gather and model the data. &nbsp;The query used to get the unique voters was</p>
<pre><code>SELECT voter, timestamp FROM Txvotes (NOLOCK) where timestamp &gt;= CONVERT(DATE,'2018-07-01') &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;and &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;timestamp&lt; CONVERT(DATE,'2018-10-01')</code></pre>
<p>The query used to get the unique authors was</p>
<pre><code>SELECT author, timestamp FROM Txcomments (NOLOCK) where timestamp &gt;= CONVERT(DATE,'2018-07-01') &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;and &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;timestamp&lt; CONVERT(DATE,'2018-10-01')</code></pre>
<p>To get the total unique users, I combined both of the above queries and then ran distinct counts on the name.The query used to get the number of new accounts was</p>
<pre><code>Select name, created FROM Accounts (NOLOCK)</code></pre>
<p>&nbsp;</p>
<p><br></p>
<p><br></p>
</html>
πŸ‘  , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , and 172 others
properties (23)
post_id64,279,907
authorpaulag
permlinksteem-churn-rates-q3-report-1539594273954
categoryutopian-io
json_metadata{"app":"steeditor\/0.1.2","users":["paulag","arcange","steemcommunity","c-squared","abh12345","Steemcommunity","wolfhart","davemccoy","pifc","meno","helpie","aggroed","janton","dustsweeper","welcomewagon"],"tags":["utopian-io","analysis","steem","retention","growth"],"links":["https:\/\/github.com\/steemit\/steem","https:\/\/github.com\/steemit\/condenser","https:\/\/www.vertoanalytics.com\/chart-week-social-media-networks-churn\/","https:\/\/steemitimages.com\/0x0\/https:\/\/www.vertoanalytics.com\/wp-content\/uploads\/2017\/05\/verto-analytics-chart-week-churn-social-media.png&nbsp","https:\/\/steemit.com\/steem\/@paulag\/steemit-monthy-churn-rate-drops-to-35","https:\/\/steemit.com\/@arcange","https:\/\/cdn.steemitimages.com\/DQmaNsqCEUbZfNVXMHX31S1LGFRQiMn6CsgPBAUmVKiydJV\/2.png&nbsp","https:\/\/cdn.steemitimages.com\/DQmZNcGeKWRiQW255aQvmM8dzpeNzxkeVy5ynxdCJiASuML\/3.png&nbsp","https:\/\/cdn.steemitimages.com\/DQmamyy872bALRRgn8A3oh1sMkHw11PRbbL9UfcSqX9ohmx\/4.png&nbsp","https:\/\/cdn.steemitimages.com\/DQman718uHXcDsa4241WhsbX8KVbF6EAj86vgxy1TiLLjRJ\/5.png"],"format":"html","image":[]}
created2018-10-15 09:04:36
last_update2018-10-15 09:04:36
depth0
children42
net_rshares70,349,864,919,697
last_payout2018-10-22 09:04:36
cashout_time1969-12-31 23:59:59
total_payout_value65.270 SBD
curator_payout_value21.870 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length8,795
author_reputation224,445,607,823,384
root_title"STEEM Churn Rates Q3 Report"
beneficiaries
0.
weight500
accountutopian.pay
max_accepted_payout100,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (236)
@chireerocks ·
$0.04
@paulag, In my opinion this is really effective **Analysis** and it's vital too because in this way we can understand, how many new users are entering into the **Steem Economy** and staying for long term and this understanding can gain by the **Retention** data. And i strongly believe that in future we will going to see more exciting opportunities in **Steem Economy** specially when we talk about the **SMT's** and then the **User Activity** will going to touch the moon height.

Wishing you an great day and stay blessed. πŸ™‚
πŸ‘  
properties (23)
post_id64,280,888
authorchireerocks
permlinkre-paulag-steem-churn-rates-q3-report-1539594273954-20181015t092859036z
categoryutopian-io
json_metadata{"app":"steemit\/0.1","users":["paulag"],"tags":["utopian-io"]}
created2018-10-15 09:29:00
last_update2018-10-15 09:29:00
depth1
children2
net_rshares40,387,056,627
last_payout2018-10-22 09:29:00
cashout_time1969-12-31 23:59:59
total_payout_value0.039 SBD
curator_payout_value0.003 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length527
author_reputation176,468,285,661,949
root_title"STEEM Churn Rates Q3 Report"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (1)
@paulag ·
hay @chireerocks and thanks for the comment.  The future is bright.  Steem on.
properties (22)
post_id64,281,010
authorpaulag
permlinkre-chireerocks-re-paulag-steem-churn-rates-q3-report-1539594273954-20181015t093231929z
categoryutopian-io
json_metadata{"app":"steemit\/0.1","users":["chireerocks"],"tags":["utopian-io"]}
created2018-10-15 09:32:33
last_update2018-10-15 09:32:33
depth2
children1
net_rshares0
last_payout2018-10-22 09:32: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_length78
author_reputation224,445,607,823,384
root_title"STEEM Churn Rates Q3 Report"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
@chireerocks ·
Welcome and that's true. πŸ™‚
properties (22)
post_id64,281,071
authorchireerocks
permlinkre-paulag-re-chireerocks-re-paulag-steem-churn-rates-q3-report-1539594273954-20181015t093400690z
categoryutopian-io
json_metadata{"app":"steemit\/0.1","tags":["utopian-io"]}
created2018-10-15 09:34:03
last_update2018-10-15 09:34:03
depth3
children0
net_rshares0
last_payout2018-10-22 09:34: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_length26
author_reputation176,468,285,661,949
root_title"STEEM Churn Rates Q3 Report"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
@destinysaid ·
Great work @paulag . I always use your stats to check how ell the steem community is doing.

Keep dropping awesome content
properties (22)
post_id64,280,954
authordestinysaid
permlinkre-paulag-steem-churn-rates-q3-report-1539594273954-20181015t093044664z
categoryutopian-io
json_metadata{"app":"steemit\/0.1","users":["paulag"],"tags":["utopian-io"]}
created2018-10-15 09:30:45
last_update2018-10-15 09:30:45
depth1
children1
net_rshares0
last_payout2018-10-22 09:30:45
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_length122
author_reputation47,618,726,630,085
root_title"STEEM Churn Rates Q3 Report"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars0
@paulag ·
$0.03
Hi @destinysaid and thanks for the feedback.  I so love when the stats are as positive as this.  We are in an amazing position right now but we need to get everyone working together now to reach the next stage.
πŸ‘  
properties (23)
post_id64,281,077
authorpaulag
permlinkre-destinysaid-re-paulag-steem-churn-rates-q3-report-1539594273954-20181015t093414457z
categoryutopian-io
json_metadata{"app":"steemit\/0.1","users":["destinysaid"],"tags":["utopian-io"]}
created2018-10-15 09:34:15
last_update2018-10-15 09:34:15
depth2
children0
net_rshares23,134,719,065
last_payout2018-10-22 09:34:15
cashout_time1969-12-31 23:59:59
total_payout_value0.022 SBD
curator_payout_value0.007 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length210
author_reputation224,445,607,823,384
root_title"STEEM Churn Rates Q3 Report"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (1)
@csy ·
$0.05
Hey @paulag - Thanks for the wonderful analysis. From my experience with businesses, as you said, churn has always been a fact of life. There is no way to fulfill the needs of all of the users in one simple platform. 

I'm not sure how to access the data within STEEM, but maybe what we can start to do is to do cohort analyses. See if recent cohorts have drop-offs in activity at a much more accelerated pace. If not, I would say STEEM is here to stay! Also, it would be pretty cool to confirm whether or not price really does have an impact on churn (my logic says it is, but I don't have the concrete evidence to support this). I always say that this is the time to take *advantage* of the opportunity!
πŸ‘  
properties (23)
post_id64,281,759
authorcsy
permlinkre-paulag-steem-churn-rates-q3-report-1539594273954-20181015t095107847z
categoryutopian-io
json_metadata{"app":"steemit\/0.1","users":["paulag"],"tags":["utopian-io"]}
created2018-10-15 09:51:09
last_update2018-10-15 09:51:09
depth1
children2
net_rshares39,670,433,031
last_payout2018-10-22 09:51:09
cashout_time1969-12-31 23:59:59
total_payout_value0.038 SBD
curator_payout_value0.012 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length705
author_reputation38,705,954,145,809
root_title"STEEM Churn Rates Q3 Report"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (1)
@paulag ·
$0.03
I use steemsql to access the data and if you want, I can get you some raw data to play around with.  There is a correlation with the users and the price of steem, but there is also a correlation between the price of steem and the general crypto sentiment.
πŸ‘  
properties (23)
post_id64,297,750
authorpaulag
permlinkre-csy-re-paulag-steem-churn-rates-q3-report-1539594273954-20181015t151105315z
categoryutopian-io
json_metadata{"app":"steemit\/0.1","tags":["utopian-io"]}
created2018-10-15 15:11:06
last_update2018-10-15 15:11:06
depth2
children1
net_rshares21,862,978,484
last_payout2018-10-22 15:11:06
cashout_time1969-12-31 23:59:59
total_payout_value0.020 SBD
curator_payout_value0.006 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length255
author_reputation224,445,607,823,384
root_title"STEEM Churn Rates Q3 Report"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (1)
@csy ·
Tried accessing the SQL database, but it's apparently a subscription model now. I'll have a look later and hopefully do some cohort analyses with your information! Thanks again for your help!
properties (22)
post_id64,324,649
authorcsy
permlinkre-paulag-re-csy-re-paulag-steem-churn-rates-q3-report-1539594273954-20181016t012635862z
categoryutopian-io
json_metadata{"app":"steemit\/0.1","tags":["utopian-io"]}
created2018-10-16 01:26:36
last_update2018-10-16 01:26:36
depth3
children0
net_rshares0
last_payout2018-10-23 01:26:36
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_length191
author_reputation38,705,954,145,809
root_title"STEEM Churn Rates Q3 Report"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
@lucylin ·
$0.06
According to @themarkymark  (link below), there is between 8,000 and 12,000 active, real users.

From a project of over two years  online - I find it hard to see the positive evidence  in the 'progress' of steemit....(as the social platform).

10, 000 real users in 2 years !!!!

https://steemit.com/utopian-io/@themarkymark/did-hf20-reduce-or-increase-usage
πŸ‘  ,
properties (23)
post_id64,282,060
authorlucylin
permlinkre-paulag-steem-churn-rates-q3-report-1539594273954-20181015t095731935z
categoryutopian-io
json_metadata{"app":"steemit\/0.1","users":["themarkymark"],"tags":["utopian-io"],"links":["https:\/\/steemit.com\/utopian-io\/@themarkymark\/did-hf20-reduce-or-increase-usage"]}
created2018-10-15 09:57:36
last_update2018-10-15 09:57:36
depth1
children11
net_rshares47,410,861,217
last_payout2018-10-22 09:57:36
cashout_time1969-12-31 23:59:59
total_payout_value0.045 SBD
curator_payout_value0.014 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length358
author_reputation53,703,179,637,025
root_title"STEEM Churn Rates Q3 Report"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (2)
@shadowspub ·
well you can see the glass half empty or half full... the platform is in very early stages. The active users may not be what you'd like to see .. but the fact there are active users means there is still life. Since HF 20 as curator, I'm seeing less spam and more real posting. That is a bonus and gives us something to build on.
properties (22)
post_id64,293,203
authorshadowspub
permlinkre-lucylin-re-paulag-steem-churn-rates-q3-report-1539594273954-20181015t135302671z
categoryutopian-io
json_metadata{"tags":["utopian-io"],"app":"steemit\/0.1"}
created2018-10-15 13:53:03
last_update2018-10-15 13:53:03
depth2
children10
net_rshares0
last_payout2018-10-22 13:53: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_length328
author_reputation122,086,225,405,906
root_title"STEEM Churn Rates Q3 Report"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
@lucylin ·
It's not about seeing it as ' half full ' (or 'empty '.)
I'm being objective.
_if_ the active users are , say 10,000 - after 2 years - on a social media platform - I fail to see how  a perspective of 'half full' regarding users is not bordering on willful delusion.
It's a crap stat for a 2 year old media platform, Imo.

I want to see it grow (screw facebook) - but facing reality is not a bad thing and calling it as it is.
I hate facebook - but still doesn't change the numbers..
![edit woods - Copy - Copy (3) - Copy.jpg](https://cdn.steemitimages.com/DQmRAagsUC6vjoTUNvSPx5MDDh4ZDespP2gKR32TNeCuDGc/edit%20woods%20-%20Copy%20-%20Copy%20(3)%20-%20Copy.jpg)

hf20 does seem to have reduced spamming, which is cool.
πŸ‘  
properties (23)
post_id64,295,774
authorlucylin
permlinkre-shadowspub-re-lucylin-re-paulag-steem-churn-rates-q3-report-1539594273954-20181015t143838787z
categoryutopian-io
json_metadata{"app":"steemit\/0.1","image":["https:\/\/cdn.steemitimages.com\/DQmRAagsUC6vjoTUNvSPx5MDDh4ZDespP2gKR32TNeCuDGc\/edit%20woods%20-%20Copy%20-%20Copy%20(3)%20-%20Copy.jpg"],"tags":["utopian-io"]}
created2018-10-15 14:38:42
last_update2018-10-15 14:38:42
depth3
children9
net_rshares7,531,577,308
last_payout2018-10-22 14:38:42
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_length717
author_reputation53,703,179,637,025
root_title"STEEM Churn Rates Q3 Report"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (1)
@gungadin ·
$0.05
Great Article - I agree that there are too many Bots on this platform. Humans are coming but it is a slow process. The next wave will make this platform very strong - the trigger?? - People can actually make money from blogging here...What a fantastic Medium!!
πŸ‘  
properties (23)
post_id64,283,214
authorgungadin
permlinkre-paulag-steem-churn-rates-q3-report-1539594273954-20181015t102653641z
categoryutopian-io
json_metadata{"tags":["utopian-io"],"app":"steemit\/0.1"}
created2018-10-15 10:26:57
last_update2018-10-15 10:26:57
depth1
children2
net_rshares39,989,233,298
last_payout2018-10-22 10:26:57
cashout_time1969-12-31 23:59:59
total_payout_value0.038 SBD
curator_payout_value0.012 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length260
author_reputation72,073,859,327
root_title"STEEM Churn Rates Q3 Report"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (1)
@paulag ·
$0.03
"People can actually make money from blogging here"
This idea also causes an expectations gap between what people think they will make and what really happens.  the rewards need to be secondary.
πŸ‘  ,
properties (23)
post_id64,297,546
authorpaulag
permlinkre-gungadin-re-paulag-steem-churn-rates-q3-report-1539594273954-20181015t150715777z
categoryutopian-io
json_metadata{"app":"steemit\/0.1","tags":["utopian-io"]}
created2018-10-15 15:07:18
last_update2018-10-15 15:07:18
depth2
children1
net_rshares22,678,051,637
last_payout2018-10-22 15:07:18
cashout_time1969-12-31 23:59:59
total_payout_value0.021 SBD
curator_payout_value0.006 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length194
author_reputation224,445,607,823,384
root_title"STEEM Churn Rates Q3 Report"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (2)
@gungadin ·
Yes I totally agree, but it is a bonus and incentive some people need to get started.
properties (22)
post_id64,329,915
authorgungadin
permlinkre-paulag-re-gungadin-re-paulag-steem-churn-rates-q3-report-1539594273954-20181016t034646256z
categoryutopian-io
json_metadata{"tags":["utopian-io"],"app":"steemit\/0.1"}
created2018-10-16 03:46:51
last_update2018-10-16 03:46:51
depth3
children0
net_rshares0
last_payout2018-10-23 03:46:51
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_length85
author_reputation72,073,859,327
root_title"STEEM Churn Rates Q3 Report"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
@newageinv ·
$0.05
Great summary and analysis!  I think that as the price and market overall start to stabilize we will see improvements in churn.  I think it will also signal an improvement in overall engagement as those who stay provide more value to the ecosystem.  While still early, I think the HF20 impact will have a β€œknee-jerk” reaction where churn will increase but subsequently decrease as communities start to onboard their own users and create innovative ways to retain them and keep them engaged through RC delegation pools and/or SMT being developed.
πŸ‘  
properties (23)
post_id64,290,848
authornewageinv
permlinkre-paulag-steem-churn-rates-q3-report-1539594273954-20181015t131107446z
categoryutopian-io
json_metadata{"tags":["utopian-io"],"app":"steemit\/0.1"}
created2018-10-15 13:11:09
last_update2018-10-15 13:11:09
depth1
children1
net_rshares40,149,740,492
last_payout2018-10-22 13:11:09
cashout_time1969-12-31 23:59:59
total_payout_value0.038 SBD
curator_payout_value0.012 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length545
author_reputation109,928,704,812,170
root_title"STEEM Churn Rates Q3 Report"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (1)
@paulag ·
I am looking forward to seeing communities on boarding and SMT's.  everything will become so much more focused then.
properties (22)
post_id64,297,599
authorpaulag
permlinkre-newageinv-re-paulag-steem-churn-rates-q3-report-1539594273954-20181015t150802141z
categoryutopian-io
json_metadata{"app":"steemit\/0.1","tags":["utopian-io"]}
created2018-10-15 15:08:03
last_update2018-10-15 15:08:03
depth2
children0
net_rshares0
last_payout2018-10-22 15:08: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_length116
author_reputation224,445,607,823,384
root_title"STEEM Churn Rates Q3 Report"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
@davemccoy ·
$0.05
Thank you very much for this information @paulag... And also thank you also for everything you do to try and help this community build and grow!  I know everyone's not always as hopeful and optimistic, so its nice to see you get the facts out there and then give us your opinions too.   Have a wonderful day :)
πŸ‘  ,
properties (23)
post_id64,292,960
authordavemccoy
permlinkre-paulag-steem-churn-rates-q3-report-1539594273954-20181015t134830502z
categoryutopian-io
json_metadata{"tags":["utopian-io"],"users":["paulag"],"app":"steemit\/0.1"}
created2018-10-15 13:48:30
last_update2018-10-15 13:48:30
depth1
children1
net_rshares44,199,129,298
last_payout2018-10-22 13:48:30
cashout_time1969-12-31 23:59:59
total_payout_value0.042 SBD
curator_payout_value0.012 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length310
author_reputation20,209,499,381,910
root_title"STEEM Churn Rates Q3 Report"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (2)
@paulag ·
$0.07
I cant help be optimistic when I have been looking at this churn rate drop month after month.
πŸ‘  
properties (23)
post_id64,297,665
authorpaulag
permlinkre-davemccoy-re-paulag-steem-churn-rates-q3-report-1539594273954-20181015t150920008z
categoryutopian-io
json_metadata{"app":"steemit\/0.1","tags":["utopian-io"]}
created2018-10-15 15:09:21
last_update2018-10-15 15:09:21
depth2
children0
net_rshares55,829,290,608
last_payout2018-10-22 15:09:21
cashout_time1969-12-31 23:59:59
total_payout_value0.052 SBD
curator_payout_value0.017 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length93
author_reputation224,445,607,823,384
root_title"STEEM Churn Rates Q3 Report"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (1)
@freebornangel ·
I talk to anybody willing to come off the beaten path, too,...

Can you look at how the value of votes increased, and how long it took to come back to normal, due to the three days of suppressed voting?
My napkin tells me i got a 50% bump in my vote's value.
I know that isnt because 20k redfish stopped voting.

Before @statsmonkey earned the ire of the un named one his report said 10 voters were distributing ~30% of the daily wealth.
If bid bots are distributing ~30%, too,  how much is left after the top 100 vote?

Im sure the inflation dilutes this sad fact, but shining a light on the curent facts can only help, imo.
properties (22)
post_id64,304,957
authorfreebornangel
permlinkre-paulag-steem-churn-rates-q3-report-1539594273954-20181015t172232163z
categoryutopian-io
json_metadata{"users":["statsmonkey"],"app":"steemit\/0.1","tags":["utopian-io"]}
created2018-10-15 17:22:54
last_update2018-10-15 17:22:54
depth1
children0
net_rshares0
last_payout2018-10-22 17:22: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_length625
author_reputation217,103,420,888,695
root_title"STEEM Churn Rates Q3 Report"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
@lextenebris ·
> Churn = Number of Active users at the beginning of the period + New registrations – Number of Active users at the end of the period.
>
> Churn rate can be calculated using 
>
> Churn rate = Churn / Number of Active users at the beginning of the period.

Assuming that we are defining "active users" as accounts which have posted a comment or post during the period, and "new registrations" actually means "new registrations total during the period", I'm not sure that this function actually properly shows the churn rate.

Instead it should probably be:

ChurnRate = TotalNewRegistrationsOverPeriod / TotalActiveUsersOverPeriod

Logically, that would mean that as the number of active users increases for a set number of registrations, churn rate decreases, and as the number of new registrations in the period increases for a set amount of activity, churn rate increases.

(And ultimately, I'm not sure that this is a good definition of churn in the first place. What we really want to know is specifically, from period to period, how many accounts which are created never become active, and I'm pretty sure that we have done that particular lens before.)

> *STEEM is not only used a as a social networking type blockchain.  Some people are investors and wallet holders only.  Previous analysis have shown this makes up less than 0.5% of accounts on STEEM and so no adjustment has been made as I have deemed it immaterial.

Is this really still the case? I feel like this sort of statement either should link to an article where that analysis is made, or we have to start by defining our terms and actually deriving the real numbers.

Would an easy way to differentiate these kinds of accounts be to simply look for accounts which have never made a post or a comment, but which are carrying at minimum 30 SP? That feels like the right breakpoint to eliminate accounts which were simply created and never made active, the very definition of churn.

That's not to say that I don't think it might not be less than 0.5% of accounts which qualify there, but it's not something that we can take upfront granted. (And given the account creation system post hardfork 20, I suspect we'll see some change in that breakdown.) 

> The churn rate varies considerably from week to week as it is dependent on two variables. The distinct users and The number of new accounts.  As both of these variables vary from week to week it is expected to see this variation reflected in the churn rates. 

The churn rate by your calculations swings wildly from -30% to over 30%. Likely as a side effect of the fact that you are calculating Churn as a difference. Churn rate should never be negative, and that should have been your first indicator that your method wasn't showing what you expected.

You can have a lot of churn or you can have a little churn, but you can't have negative churn.

Again, this should have been an indicator that something wrong is broken.

> Personally I feel the current churn rates are perfect.  If we can maintain these levels and grow the accounts we have the STEEM blockchain and SMT's will have an improved chance of success.  The next question is, how can we accelerate the growth of accounts while we have this lull to take advantage of?

I would take some exception to that, looking at the actual rate of content being produced and where it is being focused, it's pretty clear that we are seeing less general interest content being forged – and specifically that is why people come and bring value to the steem blockchain. Outside of the social network side of the operation, it really doesn't have much to offer someone who is just "into cryptocurrency." And as long as the content being created for the social networking side of the steem blockchain is monocultural, cryptocurrency for crypto cultists, we will never, ever see actual value being brought into the blockchain because there are far, far better places for investors to park their funds.

If the vision is that the steem blockchain is and should essentially be a blockchain ecology of digital applications intended purely solely to talk about the steem blockchain itself, then we are on a fine track. If it's to be a general-purpose social network ecology that just happens to be backed on a blockchain and gets certain advantages there from – then a lot of things have to change.

But first we have to start with accurate churn numbers. Once we have usable numbers, we can make better assessments.
properties (22)
post_id64,306,165
authorlextenebris
permlinkre-paulag-steem-churn-rates-q3-report-1539594273954-20181015t174605024z
categoryutopian-io
json_metadata{"community":"steempeak","app":"steempeak","tags":["utopian-io"]}
created2018-10-15 17:46:06
last_update2018-10-15 17:46:06
depth1
children4
net_rshares0
last_payout2018-10-22 17:46: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_length4,479
author_reputation15,727,752,514,706
root_title"STEEM Churn Rates Q3 Report"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
@paulag ·
So why don't you do a post on churn and show me how is should be done then?
properties (22)
post_id64,313,172
authorpaulag
permlinkre-lextenebris-re-paulag-steem-churn-rates-q3-report-1539594273954-20181015t202250932z
categoryutopian-io
json_metadata{"app":"steemit\/0.1","tags":["utopian-io"]}
created2018-10-15 20:22:51
last_update2018-10-15 20:22:51
depth2
children3
net_rshares0
last_payout2018-10-22 20:22:51
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_length75
author_reputation224,445,607,823,384
root_title"STEEM Churn Rates Q3 Report"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
@lextenebris ·
Honestly? Two reasons. Firstly, SteamData went away and I really don't enjoy working with SQL. Secondly, I'm not sure it's a useful piece of information for us to make sense of anything going on.

Like I said, as long as the number of bot accounts on the steem blockchain is increasing more than proportionally to the number of accounts which are "active" on the blockchain, churn rates decrease. It's not an indicator which is useful for communicating what we want to know.

And step one involves determining exactly what we want to know before we go in looking for signals. We have to be aware of what we're looking for.

Additionally, what we're looking for has to be in the form of a question and we have to be ready to accept any answer that falls out. A lot of your analysis lately has started with a question from which only one type of answer is going to be acceptable – boosting the steem blockchain as an investment platform. Which is somewhat disappointing, because historically you have done a fair amount of analysis which has returned negative indicators. But since this latest contraction (which seems to correlate with you having become invested as a witness as well), there seems to be a lot of internal pressure on you to hype the blockchain.

That doesn't lead to excellent analysis.

If you go looking for positive indicators and throw away indicators that aren't positive, you will inevitably find positive indicators. They may not be indicating anything real, but you will find them.

So let's start from the top. What is it that we really want to know?

I would suggest that an important question is, "is content creation on the steem blockchain by non-bot creators increasing or decreasing?" A good secondary question might be, "is the content becoming more monocultural/mono-subject or more diverse?"

"Churn" isn't going to be a useful metric. Instead, if we really want to know whether the value of the blockchain is increasing or decreasing in a real sense (as opposed to its worth), we have to look at the reason that it's a useful platform – and that is the presence or absence of content.

The guy that does @trufflepig would be good to have here, because that system does regular analysis of the content on the blockchain, deriving what terms are most entropically useful to distinguish groups of posts from one another. Part of what would be useful here would be some sort of meta-analysis of the terms which Truffle Pig have derived over the last six months and whether they have become more similar or less similar to one another.

If we are actually interested in these questions.

What are we actually interested in?
properties (22)
post_id64,314,531
authorlextenebris
permlinkre-paulag-re-lextenebris-re-paulag-steem-churn-rates-q3-report-1539594273954-20181015t205522892z
categoryutopian-io
json_metadata{"tags":["utopian-io"],"community":"steempeak","app":"steempeak"}
created2018-10-15 20:55:24
last_update2018-10-15 20:55:24
depth3
children2
net_rshares0
last_payout2018-10-22 20:55:24
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_length2,653
author_reputation15,727,752,514,706
root_title"STEEM Churn Rates Q3 Report"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
@peekbit ·
$0.33
Thank you for all the analysis βœ… It will be really interesting to see the influence of HF 20 in another one or two month... Hoping the best 😊  @peekbit
πŸ‘  ,
properties (23)
post_id64,342,056
authorpeekbit
permlinkre-paulag-steem-churn-rates-q3-report-1539594273954-20181016t090243349z
categoryutopian-io
json_metadata{"users":["peekbit"],"app":"steemit\/0.1","tags":["utopian-io"]}
created2018-10-16 09:02:42
last_update2018-10-16 09:02:42
depth1
children0
net_rshares260,324,110,127
last_payout2018-10-23 09:02:42
cashout_time1969-12-31 23:59:59
total_payout_value0.248 SBD
curator_payout_value0.081 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length151
author_reputation21,544,346,900,318
root_title"STEEM Churn Rates Q3 Report"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (2)
@crokkon ·
$7.73
Hi @paulag, very interesting follow-up to the Q2 report! While the new registration counts continue to decrease over time, the churn rate seems to follow this trend - which is not too bad if I understood it correctly?! I must admit, I was also a bit puzzled if the churn rate can be negative. Given your definition, it makes sense if previously inactive accounts are reactivated. Do you have insights how the churn rate is calculated for the other social networks? They must have the same effects somehow. But what I'm unsure about: does it make sense to add new accounts unconditionally to the churn or should only those be included that are actually "active"? I've seen definitions of the churn rate as `(active_users_at_the_beginning - active_users_at_the_end) / active_users_at_the_beginning`. I think this could treat inactive new accounts more accurately?

Your contribution has been evaluated according to [Utopian policies and guidelines](https://join.utopian.io/guidelines), as well as a predefined set of questions pertaining to the category.

To view those questions and the relevant answers related to your post, [click here](https://review.utopian.io/result/0/1222313).

---- 
Need help? Write a ticket on https://support.utopian.io/. 
Chat with us on [Discord](https://discord.gg/uTyJkNm). 
[[utopian-moderator]](https://join.utopian.io/)
πŸ‘  , , , , , , , ,
properties (23)
post_id64,350,621
authorcrokkon
permlinkre-paulag-steem-churn-rates-q3-report-1539594273954-20181016t121714656z
categoryutopian-io
json_metadata{"links":["https:\/\/join.utopian.io\/guidelines","https:\/\/review.utopian.io\/result\/0\/1222313","https:\/\/support.utopian.io\/","https:\/\/discord.gg\/uTyJkNm","https:\/\/join.utopian.io\/"],"users":["paulag"],"tags":["utopian-io"],"app":"steemit\/0.1"}
created2018-10-16 12:17:15
last_update2018-10-16 12:17:15
depth1
children2
net_rshares6,103,469,561,957
last_payout2018-10-23 12:17:15
cashout_time1969-12-31 23:59:59
total_payout_value5.852 SBD
curator_payout_value1.878 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length1,352
author_reputation75,470,595,669,689
root_title"STEEM Churn Rates Q3 Report"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (9)
@paulag ·
$0.04
hay @crokkon and thanks for the review and feedback.

I did use (active_users_at_the_beginning - active_users_at_the_end) / active_users_at_the_beginning to calculate the churn

"Churn = Number of Active users at the beginning of the period + New registrations – Number of Active users at the end of the period.

Churn rate can be calculated using 

Churn rate = Churn / Number of Active users at the beginning of the period."

The problem with the weekly and negative churn is down to steemit inc not creating accounts at the same pace each week. the variance on the week to week is to much to make sense really.
πŸ‘  
properties (23)
post_id64,598,094
authorpaulag
permlinkre-crokkon-re-paulag-steem-churn-rates-q3-report-1539594273954-20181020t133354718z
categoryutopian-io
json_metadata{"users":["crokkon"],"tags":["utopian-io"],"app":"steemit\/0.1"}
created2018-10-20 13:33:57
last_update2018-10-20 13:33:57
depth2
children0
net_rshares30,525,469,676
last_payout2018-10-27 13:33:57
cashout_time1969-12-31 23:59:59
total_payout_value0.027 SBD
curator_payout_value0.008 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length613
author_reputation224,445,607,823,384
root_title"STEEM Churn Rates Q3 Report"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (1)
@utopian-io ·
Thank you for your review, @crokkon!

So far this week you've reviewed 3 contributions. Keep up the good work!
properties (22)
post_id64,644,908
authorutopian-io
permlinkre-re-paulag-steem-churn-rates-q3-report-1539594273954-20181016t121714656z-20181021t093523z
categoryutopian-io
json_metadata{"app":"beem\/0.20.1"}
created2018-10-21 09:35:24
last_update2018-10-21 09:35:24
depth2
children0
net_rshares0
last_payout2018-10-28 09:35:24
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_length110
author_reputation152,913,012,544,965
root_title"STEEM Churn Rates Q3 Report"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
@steem-ua ·
#### Hi @paulag!

Your post was upvoted by @steem-ua, new Steem dApp, using UserAuthority for algorithmic post curation!
Your post is eligible for our upvote, thanks to our collaboration with @utopian-io!
**Feel free to join our [@steem-ua Discord server](https://discord.gg/KpBNYGz)**
properties (22)
post_id64,351,210
authorsteem-ua
permlinkre-steem-churn-rates-q3-report-1539594273954-20181016t123059z
categoryutopian-io
json_metadata{"app":"beem\/0.20.7"}
created2018-10-16 12:31:00
last_update2018-10-16 12:31:00
depth1
children0
net_rshares0
last_payout2018-10-23 12:31:00
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_length285
author_reputation23,203,609,903,979
root_title"STEEM Churn Rates Q3 Report"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
@intrepidphotos ·
Thanks.  Nice to see some positive news on the subject.  I at least feel that we have a good grasp of the problems now even if we don't as a community have all the solutions yet.  
properties (22)
post_id64,366,060
authorintrepidphotos
permlinkre-paulag-steem-churn-rates-q3-report-1539594273954-20181016t170030308z
categoryutopian-io
json_metadata{"tags":["utopian-io"],"community":"steempeak","app":"steempeak"}
created2018-10-16 17:00:33
last_update2018-10-16 17:00:33
depth1
children0
net_rshares0
last_payout2018-10-23 17: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_length180
author_reputation361,224,981,730,276
root_title"STEEM Churn Rates Q3 Report"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
@glenalbrethsen ·
Hey, @paulag.

I'm guess I'm okay with the conclusion that the churn rate is falling, but I'm wondering about the factors involved. Before I get to that, though, I should say, even if it is what I think it is, I'm okay with it to a degree. I think it's a good thing for those of us who are still here. Maybe not so much for the ecosystem.

I guess if we're looking at the churn rate in percentages based on the numbers that were previously coming/leaving versus what they've been up to hard fork 20, I've got to wonder if it's come down because a) there were fewer accounts coming in, so b) they were able to find a community quicker and c) the larger amounts of folks who left because of the decline in STEEM prices basically since April-ish (if memory serves) was the worst of the exodus or churn. Meaning, that those who have stayed have found other reasons for it other than earnings.

I have no data to back that up other than looking at what you've provided. I'm wondering if we haven't just reached that core group of humans (plus bots, apparently) that are going to hang on as long as STEEM is here, while trying to bring the newbies into the fold.
properties (22)
post_id64,381,592
authorglenalbrethsen
permlinkre-paulag-steem-churn-rates-q3-report-1539594273954-20181016t234232149z
categoryutopian-io
json_metadata{"users":["paulag"],"app":"steemit\/0.1","tags":["utopian-io"]}
created2018-10-16 23:42:33
last_update2018-10-16 23:42:33
depth1
children0
net_rshares0
last_payout2018-10-23 23:42: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_length1,156
author_reputation73,752,675,176,126
root_title"STEEM Churn Rates Q3 Report"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
@evolved08gsr ·
The missed observation from all of this is how when you consider the number of total unique individuals on Steemit, then the churn rate over time, and calculate how many people are staying on the platform vs # of the same people creating new accounts (bots, alts, etc), we've lost more people than we've been gaining and the ones that remain are simply exploiting the rewards pool for personal gain by creating more new accounts to grow their nestegg.
properties (22)
post_id64,384,746
authorevolved08gsr
permlinkre-paulag-steem-churn-rates-q3-report-1539594273954-20181017t011926233z
categoryutopian-io
json_metadata{"app":"steemit\/0.1","tags":["utopian-io"]}
created2018-10-17 01:19:27
last_update2018-10-17 01:19:27
depth1
children0
net_rshares0
last_payout2018-10-24 01:19: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_length451
author_reputation3,930,469,625,760
root_title"STEEM Churn Rates Q3 Report"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
@utopian-io ·
Hey, @paulag!

**Thanks for contributing on Utopian**.
We’re already looking forward to your next contribution!

**Get higher incentives and support Utopian.io!**
 Simply set @utopian.pay as a 5% (or higher) payout beneficiary on your contribution post (via [SteemPlus](https://chrome.google.com/webstore/detail/steemplus/mjbkjgcplmaneajhcbegoffkedeankaj?hl=en) or [Steeditor](https://steeditor.app)).

**Want to chat? Join us on Discord https://discord.gg/h52nFrV.**

<a href='https://steemconnect.com/sign/account-witness-vote?witness=utopian-io&approve=1'>Vote for Utopian Witness!</a>
properties (22)
post_id64,672,936
authorutopian-io
permlinkre-steem-churn-rates-q3-report-1539594273954-20181021t200512z
categoryutopian-io
json_metadata{"app":"beem\/0.20.1"}
created2018-10-21 20:05:15
last_update2018-10-21 20:05:15
depth1
children0
net_rshares0
last_payout2018-10-28 20:05:15
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_length588
author_reputation152,913,012,544,965
root_title"STEEM Churn Rates Q3 Report"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000