I. Scope of Analysis
- Date of analysis: Saturday 10.02.2018
- Duration of data analyzed: from 18.09.2016 to 07.11.2016
II. Tool
- Microsoft Excel gets data from SteemSQL;
IV. SQL query to get data below from the database:
select * FROM Comments (NOLOCK) where created> = ('2016-09-18T00: 00: 00.000Z') and created <('2016-11-07T00: 00: 00.000Z' ) and depth = 0 and json_metadata like '% "aceh"%'
As for this analysis to find the first party contributing to the #aceh category on steemit, I looked for how many of them and how many articles they loaded so that in the main category they linked #aceh.
After searching the steemit database, I found the first 16 people using #aceh , and the following analyst data complete with their link post:
| Author | Post Link | Date |
|---|---|---|
| @lukmanreyes | post | 9/18/16 14:25 |
| @ardyach | post | 10/20/16 16:37 |
| @keuudeip | post | 10/20/16 16:44 |
| @mapesa | post | 10/21/16 5:18 |
| @vannour | post | 10/22/16 5:38 |
| @steemcultures | post | 10/22/16 17:31 |
| @zaki.akhyar | post | 10/23/16 15:30 |
| @steemvest17 | post | 10/23/16 19:09 |
| @curiesea | post | 10/27/16 11:16 |
| @safar01 | post | 10/27/16 20:50 |
| @steemwart | post | 10/31/16 14:03 |
| @muhtadiaremi | post | 10/31/16 21:30 |
| @yonmusa | post | 11/3/16 21:21 |
| @alexsteem | post | 11/7/16 8:33 |
| @cih | post | 11/7/16 8:33 |
The above table data shows a number of users who first use hastaq #aceh on their posts. The most contribute to #aceh from 9/18/16 - 11/7/16 is as follows:
And recorded on the database, that has been disabled. So that in the whole databases will appear as in the following Row Table, there we can find the amount of their contribution I have mentioned his name over in the time bracket from 9/18/16 - 11/7/16:
The hastag categories used do not all put #aceh on the main hastag, only some of them use it at first:
75% Using #aceh category in main part is | |
| time bracket from 9/18/16 - 11/7/16.
From my analysis of the use of #aceh categories on Steemit, it was first performed by those I have mentioned above and in accordance with the data on the steemitsql.com server. As for them use in a post or article that original/official discuss about aceh, be it culture, natural portrait, history and so on. I also found some performance done by in an effort to grow a #aceh rating . He has really created a quality and official content with members of the time.
But they as the main people in forming #aceh , in those days have actually done an evaluation of the post or any contents that go to #aceh , so often they teach to those who are wrong in the use of categories.
Posted on Utopian.io - Rewarding Open Source Contributors