Smart list, email de-dupe | Community
Skip to main content
A
Anonymous
July 8, 2015
Question

Smart list, email de-dupe

  • July 8, 2015
  • 4 replies
  • 4245 views

Hi guys

I've used Marketo previously, and have been using Eloqua more recentley, however am now back where my heart belongs - Marketo

Can anyone help? Our unique contact field is something called our 'registration key' - not email address/ID. When I look at all the members in my smart list, is it possible to remove duplicate email addresses so I can get a true count of how many unique contacts are in the smart list?

Thanks!

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

4 replies

A
Anonymous
July 8, 2015

I run into the same problem as we have a duplicate issue with our Contacts. Haven't found something that would remove duplicates or give you the unique number. I usually have to export to excel and run the "remove duplicates" function.

    A
    Anonymous
    July 9, 2015

    Hannah Whyte​ I moved your post to the Products and Support​ section of the site.....AND .. welcome back to Marketo...

    Elliott_Lowe1
    Elliott_Lowe1
    Level 7
    July 9, 2015

    Do you want to remove duplicate emaill addresses from your report or from Marketo?  I'm concerned that you do not use email address as the unique key as that is a key part of Marketo's architecture.  Why would you want multiple records with the same email address, but different 'registration keys'?  With multiple records with the same email address, you run the risk of sending the same email to the same person multiple times at the same time.

    A
    Anonymous
    July 10, 2015

    >> With multiple records with the same email address, you run the risk of sending the same email to the same person multiple times at the same time.

    This is not possible in Marketo (in the same Smart Campaign).  Only one email will be sent to an email -  Marketo de-dupes at point of send.

    It would be best to de-dupe your data in order to understand the counts better. I know, in your case that dupes are a necessary evil but the less you have the better!

    Elliott_Lowe1
    Elliott_Lowe1
    Level 7
    July 10, 2015

    Thanks @Neil Robertson-Ravo​, I just learned something new!  Although the duplicates are listed as campaign members of the smart campaign, indeed only one of them is sent the email.  Do you know how Marketo decides which lead gets sent the email and is this the case all of the time?  If not, then your email data will be spread across the duplicate leads, which would have additional negative consequences.

      A
      Anonymous
      September 22, 2015

      For duplication, I think you can try TIBCO Clarity. It has a really powerful and robust de-duplication function.

      You can customize your match strategies by columns or by swappable columns or by columns against to a thesaurus table, and then use them to discover duplicate records from any incomplete or partially similar records, even from records in different languages.

      In addition, It has deep integration with both Salesforce and Marketo. It can help you directly update and remove duplication data in your salesforce and Marketo account.

      you can try TIBCO Clarity for free.   clarity.cloud.tibco.com/landing/index.html

      Terms & ConditionsAccessibility statement

      Loading footer...