gm, builders! 👋
Here’s your roundup of this week's onchain news and growth insights.
Highlights:
Updates: SQL Query API and Platform Upgrade
Updates: Contract Events Pipeline
Updates: Explore Page and Charts
What are Wallet Profiles? A Complete Guide for Beginners
Web3 CRMs: Transforming Onchain Customer Management
Web3 Weekly Recap
New SQL Query API
You can now query all events and tables in the Formo data warehouse via the SQL Query API.
Major Platform Upgrade
We’ve launched a big update to our event schema, aligned with top industry standards (Rudderstack, Mixpanel, Segment, and more).
Contract Events Pipeline
You can now track and analyze smart contract events across chains in real-time. Add your contract address in project settings to start ingesting events.
Explore Page and Charts
Query your event and wallet profile data directly with custom SQL on Formo. Turn SQL queries into a mission control dashboard for your entire team from product to marketing.
Wallet profiles are pseudonymous, data-rich user identities built around crypto wallet addresses.
What’s Inside:
ENS, wallet address, transaction history
Token balances & DeFi positions
dApp usage & activity feed
Traits like “DEX Trader,” “NFT Collector”
Referral source (e.g., Twitter, Farcaster)
Web3 CRMs are a new kind of customer platform that helps you track, engage, and grow your community using onchain intelligence.
What Makes Web3 CRMs Different:
Real-time wallet insights
Segment users by token holdings, NFT activity, and more.
Track churn signals such as asset withdrawals
Connect wallet & offchain engagement into one view
Send direct messages to wallets.
