Dashboard Templates
This wallet churn and retention dashboard template includes 8 charts for churn, lifecycle stage, revenue at risk, dormancy, acquisition quality, and cohort retention.
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.
Charts included and how they are calculated
Churned Wallets: counts wallets known before the selected end date whose last activity through that date occurred before the selected start date.
Wallet Lifecycle Distribution: classifies wallets as Active, At risk, Dormant, or Churned using equal-length inactivity windows anchored to the selected date range.
Churn Rate by Acquisition Channel: groups wallets by first-touch channel and calculates churned wallets divided by total wallets through the selected end date.
Revenue at Risk: sums lifetime revenue from wallets active in the immediately preceding equal-length period but inactive in the selected date range.
Wallets by Last Active Day: groups wallets by their latest activity date observed through the selected end date.
Dormant High-Value Wallets: ranks wallets inactive since before the selected start date by current net worth and includes revenue and days inactive.
Weekly Retention Cohorts: builds weekly wallet-connect cohorts and measures recurring return through the resolved standard transaction event.
Rolling Retention: uses the same connect-to-transaction signal and counts a cohort as retained from its first return onward.
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 & Retention 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 wallets known before the selected end date whose latest activity through that date occurred before the selected start date. This range-based definition keeps historical churn stable as future events arrive.
2. When is a wallet considered churned versus dormant?
The lifecycle bands use the selected range length as the inactivity window. Wallets progress from Active to At risk, Dormant, and Churned across successive equal-length windows anchored to the selected end date.
3. How is churn rate calculated?
Churn rate is churned wallets divided by all wallets known through the selected end date. Grouping that calculation by first-touch acquisition channel shows which sources produce durable wallets.
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 & Retention Dashboard and how are they calculated?
This template includes 8 charts: Churned Wallets, Wallet Lifecycle Distribution, Churn Rate by Acquisition Channel, Revenue at Risk, Wallets by Last Active Day, Dormant High-Value Wallets, Weekly Retention Cohorts, Rolling Retention. The chart list above explains each calculation, and date-filtered charts use the selected dashboard date range.
6. What is revenue at risk?
Revenue at risk is the lifetime revenue from wallets that were active in the immediately preceding equal-length period but inactive in the selected date range. It prioritises valuable wallets for re-engagement.
7. What setup is required to use the Wallet Churn & Retention Dashboard?
Baseline churn, lifecycle, revenue, and dormancy charts need no custom events. Retention automatically uses an observed standard transaction; if none is available, the dashboard asks you to choose the retention event.
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 & Retention 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.