Tracking MarketingDAO Grants

The NEAR MarketingDAO is in need of a grants tracking dashboard to better monitor the outcome of grant requests from their treasury. Discussion around these requests happen on the NEAR forum, but the formal decision is a vote on AstroDAO, codifying the results on chain.

Examples of the votes can be found on the platform here: ____ 

Once a proposal is approved via discussion on the NEAR forums, the team will submit a formal funding request on the AstroDAO platform. 

The analytics dashboard should track proposals and funding for the MarketingDAO's grants program. The necessary details, including the amount of funding and the target wallet are available in the proposal on AstroDAO.

The dashboard should track the funds sent on the blockchain and display metrics such as:

• number of grants approved, 
• amount of funds disbursed over time
• project name(s)
• target wallets
• council member & votes

✨ Introduction

Astro is a platform for On Chain Communities (OCC). OCC are groups of people that prove their membership and coordinate decisions through a series of smart contracts. Each vote is verified by the blockchain, and funds are distributed based on voting decisions. What is a DAO Astro builds on the foundations of SputnikDAO V1 and widely expands the functionality of DAOs built atop it. Features shipped with Astro include:

Flexible, role-based voting policies. In V1 all DAO members were Council members and each had equal voting rights. Stable coin payouts. This reduces the uncertainty imposed by crypto volatility between proposal requests and payouts. Polling system for governance. Electing representatives. Cross-DAO accountability: DAOs can serve as members of other DAOs. DAOs can own each other's social tokens for shared investment in collaboration.

Proposals are the primary way to interact with the DAO. Every action in the DAO is done by creating proposals and voting on them. Once proposal is approved by DAO members action is performed.

🛠️ Method

Since most events with "marketing.sputnik-dao.near" as the tx reciever take place in the near.core.fact actions events function call table, that's where I'll be focusing my attention for the bulk of this dashboard. Both the first and second varieties of function call methods will be examined. One such function is "add proposal," which monitors new proposal submissions. I can extrapolate a number of metrics from this, including the total number of proposals, their contents, their dates of creation, their types, the amounts of money provided for proposals, and their recipients. The "act proposal" method type, which is related to voting on specific proposals, is the second one I'll examine. I may access the council members' voting records for each proposal id and use that information to ascertain the proposals' final fates. In this article, I will be exploring a different database table than near.core.fact actions events function call. If I look at the transfer history for "marketing.sputnik-dao.near," I can see that it was transferred from near.core.fact transfers. I'll do my best to keep track of and discuss in this dashboard anything that I think might be of use to you, the reader. ⏳

🌡️ Analysis 🔎

✍🏻 Conclusion

In conclusion, the MarketingDAO on the NEAR ecosystem has been actively used to manage its grants program, with 1950 votes captured and an estimated $75,7k worth of funds disbursed. The majority of these votes were for the "VoteApprove" option, with 82% of the total votes. The highest number of captured votes was in the week of March 14-21, 2022, with the "VoteApprove" option again being the clear majority. The average disbursement of funds was $561, with two addresses, blckhntr.near and rubycop.near, receiving a disproportionate number of transfers. The busiest time for transfer proposals was between November 2021 and January 2022, with the second week of December 2021 having the greatest volume of disbursed funds and the third week of November having the highest weekly average disbursed fund. The decentralized consensus mechanism in DAOs allows users to determine the fee rate, profit, and other variables affecting their interests, as seen in the trend of proposals on MarketingDAO.

Hey there 👋!

Firstly, I appreciate you sticking with it until the conclusion.

I'm Hamed, a civil engineering Ph.D.

student interested in data analysis.

I've made many similar dashboards and visualizations since I started at Flipside in January.

Please take a look at my various contact details and let me know what you think.

About:

• Author: HaM☰d

• Discord: 0xHaM☰d#8391

• Twitter: @arjmandi_hamed

• Email: h_arjmandi2012@yahoo.com

🔎 Findings:

The results of MarketingDAO's involvement with NEAR over time are presented below.

We have captured roughly 1950 votes on MarketingDAO, with an average of 3.22 votes per proposal.

In a breakdown of captured votes per voting option, VoteApprove was shown to have received 82% of MarketingDAO's total votes.

VoteApprove has a larger user base than the other choices, according to MarketingDAO's distribution of voters and council members.

An estimated $75,7k worth of funds have been dispersed, with an average disbursement of $561.

The suggestions that are ultimately accepted on MarketingDAO represent the most significant outcome of this section. This result indicates that 790 proposals, or 81%, have been approved.

The following table represents the project name, target wallets, & votes state and count fpr each Proposal

🔎 Findings:

The week of March 14-21, 2022 saw the highest number of captured votes, with the VoteApprove option gaining a clear majority.

🔎 Overview

Here I will examine proposal transfers and the receiver ids associated with them. There are two primary kind of proposals, namely transfer proposals and vote proposals, as was mentioned before. The sums involved in the proposed transfers are the primary topic of this section.

Payments and Recipients:

To begin, we can see that the average number of NEAR being transferred through these transfer proposals is 561, based on the stats displayed at the beginning of this section. Due of outlier transfers, the average isn't a perfect representation of the distribution, but the median can tell us a lot about the mode. Two of the receiver id addresses, blckhntr.near and rubycop.near, have received a disproportionately large number of NEAR, as shown in the two graphs in the second row. Over 22% of all proposal volume is sent to just these two addresses. In the next two charts, we may examine the distribution of transfer requests by postal code. Only roughly 36% of receiver ids have been transferred to more than once, hence the vast majority have never received a transfer at all. Interestingly, while rubycop.near has received three independent transfers, blckhntr.near has only received one transfer, the largest single transfer ever received.

Sending a Proposal in a Larger Quantity:

This section concludes with a look at the overall volume of transfer proposals received each week, which once again reveals that the busiest time is between November 2021 and January 2021. The number of proposed transfers has been low during the past few months.

• The second week of December 2021 had the greatest volume of MarketingDAO disbursed funds with 11,66k.

• The third week of November 2022 has the highest weekly average disbursed fund on MarketingDAO.