# Rarible Active users (weekly) Methodology

## 1. Overview

Weekly Active Users (WAU) measures the number of unique users who interacted with the Rarible NFT marketplace within any 7-day rolling window. This metric provides insight into user engagement and platform adoption by tracking distinct user addresses that performed trading activities across Rarible's direct marketplace and through aggregated channels. The calculation uses HyperLogLog data structures to efficiently count unique users while maintaining accuracy across large datasets and multiple blockchain networks.

## 2. Data sources

- **Ethereum blockchain events**: Parsed `Buy` events from Rarible V1 and V2 exchange contracts including `ERC721Sale`, `ERC1155Sale`, `TokenSale`, and `ExchangeV1` events
- **Polygon blockchain events**: Parsed trading events from Rarible V1 exchange contracts
- **Ethereum function calls**: Direct calls to Rarible V2 exchange functions including `matchOrders`, `directPurchase`, and `directAcceptBid` operations
- **Polygon function calls**: Direct calls to Rarible V1 ExchangeMeta functions for order matching and direct purchases
- **Aggregated marketplace events**: Trading events from major NFT marketplaces including OpenSea Seaport, LooksRare, X2Y2, and SudoSwap that involve Rarible users
- **Transaction metadata**: Blockchain transaction records containing timestamps, transaction hashes, and execution status

## 3. Step-by-step calculation

### Component A: User identification and classification
- **Purpose**: Extract and classify all unique user addresses that interact with Rarible marketplace
- **Logic**: The system identifies users from multiple sources across Ethereum and Polygon blockchains. From parsed blockchain events, it extracts user addresses from event parameters such as `buyer`, `seller`, and `owner` fields in various Rarible exchange contract events. From function calls, it captures addresses from parameters like `maker`, `taker`, and `from_address` in exchange operations, filtering only successful transactions. For aggregated activity, it identifies Rarible users who trade through other marketplaces by extracting addresses from events like `offerer`, `recipient`, and `taker` fields. Each user is classified as either "Trader" for direct Rarible interactions or "Aggregator Trader" for activity through third-party platforms.
- **Key fields**: User addresses are extracted from various fields including `buyer`, `seller`, `owner`, `maker`, `taker`, `offerer`, `recipient`, and `nftRecipient` depending on the event type. Each interaction includes `block_timestamp`, `transaction_hash`, `chain`, `user_type`, and `product_id`

### Component B: Daily active user aggregation  
- **Purpose**: Aggregate user interactions into daily unique active user counts using HyperLogLog structures
- **Logic**: User interactions are grouped by day using timestamp truncation to day granularity. The system creates distinct combinations of timestamp, chain, user type, and product, then initializes HyperLogLog structures for efficient unique user counting. Each daily record contains an HLL representation of all unique user addresses that were active on that specific day within each dimensional breakdown.
- **Key fields**: Daily records include `timestamp` (truncated to day), `timestamp_grain` (set to 'day'), `chain`, `user_type`, `product_id`, and `hll` (HyperLogLog structure containing unique user addresses)

### Component C: Rolling window generation
- **Purpose**: Create 7-day rolling windows to calculate weekly active users
- **Logic**: A datespine generates every calendar day from the minimum date in the daily user data to yesterday. For each date in the datespine, the system creates a 7-day window by joining that date with the previous 6 days using timestamp array generation. This ensures complete 7-day windows even when some days have no user activity. Each window position is then joined with the daily HLL data to retrieve user activity for all days within that 7-day period.
- **Key fields**: The window structure includes `timestamp` (the end date of the 7-day window), `joinday` (each individual day within the window), and the associated HLL data for each day

### Component D: Weekly unique user calculation
- **Purpose**: Calculate unique users across each 7-day window using HLL operations
- **Logic**: For each 7-day window, the system merges all HyperLogLog structures from the constituent days using HLL merge operations. This efficiently combines unique user sets across the full 7-day period while avoiding double-counting users who were active on multiple days. The merged HLL is then extracted to produce the final unique user count for that week.
- **Key fields**: Weekly calculations produce `timestamp`, `chain_id`, `user_type`, `product_id`, and the final `user_wau` count

### Component E: Dimensional breakdown
- **Purpose**: Calculate WAU across different analytical dimensions
- **Logic**: The system creates four different dimensional views of the WAU data. Project-level WAU aggregates all users regardless of chain, user type, or product. Chain-level WAU groups by individual blockchain (Ethereum, Polygon). User type breakdown separates direct traders from aggregator traders. Product-level breakdown distinguishes between different Rarible product offerings. Each breakdown uses HLL merge operations to combine the appropriate user sets while setting non-relevant dimensions to null.
- **Key fields**: Each breakdown includes `timestamp`, `dimensions` (indicating the breakdown type), and the relevant dimensional field (`chain_id`, `user_type`, or `product_id`) with others set to null

### Final aggregation
- **Combining components**: All dimensional breakdowns are combined using union operations to create a comprehensive dataset containing WAU values across all analytical dimensions
- **Time aggregation**: The calculation uses daily boundaries with 7-day rolling windows, where each day represents the end date of a unique 7-day period
- **Final calculation**: The final WAU value for any given day represents the count of unique user addresses that were active within the 7-day period ending on that date, calculated using HyperLogLog merge and extract operations for efficient and accurate unique counting across large datasets

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

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

Active users (weekly)

Rarible

Creators mint & users sell NFTs on Rarible. Creators and users receive payments from sales & creators receive royalties from secondary sales.

Rarible is a non-custodial NFT marketplace protocol built on Ethereum. Rarible was founded by Alexander Salnikov and launched in 2020.

RARI tokenholders own and govern the protocol. They currently take all of the total transaction fees paid by traders (revenue). Rarible's investors include Coinbase Ventures, CoinFund, ParaFi Capital, etc.

RaribleRARI

Active users (weekly)

Active users (weekly)

Competitive landscape

Chain breakdown