How User Score Is Calculated (SwellChain)

Each user is evaluated on three key metrics based on their on-chain behavior:

1. Transaction Frequency (tx_count) – how often they use the chain

2. Total Value Transacted (total_value) – how much value they move

3. Total Fees Spent (total_fee) – how much cost they incur

Each metric is then ranked across all users using percent_rank() to normalize it on a 0–100 scale. Then, we calculate a weighted composite score:

user_score = 60% tx_count + 35% value + 5% fee

This final score reflects both activity and economic contribution, prioritizing frequent usage.

Users Are Segmented into Tiers:

• Tier 1: Top 10% – Power users

• Tier 2: Next 30% – Active contributors

• Tier 3: Next 40% – Occasional users

• Tier 4: Bottom 20% – Low engagement

Dashboard Introduction: Understanding User Quality and Engagement on Swell Chain

This dashboard provides a comprehensive segmentation of users on Swell Chain, evaluating them across multiple dimensions such as transaction frequency, value transacted, gas fees spent, and contract interaction depth.

Users are scored and grouped into four behavioral tiers — from low-engagement participants to high-value, high-frequency power users. These tiers allow for a clearer understanding of how different segments contribute to the chain’s economic activity, engagement footprint, and ecosystem usage.

By combining on-chain data and behavioral scoring, this dashboard enables Swell stakeholders to:

• Identify and track high-value users

• Analyze transaction trends across tiers and over time

• Evaluate contract-level loyalty and interaction density

• Observe fee dynamics and their implications on network scalability

Use this dashboard to uncover patterns that inform growth strategies, retention efforts, and ecosystem optimization.

Dashboard Data Tables:

1. Transactions table -swell.core.fact_transactions

2. Contracts table -swell.core.dim_contracts