<html> <h2> Repository</h2> <p><a href="https://github.com/steemit/steem">https://github.com/steemit/condenser</a> </p> <h2>Overview</h2> <p>Churn is a fact of life in business. 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. 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 </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. 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 </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. 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. 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.</p> <p>All data for this analysis was taken from Steemsql held and managed by <a href="https://steemit.com/@arcange">@arcange</a>. As to not distract from the data, I will first present the findings and then the queries used. </p> <h2>Weekly Churn Q3</h2> <p>https://cdn.steemitimages.com/DQmaNsqCEUbZfNVXMHX31S1LGFRQiMn6CsgPBAUmVKiydJV/2.png </p> <p> 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. As both of these variables vary from week to week it is expected to see this variation reflected in the churn rates. </p> <p>Below shows how this compares to previous reporting periods. We can see that the average weekly churn halved from Q2 to Q3.</p> <p>https://cdn.steemitimages.com/DQmZNcGeKWRiQW255aQvmM8dzpeNzxkeVy5ynxdCJiASuML/3.png </p> <h2>Monthly Churn 2018</h2> <p>https://cdn.steemitimages.com/DQmamyy872bALRRgn8A3oh1sMkHw11PRbbL9UfcSqX9ohmx/4.png </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. </p> <p>The monthly churn rate peaks in March at 71% and reduced to a low of 20% in August before rising again in September to 35%. 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. </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. 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%. </p> <h2>Conclusion</h2> <p>Churn is a fact of any business. What is an acceptable level of churn is also a business choice but the reality is, the lower this number the better. We had a Q1 churn rate of 121% was very disappointing to see. 52% qtr churn is such a massive improvement. </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. 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? What reflection do they give about Steem? Please do comment below</p> <h2>Personal Opinion</h2> <p>In my last report I shared my personal thoughts on this data. Something I don't normally do. However retention and churn are close to my heart and something I have been working towards improving with different initiatives and communities. 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. There is a massive amount of people to thank for this reduction in churn. People like @wolfhart @davemccoy and the @pifc team, @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. @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. 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. A launchpad for greater things. We all know that Steemit Incs main focus is the blockchain and not the UI. 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. However for Steemit.com to be a successful launchpad for greater things it needs to prove the concept works. 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. 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. </p> <p>Now new account creation is rather low compared to 9 months ago. In Sept we had 109K unique active accounts of which a vast majority is bots. Now is the time to focus on and grow the humans here. Because these will be the base for the next wave, a larger base to spread the rewards. 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. 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?????</p> <h2>The Queries</h2> <p>As mentioned I used Steemsql and PowerBI to gather and model the data. The query used to get the unique voters was</p> <pre><code>SELECT voter, timestamp FROM Txvotes (NOLOCK) where timestamp >= CONVERT(DATE,'2018-07-01') and timestamp< 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 >= CONVERT(DATE,'2018-07-01') and timestamp< 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> </p> <p><br></p> <p><br></p> </html>
post_id | 64,279,907 | ||||||
---|---|---|---|---|---|---|---|
author | paulag | ||||||
permlink | steem-churn-rates-q3-report-1539594273954 | ||||||
category | utopian-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 ","https:\/\/steemit.com\/steem\/@paulag\/steemit-monthy-churn-rate-drops-to-35","https:\/\/steemit.com\/@arcange","https:\/\/cdn.steemitimages.com\/DQmaNsqCEUbZfNVXMHX31S1LGFRQiMn6CsgPBAUmVKiydJV\/2.png ","https:\/\/cdn.steemitimages.com\/DQmZNcGeKWRiQW255aQvmM8dzpeNzxkeVy5ynxdCJiASuML\/3.png ","https:\/\/cdn.steemitimages.com\/DQmamyy872bALRRgn8A3oh1sMkHw11PRbbL9UfcSqX9ohmx\/4.png ","https:\/\/cdn.steemitimages.com\/DQman718uHXcDsa4241WhsbX8KVbF6EAj86vgxy1TiLLjRJ\/5.png"],"format":"html","image":[]} | ||||||
created | 2018-10-15 09:04:36 | ||||||
last_update | 2018-10-15 09:04:36 | ||||||
depth | 0 | ||||||
children | 42 | ||||||
net_rshares | 70,349,864,919,697 | ||||||
last_payout | 2018-10-22 09:04:36 | ||||||
cashout_time | 1969-12-31 23:59:59 | ||||||
total_payout_value | 65.270 SBD | ||||||
curator_payout_value | 21.870 SBD | ||||||
pending_payout_value | 0.000 SBD | ||||||
promoted | 0.000 SBD | ||||||
body_length | 8,795 | ||||||
author_reputation | 224,445,607,823,384 | ||||||
root_title | "STEEM Churn Rates Q3 Report" | ||||||
beneficiaries |
| ||||||
max_accepted_payout | 100,000.000 SBD | ||||||
percent_steem_dollars | 10,000 | ||||||
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
berniesanders | 0 | 5,715,625,320 | 1.25% | ||
nextgencrypto | 0 | 1,055,689,220 | 1.25% | ||
teamsteem | 0 | 1,167,317,526,202 | 20% | ||
nanzo-scoop | 0 | 1,089,601,789,191 | 40% | ||
mummyimperfect | 0 | 15,715,461,766 | 40% | ||
ak2020 | 0 | 6,627,952,923 | 40% | ||
emily-cook | 0 | 549,023,101 | 40% | ||
daan | 0 | 2,015,420,365 | 3.75% | ||
hitmeasap | 0 | 14,280,362,772 | 33% | ||
arcange | 0 | 23,674,676,196 | 4% | ||
raphaelle | 0 | 1,950,669,758 | 4% | ||
ace108 | 0 | 42,689,343,870 | 3% | ||
fooblic | 0 | 17,422,351,645 | 85.25% | ||
elamental | 0 | 292,423,220 | 1% | ||
protegeaa | 0 | 23,050,015,334 | 50% | ||
etcmike | 0 | 20,375,130,822 | 10% | ||
thecyclist | 0 | 10,264,636,060 | 1.25% | ||
abh12345 | 0 | 391,293,057,366 | 50% | ||
boxcarblue | 0 | 125,053,237,636 | 50% | ||
t-bot | 0 | 426,748,199,047 | 40% | ||
clayboyn | 0 | 3,734,201,034 | 5% | ||
katharsisdrill | 0 | 16,809,366,320 | 4% | ||
mangos | 0 | 569,671,877,544 | 16% | ||
jamzed | 0 | 35,367,292,661 | 100% | ||
j3dy | 0 | 21,742,579,709 | 100% | ||
mafeeva | 0 | 19,924,412,873 | 40% | ||
engagement | 0 | 289,961,517 | 1.25% | ||
chappers | 0 | 84,135,289 | 40% | ||
iflagtrash | 0 | 80,642,000 | 1.25% | ||
tarazkp | 0 | 288,309,860,797 | 17% | ||
hypexals-spiral | 0 | 25,682,861,203 | 100% | ||
omitaylor | 0 | 72,865,389 | 2% | ||
randomthoughts | 0 | 1,784,882,665 | 1.25% | ||
alexis555 | 0 | 1,219,425,965,613 | 17% | ||
destinysaid | 0 | 262,655,833,084 | 93% | ||
c0ff33a | 0 | 30,035,061,279 | 10% | ||
freebornsociety | 0 | 4,762,685,952 | 10% | ||
ivantorres | 0 | 1,472,111,642 | 50% | ||
rt395 | 0 | 5,688,256,772 | 15% | ||
isaria | 0 | 14,970,467,307 | 5% | ||
christianolu | 0 | 221,661,896 | 12.5% | ||
catchawhale | 0 | 5,852,266,599 | 2% | ||
crimsonclad | 0 | 15,005,156,208 | 6% | ||
gokulnk | 0 | 19,691,418,277 | 100% | ||
jonmagnusson | 0 | 141,363,975 | 0.5% | ||
gungadin | 0 | 1,616,387,850 | 100% | ||
jayna | 0 | 1,373,942,191 | 3.75% | ||
thedelegator | 0 | 549,812,096 | 1.25% | ||
bien | 0 | 2,527,115,155 | 100% | ||
talltim | 0 | 0 | 100% | ||
discordiant | 0 | 1,442,201,905 | 6% | ||
jrswab | 0 | 68,055,795,680 | 42% | ||
amymya | 0 | 950,815,227 | 2.5% | ||
steemitbc | 0 | 18,273,576,651 | 100% | ||
inquiringtimes | 0 | 12,707,906,011 | 50% | ||
elsurtidor | 0 | 76,632,554,186 | 76% | ||
krazypoet | 0 | 188,154,358 | 2.5% | ||
clumsysilverdad | 0 | 32,100,191,354 | 50% | ||
buggedout | 0 | 19,231,598,789 | 100% | ||
jasonbu | 0 | 11,613,634,003 | 35% | ||
redrica | 0 | 1,767,897,451 | 5.5% | ||
steemitph | 0 | 38,100,313,685 | 50% | ||
avesa | 0 | 135,946,660 | 0.33% | ||
make-a-whale | 0 | 43,588,358,075 | 6.6% | ||
steem77 | 0 | 131,177,319 | 100% | ||
niallon11 | 0 | 50,456,221,267 | 50% | ||
aneukpineung78 | 0 | 11,147,341,431 | 100% | ||
crokkon | 0 | 96,156,809,467 | 100% | ||
kiriatjrb | 0 | 106,073,591 | 10% | ||
trevorpetrie | 0 | 2,856,260,671 | 25% | ||
torico | 0 | 11,107,498,742 | 25% | ||
diantbi | 0 | 693,931,286 | 10% | ||
eastmael | 0 | 19,180,744,458 | 100% | ||
hz432creations | 0 | 96,773,742 | 12.5% | ||
amphlux | 0 | 411,598,165 | 50% | ||
roleerob | 0 | 9,092,147,594 | 10% | ||
scorer | 0 | 39,871,402,770 | 100% | ||
revisesociology | 0 | 19,456,041,914 | 15% | ||
melavie | 0 | 608,017,095 | 5% | ||
espoem | 0 | 11,974,494,435 | 10% | ||
infamousit | 0 | 4,078,329,185 | 25% | ||
art-mess | 0 | 331,384,436 | 12.5% | ||
loshcat | 0 | 3,026,238,702 | 100% | ||
pataty69 | 0 | 13,812,210,504 | 20% | ||
melvinlumacad | 0 | 2,039,317,025 | 100% | ||
ngc | 0 | 168,159,273,098 | 1.25% | ||
lucylin | 0 | 7,504,417,851 | 100% | ||
paintingangels | 0 | 8,643,274,503 | 100% | ||
learnandteach01 | 0 | 99,827,371 | 60.45% | ||
socent | 0 | 221,422,918 | 15% | ||
utopian-io | 0 | 61,445,423,980,729 | 42.66% | ||
shammi | 0 | 700,863,601 | 1% | ||
eonwarped | 0 | 13,526,776,586 | 5% | ||
mdtipo | 0 | 344,849,492 | 93% | ||
wolfnworbeikood | 0 | 3,823,607,046 | 13% | ||
solomonogene | 0 | 349,987,935 | 93% | ||
nindimtr | 0 | 1,180,469,896 | 100% | ||
amriadits | 0 | 802,242,643 | 100% | ||
emrebeyler | 0 | 14,698,698,485 | 1% | ||
seanlloyd | 0 | 356,265,830 | 1% | ||
steemtaker | 0 | 722,322,081 | 1% | ||
familytree | 0 | 1,342,092,767 | 95% | ||
chireerocks | 0 | 17,419,705,654 | 30% | ||
evecab | 0 | 229,763,945 | 1.25% | ||
murad06 | 0 | 283,001,156 | 46.5% | ||
pechichemena | 0 | 776,734,963 | 5% | ||
mela65 | 0 | 223,462,392 | 46.5% | ||
kernelillo | 0 | 244,192,676 | 12.5% | ||
josephsavage | 0 | 2,125,307,614 | 10% | ||
helpie | 0 | 410,156,858,495 | 25% | ||
markaustin | 0 | 180,678,301 | 5% | ||
williams-owb | 0 | 303,672,560 | 46.5% | ||
luisferchav | 0 | 908,258,493 | 12.5% | ||
steembasicincome | 0 | 158,037,055,635 | 3% | ||
soulturtle | 0 | 620,695,242 | 5% | ||
luoq | 0 | 3,408,048,115 | 100% | ||
amosbastian | 0 | 99,959,654,587 | 52.79% | ||
mountainjewel | 0 | 2,096,825,405 | 2.5% | ||
intrepidphotos | 0 | 43,569,175,187 | 16% | ||
jesusjacr | 0 | 504,483,970 | 0.4% | ||
carpedimus | 0 | 378,778,874 | 12.5% | ||
gamsam | 0 | 214,566,948 | 0.75% | ||
beautifuldata | 0 | 10,215,033 | 30% | ||
davemccoy | 0 | 52,296,884,369 | 100% | ||
mirnasahara | 0 | 363,223,256 | 93% | ||
kingeazi | 0 | 736,844,942 | 50% | ||
portugalcoin | 0 | 3,375,276,592 | 15% | ||
inspiration101 | 0 | 200,217,419 | 46.5% | ||
damahsyari | 0 | 491,957,762 | 100% | ||
mrday | 0 | 2,795,211,295 | 100% | ||
newageinv | 0 | 34,817,544,629 | 20% | ||
grizzle | 0 | 120,965,372 | 1% | ||
twanz | 0 | 485,914,680 | 100% | ||
osazuisdela | 0 | 665,284,412 | 20% | ||
lunaticpandora | 0 | 431,471,595 | 1% | ||
holger80 | 0 | 94,505,297,955 | 50% | ||
silentscreamer | 0 | 2,692,595,955 | 12.5% | ||
glenalbrethsen | 0 | 48,145,803,910 | 30% | ||
warpedpoetic | 0 | 710,772,409 | 3.75% | ||
orlandumike | 0 | 2,684,302,206 | 10% | ||
hazem91 | 0 | 889,202,243 | 6.25% | ||
mcmusic | 0 | 249,253,703 | 46.5% | ||
verhp11 | 0 | 245,073,553 | 1% | ||
east.autovote | 0 | 602,058,163 | 100% | ||
ameliabartlett | 0 | 124,400,954 | 1% | ||
preciousimo | 0 | 338,284,285 | 46.5% | ||
kingsman2 | 0 | 230,236,188 | 46.5% | ||
juandvg | 0 | 92,292,410 | 12.5% | ||
jbrrd | 0 | 176,914,308 | 10% | ||
gjart | 0 | 1,229,689,850 | 30% | ||
siomarasalmeron | 0 | 431,577,955 | 5% | ||
buchari | 0 | 532,022,854 | 100% | ||
steemdragon | 0 | 228,665,185 | 46.5% | ||
spawnband | 0 | 354,979,603 | 5% | ||
roman.musica | 0 | 166,751,674 | 10% | ||
newenx | 0 | 2,181,202,630 | 20% | ||
foxyspirit | 0 | 1,128,292,219 | 5% | ||
good-karma2 | 0 | 554,280,065 | 100% | ||
fitlifefashion | 0 | 4,576,365,793 | 100% | ||
jingis07 | 0 | 11,940,295,761 | 100% | ||
cicisaja | 0 | 7,854,148,174 | 50% | ||
azharmaulana | 0 | 161,924,084 | 46.5% | ||
musmui | 0 | 462,908,297 | 100% | ||
semperenglish | 0 | 1,126,028,679 | 100% | ||
zcool | 0 | 187,777,620 | 10% | ||
kentonlee | 0 | 270,361,337 | 75% | ||
tfq86 | 0 | 5,379,092,482 | 100% | ||
ladiesofsteemit | 0 | 342,200,906 | 10% | ||
lordbutterfly | 0 | 1,860,953,112 | 10% | ||
indusrush | 0 | 2,157,408,122 | 100% | ||
silverade | 0 | 552,600,055 | 100% | ||
peekbit | 0 | 10,620,441,882 | 100% | ||
legendchew | 0 | 10,448,248,692 | 60% | ||
hendragunawan | 0 | 229,961,305 | 46.5% | ||
veckinon | 0 | 700,587,177 | 12.5% | ||
camuel | 0 | 604,342,562 | 1.25% | ||
amarspm53 | 0 | 554,209,677 | 100% | ||
enlighted | 0 | 71,291,461 | 20% | ||
angelacs | 0 | 12,382,534,659 | 15% | ||
kejora05 | 0 | 232,593,278 | 46.5% | ||
archaimusic | 0 | 152,611,371 | 10% | ||
mellofello | 0 | 32,296,382,890 | 100% | ||
musicvoter | 0 | 3,172,583,629 | 1% | ||
conceptskip | 0 | 3,045,956,202 | 50% | ||
free-reign | 0 | 291,650,192 | 12.5% | ||
misterro | 0 | 120,108,909 | 25% | ||
frejafri | 0 | 154,725,997 | 2.5% | ||
marcovugts | 0 | 2,069,605,626 | 100% | ||
n32mente | 0 | 529,414,193 | 100% | ||
mrshev | 0 | 8,773,773,846 | 40% | ||
hazard10 | 0 | 555,582,644 | 100% | ||
nonzerosum | 0 | 35,296,228,120 | 100% | ||
timons | 0 | 230,205,012 | 100% | ||
steem.lion | 0 | 554,744,939 | 100% | ||
adam-aj | 0 | 109,993,919 | 0.5% | ||
steem.peng | 0 | 212,887,932 | 100% | ||
alchemicjourney | 0 | 94,279,115 | 25% | ||
fitat40 | 0 | 22,853,583,762 | 40% | ||
marysemciver | 0 | 196,012,584 | 10% | ||
remind-me | 0 | 2,006,250,909 | 100% | ||
flordiaman | 0 | 171,272,177 | 12.5% | ||
steem-bar | 0 | 555,849,662 | 100% | ||
lillywilton | 0 | 847,006,526 | 20% | ||
csy | 0 | 21,931,545,869 | 25% | ||
preventsuicide | 0 | 86,222,386 | 3.75% | ||
thales7 | 0 | 7,010,017,003 | 100% | ||
gamer86 | 0 | 555,582,644 | 100% | ||
power.steem | 0 | 552,697,849 | 100% | ||
king.steem | 0 | 553,391,285 | 100% | ||
steem.sport | 0 | 552,693,726 | 100% | ||
hafismultim | 0 | 383,068,780 | 100% | ||
markgritter | 0 | 7,309,810,789 | 100% | ||
rades | 0 | 1,889,748,642 | 100% | ||
bar-bar1903 | 0 | 552,697,849 | 100% | ||
duarte9sousa | 0 | 10,982,148,180 | 20% | ||
theexcelclub | 0 | 1,977,294,144 | 100% | ||
ab123 | 0 | 176,080,477 | 37.5% | ||
torrey.blog | 0 | 2,374,701,059 | 50% | ||
munhenhos | 0 | 1,410,908,812 | 20% | ||
icsan | 0 | 556,354,480 | 100% | ||
hornetmusic | 0 | 196,519,940 | 50% | ||
bhaski | 0 | 1,740,724,143 | 20% | ||
hashbrownhustla | 0 | 0 | 10% | ||
brsim | 0 | 537,866,248 | 100% | ||
steem-ua | 0 | 775,251,327,877 | 5.87% | ||
tebarsuara | 0 | 555,625,754 | 100% | ||
smk-trail | 0 | 553,340,683 | 100% | ||
arteem | 0 | 28,522,511,156 | 75% | ||
raoufwilly | 0 | 261,256,409 | 7.5% | ||
eonwarp | 0 | 146,681,067 | 25% | ||
solarphasing | 0 | 552,663,741 | 100% | ||
steemjetdiscord | 0 | 40,512,561,558 | 25% | ||
perspicaz | 0 | 519,446,999 | 100% | ||
nfc | 0 | 9,103,318,490 | 1% | ||
curbot | 0 | 3,930,989,870 | 10% | ||
aeiou00 | 0 | 131,887,295 | 30% |
@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. π
post_id | 64,280,888 |
---|---|
author | chireerocks |
permlink | re-paulag-steem-churn-rates-q3-report-1539594273954-20181015t092859036z |
category | utopian-io |
json_metadata | {"app":"steemit\/0.1","users":["paulag"],"tags":["utopian-io"]} |
created | 2018-10-15 09:29:00 |
last_update | 2018-10-15 09:29:00 |
depth | 1 |
children | 2 |
net_rshares | 40,387,056,627 |
last_payout | 2018-10-22 09:29:00 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.039 SBD |
curator_payout_value | 0.003 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 527 |
author_reputation | 176,468,285,661,949 |
root_title | "STEEM Churn Rates Q3 Report" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
paulag | 0 | 40,387,056,627 | 20% |
hay @chireerocks and thanks for the comment. The future is bright. Steem on.
post_id | 64,281,010 |
---|---|
author | paulag |
permlink | re-chireerocks-re-paulag-steem-churn-rates-q3-report-1539594273954-20181015t093231929z |
category | utopian-io |
json_metadata | {"app":"steemit\/0.1","users":["chireerocks"],"tags":["utopian-io"]} |
created | 2018-10-15 09:32:33 |
last_update | 2018-10-15 09:32:33 |
depth | 2 |
children | 1 |
net_rshares | 0 |
last_payout | 2018-10-22 09:32:33 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 78 |
author_reputation | 224,445,607,823,384 |
root_title | "STEEM Churn Rates Q3 Report" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
Welcome and that's true. π
post_id | 64,281,071 |
---|---|
author | chireerocks |
permlink | re-paulag-re-chireerocks-re-paulag-steem-churn-rates-q3-report-1539594273954-20181015t093400690z |
category | utopian-io |
json_metadata | {"app":"steemit\/0.1","tags":["utopian-io"]} |
created | 2018-10-15 09:34:03 |
last_update | 2018-10-15 09:34:03 |
depth | 3 |
children | 0 |
net_rshares | 0 |
last_payout | 2018-10-22 09:34:03 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 26 |
author_reputation | 176,468,285,661,949 |
root_title | "STEEM Churn Rates Q3 Report" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
Great work @paulag . I always use your stats to check how ell the steem community is doing. Keep dropping awesome content
post_id | 64,280,954 |
---|---|
author | destinysaid |
permlink | re-paulag-steem-churn-rates-q3-report-1539594273954-20181015t093044664z |
category | utopian-io |
json_metadata | {"app":"steemit\/0.1","users":["paulag"],"tags":["utopian-io"]} |
created | 2018-10-15 09:30:45 |
last_update | 2018-10-15 09:30:45 |
depth | 1 |
children | 1 |
net_rshares | 0 |
last_payout | 2018-10-22 09:30:45 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 122 |
author_reputation | 47,618,726,630,085 |
root_title | "STEEM Churn Rates Q3 Report" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 0 |
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.
post_id | 64,281,077 |
---|---|
author | paulag |
permlink | re-destinysaid-re-paulag-steem-churn-rates-q3-report-1539594273954-20181015t093414457z |
category | utopian-io |
json_metadata | {"app":"steemit\/0.1","users":["destinysaid"],"tags":["utopian-io"]} |
created | 2018-10-15 09:34:15 |
last_update | 2018-10-15 09:34:15 |
depth | 2 |
children | 0 |
net_rshares | 23,134,719,065 |
last_payout | 2018-10-22 09:34:15 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.022 SBD |
curator_payout_value | 0.007 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 210 |
author_reputation | 224,445,607,823,384 |
root_title | "STEEM Churn Rates Q3 Report" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
destinysaid | 0 | 23,134,719,065 | 9% |
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!
post_id | 64,281,759 |
---|---|
author | csy |
permlink | re-paulag-steem-churn-rates-q3-report-1539594273954-20181015t095107847z |
category | utopian-io |
json_metadata | {"app":"steemit\/0.1","users":["paulag"],"tags":["utopian-io"]} |
created | 2018-10-15 09:51:09 |
last_update | 2018-10-15 09:51:09 |
depth | 1 |
children | 2 |
net_rshares | 39,670,433,031 |
last_payout | 2018-10-22 09:51:09 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.038 SBD |
curator_payout_value | 0.012 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 705 |
author_reputation | 38,705,954,145,809 |
root_title | "STEEM Churn Rates Q3 Report" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
paulag | 0 | 39,670,433,031 | 20% |
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.
post_id | 64,297,750 |
---|---|
author | paulag |
permlink | re-csy-re-paulag-steem-churn-rates-q3-report-1539594273954-20181015t151105315z |
category | utopian-io |
json_metadata | {"app":"steemit\/0.1","tags":["utopian-io"]} |
created | 2018-10-15 15:11:06 |
last_update | 2018-10-15 15:11:06 |
depth | 2 |
children | 1 |
net_rshares | 21,862,978,484 |
last_payout | 2018-10-22 15:11:06 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.020 SBD |
curator_payout_value | 0.006 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 255 |
author_reputation | 224,445,607,823,384 |
root_title | "STEEM Churn Rates Q3 Report" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
csy | 0 | 21,862,978,484 | 25% |
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!
post_id | 64,324,649 |
---|---|
author | csy |
permlink | re-paulag-re-csy-re-paulag-steem-churn-rates-q3-report-1539594273954-20181016t012635862z |
category | utopian-io |
json_metadata | {"app":"steemit\/0.1","tags":["utopian-io"]} |
created | 2018-10-16 01:26:36 |
last_update | 2018-10-16 01:26:36 |
depth | 3 |
children | 0 |
net_rshares | 0 |
last_payout | 2018-10-23 01:26:36 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 191 |
author_reputation | 38,705,954,145,809 |
root_title | "STEEM Churn Rates Q3 Report" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
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
post_id | 64,282,060 |
---|---|
author | lucylin |
permlink | re-paulag-steem-churn-rates-q3-report-1539594273954-20181015t095731935z |
category | utopian-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"]} |
created | 2018-10-15 09:57:36 |
last_update | 2018-10-15 09:57:36 |
depth | 1 |
children | 11 |
net_rshares | 47,410,861,217 |
last_payout | 2018-10-22 09:57:36 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.045 SBD |
curator_payout_value | 0.014 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 358 |
author_reputation | 53,703,179,637,025 |
root_title | "STEEM Churn Rates Q3 Report" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
paulag | 0 | 39,829,659,902 | 20% | ||
lextenebris | 0 | 7,581,201,315 | 33% |
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.
post_id | 64,293,203 |
---|---|
author | shadowspub |
permlink | re-lucylin-re-paulag-steem-churn-rates-q3-report-1539594273954-20181015t135302671z |
category | utopian-io |
json_metadata | {"tags":["utopian-io"],"app":"steemit\/0.1"} |
created | 2018-10-15 13:53:03 |
last_update | 2018-10-15 13:53:03 |
depth | 2 |
children | 10 |
net_rshares | 0 |
last_payout | 2018-10-22 13:53:03 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 328 |
author_reputation | 122,086,225,405,906 |
root_title | "STEEM Churn Rates Q3 Report" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
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.
post_id | 64,295,774 |
---|---|
author | lucylin |
permlink | re-shadowspub-re-lucylin-re-paulag-steem-churn-rates-q3-report-1539594273954-20181015t143838787z |
category | utopian-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"]} |
created | 2018-10-15 14:38:42 |
last_update | 2018-10-15 14:38:42 |
depth | 3 |
children | 9 |
net_rshares | 7,531,577,308 |
last_payout | 2018-10-22 14:38:42 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 717 |
author_reputation | 53,703,179,637,025 |
root_title | "STEEM Churn Rates Q3 Report" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
lextenebris | 0 | 7,531,577,308 | 33% |
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!!
post_id | 64,283,214 |
---|---|
author | gungadin |
permlink | re-paulag-steem-churn-rates-q3-report-1539594273954-20181015t102653641z |
category | utopian-io |
json_metadata | {"tags":["utopian-io"],"app":"steemit\/0.1"} |
created | 2018-10-15 10:26:57 |
last_update | 2018-10-15 10:26:57 |
depth | 1 |
children | 2 |
net_rshares | 39,989,233,298 |
last_payout | 2018-10-22 10:26:57 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.038 SBD |
curator_payout_value | 0.012 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 260 |
author_reputation | 72,073,859,327 |
root_title | "STEEM Churn Rates Q3 Report" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
paulag | 0 | 39,989,233,298 | 20% |
"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.
post_id | 64,297,546 |
---|---|
author | paulag |
permlink | re-gungadin-re-paulag-steem-churn-rates-q3-report-1539594273954-20181015t150715777z |
category | utopian-io |
json_metadata | {"app":"steemit\/0.1","tags":["utopian-io"]} |
created | 2018-10-15 15:07:18 |
last_update | 2018-10-15 15:07:18 |
depth | 2 |
children | 1 |
net_rshares | 22,678,051,637 |
last_payout | 2018-10-22 15:07:18 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.021 SBD |
curator_payout_value | 0.006 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 194 |
author_reputation | 224,445,607,823,384 |
root_title | "STEEM Churn Rates Q3 Report" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
gungadin | 0 | 1,873,870,871 | 100% | ||
dustsweeper | 0 | 20,804,180,766 | 2.78% |
Yes I totally agree, but it is a bonus and incentive some people need to get started.
post_id | 64,329,915 |
---|---|
author | gungadin |
permlink | re-paulag-re-gungadin-re-paulag-steem-churn-rates-q3-report-1539594273954-20181016t034646256z |
category | utopian-io |
json_metadata | {"tags":["utopian-io"],"app":"steemit\/0.1"} |
created | 2018-10-16 03:46:51 |
last_update | 2018-10-16 03:46:51 |
depth | 3 |
children | 0 |
net_rshares | 0 |
last_payout | 2018-10-23 03:46:51 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 85 |
author_reputation | 72,073,859,327 |
root_title | "STEEM Churn Rates Q3 Report" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
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.
post_id | 64,290,848 |
---|---|
author | newageinv |
permlink | re-paulag-steem-churn-rates-q3-report-1539594273954-20181015t131107446z |
category | utopian-io |
json_metadata | {"tags":["utopian-io"],"app":"steemit\/0.1"} |
created | 2018-10-15 13:11:09 |
last_update | 2018-10-15 13:11:09 |
depth | 1 |
children | 1 |
net_rshares | 40,149,740,492 |
last_payout | 2018-10-22 13:11:09 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.038 SBD |
curator_payout_value | 0.012 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 545 |
author_reputation | 109,928,704,812,170 |
root_title | "STEEM Churn Rates Q3 Report" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
paulag | 0 | 40,149,740,492 | 20% |
I am looking forward to seeing communities on boarding and SMT's. everything will become so much more focused then.
post_id | 64,297,599 |
---|---|
author | paulag |
permlink | re-newageinv-re-paulag-steem-churn-rates-q3-report-1539594273954-20181015t150802141z |
category | utopian-io |
json_metadata | {"app":"steemit\/0.1","tags":["utopian-io"]} |
created | 2018-10-15 15:08:03 |
last_update | 2018-10-15 15:08:03 |
depth | 2 |
children | 0 |
net_rshares | 0 |
last_payout | 2018-10-22 15:08:03 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 116 |
author_reputation | 224,445,607,823,384 |
root_title | "STEEM Churn Rates Q3 Report" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
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 :)
post_id | 64,292,960 |
---|---|
author | davemccoy |
permlink | re-paulag-steem-churn-rates-q3-report-1539594273954-20181015t134830502z |
category | utopian-io |
json_metadata | {"tags":["utopian-io"],"users":["paulag"],"app":"steemit\/0.1"} |
created | 2018-10-15 13:48:30 |
last_update | 2018-10-15 13:48:30 |
depth | 1 |
children | 1 |
net_rshares | 44,199,129,298 |
last_payout | 2018-10-22 13:48:30 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.042 SBD |
curator_payout_value | 0.012 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 310 |
author_reputation | 20,209,499,381,910 |
root_title | "STEEM Churn Rates Q3 Report" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
paulag | 0 | 40,310,599,353 | 20% | ||
ilovepoorpeople | 0 | 3,888,529,945 | 100% |
I cant help be optimistic when I have been looking at this churn rate drop month after month.
post_id | 64,297,665 |
---|---|
author | paulag |
permlink | re-davemccoy-re-paulag-steem-churn-rates-q3-report-1539594273954-20181015t150920008z |
category | utopian-io |
json_metadata | {"app":"steemit\/0.1","tags":["utopian-io"]} |
created | 2018-10-15 15:09:21 |
last_update | 2018-10-15 15:09:21 |
depth | 2 |
children | 0 |
net_rshares | 55,829,290,608 |
last_payout | 2018-10-22 15:09:21 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.052 SBD |
curator_payout_value | 0.017 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 93 |
author_reputation | 224,445,607,823,384 |
root_title | "STEEM Churn Rates Q3 Report" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
davemccoy | 0 | 55,829,290,608 | 100% |
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.
post_id | 64,304,957 |
---|---|
author | freebornangel |
permlink | re-paulag-steem-churn-rates-q3-report-1539594273954-20181015t172232163z |
category | utopian-io |
json_metadata | {"users":["statsmonkey"],"app":"steemit\/0.1","tags":["utopian-io"]} |
created | 2018-10-15 17:22:54 |
last_update | 2018-10-15 17:22:54 |
depth | 1 |
children | 0 |
net_rshares | 0 |
last_payout | 2018-10-22 17:22:54 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 625 |
author_reputation | 217,103,420,888,695 |
root_title | "STEEM Churn Rates Q3 Report" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
> 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.
post_id | 64,306,165 |
---|---|
author | lextenebris |
permlink | re-paulag-steem-churn-rates-q3-report-1539594273954-20181015t174605024z |
category | utopian-io |
json_metadata | {"community":"steempeak","app":"steempeak","tags":["utopian-io"]} |
created | 2018-10-15 17:46:06 |
last_update | 2018-10-15 17:46:06 |
depth | 1 |
children | 4 |
net_rshares | 0 |
last_payout | 2018-10-22 17:46:06 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 4,479 |
author_reputation | 15,727,752,514,706 |
root_title | "STEEM Churn Rates Q3 Report" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
So why don't you do a post on churn and show me how is should be done then?
post_id | 64,313,172 |
---|---|
author | paulag |
permlink | re-lextenebris-re-paulag-steem-churn-rates-q3-report-1539594273954-20181015t202250932z |
category | utopian-io |
json_metadata | {"app":"steemit\/0.1","tags":["utopian-io"]} |
created | 2018-10-15 20:22:51 |
last_update | 2018-10-15 20:22:51 |
depth | 2 |
children | 3 |
net_rshares | 0 |
last_payout | 2018-10-22 20:22:51 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 75 |
author_reputation | 224,445,607,823,384 |
root_title | "STEEM Churn Rates Q3 Report" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
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?
post_id | 64,314,531 |
---|---|
author | lextenebris |
permlink | re-paulag-re-lextenebris-re-paulag-steem-churn-rates-q3-report-1539594273954-20181015t205522892z |
category | utopian-io |
json_metadata | {"tags":["utopian-io"],"community":"steempeak","app":"steempeak"} |
created | 2018-10-15 20:55:24 |
last_update | 2018-10-15 20:55:24 |
depth | 3 |
children | 2 |
net_rshares | 0 |
last_payout | 2018-10-22 20:55:24 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 2,653 |
author_reputation | 15,727,752,514,706 |
root_title | "STEEM Churn Rates Q3 Report" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
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
post_id | 64,342,056 |
---|---|
author | peekbit |
permlink | re-paulag-steem-churn-rates-q3-report-1539594273954-20181016t090243349z |
category | utopian-io |
json_metadata | {"users":["peekbit"],"app":"steemit\/0.1","tags":["utopian-io"]} |
created | 2018-10-16 09:02:42 |
last_update | 2018-10-16 09:02:42 |
depth | 1 |
children | 0 |
net_rshares | 260,324,110,127 |
last_payout | 2018-10-23 09:02:42 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.248 SBD |
curator_payout_value | 0.081 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 151 |
author_reputation | 21,544,346,900,318 |
root_title | "STEEM Churn Rates Q3 Report" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
retinox | 0 | 259,945,984,860 | 100% | ||
sergino | 0 | 378,125,267 | 2.25% |
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/)
post_id | 64,350,621 |
---|---|
author | crokkon |
permlink | re-paulag-steem-churn-rates-q3-report-1539594273954-20181016t121714656z |
category | utopian-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"} |
created | 2018-10-16 12:17:15 |
last_update | 2018-10-16 12:17:15 |
depth | 1 |
children | 2 |
net_rshares | 6,103,469,561,957 |
last_payout | 2018-10-23 12:17:15 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 5.852 SBD |
curator_payout_value | 1.878 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 1,352 |
author_reputation | 75,470,595,669,689 |
root_title | "STEEM Churn Rates Q3 Report" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
yuxi | 0 | 8,916,434,132 | 30% | ||
mys | 0 | 3,390,471,180 | 3.29% | ||
paulag | 0 | 56,797,613,910 | 24% | ||
pixelfan | 0 | 1,141,324,489 | 0.54% | ||
utopian-io | 0 | 5,973,351,179,911 | 4.22% | ||
emrebeyler | 0 | 29,454,816,825 | 2% | ||
amosbastian | 0 | 12,120,504,763 | 6.9% | ||
reazuliqbal | 0 | 5,050,674,373 | 8% | ||
hakancelik | 0 | 13,246,542,374 | 20% |
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.
post_id | 64,598,094 |
---|---|
author | paulag |
permlink | re-crokkon-re-paulag-steem-churn-rates-q3-report-1539594273954-20181020t133354718z |
category | utopian-io |
json_metadata | {"users":["crokkon"],"tags":["utopian-io"],"app":"steemit\/0.1"} |
created | 2018-10-20 13:33:57 |
last_update | 2018-10-20 13:33:57 |
depth | 2 |
children | 0 |
net_rshares | 30,525,469,676 |
last_payout | 2018-10-27 13:33:57 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.027 SBD |
curator_payout_value | 0.008 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 613 |
author_reputation | 224,445,607,823,384 |
root_title | "STEEM Churn Rates Q3 Report" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
crokkon | 0 | 30,525,469,676 | 30% |
Thank you for your review, @crokkon! So far this week you've reviewed 3 contributions. Keep up the good work!
post_id | 64,644,908 |
---|---|
author | utopian-io |
permlink | re-re-paulag-steem-churn-rates-q3-report-1539594273954-20181016t121714656z-20181021t093523z |
category | utopian-io |
json_metadata | {"app":"beem\/0.20.1"} |
created | 2018-10-21 09:35:24 |
last_update | 2018-10-21 09:35:24 |
depth | 2 |
children | 0 |
net_rshares | 0 |
last_payout | 2018-10-28 09:35:24 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 110 |
author_reputation | 152,913,012,544,965 |
root_title | "STEEM Churn Rates Q3 Report" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
#### 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)**
post_id | 64,351,210 |
---|---|
author | steem-ua |
permlink | re-steem-churn-rates-q3-report-1539594273954-20181016t123059z |
category | utopian-io |
json_metadata | {"app":"beem\/0.20.7"} |
created | 2018-10-16 12:31:00 |
last_update | 2018-10-16 12:31:00 |
depth | 1 |
children | 0 |
net_rshares | 0 |
last_payout | 2018-10-23 12:31:00 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 285 |
author_reputation | 23,203,609,903,979 |
root_title | "STEEM Churn Rates Q3 Report" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
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.
post_id | 64,366,060 |
---|---|
author | intrepidphotos |
permlink | re-paulag-steem-churn-rates-q3-report-1539594273954-20181016t170030308z |
category | utopian-io |
json_metadata | {"tags":["utopian-io"],"community":"steempeak","app":"steempeak"} |
created | 2018-10-16 17:00:33 |
last_update | 2018-10-16 17:00:33 |
depth | 1 |
children | 0 |
net_rshares | 0 |
last_payout | 2018-10-23 17:00:33 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 180 |
author_reputation | 361,224,981,730,276 |
root_title | "STEEM Churn Rates Q3 Report" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
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.
post_id | 64,381,592 |
---|---|
author | glenalbrethsen |
permlink | re-paulag-steem-churn-rates-q3-report-1539594273954-20181016t234232149z |
category | utopian-io |
json_metadata | {"users":["paulag"],"app":"steemit\/0.1","tags":["utopian-io"]} |
created | 2018-10-16 23:42:33 |
last_update | 2018-10-16 23:42:33 |
depth | 1 |
children | 0 |
net_rshares | 0 |
last_payout | 2018-10-23 23:42:33 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 1,156 |
author_reputation | 73,752,675,176,126 |
root_title | "STEEM Churn Rates Q3 Report" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
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.
post_id | 64,384,746 |
---|---|
author | evolved08gsr |
permlink | re-paulag-steem-churn-rates-q3-report-1539594273954-20181017t011926233z |
category | utopian-io |
json_metadata | {"app":"steemit\/0.1","tags":["utopian-io"]} |
created | 2018-10-17 01:19:27 |
last_update | 2018-10-17 01:19:27 |
depth | 1 |
children | 0 |
net_rshares | 0 |
last_payout | 2018-10-24 01:19:27 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 451 |
author_reputation | 3,930,469,625,760 |
root_title | "STEEM Churn Rates Q3 Report" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
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>
post_id | 64,672,936 |
---|---|
author | utopian-io |
permlink | re-steem-churn-rates-q3-report-1539594273954-20181021t200512z |
category | utopian-io |
json_metadata | {"app":"beem\/0.20.1"} |
created | 2018-10-21 20:05:15 |
last_update | 2018-10-21 20:05:15 |
depth | 1 |
children | 0 |
net_rshares | 0 |
last_payout | 2018-10-28 20:05:15 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 588 |
author_reputation | 152,913,012,544,965 |
root_title | "STEEM Churn Rates Q3 Report" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |