Re: Duplicate field values within the same lead record

Anonymous
Not applicable

Duplicate field values within the same lead record

Anyone know of a way to compare field values within the same lead record? One of the common bot profiles we see is the same value submitted for both first and last name; it would be great if we could have a filter for smart lists that compared two field values such as "First Name=Last Name"
Tags (1)
4 REPLIES 4
Anonymous
Not applicable

Re: Duplicate field values within the same lead record

You can use variables to accomplish this in your smart list.  First Name is {{lead.Last Name}}.
Anonymous
Not applicable

Re: Duplicate field values within the same lead record

That's what I thought - and the first thing I tried.  But it doesn't work.  It appears as though that is a text lookup, so Marketo doesn't recoginze anyone with the last name = {{lead.Last Name}}.
At least it didn't work for me 🙂

If it works for you Sophia let me know!
Thanks


 

Anonymous
Not applicable

Re: Duplicate field values within the same lead record

We had some bot issues recently as well, and there was typically another field that had something that was tell-tell - either a phone number or jamming in something with http - if you can find that then you can create a smartlist with two unique fields and not require the two identical match.

That being said, it would be nice to have a matching capability.

I haven't tested it yet, but have you tried creating a smartlist using a token so first name is token for last name?
Anonymous
Not applicable

Re: Duplicate field values within the same lead record

Thanks Clinton.  I do have alternate smartlists matching against common phone number anomalies and even company name (google all lower case).  The first thing I tried for matching was inserting the last name token - no good.