# Active users (monthly) Methodology

## 1. Overview

Active users (monthly) is defined as the number of unique addresses that perform a transaction on SparkLend within a 30-day rolling window. This metric is utilized to evaluate user engagement, adoption, and the overall transaction activity of the lending protocol. By tracking distinct addresses interacting with the smart contracts, the active user base of SparkLend is monitored over time. Interactions include borrowing, repaying, supplying, withdrawing, and executing flash loans.

## 2. Data sources

- **Blockchain events**: `Borrow`, `FlashLoan`, `Repay`, `Supply`, and `Withdraw` events from `Pool` contracts, covering Ethereum and Gnosis

## 3. Step-by-step calculation

### Component A: SparkLend user activity extraction

- **Purpose**: Extract unique user addresses and transaction details from SparkLend smart contract events.
- **Logic**: The `user` field is extracted from `Borrow`, `Repay`, `Supply`, and `Withdraw` events emitted by `Pool` contracts. The `initiator` field is extracted from `FlashLoan` events emitted by `Pool` contracts. These extracted addresses are classified into specific user types, including Borrower, Repayer, Depositor, and Withdrawer, to represent different forms of protocol interaction.
- **Key fields**: `block_timestamp`, `transaction_hash`, `user`, and `initiator`

### Component B: Monthly deduplication and aggregation

- **Purpose**: Calculate the count of unique active users per 30-day window.
- **Logic**: Transaction timestamps are aggregated over a 30-day rolling window using UTC boundaries. Distinct user addresses are aggregated by 30-day window, chain, and product ID to calculate the active users (monthly). Chain availability filters are applied to ensure data freshness and archive status alignment. Cross-product aggregation details are handled at the project level.
- **Key fields**: `block_timestamp` and `user_address`

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

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

Active users (monthly)

Lending

Lenders deposit funds into Spark and receive interest payments from borrowers (supply-side fees).

Spark is a non-custodial lending protocol built on Ethereum. Spark’s development team Phoenix Labs was founded in early 2023.

SPK tokenholders own and govern the protocol. They currently take a cut of the total interest paid by borrowers (revenue).

SparkLend

Active users (monthly)

Active users (monthly)

Chain breakdown