gm, builders! 👋
Here's your roundup of May 2026's onchain news and growth insights.
Highlights
- First-Seen Behavior Filters, Transaction Frequency, and SDK Updates
- Filter by Page, Angular SDK Support, and New Wallet Examples
- OAuth on Formo MCP, Funnel Segments, and Flow Event Exclusions
- AI SQL Helpers, Funnel Compare Mode, and Area Charts
- DeFi Testnet to Mainnet Launch Checklist: 4 Readiness Checks Before You Go Live (2026)
- AI-Powered DeFi Analytics: A 6-Step Framework for Onchain Growth Teams to Turn Data Into Decisions
- DEX vs Lending vs Vaults: How Analytics Requirements Differ by DeFi Protocol Type
- How to Measure DeFi Protocol Integration Impact: Integration Types, Retention Benchmarks, and ROI Scorecard (2026)
- Web3 Monthly Recap
Introducing First-Seen Behavior Filters, Transaction Frequency, and SDK Updates
Formo now makes it faster to write queries, explore funnels, and visualize data across your DeFi analytics dashboard.
These updates make it easier to go from question to insight without leaving the dashboard, compare conversion across time periods, and extend Formo's data into your own internal tooling.
AI SQL Helpers: Three new AI helpers now sit next to the SQL editor: Explain this Query describes what a SQL query does in plain English, Generate SQL turns a prompt into a query, and Format SQL cleans up an existing query in place.
Ask AI Follow-up Questions: Every Ask AI response now ends with suggested follow-up questions you can click to keep digging. Suggestions are generated from the current conversation, saved charts, events, and segments, so they stay relevant to the data you're actually looking at.
Funnels Compare Mode: The funnel chart now has a Compare mode toggle in its date controls, mirroring the one on the overview page, so you can put two date ranges side by side. Each step now also shows the median time to convert from the previous step, so you can see where users stall, not just where they drop.
Area Charts: You can now create Area Charts with stacking support out of the box, available alongside Line, Bar, Number, and other existing chart types.
Global Search: Hit Cmd+K (or Ctrl+K) anywhere in the app to open a command palette. Jump to key pages, custom boards, segments, past chats, and settings. If your query doesn't match a known action, send it straight to Ask AI.
Profile Side Panel: On the Users page, clicking a user now opens their profile in a side panel instead of a new tab, keeping your filtered list visible while you explore individual wallets.
Query API: The full Query API is now live with 18 public endpoints that expose the same data powering every chart on the Formo dashboard. Use it to build internal tooling and custom dashboards with Formo data.
Introducing Filter by Page, Angular SDK Support, and New Wallet Examples
Formo now helps DeFi teams analyze specific pages, reach non-React frameworks, and integrate with more wallet platforms.
These updates make it easier to measure the performance of individual campaign or vault pages, support a broader range of frontend stacks, and connect Formo to embedded and smart wallet providers.
Filter by Page: The Overview and Activity pages now support filtering by specific page, such as a vault or campaign page. Click any row in the Top Pages chart to apply the page filter inline, the same way segments work elsewhere in the dashboard.
Angular SDK Support: The Web SDK now supports Angular and other non-React frameworks (Vue, Svelte, vanilla JS) without requiring React types. React and Next.js apps continue to work as before. See the Angular example and docs for details.
Crossmint and OpenFort Examples: The examples repo now includes end-to-end integrations for Crossmint embedded wallets and OpenFort smart wallets, both platforms focused on stablecoin rails and agentic payments.
Introducing OAuth on Formo MCP, Funnel Segments, and Flow Event Exclusions
Formo now connects to your existing AI tools, enables cohort-level funnel analysis, and makes flow charts cleaner and more actionable.
These updates make it easier to bring Formo data into the tools you already use, compare conversion rates across user segments, and filter out noise from user path analysis.
OAuth on Formo MCP: The Formo MCP server now supports OAuth, so you can add it as a remote MCP connector in Claude, ChatGPT, Cursor, and other clients. Connect your Formo account with the AI tools you already use. Learn more in the MCP docs.
Segments on Funnels: You can now filter Funnels by any saved segment, the same way you can on the Users and Activity pages. Pick a segment and the entire funnel recomputes against that cohort, so you can compare conversion across audiences without duplicating charts.
Event Exclusions in Flow Charts: Flow charts now support an event exclusion filter. Pick events to leave out and the chart reflows around only the events you care about. It's the fastest way to clean up noisy paths without changing your instrumentation.
Introducing Performance Improvements, Last-Touch Attribution, and Funnel & Flow API
Formo now loads faster across core analytics views, gives marketing teams a complete attribution picture, and makes conversion and journey data available programmatically.
These updates make it easier to work with large datasets, understand which channels close conversions, and integrate Formo data into external dashboards and notebooks.
Performance Improvements: Significant performance improvements have been shipped across wallets, transactions, top pages, top sources, funnels, and flow charts.
Last-Touch Attribution for Funnels: Funnels now support last-touch attribution as a first-class breakdown option, letting you credit the most recent source, campaign, or referrer before a user converted. This complements first-touch attribution and gives growth and marketing teams a clearer view of which channels drive conversion at the moment of action. Open any existing funnel and toggle the attribution type to last-touch. Learn more in the Funnels documentation.
Funnel and Flow Public API Endpoints: Funnels and Flows are now available through the public Query API, so you can pull conversion and user-journey data programmatically into dashboards, notebooks, and downstream systems. The OpenAPI spec has been updated alongside the new endpoints. See the API overview for more.
AI SQL Helpers, Funnel Compare Mode, and Area Charts
Formo now makes it faster to write queries, explore funnels, and visualize data across your DeFi analytics dashboard.
These updates make it easier to go from question to insight without leaving the dashboard, compare conversion across time periods, and extend Formo's data into your own internal tooling.
AI SQL Helpers: Three new AI helpers now sit next to the SQL editor: Explain this Query describes what a SQL query does in plain English, Generate SQL turns a prompt into a query, and Format SQL cleans up an existing query in place.
Ask AI Follow-up Questions: Every Ask AI response now ends with suggested follow-up questions you can click to keep digging. Suggestions are generated from the current conversation, saved charts, events, and segments, so they stay relevant to the data you're actually looking at.
Funnels Compare Mode: The funnel chart now has a Compare mode toggle in its date controls, mirroring the one on the overview page, so you can put two date ranges side by side. Each step now also shows the median time to convert from the previous step, so you can see where users stall, not just where they drop.
Area Charts: You can now create Area Charts with stacking support out of the box, available alongside Line, Bar, Number, and other existing chart types.
Global Search: Hit Cmd+K (or Ctrl+K) anywhere in the app to open a command palette. Jump to key pages, custom boards, segments, past chats, and settings. If your query doesn't match a known action, send it straight to Ask AI.
Profile Side Panel: On the Users page, clicking a user now opens their profile in a side panel instead of a new tab, keeping your filtered list visible while you explore individual wallets.
Query API: The full Query API is now live with 18 public endpoints that expose the same data powering every chart on the Formo dashboard. Use it to build internal tooling and custom dashboards with Formo data.
DeFi Testnet to Mainnet Launch: 4 Readiness Checks Before You Go Live (2026 Checklist)
This article covers why testnet traction rarely converts to mainnet adoption, how to validate your onboarding flow and analytics setup before public traffic arrives, and a checklist covering product usability, wallet flows, liquidity seeding, and distribution timing to avoid the most common launch failures.
AI-Powered DeFi Analytics: A 6-Step Framework for Onchain Growth Teams to Turn Data Into Decisions
This article covers how to unify offchain and onchain data into a single queryable layer, how to filter bots and sybil wallets before analysis, and how to run the four highest-value analyses for DeFi growth teams: activation funnel breakdown, wallet cohort segmentation, retention pattern detection, and onchain campaign attribution.
DEX vs Lending vs Vaults: How Analytics Requirements Differ by DeFi Protocol Type
This article covers why applying the same retention and funnel metrics across DEX, lending, and vault protocols produces misleading data, and maps the seven analytics decisions that differ by protocol type so teams measure what actually matters for their vertical.
How to Measure DeFi Protocol Integration Impact: Integration Types, Retention Benchmarks, and ROI Scorecard (2026)
This article covers how to assess whether a DeFi protocol integration drove real growth, with a breakdown of integration types, step-by-step measurement guidance, retention benchmarks, and a scorecard for evaluating integration success.
Web3 Monthly Recap
- Stablecoins are going local by Robert Hackett and Jeremy Zhang (a16zcrypto).
- The New PMF Playbook: Three Patterns Working in Crypto Right Now by Jason Rosenthal.
- State of Onchain Credit by Patryk.
- Noncustodiality Is Not a Philosophical Question. It's a Security One by Merlin Egalite.
- Collapsing DeFi's Risk Premium by Leuts.eth.
- We raised a $2.2B crypto fund by Chris Dixon (az16crypto).
- When Abstract Becomes Concrete by Spencer Bogart.
- The long game for crypto by Chris Dixon.
- Four Business Models in Stablecoins by Jonah Burian.
- The Things That Don't Exist Yet by Spencer Bogart.
- You Can't Charge Fees on Stablecoins by Jonah Burian.
- The Machinery of Modern Finance by Brandon Kumar (Diversions).
Read our previous update HERE.
