website

twitter

discord

github

Blockchains (L1)

Berachain

# Berachain Active users (daily) Methodology

## 1. Overview

Daily active users (DAU) measures the number of unique addresses that initiated at least one transaction on the Berachain network within a given day. This metric provides insight into daily user engagement and network activity by counting distinct transaction senders. The calculation aggregates raw transaction data to daily boundaries and deduplicates user addresses to ensure each unique address is counted only once per day, regardless of how many transactions they sent.

## 2. Data sources

The calculation relies on the following raw data sources:
- **Berachain transaction records**: Complete transaction logs from the Berachain blockchain network containing transaction metadata, timestamps, sender addresses, and transaction hashes
- **Blockchain transaction data**: Raw transaction-level data including block timestamps for temporal aggregation and sender addresses for user identification

## 3. Step-by-step calculation

### Component A: User transaction identification
- **Purpose**: Extract and classify user addresses from Berachain transaction data
- **Logic**: The system processes raw Berachain transaction records to identify transaction senders. Each transaction's `from_address` field represents a user who initiated a transaction. All transaction senders are classified uniformly as 'Transaction sender' user type. The system applies consistent labeling including chain identification as 'berachain', market sector as 'blockchains_l1', and business segment as 'blockchain'. Transaction timestamps (`block_timestamp`) and transaction identifiers (`transaction_hash`) are preserved for downstream processing.
- **Key fields**: `block_timestamp` for temporal analysis, `from_address` as the unique user identifier, `transaction_hash` for transaction tracking, and standardized classification fields for chain and segment attribution

### Component B: Daily aggregation and deduplication
- **Purpose**: Aggregate user activity to daily boundaries and count unique active users
- **Logic**: The system truncates transaction-level timestamps to daily boundaries using day-level granularity, grouping all activity within each 24-hour period. For each day, the system identifies all unique user addresses that sent at least one transaction by applying distinct counting on the `user_address` field (derived from `from_address`). This deduplication ensures that users who sent multiple transactions on the same day are counted only once in the daily active user count.
- **Key fields**: `timestamp` (truncated to daily boundaries), `user_address` for unique user identification, and `user_dau` representing the deduplicated user identifier

### Final aggregation
- **Combining components**: The daily aggregation component directly processes the classified user transaction data, applying temporal truncation and deduplication in a single operation
- **Currency conversion**: Not applicable for this user count metric
- **Time aggregation**: Transaction timestamps are truncated to daily boundaries using day-level granularity, with all activity within each calendar day grouped together
- **Final calculation**: The metric value represents the count of distinct user addresses (`user_dau`) that initiated at least one transaction within each daily time period, with incremental processing ensuring data freshness through configurable lookback windows

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

Unique revenue-generating users over a fixed 24-hour window.

BerachainBERA

Active users (daily)

Active users (daily)

Competitive landscape