Realms is a Tooling to help your community thrive on Solana

DAO creation, voting, and treasury management, all in one fully on-chain product. Whether managing a multisig or a billion dollar protocol, Realms has the tools to enable your community to reach its full potential.

Question:

In this dashboard we are going to see a list of DAOs / multisigs built on SPL Governance, and understand their:

• Number of Members (assuming unique voters is what he means here)
• Total Votes
• Number of Proposals
• Date of Last Proposal
• Date of Creation

and any other interesting metrics for the following DAOs: -Mango -Grape -Psy Finance -Solend -MonkeDAO -Metaplex -Jet -Serum -The Imperium of Rain -Synthetify

Solution:

In this dashboard, we need to realms ID of these 10 DAO. I used this link to find them. Here I show the realms ID of these DAO:

We can find all the above Realms IDs from solana.core.fact_proposal_votes table.

Each DAO is ahead of the others in one measure. It is impossible for any DAO to have more members, more votes, and more proposals combined. In our example, The Imperium of Rain DAO has the most unique voters (members), Grape DAO has the most votes, and Monke DAO has the most proposal created by its users.

On the other hand, calculating these metrics alone is not efficient because some of these DAOs have been created recently and others have been around for months.

For a better understanding and clearer comparison of these DAOs, we consider two other criteria. These two criteria are the creation date of the DAO and the creation date of the last proposal of each DAO.

• creation date of each DAO - min(block_timestamp) for each DAO
• date of the last proposal of each DAO - max(block_timestamp) for each DAO

The following charts can give us a better understanding of the status of each Dao and how members interact with them. Normally, the more time that has passed since a DAO was created, the more votes, and members it has attracted, but is this true?

In the first step, I show these metrics:

• Unique voters - calculate count(distinct voter) for each DAO.
• Total votes - calculate count(distinct tx_id) for each DAO.
• Unique proposals - count(distinct proposal) for each DAO.

Based on the chart, we can see how each DAO is performing over time, rather than how many days it has been created.

The blue line shows the DAOs age in both above charts. The orange line is the total votes on the left chart and the unique voters on the right chart. If the orange line is higher than the blue line, it indicates that the DAO has outperformed its competitors during the time it was created.

So we can say:

Grape DAO has performed well in voting but not in attracting members.

The Imperium of Rain and Solend DAOs have performed well in both voting and attracting members.

This chart shows the date of last proposal of each DAO.

As you can see, not even a month has passed since the last proposal of some DAOs, but more than two months have passed for others.

Grape create the last proposal 2 days ago (Aug 15th).

This chart shows the creation date of each DAO. The left circle means the most long passed from creation date and right circle means the DAO is newer than other one.

In this chart, I used the creation date and the current date to calculate the DAO age.

This data is related to Aug 17, 2022.

The oldest DAO are Mango and Serum DAOs with 259 days and the newest DAO is Solend DAO with 59 days.

Conclusion:

• Among all DAOs I study in this dashboard, The Imperium of Rain DAO has the most unique voters (members), Grape DAO has the most votes, and Monke DAO has the most proposal created by its users.

• The oldest DAO are Mango and Serum DAOs with 259 days and the newest DAO is Solend DAO with 59 days. Based on The age of each DAOs Grape DAO has performed well in voting but not in attracting members.

  The Imperium of Rain and Solend DAOs have performed well in both voting and attracting members, and in my opinion, Serum and Metaplex Foundation DAOs have worst performed in these parameters.