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](https://res.cloudinary.com/hpiynhbhq/image/upload/v1520528946/wvo137kkjdaujfqdbrap.png)

**Jan ’18 Report**

https://res.cloudinary.com/hpiynhbhq/image/upload/v1518040186/h0truseuz5cseai1rez4.png

**Feb ’18 Report**

![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1520529079/nyamek8sn3uv71ebwul9.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](https://res.cloudinary.com/hpiynhbhq/image/upload/v1520529141/r788tyvxqpp95gl8dyjb.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](https://res.cloudinary.com/hpiynhbhq/image/upload/v1520529177/horshabvznrqdfrpbot6.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](https://res.cloudinary.com/hpiynhbhq/image/upload/v1520529209/cpybzn73g0hwp47tzo1n.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](https://res.cloudinary.com/hpiynhbhq/image/upload/v1520529255/gzvyv9t1voxyrhjsnpb7.png)

**Jan ‘18**

https://res.cloudinary.com/hpiynhbhq/image/upload/v1518040240/pkel7mqu6wwravsfng3j.png

**Feb ‘18**

![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1520529297/o3cttb1cchd85evoxqwo.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](https://res.cloudinary.com/hpiynhbhq/image/upload/v1520529485/wxmbkoptcukhipudbycb.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](https://res.cloudinary.com/hpiynhbhq/image/upload/v1520529543/lk4xmcnibnumarskbo1m.png)

**Jan ‘18**

https://res.cloudinary.com/hpiynhbhq/image/upload/v1518040287/gmfsezhzyyo6rfhibt6a.png

**Feb ‘18**

![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1520529558/nf9eea14w8cgl72kvw5m.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](https://res.cloudinary.com/hpiynhbhq/image/upload/v1520529586/mddbgqw0vj6eaqonjlsx.png)

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

## Other Data

![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1520532055/zxye07zocucqoy6xoalb.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




<br /><hr/><em>Posted on <a href="https://utopian.io/utopian-io/@paulag/february-2018-steemit-post-benchmarking-report-blockchain-business-intelligence">Utopian.io -  Rewarding Open Source Contributors</a></em><hr/>