Analytics

Web3 Activation Metrics Beyond the Wallet Connection

A wallet connection is not activation. Build a wallet activation event model that separates connection, SIWE signing and the first useful on-chain action, strips test and farm wallets, and compares cohorts by retained use.

Alex KhvoinitskiiNovember 16, 202615 min read

TL;DR: A wallet connection is not activation — it shows curiosity, not value. Count a wallet as activated only when it completes your product's core on-chain action, strip test and farm wallets from the count, and compare cohorts by retained use instead of raw connections.

The number that gets a Web3 growth lead in trouble is the wallet connection count. It climbs every week, it fits neatly in a stakeholder deck, and it says almost nothing about whether anyone received value. Teams that measure wallet activation beyond a wallet connection get a different picture: Formo's funnel analysis shows roughly 65% of dApp visitors connect a wallet while only about 35% complete a first transaction, and a separate analysis found a 40% drop-off immediately after the connect step (Coinbound's web3 marketing metrics breakdown). The gap between "connected" and "did something useful" is where most web3 activation metrics quietly fail.

This guide is for growth, customer operations, and commercial leads at Web3 product and infrastructure businesses who need one defensible activation number. It builds an event model that separates connection, signing, and useful action; it strips the test and farm noise that inflates raw counts; and it ends with a retained-use comparison you can reproduce on your own data. The discipline is the same one behind any business process automation ROI measurement: define the denominator, fix the window, and never report a number that would not change a decision.

Why a wallet connection is not activation

A wallet connection is a session, not a commitment. A user clicks connect, approves the prompt in two seconds, looks at the interface, and leaves. You hold an address; they did nothing. Formo's activation guide is blunt about it: activation is the moment a user completes the core on-chain action the protocol was built for — a swap for a DEX, a deposit or borrow for a lending protocol, a deposit for a yield vault — and pages visited or repeated connections do not count (Formo's DeFi activation metrics guide).

The scale of the gap is documented. The Blockchain-Ads User Acquisition Trends Report 2026, cited by Formo, puts the average DeFi landing-page-to-connect rate near 15% and the connect-to-first-transaction rate near 32%. Treat both as directional benchmarks, not targets — they are averages across DeFi apps, and your numbers will vary by chain, product type, and audience.

A useful test from the same guide: if your activation metric would still register while the protocol was offline tomorrow, it is not measuring activation. Connection counts, signature counts, and page-view counts all fail that test.

Separate connection, signing and useful action

The first modeling decision is to stop merging three different events into one "user joined" bucket. Each lives on a different layer and proves a different thing.

Event Layer What it proves Counts as activation?
wallet_connected Off-chain session The visitor has a wallet and mild intent No — gateway event
message_signed (for example SIWE) Off-chain authentication The visitor controls the private key No — identity, not value
first_useful_action On-chain transaction The user received the product's core value Yes — this is the activation event

The signing row deserves its own line because teams routinely misclassify it. Sign-In with Ethereum (SIWE) is an authentication feature — Reown's AppKit documentation lists it as one authentication method alongside email and social login — and it produces a signed message, not an on-chain transaction. A signature can be revoked, costs nothing, and does not show intent to use the product; Formo explicitly excludes signed messages from activation for exactly those reasons.

That leaves the useful action, which is protocol-specific. Coinbound's framing is the cleanest: the activation event is defined per product — a first deposit or swap for DeFi, a first purchase for an NFT marketplace, a first governance vote for a DAO. For infrastructure products without a user-facing contract — an RPC provider, a wallet SDK, a relay — the useful action is the nearest observable value event: a first successfully relayed transaction, a first funded call through your stack, or the first swap routed by your integration. The rule is that the event must require the product to exist and must be verifiable on-chain or in your delivery logs.

Instrumentation follows the same split. Connection and signing come from your session layer — AppKit or an equivalent wallet stack emits both. The useful action comes from chain data: Alchemy's Notify webhooks are one documented option, with an Address Activity webhook for ETH, ERC-20, ERC-721 and ERC-1155 transfers (up to 100,000 tracked addresses per webhook) and Custom webhooks for arbitrary contract interactions (Alchemy webhook types). The event-selection logic mirrors what SaaS teams do when they choose a SaaS activation event that predicts value — the difference is that your candidate events are verifiable on a public ledger instead of inside a product database.

The wallet activation event model

The asset below is a minimal event dictionary: the fields a tracking plan needs so that "activated wallet" means the same thing to product, marketing, and finance. Copy it into your analytics spec and fill the qualification column for your own product.

Field Example value Rule
event_name wallet_connected, message_signed, first_useful_action One of the three modeled events; nothing else enters the funnel
wallet_address 0x8f3... Lowercase-normalized; one address can sit in several events
chain_id 1, 8453, 137 Mainnet only for activation; testnets route to exclusion
occurred_at 2026-11-02T14:31Z UTC timestamp from the chain or session log, not the report run
on_chain true / false false for connect and sign events automatically
qualifies_activation true / false true only for the defined core action on a supported chain
exclusion_flag testnet, team, farm_suspect, null Any non-null flag removes the wallet from the qualified count
cohort_week 2026-W45 Week of wallet_connected; anchors the comparison window

Three qualification rules do most of the work:

  1. On-chain only. qualifies_activation can be true only when on_chain is true. Approvals deserve a note: an ERC-20 approve call is intent, not received value, so keep it out of the activation event unless your product's core value literally is the approval.
  2. Inside the window. The action must land within a fixed window of the first wallet_connected — seven days is the convention Coinbound documents for activated wallet rate. Fix the window per cohort and do not move it mid-report.
  3. Core action, not any action. A gas-only transfer or a dust transaction does not qualify. The event must be the action your product exists to deliver, mapped to a contract address or method ID you control.

Exclude test activity and farm noise

Raw activation counts get inflated by three kinds of noise: your own team, your own tests, and other people's scripts. The event model handles them with exclusion_flag, but the flag is only as good as the rules behind it.

Internal and test activity is the easy part. Maintain an explicit exclusion list: team wallets, QA addresses, deployment and treasury wallets, and every testnet chain. Anything matching the list sets exclusion_flag at ingestion time, before any report runs.

Farm and sybil noise is harder because the goalposts move. Documented heuristics from sybil-filtering practice give a solid first pass, and each has a known false-positive group worth naming before you turn the rule on:

Rule Catches Typical false positives
Wallet-age filter (entire history inside ~48 hours) Fresh single-use farm wallets Real newcomers the campaign was meant to bring
Minimum balance or gas-spent threshold Empty farm wallets Low-income users; users on near-zero-fee chains
Funding-graph cluster (many wallets funded from one source) Hub-funded farms Families, shared payers, exchange outflows without labels
Behavioral similarity (identical action sequences across wallets) Scripted farms Users following the same popular tutorial

These rules come from documented campaign-filtering practice — the Arbitrum airdrop, for example, deducted points from wallets whose entire history fit inside a 48-hour window (sybil filtering heuristics writeup). At the heavier end, the Arbitrum Foundation published a sybil-detection repository that builds funder/sweep transaction graphs, strips entity addresses such as bridges and exchanges using Nansen, Hop and OffChain Labs labels, then clusters with the Louvain algorithm — flagging patterns like transfer clusters above 20 addresses or many addresses funded from one source. Artemis took the machine-learning route, training a sybil-probability model on prior airdrop exclusion lists with features like transaction counts, distinct interacting addresses, and wallet balance; it is careful to note that flagged addresses may be low-engaged users rather than proven sybils (Artemis sybil detection announcement).

The operational rule that keeps this honest: flag, never silently delete. Report activation with and without the flagged set so everyone sees the spread, and route borderline rules through human review before they touch the qualified count — the same approval-gate discipline that keeps automated decisions auditable anywhere else.

Web3 wallet analytics: retained use over raw counts

With a qualified activation event defined, the metric stack is straightforward:

  • Activated wallet rate: qualified first_useful_action wallets divided by wallet_connected wallets in the same cohort, inside the fixed window. This is the web3 wallet analytics number that replaces "total connections."
  • Retained-active rate: the share of each activated cohort still transacting at day 30, 60, and 90. Cohort retention by acquisition source is where channel quality actually shows up.
  • Weekly active wallets (WAW): unique addresses with at least one on-chain transaction per week — Coinbound calls it the most honest growth measure because it resists bot and airdrop-farmer inflation. A protocol with 50,000 lifetime connections and 2,000 WAW has a 4% weekly engagement rate; if that ratio falls while connections rise, acquisition is outpacing retention.
  • Time-to-first-action: median time from connect to first transaction. Formo's funnel research reports that users who transact within 24 hours retain at roughly 3x the rate of those who delay, and flags deposits followed by immediate withdrawals as a UX-failure signal (Formo's onchain funnel analysis). The same "time to value" logic SaaS teams apply to failed signups applies here, just measured on-chain (time-to-value for SaaS failed signups).
  • Stickiness and growth quality: a DAW/MAW ratio and a Quick Ratio above 1.0 — net growth divided by churn — round out the standard web3 metrics set described in Optiblack's product analytics writeup.

The reason retained use beats raw counts is arithmetic, not philosophy. Coinbound's example: a campaign producing 10,000 wallet connections at 2% activation delivered 200 active users, while a smaller campaign producing 2,000 connections at 15% activation delivered 300. Volume lost; quality won. Only the retained-use view shows that.

A worked example with synthetic numbers

The model below is synthetic — invented inputs that exist to make the arithmetic reproducible, not a measured client result. Assume a week cohort (2026-W45) and a 7-day activation window.

Funnel for the week:

Stage Wallets Note
wallet_connected 4,000 Session layer events
message_signed 1,900 Auth only; never enters the activation count
first_useful_action inside 7 days 1,150 Before exclusions
Excluded: testnet -40 chain_id filter
Excluded: team/QA -30 Explicit exclusion list
Excluded: farm_suspect -90 Funding-cluster + wallet-age flags
Qualified activated wallets 990 1,150 - 160

Activated wallet rate: 990 / 4,000 = 24.75%.

Now split the same cohort by acquisition channel:

Channel Connected Qualified activated Activation rate Day-30 retained-active Retained rate
A: paid campaigns 2,800 420 15.0% 60 14.3%
B: partner + community 1,200 570 47.5% 270 47.4%
Total 4,000 990 24.75% 330 33.3%

Cost math, assuming $9,000 spent on channel A and $3,600 on channel B:

  • Cost per activated wallet: A = 9,000 / 420 = $21.43; B = 3,600 / 570 = $6.32.
  • Retention-adjusted cost — spend divided by wallets still active at day 30: A = 9,000 / 60 = $150.00; B = 3,600 / 270 = $13.33.

Channel A produced more connections and looked better in a vanity report. Channel B produced more retained users at roughly 11x better retention-adjusted economics — the same retention-adjusted cost-per-wallet logic Coinbound describes for creator and channel allocation. For paid channels specifically, that gap is wasted ad spend in slow motion; it is the same leak pattern a ROAS leak calculator surfaces for ad budgets, and the acquisition-cost arithmetic itself is worth checking against an ROI calculator before the next budget cycle. For scale context only, Coinbound's 2025 campaign benchmarks put cost per wallet between $1.86 (a stablecoin checkout campaign) and $14-31 (trader-focused acquisition), with referral-channel CAC averaging near $150 — directional figures from one agency's reporting, not market rates.

Reporting the metric without breaking it

Three reporting rules keep the metric honest after launch:

  1. Keep the funnel stages separate. Connection, signing, and activation are three lines on the dashboard forever. The moment a report merges "connected + signed" into one onboarding number, the activation metric loses its meaning.
  2. Version the definition. When the core action changes — new product surface, new chain, new contract — bump the definition version and annotate every chart. Comparing a v1 cohort against a v2 cohort without that note is how teams convince themselves a redesign worked.
  3. Show the flagged spread. Report activation with and without excluded wallets. If farm suspects swing the number by more than a few points, the acquisition channel needs attention before the metric does.

On tooling: any web3 analytics platform that can join session-layer events to chain-level events per wallet will do the job; the irreplaceable part is the event dictionary, not the vendor. Segment everything by channel once the base rate is stable — that is where the metric starts paying for itself, and the same funnel-reporting discipline shows up in merchant onboarding metrics, which face the same "approval is not activation" problem in payments.

If your team is still arguing about which on-chain action counts as activation, a That'sGonnaHelp automation audit can scope the event model, exclusion rules, and retention reporting as one bounded piece of work before the next campaign spends against the wrong number.

FAQ

Does signing a SIWE message count as activation? No. Sign-In with Ethereum is an authentication event — it proves key control and produces an off-chain signed message, not an on-chain transaction. It belongs in the funnel as message_signed, but the activation count only fills from first_useful_action.

What is a good wallet activation rate? Directional references exist: the Blockchain-Ads 2026 data cited by Formo puts the DeFi connect-to-first-transaction average near 32%, and Formo treats above 40% as strong. These are cross-app averages — your own cohort baseline and its trend matter more than matching a published number.

What is the best web3 analytics tool for tracking wallet activation? There is no single best tool; the requirement list matters more than the brand. You need wallet-level joining of session events (connect, sign) to on-chain events (contract calls, transfers), cohort reporting, and exclusion flags. Web3 analytics platforms and webhook infrastructure such as Alchemy Notify cover different halves of that stack — evaluate them against your event dictionary.

Can a product activate wallets without its own smart contract? Yes. Infrastructure products define the useful action nearest to delivered value — a first successfully relayed transaction, a first funded API call through your RPC, or a first swap routed by your integration. The event must be observable, attributable to the product, and meaningful to the user.

Should testnet activity ever count toward activation? Only for developer-facing products where testnet use is the value being delivered — for example, an RPC or faucet service measured on developer activation. For user-facing mainnet products, testnet events stay in the exclusion bucket permanently.

Answer clarity notes

  • Dates and sources: benchmark figures reflect what each linked source reported at publication (2025-2026 vendor and report data); check current documentation and reports before quoting them onward.
  • Evidence: funnel benchmarks (15%, 32%, 65%/35%, 40% drop-off, 24-hour retention pattern) are public-source figures from Formo, Coinbound, and the Blockchain-Ads User Acquisition Trends Report 2026, cited here with their original scope as directional averages. CPW figures are one agency's 2025 campaign reporting.
  • Synthetic example: the worked example's cohort sizes, rates, and dollar figures are invented for reproducible arithmetic. It is not a measured client result, a benchmark, or a promise of performance.
  • Recommendations: the event dictionary, qualification rules, and exclusion heuristics are editorial recommendations built from the cited documentation and filtering practice — adapt them to your chains and product.
  • Scope: this guide covers product analytics for Web3 growth, operations, and commercial teams. It is not token-price, investment, legal, or platform-policy advice.
  • Ranges and examples in this article are planning guidance, not guarantees.

Sources

A

Alex Khvoinitskii

Founder, That'sGonnaHelp

Founder of That'sGonnaHelp. Building growth and automation systems since 2021 — GTM, traction, retention, and revenue — for SaaS, FinTech, and e-commerce clients, from early-stage brands to global exchanges.

Related articles

Discuss your project