How to use Marketo to scan an excel list to see who is new | Community
Skip to main content
Parfitt_David
Parfitt_David
New Participant
May 5, 2017
Solved

How to use Marketo to scan an excel list to see who is new

  • May 5, 2017
  • 2 replies
  • 2226 views

Hi Everyone

I have an excel list of names (ready to go in a Marketo upload format) that we are not ready to add to the database quite yet.  However, I was wondering if there was an easy way to use Marketo to "look" at the list to tell us who is a new lead, not currently in the database yet.

Thanks for the help,

Dave

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 rachel2-2

If you have their email addresses (which hopefully you do if you're going to import them!) you can create a smart list with "email address is" and plug in all the emails from your spreadsheet. Exporting this smart list won't take as long as exporting your entire DB (although that's a great option too) - then use a vlookup like Devraj suggested to compare the two spreadsheets.

This will also give you an immediate sense of numbers. E.g. if your spreadsheet has 500 email addresses and the smart list renders 400, then you have 100 new leads.

2 replies

R
rachel2-2Accepted solution
New Participant
May 5, 2017

If you have their email addresses (which hopefully you do if you're going to import them!) you can create a smart list with "email address is" and plug in all the emails from your spreadsheet. Exporting this smart list won't take as long as exporting your entire DB (although that's a great option too) - then use a vlookup like Devraj suggested to compare the two spreadsheets.

This will also give you an immediate sense of numbers. E.g. if your spreadsheet has 500 email addresses and the smart list renders 400, then you have 100 new leads.

    Parfitt_David
    Parfitt_DavidAuthor
    New Participant
    May 5, 2017

    Hi Rachel,

    This worked perfectly.  Thank you!

    Dave

      Devraj_Grewal
      Devraj_Grewal
      New Participant
      May 5, 2017

      David,

      What you can do is export your Marketo database and compare that spreadsheet to this new one. You can remove duplicates based on email address and then the remaining leads will be net new.

        Terms & ConditionsAccessibility statement

        Loading footer...