[Solana] - Tracking Realms DAOs

    Bounty Question==:

    We now have Solana Realms governace data! Their team would love to be able 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

    Track these metrics and any other metrics that you find interesting for the following DAOs:

    • Mango
    • Grape
    • Psy Finance
    • Solend
    • MonkeDAO
    • Metaplex
    • Jet
    • Serum
    • The Imperium of Rain
    • Synthetify

    Introduction


    What is a DAO?

    At its simplest, 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 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 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 multisig, 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. [Source: Realms Docs]


    Realms Logo

    Results


    Loading...
    Loading...

    Methodology


    The following methods are used in this dashboard:

    • First, all the DAOs in the solana.core.fact_proposal_votes table were obtained. For this purpose, REALMS_ID and ==GOVERNANCE_PLATFORM== columns were considered. which respectively indicates the ID of each DAO in Realms and the desired platform (which in this question clearly meant the Realms platform.)
    • Then the 10 requested DAOs were determined according to the REALMS_IDs extracted from the Realms website.
        when realms_id = 'By2sVGZXwfQq6rAiAM3rNPJ9iQfb5e2QhnF4YjJ4Bip'  then 'Grape DAO'
    	when realms_id = '78TbURwqF71Qk4w1Xp6Jd2gaoQb6EC7yKBh5xDJmq6qh' then 'Jet DAO'
    	when realms_id = 'DPiH3H3c7t47BMxqTxLsuPQpEC6Kne8GA9VXbxpnZxFE' then 'Mango DAO'
    	when realms_id = '2sEcHwzsNBwNoTM1yAXjtF1HTMQKUAXf8ivtdpSpo9Fv' then 'Metaplex Foundation DAO'
    	when realms_id = 'B1CxhV1khhj7n5mi5hebbivesqH9mvXr5Hfh2nD2UCh6' then 'MonkeDAO'
    	when realms_id = 'FiG6YoqWnVzUmxFNukcRVXZC51HvLr6mts8nxcm7ScR8' then 'Psy Finance DAO'
    	when realms_id = '3MMDxjv1SzEFQDKryT7csAvaydYtrgMAc3L9xL9CVLCg' then 'Serum DAO'
    	when realms_id = '7sf3tcWm58vhtkJMwuw2P3T6UBX7UE5VKxPMnXJUZ1Hn' then 'Solend DAO'
    	when realms_id = '7oB84bSuxv9AH1iRdMp5nFLwpQApv8Yo9s1gGmDkHtSP' then 'Synthetify DAO'
    	when realms_id = '6orGiJYGXYk9GT2NFoTv2ZMYpA6asMieAqdek4YRH2Dn' then 'The Imperium of Rain DAO'
    
    • Next, a comparative analysis was performed between all DAOs and selected DAOs. In this comparison, the total number of proposals, the total number of members and the total number of votes were compared.
    • Then, the first and last proposals in the tables were obtained for each of these selected DAOs. For this purpose, the first dates of the proposal were obtained and arranged in terms of time. Then the first and last proposal of each DAO was filtered. The first proposal of each DAO was considered as the creation time of that DAO. Although this is not the correct method, it is because the fact_proposal_votes table contains data from December 2021 and there is no data before this time. The reason for the difference between the number of proposals in the obtained results and the data available on the Realms website is the same.
    • Another deficiency in the tables was that the weight of the votes was not included. In the fact_proposal_votes table and in the vote_weight column, there is a value of 100 for each yes vote and a value of 0 for each no vote. However, the number of positive and negative votes of users to the proposals of these 10 selected DAOs was also checked. For this purpose, first the total number of positive and negative votes were compared. Then, the status of the votes of the proposals were briefly and completely arranged in a table, and then the proposals were divided into 6 categories based on the percentage of users' agreement with them. Finally, it was checked how many proposals each DAO has in each of these six categories.
    • In the following, these 10 DAOs were compared in the parameters of the total number of votes, the total number of proposals and the total number of users.
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...

    \

    • So far, 417 DAOs have been registered in the tables.

      \

    • Number of Proposals: These 417 DAOs have voted 4390 proposals so far. (on average 10.5 proposals per DAO) but more than 13.3% of these proposals (i.e. 584 proposals) are related to the 10 selected DAOs. (The average proposal per DAO here is 58.4 proposals, which is about 5 times the average of all DAOs). It can be concluded that these 10 selected DAOs are among the most active DAOs on the Realms platform.

      \

    • Number of Votes: About 23.2k successful votes have been recorded for these 417 DAO. The 10 selected DAO received 9.67k votes from this number (41.75%). If the average number of votes per proposal was 5.27 votes in the general state, this number reached 16.55 votes per proposal in selected DAOs.

      \

    • Number of Members: Of the 4,500 members who have cast at least one vote on the Realms platform, more than 54 percent (2,444 members) have participated in voting for the selected DAOproposals.

    • All the above three parameters clearly show that the 10 selected DAOs are among the most important DAOs of the Realms platform.

    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    • The above table shows the first and last proposal of each DAO. The results are sorted by DAOs (in alphabetical order).

      \

    • In these 10 DAOs, 5 DAOs were created in the same last month of 2021 (which is the only month of 2021 that has data in the tables). 5 more are created in 2022.

      \

    • Grape DAO has voted its last proposal on August 17. Among the latest proposals of selected daoes, this is the most recent in terms of time. But the last oldest proposal of one of these DAOs is related to Synthetify DAO, whose last proposal was voted on June 13.

    \

    • The two pie charts above show that although there were large differences in other parameters between the selected DAOsand all DAOs, both are very close in terms of voting results. On average, about 95% of the votes cast were positive.

    • In the table below, you can also see the status of votes for all 584 proposals of selected DAOs. The percentage of positive and negative votes for each proposal can be seen along with the number of yes and no votes.

    \

    • In this table, you can see the status of 584 proposals of these DAOs. This table is sorted by dao names.

    • MonkeDAO has the most number of proposals among the selected DAOs with 196 proposals. More than 96% (189 proposals) had 100% agreement with the proposals, this is very interesting. Especially, looking at other DAOs, it can be seen that this amount for MangoDAO is about 75%.

      \

    • 563 proposals out of 584 total proposals have attracted 50 or more than 50% votes in favor.

      \

    • There are only three proposals, all the number of votes of which were no. Two related to Serum DAO and the other related to Mango DAO

    • Among the 10 proposals that received the most votes, 7 are related to The Imperium of Rain DAO. This DAO ranks first and second in the number of users and the number of votes, respectively.

    Loading...

    Comparison of selected DAOs:

    • Number of proposals: In terms of the number of proposals, MonkeDAO ranks first by a significant margin. 33.6% of the proposals of the selected DAOs are related to this DAO. In second place is MangoDAO, considering the 176 proposals of this DAO, it can be said that two-thirds of the proposals were related to these two. Grape, PSY Finance and Metaplex are located in the third to fifth category respectively.

      \

    • Number of votes: The status of the number of votes is completely different from the status of the number of proposals of each DAO. Of the 9,666 votes cast, more than 86% of them went to the first 4 DAO. Grape DAO is in the first place with 2853 votes (more than 28% of the votes), in the second to fourth place respectively.

      • The Imperium of Rain DAO
      • MangoDAO
      • MonkeDaO

      \

    • Number of Members: the results here are also different from the previous two parameters. This shows that no proposal or DAO had a decisive advantage over the others. Here, out of 2,444 members who have cast at least one successful vote, 1,322 (more than 52%) of The Imperium of Rain DAO have participated in this DAO's voting. This is about three times more than any other DAO, with Grape with 420 members and Solend with 223 members in second and third place.