How it works
The Ask AI feature provides an intelligent analytics assistant that can:- Generate queries: Ask questions in natural language and get SQL queries automatically generated
- Explore patterns: Discover trends and patterns in your data that might not be immediately obvious
- Surface anomalies: Identify unusual behavior or outliers in your metrics
- Recommend actions: Get actionable insights and recommendations based on your data
- Build charts: Create custom charts and save them to your dashboard
- Text to SQL: Write and fix SQL code based on your instructions
Access Ask AI
Use Ask AI from anywhere on the dashboard. Ask it any question about your data, or ask it to draw custom charts for your dashboard.Getting started
- Navigate to any analytics dashboard in your Formo workspace
- Look for the “Ask AI” button or chat interface
- Type your question in natural language, such as:
- “What are my top performing acquisition channels this month?”
- “Show me users who dropped off in the signup funnel”
- “Which wallets have the highest transaction volume?”
- “Are there any unusual patterns in my recent activity?”
Use cases
Data exploration
Ask AI can help you explore your data without needing to know SQL or complex analytics queries. Simply describe what you want to understand, and the AI will generate the appropriate analysis.Pattern recognition
The AI can identify trends, seasonality, and patterns in your user behavior, transaction data, and conversion metrics that might be difficult to spot manually.Anomaly detection
Get alerts about unusual spikes, drops, or changes in your key metrics, along with potential explanations for what might be causing them.Actionable insights
Beyond just showing you data, Ask AI provides context and recommendations for what actions you might take based on the insights discovered.Best practices
- Be specific: The more specific your questions, the better the AI can help you
- Provide context: Mention time periods, user segments, or specific metrics you’re interested in
- Follow up: Ask follow-up questions to dive deeper into interesting findings
- Validate insights: Always review the AI’s findings and validate important insights with your domain knowledge
10 questions to ask your data
Ask AI helps you explore your data without writing SQL. This guide provides practical prompts for common analytics tasks.How to use Ask AI
- Click Ask AI from anywhere in the dashboard
- Type your question in natural language
- Review the generated query and results
- Save useful charts to your dashboard
Essential questions for every crypto app
Here are 10 questions to ask about your data:1. User acquisition
Prompt: “Where are my users coming from this month?” What you’ll learn: Top referrers, UTM sources, and traffic channels. Follow-up: “Which referrer has the best conversion rate?“2. Daily active users
Prompt: “Show me daily active wallets for the last 30 days” What you’ll learn: DAU trend with day-over-day changes. Follow-up: “Compare this to the previous 30 days”3. Conversion funnel
Prompt: “What percentage of visitors connect their wallet?” What you’ll learn: Top-of-funnel conversion rate. Follow-up: “Of those who connect, how many complete a transaction?“4. User retention
Prompt: “What’s my week-1 retention rate?” What you’ll learn: How many users return after their first visit. Follow-up: “Show me retention by acquisition source”5. Revenue analysis
Prompt: “What’s my total transaction volume this month?” What you’ll learn: Revenue/volume metrics and trends. Follow-up: “Break this down by day of week”6. User segments
Prompt: “How many whales (net worth > $100k) do I have?” What you’ll learn: High-value user count. Follow-up: “What’s their average transaction volume?“7. Geographic distribution
Prompt: “Which countries have the most active users?” What you’ll learn: Geographic breakdown of your user base. Follow-up: “Which country has the highest average transaction value?“8. Feature adoption
Prompt: “How many users visited the /stake page this week?” What you’ll learn: Feature page traffic. Follow-up: “Of those, how many completed a staking transaction?“9. Drop-off analysis
Prompt: “Where do users drop off in the transaction flow?” What you’ll learn: Conversion bottlenecks. Follow-up: “Is drop-off higher on mobile or desktop?“10. Anomaly detection
Prompt: “Are there any unusual patterns in my data this week?” What you’ll learn: Spikes, drops, or outliers worth investigating. Follow-up: “What might have caused the spike on Tuesday?”Power user prompts
Once you’re comfortable, try these advanced prompts: Cohort analysis:“Compare retention rates for users acquired from Twitter vs Discord”Revenue attribution:
“Which UTM campaign drove the most transaction volume?”User behavior:
“What do power users do differently than churned users?”Competitive insights:
“How many of my users also use Uniswap?”Time patterns:
“What time of day do most transactions happen?”
Tips for better results
| Tip | Example |
|---|---|
| Specify time ranges | ”…in the last 7 days” vs “…recently” |
| Name metrics clearly | ”daily active wallets” vs “users” |
| Include thresholds | ”net worth > $10,000” vs “wealthy users” |
| Ask for comparisons | ”Compare X to Y” vs “Show me X” |
From question to dashboard
When you find a useful insight:- Click Save to Dashboard
- Name the chart descriptively
- Add it to your main dashboard
- Set up a recurring refresh