# Active users (weekly) Methodology

## 1. Overview

Active users (weekly) measures the number of unique addresses that execute revenue-generating transactions on Hyperbridge Substrate. This metric is used to evaluate the growth and retention of the network's user base by tracking distinct transaction signers over a 7-day rolling window. Only successful interactions with the underlying blockchain infrastructure are considered for the calculation.

## 2. Data sources

- **Blockchain events**: `extrinsics` from Hyperbridge Substrate

## 3. Step-by-step calculation

### Component A: Hyperbridge Substrate activity tracking

- **Purpose**: Identify unique users interacting directly with the Hyperbridge Substrate blockchain.
- **Logic**: Transaction data is parsed from the `extrinsics` table for Hyperbridge Substrate. The `id` field, which represents the account address that signed and submitted the transaction, is extracted. Only entries that occur after the network's official deployment date are included in the dataset to ensure historical accuracy.
- **Key fields**: `block_timestamp` (timing), `id` (sender address).

### Component B: Weekly aggregation and de-duplication

- **Purpose**: Calculate the final weekly count of unique active users.
- **Logic**: Extracted addresses are grouped by 7-day rolling windows using UTC day boundaries. A distinct count is performed on the user addresses to ensure that each individual address is counted only once per 7-day window, regardless of the frequency of transactions performed. The resulting values are filtered to match the data availability and freshness of the underlying chain.

*This methodology was automatically generated by Token Terminal's methodology analyzer.*

Unique revenue-generating users over a rolling 7-day window.

Active users (weekly)

Blockchains (L1)

Build once, connect everywhere. Hyperbridge gives developers the secure infrastructure to scale applications across any network.

Hyperbridge Substrate

Archived

Active users (weekly)

Active users (weekly)

Chain breakdown