website

twitter

Infrastructure

SolTradingBot

# SolTradingBot Average fees per user (AFPU) Methodology

## 1. Overview

Average fees per user (AFPU) measures the average revenue generated per daily active user on the SolTradingBot platform. This metric is calculated by dividing the total daily fees collected by the protocol by the number of unique users who paid fees on that day. AFPU provides insight into revenue efficiency and user monetization on the trading bot platform.

## 2. Data sources

The calculation uses the following raw data sources:
- **Solana native transfers**: Native SOL transfer events on the Solana blockchain that capture fee payments to SolTradingBot
- **Transaction records**: Solana transaction data containing transaction signers who represent the users paying fees
- **End-of-day price feeds**: SOL token price data for converting native token amounts to USD values
- **Protocol addresses**: Hardcoded fee recipient wallet addresses that identify SolTradingBot's fee collection points

## 3. Step-by-step calculation

### Component A: Fee data collection
- **Purpose**: Identifies and captures all fee payments made to SolTradingBot
- **Logic**: Filters Solana native transfer events to capture payments sent to two specific fee recipient addresses: `F34kcgMgCF7mYWkwLN3WN7KrFprr2NbwxuLvXx4fbztj` and `96aFQc9qyqpjMfqdUeurZVYRrrwPJG2uPV6pceu4B1yb`. Excludes self-transfers where the transaction signer is one of the fee recipient addresses to avoid counting internal movements. Captures the transaction signer as the user, the transfer amount, and block timestamp for each fee payment.
- **Key fields**: `transaction_signer` (user identifier), `amount` (fee amount in lamports), `block_timestamp` (transaction time), `token_address` (SOL token identifier)

### Component B: Daily active user calculation
- **Purpose**: Counts unique users who paid fees each day
- **Logic**: Takes distinct transaction signers from the fee payment data, grouped by day. Each user who makes at least one fee payment on a given day is classified as a 'Trader' user type and counted exactly once. Uses HyperLogLog sketching for efficient distinct counting across different dimensional breakdowns including project level, chain level, and user type level aggregations.
- **Key fields**: `user_dau` (unique user identifier), `timestamp` (daily date), `user_type` (always 'Trader')

### Component C: Daily fee aggregation
- **Purpose**: Calculates total fees collected per day in USD
- **Logic**: Groups fee payment data by day and sums the transfer amounts. Converts amounts from lamports (Solana's smallest unit) to SOL by dividing by 1e9. Applies USD conversion using end-of-day SOL price feeds to get fee values in USD. Aggregates across chain, product, and token dimensions.
- **Key fields**: `fees` (daily fee total in USD), `timestamp` (daily date), `chain_id` (always 'solana'), `token_address` (SOL token)

### Final aggregation
- **Combining components**: The daily fee totals and daily active user counts are combined using a division operation where fees are divided by user count for each day
- **Currency conversion**: All fee amounts are converted to USD using end-of-day SOL token price feeds applied after converting from lamports to SOL
- **Time aggregation**: Data is aggregated to daily boundaries using timestamp truncation to day level granularity
- **Final calculation**: AFPU equals total daily fees in USD divided by the count of unique users who paid fees that day, with missing days filled with zero values to maintain consistent time series data

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

SolTradingBotSTBOT

Average fees per user (AFPU)

Average fees per user (AFPU)

Competitive landscape