How well do Blog Posts Really do on Steemit – Analysis SteemitSQL DatabasesteemCreated with Sketch.

in #steemit6 years ago

Debunking a Myth

As a data enthusiast, and with the aid of awesome tools like Power BI and Excel (as I can’t program to save my life, not even a tad bit of SQL) I know that the block-chain holds information that can easily be turned into actionable business insights. 

So following on from my previous Steemit Database analysis, I have decided to gather more business intelligence and establish how well posts really do here on Steemit.  How many posts get votes?  How many posts don’t make a dime? How many post create real engagement via comments? What are the chances of having a ‘Successful’ post on Steemit?

If you are on Steemit because you think you can make a quick few pounds think again.  If someone told you to join Steemit because they made money and you can too, it’s easy.  Then think again.

Yes there have been people that have made considerable sums on Steemit, but I am hoping with this data we can debunk the myth that Steemit is an easy platform to succeed on with very little work….

I have taken the Comments posted table from the Steemit SQL held and managed by  @arcange   (thanks you rock)  The dates for which I have analysed are 1 July 17 to 23 July 2017 at 22:08 GMT.

During this time there were 377,880 Blogs.  This is the number of new articles or posts written, NOT Comments…..

What's the chances a post will actually create engagement, conversation & comments?

Over 123K blogs have no response at all.  No comments, no feedback. Do keep in mind that included in these blogs are blogs made within a few seconds of the report, so many not have had a chance to get comments.  I will run this report again 7 days after month end to see if there is much of a change.

Have a look at the table below. A considerable number of blogs have only 1 comment.  I would how many of these comments are made by bots, such as minnowsupport or comments from Randowhale?  This is something I would like to look at in a further analysis.  I will try and include this in the month end report.

11 to 20 comments is where I would like to aim.  I would consider myself successful on creating a content engaging post if I got this amount of comments.  Where would you consider yourself successful?   Let’s face it, blogs at this level are doing better than 90% of all blogs made.

What about Votes?  

 To some Votes would be the most important factors for success on Steemit.  But I have some bad news for you.  Based on the data taken, you have a bigger chance of being downvoted than you have of getting more than 500 votes.  But hay, the news is not all that bad! 

Have a look at the table below

It’s easy to see that the vast majority of posts have received between 2 and 10 votes.

Nice to see 13,297 really honest blogs where the creator did not self-vote.

I am finding myself now at about 51-100 votes per post.  To be honest, I personally don’t count votes as a success factor here on Steemit.  Why well because many people will vote without reading.  There are trails you can follow that will auto vote for you based on other steemers votes.  What votes do contribute for me is social proof.  The more votes you see on a post, the more likely you are to read it right!  Social proof is important, but in my little head, it is a contributing factor in success but not a measure.


Financial Success on Steemit

Those that are in Steemit for a quick quid, then this section is important to you.

 Let me break the bad news to you.  Less than 1% of blogs have a payout of more than $100.  The number of blogs that have made nothing is the same as the number of posts that have made between $11 and $100.  That’s nuts.  And a whopping 256K blogs have only made between $1 - $2


Most of my blogs are now between $2 and $10.  This places my blogs in the top 20%.  My target for success is between $51- $100. Looks like I still have a lot of work to do.

What’s your target?


This analysis serves as a bench marking tool.  I have not taken into consideration the correlation between no of votes, comments and payout.  Nor have I discussed followers as a measure of success and correlation, which with traditional online marketing, is something I would track.

What I think from reading this analysis it is clear to see, with the majority of posts having less than 10 votes and less than a $1 payout, Steemit is not a get rich scheme.

Success, well that depends on your goal……I hope you will share them below 

Interested in my other Analysis:

I blog about Excel, Power BI, Business, Business-Intelligence ,blogging, Steemit and things of interest.  Steem on and Follow me!


Thank you for putting all of this together @paulag. For the last few days, I've noticed a few bots hitting the photo and travel sections, fishing for up votes by leaving generic 'wow, beautiful pic' like comments.
I'm hoping these scammers somehow get weeded out of course, but the reason I say this is that they're distorting all stats re steemit as a whole, and wasting the time of posters who reply, thinking they may have a genuine fan.
So, I was wondering, since I can't do the kind of stuff you can, whether it's possible to compile a list of steemians who comment the most to get a general idea of who these bots are, so we can mute them based on their thousands and thousands of comment and no up vote histories?

Start flagging them. I have and have noticed some of the accounts rep levels dropping fast. It's going going to get a lot worse unless we do something about it.

@steemmeupscotty yes i can do something to try and work this out. leave it with me

Honestly - that would be fab! And would save us all much time, voting power, and peace of mind. Thank you!

Nice - and yes, as @rt395 said, just flag them and tag @steemcleaners - eventually when they learn that these useless comments from their auto-posting bots aren't going to buy them that yacht, they'll find somewhere else to go and try find riches through being unproductive. :)

I just ignore them and tell any newbies I come across to do the same.

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: First 7 weeks of xx-votesplus: YOUR dropAhead Curation Team!

Very interesting, thank you for sharing. Would be great to find out about the success of blogs linked to the size of the post.

This is something I was thinking too. Need to do some text analytics

Great info. have you done any other topic breakdowns?

I have only really started analyzing the database.....I have done a few posts but plenty more to come

Very informative read. Puts a lot of things right in my head. Thank you for doing the hard work and sharing.
Cheers !!!

You are most welcome

If you are on Steemit because you think you can make a quick few pounds think again. @naz722

When you are counting votes, is it a net count where downvotes count as negative?

yes, I have counted the number of votes where the net votes is <0

So for example, some of the posts with total 0 could be 1 upvote and 1 downvote?

Ah, I have not caught I have just taken the net votes

These are some interesting stats. Thank you for the info. I feel better knowing I'm doing alright on Steemit compared to all users.

Thanks for the analysis. It's interesting to see it broken down.

Awesome post! Loved how you analysed the data and presented your findings. You just got yourself a loyal follower.

Coin Marketplace

STEEM 0.17
TRX 0.08
JST 0.023
BTC 26569.18
ETH 1593.67
USDT 1.00
SBD 2.15