## November is a Wrap!
#
Gathering data of Utopian-io is extremely fun, and its a good way for me to contribute to the platform. Being able to share this type of analysis of how *Utopian-io* behaves as a whole, how the contributors we're rewarded, and who among them stood out for this amazing initiative.

Thanks to the people behind who made me realize creating this type of contribution will somehow impact. With it, I'd like to say thank you to *eastmael*, *erangvee*, *bitrocker2020*, and *carlgnash* for helping me in terms of Queries and being able to come up with this type of contribution.
#
In this contribution, let's wrap everything about november. The contributions, payouts, votes, and comment engagements made on it with #utopian-io as part of their tags. Basically, we're consolidating everything in this post.
#
## Details of the Analysis
#
- Data were extracted using @arcange's Steem SQL at December 6, 2017 at 4:52 p.m. (UTC +8).
- The Analysis Features a Consolidated Data of November Contributions, Total Votes, Total Payout, and Total Comments gathered.
- The Analysis Also features the Top 10 Contributors per category.
- In Comment Analysis, the data includes comments from the authors, bot's comments, and comments from the users (Which typically can still be considered as a comment), self-upvotes, bot's votes.
- We will exclude *trafficmonitor*, *vertical*, *monitorcap*, and *markboss* in the data (They're just spamming everything).
- We will exclude elear and utopian-io on the data analysis (at a very obvious reason).
- Table, Pie, and Bar Graph will be presented for a better understanding of he analysis.
#
## Contributions/Posts Analysis
#
In terms of the number of posts *(excluding elear and utopian-io, and the bots mentioned above)*, this is the total Contributions submitted : 
#
# <center> "4,694 Posts!"</center>
#
Its an amazing month for Utopian-io, job well done to the team! Here's a Pie Graph of the Top 10 Post Contributors (Posts with #utopian-io as part of their tags).
<center>![](https://steemitimages.com/DQmSnfEibdoYaufZLuBKDLA7Whafjy4dLVcUYSHTV72T3VP/image.png)</center>
#
### And here's a Tabular Form of the Top 10 Contributors
#
<center>Author</center> | <center>Total Posts</center>
-|-|
robin-ho|	93
vladimir-simovic|	63
rosatravels|	61
deveerei|	46
julstamban|	46
marshalllife	|46
ranielbrianulan|	45
ruah|	42
arie.steem|	40
katteasis	|39
#
## Votes Analysis
#
As mentioned, we will eliminate the votes from *utopian-io* and *elear* plus the mentioned spam bots above.
#
# <center>"171,738 Votes!"</center>
#
Amazing numbers! The initiative has garnered a lot of attention! :) Here's a Pie Graph of Most Votes Contributors (Though number of posts is factor)
#
<center>![](https://steemitimages.com/DQmeEoSV9VyZheF81s1iGxP3vr85Xv7UkPazb1wrVtkGDaQ/image.png)</center>
#
### Here's also the tabular Form of the Top 10 Contributors :
#
<center>Author</center> | <center>Total Votes Gathered</center>
-|-|
deveerei	|3292
netuoso|	3154
rosatravels	|3094
flauwy|	2870
stellabelle|	2596
kalvas|	2542
robin-ho	|2440
nehomar|	2414
vitruvianman|	2388
monomyth	|1995
#
## Total Payout Analysis
#
This consolidates the total payout from users with #utopian-io as their tag for. *(excluding elear and utopian-io Payouts)*
#
# <center>"$53,046.97"!</center>
#
Here's Also a Pie Graph of the Top 10 Highest Earners for the Month of November.
<center>![](https://steemitimages.com/DQmd58i9NUcY4FC94DGUtpvdDcqsdnLTGKsvZYR5vzabusz/image.png)</center>
#
### A tabular form of the Top 10 Contributors
#
<center>Author</center> | <center>Total Payout</center>
-|-|
deveerei	|1637.3020
rosatravels	|1270.9350
netuoso	|1224.4790
vladimir-simovic	|1160.0440
julstamban|	960.0880
robin-ho|	936.1620
eastmael	|833.0710
imwatsi	|821.3490
flauwy	|714.1180
stoodkev	|691.1640
#
## Comment Engagement Analysis
#
In this we feature the top 10 Most Engaging Comments and the total Comments Gathered.
#
# <center> "34,903 Comments!"</center>
#
Here's also a pie Graph of the Top 10 Most Engaging Contributors :
#
<center>![](https://steemitimages.com/DQmQnTW9nA6GCv7mg3aiDfUjwyyrPLwC7MxYZQ1JLrA66rn/image.png)</center>
#
## And That Wraps Up the Month of November!
#
This is part of the queries I used :

    count(author) as Posts, 
    sum(net_votes) as upvotes,
    sum(total_payout_value) as Total_Payout,
    sum(children) as Comments
## What are your Thoughts?
#
I am always ending my analysis on by this style, **to ask for your feedback**, **learn from your comments**, or anything you want to say.

are they deserving to be on top? Do you think next month there will be new set of contributors rising? Share us your thoughts! 

<br /><hr/><em>Posted on <a href="https://utopian.io/utopian-io/@jassennessaj/utopian-io-behavior-analysis-wrapping-up-the-month-of-november-with-utopian-io-tag-or-a-consolidation-of-data">Utopian.io -  Rewarding Open Source Contributors</a></em><hr/>