# Active users (weekly) Methodology

## 1. Overview

Active users (weekly) measures the number of unique addresses that make a revenue-generating transaction on Celo L2. An address is considered active if it initiates at least one transaction that incurs a network fee within a 7-day rolling window. This metric serves as a primary indicator of network adoption and user engagement following the transition of the protocol to a Layer 2 architecture.

## 2. Data sources

- **Blockchain events**: Transaction data from the Celo L1 (legacy) blockchain, covering Celo L1 (legacy)
- **External data**: Metadata for market sector and business segment classification

## 3. Step-by-step calculation

### Component A: Transaction sender extraction

- **Purpose**: Identify individual participants interacting with the network
- **Logic**: Transaction records are parsed to extract the `from_address`, which represents the transaction sender. Each transaction hash is associated with a specific sender address and a block timestamp to establish the timing of activity.
- **Key fields**: `from_address` (user identification), `block_timestamp` (timing), `transaction_hash` (uniqueness)

### Component B: Product classification and filtering

- **Purpose**: Separate Celo L2 activity from legacy network data
- **Logic**: Transaction data is filtered based on the block timestamp. Transactions occurring on or after March 26, 2025, are assigned to Celo L2. This temporal boundary ensures that the metric accurately reflects the protocol's operation as a Layer 2 network, while transactions prior to this date are attributed to the legacy Celo L1 (legacy) product.

### Component C: Weekly aggregation

- **Purpose**: Calculate the count of unique users per 7-day window
- **Logic**: Sender addresses are truncated to a weekly granularity based on the UTC timestamp. Unique addresses are deduplicated so that each address is counted only once per 7-day window, regardless of the total number of transactions submitted by that address within the 7-day rolling window. The resulting values are aggregated by product and market sector dimensions.

*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 (L2)

Validators process transactions and receive fees from users (supply-side fees).

Celo is a smart contract platform for decentralized applications (a blockchain). Celo was founded by Rene Reinsberg and Marek Olszewski and launched in 2020.

CELO holders own and govern the protocol. They currently take a cut of the total transaction fees paid by users (revenue). Celo's investors include a16z, Greenfield, Electric Capital, etc.

Celo L2

Active users (weekly)

Active users (weekly)

Chain breakdown