Terra — [Galactic Punks] — New User Onboarding Analysis
How many users joined Terra just to get involved with GP? Who is the new users and how to understand the new users onboarding situation? In this article, I am going take the data and chart to analyze the new users. All the data come from Flipside Crypto.
Quick introduction to Galactic Punks at Terra ecosystem: Galactic Punks are 10,921 randomly generated NFTs on the Terra blockchain. It is a NFTs platform, equipped with the backend story about galactic, people, characters etc. in Terra. More details can be found here: https://galacticpunks.io/. The contract address for Galactic Punks is terra103z9cnqm8psy0nyxqtugg6m7xnwvlkqdzm4s4k. We can do a very quick dive into that to see what is happening behind the scene.
New users analysis
The definition of new or old users is whether this address has other transactions beside the Galactic Punks transactions
How many new users for GP?
There are 62 new users and 1,587 old users for Galactic Punks. Query is to get the msgs data to the address and then compare whether that transaction is latest one or not, it will help identify the new/old users.
How many new users for GP turns out to be ecosystem users?
Here, the logic is the opposite compared to the last logic, not to compare the data before the transaction date, but after to see how many users after GP is still using it.
From the below chart we can find that ~92% of new users stay at the ecosystem after the Galactic Punks.
Thanks to Flipside Crypto for providing the data.