I missed the new user Analysis last month, so this month I present to you both October and November New Steemit Users Analysis
Just in case you missed Septembers report (or you just forget at this stage!) here is the stats for that month
October Report
November Report
Summary
Steemit experienced a fall in the number of new users registering in Sept from Aug of 19.75%. From Sept to Oct this decline slowed down to only 8%. The decline might have also seen a bottom with an increase in new users for November of 1%
Looking at the stats for the users that update their profile, we can use this as a simple measure of the quality of the user that has joined steemit. The thinking behind this is that if you really intend on using Steemit as a social media platform then you will use the opportunity to complete the ‘about’ section and maybe even put a link into your profile too.
Again in September there was a downturn in the % of accounts that had added the ‘about’ or ‘website’ section. However these stats exceed previously reported for October with almost 18% completing their about section. The % of new accounts that have added a link to their profile has remained consistent over the months.
The % of new accounts from October that have posted is showing at 41.16%. It must be noted here that this value is showing higher than previous months because the data pulled for October as only been pulled today. That means that these accounts have had more ‘time’ to post than accounts set up in Nov. This is also true for the number of account set up in October that have 10 or more posts and the total posts count for accounts set up in during this time.
We can however see that the % of account with 10+ posts has increased from 15.45% in Sept to 17.68% in November
Looking at the new users by date in the November dashboard we can see a lull for the first number of days in the month and then a spike on the 10th Nov. For those of you that wish to query this, Steemfest 2 was on and I am sure that most of the team were busy with that at the time.
Datasource and queries
I connected to Steemsql held and managed by @arcange
The sql query used was for October
Select *
FROM Accounts (NOLOCK)
where
( created >= CONVERT(datetime,'10/01/2017')
AND created< CONVERT(datetime,'11/01/2017'))
And for November
Select *
FROM Accounts (NOLOCK)
where
( created >= CONVERT(datetime,'11/01/2017')
AND created< CONVERT(datetime,'12/01/2017'))
After this the data was further transformed with the query editor in Power BI and then calculations were carried out using DAX
I am part of a Steemit Business Intelligence community. We all post under the tag #BIsteemit. If you have an analysis you would like carried out on Steemit data, please do contact me or any of the #bisteemit team and we will do our best to help you... *
You can find #bisteemit on discord https://discordapp.com/invite/JN7Yv7j
Posted on Utopian.io - Rewarding Open Source Contributors