gm, builders! 👋
Here’s your roundup of December 2025's onchain news and growth insights.
Highlights
Funnel Modes, Retention by Segment, and Protocol Tokens
User Flows and Retention Charts
Live View and Text to SQL
User Lifecycles, Activity Chart, Funnel Breakdown, and Advanced Filters
Data Activation Best Practices for DeFi Teams
Web3 Monthly Recap
Introducing Funnel Modes, Retention by Segment, and Protocol Tokens
Funnel Modes, Retention by Segment, and Protocol Tokens are upgrades to Formo's core analytics that give teams more precise control over how they measure conversion, retention, and onchain activity.
They enable builders to go beyond aggregate metrics and understand how different user groups behave at every stage of the product journey.
Funnel Modes: Switch between different funnel calculation methods to match how your product defines conversion, from strict ordered funnels to flexible unordered paths.
Retention by Segment: Break down retention curves by user segment to identify which cohorts stick around and which need intervention.
Protocol Tokens: Track protocol-native token activity alongside user behavior to connect incentive programs directly to engagement and retention outcomes.
User Flows and Retention Charts
User Flows and Retention Charts are new visualization tools in Formo that help teams see exactly how users navigate their product and how well they retain over time.
They turn raw event data into clear visual narratives that make it easier to spot friction, drop-off, and high-value paths.
User Flows: Visualize the sequences of actions users take through your product, from wallet connection to key transactions, to identify the most common paths and where users fall off.
Retention Charts: Track how different user cohorts return to your product over days, weeks, and months with charts built for onchain apps.
Live View and Text to SQL
Live View and Text to SQL are real-time and query capabilities that make it faster to monitor user activity as it happens and explore data without writing SQL from scratch.
Live View: Watch wallet connections, transactions, and custom events stream in real time, giving your team instant visibility into what users are doing right now.
Text to SQL: Describe the data you want to query in plain language and get a SQL query generated automatically, ready to run or refine in the editor.
User Lifecycles, Activity Chart, Funnel Breakdown, and Advanced Filters
User Lifecycles, Activity Chart, Funnel Breakdown, and Advanced Filters are a suite of analytical tools that give teams a fuller picture of how users move through their product over time.
User Lifecycles: Categorize users by lifecycle stage: new, active, dormant, churned and track how they move between stages over time.
Activity Chart: Get a high-level view of overall product engagement trends across any time period to spot growth, plateaus, and drop-off.
Funnel Breakdown: Drill into individual funnel steps to see where specific segments convert or drop off, by chain, wallet type, or custom property.
Advanced Filters: Apply layered filters across any report to isolate exactly the user group or behavior you want to analyze.
Data Activation Best Practices for DeFi Teams
Collecting data is only half the job. This guide covers how DeFi teams can move from raw onchain and offchain signals to action, using real-time alerts, lifecycle segmentation, and progressive event tracking to improve retention and drive growth.
Step-by-Step Guide to Tracking User Behaviour in Crypto and DeFi
A practical walkthrough of how to instrument a Web3 product for behavioral analytics, from wallet connections and transaction events through to retention and funnel analysis.
Complete Guide to Customer 360 for Crypto Apps
A comprehensive look at how crypto apps can combine onchain and offchain data to build complete user profiles, and how those profiles translate into better engagement, sharper segmentation, and stronger retention.
How to Build a DeFi Metrics Dashboard in 5 Steps
A step-by-step guide to defining the right KPIs, choosing analytics tooling, and building a metrics dashboard that gives your DeFi team a clear, real-time view of product performance.
Web3 Monthly Recap
Recapping Crypto’s Most Consequential Year by Multicoin. Link
When stablecoins weren’t inevitable: The story of USDC by a16z crypto. Link
Specialized Stablecoin Fintechs by Multicoin. Link
AI x crypto crossovers by a16z crypto. Link
AI agents find $4.6M in smart contract exploits by Anthropic Link
Ethereum Ecosystem Overview by Jason Chaskin. Link
Ethereum Roadmap in 30 mins by Vitalik Buterin. Link
Crypto Marketing Trends & Predictions by Emily Lai Link
Web3 Operational Security 101 by Opsek. Link
Read our previous update HERE.
