Question in detail:

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

Overview of analysis:

The activity of MarketingDAO on NEAR blockchain has been investigated through this analysis. This analysis contains 3 parts as below:

• Track voting stats on MarketingDAO (General and over time)
• Proposals on MarketingDAO
• Summary and references

Approach:

The data provided by Flipside has been used to handle this analysis.

• Account of MarketingDAO on NEAR:
  • Account: @marketing.sputnik-dao.near
• Used tables:
  • near.core.fact_actions_events_function_call and METHOD_NAME = 'act_proposal'
  • join near.core.fact_transactions on previous table with tx_hash
  • join near.core.fact_receipts with tx_hash
• Used Metrics:
  • Count of proposals, Captured vote, unique voters, council members, average vote per proposal and voter, total and average amount of funds disbursed
  • Cumulative, average and weekly analysis of previous metrics over time
• Proposals on MarketingDAO
  • Targer wallet, amount of funds, description of proposal
• Conclusion: By aggregating the outcomes of the previous parts and deep dive into the proposals of MarketingDAO on NEAR draw a conclusion about the Blockchain.

NEAR blockchain:

Near is a public, sharded, extensible blockchain network based on the proof-of-stake (POS) paradigm. Developers can use this platform to launch their own decentralized applications (similar to the Ethereum network). The token of this network is called NEAR, which is the functional token of this network. The main goal of the NEAR network is to create an infrastructure for creating a new Internet. In the new internet, it will be harder for big companies to access people's personal information. Countries cannot ban some programs and destroy their business in this system. A world of freedom where everyone can act freely.

MarketingDAO:

One of the central tasks of management in centralized systems and networks is to make decisions about processes according to the interests of the network. The concept of DAO or Decentralized Autonomous Organization is a solution for automating decision-making processes using smart contracts, which is widely used in DeFi projects.

> The Marketing DAO allocates funding to NEAR ecosystem marketing initiatives seeking grants under $10K USD. The Marketing DAO is made up of globally distributed marketing professionals, creatives and NEAR enthusiasts. > > The Marketing DAO began during the summer of 2021 to empower active members of the NEAR Community to use marketing activities to further the overall growth and expansion of the NEAR ecosystem. > > The origins of the Marketing DAO date back to the original Sputnik DAO. We were among the first to migrate to AstroDAO when it launched and to this day are amongst the most active DAOs. > > From AwesomeNEAR

Part 1: Track voting stats on MarketingDAO (General and over time)

Part 3: Summary and references

Part 2: Proposals on MarketingDAO

This part represents the detailed information about the proposals on MarketingDAO. Two various tables have been represented and according to them you can find the following information about proposals on MarketingDAO:

• The status of proposals with accept and reject votes
• Count of voters and council members
• The amount of disbursed fund
• Target wallet of proposal
• Description of proposals on detail

How to use these tables:

• For example, the proposal No.335 has been accepted with domination of positive votes and has 3 council members.
• Also, proposal No.496 has the highest amount of fund with 8130. However if we track this proposal in the first table, it can be seen that this proposal has been rejected.

Findings:

This part contains the outcomes related to the activity of MarketingDAO on NEAR in general and over time.

• Total count of captured votes on MarketingDAO is about 1950 votes and the average vote per proposal is about 3.22 votes.
• The distribution of captured votes by vote options demonstrated the dominance of VoteApprove on MarketingDAO with 82% of captured votes.
• The distribution of unique voters and council members on MarketingDAO reveal that the VoteApprove has higher count of users compared to other options.
• The total volume of disbursed fund is about 75.7k and the average disbursed fund is 561.
• The most important outcome of this part is related to the accepted proposals on MarketingDAO. According to this outcome, about 79% of proposals have been accepted with 504 proposals.
• The highest count of captured votes occurred on March 14 to 21, 2022 and the VoteApprove option dominated the captured votes on that week.
• The highest volume of disbursed fund on MarketingDAO happened on second week of December 2021 with 11.66k.
• The average disbursed fund on MarketingDAO shown the highest average fund occurred on Third week of November 2022.

Conclusion:

By aggregating the outcomes of the previous parts and general knowledge of DAO and NEAR ecosystem, the following statements could be drawn as conclusion:

• The collective consensus mechanism in DAOs is decentralized and usually distributed among investors according to the amount of tokens that users lock for voting rights. According to this definition, the importance of proposals on MarketingDAO could be determined from the locked and the consequences of this action.
• The DAO concept is a decentralized financial service solution to resolve the conflict of interests between the investors of a project and its development team. In DAO projects, users can determine the fee rate, profit, and various variables affecting their interests. The trend of proposals on MarketingDAO demonstrated the specific patterns related to various proposals and their outcomes.

Useful links:

• NEAR blockchain
• MarketingDAO account
• Proposals on MarketingDAO

Author:

Credited by MZG

Discord handle: m.zamani#0361

Twitter handle: @GargariZamani