Spanish Community 2017 Statistics and Chinese Community 2017 Statistics: A comparative analysis

Details

The purpose of this analysis is to compare the Chinese and Spanish community 2017 statistics, explore both community progress and see interesting details.

Outline

1. Scope of Analysis;
2. Tools;
3. Posts and comments
4. Payout distribution;
5. Authors with most posts, comments and payouts;
6. DATA ANALYSIS AND THE QUESTIONS THAT DESERVE ANSWERS
7. Conclusion
8. Code

1. Scope of Analysis

Date of the analysis: 01.02.2018 (date the data was sourced from SteemSQL for both the Chinese and Spanish Communities

Timeframe of the analysed data: from 01.01.2017 to 31.12.2017 for both the chinese and Spanish Communities

2. Tools

Valentina Studio to get data from SteemSQL;

Google Sheets to organize and sum up data

Microsoft Excel to make graphs.

Results

3. Posts and comments

4352 Chinese authors created 44855 posts with cn tag and more than 186490 comments have been written under that posts while 9044 Spanish authors created 130966 posts with spanish tag and more than 324243 comments have been written under that posts.

Every post in the Chinese community has an average of 4.2 comments while the Spanish community averages 2.48 comments per post.

Both communities started 2017 on a low but the Spanish community made progress from June 2017 which saw their comments increasing from 20,022 and peaked at 74,183 by December.
The Chinese community has had ups and downs from June 2017 with their peak month for comment being September with 46,287 comments

In terms of post, the Spanish community also made more progress than the Chinese community with both communities peaking at December 2017 for highest number of post through out the year

4. Payout distribution

All figures are in ($)

Here is a brief summary of spanish tag in 2017:

• Total number of posts created under spanish tag: 130,966

• Total number of comments for spanish tag: 324,243

• Total unique authors posted under spanish tag: 9,044

• Total payout for posts made under spanish tag: $500,226.68

• $397,043.18 author rewards paid in SBD and STEEM POWER

• $103,183.50 curation rewards paid in STEEM POWER)

Here is a brief summary of cn tag in 2017:

• Total number of posts created under cn tag: 44,855

• Total number of comments for cn tag: 186,490

• Total unique authors posted under cn tag: 4,352

• Total payout for posts made under cn tag: $934,564.77

• $744,875.99 in author rewards paid in SBD and STEEM POWER

• $189,688.78 in curation rewards paid in STEEM POWER)

Even though the Spanish Community created 86,111 post more than the Chinese community, it earned $434,338.09 less than the Chinese community

The Spanish community also earned $347,832.81 less than the Chinese community in author reward paid in SBD and STEEM POWER

In terms of curation reward paid in STEEM POWER, the Spanish Community all earned $86,505.28 less than the Chinese community

Highest curation reward by the chinese community made progress from June to September 2017. The spanish did mot make much progress in terms of earning from curation.

Just like in curation rewards, the spanish community earned far less than the chinese community

5. Authors with most posts, comments and payouts

Top authors by number of posts

Here is a table with top 10 users by number of posts under cn and Spanish tag:

The top Chinese author under cn tag created more post than the top Spanish author under spanish tag

The difference between the top 10 authors is more pronounced in the Chinese cn tag than the spanish tag

Top authors by posts payouts

Here is a table with top 10 users by total posts payouts under cn and spanish tag:

The Chinese community boast a better average payout per post than the spanish community. The most impressive under the chinese community was @sweetssj who earned about $472.33 average payout per post while the best performer under the spanish community was @spanish-trail who earned $110.21 average payout per post

Top authors by comments under their posts

The most impressive once again under the chinese community was @sweetsssj who post were very interactive and averaged 300.9 comments per post (isn't that wonderful?)

While the spanish community lags behind as their most interactive user @michelcamacaro could only pull an average of 43.8 comments per post.

6. DATA ANALYSIS AND THE QUESTIONS THAT DESERVE ANSWERS

Why was there a sudden increase in steemit activities for both chinese and spanish communities (post, comments and payout) from the month of June to September?

News Link

The rise in steem price in June caused both communities to witness a rise in tag activities. Before June 2017, it wasn’t really profitable to be on the steemit platform in terms of rewards

Why was there a drop in steemit activities for the Chinese community (post, comments and payout) from the month of October to November?

News Link

The ban of cryptocurrency from large exchange trading by the Chinese government in the month of October had a significant effect on the Chinese tag activities on steemit (drop in post and comments).
And because of the power down within that period the payout on Chinese tag reduced and only regained from strength from December but is yet to reach peak periods on August 2017 as at December 2017

Why was there another increase in steemit activities for both communities (post, comments and payout) in December?

News Link

Both communities saw a rise in post, comments and payouts because there was an exponential rise in the price of cryptocurrency in that month, and that pushed a lot of people unto the steemit platform in order to earn in digital currency as digital currency was being tagged as the future of economics.

Why does Chinese tag have more payout than Spanish tag even with less posts and comments?

The Chinese community has more authors who holds significant steem power. @Sweetsssj holds more than 700,000 SP. With such people in their ranks, they are able to support each other. Out of the top 10 Chinese tag, 4 of them have over 50,000 SP.

7. CONCLUSION

This analysis goes to show that number of post and comments does not automatically translate to a higher payout. The spanish tag had more post and comments but earned less than the chinese cn tag with fewer post and comments.

Government regulation can also have an impact on steemit activities as displayed in the chinese community

China has a population of about 1.4 billion and has potential for expansion, the problem is government control of any social media platform which does not originate from China

8. Code

SQL request to get above data for Chinese community from database:

select * FROM Comments (NOLOCK) where created >= ('2017-01-01T00:00:00.000Z') and created < ('2018-01-01T00:00:00.000Z') and depth = 0 and json_metadata like '%"cn"%'

SQL request to get above data for Spanish community from database:

select * FROM Comments (NOLOCK) where created >= ('2017-01-01T00:00:00.000Z') and created < ('2018-01-01T00:00:00.000Z') and depth = 0 and json_metadata like '%"spanish"%'

Note: Special thanks to @artz for his inputs in this analysis

---

Posted on Utopian.io - Rewarding Open Source Contributors

---