Changelog

Here are this week's highlights:

• Live View

• Text to SQL

• Ask AI Gets Smarter

• Fixes and Improvements

Live View

You can now see a realtime activity feed of your current visitors on a rotating globe. Perfect for a mission control dashboard!

Click on any user or activity in the live feed to see where they are on the map. Click again to open their profile page.

Text to SQL

You can now ask AI to write and fix SQL code based on your instructions. Just select your query and share your instructions.

Ask AI Gets Smarter

We've shipped improvements to the Ask AI feature to make it smarter, accurate, and more accessible.

Try Ask AI from any page on the dashboard and ask it any question about your data. You can even ask it to draw custom charts for your dashboard.

Track Outflows

You can now track outflows (outgoing volume) in your custom events. Simply send a negative value in your event's volume property.

track('Withdrawal', {
  volume: -100,
  token: ...,
  vault_id: ...,
})

Improvements and Fixes

• Added search bar for event property filters

• Added CSV exports to the edit chart page

• Added view all link to top apps/chains/tokens charts

• Added new explore page examples

• Added support for outflows (negative values) when tracking volume.

• Fixed issue with profile page activity pagination

• Fixed an issue in window funnel calculations

• Fixed an issue in top countries chart

• Fixed an issue with Connect X

• Fixed sorting order for paginated results

• Ask AI improvements

• Data quality improvements

• UI enhancements and fixes

This week, we've shipped features and improvements that help you better understand your users. Here are the highlights:

• User Lifecycle Detection

• User Activity Chart

• Filter Users by Multiple Apps, Tokens, Chains

• Filter Activity by Event Properties

• Funnel Breakdowns

Read on to learn more.

User Lifecycle Detection

You can now see the lifecycle stage for each user, automatically calculated based on their activity.

Here's what each lifecycle mean:

• New: These wallets represent new users engaging with your app for the first time, offering insight into acquisition success. Monitoring new wallets gauges the effectiveness of acquisition campaigns. A spike in new wallets indicates a successful campaign or marketing push.

• Returning: Users who consistently return after their first interaction. Tracking retained wallets measures user satisfaction and long-term engagement. Low retention may indicate issues with the user experience or platform value.

• Power Users: Returning ysers who very frequently used your app (on at least 5 active days out of the last 30 days.)

• Churned: Wallets that stop engaging after being active for a period of time (e.g., 30 days). This helps you spot drop-off points and potential issues with user retention. An increase in churned wallets signals a need to reassess your user engagement strategies.

• Resurrected: Wallets that were once inactive but have re-engaged with your platform. Monitoring resurrected wallets evaluates the success of your re-engagement campaigns or events that drive users back.

You can also filter users by lifecycle to create segments and audiences based on their lifecycle stage. For example, 'Show me whales who use another app X who are power users' or 'Show me high net worth wallets who have churned.'

User Activity Chart

You can now see your users' active days at a glance with the new user activity chart.

Activity charts are available on the wallet profile and anonymous profile pages.

Filter Users by Multiple Apps, Tokens, Chains

You can now apply multiple filters such as 'users who use app X and Y' for the apps, tokens, and chains filters. This enables you to create even more granular segments.

Filter Activity by Event Properties

You can now filter by event properties on the activity page.

Funnel Breakdowns

You can now breakdown funnels steps by Referrer, Country, Device, and OS.

Improvements and Fixes

• Wallet profiles: Added support for protocol tokens (e.g. Pendle YT tokens)

• Wallet profiles: Filter out spam and low-quality tokens from profiling

• Added search by token symbol to token filter

• Added new string comparison options to filters and funnels (starts with, ends with, includes)

• Added links from the overview Pages chart to the activity page

• Added links from the users page charts to apply filters

• Added anonymous users to search results when filtering by events

• Added last indexed date to wallet profile page

• Improved data platform query performance

• Improved chart loading performance on the overview page

• Improved auth token validation and refresh

• Improve device, browser, os detection

• Fixed long properties display in funnel steps filter

• Fixed UI issue with renaming dashboards

• Fixed profile breadcrumb UI missing data

• Fixed issue with filtering users

• Fixed unknown values on charts

• Miscellaneous fixes and improvements

Improved Attribution Accuracy

We've made significant improvements to attribution accuracy.

Measure onchain attribution with the greatest accuracy and data quality from Formo. Attribution works with first-touch and last-touch attribution out of the box.

More complex attribution models such as multi-touch attribution is supported through open access to your data, which you can freely query and export to support your use case.

Breakdown by Referrers

You can now see a breakdown of your metrics by referrers. Easily understand where your onchain users come from and how they find you.

Conversion Windows for Funnels

You can now specify a conversion window for your funnels.

The conversion window is the time period during which the funnel steps must be completed. The default value is 2 weeks, which means all steps must be completed within that time. Longer windows will include more event completions.

The conversion window type setting allows you to choose the type of the conversion window:

• Entire funnel - all the steps must be completed within the conversion window.

• Between each step - the maximum amount of time that can pass between each step must be within the conversion window.

Update Billing Details

You can now update your billing address and company information. Once set, your organization address, name, and tax information will be used for all future invoices.

Visit to your billing page to get started.

Improvements and Fixes

• Improved dashboard loading performance by optimizing API calls

• Improved wallet profile properties visuals and ordering for clarity

• Filtering with 'OR' clauses are now supported on the users page, for referrers, referrals, and UTM parameters.

• Fixed missing origin on revenue / volume breakdown on overview page

• Fixed an edge case with first / last onchain profiling

• Refactored retention endpoints

• Minor design and usablity improvements

Build Charts with AI

You can now use the Ask AI feature from anywhere on the dashboard. Ask AI to build you charts that you can then save them your dashboard.

SQL Editor Autocomplete

You can now use autocomplete within the SQL editor on the Explore and Edit Chart pages. With Formo, your data is yours to query, transform, and export.

Autocomplete is supported for table names, table columns, and Clickhouse SQL keywords and functions.

Filter by First-Touch and Last-Touch properties

You can now filter users by referrer, referral, and UTM properties using first-touch and last-touch attribution.

Improvements and Fixes

• Added 'sessions' units to overview page charts, in addition to 'users'

• All events now include query parameters and page fragment properties to better support apps with query-based and hash-based navigation

• Page events now have expanded query parameters in properties for more granular filtering

• Transaction events now have expanded function arguments in properties based on decoded contract data for more granular filtering

• Fixed an issue with CSV imports

• Fixed an issue with token search

• Fixed an issue with overview page redirects for first touch parameters

• Fixed an issue with Zapier integration

• Other minor fixes and improvements

NPM Trusted Publishing

Trusted publishing creates a trust relationship between npm and a CI/CD provider using OIDC. This approach eliminates the security risks associated with long-lived write tokens, which can be compromised, accidentally exposed in logs, or require manual rotation.

The Formo SDK (from 1.24.0 onwards) is now published through NPM Trusted Publishing. This improves security as each publish uses short-lived, cryptographically-signed tokens that cannot be extracted by malicious actors.

Add Contracts

You can now add contracts to enrich your project's transaction event data, even without contract events enabled.

After adding a contract, transaction events from the contract will contain enriched data including function names and function parameters. For example:

You can then use event parameters in filters, funnels, and custom dashboards.

Workspace API Keys

You can now create and manage multiple API keys to access Formo's growing set of APIs.

The Forms API is available today. The Profiles API is coming later this year.

Filters Users by Chain Net Worth

You can now filter and segment users by their net worth both on individual chains and across all chains.

Forms: Sign-in With Ethereum (SIWE)

Token-Gated Forms now uses the Sign-In With Ethereum (SIWE) standard to verify wallet ownership.

Improvements and Fixes

• Added multiple events support for behavioural segments. (Performed “connect wallet” in the last 7 days (>=1) AND did NOT perform “connect wallet” between 14 and 7 days ago (=0))

• Added 0 value ('NOT') comparisons for behavioural segments.

• Added links from overview page charts to activity and users page.

• Redesigned dropdown menus (workspace, project, account) to be consistent

• Alerts are temporarily disabled while we rework and refactor our alerting infrastructure.

• Fixed filtering by origin issue

• Fixed filtering by device bug

• Fixed copy address button edge case

• Fixed missing wallet profiles

• Fixed issue with Paddle retain and payment flow