Is there a way to find duplicate phone numbers in Marketo? | Community
Skip to main content
Arvind_Rangaraj
Arvind_Rangaraj
Level 2
August 16, 2017
Question

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

  • August 16, 2017
  • 2 replies
  • 2014 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

Josh_Hill13
Josh_Hill13
Level 10
August 16, 2017

No.

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

Trevor_Parsell
Trevor_Parsell
Level 5
August 16, 2017

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
    SanfordWhiteman
    Level 10
    August 16, 2017

    ... 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!

    Terms & ConditionsAccessibility statement

    Loading footer...