STEEM MEETUP: The secret behind #nigeria tag rise

Image Source

Details

In this data analysis, I would be looking at the growth of the Nigerian tag and proving statistically what has propelled this growth and its effects on the steemit community.

I would also be looking at future prospects of the tag

Outline

1. Scope of Analysis;
2. Tools;
3. Posts and comments;
4. Payout distribution;
5. STEEM MEET-UP: The secret behind #nigeria tag rise
6. Conclusion;
7. Code.

1. Scope of Analysis

• Date of the analysis: 02.03.2018

• Timeframe of the analysed data: from 01.01.2017 to 01.03.2018

2. Tools

Microsoft Excel to get data from SteemSQL;

Microsoft Excel to organize and sum up data;

Results

3. Posts and comments

Here is the distribution of posts and comments by month:

Between January 2017 and February 2018, a total of 83,018 post and 426,204 comments under the #nigeria tag

Every post averaged 5.13 comments

4. Payout distribution

There was a total payout of $359,021.55 with authors getting $258,784.291

The payout shows a progressive increase from January 2017 and peaking at February 2018

5. STEEM MEETUP: The secret behind #nigeria tag rise

A steemit meet up is an event in which the long standing people on the steemit platform meet with minnows and prospective steemians. They talk to them about the platform and encourage them to be a part of the revolution.

LEFT TO RIGHT @iconnelly , @lordjames and @jingis07 at ABUJA STEEM MEETUP Read more about it here

Meet ups are for evangelism and networking. They are important part of the steemit development. Many people have positive content but they are ignorant of such a platform like steemit.

Steemit evangelism has played a critical role in the expansion of the steemit platform. I am a living testimony to that, I only joined steemit when a friend of mine @lordjames told me about it.

A total of 314 users have created 716 topics about meetups in Nigeria since the first topic was created on 13th May 2017.

Below I will be displaying the meetup topics that have been shared on steemit using atleast two tags #nigeria and #meetup which I filtered using the SQL query via steemSQL.

A cross section of some topics created with tags #nigeria and #meetup

The meetup evangelism has been very effective as seen in increase in post, comments and payout to authors.

Meetups have an average of 100 people attending, that's a good number of potential steemians

A cross section of people in attendance of Abuja Steem meetup held last month.
Photo Credit @xpency

For a comprehensive list of all topics created with #meetup and #nigeria tags click here

*****6. CONCLUSION*****

Statistics has proven that meetups have improved and increased the #nigeria population on Steemit. Nigeria has a population of About 185 Million people, that is a huge potential market for steemit.

The future is bringht for #nigeria with its users making wave and impact on the platform. I foresee an ever increasing population on steemit

As at January 2018, there were more than 4000 accounts with location (Nigeria) in their profile settings. This is set to increase as more meetups are planned and scheduled to invade all corners of the country by people like @xpency @nairadaddy @destinysaid @michaelcj @ejemai @stach @gbenga @mediahouseent among others.

****7. CODE****

Monthly statistics

  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,'03/01/2018') AND
 depth = 0 AND
 json_metadata LIKE '%"nigeria"%'
GROUP BY
  month(created)

To filter Topics with #nigeria and #meetup tags

FROM Comments (NOLOCK)
WHERE json_metadata like '%"meetup"%' AND json_metadata like '%"nigeria"%'

---

Posted on Utopian.io - Rewarding Open Source Contributors

---