gm, builders! 👋
Here’s your roundup of November 2025's onchain news and growth insights.
Highlights
Improved Attribution, Referrer Breakdown, and Conversion Windows
Build Charts with AI and SQL Editor Autocomplete
NPM Trusted Publishing, Contracts, and API Keys
Entry Exit Pages Analytics and Improved Retention Chart
Proxy Support, Improved Filtering, and More
Behavioural Segments
How to Turn Wallet Addresses into User Profiles for DeFi Growth
Ultimate Guide to Measuring CAC and LTV for Onchain Apps
A Founder's Guide to Data Strategy for Crypto & DeFi
Step-by-Step Guide to Tracking User Behaviour in Crypto and DeFi
Web3 Monthly Recap
Introducing Improved Attribution, Referrer Breakdown, and Conversion Windows
Improved Attribution, Referrer Breakdown, and Conversion Windows are upgrades to Formo's campaign analytics that give teams sharper visibility into where users come from and how long it takes them to convert.
They enable builders to move beyond surface-level traffic data and understand the full journey from first touch to onchain action.
Improved Attribution: Get clearer credit assignment across campaigns, partners, and channels so you know exactly which efforts are driving wallet connections and transactions.
Referrer Breakdown: See which domains, apps, or platforms are sending users to your product and compare their quality based on onchain behavior.
Conversion Windows: Define custom time windows to measure how quickly users move from discovery to conversion, and identify where drop-off happens along the way.
Build Charts with AI and SQL Editor Autocomplete
Build Charts with AI and SQL Editor Autocomplete are new capabilities in Formo that make it faster to explore data and create visualizations without needing to write queries from scratch.
They help teams go from question to insight in seconds, whether they prefer natural language or SQL.
Build Charts with AI: Describe the metric or trend you want to see and let AI generate the chart for you, complete with the underlying query.
SQL Editor Autocomplete: Write queries faster with intelligent autocomplete suggestions for table names, columns, and functions directly in the editor.
NPM Trusted Publishing, Contracts, and API Keys
NPM Trusted Publishing, Contracts, and API Keys are developer-focused improvements that streamline how teams integrate and authenticate with Formo.
They reduce setup friction and give engineering teams more control over how they connect their stack to Formo's analytics infrastructure.
NPM Trusted Publishing: Install and update Formo packages with verified, trusted publishing directly from npm.
Contracts: Link smart contract addresses to your analytics workspace to track onchain interactions alongside user behavior.
API Keys: Generate and manage API keys to authenticate programmatic access to Formo's Events API and data endpoints.
Entry Exit Pages Analytics and Improved Retention Chart
Entry Exit Pages Analytics and an improved Retention Chart are additions to Formo's behavioral analytics suite that help teams understand where users begin and end their sessions, and how well products retain them over time.
Entry Exit Pages: Identify which pages users land on first and which pages they leave from, helping you optimize onboarding flows and reduce early drop-off.
Improved Retention Chart: Get a cleaner, more detailed view of cohort retention over time with better filtering and breakdown options.
Proxy Support, Improved Filtering, and More
Proxy Support and Improved Filtering are infrastructure upgrades that give teams more flexibility in how they collect and analyze data.
Proxy Support: Route Formo tracking through your own domain to improve data reliability and reduce the impact of ad blockers.
Improved Filtering: Apply more granular filters across dashboards and queries to zero in on specific user cohorts, chains, or time periods.
Behavioural Segments
Behavioural Segments is a new segmentation feature that lets teams create dynamic user groups based on onchain and offchain behavior to power more targeted analysis and personalization.
Dynamic Segmentation: Build segments that update automatically as users meet or exit defined behavioral criteria.
Onchain + Offchain: Combine wallet activity, transaction history, and product usage into a single segmentation layer.
How to Turn Wallet Addresses into User Profiles for DeFi Growth
Wallet addresses are the starting point, not the destination. This piece covers how DeFi teams can enrich raw address data with onchain history, token holdings, and behavioral signals to build actionable user profiles that inform growth strategy.
Ultimate Guide to Measuring CAC and LTV for Onchain Apps
CAC and LTV look different onchain. This guide covers how to define, measure, and improve both metrics in the context of crypto and DeFi products, where user acquisition spans multiple channels and value is expressed in transactions and protocol activity.
A Founder's Guide to Data Strategy for Crypto & DeFi
Practical frameworks for crypto founders on how to think about data infrastructure early, what to measure at each stage, and how to turn onchain signals into product decisions.
Learn more
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.
Web3 Monthly Recap
Phishing Dojo byThe Red Guild. Link
The Embedded Economy by Decentralised Link
Trustless Manifesto by Vitalik Buterin. Link
Onchain Revenue Report (H1 '25) by1kx. Link
5 (more) charts that explain crypto right now by a16zcrypto. Link
State of Crypto 2025: The year crypto went mainstream a16zcrypto. Link
Oracle Infrastructure: The Backbone of Lending Protocols. Link
Read our previous update HERE.
