Grant Proposal: CoW DAO Dune Governance Dashboard

Grant Title:

CoW DAO Dune Governance Dashboard

---

Author:

@bleu @yvesfracari @ribeirojose @mendesfabio

---

About You:

bleu collaborates with companies and DAOs as a web3 technology and user experience partner. We’re passionate about bridging the experience gap we see in blockchain and web3.

---

Additional Links:

Our work for CoW so far:

• [CoW] AMM Deployer: a Safe app to deploy new CoW AMM pools from a Safe Wallet.
• [CoW] CoW Hooks dApps (ongoing): a set of hooks dapps to (to be launched) CoWSwap Hooks Store. Also, we helped the CoWSwap team to develop the store focusing mainly on the hooks simulation feature.
• [CoW] Python SDK (ongoing): we’re helping CoW put together a Python SDK to provide for developers for query on-chain data, managing orders, and integrating with the CoW Protocol’s smart contracts.
• [CoW] Stop-Loss: a Safe app UI to allow for multisig wallets to fully manage stop-loss orders.
• [CoW] Have I been MEV’d: a suite of bots and a web application integrated with the ZeroMEV API to inform the Web3 community about potential MEV losses.

Besides CoW's previous grants, we already developed a Dune Dashboard related to the state of Aave liquidations on Optimism. Also, Fabio (bleu co-founder and project's advisor) is the Head of Data at Balancer Labs - check out @metacrypto on Dune.

---

Grant Category:

User interface and user experience (UI/UX)

---

Grant Description:

This proposal aims to develop a governance analytics dashboard for CoW DAO using Dune (demo and mockup here). The project addresses the current challenge of scattered governance information by consolidating key metrics into a single, user-friendly interface as mentioned in this RFP. The dashboard will serve as a centralized hub for tracking and visualizing CoW DAO's governance activities, focusing on four main areas:

1. High-Level Governance Metrics
2. Proposal Metrics
3. Voting Analytics
4. Delegation Tracking

To achieve this we will be using the Shots Tables from the Dune Community Data to find all snapshot-related data (votes, proposals, etc). Regarding the delegation data, we have already send the snapshot delegation contract to Dune decoding. All information will be first preprocessed and consolidated into views to be consumed by our visualizations, here are the views that we developed by the demo: snapshot proposals, snapshot views and delegations (wip).

---

Grant Goals and Impact:

This project aims to make CoW DAO governance metrics more transparent and accessible by creating a comprehensive analytics dashboard. By consolidating key metrics like voting patterns, proposal outcomes, and delegation activities into a single interface, the dashboard will enable community members to make better-informed governance decisions and track participation trends effectively.

---

Milestones:

| Milestone | Due Date | Payment (10k xDAI + 10k COW vested) | | --- | --- | --- | | High-Level Governance and Proposal Metrics | 1 week | 2.5k xDAI + 2.5k COW vested | | Voting Analytics | 1 week | 2.5k xDAI + 2.5k COW vested | | Delegation Tracking | 1 week | 2.5k xDAI + 2.5k COW vested | | Review and feedback | 1 week | 2.5k xDAI + 2.5k COW vested |

High-Level Governance Metrics (1 week)

• Total amount of proposals already vote
• Total of unique all-time voters
• Percentage of active and non-active voting power.

Proposal Metrics (1 week)

• Provide detailed CIP tracking with chronological overview, including proposal result and quorum status
• Overview of all proposals states (passed, rejected, on voting, etc)
• Number of proposals voted over time.

Voting Analytics (1 week)

• Track unique voting addresses per proposal
• Participation over time considering total and individual votes.
• Visualize votes of individual addresses or CIP.
• Current distribution of the voting power using Gini index.

Delegation Tracking (1 week)

• List of all delegates and their voting power over time
• Find a delegate by address or ENS to see their participation over time and how they voted + their voting power (historically over time)
• Possibility for a delegator to past their address and see whom they have delegated to
• Total of voting power delegated over time
• Percentage of delegated voting power actively participating in governance (per proposal)
• Percentage of active delegates (per proposal)

We propose that milestone payments be released upon each milestone’s approval.

---

Budget Breakdown:

The budget includes the hourly rates of a developer during the execution and a project manager on a need basis. The xDAI part of the budget shall be paid after each milestone’s completion and the COW shall be vested over 1 year to cover diluted maintenance and related costs for the same period.

---

Gnosis Chain Address (to receive the grant):

0x554866e3654E8485928334e7F91B5AfC37D18e04

---

Other Information:

• All the code will be open-source from day 0. We’re open to feedback;
• We’re happy to answer any questions and are open to feedback about this proposal;
• Once this dashboard is done it should be migrated to CoW’s Dune org for better discoverability;
• To explore the viability of this proposal and give a glimpse of what we’re envisioning, we developed a PoC of the dashboard here which we plan to work on should we get this grant.
  • this PoC already comprises four modules, with the following data:
    • Aggregated Governance Metrics:
      • Total proposals
      • Unique voters
    • Proposals:
      • List of proposals + aggregated data (e.g. proposals by month, by state)
    • Voting:
      • Aggregated participation over time
    • Delegation:
      • List of delegators (WIP)
  • aspirationally, we also included the following:
    • Aggregated Governance Metrics:
      • Active vs non-active voting power
    • Voting:
      • Voting Power Distribution
      • Votes list with voter address (or ENS name) and proposal filter
    • Delegation:
      • Percentage of active delegates (per proposal)
      • Total of voting power delegated over time
      • Percentage of delegated voting power actively participating in governance (per proposal)

---

Terms and Conditions:

By submitting this grant application, I acknowledge and agree to be bound by the CoW DAO Participation Agreement and the CoW Grant Terms and Conditions.