Database clean-up: Email Invalid | Community
Skip to main content
P
Patrick_Vesely
New Participant
November 16, 2018
Solved

Database clean-up: Email Invalid

  • November 16, 2018
  • 3 replies
  • 5251 views

I have a Smart list of over 80K leads that are marked as Email Invalid- these are taking up space in our database.

I am trying to run a campaign to:

1. Remove their invalid email from the email address field

2. Remove them from Marketo, not SalesForce.

Ideally, I would like the Sales and Client Service team to find the proper email address, fill it in and re-sync to Marketo.

I have tried to set up a Smart Campaign that would NULL out the email address but that did not clear the email address. Below is the Flow that I put together.

The smart list will be anyone that is on the Email Invalid Smart List that I created.

Any suggestions would be greatly appreciated.

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 SanfordWhiteman

What's the reason you're changing their email address immediately before you delete them? Is this to thwart Durable Unsubcribe?

Also:

  • IMO simply emptying the email doesn't signify "email needs fixing".  There should be specific flags that make it easy to tell Sales/CS that their attention is needed, and a timestamp for when they've last tried to get up-to-date info.
  • Not having the original email to go on makes fixup that much harder. What if the only evidence you have of their previous employer is in their email domain? Then you've lost that, so good luck calling the old place and finding out where they might've moved!

3 replies

Abhishek_Chand2
Abhishek_Chand2
New Participant
November 19, 2018

Hi Patrick,

Even if you make the email address as null, it will still be taking space in your marketo database. if you want to make space then you have to delete them. Also, as sanford mentioned you need to flag these leads in your CRM so that sales team get the idea about updating the lead

-AC

Abhishek Chandra
    SanfordWhiteman
    SanfordWhitemanAccepted solution
    New Participant
    November 17, 2018

    What's the reason you're changing their email address immediately before you delete them? Is this to thwart Durable Unsubcribe?

    Also:

    • IMO simply emptying the email doesn't signify "email needs fixing".  There should be specific flags that make it easy to tell Sales/CS that their attention is needed, and a timestamp for when they've last tried to get up-to-date info.
    • Not having the original email to go on makes fixup that much harder. What if the only evidence you have of their previous employer is in their email domain? Then you've lost that, so good luck calling the old place and finding out where they might've moved!
    P
    Patrick_VeselyAuthor
    New Participant
    November 29, 2018

    Hi Sanford,

    This was something that the SalesForce Admin discussed- I agree with you on this.  Thank you

    Patrick Vesely
    F
    falvares
    Employee
    November 17, 2018

    Hi Patrick,

    Setting the email address value to "NULL" should work.

    However have a look at the activity log for the records you attempted to reset the email address to NULL, maybe you have a "block field update" that maybe interfering with your change step.

    Also can you run a test scenario so that you can post the results here.

    1. Create a new record in Marketo
    2. Run the Smart Campaign logic for this new record
    3. View the activity log or results tab and take a screen shot and post the results.

    Thanks,

    Floyd

      Terms & ConditionsAccessibility statement

      Loading footer...