1. Executive Summary
This proposal introduces the development of a Grant Progress Tracking Platform for SandboxDAO-funded projects, offering a transparent and user-friendly way for the community to monitor grant performance. The tool will include milestone tracking, real-time updates, and automated alerts for delays or scope changes. The platform will centralize data on all grants past and present for improved viewing.
2. Problem Statement
Currently, tracking SandboxDAO’s grant activity is decentralized and fragmented across different forums and communication channels. This lack of cohesion reduces visibility, slows down accountability, and hinders community oversight.
3. Proposed Solution
To address these issues, we propose building a custom Grant Progress Tracking Platform with the following key features:
- Milestone Tracking: Each grant includes a page with major milestones, visual progress bars, and status indicators.
- Real-time Updates: Projects can submit live updates as they reach milestones or face delays.
- Automated Alerts: Notifications sent via email and in-app when deadlines are missed or scopes change.
- Interactive Visuals: Dashboards and graphs help visualize project health and funding usage.
- Risk Detection: Machine learning helps detect early signals of delay, inaction, or deviation from grant terms.
4. Team
Emmanuel – Project Lead
With over 9 years of experience in the Web3 space since its early days, this professional has played a significant role in shaping decentralized technologies. At Dash, the first-ever DAO, they contributed to the development of decentralized governance systems and the foundational evolution of DAO structures. Later, at Pi Network, I have led a cross-functional team to successfully launch the Pi Ad-server services, aligning technical execution with strategic business goals. Work consistently centers on building scalable, user-focused tools that support the dynamic needs of decentralized communities.
LinkedIn: https://www.linkedin.com/in/emmanueleclipsewebsite/
5. Technical Details
Grant Overview
- Browse all current and completed grants
- View progress percentages, risk scores, and last activity updates
- Filter by type, status, or team
Risk Assessments
- Color-coded risk levels
- Automated analysis based on update frequency, milestone delays, and funding status
Project Pages
- Display deliverables, milestones, documentation, and community discussions
- Funding history and comments included
Admin & Delegate Tools
- Approve or flag milestones
- Pause or escalate grants with transparency
Treasury Dashboard
- Track all outgoing funds, disbursement schedules, and project expenses
- View overall budget impact and upcoming obligations
Grant-to-Transaction Matching Logic (Automated Heuristics)
When a grant is approved (e.g., SIP-12), the system records key metadata: the SIP number, the grantee’s wallet addresses, and the expected payment schedule (such as 30k SAND in July and 10k in August). The matching engine will attempt to link on-chain treasury transactions to their corresponding SIPs using a layered approach:
- Check whether the transaction was sent to a wallet associated with the SIP-12 grantee
- Compare transaction recipient addresses to known
grantee_wallets
in the database- IF
tx.to
is ingrantee_wallets
→ candidate match - Then validate that the transaction timestamp falls within an expected disbursement window (e.g., +/- a few days of a scheduled milestone)
- Each transaction match is assigned a confidence score based on the number of conditions it satisfies
- Edge cases or low-confidence matches will be flagged for manual review via the admin dashboard
- IF
Frontend
- Tech Stack: React + Tailwind CSS
- Features:
- Grant dashboards with live status, risk indicators, and update logs
- Public project pages (milestones, deliverables, funding history)
- Filterable lists by status, team, or grant type
- Admin controls for delegates (e.g., approve/flag milestones, pause grants)
Backend
- Tech Stack: Node.js with a PostgreSQL database (or Supabase for rapid deployment)
- Core Functions:
- Milestone & update management engine
- Rule-based risk analysis (e.g., delay frequency, inactivity, missed updates)
- Alert system for overdue milestones or scope changes (email)
- API endpoints for project data, update submissions, and treasury tracking
Security & Hosting
- Secure cloud deployment (e.g., Vercel + Supabase)
- Role-based access for contributors, teams, and community reviewers
- Encrypted data storage and daily backups to ensure resilience
SandboxDAO Integrations
- Scrape SIP threads for update activity (e.g., post frequency, milestone completions, delays) to help evaluate project status
- SandboxDAO.com integration (post MVP): Embedded on SandboxDAO.com to display live grant data and summaries
6. Budget & Work Plan
Milestone | Timeline | Key Deliverables | Payout (USD) |
---|---|---|---|
Milestone 1 – Design & Frontend Structure | Week 1 | - Finalize UI/UX design - Build frontend component scaffolding - Convert the design system into reusable components | $4,000 |
Milestone 2 – Feature Development | Weeks 1–3 | - Build milestone tracking, project views, and live updates - Add filterable dashboards and risk visualizations - Implement permissions, roles, and data source integrations (Discourse, GitHub, etc.) - Deliver treasury dashboard: transaction mapping, SIP-to-wallet matching, and upcoming obligation views - Add admin controls and visual risk alerts | $7,000 |
Milestone 3 – Finalization & Deployment | Week 3 | - QA, polish, and deploy - Publish docs and onboarding guide - Set up hosting, monitoring, and 12 months of support | $1,000 |
Total Budget: $12,000
7. DAO Alignment & Impact Measurement
This proposal strongly aligns with SandboxDAO’s core values of transparency, community empowerment, and accountability. By providing a centralized, user-friendly platform to track grant progress, it fosters a more decentralized governance process and improves trust across all stakeholders.
How this contributes to decentralization and community empowerment
- Transparency: Clear, unified visibility into how funds are being used
- Accountability: Encourages timely updates and milestone achievement
- Community Engagement: Empowers DAO participants to evaluate, contribute, and respond
- Provides open access to grant data, encouraging more informed participation in voting and decision-making
- Risk Management: Enables earlier detection of delivery issues, proactive actions to prevent delays and misuse
- This platform will serve as a foundation for long-term accountability, operational insight, and stronger collaboration across SandboxDAO’s grant ecosystem
Impact tracking and KPIs
- Number of active users on the platform (community members, delegates, admins)
- Frequency and timeliness of grant updates aggregated
- Number of milestones completed on time vs. delayed
- Time-to-flag from milestone delay to risk alert
- Risk alerts generated and resolved
- Community/delegate engagement: flags, comments, update reactions
- Feedback from the community via surveys or forum discussions