Steempress is a wordpress plug in that allows you cross post your blog to the steem blockchain
Repository
https://github.com/steemit/steem
https://github.com/drov0/steempress
@steempress.io has been in receipt of funding from Steemit Inc by way of delegation from @Misterdelegation. As one of the newer apps on the block, this is the first analysis I have published on data around steempress-io, and I think it is a project worth showcasing.
Aim of Analysis
• Obtain a general feel for the activity levels on steempress
• Find out how much was paid out in rewards by steempress
• Find out how much posts to steempress earned in total
• See who the movers and shakers are
• Correlation tests on voting habits
• User profiling
Scope of Analysis
The analysis was carried out for the month of October 18. Data from the STEEM blockchain and Coinmarketcap was used and full details of the queries can be found at the bottom of this post.
Findings
• 4% of steempress posts received a vote from @steempress.
• @steempress votes make up 44% of the funding earning on steempress posts.
• Over US$33.55K in gross payouts was earning by authors using steempress.
• There is no correlation with the voting habits of steempress .
• The user based voted on has relatively the same profiling as the user base posting .
Activity on Steempress
17K posts were made by 1484 authors and received 9004 comments from 1902 authors and the comments grossed a payout of SBD$119.08 from 2467 votes.
The posts also netted over 991K votes with a gross payout of SBD$33.66K.
In US$ this equates to $33.55 in gross funding
Votes From Steempress
708 distinct Authors received in total 7269 votes from Steempress in October. The average vote weight was 4.33% giving a vote of approx. 4 SBD. In total Steempress have funded 14.71K SBD by way of upvotes.
If we look at this in US$ we can see that steempress have funded projects to the tune of US$14.62K
4% of steempress posts received a vote from @steempress.
@steempress votes make up 44% of the funding earning on steempress posts.
Movers and Shakers
The table below shows the top earning on Steempress
The most active posters are shown in the table below
Correlation tests on Steempress Voting
A series of tests were carried out to see if there is a correlation between steempress voting
The first test is to see if there is a correlation between the Average voting weight used by steempress and the % of app posts submitted per author that received a vote. A correlation coefficient of -0.122 was found. Therefore we can establish there is no / very weak negative correlation between the voting weight and the % of your posts that get approved.
The second test is to see if there is a correlation between the voting weight used and the % of total posts by an author on STEEM that relate to steempress. A correlation coefficient of -0.058 was found which indicates no correlation
The third test is to see if there is a correlation between the owned SP of the posting account and the average weight used by steempress on the voting. As you can see there is no correlation/very weak positive between these metrics.
The forth test looks for a correlation between the voting weight used and the age of the account that is posting the project. An extremely weak correlation can be found.
User Profiling
I thought it would be interesting to take a look at the user profiling of both those supported by Steempress and those posting to steempress
The Green represents accounts that have received a vote from steempress and the blue include all authors posting to steempress.
The below histogram shows the % of posts an account made to steempress against all their posts on steem. 557 account made >97% of their posts to steempress in October. 287 of these were supported. On the other end of the scale 242 people had <=17% of their steem posts to steempress and 46 of these were supported.
The below histogram shows the age of the STEEM account posting to steempress. The green showing the spread of account voted for and the blue showing the spread of the age of accounts that posted to steempress. Both histograms follow the same pattern
Above we can see the accounts by SP owned and the distribution of both posts and votes seems to be very much in line with each other and the vast majority of accounts have active have 1003SP or less
Below shows the distribution of steempress users in terms of powering down
Above shows the distribution of users in terms of those that power up liquid steem.
Conclusion
Steempress is an amazing project allowing anyone with a wordpress blog connect to the steem blockchain. I would very much encourage you to take a look at the project.
It is positive that the user profiling of the accounts receiving votes follow the same trend as the profiling of accounts posting and it is also very positive that there is no correlation between the voting habits and user account types. This indicates that Steempress is not easily gamed and they are spreading their rewards in manor not favoring any one group.
I would like to congratulate both @fredrikaa and @howo as co-founders of steempress. The potential for this app is amazing and I wish you both and all of your team massive success.
Shameless Promotion
Like what we are doing? Dont forget to vote for @steemcommunity as your steem witness.
Data and queries
Data was gathered in Power BI and Excel From Steemsql held and managed by @arcange.
The M code used to get vote information from steempress was
let
Source = Sql.Database("vip.steemsql.com", "DBSteem", [Query="SELECT#(lf)*#(lf)FROM #(lf)Txvotes (NOLOCK)#(lf)#(lf)WHERE [voter] in ('steempress')#(lf)and CONVERT(DATE,timestamp) BETWEEN '2018-10-01' AND '2018-10-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 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}})
in
#"Changed Type1"
The M code used to post information to steempress was
let
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-10-01' AND '2018-10-31' and#(lf)contains (json_metadata, 'steempress')#(lf)#(lf)#(lf)#(lf)"]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"created", type date}})
in
#"Changed Type"
The M code used to get coinmarketcap data was
let
Source = Web.Page(Web.Contents("https://coinmarketcap.com/currencies/steem-dollars/historical-data/?start=20180101&end=20181031")),
Data0 = Source{0}[Data],
#"Changed Type" = Table.TransformColumnTypes(Data0,{{"Date", type date}, {"Open*", type number}, {"High", type number}, {"Low", type number}, {"Close**", type number}, {"Volume", type number}, {"Market Cap", type number}}),
#"Removed Other Columns" = Table.SelectColumns(#"Changed Type",{"Date", "Close**"})
in
#"Removed Other Columns"
The value of a vote for steempress was taken from steemworld.org on 10 Nov.