[1IP-18] 1inch Analytics Dashboard

Voting ended about 3 years agoSucceeded

Summary

We propose to build a dedicated analytics dashboard for the 1inch ecosystem, allowing users to analyze the protocol's main KPIs, activity, treasury, and token related metrics. This proposal is coming along after several meetings with 1inch core team. We determined the requirements scope and technical design together.

Abstract

The dashboard will allow anyone in the community to browse the protocol's treasury, KPIs, token metrics, and transactions. The dashboard will initially support the following chains:

Ethereum
Polygon
Avalanche
Arbitrum
Optimism
BSC Dashboard will be served on a dedicated web app.

Motivation

Make the protocol's key information as accessible and transparent as possible.
Help governance and users with decision-making.
Provide more thorough information than currently available on Dune (i.e breakdown per user, search tooling)

Specification

This dashboard will be built using the Dune API as a data source. Data from Dune will then be indexed on an intermediate database for easy and quick access. We propose to create the following subsections for the dashboard:

Homepage (Protocol KPIs)

The UI would be somewhat similar to this: https://info.notional.finance/

Users
DAU, WAU, MAU
Cumulative user count
Transactions
Daily, weekly and month trade count
Breakdown of the number of trades per DEX
Volume
Daily volume, weekly volume, monthly volume
Average trade size (daily, weekly, monthly)
Median trade size (daily, weekly, monthly)
Volume by underlying liquidity source

1inch Fusion

1inch Fusion KPIs
Total orders, volume, unique users (current + historical)
Latest and top transactions
Explore and compare resolvers
Search by address
Compare and access all resolvers in a leaderboard view - Sort by unicorn power, staked 1Inch, all-time fees, total orders, …
Breakdown per resolver (Total orders and volume, Historical orders and volume, Historical fees, Staked 1inch / unicorn power / lockout period)

Treasury

The UI would be somewhat similar to this: https://info.notional.finance/treasury

Protocol treasury balances per token.
Cumulative treasury revenue over time (per token type)
List of recent treasury transactions
Protocol revenues (daily/weekly/monthly)
Revenue as a percentage of volume (daily/weekly/monthly)

1INCH/st1INCH token section

The UI would be somewhat similar to this: https://info.notional.finance/note-token

Token price over time
Token unlock supply schedule over time
TVL
Amount of staked 1INCH (st1INCH) over time
Staking rewards

Recent Transactions

The UI would be somewhat similar to this: https://info.notional.finance/transactions

List of recent transactions (tx amount, user, main liquidity source, link to etherscan)
Filter for a given account

Transaction gas cost estimate

Similar to what we show on the left side of the screen here: https://info.notional.finance/

Estimated gas cost in USD
Gas price in GWEI chart
ETH price Hosting and maintenance of the web app will be provided by the Shippooor team.

Rationale

Dune analytics is the current solution for surfacing most of that information. Due to technical limitations, Dune does not allow surfacing per-user information and does not provide useful search features. Also, in general, Dune dashboards have a hard time getting the reach they deserve. Not only the information is often non-trivial to understand. but the dashboards themselves are hard to find. 1 Inch Dune account: https://dune.com/1inch Important Dune Dashboards: https://dune.com/1inch/main https://dune.com/1inch/fusion

Considerations

Hosting and Maintenance

Website will be hosted through 1inch subdomain (i.e info.1inch.io) Shippooor commits to 1 year maintenance. Will be renewed through governance afterward. Code will be open sourced.

Costs

Dune API integration work & intermediary database - $35k

Identify and expose all existing Dune queries that will provide data (historical volume, DAU, transactions, protoco, 1inch token)
Write new Dune queries for missing data (i.e breakdown per resolver, treasury balances/historical data)
Implement cron workers that will sync all Dune queries with DB through Dune API
Convert Dune data structures to fit DB's model
Design and implement a relational model that will allow to quickly query and filter the data (wallets, transactions, 1inch fusion resolvers, treasury portfolios, historical data, etc.)
Design and implement a production setup on AWS (or other cloud provider if needed) supporting all of the above + CI/CD. Likely going to be Amplify + Postgres on RDS
Setup logging and alert to help with monitoring Front-end work - $25k
Build an API that will serve all of the aforementioned indexed data and will allow filtering/sorting (likely going to be a GQL API with similar structure as subgraphs).
Build a NextJS app that will serve all of the views mentioned in specs. Design - $15k
Visual design and implementation work for page layouts, charts, tables, filtering, sorting, etc. Maintenance: $10k for year 1
Regular infra monitoring and any bug fixing that may occur
Minor specification changes

Total: $85k

Payment structure

We propose to receive $25K upfront and the rest of the grant upon delivery of the dashboard. This way the 1Inch grant program takes minimal financial risk and our compensation is based on the delivery of the dashboard. We are also willing to break down the grant in multiple smaller milestones if necessary. Receiving address: 0x70cd17186aae48729f12dba63ba5a9abe7b4116d

Timeline

We expect to be able to deliver the dashboard within 8-12 weeks from the grant approval date.

Team

Our team has extensive experience in crypto, finance, and software engineering. As builders, we've completed several projects for notable projects including: