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

​
Part 1: Understanding Crypto App User Metrics

​
What is a user?

Traditional web analytics count “active users” by sessions or page views. For crypto apps, this misses the mark:
MetricTraditional AnalyticsFormo
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.

​
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 Dashboards in the sidebar

2

Click Create Chart and select the Retention chart type

3

Set the starting event to connect and the returning event to connect

4

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 high-value user activity and key events

​
Next Steps

​
FAQ

A user who connected a wallet or completed a transaction within the time period. Page-only visitors are counted separately as visitors.
Visitors are anonymous page views tracked by session. Wallets are unique addresses that connected to your app. A single visitor can connect multiple wallets.
Yes. Formo tracks wallet connections across all supported chains. A user connecting on Ethereum and Polygon counts as one unique wallet address.