Is there a way to find duplicate phone numbers in Marketo?

Arvind_Rangaraj
Level 2

Is there a way to find duplicate phone numbers in Marketo?

Hi,

Is there a way to find duplicate phone numbers in Marketo?

I see that duplicate Email address can be sorted using "Duplicate Field".

"Duplicate field" filter displays options for Email Address, full Name, Last Name, SFDC Type & Updated At, but no phone number.

We came across a criteria where single Lead is using different email id but same phone number.

Thanks,

Arvind. R

3 REPLIES 3
Josh_Hill13
Level 10 - Champion Alumni

Re: Is there a way to find duplicate phone numbers in Marketo?

No.

You can use external tools to handle this. Check launchpoint. Probably better handled in SFDC.

Trevor_Parsell
Level 6

Re: Is there a way to find duplicate phone numbers in Marketo?

Hey Arvind,

This may not work in every scenario (depending on the size of your database), but you can:

- Export all leads into excel and delete blank phone number rows

- Order the phone number column from largest to smallest

- Use Conditional formatting>Highlight Cells Rules>Duplicate Values

- Use Filter>Filter by color to show only the duplicate values

This will give you a view of all duplicate phone numbers in one place before deciding how to handle in Marketo/Salesforce. One potential issue is that many different leads may be using the same company phone number.

SanfordWhiteman
Level 10 - Community Moderator

Re: Is there a way to find duplicate phone numbers in Marketo?

... one potential issue is that many different leads may be using the same company phone number.

+1, sharing a phone number isn't grounds for merging when Email is different!