TL;DR
-
I’ve built the first version of the Moonwell Governance Dashboard on Dune.
-
Covers multi-chain governance data across Base, Moonbeam, Moonriver, and Optimism.
-
Data for Moonbeam and Moonriver required custom indexing (Boardroom API + RPCs) since Dune doesn’t support them.
-
Next step: independent indexing + robust ETL pipeline to keep data accurate and up-to-date.
-
Dashboard includes: proposal tracking, voting outcomes, voter insights, and delegate analytics (multi-chain).
-
Check it out here: Moonwell Governance Dashboard
The Challenge of Multi-Chain Governance Data
As you may already know, Moonwell’s governance data spans across Base, Moonbeam, Moonriver, and Optimism. While chains like Base and Optimism are already indexed on Dune (which makes their data relatively straightforward to access), the real challenge was with Moonbeam and Moonriver.
- Moonbeam: While the multi-chain governor contract is deployed here, the event logs have not been indexed by Dune, making the available data unusable.
- Moonriver: No data is available on Dune at all.
This fragmentation makes it hard for the community to see the full picture of Moonwell governance in one place. To bridge this gap, I combined Boardroom’s API with public RPC endpoints for Moonbeam and Moonriver. While this approach worked, it also exposed limitations. For instance, although Moonwell has now passed 113 onchain proposals, the Boardroom API hasn’t updated accordingly, leading to gaps.
That’s why my next focus is to independently index Moonbeam and Moonriver governance data and build a robust ETL (Extract, Transform, Load) pipeline that ensures data accuracy, timeliness, and completeness going forward.
What You’ll Find on the Dashboard
Proposal Tracking
- Aggregate counts: total proposals across both onchain governance and Snapshot.
- Breakdowns: separate tallies for onchain and Snapshot proposals.
- Detailed tables for each proposal:
- Title (hyperlinked to the proposal’s page)
- Proposer
- Current proposal state
- Total voters (count of participants, not weight)
- Vote breakdown (for, against, abstain)
- Total vote weight
- Voting window (start and end times)
- Transaction hash and block number
Proposal Outcomes & Voting Patterns
- Chart of proposal outcomes (succeeded vs. failed).
- Bar chart of vote choice distribution (for/against/abstain) per proposal.
- Scatter plot of delegated voting power segmented by choice.
Voter Insights
- High-level metrics: total voters, active voters, aggregate voting power.
- Voter tables including:
- Voting power and share of total
- Days since becoming a voter
- Participation rate
- Total votes cast
Delegate Insights (Multi-Chain)
- Chain-level summaries for Base, Moonbeam, Optimism, and Moonriver:
- Total delegators
- Total delegates
- Total delegated voting power
- Delegate tables with:
- Address
- Voting power and share of total
- Tenure as delegate
- Votes cast
- Participation rate
- Custom delegate view: filter by delegate address to dynamically generate:
- Current voting power and share relative to peers
- Voting participation rate
- Proposals engaged
- Voting history across multiple chains
What’s Next
- Full indexing of Moonbeam and Moonriver governance data (reducing reliance on external APIs).
- Creation of a reliable ETL process to keep data fresh and accurate.
- Iterative updates to expand analysis and improve visualizations.
Explore & Share Feedback
Dashboard link: Moonwell Governance Dashboard
If you notice any inaccuracies, or if you have suggestions for additional insights or visualizations, kindly reach out here on the forum, in the comments, or send me a DM on X (Twitter).