Steemit Business Intelligence: Tags Specific to Malaysia Trends & Distribution
Malaysia just like the Philippines has a lot of potential for growth. As of 2016 data from http://www.internetlivestats.com/internet-users/malaysia there's more than twenty one million internet users in Malaysia. At the time of the analysis, the data suggests that there are only 191 authors who have posted using #teammalaysia tag.
Like the #philippines tag, the first #malaysia tag was seen in July of 2016. I have only seen #malaysia and #teammalaysia being used as an identifier of the country of origin of authors. In contrast with Philippines based author where #philippines is still the main tag used as pointed out in an earlier contribution, Malaysian authors are mainly using #teammalaysia. In this analysis I will present the data-points showing both the number of posts, and the corresponding total rewards for #malaysia, and #teammalaysia tags. I will also present the top 20 authors using #teammalaysia in terms of total_rewards_payout.
The chart above presents an exponential growth in terms of posting using #teammalaysia as the primary tag towards the end of 2017. From as low as 4 posts in January of 2017 to 613 in December. I think our fellow Steemians in Malaysia are just getting started in terms of both growth in user-base, and activity.
Delimitation
This analysis will present the distribution and trend related to post count and total_payout_value of #malaysia, and #teammalaysia categories. The data will only be captured then if any of those were used as the primay tag. The analysis will also not filter the data by author to determine if he/she is a Malaysian or based in Malaysia. There will in fact be an incubator group that will show up in the top 20 authors which will be highlighted in the analysis.
The analysis will only capture the data for the posts where the tags were used and will filter out comments in calculating the count of posts, and total_payout_value.
I used arcange's Steem SQL Public Database to acquire the data-points related to usage of tags from the Comment table.
Methodology
Having done earlier contribution using the Comment table in analyzing the Philippines related tags, I know that the data is quite huge. I extracted the data related to each of the tags that are subjects of this analysis by running these SQL queries:
SELECT *
FROM Comments (NOLOCK)
WHERE category in ('malaysia')
SELECT *
FROM Comments (NOLOCK)
WHERE category in ('teammalaysia')
To get the month and year date format from default date time format, I used =TEXT(timestamp,"mmm-yyyy") in excel
I removed the comments by running the =RIGHT(Text,Number of Characters) formula in excel and filtered out the result beginning with re-.
I then plotted the data-points in an excel spreadsheet to create the charts and visually present the data.
The data is complete until the end of December 2017, and there was not need to extrapolate anything the figures used in this analysis are all actual results.
The Analysis
I have already mentioned about the exponential growth in posting activities where #malaysia and #teammalaysia tags were used. The chart below shows an even more exponential growth in terms of total_payout_value. From a low of $0.30 in January 2017, to a high of $2,534.5 in December 2017; that's a growth of nearly 8,450 times.
As can be seen from the chart the #teammalaysia tag took over the #malaysia tag from the first month (July 2017) when it was used.
Here is the data for both post count and total_payout_value between #malaysia and #teammalaysia tags shown in a table:
Month | #malaysia Posts | #teammalaysia Posts | #malaysia Payout | #teammalaysia Payout |
---|---|---|---|---|
Jul-16 | 2 | 0 | $0.0 | $- |
Aug-16 | 4 | 0 | $0.1 | $- |
Sep-16 | 0 | 0 | $- | $- |
Oct-16 | 0 | 0 | $- | $- |
Nov-16 | 2 | 0 | $- | $- |
Dec-16 | 1 | 0 | $- | $- |
Jan-17 | 4 | 0 | $0.3 | $- |
Feb-17 | 0 | 0 | $- | $- |
Mar-17 | 2 | 0 | $- | $- |
Apr-17 | 3 | 0 | $0.0 | $- |
May-17 | 4 | 0 | $6.1 | $- |
Jun-17 | 10 | 0 | $52.2 | $- |
Jul-17 | 13 | 5 | $6.8 | $49.0 |
Aug-17 | 22 | 70 | $9.5 | $449.5 |
Sep-17 | 17 | 142 | $0.4 | $634.1 |
Oct-17 | 33 | 97 | $14.7 | $717.1 |
Nov-17 | 38 | 132 | $7.2 | $645.9 |
Dec-17 | 17 | 596 | $1.4 | $2,534.5 |
In the next two charts below it can be seen that since July 2017, #teammalaysia was already dominating in terms of distribution of total_reward_payout, but in December 2017 #teammalaysia took almost the entirety of the pie chart.
In the chart below, I listed the Top 20 Authors (in terms of total_payout_value) who used #teammalaysia tag. Here are key observations:
- Out of the total_payout_value of $5,030.04 between July to December 2017, $3,992.22 (79.37%) were generated from the top 20 out of 191 authors who used #teammalaysia as a primary tag.
- 34.41% or $1,731.08 went to just one author; bitrocker2020
- 5 out of the Top 20 Authors are related to Sndbox, one being the Sndbox account itself, one is a Sndcastle (myach) and the three are Sndbox fellows (bitrocker2020, elizacheng, and maverickfoo).
Conclusion
The data-points presented here shows the growth of the Malaysian Steemit community. Furthermore, it shows how Sndbox and their Sndcastle incubation programs are driving growth in communities like in Malaysia. The Sndcastle MYACH based on the account description stands for MY Accelerator Hub, and it seems to be doing what it is meant to do; accelerate the growth of the user-base, posting activities, and Steemit related initiatives.
In terms of country specific tag, the (team)+(country name) seems to be a common format.
The two country specific tags I have done an analysis on showed very significant growth both in terms of posting activities, and total_payout_value. Both of which are very powerful in terms of getting the word out about Steemit, and supporting further growth of the whole community.
Posted on Utopian.io - Rewarding Open Source Contributors
Thank you for the contribution. It has been approved.
Hi @steemitph
Whilst the data queries are quite simple, I still think there is good value in this post (and the previous contribution) due to the extended time period that the data has been collected from.
Also, very clear and well written!
Thanks
Asher
You can contact us on Discord.
[utopian-moderator]
Thanks Asher for reviewing and for the thoughtful comment. I will never forget getting educated by yourself in an earlier contribution. That made me want make each contribution count.
My pleasure @steemitph, thank you for your kind words and a happy new year to you!
Hey @steemitph I am @utopian-io. I have just upvoted you!
Achievements
Community-Driven Witness!
I am the first and only Steem Community-Driven Witness. Participate on Discord. Lets GROW TOGETHER!
Up-vote this comment to grow my power and help Open Source contributions like this one. Want to chat? Join me on Discord https://discord.gg/Pc8HG9x
I read this post from two points of view and all I can say is wow. Incredible job.
The follow up in 3 to 6 months will be interesting to see. How much will #teammalaysia grow? How can the Steemit community help?
My second perspective is a desire to learn this kind of research structure. I see you documented where and how you got your data. What tools are you using to build the graphs?
Thank you. :)
Appreciate your interest and support @inalittlewhile. Would you believe that I did not know how to do this 4 months ago? This means you can also learn how to do it. I used an excel spreadsheet and @arcange's public SQL. Start with this link. There's a linked tutorial in that post on how to use SQL in excel.
If you have questions after reading those two post, feel free to hit me on discord (same username).
Awesome and thanks so much. I'm going to absorb this info. :)
thanks for the detailed analysis @steemitph
Thanks for your support @bitrocker2020, and congratulations for the success of your efforts in @myach and supporting the growth of the Malaysian Steemit community. Wishing you all an even better 2018.
Thanks for the mention!
Could you make a post on marketing posts on steem ? Like posts featuring amazon, uber or any other commerce giants. Or about any post that can be considered as advertising. How much steem power such accounts have which regularly engage (post or upvote) marketing content ?
It will add a lot of value to steem.
This is one great suggestion @shreyasgune. Will give it some thought. The main challenge I can see is isolating those post via a unique identifier. The tag #promo-steem's been used excessively outside of what it was meant to be for. Will continue thinking for sure. Thanks for this brilliant suggestion.
You have identified the challenge precisely. A good work around could be to try to dig out marketing posts and finding what words are common between them. I bet we can easily identify some words that appear repeatedly in advertisements. We can identify more such identifiers. Also we could have negating identifiers. Like If the post has A it is ok. But it should definitely not have B. It is indeed a big exercise. But we could start small and take baby steps !!
Thanks @steemitph for #teammalaysia analysis ..
Wow.. Thank you for the insightful analysis. This is really a good post , and helps a lot to us all in team Malaysia.
Wow! This is definitely a very thorough analysis of #teammalaysia! Kudos to @steemitph for taking the time and effort to compile this analysis!
Great Analysis.
Hey bro will you upvote me worth 3.5-4 sbd if I transfer you 1 sbd in memo with URL.