Methodology

Dashboard Objective

Show Near CEXes Activity.

Dashboard Structure

Introduction
Overview
- CEX Activity in Near
Activity by CEX
- Transfer Activity
- User Activity
- Volume Activity
User Behaviour
- How Many Near Users received their first transfer from CEXs?
- How Was their Retention in Near?
- What are their favorite Dapps?
Conclusion
Methodology

Dashboard Method

Using Flipside Tables of Near I'll track the CEX activity.

Table Used to track all CEX Wallets:

near.core.dim_address_labels (WHERE label_type = 'cex')

Table Used to track CEX Transfers:

near.core.fact_transfers

Table Used to track Dapp Activity received:

near.core.fact_transactions

Dashboard Sources

Near Logo

Centralized Exchange Image

Binance Logo

Okex Logo

MetricsDAO Bounty Question

Using the labels table create a dashboard that illustrates the inflows and outflows of assets from NEAR to CEX and vice-versa.

Look at items such as number of users and volume by CEX.

Another thing to look at is which CEXes bring in the most active users to the ecosystem?

Lastly what dApps in the ecosystem are users who onboarded funds from CEXes are using?

Centralized Exchange Activity in Near