Every month I carry out an analysis of Posts made on the steemit platform with the aim of establishing some sort of benchmark that I can work towards and to give you a better understand on Post activity for the month.
As always I have connected to Steemsql using Power BI and the query is used was
SELECT *
FROM Comments (NOLOCK)
where created >= CONVERT(datetime,'11/01/2017')
and created< CONVERT(datetime,'12/01/2017')
and depth = 0
This analysis only looks at Posts, it does not look at comments.
October Report
November Report
The % of posts with <=$1 payout has remained consistent over the two months, however the % of posts that did not achieve a payout has increased from 16% to 19%.
There was also a substantial increase of 23% in the number of posts made in November over the month of October. Yet the total rewards achieved on posts is down 1%.
In Nov 645 posts had a payout value of more that $100 compared to 748 in October. This is a 13% decrease.
Overall the average payout per post for November is $1.76. If we remove all posts that have No payout this increase the average post payout to $2.18
Let’s see how I compare
I must say, I am rather happen with this performance. Although I have 4 less posts this month to last month, my post earning are well up as I had 5 posts earning between $51 and $100.
October Report
November Report
In October 7.21% of posts had a net vote of 0, this has increased to 8.45% in October. There has also been an increase in the number of posts that have a net Downvote. I know 
The number of posts with a net vote of 1 has increased decreased from 11.77% to 9.56%.
The largest gainer this month on vote brackets is the % of posts that have received 11-50 votes. This has increased from 23.11% to 30.76%
How did I do?
To me this is whopper. All of my posts had 51 or more votes. Last month almost 26% of my posts had between 11-50 votes. Also this month I stopped using @Minnowsupport on all of my posts, so I was expecting to see a negative effect from this.
October Report
November Report
The % of posts with 0 comments has increased from 39.47% to 46.32%. There has also been a decrease in the number of posts with 51 or more comments.
In October this was 0.47% and in November is was down to 0.37%. There was also a decrease in the number % of posts with 2-10 comments moving from 32.74% in October to 27.97% in November.
Comments left on my posts
In October 40% of my posts received 11 or more comments. In November 73.9% of my posts received 11 or more comments.
Below are two further charts for your information, the top chart shows the number of posts made each day. We can see the start of the month the number of daily posts was lower than the rest of the month. This may have been down to Steemfest 2. Below that is a chart showing how many new users registered each day on Steemit.
How did your posts preform against these metrics in November? Comment below and share your experience.
I am part of a Steemit Business Intelligence community. We all post under the tag #BIsteemit. If you have an analysis you would like carried out on Steemit data, please do contact me or any of the #bisteemit team and we will do our best to help you... *
You can find #bisteemit on discord https://discordapp.com/invite/JN7Yv7j