March Steemit Post Benchmarking Report – BlockChain Business Intelligence

in #utopian-io6 years ago (edited)

Every month I produce a Post benchmarking report with the aims of:

• Aiding the Steemit Community with a place to benchmark their posts and growth

• Create a report that can be used for comparisons in other periods

• To track my personal targets and record achievements

Over the last few months I have added new data to this report, including comparisons to the same period last year, top earn authors and authors with the highest number of votes.

If you missed last months full report you can read it here:
https://utopian.io/utopian-io/@paulag/february-2018-steemit-post-benchmarking-report-blockchain-business-intelligence

Financial Performance

March ’17 Report

image.png

Feb ’18 Report

image.png

March ’18 Report

image.png

In March ’18 the % of posts with No payout was 13% up from 10.8% in Feb. Although in March ’17 this was 24.6%.

The % of posts with a payout of <$1 is up to 69.29% from 68.37% in Feb. The number of posts that earned over $500 reduced from 41 in Feb to 13 in March.

The average post payout value in March ’18 was$1.76 SBD down from $2.56 SBD in Feb and $3.81 SBD in Jan. If we exclude posts with no payout the average post payout increases to $2.03 SBD. In Feb the average post payout excluding post with no payout was $2.87 SBD. In March ’17 these values were $2.62 SBD and $3.48 SBD.

The number of posts reduced from Feb 18 to March 18 by 10%, although the payout value reduced by 38% for the same period.

However from March ’17 to March ’18 the number of posts increased by 2472% and the total payout value by 1627%

My Stats

image.png

With 9 more post in March than I had in Feb, my total post payout is down 33%. It was also down 33% from Jan to Feb. This month I had 55% of posts in the payout range of $2 SBD to $10 SBD. As mentioned before I was expecting to see this as I have been trying some new types of content on Steemit. My posts however still earn on average $20 which is considerably higher than the average post on Steemit.

Top Authors based on payouts

image.png

From this report we can see that many of the top earns from last month are still on the list. However the top earner is down 56% and the second highest earner is down 37%.

Top Category’s

image.png

The top 2 categories remain the same as last month and there is some movement between the remaining categories.

Comments

March ‘17

image.png

Feb ‘18

image.png

March ‘18

image.png

The % of posts with no comments remained consistent with Feb at under 45%. More or less Feb and March % for comments remain consistent.

From March ’17 to March ’18 the % of posts that received no comments increased from 39% to 44%.

My Stats

image.png

Last month 88% of my post received 11+ comments, this has dropped to 51%. Again I am not surprised as I mentioned above that some of my content for March was different to what I normally post. However I am a little disappointed with the engagement levels and intend on reviewing some of the posts to see how I can improve this.

Votes

March ‘17

image.png

Feb ‘18

image.png

March ‘18

image.png

The % of posts with 0 net votes has increased from 6.7% in Feb to 7.6% in March however this was only 0.44% in March ‘17.

The average number of votes per post in March ‘18 was 15.23 up from 12.75 in Feb 18.

My Stats

image.png

Awesome 100% of my posts received 51+ votes without the use of voting bots. Go girl. Could not be happier.

Other Data

image.png

The line chart above represents the number of new posts per day in March 19 and the bar chart below that shows the peak posting hours.

March saw a general downwards trend in the number of posts made per day.

Conclusion

As the price of STEEM and SBD continued to fall in March, this has had a direct impact in the worth of a vote and so the financial performance of posts.

I did find it very interesting that the average number of posts per day fell in March although we have a very high month with new accounts registering. The average number of posts per day also feel in Feb. I wonder if this is directly related to the price of STEEM and SBD as people are not earning the same, although I posted more myself!

If you missed the report on new users for March you can check it out here

I would also like to mention the rise of Dlive now positioned in the top three tags in terms of gross post payout.

With regards to my own data, happy to see the average number of votes per post is up, but at the same time I am a little concerned as the level of engagement by way of comments is down. That could indicate more people vote for my content with some sort of auto vote and are not actually reading it. I think improving the engagement is where I need to put some effort in for the month of April and hope to improve on the comments stats.

So how did your posts preform in March ’18 ? - Please do comment below and let me know.

The Datasource and Query

As always I have connected to Steemsql managed by @arcange using Power BI and the query is used
for 2018 data was

 SELECT
     author,
    category,
     created,
     children,
     total_payout_value,
     net_votes,
     pending_payout_value
     FROM 
     Comments (NOLOCK)
      where created >= CONVERT(DATE,'2018-03-01')
     and created< CONVERT(DATE,'2018-04-01')
    and depth = 0

And 2017 query was

SELECT
    author,
    category,
    created,
    children,
    total_payout_value,
    net_votes,
    pending_payout_value
     FROM 
    Comments (NOLOCK)
    where created >= CONVERT(DATE,'2017-03-01')
     and created< CONVERT(DATE,'2017-04-01')
    and depth = 0

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 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

Sort:  

Thank you for the contribution. It has been approved.

You can contact us on Discord.
[utopian-moderator]

Hey @crokkon, I just gave you a tip for your hard work on moderation. Upvote this comment to support the utopian moderators and increase your future rewards!

it's good that you track engagements in your posts @paulag.. as your follower and avid fan, i read and engage.

i'm interested in how you are retrieving data from the blockchain.. i know from experience that the dashboards seem to be built on PowerBI. please correct me if that is not accurate.

Yes i use powerbi. If you join blockchainbi on discord i can help you out with that

Sangat menarik untuk di baca, ini adalah laporan yang sangat detil, resteem untuk sesuatu yang luar biasa 😊

Good work, nicely done the analysis will help the community and users

329 posts in a month.. ugh...

March 2017 Votes

March 2018 Votes

This is pathetic. Completely ignoring the fact that Downvotes have declined as a percentage of total votes, it's clear that active curation across the platform has drastically declined.

  • 1 vote per post went from 0.51% of total votes to 13.29%. Mathematically, that's more than a 2600% increase! Indicating a significant decline in voter participation.
  • 2 to 10 votes per post went from 11.97% of total votes to 50.25%. Nearly a 420% increase! Another indication of declined voter participation.
  • 11 to 50 votes per post went from 42.49% of total votes to 22.10%. A decline of approximately 192%.
  • 51 to 100 votes per post went from 24.79% of total votes to 4.03%. A decline of more than 615%.

I don't care how many new users are joining Steem(it), or the number of daily active users anymore. These are clear signs of a drastic shift in how the community participates and how much the community cares about each other / the growth of the platform.

I'm not surprised by the numbers, but I'm surely disheartened.

I think this comparison on votes for the same period last year is alarming, however much has changed on Steemit and this include audience choice and what is being posted. As the content type expands it will take some time for the level of curation to also increase as steemit did not come with a ready made audience for all the content types we have now.

I am not overly concerned yet!

So how did your posts preform in March ’18 ?

I would be interested to know @paulag but wouldn't know where to begin with any analysis. What I an say though is engagement is definitely down and has been declining in line with the price of Steem.

I've not been here that long but a number of the people I had conversations with when I first joined (Dec/Jan) are no longer posting yet alone engaging on my content.

I'm also interested by the Top Authors based on payouts payouts. I'd love to know if the top author is down by 56% because of the price of Steem/SBD or because of the Stewards of Condors guy's crusade. Perhaps a bit of both.

It would be interesting to see all the stats if there was some way of equalising the value of Steem. Then it might be easier to compare what is actually going on rather than the figures being lower because Steem is lower.

I'm not convinced your fall in engagement is due to your testing different content because, as I mentioned, it looks to me that engagement is down across the platform.

Wishing you a fun week!

retention rates on Steemit are very low and this is a problem. But I am glad to say there are many communities now trying to tackle this problem head on.

The top author being down, well stewardsofgondor have a lot to do with it, but so does the price of Steem, so it is a combination of both.

I'm guessing that most of the people who I was in conversation with in December and January who are no longer posting or engaging will be back when Steem goes back up. They weren't newbies and were able to get good returns whenever they posted. But only time will tell. 😊

I'm killing it! :-)

7d.png

If my memory serves me correctly, I don't think that I've ever had a post with more than $1.76 SBD payout (the average for this month).

I believe that the average payout per post in the betting category is much lower than the average in general. Betting is not a popular/profitable niche here.

I don't expect to earn money here, but I'm taking my earnings on steemit as a kind of game I play. See what I can do to up my SP,... There are two reasons I'm here:

  1. Community - surprisingly, steemit has some fine professional bettors sharing their knowledge here.
  2. Public record - I'm working on a prediction model and I'm posting its performance(profitability) here. The blockchain tech allows me to have a permanent, public, and verifiable performance record. If my model shows a consistent profitability I may turn it into a product and having a verifiable track record can be useful in marketing purposes.

If I were to use steemit to make money, I'd invest in STEEM and create my upvote bot.

arghhhhh no, not an upvote bot :-(

but besides that I am glad you mentioned Community as number 1, because I really think that is key

If you're here for the money, what is more profitable than running a bot (or delegating SP to one)?

I think that it is both dishonest and misleading to push the great content will make you money story onto newcomers. They are not idiots, they're just new and soon enough they'll see that their post into which they put their heart and soul (and a lot of time) isn't making them money. What's worse, their post isn't getting any views.

The way the steemit's economic model works, you either get lucky and end up supported by some big accounts (whales, curation guilds,...) or you invest into buying upvotes. I'm sure, you can find a few cases that will go against what I've just written but just look at the numbers you've posted.

Do you think that all those one upvote posts are pure garbage, not worthy of more? The majority of it probably is, but there are certainly some gems that would be on the trending page earning $xxx if the quality content was the secret to making money here.

I don't like the rape of the reward pool made possible by the bots, but I don't like the quality content lie either. We should be honest about how things work around here and vocal about how to improve this platform and make it live up to its ideal (the great content getting the reward it deserves).

A newbie is bombarded with the following formula for success on steemit:

  1. write a great post
  2. hit publish button
  3. ???
  4. profit

All the while the pros are doing this:

  1. Write something, anything really
  2. Buy $xxx of upvotes
  3. Claim your author reward in 7 days

This is not me attacking you, this is just me calling for an honest discussion. What I propose is to be open about how things work around here and when a newbie asks how to earn money we should present him with all the options and point out that the upvote bots are the only tool that can guarantee them visibility. All the other options have a rather large element of luck.

Do I like it? No. Do I want the ideal of steemit to be true? Yes. Do I know how to make it so? No, and I don't see anyone with a concrete proposal that would work and prevent the abuse.

So here we are... a lot of words that won't change a damn thing

an honest discussion - bidbots will destroy Steemit if allowed. I am 10 years monetizing content online, its all I do :-) and I make a really good living from it. I don't use bots.

what you have said shows the major expectation gap on steemit. That you should come to steemit, make a post and make a load of money in the process. I have said before and I will say again, the person that becomes know as an overnight success has really worked a 70 hour week for the last number of years. There is no such thing as an overnight success and if you are here for the money, well it can be made with good content, consistency and time.

I agree with you on both counts.

There should be some pressure from the community on the bidbots owners to keep them under control.

There is no such thing as an overnight success and if you are here for the money, well it can be made with good content, consistency and time.

It can, but as a betting man, I wouldn't put my money on it. You have the numbers in front of you, I know you wouldn't either.

what you have said shows the major expectation gap on steemit.

And that gap is something created and promoted to this day by the community. All I'm saying is that the community should ease up on selling the dream and be honest about the state of things. A newbie should know that he or she has like 1 in 1000 chance to make money with good content and consistency, and 1 in 10 with money invested in buying upvotes. That's all.

As far as I know, almost everybody is here for the money to the varying degrees. If you could by some magic remove the money aspect for a month you know what would happen... In a month I'd leave you a comment: "I told you so" :-)

Hey @paulag I am @utopian-io. I have just upvoted you!

Achievements

  • People loved what you did here. GREAT JOB!
  • Seems like you contribute quite often. AMAZING!

Utopian Witness!

Participate on Discord. Lets GROW TOGETHER!

Up-vote this comment to grow my power and help Open Source contributions like this one. Want to chat? Join me on Discord https://discord.gg/Pc8HG9x

Coin Marketplace

STEEM 0.19
TRX 0.16
JST 0.032
BTC 63598.38
ETH 2746.61
USDT 1.00
SBD 2.65