Note: View a curated set of ready-to-use prompts, variants and example outputs in the Ometria Deep Insights Agent prompt library.
Revenue and orders
Simple
- "What's the split between first-time buyer revenue and repeat customer revenue?"
- "How much discount did we give away last month, and what percentage of orders used a discount?"
- "Break down our revenue by channel — online vs instore"
Intermediate
- "Which days of the week consistently drive the highest revenue?"
- "How has our average basket size changed over the past 6 months — are customers buying more items per order or fewer?"
- "What's our refund rate trend — is it getting better or worse?"
Advanced
- "What does our order value distribution look like? Are most orders clustered in a particular price range?"
- "What's the average discount rate for first-time buyers vs repeat customers — are we over-discounting to acquire?"
- "Show me revenue by channel and by new vs repeat customer — where is each channel's growth coming from?"
Campaign performance
Simple
- "Which campaigns drove the most revenue this month?"
- "How does our broadcast campaign performance compare to our automations?"
- "What's our revenue per email sent — and which campaigns are most efficient?"
Intermediate
- "Which of our welcome series emails are underperforming on click-through rate?"
- "Are our abandoned basket automations actually converting? Show me sends, clicks, and attributed revenue"
- "How much of our total revenue is attributable to email vs organic orders?"
Advanced
- "Across all campaigns last quarter, which had the best ratio of revenue to unsubscribes?"
- "Do campaigns using product recommendations outperform those without?"
- "Show me a weekly trend of automation revenue by trigger type — which flows are growing and which are declining?"
Customer health
Simple
- "Are we acquiring new customers faster than we're losing them to lapse?"
- "What's the average time between a customer's first and second order?"
- "What percentage of our customer base is contactable by email vs SMS right now?"
Intermediate
- "Which acquisition cohort has the best repeat purchase rate — are newer customers more or less loyal than older ones?"
- "Of customers who went at-risk in Q3, how many have since lapsed vs been saved?"
- "What's our customer lifetime value distribution — where are the biggest concentrations?"
Advanced
- "What's our 12-month repeat rate by acquisition quarter — is it improving over time?"
- "How do customers acquired via campaigns compare to organic acquirers on lifetime value?"
- "Show me a net customer health waterfall: new customers in, at-risk out, lapsed out, won back in — what's the net change each month?"
Product performance
Simple
- "Which products have the highest refund rates?"
- "What's the average selling price by category — where are we most premium?"
- "How has our brand ranking changed compared to last quarter?"
Intermediate
- "Show me revenue by product category and month — are any categories trending up or down?"
- "Which product types are growing fastest in units sold vs 6 months ago?"
- "Do orders containing accessories have a higher AOV than orders without?"
Advanced
- "Which products are most frequently bought together in the same order?"
- "What's the category mix difference between first-time buyer orders and repeat customer orders?"
- "Show me products where units are growing but revenue is flat or declining — are we discounting them too heavily?"
Site traffic
Simple
- "Which traffic sources drive the most visits, and which ones actually convert?"
- "What's our visit-to-order conversion rate by device type?"
Intermediate
- "How has our conversion rate by traffic source changed month-over-month?"
- "Which traffic sources bring in customers who go on to place repeat orders?"
Advanced
- "What's the average session depth and duration by traffic source — which channels bring the most engaged visitors?"
- "Show me campaign-driven visits vs campaign-attributed orders — where are we losing people between click and purchase?"
Comments
0 comments
Article is closed for comments.