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

in #steemit4 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

I love the stats and most the one about comments , sadly most of them are f4f , vote me etc :)

Lol I will be looking at that too in a future post @patelincho. Thanks for stopping by

Is cool to look at this numbers acording to the situation in steemit :)

Very informative thanks!
It's always nice to see such a nice community like this one to grow.
Keep up the work.

Thanks for the data @paulag.

I'm not going to lie and say that these metrics are crucial to me, but, your point about including a web site in my profile made me realize that I should.

Even if it's not germane to my blog on Steemit, it should help to send some link love to my wife's web site (and I am responsible for that).

It just goes to show that you never know where inspiration is going to come from.

thank you @theblindsquirl. The backlinks are really good for seo!

I'm not sure how well a Steemit blog compliments a bankruptcy attorney but it shouldn't hurt the rankings. ;-)

A great post indeed Lady Paula, I think I have our website on my profile and we run The Papillon Foundation Charity. @papilloncharity The other use that I found here is the best days to post, although I try to post every day. Of course time differences matter as we are in South Africa. I have a question for you! If I have almost 200 followers and I post quality and original material, why do the followers not vote? I have a max of 15 votes? I saw the same thing on tsu where we had almost 5000 followers, but our maximum vote was 200 votes?

There are a number of reasons people don't vote. If your followers are following a lot of people then they might not even see your post. i think the algorithm for the trending page should be changed to help with this

Now you are talking Chinese to me Lady Paula! An "algorithm" I can find the word in my dictionary. but what does this have to do with my post to get it trending? Beware, I was the only one in my maths class that was older than the teacher Lol.

Apologies! I almost forgot! Upvoted!

Awesome information. I appreciate the time and detail that went into creating this analysis. Thank you for sharing!

you are most welcome

Congratulations @paulag! You have completed some achievement on Steemit and have been rewarded with new badge(s) :

Award for the number of upvotes

Click on any badge to view your own Board of Honor on SteemitBoard.
For more information about SteemitBoard, click here

If you no longer want to receive notifications, reply to this comment with the word STOP

By upvoting this notification, you can help all Steemit users. Learn how here!

Correctly dispensed reports with explanations .. keep them coming ...

thanks utfull

Congratulations! This post has been upvoted from the communal account, @minnowsupport, by paulag from the Minnow Support Project. It's a witness project run by aggroed, ausbitbank, teamsteem, theprophet0, and someguy123. The goal is to help Steemit grow by supporting Minnows and creating a social network. Please find us in the Peace, Abundance, and Liberty Network (PALnet) Discord Channel. It's a completely public and open space to all members of the Steemit community who voluntarily choose to be there.

If you like what we're doing please upvote this comment so we can continue to build the community account that's supporting all members.

I love stats because they empower decision making IF they respond to the right questions. I would like see more stats related to STEEM and steemit business. For example, what is the trend of users leaving the system (inactive for more than x amount of time)? Then compare it to crypto market trends, you'll find interesting surprises.

love the idea. Yes the right questions need to be asked when it comes to business intelligence.

I need to start keeping track of all of these suggestions. I am new to steemit and crypto so I dont hold all the questions...although I could get most of the answers

What about all the fake accounts use only as bots to upvote real profiles? I found quite a few, and this seem to me such an unfair way of using steemit...

yes this is somthing I am also going to look at. There are so many analysis that I want to do..... its just finding the time

I really enjoyed reading your analysis and appreciate it. I am new newbie on steemit and trying to understand such the huge and interesting community. Literally telling i really loved. One thing i have noticed that the people with good SP do neglect the newbies. Why? Instead, they should encourage all new users . I wonder, why don't the understand the pain of new users, though they had passed through this stage.