Method

I for this analysis, I obtained the transactions of the last 1 month, and then I obtained the list of addresses that made another transaction a week or a month later from Solana, Ethereum, and Flow tables and compared them.

• Flow => I used flow.core.fact_transactions table.

• Solana => I used solana.core.fact_transactions table.

• Ethereum => I used the ethereum.core.fact_transactions table.

  I divided the users into two types:

  1. User who made a transaction previously.
  2. Users who have made another transaction
     • After a week.
     • After a month

After a week

The charts below compare users who made a transaction a month ago to users who made another transaction a week later. (Flow, Solana, Ethereum).

The charts below are marked with 0 and 1:

• 0 : User who made a transaction previously
• 1 : Users who have made another transaction a week later

Flow

• User who made a transaction previously: 3.23M, 99.9%
• Users who have made another transaction a week later: 2.2k, 0.1%

Solana

• User who made a transaction previously: 36.87M, 99.8%
• Users who have made another transaction a week later: 55.5k, 0.2%

Ethereum

• User who made a transaction previously: 7.25M , 99.9%
• Users who have made another transaction a week later: 33.7k, 0.5%

After a month

The charts below compare users who made a transaction a month ago to users who made another transaction a month later. (Flow, Solana, Ethereum).

The charts below are marked with 0 and 1:

• 0 : User who made a transaction previously
• 1 : Users who have made another transaction a month later

Solana

• User who made a transaction previously: 36.87M, 99.9%
• Users who have made another transaction a month later: 20.5k, 0.1%

Ethereum

• User who made a transaction previously: 7.25M, 99.8%
• Users who have made another transaction a month later: 16.1k, 0.2%

Flow

• User who made a transaction previously: 3.23M, 100%
• Users who have made another transaction a month later: 615, 0%

Conclusion

According to observations Ethereum has a higher user retention rate than Solana and Flow. Users who made a transaction a month ago and make another transaction after a week is about 0.5% in Ethereum.

The number of transactions in Solana is high, but only 0.2% of users have been retained in the next week's transaction.

Flow has the weakest performance in retaining users and it can be said that users have not made another transaction after 1 month of the previous transaction.