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
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,
and
, 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
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