Mission

• 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

• Realms, is a project which provides a platform for builders on Solana (another projects) to create and manage a DAO, anyone with a wallet can create their DAO and govern using Realms.
• There a lot of differents DAO’s to create in Realms and more information about these DAO’s or how to create one are in their docs.

Flipside data about Solana is incomplete, a lot of information before December 2021 isn’t present at the moment.

Also the table “solana.core.fact_proposal_votes”, which is used for this analysis, have problems with vote_rank and vote_weight columns.

The search of the Date of Creation

The reason i’m starting with this, is because this was the most difficult thing to do, i saw some users in Flipside discord, using the first date of Solana.core.fact_proposal_votes as the date of creation but this is wrong because that table only have information about votes. So let me explain how to search correctly this date.

When a DAO is born in Realms, a transaction id is created and can be searched in the solana.core.fact_events, If the DAO have their own project_id related to their governance program such as Mango or Solend for example, looking for the transaction in the earliest block_timestamp using their project_id, do the work.

In the other case that the DAO uses the Realms project_id ‘GovER5Lthms3bLBqWub97yVrMmEogzX7xNjdXpPPCVZw’ such as Grape or Synthetify, we need to do the same search again using the earliest block_timestamp and the Realms project_id but adding a new condition of looking in the Instruction:accounts if the Realms_id (Pubkey in Realms app parameters) of the DAO we want to search is present.

For a better visualization i’ll add my SQL as example of how to search in the second case:

Using this method i got most of the creations dates and transactions id of the DAO’s, except for Serum, Mango and Metaplex. This is because their creation date is before December 2021, and at this moment Flipside Solana tables doesn’t have that data, and is really hard to look in a Solana Explorer for the transaction because most of them filters transactions by the newest only.

Date of Creation and Transaction ID of the DAO’s - You can see in the instruction logs (at the bottom) in the Explorer that the “Realm” is created

• Mango: Before December 2021, Not Found.
• Grape: 2021-12-14 15:26:15.000 2aQ9qbZfB8oCTDFspH42ot6YWENGsyXd9PkordxoQnDBRVGv9aTJaMpSiwkCrbPYcpk3iuFS2aFUe8asHYF9JXrL
• Psy Finance: 2022-03-18 01:21:31.000 3uXVNkncPWChnWkTYb3LUtQeZwxCPJShiFM9BmXLVcsGj1SLAFjC5s5xZX6PaZwmQfZFnnG1veJbyqFiaGcCw3C2
• Solend: 2022-06-19 06:18:01.000 tW9yFQwMmSa6tmq6obKHdk6ppwRWm8kAQBKve2bj1Lcjth37BD9D1C72Canh6WpyD1e6tQ7JLiErCT8KkUbM581
• MonkeDAO: 2021-12-17 16:56:28.000 4PmgFqGzR8PGgywjGCociocLgurT8bg3Us679oWDSUPVtnWPpcPK2pPdfxW1sBWDuvzjazPo5mBvb9pN29bgjria
• Metaplex: Before December 2021, Not Found.
• Jet: 2022-04-12 19:52:00.000 2capYD4spu3dRPAw3iN3hwGiBwc1mBvoxkqTrXY1dCZwPMc9Z4TvSJ51j5Wa9tRPLXL7mVgWzNjCQqKFMs3f8hUB
• Serum: Before December 2021, Not Found.
• The Imperium of Rain: 2022-04-20 19:21:04.000 QSEbXLT5sdqm3kq9jqkQdHdrmdGr2RURjUDZUNMZGrYNkqmGXcsNCP27vv7EVo1s1Z7cjJH1YmCdfDB5SQu95BP
• Synthetify: 2022-03-08 14:53:40.000 56VgbdojkkxhoEQy1A4P5UkKuSfj4MemCD4RPTxrEwqYoxzxatS38FsNGHbbqu6F4u7r9pd7NfyYKFapUfbse9pK

This is the only metric i have to input manually, and thats why i decided to present this first.

Inspect the SQL in this query to understand how i found the Date of Creation

Some important info about the DAO’s

I’ll skip the data missing, because is already explained, but, some projects have their own project_name meanwhile others have the project_name of the Realms app and in that case i use the Realms_id to search the info.

Because of that, Solend, for example have 4 proposals but in the app are only 3, that’s because using the project_name to search for info, i’ll include the different Realms_ID vinculated to that project_name, and there are other DAO’s of Solend which were used as “test” and in one of them exist a proposal and votes. I decided to include that data too because is related to the DAO.

Additionally Metaplex DAO is divided in 2 differents DAO’s with 2 differents project_name (Metaplex Foundation and Metaplex Genesis)

Mango and MonkeDAO are the DAO’s with most Proposals.

Grape and The Imperium of Rain DAO’s have the most Votes.

The Imperium of Rain DAO have the most Unique Voters (users).

Some DAO’s like Solend, only have activity in some days (June 19 - June 21), Mango and Grape are the DAO’s with most days with activity.

“May the force be with you”, the Empire Imperium of Rain have the biggest spikes in activity and users in 2022 May 2.

Methodology

• Using Flipside data bank tables:
  • Solana.core.fact_proposal_votes: To get all the info about the DAO’s
  • Solana.core.fact_events: To get the tx_id and the date when the DAO’s were created
• Most of the “method” to get the creation date was already explained because it was the most complicated metric to get.

Summary

• Most of the DAO’s activity comes from this year, and a few of them were created in 2022 too, the biggest spikes were in 2022 May, but the activity in the later months have a uptrend in comparison with the year 2021 or the first months of 2022.
• Mango, Grape, MonkeDAO and The Imperium of Rain are the Most active DAO’s.
  • MonkeDAO have fewers Voters but a lot of proposals and votes.
  • Jet and Solend have a significant number of Voters but because of the few proposals their Votes aren’t that high.
• The majority of latest proposals are from 2022 August.
• Realms is a healthy project for DAO’s in Solana, a lot of the DAO’s in this analysis have a lot of activity in the recent months.

Now let’s look the DAO’s other Metrics.