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.â