Steemit Churn Rates Q1 2018
utopian-io·@paulag·
0.000 HBDSteemit Churn Rates Q1 2018
<html> <p>Churn is a fact of life in business. You will win new users and you will lose users. 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>“While churn is not necessarily a bad thing for all businesses, a high churn rate compared to your competitors can be a troubling sign. For social media and advertising platforms, it can suggest a lack of engagement and loyalty among the user base – and increased consumer dissatisfaction with the platform at large. Especially for companies that rely on advertising revenue, the lack of a consistent, engaged audience could jeopardize key business models and monetization strategies.”</p> <p>Source https://www.vertoanalytics.com/chart-week-social-media-networks-churn/</p> <p>https://www.vertoanalytics.com/wp-content/uploads/2017/05/verto-analytics-chart-week-churn-social-media.png</p> <p>The aim of this analysis is to calculate the churn rate on Steemit. I have seen the question being asked a number of times now in different comments on posts, and most recently I had a direct request from @davemccoy for this information.</p> <h2> Repository</h2> <p><a href="https://github.com/steemit/steem">https://github.com/steemit/condenser</a></p> <p>All data for this analysis was taken from Steemsql held and managed by @arcange. As to not distract from the data, I will first present the findings and then the queries used.</p> <h2>Weekly Churn Rates 2018</h2> <p>The chart below shows the weekly churn rate by line and by bar you can see the number of new accounts and the distinct user count for the week.</p> <p> https://steemitimages.com/DQmWyNfJey8aLnhuJSkuzzPMeivreqhV4GLLAzVUXTfGfDW/image.png </p> <p>https://steemitimages.com/DQmPy5egfTzxfEfCaYtbCF64s5fzB9EGEyhUQbxCPQDasdv/image.png </p> <p> </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 can vary from week to week it is expected to see this variation reflected in the churn rates.</p> <p>The average weekly churn rate is 22% and the median is 20%</p> <h2>Monthly Churn 2018</h2> <p>https://steemitimages.com/DQmaACh57CyngcrpkoFNg1P7ZV9KReQzR2pU4BaCADWkAEe/image.png https://steemitimages.com/DQmXWZsAK8j3N59fp8RsP88qvNVqTE7dsjZv3eD61UFNBob/image.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. There are notable swings on the number of new accounts each month. However the distinct user is smoother when looked at monthly over weekly. This smoothness in the distinct user reduces the swings on the churn rates</p> <p>Both the average and the median monthly churn rates are 59%</p> <h2>Q1 2018 Churn rate</h2> <p>https://steemitimages.com/DQmUEzXxmLkbi6ioeTmLPJ2RTj5Av7M1KyoRjhtnYbumRry/image.png</p> <p> In Q1 of 2018 Steemit lost more active users than gained. The churn rate was 121% </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%. I was unable to source more recent data and I was also unable to source churn rates for Reddit. If you do have this information, please do comment below as it would add value to this post.</p> <h2>Specific Turn Rates</h2> <p>In @davemccoy request he defined the</p> <blockquote> "active users" as those members that post or comment in the preceding 2 week period of time</blockquote> <p> https://steemitimages.com/DQmdgbfpJfutaArNrjkDZwn3ZZdCtfV4EvB27TiRiE5qWGU/image.png https://steemitimages.com/DQmaEFsL236nxNA1Q2TzwDYDrJ9LLzk7nRJk6hH8qMLkNQQ/image.png</p> <p> Calculating churn rates this was results in a higher monthly churn, with January showing that Steemit lost more active users than gained. Both the average and the median month churn rates are 79% in 2018</p> <p><br></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. Calculating monthly churn in both ways as above show that Steemit has a monthly churn of between 59% and 79%. However a Q1 turn rate of 121% is very disappointing to see.</p> <p>What are your thoughts on the churn rates above? What reflection do they give about Steemit? Please do comment below </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,'2017-10-01') and timestamp< CONVERT(DATE,'2018-05-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,'2017-01-01') and timestamp< CONVERT(DATE,'2018-05-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.</p> <p>The query used to get the number of new accounts was</p> <pre><code>Select name, created FROM Accounts (NOLOCK)</code></pre> <p> I am part of a Blockchain Business Intelligence community. We all post under the tag <a href="https://steemit.com/trending/blockchainbi">#blockchainbi</a>. If you have an analysis you would like carried out on Steemit data, please do contact me or any of the <a href="https://steemit.com/trending/blockchainbi">#blockchainbi</a> team and we will do our best to help you...<br> You can find <a href="https://steemit.com/trending/blockchainbi">#blockchainbi</a> on discord <a href="https://discordapp.com/invite/JN7Yv7j">https://discordapp.com/invite/JN7Yv7j</a> </p> </html>
👍 nin4i, east.autovote, lord-geraldi, elsurtidor, damahsyari, zcool, semperenglish, beautifuldata, musmui, freebornsociety, j3dy, safwaninisam, josephsavage, steembasicincome, tarazkp, steemitph, kubbyelizabeth, gokulnk, steemitbc, abh12345, revisesociology, xny, boxcarblue, livinguktaiwan, rt395, pataty69, steem.curator, orlandumike, crimsonclad, eastmael, discordiant, legendchew, malloryblythe, jasonbu, mangos, manfaluthi, luoq, beat-the-bookies, ladiesofsteemit, ethandsmith, dodybireuen, nanzo-scoop, newhope, orballun, ameliabartlett, inquiringtimes, smithbot, juecoree, daiky69, mattclarke, soma909, nawamy, techslut, sinbad989, demotruk, techtek, evolved08gsr, enforcer48, lpfaust, enjar, mrday, steem77, paulawonders, utopian-io, alexzicky, newsrx, whellocats, guttormf, bryan-imhoff, nyakdira, sevenfingers, equ1l1br1um, talltim, michaelnem, iskandarpcc, bendi, davemccoy, cutemachine, helenoftroy, dylanhobalart, themanwithnoname, magicalmoonlight, mohdrafi786, glenalbrethsen, zainnosa, jeangris19, aci7, curatorcat, jan23com, datavizcat, herigoodboy, gacekbwp, krischik, plushzilla, carlgnash, scruffy23, misterakpan, tormiwah, dillemma, beelzebub, buckydurddle, papaudeme, awesomeabasiono, belial, demogorgon, aamon, zuul, fredkese, scorer, peekbit,