Duplicate Mobile Number | Community
Skip to main content
D
dpatil36
Level 2
June 19, 2024
Question

Duplicate Mobile Number

  • June 19, 2024
  • 1 reply
  • 2140 views

Hello,

 

We have an SMS campaign that we run using a list in Marketo but constantly facing issues due to duplicate mobile numbers which is causing the members to receive single SMS multiple times.

 

The "Duplicate Field" filter does not contain "Mobile Number" as a criteria to merge/delete numbers.

 

I know we can achieve this by exporting-cleaning and then importing it back to Marketo.

 

But we are looking for a way to achieve this in Marketo itself since new members are added to this list on a daily basis.

 

Will look forward to your inputs.

 

Thanks in advance! 

Dheeraj

 

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

    1 reply

    uditmathur
    Community Advisor
    uditmathurCommunity Advisor
    Community Advisor
    June 19, 2024

    Hi,

    By default Marketo uses Email address as a unique identifier lookup key hence by using "possible duplicates" you can not track mobile numbers.

    You will have to achieve this outside of marketo.

    A word of caution though... Make sure to check the email id of the records with same mobile number as there might be cases in your database which have same mobile number but different email ids & then this will create issues if you delete the record which might have updated email id.

      D
      dpatil36Author
      Level 2
      June 19, 2024

      Thank you Udit.

       

      Yes, I do have the same concern where we have same mobile number but different email addresses, so will take care of that.

      However, I am wondering if anything can be done in Marketo like "remove from the list if the email already exists in the list" which I am not able to execute in Marketo.

       

      Also, another concern for me: The list contains 12k records and when I put in the Duplicate: Email Address" filter, it is showing 7500 records which is not possible. Any inputs why this could be happening?

       

      Appreciate your guidance.

      SanfordWhiteman
      SanfordWhiteman
      Level 10
      June 19, 2024
      Also, another concern for me: The list contains 12k records and when I put in the Duplicate: Email Address" filter, it is showing 7500 records which is not possible.

      Don’t understand. How are you proving it’s “not possible”? Should be very simple to export that Smart List and see that the records in it are indeed members of duplicate sets. All the dupes are there in the file!

      Terms & ConditionsAccessibility statement

      Loading footer...