# Dogecoin Active users (daily) Methodology

## 1. Overview

Daily Active Users (DAU) for Dogecoin measures the number of unique addresses that send transactions on the Dogecoin network each day. This metric provides insight into the actual usage and adoption of Dogecoin by counting addresses that are actively spending funds. The calculation leverages Dogecoin's UTXO (Unspent Transaction Output) model to trace transaction inputs back to their originating addresses, identifying the true senders of each transaction.

## 2. Data sources

The calculation relies entirely on raw Dogecoin blockchain data:
- **Dogecoin transaction records**: Complete transaction data including inputs, outputs, timestamps, and transaction hashes
- **Dogecoin UTXO data**: Transaction outputs with recipient address information encoded in scriptPubKey structures  
- **Transaction input references**: Links between transaction inputs and the previous outputs they consume, including transaction ID (`txid`) and output index (`vout`) references
- **Address resolution data**: Parsed address information extracted from Dogecoin scriptPubKey fields that identify fund recipients

## 3. Step-by-step calculation

### Component A: Address resolution lookup table
- **Purpose**: Creates a mapping between transaction outputs and their recipient addresses to enable input address resolution
- **Logic**: Extracts all transaction outputs from Dogecoin blockchain data and parses the JSON-encoded `scriptPubKey.addresses` field to identify recipient addresses. For each output, records the `transaction_hash`, `output_index`, and resolved `user_address`. Uses the explicit output index from the `$.n` field when available, otherwise falls back to the unnest array offset. Only captures the first address from multi-address scripts (offset = 0).
- **Key fields**: `transaction_hash`, `output_index`, `user_address`, `block_timestamp`

### Component B: Historical user extraction (pre-2019)
- **Purpose**: Identifies daily active users from historical Dogecoin transactions before 2019
- **Logic**: Processes all Dogecoin transactions with timestamps before 2019-01-01. For each transaction, unnests the `inputs` array to extract individual input records. Parses each input's JSON structure to extract the `txid` (previous transaction hash) and `vout` (previous output index) fields that reference the output being spent. Joins these input references with the address resolution lookup table to determine which address originally received the funds being spent.
- **Key fields**: `block_timestamp`, `transaction_hash`, `inputs` array, `txid`, `vout`, resolved `user_address`

### Component C: Recent user extraction (2019 onwards)  
- **Purpose**: Identifies daily active users from recent Dogecoin transactions starting from 2019
- **Logic**: Identical logic to the historical component but processes transactions from 2019-01-01 onwards. Uses incremental processing to handle new data efficiently. Extracts transaction inputs, parses `txid` and `vout` references, and joins with the address resolution lookup table to identify spending addresses.
- **Key fields**: `block_timestamp`, `transaction_hash`, `inputs` array, `txid`, `vout`, resolved `user_address`

### Final aggregation
- **Combining components**: Unions the historical and recent user datasets to provide complete coverage across all time periods
- **Time aggregation**: Truncates `block_timestamp` to day boundaries using `timestamp_trunc` function to group activity by calendar day
- **Deduplication**: Applies `distinct` to count each unique address only once per day, regardless of how many transactions they sent
- **Final calculation**: The result is a time series of daily unique active addresses, where each record represents one unique address that sent at least one transaction on that specific day. The `user_address` field contains the active address, and `timestamp` contains the day boundary.

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

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

Active users (daily)

Dogecoin

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

Dogecoin is a distributed ledger for transfer and store of value (a blockchain). Dogecoin was founded by Billy Markus & Jackson Palmer and launched in 2013.

DOGE holders own and govern the protocol. They currently do not take a cut of the total transaction fees paid by users (revenue).

DogecoinDOGE

Active users (daily)

Active users (daily)

Competitive landscape