Grant Progress Tracking Platform for SandboxDAO

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:

  1. Check whether the transaction was sent to a wallet associated with the SIP-12 grantee
  2. Compare transaction recipient addresses to known grantee_wallets in the database
    • IF tx.to is in grantee_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

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

8. Attachments

Notion link

Hello @BuildUnion

Thanks for submitting your proposal. I have a few questions:

  • Are you going to develop the project alone?
  • Can you provide a GitHub o portfolio, please?

Finally, the Notion documents is blocked; please provide access to review it.

@yuelwolf Thank you for your questions.

1. Team Structure
I will be working on this as a team, along with 3 other developers. Build Union is a collaborative collective of experienced developers, designers, and strategists focused on Web3 tooling, DAO infrastructure, and decentralized governance. We work as an integrated unit to ship high-impact, production-grade applications.

Project Team:

2. Notion Access Thanks for the heads-up, the link permissions have now been updated. You should be able to access it now.

Update: Good progress made! We’ve completed the UX/UI for the Projects, Project Details, and Admin pages. Currently building the Alert Engine and Treasury views. Please share the branding guidelines for iconography and any other edits so we can match with the Sandbox website. We’re using Tailwind CSS, so UI iteration won’t be much of a hassle.

On the backend, data scraping and structuring are coming together, and the system’s starting to breathe on its own. Currently using static data.

Projects page

Project page list view of all grants

Admin page

Project details page

Organization View of Grants

a cartoon character is smiling with the words it 's all coming together

Hi @yuelwolf following up to see if this is under review. Since the target period ends in about 2 weeks, we have already begun to meet the delivery requirement immediately. Any updates from domain allocators would be greatly appreciated

Execution Readiness

Project Lead: Emmanuel (BuildUnion)
Status: Under Review – Ready to Begin Immediately

Timeline (2 Weeks Total)

Day 0 – Approval & Kick-off

  • Set up repo, hosting environment, and data integrations.

Day 1 – Design & Frontend Setup (Within 2 days of approval)

Week 1 – Core Feature Development

  • Implement milestone tracking, live update submission, and risk alerts.

  • Integrate treasury transaction mapping to SIPs.

  • Build admin tools for customized management.

Week 2 – QA, Deployment, and Support Setup

  • Final testing and polish.
    Deploy to production with hosting and backups.

  • Publish onboarding guide for DAO members.

Immediate Deliverables (within 2 days of approval)

  • Live staging site with initial dashboard and placeholder data.

  • Working frontend component with visual progress indicators.

Technical Stack

  • Frontend: React + Tailwind CSS

  • Backend: Node.js + PostgreSQL / Supabase

  • Integrations: Discourse scraping, Etherscan/Polyscan APIs, SandboxDAO Treasury Wallets

  • Hosting: Vercel + Supabase (secure, role-based access)

Readiness

  • Team available to start the same day as approval.

  • Design assets and technical architecture are already outlined.

  • Risk management and treasury mapping logic prepared for rapid integration.
    Community Discussion: Forum Thread & Feedback

Update: I’m withdrawing this proposal to be submitted via SIP instead of SDGP to ensure timely review and delivery. Looking forward to community feedback there!

1 Like