WOW we left 2017 with a bang and we entered 2018 with an even bigger bang. Every month I look at some data on new users and all I can say for January 18 is WOW.
If you missed the December 17 report you can catch it here
@paulag/new-steemit-user-analysis-december-report
You might remember from that report that we took the analysis a little further than before, well this month we had added more, and I hope over time to continue to improve this report. If you have any suggests on data re new users, please do leave a comment below.
Did you join Steemit in Jan 18? Then welcome to the platform. You might like to see how people are doing after 1 year on Steemit. Check out this post to find out more
@paulag/did-you-join-steemit-in-jan-17-here-is-some-data-to-celebrate
December Overview
January Overview
January 18 saw 159,740 new accounts register on Steemit proving to be the biggest month so far for signups. It’s up 116% on December 2017. We can see from the table below the % change each month for the last few months.
In January 2017 only 6,739 new accounts registered on Steemit. Based on the same period last year this is a massive 1275% increase.
Almost 17% of new account holders have completed their about profile section, this is up on the 14.8% reported in December and is an indication of the quality of the user. If people are just browsing they are less likely to complete their about section.
The % of accounts with posts is 45.14%, and the % of accounts with 10+ post is 20.29%, up from 16.8% in December.
We can see from the pie chart above, 54.86% of new accounts have not yet posted. 9.8% have made one post and 5.2% has made two posts.
Below is a table of new users that registered in Jan 18 sorted by the vesting shares held. @z8teyb289qav9z is holding about 85K STEEM and this dude made a post about powering up.
Strange Activity
New to this report last month was to identify accounts where the activity appeared strange. Activity as in excessive posting. Again this month I have identified a number of accounts that have posted or commented more than 1000 times within their first month.
I must add that I have not checked the integrity of these accounts or posts, I struggle to get 1 data post done a day and I know from talking with writers, good form content can take a number of hours to write and post.
Conclusion
Jan 18 saw the biggest increase in the number of new users on Steemit. There could be a number of factors involved in this
- the price of STEEM peaked in Jan 18
- the price of SBD remained high in Jan 18
- Cryptocurrency in general is becoming more popular
- there are now more people than ever promoting the steemit platform on social media such as Youtube and Twitter.
If the number of new accounts remains consistent for 2018, so at about 150K per month, within 7 months we will have 1m new users. With a retention rate of lets say 10%, within 12 months we would see a total active user base of 250K people.
Datasource and queries
I connected to Steemsql held and managed by @arcange using Power BI
The sql query used was for December
Select *
FROM Accounts (NOLOCK)
where
( created >= CONVERT(datetime,'01/01/2018')
AND created< CONVERT(datetime,'02/01/2018')
After collecting the data I then use DAX (Data Analysis Expressions) to carry out calculations on the data, and the results are presented in the visualizations above.
I am part of a Blockchain Business Intelligence community. We all post under the tag #BlockchainBI. If you have an analysis you would like carried out on Steemit or Blockchain data, please do contact me or any of the #BlockchainBI team and we will do our best to help you...
You can find #BlockchainBI on discord https://discordapp.com/invite/JN7Yv7j
Posted on Utopian.io - Rewarding Open Source Contributors