TeamMalaysia - Full Year 2017 Statistics

The goal of this analysis is to analysed how much has teammalaysia grow by analysing how the tag #teammalaysia being used back in 2017.

Outline

• Scope of analysis
• Tools
• Results
  • Overall Statistics
  • Montly Statistics
  • Top 10 tags used alongside with #teammalaysia
  • Top 10 author
• Sample Codes

Scope of Analysis

Timeframe: 01/01/2017 - 31/12/2017

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

[1] Overall statistics

Author	Posts	Comments	Upvotes	Total_Payouts	Author_Payouts
498	5777	50938	201706	36401.6070	26318.5530

In 2017, there is 5777 posts on #teammalaysia tag, a total of 498 authors, 50938 comments and 201706 upvotes. The total payout in 2017 is $36401.6070 and author earns $26318.5530.

On average, #teammalaysia author posted 11.6 posts, received 8.8 comments and 72.6 upvotes. The average total payout is $4.56.

[2] Monthly Statistics

Month	Posts	Comments	Upvotes	Total_Payouts	Author_Payouts
7	69	1029	2003	461.9480	340.5200
8	366	4384	12375	2006.5580	1466.8310
9	618	7868	19736	2524.8600	1810.6160
10	838	8610	30653	4912.7000	3474.0730
11	1128	8875	46752	6155.7500	4469.0230
12	2758	20172	90187	20339.7910	14757.4900

TeamMalaysia started back in July 2017, and we had grow a lot lately.

Based on the statisctics shown, the use of #teammalaysia tags grow exponentialy. In fact, right now, #teammalaysia is the top 100 most used tags.

[3] Top 10 most used tags alongside with #teammalaysia

This analysis is to indicate what are amongst the most popular tags that are being used alongside with #teammalaysia.

[4] Top 10 Authors

This section analysed the top author of #teammalaysia on 2017 in terms of:

• Number of Posts

Author	Posts
Hive account@ackhoo	345
Hive account@perennial	162
Hive account@howtostartablog	146
Hive account@maverickfoo	116
Hive account@zouxx	116
Hive account@bitrocker2020	116
Hive account@positivesteem	108
Hive account@cikxaijen	105
Hive account@elizacheng	105
Hive account@zord189	101

• Number of Upvotes

Author	Votes
Hive account@ackhoo	15935
Hive account@positivesteem	7989
Hive account@bitrocker2020	7871
Hive account@howtostartablog	7485
Hive account@perennial	6591
Hive account@zord189	6265
Hive account@maverickfoo	5800
Hive account@cikxaijen	5076
Hive account@elizacheng	5052
Hive account@walkinharmony	4899

• Number of Comments

Author	Comments
Hive account@ackhoo	6320
Hive account@positivesteem	3360
Hive account@howtostartablog	2677
Hive account@bitrocker2020	2227
Hive account@zord189	2026
Hive account@perennial	1533
Hive account@elizacheng	1187
Hive account@coloringiship	1094
Hive account@cikxaijen	1004
Hive account@fr3eze	897

• Total Payouts

Author	Total_Payouts
Hive account@bitrocker2020	2864.6820
Hive account@positivesteem	2739.5420
Hive account@howtostartablog	1879.6050
Hive account@maverickfoo	1652.6240
Hive account@alvinauh	1097.0600
Hive account@fr3eze	1095.6320
Hive account@perennial	925.0320
Hive account@ackhoo	775.1530
Hive account@anthonywong	745.9270
Hive account@fundurian	667.2810

Sample codes

[1] Overall statistics

SELECT
  COUNT ( DISTINCT author ) AS Author,
  COUNT (*) AS Posts,
  sum(children) AS Comments,
  sum(net_votes) AS Upvotes
FROM Comments (NOLOCK)
WHERE
 parent_author = '' AND
 created >= CONVERT(datetime,'01/01/2017') AND
 created< CONVERT(datetime,'01/01/2018') AND
 depth = 0 AND
 json_metadata LIKE '%"teammalaysia"%'

[2] Monthly 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(total_payout_value) - SUM(curator_payout_value) AS Author_Payouts
FROM Comments (NOLOCK)
WHERE
 parent_author = '' AND
 created >= CONVERT(datetime,'01/01/2017') AND
 created< CONVERT(datetime,'01/01/2018') AND
 depth = 0 AND
 json_metadata LIKE '%"teammalaysia"%'
GROUP BY
  month(created)

[3] Top 10 most used tags alongside with #teammalaysia
Extract the json_metatag data from 2017 and parse it into Node.js codes

let unprocessedMeta = require('./week1.json');
let metas = {};
unprocessedMeta.map(meta => {
  real_meta = JSON.parse(meta.meta);
  real_meta.map(m => {
    if (m in metas) {
      metas[m] += 1;
    } else {
      metas[m] = 1;
    }
    return;
  });
});
function sortProperties(obj) {
  let sortable = [];
  for (var key in obj)
    if (obj.hasOwnProperty(key)) sortable.push([key, obj[key]]);
  sortable.sort(function(a, b) {
    return a[1] - b[1];
  });
  return sortable;
}
let array = sortProperties(metas);
for(a in array)console.log(array[a]);

[4] Top 10 Authors

SELECT
 '@' + author AS Author,
 COUNT(author) AS Posts,
 SUM(net_votes) AS Votes,
 SUM(total_payout_value) AS Total_Payouts,
 SUM(children) AS Comments
FROM
 Comments (NOLOCK)
WHERE
 parent_author = '' AND
 created >= CONVERT(datetime,'01/01/2017') AND
 created< CONVERT(datetime,'01/01/2018') AND
 depth = 0 AND
 json_metadata LIKE '%"teammalaysia"%'
GROUP BY
   Author
ORDER BY
 Posts desc

---

Posted on Utopian.io - Rewarding Open Source Contributors

---