Duplicate Contact Records
Clean your CRM by finding duplicate entries in the contacts table.
“Find duplicate records in the contacts table”
Expected Insight
Groups of potential duplicate contacts matched by email, phone, or fuzzy name matching, with a confidence score for each match.
Prompt variations
Try these follow-up prompts to explore your data further.
“Group by warehouse location”
“Show trends over the last 6 months”
“Include supplier information”
“Add cost impact estimates”
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
Shipping Delay Analysis
Find all orders with shipping delays to improve fulfillment.
Inventory Below Reorder Point
Prevent stockouts by identifying items that need reordering.
Employee Utilization Rates
Measure how effectively team capacity is being used across departments.
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.