Missing leads in import

[Anonymous]

Hi,

Could anybody please let me know why Marketo only picks up 60 leads when I've imported a .csv list of 100 leads? This is excluding duplicates (as I already checked to make sure there weren't any duplicates).

After Marketo imported the list, there were 5 that failed as they were in a different partition - so I changed the partition of these leads and added them back to the list but it's still only 60 leads?? Struggling to understand where the other 40 went.

Any insights you can share will be very much appreciated.

Thank you,

Judy

[Jessica_Kao3]

Without seeing the file its difficult to say.  Is there a line break somewhere in the file?  Are their duplicates in the email?  Do all leads have a unique email address. Are there any leads that have email address is empty?  Marketo dedupes on email address.   I would not post the file here obviously for data privacy reasons.  These are the common things to check. 

[Anonymous]

Hi Jessica,

Thank you for your response. Yes unfortunately I had already de-duplicated the emails from the .csv file, ensuring that there were no empty slots or line breaks. Do you know if there could there be any other explanations why?

[Chelsea_Kiko]

If you double checked for duplicates - I would try to remove leads from the static list and re-import. Have you tried that? Judy Yoo​

[Devraj_Grewal]

Judy,

Personally, I actually like to use the SFDC Data Loader for importing leads. It reports on the successful imports and provides notes for the errors so you know why a lead wasn't imported.

[Anonymous]

Hi Devraj - do you mean syncing Marketo programs with SFDC campaigns to import leads?

[Devraj_Grewal]

The Data Loader is a separate application altogether. You log into the wizard with your SFDC credentials and choose which object you would like to insert or update.