How to update mass amounts of email addresses when a company changes email addresses, without creating duplicate/separate leads? | Community
Skip to main content
A
Anonymous
June 17, 2016
Solved

How to update mass amounts of email addresses when a company changes email addresses, without creating duplicate/separate leads?

  • June 17, 2016
  • 1 reply
  • 14941 views

Hi,

We have come across this several times, and I would imagine others would be dealing with this as well... In the cases of mergers and acquisitions, occasionally companies change their email addresses (specifically after the @symbol). i.e. first.last@company1.com changes now to first.last@company2.com.

We don't know how to go about making a mass change (2000+ contacts) for a company that recently experienced this.

We know we cant export and adjust easily in Excel and reimport, since email address is the unique identifier in Marketo - that would then create entirely new contacts in Marketo.

What is the best way to update mass amounts of email addresses within Marketo without creating duplicate/separate leads?

Can you run a smart list? Can you import with specific data added to a file to ensure a duplicate isn't created?

What are our options?

Thanks,

Chelsie

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by Grégoire_Miche2

    Hi Chelsie,

    Create a "new email address" field. populate this field whith your import, not the email address field. Then run a smart campaign:

    Smart list:

    • filter: New email address is not empty

    Flow

    • Change data value: attribute: email address, new value: {{lead.new email address}}
    • Change data value: attribute new email address, new value: NULL

    -Greg

    1 reply

    Grégoire_Miche2
    Grégoire_Miche2Accepted solution
    New Participant
    June 17, 2016

    Hi Chelsie,

    Create a "new email address" field. populate this field whith your import, not the email address field. Then run a smart campaign:

    Smart list:

    • filter: New email address is not empty

    Flow

    • Change data value: attribute: email address, new value: {{lead.new email address}}
    • Change data value: attribute new email address, new value: NULL

    -Greg

      A
      Anonymous
      June 8, 2017

      Is there a video to show step by step, im confused on how to do that

      SanfordWhiteman
      SanfordWhiteman
      New Participant
      June 8, 2017

      A video? That seems a bit extreme.

      Greg means an export of relevant leads, followed by a list import with a new column, followed by a batch Smart Campaign w/Change Data Value flow step. These all should be clear from the docs.

        Terms & ConditionsAccessibility statement

        Loading footer...