Skip to main content
March 1, 2013
Question

Duplicate field values within the same lead record

  • March 1, 2013
  • 4 replies
  • 1067 views
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"
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

4 replies

March 1, 2013
You can use variables to accomplish this in your smart list.  First Name is {{lead.Last Name}}.
March 1, 2013

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


 

March 1, 2013
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?
March 1, 2013
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.