Overview
- Determine which metrics are wanted by the team
- Ensure they’re easily accessible through: Dune, pool-stats, pool-explorer.
Thread
Aggregated Requested Metrics
- PoolTogether Users
- Token holder breakdown percentiles
- For all chains and prize pools
- Average time holding tokens in a prize pool
- Over time
- For all chains and prize pools
- Wallet experience level
- Wallets that have used other protocols
- Aave, Uniswap
- What clusters of protocols do our users interact with
- Prize Pool Network
- Token infolows/outflows
- Total Yield vs Prizes vs Expenses
- Total
- Prize Pools
- Prizes
- Unique winners per draw
- % of total depositors that won
- % of total prize dollars going to the top 1%, 5%, 10%, 25%, 50% of ticket token holders
- Average & median deposit size of winners
- Expected APR vs real APR
- Expected return rate range by deposit graph
- x axis is deposit size
- y axis is APR
- 1 line graph for “Unlucky”
- Expected win rate / 2
- 1 line graph for “Lucky”
- Expected win rate * 2
- NOTE: Probably not the best number, need to play with the “lucky” scaling number
- Unique withdrawer count vs unique depositor count
- Withdrawals (per draw)
- Total withdrawn amount
- Average & median withdrawal size
- % of total depositors who have withdrawn fully
- Note: Account for users migrating chains
- Deposits (per draw)
- Total deposited amount
- Average & median deposit size of all depositor
- Prize pool % of total unique depositors
- Prize pool % of total deposit value
- Total Yield vs Prizes vs Expenses
- Number of wallets withdrawing/depositing over time
- Not just withdraw/deposit events/amounts
- User
- Time since last win
- “Lucky score” - deviation from the expected win frequency for a given deposit size
- Gas spent
- Claiming, depositing, withdrawing, delegating
- For all chains and prize pools
- Token Faucets
- Token X claimers who sold token X 24h, 7d, 1m after claiming
- POOL Pool, OP
- % of wallets that hold at least X% of the amount of token X they claimed
- POOL Pool, OP
- What did the top Y percentile of token X claimers do with their tokens
- POOL Pool,OP
- DAO Multisig views
- Token inflows & outflows
- App
- User
- Location
- Language
- Deposit size
- Return rate
- Log site visits
- Frequency of visiting the site
- Averages
- Time since last visit
- Referrer
