#recordpool Weekly Analysis Report #1 (Weekly Contest #4)
This is my first weekly report for #recordpool tag. The analysis is carried out in order to understand the growth of #recordpool , and the analysis will helps #recordpool hosts to choose the winners for "Weekly Roundup Contest".
You can read more about "Weekly Roudup Contest" at 'Steemit Record Pool' New Community Contest Update! Curate Music & Win Weekly Whaleshares & Hairshares! by @djlethalskillz
STEEMIT RECORD POOL is a community-based medium that offers the opportunity to share music with more listeners.
This initiative was developed by fellow passionate music lovers, @djlethalskillz and @vandigital, with the goal of bringing all our favorite music to one convenient source -- the Steemit Record Pool.
this is the official Steemit Record Pool statement
description credit to @djlethalskillz
Outline
- Tools
- Results
- Overall Statistics
- Montly Statistics
- This week Statistics
- Post of the week (Top 10)
- Most upvoted post
- Most commented post
- Post of the week (Top 10)
- Sample Codes
Scope of Analysis
Timeframe:
- Overall Statistics and Montly Statistics (11/2017 -> Now)
- This week statistics (29/01/2018 -> 04/02/2018 6pm)
Date of Analysis: 04/02/2018 6pm (GMT +8)
Tools
- SteemSQL (An SQL server to extract out Steem blog post data)
- DataGrip to extract out SQL data
- Mac app Pages for data visualize
Results
Overall Statitics
Author | Posts | Comments | Upvotes | Total_Payouts | Author_Payouts | Pending_Payouts |
---|---|---|---|---|---|---|
73 | 612 | 2397 | 11185 | 2414.4370 | 1779.3270 | 235.6610 |
Until today, there is 73 authors had published under #recordpool with a total of 612 posts, 2397 comments, 11185 upvotes, $2414.437 of steem in terms of payout, and the pending payout of $235.661.
Montly Statistics
Month | Posts | Comments | Upvotes | Total_Payouts | Pending_Payout |
---|---|---|---|---|---|
10 | 8 | 72 | 434 | 35.0400 | 0.0110 |
11 | 135 | 585 | 3164 | 262.2710 | 0.0000 |
12 | 142 | 491 | 3377 | 659.6810 | 0.0260 |
1 | 296 | 1161 | 3849 | 1457.4450 | 166.9400 |
2 | 31 | 88 | 361 | 0.0000 | 68.6840 |
The tag #recordpool had started since October 2017 and had gain a lot of attention in the music community back in January last month.
This Week Statistics
This week which is 29/01/2018 until 04/02/2018 6pm, the analysis are followed. The weekly statistics is done to check this week performance in terms of number of post, upvotes, comments and pending payout.
Posts | Comments | Upvotes | Pending_Payouts |
---|---|---|---|
67 | 163 | 857 | 195.7860 |
For this week, there is 67 posts that contains #recordpool , 163 comments, 857 upvotes and the pending payout is $195.786 steem.
Top 10 Posts of the week
Most upvoted post
Most commented post
Sample Codes
- Overall Statistics
SELECT
COUNT(DISTINCT author) AS Author,
COUNT(*) AS Posts,
SUM(children) AS Comments,
SUM(net_votes) AS Upvotes,
SUM(total_payout_value) AS Total_Payouts,
SUM(total_payout_value) - SUM(curator_payout_value) AS Author_Payouts,
SUM(pending_payout_value) AS Pending_Payouts
FROM Comments(NOLOCK)
WHERE
parent_author = '' AND
created >= CONVERT(datetime,'10/01/2017') AND
created< CONVERT (datetime, '02/05/2018') AND
depth = 0 AND
json_metadata LIKE '%"recordpool"%'
- Montly Statistics
SELECT
MONTH(created) as Month,
COUNT(*) AS Posts,
SUM(children) AS Comments,
SUM(net_votes) AS Upvotes,
SUM(total_payout_value) AS Total_Payouts,
SUM(pending_payout_value) AS Pending_Payout
FROM Comments (NOLOCK)
WHERE
parent_author = '' AND
created >= CONVERT(datetime,'10/01/2017') AND
created< CONVERT(datetime,'02/05/2018') AND
depth = 0 AND
json_metadata LIKE '%"recordpool"%'
GROUP BY
month(created)
- This Week Statistics
SELECT
COUNT(*) AS Posts,
SUM(children) AS Comments,
SUM(net_votes) AS Upvotes,
SUM(pending_payout_value) AS Pending_Payouts
FROM Comments (NOLOCK)
WHERE
parent_author = '' AND
created >= CONVERT(datetime,'01/29/2018') AND
created< CONVERT(datetime,'02/05/2018') AND
depth = 0 AND
json_metadata LIKE '%"recordpool"%'
Top 10 post
SELECT TOP 10
'@' + author AS Author,
title + ' (https://steemit.com' + url + ')' as Title,
net_votes as Upvotes,
children as Comments,
pending_payout_value as Pending_Payout
FROM Comments (NOLOCK)
WHERE
parent_author = '' AND
created >= CONVERT(datetime,'01/29/2018') AND
created< CONVERT(datetime,'02/05/2018') AND
depth = 0 AND
json_metadata LIKE '%"recordpool"%'
ORDER BY
Upvotes DESC
Posted on Utopian.io - Rewarding Open Source Contributors
Your contribution cannot be approved because it is not as informative as other contributions. See the Utopian Rules. Contributions need to be informative and descriptive in order to help readers and developers understand them.
Dear @superoo7, I'm sorry, I'm rejecting your contribution because it is not as detailed as other analysis contributions. Especially the scope of your work is too narrow to accept this as an analysis for the
steemit/steem
open source project. I like the community effort of #recordpool, but with the current activity and user base this is very small in relation to the Steem network and does not bring owncode/implementations. I'm sure your analysis is very valuable for the #recorpool community, but at this stage utopian is not the right platform for weekly reports about it.
You can contact us on Discord.
[utopian-moderator]
Hey @crokkon , thanks for your feedback. I understand that you cannot approve this post and I am okay with it. Thanks a lot for your effort.
We'll get there soon..
interesting stats, brother! keep'em comin!
Thanks for your support. #recordpool is a really amazing project
Your stats are amazing and this kind of steem stats really inspires us the new steem comer keep the good things going All the best
Thanks @rajaduttablogs. #recordpool are still growing 😄
Amazing data ! #recordpool love
Hey @djlethalskillz. Thanks for giving me the chance for analysing #recordpool
Wow awesome work! thanks so much for this @superoo7!
Congratulations! This post has been upvoted from the communal account, @minnowsupport, by superoo7 from the Minnow Support Project. It's a witness project run by aggroed, ausbitbank, teamsteem, theprophet0, someguy123, neoxian, followbtcnews, and netuoso. The goal is to help Steemit grow by supporting Minnows. Please find us at the Peace, Abundance, and Liberty Network (PALnet) Discord Channel. It's a completely public and open space to all members of the Steemit community who voluntarily choose to be there.
If you would like to delegate to the Minnow Support Project you can do so by clicking on the following links: 50SP, 100SP, 250SP, 500SP, 1000SP, 5000SP.
Be sure to leave at least 50SP undelegated on your account.
This post has received a 0.35 % upvote from @drotto thanks to: @banjo.