April Steemit Post Benchmarking Report – BlockChain Business Intelligence

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://steemit.com/utopian-io/@paulag/march-steemit-post-benchmarking-report-blockchain-business-intelligence 

Since I produced last month’s report, I have since found out that any posts with a payment of less than $0.02 are not paid out.  This makes a material difference in the comparison on previous month, so I have re-ran the April report for comparison under this criteria

 Repository

 https://github.com/steemit/steem

Financial Performance

April ’17 Report

  

March’18 Report Pre Adjustment

 

March’18 Report Post Adjustment

  

As post with a payout value of less than $0.02 are not paid out, we can see this impacts the March % of posts with no payout, increasing it from originally reported 13.29% to 45.31%.  It also reduces the % of posts with a payout of less than $1 from 69.29% to 37.27%

April ’18 Report

  

In April ’18 the % of posts with No payout was 38.69% down from 45.31% in March.  Although in April ’17 this was 28.76%

The % of posts with a payout of <$1 is up to 38.09% from 37.27% in March.  The number of posts that earned over $500 increased from 13 in March to 86 in April

The average post payout value in April ’18 was $3.18 .In March it was $1.76 SBD, $2.56 SBD in Feb and $3.81 SBD in Jan.  If we exclude posts with no payout the average post payout increases to $5.19 SBD.  In Feb the average post payout excluding post with no payout was $2.03 SBD.  In April ’17 these values were $2.10 SBD and $2.95 SBD.

The number of posts reduced from March 18 to April 18 by 18%, although the payout value increased by 50% for the same period.

However from April ’17 to April ’18 the number of posts increased by 2431% and the total payout value by 3735%

My Stats

 

With 13 less post in April than I had in March, my total post payout is up.  This month I had 6% of posts in the payout range of < $20 SBD and 67% of my posts earned more than $101.  My posts have earned on average $47 which is considerably higher than the average post on Steemit.

Top Authors based on payouts

  

From this report we can see that many of the top earns from last month are still on the list.  

Top Category’s

 

The top category remain the same as last month, however Dlive has now taken second place pushing life into third. There is some movement between the remaining categories.

Comments

April ‘17

 

Mar ‘18

 

April ‘18

  

The % of posts with no comments is down on March and is for April was 41%.  This has been offset with the % of posts with 1 and between 2-10 comments.

From April ’17 to April ’18 the % of posts that received no comments increased from 40% to 41%.

My Stats

   

In April 90% of my post received 11+ comments. Last month I was a little disappointed in the engagement levels on my posts but this month 30% of my posts received 51+ comments.  One posts even received more than 100 comments.

Votes

April ‘17

    

March ‘18

    

April ‘18

  

The % of posts with 0 net votes has reduced from 7.6% in March to  5.3% in April. However this was only 0.88% in April ‘17.  

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

My Stats

     

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

Other Data

    

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

April saw a general uptrend trend in the number of posts made per day.

Conclusion

As the price of STEEM and SBD had a nice rise April, this has had a direct impact in the worth of a vote and so the financial performance of posts.

Last month I found it very interesting that the average number of posts per day fell in April although we have a very high month with new accounts registering. The average number of posts per day also feel in Feb.  I wondered if this is directly related to the price of STEEM and SBD as people are not earning the same?  This month we seen another decrease in the number of posts, along with a decrease in the number of new users to the site.  And we see this with a price increase.  Kind of means my questions from last month are answered.

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

https://steemit.com/utopian-io/@paulag/april-18-new-steemit-user-report-blockchain-business-intelligence

With regards to my own data, I am really happy to see the increase in engagement as the drop was concerning last month.

So how did your posts preform in April ’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-04-01')     and created< CONVERT(DATE,'2018-05-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-04-01')     and created< CONVERT(DATE,'2017-05-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