Basic Analysis on Steem Top dApps, Activity and Support to the Community – December 2018

in utopian-io •  5 months ago



The last month was a month for dApps promotion on Steemit. We had interesting situation and a real community effort that put steem dApps on @stateofthedapps. Some of the persons behind this were @soyrosa and @therealwolf. Steem dApps are now on State of the dApps and can be compared how are they doing against the other crypto platform. And they are not bad at all. The Steemit interface is actually on the first place. @therealwolf also created a dedicated page for the steem dapps.

Watching how dApps are developing is pretty exciting. These are early times in the industry and everyone is experimenting. A lot of the prominent people in the industry have agreed that a real life crypto usage, will come from dApps.

I’m doing this analysis for a couple of months now. The results on the State of the dApps wasn’t that surprising. And if we look even closer the structure of the dApps on the other platform will see that most of them are gambling dApps. Steem have the most genuine dApps.

This said, let’s see the numbers.

Scope of Analysis

The analysis was carried out for the period from 20.11.2018 to 20.12.2018. Data from the STEEM blockchain was used and details of the queries can be found at the bottom of this post.

Activities on dApps

I’m starting this analysis with an overview of the activities on dApps (posts and comments). The past period was one of the worst for the crypto world. The value of Steem dropped a lot. On 14th November it was around 0,74$. Today it is around 0,27. That is almost 2/3 of the value lost, in a period of month and a half. This kind of drop cannot be without consequences. A drop in activities is expected as well.

Here are the number of posts and comments made on each dApp.

The only dApp that shows growth in activities, compared with the previous analysis is @partiko. Partiko is now firs on the list, taking the tron from @busy. All of the other dApp have dropped in activitie. The main reason for this, can be found because of the last month @partiko had a delegation round, and started to reward it users even more.

Next comes the alternative interface to Steemit, @busy and @esteem. The other dApps are also doing a great job.

Number of users voted from the dApps

One of the indexes that I personally find quite important is the number of users that the dApp support. Because of this, I’m putting this criteria. Here it is.

@partiko is the unmatched champion here with more than 2400 users voted for. It is leading by quite a lot. It is followed by @busy and @esteem. They are supporting more than 1000 users.

The interesting thing with @partiko is when I was doing the last month analysis they didn’t had a big amount of SP. They were on the bottom with SP. I was thinking wouldn’t be great for @partiko to gather some amount of SP. Look at the number of users they support. And just after a week or so, they announced their delegation plan. They planned to gather 100k SP but achieved 250k in just four days.
This shows that the community values a good product. And they build the product first, and asked for delegation later. Way to go.

From the other dApps @actifit is also growing and bringing more users and gives them support. The other dapps like @tasteem, @steemhunt, @dtube, @steepshot, @dlike and @utopian-io are also doing a great job and support quite a number of users.

Compering the dApps only by the number of users they support is important, but there are also other things to take into consideration. Every dApp have a different strategy to give their support to the community. Let’s take a look at some other aspects.

Number on posts and comments voted

Some of the other main thing about dApps is the activity they have on their platforms and the number of the posts and comments they vote on. Here are the number of posts and comments each dApp they have voted on.

@steem-ua comes first here, closely followed by @steemhunt. @steem-ua, or Steem User Authority is an alternative user reputation system to the current system that Steemit have. A lot of people complain about the current reputation system, arguing that it is broken. Steem-UA tries to fix that. They are doing ranking on the Steemit users and reward the delagators with votes according to their UA score and the score of the post.

Next comes @steemhunt. This score comes from the fact that @steemhunt rewards comments, and not just posts. Obviously, there are a lot commenting happening on Steemhunt 😊. I have personally used the platform and I can say it is a nice way to get reward just for a decent comment.

Average Votes Value by dApps

Except the number of users dApps support, and the number of posts and comment, another important parameter is the value of their vote. And this depends on the amount of SP they are holding.

Here is a representation of the SP that dApps are holding.

Different dApps use their SP in different manner. Some are rewarding more users, and some less. Here is how they distribute their voting power and the average vote per dApp.

Utopian is the leader here. There average vote is around 18$. They are supporting open source contributions. There are various of categories in which one can make contribution, like blog, analysis, developers, translation etc. After @utopian-io next comes @dtube. The Steemit video platform. Then comes @tasteem, a restaurant reviewing platform. We can see here that the vote value follows the amount of SP the DApps are holding.

The biggest distribution of votes is coming from @steemhunt. Compared to their SP.

The votes values are according to todays steem prices.


The web platforms that are following the dApps are making rankings on them with a custom algorithm that is giving weight to a specific criteria. Here I’m not doing this. The rankings are made above, according to different criteria. In the end are all the data that was used, and the dApps in alphabetic order. Here it is.

Steem Monster and Magic Dice

A word on this two. These are steem based games that are showing great activites recently. But the way they operate is not suitable to include them in this analysis.

@steemmonsters is and excellent project and it is ranked on second place just after Steemit itself. It deserve it and the team behind it is doing a great job.

Magic Dice is a game of luck 😊. You put your bet, roll the dice and hope for the best. Having in mind that this kind of dApps are the one with most users on other platforms, no wonder we are starting to see them here.


From all the project presented above we can see that at the moment the Steemit ecosystem provide support to its users in a variety of different ways. There is something for everyone, no doubt about that. Some of this project may still need a little bit refining.

In the bear market the overall acititie is down, except for @partiko who is showing growth.

But if one is willing to grow here on Steemit there is a lot of opportunity out there, from tracking his activity, reviewing restaurants or making contribution to the open source projects. Or just use a different Steemit interface.

Tools and Scripts

The data was gathered in Excel From Steemsql held and managed by @arcange.
@paulag queries are of great help as well. Many thanks to her.

The query used to get vote information was
Source = Sql.Database("", "DBSteem", [Query="SELECT#(lf)*#(lf)FROM #(lf)Txvotes (NOLOCK)#(lf)#(lf)WHERE [voter] in ('actifit','','dlike','dtube','esteemapp','partiko','steemhunt','steempress-io','tasteem','utopian-io','steempeak, steem-ua')#(lf)and CONVERT(DATE,timestamp) BETWEEN '2018-11-20' AND '2018-12-20'"]), #"Added Custom" = Table.AddColumn(Source, "% weight", each [weight]/10000), #"Changed Type" = Table.TransformColumnTypes(#"Added Custom",{{"% weight", Percentage.Type}}), #"Added Custom1" = Table.AddColumn(#"Changed Type", "Current vote worth", each 95.44), #"Added Custom2" = Table.AddColumn(#"Added Custom1", "approx vote $", each [Current vote worth]*[#"% weight"]), #"Changed Type1" = Table.TransformColumnTypes(#"Added Custom2",{{"timestamp", type date}, {"approx vote $", type number}})

The query used to get posts information was
Source = Sql.Database("", "DBSteem", [Query="SELECT#(lf) author,#(lf)json_metadata,#(lf) permlink,#(lf) total_payout_value,#(lf) pending_payout_value,#(lf) net_votes,#(lf) created,#(lf) children,#(lf) Category,#(lf) Depth#(lf)#(lf)FROM comments (NOLOCK)#(lf)where CONVERT(DATE,created) BETWEEN '2018-11-20' AND '2018-12-20' and#(lf)contains (json_metadata, 'actifit')#(lf)#(lf)#(lf)#(lf)"]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"created", type date}})

GitHub Account

All the best

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:  

Hi @dalz, nice overview of the current state! We've had a couple of posts in that direction in the last few weeks, like @miniature-tiger's monthly dapp analysis, Asher's Application Usage and @paulag's exploratory analysis. Yours fits well in that line, providing some additional aspects especially from the perspective of dapps supporting their users! You've mentioned your previous analysis, but including/visualizing a larger timescale on these aspects could maybe have provided some additional insights? What were your criteria for the selection of dapps to include here? From user count perspective, apps like steempeak, steepshot or musing could play in that league as well. I like that you mentioned steemmonsters and magic dice! I haven't seen many stats on them lately, and they unfortunately do not fall into the scope of utopian contributions either, but getting numbers on those could be an interesting topic as well! :)

Your contribution has been evaluated according to Utopian policies and guidelines, as well as a predefined set of questions pertaining to the category.

To view those questions and the relevant answers related to your post, click here.

Need help? Write a ticket on
Chat with us on Discord.


Thanks for the detailed review @crokkon.
I really appreciate the feedback that you are giving me.

dApps are intersting topic and there is a focus on them lately, as we can see from the other analysis that you mentioned.

I agree that including a visualizations on the larger timescale is something that will be interesting to see. Will work to provide that in the future.

About the selection on dApps, I got the data for steepshot and steampeak as well. But the number of users they suported was very small, thats way I didn't inculde them. But they have some decent activite on their platform.


Thank you for your review, @crokkon! Keep up the good work!

great work @dalz. Excel is a fantastic tool to use for data analysis. I am getting more active here now on steem with my brand account @theexcelclub, you may find some useful stuff being posted there over the coming weeks and months ;-)


Thanks @paulag!
I took your advice and put all the dapps in the voter query. It helped a lot :)
I have noticed your work with the @theexcelclub and will follow it closley.

Happy New Year!
Wish you a good health and a lot of success.


Just a quick question @paulag, if you have the time.
I'm trying to separate no of posts from comments.
I'm doing this in the depth column. 0 for posts, and greater then 0 for comments. Is this the right way?


yes this is correct


Thank you :)

Hi @dalz!

Your post was upvoted by @steem-ua, new Steem dApp, using UserAuthority for algorithmic post curation!
Your UA account score is currently 2.965 which ranks you at #10735 across all Steem accounts.
Your rank has dropped 17 places in the last three days (old rank 10718).

In our last Algorithmic Curation Round, consisting of 163 contributions, your post is ranked at #146.

Evaluation of your UA score:
  • Only a few people are following you, try to convince more people with good work.
  • The readers like your work!
  • Try to work on user engagement: the more people that interact with you via the comments, the higher your UA score!

Feel free to join our @steem-ua Discord server

Hi, @dalz!

You just got a 3.75% upvote from SteemPlus!
To get higher upvotes, earn more SteemPlus Points (SPP). On your Steemit wallet, check your SPP balance and click on "How to earn SPP?" to find out all the ways to earn.
If you're not using SteemPlus yet, please check our last posts in here to see the many ways in which SteemPlus can improve your Steem experience on Steemit and Busy.

Congratulations! Your post has been selected as a daily Steemit truffle! It is listed on rank 1 of all contributions awarded today. You can find the TOP DAILY TRUFFLE PICKS HERE.

I upvoted your contribution because to my mind your post is at least 10 SBD worth and should receive 262 votes. It's now up to the lovely Steemit community to make this come true.

I am TrufflePig, an Artificial Intelligence Bot that helps minnows and content curators using Machine Learning. If you are curious how I select content, you can find an explanation here!

Have a nice day and sincerely yours,


Well thanks ....No 1 :)

Posted using Partiko Android

Hey, @dalz!

Thanks for contributing on Utopian.
We’re already looking forward to your next contribution!

Get higher incentives and support!
Simply set as a 5% (or higher) payout beneficiary on your contribution post (via SteemPlus or Steeditor).

Want to chat? Join us on Discord

Vote for Utopian Witness!