**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 was previously in receipt of funding Steemit Inc by way of delegation from Misterdelegation. However this funding has now been revoked.

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.
If you missed last months post you can read it here
https://steemit.com/utopian-io/@paulag/feb-18-zappl-steem-app-analysis-blockchainbi

## 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

### March @Zappl Votes Analysis

 ![image.png](https://cdn.utopian.io/posts/0e519bf440fc188a22c71a39c86873946315image.png)

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

In March 2018 Zappl voted 15K times for 4339 Authors. The average vote pay out was SBD $1 and the total approx. pay out given by Zappl was SBD $40.06 We can also see from above that the average % voting weight used by @Zappl was .69% and the average number of votes given per day was 483.

We can see also that the voting from @zappl came to an almost complete halt after the 11th March.
In addition to this the vote value reduced from $103.45 to only $0.40 as the delegation was removed by Misterdelegation

For comparison 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.

### March Voting Time Series

 ![image.png](https://cdn.utopian.io/posts/3b5fcc0320af508cbecb34cfa86830208d28image.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.  It is disappointing to see the drop off in votes, although I am sure this is down to the removal of delegation.

### Popular Steemains in terms of Upvotes from @Zappl

![image.png](https://cdn.utopian.io/posts/ca4fcf127ef6455b052eb9a8b3a946696b91image.png)
 
### Zappl Tag Post Analysis

![image.png](https://cdn.utopian.io/posts/f062cfecc8cf80130e7e598afd711d8956e3image.png)
 
The visualisation above show all postings – both Posts and Comments made in the category/tag for #zappl in March 2018

In March 48K posts were made by 7955 authors receiving 49K comments and 334K votes. The pay-out value of these posts was SBD $15.50K

For comparison 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.

We can see when Zappl stopped voting, there was also a steep decline in posting.

The average post pay out in Feb for #Zappl posts was $3.10 substantially up from the $0.48 in Feb.
These 48K posts received 49K comments from 8,503 authors. The comments received 11K votes and received rewards of SBD $1.10K

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

![image.png](https://cdn.utopian.io/posts/a6f3b5a370912c83fa64daec52ed33f90b89image.png)

 
And the list below shows those that engage with the posts via comments

![image.png](https://cdn.utopian.io/posts/3873022e90e1b101476555dfd36099ce82afimage.png)

 
## Conclusion
The Stats for Zappl this month show major changes.  Delegation has been removed and the vote from Zappl is no longer sizeable. 

This has had a major impact on activity.  Both the number Votes made by @zappl and the number of posts have taken a hit.  Although the first two weeks of March saw almost the same number of posts as all of February.

It is also worth pointing out that the value of the vote for @zappl was taken 10 April.  Delegation was removed during the month and some of the votes were made with the delegation in place.  Therefore the payout values shown are not accurate.

### The SQL Queries

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

``` language
 SELECT    *
 FROM Txvotes (NOLOCK)
 WHERE [voter] in ('zappl')
  AND CONVERT(DATE,timestamp) BETWEEN '2018-03-01' AND '2018-03-31'
```

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

``` language
 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-03-01' AND '2018-03-31'
  and json_metadata like ('%"zappl"%')
```


The Current vote worth for Zappl has been taken from https://steemworld.org/@zappl at 10th April 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/march-18-zappl-steem-app-analysis-blockchainbi">Utopian.io -  Rewarding Open Source Contributors</a></em><hr/>