What a year 2017 was on Steemit. One heck of a journey that started for me in June. I guess this report ends the year on a high. I can’t wait to show you the data.
But before that, this analysis is prepared on a monthly basis. If you missed last month’s report you can find it here
@paulag/new-steemit-users-analysis-oct-and-nov-report-steemit-business-intelligence
However this month I have taken the analysis a step further. Included in this report are new accounts that by the numbers show suspicious activity and a report on drop offs when it comes to voting.
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,'12/01/2017')
AND created< CONVERT(datetime,'01/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 below.
The analysis includes data for December using November as the comparable period, and included analysis not previous shown in previous months reports
November Report
December Report
Summary
In November 40,788 new accounts were registered with Steemit. In December this value jumped 81% to 73,793. This is by far the largest jump since I began tracing this data. The total posts by new accounts also increased as you would expect with a rise in the number of new accounts. This increased by 57%.
Other important stats include % of accounts with an external link and ‘about’ profile complete. The % here has not changed much on November, however the percentages are slightly down.
What is also interesting is that only 39.81% of new account, so the minority of new accounts, have posted. This leaves a substantial number of new accounts that have not yet posted. This can be better seen in the pie chart below
7K new accounts only had 1 post, 3.5K had two posts and 2.81K had 3 posts.
Strange Activity
16.82% of new accounts had 10 or more posts. It is really good to see new Steemains engaging with the platform and posting. However when looking at the data I came across many accounts set up in December that have posted/commented more than 1000 times.
This seems rather excessive, 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.
What I will say is that I have not checked the integrity of these accounts or posts, but I really don’t see how one account as added 4416 good/valuable posts in 7 days like @nijeah and as it is one of the accounts I actually did look at. I would suggest you take a look yourself and decide.
On saying that I am tagging @steemcleaners so they can compare lists :-)
Additional Data
The visualization below shows the % off accounts registered in December that have not voted since the given date and also the cumulative
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