At the beginning of every month I prepare a report containing details of new users for the previous month.
Aim of Analysis
The aim of this analysis is:
• Establish how many new users registered
• Establish what % of accounts have posts
• Find out who are the new big players in terms of SP
• See what accounts are acting suspiciously
• Establish if there is a break in any of the trends from previous periods
The Data-source and Query
As always to produce this report I connect to Steemsql (paid subscription services held and managed by @arcange ) with Power BI.
The SQL query used to gather the data for this report was
Select *
FROM Accounts (NOLOCK)
where
( created >= CONVERT(datetime,'01/01/2018')
AND created< CONVERT(datetime,'02/01/2018')
Once I loaded the data into Power BI, I then carried out transformation and calculations using DAX language.
If you missed the full January ‘18’s report you can check it out here
@paulag/january-2018-new-steemit-user-report-blockchain-business-intelligence
Overview
Jan ‘18 Overview
Feb ‘18 Overview
After a bumper month in January with over 159K new users, February new user registration was down 54% to 73K. However 73K is still a substantial number of new users and is in line with December 17 values
In February ’17 there were 4,636 new account. Feb ’18 is therefore up 1439% on the same period last year.
Just over 17% of new accounts completed their ‘about’ section in their profile and almost 8% have added a link to an external reference. These values have remained rather consistent each month since starting this analysis. Why are these values of importance? Well I use these to assess potential the quality of the user. If they have come to Steemit to browse then chances are they may not complete these fields. However if they are experienced bloggers or have experience in social media marketing, then they know the importance of competing this information.
Posting Activity
The % of new accounts with posts was 43.77% and the % of accounts with 10+ posts is 20.29%, the exact same as January.
We can see from the pie chart above, 56.22% of new accounts have not yet posted. 9.8% have made one post and 4.86% have made two posts.
Strange Activity
There are very very few extraordinary accounts on Steemit that can push out multiple posts a day of high quality. From discussion with other experienced steemain and whales, account producing large volumes of comments or posts could very well be bots, scammers or plagiarists and the activity is deemed suspicious till otherwise cleared up.
Below are the new accounts from Feb that have suspicious activity. Tagging @steemcleaners and @cheetah to cross reference
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. However it is also not unheard of for account to produce multiple good quality posts or comments a day.
New High Value SP Accounts set up in February
The table below shows the new Steemit Users sorted by Vesting Shares.
@promobot has about 297K SP. Both the recovery account and the witness proxy on this account is set to @transisto.
@puzzlingestate has about 36K SP, most of which has been delegated to @minnowbooster.
@pi50000 has about 28K SP, most of which has been delegated to @spydo.
@jayzel has about 21K SP – this time the SP has not been invested into a voting bot and @jayzel has yet to post.
A big big welcome to all the new users that registered with Steemit in Feb ’18. If you did join in Feb ’18 you might be interested in seeing how those are doing after a year on Steemit. You can read that report here
@paulag/if-you-joined-steemit-in-february-2017-then
Conclusion
Although there was a dip in the number of new users registered in February compared to January, this is of no concern as the number of new users for Feb was still higher than then average month in 2017.
It is also interesting to see that people see voting bots as a profitable venture to invest in. This is evident by the delegation given by new accounts to voting bots.
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