Almost a Week of Zappl Data - Lets Dig In - Steemit Business Intelligence

With much excitement on Steemit,  Zappl launched on the 23rd of October and I have heard much chatter about the app in different communities build around Steemit.

Being the new App on the Block, I though it would be a good idea to look at the first (almost) week in Zappl’s life through the blockchain data.

As always I have used Power BI to connect to  @arcange  SQL database and I have taken data from the 23rd October to 30 October @ 22:30 GMT

When I originaly decided to do this analysis, my though was on filtering the Comments table by the category Zappl. However a post from @crokkon brought to my attention that included within the Json column is the app from which the posting was made.  

Using Power BI it is possible to parse a json column in the dataset, which would enable me extract the apps used to post to steemit.  I was then going to filter the table based on Zappl/0.1. 

This did not work.  It seems because I parsed the json column and created a new column for the apps, a filter on the new column will not pass back up the chain to the database.

My workaround for this is to filter the Json column to rows that only contain ""app"":""zappl/0.1""" and not bother with the parsing.

Lets see how Zappl is Performing

In total there have been 599 posts and 117 comments made via Zappl by 269 unique authors. Averaging at +100 posts per day

The column charts below show the total posts and comments by day.  Zappl was not live for the full day on the 23rd and also today 30 Oct is not yet complete

The second column chart represents the same data but showing the breakdown by %

 

In the line chart above we can see the unique daily number of authors on Zappl, peaking this week on the 24th with 96 distinct authors.

The chart below represents post and comments made by time of day

 

The current pending payouts value is $947.84.  this is subject to change as these posts are not yet past the 7 days mark for payouts. This can be further broken down to $943.03 for Posts and $5.81 on comments.  This give an average post value of $1.57

The table below shows the authors sorted by pending payouts and the number of posts or comments made by that author via Zappl.

 

Interesting also is the Categories that posts have been allocated too

   

 As at the time of taking the data, 6117 votes have been made on Posts made via Zappl.  This is not how many Votes were made via Zappl but the general performance of the posts on the Steemit Platform. That gives an average of $0.15 per vote and posts get on average 10.21 votes

How does this compare to Steemit in General?

To get a general perspective on this data I had a look back at the data from the September Posts Benchmarking report.  At this time the average payout for a post was $2.63 and the average vote was worth $0.12.  The average number of votes per post in September was 21.69

Awesome Start to Zappl - well done to the team involved

 I am part of a Steemit Business Intelligence community. We all post under the tag #BIsteemit. If you have an analysis you would like carried out on Steemit data, please do contact me or any of the #bisteemit team and we will do our best to help you... 

You can find #bisteemit  on discord https://discordapp.com/invite/JN7Yv7j