What is an Active, High Quality Wallet?

To Answer this question i'll look at the users in 3 differents areas and because of that this dashboard will use Tabs.

• Introduction: Here are some General Metrics about users, the High Quality Wallets, the Methodology and the Conclusion of this Dashboard.
• Top Users by Total Txs: My first area to find High Quality Wallets, using data since the origin and weekly aggregation to see their activity over time.
• Top Users by Last Month Txs: The second area to find these wallets, using data from the last 31 days and daily aggregation to see their activity over time.
• Top Users by Voting Activity: My last area to find these Active Wallets, using data from voting activity.

After Reading the Infomation from these Tabs you can see the actual amount of High Quality Wallets found at the end of this Tab.

Understanding the Wallets in Terra by their Total Transactions

Is easy to claim that Wallets with more than 1000 Transactions are Active and High Quality Wallets, and therefore my focus will be in the wallets with 11 to 1000 Transactions, or in other words how many of these 16.6k+1.86k (18,460) Users are a High Quality Wallets or not, so i'll invite you to review each tab to understanding my way to find these Wallets

How Many High Quality Users are in Terra

Explanation of how i get this results

In every Tab i explained how i ranked the users in differents tiers, and after doing that i can get all the users using the following algorithm:

• First: I get The Most Important Users that are the Proposal Voters and Only Tier ⭐⭐ and ⭐⭐⭐ made it, so only 97 Wallets are High Quality Users by Votes.
• Second: After the voters were filtered is the turn for wallets with Tier ⭐⭐ and ⭐⭐⭐ in Total TXs, with 855 Wallets being High Quality Users by Total TXs
• Third: I get the Users Most active in the last month this time considering only Tier ⭐⭐ and ⭐⭐⭐, with 346 Wallets being High Quality Users in the Last Month by TXs
• But this method is unfair for the Tier ⭐ wallets so i decided to include the wallets (7) that didn't make it before and have Tier ⭐ in Each Section as High Quality User by Tier ⭐ in All

And then we have it from 217,527 Users in Terra there are only 1305 Wallets that are High Quality Users, thanks to being highly active in Governance, or making a lot of transactions since the origin of Terra or by making a lot of transactions in the last 31 days, or being present in all these 3 areas.

How to Attract Additional Users?

I can see that in the first weeks of Terra, the amount of users which made only a small amount of transactions reached the best spikes in this period, so the Hype will always work to reach short term users.

To improve Terra reach we need more DAOs and users participating in Governance, we can see that only a few number of High Quality Users are from Voting in Unique Proposals, and these are the users with most potential to being in the Long run, DAOs always improve the blockchain ecosystem by adding new Liquidity Staking Projects or Exclusive assets, for example we have boneLUNA ($bLUNA) from the Skeleton Punks NFT Collection in Terra 2.0, or the Terra Poker Token ($TPT) from Terra Poker.

There isn't a need for more DeFi Apps, because these Projects will always appear by themselves followed by the Heavy Traders Users making most of the Activity in the Ecosystem.

Terra has a lot of potential thanks to being part of the IBC and more DApps from Terra or Other IBC Blockchains Will connect the Blockchains and adding new users to the network.

Finally trying to expand beyond the Web3 will always bring more users such as other Blockchains that made partnership with Popular Brands to Bring NFTs projects or Making Apps that connects both Web2 and Web3 Users (Via Smartphone) will always be another interesting strategy.

What is the Acquisition cost for a high-value user?

As explained before the main goal to improve reach for users that stay in the long term is in the Governance, the users that participate in the Proposals voting are always likely to stay because they're invested in the ecosystem.

So by improving the Governance and Proposals Systems new DAOs and Projects that will benefit the Ecosystem will be voted by these users, new users will appear and some of them will stay as High Quality users by Votes (Unique Proposals Voted) At the cost of a Grant asked by themselves.

Heavy DEX Traders will always appear after DeFi Projects received Grants to improve their projects in the Ecosystem.

Methodology

Image Source: Terra1, Terra#2, Terra#3, 2023,

Using FlipsideCrypto New App and Tables of Terra:

• terra.core.fact_governance_votes: To get information about voters by the amount of Unique Proposal_ID Voted.
• terra.core.fact_transactions: To get All the information about transaction activity (tx_id) from users (tx_sender) after joining for example with the voters table using Voter=TX_Sender.

With These 2 Tables i did most of my analysis, because there is a lot of unlabeled Projects in Terra so is better to be more general in this case and track the Transaction Activity only.

But Honestly i think that Voters in Terra are the most Valuable Users in the Ecosystem, and not by the amount of Votes, which can mislead, Voters by Proposals Participated are the better High Quality Users, because Heavy Traders will always present a high number of TXs, meanwhile voters will participate in both Staking and Governance in a daily basis and will stay in the longer run.

Made by Popex404, Twitter Link Here