Introduction
The goal of this analysis is to analyze the activity of #cebu in order to assess the community performance and behavior in Steemit on February 2018. The analysis is intended to see the performance of the tag #cebu as in terms of a comparison to the January 2018 performance. It also includes daily behavior of #cebu in terms of no. of authors, post, sum of total payout, comments, and upvotes.
Outline
I. Scope of Analysis
II. Data presentation and analysis result
- Full Month Data presentation and comparison between January and February 2018
- Daily Statistics for February 2018
III. Summary
IV. Tools and Codes
I. Scope of the Analysis
The analysis is performed on data extracted from 
- A full month statistics that shows the sum fo the number of post for #cebu for January and February 2018;
- A daily statistical data for #cebu in for January and February 2018;
- A data that includes all the post and variables for #cebu.
The analysis of the extracted data involves taking sum for each categories/ variables; and, comparing the January 2018 data to February 2018. This is done to assess the growth and performance of #cebu community. The data then presented using charts and tables, as applicable. The analysis also present a summary of all result.
II. Data presentation and analysis result
The following data presented below either tabulated or charted is based on the data extracted from SteemSQL as of March 9, 2018 ( 2 PM UCT).
1. Full Month Data presentation and comparison between January and February 2018
In February 2018, the tag #cebu was used by 689 authors whom generated a total number of post , comments, upvotes, and payouts equal to 4882, 15783, 92125 and 12299.4387 (SBD and SP) respectively. This numbers are summation of all accumulated post, comments, upvotes, and total payout received by 689 distinct authors.
Table 1.1: Monthly statistics for #cebu as of February 2018
If we compare the data from the previous month, we can accumulate an increase in the no. of authors, posts, and upvotes amounting to 87, 1198, and 39713, respectively. At the same time, we can observe a decrease in the comment and total payout generated by the #cebu equal to 3262 and 2565.413 respectively. Overall, we can see a positive growth indicator in the #cebu tag which we can account 87 new authors, even though with the decrease in comments and payouts. The positive increase in post and upvotes could be attributed to the increase in the number of authors.
Graph 1.1: January and February Statistics 2018
Overall, we can see a positive growth indicator in the #cebu tag which we can account 87 new authors, even though with the decrease in post, comments and payouts. The positive increase in upvotes could be attributed to the increase in the number of authors. This data trends are shown in graph 1.1.
2. Daily statistics for February 2018
In Table 2.1, we can draw an average of 133 authors per day are using the tag #cebu. This average authors generates close to 174 daily posting which receive approximately 564 comments, 3290 upvotes and 439.27 payout in SBD and SP.
Table 2.1: Daily statistics for #cebu in February 2018
In the last month daily statistics, we have drawn an average of 85 authors per day on average using the tag #cebu. This average authors generates close to 199 daily posting which receive approximately 614 comments, 1691 upvotes and 479.51 payout in SBD and SP. The data is based on the last month statistics. (You can view it here)
An increase of 28 authors from the January's 85 author per day to February's 133 authors per day on average. However, the increase in the number of authors does not result to any positive increase in terms of number of post, comments and payouts generated. We can account a decrease in the daily average of post, comments and payouts equal to 25, 50, and 40.24 respectively. The only factor that has a positive increase as compared to the increase in the number of authors per day is in terms of upvotes generated where the average increases to 1599.
Graph 2.1: Daily no. of auhthor and post in February 2018
From graph 2.1, we can observe a negative data trends for the number of authors using the tag #cebu in February 2018. However, this is way above the daily averages in January 2018 of 85 authors using the tag and generating a average posting close to 199. In terms of the full month average, this is way low down than that of the January 2018. An observable 25 post decrease on average. We can account the highest no. of authors that uses the #cebu tag was on February 13 which generates 188 post. In addition, we can account the highest no. of post generated was on February 1 for 157 authors. Overall, the author and post line graph shows a downward trends but still on the positive values in terms of the last month data average.
Graph 2.2: Frequency distribution(Histogram) of Sum of Total Payouts on February 2018
In February 2018, an average sum of total payout of 439.26 in SBD and SP is received by #cebu daily. We can see a normal distribution curve from the histogram shown in graph 2.2. The data from sum of the total payout is concentrated between 341.493 to 481.302 in SBD and SP. It means that 57.14 % or 16 of the daily accumulated post using the tag #cebu accumulates a total payout between 341.493 to 481.302 in SBD and SP.
Graph 2.3: Daily Comments and Upvotes for February 2018
If we take a closer look at the comments and upvotes, we can draw a conclusion that the comment generated per post is in some way dependent to the number of upvotes receive by the post. On average, using the tag #cebu, each accumulated post received an average sum of comments equal to 564 on a daily basis. The post s also generate a daily average sum of upvotes equal to 3290.
Graph 2.4: Daily Frequency Distribution of Upvotes on February 2018
We can see a normal distribution curve from the histogram shown in graph 2.4. The data from sum of the total upvotes is concentrated between 2999 to 3509 upvotes. It means that 39.29% or 11 days of the daily accumulated post using the tag #cebu accumulates a total upvotes between 2999 to 3509.
Graph 2.5: Daily overall statistics on February 2018
Generally, the daily statistics for #cebu shows a very positive trends in terms of the number of accumulated authors, and posts with daily averages 133, and 3290, respectively. However, for post, comments and payout, there is an observable decline in terms of its averages as compared to the previous months. In February 2018, the #cebu tag approximately receives 174 post 564 comments, and 439.27 payout in SBD and SP on average. Looking closer to the daily statistics, this numbers still way above than the daily stats for January 2018, but we cannot neglect that there is a minimal downward trends in terms of number post, comments, and payout generated.
III. Summary
In February 2018, the tag #cebu was used by 689 authors whom generated a total number of post , comments, upvotes, and payouts equal to 4882, 15783, 92125 and 12299.4387 (SBD and SP) respectively. This numbers has a daily averages equal to we can draw an average of 133 authors per day are using the tag #cebu. This average authors generates close to 174 daily posting which receive approximately 564 comments, 3290 upvotes and 439.27 payout in SBD and SP. By comparing daily averages for February and January in 2018, Iwe can see a positive increase in the number of authors who have engage and used the #cebu tag, which is the primary tag for the Cebu community. We can account an increase equal to 28 authors and 199 upvotes is gathered. In terms of the number of post, comments, and payout generated, a decrease in the averages was accounted. As we take a closer look on the the daily average, we found out that the daily number of authors, post, comments, upvotes and payout are still above the daily numbers in the previous months. In adition, a 57.14 % or 16 of the daily accumulated post using the tag #cebu accumulates a total payout between 341.493 to 481.302 in SBD and SP. In terms of upvotes, we can account a 39.29% or 11 days of the daily accumulated post using the tag #cebu accumulates a total upvotes between 2999 to 3509. Therefore, #cebu tag is still performing better even with an observable decrease in the averages as compared to the previous month. This is supported by the numbers presented that is a way higher as to the previous month. Aside from that, we can account that the #cebu tag and the community is growing as indicated by the increase in number of authors joining the community by using the #cebu tag.
IV. Tools and Codes
I extracted the data from SteemSQL by importing it on Microsoft Excel using SQL Queries. I used Microsoft Excel to visualize and create a graph for the data. The data is extracted by using COUNT() and SUM() function from comments and json_metadata. The variables being treated are authors, no. of post, comments, total payout, and net votes. The full SQL script is shown below.
| SQL query for Overall January and February 2018 Data |
|---|
| SELECT MONTH(created) AS MONTH, COUNT ( DISTINCT author ) AS Author, COUNT (*) AS Posts, sum(children) AS Comments, sum(net_votes) AS Upvotes, sum(total_payout_value) AS Total_Payout FROM Comments (NOLOCK) WHERE parent_author = '' AND created >= CONVERT(datetime,'01/01/2018') AND created< CONVERT(datetime,'03/01/2018') AND depth = 0 AND json_metadata LIKE '%"cebu"%' GROUP BY month(created) |
| SQL query for Daily February 2018 Data |
|---|
| SELECT DAY(created) AS DAY, COUNT ( DISTINCT author ) AS Author, COUNT (*) AS Posts, sum(children) AS Comments, sum(net_votes) AS Upvotes, sum(total_payout_value) AS Total_Payout FROM Comments (NOLOCK) WHERE parent_author = '' AND created >= CONVERT(datetime,'02/01/2018') AND created< CONVERT(datetime,'03/01/2018') AND depth = 0 AND json_metadata LIKE '%"cebu"%' GROUP BY day(created) |
Posted on Utopian.io - Rewarding Open Source Contributors