Unique Users
Q7. How many unique wallets are active on Osmosis per day? How has this changed over time? What has been the largest event that has brought the most wallet activity to Osmosis?
Deciding which table to use to answer this question is very clear. By looking at the chart below, we can see that transfers are only a small part of the transections, and in fact it is the transection table that contains all the information, not the transfer table. We also got help from the same table.
Once we have selected the table, we try to count the number of new users who are attracted to the project each day. For this purpose, it is enough to consider only the date of the first activity of each user. The result is as follows:
We've highlighted all the days when more than 4,000 new users were added to the collection to emphasize those days. Usually, dramatic changes in the level of user activity in such a project, whether positive or negative, are the result of changing the rules and policies of that project or the start of some airdrops. Airdrops attract users because of the satisfying financial benefits they bring to users. On the other hand, sometimes changing the rules, such as the rules governing the calculation of participation and investment profits, can lead to a loss of cooperation and participation of users. However, despite my searches on the Internet, I could not provide more detailed details on this subject. But I guess it's very likely. Of course, the information in this link may contain good tips.
In this diagram, you can see the number of active users per day. It is enough for a user to have at least one transaction per day to be considered active. But how active he is has no bearing on how he counts. That is, if user A has only one transaction on a given day, and user B has completed 1000 transactions on the same day, both users will leave the same share on that day.
It can be seen that there is a good correlation between the two recent graphs. This means that in reservations where the number of active users was high, the rate of attracting new users was also acceptable.