Example questions across different analytical domains
The AI Analyst understands natural language questions about your e-commerce data. This page shows example questions organized by domain to help you get started.
Be specific about time ranges when possible. “Last 30 days” is clearer than “recently.”
Questions about sales, order volume, and revenue metrics.
What was our total revenue last month?Show me daily revenue for the past 2 weeksHow many orders did we have yesterday?What's our average order value this quarter vs last quarter?Top 10 days by revenue in 2024What was our revenue by channel last week?How much did we discount last month?
Questions about customer acquisition, retention, and behavior.
How many new customers did we acquire last month?What's the split between new and repeat customers this year?Show me new customer acquisition by week for the past 3 monthsHow many customers placed more than one order?What's our repeat purchase rate?
Questions about advertising performance and marketing spend.
What was our ROAS by channel last month?Show me ad spend by platform for the past 30 daysWhich campaigns had the best ROAS last week?What's our cost per acquisition by channel?Top 10 campaigns by attributed revenueHow much did we spend on Meta ads in January?
Questions where you want the underlying rows or specific fields returned as a CSV.
Pull order ID, order date, customer email, UTM source, UTM medium, and revenue for last weekGive me raw orders from yesterday with discount code, channel, and net revenueExport customers acquired in March with email, first order date, and lifetime revenueShow line items for SKU ABC-123 from the past 30 daysPull campaign-level spend, clicks, impressions, and campaign name for TikTok last month
Raw data pulls work best when you name:
The time range
The fields or entity you want
Any filters, such as product, campaign, store, or channel
Use raw data pull wording when you want the data itself. If you want interpretation, ask an analysis question like “What are the trends in orders by UTM source?”
Top 10 email campaigns by attributed revenue last 30 daysWhat's our email open rate trend?Which SMS campaigns drove the most orders?Show me email performance by campaign type
Top 10 products by units sold this monthWhich products have the highest revenue?What's our best-selling product by channel?Show me product performance for [specific SKU]
Questions about what metrics mean, where data lives, and how SourceMedium works. These are answered using our documentation — no SQL required.
What is LTV?How do you calculate conversion rate?What does ROAS mean?Which table has order data?What columns are in the orders table?Where do I find email performance data?How does attribution work?What's the difference between first-click and last-click?How do I set up UTM tracking?What are the possible values for order_type?
Instead of “recently” or “lately,” use specific ranges like “last 7 days,” “in January,” or “Q4 2024.”
Name the metric you want
“Revenue” is clearer than “sales.” “Orders” is clearer than “transactions.” Use the terminology from your dashboards.
Ask one thing at a time
Complex multi-part questions work better as separate queries. Ask “What was our revenue last month?” then “How does that compare to the previous month?”
Use pull/export language for raw data
“Pull order ID, date, UTM source, and revenue for last week” tells the AI Analyst to return rows and attach a CSV instead of writing an interpretive analysis.
Use 'top N' for rankings
“Top 10 products by revenue” is specific. “Best products” is ambiguous.
