Steempress Steem Dapp - 12 Month Data Analysis

in #analysis5 years ago

 Steempress – Posting from Wordpress to Steem

@Steempress-io has been in receipt of funding from Steemit Inc by way of delegation from @misterdelegation to the tune of just over 1M SP for over 12 months now.  The owned SP for @steempress-io is currently 11K SP

Repository

https://github.com/steemit/steem

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 Year June 18 to May 19.  Data from the STEEM blockchain and Coinmarketcap was used and full details of the queries can be found at the bottom of this post.  The user prifling and correlation tests were carried out on data for the last 3 months.

The value of a vote for Steempress-i0 was taken from steemworld.org on 25th June.

Findings

• 20% of Steempress posts and comments received a vote from @Steempress-io

@Steempress votes make up 29.3% of the gross payouts on Steempress posts. (The lower the value found here the better)

• Over US$293 in gross payouts was earning by authors using Steempress.

• There is no correlations on voting behaviour that give rise to further investigations.

• The user based voted on has relatively the same profiling as the user base posting with the exception of % of posts made via Steempress relative to all posts made, Steempress tends to support loyal consistent users.

Activity on Steempress June 18 to May 19

  

365K posts were made by 5224 authors and received 93K  comments from 9244 authors and the comments grossed a payout of SBD$1.13  from 26K votes.

The time series shows a drop in Posts and Comments after HF20 along with a total post payout reduction decline begin just after the HF

The posts also netted over 10M votes with a gross payout of SBD$293.92.

In US$ this equates to $297.74  in gross payouts.  We can see from the below July 18 had the highest payouts in US$ while prices were above $1 and Dec 18 the lowest, where we also seen the lowest US$ Steem pricing.

 

Votes From Steempress

  

1796 distinct Authors on both posts and comments, received in total 74K votes from Steempress over the year.  The average vote weight was 5.14% giving a vote of approx. 1.26 SBD.  In total Steempress have funded 92.93K SBD by way of upvotes.

If we look at this in US$ we can see that Steempress votes have awarded payouts to the tune of US$85.97K

  

20% of Steempress posts and comments received a vote from @Steempress

@Steempress votes make up 29.3% of the funding earning on Steempress posts and comments

Movers and Shakers

The table below shows the top authors by way of Steempress votes received

  

 The most active posters are shown in the table below

   

The table below shows the readers most active in comments

     

Correlation tests on Steempress Voting

These tests were only carried out on the data for the last 3 months

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.107 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.04 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.  It appears that there is a very small positive correlation (0.227) between these values

     

The fourth 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.  This tests were only carried out on data for the last 3 months

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.  356 account made >96% of their posts to Steempress.  124 of these were supported.  On the other end of the scale 986 people had <=16% of their steem posts to Steempress and 288 of these were supported.  From this we can tell that Steempress tend to favour loyal users.

 

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 12KSP 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.

20% of posts and comments made via steempress get a vote from steempress.io, this coupled with the correlation tests and user profiling indicates some sort of manual curation or account review.

29.3% of post payouts were funded by steempress.  This is not a bad value as steempress is funded by @misterdelegation and should they lose that delegation, steempress users stand to see this much of a reduction in their payouts.  Therefore the lower the value the better.

The voting habits and user profiling didn’t reveal anything that would cause a need for further analysis or anything to suggest misuse of delegated stake.

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-06-01' AND '2019-05-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-06-01' AND '2019-05-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=20190631")),
    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"


Sort:  

I never knew the steempress like this. Is it a form of WordPress on steemit

steempress is an app that will post your wordpress blog to steem :-)
you can see it in action here https://theexcelclub.com/power-pivot-orientation/

Hmmm. Only numbers. No Bon Jovi ;)

Posted using Partiko Android

lol yep, I got to the numbers in the end, although you cant get better than a live bon jovi gig :-)

Bon Jovi concerts are dank af - as the kids might say :D

Incredible to see the impact of HF20.

Posted using Partiko Android

Congratulations @paulag! You have completed the following achievement on the Steem blockchain and have been rewarded with new badge(s) :

You distributed more than 39000 upvotes. Your next target is to reach 40000 upvotes.

You can view your badges on your Steem Board and compare to others on the Steem Ranking
If you no longer want to receive notifications, reply to this comment with the word STOP

To support your work, I also upvoted your post!

Vote for @Steemitboard as a witness to get one more award and increased upvotes!

Thank you so much for participating in the Partiko Delegation Plan Round 1! We really appreciate your support! As part of the delegation benefits, we just gave you a 3.00% upvote! Together, let’s change the world!

Hi @paulag!

Your post was upvoted by @steem-ua, new Steem dApp, using UserAuthority for algorithmic post curation!
Your UA account score is currently 8.075 which ranks you at #17 across all Steem accounts.
Your rank has not changed in the last three days.

In our last Algorithmic Curation Round, consisting of 173 contributions, your post is ranked at #1. Congratulations!

Evaluation of your UA score:
  • Your follower network is great!
  • The readers appreciate your great work!
  • Great user engagement! You rock!

Feel free to join our @steem-ua Discord server

Hey, @paulag!

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

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

Want to chat? Join us on Discord https://discord.gg/h52nFrV.

Vote for Utopian Witness!

Hi @paulag

I hope you won't mind this comment (it's not really related in any way to your current publication).

I've been just wondering if you joined PALnet airdrop (PALnet is a token build on Steem-engine).

If you didn't claim it then perhaps I could ask you for small favour. Would you consider claiming your tokens and selling or delegating it to me for few months? I would obviously pay you some STEEM for those tokens (I can even pay for delegation - I want to invest some time and money into that platform).

How to claim your token?

a) login in http://palnet.io/ (it's build on STEEM blockchain, so you will use same login details)
b) login in steem-engine.com
c) claim your tokens -> to do that you need to open steem-engine.com and go to "wallet". In left-top corner you will have PALnet (blue colour) logo. Click on it and claim your PAL tokens.
d) go to your palnet wallet and either transfer your PAL tokens to crypto.piotr or STAKE it and delegate to me (click STAKE and then "advanced" and simply type in my username).

Amount of received tokens depend mostly on your current level of SP (I'm not sure if delegations are being taken into consideration as well).

So based on my current experience, if you have 200 STEEM POWER then you should be able to receive something around 100-150 PALnet tokens.
I would pay you 10 STEEM for purchasing each 100 of those PAL tokens. So basically you can earn something and help me grow on this particular platform, making both of us happy :) Plus you would sell/delegate those tokens without bringing down their current price (you won't need to dump them on exchange).

You would earn some extra STEEM and I would have higher STAKE in this platform.

I've only 500 STEEM I can spent on that purpose (plus airdrop will not last forwer) so HURRY UP :) :)

Cheers,
Piotr

Coin Marketplace

STEEM 0.35
TRX 0.12
JST 0.040
BTC 70597.89
ETH 3559.60
USDT 1.00
SBD 4.77