Engagement is the foundation of any society.  Without it, society crumbles.  Strong engagement, on the other hand, allows society to grow beyond its initial boards.  It allows every member to benefit from positive growth.  When a society begins to stagnate or decline, engagement is the thing that can restore it to greatness.  
<center>https://files.peakd.com/file/peakd-hive/scholaris/RWmoWX1a-network-3537401_1280.jpg</center><center>Image by <a href="https://pixabay.com/illustrations/network-earth-block-chain-globe-3537401/" class="keychainify-checked">Gerd Altmann</a> from <a href="https://pixabay.com/?utm_source=link-attribution&amp;utm_medium=referral&amp;utm_campaign=image&amp;utm_content=3537401" class="keychainify-checked">Pixabay</a></center>
<center>https://files.peakd.com/file/peakd-hive/scholaris/mrqKjrZh-pg20divider2001.png</center>
# Lifeblood of Leo Finance
<center>https://files.peakd.com/file/peakd-hive/scholaris/B1XkXmeI-adventure-1807524_1280.jpg</center><center>Image by <a href="https://pixabay.com/photos/adventure-height-climbing-mountain-1807524/" class="keychainify-checked">Sasin Tipchai</a> from <a href="https://pixabay.com/?utm_source=link-attribution&amp;utm_medium=referral&amp;utm_campaign=image&amp;utm_content=1807524" class="keychainify-checked">Pixabay</a></center>

Engagement is the lifeblood of Leo Finance.  Its leadership takes into account user and community input and data from outside the community to determine the best path forward for the group.  

Users contribute towards the Leo community's value by investing in the platform, creating and curating posts, and providing critiques and recommendations to the community.  Arguably, no one part of the community supersedes the other.  Leo can only grow if everyone participates smartly.

I know Leo does well, but ***how well?***  Does Leo perform outside of a standard?  Is Leo Finance at the top of Engagement metrics?  Metrics on community performance are available, but I would like to expand that view to performance predictions ultimately.  

<center>https://files.peakd.com/file/peakd-hive/scholaris/mrqKjrZh-pg20divider2001.png</center>

# Performance Indicators
<center>https://files.peakd.com/file/peakd-hive/scholaris/8FabGaA3-belly-2354_1280.jpg</center><center>Image by <a href="https://pixabay.com/users/publicdomainpictures-14/?utm_source=link-attribution&amp;utm_medium=referral&amp;utm_campaign=image&amp;utm_content=2354" class="keychainify-checked">PublicDomainPictures</a> from <a href="https://pixabay.com/photos/belly-body-calories-diet-exercise-2354/" class="keychainify-checked">Pixabay</a></center>

### Indicator Basics
<center>https://files.peakd.com/file/peakd-hive/scholaris/iZCaj1OI-certification-571151_1280.jpg</center><center>Image by <a href="https://pixabay.com/illustrations/certification-quality-control-571151/" class="keychainify-checked">Gerd Altmann</a> from <a href="https://pixabay.com/?utm_source=link-attribution&amp;utm_medium=referral&amp;utm_campaign=image&amp;utm_content=571151" class="keychainify-checked">Pixabay</a></center>

How do we measure a thing?  In terms of engagement, I've been taught in the community that the following questions are important performance indicators:
- How many people vote on a post?
- How many people comment on a post?
- Where does #LeoFinance stand in this analysis?

As a side note, I've always wondered which months, days of the week, and times of the day had the highest engagement. My goal was to analyze the following items, over the course of 2020, via Hive SQL:
- Number of votes for posts by community
- Number of post responses by community

### Method of Analysis
<center>https://files.peakd.com/file/peakd-hive/scholaris/cTfnE5jf-strategy-3224515_1280.png
</center><center>Image by <a href="https://pixabay.com/illustrations/strategy-arrows-building-startup-3224515/" class="keychainify-checked">Gerd Altmann</a> from <a href="https://pixabay.com/?utm_source=link-attribution&amp;utm_medium=referral&amp;utm_campaign=image&amp;utm_content=3224515" class="keychainify-checked">Pixabay</a></center>

Thanks to the HiveSQL databases, anyone in the community can help data mine the Hive database.  In an article entitled, ["HiveSQL is ready with all the Hive blockchain data"](https://peakd.com/hive-146513/@arcange/hivesql-is-ready-with-all-the-hive-blockchain-data), @arcange discusses the process to gain access to the Hive databases.  

I utilized Microsoft Access & Excel 365 for querying the databases and shaping the data into the charts we'll discuss shortly.  I have also narrowed my search to meet the following criteria:
- Only Hive communities starting with "HIVE-" are included in the search due to technical limitations at this time.
- Posts created between 1/1/2020 and 12/31/2020 are considered for this analysis

Overall, 2189 communities were included in the analysis for this post.  

<center>https://files.peakd.com/file/peakd-hive/scholaris/mrqKjrZh-pg20divider2001.png</center>

# 2020 Hive Community Trending Results
<center>https://files.peakd.com/file/peakd-hive/scholaris/RWaixIXV-motogp-1280311_1280.jpg</center><center>Image by <a href="https://pixabay.com/users/angelo_giordano-753934/?utm_source=link-attribution&amp;utm_medium=referral&amp;utm_campaign=image&amp;utm_content=1280311" class="keychainify-checked">Angelo Giordano</a> from <a href="https://pixabay.com/photos/motogp-valentino-rossi-race-1280311/" class="keychainify-checked">Pixabay</a></center>

### Top 10 Total Postings by HIVE Group
<center>https://files.peakd.com/file/peakd-hive/scholaris/uA1GMEAM-Top201020Postings.PNG
</center>

The graph above represents total postings during the course of 2020 for HIVE communities.  Out of 2189 communities, Leo Finance is in the top five.

### Top 10 Total Votes by HIVE Group
<center>https://files.peakd.com/file/peakd-hive/scholaris/1seRTL85-Top201020Votes.PNG</center>

The graph above represents total votes during the course of 2020 for HIVE communities.  Out of 2189 communities, Leo Finance is in the top two.

### Top 10 Total Comment Postings by HIVE Group
<center>https://files.peakd.com/file/peakd-hive/scholaris/1rm9y3Uj-Top201020Posting20Responses.PNG</center>

The graph above represents total comment postings during the course of 2020 for HIVE communities.  Out of 2189 communities, Leo Finance is also in the top two.

<center>https://files.peakd.com/file/peakd-hive/scholaris/mrqKjrZh-pg20divider2001.png</center>

# In Closing
<center>https://files.steempeak.com/file/steempeak/scholaris/PFkmcoIN-image.png
Image by <a href="https://pixabay.com/users/geralt-9301/?utm_source=link-attribution&amp;utm_medium=referral&amp;utm_campaign=image&amp;utm_content=2490552">Gerd Altmann</a> from <a href="https://pixabay.com/?utm_source=link-attribution&amp;utm_medium=referral&amp;utm_campaign=image&amp;utm_content=2490552">Pixabay</a>
</center>

Thank you for joining me on my first journey datamining HIVE.  

It seems that Leo Finance is in the top 5 of HIVE communities in posts, votes, and posting comments.  I see community members speaking nothing but good about this platform.  It's quite impressive to see that their comments about Leo Finance are true.  

Also, I'm just amazed at the level of interaction within the HIVE community.  There is so much interaction here that I initially questioned the very numbers I saw in the data stream.  

Moving forward, I will be able to produce the data and graphs automatically.  Also, I would like to include the following metrics in subsequent postings:
- Engagement and curation by date-time
- Expanding the analysis to all communities though I'll have to focus on the "HIVE-" groups for now.  

Posted Using [LeoFinance <sup>Beta</sup>](https://leofinance.io/@scholaris/2020-leaders-of-the-pack)