MetricsDAO dashboard
Introduction
MetricsDAO is a decentralized autonomous organization that is committed to promoting the growth and development of the blockchain ecosystem. The organization uses multisigs on various blockchains to receive funds from partners and pay out participants, thereby ensuring transparency and accountability in the distribution of funds.
To facilitate this process, MetricsDAO has a treasury dashboard that allows stakeholders to track the inflows, outflows, and balances of tokens and USD across different chains. The dashboard provides a comprehensive overview of the current treasury balance, as well as detailed metrics on payouts to contributors and marketplace participants.
The dashboard has a user-friendly interface that provides easy access to the key metrics and performance indicators that matter most to users. Users can view the total value of tokens transferred via MetricsDAO multi-sigs since inception, as well as the total number of unique wallets paid via MetricsDAO multi-sigs since inception.
In addition, the dashboard provides detailed information on the treasury balance, including balances by token by chain and balance over time by chain in USD. Users can also view inbound and outbound transaction data in bar chart form, as well as a tabular view of all inbound and outbound token flows.
The dashboard also includes user metrics, such as the average number of payouts per wallet, broken out by contributor vs. marketplace participant. Users can view monthly contributor payments vs. challenge-specific payments, as well as unique wallets paid per month broken out by chain. The dashboard also provides insights into payouts per bounty, broken out by partner.
Overall, the MetricsDAO treasury dashboard is a powerful tool that provides stakeholders with a comprehensive and transparent view of the organization's financial performance. The dashboard is regularly updated with accurate and up-to-date information, and it is hosted on a platform that allows others to easily fork code,
References :
- Metrics from brainstorming even : https://metricsdao.canny.io/metricsdao/p/brainstorming-metricsdao-treasury-dashbboard
- Contracts from https://docs.metricsdao.xyz/metricsdao/treasury
- Jackguy's dashboard on https://flipsidecrypto.xyz/jackguy/mdao-multisigs-M7MTQW was used for calcluating the treasury balance over time for Terra and Near chain. While his code for terra treasury does not include the latest payment address 'terra1v0yhsvk9gzwglu27c02md9z9kmg0vqgrf4q433', the code has been modified to include it.
Note : As this is a dashboard challenge and not an analytical piece, The words used are kept to a bare minimum.
Methodology:
-
Ethereum: To determine outgoing transfers made to pay contributors, we used the Fact_Token_Transfers Table and qualified the transactions by the amount paid. Contributors are typically paid in USDC with a value of either 300, 600, 1,200, or 4,000. The USDC values were used to identify the transactions made to contributors. The top five active analysts were identified based on their participation in one of the past five dashboard challenges on the specified chain.
-
xMetric: To determine the XMetric balance, we utilized the Fact_Token_Transfers Table and filtered out transactions made to the MetricsDAO contract address (0x4b8923746a1d9943bbd408f477572762801efe4d). We considered new users as those addresses that have received XMetric tokens for the first time and active analysts as those who participated in one of the previous five challenges.
In order to identify the treasury balance, we referred to the total cap mentioned on Polygonscan and subtracted the total amount of XMetric tokens issued. As XMetric tokens are non-transferable, only the treasury can send them.
-
Terra : In order to determine the payments issued on Terra, we utilized the terra.core.ez_transfers table. The treasury address used for this purpose was ('terra1tu5z28h9ssattvsltlzt5c8r2mvs2006qvq3tvjk5c8fxve85xss84w8vr') as mentioned in the MetricsDAO documentation. However, to identify the outgoing transactions, we needed to look at two addresses, namely ('terra1tu5z28h9ssattvsltlzt5c8r2mvs2006qvq3tvjk5c8fxve85xss84w8vr', 'terra1v0yhsvk9gzwglu27c02md9z9kmg0vqgrf4q433'). We defined new users as the addresses that received the token for the first time and active analysts as those who had participated in at least one of the past five challenges
-
Near : To determine the NEAR token balance, we use the fact_receipts table from Flipside Crypto. The treasury address used is 79501b068d4fcbbcea3e7c332891a7d8abfd9864657b9c2cc3c18c944b1db558, obtained from the MetricsDAO documentation. We identify outgoing transfers made from the treasury address, as well as from 12da367348f40c3dec5b919c49b61bf4eb67544674e71edbe93dcbaded3819ea, 869554f6594f866d1aeae1c07d4687ebf8e421d6ef69c460b48ce0b33733eebf, 38b445487678a1173fba0e09fd346f3ecb66db858cb399d7637d7618868f9f03, and d1cba12439c2fa4e0b55ae880b830de415e70ccee22fc7e4cd2493d9a871bace identified as NEAR payments.
We define new users as the addresses that have received the NEAR token for the first time, and active analysts as those who have participated in one of the past 5 challenges.
Definitions:
- New users: We define new users as the addresses that have received the NEAR token for the first time
- Active analysts: active analysts are those who have participated in one of the past 5 challenges.