Question:

Q104. 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

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.

This study help us to better understand the Realms DAO governance data and explore the statistics related to the mentioned realms DAOs.

Approach:

To handle this investigation, the Data provided by Flipside community has been adopted, accordingly.

The data related to Realms have been shown by solana.core.fact_proposal_votes and GOVERNANCE_PLATFORM='realms' on Flipside. The rest of the analysis have been done by application of realms_id on fact_proposal_votes of solana.core table**:**

when realms_id ='DPiH3H3c7t47BMxqTxLsuPQpEC6Kne8GA9VXbxpnZxFE' then 'Mango'

when realms_id = 'By2sVGZXwfQq6rAiAM3rNPJ9iQfb5e2QhnF4YjJ4Bip' then 'Grape' when realms_id = 'FiG6YoqWnVzUmxFNukcRVXZC51HvLr6mts8nxcm7ScR8' then 'Psy Finance'

when realms_id = '7sf3tcWm58vhtkJMwuw2P3T6UBX7UE5VKxPMnXJUZ1Hn' then 'Solend'

when realms_id = 'B1CxhV1khhj7n5mi5hebbivesqH9mvXr5Hfh2nD2UCh6' then 'MonkeDAO'

when realms_id = 'Cdui9Va8XnKVng3VGZXcfBFF6XSxbqSi2XruMc7iu817' then 'Metaplex Genesis'

when realms_id = '2sEcHwzsNBwNoTM1yAXjtF1HTMQKUAXf8ivtdpSpo9Fv' then 'Metaplex Foundation'

when realms_id = '3MMDxjv1SzEFQDKryT7csAvaydYtrgMAc3L9xL9CVLCg' then 'Serum'

when realms_id = '6orGiJYGXYk9GT2NFoTv2ZMYpA6asMieAqdek4YRH2Dn' then 'The Imperium of Rain'

when realms_id = '7oB84bSuxv9AH1iRdMp5nFLwpQApv8Yo9s1gGmDkHtSP' then 'Synthetify'

Part 1: General stats

The general stats updated in the daily basis.

Findings:

• The number of votes on realms DAO has spiked in special dates like June 20th, May 3th and March 23th.
• The count of distinct voters on Realms DAO follows the trend of votes on realms.
• About 82% of voters voted under 5 times.
• Most of the voters (more than 3000) have been voted for below 3 proposals.
• Approximately, most of the voters voted on one special DAO and only 4.83% of voters voted for 2 DAOs.

Part 2: Track DAOs in detail

Findings:

• The date of creation and date of last proposal for mentioned DAOs have been listed in the above table.
• The distribution of votes on Realms DAOs reveals the highest application on Grape, The Imperium of Rain, Mango and MonkeDAO.
• The Imperium of Rain DAO on realms has 1321 distinct voter and takes the first place.
• MonkeDAO has 196 different proposals and dominated the DAOs from this point of view. The Mango realms DAO has 176 various proposals.

References and useful links:

• Realms DAO DOCs
• Realms DAO github
• Official Website: RealmsDAO

Author:

Credited by MZG

Discord handle: m.zamani#0361

Twitter handle: @GargariZamani