Skip to main content
The Explorer gives you direct SQL access to your analytics data. Run custom queries, build complex analyses, and answer questions that go beyond pre-built dashboards.
Explorer SQL Editor

The Explorer query editor lets you run SQL against your analytics data.

​
When to use the Explorer

Use the Explorer when you need:
  • Ad-hoc analysis for specific questions
  • Custom calculations that aren’t available in standard dashboards
  • Complex joins across multiple data types
  • Testing queries for custom charts and dashboards
  • Data validation to verify metrics

​
Running queries

​
Step 1: Open the Explorer

  1. Go to the Formo Dashboard
  2. Select your project
  3. Click Explore in the left navigation

​
Step 2: Write your query

Enter your SQL query in the editor. Formo uses ClickHouse SQL syntax. Example: Daily active wallets 
SELECT
  toDate(timestamp) AS date,
  countDistinct(address) AS daily_active_wallets
FROM events
WHERE type = 'connect'
  AND timestamp >= now() - INTERVAL 30 DAY
GROUP BY date
ORDER BY date

​
Step 3: Run and visualize

  1. Click Run to execute your query
  2. View results in the table below
  3. Optionally, switch to chart view to visualize the data

​
Available tables

TableDescription
eventsAll user interaction events (page views, wallet events, custom events, contract events)
usersAggregated wallet user profiles identified by address, with attribution and engagement metrics
anonymous_usersProfiles for users who haven’t connected a wallet yet, identified by anonymous_id
identitiesIdentity graph linking anonymous user IDs to wallet addresses and user IDs
revenueFinancial metrics and revenue with full attribution context
sessionsAggregated user session data with engagement metrics and attribution
sourcesDaily aggregated traffic source metrics and attribution data
wallet_profiles_mvComprehensive global wallet profile data aggregated across all chains
wallet_profiles_chains_mvWallet profile data broken down by individual blockchain networks
wallet_profiles_chains_apps_mvWallet DeFi application usage data broken down by blockchain
wallet_profiles_chains_tokens_mvWallet token holdings data broken down by blockchain
wallet_profiles_eventsTimestamped wallet profiling events from external offchain and onchain analysis

​
Tips

  • Use LIMIT to avoid returning too much data
  • Use date filters to improve query performance
  • Reference the Event Spec for available event properties
  • Use Ask AI to help write and fix queries

​
Saving queries

After writing a useful query, save it as a chart on your custom dashboard:
  1. On the Dashboards page, select an existing board or create a new one
  2. Add a new chart by clicking Add Chart
  3. Paste your query into the SQL editor and run it
  4. Choose a visualization type (line, bar, table, etc.)
Your query becomes a reusable chart on your dashboard that you can share with your team.

​
Next steps

Dashboards

Save queries as dashboard charts

Event Spec

Understand available event properties

AI Assistant

Let AI help write queries

Data Schema

Full data warehouse schema