Dashboard Templates
Find churned and dormant wallets, and the revenue at risk, with this wallet churn dashboard template for onchain and DeFi teams.
Wallet churn measures the users who stop coming back. Where a retention dashboard shows who stays, a churn and dormancy dashboard shows who left, how long they’ve been quiet, what they were worth, and who is worth winning back. It turns inactivity into a reactivation to-do list.
Wallets rarely announce that they’ve churned; they simply go dormant. Bucketing every wallet by days since last seen, then layering in the channel that acquired it and the revenue it produced, tells you which cohorts are slipping away and which lapsed wallets are valuable enough to re-engage. It is the mirror image of churn rate.
What’s included
Churned Wallets: a KPI number of wallets with no activity in the last 30 days.
Wallet Lifecycle Distribution: a pie chart bucketing every wallet as active, at risk, dormant, or churned.
Churn Rate by Acquisition Channel: a table showing which channels deliver wallets that stick and which deliver wallets that leave.
Revenue at Risk: a KPI number of lifetime revenue from wallets that have gone quiet for 8 to 30 days.
Wallets by Last Active Day: a bar chart of when wallets dropped off, to tie churn spikes to releases or incentive cliffs.
Dormant High-Value Wallets: a table ranking the richest wallets that stopped showing up, as a reactivation list.
Rolling Retention: a weekly cohort chart of wallets that connect and later return to transact.
Use this dashboard to spot churn early, quantify the revenue at risk, and target the lapsed wallets worth winning back.
How to build this dashboard
Install the Formo SDK — last-seen dates, acquisition channels, revenue, and net worth are captured automatically.
Create a board and add the Wallet Churn & Dormancy template from the gallery.
Use the dormant high-value list to target reactivation, and pair it with the retention view to see who comes back.
Related dashboards
Active Wallets Dashboard — the active base churn eats into
User Retention & Cohorts Dashboard — cohort-level retention over time
Frequently Asked Questions
1. What is wallet churn?
Wallet churn is the share of previously active wallets that stop interacting with your app over a period. Because wallets go quiet rather than cancel, churn is usually defined by an inactivity threshold, such as no activity in the last 30 days.
2. When is a wallet considered churned versus dormant?
It depends on the inactivity band. This dashboard treats 0 to 7 days as active, 8 to 30 days as at risk, 31 to 90 days as dormant, and 90 days or more as churned. The exact thresholds should match your app’s natural usage frequency.
3. How is churn rate calculated?
Divide the number of wallets that crossed your inactivity threshold by the total wallets in the cohort. Measuring it per acquisition channel shows which sources deliver durable wallets and which deliver wallets that leave quickly.
4. What is the difference between churn and retention?
Retention measures who stays; churn measures who leaves. They are two sides of the same cohort, but a churn and dormancy view adds what the lapsed wallets were worth and who is worth re-engaging, which a retention chart alone does not.
5. What charts are included in the Wallet Churn & Dormancy Dashboard?
A Churned Wallets KPI, a Wallet Lifecycle Distribution, Churn Rate by Acquisition Channel, a Revenue at Risk KPI, Wallets by Last Active Day, a Dormant High-Value Wallets list, and a Rolling Retention cohort chart.
6. What is revenue at risk?
Revenue at risk is the lifetime revenue attributable to wallets that have recently gone quiet, in this dashboard those inactive for 8 to 30 days. It quantifies what you stand to lose if those wallets churn, so you can prioritise re-engagement.
7. What setup is required to use the Wallet Churn & Dormancy Dashboard?
None. Last-seen dates, acquisition channels, revenue, and net worth come from standard Formo tracking and wallet profiles once the SDK is installed. No custom events are required.
8. How do I find lapsed wallets worth winning back?
The Dormant High-Value Wallets table ranks wallets that stopped showing up by net worth, so you can target reactivation at the highest-value lapsed users rather than treating every churned wallet the same.
9. Why break churn down by acquisition channel?
Because some channels deliver curious one-time visitors and others deliver committed users. Seeing churn rate by channel tells you which sources are worth scaling and which are quietly inflating acquisition while leaking out the back.
10. Who should use the Wallet Churn & Dormancy Dashboard?
Growth, lifecycle, and product teams at onchain and DeFi apps that want to catch churn early, quantify the revenue at stake, and run targeted reactivation instead of guessing who left.