I recently just became member of @thesteemengine , and I am glad that I was given this oppurtunity by @ethandsmith for carry out this analysis for #thesteemengine.

If you want to know more about The STEEM Engine, you can read their introduction post.

Outline

• Overall Statistics
• Tags used alongside with #thesteemengine
• Upvotes given by @thesteemengine
• Top Author

Scope of Analysis

Date of the analysis: 08/02/2018
Timeframe of the analysed data: 25/12/2017 - 08/02/2018

Tools

SteemSQL (@steemsql), DataGrip, Tableau

Results

Overall Statistics

Posts	Comments	Upvotes	Payouts
258	3638	13990	3268.2980

The tag #thesteemengine started since 26/12/2017, and up till 8th February 2018, there is 258 posts, 3638 comments, 13990 upvotes and total payouts of $3268.298.

On average, each post has 54.225 upvotes, 14.101 comments and the profitability of #thesteemengine is $12.667821705 (average payout per post).

Total payout includes of paid payout (after 7 days), pending payout, and declined payout.

Statistics break down in weeks

The last data is not the final as it is not the end of the week.

Based on the breakdown of data in weeks, #thesteemengine has grown from 20 posts per week to the peak of 80 posts (last week).

Statistics break down in days

The breakdown in day does not give too much insights about #thesteemengine.

Top 5 tags that used alongside with #thesteemengine

The most common used tags that used alongside with #thesteemengine are the following:

• #teammalaysia (157)
• #steem-cartoon (88)
• #curation (45)
• #ocd-resteem (43)
• #steemiteducation (37)

Votes given by @thesteemengine

@thesteemengine is the curator account for #thesteemengine with more than 3000SP.

Total 1416 votes given out by @thesteemengine (including upvotes and flag).

And the most voted author is @sultnpapper, where 49 of his posts got voted by @thesteemengine.

Top Author

The top contributor of #thesteemengine are being analysed in terms of number of posts and upvotes.

In terms of posts

• @thesteemengine (38 posts)
• @calebleejl (37 posts)
• @maxyong (15 posts)

In terms of payout

• @thesteemengine ($1022.932)
• @calebleejl ($309.959)
• @aurah ($234.386)

Codes

Posts upvoted by @thesteemengine

SELECT
*
FROM TXVotes (NOLOCK)
WHERE
  voter = 'thesteemengine' AND
  timestamp >= CONVERT(datetime,'12/25/2017') AND
  timestamp < CONVERT (datetime, '02/09/2018')

Post with #thesteemengine

SELECT
  *
FROM
 Comments (NOLOCK)
WHERE
     parent_author = '' AND
     created >= CONVERT(datetime,'12/25/2017') AND
     created< CONVERT(datetime,'02/09/2018') AND
     depth = 0 AND
     ISJSON(json_metadata) > 0 AND
     (
          ( JSON_VALUE(json_metadata,'$.tags[4]') in ('thesteemengine') ) or
          ( JSON_VALUE(json_metadata,'$.tags[3]') in ('thesteemengine') ) or
          ( JSON_VALUE(json_metadata,'$.tags[2]') in ('thesteemengine') ) or
          ( JSON_VALUE(json_metadata,'$.tags[1]') in ('thesteemengine') ) or
          ( JSON_VALUE(json_metadata,'$.tags[0]') in ('thesteemengine') )
     )

---

Posted on Utopian.io - Rewarding Open Source Contributors

---