Looking at the numbers from Steemhunt - Dig Products, Earn STEEMs // February - May 2018

Source: www.steemhunt.com

Repository

https://github.com/Steemhunt

Introduction

Steemhunt is platform where you discover cool products and get rewards by STEEM.
You can surface new products, upvote and comment on them, and most importantly, you will be rewarded with STEEM tokens for your contribution.

Outline

• Scope
• Results
• Findings 1
• Findings 2
• Findings 3
• Conclusion
• Tools and Scripts

Scope

Date of the analysis: 25th June 2018
Time frame of the analyzed data: January to May 2018
Components of the analysis: Analyzing users and post made from Steemhunt

Results

ACTIVE USERS
Steemhunt was officially launched on 5th March 2018 but the first posts were made in February. The vision was a community-generated leaderboard that rewards people for sharing and upvoting cool new products, run on top of the STEEM blockchain.

https://steemit.com/steemdev/@steemhunt/introducing-steemhunt-daily-ranking-of-effortlessly-cool-products-fueled-by-steem-blockchain

Between February and May 2018, there were 2,977 post from Steemhunt app with unique 299 authors contributing. That is an average of 10 post per user. In order to find "active users" we would look at users who made at least one post a month through the Steemhunt app

Since Steemhunt was officially launched in March 2018, only 8.36 % of authors can be termed as 'active' and have made contribution at least once every month between March to May 2018. With a large chunk (82.94%) only making contributions in one month only

POST/COMMENTS INTERACTIONS

depth = 0 and depth > 0 was used to filter comments and posts.
The app used was filtered from the json_metadata

Between when Steemhunt was launched in March, no comment was recorded via Steemhunt until May. In May, there were 5,751 comments on post made via Steemhunt and 3,784 of this comments were made via Steemhunt representing 65%

MONTH	TOTAL COMMENTS	COMMENT VIA STEEMHUNT
Feb	20	-
Mar	1136	-
Apr	1281	-
May	5751	3784

GROWTH OF STEEMHUNT

MONTH	AUTHORS	NO OF POST	COMMENTS	NET VOTES	PAYOUT	AVG STEEM PRICE
Feb	1	4	20	12	$7.645	$4.03
Mar	100	537	1136	5423	$924.11	$2.37
Apr	51	674	1281	7901	$2186.972	$2.70
May	222	1762	5751	30902	$7654.537	$3.10

STEEM price was evaluated from https://coinmarketcap.com/

All indices points to steady growth in Steemhunt activities except for Steem price which has affected the payout from post, with a higher steem price the payout would have been higher. Only 255 Posts (8.5%) out of 2799 post had $0 payout when compared to 43% in Steepshot while 62.8% of post earned less than $2 in payout compared to 90% in Steepshot

Findings 1

Steemhunt is new but growing at a reasonable rate.

Findings 2

With steemhunt, a lot of known and unknown 'cool' applications have been discovered as users are required to dig up applications that make life easier/fun.

Findings 3

The number of comments via steemhunt is quite impressive.

Conclusion

It can only get better for Steemhunt, over the last few weeks they have made an impact in the steem blockchain. More STEEM POWER delegations, more awareness would be created about steemhunt and further growth would be experienced.

And with the recent support from Utopian-io i predict an increase in authors contributing and payout.

Tools and Scripts

Microsoft SQL Server Management Studio 17 was used to access the data from STEEMSQL ( a publicly managed database by @arcange )

Microsoft Excel and Power BI was used to plot graphs and Charts.

SCRIPTS

SELECT
author,
created,
json_metadata,
(JSON_VALUE (json_metadata,'$.app')) AS App,
children,
total_payout_value,
net_votes

FROM COMMENTS (NOLOCK)
WHERE 
depth = 0
AND
created>= CONVERT(datetime,'2/01/2018') AND created< CONVERT(datetime,'6/01/2018') 
AND
IIF(isjson(comments.json_metadata) = 1, IIF(CHARINDEX('/', json_value(comments.json_metadata, '$.app')) > 0, SUBSTRING(json_value(comments.json_metadata, '$.app'), 1, CHARINDEX('/', json_value(comments.json_metadata, '$.app'))-1),json_value(comments.json_metadata, '$.app')), null) = 'steemhunt'

Proof of Authorship

https://github.com/jingis07