This is an analysis of the voting habits of @utopian-io, @dtube, and @curie over the last 3 months.

The aim of this analysis is to compare the voting 'styles' of the above accounts to find out more information with regards to:

- Voted Steem account reputation - 7/30/90 days
- Unique author coverage
- Popular author vote counts

Each of the above will be analysed over a 7, 30, and 90 period, with an overall analysis summary to conclude.

**Contents**
1. Introduction
2. Votes by Steem account reputation
3. Unique author votes
4. Vote counts - popular authors
5. Summary analysis
6. Tools and queries used to gather data and compile this report
## 

-----------------------

![title.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1517631731/vqbtgxpguvs12jka0a1t.png)

---------------------

## 1. Introduction
##

The 3 accounts analysed in this report are @dtube, @curie, @utopian-io.  I have chosen to compare these accounts to try and guage:

- If there is a best account/application to aim your time at, depending on your reputation
- If these accounts are supporting many users by spreading their vote / loyal to their contributors
- If it is possible to frequently be supported by any of these accounts

### @utopian-io
### 
@utopian-io is the open source project for open source projects, housed on the Steem Blockchain.  @utopian-io joined the Steem Blockchain in September 2017 and holds over **3.6 million Steem power** through delegations from its kind sponsors.

### @curie
### 
> Curie is a meritocratic, voluntary organization which supports the development and growth of new and existing authors on the Steem blockchain. [source](http://curiesteem.com/)
#### 
@curie joined in September 2016 and has 115,000 Steem Power.  However, @curie has a long voting trail that include one of the largest 'user' accounts on the Steem Blockchain.

### @dtube
### 
@dtube is a decentralised video sharing platform and is built on the Steem Blockchain.  Clear comparisions can be made with YouTube, both in name and content.  @dtube currently holds just over 1 million Steem Power through delegations.

------------
#### 
Each of these accounts (and trails) can provide a sizable vote to content deemed worthy by their curation teams/moderators.  Which accounts do they vote for?  How many votes do they give out? Do we have to be a popular author to get a vote?  Perhaps the numbers can provide the answers.

---------------------------
## 2. Votes by Steem account reputation
## 

### 7 day data
###

The following chart show the votes cast by each account over the previous **7 days**.

#### @utopian-io
#### 
![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1517632211/unp5gx97kajzmcgmzuzr.png)

@utopian-io has cast a total of **2212 votes** over accounts which average at a **reputation of 52.97**.

#### @dtube
#### 

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

@dtube has cast a total of **558 votes** over accounts which average at a **reputation of 53.31**.

#### @curie
#### 

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

@curie has cast a total of **981 votes** over accounts which average at a **reputation of 52.93**.

Whilst @utopian-io has cast the most votes, it is @curie that has voted for the lowest average reputation.  @dtube has cast 41 votes for a reputation of 70 or above, whilst @utopian and @curie have voted only once each for an account with 70+ reputation.

------------------
### 30 day data
### 
The following chart show the votes cast by each account over the previous **30 days**.

#### @utopian-io
#### 

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

#### @dtube
#### 

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

#### @curie
#### 

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


### Summary
### 
The data above has been compiled to include the 90 day voting totals and reputation average and listed in the following table.

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

Across each of the time frames analysed, @utopian-io casts the most votes but it is @curie that supports the lowest average reputation.

Over the past 90 days, @dtube has cast over 150 votes to accounts with a reputation of 70 or higher.

From this data, we could suggest that for accounts with a lower reputation have a greater chance of success by posting blog content on Steemit (busy.org and others), and utopian-io.  And accounts with a higher reputation could be more likely to succeed by posting video content on dtube.

---------------------------
## 3. Unique author votes
## 

By looking at the number of votes for unique authors, it is possible to gauge which account is supporting the widest set of users.

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

From the table above, we can see that over the 7 day period it is @utopian-io that casts votes to the widest set of different accounts.  However, when we look at the 30 and 90 days totals, it is @curie that has reached the widest set of unique authors.

It is worth stating here that data should be taken with caution as @curie has the breadth of the Steem Blockchain accounts to target, where as @utopian-io and @dtube are almost exclusively only voting on content posted to their applications.

It is likely the case that there is a smaller subset of authors posting to @utopian-io and @dtube and so the number of unique authors voted for is lower than @curie.

If we compare @utopian-io against @dtube, we can see that there are about 300 more unique votes cast by utopian-io in each time frame analysed.  It would be interesting to see if this figure changes in future.

------------------------
## 4. Vote counts - popular authors
## 

In this section, we look at the vote counts for the top authors by the 3 accounts in this analysis.

### 7 day top author vote count
### 
![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1517640567/b8kqoumuhwws81ltqgds.png)

In the past 7 days, we can see that @curie votes on average, 7 times for the top authors receiving a vote.  This votes are most likely to be 'smaller' votes for budding new authors that have been spotted by the curation team.

Both @dtube and @utopian-io show that it is possible to pick up a vote more than once per day, with the top two @utopian-io authors receiving an average of over 3 votes each day over the last 7 days.

### 30 day top author vote count
### 
![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1517640583/ybvhisgy9srjeicx3d5g.png)

### 90 day top author vote count
### 
![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1517640596/ucrkslkmlmwbtmdx8hrn.png)

For both the 30 and 90 days time frames assessed, the trend continues with @curie voting once each day for the top 20 accounts receiving a vote.

The top 2 @utopian-io accounts have received an average of 2 votes a day for the past 90 days, and one account submitting to @dtube has also almost reached an average of 2 votes in each of the past 90 days.

From these figures, we can say that @curie is again spreading the vote to a wider selection of accounts.

As above, it's likely that this figure is due to a wider available audience to vote for.

The data also shows that their is potentially no limit to the number of votes that can be given to a particular author by both @utopian-io and @dtube.

---------------------------
## 5. Summary analysis
## 

With regards to @dtube, it is reasonable to suggest that with the highest average reputation votes, and larger number of votes to accounts with 70 and above reputation, this account has a slight bias to more 'well established' authors.  It also seems likely that once you have received that first vote, you could well be followed/voted further.

@utopian-io is the clear leader in the total number of votes issued.  We can also see that @utopian-io will vote for an author as often as they submit approved content.  Will only a few votes for reputation above 70, @utopian-io votes a lot for newer authors.

@curie has the lowest reputation average across all 3 time frames. This shows a clear willingness to support new authors.  With over 3000 unique author votes in the past 90 days, @curie also supports the widest selection of authors - this is complimented by the general average of 1 vote each day for each author in the top 20 vote total for each time frame.

------------------------
#### 
From this analysis, I would suggest that newer authors might be best contributing content via Steemit (busy.org etc.) and @utopian-io.  Whilst more established accounts, could perhaps look to @dtube, if they are willing to submit video content.

However, if the content is up to the desired quality, it is very possible for any author to receive a votee from @utopian-io, @dtube, or @curie.

A future analysis could be done based on the above, but with the inclusion of more 'community accounts/applications' and with an inclusion of the number of followers that the accounts receiving votes have.

---------------------
## 6. Tools used to gather this data and compile report
##

The data is sourced from SteemSQL - A [publicly available SQL database](https://steemit.com/steemit/@arcange/steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data) with all the blockchain data held within (Data is normally 1/2 hours delayed from live)

The SQL queries to extra to the data have been produced in both SQL Server Personal Edition and LINQPAD 5.

Code examples:

#### Popular authors - 7 days
![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1517642374/wwgnkebj282sfgo81dey.png)

#### Distinct authors - 7 days
![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1517642409/vcdmun0iyi1gkpuzuouv.png)

#### Vote count - 7 days
![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1517642515/ekvldxvbg1yzgstlb2jx.png)

The charts used to present the data were produced using MS Excel.

----------------------------------------------

<sub>This data was compiled on the 2nd February 2018 at  11:00 pm (UCT+4)</sub>

<sub>I am part of a Steemit Business Intelligence community. We all post under the tag #blockchainbi. If you have analysis you would like to be carried out on utopian-io/Steem data, please do contact me or any of the #blockchainbi team and we will do our best to help you.</sub>

---------------------
<br>

Thanks

Asher @abh12345
    

<br /><hr/><em>Posted on <a href="https://utopian.io/utopian-io/@abh12345/voting-analysis-is-curie-still-the-best-community-support-account">Utopian.io -  Rewarding Open Source Contributors</a></em><hr/>