Title: DAO Dash Season 5 Funding Request
Program Champion: RunTheJewelz
Authors: RunTheJewelz
Reviewers: McKethanor,ItamarGo, JokerDelMar, aaron
Created Date: July 20, 2022
Gnosis Safe: eth:0x3aEF6716a492D5bE3D8A785b4998B94D5171B732
Summary
The mission of the DAO Dash project is to provide DAO role holders, guild leaders and members with analytical insights that are meaningful for the community as a whole. Starting with BanklessDAO and expanding to the rest of the DAO ecosystem.
In Season 2, we provided insights in the areas of Member Engagement, Transaction Analysis, Governance, Coordination and Education to answer the following questions:
Member Engagement:
- How many weekly active members are there within the DAO by roles (i.e., L1, L2, guests)?
- What % of new members go on to obtain the “First Quest Complete” role? (First Quest)
- Of members who obtain the “First Quest Complete” role, how many are active after 1 day, 1 week, 1 month? (First Quest)
- What is the retention rate between those who complete First Quest vs those that do not?
- What do tipping patterns tell us about member engagement?
- Member Participation in Governance:
- What % of members vote on Snapshot? (DAO wide)
Grants & Rewards:
- How are funds distributed to and from various guilds, projects?
- What do Coordinape giving patterns tell us about Bankless DAO network health?
- What do tipping patterns tell us about Bankless DAO network health?
Education
- What is the number of users who start and complete Academy course(s)?
- What is the number of mobile vs desktop users? (Academy)
In Season 3, we provided additional insights and started distributing them to the DAO. Additionally, we built several pipelines including a BANK Subgraph, Snapshot Pipeline, andCoordinape Pipeline. We built a POC for interacting with DAODash via Discord Slash commands, and aligned that this is a viable path forward for value accumulation for DAO Dash.
Support for the DAO:
- Answered guild membership questions for:
- Dev Guild
- Fight Club
- Bankless Consulting
- Answered meeting attendance questions for multiple guilds
- Helped solve the Snapshot quorum question with detailed metrics and breakdowns of contributor voting patterns
DAO Dash interaction:
- Created DAO Dash bot command protocol
- Created DAO Dash parameterized dashboard
- Experimented with 1 dashboard
DAO Dash Deployments
- Created multi-tenancy environment for multi-DAO scaling
- DAO Punks
- Bankless Brazil
- TalentDAO
In Season 4, we went further down the path of Discord CLI and focused on building out a Discord Bot interaction protocol. DAO Dash, at the end of S4, will be delivered to the bDAO server, along with training, to enable members to answer the questions that they come to our team to answer. On a daily basis, we are asked questions such as
- “Who is active in the [insert guild name] guild this season?”
- “How many L1s and L2s have gone silent in the past 30 days”
- “How much budget is sent out from the [insert project name] multisig, and to which wallets is it being distributed?”
- “What is Snapshot voter behavior like over the past 3 seasons?
- “Which voice channels or text channels are the most active?”
We are now turning the ability to answer these questions over to the DAO, using the technology behind DAO Dash, and the simplicity of the Discord UI.
Progress in S4
Here are some working prototypes on our Sandbox server.
In our Sandbox, we have command interfaces that trigger our first 4 (of 5 planned) KPIs and insights using simple commands and parameters.
We have help commands to ensure that the user base understands and can access the charts.
Below are samples of our work in progress charts that result from the queries our Bot consumes, generates, and produces for the front end.
Members
Who were the last members of the Analytics Guild to post in the Analytics channel?
Multisig
Show me the distribution for the Writers Guild Multisig since May 1
Snapshot
How has voting trended over the last 6 Snapshot Votes?
Data Engineering Updates:
- Implementation of Airflow for data pipeline orchestration + CI/CD architecture via github integration
- Implementation of dbt(Data Build Tool) for complex ELT logic and integrity checks running at Daily and Hourly cadence.
User Analytics Dataset
S4 Program Outcomes
Here are the project outcomes and KPIs for Season 4:
- Make dashboards accessible through DAO Dash bot platform
- Extend to 3-4 more DAOs
- Partial, we have deployed to Talent DAO and Bankless Brasil
- Gate Discord bot to BANK (or other token) holders
- TBD, the ability to do this exists, but has not been put into place (and may not be)
- Build 2 new pipelines
- Refactor Bot code to Python
- Support Analytics Guild and bDAO Guilds information requests
- Support GSE mission with data upon request
- Develop set of documentation for tooling
- DE Automation and Integrity Checks for core data sources
- Implementation of Airflow for orchestrating data pipelines
- Bankless Snapshot Header
- Bankless Snapshot
- Bank subgraph
- Bank subgraph polygon (New)
- Poap_events (New)
- Implementation of CI/CD architecture for airflow
- Implementation of dbt for ELT and Integrity check automation
- Performance optimization - Migration of user_analytics dataset from view to table via ELT model running at daily cadence
- Hourly Integrity checks on discord bot data freshness
- Implementation of Airflow for orchestrating data pipelines
- Define Revenue Generation, Ownership and Legal entity US & International considerations
- This is not completed, but we are operating under the assumption of Public Good / Freemium model, and will seek alternate sources during S5
Season 5 Plan and Goals
For Season 5, the DAO Dash team will continue to refine the CLI bot, begin to collect user feedback, improve design and aesthetics, and seek to improve data sources.
We will work on 2 incremental insights and 2 additional data sources.
Additional Insights:
- Role based user engagement - Count of Users (who hold the requested roles) who have been active in the last week, 2 weeks, 3 weeks and 4 weeks.
- Role acquisition - Count of new users who were assigned/taken on this role in the last week, 2 weeks, 3 weeks and 4 weeks.
Data Sources:
- Discourse
- Collab.Land
We will deploy to an additional 2-4 DAOs, seeking end user feedback on the usefulness, and ease of use of the product.
We will seek to apply for Public Goods funding to subsidize the development costs for the project.
We will document onboarding processes for new team members, and onboarding processes for new DAOs to bring the bot to their servers.
Season 5 Budget
Roles | Area | Hours / Season | Rate | Total |
---|---|---|---|---|
Project Champion | Stakeholder | 80 | 1000 BANK | 80,000 |
Project Coordinator | PM | 80 | 1000 BANK | 80,000 |
Product Documentation and Support | User Onboarding | 80 | 1000 BANK | 80,000 |
Data Engineering | Engineering | 220 | 1000 BANK | 220,000 |
Development / DevOps | DevOps | 280 | 1000 BANK | 240,000 |
Analysts | Insights | 150 | 1000 BANK | 150,000 |
Expenses (database) | Expenses | $40/mo | $120 USDC or DAI | |
Expenses (airflow orchestration server) | Expenses | $20/mo | $60 USDC or DAI | |
Total | 850,000 BANK +$180 USDC |
References
Project channel: #dao-dash-project
- I support DAO Dash S5 Funding
- More detail needed, please revise.
0 voters