🔎 What's in this dashboard?

• First interaction of new Near users in the last three months daily.
• Most popular first interaction of new Near users in the last three months.
• New users onbarding on Near cumulative.
• Most popular first interacted protocols of new Near users in the last three months daily.
• Most popular first interacted protocols of new Near users.

Methodology

• We found the first interaction of new users(wallets who made their first transaction in the last 3 months) we used the

  near.core.fact_transactions table and took the tx_signer as the new wallet address ,we found their first transaction by taking min(block_timestamp) with their tx_hash

  if we use that tx_hash in

  near.core.fact_actions_events_function_call this gives us the method name which is an event.

• To find the TOP 10 events each day we are using row_number() function

• To find the most popular first interaction protocols of new users , we took the same steps as above and used

  near.core.fact_transactions table with count of tx_receiver column which will give us the most used protocols.

• Swap and Submit events are leading the way as the first interactions of new Near users.
• Submit event leads the way but there are days that swap transactions surpassed the submit like Aug 20, Aug 21
• Claim assignment event is the third popular event among the first interaction of new Near users.

Because of the low number of colors, colors of the event names looks same.

• We can see that submit event is the most popular interaction among the new Near users onbarding.
• We have swap event in the second place.
• Claim assigment in the third place.

• Near Finance protocol and Aurora are the most popular first interaction protocols that new users interacted with.
• We have the Ref Finance in the days like Aug 20 and Aug 21 that Ref Finance transactions made a peak, which shows us the reason of increases in the swap event name in Aug 20 and Aug 21

• Aurora is the most popular choice among the new users onbording

• We have the nearcrowd in the second place.

• Ref Finance is in the third place, reason of this is the transaction increase in the days like Aug 20 and Aug 21.