Projects
Initiative
‌
An initiative is something the guild is trying to do to achieve its current objects. Initiatives are usually broader categories like On-Chain Cash Flows, DAO Operations, Community (e.g., distribution and curation), or Media Nodes. Make sure initiatives align with the DAO's Mission & Values and do your best to support its initiative and projects. You can also look to other guild's initiative and projects page to see what they're working on and if there's anything you can do to chip in. Make sure to include an initiative title and a brief description of the initiative underneath.
Â
Coordinator(s): These are the people that are coordinating the projects and activities that are being done to fulfill the initiative's goals.
Â
Projects
Projects are the things DAO members do to support initiatives. For example, the apparel drops on Metafactory and the BED Index are projects that support the On-Chain Cash Flows initiative.
Â
Welcome New Members!
If you're new to the Analytics Guild, use the projects list below to explore existing projects. To get involved with a project, contact one of its contributors.
If you have an idea for a new project, add it to the list and name yourself as a contributor.
Projects listed below may or may not be directly tied to broad initiatives.
Â
Theme
Default view
Initiative Name
Project Name
Status Updates
Project Description
Project Docs
Contributors
Project Goals and KPIs
Complete: discuss project requirement with Behold. Complete: Communicate to Analytics Guild, open for contributions. Complete: Draft of Data Fields & Potential Queries Next: Get up to speed with MongoDB to create data schema in JSON.
The Bounty Board will be a DAO-wide tool used to coordinate tasks that need to get done. The Developer's Guild has created a Bounty Board project team. There is a significant Analytics component to 1. anticipate Queries to be made of the Bounty Board (inform Data Model Object & Data Transfer Object), 2. Inform Automated Dashboard of bounties
Developer's Guild (@Behold) will lead, @paulapivat as liaison for Analytics Guild. @garywolf
1. Brainstorm potential queries for Bounty Board (assume perspective of Analytics Persona), 2. Data object model: Create schema table for Bounty Board data, 2a. Data transfer model: data attributes, JSON, http request. 3. Scope out Dashboard (data backend), 4. Create data pipeline (i.e., Data Storage, Query, Automated Dashboard, BI interface)
Prepping for Season1. Complete and wrote up: @paulapivat provided descriptive/exploratory analysis of OnBoard Survey. Status:
DAO-wide initiative to create an Onboard DeFi Education platform. This is a Season 1 initiative that will span multiple guilds. The Analytics Guild will provide supporting analytics/data for the project. Used by Education & Marketing Guild.
Airbayer, paulapivat
Create metrics to track: 0. Onboard Survey analysis, 1. how many people interact with the site. 2. How many start a course. 3. How many complete the course.
Next Step: Discuss with Icedcool on Finance & Managerial side. Topics: Multi-sig management, Analytics Guild Proposal process
Not a data-project perse, more of a meta-project for the guild. Hammer out details on how to secure and distribute funding.
Icecool, paulapivat, Airbayer
TBD
Complete and wrote up basic visualization of POAPs claimed for Community Calls & Total POAPs claimed by the community; Accessed data from poap.gallery (search 'Bankless'). Complete: Query POAP.xyz subgraph with Python. Complete: Query all Community Call data via Subgraph to reconcile with csv data. Exploring xDai on BlockScout / Graph Protocol (ongoing),
Tracking metrics around POAPs claimed across various DAO events
@paulapivat
Pull aggregate data (i.e., total number of POAPs claimed after a Community Call). Basic descriptive stats, visualizations.
Complete: Data cleaning and exploration of Discord data (csv). Next steps (tbd): Potentially cross Discord data w Membership data, would need access to additional data
Explore discord data to provide descriptive stats and analytics on Community behavior / engagement
@paulapivat, @frogmonkee
0. Explore and clean Discord data provided by Frogmonkee, 1. Provide basic descriptives and visualizations of available data, 2. Potentially access Discord data directly through server
Complete: Add Sushiswap LP to dashboard. Potentially analyze airdrop vs purchased. Complete version 1.0 of Dashboard and Google Form. Open for community feedback.
Dashboard to capture real-time numbers of addresses in different member categories (i.e., LP, Whale, Contributor/Member) and segmentation of different levels of BANK holdings.
Link to dashboard. Documentation in github forthcoming.
@paulapivat. Airbayer
Create dashboard showing number of addresses in each meaningful category. Create google form to capture change in numbers over time.
Complete: Add changing in Whale, Contributor and other categories over time.
Capture Member categories changing over time
@paulapivat
Complete version 1.0. Open for community feedback. Next: Meet with Kouros next week to discuss building out Financial Reporting Dashboard.
Create a dashboard for real-time reporting on transactions in and out of the Bankless DAO treasury. Supports Treasury Guild reporting efforts.
paulapivat, Kouros
Create dashboard that aggregates metrics generally scattered in various places on etherscan.io
Complete exploring all major metrics including Impressions, Engagement and several metrics that make up Engagement (i.e., likes, replies, retweets, media clicks, url clicks)
Explore Twitter Analytics data for Bankless DAO twitter account; could be used by Marketing Guild.
@paulapivat
Provide exploratory analysis + charts.
Complete: Confirmed this is a separate project from Bounty Board (hold for now as Bounty Board should cover this need)
TBD
paulapivat, frogmonkee
TBD
Post feature request to Collab.Land and join their telegram to ask how to access data [Update: They will be adding ability to view tipping analytics in the future, doesn't appear to be a priority for them at the moment]
Access tipping data (i.e., total tips, average tip size, number of people giving and receiving tips)
TBD
wolfehr, paulapivat
Pull data. Get basic descriptive statistics.
Complete version 1.0. Open for community feedback.
Dashboard capturing Total BANK trading volume, addresses with highest trade vol, unique addresses that traded BANK, Trading Pairs with BANK (by vol USD), preferred DEXes for trading BANK.
Link to dashboard. Documentation in github forthcoming
paulapivat
Create charts and numbers to capture various metrics.
TBD
Provide social media analytics for Marketing Guild
TBD
?
1. Newsletter signups, 2. Open rate and click through rate, 3. Web traffic to Bankless DAO website, 4. Social media followers, 5. Facebook / Linkedin Group members, 6. Engagement: likes, comments, 7. Merch sales, 8. NFT sales, 9. Referral rewards to PieDAO
Complete.
Dashboard showing $BANK wallet allocations
0xHouston
Aggregate top 10 projects in the Defi space for external use - Paid for by Rossco from SyncDAO
Icedcool - Coordinator
Paul - Analyst
Mckethenor - Analyst
Collect data from external projects to be stored in a data warehouse
Expansive vision for Analytics Guild
Theme
Â
General High-level Queries [Priority]
- How many Bounties were created in Season 1?
- How much BANK was allocated for Bounties in Season 1?
- Number of Bounties at the start of the season vs end of season?
- Who completed the most bounties?
- Which guild completed the most bounties?
- Who claimed the most bounties?
- Who submitted the most bounties?
Bounty Status Queries [Priority]
- How many Bounties were completed in the last 30 days?
- How many Bounties were created in the last 30 days?
- How many Bounties were activated in the last 30 days?
- How many Bounties were updated in the last 30 days?
- How many Bounties were completed on time?
- How many bounties expired?
- How many Bounties were expired?
- How many Bounties are open?
- How many Bounties were drafted?
- How many Bounties are in-progress?
- How many Bounties are in-review?
Â
Guild Specific Queries [Priority]
- How many Bounties were created by each Guild?
- Which Guild created the most bounties?
- Who authored the most bounties?
- How many Entries did each Guild receive?
- Which Guild received the most entries?
- How many Submissions did each Guild receive? (completed entries)
- Which Guild received the most submissions?
- What is the distribution of Rewards across Guilds?
- Which Guild gave out the most rewards?
Â
Nature of the Work Queries
- Which knowledge, skills or abilities (KSAOs) were needed the most across Bounties?
- What tools/software/apps were used the most across Bounties?
- What kind of tasks was most requested across Bounties?
Â
Rewards-related Queries
- What is the distribution of Rewards across Bounties? Min, Max, Avg?
- Which bounty had the highest (max) reward?
- What kind of knowledge, skills, abilities are most rewarded?
- What kind of tasks is most reward?
Â
Misc
- How many Bounties were authored by individual DAO members?
- How many Bounties were completed by individual members?
Â
Â