How Questions Are Routed
When you send a message, the AI Analyst classifies it into one of three categories:| Question Type | Workflow |
|---|---|
| Specific data requests | Standard Analysis |
| Open-ended / strategic | Deep Analysis |
| Definitions & concepts | Knowledge Retrieval |
Workflow Overview
Standard Analysis
Single-path SQL analysis for specific metrics and time ranges. One question, one query, one answer.
Deep Analysis
Multi-perspective analysis for strategic questions. Runs multiple Standard Analyses in parallel and synthesizes insights.
Knowledge Retrieval
Instant answers about metrics, tables, and concepts. Draws from SourceMedium documentation and metadata.
Choosing the Right Approach
For Data Answers
Ask specific, bounded questions:For Strategic Insights
Ask open-ended, exploratory questions:For Definitions & Concepts
Ask about metrics, tables, or how things work:Workflow Comparison
| Feature | Standard | Deep Thinking | Knowledge |
|---|---|---|---|
| Data Source | BigQuery | BigQuery | Docs + Metadata |
| SQL Queries | 1 | 2–4 | 0 (usually) |
| Parallel Execution | No | Yes | No |
| Charts | Yes | Yes | No |
| Best For | Specific metrics | Strategic questions | Learning concepts |
How Classification Works
The AI uses contextual signals to determine the right workflow: Standard Analysis triggers:- Specific time ranges (“last week”, “in January”)
- Named metrics with data requests (“revenue”, “orders”, “ROAS”)
- Rankings and comparisons (“top 10”, “vs last month”)
- Computed results (“by channel”, “trend over time”)
- “How can we improve…” questions
- “What should we focus on…” questions
- Trend analysis without specific bounds
- Strategy and optimization requests
- “What is…” or “What does…mean”
- “How is X calculated?”
- “Which table has…” or “What columns…”
- Data health and attribution health questions

