Zappl is a fun app built upon the Steem Blockchain that allows you earn STEEM by posting or up voting on short form content up to 240 characters that are just like tweets.

Zappl has received funding from Steemit Inc by way of delegation from Misterdelegation.

The aim of this analysis is to monitor the monthly activity from @Zappl in terms of voting.  It is also to analyse posts made via the Zappl app and posts made to the Zappl category on the STEEM Blockchain.

This analysis will be carried out on a monthly basis so that trends can be established and growth measured.

## The Data 
Using PowerBI, I have connected to the SteemSQL database (paid subscription service held and managed by @arcange).  You can find the full query at the end of this post.

 ## The Analysis

## February @Zappl Votes Analysis

 ![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1520677308/lyz3fcuvvgf3edjphnud.png)

The visualization above show the voting for @zappl in February 2018.

In Feb 2018 Zappl voted 26K times for 4480 Authors.  The average vote pay out was SBD $1 and the total approx. pay out given by Zappl was SBD $24.17K  We can also see from above that the average % voting weight used by @Zappl was .89% and the average number of votes given per day was 928.

## February Voting Time Series

![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1520677335/a8pm0rtrwami0ukyxoiw.png)

 The time series above shows the No of Authors, No of Votes, Average SBD value and the average voting weight used by @zappl each day during the reporting period

## Popular Streemers in terms of Upvotes from @Zappl

![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1520677583/uxffk2eakogtkq5l58xp.png)

 
## #Zappl Tag Post Analysis

![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1520677606/tiq2reb0yueynkoyjoaq.png)
 
The visualisation above show all postings – both Posts and Comments made in the category/tag for #zappl in February 2018

In February 49K posts were made by 6889 authors receiving 126K comments and 255K votes. The pay-out value of these posts was SBD $23.65K.

The average post pay out in Feb for #Zappl posts was $0.48 – substantially lower than the overall post pay out average on the Steemit blockchain.

We see above that Zappl have given out approx. SBD $24.17K.  That equates to 81% of the total rewards for this category/tag/app on both posts and comments.

These 49K posts received 126K comments from 6.18K authors.  The comments received 29K votes and received rewards of SBD $6.18K

## Creators
Below shows which accounts have posted the most to Zappl in the month of February

![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1520677629/jvxas967jxio8s41721c.png)

 
And the list below shows those that engage with the posts via comments
 
![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1520677647/udddjuie1tbsgons1sta.png)


## Conclusion

Zappl is an awesome project, receiving 49K posts in the month of Feb and voting for 26Kof them. This means that almost 1 in 1.8 posts made will be voted on by @Zappl.  @Zappl voted on average +900 times a day in Feb.  I am not sure how much of this is manual curation and how they pick the posts they vote on – maybe someone from the Zappl team could let me know?

81% of the pay out in this category comes from @Zappl. This is rather high and is coupled with a lower than average pay out compared to the total posts on the steemit blockchain.  Zappl needs to both reduce the post dependency on votes from @Zappl and also increase the average post payout. 

The number of commets per post in #zappl for Feb was 2.57 per post.  It’s good to see this level of engagement.

Welcome to the block @Zappl – I wish you every success in with this project. I will be preparing this report on a monthly basis to track the progress of the project.

Do you have any questions or queries on the data above?  If so, please do leave a comment below.

## The SQL Queries
The SQL query used to collect data for votes made by @zappl was:


     SELECT    *
     FROM Txvotes (NOLOCK)
     WHERE [voter] in ('zappl')
      AND CONVERT(DATE,timestamp) BETWEEN '2018-02-01' AND '2018-02-28'


The query used to collect data for posts made to the category/tag Zappl on steemit was:


     SELECT
     author,
      json_metadata,
     permlink,
     total_payout_value,
      pending_payout_value,
      net_votes,
     created,
    children,
    Category,
    Depth
      FROM comments (NOLOCK)
      where CONVERT(DATE,created) BETWEEN '2018-02-01' AND '2018-02-28'
      and json_metadata like ('%"zappl"%')


The Current vote worth for Zappl has been taken from https://steemworld.org/@zappl at 7st March 2018.

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

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


    


<br /><hr/><em>Posted on <a href="https://utopian.io/utopian-io/@paulag/feb-18-zappl-steem-app-analysis-blockchainbi">Utopian.io -  Rewarding Open Source Contributors</a></em><hr/>