DApps on STEEM - Analyzing Steempress

 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.