L2 Transactions
- Source: mantle.core.fact_transactions
- Filtering: Use WHERE clauses to include only valid L2 transactions
- Aggregation:
  - DATE_TRUNC('day', block_timestamp)
  - GROUP BY DATE_TRUNC('day', block_timestamp) for daily counts
L1 Batch Entries
- Source: ethereum.core.fact_transactions, filtered by Mantle batch contract addresses
  - WHERE to_address IN ('0x...CTC', '0x...SCC')
- Aggregation:
  - DATE_TRUNC('day', block_timestamp)
  - GROUP BY DATE_TRUNC('day', block_timestamp) to get daily_l1_batch_count
Joins / Merging
- Use LEFT JOIN or FULL OUTER JOIN on day to combine L2 and L1 data
- Use COALESCE or CASE WHEN to handle null values (missing data after the upgrade)
- CASE WHEN daily_l1_batch_count IS NULL THEN 0 ELSE daily_l1_batch_count END to convert null to zero
Tx/Batch Ratio
- Calculate as (daily_l2_tx_count * 1.0) / daily_l1_batch_count
- Nulls: Appear after mid-March 2024 because Mantle v2 Tectonic (EigenDA) no longer posts batch logs on Ethereum

Dashboard	Creator	Published
Mantle Network: Comprehensive On-Chain Analytics Dashboard Feb 21, 2025	10Blockchain	Feb 21, 2025
Monad Testnet: Fast Blocks, High Throughput, Low Failures Feb 27, 2025	10Blockchain	Feb 27, 2025
Mantle Weekly: 4 Key Metrics for Adoption & Retention Feb 23, 2025	10Blockchain	Feb 23, 2025
Mantle L2 Post-Tectonic: Data Gaps and DA Externalization Feb 24, 2025	10Blockchain	Feb 24, 2025

10Blockchain