What is the Question?🚨

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

Analyzed Topics:

1. Overall & Over Time Marketing-DAO Statistics
2. Grants and Disbursed Funds
3. Council Members

Introduction🚩

What is Marketing DAO?

The MarketingDAO serves to enable NEAR Communities, Guilds, and Projects to achieve their marketing goals through both consultation and dynamic funding.

More Info

What Is Near Protocol?

NEAR Protocol is a decentralized application (dApp) platform and Ethereum competitor that focuses on developer and user-friendliness. Its native NEAR tokens are used to pay for transaction fees and storage on the Near crypto platform.

More Info

Method⚡

In this dashboard i tried to track Marketing-DAO grants and activity since its launch to see how it performed and what was going on with its grants over time.

For this purpose i got help from Flipsidecrypto and used its ==Near.core== database to extract the data from it.

I filtered Marketing-DAO stats on NEAR tables with RECEIVER_ID = 'marketing.sputnik-dao.near' and also for its activity i used

METHOD_NAME ='act_proposal' clause too.

Findings👀

• In this section, i showed an overview of Marketing-DAO activity in overall and monthly basis.
• Most of Marketing-DAO activity happened on Feb and May 2022 while the highest number of validators belongs to September when they were equal on VoteApprove and VoteReject with 3 votes.
• VoteApprove is leading on all charts except validators and it was the highest number of votes that has been recorded by voters on Marketing-DAO.
• By far, A total of 12 voters has been recorded 1960 votes on proposals and they were 10 council members with 3 validators on Marketing-DAO over time.

2. Grants and Disbursed Funds

Findings👀

• Above charts are showing the grants status on Marketing-DAO and we can see what percentage of them has been rejected and how many of them has been approved by voters.
• As we see, Most of the grants has been approved on Marketing-DAO with a percentage of over 81% and 492 grants in total while they were 14 grants that got rejected over time.

Findings👀

• Here i showed monthly disbursed funds on Marketing-DAO by top 10 receivers and their overall stats and share.
• The highest amount of funds disbursed on December 2021 when most of it belong to stars-guild.sputnik-dao.near with 5850 $NEAR followed by rucommunity-sputnikdao.near with 4140 $NEAR.
• After that month, the amount has decreased massively and didnt record a serious move after that but after few months on August, the disbursed amount peaked again but not as much as the last peak, which was most of it belongs to blckhntr.near with 8130 $NEAR, the highest disbursed amount that has been recorded in 1 single month.
• In total share, we see that rubycop.near is in the first place of the most disbursed funds and total volume with 8750 $NEAR and accounting 20.5% of the whole share followed by blckhntr.near with 8130 $NEAR which i talked about it earlier that it has recorded this amount in only one month.

1. Overall & Over Time Marketing-DAO Statistics

3. Council Members

Findings👀

• This section is all about council members and their activity and also their join dates.
• The most active council member was whendacha.near wallet address which has joined on December 13th 2021 and has been recorded 533 votes so far.
• cryptocredit.near and alejandro.near recorded pretty close number of votes together and they are the highest votes casted by council members after whendacha.near.

Conclusion💡

• In overall, Marketing-DAO has recorded pretty good activity in the past especially 2022 but recently the activity has decreased and November had the lowest activity of all time for Marketing-DAO. Most of the votes were VoteApprove followed by VoteReject in the second.
• over 80% of grants has been approved which means a total of approximately 500 grants.
• The highest disbursed funds on Marketing-DAO happened on December 2021 with over 15K $NEAR and rubycop.near is in the lead in this term with 8750 received $NEAR over time.
• It is interesting that Alejandro.near and cryptocredit.near council members has joined together to Marketing-DAO on a same date.

Author: Sbhn_NP

Discord : Sbhn_NP#8717

Twitter : Sbhn_np

Instagram : Sbhn_NP

Special Thanks to Yousefi_1994 for some inspiration and queries.

> Image Source

Thanks for your time!