Analysis of New Steemit Users July ’17 – Steemit Business IntelligencesteemCreated with Sketch.

in #steemit6 years ago

On the 11 July I had my first look at the SteemitSQL database using Power BI and I prepared the report below.  This report analysed New Steemit Accounts from the 1st to the 11th July. ( you can read the blog post here )

I have decided that this report should from part of my regular Steemit Business Intelligence reports as there are some key metrics here that are important to the success of Steemit as a whole.  This report might change from month to month as I understand the database better and can provide more insights.

So what’s the story with New Steemit Users for July ’17?

In total 54,545 new accounts were registered and approved on Steemit.

Of this only 18% have completed their ‘About’ profile and 8.4% have added a website.  This is consistent with the report completed on the 11th.

 Why are these two metrics important? 

Well first of all if you are an established blogger trying to get reach, then you know that your profile information is important.  It is a tool that will help you sell yourself to a new audience and help you get found.  Not completing this section would suggest to me

a) The new user is not experienced in Social media/content marketing

b) The new user is only exploring the site and does not want to give details

c) New users don’t know how to update their profile

By adding a website to your profile will allow Steemit users see your other work, if you have any.  Like with adding profile details, an experienced blogger or social media marketer would know this is an important field to complete.

And on Steemit, by adding an external website to your profile you are securing a back-link from which has a rather high domain authority.  A key ingredient for good SEO.  Again something experienced bloggers, content or social media marketers would know.

An increase in these values would suggest more experienced bloggers are coming to Steemit.

Other Stats on New Steemit Users for July

45% of new accounts have made a post or a comment. This is consistent with the earlier report.  However 55% of accounts have not made a post or comment.   This is a metric we should keep an eye on.  Ideally we would like to see 55%+ with posts or comments

Also marginally higher is the number of new accounts that contains 10 or more posts/comments.

What has changed is that for the month in Total Mondays had the highest total registrations in the month. Please keep in mind July 17 has 5 Mondays and Sundays.

The day with the highest number of new accounts is the 8th July (which was a Saturday).

In my previous analysis there was a comment made about finding out how many new users are commenting or blogging.  In total there were 745K posts made my new steemit users in July.  Of this 21.7% are blog posts and 78.3 % are comments.

I have added a new worksheet to the dashboard with two new tables. These tables show the % of new accounts that have not voted since the date shown, or not posted since the date shown.  These tables give an indication of drop off rates.

Did you like this analysis?  Is there something else about new users you would like me to include in next month’s report?  Have you any questions on any of the above?

If so then comment below.

Steem On Everyone – I am really enjoying carrying out these analysis….follow me for more!!!

I have included the tag steem-dev as a comment on a recent post said my analysis and business intelligence would be useful for developers - please comment below if you feel I should not share in this tag as I do not want to abuse tags

I use PowerBI to produce these dashboards - PowerBI  desktop is a free self service business intelligence tool. You can download it from here.  Then if you want a copy of any of these dashboards we can swap for some steem!

I also have course -Power BI the Ultimate Orientation - You can access it FREE from here


Upvoted and Resteemed by xx-votesplus, the dropAhead curation team! Want more earnings? Join @dropahead in Streemian, or delegate/donate some STEEM POWER to @dropahead!

Please upvote this comment! We will earn more STEEM POWER (SP) to give you more earnings!

Keep up the good work!

Most recent post: dropAhead to focus on curating posts, core of the project!

Thanks for this Paula, another really good bit of analysis.

It would be interesting to measure the metric of how many accounts have not posted/commented/resteemed one month after account creation - on a rolling 30 day basis.

And then the same 30 day rolling metric for accounts that have only upvoted.

This might give some more insight into the purpose of the half or so of all accounts that seem to be ghost accounts.

From a steemit marketing point of view I guess total accounts is a better number than total active accounts.

It would make an interesting graph to see how those two figures have respectively grown since the start of steemit. (It may already exist somewhere?)

great suggestion. Watch this space

Lol someone from Antarctica joined

Nice post. I like the emphasis you gave on the importance of users completing their profile and providing a website link!

To me it makes scene to complete the profile and link, but I am working online for 7 years now so I know some of the ropes that need to be pulled

Didn't take long for them to start dropping off. how sad. :(

Thanks for the information!

That's not unusual. Many people will try out something new, and if they do not meet "instant success" they will go elsewhere. However, when critical mass is reached that so many of their friends or associates are on Steemit, they will have to come back.

Andreas M. Antonopoulos gave an interview just on this topic and comparing the path of growth Facebook took to where Steemit is now.

the drop offs and retention are a problem.....but there are people trying to help solve this such as #Minnowsupport and #steemitbc

This post has received a 29.46 % upvote from @lovejuice thanks to: @abh12345. They have officially sprayed their dank amps all over your post rewards. GOOD TIMES! Vote for Aggroed!

Great piece of analysis! List of best BI tools

Thank you for this, it is good to know this information, provides a perspective on how productive we are individually being. I look forward to your next report.

Seems worth the data collection.

I wonder how many weeks go by before the average account falls dorment, even for a while, like in my case where I was absent from Steemit for a couple months.

i will be keeping an eye on this in my monthly retention report

Interesting to see an analysis of what new users do. Seeing 20 % of users write at least 10 posts is honestly surprising. To me that's seems pretty decent. Especially considering all the "lurkers" that probably join the site and look around before trying to post themselves.

it appears there are many 'lurkers' but that is okay, more people to read our posts

Coin Marketplace

STEEM 0.17
TRX 0.08
JST 0.023
BTC 26537.82
ETH 1592.45
USDT 1.00
SBD 2.15