Repository
https://github.com/drov0/steempress
Introduction
SteemPress is a tool that converts any websites to a Steem blog. From blog to blockchain! That is the moto of the project. It is a WordPress plugin that integrates the Steem blockchain on the web. More than 70% of the web pages out there are built with WordPress. Me myself I have played around a little bit with WordPress and have setup a page with it in the past. It is easy to learn and do. Buy the domain, install WordPress, setup a template and of you go. So, a tool to integrate the Steem blockchain into most web pages, with easy setup, can really increase the usage of the blockchain. Plus, you can get a fancy looking web page, with categorization of different topics that you write on, all arranged in a nice way. Not the Steemit interface 😊. Furthermore, one can reach a wider audience, outside the Steem ecosystem, and of course can monetized the content with adds.
@steempress-io was launched in February 2018. It has been around for an almost a year. It is a nice period to do an analysis. At the time this project was launched the crypto space was still flying high, but with the first signs of what to come. The crypto prices dropped by a lot in February 2018, but there was still hope. Later they will go down and down. So, one can say that this project catches some of the euphoria surrounding the crypto space at the time.
In this overview, daily data will be presented for posts that were made through the platform and with the help of the SteemPress plugin. Data like delegations, posts and comments, number of posts and users voted on, average vote worth, number of users and the top Authors that take advantage of this tool.
Scope of Analysis
The analysis was carried out for the period from 01.01.2018 to 31.12.2018. Data from the STEEM blockchain was used and details of the queries can be found at the bottom of this post.
SteemPress Delegations History
Looking at the delegation of a project and the Steem Power in general, gives the sense of the activities that follows.
Here is a graph on SP delegated to @steempress-io in 2018.
Well the graph is quite a simple one to look at, with only one big movement.
SteemPress have started humble, with a delegation of 2k SP in the first part of the year. This continued until 1st of June, when a delegation of around one million SP was received from @misterdelegation. This allows the project to reward authors that use the plugin with votes, incentivize the usage of the tool, and to attract users to its platform.
Except for the big delegation of one million SP from @misterdelegation, SteemPress doesn’t have any additional delegation to its accounts. Maybe a new strategy is needed to be put in place that will bring more delegation from different users to the project.
At the moment @steempress-io holds 1.022.340 SP.
Activity on SteemPress
Activity on the platform is in posts and comments. All of the content from the authors that have installed the plugin in their web is being published on the Steem blockchain as well and it is appearing on all the interaces for the blockcain, like Steemit, eSteem, Busy, Partiko, SteemPeak etc.
The total number of posts and comments is show in the chart below. Data for each day was collected and presented on this graph.
The total number of posts and comments on SteemPress in 2018 is 469.078
Interesting graph 😊.
When I first saw this, I was thinking, man something got wrong in the data, now I will need to go back and check what it is, this will take more time etc. I did the check and it turns out the data is OK. What was happening here is that before the Hardfork in October 2018, this tool was used for a lot of spamming. Content with almost nothing on it, one photo, one sentence was published daily. But, after the Hardfork 20, and the introduction of the new Resource Credit system (RC), when you need to have some SP in order to post regularly, the activity dropped massively. So, it looks like this tool was especially good for spammers. Well all that has come to an end and spamming is reduced by a lot. This is in general for the Steemit platform.
The first activity on the platform started from the beginning of February 2018. It has a sharp increase to a 1000 posts and comments per day, and then stabilize around 600 per day until the end of April. At the end of April, the activity picks up an went to almost 2000 per day until the end of May. Then starting from 1st of June comes the big delegation of SP and more rewards to authors. In the next couple of months the activity is constantly growing reaching 3000 posts and comments daily. Then comes the Hardfork in October, and massive drop in activity. No more spamming. After this the activity went down from 800 a day to a 500 at the end of the year.
Below is a breakdown of posts and comments and their movement in 2018.
The total number of SteemPress posts in 2018 is 394.454.
Now as mentioned above a lot of these posts are spamming. Still there has being a lot of activities on the platform.
Here we can see a similar pattern as in the overall activity. A fast growth in February, steady activity in the next couple of months, and then again, a big growth after May until October and HF20. After the Hardfork the number of posts stabilize itself around 600, with a slow decline to the end of the year. Still this is a steady number of posts a just a small drop having in mind the drop in price in the crypto world in the last months of the year.
The total number of comments on SteemPress in 2018 is 74.624.
Commenting on the platform is almost the same as the previous graphs. It has a bigger drop then the number of posts after October 2018. At the end of the year there is around 150 daily comment on average.
Number of posts voted
I haven’t use SteemPress myself and I’m not entirely clear with the criteria that @steempress-io uses to vote the posts.
Here how the voting looks in 2018.
The total number of posts voted from SteemPress in 2018 was 49.340
SteemPress started voting in the middle of February 2018. Until June it casted around 70 votes on average per day. Then after the big delagtion in June 2018 it increases the number of votes, with a spike in the beginning of June reaching almost 300 votes per day. Until the end of the year the number of daily votes stabilized itself on around 200 votes per day and remained the same.
Number of Authors
The number of Authors that received a vote from @steempress-io is an interesting to follow.
This shows how many users @steempress-io supported with their vote. Below is a chart with a number of monthly users that received vote.
A Total of 1846 users received a vote from SteemPress in 2018.
This is a nice number of users supported by SteemPress. Here as well we can see a steady number of users voted on in the first half of the year, then increase in the number of users voted on starting from June, a small growth until aughust, and then a stable number of around 600 monthly users receiving vote from SteemPress until the end of the year.
Below is a chart with the number of unique users that posted on SteemPress in 2018.
The chart represent the number o unique users, not a daily or monthly active ones. Still we can see that a new users continued to arive to the platfor in all of the 2018. The biggest growth is in June until Aughust, and then it is slowly growing till the end of the year. In the period after August 2018, more than 500 new users posred on the platform. In 2018 a total of 1846 authors posted on the SteemPress platform and received a vote.
Daily Average Vote Value in STEEM
SteemPress is voting with difrent vote weight on the posts. The average weight for 2018 is around 5,6%. Lets see how much is this in STEEM. Below is a chart of daily average worth of SteemPress vote in steem.
The daily average value of the vote in 2018 is around 1,9 STEEM
Here we can clearly see a big increase in the average vote starting from June 2018. This is again because of the big delegation that SteemPress received in June 2018. After an intimal variation in the average daily vote it later stabilize itself on an average 3 STEEM per vote.
SteemPress has generated more than a 100k SP in reward in 2018.
Note to the vote values. These values are not directly from the blockchain, but calculated. For this purpose the daily SP that the account holds is used, then the weight of the vote, and a theoretical value of the 95% SteemPress vote. The curator share is also removed
**This means the values are not 100% accurate but approximate. **
Top SteemPress Authors in 2018
Below is a table with top SteemPress Authors ranked by rewards from Steempress.
No | Author |
---|---|
1 | @sndbox |
2 | @adonisabril |
3 | @flaws |
4 | @bullsvsbears |
5 | @chuuuckie |
6 | @pojan |
7 | @joythewanderer |
8 | @exe8422 |
9 | @talentclub |
10 | @tarazkp |
11 | @chronocrypto |
12 | @sevenfingers |
13 | @bharathi22 |
14 | @elocuenciadsnuda |
15 | @travelfeed |
16 | @irfandogan |
17 | @rachelhanson10 |
18 | @celfmagazine |
19 | @ftlob |
20 | @thewritersblock |
Congratulation to the top SteemPress Author in 2018! You have done a great job integrating the Steem blockchain with the regular web.
On the first place is @sndbox, second is @adonisabril, and on the third place @flaws. If some SteemPress author who is not in the top 20 wants to know the ranking for his account feel free to ask in the comment.
Conclusion
SteemPress is providing a unique tool. A way to integrate the usual web with the Steem blockchain. This is a real tokenization of the web. The project started in February 2018 and gained users and activity in the months that follows. Then in June comes the big delegation from @misterdelegation, and a big growth in activity with a lot of spaming. This continued till October when Hardfork 20 happened and stopped the spamming. After this a nice stable activity happened of the platform with just a small drop in activity that is insignificant compering to the drop in price.
A total of 1846 users posted from the SteemPress platform in 2018, and almost 400.000 posts.
Link to the plugin:
https://wordpress.org/plugins/steempress/
Tools and Scripts
The data was gathered in Excel From Steemsql held and managed by @arcange.
The query used to get vote information was
Source = Sql.Database("vip.steemsql.com", "DBSteem", [Query="SELECT#(lf)*#(lf)FROM #(lf)Txvotes (NOLOCK)#(lf)#(lf)WHERE [voter] in ('steempress-io')#(lf)and CONVERT(DATE,timestamp) BETWEEN '2018-01-01' AND '2018-12-31'"]),
#"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 50),
#"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}})
in
#"Changed Type1"
The query used to get post information was
Source = Sql.Database("vip.steemsql.com", "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-01-01' AND '2018-12-31' and#(lf)contains (json_metadata, 'steempress')#(lf)#(lf)#(lf)#(lf)"]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"created", type date}})
in
#"Changed Type"
The query used to get delegations was
Source = Sql.Database("vip.steemsql.com", "DBSteem", [Query="SELECT#(lf)TxDelegateVestingShares.*,#(lf)Convert(date, TxDelegateVestingShares.timestamp) as [Date],#(lf)Convert(time, TxDelegateVestingShares.timestamp) as [Time]#(lf)FROM #(lf)TxDelegateVestingShares (NOLOCK)#(lf)#(lf)WHERE TxDelegateVestingShares.delegatee = 'steempress-io'"]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Date", type date}})
in
#"Changed Type"
GitHub Account
https://github.com/dalz
All the best
@dalz