Results Don’t Match Expectations
The numbers seem wrong
Check the date range in the SQL
Review the generated SQL query. The AI Analyst may have interpreted your time range differently than you intended. “Last week” could mean the previous 7 days or the previous calendar week.
Verify the metric definition
Confirm the AI used the metric you expected. “Revenue” might be gross or net depending on context. Check the SQL to see exactly what was summed.
High (direct) / (none) in results
This indicates an attribution issue, not a query issue. The AI Analyst is correctly reflecting what’s in your data.Attribution Health
Learn how to diagnose and improve attribution coverage.
The AI Misunderstood My Question
It answered a different question
Rephrase with more specificity:| Instead of | Try |
|---|---|
| ”How are we doing?" | "What was our revenue last 30 days vs. the previous 30 days?" |
| "Show me sales" | "Show me daily order count for the past 2 weeks" |
| "Best products" | "Top 10 products by revenue this month” |
It used the wrong table
If the AI queried the wrong data source, clarify the domain:| Instead of | Try |
|---|---|
| ”Show me performance" | "Show me ad performance by platform" |
| "Customer data" | "Show me new customer acquisition by week” |
No Results Returned
”No data found” or empty results
- Check the date range — You may be querying a period with no activity
- Check filters — The AI may have applied filters that excluded all rows
- Check Data Health — The table may be empty or not yet populated for your account
Query timed out
Complex queries against large date ranges may time out. Try:- Narrowing the date range
- Asking for aggregated data instead of row-level details
- Breaking the question into smaller parts
Chart Not Generated
The AI Analyst generates charts when visualization adds value. Charts may not appear when:- The result is a single number (e.g., “total revenue was $142,350”)
- The data structure doesn’t lend itself to visualization
- There was an error generating the chart
Slow Responses
Response time depends on:- Query complexity — Aggregations across large date ranges take longer
- Table size — Some tables have more data than others
- Current load — Occasional delays during peak usage
The AI Said It Can’t Help
The AI Analyst is designed for e-commerce analytics questions. It will decline requests that:- Ask about data outside your BigQuery warehouse
- Request actions (modifying data, sending emails, etc.)
- Are unrelated to analytics (general knowledge questions)
Common Questions
Can I ask follow-up questions?
Can I ask follow-up questions?
Yes. Follow-up questions are supported in Slack threads.
- In DM, you can ask follow-ups naturally.
- In channels, mention the bot with
@SourceMediumfor follow-up analysis (for example,@SourceMedium what were sales yesterday?).
Why can’t I switch stores in the same thread?
Why can’t I switch stores in the same thread?
In multi-store tenants, once a store is confirmed, that thread stays on that store. This prevents mixed-store analysis in the same thread. Start a new thread to switch stores.You can view your available stores in Data Availability Report. The list is shown by
sm_store_id (see the Glossary).Why did my typed reply confirm the store?
Why did my typed reply confirm the store?
If a thread is waiting for store confirmation, any reply in the thread (for example, “yes” or typing a follow-up question) is treated as confirmation so analysis can continue. After confirmation, the question you already asked runs automatically.
Why didn’t the bot answer my channel thread reply without @mention?
Why didn’t the bot answer my channel thread reply without @mention?
In channels and private channel threads, follow-up analysis requires mentioning the bot with
@SourceMedium. If you reply without that mention, the bot won’t run a new analysis turn.Why did it ask me to run analysis first before summarizing?
Why did it ask me to run analysis first before summarizing?
Summary and recommendation prompts depend on prior analysis in the same thread. If that thread does not have enough prior analysis context, the AI asks you to run analysis first.
Why did it miss an older detail from this thread?
Why did it miss an older detail from this thread?
Continuity in a thread is condensed so follow-ups stay fast and reliable. In long threads, some older details may be compressed. If an older detail matters, restate it directly in your next prompt.
How do I reset context?
How do I reset context?
Start a new thread to reset context.
How often does data refresh?
How often does data refresh?
Most tables refresh daily. Our SLA guarantees fresh data through yesterday based on your reporting timezone. Today’s data is not guaranteed. See Data Health for details.
Can I export the results?
Can I export the results?
Yes. Each response includes downloadable files:
query.sql (the SQL used), results.csv (full data), and the chart image if one was generated.Can multiple people use it at once?
Can multiple people use it at once?
Yes. Anyone in your Slack workspace with access to the bot can ask questions simultaneously. There’s no queue or limit on concurrent users.
Why do I see different results than my teammate?
Why do I see different results than my teammate?
You shouldn’t — everyone queries the same underlying data. If results differ, check:
- Are you asking about the same time range?
- Are you using the same metric definition?
- Did the data refresh between queries?
Multi-store thread scoping
Learn selector prompts, confirmation, lock rules, and channel mention requirements.
Thread continuity and follow-ups
See what the AI remembers in the same thread and how to reset context.
Getting More Help
If you’re stuck:- Check the SQL — The generated query often reveals how the AI interpreted your question
- Try a simpler question — Start basic, then add complexity
- Ask about schema — “Which table has order data?” can help you understand the data structure
- Contact support — Reach out to your SourceMedium team for persistent issues