Introduction

In this dashboard we will analyze the activity of new users coming to Terra since their first transaction. New users as set to those whose first transaction was 3 month ago or less. Then, those who joined Terra during the last 3 months.

In this case, it has been computed the number of transactions as well as the number of different type of transactions undertaken.

Methodology

The methodology is based on firstly find the new users that made their first transaction during the past 3 months. Then, I have taken the users whose min(blok_timestamp) on terra.transactions table is posterior tu the current_date-90. From these new users, I have computed the number of transactions made in a daily basis, as well as the number of transactions per user. Further analysis have been done to go deeper in it. Finally, some analysis having done in the transactions made by new users splitting by type of transaction in the terra msg_events table.

Results

The results are divided in two parts, one for the transactions and the other one for the type of events to clear expose the two approaches of this analysis. Both have several charts described below.

As we can see, more than 1k users came to Terra daily from the beginning till the end of these past 3 months. The number of daily users have increased over time. From the beginning numbers around 3k daily users to around 5k daily users during last days. However, a damp occurred during finals January and the starting of Feburary months.

During this period of time a total of 323k new users joined Terra network, whose have been done almost 5M of transactions. Representing around 15 transactions done per user since their debut.

If we take into account the daily active users since the beginning of the period observed, we can see the big growht in transactions. It is logic because of each day new users come and then, more probability to do more transactions. But, the evidence are there. The nnumber of daily transactions jump from 3k to 20k.

Finally, taking into account the whole users and all transactions done, we have seen as well a big growth from 9k transactions on the firt day to 144k transactions registered on the last entire date evaluate. An interesting metric detected is that the average number of transactions per user have been stable during the first period of time, but during the last days, this number increasaed a lot from around 5 to 7.

Finally, analizing the results for the type of transactions done, we have seen a big correlation between distribution of type of transactions by users and by number of transactions. In both cases, the major part of the cases a transfer have been done, followed by delegations. Another important type of event are the burns, swaps and redelegations in a few terms.

Conclusion and takeaways

The dashboard shows a deep analysis about the activity of new users that come to Terra ecosystem during the past 3 months. We have seen how the number of users have been grown as well as the number of transactions done by users. FInally, an analysis about the type of transactions done by these users have been done as well, determining that transfers are the most common one.