✅ Metric Lookups
“What is the total revenue in Q1 2024?”
|❌ External KPIs (not in your database)
“How much is the GDP of the USA?”
| |✅ Time-Based Aggregations
“Show sales by month this year”
|❌ Real-Time World Data
“What’s the weather like today?”
| |✅ Top/Bottom Filters
“Show top 10 products by revenue”
|❌ Industry Benchmarks
“How does my sales compare to the industry average?” (unless stored in your own data)
| |✅ Comparisons
“Compare revenue this year vs last year”
|❌ Access Limitations / System Questions
“Why aren’t you giving me access to external data?”
| |✅ Anomaly or Trend Detection
“Identify top 3 churn spikes in 2023”
|❌ Social Prompts
“How are you today, Connecty AI?”
| |✅ Customer Segmentation
“List high-value customers by region”
|❌ Live Market Data
“Tell me the price of Tesla stock”
| |✅ Funnel/Drop-off Analysis
“What is the drop off rate in the onboarding funnel from trial to conversion page?”
|❌ UI Troubleshooting
“Why is this question not working?”
| |✅ Drilldowns
“Break down revenue by campaign grouped by region”
|❌ General Business Advice
“Can you help me write a business plan?”
| |✅ Metric Definitions
“What is Customer Lifetime Value?”
|❌ Cross-Workspace Data Access
“Give me data from another data workspace”
| |✅ Filters
“Only show customers from Germany”
|❌ Sentiment/Opinion Analysis (outside DB)
“What do people think of our pricing model?”
| **More examples from** [**TPCH**](https://docs.snowflake.com/en/user-guide/sample-data-tpch) **dataset**| Topic | Metric Question |
| Supplier analytics | Average fulfillment time by supplier and customer nation for parts from Asia region suppliers grouped by part type |
| Supplier analytics | Gross margin per part category from suppliers who shipped parts with discount over 5% |
| Supplier analytics | Late shipment rate by supplier region and part size category grouped by nation and year |
| Supplier analytics | Total number of parts supplied by high-value-order suppliers segmented by part brand |
| Supplier analytics | Profit margin from parts supplied by top 10 European suppliers segmented by customer segment |
| Customer analytics | Average order value per part category for 'Automotive' segment customers ordering from European suppliers |
| Customer analytics | Total profit per supplier from orders by customers who only ordered in the last 3 years |
| Customer analytics | Average order value by part type for delayed shipments to Asian customers ordering German parts |
| Customer analytics | Number of unique suppliers per customer segment in orders containing discounted parts |
| Customer analytics | Customer lifetime discount amount grouped by region |
| Order analytics | Average line item count per part category in orders from 1995 with Japanese suppliers and European customers |
| Order analytics | Total discount amount by supplier nation for orders over $20,000 with average line item count analysis |
| Order analytics | Average part cost grouped by region in multi-supplier orders with at least 3 suppliers and higher cancellation rates |
| Order analytics | Supplier count per order for fast-shipped orders (under 10 days) containing at least 5 distinct parts with average part cost analysis |
| Order analytics | Gross margin segmented by part brand for orders with line items sourced from multiple regions |
| First/last order analytics | Total number of suppliers engaged by customers active for over 5 years and their first-to-last order time gap |
| First/last order analytics | Average line item discount in first orders per customer segment by supplier region |
| First/last order analytics | Total part cost grouped by part category in last orders for customers with decreasing order frequency and high discount rates |
| First/last order analytics | Difference in gross margin and order value between first and last orders per supplier segmented by customer segment |
| First/last order analytics | Average part discount grouped by part type in first orders from new suppliers in each region |