Loading...
    Loading...
    Loading...
    Loading...
    Loading...

    Introduction

    main subject for this dashboard is to find What actions does a user take when they deposit money into the NEAR ecosystem.

    most of crypto users have a goal to do actions on a blockchain.

    we want to find what is Near new users goal on Near ecosystem.

    actually it is a very important part to know what actions attracts users into an ecosystem.

    Methodology

    as bounty asked all data are filtered to start from past 3 months.

    to find first users actions we need to find their first transaction and then look for other action of the users right after their first transactions.

    we have used fact_transactions table to find new users.

    and then use fact_actions_events_function_call table to find user’s actions.

    Analyze

    so we will first new users from past 3 month which we simply convert it to 90 days.

    we will first show some data of these new users and then look for their actions on Near ecosystem.

    most important part is event calls table that most actions are registered on it.


    since 90 days ago about 202K new users have joined Near ecosystem.

    as an average per day about 2220 new users are created/joined Near.

    in compare to other L1 blockchains like Solana, Near has less users and it is a good sign that since 90 days ago about 200K new users have joined Near.


    here is number of unique users per day on Near.

    almost there is a stable number of unique users that are created per day.

    on Jul 11th about 10.9K new users have created on Near.


    This chart shows top 10 actions that new users did on Near after their first transaction.

    this chart is made from actions and unique users that did that action.

    first action is create account which is used by about 6K unique users.

    all top 10 on the chart are from different types.

    top 10 is NFT approve which probably belongs to a marketplace.

    this shows that NFTs on Near are not so popular.


    we have used ez_dex_swaps table for this result.

    so we have find users among these new users which have used DEXs for swap right after their first transaction.

    as we see about 15 users have just used DEX after their first transaction.

    I guess this number can not be so correct so we just have used application calls on Near and came to next chart which is more reasonable.

    Result

    top one action that new Near users did after their first transaction is create account.

    NFT actions are top 10 from the top 10 action which means NFTs are not a popular trend for new users on Near.