The fundamentals
Be specific
Vague questions get vague answers. Specific questions get actionable insights.Define your terms
Don’t assume FlipsideAI knows what you mean by “whales,” “recently,” or “active users.” Define it explicitly.Thresholds
Thresholds
- Whales: greater than $100K holdings
- Retail: less than $1K holdings
- High-value transactions: greater than $50K
Time ranges
Time ranges
Use explicit dates instead of relative terms:
- ✅ “2024-01-01 to 2024-03-31”
- ❌ “recently” or “this quarter”
User categories
User categories
- Quality users: score >4 on reputation metric
- New addresses: first transaction within date range
- Active addresses: >5 transactions in period
- Power users: >20 transactions or >$10K volume
Provide chain and contract context
Always specify which chain(s) and contract(s) you want to analyze. The more context you provide upfront, the better FlipsideAI can understand your intent and deliver accurate results.- Many tokens exist on multiple chains (USDC, USDT, WETH, etc.)
- Contract addresses eliminate ambiguity completely
- Specifying chains helps FlipsideAI choose the right data sources
- Multi-chain analysis requires explicit chain names
Specify chains explicitly
Specify chains explicitly
Always include the chain name:
- ✅ “Analyze Uniswap v3 on Arbitrum”
- ✅ “Compare DEX volumes across Ethereum, Arbitrum, and Optimism”
- ❌ “Show me Uniswap activity” (which chain?)
Use contract addresses when possible
Use contract addresses when possible
Contract addresses eliminate ambiguity: - ✅ “Analyze 0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48
(USDC on Ethereum)” - ✅ “Show transfers for 0x… (UNI token) on Arbitrum” - ❌ “Show me UNI
token activity” (there are multiple UNI tokens) Even if you include the token name, adding the
contract address ensures accuracy.
Multi-chain analysis
Multi-chain analysis
When comparing across chains, be explicit about each:
- ✅ “Compare USDC transfers on Ethereum vs Arbitrum vs Polygon for Q1 2024”
- ✅ “Show me Uniswap v3 TVL on Ethereum, Arbitrum, and Optimism”
- ❌ “Compare USDC across chains” (which chains?)
Build context incrementally
Start broad, inspect the results, then narrow your focus. Think of it as a conversation, not a single query.1
Explore
”Show me DEX activity on Base"
2
Narrow
"Focus on the top 3 protocols by volume"
3
Deep dive
"Break down Uniswap swaps by token pair for the top 10 pairs"
4
Analyze
"Which pairs have the highest concentration of whale trades?”
Advanced techniques
Provide examples
Show FlipsideAI what you’re looking for:Specify output format
Tell FlipsideAI how you want to see the results:- “Show this as a time series line chart”
- “Create a bar chart comparing the top 10 protocols”
- “Format this as a table with columns for: date, protocol, volume, unique users”
- “Make this Twitter-ready with a clean, simple visualization”
Request validation
Ask FlipsideAI to double-check its work:- “Validate these results using an alternative calculation method”
- “Cross-check this TVL against DeFiLlama data”
- “Show me the query you used and explain your methodology”
Break complex questions into steps
For multi-part analyses, guide FlipsideAI through the process:Common patterns that work
Comparison questions
- “Compare DEX volumes across Ethereum, Arbitrum, and Optimism for the last 30 days”
- “Compare average transaction fees for Uniswap v2 vs v3 this month”
Trend analysis
- “Show me the daily active user trend for Aave on Ethereum over the past 90 days”
- “Show weekly stablecoin transfer volumes on Solana for Q1 2024”
Cohort analysis
- “Find addresses that first used Uniswap in January 2024, then track their monthly trading volume”
- “Find wallets that bridged to Arbitrum in Q1, then show their DeFi adoption rate”
Anomaly detection
- “Identify pools where liquidity dropped >50% in a single day over the past month”
- “Find tokens where trading volume spiked >10x compared to their 30-day average”
Working with specific data
Remember: Always provide chain and contract context upfront. See Provide chain and contract
context in the fundamentals section above.
Reference contract addresses
When in doubt, use contract addresses instead of token symbols. This eliminates ambiguity and ensures you’re looking at the right asset:- ✅ “Analyze 0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48 (USDC on Ethereum)”
- ✅ “Show transfers for 0x1f9840a85d5aF5bf1D1762F925BDADdC4201F984 (UNI token on Ethereum)“
Specify chains explicitly
Many tokens exist on multiple chains. Be explicit about which chain(s) you want:- ✅ “Compare USDC transfers on Ethereum, Arbitrum, and Polygon”
- ✅ “Show me Uniswap v3 TVL on Ethereum, Arbitrum, and Optimism”
- ❌ “Show me USDC across chains” (which chains?)
Use table names when you know them
If you’re familiar with Flipside’s data structure, reference specific tables:@ in the chat to browse available tables and datasets.
What to avoid
Pro tips
Ask 'why' questions
Ask 'why' questions
Don’t just accept the numbers. Dig in:
- “Why is this number so high?”
- “What might explain this trend?”
- “Are there any data quality issues I should be aware of?”
Request visual styles
Request visual styles
Upload an example image or describe the style you want:
- “Make this chart look like the ones in Dune Analytics”
- “Use a dark background with purple accents”
- “Create a minimalist chart suitable for a presentation”
Iterate openly
Iterate openly
If something looks wrong, say so: - “This number seems too low. Can you double-check?” - “I
expected to see more activity in December. Did we miss something?” - “This chart is hard to read.
Can you simplify it?”
Use workflows for complex analyses
Use workflows for complex analyses
For structured, methodological analyses, use Workflows:
- Type
@to browse available workflows - Workflows provide pre-trained, quasi-deterministic approaches to common analytical questions
Example prompts to try
Get inspired by these real-world prompts:- DeFi
- NFTs
- Cross-chain
- User behavior
- “Compare lending protocol TVL across Ethereum Layer 2s (Arbitrum, Optimism, Base) for Q1 2024. Include market share breakdown.”
- “Find all addresses that provided >$100K liquidity to Uniswap v3 ETH/USDC pools on Arbitrum, then track their impermanent loss.”
- “Analyze liquidation events on Aave v3 for the past 30 days: total value liquidated, top liquidated assets, and liquidator concentration.”