SOLVED

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

Go to solution
Parfitt_David
Level 3

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

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

1 ACCEPTED SOLUTION

Accepted Solutions
Rachel_Noble
Level 10 - Champion Alumni

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

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.

View solution in original post

3 REPLIES 3
Devraj_Grewal
Level 10 - Champion Alumni

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

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
Level 10 - Champion Alumni

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

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
Level 3

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

Hi Rachel,

This worked perfectly.  Thank you!

Dave