{"signature": "0x1e962467e71ccfcccc99e8c8820ff9a97ef1252d55ba50788fe6ab17726eb532230dd4d76ac8d77d67b247dc1575fc72940740189a7211b0618a4dfc45bace8e1b", "application": {"round": "0x3aA3C6cc0004b7366A12b8E4262015AF525531a9", "answers": [{"type": "short-answer", "answer": "GoodDollar: Dune Spellbook Models enhances G$ utility and adoption by establishing a comprehensive analytics infrastructure on Dune Spellbook to track UBI distribution on the Celo blockchain. By transforming raw onchain data into structured, easily accessible models, this project provides deep insights into individual claims, aggregate statistics, and behavioral patterns. These data models improve transparency, empower researchers to analyze UBI efficiency and engagement, and enable ecosystem participants to make data-driven decisions. By increasing the accessibility and accuracy of GoodDollar’s financial data, this initiative strengthens trust, adoption, and usability of G$ within the broader Web3 community.", "hidden": true, "question": "Project Description: Briefly describe your project and how it enhances G$ utility or adoption", "questionId": 0}, {"type": "paragraph", "answer": "My approach leverages Dune Spellbook, a collaborative dbt framework, to transform raw blockchain data into structured analytics models focused on GoodDollar's UBI system on Celo. I'll extract and process transaction data from GoodDollar's smart contracts, implementing data models that track individual claims, daily aggregations, claimer statistics, and engagement patterns. The solution integrates directly with GoodDollar by monitoring on-chain events and contract interactions, requiring no additional infrastructure from the protocol team. My implementation plan includes developing SQL-based transformations, establishing comprehensive data tests for accuracy, and documenting each model thoroughly to ensure accessibility for community developers and researchers who wish to build upon this analytics foundation.", "hidden": true, "question": "Technical Implementation: Describe your approach and how it integrates with GoodDollar. For new builders, outline your implementation plan. ", "questionId": 1}, {"type": "paragraph", "answer": "I bring over 15 years of professional SQL development experience to this project, with specialized expertise in web3 analytics. As a major contributor to Dune Spellbook with 170+ merged PRs, I've developed analytics infrastructure across DeFi sectors including DEX trading, lending protocols, perpetuals markets, and on-chain attestations. Currently serving as the Dune Wizard for Nexus Mutual, I've demonstrated the ability to transform complex blockchain data into accessible analytics models. My experience includes collaborating with DAOs, building data quality dashboards, developing API integrations, and implementing blockchain data feeds for web3 projects. This diverse background in both traditional data engineering and blockchain-specific analytics positions me ideally to deliver comprehensive GoodDollar UBI analytics infrastructure.\n\nhttps://github.com/tomfutago \nhttps://dune.com/tomfutago ", "hidden": true, "question": "Team Capability: Highlight your team's relevant experience and past delivery of similar projects, particularly in the Web3 space or with GoodDollar. Please add relevant links to members GitHub, Twitter, LinkedIn, etc as needed. ", "questionId": 2}, {"type": "paragraph", "answer": "1. Initial Data Model Implementation (Month 1-2)\n- Submit first Dune Spellbook PRs, focusing on foundational models for claims tracking and claimer statistics (already completed).\n- Conduct validation and refinement to ensure data accuracy and usability.\n\n2. Expanding Analytics Models & R&D (Month 2-4)\n- Research additional analytics needs within the GoodDollar ecosystem.\n- Develop and deploy new models to enhance engagement tracking, behavioral analysis, and financial inclusion metrics.\n- Improve data coverage and efficiency through iterative optimization.\n\n3. Collaboration within Onchain Data Transparency Track (Ongoing)\n- Work closely with the GoodDollar community and broader Celo ecosystem to ensure transparency and accessibility of onchain data.\n\n4. Infrastructure Migration & Dashboard Development (Month 4-6)\n- Support migration of GoodDollar’s data infrastructure to Dune, ensuring a seamless transition.\n- Assist in moving the main GoodDollar analytics dashboard to Dune for improved data accessibility.\n- Develop supplemental dashboards to provide deeper insights into UBI distribution, user engagement, and ecosystem trends.\n\n5. Long-Term Sustainability & Knowledge Sharing (Month 6+)\n- Document all models and methodologies to ensure long-term maintainability.\n- Explore additional use cases for data-driven insights within the GoodDollar protocol.", "hidden": true, "question": "Roadmap & Milestones: Outline 3-5 key milestones with timeframes demonstrating how you'll deliver value to the GoodDollar ecosystem.", "questionId": 3}, {"type": "paragraph", "answer": "The created \"spells\" will be publicly available on the Dune platform, enabling data analysts to build custom dashboards and conduct in-depth analysis, driving transparency and G$ adoption.", "hidden": true, "question": "User Adoption Strategy: How will you attract users to your project and drive G$ adoption? Include specific strategies or metrics. You can find more details on the engagement rewards to support this at: https://engagement-rewards.vercel.app/ ", "questionId": 4}, {"type": "paragraph", "answer": "Funding will be allocated solely as compensation for my time and expertise, as no additional resources or infrastructure are required—my rewards will directly reflect the value delivered through analytics development and ecosystem contributions.", "hidden": true, "question": "Funding Allocation: How will you allocate the funding to maximize impact? Provide a simple breakdown of resource allocation. ", "questionId": 5}, {"type": "paragraph", "answer": "Dune Spellbook is an open-source project, and the Dune platform is publicly available for any analyst to use, ensuring that my work complements existing GoodDollar initiatives by enhancing data accessibility rather than competing with them.", "hidden": true, "question": "Ecosystem Contribution: How does your project complement existing initiatives in the GoodDollar ecosystem rather than competing with them?", "questionId": 6}, {"type": "dropdown", "answer": "Yes", "hidden": true, "question": "Ethical Compliance: Confirm you have read and will comply with the ethical standards outlined in the eligibility criteria.", "questionId": 7}, {"type": "paragraph", "answer": "This project aligns with the broader goal of onchain data transparency, ensuring that GoodDollar's UBI distribution can be analyzed and understood by the community with ease.", "hidden": true, "question": "Additional Info: Is there anything else critical for evaluating your project that wasn't covered in the questions above?", "questionId": 8}], "project": {"id": "0xf8d775bf30fbf4c772dbe0a18e5a1e7dd278eadc8ffef556d9b98b36e9d293b6", "title": "GoodDollar: Dune Spellbook models", "logoImg": "bafkreig5g33m5wliz3frmebr3w3dybbujsbguqmea2hub65vhjx6byt4w4", "metaPtr": {"pointer": "bafkreid6plewoj7i3ktlbyxaxpuyvzzeoewvixuovyominya7zp2hsdjwi", "protocol": "undefined"}, "website": "https://github.com/duneanalytics/spellbook", "createdAt": 1742830649946, "userGithub": "tomfutago", "credentials": {"twitter": {"type": ["VerifiableCredential"], "proof": {"type": "EthereumEip712Signature2021", "created": "2025-03-24T15:34:57.717Z", "@context": "https://w3id.org/security/suites/eip712sig-2021/v1", "proofValue": "0xa69ff4edf70226ed2dc5a4f38f5e738bceab7e50c96eae6b390d1ac9f89c07f34e9b28ecfe925ce7fa68770ceb1b350d10dbac4de1ea04d862278a227af38e761c", "eip712Domain": {"types": {"Proof": [{"name": "@context", "type": "string"}, {"name": "created", "type": "string"}, {"name": "proofPurpose", "type": "string"}, {"name": "type", "type": "string"}, {"name": "verificationMethod", "type": "string"}], "@context": [{"name": "nullifiers", "type": "NullifiersContext"}, {"name": "provider", "type": "string"}], "Document": [{"name": "@context", "type": "string[]"}, {"name": "credentialSubject", "type": "CredentialSubject"}, {"name": "expirationDate", "type": "string"}, {"name": "issuanceDate", "type": "string"}, {"name": "issuer", "type": "string"}, {"name": "proof", "type": "Proof"}, {"name": "type", "type": "string[]"}], "EIP712Domain": [{"name": "name", "type": "string"}], "CredentialSubject": [{"name": "@context", "type": "@context"}, {"name": "nullifiers", "type": "string[]"}, {"name": "id", "type": "string"}, {"name": "provider", "type": "string"}], "NullifiersContext": [{"name": "@container", "type": "string"}, {"name": "@type", "type": "string"}]}, "domain": {"name": "VerifiableCredential"}, "primaryType": "Document"}, "proofPurpose": "assertionMethod", "verificationMethod": "did:ethr:0xd6f8d6ca86aa01e551a311d670a0d1bd8577e5fb#controller"}, "issuer": "did:ethr:0xd6f8d6ca86aa01e551a311d670a0d1bd8577e5fb", "@context": ["https://www.w3.org/2018/credentials/v1", "https://w3id.org/vc/status-list/2021/v1"], "issuanceDate": "2025-03-24T15:34:57.717Z", "expirationDate": "2025-06-22T15:34:57.717Z", "credentialSubject": {"id": "did:pkh:eip155:1:0xfDe4Bef9B6060cE3a214FbC220677a13535CEb9A", "@context": {"provider": "https://schema.org/Text", "nullifiers": {"@type": "https://schema.org/Text", "@container": "@list"}}, "provider": "ClearTextTwitter#tomfutago", "nullifiers": ["v0.0.0:hIfb7xRYFTUYuTo+awTzADi2CFnPw4V/QHZwSE4pdzc="]}}}, "description": "This project establishes comprehensive analytics infrastructure within Dune Spellbook for tracking UBI distribution through the GoodDollar protocol on the Celo blockchain. Created data models capture individual transaction details to aggregate statistics and behavioral patterns.\n\nAdded data models (\"spells\") improve onchain data transparency for GoodDollar by enhancing the accessibility, accuracy, and usability of blockchain data for developers, community members, and ecosystem participants. Researchers can analyze UBI distribution efficiency, participant engagement, and financial inclusion metrics with ease.\n\nKey capabilities include:\n- Transaction-level tracking of all UBI claims with complete financial details\n- Daily aggregation of claim metrics to identify temporal patterns\n- Individual claimer profiles with comprehensive financial summaries\n- Advanced engagement analytics through streak tracking and behavioral modeling\n\nThis infrastructure supports evidence-based decision making, provides transparency for stakeholders, and enables research capabilities on the real-world implementation of Universal Basic Income programs on blockchain networks. All models are designed with rigorous data validation to ensure reliability for critical economic analysis.", "lastUpdated": 0, "projectGithub": "tomfutago", "projectTwitter": "tomfutago"}, "recipient": "0xfDe4Bef9B6060cE3a214FbC220677a13535CEb9A"}}