eSteem - Full Year 2017 Statistics

in utopian-io •  2 years ago  (edited)

In this second study of the 2017 full year statistics for the steem blockchain platforms I will look at the figures for eSteem.

esteem title.png

eSteem is an open source blogging application built on top of the steem blockchain. It is a mobile based application, allowing users to access the blockchain whilst on the move. It is available to all steem accounts but in particular provides accessibility to users whose only method to connect to the internet is through their mobile device.

There are three parts to the analysis:
Overview of 2017: An overview of the figures for the full year 2017 (daily individual author numbers, post numbers and reward payouts) illustrating the growth in the platform over the second half of the year;
Location analysis: A breakdown of the 2017 users by location to understand the main locations for the user base; and
Top 50 users: A summary of the payouts for the 50 users over 2017 showing those users that have had most financial success over 2017 through the platform.


Outline

  1. Scope of Analysis
  2. Tools Used
  3. Overview of 2017
  4. Location Analysis
  5. Top 50 users
  6. Scripts


1 Scope of Analysis

The analysis is based on the data for the eSteem application obtained through SQL queries of SteemSQL, a publicly available Microsoft SQL database containing all the Steem blockchain data.

The eSteem data has been filtered from the overall steem blockchain data by filtering on the app label information in the json_metadata column of the Comments table. One limitation of this approach is that modifying an article in another application causes the app label information in the json_metadata column to change to that of the modifying platform. However it is expected that this limitation has minimal effect.

The analysis focuses on articles posted in 2017. The data has been filtered by date using the timestamps in the created column of the Comments table.

Location information has been obtained from the location label information in the json_metadata column of the Accounts table.


2 Tools Used

Valentina Studio, a free data management tool, was used to run the SQL queries. The raw data was then verified and analysed in the spreadsheet application of the LibreOffice office suite.

Graphs and charts were produced using Numbers, the Mac spreadsheet tool, or using RAWGraphs, an open source data visualisation framework.

SQL scripts are included at the end of this analysis.


3 Overview of 2017

eSteem has consistently been the second largest of the steem blockchain applications when measured by numbers of posters and number of posts. This chart illustrates the relative size of the “alternative” steem apps (i.e. excluding steemit.com) measured by the number of individual authors per day. The time period is the second half of 2017.

esteem daily user numbers 2017.png

Individual authors per day - "alternative" platforms

eSteem also managed to grow substantially throughout 2017 under all three metrics: articles, authors, and payouts. The chart below covers the full year 2017 for the eSteem application:

  • The light blue line is the number of articles per day and the dark blue line is number of distinct authors. These are plotted against the left hand axis.
  • The silver columns are author rewards and the gold columns are curator rewards. These are plotted against the right hand axis.

Screen Shot 2018-01-11 at 20.56.19.png

2017 main metrics - eSteem

Key growth spurts can be seen in June and December 2017, both periods when the price of the underlying steem currency was increasing significantly. It will be interesting to see how the statistics react over January given the rapid rise and fall in the steem price that has already occurred in the month.

Finally the table of monthly figures for eSteem shows continual growth in article numbers and poster numbers over 2017.

MonthAll PostersRegular PostersAll PostsTotal Payouts
Jan154488092,095
Feb122517121,928
Mar156661,0701,797
Apr137588012,364
May4011552,43424,872
Jun2,2051,09321,939132,169
Jul4,2592,33954,72371,428
Aug4,0562,22246,21161,099
Sep4,2062,39349,03863,413
Oct4,3662,37847,20349,543
Nov3,9322,23251,26047,889
Dec6,9643,99587,538145,961
Total363,738604,558

The December figures showed a 200% increase in total payouts generated and over 70% increases in poster numbers and post numbers.

User retention was also strong over December, with 70% of November posters also posting in December (this only considers posts, not comments). New users of the platform in December were roughly equally split between new December steem blockchain accounts and existing accounts diversifying into eSteem.


4 Location Analysis

The aim of this second part of the analysis is to understand the main locations for the eSteem user base over 2017. It is one of the aims of eSteem to reach users whose only method to connect to the internet is through their mobile device.

The location analysis relies on steem users filling in the location information in their profile. Unfortunately a majority of users do not complete this information. Of the 15,465 users who posted (not including comments) over 2017 I was only able to analyse 36%. As such the results of the analysis can only be considered indicative.

Screen Shot 2018-01-11 at 22.34.49.png

location analysis over 2017 - eSteem

The largest number of posters over 2017 (of those analysed) were located in Indonesia, the USA, Nigeria, and India.


5 Top 50 Users

Finally, a sunburst chart of the top 50 users by author payout for the eSteem platform over 2017 (excluding @good-karma the developer of eSteem who would otherwise be the number 1 rated user).

A further layer of breakdown - the main tags under which they post - has also been added (“other” is typically seen where posters use a wide variety of main tags).

It is worth noting that there are a couple of limitations to this analysis:

  • Some author payouts will have been augmented by votes from upvote bots. As such the net earnings will be lower than those seen here.
  • The amounts are expressed as per the payout values shown on steem platform sites - no conversion has been made to US$ or to Steem. The value of payouts can actually differ quite substantially from one month to the next, depending on the value of the underlying currencies.

esteem top 50 users.png

top 50 users over 2017 - eSteem

It is interesting that the author payout rewards are really quite evenly split over the top 50 users. This may be a function of the way the application is used - perhaps a mobile app is used for more frequent and shorter posts with less differentiation in the rewards obtained.


6 Scripts

This was the main script used for the analysis.


/* SINGLE APP ANALYSIS by AUTHOR and MONTH - 2017 Full year */
SELECT
    Comments.author,
    Month(Comments.created) as [CommentMonth],
    IIF(isjson(comments.json_metadata) = 1, IIF(CHARINDEX('/', json_value(comments.json_metadata, '$.app')) > 0, SUBSTRING(json_value(comments.json_metadata, '$.app'), 1, CHARINDEX('/', json_value(comments.json_metadata, '$.app'))-1),json_value(comments.json_metadata, '$.app')), null) as [Application], 
    Count(Comments.author) AS [Posts],
    Count(distinct Comments.author) AS [DistinctCommentAuthor],
    count(Comments.parent_author) AS [ParentAuthor],
    count(distinct Comments.parent_author) AS [DistinctParentAuthor],
    sum(CONVERT(REAL,Comments.pending_payout_value)) AS [PendingPayoutValue],
    sum(CONVERT(REAL,Comments.curator_payout_value)) AS [CuratorPayoutValue],
    sum(CONVERT(REAL,Comments.total_payout_value)) AS [TotalPayoutValue]


FROM
    Comments (NOLOCK)


WHERE
    YEAR(Comments.created) = 2017 AND
    depth = 0 AND
    IIF(isjson(comments.json_metadata) = 1, IIF(CHARINDEX('/', json_value(comments.json_metadata, '$.app')) > 0, SUBSTRING(json_value(comments.json_metadata, '$.app'), 1, CHARINDEX('/', json_value(comments.json_metadata, '$.app'))-1),json_value(comments.json_metadata, '$.app')), null) = 'busy'     


GROUP BY
    Comments.author,
Month(Comments.created) as [CommentMonth]
    IIF(isjson(comments.json_metadata) = 1, IIF(CHARINDEX('/', json_value(comments.json_metadata, '$.app')) > 0, SUBSTRING(json_value(comments.json_metadata, '$.app'), 1, CHARINDEX('/', json_value(comments.json_metadata, '$.app'))-1),json_value(comments.json_metadata, '$.app')), null)

Very similar scripts were used for the location analysis and the extraction of data by day. Briefly the small differences are:

  • Changing from grouping by the month of the comment creation date to the exact date of comment creation allows the extraction by individual date. The author information is not required for this run (and the results would be very large by author and date)
  • An inner join to the Accounts table allowed the additional location data to be extracted.

That's all for today. Thanks for reading!



Posted on Utopian.io - Rewarding Open Source Contributors

Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE STEEM!
Sort Order:  

Great Data!

Seriously. How does one have a 78 dollar post go to 70 when the price of both the steem dollar and coin have stay virtually the same??!! @ned ? @jerrybanfeild?

Can someone please explain to me why it is I'm losing drastic value my steam back dollar post amounts even a steam back dollar has stayed the same price or fluctuated by only $0.30. On a $78 post yesterday is now under $75? My whole account lost over 20 SBD for what seems like no reason as the coin and dollar price is virtually the same as yesterday. This is extremly fustrating to watch and discouraging. @ned

Your analysis has really made me easy with esteem and to be honest, before this I never used esteem, but after reading your article only, I am getting used to.

Thank you for such a detailed analysis.

Have a great day.

No problem. Thanks for stopping by!

Just a comment to note that this post is past its seven day payout period so no longer accepts upvotes.

You can check out my latest posts here if your votes are burning a hole in your pocket: @miniature-tiger !!!

Good and nice information many thanks.
By the way here we exist one or two person in El Salvador centralamerica for your considerations.
Thank you so much.

No problem. And yes, a few eSteem users in El Salvador, but many more in Venezuela, as far as I can tell from the data.

Amazing how i could identify salvadoream user???? I feel i am alone no more than 2 me and others could you help me to identify them. ?????

From a quick look at the accounts data I have:

xak, balbuceando, jorgem2, sibelius6809, galberto, sucot2004, arqheos

who have all made a comment or post since 1 December 2017 and who list El Salvador as their location. But you are by far the largest SP holder. You're going to have to spread the word a little!

Many thanks i review this user for identify and visit them, i invited every of my friend but they do not believe, me i will continued work hard thank for help me i apreciate it
Best regard @galberto

Thank you for the contribution. It has been approved.

Hi @minitature-tiger, great work again!
Just out of curiosity: How did you filter the locations? Is it just a check if the exact string is in a dictionary of known countries, or did you go deeper like substring parsing, or detecting region names within a country etc?

You can contact us on Discord.
[utopian-moderator]

Thanks @crokkon!

It was very manual (deep shame).

I put all the locations into a pivot table, sorted by count, and then went through the list from the top. I think the first one was Indonesia, so I searched all the other strings for Indonesia, and summed the count if there was a hit (so Berlin, Germany would be a hit for Germany for example).

And then I went down the list, making sure not to double count, and grouping cities into the right country etc (i.e. Berlin by itself in with Germany). Very manual!

I'm not a big fan of the location analyses, just because they rely on user input, and not enough people enter the details for it to be scientific. So I didn't want to spend too long developing something more complex. But for eSteem it's one of their aims to reach developing countries so I thought it was important to see whether that was the case. There's enough data for it to be interesting and indicative but not enough to prove any firm conclusions.

I'd be interested if @good-karma and the team have better data themselves, from it being a mobile app, and whether that correlates to the data above or if it's wide of the mark.

No, not "deep shame", rather the opposite. Kudos for digging through the data by hand! :)
Free text fields are hard to analyze because users can put anything there and I guess your approach still provides the most reliable results.
Adding a GPS location to the the json_metadatacould actually make a nice (OPTIONAL) feature for reliable location reporting...

WOW @miniature-tiger, as a newbie, I was curious to see Indonesia (Where I live), rate so high on the list and well above everyone else! At first I thought it was targeting posts to my location, a bit like the other (unnamed) social portals do with their ads, but it appears there a lot of Indonesian folk out there with time on their hands to contribute.

Nice analysis as always, and perty graphics too, although TBH my main question is WTF is esteem? Something else to explore for tomo, as you say, that's all for today.

Timed that right for a nice little curation reward, I think. Something I'll be analyzing at some point.

Night!

So many apps now it's hard to keep track! But eSteem was one of the earliest ones I believe.

I think you're right on the curation too. @crokkon's analysis, a few days back, was really interesting on curation timing. I tend to run late, which does not surprise me!

Great. I will take my time to check this deeper. Seeing that Western occidental world is not leading is good path toward more worldwidee balance redistribution. thank you for this study

Yes, I believe that part of the aim was to try and bring steem to users in developing countries and superficially it looks like that could be succeeding.

But I couldn't really talk more about it in the analysis because there's really little information about the type of users in those countries who use the app. So they could all be very rich. But it's an interesting chart for debate so I decided to include it even though the numbers are a little thin.

This is honestly the first time ive heard of esteem, I will be looking into this. Is this going to be the official mobile app for @steemit ? I heard they are working on one also. Thank for the data!

I didn't realise there would be a steemit mobile app also. I think the team has a lot on their plate already!

Great infographics, I like your analysis!

Thank you!

Hi @miniature-tiger... I have been using this esteem application, since last 7 months after my son @firepower got me this phone.. In last few months, I have written about so many things on this beautiful platform. Thank you so much for sharing a good post with all these statistics. After reading your post, I came to know that I am one among the top users.

And I am extremely grateful to @good-karma for developing and working hard behind the success of this app. As I am still not familiar with laptop, I am using only esteem app for all my work!!.

Thank you once again @miniature-tiger..
Reblogged this post....

Congratulations! Yes, you are right up near the top.

I think that's part of the idea with eSteem, to bring the steem blockchain to people who just use phones, not laptops. I'm glad to hear that it's hitting the mark.

And thanks for the resteem. Much appreciated!

Really interesting analysis and hope in the future may be more interesting again and I wait ... sorry if there are words that I am not good then I apologize.
1515700802657.png

That's a powerful and detailed analysis. No surprise that Nigeria is such a majority; we are coming into Steemit in a big way. If you do such an analysis again in, like, July of 2018, Nigeria might be the biggest circle by then.

That's great to hear! My bet is on India, just given the size of the population, but Nigeria is a strong contender too.

It feels good to see the payouts and all that,at least that will make me more comfortable knowing that steemit works pretty good.

I'm so excited how the statistics will rise in 2018. Hopefully the people will recognize this plattform and start interacting with it. Great post, steem on! :)

great post

good analysis, esteem needs some improvements to compeete withe facebook and twitter.

interesting to see that monetary instable markets (Venezual) use esteem.

This is such a wonderful analysis of the increase in steemit posters. In Pakistan, it is also growing day by day and I think it will gain a wholesome popularity and a very comfortable way to earn some income as well.

Thank you @neelamnaz!

I love all these numbers. Thanks for sharing them @miniature-tiger

No problem @braxton101!

A comprehensive and well strict analysis. Nice work. Thanks for sharing.

No problem! I think that the additional applications add huge value to the steem blockchain. And analysing them helps show the progress they are making!

Thank you for the great analysis, looking forward to the future with steemit, especially with it being open sourced like Android!

Thank you for putting in the work bro. Some crazy analytics, and statistical data. It's funny I mad an analogy earlier saying if reddit and tumblr were to have a kid you would get steemit lol. With the added value of currency. Just curious were you thinking it would be this big, or bigger by this time? @good-karma. Thank you for creating this platform brother.

This is actually a good information and quite educational in this aspect to read. Thank you for the information @minature-tiger I am happy I came across this update.

No problem! Be sure to check you all my other analyses!

I was wondering how the Steem blockchain evolved among the previous year 2017.

Despite the fact that this Blockchain is the most used one (heavily strengthen fact btw), It's encouraging that it's the only one 'finished' (loads of unfinished projects & lots of promises in the first 30 spots of coinmarketcap). Steemit is so undervalued I guess.

Great work! Cheers :)

I do think that there's been huge progress in the last six months on the additional applications - and hopefully lots more to come this year!

woww .. Indonesia has the most. thank you for information. hopefully esteem stay debuted !! and if you can esteem give vote automatically to 3 posts every day as before. good luck @miniature-tiger

Wow, great job! It's posts like this that are the reason that I've haven't been on reddit in over a week. This is way more interesting than memes from 4 years ago and bitter complaints over politics, lol.

The analysis was good and am happy my Country Nigeria is among the highest users of Steemit.

Merhaba gonderilerini yakindan takip ediyorum cok basarili. Sagladiginiz bilgiler icin teskkurler. Basarilar dilerim

hallo bos? there are other things to do to grow in steemit

Introduce me ... Paknyak Nyaklah (@abda) I am newcomer, Thank you for very good information and I have upvote.

I like yours post and shair

Thank you!

thank already want to upvote me.

very informative, thank you for sharing this.
I got a lot of lessons from this post

Good information....

  ·  2 years ago Reveal Comment

Test comment

Thank for response

Increible admirable la verdad

Informative 👍

thanks for the information his friend, hope you are healthy always and your dream in this year can be achieved all its
continue to work,

great
resteem

wua great information ,,,, we need people like you to help us that way ,,, thanks for such valuable information ,,,

Waow..Indonesia most widely..Great infographics, thank you for sharing this..I like your analysis.

Wow great 👍

go ahead good luck

Hey @miniature-tiger I am @utopian-io. I have just upvoted you!

Achievements

  • WOW WOW WOW People loved what you did here. GREAT JOB!
  • You are generating more rewards than average for this category. Super!;)
  • Seems like you contribute quite often. AMAZING!

Community-Driven Witness!

I am the first and only Steem Community-Driven Witness. Participate on Discord. Lets GROW TOGETHER!

mooncryption-utopian-witness-gif

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

Thank you very much for developing this app! I use it frequently while travelling, it has helped me a lot!

Verry good post

nice spirit

Good post, very complet.👍

Thanks for your good effort!!!
We are also enjoying with your talent.

I beg your help brother.. Please upvote and follback me..

Nice post . i resteemd

What is difference between a miner and witness??

upvote please

Hi I am following to u and your articles are very interesting good going best of luck to you. I am new to steemit follow me and upvote me.

Thank for you
Help me,apvote my post

awesome post as always. upvoted. please see my elliot wave analysis as I may be a valuable source for your massive profits soon.
https://steemit.com/bitcoin/@philakonecrypto/etp-metaverse-jan-12-ascending-triangle-but-first-may-test-bottom-if-so-80-gains

Do you have any discord server that I can use to get connected with you, cos I think there's a lot we can do together.

A little bit of my States about the application of esteem
All my colleagues complain with the State of the application kasi esteem at the moment.
The post, open wallets, and as its wdng cannot
What is the cause of all this could happen to PAL?
So I can explain to my colleagues that they should not panic.
I really expect your answer good-karma please

Valentina studio used instead of RStudio which is also opensource. Overall, great growth of Steem userbase and equally the payout rate. Steemit will eclipse Youtube, reddit, facebook in less than 10 years. Thanks for founding it!

Thank you eSteem....
Hopefully eSteem always be the best application of all time 😀

Nice one will take time to go through it

great

very impression your post, I really like, I want to like you what is its secret?

if you wish please visit my blog, i need your support .thank you https://steemit.com/@muliadi

Good post @miniature, please help me

Interesting analysis. Thank you

I like your post brather @miniature-tiger

Good infografic , great analysis

I am very impressed as you have taken time to explicitly analyse everything. I have really gained a lot from it. Good job!

Great info, thank you for sharing. Really interesting.

Yeah !!! It’s crazzzzzzzy !!!

wow this is interesting information, and a lot of appreciation, it's very helpful and thank you for sharing.

Great work.

Good!

Thank you!

Good post

Thanks lot for sharing these with us. really you are a legend man in the world.I like you so much.I love to steemit.Once again thanks to you for good information

thanks you for all this information ! Nice work

esteem still number one

It's very cool eSteem. And there are lots of other great apps on the steem blockchain as well. You can see my latest stats review for steepshot here:
https://steemit.com/utopian-io/@miniature-tiger/steepshot-full-year-2017-statistics

i realize it and nalysis this blog...please carry on...
i will wait for your next post..

Share good
@aidilputra911

Nice post

Amazingly

Great share. I liked it.

Please follow back if you like my feed. Let's grow together.

@kunalcold

Upvote please

I see you are new. Welcome!

Comments like "Upvote please" are just going to get you lots of flags / downvotes. A better approach is to find articles that you enjoy and make an interesting comment.

Good luck!

Lots of information handed out precise no thought provoking. Thanks .

I’m new here and this is very interesting. The future of this site is looking bright. I hope my content can find a place here.

Very good

then sometimes you have to go Indonesia... :)

Good post...
Vote back.

oh very nice and important news...
thanks you for that

@ned help me go through this

Like your post bro @good-karma

806D82A6-F832-4AE6-B5CC-B694B007743D.jpeg

perfect post

Thank you!

Nice goot

Pliss follo me

We can say a very successful year for Steemit.... Hope it continues the coming years....

@ned nice article i need you and Stemians please support and bring awareness to this serious cause https://steemit.com/trophy-hunting/@finaltouch25/cnn-new-hunting-special-is-fucking-sickening-hunters-claim-it-s-saving-animal-extinction

Wow! great stats.Nigeria is gradually picking up on the platform. Up Nigerians