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

[Parfitt_David]

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

[Devraj_Grewal]

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.

[Rachel_Noble · Accepted solution]

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]

Hi Rachel,

This worked perfectly.  Thank you!

Dave