Re: create email + country as key in marketo

Saveena
Level 1

create email + country as key in marketo

can we create email and country as a unique key in Marketo? We have done first name and email earlier but want to check the possibility with the country or any other field. also, can we create 3 attributes as the joint key or its restricted to just two?

Tags (2)
1 REPLY 1
SanfordWhiteman
Level 10 - Community Moderator

Re: create email + country as key in marketo


can we create email and country as a unique key in Marketo? We have done first name and email earlier but want to check the possibility with the country or any other field. also, can we create 3 attributes as the joint key or its restricted to just two?

It's 2, but in theory you can extend it to an unlimited # of fields by using a delimited String field as the 2nd one. Just make sure to use a non-colliding delimiter. (For example, the pipe | cannot work to separate fields if one of the fields may have a pipe in it, which is true of Company name.)

 

HOWEVER.... having a compound key is almost always a bad idea. It's impossible to automatically enforce everywhere in Marketo and inevitably leads to the proliferation of (business-level) duplicates. Can you explain your business case for a multi-field compound key?

 

(P.S. First Name and Email Address breaks when parent and child share an email address and have the same name, so it really isn't a solution to households sharing email addresses, if that's what you're going for.)