Description of Work

In this bounty, we want to compare User Retention in Flow with other L1s blockchains. Here we have chosen Avalanche and Ethereum for comparison. for this, we will check the following items:

• Total Number of Transactions from 2022-06-18 to 2022-07-18 for Flow, Ethereum and Avalanche compared to the 2022-05-18== to ==2022-06-18==.
• The total Number of Unique Wallets that have transacted on Flow, Ethereum and Avalanche 2022-06-18 to 2022-07-18 compared to the **2022-05-18== to ==2022-06-18 **.
• User retention review for Flow, Ethereum and Avalanche in the last months (from 2022-06-18 to 2022-07-18).

For Avalanche, data is available from ==2022-05-30

Note

• We use the
  • flow.core schema and fact_transactions table for Flow
  • ethereum.core schema and fact_transactions table for Ethereum
  • avalanche.core schema and fact_transactions table for Avalanche

• User Retention: Is a user who made a transaction previously likely to make another transaction a week or a month later?
  • To obtain User Retention in each of the three blockchains, we find the first transaction for each user in the last 2months → min(block_timestamp::date)
  • Then we find the total transactions for each user along with their min(block_timestamp::date) and check how long each transaction was made after the first transaction. for example:
    • If a user's first transaction is on 2022-06-18== (min(block_timestamp::date)) and his/her next transaction is on 2022-04-25== (block_timestamp::date) then he/she has had a transaction after 1 week again because we have:
      • (2022-06-25 - 2022-06-18) = 7 → So this user has transaction after 1 week again
  • We assume several different time intervals and count the number of users who have made a transaction in these time intervals after the first transaction:
    • block_timestamp::date - min(block_timestamp::date) >= 1 → user has transaction after 1 day again
    • block_timestamp::date - min(block_timestamp::date) >= 7 → user has transaction after 1 week again
    • block_timestamp::date - min(block_timestamp::date) >= 14 → user has transaction after 2 week again
    • block_timestamp::date - min(block_timestamp::date) >= 21 → user has transaction after 3 week again
    • block_timestamp::date - min(block_timestamp::date) >= 28 → user has transaction after 4 week again
    • block_timestamp::date - min(block_timestamp::date) > 28 → user has transaction after 1 month or more again

1.1 → Number of Transactions from ==2022-05-18== to ==2022-06-18

1.2 → Number of Transactions from ==2022-06-18== to ==2022-07-18

2.1 → Number of unique user from ==2022-05-18== to ==2022-06-18

2.2 → Number of unique user from ==2022-06-18== to ==2022-07-18

Conclusion of part 1 and 2

• The Number of Transactions and the Number of unique Users (Wallet) for all three blockchains Flow, Ethereum and Avalanche increased between 2022-06-18 and 2022-07-18 compared to one month before this period.
• The Number of unique Users for Flow increased by 7.61% between 2022-06-18 and 2022-07-18 compared to one month before this period.
• The Number of unique Users for Ethereum increased by 8.55% between 2022-06-18 and 2022-07-18 compared to one month before this period.
• The Number of unique Users for Avalanche increased by 13.02% between 2022-06-18 and 2022-07-18 compared to one month before this period. (In Avalanche, we don't have the data from 2022-05-18 to 2022-05-30, that's why the increase in the number of users is more.)

Now we want to check what percentage of the users who made transactions on 2022-06-18 and 2022-07-18 are old users (they are for the month before this time period)

Observations

• Out of 1,942,727 unique users who have made at least one transaction on Flow in the last month, only 91,308 of them are from the previous month, which is about 4.7% (old users compared to the previous month) and the rest are new users..
• Out of 5,454,669 unique users who have made at least one transaction on Ethereum in the last month, 1,442,885 of them are from the previous month, which is about 26.45% (old users compared to the previous month) and the rest are new users..
• Out of 310,631 unique users who have made at least one transaction on Avalanche in the last month, 136,727 of them are from the previous month, that is, about 44.02% (old users compared to the previous month) and the rest are new users.

3.1 → The percentage of users who had transactions in the last month and the previous month

2 → User retention review on Flow, Ethereum and Avalanche in the last 2 months

Observations

According to the results obtained from the User retention review on Flow, Ethereum and Avalanche in the last 2 months:

• Flow:
  • In the last two months in Flow, 23.1% of users have transacted 1 day again
  • In the last two months in Flow, 20.4% of users have transacted 1 week again
  • In the last two months in Flow, 17.4% of users have transacted 2 week again
• Ethereum:
  • In the last two months in Flow, 28.3% of users have transacted 1 day again
  • In the last two months in Flow, 22.6% of users have transacted 1 week again
  • In the last two months in Flow, 17.6% of users have transacted 2 week again
• Avalanche:
  • In the last two months in Flow, 29% of users have transacted 1 day again
  • In the last two months in Flow, 24.2% of users have transacted 1 week again
  • In the last two months in Flow, 17.8% of users have transacted 2 week again

Final Conclusion

> According to the results obtained in the last month on the three blockchains Avalanche, Ethereum and Flow, the number of users and transactions has increased compared to the previous month, also the number of old users in the last month in Ethereum and Avalanche is more than Flow blockchains, also according to the calculation User retention for all three blockchains and the number of old users in the last month compared to the previous month in Ethereum and Avalanche, we conclude that these two blockchains have more and better user retention than Flow.