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

Author	Title	Upvotes	Comments	Pending_Payout
@deeptechhouse	Deep House :: Tune of the Day : AMPEAR - Extraterrestrial Water (https://steemit.com/electronicmusic/@deeptechhouse/deep-house-tune-of-the-day-ampear-extraterrestrial-water)	93	4	20.4750
@vibekilla	The NOLIFECLUB Initiative (https://steemit.com/nolifeclub/@vibekilla/the-nolifeclub-initiative)	90	7	18.0820
@djlethalskillz	'Steemit Record Pool' Weekly Roundup Contest #3 \| Curate Music & Win Rewards! (https://steemit.com/recordpool/@djlethalskillz/steemit-record-pool-weekly-roundup-contest-3-or-curate-music-and-win-rewards)	61	5	24.3910
@killuminatic	Steemit Record Pool \| Talent of the Day \| Praniti \| Cover of Yogi B and Natchatra - Madai Thiranthu 🔥 (https://steemit.com/recordpool/@killuminatic/steemit-record-pool-or-talent-of-the-day-or-praniti-or-cover-of-yogi-b-and-natchatra-madai-thiranthu)	48	10	7.5660
@rawselectmusic	BEST NEW MUSIC: Kiefer - Miss U [jazzy instrumental hip-hop] (https://steemit.com/music/@rawselectmusic/best-new-music-kiefer-miss-u-jazzy-instrumental-hip-hop)	47	1	16.2450
@djlethalskillz	'Steemit Record Pool' Weekly Roundup #2 Winners Announcement! (https://steemit.com/recordpool/@djlethalskillz/steemit-record-pool-weekly-roundup-2-winners-announcement)	41	13	33.5080
@soundwavesphoton	Steemit Musical Collab with a Great Bass Player. "Libertad" a Hypno Groove from Space. (https://steemit.com/music/@soundwavesphoton/steemit-musical-collab-with-a-great-bass-player-libertad-a-hypno-groove-from-space)	41	14	6.4370
@mateonav53	Steemit Record Pool - Introspective, Experimental Jam by Aleksi Perälä - NLL561606934 (https://steemit.com/recordpool/@mateonav53/steemit-record-pool-introspective-experimental-jam-by-aleksi-peraelae-nll561606934)	39	5	13.1250
@danielwong	Justin Johnson Whiskey Barrel Guitar (https://steemit.com/recordpool/@danielwong/justin-johnson-whiskey-barrel-guitar)	33	9	4.3980
@vandigital	Steemit Record Pool // Song Of The Day - "You Must Learn" by Boogie Down Productions (https://steemit.com/recordpool/@vandigital/steemit-record-pool-song-of-the-day-you-must-learn-by-boogie-down-productions)	22	7	16.4220

Most commented post

Author	Title	Upvotes	Comments	Pending_Payout
@soundwavesphoton	Steemit Musical Collab with a Great Bass Player. "Libertad" a Hypno Groove from Space. (https://steemit.com/music/@soundwavesphoton/steemit-musical-collab-with-a-great-bass-player-libertad-a-hypno-groove-from-space)	41	14	6.4370
@djlethalskillz	'Steemit Record Pool' Weekly Roundup #2 Winners Announcement! (https://steemit.com/recordpool/@djlethalskillz/steemit-record-pool-weekly-roundup-2-winners-announcement)	41	13	33.5080
@killuminatic	Steemit Record Pool \| Talent of the Day \| Praniti \| Cover of Yogi B and Natchatra - Madai Thiranthu 🔥 (https://steemit.com/recordpool/@killuminatic/steemit-record-pool-or-talent-of-the-day-or-praniti-or-cover-of-yogi-b-and-natchatra-madai-thiranthu)	48	10	7.5660
@danielwong	Justin Johnson Whiskey Barrel Guitar (https://steemit.com/recordpool/@danielwong/justin-johnson-whiskey-barrel-guitar)	33	9	4.3980
@scuzzy	Steemit Record Pool \| Song of the Day: Erykah Badu - Window's Seat (2010) (https://steemit.com/recordpool/@scuzzy/steemit-record-pool-or-song-of-the-day-erykah-badu-window-s-seat-2010)	14	9	5.3920
@vibekilla	The NOLIFECLUB Initiative (https://steemit.com/nolifeclub/@vibekilla/the-nolifeclub-initiative)	90	7	18.0820
@vandigital	Steemit Record Pool // Song Of The Day - "You Must Learn" by Boogie Down Productions (https://steemit.com/recordpool/@vandigital/steemit-record-pool-song-of-the-day-you-must-learn-by-boogie-down-productions)	22	7	16.4220
@simgirl	Record Pool Song of the Day: Made on McCosh Mill Rd (https://steemit.com/recordpool/@simgirl/record-pool-song-of-the-day-made-on-mccosh-mill-rd)	16	6	0.3980
@rawselectmusic	NEW MUSIC: Mestizo Beat - Featherbed Lane [Latin funk] (https://steemit.com/music/@rawselectmusic/new-music-mestizo-beat-featherbed-lane)	6	6	0.2090
@deeptechhouse	Deep House :: Tune of the Day : Yarosslav - Cytarra (https://steemit.com/electronicmusic/@deeptechhouse/deep-house-tune-of-the-day-yarosslav-cytarra)	4	6	0.0870

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"%'

#recordpool Weekly Analysis Report #1 (Weekly Contest #4)