What It Does
The SQL query editor is for operators and analysts who need more precision than simple rule builders. It is especially useful when you want to combine onchain behavior, audience state, and messaging history in one cohort definition.Common Questions To Answer
- Which wallets interacted with a contract recently but have not converted?
- Which contacts clicked a campaign and then returned onchain?
- Which users have high-value wallet activity but low recent engagement?
- Which cohort should move into a campaign, report, or automation next?
What You Can Query
The current intelligence model supports tables for audience and delivery analysis such as contacts, delivery events, audience profiles, audience segments, campaigns, user onchain metrics, wallet activity summary, and NFT holdings.Query Workflow
- Start from a known table or starter query.
- Limit the date range while iterating.
- Validate a few rows manually.
- Save the result as a report or segment.
- Reuse the output in campaigns or automation handoff.