Methodology

Dashboard Objective

Show the total & time performance for the top 4 projects that received the biggest amount of $ARB to their DAOs, explain the reason behind that allocation and give some insights in how they should allocate these tokens.

Dashboard Structure

Introduction
Total Metrics
- Total Transactions - Active Users - $ETH Fees
- Transactions and Gas Fees (USD) Activity
Time Metrics
- Weekly Transactions
- Weekly Users
- Weekly $ETH Fees
- Weekly $USD Fee per Transaction
- User Retention - Stickiness Ratio (DAU/MAU)
User Preferences
- Treasure User Preference
- GMX User Preference
- Uniswap User Preference
- Sushiswap User Preference
Conclusion
Methodology

Dashboard Method

Using Flipside Tables of Arbitrum I'll track the activity of the top 4 projects using the transactions obtained in the events table after joining the contract address with the addresses from the label table for these four projects.

--Table Used to get all the Activity

arbitrum.core.fact_transactions

--To get the transactions I used this method (From Adria Parcerisas Query)
--Project = 'treasure dao','gmx','uniswap','sushiswap' 

Project as (
select tx_hash
from arbitrum.core.fact_event_logs 
join arbitrum.core.dim_labels  on contract_address=address
where project_name = 'Project'
)

--To get the Amount of days for my X_per_day and X_per_second columns

datediff(day,min(block_timestamp)::date,current_date()::date) 

--This was 343 for the 4 projects, meaning that the data from Flipside doesn't cover all time.

--To get the $USD price for the fees

from arbitrum.core.fact_transactions left join (
    select
      date_trunc('day', hour) as day1,
      avg(price) as price
    from ethereum.core.fact_hourly_token_prices
    where symbol LIKE 'WETH'
    group by 1 
  ) on day1 = date_trunc('day', block_timestamp)

-- Stickiness Ratio is a template learned at the Alchemist Bootcamp from Covalent

-- $ARB Price

select date_trunc('hour',recorded_hour) as "Date",
avg(close) as "Price"
from crosschain.core.fact_hourly_prices
where ID = 'arbitrum'
group by 1

Dashboard Sources

What is Arbitrum by Arbitrum Docs

$ARB Airdrop and Screenshots of the Airdrop by Arbitrum Docs

Doc for the DAO Distribution by Arbitrum Docs

Arbitrum Logo

MetricsDAO Bounty Question

1.13% of ARB Allocations have been sent to DAOs within the Arbitrum ecosystem. If you were the Arbitrum Foundation, how would you allocate these tokens across DAO users, and why?

First analyze the top DAOs within the arbitrum ecosystem. Then, provide reasoning through on-chain data as to why they should receive an allocation and how much?

Dashboard	Creator	Published
ShroomDK Mint Jul 2, 2022	Popex404	Jul 2, 2022
Ethereum and the Address Poisoning Incident Jan 13, 2023	Popex404	Jan 13, 2023
Blur.io NFT marketplace Dec 9, 2022	Popex404	Dec 9, 2022
$ARB DAO Allocation Mar 27, 2023	Popex404	Mar 27, 2023
Total Value Locked Jul 2, 2022	Popex404	Jul 2, 2022

Popex404