Repeat Customer Rate
Measure customer loyalty by tracking repeat purchase behavior.
“What percentage of orders are from repeat customers?”
Expected Insight
Overall repeat purchase rate plus monthly trend, average orders per repeat customer, and time between purchases.
Prompt variations
Try these follow-up prompts to explore your data further.
“Break down by channel”
“Compare to industry benchmarks”
“Show cost per acquisition”
“Filter to campaigns over $1,000 spend”
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
Top Marketing Campaigns by ROI
Evaluate which campaigns deliver the best return on investment.
Email Campaign Performance
Analyze open rates, click rates, and conversions across email campaigns.
Lead Source Attribution
Understand which lead sources drive the most qualified pipeline.
Top Customers by Revenue
Identify your highest-value customers for the current quarter.
Try this prompt in AI for Database
Connect your database and get answers in seconds. No SQL required.