Skip to main content
Track daily active users (DAU), weekly active users (WAU), and monthly active users (MAU) for your crypto app with Formo’s wallet-native analytics. Unlike traditional analytics that count page views, Formo tracks actual wallet engagement, giving you accurate user metrics for onchain applications.

​
What you’ll learn

  • Understand the difference between visitors and active users for crypto apps
  • Set up DAU/WAU/MAU tracking with wallet-based metrics
  • Create custom dashboards for user engagement
  • Analyze active user trends over time

​
Prerequisites

  • Formo SDK installed (Installation Guide)
  • At least 7 days of data collection (for meaningful WAU metrics)

​
Part 1: Understanding Crypto App User Metrics

​
Traditional vs. onchain active users

Traditional web analytics count “active users” by sessions or page views. For crypto apps, this misses the mark:
MetricTraditional AnalyticsFormo (Onchain)
Active userAny visitor with a sessionWallet connected OR transaction completed
Unique usersCookie-based (easily duplicated)Wallet address (unique by design)
EngagementTime on page, clicksTransactions, signatures, value moved

​
Key metrics for crypto apps

MetricDefinitionWhy it matters
DAUUnique wallets active in the last 24 hoursDaily engagement health
WAUUnique wallets active in the last 7 daysWeekly usage patterns
MAUUnique wallets active in the last 30 daysMonthly reach
DAU/MAU ratioDAU divided by MAUStickiness (higher = more engaged)
New usersFirst-time wallet connectsGrowth rate
Returning usersWallets with multiple sessionsRetention quality
Power usersActive 5+ days in last 30 daysCore engaged users
Volume/RevenueTotal transaction valueEconomic activity
Retention% of users returning over timeLong-term engagement

​
Part 2: How to View Core Metrics

Formo provides core metrics for tracking user engagement out of the box.

​
Step 1: Open the Overview dashboard

1

Go to the Formo Dashboard

Open app.formo.so.
2

Select your project

3

Click Overview in the left navigation

You’ll see top-line metrics including:
  • Visitors (page views)
  • Wallets (connected wallets)
  • Transactions (completed transactions)

​
Step 2: Adjust the date range

Use the date picker to view different time periods:
Date rangeWhat you’ll see
TodayDAU (daily active wallets)
Last 7 daysWAU breakdown by day
Last 30 daysMAU breakdown by day

​
Step 3: View the trend chart

The overview chart shows daily unique wallets over time. Look for:
  • Growth trends: Is DAU increasing week-over-week?
  • Weekly patterns: Which days have highest engagement?
  • Anomalies: Sudden spikes or drops to investigate

​
Part 3: How to Create a Custom DAU Dashboard

Build a dedicated dashboard to monitor active user metrics.

​
Step 1: Navigate to Dashboards

1

Click Dashboards in the left navigation

2

Click Add board to create a new dashboard

​
Step 2: Create a DAU chart

Using Ask AI (Recommended):
1

Click Ask AI in the sidebar

2

Type: "Show me daily unique connected wallets for the last 30 days"

3

Save the generated chart to your dashboard

4

Or, click Add Chart to add a visualization yourself with SQL

Using SQL (via the Explorer): 
SELECT
  toDate(timestamp) AS date,
  countDistinct(address) AS daily_active_wallets
FROM events
WHERE type = 'connect'
  AND timestamp >= now() - INTERVAL 30 DAY
GROUP BY date
ORDER BY date
Choose Line chart for visualization.

​
Step 3: Create a WAU chart

Using Ask AI: Type: “Show me 7-day rolling unique wallets” Using SQL: 
SELECT
  toDate(timestamp) AS date,
  countDistinct(address) AS wallets
FROM events
WHERE type = 'connect'
  AND timestamp >= now() - INTERVAL 37 DAY
GROUP BY date
HAVING date >= now() - INTERVAL 30 DAY
ORDER BY date
For a true rolling 7-day WAU, you’ll need a window function. The Ask AI feature can help generate this query.

​
Step 4: Create a DAU/MAU stickiness chart

This ratio shows what percentage of monthly users engage daily. It’s a key health metric. Using Ask AI: Type: “Calculate DAU/MAU ratio for the last 30 days” A healthy DAU/MAU ratio for crypto apps:
  • 5-10%: Normal for most crypto apps
  • 10-20%: Strong engagement
  • 20%+: Exceptional stickiness (common for DEXes, gaming)

​
Step 5: Organize your dashboard

Arrange your charts into a useful layout:
RowCharts
TopDAU (number), WAU (number), MAU (number)
MiddleDaily active wallets trend (line chart)
BottomDAU/MAU ratio, New vs. Returning users

​
Part 4: How to Segment Active Users

Not all active users are equal. Segment by behavior and value.

​
By user lifecycle

Formo automatically categorizes users by lifecycle:
SegmentDefinition
NewFirst activity in last 30 days
ReturningMultiple sessions, active recently
Power UserActive 5+ days in last 30 days
ChurnedNo activity for 30+ days
ResurrectedReturned after being churned
View these segments by going to Users and applying the Lifecycle filter.

​
By engagement level

Create segments for different activity levels: High-value active users:
  • Connected wallet in last 7 days AND
  • Completed transaction in last 7 days AND
  • Net worth > $10,000
Churned users who were previously active:
  • Volume > $10,000 AND
  • Lifecycle = Churned

​
By traffic source

Track which channels drive the most engaged users:
1

Go to Overview

2

View Wallets by Referrer in the breakdown tabs

3

Compare conversion rates across sources

​
Part 5: How to Track Active Users Over Time

​
Week-over-week comparison

Compare this week’s DAU to last week:
1

Open your DAU chart

2

Select Last 7 days date range

3

Compare to the previous week's data

Look for:
  • Growth: This week > last week = positive trend
  • Decline: Investigate causes (seasonal, product issues, competition)
  • Stability: Consistent DAU week-over-week

​
Weekly cohort analysis

Track how each week’s users retain over time:
1

Go to Retention in the left navigation

2

View the cohort retention chart

3

Compare retention rates across weekly cohorts

A healthy pattern:
  • Initial drop-off in week 1 (normal)
  • Stabilization in weeks 2-4
  • Consistent long-term retention

​
Part 6: Example DAU Dashboard

Here’s a complete dashboard setup for tracking active users:
ChartTypeQuery
DAUNumberUnique wallets today
WAUNumberUnique wallets last 7 days
MAUNumberUnique wallets last 30 days
DAU TrendLineDaily unique wallets, 30 days
New vs. ReturningStacked barNew and returning users by day
DAU/MAUNumberStickiness ratio
Active by ReferrerBarDAU breakdown by traffic source
Active by CountryPieGeographic distribution

​
Summary

You’ve learned how to:
  1. Understand crypto app user metrics (DAU/WAU/MAU with wallet addresses)
  2. View core metrics in the Formo dashboard
  3. Create custom dashboards with SQL or Ask AI
  4. Segment active users by lifecycle and engagement
  5. Track trends with week-over-week comparisons
  6. Set up alerts for metric changes

​
Benchmarks for crypto app DAU

App TypeTypical DAU/MAUNotes
DEX15-25%High-frequency usage
Lending5-10%Less frequent interactions
Gaming20-40%Daily engagement loops
Bridge3-5%Infrequent, high-value

​
Next steps

Retention Analysis

Measure week-over-week retention

User Segments

Create behavioral segments

Dashboards

Build more custom visualizations

Explorer

Run custom SQL queries