New NEAR Users
What actions does a user take when they deposit money into the NEAR ecosystem?
Summary of NEAR protocol
NEAR Protocol is a decentralized application (dApp) platform and Ethereum competitor that focuses on developer and user-friendliness. Its native NEAR tokens are used to pay for transaction fees and storage on the Near crypto platform.
Most common actions taken by users-Over past 3 months
In general, there are several actions in the Flipside table showing the type of NEAR network events.
The results show that "Addkey" was the most requested action after depositing $NEAR to the wallet, followed by "DeletAccount", "Transfer", and "FunctionCall", respectively.
These results are related to the period of the last three months, and in the next barchart, the results related to the entire period are shown.
Conclusion
In summary, in this article, we focused on two charts showing:
1-Most common actions taken by users-Over the past 3 months
2-Most common actions taken by the users-Over time
The results showed that when we looked at the recent three months, "Addkey" was the most requested action after depositing $NEAR to NEAR wallets, followed by "DeletAccount", "Transfer", and "FunctionCall", respectively.
On the other hand, the second chart (The longest possible period of time) revealed that "Addkey" was still the most requested action after depositing $NEAR to the wallet, but followed by "FunctionCall", "Transfer", and "DeletAccount", respectively.
Most common actions taken by users-Over time
In this section, an additional chart is also plotted, which shows the top actions that users have performed immediately after charging their wallets in the entire time period available in the Flipside tables. Here, we can see that "Addkey" is still the most requested action after depositing $NEAR to the wallet, followed by "FunctionCall", "Transfer", and "DeletAccount", respectively.

How to hit the target
To find out what NEAR users do immediately after charging their wallet, it is necessary to obtain the second successful transaction after the NEAR token deposit transaction to the wallet. Briefly:
1- Calculating the date of the first deposit to the wallet using the "near.core.fact_transfers" table.
2- Finding the first transaction after depositing the $NEAR tokens from the "near.core.fact_transactions" table.
Finally, to find the action of the transaction, it is enough to use the substr() command:

NEAR transactions types (actions)
Near has several action types including:
-
CreateAccount/DeleteAccount, AddKey/DeleteKey - accounts and key management transactions.
-
Transfer - send NEAR tokens from one account to another. The basic command of any blockchain.
-
Stake - needed to become a validator in a Proof-of-Stake blockchain network. We won’t touch this topic in this guideline, more information can be found here.
-
DeployContract - deploy a smart contract to a given account. An important thing to remember - one account can hold only one contract, so the contract is uniquely identified by the account name. If we issue this transaction to an account which already has a deployed contract, a contract update will be triggered.
-
FunctionCall - the most important action on the blockchain, it allows us to call a function of a smart contract.
For more information click here.