SFDC leads with no email address syncing to Marketo

[Grégoire_Miche2]

Hi Veronica,

You are right and yet, it has not always been that way.

Marketo sites says :

What is a record?

A record represents a person in your Marketo marketing database for whom you have at least one point of contact (email, Facebook, Twitter, physical mailing address, etc.). Records without a point of contact, such as a record created as a result of a person visiting your website anonymously, are recorded in the Marketo marketing database, but do not count toward database size pricing.

We are going to have to set up some licence control mechanisms

-Greg

[Steven_Vanderb3]

Support can actually just make a filter for null email fields.  We can make a filter for the value of any field the sync user can see in SFDC as far as I know.

[Anonymous]

Thanks everyone!! I have been receiving many different answers on this. Even my Marketo account manager has contradicted herself. I just want to know, do i need to clean up the leads with no email addresses in Marketo bc they cant be marketed to and they are taking up space in our database- in other words is this counting towards our license?

At this point i have worked with support to make a filter for bull email fields, so no one is created in Marketo without an email address moving forward.

Does anyone agree that we should delete the folks with no email addresses in our Marketo instance? if so do you have a best practice for deleting these records?

Thank you!

[Steven_Vanderb3]

I can confirm that those leads that came over with no email address will count against your lead database limit.  If you have no way of identifying them to merge them into some existing record or find some other use for them, you'll probably want to delete them.

[Anonymous]

We have many leads in Salesforce without email addresses that we use for print or calling campaigns only. If an email address is acquired, the Salesforce user will enter that info and get them back into Marketo.

To keep those without email addresses out of Marketo, I have a weekly "cleanse" campaign that runs on Sundays. You could set it to run as often as you'd like.

1. To start I created a Smart List in the Lead Database of those without email addresses, Email Address is empty
2. Then I created the Smart Campaign

• Smart List - Member of Smart List = No email address
• Flow - Delete Lead, Remove from CRM = False
• Schedule - Repeats every Sunday at 1 a.m.

[Anonymous]

Hi Allison,

Just to confirm - Your Flow step, " Delete Lead. Remove from CRM = False", translates to Delete Lead (from MKTO), but (don't) Remove from (SFDC) CRM?

Thank you in advance for your help with this!

Lynn

[Grégoire_Miche2]

Hi Lynn Ray,

Yes, this is it. Just double check before hitting the "run" button

-Greg

[Dan_Stevens_]

This is a good approach, but unfortunately, this only work for SFDC.  If using MS Dynamics, for example, you cannot delete or merge any lead that is a Microsoft LEAD or CONTACT record.  That has to be done in Dynamics.

[cek10428]

Does anyone have a suggestion for this for MS Dynamics? We have the same issue - contacts without email addresses for call campaigns. 

[Jo_Pitts1]

@cek10428 ,

try this https://nation.marketo.com/t5/employee-blogs/marketo-custom-sync-filter-for-microsoft-dynamics-nativ...

Cheers

Jo