Inactive Customers
Find customers at risk of churning based on inactivity.
“List customers who haven't ordered in 90 days”
Expected Insight
A list of inactive customers with last order date, total lifetime value, and previous order frequency to prioritize outreach.
Prompt variations
Try these follow-up prompts to explore your data further.
“Break down by customer segment”
“Add revenue at risk for each”
“Show the trend over the past year”
“Include engagement scores”
Tips for best results
Be specific with time ranges
Instead of "recently," say "in the last 30 days" or "this quarter." Specific dates produce more accurate results.
Name your dimensions
Say "by region" or "grouped by sales rep" to get the breakdowns you need. The AI works best with explicit grouping.
Ask for the format you want
Request "as a bar chart," "in a table," or "as a percentage" to get results in the format that is most useful to you.
Use follow-up questions
After your first answer, drill deeper with "Why?" or "Break this down further." The AI remembers context.
Related prompts
Monthly Churn Rate
Track customer churn trends over the past 6 months.
Support Ticket Resolution Time
Analyze support performance by ticket priority level.
Customer Lifetime Value by Channel
Understand which acquisition channels deliver the most valuable customers.
NPS Score Trend
Track Net Promoter Score changes and identify improvement areas.
Try this prompt in AI for Database
Connect my database and get answers in seconds. No SQL required.
Free plan available · No credit card required