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

Last month I added to new data to the report, which included a comparison on the same period last year and also the top earning authors for the reporting period. This month I have also improved this report and have added a list of Authors sorted by highest average number of votes per post and more comparisons on same period last year

Financial Performance

Feb ’17 Report

image.png

Jan ’18 Report

Feb ’18 Report

image.png

In February ’18 the % of posts with No payout was 11% almost identical to Jan ’18. Although in Feb ’17 this was 37.45%

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

The average post payout value in February ’18 was $2.56 SBD down from $3.81 SBD. That’s a 32% reduction. If we exclude posts with no payout the average post payout increases to $2.87 SBD. In Jan the average post payout excluding post with no payout was $4.28 SBD. In Feb ’17 these values were $4.02 and $6.43

The number of posts reduced from Jan 18 to Feb 18 by 4%, although the payout value reduced by 35% for the same period.

However from Feb ’17 to Feb ’18 the number of posts increased by 3730% and the payout value by 2338%

My Stats

image.png

With 4 less post in Feb than I had in Jan, my post payout is down 33%. This month I had 46% of posts in the payout range of $2 SBD to $10 SBD. 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 $41.

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 45% and the second highest earner is down 35%.

Top Category’s

image.png

The top 3 categories remain the same as last month and there is some movement between the remaining categories. Life Art and Food were the top 3 categories in Feb 17.

Comments

Feb ‘17

image.png

Jan ‘18

Feb ‘18

image.png

The % of posts with no comments remained consistent with Jan at 45%. There is a small offset between the % of posts with 2-10 comments and 1 comments but more or less Jan and Feb % for comments remain consistent.

From Feb ’17 to Feb ’18 6.5% more posts received no comments, this is offset with the 6% on postst that get 2-10 comments

My Stats

image.png

Last month 90% of my post received 11+ comments, this has dropped to 88%. Again I am not surprised as I mentioned above that some of my content for February was different to what I normally post.

Votes

Feb ‘17

image.png

Jan ‘18

Feb ‘18

image.png

The % of posts with 0 net votes remained consistent with Jan at 6% however this was only 0.08% in Feb ‘17. Posts with a net down vote decreased from 1% to 047%.

The average number of votes per post in Feb ‘18 was 12.75 down from 83 in Feb ‘17

My Stats

image.png

Awesome 99% of my posts received 51+ votes without the use of voting bots

Other Data

image.png

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

Comparing this to last month, the trend for the month was up for the number of posts per day. Feb saw a general downwards trend.

Conclusion

It is worth pointing out at this stage that the average price of STEEM was considerably lower in Feb 18 as to Jan 18 and this has had an impact on the values above. There is also a worrying trend
So how did your posts preform in Feb ’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-02-01')
 and created< CONVERT(DATE,'2018-03-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-02-01')
 and created< CONVERT(DATE,'2017-03-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

H2
H3
H4
Upload from PC
Video gallery
3 columns
2 columns
1 column
7 Comments