Introduction

What is a DAO?

a Decentralized Autonomous Organization (DAO) is a community with a shared bank account. Members of the DAO make decisions in a transparent and decentralized fashion, with smart contracts executing these decisions.

For instance, a member can create a proposal suggesting an investment of the treasury or a program upgrade. The DAO members then come together to vote on the proposal. If a predefined quorum votes for the proposal to pass, the proposal is accepted and executed by a smart contract.

As a result, the DAO structure provides a “flat” organizational structure. Each DAO member has a voice in the community and the opportunity to drive the direction of the organization.

What is Realms?

Realms is a tool to help the community thrive on Solana DAO creation, voting, and treasury management, all in one fully on-chain product. Whether managing a multi-sig or a billion-dollar protocol, Realms has the tools to enable the community to reach its full potential. Realms provides a platform for builders on Solana to create a DAO, manage their members, vote on proposals, and allocate their treasury. Whether you are running a multi-sig, NFT community DAO, or community token DAO, Realms has the tools and integrations to help your community flourish. Realms serves as the frontend for SPL Governance, a DAO-type and asset-type agnostic standard for building and maintaining DAOs on Solana.

Some of the thriving communities are Grape, UXD, Mango, Monkes & 800+ more DAOs

Methodology

For this bounty, First (and the key to the bounty solution I guess), I have extracted the realms_id of each requested DAO from “pubkey” on “Params” section of each DAO landing page.

(For example, this is the landing page for Mango DAO and from this param page, we can extract the provided “pubkey” which is DPiH3H3c7t47BMxqTxLsuPQpEC6Kne8GA9VXbxpnZxFE and is equal to realms_id on Solana.core.fact_proposal_votes table)

Then, I have used Solana.core.fact_proposal_votes table to track requested metrics for the mentioned DAOs as below. (the “mark” column acts as a helper to visualize the date of creation for each DAO)

Moreover, there are two columns that are related to the voters: VOTER and VOTER_ACCOUNT, for realizing which one is the correct one to identify the voter address, I have extracted a voter address from a DAO on realms website and queried it on the Solana.core.fact_proposal_votes table, then I realized the “VOTER” column is related to our assumed unique voter. but anyway, I have brought “Voter_Account” column as (Account) in the table.

Also, I have just considered the successful votes (SUCCEEDED = ‘TRUE’) for this analysis.

==(Since the starting date for these metrics on Flipside tables is 1 December 2021, the results are for this timespan, and any data before this date is not included in this dashboard. So, since we are using min(block_timestamp) to find the creation date of each DAO, if the DAO was created before 1 December 2021, the result may not be accurate then)==

Conclusion

Based on the above analysis, we have realized the below data for "Mango, Grape, Psy Finance, Solend, MonkeDAO, Metaplex, Jet, Serum, The Imperium of Rain and Synthetify DAOs (Timespan is >= 1 December 2021)

• There are total 2450 unique users who have voted on these DAOs. The total number of successful votes made by these voters is 9678 and these votes were made on 596 unique proposals.
• The Imperium of Rain DAO has by far the most number of voters among all other DAOs. but the number of cast votes on Grape DAO is more than other DAOs.
• The number of executed proposals on MonkeDAO DAO is more than other DAOs.
• Serum is the oldest created DAO and Solend is the most newbie one.
• The Proposal 4V7XqPYMiKg6Lt5JimTCVsmmFw3ybMV5vgE1cngfiwkD on MonkeDAO is currently the newest executed proposal among all DAOs proposals.
• The most votes were cast during April and May 2022 on these DAOs.
• Traces of Grape and Mango votes are visible and distributed on almost all days. Despite Serum and The Imperium of Rain that their votes are cast suddenly and created some high spikes.
• The most number of proposals on these DAOs were created on 20th April 2022 and it’s mainly because of MonkeDAO with 17 created proposals in one day.
• There are more and more numbers and traffic of daily created proposals over time which we can barely see a day without any created proposals during recent months (despite the first months).
• The Imperium of Rain DAO proposals are the most popular ones and attracted the most number of votes and voters.
• The most popular proposal in both terms of the number of votes and votes among all proposals on these DAOs is 9aLYCv1sazi2uvv1GAEHS68hx4JWrmMSd7ywCivT7cmj. The title of this executed proposal is “Fourth Time’s a Charm” and it’s about Sending 1 RAIN to TRASH!
• The proposal with the most number of “NO” votes is HuaL6cDtuNtfnJgvwMnYiZDHVCoLAuDtVFgJD8kYChJ4 on Solend DAO, however, this proposal was successfully completed anyway.

==Discord: Ali3N#8546==

Based on the left chart, the number of “YES” votes on proposals on all DAOs is way way more than “NO” ones and this means the most number of proposals have executed succesfully and their members agreed with the executed proposal.

Based on the above data, there are total 2450 unique users who have voted on these DAOs. the total number of successfull votes made by these voters is 9678 and these votes were made on 596 unique proposals.

Based on the above charts, The Imperium of Rain DAO has by far the most number of voters among all other DAOs. but the number of cast votes on Grape DAO is more than other DAOs (The Imperium of Rain is on the second rank here)

Based on the above left chart, the number of executed proposals on MonkeDAO DAO is more than other DAOs and on the second rank we have Mango DAO which second highest number of executed proposals.

On the above right chart, we can see the distribution of creation date of each DAO over time. As we see, Serum is the oldest created DAO and Solend is the most newbie DAO.

On the above table, we can see the executed date of last proposal on each DAO and the relevant proposal. As we see, the Proposal 4V7XqPYMiKg6Lt5JimTCVsmmFw3ybMV5vgE1cngfiwkD on MonkeDAO is currently the newest executed proposal among all DAOs proposals.

According to the above chart, most number of votes were cast during April and May 2022 on these DAOs and these high spikes are mainly because of cast votes on The Imperium of Rain DAO.

Totally, we can almost see traces of Grape and Mango votes in all days of the above chart. despite Serum and The Imperium of Rain that their votes are cast suddenly and created some high spikes on the chart.

Based on the above chart, the most number of proposals on these DAOs were created on 20th April 2022 and its mainly because of MonkeDAO with 17 created proposal on one day.

Totally, we can see more and more number and traffic of daily created proposals over time which we can barely see a day without any created proposals during recent months (despite first months of the chart)

On the above charts, we can see top 30 executed proposals on these DAOs based on their number of votes and also voters.

As we see, The Imperium of Rain DAO proposals are the most popular ones and attracted the most number of votes and voters.

Totally, as we see, the top 30 executed proposals belong to 5 DAOs (The Imperium of Rain, PSY Finance, Solend, Jet and Grape) and there is no trace of other DAOs proposals on the top 30 list.

The most popular proposal in both terms is 9aLYCv1sazi2uvv1GAEHS68hx4JWrmMSd7ywCivT7cmj. The title of this executed proposal is “Fourth Time’s a Charm” and its about Sending 1 RAIN to TRASH!

On the left chart we can see the top 5 rejected proposals based on number of “No” votes on them and also their relevant DAO.

As we see, the share of Grape DAO on rejected proposals is more than all DAOs.

Also, the HuaL6cDtuNtfnJgvwMnYiZDHVCoLAuDtVFgJD8kYChJ4 proposal on Solend DAO has the most number of “NO” votes among all other proposals on these DAOs. however, this proposal was successfully completed anyway. the subject of this proposal was about Enacting special margin requirements for large whales that represent over 20% of borrows and grant emergency power to Solend Labs to temporarily take over the whale's account so the liquidation can be executed OTC. (because the largest user on Solend (3oSE9CtGMQeAdtkm2U3ENhEpkFMfvrckJMA8QwVsuRbE) had an extremely large margin position that was putting Solend protocol and its users at risk.)