/
/
Find duplicate, orphaned and unreachable Salesforce contacts
For sales and ops teams who want contact data quality problems found across Salesforce, with nothing changed, by asking their AI assistant.
On this page
Connector
Connect Salesforce, pick your AI tool and paste the prompt.
The problem
Contact data that decays quietly
Salesforce contact data decays without anyone noticing: the same email on two contacts, people with no way to reach them, contacts with no account and people also sitting as open leads. Finding them by hand across thousands of records is not realistic.
Without PopdockAI
- Export contacts to a spreadsheet
- Sort and scan for duplicate emails and names
- Filter for missing email, phone or account
- Cross check leads by hand, or not at all
With PopdockAI
- Up to 2000 contacts are read and checked for you
- Duplicates, unreachable and orphaned contacts are found
- Matching open leads are flagged
- Read only, with the record to keep suggested
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Find data quality problems in contacts, optionally for account `{account-name}`.
**Step 1: Pull contacts**
Call `salesforce-get-contact` with `account-name.contains` set to `{account-name}` when given, and `max-records` 2000.
**Step 2: Check**
* **Duplicate email:** the same email (compared case-insensitively) on more than one contact.
* **Duplicate name within an account:** the same name twice under one account-id.
* **Unreachable:** no email and no phone and no mobile phone.
* **Orphaned:** no account-id.
* **Also a lead:** for contacts in the duplicate or orphaned sets, call `salesforce-get-lead` with `email` and `converted` false; an unconverted lead with the same email is a duplicate record.
**Step 3: Report**
A count per problem, then one table per problem (name, account, email, phone, owner, created date). For duplicates, group the rows and suggest which record to keep (the older one with more data) without changing anything.
**Rules & Guidelines:**
* This prompt is read-only. Do not call any write tool: `salesforce-add-account`, `salesforce-add-contact`, `salesforce-add-lead`, `salesforce-add-opportunity`, `salesforce-add-case`, `salesforce-add-task`, `salesforce-add-asset`, `salesforce-add-campaign`, `salesforce-update-account`, `salesforce-update-contact`, `salesforce-update-lead`, `salesforce-update-opportunity`, `salesforce-update-case`, `salesforce-update-task` or `salesforce-update-asset`.
* Point to `move-contact-to-account` for fixing an orphaned contact.
**Validation:**
* If the pull hits `max-records`, say the audit is partial.Who it's for
One answer, three teams that use it
Sales operations
Find the clean up work in one pass
Get counts and tables for every contact data problem, with duplicates grouped.
Check our Salesforce contacts for duplicate emails, missing phone and email, and contacts with no account.
CRM administrators
Plan merges with confidence
See duplicate groups with the record worth keeping suggested before you merge anything.
Find duplicate contacts in Salesforce and tell me which record to keep in each group.
Account managers
Tidy up your own accounts
Audit the contacts on one account before a campaign or renewal.
Audit the contacts on the Contoso account for duplicates and people we cannot reach.
How it works
What PopdockAI does when you ask
You optionally name an account, and your AI assistant audits the contacts for common data problems. It changes nothing and tells you if the audit is partial.
01
Ask
You optionally name an account.
02
Read
It reads up to 2000 Salesforce contacts.
03
Check
It looks for duplicates, unreachable and orphaned contacts, and matching open leads.
04
Report
You get a count and table per problem, with the record to keep suggested.
What PopdockAI provides
The tools behind the answer
Ready made tools for Salesforce and one secure connection to your AI tool. No code, no exports.
salesforce-get-contact
salesforce-get-lead
This report is built from Get data tools only. PopdockAI applies the row, field and parameter rules your admin sets, and every query is written to the audit trail.
The outcome
A clear list of what to merge and fix
Related use cases
More ways to put this data to work
Capture a new Salesforce lead
Ask your AI to add a lead to Salesforce and it checks existing leads, contacts and accounts first, then creates the lead or updates the existing one only after you confirm.
Learn More
Create a Salesforce account with a contact
Ask your AI to create a Salesforce account with a contact and it checks for existing accounts, contacts and leads, then creates and links both only after you confirm.
Learn More
Create Salesforce leads from tagged Drip subscribers
Ask your AI to create Salesforce leads from tagged Drip subscribers and it skips anyone already a contact or lead, proposes the rest and creates them after you confirm.
Learn More
Flag Salesforce contacts who unsubscribed or bounced in Constant Contact
Ask your AI which Salesforce contacts unsubscribed or bounced in Constant Contact and it matches each address to a contact or lead and owner, with live deals first.
Learn More
Flag Salesforce contacts who unsubscribed or bounced in Mailchimp
Ask your AI which Salesforce contacts unsubscribed or bounced in Mailchimp and it matches each address to a contact or lead and lists the campaigns that still include them.
Learn More
One prompt template with infinite possibilities.
Your AI assistant adapts its approach, tone, and capabilities to match each unique context while you maintain a single, manageable workflow.
Join forward-thinking companies that are transforming their operations with intelligent, secure AI automation.