Missing leads in import | Community
Skip to main content
A
Anonymous
June 6, 2017
Question

Missing leads in import

  • June 6, 2017
  • 3 replies
  • 2969 views

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

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

3 replies

Jessica_Kao3
Jessica_Kao3
Level 7
June 6, 2017

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. 

    A
    Anonymous
    June 6, 2017

    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
    Chelsea_Kiko
    Level 4
    June 6, 2017

    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
    Devraj_Grewal
    Level 10
    June 6, 2017

    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.

    A
    Anonymous
    June 29, 2017

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

    Devraj_Grewal
    Devraj_Grewal
    Level 10
    June 29, 2017

    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.

    Terms & ConditionsAccessibility statement

    Loading footer...